Payroll Accounting report - File Layout and Data Mapping
The default file name for the Payroll Accounting report is edfi_staff_payroll.xlsx.
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 amount paid for this activity, rounded to the nearest dollar. | Retrieved from the Pay Amount field on the Payroll Accounting tab of the Staff Information page. |
O | Begin Date | The starting pay date. | Retrieved from the Begin Date field on the Payroll Accounting tab of the Staff Information page. |
P | End Date | The ending pay date. | Retrieved from the End Date field on the Payroll Accounting tab of the Staff Information page. |