|
View Definition| S.ADMISSION_VW (DEMODB) | | S.ADMISSION (DEMODB)
S.ADMISSION_REASON (DEMODB)
S.DISCHARGE_REASON (DEMODB) | |
| Column | Type | | Column | Type | Table | | Comment |
|---|
| CLINIC_ID | NUMBER | ⇐ | CLINIC_ID | NUMBER | S.ADMISSION | | | | PATIENT_ID | NUMBER | ⇐ | PATIENT_ID | NUMBER | S.ADMISSION | | | | ADMISSION_DATE | DATE | ⇐ | ADMISSION_DATE | DATE | S.ADMISSION | | | | DISCHARGE_DATE | DATE | ⇐ | DISCHARGE_DATE | DATE | S.ADMISSION | | | | ADMISSION_REASON_CODE | VARCHAR2 | ⇐ | ADMISSION_REASON_CODE | VARCHAR2 | S.ADMISSION | | | | ADMISSION_REASON_DESCRIPTION | VARCHAR2 | ⇐ | REASON_DESCRIPTION | VARCHAR2 | S.ADMISSION_REASON | | | | DISCHARGE_REASON_CODE | VARCHAR2 | ⇐ | DISCHARGE_REASON_CODE | VARCHAR2 | S.ADMISSION | | | | DISCHARGE_REASON_DESCRIPTION | VARCHAR2 | ⇐ | REASON_DESCRIPTION | VARCHAR2 | S.DISCHARGE_REASON | | | | INSERT_DATE | DATE | ⇐ | INSERT_DATE | DATE | S.ADMISSION | | | | UPDATE_DATE | DATE | ⇐ | UPDATE_DATE | DATE | S.ADMISSION | | | | LATEST_ROW_IND | CHAR | ⇐ | LATEST_ROW_IND | CHAR | S.ADMISSION | | | | |
|
|
|