Extract Deleted Object Details

Extract the key details of deleted objects using the Event Object Changes user entity, HRC_EVT_OBJ_CHANGES_UE.

The method relies on the data captured using the HCM Events framework. You need to purge this data periodically by using the Purge HCM Event Archive Data process for an improved application response.

After extracting the details, send that information to your downstream applications. To extract the deleted object details, you need to include the filter, Event Object Changes operation type in = ('DELETE', 'DELETE CHANGES', 'ZAP'). This table lists the tracked objects and keys.

Objects

Tables

Primary Key Attributes

Primary Key Columns

SalaryEO

CMP_SALARY

SalaryId

SALARY_ID

EvaluationEO

HRA_EVALUATIONS

EvaluationId

EVALUATION_ID

ProfileInterestEO

HRT_PROFILE_INTERESTS

ProfileInterestId

PROFILE_INTEREST_ID

ProfileKeywordEO

HRT_PROFILE_KEYWORDS

ProfileKeywordId

PROFILE_KEYWORD_ID

Element Entry

PAY_ELEMENT_ENTRIES_F

ElementEntryId

ELEMENT_ENTRY_ID

ApplicantAssignmentDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

ApplicantTermsDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

CWKTermsDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

EmployeeAssignmentDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

EmployeeTermsDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

NWAssignmentDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

NWTermsDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

OfferAssignmentDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

OfferTermsDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

PWAssignmentDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

PWTermsDEO

PER_ALL_ASSIGNMENTS_M

AssignmentId

ASSIGNMENT_ID

AssignmentExtraInfoDEO

PER_ASSIGNMENT_EXTRA_INFO_M

AssignmentExtraInfoId

ASSIGNMENT_EXTRA_INFO_ID

AssignmentSupervisorDEO

PER_ASSIGNMENT_SUPERVISORS_F

AssignmentSupervisorId

ASSIGNMENT_SUPERVISOR_ID

AssignGradeStepsDEO

PER_ASSIGN_GRADE_STEPS_F

AssignGradeStepId

ASSIGN_GRADE_STEP_ID

AssignmentWorkMeasureDEO

PER_ASSIGN_WORK_MEASURES_F

AssignWorkMeasureId

ASSIGN_WORK_MEASURE_ID

CitizenshipEO

PER_CITIZENSHIPS

CitizenshipId

CITIZENSHIP_ID

ContactRelationshipDEO

PER_CONTACT_RELSHIPS_F

ContactRelationshipId

CONTACT_RELATIONSHIP_ID

DriversLicenceEO

PER_DRIVERS_LICENSES

DriversLicenseId

DRIVERS_LICENSE_ID

EmailAddressEO

PER_EMAIL_ADDRESSES

EmailAddressId

EMAIL_ADDRESS_ID

ExternalIdentifierEO

PER_EXT_APP_IDENTIFIERS

ExternalIdentifierId

EXT_IDENTIFIER_ID

NationalIdentifierEO

PER_NATIONAL_IDENTIFIERS

NationalIdentifierId

NATIONAL_IDENTIFIER_ID

PassportEO

PER_PASSPORTS

PassportId

PASSPORT_ID

PersonExtraInfoDEO

PER_PEOPLE_EXTRA_INFO_F

PersonExtraInfoId

PERSON_EXTRA_INFO_ID

PeriodOfServiceEO

PER_PERIODS_OF_SERVICE

PeriodOfServiceId

PERIOD_OF_SERVICE_ID

PersonEO

PER_PERSONS

PersonId

PERSON_ID

PersonAddressUsageDEO

PER_PERSON_ADDR_USAGES_F

PersonAddrUsageId

PERSON_ADDR_USAGE_ID

PersonNameDEO

PER_PERSON_NAMES_F

PersonNameId

PERSON_NAME_ID

PhoneEO

PER_PHONES

PhoneId

PHONE_ID

RateValueDEO

PER_RATE_VALUES_F

RateValueId

RATE_VALUE_ID

VisaPermitDEO

PER_VISAS_PERMITS_F

VisaPermitId

VISA_PERMIT_ID

A few things to consider when using the operation types:

  • Use the DELETE operation type to identify deletes of nondate-effective objects.

  • Use the DELETE CHANGES operation type to identify deletes of one or more date effective changes for a date-effective object.

  • Use the ZAP operation type to identify deletes of a date-effective object including the delete of all its date-effective changes.

  • Use the Purge HCM Event Archive Data process to purge the data periodically and improve the application response. The method relies on data captured using the HCM Events framework.

  • Ignore the deleted objects that appear multiple times in the extract results. Multiple events might record one delete and therefore a deleted object might appear many times in the extract results.