Analytics Catalog/Data dictionary/PER_WORKING_HOUR_PATTERNS_F
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
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

ColumnKeyIn reportsDescription (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_DATEPK?●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_DATEINCR●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_IDPK?●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.
Talk to us