| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: PER_ORG_ASGN_VW.HIRE_DT
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
NL_SA_ZFW |
Character(2) |
VARCHAR2(2) NOT NULL |
Premium Health Insurance
00=No deduction
01=Deduction
Default Value: 00
|
| 6 |
ZVW_CNTR_MTHD_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
ZVW Contribution Method "Basis zorgverzekering"
00=No Deduction
01=Deduction
|
| 7 |
ZVW_CD_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance Code for the ZVW
A=Not Insured, No AWBZ
B=Not Insured, Military Service
C=Insured, Regular Rate
D=Insured, Exception Sea-going
E=Insured, Non-Regular Rate
F=Insured, Multiple Rates
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 9 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_NHS_VW
|
| 10 |
REGISTR_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Registration Nbr
|
| 11 |
NL_SA_ZW |
Character(2) |
VARCHAR2(2) NOT NULL |
Premium Health Law
00=No Deduction
01=Deduction
Default Value: 00
|
| 12 |
NL_SA_WW |
Character(2) |
VARCHAR2(2) NOT NULL |
Unemployment Tax
00=No Deduction
01=Deduction
Default Value: 00
|
| 13 |
NL_SA_WAO |
Character(2) |
VARCHAR2(2) NOT NULL |
Disability Insurance
00=No Deduction
01=Deduction WAO
Default Value: 01
|
| 14 |
NL_WBA |
Character(1) |
VARCHAR2(1) NOT NULL |
Reducement Unemployment
Y/N Table Edit
Default Value: N
|