Power BI Connector for Oracle Fusion Cloud HCM

Build 26.0.9770

AbsencesabsenceEntryCertifications

Retrieves certifications associated with an absence entry.

Columns

Name Type SupportedFinders Description
AbsencespersonAbsenceEntryId [KEY] Long Unique identifier of absence.
AbsenceAggregationId Long Unique identifier for a group of assignments associated to a single set of entitlements.
AbsenceCertificationId Long Unique identifier of a certification associated with an absence.
AcceptedBy String Certification accepted by the user.
AcceptedDate Date Date of acceptance of the certification.
AcceptedFlag Bool Indicates whether the certification has been accepted or confirmed.
CaseId Long Absence case identifier associated with the certification.
CertificationCreationDate Date Date when the certification was created.
ClassificationCode String Classification of the certification, which could be either Entitlement or Documentation.
Comments String Comments when entering a certification.
CompleteFlag Bool Indicates whether the certification is completed.
ConfirmationDate Date Date of certificate confirmation.
ConfirmationReasonCode String Reason code for the certification confirmation.
CreatedBy String Creator of the certification.
CreationDate Datetime Creation date of the certification.
CertificationCreationMode String Mode of certification creation. It could either be on demand or system triggered.
Description String Description of the certification.
EvidenceSource String Evidence attached to the certification.
LastUpdateDate Datetime Last update date of the certification record.
LastUpdateLogin String Last update login date for the certification record.
LastUpdateType String Last update type of the certification.
LastUpdatedBy String User who last updated the certification.
LateReason String Reason for late certification.
PersonAbsenceEntryId Long PrimaryKey, findAbsenceUsingAllAbsParameters, findByAbsenceEntryId, findByAbsenceLinkages Absence entry identifier associated with a person.
PersonCertificationId [KEY] Long Certification identifier associated with a person.
ReceivedDate Date Received date on the certification.
ReceivedLateFlag Bool Indicates whether the certification is past its due date.
ReceivedFlag Bool Indicates whether the certification was received.
RequiredByDate Date Date when the certification is required.
RevisedPayEndDate Date Revised payment end date for the worker's entitlement.
RevisedPayPercentage Long Revised payment percentage for the worker's entitlement.
RevisedPayStartDate Date Revised payment start date for the worker's entitlement.
Status String Status of the certification.
TargetPlanAllFlag Bool Indicates whether the certification is associated to all qualified plans in the absence of that worker.
TargetPlanId Long Unique identifier of the target plan associated with the certification.
ValidUptoDate Date Date of certification validity.
VoidReasonCode String Reason for the certification to be voided.
VoidFlag Bool Indicates whether the certification is voided.
VoidedDate Date Date when the certification was voided.
Name String Name of the certification.
ClassificationCodeMeaning String Description of the classification code.
StatusMeaning String Description of the status of the certification.
CertificationCreationModeMeaning String Description of the mode of certification creation.
PersonId Long FindAbsenceUsingAllAbsParameters, findByAbsenceLinkages, findByPersonAbsenceTypeIdAndAbsDate, findByPersonAndAbsenceTypeId, findByPersonId Unique identifier of a person.
ConfirmationReasonMeaning String Description of the certification confirmation reason.
VoidReasonMeaning String Description of the reason for the certification to be voided.
LastUpdateTypeMeaning String Description of the last update type of the certification. The values for this field are Certification evaluation, Absence evaluation process, User Updated.
TargetPlanName String Target plan name where the revised payment percentage will be applied by the certification.
ConfirmActionFlag Bool Indicates whether the certification is confirmed or not.
ReviseDateActionFlag Bool Indicates whether the certification payment percentage dates can be revised.
UpdateDueDateActionFlag Bool Indicates whether the certification due date can be updated.
UpdateExpirationDateActionFlag Bool Indicates whether the certification expiration date can be updated.
VoidActionFlag Bool Indicates whether the certification can be voided.
AbsencePatternCd String FindByAbsenceLinkages Pattern code of the absence used to filter absence records.
AbsenceTypeId Long FindAbsenceUsingAllAbsParameters, findByAbsenceLinkages, findByAbsenceTypeId, findByPersonAbsenceTypeIdAndAbsDate, findByPersonAndAbsenceTypeId Unique identifier of the absence type used to filter absence records.
EndDate Date FindAbsenceUsingAllAbsParameters, findByAbsStartAndEndDate, findByPersonAbsenceTypeIdAndAbsDate End date used to filter absence records.
Finder String The named finder used to filter the records returned for this resource.
StartDate Date FindAbsenceUsingAllAbsParameters, findByAbsDate, findByAbsStartAndEndDate, findByAbsenceLinkages, findByPersonAbsenceTypeIdAndAbsDate Start date used to filter absence records.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770