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. |