EXPORT TIMESHEETS TO CERIDIAN

Use this screen to download a range of timesheets to a standard ASCII text file in the format prescribed by Ceridian for its Signature or Source 500 series payroll product. You can then transmit this file to Ceridian for payroll processing. You can select the Ceridian configuration to be used, the range of timesheets to be downloaded, and other processing options.

Use this screen after establishing all Ceridian configuration information and after all timesheets for the cycle are entered. If you have Costpoint Payroll installed, you must use this function before posting payroll.

Export Timesheets to Ceridian is a single-user application. Also, if you select the Set Payroll Posted Flag check box, the application requires momentary exclusive access to the Timesheet Header table. If you select this option, be sure that no other users are accessing timesheets while the application is running.

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 are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

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 in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in 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 in 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

Option

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.

Option

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

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

Option

Start

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

Ceridian Product

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

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.

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.

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

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.

As the application writes records to the output file, the size of the file can grow quite large, easily exceeding the capacity of a standard floppy diskette.

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.

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.)