Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table for the patient receiving service coordination |
|
| RelationshipStatus | char | 10 | √ | null |
|
|
Relationship status - Status of the service coordinator-patient relationship (Active, Inactive, etc.) |
|
| AccessUserID | int | 4 | √ | null |
|
|
Service coordinator reference - Links to AccessUser table for the assigned service coordinator |
|
| caseID | int | 4 | √ | null |
|
|
Case reference - Links to PatientAdministration table for the administrative case |
|
| FirstName | varchar | 50 | √ | null |
|
|
Coordinator first name - First name of the assigned service coordinator |
|
| LastName | varchar | 50 | √ | null |
|
|
Coordinator last name - Last name of the assigned service coordinator |
|
| SC_Type | char | 10 | √ | null |
|
|
Service coordination type - Type or category of service coordination provided |
|
| CompanyName | varchar | 50 | √ | null |
|
|
Agency name - Name of the agency employing the service coordinator |
|
| dateActive | smalldatetime | 16 | √ | null |
|
|
Active date - Date when the service coordinator assignment became active |
|
| dateInactive | smalldatetime | 16 | √ | null |
|
|
Inactive date - Date when the service coordinator assignment became inactive |
Relationships
Close relationships within degrees of separation
