Contents of the Create CTS Tax File Data

Use the fields and options to configure the Create CTS Tax File 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.

Select

Use this group box to select records for processing.

File Type

Use this group box to select the type of file that should be created.

Field Description
Periodic

Select this option to create the periodic CTS Tax file. Selecting this button will enable the Periodic group box.

Quarterly

Select this option to create the quarterly CTS Tax file. Selecting this button will enable the Quarterly group box.

Select

Use this group box to select the range of check dates that will be included in the Periodic or Quarterly CTS tax file.

Check Date

These fields are active when you select the Periodic file type. From the drop-down list, select the range type of the check dates that will be included in the Periodic CTS tax file. Valid options are:

  • All: Select this option to include all dates in the file.
  • One : Select this option to include only one date in the file.
  • Range: Select this option to specify range of dates. Enter the beginning date in the Start field and the ending date in the End field.
  • From Beginning: Select this option to include the first check date up to a date that you specify. Enter the ending date in the End field.
  • To End: Select this option to include dates from a date that you enter up to last check date. Enter the beginning date in the Start field.
Field Description
Start

Enter the beginning date of the check date range to be included in the CTS tax file.

End

Enter the ending date of the check date range to be included in the CTS tax file.

Quarter

These fields are active when you select the Quarterly file type. Select the payroll year and quarter that will be included in the quarterly CTS tax file. The unlabeled range type field always display One.

Field Description
Payroll Year

Enter the four-digit payroll year that will be processed by this application. The application uses the Payroll Year and Quarter to select checks to include in the quarterly CTS tax file.

Quarter

Select the quarter that will be processed by this application. The application uses the Payroll Year and Quarter to select checks to include in the quarterly CTS tax file.

Options

Use this group box to select records for processing.

Process

When a CTS Tax file is created, the Payroll Edit or Employee Earnings records are flagged as "processed through CTS." This helps prevent the same data from being submitted twice. Use this group box to specify the whether or not to include paychecks that have already been included in a previous CTS periodic file.

If you select Quarterly as the File Type, these fields become disabled and the All Records option is automatically selected.

Field Description
All Records

Select this radio button to include records that have been included in a previous CTS File.

Unprocessed Records Only

Select this radio button to include only records that have not previously been included in a CTS File.

Include

Use this group box to specify whether Payroll Edit records should be included in the CTS tax file. Only Payroll Edit records that have check numbers are included if this option is selected.

Field Description
Include Payroll Edit Records

Select this check box to include Payroll Edit records in addition to Employee Earnings records.

Report

Field Description
Include Employee Detail on Report

Select this check box to include Employee detail information on the report.

Alaska Occupational Code

Use this group box to specify Alaska Occupational Code information.

Field Description
Source

From the drop-down list, select what you want to use for the Alaska Occupational Code for employees being reported in the Alaska 602 record.

  • Employee Taxes: Uses the Alaska Occupational Code assigned to the employee on the Manage Employee Taxes screen.
  • Detail Job Title Code: Uses the detail job title code entered for an employee on the Manage Employee Salary Information screen. This option is available only if you use Costpoint Human Resources.
  • Job Title Description: Uses the detail job title description entered for an employee on the Manage Employee Salary Information screen.
  • User-Defined Info: Uses the label you define in the User-Defined Label field in this screen for all employees.
User-Defined Label

If you select the User-Defined Info option in the Source field in this screen, enter the user-defined label you want to use for the Alaska Occupational Code for all employees being reported.

Maine Seasonal Period

Use this group box to specify the seasonal period start and end dates.

Field Description
Start Date

If applicable, enter, or click to select, the Maine seasonal period start date.

End Date

If applicable, enter, or click to select, the Maine seasonal period end date.

New York Dependent Health Insurance

Indicate whether or not you provide dependent health insurance benefit options to New York employees.

Field Description
Benefit Options Provided to Employees

Select this check box if you provide dependent health insurance benefit options to New York employees.

Puerto Rico Second Last Name

For Puerto Rico SUTA Reporting, specify the user-defined label used to store the second last name.

Field Description
User-Defined Label

Enter, or click to select, the User-Defined label used to store the second last name.

Report and Output File

Use this group box to specify the output file information. Be sure that the file location and file name are correct before processing.

Field Description
File Location

Enter the location of the file you are creating. There are two ways to do this:

  • In the File Location field, 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.
  • Leave the File Location field blank. When you execute this application, the export file is saved to the Costpoint database. Use the Export Files application to retrieve it and save it to a location on the network.
File Name

Enter the file name of the CTS tax file that will be created and sent to CTS.

Important information for creation of the file:

  • When creating the Periodic file, if you select the Exclude SUI Data check box for the specified CTS Collector ID on the Configure CTS Settings screen, all SUI data will be excluded from the periodic file (this does not apply to the quarterly file).
  • When creating the Periodic file, if you select the Exclude Supplemental Data check box for the specified CTS Collector ID on the Configure CTS Settings screen, all supplemental SUI data is excluded from the periodic file. This does not apply to the quarterly file.
  • Deltek recommends using the .TXT and .CSV file-naming conventions.
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.