Most frequently used User Entities in HCM Extracts
Most frequently used User Entities in HCM Extracts

 1,875 total views

In this article we will look into the list of User Entities that can be used to design HCM Extracts.

Want to learn Fusion Technical tools? Check out this article.

If you are new to HCM Extracts, please go through the below posts to get an idea of it.

User Entities are the basic building blocks of HCM Extracts and without them we cannot start developing the HCM Extract.

Here is the list of UEs split by Person, Assignment, Setup, Current and History levels

Person Current User EntitiesDescription
PER_EXT_SEC_PERSON_UEReturns person data as on effective date for each person type.
PER_EXT_NATIONAL_IDENTIFIERS_UEExtract National Identifiers
PER_EXT_ADDRESSES_UEExtract Addresses
PER_EXT_PERSON_ADDRESSES_UEExtract Person Addresses
PER_EXT_PHONES_UEExtract Phones for a specific person as on specific date
PER_EXT_EMAIL_ADDRESSES_UEExtract E-Mail Addresses for a specific person as on specific date
PER_EXT_VISA_PERMITS_UEExtract Visa Permits
PER_EXT_CITIZENSHIPS_UEExtract Person Citizenships
PER_EXT_RELIGION_UEExtract Person Religions
PER_EXT_PASSPORT_UEExtract Passports
PER_EXT_APP_IDENTIFIERS_UEPerson External Application Identifiers
PER_EXT_PER_ALL_LEGISLATIVE_DETAILS_UEExtract People All Legislative Details
PER_EXT_DRIVING_LICENSE_UEExtract Driving License
PER_EXT_ALL_EMAIL_ADDRESSES_UEExtract E-Mail Addresses as on specific date
PER_EXT_ALL_PHONES_UEExtract Phones as on specific date
PER_EXT_PERSON_DIRECTS_HIERARCHY_UEExtract Person Directs Hierarchy
PER_EXT_PERSON_MANAGERS_HIERARCHY_UEExtract Person Managers Hierarchy
PER_PER_PHONES_UEPerson Phones
PER_PER_SENIORITY_DATES_UEExtract Person Seniority Dates
PER_SENIORITY_DATES_UEThis user entity is used for the seniority date information
PER_SENIORITY_HOURS_UEThis user entity is used for the seniority hours information for a hours based worker.
PER_SENIORITY_DATES_V3_SDC_UEThis user entity is used for the seniority date information for V3 . The Seniority date code should be provided as a context in this user entity
PER_SENIORITY_DATES_V3_UEThis user entity is used for the seniority date information for V3. This is an array UE
PER_SENIORITY_HOURS_V3_UEThis user entity is used for the seniority hours information for a hours based worker in V3 Seniority Dates
PER_PERSON_DLVRY_METHODS_UEPerson Delivery Methods
PER_PERSON_EIT_ALL_CONTEXT_UEPerson All Extra Information
PER_PERSON_EMAIL_ADDRESS_UEPerson E-mail Address
PER_PER_ALL_VISA_PERMITS_UEPerson All Visa Permits
PER_PER_CITIZENSHIPS_UEPerson Citizenships
PER_PER_CONTACTS_UEPerson Contacts
PER_PER_CONTACT_RELATIONSHIPS_UEExtract Person Contact Relationships
PER_PER_DISABILITIES_UEExtract Person Disabilities
PER_PER_DOCUMENTS_OF_RECORD_UEPerson Documents of Record
PER_PER_DRIVERS_LICENSE_TYPES_UEPerson Drivers License Type
PER_PER_EMAIL_ADDRESSES_UEPerson E-Mail Addresses
PER_PER_ETHNICITIES_ALL_UEExtract Person Ethnicity
PER_PER_NATIONAL_IDENTIFIERS_UEPerson National Identifiers
  
Person History and Future User EntitiesDescription
PER_EXT_SEC_PERSON_NOW_FUTURE_UECurrent and future person details.
PER_EXT_PERSON_CUR_FUTURE_BY_TYPE_UEExtract Current and Future Persons by Type
PER_EXT_PERSON_BY_TYPE_USAGE_UEReturns current and future person data for each person type.
PER_EXT_SEC_HISTORY_PERSON_UEHistoric details of a person.
PER_EXT_SEC_HISTORY_PERSON_V2_UEHistoric details of a person.
PER_PER_PEOPLE_HISTORY_UEArray type of User Entity that returns basic person history details for a person.
PER_PER_PASSPORT_UEPerson Passport History
PER_PER_HISTORY_PERSON_NAMES_UEPerson Name History
PER_EXT_HISTORY_ADDRESS_UEExtract Person Address History
PER_EXT_HISTORY_PERSON_NAMES_UEExtract Person Name History
  
