Available in Sage 50 Premium Accounting and higher.

Review Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: REVIEW.DAT

REVIEW.DAT is the employee performance review history file. Most of the information below is entered or displayed in Sage 50's Performance Reviews window, which is accessed from the Pay Info tab of the Maintain Employees/Sales Reps window.

To add Sage 50 raise history fields to your Crystal reports, select REVIEW.DAT.

Indexes and Their Uses

This file has the following key:

0 = By GUID

Fields

The following table shows the fields available in the REVIEW.DAT file and includes the type and size in number of bytes of each field.

Field Name	Type	Size	Comment
EmployeeGuid	UBinary		GUID (Globally Unique Identifier) used for linking the Employee table.
ReviewDate	Date		Date of the employee's review.
Rating	Integer		Rating the employee was given on the review. 0=none 1=Rating 1 2=Rating 2 3=Rating 3 4=Rating 4 5=Rating 5 6=Rating 6 7=Rating 7 8=Rating 8 9=Rating 9 10=Rating 10
GUID	UBinary		GUID (Globally Unique Identifier) used for linking Review table.
ReviewerGuid	UBinary		GUID (Globally Unique Identifier) used for linking the Employee table.
Notes	ZString	100	Notes entered for the employee review.

What do you want to do next?

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