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.
`inquiry_date`	DATE	The date when the application inquiry was made.
`applicant_data_percentage_complete`	INTEGER	Percentage completion of applicant data fields (0-100).
`applicant_forms_percentage_complete`	INTEGER	Percentage completion of applicant forms (0-100).
`supporting_docs_percentage_complete`	INTEGER	Percentage completion of supporting documents (0-100).
`agency_forms_percentage_complete`	INTEGER	Percentage completion of agency forms (0-100).
`references_percentage_complete`	INTEGER	Percentage completion of references (0-100, or null if number of required references is unknown).
`family_type`	STRING	The type of family (relative, nrefm, community, or guardian).
`in_renewal_process`	BOOLEAN	Whether the application is "In Renewal Process" (AKA is a Renewal Application and has the "Applying" status).
`is_most_recent_application_for_applicant`	BOOLEAN	Whether this is the most recent application for the applicant.

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.