Module: Common
Type: Dimension
US_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| US_ID | VARCHAR2 | 12 | True | Usage Subscription | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| D1_SPR_CD | VARCHAR2 | 30 | Service Provider | ||||
| DIVISION_CD | VARCHAR2 | 30 | Division | ||||
| END_DTTM | TIMESTAMP | 0 | 6 | End Date/Time | |||
| MOST_RECENT_TRANS_DTTM | TIMESTAMP | 0 | 6 | Most Recent Transaction Date/Time | |||
| PROD_EXT_ID | VARCHAR2 | 60 | Our Name/ID in Their System | ||||
| SPR_EXT_REF_ID | VARCHAR2 | 60 | External Reference ID | ||||
| SPR_TYPE_FLG | VARCHAR2 | 4 | Service Provider Type | ||||
| START_DTTM | TIMESTAMP | 0 | 6 | Start Date/Time | |||
| TIME_ZONE_CD | VARCHAR2 | 10 | Time Zone | ||||
| USG_APPR_REQ_FLG | VARCHAR2 | 4 | Usage Approval | ||||
| US_CLASS_FLG | VARCHAR2 | 4 | Subscription Class | ||||
| US_STAT_COND_FLG | VARCHAR2 | 4 | Status Condition | ||||
| US_TYPE_CD | VARCHAR2 | 30 | Usage Subscription Type | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |