Oracle Fusion · Data dictionary
ANC_PER_ACRL_ENTRY_DTLS
HCM AbsenceUsed in 0 subject areas52 reporting columnsBICC incremental-ready
Absence Management (ANC).
Likely primary key: ANC_PER_BEN_ELCTD_DISB_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADJUSTMENT_REASON | ● | Adjustment reason. | |
| ADJ_EXP_DT | ● | Adj exp date. | |
| ADJ_EXP_DT_REASON_CD | ● | Adj exp date reason code. | |
| ANC_PER_ACRL_ENTRY_DTLS_ALTCD | ● | Anc per acrl entry dtls altcd. | |
| ANC_PER_BEN_ELCTD_DISB_ID | PK? | ● | Identifier for the anc per ben elctd disb. |
| APPROVAL_STATUS_CD | ● | Approval status code. | |
| APPROVAL_SUBMITTED_DATE | ● | Approval submitted date. | |
| ASSIGNMENT_ID | ● | Identifier for the assignment. | |
| BEN_DISB_FIXED | ● | Ben disb fixed. | |
| BEN_DISB_PROCESSED | ● | Ben disb processed. | |
| BEN_DISB_PROC_ERROR | ● | Ben disb proc error. | |
| COMP_ADJ_REASON_CD | ● | Comp adj reason code. | |
| COVR_ENTRY_DTL_ID | ● | Identifier for the covr entry dtl. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DON_POOL_PLAN_ID | ● | Identifier for the don pool plan. | |
| DON_TYPE | ● | Type of don. | |
| ELECTED_AMT | ● | Elected amount. | |
| ELECTION_DT | ● | Election date. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| EXP_DISB_PAY_PUSH | ● | Exp disb pay push. | |
| EXP_DT | ● | Exp date. | |
| 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. | |
| LEGAL_EMPLOYER_ID | ● | Identifier for the legal employer. | |
| LOADER_REF_ID | ● | Identifier for the loader reference. | |
| 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_TYPE_ENTRY_ID | ● | Identifier for the per abs type entry. | |
| PER_ACCRUAL_ENTRY_DTL_ID | ● | Identifier for the per accrual entry dtl. | |
| PER_ACCRUAL_ENTRY_ID | ● | Identifier for the per accrual entry. | |
| PER_EVENT_ID | ● | Identifier for the per event. | |
| PER_PLAN_ENRT_ID | ● | Identifier for the per plan enrt. | |
| PL_ID | ● | Identifier for the pl. | |
| PROCD_DATE | ● | Procd date. | |
| PROC_STATUS_CD | ● | Proc status code. | |
| RECIPIENT_PLAN_ENRT_ID | ● | Identifier for the recipient plan enrt. | |
| REFERENCE_DATE | ● | Reference date. | |
| REF_ID | ● | Identifier for the reference. | |
| REPROCESS_REQUIRED | ● | Reprocess required. | |
| SOURCE | ● | Source. | |
| TIME_CARD_ID | ● | Identifier for the time card. | |
| TIME_CARD_VERSION | ● | Time card version. | |
| TYPE | ● | Type. | |
| USER_MODE | ● | User mode. | |
| VALUE | ● | Value. | |
| VOIDED_ACRL | ● | Voided acrl. | |
| VOIDED_BY | ● | Voided by. | |
| VOIDED_DATETIME | ● | Voided datetime. | |
| WORK_TERM_ASG_ID | ● | Identifier for the work term asg. |
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_ACRL_ENTRY_DTLS?
We ship parameterized SQL, BICC config, and dbt models you own.