Oracle Fusion · Data dictionary
ANC_PER_ABS_ENTRIES
HCM AbsenceUsed in 0 subject areas60 reporting columnsBICC incremental-ready
Absence Management (ANC).
Primary key: not yet catalogued for ANC_PER_ABS_ENTRIES, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES · LEGISLATIVE_DATA_GROUP_ID → PER_LEGISLATIVE_DATA_GROUPS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ABSENCE_CASE_ID | ● | Identifier for the absence case. | |
| ABSENCE_ENTRY_BASIC_FLAG | ● | Indicator (Y/N) for the absence entry basic. | |
| ABSENCE_PATTERN_CD | ● | Absence pattern code. | |
| ABSENCE_STATUS_CD | ● | Absence status code. | |
| ABSENCE_TYPE_ID | ● | Identifier for the absence type. | |
| ABSENCE_TYPE_REASON_ID | ● | Identifier for the absence type reason. | |
| APPROVAL_DATETIME | ● | Approval datetime. | |
| APPROVAL_STATUS_CD | ● | Approval status code. | |
| ASSIGNMENT_ID | ● | Identifier for the assignment. | |
| AUTH_STATUS_UPDATE_DATE | ● | Auth status update date. | |
| BLOCKED_LEAVE_CANDIDATE | ● | Blocked leave candidate. | |
| CERTIFICATION_AUTH_FLAG | ● | Indicator (Y/N) for the certification auth. | |
| CHILD_EVENT_TYPE_CD | ● | Child event type code. | |
| COMMENTS | ● | Comments. | |
| CONDITION_START_DATE | ● | Condition start date. | |
| CONFIRMED_DATE | ● | Confirmed date. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DISEASE_CODE | ● | Code identifying the disease. | |
| DURATION | ● | Duration. | |
| END_DATE | ● | End date. | |
| END_DATETIME | ● | End datetime. | |
| END_DATE_DURATION | ● | End date duration. | |
| END_DT_DUR_PREF_CD | ● | End date dur pref code. | |
| END_TIME | ● | End time. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| ESTABLISHMENT_DATE | ● | Establishment date. | |
| FREQUENCY | ● | Frequency. | |
| INITIAL_REPORT_BY_ID | ● | Identifier for the initial report by. | |
| INITIAL_TIMELY_NOTIFY_FLAG | ● | Indicator (Y/N) for the initial timely notify. | |
| 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_NOTIFY_FLAG | ● | Indicator (Y/N) for the late notify. | |
| LEGAL_ENTITY_ID | ● | Identifier of the legal entity. | |
| LEGISLATION_CODE | ● | Code identifying the legislation. | |
| LEGISLATIVE_DATA_GROUP_ID | ● | Identifier for the legislative data group. | |
| NOTIFICATION_DATE | ● | Notification date. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| OPEN_ENDED_FLAG | ● | Indicator (Y/N) for the open ended. | |
| OVERRIDDEN | ● | Overridden. | |
| PERIOD_OF_INCAP_TO_WORK_FLAG | ● | Indicator (Y/N) for the period of incap to work. | |
| PERIOD_OF_SERVICE_ID | ● | Identifier for the period of service. | |
| PERSON_ID | ● | Identifier for the person. | |
| PER_ABSENCE_ENTRY_ID | ● | Identifier for the per absence entry. | |
| PLANNED_END_DATE | ● | Planned end date. | |
| PROCESSING_STATUS | ● | Status of the processing. | |
| PROJECT_ID | ● | Identifier for the project. | |
| SINGLE_DAY_FLAG | ● | Indicator (Y/N) for the single day. | |
| SOURCE | ● | Source. | |
| SPL_CONDITION | ● | Spl condition. | |
| START_DATE | ● | Start date. | |
| START_DATETIME | ● | Start datetime. | |
| START_DATE_DURATION | ● | Start date duration. | |
| START_DT_DUR_PREF_CD | ● | Start date dur pref code. | |
| START_TIME | ● | Start time. | |
| SUBMITTED_DATE | ● | Submitted date. | |
| TIMELINESS_OVERRIDE_DATE | ● | Timeliness override date. | |
| UOM | ● | Unit of measure. | |
| USER_MODE | ● | User mode. |
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_ENTRIES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table