ANC_PER_ABS_CERTS

HCM AbsenceUsed in 0 subject areas35 reporting columnsBICC incremental-ready

Absence Management (ANC).

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

Columns

Column	Key	In reports	Description (inferred)
ABSENCE_CERTIFICATION_ID		●	Identifier for the absence certification.
ACCEPTED_BY		●	Accepted by.
ACCEPTED_DATE		●	Accepted date.
ACCEPTED_YN		●	Accepted yn.
CASE_ID		●	Identifier for the case.
CERT_CREATION_DATE		●	Cert creation date.
COMMENTS		●	Comments.
COMPLETED_DATE		●	Completed date.
COMPLETE_YN		●	Complete yn.
CONFIRM_RSN_CD		●	Confirm rsn code.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
CTFN_CREATION_MODE		●	Ctfn creation mode.
ENTERPRISE_ID		●	Identifier for the enterprise.
EVIDENCE_SOURCE		●	Evidence source.
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.
LATE_REASON		●	Late reason.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
PER_ABSENCE_ENTRY_ID		●	Identifier for the per absence entry.
PER_CERT_ID		●	Identifier for the per cert.
RECEIVED_DATE		●	Received date.
RECEIVED_LATE_YN		●	Received late yn.
RECEIVED_YN		●	Received yn.
REQUIRED_BY_DATE		●	Required by date.
REV_PAY_END_DT		●	Rev pay end date.
REV_PAY_PCT		●	Rev pay percent.
REV_PAY_START_DT		●	Rev pay start date.
STATUS		●	Status.
TARGET_PLAN_ID		●	Identifier for the target plan.
VALID_UPTO_DATE		●	Valid upto date.
VOIDED_DATE		●	Voided date.
VOID_RSN_CD		●	Void rsn code.
VOID_YN		●	Void yn.

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_CERTS?

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