Analytics Catalog/Data dictionary/ANC_PER_ABS_CERTS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

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

ColumnKeyIn reportsDescription (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_DATEINCR●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.

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 ANC_PER_ABS_CERTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern