Module List > Module HR tables RV010121
You are currently viewing the COMPANY database.
Change

COMPANY..RV010121 Table Definition

(COMPANY..HR_Review_MSTR_V2)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPID_I char(15)
''
Employee I...(more) Join Now TATX1030.EMPID_I
DATEOFLASTREVIEW_I datetime
'1/1/1900'
*Date Of ...(more) Join Now UPR00100.DATEOFLASTREVIEW_I
REVIEWRATINGDECIMA_I numeric(19,5)
0.00

REVIEWSETUPCODE_I char(31)
''

REVIEWSETUPNAME_I char(31)
''

REVIEWRANGE_I smallint
0

REVIEWEDBY_I char(21)
''

APPROVEDBY_I char(21)
''

DATEOFNEXTREVIEW_I datetime
'1/1/1900'
*Date Of ...(more) Join Now UPR00100.DATEOFNEXTREVIEW_I
EFFICIENCY_I smallint
0

COSTOFERROR_I numeric(19,5)
0.00

COSTOFQUALITY_I numeric(19,5)
0.00

RECOMMENDEDWAGE_I numeric(19,5)
0.00

EFFECTIVEDATE_I datetime
'1/1/1900'

PROBATION_I tinyint
0

TOTALWEIGHT_I smallint
0

DESPOSCODE_I char(7)
''

IMPROVEMENT_I char(31)
''

SALPERCHANGE_I smallint
0

CHANGEBY_I char(15)
''
*Change By...(more) Join Now UPR00100.CHANGEBY_I
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now UPR00100.CHANGEDATE_I
NOTESINDEX_I numeric(19,5)
0.00

NOTESINDEX2_I numeric(19,5)
0.00

NOTESINDEX3_I numeric(19,5)
0.00

NOTESINDEX4_I numeric(19,5)
0.00

USEWORDSGB_I smallint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3