Licenses

Field	Type	Description
`id` 🔑	INTEGER	The unique identifier for the license record.
`agency_id` 🔗	INTEGER	The ID of the agency this license belongs to.
`external_identifier`	STRING	External systems identifier for the license, if provided.
`placement_provider_id` 🔗	INTEGER	The ID of the placement provider associated with this license.
`license_type`	STRING	The primary type of license (e.g., child placing agency, congregate care, family home).
`sub_license_type`	STRING	The subcategory or specific type within the main license type.
`expiry_date`	DATE	The date when the license expires.
`status`	STRING	The status of the latest application associated with the license.
`confidential`	BOOLEAN	Whether the license has been marked as confidential.
`confidential_reason`	STRING	The reason why the license is marked as confidential.
`confidential_reason_other_explanation`	STRING	Additional explanation for the confidential reason, if 'other' was selected.
`initial_approval_date`	DATE	The date when the license was initially approved.
`most_recent_approval_date`	DATE	The date of the most recent approval or renewal of the license.
`approved_age_max`	INTEGER	The maximum age of children this license allows the caregiver to care for.
`approved_age_min`	INTEGER	The minimum age of children this license allows the caregiver to care for.
`capacity`	INTEGER	The maximum number of children this license allows the caregiver to care for.
`approved_gender_female`	BOOLEAN	Whether the license allows caring for female children.
`approved_gender_male`	BOOLEAN	Whether the license allows caring for male children.
`approved_gender_non_binary`	BOOLEAN	Whether the license allows caring for non-binary children.
`approved_gender_not_listed`	BOOLEAN	Whether the license allows caring for children whose gender is not listed in the standard options.
`created_at`	TIMESTAMP	The timestamp when the license record was created.
`updated_at`	TIMESTAMP	The timestamp when the license record was last updated.

Key Information

Primary Keys

id - The unique identifier for the license record.

Foreign Keys

agency_id - The ID of the agency this license belongs to.
placement_provider_id - The ID of the placement provider associated with this license.