| Table List | Database Tables |
Pages produced by a web-based metadata application, which joins the database dictionary to entity-level information entered by the analyst. See the author's web page |
ADMISSION
| Description: | Patient admissions to a clinic. An active admission has a non-null admission date and a null discharge date. The source application ensures that only one admission is active per patient per clinic. |
| What defines a unique row: | Logical key is PATIENT_ID, CLINIC_ID, and ADMISSION_DATE. Only one row with LASTEST_ROW_IND='Y' is expected for each logical key. The logical key and the INSERT_DATE consitute the database unique key.. |
| Current rows: | LATEST_ROW_IND = 'Y' |
| Historical rows: | LATEST_ROW_IND = 'N' |
S.ADMISSION in DEMODB | view S.ADMISSION_VW in DEMODB | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| S.ADMISSION_VW | View Sources | ||||||||||
| Column Name | Type | Column Name | Type | Sources | Joins | Comments | |||||
| PATIENT_ID | NUMBER(22) | PATIENT_ID | NUMBER(22) | Clinical System: clin.adm.patient_number | Join to table S.PATIENT on: PATIENT_ID = PATIENT_ID | Patient record number | |||||
| CLINIC_ID | NUMBER(22) | CLINIC_ID | NUMBER(22) | Clinical System: clin.adm.clinic_number | Join to table S.CLINIC on: CLINIC_ID = CLINIC_ID | Clinic number | |||||
| ADMISSION_DATE | DATE(7) | ADMISSION_DATE | DATE(7) | Clinical System: clin.adm.clinic_admission_dt | Date when the patient started being cared for by the clinic. May differ from the first treatment date by a few days. | ||||||
| DISCHARGE_DATE | DATE(7) | DISCHARGE_DATE | DATE(7) | Clinical System: clin.adm.clinic_discharge_dt | Date when the patient's care ended at the clinic. May differ from the last treatment date by a few days. Corresponds to the date of death if the patient was not previously discharged. | ||||||
| ADMISSION_REASON_CODE | VARCHAR2(9) | ADMISSION_REASON_CODE | VARCHAR2(9) | Clinical System: clin.adm.chief_complaint | Join to table S.ADMISSION_REASON on: ADMISSION_REASON_CODE = S.ADMISSION_REASON.REASON_CODE | ||||||
| ADMISSION_REASON_DESCRIPTION | VARCHAR2(60) | Available in the view based on join to the reference table | |||||||||
| DISCHARGE_REASON_CODE | VARCHAR2(9) | DISCHARGE_REASON_CODE | VARCHAR2(9) | Clinical System: clin.adm.reason_for_discharge_code | Join to table S.DISCHARGE_REASON on: DISCHARGE_REASON_CODE = S.DISCHARGE_REASON.REASON_CODE | ||||||
| DISCHARGE_REASON_DESCRIPTION | VARCHAR2(60) | Available in the view based on join to the reference table | |||||||||
| INSERT_DATE | DATE(7) | INSERT_DATE | DATE(7) | ETL: audit_columns.g.system_date_at_insert | |||||||
| UPDATE_DATE | DATE(7) | UPDATE_DATE | DATE(7) | ETL: audit_columns.g.system_date_at_update | |||||||
| LATEST_ROW_IND | CHAR(1) | LATEST_ROW_IND | CHAR(1) | ETL: audit_columns.g.process | |||||||
Table Diagram:
Sample query script:
Highlight all, copy to clipboard, and paste as needed