|
View Definition| S.MEDICATION_VW (DEMODB) | | S.MEDICATION (DEMODB)
S.DIAGNOSIS (DEMODB)
S.DRUG (DEMODB)
S.ROUTE (DEMODB)
S.MEASUREMENT (DEMODB) | |
| Column | Type | | Column | Type | Table | | Comment |
|---|
| CLINIC_ID | NUMBER | ⇐ | CLINIC_ID | NUMBER | S.MEDICATION | | | | ADMINISTRATION_DATE | NUMBER | ⇐ | ADMINISTRATION_DATE | NUMBER | S.MEDICATION | | | | DIAGNOSIS_CODE | VARCHAR2 | ⇐ | DIAGNOSIS_CODE | VARCHAR2 | S.MEDICATION | | | | DIAGNOSIS_DESCRIPTION | VARCHAR2 | ⇐ | DIAGNOSIS_DESCRIPTION | VARCHAR2 | S.DIAGNOSIS | | | | DRUG_CODE | VARCHAR2 | ⇐ | DRUG_CODE | VARCHAR2 | S.MEDICATION | | | | DRUG_NAME | VARCHAR2 | ⇐ | DRUG_NAME | VARCHAR2 | S.DRUG | | | | ROUTE_CODE | VARCHAR2 | ⇐ | ROUTE_CODE | VARCHAR2 | S.MEDICATION | | | | ROUTE_DESCRIPTION | VARCHAR2 | ⇐ | ROUTE_DESCRIPTION | VARCHAR2 | S.ROUTE | | | | MEASUREMENT_CODE | VARCHAR2 | ⇐ | MEASUREMENT_CODE | VARCHAR2 | S.MEDICATION | | | | MEASUREMENT_DESCRIPTION | VARCHAR2 | ⇐ | MEASUREMENT_DESCRIPTION | VARCHAR2 | S.MEASUREMENT | | | | QUANTITY | NUMBER | ⇐ | QUANTITY | NUMBER | S.MEDICATION | | | | DOSE_CODE | NUMBER | ⇐ | DOSE_CODE | NUMBER | S.MEDICATION | | | | INSERT_DATE | DATE | ⇐ | INSERT_DATE | DATE | S.MEDICATION | | | | UPDATE_DATE | DATE | ⇐ | UPDATE_DATE | DATE | S.MEDICATION | | | | LATEST_ROW_IND | CHAR | ⇐ | LATEST_ROW_IND | CHAR | S.MEDICATION | | | | |
|
|
|