| 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 |
PATIENT
| Description: | Patient details, independent of clinic. |
| What defines a unique row: | Logical key is PATIENT_ID. Only one row with CURRENT_ROW_IND='Y' is expected for each logical key. The logical key and the INSERT_DATE consitute the database unique key. |
| Current rows: | CURRENT_ROW_IND = 'Y' |
| Historical rows: | CURRENT_ROW_IND = 'N' |
S.PATIENT in DEMODB | view S.PATIENT_VW in DEMODB | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| S.PATIENT_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.ADMISSION on: PATIENT_ID = PATIENT_ID Join to table S.LAB_RESULT on: PATIENT_ID = PATIENT_ID Join to table S.MEDICATION on: PATIENT_ID = PATIENT_ID Join to table S.TREATMENT on: PATIENT_ID = PATIENT_ID | Patient record number | |||||
| PATIENT_TYPE_CODE | VARCHAR2(10) | PATIENT_TYPE_CODE | VARCHAR2(10) | Join to table S.PATIENT_TYPE on: PATIENT_TYPE_CODE = PATIENT_TYPE_CODE | Indicates ESRD, acute, or other patient type | ||||||
| FIRST_DIALYSIS_DATE | DATE(7) | FIRST_DIALYSIS_DATE | DATE(7) | Clinical System: clin.adm.patient_start_date | Date of first chronic dialysis after being diagnosed with End Stage Renal Disease | ||||||
| HEIGHT | NUMBER(22) | HEIGHT | NUMBER(22) | Clinical System: clin.adm.patient_height_cm | in cm | ||||||
| HEIGHT_EFF_DATE | DATE(7) | HEIGHT_EFF_DATE | DATE(7) | Clinical System: clin.adm.patient_height_date | When the height was measured | ||||||
| PHYSICIAN_ID | NUMBER(22) | PHYSICIAN_ID | NUMBER(22) | Clinical System: clin.adm.physician_id | Join to table S.PHYSICIAN on: PHYSICIAN_ID = PHYSICIAN_ID | Attending physician ID, links to the PHYSICIAN table | |||||
| DIABETES_STATUS_CODE | VARCHAR2(9) | DIABETES_STATUS_CODE | VARCHAR2(9) | Clinical System: clin.adm.patient_has_diabetes | Join to table S.DIABETES_STATUS on: DIABETES_STATUS_CODE = DIABETES_STATUS_CODE | ||||||
| DIABETES_STATUS_DESCRIPTION | VARCHAR2(60) | Available in the view based on join to the reference table | |||||||||
| LAST_NAME | VARCHAR2(50) | LAST_NAME | VARCHAR2(50) | Clinical System: clin.adm.patient_last_name | |||||||
| FIRST_NAME | VARCHAR2(50) | FIRST_NAME | VARCHAR2(50) | Clinical System: clin.adm.patient_first_name | |||||||
| GENDER | CHAR(1) | GENDER | CHAR(1) | Clinical System: clin.adm.patient_gender | |||||||
| DATE_OF_BIRTH | DATE(7) | DATE_OF_BIRTH | DATE(7) | Clinical System: clin.adm.patient_dob | |||||||
| 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 | |||||||
| CURRENT_ROW_IND | CHAR(1) | CURRENT_ROW_IND | CHAR(1) | ETL: audit_columns.g.process | |||||||
| CLINIC_ID_UPDATED_BY | NUMBER(22) | Number of clinic that updated the row | |||||||||
Table Diagram:
Sample query script:
Highlight all, copy to clipboard, and paste as needed