PatientCaseSupply


Description

Patient case supply and incident tracking managing supplemental case information including hospitalization periods, lab charges, and incident documentation. This table stores additional case-related data including work restrictions, hospitalization dates, outside lab information, Medicaid resubmission codes, and incident tracking, supporting comprehensive case management and supplemental documentation for patient care coordination.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SupplyID int identity 4 √ null

Primary key - Unique identifier for each patient case supply record
caseID int 4 √ null
PatientAdministration.AdmitID FK__PatientCa__Admit__3D3EEF98 C

Case reference - Links to PatientAdministration table for the associated patient case (foreign key to PatientAdministration.AdmitID)
DateCantWorkFrom smalldatetime 16 √ null

Work restriction start - Start date when patient cannot work or attend regular activities
DateCantWorkTo smalldatetime 16 √ null

Work restriction end - End date when patient cannot work or attend regular activities
DateHospitalizedFrom smalldatetime 16 √ null

Hospitalization start - Start date of patient hospitalization period
DateHospitalizedTo smalldatetime 16 √ null

Hospitalization end - End date of patient hospitalization period
OutsideLab int 4 √ null

Outside lab reference - Links to outside laboratory used for testing
LabCharge money 21,4 √ null

Laboratory charge - Monetary amount charged for outside laboratory services
MedicaidResubCode varchar 20 √ null

Medicaid resubmission code - Code used for Medicaid claim resubmission
OriginalRefNum int 4 √ null

Original reference number - Original reference number for tracking purposes
DateOccurred smalldatetime 16 √ null

Incident occurrence date - Date when incident or event occurred
DateSimilarOccurred smalldatetime 16 √ null

Similar incident date - Date when similar incident previously occurred

Indexes

Constraint Name Type Sort Column(s)
PK__PatientCaseSuppl__3C4ACB5F Primary key Asc SupplyID

Relationships

Close relationships within degrees of separation