Employee Earnings Summary Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: EARNSUMM.DAT
EARNSUMM.DAT is the employee earnings summary file. It contains a record (row) for each quarter per employee.
- To add Sage 50 employee earnings summary fields to your Crystal reports, select EARNSUMM.DAT.
These fields define the quarters per employee and weeks worked per quarter. There are two sets of quarters:
- Quarter 0 is used to contain only beginning balances for "running" fields such as vacation and sick time.
- Quarters 1-4 are for the current calendar (payroll) year, while quarters 5-8 are for the next payroll year.
To determine Sage 50's current calendar (payroll) year, do the following:
- From the Tasks menu, select System, and then Change Accounting Period.
Note: Calendar (payroll) and the fiscal years are different concepts that don’t necessarily refer to the same real year. Calendar years refer to payroll years that start in January and end in December; fiscal years are established in Sage 50's New Company Setup wizard and can start and end at any time.
Indexes and their uses
The EARNSUMM.DAT file has four keys, as follows:
0 = ByEarnSumm_RecordNumber – Unique and doesn’t change. Usually used to link to other tables.
1 = ByEarnSumm_EarnSummGUID
2 = ByEarnSumm_EmpRecNum – Identifies the employee associated with this earning summary information
3 = ByEarnSumm_EmpRecNumQtr – Used to retrieve the earning summary information for an employee sorted by quarter
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
RecordNumber |
Integer |
Used as a table-linking field. |
|
|
GUID |
Ubinary |
GUID (Globally Unique Identifier) used for linking the Earnings Summary table. |
|
|
LastUpdateCounter |
Integer |
This is a counter that increases incrementally each time a record is modified. |
|
|
EmployeeRecordNumber |
Integer |
Identifies the employee. |
|
|
Quarter |
Integer |
Identifies the quarter. |
|
|
WeeksWorked |
Integer |
The number of weeks the employee worked (based on paychecks entered in Sage 50) in the quarter. |