Human Capital Management Descriptive Flexfields for Oracle Transactional Business Intelligence

You can use these Human Capital Management descriptive and extensible flexfields with Oracle Transactional Business Intelligence. The reference tables include the:

• Oracle HCM Cloud page where the flexfield appears.

• Folder in Transactional Business Intelligence that contains the flexfield after you import it.

To see which subject area a folder is located in, see Data Lineage for Oracle Human Capital Management Cloud. Go to Help for Business Intelligence in Oracle Applications Cloud and click the Data Lineage link under Oracle Human Capital Management Cloud.

These are the descriptive flexfields.

Descriptive Flexfield Code and Name	Location in Oracle HCM Cloud	Location in Transactional Business Intelligence
ANC_ABSENCE_CATEGORIES_DFF Absence Category Attributes	Manage Absence Categories	Dimension: Assignment Absences Details
ANC_ABSENCE_PLANS_DFF Absence Plan Attributes	Manage Absence Plans	Dimension: Assignment Absences Details
ANC_ABSENCE_REASONS_DFF Absence Reason Attributes	Manage Absence Reasons	Dimension: Assignment Absences Details
ANC_ABSENCE_TYPES_DFF Absence Type Attributes	Manage Absence Types	Dimension: Assignment Absences Details
HNS_INCIDENTS_DFF Incident Details	Safety Incidents	Dimension: Incident Details
HNS_ACTIONS_DFF Incident Action Details	Safety Incidents	Dimension: Incident Action Details
HNS_INJURED_PERSON_DFF Injured Person	Safety Incidents	Dimension: Incident Event Details/Injury or Illness
HNS_INJURED_PERSON_SUMMARY_DFF Injured Person Summary	Safety Incidents	Dimension: Incident Event Details/Injury or Illness
HNS_INVEST_SUMMARY_DFF Investigation Summary	Safety Incidents	Dimension: Incident Investigation Details
HNS_AIR_QUALITY_EVT_DFF Air Quality Events	Safety Incidents	Dimension: Incident Event Details/Air Quality
HNS_ERGONOMIC_EVENTS_DFF Ergonomic Events	Safety Incidents	Dimension: Incident Event Details/Ergonomic
HNS_FIRE_OR_EXPLOSION_EVENTS_DFF Fire or Explosion Events	Safety Incidents	Dimension: Incident Event Details/Fire or Explosion
HNS_ISSUE_EVENTS_DFF Issue Events	Safety Incidents	Dimension: Incident Event Details/Issue
HNS_NEAR_MISS_EVENTS_DFF Near Miss Events	Safety Incidents	Dimension: Incident Event Details/Near Miss
HNS_VEHICLE_INCIDENT_DFF Vehicle Events	Safety Incidents	Dimension: Incident Event Details/Vehicle Incident
HNS_DRIVER_AND_VEHICLE_EVENTS_DFF Driver and Vehicle	Safety Incidents	Dimension: Incident Event Details/Vehicle Incident
HNS_NOTICE_OF_VIOLATION_EVENTS_DFF Notice of Violation Events	Safety Incidents	Dimension: Incident Event Details/Notice of Violation
HNS_PROPERTY_DAMAGE_EVENTS_DFF Property Damage Events	Safety Incidents	Dimension: Incident Event Details/Property Damage
HNS_SPILL_OR_RELEASE_EVENTS_DFF Spill or Release Events	Safety Incidents	Dimension: Incident Event Details/Spill or Release
HNS_SUGG_FOR_IMPROV_EVENTS_DFF Suggestion for Improvement Events	Safety Incidents	Dimension: Incident Event Details/Suggestion for Improvement
HNS_UNSAFE_ACT_EVENTS_DFF Unsafe Act Events	Safety Incidents	Dimension: Incident Event Details/Unsafe Act
HNS_UNSAFE_CONDITION_EVENTS_DFF Unsafe Condition Events	Safety Incidents	Dimension: Incident Event Details/Unsafe Conditions
HNS_RISK_ASSESSMENTS_DFF Risk Assessments	Safety Incidents	Dimension: Incident Details
HNS_UNAUTHD_SYSTEM_ACCESSES_DFF Unauthorized System Access Events	Safety Incidents	Dimension: Incident Event Details/ Unauthorized System Access Events
HNS_SUSPICIOUS_EMAIL_OR_CALLS_DFF Suspicious Email or Calls Events	Safety Incidents	Dimension: Incident Event Details/ Suspicious Email or Calls Events
HNS_OTHER_DATA_SECURITY_ISSUES_DFF Other Data Security Issues Events	Safety Incidents	Dimension: Incident Event Details/ Other Data Security Issues Events
HNS_LOST_OR_STOLEN_DEVICES_DFF Lost or Stolen Device Events	Safety Incidents	Dimension: Incident Event Details/ Lost or Stolen Device Events
PER_ACT_DFF Additional Action Attributes	Manage Employment Actions	Dimension: HR Action
PER_ACT_LEG_DDF Legislative Action Attributes	Manage Actions	Dimension: HR Action
PER_ACT_REASONS_DFF Additional Action Reason Attributes	Manage Employment Actions	Dimension: HR Action Reason
PER_ADDRESSES_DFF	Manage Person	Dimension: Location
PER_ALL_PEOPLE_DFF	Manage Person	Dimension: Person Details
PER_ASG_DF Assignment Attributes	Employment Assignment	Dimension: Worker Assignment Details
PER_ASG_LEG_DDF Legislative Assignment Attributes	Employment Information page, Assignment tab for these tasks: Add Contingent Worker Manage Employment Add Assignment Add Employment Terms (Also appears on the Terms tab for this task) Employment Information page, Assignments tab, Contracts region (Single Contract Single Assignment) for these tasks: Hire an Employee Add NonWorker Add Pending Worker Create Work Relationship Job Details page in Manager Self-Service (Line Manager) for these tasks: Promote Transfer Change Working Hours	Dimension: Worker Assignment Details Assignment Event Details
PER_CITIZENSHIPS_DFF Citizenship Attributes	Manage Person	Dimension: Person Citizenship
PER_CONTACT_RELSHIPS_DFF Contact Relationships Attributes	Manage Person	Dimension: Person Contact Relationship
PER_CONTRACT_DF Contract Attributes	Manage Employment - Employment Term	Dimension: Employment Contract Details
PER_CONTRACT_LEG_DDF Contract Legislative Information	Employment Information page, Terms tab, Contracts region (Single Contract Single Assignment) for these tasks for the Line Manager and HR Specialist: Hire an Employee Add NonWorker Add Pending Worker Create Work Relationship Also appears on these pages: Manage Employment (HR Specialist) - Terms tab Add Assignment - Employment Information page, Assignment tab Add Employment Terms -Employment Information page, Terms tab	Dimension: Employment Contract Details
PER_DOC_OF_RECORD_LEG_DDF Document of Record Legislative Information	Manage Documents of Record	Dimension: Document of Record Details
PER_DOC_OF_RECORD_LEG_DFF Documents of Record Attributes	Manage Documents of Record	Dimension: Document of Record Details
PER_DRIVERS_LICENSE_TYPES_DFF Drivers License Types Attributes	Manage Person	Dimension: Person Driver License
PER_EMAIL_ADDRESSES_DFF Email Addresses Attributes	Manage Person	Dimension: Person Email Addresses
PER_ETHNICITIES_DFF Ethnicity Attributes	Manage Person	Dimension: Person Ethnicity
PER_GRADES_DF Grade Additional Details	Manage Grades	Dimension: HR Grade
PER_JOBS_DFF Job Attributes	Manage Jobs	Dimension: Job
PER_JOB_FAMILY_DFF Job Family Attributes	Manage Job Family	Dimension: Job
PER_LOCATIONS_DF Location Attributes	Manage Location	Dimension: Worker Location
PER_NATIONAL_IDENTIFIERS_DFF National Identifiers Attributes	Manage Person	Dimension: Person National Identifiers
PER_ORGANIZATION_UNIT_DFF Organization Attributes	Manage Department	Dimension: Department
PER_PERSON_ADDR_USG_DFF Person Address Usage Attributes	Manage Person	Dimension: Person Address
PER_PERSON_ALLOCATION_DDF Person Allocated Task Attributes	Allocated Checklists	Workforce Management: Checklist Real Time Allocated Checklist
PER_PERSON_CONTACT_RELATIONSHIP_DDF Person Contact Relationship Information	Manage Person	Dimension: Person Contact Information
PER_PERSON_DISABILITY_DFF Person Disability Attributes	Manage Person	Person Disability
PER_PERSON_DISABILITY_LEG_DDF Person Disability Legislative Information	Manage Person	Person Disability
PER_PERSON_DLVRY_METHODS_DFF Delivery Methods Attributes	Manage Person	Dimension: Person Delivery Methods
PER_PERSONDRIVERS_LICENSE_LEG_DDF Person Drivers License Legislative Information	Manage Person	Dimension: Person Driver License
PER_PERSON_LEGISLATIVE_DATA_LEG_DDF Person Legislative Information	Manage Person and New Hire	Dimension: Person Legislative Information
PER_PERSON_LEGISLATIVE_DFF Person Legislative Attributes	Legislative section of Manage Person	Dimension: Person Legislative Information
PER_PERSON_NAME_DFF	Manage Person	Dimension: Person Names
PER_PERSON_NAME_LEG_DDF Person Name Legislative Information	Not exposed	Dimension: Person Names
PER_PERSON_PASSPORT_LEG_DDF Person Passport Legislative Information	Manage Person and New Hire	Dimension: Person Passport Details
PER_PERSON_TYPE_USG_DFF	Manage Person	Dimension: Person Types
PER_PERSON_VISA_LEG_DDF Person Visa Legislative Information	Manage Person and New Hire	Dimension: Person Work Permit
PER_PERSONS_DFF Persons Attributes	New Hire	Dimension: Worker
PER_PHONES_DFF Phones Attributes	Manage Person	Dimension: Person Phones
PER_POSITIONS_DFF Position Attributes	Manage Position	Dimension: HR Position
PER_PPS_LEG_DDF Work Relationship Legislative Information	Employment Information page, Work Relationship Details region for Line Manager and HR Specialist for these tasks: Hire an Employee Add Contingent Worker Add NonWorker Add Pending Worker Create Work Relationship Manage Work Relationship (HR Specialist) - Work Relationship Details Work Relationship Details region in these tasks: Manager Self-Service (Line Manager and HR Specialist), Terminate Manage Work Relationship (HR Specialist)	Dimension: Work Relationship Details
PER_PPS_DF Work Relationship Attributes	Manage Work Relationship, Termination, Add Person, Create Work Relationship	Dimension: Work Relationship Details
PER_RELIGIONS_DFF Religions Attributes	Manage Person	Dimension: Person Religion
PER_VISA_PERMIT Visa Permit Attributes	Manage Person	Dimension: Person Work Permit
Requisition DFF (attributes from IRC_REQUISITION_B)	Job Requisitions	Dimension: Job Requisition - Additional Details
Offer DFF (Attributes from IRC_OFFERS)	Job Offers	Dimension: Job Offer - Basic Information
Offer – Assignment DFF (from PER_ALL_ASSIGNMENTS_M DFF; ASS_ATTRIBUTE%)	Job Offers	Dimension: Job Offer - Assignment Details
DFF for referrals (under requisition – referrals, IRC_RF_REFERRALS_DFF)	Agency Portal Job Applications	Dimension: Job Requisition - Job Referrals

