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

COMPANY..HRPSLH01 Table Definition

(COMPANY..HRP_Salary_History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
PAYRCORD char(7)
''
Pay Record...(more) Join Now UPR40600.PAYRCORD
EFFECTIVEDATE_I datetime
'1/1/1900'

SEQNUMBR int
0
Sequence N...(more) Join Now
PAYRTAMT numeric(19,5)
0.00
Pay Rate A...(more) Join Now UPR40600.PAYRTAMT
PAYUNIT char(25)
''
Pay Unit: ...(more) Join Now UPR40600.PAYUNIT
PAYUNPER smallint
0
Pay Unit P...(more) Join Now UPR40600.PAYUNPER
PAYPEROD smallint
0
Pay Period...(more) Join Now UPR00400.PAYPEROD
PAYPRPRD numeric(19,5)
0.00
Pay Per Pe...(more) Join Now UPR00400.PAYPRPRD
ANNUALSALARY_I numeric(19,5)
0.00

CHANGEREASON_I char(31)
''

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now
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