ANC_PER_ABS_PLAN_ENTRIES

HCM AbsenceUsed in 0 subject areas30 reporting columnsBICC incremental-ready

Absence Management (ANC).

Primary key: not yet catalogued for ANC_PER_ABS_PLAN_ENTRIES — reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE

Columns

Column	Key	In reports	Description (inferred)
ABSENCE_PAY_FACTOR		●	Absence pay factor.
ABSENCE_PLAN_ID		●	Identifier for the absence plan.
ABS_UNITS		●	Abs units.
ASSIGNMENT_ID		●	Identifier for the assignment.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
END_DATE		●	End date.
END_DATETIME		●	End datetime.
END_TIME		●	End time.
ENTERPRISE_ID		●	Identifier for the enterprise.
ENTITLEMENT_DATE		●	Entitlement date.
HEADER_ID		●	Identifier for the header.
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.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
PERSON_ID		●	Identifier for the person.
PER_ABSENCE_ENTRY_ID		●	Identifier for the per absence entry.
PER_ABS_PLAN_ENTRY_ID		●	Identifier for the per abs plan entry.
PER_ABS_PLN_SUMM_ENTRY_ID		●	Identifier for the per abs pln summ entry.
PER_ABS_TYPE_ENTRY_ID		●	Identifier for the per abs type entry.
PER_ACCRUAL_ENTRY_DTL_ID		●	Identifier for the per accrual entry dtl.
QUALIFICATION_DATE		●	Qualification date.
RATE_DEFINITION_ID		●	Identifier for the rate definition.
SCHEDULED_UNITS		●	Scheduled units.
START_DATE		●	Start date.
START_DATETIME		●	Start datetime.
START_TIME		●	Start time.
TM_REC_ID		●	Identifier for the tm rec.
UOM		●	Unit of measure.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Need the extract + dbt staging for ANC_PER_ABS_PLAN_ENTRIES?

We ship parameterized SQL, BICC config, and dbt models you own.