Time Dimension
Module: Work Asset Analytics
Type: Dimension
F1_TIME_KEY
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| F1_TIME_KEY | NUMBER | 4 | 0 | True | Minute Key | ||
| SOURCE_RECORD_ID | VARCHAR2 | 38 | Source Record Id | ||||
| F1_AM_PM_IND | VARCHAR2 | 2 | AM/PM | ||||
| F1_HOUR_12_NUM | NUMBER | 2 | 0 | Hour (12 Hours) | |||
| F1_HOUR_KEY | NUMBER | 2 | 0 | Hour | |||
| F1_HOUR_NAME | VARCHAR2 | 2 | Hour Name | ||||
| F1_MINUTE_IN_DAY | NUMBER | 4 | 0 | Minute in Day | |||
| F1_MINUTE_IN_HOUR | NUMBER | 2 | 0 | Minute in Hour | |||
| F1_MINUTE_NAME | VARCHAR2 | 5 | Minute Name | ||||
| F1_MINUTE_NUM | NUMBER | 4 | 0 | Minute Number | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |