38Integrations with Absence Management, Payroll, and Projects

This chapter contains the following:

Using Time and Labor with Absence Management

Basic Process to Integrate Absence Management and Time and Labor

Let people report absences and view accrual balances on their time cards by integrating Oracle Absence Management Cloud with Oracle Time and Labor Cloud. You can find details about the absence management setup tasks in the Oracle Global Human Resources Cloud Implementing Absence Management guide. The time and labor tasks are in the Setup and Maintenance work area. They're part of the Workforce Deployment offering, Time and Labor functional area.

Absence Management Setup

Create the absence management configurations that support your absence and time management policies. Here are key requirements when integrating with Time and Labor.

  1. Make sure that a work schedule exists for each person's primary assignment.

  2. Set the absence type units of measure to Hours.

  3. Enable the absence type for time card entry.

  4. Enroll people in absence accrual plans that are associated with the absence type. Make sure that the plan balances are up to date.

Time Entry Setup

Create the time entry configurations that support your time and absence reporting policies, as summarized here.

Diagram showing how payroll, absence management,
project costing, and custom time attributes make up time entry layout
components. Layout components can be time card fields or web clock
buttons. The components and time categories make up the layouts of
a layout set. Layouts include time entry, view, review, and approval
notification layouts. They can also include calendar time entry, responsive
UI, shift, cost overrides, and web clock layouts. A layout set and
HCM groups make up worker time entry profiles.

Also, create the time collection device configurations, as appropriate.

Diagram showing how time device event mappings
make up time device event mapping sets and time rules and rule sets
make up time rule sets. These mapping and rule sets, along with time
device export data configurations and HCM groups make up worker time
device processing profiles.

Time Processing Setup

Create the time processing configurations that support your time and absence processing policies, as summarized here.

Diagram showing how time categories and repeating
time periods make up time consumer sets. Time categories also can
make up time rules and rule sets. Repeating periods, time consumer
sets, rule sets, and HCM groups make up worker time processing profiles.

You can need people to work excess hours outside of their regular work schedule, such as overtime hours or hours worked on a holiday. You can convert these excess hours to earned compensatory time off, also known as time off in lieu (TOIL), instead of monetary compensation. People can then record absences against the defined compensatory plan specific to your policies when they take time off in the future.

Here's how people earn and use compensatory time:

  1. They report earned time on the same Oracle Time and Labor Cloud time cards that they use to report regular worked hours. This earned time transfers to Oracle Absence Management Cloud and updates the corresponding plan balance.

  2. They apply for paid time off using the corresponding compensatory absence plan.

To provide seamless integration between Time and Labor and Absence Management, you need to complete some setup tasks. When you're done, compensatory time reported on time cards will automatically transfer to the corresponding absence plans.

Here's what you need to do to implement compensatory time in Absence Management. The tasks are in the Absence Management work area.

  1. Create an absence plan with the Compensatory plan type and define the related attributes for compensatory time. Use the Absence Plans task.

  2. Create an absence type for compensatory time absence entry. Use the Absence Types task.

  3. Link the absence type to the compensatory time plan. Use the Absence Plans task.

After you define the absence plan and absence type, you can enroll people in the linked compensatory plan. Use the Absence Records task in the Person Management work area.

To report and calculate earned compensatory time and take compensatory absences you must complete these time entry and processing configuration tasks. They're in the Setup and Maintenance work area, Workforce Deployment offering, Time and Labor functional area.

Time Entry

Here are the time entry configuration tasks you need to complete.

Task Description

1

Generate Data Dictionary Time Attributes

Link time attributes stored in the data dictionary with any absence types enabled for time entry. These attributes identify the time data for transfer to Absence Management for processing.

The absence types make up the choice list for the Absence Management Type attribute. You use these choice list values when you create time card fields and web clock buttons. Time reporters use them when they report time worked and time off.

2

Time Entry Layout Components

Create a multiattribute time entry field that includes the time attributes Absence Management Type and Compensatory Time Absence Plan.

  • In one row, you select the absence management type that decrements the person's earned compensatory time--the compensatory absence.

  • In another row, you select the compensatory time absence plan that increments the person's earned compensatory time.

Optionally, create a dependent field to set an expiration date for earned compensatory time.

