Service Referral Status Changes

Service Referral Status Changes

FieldTypeDescription
service_referral_status_change_id šŸ”‘INTEGERUnique identifier for this service referral status change.
service_referral_id šŸ”—INTEGERThe ID of the service referral this status change belongs to.
old_statusSTRINGThe status of the service referral before this change.
new_statusSTRINGThe status of the service referral after this change.
reasonSTRINGThe reason for the status change.
detailsSTRINGAdditional details for the status change.
created_atTIMESTAMPThe date and time the status change was created.
occurred_dateDATEThe date the status change occurred.

Key Information

Primary Keys

  • service_referral_status_change_id - Unique identifier for this service referral status change.

Foreign Keys

  • service_referral_id - The ID of the service referral this status change belongs to.

Did this page help you?