Oracle Fusion · Data dictionary
HMO_MODEL_PLAN_DETAILS
SharedUsed in 0 subject areas107 reporting columnsBICC incremental-ready
detail-level data.
Likely primary key: MODEL_PLAN_DETAIL_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: ASG_FTE_LAST_UPDATE_DATE, ASG_LAST_UPDATE_DATE, ASG_SUP_LAST_UPDATE_DATE, CMP_LAST_UPDATE_DATE, GRADE_STEP_LAST_UPDATE_DATE, LAST_UPDATE_DATE, POS_EVAL_LAST_UPDATE_DATE, VACANCY_LAST_UPDATE_DATE
Joins (inferred from key columns): ACTION_REASON_ID → PER_ACTION_REASONS_B · LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES · MODEL_PLAN_ID → HMO_MODEL_PLANS_B · ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCEPTED_TERMINATION_DATE | ● | Accepted termination date. | |
| ACTION_ID | ● | Identifier for the action. | |
| ACTION_REASON_ID | ● | Identifier for the action reason. | |
| ACTUAL_TERMINATION_DATE | ● | Actual termination date. | |
| ANNUALIZED_SALARY_AMOUNT | ● | Annualized salary amount. | |
| ASG_FTE_LAST_UPDATE_DATE | INCR | ● | Asg fte last update date. |
| ASG_LAST_UPDATE_DATE | INCR | ● | Asg last update date. |
| ASG_SUPERVISOR_ID | ● | Identifier for the asg supervisor. | |
| ASG_SUP_LAST_UPDATE_DATE | INCR | ● | Asg sup last update date. |
| ASG_SUP_MANAGER_ASSIGNMENT_ID | ● | Identifier for the asg sup manager assignment. | |
| ASG_SUP_MANAGER_ID | ● | Identifier for the asg sup manager. | |
| ASSIGNMENT_ID | ● | Identifier for the assignment. | |
| ASSIGNMENT_NAME | ● | Name of the assignment. | |
| ASSIGNMENT_STATUS_TYPE | ● | Type of assignment status. | |
| ASSIGNMENT_TYPE | ● | Type of assignment. | |
| ASSIGN_GRADE_STEP_ID | ● | Identifier for the assign grade step. | |
| ASSIGN_WORK_MEASURE_ID | ● | Identifier for the assign work measure. | |
| BARGAINING_UNIT_CODE | ● | Code identifying the bargaining unit. | |
| BUSINESS_UNIT_ID | ● | Identifier for the business unit. | |
| CMP_LAST_UPDATE_DATE | INCR | ● | Cmp last update date. |
| CMP_SALARY_ID | ● | Identifier for the cmp salary. | |
| COLLECTIVE_AGREEMENT_ID | ● | Identifier for the collective agreement. | |
| COMMENTS | ● | Comments. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| EMPLOYEE_CATEGORY | ● | Employee category. | |
| EMPLOYMENT_CATEGORY | ● | Employment category. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| FREQUENCY | ● | Frequency. | |
| FULL_PART_TIME | ● | Full part time. | |
| GRADE_ID | ● | Identifier for the grade. | |
| GRADE_LADDER_PGM_ID | ● | Identifier for the grade ladder pgm. | |
| GRADE_STEP_ID | ● | Identifier for the grade step. | |
| GRADE_STEP_LAST_UPDATE_DATE | INCR | ● | Grade step last update date. |
| HIRING_STATUS | ● | Status of the hiring. | |
| HOURLY_SALARIED_CODE | ● | Code identifying the hourly salaried. | |
| INCLUDED_IN_BENCH | ● | Included in bench. | |
| INTERNAL_BUILDING | ● | Internal building. | |
| INTERNAL_FLOOR | ● | Internal floor. | |
| INTERNAL_MAILSTOP | ● | Internal mailstop. | |
| INTERNAL_OFFICE_NUMBER | ● | Internal office number. | |
| JOB_ID | ● | Identifier for the job. | |
| 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. | |
| LATEST_CHANGE | ● | Latest change. | |
| LEGAL_ENTITY_ID | ● | Identifier of the legal entity. | |
| LOCATION_ID | ● | Identifier for the location. | |
| MANAGER_ASSIGNMENT_ID | ● | Identifier for the manager assignment. | |
| MANAGER_FLAG | ● | Indicator (Y/N) for the manager. | |
| MANAGER_ID | ● | Identifier for the manager. | |
| MODEL_PLAN_ASG_TYPE | ● | Type of model plan asg. | |
| MODEL_PLAN_DETAIL_ID | PK? | ● | Identifier for the model plan detail. |
| MODEL_PLAN_DETAIL_TYPE | ● | Type of model plan detail. | |
| MODEL_PLAN_ID | ● | Identifier for the model plan. | |
| NORMAL_HOURS | ● | Normal hours. | |
| NOTIFIED_TERMINATION_DATE | ● | Notified termination date. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| OPEN_FTE | ● | Open fte. | |
| OPEN_HEAD_COUNT | ● | Open head count. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| PEOPLE_GROUP_ID | ● | Identifier for the people group. | |
| PERMANENT_TEMPORARY_FLAG | ● | Indicator (Y/N) for the permanent temporary. | |
| PERSON_ID | ● | Identifier for the person. | |
| POSITION_CODE | ● | Code identifying the position. | |
| POSITION_ID | ● | Identifier for the position. | |
| POSITION_OVERRIDE_FLAG | ● | Indicator (Y/N) for the position override. | |
| POSITION_TYPE | ● | Type of position. | |
| POS_EVAL_ACCOUNTABILITY | ● | Pos eval accountability. | |
| POS_EVAL_DATE_EVALUATED | ● | Pos eval date evaluated. | |
| POS_EVAL_EVALUATION_ID | ● | Identifier for the pos eval evaluation. | |
| POS_EVAL_EVALUATION_SYSTEM | ● | Pos eval evaluation system. | |
| POS_EVAL_KNOWHOW | ● | Pos eval knowhow. | |
| POS_EVAL_LAST_UPDATE_DATE | INCR | ● | Pos eval last update date. |
| POS_EVAL_MEASURED_IN | ● | Pos eval measured in. | |
| POS_EVAL_OVERALL_SCORE | ● | Pos eval overall score. | |
| POS_EVAL_PROBLEM_SOLVING | ● | Pos eval problem solving. | |
| PROBATION_PERIOD | ● | Probation period. | |
| PROBATION_UNIT | ● | Probation unit. | |
| PROJECTED_TERMINATION_DATE | ● | Projected termination date. | |
| REHIRE_AUTHORIZER_PERSON_ID | ● | Identifier for the rehire authorizer person. | |
| REHIRE_REASON | ● | Rehire reason. | |
| REHIRE_RECOMMENDATION | ● | Rehire recommendation. | |
| REQUISITION_INTERFACE_ID | ● | Identifier for the requisition interface. | |
| REQUISITION_NUMBER | ● | Requisition number. | |
| REVOKE_USER_ACCESS | ● | Revoke user access. | |
| SALARY_AMOUNT | ● | Salary amount. | |
| SALARY_BASIS_ID | ● | Identifier for the salary basis. | |
| SALARY_REVIEW_DATE | ● | Salary review date. | |
| SEASONAL_END_DATE | ● | Seasonal end date. | |
| SEASONAL_FLAG | ● | Indicator (Y/N) for the seasonal. | |
| SEASONAL_START_DATE | ● | Seasonal start date. | |
| SECURITY_CLEARANCE | ● | Security clearance. | |
| TIME_NORMAL_FINISH | ● | Time normal finish. | |
| TIME_NORMAL_START | ● | Time normal start. | |
| UNION_ID | ● | Identifier for the union. | |
| VACANCY_HIRED_HEADCOUNT | ● | Vacancy hired headcount. | |
| VACANCY_JOB_SCHEDULE | ● | Vacancy job schedule. | |
| VACANCY_LAST_UPDATE_DATE | INCR | ● | Vacancy last update date. |
| VACANCY_OPEN_HEADCOUNT | ● | Vacancy open headcount. | |
| VACANCY_UNLIMITED_HIRE | ● | Vacancy unlimited hire. | |
| VALIDATION_ERROR | ● | Validation error. | |
| VALIDATION_STATUS | ● | Status of the validation. | |
| WORK_AT_HOME | ● | Work at home. | |
| WORK_MEASURE_FTE | ● | Work measure fte. |
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 HMO_MODEL_PLAN_DETAILS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table