Templates information

Each section provides information about template-specific items for a template:

  • Columns

  • Error messages

  • Special Conditions

Data - Punch Template

The Data Punch Template imports transactional punches and supports import of punch data with custom break rules, provided those break rules are also defined in the destination environment.

Information about the Override Type field

The information that appears in the Override Type field differs between 2024.R1 Express Upgrade 11 and 2024.R1 Express Update 10 and earlier.

  • For UKG Pro WFM 2024.R1 Express Update 10 and earlier, the Override Type field in templates displays a numeric value instead of an ID. This occurs because the ID is stored in the system and then converted to a numeric value.

  • For UKG Pro WFM 2024.R1 Express Update 11 and later, the Override Type field in templates displays a value.

If your system is at Release 9 Express Update 11 and the Override Type field is still displaying numeric values, download the file and remap the Override Type as follows:

Numeric values and mapped values

This table lists numeric values and their corresponding mapped values.

Numeric Values

Mapped Values

1

Break In

2

In Punch

3

New Shift

4

Out Punch

Columns

Mandatory Columns

Optional Columns

Static Column Values

Person Number Punch DTM

  • Override type

  • Transfer

  • Work Rule

  • Cost Center

  • Labor Categories

Override types:

  • Break In

  • In Punch

  • New Shift

  • Out Punch

  • Custom Break Rules

Error Messages

S.No

Error Message

Reason for Error

Resolution

1

Duplicate punches not allowed.

A duplicate punch (dtm) is imported to UKG Pro Workforce Management( UKG Pro WFM) and the same punch data is already present in UKG Pro WFM.

Check the data for a duplicate punch.

2

ObjectRef with qualifier: "abc" could not be found.

An invalid person number is imported to UKG Pro WFM.

The system does not allow invalid persons for the Data Punch Import. Review the data and verify that there are no invalid person entries.

3

Employees do not have a Timekeeping Employee License or terminated.

A person does not have a license or the employment status is terminated.

Punches performed by terminated employees are not allowed.

Perform one of these options:

  • Change the employee's status to active.

  • Assign a Timekeeping license to the employee.

Special Conditions

Special Conditions

Values in the following columns are string (without a semi colon or comma):

  • Transfer

  • Work Rule

  • Cost Center

Values in the Labor Categories column have commas according to the levels of Labor Categories configured in the system. For example, if there are three labor categories configured in the system, then the value is sent in one of the following formats, depending upon which labor category the user wants to assign:

  • Fed101,,

  • ,,First Shift

  • Fed-101,SS Minnow 1,First Shift

Dependencies

N/A

Limitations

Punch DTM format is as follows and does not change based on changes in a Locale Policy: YYYY-MM-DDTHH:MM.

Partial Success

This template supports Partial Success. For example, if the import includes a total of 10 rows, 3 of which include incorrect data and 7 of which include correct data, the 7 rows with correct data are imported

Data - Accrual Balance

The Data - Accrual Balance import template performs accrual balance resets and updates.

Columns information

Mandatory Columns

Optional Columns

Static Column Values

Transaction TypePerson NumberEffective DateAccrual CodeAmount

Probation Amount

Transaction Types

  • Reset

  • Update

Error Messages

S.No

Error Message

Reason for Error

Correction Steps

1

Invalid Person Number : abc

Employee "abc" does not exist in the system. UKG Pro WFM does not allow accrual resets or updates to employees that are not in the system.

Enter a valid employee.

2

No Accrual Profile Assigned or the accrual code is not part of the profile.

The Accrual Profile is not assigned to the person being imported or the Accrual Codes in the associated Accrual Profile are not correct.

Confirm that the employee being imported has been assigned an Accrual Profile and that the Accrual Codes in the employee's Accrual Profile are correct.

3

Amount is Too Large: Max Value : 9999

The Amount column contains a value greater then 9999

Enter a value less than or equal to 9999.

Special Conditions

Special Conditions

N/A

Dependencies

Accrual Profile must be assigned to the employee.

Limitations

N/A

Partial Success

Partial Success is supported

Data Pay Code Edit

The Data Pay Code Edit import template imports pay code edits.

Columns information

Mandatory Columns

Optional Columns

Static Values

Person Number

Apply date

Type

Paycode

Amount

Start Time

Job Path

Cost Center

Labor categories

Types:

  • Day

  • Hour

  • Money

Person Number

Apply Date

Paycode Type

Paycode

Type

Amount

Symbolic Amount

Start Time

End Time

Job Path

Cost Center

Labor categories

Paycode Type:

  • Duration

  • Regular / Cascade

If a paycode type is not indicated, the system defaults to Regular / Cascade paycode type.

Type:

  • Day

  • Hour

  • Money

Error Messages

S.No

Error Message

Reason for Error

Correction Steps

4

Unexpected error occurred while executing the Data Import. For more details, please contact your System Administrator.

The import included may have included one or more of the following:

  • Corrupted data.

  • An invalid duration paycode.

  • An issue with the Data Import Tool service.

Contact UKG Global Supportto open a case.

3

The combined paycode edit is not allowed

Currently, the DIT does not support the import of edits made to combined paycodes.

N/A

2

You cannot do a bulk import or group edit during employee's signed off timeframe.

When an employee's timecard is signed off, Paycode edit cannot be executed in that timeframe.

Use the Data - Pay Code Edit Historical - Import template to import historical paycode edits.

1

Invalid Person Number : abc

Appears when entered person does not exist in the system.

Enter a valid employee.

Special Conditions

Special Conditions

The Data Paycode Edit template is not loading transfers in the timecard. Use the following format for the string ensuring each value is separated by a comma and that string ends with a semicolon (;):

Primary Job;work rule;cost center;Labor Categories;

The system automatically inserts a semicolon (;) at the end of the string.

To view the available paycodes for this tenant, the Paycode Type must be selected.

Dependencies

N/A

Limitations

Combined paycodes are not supported.

Partial Success

Supports Partial Success.

Note: Partial Success is not supported when edits are being made to a single employee.