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

COMPANY..PC30301 Table Definition

(COMPANY..PC Position Setup History)

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
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
SEQ_I int
0

CHANGETIME_I datetime
'1/1/1900'

DSCRIPTN char(31)
''

ACTINDX int
0
Account In...(more) Join Now UPR40500.ACTINDX
join ... more text available
ATACRSTM tinyint
0

ATACRVAC tinyint
0

BUDGETPERMSEATAMT smallint
0

BUDGETTEMPSEATAMT smallint
0

BUGETBENPERCENT numeric(19,5)
0.00

BUDGETTAXPERCENT numeric(19,5)
0.00

BUDGETBENAMOUNT numeric(19,5)
0.00

BUDGETTAXAMOUNT numeric(19,5)
0.00

Calc_Min_Wage_Bal tinyint
0

WCACFPAY smallint
0

CHANGEBY_I char(15)
''
*Change By...(more) Join Now TATX1030.CHANGEBY_I
CONTENDDTE datetime
'1/1/1900'
Contract E...(more) Join Now
CONTSTARTDTE datetime
'1/1/1900'

CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now POP10100.CREATDDT
CRUSRID char(15)
''

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

EEOCLASS_I smallint
0

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

BUDGETEDFTE numeric(19,5)
0.00

INHERITANCELOCK tinyint
0

LOCATNID char(15)
''
Location I...(more) Join Now PA01101.LOCATNID
join ... more text available
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
NOTEINDX2 numeric(19,5)
0.00
Note Index...(more) Join Now
GROSSPAYINDEX int
0

BENEFITEXPINDEX int
0

WCOMPTAXEXPINDEX int
0

TAXBENEXPENSEINDEX int
0

EMPLYRFICAMEINDEX int
0

EMPLYRFICASEINDEX int
0

EMPLYRFUTAINDEX int
0

EMPLYRSUTAINDEX int
0

POSSTATUS smallint
0

REPORTSTOPOS char(7)
''

REVIEWSETUPCODE_I char(31)
''

STMACMTH smallint
0

SKTMACAM int
0

SKTMHPYR int
0

SKILLSETNUMBER_I int
0

SUPERVISORCODE_I char(7)
''

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

UNIONDUESAMOUNT_I numeric(19,5)
0.00

UNIONNAME_I char(31)
''

VACCRMTH smallint
0

VACCRAMT int
0

VACAPRYR int
0

WRNSTFLSBLWZR tinyint
0

WRNVCNFLSBLWZR tinyint
0

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

CHANGEREASON_I char(31)
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
TXTFIELD text

Text Field...(more) Join Now UPR40301.TXTFIELD
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