Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AdmitID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each case/admission record |
||||||||||||||||||||||||||||||||||||||||
| DateAdmin | smalldatetime | 16 | √ | null |
|
|
Admission date - Date when the patient was admitted to services |
||||||||||||||||||||||||||||||||||||||||
| DateDischarge | smalldatetime | 16 | √ | null |
|
|
Discharge date - Date when services were discontinued |
||||||||||||||||||||||||||||||||||||||||
| DischargeReason | int | 4 | √ | null |
|
|
Discharge reason - Reference to reason for service discontinuation |
||||||||||||||||||||||||||||||||||||||||
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table for the client receiving services |
||||||||||||||||||||||||||||||||||||||||
| DeclinedDate | smalldatetime | 16 | √ | null |
|
|
Declined date - Date when services were declined |
||||||||||||||||||||||||||||||||||||||||
| ProgramTypeID | int | 4 | √ | null |
|
|
Program type - Links to program type for the healthcare service category |
||||||||||||||||||||||||||||||||||||||||
| CaseName | varchar | 255 | √ | null |
|
|
Case name - Descriptive name or identifier for this case |
||||||||||||||||||||||||||||||||||||||||
| CaseCoordID | int | 4 | √ | null |
|
|
Case coordinator - UserID of the case coordinator managing this case |
||||||||||||||||||||||||||||||||||||||||
| groupingID | int | 4 | √ | null |
|
|
Case category - Links to CaseCategory table for case classification |
||||||||||||||||||||||||||||||||||||||||
| Status | int | 4 | √ | null |
|
|
Case status - Current status of the case (Active, Closed, Pending, etc.) |
||||||||||||||||||||||||||||||||||||||||
| Comments | varchar | 1000 | √ | null |
|
|
Case comments - Administrative notes about the case |
||||||||||||||||||||||||||||||||||||||||
| caseID | int | 4 | √ | null |
|
|
Case reference - Links to CaseCategory table for case type |
||||||||||||||||||||||||||||||||||||||||
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Timestamp when the case record was created |
||||||||||||||||||||||||||||||||||||||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this case |
||||||||||||||||||||||||||||||||||||||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Timestamp of the most recent case update |
||||||||||||||||||||||||||||||||||||||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified this case |
||||||||||||||||||||||||||||||||||||||||
| AdminEntered | datetime | 16,3 | √ | null |
|
|
Admin entry date - Timestamp when admission was entered |
||||||||||||||||||||||||||||||||||||||||
| DischargeEntered | datetime | 16,3 | √ | null |
|
|
Discharge entry date - Timestamp when discharge was entered |
||||||||||||||||||||||||||||||||||||||||
| DateAgingOut | datetime | 16,3 | √ | null |
|
|
Aging out date - Date when patient ages out of program eligibility |
||||||||||||||||||||||||||||||||||||||||
| EmployerRelated | varchar | 1 | √ | null |
|
|
Employer related - Flag indicating if case is employer-related |
||||||||||||||||||||||||||||||||||||||||
| AutoAccident | varchar | 1 | √ | null |
|
|
Auto accident - Flag indicating if case involves auto accident |
||||||||||||||||||||||||||||||||||||||||
| OtherAccident | varchar | 1 | √ | null |
|
|
Other accident - Flag indicating if case involves other type of accident |
||||||||||||||||||||||||||||||||||||||||
| caseOpenClosed | varchar | 10 | √ | null |
|
|
Open/closed status - Simple open or closed status indicator |
||||||||||||||||||||||||||||||||||||||||
| fkRateTypeID | int | 4 | √ | null |
|
|
Rate type - Links to RateType table for billing rate classification |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__PatientAdministr__7908F585 | Primary key | Asc | AdmitID |
| IX_CaseOpenClosed | Performance | Asc | caseOpenClosed |
| IX_DateAdmin | Performance | Asc | DateAdmin |
| IX_DateAgingOut | Performance | Asc | DateAgingOut |
| IX_DateDischarge | Performance | Asc | DateDischarge |
| IX_fkRateTypeID | Performance | Asc | fkRateTypeID |
| IX_GroupingID | Performance | Asc | groupingID |
| IX_PatientAdministration | Performance | Asc | ProgramTypeID |
| IX_PatientID | Performance | Asc | AdmitID |
| IX_ProgramtypeID | Performance | Asc/Asc | AdmitID + ProgramTypeID |
| IX_Status | Performance | Asc | Status |
Relationships
Close relationships within degrees of separation
