The fields in the Employee Information section of the Employee Ledger report are arranged in six lines:
Line 1 Fields
The following table shows the field names and data sources or valid values for the Line 1 fields in the Employee Information section of the Employee Ledger report.
|
Field Name |
Data source and Valid values |
|---|---|
|
EMPL# (Employee Number) |
Retrieved from the Employee Number field on the Employee Information page. |
|
BIRTH (Birth Date) |
Retrieved from the Birthdate field on the Employee Information page. |
|
PERS STAT (PERS Status) |
Retrieved from the Old PERS Stat field on the Payroll Information - State Required page. Displays a dash (-) if not found. |
|
PAY HOURS |
Retrieved from the Pay Hours field on the Pay Rate Information page (primary pay rate only). |
|
ANNUAL SAL (Annual Salary) |
Retrieved from the Annual Salary field on the Pay Rate Information page (primary pay rate only). |
Line 2 Fields
The following table shows the field names and data sources or valid values for the Line 2 fields in the Employee Information section of the Employee Ledger report.
|
Field Name |
Data source and Valid values |
|---|---|
|
SSN (Social Security Number) |
Retrieved from the Social Security field on the Employee Information page. Masked based on user security settings. |
|
START (Original Hire Date) |
Retrieved from the Original Hire field on the Employment tab of the Employee Information page. |
|
HOURS/DAY |
Retrieved from the Hours/Day field on the Pay Rate Information page (primary pay rate only). |
|
PAY RATE |
Retrieved from the Rate field on the Pay Rate Information page (primary pay rate only). |
|
CONTRACT SAL (Contract Salary) |
Retrieved from the Contract Limit field on the Pay Rate Information page (primary pay rate only). |
Line 3 Fields
The following table shows the field names and data sources or valid values for the Line 3 fields in the Employee Information section of the Employee Ledger report.
|
Field Name |
Data source and Valid values |
|---|---|
|
NAME (Full Name) |
Constructed from multiple fields. The First Name, Middle Name, Last Name, and Name Suffix are retrieved from the Employee Information page. |
|
END (Termination Date) |
Retrieved from the Last Day Worked field on the Employee Information page. |
|
DAYS (Days Worked) |
Retrieved from the Days Worked field on the Pay Rate Information page (primary pay rate only). |
|
EXEMPTIONS FED (Federal Exemptions) |
Retrieved from the Status field in the Federal section and the Dependents field in the W4 Pre-2020 section of the Employee Tax Information page. |
|
STATE (State Exemptions) |
Retrieved from the Status and Dependents fields in the State section of the Employee Tax Information page. |
Line 4 Fields
The following table shows the field names and data sources or valid values for the Line 4 fields in the Employee Information section of the Employee Ledger report.
|
Field Name |
Data source and Valid values |
|---|---|
|
ADDRESS (Address Line 1) |
Retrieved from the Address field on the Employment tab of the Employee Information page. |
|
WC CODE (Workers' Comp Code) |
Retrieved from the Workers' Comp field on the Personnel tab of the Employee Information page. |
|
PAY TYPE (Pay Method) |
Retrieved from the Pay Method field on the Pay Rate Information page (primary pay rate only). |
|
CLASS (Classification) |
Retrieved from the Job Class field on the Pay Rate Information page. The title is retrieved from the Title field on the Job Class page. |
Line 5 Fields
The following table shows the field names and data sources or valid values for the Line 5 fields in the Employee Information section of the Employee Ledger report.
|
Field Name |
Data source and Valid values |
|---|---|
|
Address Line 2 |
Retrieved from the Address field on the Employment tab of the Employee Information page. |
|
FTE |
Retrieved from the FTE field on the Pay Rate Information page (primary pay rate only). |
|
PAY CODE |
Retrieved from the Pay Code field on the Pay Rate Information page (primary pay rate only). |
|
ORGN (Primary Organization) |
Retrieved from the Organization section of the Pay Rate Information page (highest percentage distribution). |
|
ACCT (Primary Account) |
Retrieved from the Organization section of the Pay Rate Information page (highest percentage distribution). |
|
PER (Primary Percent) |
Retrieved from the Organization section of the Pay Rate Information page (highest percentage distribution). (highest percentage distribution). |
Line 6 Fields
The following table shows the field names and data sources or valid values for the Line 6 fields in the Employee Information section of the Employee Ledger report.
|
Field Name |
Data source and Valid values |
|---|---|
|
City, State Zip |
Retrieved from the City, State, and Zip fields on the Employment tab of the Employee Information page. |
|
CHK LOCN (Check Location) |
Retrieved from the Check Location field on the Payroll tab of the Employee Information page. |
|
ORGN (Secondary Organization) |
Retrieved from the Organization section of the Pay Rate Information page (second-highest percentage distribution, if it exists). |
|
ACCT (Secondary Account) |
Retrieved from the Organization section of the Pay Rate Information page (second-highest percentage distribution, if it exists). |
|
PER (Secondary Percent) |
Retrieved from the Organization section of the Pay Rate Information page (second-highest percentage distribution, if it exists). |