Oracle Fusion · Data dictionary
HR_ALL_POSITIONS_F
HCMUsed in 0 subject areas124 reporting columnsBICC incremental-ready
HR / Workforce (HR).
Primary key: not yet catalogued for HR_ALL_POSITIONS_F, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): ACTION_OCCURRENCE_ID → PER_ACTION_OCCURRENCES · ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_OCCURRENCE_ID | ● | Identifier for the action occurrence. | |
| ACTIVE_STATUS | ● | Status of the active. | |
| ANNUAL_WORKING_DURATION | ● | Annual working duration. | |
| ANNUAL_WORKING_DURATION_UNITS | ● | Annual working duration units. | |
| ASSIGNMENT_CATEGORY | ● | Assignment category. | |
| ATTRIBUTE1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE11 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE12 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE13 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE14 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE15 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE16 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE17 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE18 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE19 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE20 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE21 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE22 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE23 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE24 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE25 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE26 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE27 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE28 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE29 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE30 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE9 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_CATEGORY | ● | Descriptive flexfield context (structure definition). | |
| ATTRIBUTE_DATE1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE11 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE12 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE13 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE14 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE15 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE9 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER11 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER12 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER13 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER14 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER15 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER16 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER17 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER18 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER19 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER20 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER9 | ● | Descriptive flexfield segment. | |
| BARGAINING_UNIT_CD | ● | Bargaining unit code. | |
| BUDGETED_POSITION_FLAG | ● | Indicator (Y/N) for the budgeted position. | |
| BUDGET_AMOUNT | ● | Budget amount. | |
| BUDGET_AMOUNT_CURRENCY | ● | Budget amount currency. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| BUSINESS_UNIT_ID | ● | Identifier for the business unit. | |
| CALCULATE_FTE | ● | Calculate fte. | |
| CATEGORY_CODE | ● | Code identifying the category. | |
| COLLECTIVE_AGREEMENT_ID | ● | Identifier for the collective agreement. | |
| COST_CENTER | ● | Cost center. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DELEGATE_POSITION_ID | ● | Identifier for the delegate position. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | ● | Start date of the effective-dated record. | |
| ENTRY_GRADE_ID | ● | Identifier for the entry grade. | |
| ENTRY_STEP_ID | ● | Identifier for the entry step. | |
| FREQUENCY | ● | Frequency. | |
| FTE | ● | Fte. | |
| FULL_PART_TIME | ● | Full part time. | |
| FUNDED_BY_EXISTING_POSITION | ● | Funded by existing position. | |
| GRADE_LADDER_ID | ● | Identifier for the grade ladder. | |
| HIRING_STATUS | ● | Status of the hiring. | |
| JOB_ID | ● | Identifier for the job. | |
| 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. | |
| LOCATION_ID | ● | Identifier for the location. | |
| MAX_PERSONS | ● | Max persons. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| OVERLAP_ALLOWED | ● | Overlap allowed. | |
| PERMANENT_TEMPORARY_FLAG | ● | Indicator (Y/N) for the permanent temporary. | |
| POSITION_CODE | ● | Code identifying the position. | |
| POSITION_ID | ● | Identifier for the position. | |
| POSITION_SYNCHRONIZATION_FLAG | ● | Indicator (Y/N) for the position synchronization. | |
| POSITION_TYPE | ● | Type of position. | |
| PROBATION_PERIOD | ● | Probation period. | |
| PROBATION_PERIOD_UNIT_CD | ● | Probation period unit code. | |
| REQUISITION_TEMPLATE_ID | ● | Identifier for the requisition template. | |
| SEASONAL_END_DATE | ● | Seasonal end date. | |
| SEASONAL_FLAG | ● | Indicator (Y/N) for the seasonal. | |
| SEASONAL_START_DATE | ● | Seasonal start date. | |
| SECURITY_CLEARANCE | ● | Security clearance. | |
| STANDARD_WORKING_FREQUENCY | ● | Standard working frequency. | |
| STANDARD_WORKING_HOURS | ● | Standard working hours. | |
| STD_ANNUAL_WORKING_DURATION | ● | Std annual working duration. | |
| SUPERVISOR_ASSIGNMENT_ID | ● | Identifier for the supervisor assignment. | |
| SUPERVISOR_ID | ● | Identifier for the supervisor. | |
| TIME_NORMAL_FINISH | ● | Time normal finish. | |
| TIME_NORMAL_START | ● | Time normal start. | |
| UNION_ID | ● | Identifier for the union. | |
| WORKING_HOURS | ● | Working hours. |
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 HR_ALL_POSITIONS_F?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table