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

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.

Talk to us