Applications

Field	Type	Description
`id` 🔑	INTEGER	The unique identifier for the application record.
`agency_id` 🔗	INTEGER	The ID of the agency this application belongs to.
`external_identifier`	STRING	External systems identifier for the application, if provided.
`license_id` 🔗	INTEGER	The ID of the license this application is associated with.
`placement_provider_id` 🔗	INTEGER	The ID of the placement provider (caregiver) this application is for.
`type`	STRING	The type of application (e.g., initial, renewal, conversion).
`application_template_id` 🔗	INTEGER	The ID of the application template used for this application.
`created_at`	TIMESTAMP	The timestamp when the application was created.
`updated_at`	TIMESTAMP	The timestamp when the application was last updated.
`started_at`	TIMESTAMP	The timestamp when the application process was started.
`completed_at`	TIMESTAMP	The timestamp when the application was completed, if applicable.
`previous_application_id` 🔗	INTEGER	The ID of the previous application this one is renewing or replacing.
`is_latest_for_license`	BOOLEAN	Whether this is the most recent application for the associated license.
`maximum_approved_age`	INTEGER	The maximum age of children this application approves the caregiver to care for.
`minimum_approved_age`	INTEGER	The minimum age of children this application approves the caregiver to care for.
`maximum_capacity`	INTEGER	The maximum number of children this application approves the caregiver to care for.
`status`	STRING	The current status of the application.
`status_reason`	STRING	The reason for the current application status.
`status_reason_description`	STRING	Additional details or explanation for the status reason.
`latest_status_change_date`	DATE	The date when the application status was last changed.

Key Information

Primary Keys

id - The unique identifier for the application record.

Foreign Keys

agency_id - The ID of the agency this application belongs to.
license_id - The ID of the license this application is associated with.
placement_provider_id - The ID of the placement provider (caregiver) this application is for.
application_template_id - The ID of the application template used for this application.
previous_application_id - The ID of the previous application this one is renewing or replacing.