Security User EntitiesDescription
PER_EXT_ASE_ROLES_UEExtract Global Roles
PER_EXT_USERS_UEExtract Users
PER_EXT_USER_ROLES_UEExtract Person User Roles
Assignment Current User EntitiesDescription
PER_EXT_SEC_ASSIGNMENT_UEAssignment data along with action details, as on effective date.
PER_EXT_PAY_EMPLOYEE_UEReturns Person, Assignment and Payroll details, as on effective date.
PER_EXT_PAY_EMPLOYEES_V2_UEReturns Person, Assignment and Payroll details, as on effective date.
PER_EXT_SEC_ASSIGNMENT_BASIC_UEAssignment data as on effective date.
PER_EXT_MANAGERS_UEExtract Managers
PER_EXT_MANAGER_DETAILS_UEExtract Manager Details
PER_EXT_MANAGER_HEADCOUNT_UEExtract Manager Headcount
PER_EXT_WORK_RELATIONSHIP_ALL_UEExtract Work Relationships
PER_EXT_WORK_RELATIONSHIP_UEPerson Work Relationships
PER_EXT_WORK_MEASURES_UEExtract Assignment Work Measures
PER_EXT_SCHEDULE_ASG_EXCEPTION_UEExtract Schedule Assignment Exception
PER_EXT_PEOPLE_GROUPS_UEExtract People Groups
PER_ASG_GRADE_RATE_VALUES_UEAssignment Grade Rate values
PER_ASG_SEQ_HISTORY_DETAILS_UEArray type of User Entity that returns historic assignment details for an assignment.
PER_ASG_WORKING_HOUR_PATTERNS_UEExtract Assignment Working Hour Patterns
PER_ASG_WORK_CONTACTS_NEW_UEExtract Assignment Contacts
PER_ASSIGNMENT_EIT_ALL_CONTEXT_UEAssignment All Extra Information
  
Assignment History or Future User EntitiesDescription
PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UECurrent and future assignments, should mostly be used with hire action code in filter criteria.
PER_EXT_SEC_HISTORY_ASSIGNMENTS_UEHistoric details of an assignment along with actions; sets the context such that all data is extracted as on assignment effective start date.
PER_EXT_SEC_ASSIGNMENT_RANGE_UEHistoric details of an assignment along with actions; all the data including child data is extracted as on effective date.
PER_EXT_ASSIGNMENT_BASIC_HISTORY_UEHistoric details of an assignment; sets the context such that all the data including child data is extracted as on assignment effective start date.
PER_PERSON_HISTORY_ASSIGNMENTS_UEArray type of User Entity that returns basic assignment history details for a person.
PER_EXT_HISTORY_WORK_MEASURES_UEExtract Work Measures History
PER_EXT_HIST_ASG_SUPERVISORS_UEExtract Assignment Supervisors History
  
