Module: Common
Type: Dimension
FACILITY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| FACILITY_ID | VARCHAR2 | 14 | True | Facility | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| D1_SVC_TYPE_CD | VARCHAR2 | 30 | Service Type | ||||
| FACILITY_TYPE_FLG | VARCHAR2 | 254 | Facility Type | ||||
| STATUS_UPD_DTTM | TIMESTAMP | 0 | 6 | Status Date/Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |