The Montana CPI Export Process generates a report and export file for the submission of tax-sheltered annuity plan information to CPI. This process generates an ASCII tab delimited export file %%%%_CPI_YYYYPP.EXP where %%%% is the payroll id and YYYYPP is the starting pay period selected. This file is created at the directory pointed to by the logical SRB$Export. The actual file location and name is included in the header of the report. This process requires the logical SRB$Export be defined.
This process includes the option to maintain multiple sets of stored prompts.
Name the prompt sets by defining a title up to 10 characters, with a 30-character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.
Enter Starting Pay Period
-
Enter the starting pay period for a range of pay periods to be reported.
Enter Ending Pay Period
-
Enter the ending pay period for a range of pay periods to be reported.
Report All or Selected Employees
Exclude Terminated Employees Prior to Date
-
Enter a date to defined when Terminated employees should be omitted. Any Terminated employee with a Termination date prior to this date will be omitted.
Leave this prompt empty when no Terminated employee should be excluded.
Enter Pre-Tax Salary Deferral Deduction Codes
-
Enter the list of deductions one at a time. Use look-up for valid deduction codes. The employee's deduction amount for these deductions for the given range of pay periods will be reported as the Pre-Tax Salary Deferral amount.
Enter Roth Deferral Deduction Codes
-
Enter the list of deductions one at a time. Use look-up for valid deduction codes. The employee's deduction amount for these deductions for the given range of pay periods will be reported as the Roth Deferral amount.
Enter 457 Deferral Deduction Codes
-
Enter the list of deductions one at a time. Use look-up for valid deduction codes. The employee's deduction amount for these deductions for the given range of pay periods will be reported as the 457(b) Deferral amount.
Sort Report BY Employee Number or Name
-
Enter 'E' to generate the report in employee number sequence.
-
Enter 'N' to generate the report in employee name sequence.
The Export file contains:
-
Header column line
-
Employee name (maximum 50)
-
Social insurance number
-
Employee mailing address (ADDR1 & ADDR2 maximum 100 characters)
-
City
-
State
-
Zip
-
Date of Birth (MM/DD/YYYY)
-
Date of Hire (MM/DD/YYYY – original hire date)
-
Date of Termination (MM/DD/YYYY)
-
Date of Rehire (MM/DD/YYYY – current hire date)
-
Gross Compensation - total earnings per pay period range
-
Pre-tax Salary Deferrals - total employee portion of selected deduction per period range
-
Roth Deferrals - total employee portion of selected deduction per period range
-
457(b) Deferrals - total employee portion of selected deduction per period range