Setup Current User EntitiesDescription
PER_EXT_SEC_ORGANIZATION_UEExtract Secured Organizations
PER_EXT_ORGANIZATION_TL_UEOrganization Translation
PER_EXT_ORGANIZATION_INFORMATION_UEExtract Organization Information
PER_EXT_ORGANIZATION_TREE_UEExtract Organization Tree
PER_EXT_ORG_ORG_INFORMATION_UEExtract Organization Information Array
PER_ORGANIZATION_TREE_UEOrganization Tree
PER_ORG_DEPARTMENT_TREE_ANCESTOR_UEOrganization Department Tree Ancestors
PER_ORG_DEP_TREE_DESCENDANT_UEDepartment Tree Descendants
PER_ORG_ORGANIZATION_HISTORY_UEOrganization History
PER_ORG_ORGANIZATION_TREE_ANCESTOR_UEOrganization Tree Ancestors
PER_ORG_ORG_TREE_DESCENDANT_UEOrganization Tree Descendants
PER_EXT_DEPARTMENT_TREE_UEExtract Department Tree
PER_EXT_SEC_LOCATION_UEExtract Secured Locations
PER_EXT_LOCATION_DETAILS_TL_UELocation Translation
PER_LOCATION_EXTRA_INFO_ALL_UELocation All Extra Information
PER_LOCATION_LEG_ALL_CONTEXT_UELocation All Legislative Information
PER_EXT_SEC_JOB_UEExtract Secured Jobs
PER_EXT_JOBS_TL_UEJob Translation
PER_EXT_JOB_FAMILY_TL_UEJob Family Translation
PER_EXT_JOB_EVALUATION_UEExtract Job Evaluations
PER_JOB_EXTRA_INFO_ALL_UEJob All Extra Information
PER_JOB_PROFILE_UEExtract Job Profiles
PER_JOB_LEG_ALL_CONTEXT_UEJob All Legislative Information
PER_JOB_VALID_GRADES_UEJob Valid Grades
PER_EXT_SEC_POSITION_UEExtract Secured Positions
PER_EXT_POSITIONS_TL_UEPosition Translation
PER_EXT_POSITION_EVALUATION_UEExtract Position Evaluations
PER_EXT_POSITION_EXTRA_INFORMATION_UEExtract Position Extra Information
PER_EXT_POSITION_TREE_UEExtract Position Tree
PER_POSITION_EXTRA_INFO_ALL_UEPosition All Extra Information
PER_POSITION_LEG_ALL_CONTEXT_UEPosition All Legislative Information
PER_POSITION_VALID_GRADES_UEPosition Valid Grades
PER_EXT_ACTIONS_UEExtract Action Reasons
PER_EXT_WORKSTRUCTURES_UEExtract All Work Structures Data
PER_EXT_SEC_GRADE_UEExtract Secured Grades
PER_EXT_GRADES_TL_UEGrade Translation
PER_EXT_GRADE_STEP_RATE_UEExtract Grade Step Rate
PER_GRADE_EXTRA_INFO_ALL_UEGrade All Extra Information
PER_GRADE_LEG_ALL_CONTEXT_UEGrade All Legislative Information
PER_GRADE_RATE_VALUES_UEGrade Rate values
PER_GSP_STEP_RATES_UEGrade step rates
PER_EXT_LOOKUPS_UEExtract Lookups
PER_EXT_SENIORITY_DATES_SETUP_UEExtract Seniority Dates Setup
PER_EXT_RESET_UEExtract Reset Contexts. Dummy user entity
PER_EXT_ROLES_UEExtract Roles
PER_EXT_CURRENCIES_UEExtract Currencies
PER_EXT_CALENDAR_COVERAGE_EVENTS_UEExtract Calendar Coverage Events
PER_EXT_CALENDAR_EVENTS_UEExtract Calendar Events
PER_EXT_COLLECTIVE_AGREEMENTS_UEExtract Collective Agreements
PER_EXT_CONTRACT_DETAILS_UEExtract Contract Details
PER_EXT_DISABILITIES_UEExtract Disabilities
PER_EXT_DOCUMENT_TYPES_UEExtract Document Types
PER_EXT_ESTABLISHMENT_UEExtract Establishments
PER_EXT_ASG_STATUS_DETAILS_UEExtract Assignment Status Types
PER_EXT_ASG_RESPONSIBILITIES_UEExtract Assignment Responsibilities
PER_EXT_PERSON_TYPES_UEExtract Person Status Types
PER_EXT_SCH_ASG_UESchedule Assignment
PER_EXT_SEC_LDG_UEExtract Secured Legislative Data Groups
PER_EXT_LEGAL_EMPLOYER_UEExtract Legal Employers
PER_EXT_LEGISLATIVE_DATA_GROUP_UELegislative Data Groups Details
PER_EXT_LEG_EMP_CONTACT_DETAILS_UEExtract Legal Employer Contact Details
PER_EXT_PSU_UEExtract Payroll Statutory Unit
PER_EXT_LRU_CONTACT_DETAILS_UEExtract Legal Reporting Unit Contact Details
PER_EXT_TAX_REPORTING_UNIT_UEExtract Tax Reporting Units
PER_SENIORITY_DATES_SETUP_UEThis user entity is used for the seniority dates configuration information.
Setup History User EntitiesDescription
PER_EXT_SEC_HISTORY_GRADE_UEExtract Secured Grades History
PER_EXT_SEC_HISTORY_POSITION_UEExtract Secured Positions History
PER_EXT_HISTORY_JOB_FAMILY_UEJob Family History
PER_EXT_SEC_HISTORY_JOB_UEExtract Secured Jobs History
PER_EXT_SEC_HISTORY_LOCATION_UEExtract Secured Locations History
PER_EXT_SEC_HISTORY_ORGANIZATION_UEExtract Secured Organizations History
PER_GRD_GRADE_HISTORY_UEGrade History
PER_JOB_JOB_HISTORY_UEJob History
PER_PERSON_TYPE_USAGES_HISTORY_UEPerson Type Usages History
PER_POS_POSITION_HISTORY_UEPosition History
List of User Entities for HCM Extracts

This is not an exhaustive list of extracts, however it will serve as a reference when you look for user entity names.

The Most frequently used list of User Entities are listed below for ease of use:

PER_EXT_PAY_EMPLOYEES_UE – Person, Assignment, Payroll, Compensation Info
PER_EXT_SEC_ASSIGNMENT_UE – Person and Assignment Info
PER_EXT_SEC_PERSONS_UE – Only Person Info
PER_EXT_SEC_ASSIGNMENT_RANGE_UE – Assignment History range Info.
PER_EXT_RESET_UE – Dummy User Entity for creating Inbound Interfaces or for resetting effective dates when using history UEs.

SQL Query for getting complete list of User Entities:

Select * from ff_user_entities_vl

Tip: Selecting the right UE for root data group is important step that you take before creating an extract. So choose it wisely

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has 3 Comments

  1. Anurag

    Hi Sricharan,

    Thanks a lot for posting useful information on user entities.
    It would be more helpful if you could also explain how to find common fields (DBI) that are used to link/join different user entities.
    I am from PeopleSoft background and found your this block very useful for my learning.

  2. Sricharan

    Thanks Anurag for the compliment. Even i am from peoplesoft background and learnt fusion in baby steps. Sure. I will post another article on how to identify the links between user entities.

  3. Anurag

    Thanks a lot!!

Leave a Reply