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

ANC_ABSENCE_PLANS_F

HCM AbsenceUsed in 0 subject areas259 reporting columnsBICC incremental-ready

Absence Management (ANC).

Likely primary key: ABSENCE_PLAN_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): LEGISLATIVE_DATA_GROUP_ID → PER_LEGISLATIVE_DATA_GROUPS

Columns

ColumnKeyIn reportsDescription (inferred)
ABSENCE_DURATION_DEFN_ID●Identifier for the absence duration defn.
ABSENCE_DURATION_FORMULA_ID●Identifier for the absence duration formula.
ABSENCE_PLAN_IDPK?●Identifier for the absence plan.
ACCRUAL_METHOD_CD●Accrual method code.
ACCRUAL_MODE●Accrual mode.
ACCRUAL_VESTING_CD●Accrual vesting code.
ACC_DEFINITION_TYPE●Type of acc definition.
ACC_FORMULA_ID●Identifier for the acc formula.
ACC_NEGATIVE_BAL_FLAG●Indicator (Y/N) for the acc negative balance.
ACC_NEGATIVE_BAL_LIMIT●Acc negative balance limit.
ACC_NEGATIVE_BAL_UOM●Acc negative balance unit of measure.
ACC_PERIOD_FREQUENCY●Acc period frequency.
ACC_PERIOD_PAYROLL_FREQ_ID●Identifier for the acc period payroll freq.
ACC_PERIOD_WFM_CALEDAR_ID●Identifier for the acc period wfm caledar.
ANC_ABSENCE_PLANS_F_ALTCD●Anc absence plans f altcd.
ANC_CHAR1●Anc char1.
ANC_CHAR2●Anc char2.
ANC_CHAR3●Anc char3.
ANC_CHAR4●Anc char4.
ANC_CHAR5●Anc char5.
ANC_DATE1●Anc date1.
ANC_DATE2●Anc date2.
ANC_DATE3●Anc date3.
ANC_DATE4●Anc date4.
ANC_DATE5●Anc date5.
ANC_NUMBER1●Anc number1.
ANC_NUMBER2●Anc number2.
ANC_NUMBER3●Anc number3.
ANC_NUMBER4●Anc number4.
ANC_NUMBER5●Anc number5.
ANNIVERSARY_EVENT_FORMULA_ID●Identifier for the anniversary event formula.
ANNIVERSARY_EVENT_RULE●Anniversary event rule.
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE21●Descriptive flexfield segment.
ATTRIBUTE22●Descriptive flexfield segment.
ATTRIBUTE23●Descriptive flexfield segment.
ATTRIBUTE24●Descriptive flexfield segment.
ATTRIBUTE25●Descriptive flexfield segment.
ATTRIBUTE26●Descriptive flexfield segment.
ATTRIBUTE27●Descriptive flexfield segment.
ATTRIBUTE28●Descriptive flexfield segment.
ATTRIBUTE29●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE30●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE11●Descriptive flexfield segment.
ATTRIBUTE_DATE12●Descriptive flexfield segment.
ATTRIBUTE_DATE13●Descriptive flexfield segment.
ATTRIBUTE_DATE14●Descriptive flexfield segment.
ATTRIBUTE_DATE15●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER13●Descriptive flexfield segment.
ATTRIBUTE_NUMBER14●Descriptive flexfield segment.
ATTRIBUTE_NUMBER15●Descriptive flexfield segment.
ATTRIBUTE_NUMBER16●Descriptive flexfield segment.
ATTRIBUTE_NUMBER17●Descriptive flexfield segment.
ATTRIBUTE_NUMBER18●Descriptive flexfield segment.
ATTRIBUTE_NUMBER19●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER20●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
BALANCE_TRANSFER_FLAG●Indicator (Y/N) for the balance transfer.
CALENDAR_START_DAY●Calendar start day.
CALENDAR_START_MONTH●Calendar start month.
CARRY_OVER_EXPIRED_FLAG●Indicator (Y/N) for the carry over expired.
CARRY_OVER_EXPIRED_UNITS●Carry over expired units.
CARRY_OVER_EXPIRED_UOM●Carry over expired unit of measure.
CARRY_OVER_FLAT_AMT●Carry over flat amount.
CARRY_OVER_FORMULA_ID●Identifier for the carry over formula.
CARRY_OVER_PRORATE_FORMULA_ID●Identifier for the carry over prorate formula.
CARRY_OVER_PRORATE_RULE●Carry over prorate rule.
CARRY_OVER_RULE●Carry over rule.
CASHOUT_RATE_FORMULA_ID●Identifier for the cashout rate formula.
CASHOUT_RATE_ID●Identifier for the cashout rate.
CASHOUT_RATE_RULE●Cashout rate rule.
CASH_OUT_FLAG●Indicator (Y/N) for the cash out.
CEIL_LIMIT_FLAT_AMT●Ceil limit flat amount.
CEIL_LIMIT_FORMULA_ID●Identifier for the ceil limit formula.
CEIL_LIMIT_PRORATE_RULE●Ceil limit prorate rule.
CEIL_LIMIT_RULE●Ceil limit rule.
CEIL_LMT_PRORATE_FORMULA_ID●Identifier for the ceil lmt prorate formula.
COMP_EXP_ADJRSN●Comp exp adjrsn.
COMP_MNUL_ADJRSN●Comp mnul adjrsn.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DONATION_TYPE●Type of donation.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATEPK?●Start date of the effective-dated record.
EMP_ENRL_NEGATIVE_BALANCE_FLAG●Indicator (Y/N) for the emp enrl negative balance.
EMP_ENRL_POSITIVE_BALANCE_FLAG●Indicator (Y/N) for the emp enrl positive balance.
EMP_ENRL_TERMINATE_ENTL_FLAG●Indicator (Y/N) for the emp enrl terminate entl.
ENROLLMENT_END_FORMULA_ID●Identifier for the enrollment end formula.
ENROLLMENT_END_RULE●Enrollment end rule.
ENROLLMENT_START_FORMULA_ID●Identifier for the enrollment start formula.
ENROLLMENT_START_RULE●Enrollment start rule.
ENROLL_NEGATIVE_BALANCE_FLAG●Indicator (Y/N) for the enroll negative balance.
ENROLL_POSITIVE_BALANCE_FLAG●Indicator (Y/N) for the enroll positive balance.
ENROLL_TERMINATE_ENTL_FLAG●Indicator (Y/N) for the enroll terminate entl.
ENTERPRISE_ID●Identifier for the enterprise.
ENTITLEMENT_END_FORMULA_ID●Identifier for the entitlement end formula.
ENTITLEMENT_END_RULE●Entitlement end rule.
ENTITLEMENT_START_DATE●Entitlement start date.
ENTL_DEFINITION_TYPE●Type of entl definition.
ENTL_FORMULA_ID●Identifier for the entl formula.
ENTL_METHOD_CD●Entl method code.
EXPIRATION_ACTION_CD●Expiration action code.
EXPIRATION_LIMIT●Expiration limit.
EXPIRATION_TERM_CD●Expiration term code.
EXPIRATION_UOM_CD●Expiration unit of measure code.
INFORMATION1●Information1.
INFORMATION10●Information10.
INFORMATION11●Information11.
INFORMATION12●Information12.
INFORMATION13●Information13.
INFORMATION14●Information14.
INFORMATION15●Information15.
INFORMATION16●Information16.
INFORMATION17●Information17.
INFORMATION18●Information18.
INFORMATION19●Information19.
INFORMATION2●Information2.
INFORMATION20●Information20.
INFORMATION21●Information21.
INFORMATION22●Information22.
INFORMATION23●Information23.
INFORMATION24●Information24.
INFORMATION25●Information25.
INFORMATION26●Information26.
INFORMATION27●Information27.
INFORMATION28●Information28.
INFORMATION29●Information29.
INFORMATION3●Information3.
INFORMATION30●Information30.
INFORMATION4●Information4.
INFORMATION5●Information5.
INFORMATION6●Information6.
INFORMATION7●Information7.
INFORMATION8●Information8.
INFORMATION9●Information9.
INFORMATION_CATEGORY●Information category.
INFORMATION_DATE1●Information date1.
INFORMATION_DATE10●Information date10.
INFORMATION_DATE11●Information date11.
INFORMATION_DATE12●Information date12.
INFORMATION_DATE13●Information date13.
INFORMATION_DATE14●Information date14.
INFORMATION_DATE15●Information date15.
INFORMATION_DATE2●Information date2.
INFORMATION_DATE3●Information date3.
INFORMATION_DATE4●Information date4.
INFORMATION_DATE5●Information date5.
INFORMATION_DATE6●Information date6.
INFORMATION_DATE7●Information date7.
INFORMATION_DATE8●Information date8.
INFORMATION_DATE9●Information date9.
INFORMATION_NUMBER1●Information number1.
INFORMATION_NUMBER10●Information number10.
INFORMATION_NUMBER11●Information number11.
INFORMATION_NUMBER12●Information number12.
INFORMATION_NUMBER13●Information number13.
INFORMATION_NUMBER14●Information number14.
INFORMATION_NUMBER15●Information number15.
INFORMATION_NUMBER16●Information number16.
INFORMATION_NUMBER17●Information number17.
INFORMATION_NUMBER18●Information number18.
INFORMATION_NUMBER19●Information number19.
INFORMATION_NUMBER2●Information number2.
INFORMATION_NUMBER20●Information number20.
INFORMATION_NUMBER3●Information number3.
INFORMATION_NUMBER4●Information number4.
INFORMATION_NUMBER5●Information number5.
INFORMATION_NUMBER6●Information number6.
INFORMATION_NUMBER7●Information number7.
INFORMATION_NUMBER8●Information number8.
INFORMATION_NUMBER9●Information number9.
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.
LEGISLATION_CODE●Code identifying the legislation.
LEGISLATIVE_DATA_GROUP_ID●Identifier for the legislative data group.
LIABILITY_RATE_FORMULA_ID●Identifier for the liability rate formula.
LIABILITY_RATE_ID●Identifier for the liability rate.
LIABILITY_RATE_RULE●Liability rate rule.
MODULE_ID●Identifier for the module.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
OTHER_ADJUSTMENT_FLAG●Indicator (Y/N) for the other adjustment.
OTHER_REASONS●Other reasons.
OVERLAP_CD●Overlap code.
PARTIAL_ACCRUAL_FORMULA_ID●Identifier for the partial accrual formula.
PAYOUT_RATE_FORMULA_ID●Identifier for the payout rate formula.
PAYOUT_RATE_ID●Identifier for the payout rate.
PAYOUT_RATE_RULE●Payout rate rule.
PAYROLL_IMPACT_FLAG●Indicator (Y/N) for the payroll impact.
PAYROLL_MAPPING_ID●Identifier for the payroll mapping.
PAY_ADVANCES_FLAG●Indicator (Y/N) for the pay advances.
PAY_RATE_FACTOR●Pay rate factor.
PERIOD_UOM●Period unit of measure.
PLAN_ACTIVATION_FLAG●Indicator (Y/N) for the plan activation.
PLAN_MGMT_CD●Plan mgmt code.
PLAN_PERIOD_ID●Identifier for the plan period.
PLAN_PERIOD_TYPE●Type of plan period.
PLAN_STATUS●Status of the plan.
PLAN_UOM●Plan unit of measure.
PLAN_USE_FORMULA_ID●Identifier for the plan use formula.
PLAN_USE_RATE_ID●Identifier for the plan use rate.
PLAN_USE_RATE_RULE●Plan use rate rule.
PREV_EMP_ENTL_FLAG●Indicator (Y/N) for the prev emp entl.
PREV_EMP_USAGE_FLAG●Indicator (Y/N) for the prev emp usage.
PROCESSING_LEVEL_CD●Processing level code.
PRORATION_FORMULA_ID●Identifier for the proration formula.
PRORATION_RULE●Proration rule.
ROLL_BACKWARD_END_FORMULA_ID●Identifier for the roll backward end formula.
ROLL_BACKWARD_END_RULE●Roll backward end rule.
ROLL_FORWARD_START_FORMULA_ID●Identifier for the roll forward start formula.
ROLL_FORWARD_START_RULE●Roll forward start rule.
ROLL_PERIOD_DURATION●Roll period duration.
STATUTORY_FLAG●Indicator (Y/N) for the statutory.
VESTING_PERIOD_DURATION●Vesting period duration.
VESTING_PERIOD_FORMULA_ID●Identifier for the vesting period formula.
VESTING_PERIOD_UOM●Vesting period unit of measure.
WAIT_PERIOD_DUR_UNITS●Wait period dur units.
WAIT_PERIOD_DUR_UOM●Wait period dur unit of measure.

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