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)

What do you want to do next?

See a list of Crystal Reports data (.DAT) files