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

 

PHYSICIAN

Description:Physicians attending at a clinic.
What defines a unique row:The logical key is CLINIC_ID and PHYSICIAN_ID. 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. Note that if a physician works at a clinic after being inactive, the NO_LONGER_ACTIVE_DATE is set to null.
Current rows:CURRENT_ROW_IND = 'Y'
Historical rows:CURRENT_ROW_IND = 'N'

 

Show more details

S.PHYSICIAN in DEMODB

 
Column Name Type  
CLINIC_IDJoins:
Join to table S.CLINIC on:
CLINIC_ID = CLINIC_ID
Sources:
Clinical System: clin.phys.clinic_number		 NUMBER(22) 
PHYSICIAN_IDJoins:
Join to table S.PATIENT on:
PHYSICIAN_ID = PHYSICIAN_ID
Sources:
Clinical System: clin.phys.physician_id		 NUMBER(22) 
INSERT_DATESources:
ETL: audit_columns.g.system_date_at_insert		 DATE(7) 
LAST_NAMESources:
Clinical System: clin.phys.physician_last_name		 VARCHAR2(50) 
FIRST_NAMESources:
Clinical System: clin.phys.physician_first_name		 VARCHAR2(50) 
NPISources:
Clinical System: clin.phys.physician_nat_prov_id		 VARCHAR2(15) 

 

Show sources for PHYSICIAN

 

 

 

 

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'