Contents of the Export Timesheets To Ceridian Screen

Use the fields and options to configure the Export Timesheets to Ceridian screen.

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Timesheet Cycle

Field Description
Option

This field always displays One.

Start

Enter, or click , to select the timesheet cycle to be processed. Only one timesheet cycle can be processed at a time.

Timesheet Date

Use this group box to specify the range of timesheet dates to be processed by this application.

Field Description
Option

From the drop-down list, select the range type for timesheet selection. Valid options are:

  • All: Select this option to include all timesheet dates in the process.
  • One: Select this option to include only one timesheet date in the process. Enter this timesheet date in the Start field.
  • Range: Select this option to include timesheets dates fall within the date in the Start field and the date in the End field.
  • From Beginning: Select this option to include all timesheet dates from the start up to the date in the End field.
  • To End: Select this option to include all timesheet dates from the date in the Start field up to the last timesheet date.
Start

Enter the first timesheet date to be processed by this application. This field is required if you selected One, Range, or To End in the Option drop-down list.

End

Enter the last timesheet date to be processed by this application. This field is required if you selected Range or From Beginning in the Option drop-down list.

Ceridian Configuration

Field Description
Option

This field always displays One.

Start

Enter, or click , to select the Ceridian configuration ID to be used.

The value you enter in this field determines the Ceridian company ID that populates the ASCII file. It also determines the format of Ceridian employee IDs. The format is specified in the Manage Ceridian Configuration screen.

If you are a Ceridian Signature user, the value entered here also determines the Ceridian Sub-Company that populates the ASCII file.

Company, Sub-Company

After you enter an ID in the Ceridian Configuration ID field, these fields display the information you entered in the Manage Ceridian Configuration screen.

Options

Field Description
Ceridian Product

From the drop-down list, select the Ceridian product you are using. Valid options are:

  • Source 500 Series
  • Signature

The product you specify here determines the layout of the ASCII file generated by this application.

Processing Options

Use this group box to indicate whether certain options are enabled or disabled during timesheet processing.

Field Description
Include Correcting Timesheets

Select this check box to include type C (Correcting) timesheets in the download process. If you do not select this check box, only type R (Regular) timesheets and type B (Bonus) timesheets are processed. The default setting is selected.

Set Payroll Posted Flag

Select this check box to set the Payroll Posted Flag (PR_POSTED_FL) in the Timesheet Header table to Y (posted) after a timesheet has been successfully downloaded. If you do not select this check box, the Payroll Posted Flag setting is unaffected by this application.

If you do not have Costpoint Payroll installed, this check box is permanently selected and non-editable (that is, the Payroll Posted Flag is always selected after a successful timesheet export). If you do have Costpoint Payroll installed, this check box is cleared by default, allowing you to process Costpoint Payroll in parallel with Ceridian.

Use Pay Code 8 for all Bonus timesheets

Select this check box if you want to override the normal account/pay type links set up in the Ceridian Mapping subtask of the Manage Ceridian Configuration screen for a type B (Bonus) timesheet. When you select this check box, all timesheet lines in a bonus timesheet are exported with a Ceridian pay code of 8, which instructs Ceridian to generate a separate check. The default setting is to export bonus timesheets as a separate check.

If you do not select this check box, bonus timesheets are processed in the same fashion as regular and correcting timesheets. A bonus timesheet line is exported with a Ceridian pay code of 8 only if the account or pay type on that line has been linked to pay code 8 in the Ceridian Mapping subtask of the Manage Ceridian Configuration screen.

Note:

Ceridian generates a separate check for each record with a pay code of 8. Therefore, a bonus timesheet containing more than one charge line generates more than one bonus check. For example, if this check box is selected and a bonus timesheet with three charge lines is processed, three records with a pay code of 8 are exported and three bonus checks are generated by Ceridian.

Print Audit Report

This check box is selected by default, to indicate that the audit report prints upon processing.  If you clear this check box, only the error report is generated during processing.

Output File

Field Description
File Name

Enter the file name to be used when creating the Ceridian export file. If an existing file name is entered, the application overwrites its contents when the export process begins.

Note:

International users: The data can contain non-English characters, provided they are in the ASCII character set. Before creating an ASCII text (.TXT) file, be sure that your keyboard language is set to "EN" (United States English) to prevent the application from generating errors.  

We recommend the use of .TXT and .CSV file-naming conventions.

File Location

Enter, or click to select, the alternate file location where you want to store the export file. Alternate file locations are set up on the Manage Alternate File Locations screen.

Ceridian Pay Period Year

Enter the Ceridian pay period year for this processing cycle. The system uses this value to populate the Ceridian Signature export file. 

This is a required field if you selected a Ceridian Product of Signature on this screen.

Ceridian Pay Period

Enter the Ceridian pay period for this processing cycle. The system uses this value to populate the Ceridian Signature export file.

This is a required field if you selected a Ceridian Product of Signature on this screen.

Print

Click to print the audit and error reports. The export file creation process does not take place nor is the Payroll Posted Flag set if you selected the Set Payroll Posted Flag check box.

Process

Click to print the audit and error reports, generate the Ceridian export file, and (if you selected the Set Payroll Posted Flag check box) set the Payroll Posted Flag for processed timesheets to Y (posted.)

Processing Narrative

Ceridian Signature Export File Layout

Ceridian Source 500 Series Export File Layout