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 less details

S.PHYSICIAN in DEMODB
				View Sources
Column Name	Type			Sources	Joins	Comments
CLINIC_ID	NUMBER(22)			Clinical System: clin.phys.clinic_number	Join to table S.CLINIC on: CLINIC_ID = CLINIC_ID
PHYSICIAN_ID	NUMBER(22)			Clinical System: clin.phys.physician_id	Join to table S.PATIENT on: PHYSICIAN_ID = PHYSICIAN_ID
INSERT_DATE	DATE(7)			ETL: audit_columns.g.system_date_at_insert
LAST_NAME	VARCHAR2(50)			Clinical System: clin.phys.physician_last_name
FIRST_NAME	VARCHAR2(50)			Clinical System: clin.phys.physician_first_name
NPI	VARCHAR2(15)			Clinical System: clin.phys.physician_nat_prov_id

Show sources for PHYSICIAN