FTE Distribution Report

The FTE Distribution Report is a cross payroll report that reports employee's FTE (or hours when FTE is not applicable) per function line costing distribution. The report lists the employee's FTE according to the GL account Program code per distribution, summarized by GL account Object code with page breaks per Location code.

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.

Report Current, Selective or All Payrolls

Enter 'C' to report on employees from the current payroll only.
Enter 'S' to select specific payrolls to be reported.
Enter 'A' to report on all like payrolls defined in the payroll location profile.
When you are currently running from a live payroll then only live payrolls will be included in the report.

When 'S'elective payrolls is selected the following prompts will display:

Enter Payroll Location ID

Enter the payroll ID codes (one at a time) for payrolls to be reported. Up to 10 payrolls may be selected. Use look-up for a list of valid payroll ID codes.

Enter Pay Types for Function Line Selection

Accept default to report on all pay types.
Enter 'F' to report on fixed salaried employees only.
Enter 'L' to report on lump sum.
Enter 'A' to report on annual salaried employees only.
Enter 'S' to report on salaried employees only.
Enter 'H' to report on hourly paid employees only.
Enter 'P' to report on part-time employees only.
Enter 'C' to report on contract paid employees only.

Use of the various pay type codes provides control over the function lines on the employee's master that will be included in the report.

Report Employees Terminated/On Leave/ Both

Use Employee Master Location or GL Account Level

Enter 'M' to use the employee's location codes from the Pay Screen.
Enter 'L' to use the location code per GL account code from the employee's costing distribution.

When 'L'evel was selected:

Select location GL Level to page break On

The levels of your GL account will display. Enter the two-digit GL level which represents the location code.

Enter Select Location Codes to be Reported

Leave this prompt empty to include all location codes.
Enter a list of location codes to be reported, separated by a comma.

Use look-up for valid location codes.

Select Object GL Level to Sub Total On

The levels of your GL account will display. Enter the two-digit GL level which represents the object code.

Enter Select Object Codes to be Reported

Leave this prompt empty to include all object codes.
Enter a list of object codes to be reported, separated by a comma.

Use look-up for of valid object codes.

Select Program GL Level to Report On

The levels of your GL account will display. Enter the two-digit GL level which represents the program code.

Enter up to 15 program codes separated by a comma
Enter a list of (up to a maximum of 15) program codes to be reported. The order in which the program codes are defined determine the program order for the report headings.

Use look-up for valid program codes.

The report prints the following information:

Employee's name
Employee's FTE (hours when Percent Employed is not active) under applicable program code per distribution.
Other – programs codes not current listed on the report.
Total – FTE per line
Sub totals per Object code
Totals per location code
Grand total for report
Program code descriptions are listed for reference.