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

View Definition

S.PATIENT_VW (DEMODB)			S.PATIENT (DEMODB) S.DIABETES_STATUS (DEMODB)
Column	Type		Column	Type	Table	Comment
PATIENT_ID	NUMBER	⇐	PATIENT_ID	NUMBER	S.PATIENT
FIRST_DIALYSIS_DATE	DATE	⇐	FIRST_DIALYSIS_DATE	DATE	S.PATIENT
HEIGHT_EFF_DATE	DATE	⇐	HEIGHT_EFF_DATE	DATE	S.PATIENT
HEIGHT	NUMBER	⇐	HEIGHT	NUMBER	S.PATIENT
DIABETES_STATUS_CODE	VARCHAR2	⇐	DIABETES_STATUS_CODE	VARCHAR2	S.PATIENT
DIABETES_STATUS_DESCRIPTION	VARCHAR2	⇐	DIABETES_STATUS_DESCRIPTION	VARCHAR2	S.DIABETES_STATUS
LAST_NAME	VARCHAR2	⇐	LAST_NAME	VARCHAR2	S.PATIENT
FIRST_NAME	VARCHAR2	⇐	FIRST_NAME	VARCHAR2	S.PATIENT
GENDER	CHAR	⇐	GENDER	CHAR	S.PATIENT
DATE_OF_BIRTH	DATE	⇐	DATE_OF_BIRTH	DATE	S.PATIENT
PHYSICIAN_ID	NUMBER	⇐	PHYSICIAN_ID	NUMBER	S.PATIENT
INSERT_DATE	DATE	⇐	INSERT_DATE	DATE	S.PATIENT
UPDATE_DATE	DATE	⇐	UPDATE_DATE	DATE	S.PATIENT
CURRENT_ROW_IND	CHAR	⇐	CURRENT_ROW_IND	CHAR	S.PATIENT