Module List >
Module HR tables
PC40802
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PC40802 Table Definition
(COMPANY..PC Position Benefit Inheritance)
Field Definitions:
What is the 'source' column?
| PLANCODE |
char(15)
''
|
|
|
|
|
| JOBTITLE |
char(7)
''
|
Job Title:...(more) Join Now
|
TATX1030.JOBTITLE
|
|
|
| SEAT |
int
0
|
|
|
|
|
| SEQNUMBR |
int
0
|
Sequence N...(more) Join Now
|
IV10400.SEQNUMBR
|
|
|
| BENEFIT |
char(7)
''
|
Benefit: ...(more) Join Now
|
UPR00600.BENEFIT
|
|
|
| DEDCAMNT_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
|
|
|
| DEDCAMNT_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFBEGDT |
datetime
'1/1/1900'
|
Benefit Be...(more) Join Now
|
|
|
|
| BENEFITCB |
tinyint
0
|
|
|
|
|
| DEDNMTHD |
smallint
0
|
Deduction ...(more) Join Now
|
|
|
|
| DEDNPRCT_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
|
|
|
| DEDNPRCT_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDFRMLA |
smallint
0
|
Deduction ...(more) Join Now
|
|
|
|
| BENEFITSTATUS_I |
smallint
0
|
|
|
|
|
| DEDTRMAX_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
|
|
|
| DEDTRMAX_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_5 |
numeric(19,5)
0.00
|
|
|
|
|
| DETRMXUN_1 |
int
0
|
Deduction ...(more) Join Now
|
|
|
|
| DETRMXUN_2 |
int
0
|
|
|
|
|
| DETRMXUN_3 |
int
0
|
|
|
|
|
| DETRMXUN_4 |
int
0
|
|
|
|
|
| DETRMXUN_5 |
int
0
|
|
|
|
|
| CHILDREN_I |
smallint
0
|
|
|
|
|
| CONTRIBAFTERTAX_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTAFTERTAXDLR_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTRIBBONUS_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTRIBBONUSDOLLAR_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTRIBPRETAX_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTPRETAXDLR_I |
numeric(19,5)
0.00
|
|
|
|
|
| EARNINGSCODE |
char(15)
''
|
Earnings C...(more) Join Now
|
|
|
|
| PREMMETHOD_I |
smallint
0
|
|
|
|
|
| LIFEAMTCHILDREN_I |
numeric(19,5)
0.00
|
|
|
|
|
| LIFEAMTEMPL_I |
numeric(19,5)
0.00
|
|
|
|
|
| LIFEAMTSPOUSE_I |
numeric(19,5)
0.00
|
|
|
|
|
| SMOKER_I |
tinyint
0
|
|
|
|
|
| SMOKERSP_I |
tinyint
0
|
|
|
|
|
| TIERSUSED_I |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|