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 |
|
|
Relationships
Close relationships within degrees of separation
