| PHYSICIAN_DIMENSION | ||
| Name | Null? | Type |
| PHYSICIAN_ID | NOT NULL | NUMBER |
| PHYSICIAN_FIRST_NAME | NOT NULL | VARCHAR2(20) |
| PHYSICIAN_MIDDLE_NAME | VARCHAR2(20) | |
| PHYSICIAN_LAST_NAME | NOT NULL | VARCHAR2(25) |
| PHYSICIAN_DOB | NOT NULL | DATE |
| PHYSICIAN_GENDER | NOT NULL | VARCHAR2(1) |
| CREATED_BY | NOT NULL | VARCHAR2(25) |
| CREATED_DATE | NOT NULL | TIMESTAMP(3) |
| COLUMN_NAME | FORMAT | DESCRIPTION |
| date_id | ccyymmdd | |
| full_date_id | ccyymmddhh24miss | |
| month_id | ccyymm | |
| week_id | ccyyww |