Module: Work Asset Analytics
Type: Dimension
SVC_HIST_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SVC_HIST_ID | VARCHAR2 | 12 | True | Service History | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ANNIVERSARY_DT | DATE | 0 | Anniversary Date | ||||
| ANNIVERSARY_VALUE | NUMBER | 18 | 7 | Anniversary Value | |||
| ASSET_SCORE_FLG | VARCHAR2 | 38 | Score | ||||
| BO_STATUS_CD | VARCHAR2 | 38 | Status | ||||
| EFF_DTTM | TIMESTAMP | 0 | 6 | Effective Date/Time | |||
| END_DTTM | TIMESTAMP | 0 | 6 | End Date/Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |