| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 5 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 6 |
GPNL_SOC_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Social Security Number
|
| 7 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 8 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 9 |
NAME_INITIALS |
Character(6) |
VARCHAR2(6) NOT NULL |
Name Initials
|
| 10 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 11 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 12 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 13 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
|
| 14 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 15 |
GPNL_SV_DAYS_1E |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Social Insurance Days 1e
|
| 16 |
GPNL_SV_INCOME_1E |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Income 1e
|
| 17 |
GPNL_WAO_BS_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WAO (disabillity) Base 1e
|
| 18 |
GPNL_WAO_CT_EE_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WAO (Disabillity) EE Contributn 1e
|
| 19 |
GPNL_WAO_CT_TT_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WAO (Disabillity) Total Contributn 1e
|
| 20 |
GPNL_WAO_BS_2E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WAO (Disabillity) Base 2e
|
| 21 |
GPNL_WAO_CT_TT_2E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WAO (Disabillity) Total Contributn 2e
|
| 22 |
GPNL_WW_BS_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WW Base 1e
|
| 23 |
GPNL_WW_CT_EE_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WW EE Contributn 1e
|
| 24 |
GPNL_WW_CT_TT_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WW Total Contributn 1e
|
| 25 |
GPNL_WW_BS_2E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WW Base 2e
|
| 26 |
GPNL_WW_CT_TT_2E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WW Total Contributn 2e
|
| 27 |
GPNL_ZFW_BS_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ZFW Base 1e
|
| 28 |
GPNL_ZFW_CT_EE_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ZFW EE Contributn 1e
|
| 29 |
GPNL_ZFW_CT_TT_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ZFW Total Contributn 1e
|
| 30 |
GPNL_ZW_BS_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ZW Base 1e
|
| 31 |
GPNL_ZW_CT_EE_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ZW EE Contributn 1e
|
| 32 |
GPNL_ZW_CT_TT_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ZW Total Contributn 1e
|
| 33 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 34 |
GPNL_ZVW_BS_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ZVW Base
|
| 35 |
GPNL_ZVW_CT_EE_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WALVIS
|
| 36 |
GPNL_ZVW_CT_TT_1E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WALVIS
|