Oracle fusion HCM: Extracts User Entities

Product	Business need	User Entity Name (BASE_USER_ENTITY_NAME)	Note
HR	Job, Position, Grade, Location, Department, Legal Employer, Operating Unit	PER_EXT_WORKSTRUCTURES_UE
			PER_EXT_WORKSTRUCTURES_UE can be used in the Root block. Create child blocks for each of the Business object using block link on ENTITY_ID (eg: WORKSTCUTURE_UE.ENTITY_ID = PER_EXT_SEC_GRADE_UE.GRADE_ID ).
			Department: PER_EXT_SEC_ORGANIZATION_UE (in block criteria use classification code as 'DEPARTMENT'),
			Business Unit: PER_EXT_SEC_ORGANIZATION_UE (in block criteria use classification code as 'FUN_BUSINESS_UNIT'),
			Job: PER_EXT_SEC_JOB_UE,
			Grades: PER_EXT_SEC_GRADE_UE,
			Location: PER_EXT_SEC_LOCATION_UE.
HR	Organizations	PER_EXT_SEC_ORGANIZATIONS_UE	Used to retrieve all the organization based entities like Department (Classification code = ‘DEPARTMENT’), Legal Employer (Classification code = ‘HCM_LEMP’), Business Unit (Classification code = 'FUN_BUSINESS_UNIT'). Need to explicitly filter specific organization by the classification code. Should be used as a root.
HR	Job EEO Code	PER_JOBS_LEG_EFF_HRX_US_JOBS_UE
HR	List of valid grades	PER_POSITION_VALID_GRADES_UE	-
HR	List of all employees	PER_LEG_EMP_PERSON_UE	Includes contingent workers.
HR	All persons and person related attributes across the enterprise	PER_EXT_SEC_PERSON_UE	Used to retrieve all the Person related information. Should be used as a root.
HR	All the Person, Assignment, Salary related information	PER_EXT_SEC_ASSIGNMENT_UE	Should be used as a root.
			In order to get termination date use Entity PER_EXT_SEC_ASSIGNMENT_UE or PER_EXT_PAY_EMPLOYEE_UE as root. The Termination Date is property of Relationship and Assignment. Person Enterprise Termination Date should be used to get the last person termination date in the Enterprise.
HR	Reset	PER_EXT_RESET_UE	Used to organize sections at root level, it is a dummy container and if you need more than one of above user entities to be siblings. It is also used to reset effective date if you have used Historical User entities. Do not use this user entity unless you clearly know why it is used.
HR	List of employees and their addresses	PER_EXT_PERSON_ADDRESSES_UE	PER_EXT_PERSON_ADDRESSES_UE or PER_EXT_ADDRESSES_UE join with Usage Person id to parent block.
		PER_EXT_ADDRESSES_UE
HR	Future hired employees	PER_EXT_SEC_PERSON_NOW_FUTURE_UE	-
		PER_EXT_SEC_HISTORY_PERSON_UE
HR	Employee's area of responsibility	PER_EXT_PAY_EMPLOYEES_UE PER_EXT_ASG_RESPONSIBILITIES_UE	-
HR	Employee's Legal Seniority Date	PER_PERSON_ENTERPRISE_HIRE_DATE	This gives min(ppos.date_start) from periods of service (i.e. Enterprise Hire Date).
HR	Employee's Enterprise Seniority Date	PAYROLL_INTERFACE_ORIGINAL_DATE_OF_HIRE_UE	This gives min(pps.original_date_of_hire) from periods of services (i.e. Enterprise Seniority Date).
			Hire date is more driven by Work relationship. have PER_EXT_WORK_RELATIONSHIP_ALL_UE as root and create filter based on Extract relationship start date.
HR	Job name	PER_JOB_JOB_DETAILS_UE	This UE contains name of the job.
Absence	Absence data	HcmAbsMgmtAccruals	These modules contain Absence data DBIs.
		HcmEmploymentAbsences
		HcmGblAbsencesProcesses
		HcmGblAbsencesSetup
		HcmWfmCore
Payroll	Employee	PER_EXT_PAY_EMPLOYEES_UE	Used to retrieve all the Person, Assignment, Salary, Payroll (Payroll, Element Entries) information. Note: Payroll Interface User entity also serves same purpose and hence can be used in its place as a secondary user entity for specific needs.
Payroll	Historical and current Element Entry values for the Employee	PER_EXT_PAY_EMPLOYEES	PER_EXT_PAY_EMPLOYEES as root block and child as ELEMENT ENTRIES RANGE. Join both of them with Payroll Relationship Id in block link.
		ELEMENT ENTRIES RANGE
			If need to run extract with 'Change and Marked attribute' as parameter, set the PER_EXT_PAY_HR_ASSIGNMENT_ID as the threading DBI in your extract definition. Make Element Entry Value Id as the Key attribute.
Payroll	Employee Withholding Certificate (DIR)W4
Payroll	Payroll element run results	PAY_EXTRACT_RUN_RESULT_VALUES_UE