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

COMPANY..PC40800 Table Definition

(COMPANY..PC Position Seat Inheritance)

4Penny.net

Field Definitions:

What is the 'source' column?

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

JOBTITLE char(7)
''
Job Title:...(more) Join Now TATX1030.JOBTITLE
TEMPSEAT tinyint
0

SEAT int
0

SEQNUMBR int
0
Sequence N...(more) Join Now IV10400.SEQNUMBR
ACTINDX int
0
Account In...(more) Join Now UPR40500.ACTINDX
join ... more text available
ACRUSTIM tinyint
0
Accrue sic...(more) Join Now
ACRUVACN tinyint
0
Accrue Vac...(more) Join Now
Calc_Min_Wage_Bal tinyint
0

CALCMINWAGEBALCB tinyint
0

CONTENDDTE datetime
'1/1/1900'
Contract E...(more) Join Now
CONTSTARTDTE datetime
'1/1/1900'

DIVISIONCODE_I char(7)
''

DIVISIONCODECB tinyint
0

EMPLCLAS char(15)
''
Employee C...(more) Join Now UPR00100.EMPLCLAS
join ... more text available
EMPLCLASCB tinyint
0

WCACFPAY smallint
0

WHICHCACHACCTCB tinyint
0

LOCATNID char(15)
''
Location I...(more) Join Now PA01101.LOCATNID
join ... more text available
LOCATNIDCB tinyint
0

STMACMTH smallint
0

SKTMACAM int
0

SKTMHPYR int
0

SUPERVISOR char(31)
''

SUPERVISORCB tinyint
0

EMPLOYMENTTYPE smallint
0
Type of Em...(more) Join Now HR2EMP02.EMPLOYMENTTYPE
EMPLOYMENTTYPECB tinyint
0

CONTACTNUMBER_I smallint
0

UNIONDUESAMOUNT_I numeric(19,5)
0.00

UNIONINFOCB tinyint
0

UNIONNAME_I char(31)
''

VACCRMTH smallint
0

VACCRAMT int
0

VACAPRYR int
0

VACSICKCB tinyint
0

WRNSTFLSBLWZR tinyint
0

WRNVCNFLSBLWZR tinyint
0

WKHRPRYR smallint
0

WKHRPRYRCB tinyint
0

WRKRCOMP char(7)
''
Workers Co...(more) Join Now UPR00400.WRKRCOMP
CONTACTNUM_I char
''

WRKRCOMPCB tinyint
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