Service Referrals

Field	Type	Description
`service_referral_id` 🔑	INTEGER	Unique identifier for this service referral.
`service_id` 🔗	INTEGER	The ID of the service this service referral belongs to.
`referring_agency_id` 🔗	INTEGER	The ID of the referring agency that referred the service.
`provider_agency_id` 🔗	INTEGER	The ID of the provider agency that provided the service.
`external_identifier`	STRING	The external identifier for the service referral.
`status`	STRING	The status of the service referral.
`notes`	STRING	The notes for the service referral.
`status_reason`	STRING	The reason for the status of the service referral.
`status_subreason`	STRING	The subreason for the status of the service referral.
`status_details`	STRING	The details for the status of the service referral.
`status_change_date`	TIMESTAMP	The date and time the status of the service referral was changed.
`start_date`	DATE	The start date of the service referral.
`end_date`	DATE	The end date of the service referral.
`created_at`	TIMESTAMP	The date and time the service referral was created.
`updated_at`	TIMESTAMP	The date and time the service referral was last updated.

Key Information

service_id - The ID of the service this service referral belongs to.
referring_agency_id - The ID of the referring agency that referred the service.
provider_agency_id - The ID of the provider agency that provided the service.