Oracle Fusion · Data dictionary
PER_ALL_ASSIGNMENTS_M
HCMUsed in 21 subject areas129 reporting columnsBICC incremental-ready
Person / Worker (PER).
Primary key: ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE (Oracle's PER_ALL_ASSIGNMENTS_M_PK) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): ACTION_OCCURRENCE_ID → PER_ACTION_OCCURRENCES · ESTABLISHMENT_ID → HRT_ESTABLISHMENTS_B · LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES · ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_CODE | ● | Code identifying the action. | |
| ACTION_OCCURRENCE_ID | ● | Identifier for the action occurrence. | |
| ADJUSTED_FTE | ● | Adjusted fte. | |
| ALLOW_ASG_OVERRIDE_FLAG | ● | Indicator (Y/N) for the allow asg override. | |
| ANNUAL_WORKING_DURATION | ● | Annual working duration. | |
| ANNUAL_WORKING_DURATION_UNITS | ● | Annual working duration units. | |
| ANNUAL_WORKING_RATIO | ● | Annual working ratio. | |
| APPLICANT_RANK | ● | Applicant rank. | |
| ASSIGNMENT_ID | PK | ● | Identifier for the assignment. |
| ASSIGNMENT_NAME | ● | Name of the assignment. | |
| ASSIGNMENT_NUMBER | ● | Assignment number. | |
| ASSIGNMENT_SEQUENCE | ● | Assignment sequence. | |
| ASSIGNMENT_STATUS_TYPE | ● | Type of assignment status. | |
| ASSIGNMENT_STATUS_TYPE_ID | ● | Identifier for the assignment status type. | |
| ASSIGNMENT_TYPE | ● | Type of assignment. | |
| AUTO_END_FLAG | ● | Indicator (Y/N) for the auto end. | |
| BARGAINING_UNIT_CODE | ● | Code identifying the bargaining unit. | |
| BILLING_TITLE | ● | Billing title. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| BUSINESS_UNIT_ID | ● | Identifier for the business unit. | |
| CAGR_GRADE_DEF_ID | ● | Identifier for the cagr grade def. | |
| CAGR_ID_FLEX_NUM | ● | Cagr id flex number. | |
| CATEGORY_CODE | ● | Code identifying the category. | |
| COLLECTIVE_AGREEMENT_ID | ● | Identifier for the collective agreement. | |
| CONTRACT_ID | ● | Identifier for the contract. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DATE_PROBATION_END | ● | Date probation end. | |
| DEFAULT_CODE_COMB_ID | ● | Identifier for the default code combination. | |
| DUTIES_TYPE | ● | Type of duties. | |
| EFFECTIVE_END_DATE | PK | ● | End date of the effective-dated record. |
| EFFECTIVE_LATEST_CHANGE | PK | ● | Effective latest change. |
| EFFECTIVE_SEQUENCE | PK | ● | Effective sequence. |
| EFFECTIVE_START_DATE | PK | ● | Start date of the effective-dated record. |
| EMPLOYEE_CATEGORY | ● | Employee category. | |
| EMPLOYMENT_CATEGORY | ● | Employment category. | |
| ESTABLISHMENT_ID | ● | Identifier for the establishment. | |
| EXPENSE_CHECK_ADDRESS | ● | Expense check address. | |
| FREEZE_START_DATE | ● | Freeze start date. | |
| FREEZE_UNTIL_DATE | ● | Freeze until date. | |
| FREQUENCY | ● | Frequency. | |
| FULL_PART_TIME | ● | Full part time. | |
| GRADE_ID | ● | Identifier for the grade. | |
| GRADE_LADDER_PGM_ID | ● | Identifier for the grade ladder pgm. | |
| GSP_ELIGIBILITY_FLAG | ● | Indicator (Y/N) for the gsp eligibility. | |
| HOURLY_SALARIED_CODE | ● | Code identifying the hourly salaried. | |
| ID_FLEX_NUM | ● | Id flex number. | |
| INTERNAL_BUILDING | ● | Internal building. | |
| INTERNAL_FLOOR | ● | Internal floor. | |
| INTERNAL_LOCATION | ● | Internal location. | |
| INTERNAL_MAILSTOP | ● | Internal mailstop. | |
| INTERNAL_OFFICE_NUMBER | ● | Internal office number. | |
| JOB_ID | ● | Identifier for the job. | |
| JOB_POST_SOURCE_NAME | ● | Name of the job post source. | |
| LABOUR_UNION_MEMBER_FLAG | ● | Indicator (Y/N) for the labour union member. | |
| 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. | |
| LAST_WORKING_DATE | ● | Last working date. | |
| LEGAL_ENTITY_ID | ● | Identifier of the legal entity. | |
| LEGISLATION_CODE | ● | Code identifying the legislation. | |
| LINKAGE_TYPE | ● | Type of linkage. | |
| LOCATION_ID | ● | Identifier for the location. | |
| MANAGER_FLAG | ● | Indicator (Y/N) for the manager. | |
| NORMAL_HOURS | ● | Normal hours. | |
| NOTICE_PERIOD | ● | Notice period. | |
| NOTICE_PERIOD_UOM | ● | Notice period unit of measure. | |
| NOTIFICATION_DATE | ● | Notification date. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| OVERTIME_PERIOD | ● | Overtime period. | |
| PARENT_ASSIGNMENT_ID | ● | Identifier for the parent assignment. | |
| PEOPLE_GROUP_ID | ● | Identifier for the people group. | |
| PERIOD_OF_SERVICE_ID | ● | Identifier for the period of service. | |
| PERMANENT_TEMPORARY_FLAG | ● | Indicator (Y/N) for the permanent temporary. | |
| PERSON_ID | ● | Identifier for the person. | |
| PERSON_REFERRED_BY_ID | ● | Identifier for the person referred by. | |
| PERSON_TYPE_ID | ● | Identifier for the person type. | |
| POSITION_ID | ● | Identifier for the position. | |
| POSITION_OVERRIDE_FLAG | ● | Indicator (Y/N) for the position override. | |
| POSTING_CONTENT_ID | ● | Identifier for the posting content. | |
| PO_HEADER_ID | ● | Identifier for the purchase order header. | |
| PO_LINE_ID | ● | Identifier for the purchase order line. | |
| PRIMARY_ASSIGNMENT_FLAG | ● | Indicator (Y/N) for the primary assignment. | |
| PRIMARY_FLAG | ● | Indicator (Y/N) for the primary. | |
| PRIMARY_WORK_RELATION_FLAG | ● | Indicator (Y/N) for the primary work relation. | |
| PRIMARY_WORK_TERMS_FLAG | ● | Indicator (Y/N) for the primary work terms. | |
| PROBATION_PERIOD | ● | Probation period. | |
| PROBATION_UNIT | ● | Probation unit. | |
| PROJECTED_ASSIGNMENT_END | ● | Projected assignment end. | |
| PROJECTED_START_DATE | ● | Projected start date. | |
| PROJECT_TITLE | ● | Project title. | |
| PROPOSED_WORKER_TYPE | ● | Type of proposed worker. | |
| REASON_CODE | ● | Code identifying the reason. | |
| RECORD_CREATOR | ● | Record creator. | |
| RECRUITER_ID | ● | Identifier for the recruiter. | |
| RECRUITMENT_ACTIVITY_ID | ● | Identifier for the recruitment activity. | |
| REHIRE_AUTHORIZER_PERSON_ID | ● | Identifier for the rehire authorizer person. | |
| REHIRE_REASON | ● | Rehire reason. | |
| REHIRE_RECOMMENDATION | ● | Rehire recommendation. | |
| RETIREMENT_AGE | ● | Retirement age. | |
| RETIREMENT_DATE | ● | Retirement date. | |
| REVIEW_USER_ACCESS | ● | Review user access. | |
| SAL_REVIEW_PERIOD | ● | Sal review period. | |
| SAL_REVIEW_PERIOD_FREQUENCY | ● | Sal review period frequency. | |
| SENIORITY_BASIS | ● | Seniority basis. | |
| SET_OF_BOOKS_ID | ● | Ledger identifier for the row. | |
| SOFT_CODING_KEYFLEX_ID | ● | Identifier for the soft coding keyflex. | |
| SOURCE_ASSIGNMENT_ID | ● | Identifier for the source assignment. | |
| SOURCE_ORGANIZATION_ID | ● | Identifier for the source organization. | |
| SOURCE_TYPE | ● | Type of source. | |
| SPECIAL_CEILING_STEP_ID | ● | Identifier for the special ceiling step. | |
| STANDARD_FREQUENCY | ● | Standard frequency. | |
| STANDARD_HOURS | ● | Standard hours. | |
| STD_ANNUAL_WORKING_DURATION | ● | Std annual working duration. | |
| STEP_ENTRY_DATE | ● | Step entry date. | |
| SYSTEM_PERSON_TYPE | ● | Type of system person. | |
| TAX_ADDRESS_ID | ● | Identifier for the tax address. | |
| TERMINATION_DATE | ● | Termination date. | |
| TIME_NORMAL_FINISH | ● | Time normal finish. | |
| TIME_NORMAL_START | ● | Time normal start. | |
| UNION_ID | ● | Identifier for the union. | |
| VACANCY_ID | ● | Identifier for the vacancy. | |
| VENDOR_ASSIGNMENT_NUMBER | ● | Vendor assignment number. | |
| VENDOR_EMPLOYEE_NUMBER | ● | Vendor employee number. | |
| VENDOR_ID | ● | Identifier for the vendor. | |
| VENDOR_SITE_ID | ● | Identifier for the vendor site. | |
| WORK_AT_HOME | ● | Work at home. | |
| WORK_TERMS_ASSIGNMENT_ID | ● | Identifier for the work terms assignment. |
3 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to PER_ALL_ASSIGNMENTS_M.
- Credit Card Issuer Invoice Report
- Journal Approval Audit History Report
- Active Employee Details Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - Cost Accounting Real Time
- Costing - Fiscal Document Capture Transactions Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Innovation Management - Ideas Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transactions Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Resource Usage Real Time
- Manufacturing - Production Exceptions Real Time
- Manufacturing - Resource Usage Real Time
- Manufacturing - Workstation Supervision Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Real Time
- Project Costing - Actual Costs Real Time
- Project Costing - Expenditure Item Performance - Real Time
- Project Costing - Unprocessed Transactions Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for PER_ALL_ASSIGNMENTS_M?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table