Module: Device Analytics
Type: Dimension
TD_ENTRY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TD_ENTRY_ID | VARCHAR2 | 14 | True | To Do | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ASSIGNED_DTTM | TIMESTAMP | 0 | 6 | Assigned Date/Time | |||
| COMMENTS | VARCHAR2 | 254 | Comments | ||||
| COMPLETE_DTTM | TIMESTAMP | 0 | 6 | Completion Date/Time | |||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| ENTRY_STATUS_FLG | VARCHAR2 | 2 | Status | ||||
| MESSAGE_CAT_NBR | NUMBER | 5 | 0 | Message Category | |||
| MESSAGE_NBR | NUMBER | 5 | 0 | Message Number | |||
| ROLE_ID | VARCHAR2 | 10 | To Do Role | ||||
| TD_PRIORITY_FLG | VARCHAR2 | 4 | Priority | ||||
| TD_TYPE_CD | VARCHAR2 | 8 | To Do Type | ||||
| TD_USAGE_TYPE_FLG | VARCHAR2 | 4 | To Do Type Usage | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |