Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| first_census_id | int | 4 | null |
|
|
|||||
| patient_id | int | 4 | null |
|
|
|||||
| facility_id | int | 4 | null |
|
|
|||||
| facility_code | varchar | 5 | √ | null |
|
|
||||
| facility_name | varchar | 375 | √ | null |
|
|
||||
| facility_state | varchar | 3 | √ | null |
|
|
||||
| line_of_business | varchar | 10 | √ | null |
|
|
||||
| stay_begindate | datetime | 16,3 | null |
|
|
|||||
| stay_enddate | datetime | 16,3 | √ | null |
|
|
||||
| resident_number | varchar | 50 | √ | null |
|
|
||||
| last_name | varchar | 50 | √ | null |
|
|
||||
| first_name | varchar | 50 | √ | null |
|
|
||||
| total_censusdays | int | 4 | √ | null |
|
|
||||
| length_of_stay | int | 4 | √ | null |
|
|
||||
| primary_inscnt | int | 4 | √ | null |
|
|
||||
| total_reimbursement | money | 21,4 | √ | null |
|
|
||||
| is_active_patient | char | 1 | √ | null |
|
|
||||
| as_of_date | date | 6 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
