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. |