Raise History Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: RAISEHST.DAT
RAISEHST.DAT is the employee raise history file. If you are using Sage 50 Pro Accounting or Sage 50 Premium Accounting, the information below is entered or displayed in the General tab of the Maintain Employees/Sales Reps window. If you are using Sage 50 Premium Accounting, most of the information below is entered or displayed in the Raise History window.
- To add Sage 50 raise history fields to your Crystal reports, select RAISEHST.DAT.
Indexes and Their Uses
This file has the following two keys:
0 = By Employee Record Number, Raise Date, and then Pay Rate Index
1 = By GUID
Fields
The following table shows the fields available in the RAISEHST.DAT file and includes the type and size in number of bytes of each field.
Field Name |
Type |
Size |
Comment |
---|---|---|---|
EmployeeRecordNumber |
Integer |
Employee ID entered in the Maintain Employees/Sales Reps window. |
|
RaiseDate |
Date |
Date of the employee's raise. In Sage 50 Pro Accounting and Sage 50 Premium Accounting, this information is entered in the Last Raise Date field on the General tab of the Maintain Employees/Sales Reps window. In Sage 50 Premium Accounting, this information is entered in the Raise Date field of the Raise History window. |
|
Rate |
Integer |
Hourly or salary pay level entered in the Applicable Rate field in the Raise History window. (Sage 50 Premium Accounting and higher) |
|
GUID |
UBinary |
GUID (Globally Unique Identifier) used for linking Raise History table. |
|
BaseAmount |
Float |
Base amount of pay, as displayed in the Base Amount field in the Raise History window. (Sage 50 Premium Accounting and higher) |
|
RaiseAmount |
Float |
8 |
Raise amount, as displayed in the Raise Amount field in the Raise History table. (Sage 50 Premium Accounting and higher) |
RaisePercent |
Float |
Raise percentage, as displayed in the Raise Percentage field in the Raise History window. (Sage 50 Premium Accounting and higher) |
|
NewAmount |
Float |
Total of the base amount, plus the raise amount. This information appears in the New Amount field in the Raise History window. (Sage 50 Premium Accounting and higher) |
|
RaiseNote |
ZString |
254 |
Text entered through the use of the Note button in the Raise History window. (Sage 50 Premium Accounting and higher) |