1. HCM Data Loading Business Objects
  2. Columns and Event Source Objects for Time and Labor Events

Columns and Event Source Objects for Time and Labor Events

When defining a Time and Labor event, you must provide values for the Column Name (ColumnName) and Event Source Object Name (DatedObjectName) attributes. This topic lists the values of these attributes for each Time and Labor event.

Event

Column Name

Event Source Object Name

Marital Status

MARITAL_STATUS

oracle.apps.hcm.people.core.protectedModel.entity.PersonLegislativeInfoDEO

Home Location

ADDRESS_ID

oracle.apps.hcm.addresses.publicModel.entity.AddressDEO

Effective Start Date

EFFECTIVE_START_DATE

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Effective End Date

EFFECTIVE_END_DATE

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Business Unit

BUSINESS_UNIT_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Grade Ladder

GRADE_LADDER_PGM_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Working Hours

NORMAL_HOURS

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Standard Working Hours

TOTAL_HOURS

oracle.apps.hcm.employment.core.publicModel.entity.WorkingHourPatternDEO

Job

JOB_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Grade

GRADE_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Is Manager

MANAGER_FLAG

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Location

LOCATION_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Position

POSITION_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Worker Category

EMPLOYEE_CATEGORY

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Assignment Category

EMPLOYMENT_CATEGORY

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Regular or Temporary

PERMANENT_TEMPORARY_FLAG

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Full-Time or Part-Time

FULL_PART_TIME

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Person Type

PERSON_TYPE_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Hourly Paid or Salaried

HOURLY_SALARIED_CODE

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Frequency

FREQUENCY

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Working at Home

WORK_AT_HOME

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Legal Employer

LEGAL_ENTITY_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Department

ORGANIZATION_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Reporting Establishment

ESTABLISHMENT_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Bargaining Unit

BARGAINING_UNIT_CODE

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Collective Agreement

COLLECTIVE_AGREEMENT_ID

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Union Member

LABOR_UNION_MEMBER_FLAG

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Overtime Period

OVERTIME_PERIOD

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Manager

MANAGER_ID

oracle.apps.hcm.employment.core.publicModel.entity.AssignmentSupervisorDEO

Work Day Definition

WORK_DAY_DEF_ID

oracle.apps.hcm.employment.core.publicModel.entity.WorkingHourPatternDEO

Assignment DFFs

Provide the column name for the global context DFF.

oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO

Related Topics