Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
censusid | int | 4 | √ | null |
|
|
||||
facilityid | int | 4 | √ | null |
|
|
||||
patientid | int | 4 | √ | null |
|
|
||||
bedid | int | 4 | √ | null |
|
|
||||
begineffectivedate | datetime | 16,3 | √ | null |
|
|
||||
endeffectivedate | datetime | 16,3 | √ | null |
|
|
||||
payerid | int | 4 | √ | null |
|
|
||||
secondpayerid | int | 4 | √ | null |
|
|
||||
thirdpayerid | int | 4 | √ | null |
|
|
||||
fourthpayerid | int | 4 | √ | null |
|
|
||||
fifthpayerid | int | 4 | √ | null |
|
|
||||
carelevelcode | varchar | 5 | √ | null |
|
|
||||
alternatecarelevelcode | varchar | 5 | √ | null |
|
|
||||
statuscodeid | int | 4 | √ | null |
|
|
||||
actioncodeid | int | 4 | √ | null |
|
|
||||
admitdischargelocationid | int | 4 | √ | null |
|
|
||||
admitdischargelocation | varchar | 254 | √ | null |
|
|
||||
admitdischargelocationtype | varchar | 254 | √ | null |
|
|
||||
createddate | datetime | 16,3 | √ | null |
|
|
||||
revisiondate | datetime | 16,3 | √ | null |
|
|
||||
outpatientstatus | char | 1 | √ | null |
|
|
||||
hospitalstayfrom | datetime | 16,3 | √ | null |
|
|
||||
hospitalstayto | datetime | 16,3 | √ | null |
|
|
||||
admittofromid | int | 4 | √ | null |
|
|
||||
admissiontype | int | 4 | √ | null |
|
|
||||
admissionsource | int | 4 | √ | null |
|
|
||||
priormedicaredays | int | 4 | √ | null |
|
|
||||
dss_update_time | datetime | 16,3 | √ | null |
|
|