3

Time Layout Sets

Add the multiattribute field that includes compensatory time to the time entry, review, view, and approval notification layouts as well as the calendar entry layout. Optionally add the dependent expiration date field to the entry-level details page of each layout.

If you use responsive time cards, then add the multiattribute field to the responsive UI layout.

4

Worker Time Entry Profiles

Create profiles that link individuals and their managers to the layout set that includes the compensatory time fields.

Time Processing

Here are the time processing tasks you need to complete.

Task Description

1

Time Rule Templates

Create rule templates to calculate earned compensatory time, as needed. Use time categories in rule templates to identify the absence time data to use in the calculations.

You need to create rule templates for these conditions:

  • You use your own formulas.

  • You use multiattribute time card fields with more than one stored time attribute.

You can use delivered rule templates if the time card field or web clock button stores a single time attribute.

2

Time Rules

Create time rules using the rule templates.

  • Advanced time category rules identify time events and entries using complex logic not available in the condition components of a time category.

  • Time calculation rules generate earned compensatory time, which automatically transfers to Absence Management.

3

Time Rule Sets

Create collections of time calculation rules that generate earned compensatory time.

4

Worker Time Processing Profiles

Create profiles that link individuals and their managers to the time calculation rule set that generates earned compensatory time.

For people in the US to accurately accrue time off, the time entry process reads and stores the work location set in their assignments. You can let these people override the assignment work location on their time cards. Use these bundled time attributes: Work Location Overrides and Work Location with US Hierarchy Overrides. The data sources for the work location override time attributes use a bundled value set of valid HR work locations. You can create your own value set using the bundled set as a template.

You can also define time balances for people in the US using bundled time balance dimensions that include these location attributes:

  • State (area1)

  • County (area2)

  • City (area3)

Then, you can use the time balances and generated time balance database items in absence accrual formula to include time card hours in absence calculations. Here are descriptions of the supported actions for each time attribute.

Bundled Time Attribute Actions

Work Location Override

Overrides the work location of time balances used by absence accruals

Work Location with US Hierarchy Overrides

Overrides the work location of time balances used by absence accruals

Transfers the state, county, and city values to payroll for processing

Before you can override work locations, you need to correctly configure Global Payroll element and work location override objects. You also need to complete these time entry and processing configuration tasks in the Setup and Maintenance work area. They're part of the Workforce Deployment offering, Time and Labor functional area.

Task Description

1

Generate Data Dictionary Time Attributes

Associate time attributes stored in the data dictionary with payroll elements and element input values, known in Global Payroll as value definitions. These associations enable Global Payroll to process the transferred time data.

2

Time Entry Layout Components

Create the work location time card fields and select the data sources. You use the fields to configure time entry, review, view, approval, and calendar layouts. If you use responsive time cards, then you configure the responsive UI layout.

The bundled value set of HR work locations corresponds to organizational offices. For people who don't work in an office, such as remote workers or consultants, you can add dependent State, County, and City fields. These dependent fields enable them to provide the appropriate location details for their time entries.

You don't create layout components for third parties with this task. You do use layout components created with this task to configure these layouts:

  • Time card layouts that managers use to resolve device-related time exceptions

  • The approval notification layout

3

Time Layout Sets

Create different layout sets for the pages that individuals and managers use to enter, view, review, and approve time data, including work location overrides. Add override work location time entry fields when you want to let individuals or managers override the work location of the individual's assignment.

You don't create third-party device layouts with this task. You do use these layouts for these configurations:

  • Time card pages that managers use to resolve device-related time exceptions

  • The approval notification layout

4

Time Categories

Create and edit categories that identify the time entries to use in time balances, rules, summaries, and transfers based on your time and payroll policies.

5

Time Balance Dimensions

View the list of bundled time balance dimensions that use the US state, county, and city summation contexts, and the absence accrual period.

6

Time Balance Definitions

Create the time balance definitions to use in absence accrual fast formula. The time balance definition combines one of the bundled time balance dimensions and one or more time categories.

The balance dimension sums entries based on the US state (area1), county (area2), and city (area3) values. The created balance definition defines a database item that you can use in the absence accrual fast formula.

Using Time and Labor with Global Payroll

