Available in Sage 50 Premium Accounting and higher.
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
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.
This file has the following key:
0 = By GUID
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. |