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?