Module: Device Analytics
Type: Dimension
D1_ACTIVITY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| D1_ACTIVITY_ID | VARCHAR2 | 14 | True | Activity | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| A1_FIELD_TASK_ID | VARCHAR2 | 14 | Field Task Name | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| CANCEL_REASON | VARCHAR2 | 254 | Cancel Reason | ||||
| EFF_DTTM | TIMESTAMP | 0 | 6 | Effective Date/Time | |||
| END_DTTM | TIMESTAMP | 0 | 6 | End Date/Time | |||
| FIELD_TASK_TYPE | VARCHAR2 | 254 | Field Task Type | ||||
| START_DTTM | TIMESTAMP | 0 | 6 | Start Date/Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |