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.