Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | null |
|
|
Case identifier - Unique identifier for the patient case (AdmitID from PatientAdministration) |
||
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to the patient associated with this case |
|
| Status | nvarchar | 146 | √ | null |
|
|
Case status - Current status of the case with open/closed indicator calculated from PatientStatus for case management workflows |
|
| ProgramType | varchar | 282 | √ | null |
|
|
Program type - Program name from iCS2.dbo.ProgramType with calculated case sequence number using ROW_NUMBER() for multi-case patients to track service progression |
|
| CaseCoordinator | varchar | 101 | √ | null |
|
|
Case coordinator - Full name of the assigned case coordinator retrieved from AccessUser table via subquery for case management assignment tracking |
|
| CaseName | varchar | 255 | √ | null |
|
|
Case name - Descriptive name or title for the case from PatientAdministration |
|
| Comments | varchar | 1000 | √ | null |
|
|
Case comments - Administrative notes and comments about the case from PatientAdministration |
|
| CaseType | varchar | 50 | √ | null |
|
|
Case type - Category or type classification for the case from CaseCategory lookup table |
|
| Paysource | varchar | 131 | √ | null |
|
|
Payment source - Primary payment source name from PaymentSource_vw for billing and financial tracking through PaysourceInCase relationship |
|
| BillingApp | varchar | 100 | √ | null |
|
|
Billing application - Associated billing application name from iCentralMarketPlace.dbo.Apps linked through CategoryApp for cross-system billing integration |
|
| ProgramId | nvarchar | 1073741823 | √ | null |
|
|
Program identifiers - Concatenated list of patient ID types and values for the program using STUFF function with iCS2.dbo.PatientIDTypes and iCS2.dbo.IDTypesInProgramType for comprehensive patient identification |
Relationships
Close relationships within degrees of separation
