Case Notes
Case Notes
| Field | Type | Description |
|---|---|---|
case_notes_id 🔑 | INTEGER | Unique identifier for this case note. |
agency_id 🔗 | INTEGER | The ID of the agency this case note belongs to. |
license_id 🔗 | INTEGER | The ID of the license associated with this case note, if applicable. |
child_id 🔗 | INTEGER | The ID of the child associated with this case note, if applicable. |
agency_worker_id 🔗 | INTEGER | The ID of the agency worker who authored this case note. |
application_participant_id 🔗 | INTEGER | The user-agency profile ID for the adult associated with this case note, if applicable. |
date | DATE | The calendar date of the case note. |
contact_method | STRING | The method of contact used for this case note. |
case_note_type | STRING | The type of case note. |
visit_type | STRING | The visit type for this case note, if applicable. |
support_service_type | STRING | The support service type for this case note, if applicable. |
complaint_or_violation_type | STRING | The complaint or violation type for this case note, if applicable. |
body | STRING | The text body of the case note. |
amount_spent_cents | INTEGER | The amount spent for a support services case note, as an integer in the smallest currency unit for amount_spent_currency (cents for USD). |
amount_spent_currency | STRING | The ISO 4217 currency code for amount_spent_cents (e.g. USD). Defines which minor unit amount_spent_cents is expressed in. |
estimated_approval_date | DATE | The estimated approval date for an approval date estimate case note, if applicable. |
review_required | BOOLEAN | Whether this case note requires review. |
created_at | TIMESTAMP | When this case note was created. |
updated_at | TIMESTAMP | When this case note was last updated. |
Key Information
Primary Keys
case_notes_id- Unique identifier for this case note.
Foreign Keys
agency_id- The ID of the agency this case note belongs to.license_id- The ID of the license associated with this case note, if applicable.child_id- The ID of the child associated with this case note, if applicable.agency_worker_id- The ID of the agency worker who authored this case note.application_participant_id- The user-agency profile ID for the adult associated with this case note, if applicable.
Updated 27 days ago
Did this page help you?