Module List > Module UPR tables UPR41200
You are currently viewing the COMPANY database.
Change

COMPANY..UPR41200 Table Definition

(COMPANY..Payroll Class Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLCLAS char(15)
''

DSCRIPTN char(31)
''

DEPRTMNT char(7)
''
Department...(more) Join Now
join ... more text available
JOBTITLE char(7)
''

SUTASTAT char(3)
''
Suta State...(more) Join Now
WRKRCOMP char(7)
''
Workers Co...(more) Join Now
MINETPAY numeric(19,5)
0.00
Minimum Ne...(more) Join Now
WKHRPRYR smallint
0
Work Hours...(more) Join Now UPR00100.WKHRPRYR
WCACFPAY smallint
0
Which Cash...(more) Join Now UPR00100.WCACFPAY
ACTINDX int
0
Account In...(more) Join Now
join ... more text available
USERDEF1 char(21)
''
UserDefine...(more) Join Now CM20200.USERDEF1
USERDEF2 char(21)
''
UserDefine...(more) Join Now CM20200.USERDEF2
ATACRVAC tinyint
0
Auto Accru...(more) Join Now UPR00100.ATACRVAC
VACCRMTH smallint
0
Vacation A...(more) Join Now UPR00100.VACCRMTH
VACCRAMT int
0
Vacation A...(more) Join Now UPR00100.VACCRAMT
VACAPRYR int
0
Vacation H...(more) Join Now UPR00100.VACAPRYR
VACAVLBL int
0
Vacation A...(more) Join Now UPR00100.VACAVLBL
WRNVCNFLSBLWZR tinyint
0
Warn Vacat...(more) Join Now UPR00100.WRNVCNFLSBLWZR
ATACRSTM tinyint
0
Auto Accru...(more) Join Now UPR00100.ATACRSTM
STMACMTH smallint
0
Sick Time ...(more) Join Now UPR00100.STMACMTH
SKTMACAM int
0
Sick Time ...(more) Join Now UPR00100.SKTMACAM
SKTMHPYR int
0
Sick Time ...(more) Join Now UPR00100.SKTMHPYR
SIKTIMAV int
0
Sick Time ...(more) Join Now UPR00100.SIKTIMAV
WRNSTFLSBLWZR tinyint
0
Warn Sick ...(more) Join Now UPR00100.WRNSTFLSBLWZR
DEFLTCLS tinyint
0
Default Cl...(more) Join Now PM00100.DEFLTCLS
Calc_Min_Wage_Bal tinyint
0
Calc Min W...(more) Join Now UPR00100.Calc_Min_Wage_Bal
EMPLOYMENTTYPE smallint
0
Type of Em...(more) Join Now UPR00100.EMPLOYMENTTYPE
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
ASSIGNMENTCODE char
''

Time_on_Behalf_Code char
''

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