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 :: PATIENT

 

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'

 

Show more details

S.PATIENT in DEMODB

 

view S.PATIENT_VW in DEMODB

 
S.PATIENT_VW
Column Name Type   Column Name Type  
PATIENT_IDComments:
Patient record number
Joins:
Join to table S.ADMISSION on:
PATIENT_ID = PATIENT_ID
Joins:
Join to table S.LAB_RESULT on:
PATIENT_ID = PATIENT_ID
Joins:
Join to table S.MEDICATION on:
PATIENT_ID = PATIENT_ID
Joins:
Join to table S.TREATMENT on:
PATIENT_ID = PATIENT_ID
Sources:
Clinical System: clin.adm.patient_number		 NUMBER(22)  PATIENT_IDComments:
Patient record number
Joins:
Join to table S.ADMISSION on:
PATIENT_ID = PATIENT_ID
Joins:
Join to table S.LAB_RESULT on:
PATIENT_ID = PATIENT_ID
Joins:
Join to table S.MEDICATION on:
PATIENT_ID = PATIENT_ID
Joins:
Join to table S.TREATMENT on:
PATIENT_ID = PATIENT_ID
Sources:
Clinical System: clin.adm.patient_number		 NUMBER(22) 
PATIENT_TYPE_CODEComments:
Indicates ESRD, acute, or other patient type
Joins:
Join to table S.PATIENT_TYPE on:
PATIENT_TYPE_CODE = PATIENT_TYPE_CODE		 VARCHAR2(10)  PATIENT_TYPE_CODEComments:
Indicates ESRD, acute, or other patient type
Joins:
Join to table S.PATIENT_TYPE on:
PATIENT_TYPE_CODE = PATIENT_TYPE_CODE		 VARCHAR2(10) 
FIRST_DIALYSIS_DATEComments:
Date of first chronic dialysis after being diagnosed with End Stage Renal Disease
Sources:
Clinical System: clin.adm.patient_start_date		 DATE(7)  FIRST_DIALYSIS_DATEComments:
Date of first chronic dialysis after being diagnosed with End Stage Renal Disease
Sources:
Clinical System: clin.adm.patient_start_date		 DATE(7) 
HEIGHTComments:
in cm
Sources:
Clinical System: clin.adm.patient_height_cm		 NUMBER(22)  HEIGHTComments:
in cm
Sources:
Clinical System: clin.adm.patient_height_cm		 NUMBER(22) 
HEIGHT_EFF_DATEComments:
When the height was measured
Sources:
Clinical System: clin.adm.patient_height_date		 DATE(7)  HEIGHT_EFF_DATEComments:
When the height was measured
Sources:
Clinical System: clin.adm.patient_height_date		 DATE(7) 
PHYSICIAN_IDComments:
Attending physician ID, links to the PHYSICIAN table
Joins:
Join to table S.PHYSICIAN on:
PHYSICIAN_ID = PHYSICIAN_ID
Sources:
Clinical System: clin.adm.physician_id		 NUMBER(22)  PHYSICIAN_IDComments:
Attending physician ID, links to the PHYSICIAN table
Joins:
Join to table S.PHYSICIAN on:
PHYSICIAN_ID = PHYSICIAN_ID
Sources:
Clinical System: clin.adm.physician_id		 NUMBER(22) 
DIABETES_STATUS_CODEJoins:
Join to table S.DIABETES_STATUS on:
DIABETES_STATUS_CODE = DIABETES_STATUS_CODE
Sources:
Clinical System: clin.adm.patient_has_diabetes		 VARCHAR2(9)  DIABETES_STATUS_CODEJoins:
Join to table S.DIABETES_STATUS on:
DIABETES_STATUS_CODE = DIABETES_STATUS_CODE
Sources:
Clinical System: clin.adm.patient_has_diabetes		 VARCHAR2(9) 
     DIABETES_STATUS_DESCRIPTIONComments:
Available in the view based on join to the reference table		 VARCHAR2(60) 
LAST_NAMESources:
Clinical System: clin.adm.patient_last_name		 VARCHAR2(50)  LAST_NAMESources:
Clinical System: clin.adm.patient_last_name		 VARCHAR2(50) 
FIRST_NAMESources:
Clinical System: clin.adm.patient_first_name		 VARCHAR2(50)  FIRST_NAMESources:
Clinical System: clin.adm.patient_first_name		 VARCHAR2(50) 
GENDERSources:
Clinical System: clin.adm.patient_gender		 CHAR(1)  GENDERSources:
Clinical System: clin.adm.patient_gender		 CHAR(1) 
DATE_OF_BIRTHSources:
Clinical System: clin.adm.patient_dob		 DATE(7)  DATE_OF_BIRTHSources:
Clinical System: clin.adm.patient_dob		 DATE(7) 
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) 
CURRENT_ROW_INDSources:
ETL: audit_columns.g.process		 CHAR(1)  CURRENT_ROW_INDSources:
ETL: audit_columns.g.process		 CHAR(1) 
CLINIC_ID_UPDATED_BYComments:
Number of clinic that updated the row		 NUMBER(22)     

 

Show sources for PATIENT

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'