Basic Process to Integrate Global Payroll and Time and Labor

You can validate, approve, and transfer reported time to payroll for payment by integrating Oracle Global Payroll Cloud with Oracle Time and Labor Cloud.

  • You can find details about the payroll costing setup tasks in the Oracle Global Human Resources Cloud Implementing Payroll Costing guide.

  • You can find details about the global payroll setup tasks in the Oracle Global Human Resources Cloud Implementing Global Payroll guide.

  • The time and labor tasks are in the Setup and Maintenance work area. They're part of the Workforce Deployment offering, Time and Labor functional area.

Payroll Setup

Create the payroll costing and global payroll configurations that support your payroll and time management policies. Here are key requirements when integrating with Time and Labor.

  1. Configure payroll costing if you want to let people allocate time to different cost segments. It will also let people override default cost segments on their time cards.

  2. Create elements to store payroll time types from the time card and to transfer time to payroll or a third-party application for processing.

  3. Create rate definitions to show default and payroll calculated rates on time cards and get overrides from time card entries.

  4. Create the relevant calculation value definitions to link elements and rate definitions.

  5. Confirm that the Time Card Required field is selected on the Employment page for each person who reports time.

Time Entry and Collection Device Setup

Create the time entry configurations that support your time entry and payroll policies, as summarized in these diagrams. Here are some considerations when integrating with Global Payroll.

  • Make sure that dependent time card fields showing calculated rates provided by payroll populate new entries using the Based on payroll rate function.

  • You can use delivered payroll time card fields, such as Payroll Time Type and Assignment Number. If you don't have any changes to the delivered fields and display names, you can use the delivered payroll layout set.

Diagram showing how payroll, absence management,
project costing, and custom time attributes make up time entry layout
components. Layout components can be time card fields or web clock
buttons. The components and time categories make up the layouts of
a layout set. Layouts include time entry, view, review, and approval
notification layouts. They can also include calendar time entry, responsive
UI, shift, cost overrides, and web clock layouts. A layout set and
HCM groups make up worker time entry profiles.

Also, create the time collection device configurations, as appropriate.

Diagram showing how time device event mappings
make up time device event mapping sets and time rules and rule sets
make up time rule sets. These mapping and rule sets, along with time
device export data configurations and HCM groups make up worker time
device processing profiles.

Time Processing Setup

Create the time processing configurations that support your time processing and payroll policies, as summarized in the diagram. Here are some considerations to keep in mind when integrating with Global Payroll.

  • Repeating periods for reporting and approving time can be weekly or biweekly.

  • Approval periods need to match the reporting period so that the approval workflow tasks run as soon as people submit their time cards.

  • Payroll periods can be weekly, biweekly, semimonthly, or monthly.

Diagram showing how time categories and repeating
time periods make up time consumer sets. Time categories also can
make up time rules and rule sets. Repeating periods, time consumer
sets, rule sets, and HCM groups make up worker time processing profiles.

Create Time Card Elements for Time Entries

Time card elements support hours-based and units-based quantities. You use the hours-based quantifies to assign people a flat payment amount through associated rates. For example, you pay people a meal allowance according to the number of meals they take daily. The related payroll elements, balances, formulas, and calculation components are automatically generated when you create a time card element.

Tip: If people report regular and straight time portions of overtime separately, create two elements, such as Overtime and Overtime Premium. If they report the portions together, you might use straight time instead of regular time, and create a separate element for the overtime premium.

Create the Payroll Element

