Prevention Agency Service Rates

Prevention Agency Service Rates

FieldTypeDescription
agency_service_rate_id 🔑INTEGERUnique identifier for this agency service rate.
agency_service_id 🔗INTEGERThe ID of the parent agency service.
referring_agency_id 🔗INTEGERThe ID of the referring agency.
provider_agency_id 🔗INTEGERThe ID of the provider agency.
labelSTRINGContract name/label.
codeSTRINGContract code identifier.
billing_structureSTRINGBilling structure type.
amount_centsINTEGERContract amount in cents.
start_dateDATEContract start date.
end_dateDATEContract end date.
created_atTIMESTAMPWhen this record was created.
updated_atTIMESTAMPWhen this record was last updated.

Key Information

Primary Keys

  • agency_service_rate_id - Unique identifier for this agency service rate.

Foreign Keys

  • agency_service_id - The ID of the parent agency service.
  • referring_agency_id - The ID of the referring agency.
  • provider_agency_id - The ID of the provider agency.