These are the extensible flexfields in HCM (Core HR and Payroll).

Extensible Flexfield Name and Code	Location in Oracle HCM Cloud	Location in Transactional Business Intelligence
PER_ASSIGNMENT_EIT_EFF	Hire an Employee (Line Manager and HR Specialist) - Employment Information page, Assignment tab Hire an Employee (Line Manager and HR Specialist) - Employment Information Page, Contracts Region (Single Contract Single Assignment) Manage Employment (HR Specialist) - Assignment tab	Dimension: Worker Assignment Details
PER_JOBS_EIT_EFF	Manage Jobs	Dimension: Job
PER_JOBS_LEG_EFF	Manage Jobs	Dimension: Job
PER_LOCATION_INFORMATION_EFF	Manage Locations	Dimension: Worker Location
PER_LOCATION_LEG_EFF	Manage Locations	Dimension: Worker Location
PER_ORGANIZATION_INFORMATION_EFF	Manage Departments	Dimension: Department
PER_PERSON_EIT_EFF	Manage Person	Fact - Person
PER_POSITIONS_EIT_EFF	Manage Positions	Dimension: HR Position
PER_POSITIONS_LEG_EFF	Manage Positions	Dimension: HR Position
Action Occurrence EFF (PER_ACTION_OCC_EIT_EFF)	Manage Employment	Dimension: Assignment Action Occurence Details