Here's how you create the time card element and corresponding calculation components.

  1. In the Setup and Maintenance work area, use the following:

    • Offering: Workforce Deployment

    • Functional Area: Elements and Formulas

    • Task: Manage Elements

  2. On the Manage Elements page toolbar, click the Create icon.

  3. On the Create Element dialog box, complete these steps:

    1. Select the legislative data group, such as FR LDG, Hong Kong LDG, or US LDG.

    2. Select the primary classification, such as Regular Earnings or Earnings.

    3. When available, select the secondary classification.

    4. Select the Time Card category.

    5. Click Continue.

  4. On the Create Element: Basic Information page, complete these steps:

    1. Enter a descriptive name, such as Regular, Straight Time, Overtime, or Shift Pay.

    2. Enter the name that you want to display on reports containing this payroll element.

    3. Select the effective date January 1, 1951. The early date ensures that the element attributes are immediately available to use with shifts, time cards, web clock, and time collection devices.

    4. Click Next to accept the remaining default values.

  5. On the Create Element: Additional Details page, complete these steps.

    1. Select either Hours * Rate or Other Units as the calculation units for reporting.

    2. Select the Work Units conversion rule. For the calculation used by each conversion rule, see the table in the next section.

    3. Click Next to accept the remaining default values.

  6. On the Create Element: Review page, complete these steps:

    1. Review the element configuration to ensure everything is correct.

    2. Click Submit to create the element and automatically generate all of the related elements, balances, formulas, and calculation components.

    By default, the Time Card category elements already have the appropriate value definition configurations required to support location overrides. You don't have to make any edits.

  7. On the Element Summary page, configure element eligibility by completing these steps:

    1. In the Elements Overview section, select Element Eligibility.

    2. On the Actions menu, select Create Element Eligibility.

    3. In the Information section, enter an element eligibility name with a suffix that identifies the criteria. For example, for the regular element with open eligibility--no selected criteria--the name would be Regular Open.

    4. Select the eligibility criteria. To leave eligibility open on the element and control it with HCM groups and time processing profiles, skip this step.

    5. Click Done.

Select the Work Units Conversion Rule

Use this information to help you select the correct conversion rule when you're configuring the additional details in the previous section.

Conversion Rule Calculation Example

Standard Rate Annualized

  1. Convert the source amount and periodicity to an annual value using default values of 2080 hours, 260 working days.

  2. Convert the amount to the required periodicity and rate.

N/A

Standard Rate Daily

  1. Calculate a daily rate using default value 260 working days.

  2. Convert the amount to the required output periodicity and rate.

N/A

Standard Working Hours Rate Annualized

  1. Convert the source amount and working hours to an annual value, using the employee's standard working hours.

  2. Calculate the rate.

Scenario: The employee works 40 hours a week with a monthly salary of 1000 US dollars.

