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

Table Details :: ADMISSION

 

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'

 

Show more details

S.ADMISSION in DEMODB

 

view S.ADMISSION_VW in DEMODB

 
S.ADMISSION_VW
Column Name Type   Column Name Type  
PATIENT_IDComments:
Patient record number
Joins:
Join to table S.PATIENT on:
PATIENT_ID = PATIENT_ID
Sources:
Clinical System: clin.adm.patient_number		 NUMBER(22)  PATIENT_IDComments:
Patient record number
Joins:
Join to table S.PATIENT on:
PATIENT_ID = PATIENT_ID
Sources:
Clinical System: clin.adm.patient_number		 NUMBER(22) 
CLINIC_IDComments:
Clinic number
Joins:
Join to table S.CLINIC on:
CLINIC_ID = CLINIC_ID
Sources:
Clinical System: clin.adm.clinic_number		 NUMBER(22)  CLINIC_IDComments:
Clinic number
Joins:
Join to table S.CLINIC on:
CLINIC_ID = CLINIC_ID
Sources:
Clinical System: clin.adm.clinic_number		 NUMBER(22) 
ADMISSION_DATEComments:
Date when the patient started being cared for by the clinic. May differ from the first treatment date by a few days.
Sources:
Clinical System: clin.adm.clinic_admission_dt		 DATE(7)  ADMISSION_DATEComments:
Date when the patient started being cared for by the clinic. May differ from the first treatment date by a few days.
Sources:
Clinical System: clin.adm.clinic_admission_dt		 DATE(7) 
DISCHARGE_DATEComments:
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.
Sources:
Clinical System: clin.adm.clinic_discharge_dt		 DATE(7)  DISCHARGE_DATEComments:
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.
Sources:
Clinical System: clin.adm.clinic_discharge_dt		 DATE(7) 
ADMISSION_REASON_CODEJoins:
Join to table S.ADMISSION_REASON on:
ADMISSION_REASON_CODE = S.ADMISSION_REASON.REASON_CODE
Sources:
Clinical System: clin.adm.chief_complaint		 VARCHAR2(9)  ADMISSION_REASON_CODEJoins:
Join to table S.ADMISSION_REASON on:
ADMISSION_REASON_CODE = S.ADMISSION_REASON.REASON_CODE
Sources:
Clinical System: clin.adm.chief_complaint		 VARCHAR2(9) 
     ADMISSION_REASON_DESCRIPTIONComments:
Available in the view based on join to the reference table		 VARCHAR2(60) 
DISCHARGE_REASON_CODEJoins:
Join to table S.DISCHARGE_REASON on:
DISCHARGE_REASON_CODE = S.DISCHARGE_REASON.REASON_CODE
Sources:
Clinical System: clin.adm.reason_for_discharge_code		 VARCHAR2(9)  DISCHARGE_REASON_CODEJoins:
Join to table S.DISCHARGE_REASON on:
DISCHARGE_REASON_CODE = S.DISCHARGE_REASON.REASON_CODE
Sources:
Clinical System: clin.adm.reason_for_discharge_code		 VARCHAR2(9) 
     DISCHARGE_REASON_DESCRIPTIONComments:
Available in the view based on join to the reference table		 VARCHAR2(60) 
INSERT_DATESources:
ETL: audit_columns.g.system_date_at_insert		 DATE(7)  INSERT_DATESources:
ETL: audit_columns.g.system_date_at_insert		 DATE(7) 
UPDATE_DATESources:
ETL: audit_columns.g.system_date_at_update		 DATE(7)  UPDATE_DATESources:
ETL: audit_columns.g.system_date_at_update		 DATE(7) 
LATEST_ROW_INDSources:
ETL: audit_columns.g.process		 CHAR(1)  LATEST_ROW_INDSources:
ETL: audit_columns.g.process		 CHAR(1) 

 

Show sources for ADMISSION

Table Diagram:

Table diagram

Sample query script:

Highlight all, copy to clipboard, and paste as needed

 

 

 

 

Although I worked at the world's largest provider of dialysis services, this data model is my invention.
It is a simplified model that serves as an example for the metadata application that I built.
It does not describe the data model of the company.

Version 2.0, 2014-05-02 13:52:48,  Questions? Contact 'chris _ thullen (a) yekesys d0t c0m'