| S.PHYSICIAN | | clin.phys (Clinical System)
audit_columns.g (ETL) |
|
| Column | Type | | Column | Type | Table | | Comment |
|---|
| CLINIC_ID | NUMBER | ⇐ | clinic_number | | clin.phys (Clinical System) | | |
| PHYSICIAN_ID | NUMBER | ⇐ | physician_id | | clin.phys (Clinical System) | | |
| INSERT_DATE | DATE | ⇐ | system_date_at_insert | | audit_columns.g (ETL) | | |
| LAST_NAME | VARCHAR2 | ⇐ | physician_last_name | | clin.phys (Clinical System) | | |
| FIRST_NAME | VARCHAR2 | ⇐ | physician_first_name | | clin.phys (Clinical System) | | |
| NPI | VARCHAR2 | ⇐ | physician_nat_prov_id | | clin.phys (Clinical System) | | |
| |