Module: Work Asset Analytics
Type: Dimension
COMPLIANCE_TYPE_CD
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| COMPLIANCE_TYPE_CD | VARCHAR2 | 30 | True | Compliance Type | |||
| SOURCE_RECORD_ID | VARCHAR2 | 30 | Source Record Id | ||||
| ADDER_DAYS | NUMBER | 9 | 0 | Compliance Adder Days | |||
| ADDER_MONTHS | NUMBER | 9 | 0 | Compliance Adder Months | |||
| ADDER_YEARS | NUMBER | 9 | 0 | Compliance Adder Years | |||
| COMPLIANCE_CAT_CD | VARCHAR2 | 30 | Compliance Category | ||||
| COMPLIANCE_CLASS_FLG | VARCHAR2 | 4 | Compliance Class | ||||
| DEC_END_FLG | VARCHAR2 | 38 | December 31st | ||||
| END_MONTH_FLG | VARCHAR2 | 38 | End of Month | ||||
| END_YEAR_FLG | VARCHAR2 | 38 | End of Year | ||||
| INTERVAL_DAYS | NUMBER | 9 | 0 | Interval Days | |||
| INTERVAL_MONTHS | NUMBER | 9 | 0 | Interval Months | |||
| INTERVAL_YEARS | NUMBER | 9 | 0 | Interval Years | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |