Oracle Fusion · Data dictionary
PER_WORKING_HOUR_PATTERNS_F
HCMUsed in 0 subject areas82 reporting columnsBICC incremental-ready
Person / Worker (PER).
Likely primary key: WORKING_HOUR_PATTERN_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DEFAULT_START_DAY | ● | Default start day. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | PK? | ● | Start date of the effective-dated record. |
| FRI_END_TIME | ● | Fri end time. | |
| FRI_HOURS | ● | Fri hours. | |
| FRI_START_TIME | ● | Fri start time. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| MON_END_TIME | ● | Mon end time. | |
| MON_HOURS | ● | Mon hours. | |
| MON_START_TIME | ● | Mon start time. | |
| OBJECT | ● | Object. | |
| OBJECT_ID | ● | Identifier for the object. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PERSON_ID | ● | Identifier for the person. | |
| SAT_END_TIME | ● | Sat end time. | |
| SAT_HOURS | ● | Sat hours. | |
| SAT_START_TIME | ● | Sat start time. | |
| SUN_END_TIME | ● | Sun end time. | |
| SUN_HOURS | ● | Sun hours. | |
| SUN_START_TIME | ● | Sun start time. | |
| THU_END_TIME | ● | Thu end time. | |
| THU_HOURS | ● | Thu hours. | |
| THU_START_TIME | ● | Thu start time. | |
| TOTAL_HOURS | ● | Total hours. | |
| TUE_END_TIME | ● | Tue end time. | |
| TUE_HOURS | ● | Tue hours. | |
| TUE_START_TIME | ● | Tue start time. | |
| WED_END_TIME | ● | Wed end time. | |
| WED_HOURS | ● | Wed hours. | |
| WED_START_TIME | ● | Wed start time. | |
| WHP_ATTRIBUTE1 | ● | Whp attribute1. | |
| WHP_ATTRIBUTE10 | ● | Whp attribute10. | |
| WHP_ATTRIBUTE11 | ● | Whp attribute11. | |
| WHP_ATTRIBUTE12 | ● | Whp attribute12. | |
| WHP_ATTRIBUTE13 | ● | Whp attribute13. | |
| WHP_ATTRIBUTE14 | ● | Whp attribute14. | |
| WHP_ATTRIBUTE15 | ● | Whp attribute15. | |
| WHP_ATTRIBUTE16 | ● | Whp attribute16. | |
| WHP_ATTRIBUTE17 | ● | Whp attribute17. | |
| WHP_ATTRIBUTE18 | ● | Whp attribute18. | |
| WHP_ATTRIBUTE19 | ● | Whp attribute19. | |
| WHP_ATTRIBUTE2 | ● | Whp attribute2. | |
| WHP_ATTRIBUTE20 | ● | Whp attribute20. | |
| WHP_ATTRIBUTE3 | ● | Whp attribute3. | |
| WHP_ATTRIBUTE4 | ● | Whp attribute4. | |
| WHP_ATTRIBUTE5 | ● | Whp attribute5. | |
| WHP_ATTRIBUTE6 | ● | Whp attribute6. | |
| WHP_ATTRIBUTE7 | ● | Whp attribute7. | |
| WHP_ATTRIBUTE8 | ● | Whp attribute8. | |
| WHP_ATTRIBUTE9 | ● | Whp attribute9. | |
| WHP_ATTRIBUTE_CATEGORY | ● | Whp attribute category. | |
| WHP_ATTRIBUTE_DATE1 | ● | Whp attribute date1. | |
| WHP_ATTRIBUTE_DATE10 | ● | Whp attribute date10. | |
| WHP_ATTRIBUTE_DATE11 | ● | Whp attribute date11. | |
| WHP_ATTRIBUTE_DATE12 | ● | Whp attribute date12. | |
| WHP_ATTRIBUTE_DATE13 | ● | Whp attribute date13. | |
| WHP_ATTRIBUTE_DATE14 | ● | Whp attribute date14. | |
| WHP_ATTRIBUTE_DATE15 | ● | Whp attribute date15. | |
| WHP_ATTRIBUTE_DATE2 | ● | Whp attribute date2. | |
| WHP_ATTRIBUTE_DATE3 | ● | Whp attribute date3. | |
| WHP_ATTRIBUTE_DATE4 | ● | Whp attribute date4. | |
| WHP_ATTRIBUTE_DATE5 | ● | Whp attribute date5. | |
| WHP_ATTRIBUTE_DATE6 | ● | Whp attribute date6. | |
| WHP_ATTRIBUTE_DATE7 | ● | Whp attribute date7. | |
| WHP_ATTRIBUTE_DATE8 | ● | Whp attribute date8. | |
| WHP_ATTRIBUTE_DATE9 | ● | Whp attribute date9. | |
| WHP_ATTRIBUTE_NUMBER1 | ● | Whp attribute number1. | |
| WHP_ATTRIBUTE_NUMBER10 | ● | Whp attribute number10. | |
| WHP_ATTRIBUTE_NUMBER2 | ● | Whp attribute number2. | |
| WHP_ATTRIBUTE_NUMBER3 | ● | Whp attribute number3. | |
| WHP_ATTRIBUTE_NUMBER4 | ● | Whp attribute number4. | |
| WHP_ATTRIBUTE_NUMBER5 | ● | Whp attribute number5. | |
| WHP_ATTRIBUTE_NUMBER6 | ● | Whp attribute number6. | |
| WHP_ATTRIBUTE_NUMBER7 | ● | Whp attribute number7. | |
| WHP_ATTRIBUTE_NUMBER8 | ● | Whp attribute number8. | |
| WHP_ATTRIBUTE_NUMBER9 | ● | Whp attribute number9. | |
| WORKING_HOURS_TYPE | ● | Type of working hours. | |
| WORKING_HOUR_PATTERN_ID | PK? | ● | Identifier for the working hour pattern. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Subject areas
- ,
Need the extract + dbt staging for PER_WORKING_HOUR_PATTERNS_F?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table