Calculation: ((1000*12) / (40.00*52) = 5.77 an hour

Assignment Working Hours Rate Annualized

  1. Convert the source amount and working hours to an annual value, using the employee's working hours.

  2. Calculate the rate.

Scenario: The employee works 40 hours a week, with a 37.5 standard working hours a week, and a monthly salary of 1000 US dollars.

Calculation: ((1000*12) / (37.50*52) = 6.15 an hour

Periodic Work Schedule Rate Annualized

  1. Convert the monetary value and work schedule to an annual value, using the employee's work schedule for the payroll period for daily and hourly conversions.

  2. Calculate the rate.

Scenario for an employee assigned a monthly payroll:

  • The employee has a monthly salary of 1000 US dollars.

  • The formula checks the work schedule details for the month.

Daily conversion calculation: 1000 a month / 20 days in the month = 50

For an employee not assigned a payroll: The calculation uses the weekly rate and converts the result to an annual amount. The calculation then divides the annual amount by the number of days or hours in that week based on the work schedule.

Configure Element Eligibility for the Related Elements

Configure element eligibility for each of the related elements, which share the same name as this element and have suffixes. Suffixes include Earnings Calculator, Earnings Distributor, Earnings Results, Retro, and Retro Results.

  1. On the Manage Elements page, search for the element that you just created.

  2. Click the related element name.

  3. On the element summary page, complete these steps:

    1. In the Elements Overview section, select Element Eligibility.

    2. On the Actions menu, select Create Element Eligibility.

    3. In the Information section, configure the same eligibility criteria as the original element.

    4. Click Submit.

    5. Click Done.

Generate Time Attributes and Time Card Fields for Your Elements

After you create or edit earnings elements for time entries, such as Regular, Overtime, and Shift Pay, you generate time attributes for the data dictionary. Optionally, you can also generate time card fields for them.

Complete the processes in this table using the Time and Labor functional area in the Setup and Maintenance work area, Workforce Deployment offering.

Step Process Description Comments

1

Generate Data Dictionary Time Attributes, required

Creates dependent payroll attributes for all element input values, such as hours and rate

You must run the Generate Data Dictionary Time Attributes process after making any changes to time elements. Such changes include adding or deleting elements, editing input values, or editing element eligibility records.

Caution: Failure to run the process might negatively affect the setup of fields, validation of payroll time types, or transfers of time data to payroll.

2

Generate Time Card Fields, optional

Creates time card fields using time attributes from the data dictionary for the specified legislative data group

Instead of running this process, use the Time Entry Layout Components task to create time card fields and web clock buttons.

If you are using a third-party time provider, create an HCM extract for the time entry elements. The extract includes the element mapping ID that you specify in the XML file when you transfer the time entries to payroll.

Create the Units-Based Meals Taken Element for Time Entries

You're creating a units-based meals taken time card element with an associated flat rate from payroll.

Before You Start

Confirm that the Meal rate definition exists or create it using the Rate Definitions task in the Payroll Calculations work area.

Create the Time Card Element

Use the Elements task in the Setup and Maintenance work area. It's part of the Workforce Deployment offering, Elements and Formula functional area.

  1. On the Elements page, click the Create icon.

  2. On the Create Element dialog box, complete the fields, as shown here.

    Field Value

    Legislative Data Group

    FR LDG

    Primary Classification

    Earnings

    Category

    Time Card

  3. Click Continue.

Configure the Element

  1. On the Create Element: Basic Information page, complete the fields, as shown here.

    Field Value

    Name

    Meals Taken

    Reporting Name

    Meals Taken

    Description

    Units-based nonrecurring earnings element with an associated pay rate

    Effective Date

    January 1, 1951

  2. To accept the remaining default values, click Next.

  3. On the Create Element: Additional Details page, complete the fields, as shown here.

    Field Value

    What is the calculation rule?

    Meals Taken

    Does this element have a default rate definition?

    Yes

    Rate Name

    Meal Rate

    If you don't specify a default rate, the element uses the rate from the salary record.

    Effective Date

    January 1, 1951

  4. Click Next.

  5. On the Create Element: Review page, review the element configuration to ensure everything is correct.

  6. Click Submit.

Configure the Element Eligibility

  1. On the Element Summary: Meals Taken page, in the Elements Overview section, select Element Eligibility.

  2. On the toolbar Actions menu, select Create Element Eligibility.

  3. In the General Information section, Element Eligibility Name field, enter Meals Taken Open. Appending Open is a standard method to easily identify that no eligibility criteria constrains the people the element applies to. Time and labor administrators and managers typically constrain eligibility using HCM groups and worker time entry and processing setup profiles.

  4. Click Submit.

  5. Click Done.

Configure the Element Eligibility for Related Elements

Configure element eligibility for each of the related elements, which share the same name as this element and have suffixes. Suffixes include Earnings Calculator, Earnings Distributor, Earnings Results, Retro, and Retro Results.

  1. On the Elements page, search for the element that you just created.

  2. Click the related element name.

  3. On the element summary page, complete these steps:

    1. In the Elements Overview section, select Element Eligibility.

    2. On the toolbar Actions menu, select Create Element Eligibility.

    3. In the General Information section, Element Eligibility Name field, enter the element name and append the term Open, for example Meals Taken Earnings Calculator Open.

    4. Click Submit.

    5. Click Done.

Generate the Time Attributes in the Data Dictionary

Use the Generate Data Dictionary task in the Setup and Maintenance work area. It's part of the Workforce Deployment offering, Time and Labor functional area.

  1. On the Generate Data Dictionary Time Attributes page, in the Legislative Data Group field, select US LDG.

  2. Click Submit.

  3. On the Confirmation dialog box, click OK.

Using Time and Labor with Project Costing

Set Up Project Costing for Use with Time and Labor

Let people working on projects report their billable hours on time cards by integrating Oracle Project Costing Cloud and Oracle Time and Labor Cloud. With this integration, you can automatically validate reported project time entries and transfer validated entries to Project Costing. Here's what you need to do in Project Costing.

Classify Departments as Expenditure Organizations

To let people submit time cards, the department on the person's employment record has to be an expenditure organization. Here's how you classify a department as an expenditure organization. The tasks are in the Setup and Maintenance work area. They're part of the Project Financial Management offering, Project Organizations functional area.

  1. For each department, select the Classify as project expenditure organization check box. Use the Manage Project Organization Classifications task.

  2. To apply your changes, use the Submit Process to Maintain Project Organizations task.

Populate the Projects Table

You need to populate the Project Foundation tables because the project value sets are the data sources for these bundled time card fields. Use the Manage Project Foundation Value Sets task in the Project Financial Management offering, Project Foundation functional area.

  • Project Name for Project Team Members

  • Project Name

  • Project Number

  • Task Number

  • Project Unit

  • Expenditure Type

  • Expenditure Type Name

  • Organization

  • Expenditure Type Class (application linkage function)

  • Billable

  • Work Type

  • Optional Expenditure Type

  • Optional Expenditure Type Name

  • Optional Project Name

  • Optional Project Name for Project Team Members

  • Optional Project Number

  • Optional Project Number for Project Team Members

  • Optional Task Number

  • Optional task Number for Project Team Members

Overview of Time Entry Configuration for Only Project Costing and Project Costing and Payroll Combined

You can let people report only project costing time on time cards or project costing, payroll, and absence time. You can use bundled data sources, time card fields, layouts, HCM groups, and worker time entry profiles. They're already configured to support time reporting for only project costing, project costing according to team membership, or for project costing, payroll, and absences combined. You can also create your own configurations, as shown here.

View the bundled time card fields and data sources
(value sets) and decide whether to use the value sets. If yes, then
continue to the next object. If no, create your own value sets. View
the delivered layout set and decide whether to use the bundled time
card fields. If yes, then continue to the next decision. If no, or
you created your own value sets (data sources), then you must also
create time card fields that use your data sources. Next, decide whether
to use the bundled layout set. If yes, continue to the next object.
If no, or you created your own fields, you must also create one or
more layout sets to include them. View the bundled time entry profile
and decide whether to use it. If yes, then you decided to use all
of the bundled time entry objects. If no, or you created your own
layout sets, then you must create one or more time entry profiles.
Last, view the bundled group and decide whether to use it. If yes,
then you are done setting up time entry objects for project costing.
If no, create one or more groups. You must create your own time entry
profiles to associate with any groups that you create.

If you create your own value sets and time card fields, then you need to create your own layout sets and time entry profiles. You also need to create layout sets and profiles if you use bundled fields that aren't included in the bundled layout sets. For example, you want to track funding sources and expenditure organizations for sponsored projects using bundled fields. To do this, you need to create layout sets that include these fields and profiles that link to the new layout sets.

To use the bundled time entry configurations with your own HCM groups, you only need to create time entry profiles. You can link the bundled value sets, time card fields, and layout sets to your HCM groups using your profiles.

Tip: To save time if you create your own objects, search for and duplicate the closest bundled project costing or project costing and payroll object.

Initial Assignment Info and Payroll Relationships Setup

To let new hires report project costing work on time cards, you need to set up their initial assignment information and payroll relationships. Use the Hire an Employee task in the New Person work area. To view and maintain assignments and payroll relationships for existing employees, use the Employment and Payroll Relationships tasks in the Person Management work area.

To filter time card choice lists by project team membership, assign people to project teams. To enable team membership, edit the Projects Party table using the Manage Project Definition task in the Project Financial Management work area.

Bundled Project-Specific Time Card Fields and Data Sources

The bundled time repository includes project-specific time card fields and data sources to expedite time entry setup for project costing and project execution management. The bundled data sources are value sets.

Primary Assignment ID

Project time entry includes the bundled Primary Assignment ID time card field. The bundled data sources use the same private view object, List of Assignments, which contains all employees with a payroll relationship.

Single-Attribute Fields for Projects

Here are the project-specific single-attribute time card fields and the value sets that are their filtered and unfiltered data sources. Here also are the layout sets that use each field.

Bundled Projects Fields Bundled Value Set Layout Set

Project Number

Filtered: PJC_PROJECTS_NUMBER_EXPEND_T_V

Unfiltered: PJC_PROJECTS_NUMBER_EXPEND_A_T_V

Projects Layout Set

Optional Project Number

Filtered: PJC_PROJECTS_NUMBER_EXPEND_T_V

Unfiltered: PJC_PROJECTS_NUMBER_EXPEND_A_T_V

Projects and Payroll Layout Set

Project Number for Project Team Members

Filtered: PJC_PROJECTS_NUMBER_TEAMMEMBER_T_V

Unfiltered: PJC_PROJECTS_NUMBER_EXPEND_A_T_V

Projects Layout Set Filtered by Project Team Members

Project Unit

Filtered and unfiltered: PJC_PROJECT_UNIT_T_V

Projects Layout Set

Projects Layout Set Filtered by Project Team Members

Projects and Payroll Layout Set

Task Number

Filtered: PJC_TASKS_EXPEND_T_V

Unfiltered: PJC_TASKS_EXPEND_A_T_V

Projects Layout Set

Optional Task Number

Filtered: PJC_TASKS_EXPEND_T_V

Unfiltered: PJC_TASKS_EXPEND_A_T_V

Projects

Task Number for Project Team Members

Filtered: ORA_PJC_TASKS_EXPEND_TEAMMEMBER_T_V

Unfiltered: PJC_TASKS_EXPEND_A_T_V

Projects Layout Set Filtered by Project Team Members

Expenditure Type Name

Filtered: ORA_PJC_EXPENDITURE_TYPES_NAME_T_V

Unfiltered: ORA_PJC_EXPENDITURE_TYPES_NAME_A_T_V

Projects Layout Set

Projects Layout Set Filtered by Project Team Members

Expenditure Type Class

Filtered and unfiltered: PJC_EXPEND_TYPE_CLASS_T_V

Projects Layout Set

Projects Layout Set Filtered by Project Team Members

Projects and Payroll Layout Set

Expenditure Type(hidden)

Filtered: PJC_EXPENDITURE_TYPES_EXPEND_T_V

Unfiltered: PJC_EXPENDITURE_TYPES_EXPEND_A_T_V

Projects Layout Set

Projects Layout Set Filtered by Project Team Members

Projects and Payroll Layout Set

Multiple-Attribute Fields for Projects and Payroll

Here are the time attributes that provide the field definition structure for the multiattribute Time Type field. This field has time attributes for both Project Costing and Project Execution Management as well as Global Payroll. Here also are the corresponding bundled data sources.

Bundled Time Attribute Bundled Data Source Data Sources Type

Expenditure Type Name

Filtered: ORA_PJC_EXPENDITURE_TYPES_NAME_T_V

Unfiltered: ORA_PJC_EXPENDITURE_TYPES_NAME_A_T_V

Value set

Payroll Time Type

Filtered: List of Payroll Time Types for User

Unfiltered: List of Payroll Time Types for Administrator

Private view object

Absence Management Type

Filtered: List of Absence Types for User

Unfiltered: List of Absence Types for Administrator

Private view object

Identifier

Filtered and unfiltered: Default format value set for text

Value set

Choice List Filters for Project Costing Time Cards

Here's how time cards derive values for project-specific choice lists.

Projects That Are Correct for the Person

The time card finds the appropriate projects for the person using their business unit. If the time card also filters by team membership, the project names and numbers are for projects where the person is a team member.

Tasks That Are Correct for the Person

The time card finds the appropriate tasks for the person using the selected project name or number. If the time card also filters by team membership, the tasks are for projects where the person is a team member.

Expenditure Types That Are Correct for the Project

The time card finds the appropriate project unit using the selected project. The time card uses the derived project unit to find the appropriate expenditure types.

Overview of Time Card Processing Configuration for Only Project Costing and Project Costing and Payroll Combined

To process time data for only project costing or project and payroll combined you can use bundled time processing profiles. These profiles use bundled repeating time periods, time categories, time consumer sets, and HCM groups. They're already configured to support project-specific time processing. Or, you can create your own configurations, as shown here.

If you create any of your own repeating time periods, time categories, and time consumer sets, then you need to create your own processing profiles. To use the bundled time processing configurations with your own HCM groups, then you only need to create time processing profiles. You can link the bundled repeating time periods, time categories, and time consumer sets to your HCM groups using your profiles.

Diagram showing how time categories and repeating
time periods make up time consumer sets. Time categories also can
make up time rules and rule sets. Repeating periods, time consumer
sets, rule sets, and HCM groups make up worker time processing profiles.