Agency Services

Agency Services

FieldTypeDescription
agency_service_id 🔑INTEGERUnique identifier for the agency service.
nameSTRINGThe name of the agency service.
is_ffpsaBOOLEANBoolean indicating whether the agency service is FFPSA.
provider_agency_id 🔗INTEGERThe Agency ID of the provider agency.
referring_agency_id 🔗INTEGERThe Agency ID of the referring agency.
evidence_based_practice_id 🔗INTEGERThe ID of the evidence-based practice.
external_identifierSTRINGThe external identifier of the agency service.
created_atTIMESTAMPThe timestamp of when the agency service was created.
updated_atTIMESTAMPThe timestamp of when the agency service was updated.

Key Information

Primary Keys

  • agency_service_id - Unique identifier for the agency service.

Foreign Keys

  • provider_agency_id - The Agency ID of the provider agency.
  • referring_agency_id - The Agency ID of the referring agency.
  • evidence_based_practice_id - The ID of the evidence-based practice.