Payroll Accounting report - File Layout and Data Mapping

The default file name for the Payroll Accounting report is edfi_staff_payroll.xlsx.

Payroll rows that share the same accounting key (Activity Code, Fund, Function, Object, Organization, Year, and Program Code) and are active for the snapshot date are consolidated into a single row in this report. The Amount column reflects the total for the accounting key. The Begin Date and End Date columns reflect the dates determined by the consolidation rules applied during the load.

The following table shows the columns, column names, descriptions, and data sources or valid values for the Payroll Accounting report.

Column	Column Name	Description	Data Source or Valid Values
A	Employee Number	The employee’s identification (ID) number.	Retrieved from the Employee Number field on the Demographic tab of the Staff Information page.
B	Staff ID	The employee’s social security number, without dashes.	Retrieved from the Staff ID field on the Demographic tab of the Staff Information page.
C	First Name	The employee’s first name.	Retrieved from the First Name field on the Demographic tab of the Staff Information page.
D	Middle Name	The employee’s middle name.	Retrieved from the Middle Name field on the Demographic tab of the Staff Information page.
E	Last Name	The employee's last name.	Retrieved from the Last Name field on the Demographic tab of the Staff Information page.
F	Generation	The employee’s generation suffix.	Retrieved from the Generation field on the Demographic tab of the Staff Information page.
G	Activity Code	The code identifying the employee's payroll activity.	Retrieved from the Activity Code field on the Payroll Accounting tab of the Staff Information page.
H	Fund	The three-digit code identifying the PEIMS fund for this activity.	Retrieved from the Fund field on the Payroll Accounting tab of the Staff Information page.
I	Function	The two-digit code identifying the PEIMS function for this activity.	Retrieved from the Function field on the Payroll Accounting tab of the Staff Information page.
J	Object	The four-digit code identifying the PEIMS object for this activity.	Retrieved from the Object field on the Payroll Accounting tab of the Staff Information page.
K	Organization	The three-digit code identifying the PEIMS organization for this activity.	Retrieved from the Organization field on the Payroll Accounting tab of the Staff Information page.
L	Year	The single-digit code identifying the PEIMS year for this activity.	Retrieved from the Year field on the Payroll Accounting tab of the Staff Information page.
M	Program Code	The code identifying the program for this activity.	The valid values are stored on the PEIMS Programs Table page. Retrieved from the Program Code field on the Payroll Accounting tab of the Staff Information page.
N	Amount	The total amount paid for this accounting key, rounded to the nearest dollar. When multiple payroll rows with the same accounting key are active for the snapshot date, this value is the sum of all consolidated row amounts.	Retrieved from the Pay Amount field on the Payroll Accounting tab of the Staff Information page.
O	Begin Date	The starting pay date for the consolidated row. When multiple rows with the same accounting key are consolidated, this is the earliest Begin Date from the consolidated rows.	Retrieved from the Begin Date field on the Payroll Accounting tab of the Staff Information page.
P	End Date	The ending pay date for the consolidated row. When multiple rows with the same accounting key are consolidated, this is the latest End Date from the consolidated rows. This column is blank if any of the consolidated rows has a blank End Date (open-ended).	Retrieved from the End Date field on the Payroll Accounting tab of the Staff Information page.