| # |
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 Record
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 5 |
NAME_INITIALS |
Character(6) |
VARCHAR2(6) NOT NULL |
Name Initials
|
| 6 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 7 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 8 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 9 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
|
| 10 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 11 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 12 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 13 |
COMP_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
|
| 14 |
EMPLR_TAX_NUM_NLD |
Number(9,0) |
DECIMAL(9) NOT NULL |
Federal Employer Tax ID
|
| 15 |
GPNL_TAX_NUM_SUF |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Number Suffix
|
| 16 |
GPNL_SOC_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Social Security Number
|
| 17 |
GPNL_ZFW_CNTR_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
ZFW Contribution Method
00=No Premium
01=Employee/Total
02=No Employee/Total
03=No Employee/Employer
04=Private Health Insurance
|
| 18 |
GPNL_ZW_CNTR_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
GPNL_ZW_CNTR_MTHD
00=No Premium
01=Employee/Total
02=No Employee/Total
03=No EE/Employer
|
| 19 |
GPNL_WW_CNTR_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
GPNL_WW_CNTR_MTHD
00=No Premium
01=Employee/Total
02=No Employee/Total
03=No Employee / Employer
|
| 20 |
GPNL_WAO_CNTR_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
GPNL_WAO_CNTR_MTHD
00=No Premium
01=Employee/Total
02=No Employee/Total
03=No Employee/ Employer
|
| 21 |
GPNL_TAX_TABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Table
0=No Tax
1=White Tax Table
2=Green Tax Table
|
| 22 |
GPNL_TAX_CREDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Credits
|
| 23 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
|
| 24 |
GPNL_INCOME |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Income
|
| 25 |
GPNL_SPCL_RT_TAX |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Percentage Special Adjustment
|
| 26 |
GPNL_SPCL_RT_DT |
Date(10) |
DATE |
Date Authorization for Percentage Special Tax Rate
|
| 27 |
GPNL_TRAVEL_DATA |
Character(2) |
VARCHAR2(2) NOT NULL |
Travel Data
00=N/A
01=Company Car or Van
02=Arrangement Tax Authority
03=Employer Transportation
04=Travel Allowance for Commute
04=Travel Allowance
05=Carpool Rules Applicable
05=Carpool Rules Applicable
06=Private Use Company Van 10%
06=Private Use Company Van 10%
07=Private Use Company Van 2.5%
07=Private Use Company Van 2.5%
08=Special Tax Company Van
08=Special Tax Company Van
|
| 28 |
GPNL_COM_ALLOW |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Commute Allowance
|
| 29 |
GPNL_CAR_NO_TAX_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason for not having a fiscal contribution for a company car.
1=Employer Arrangement
2=Personal Arrangement
3=Other Evidence
4=Company Van no Private Use
4=Company Van no Private Use
5=Alternately use Company Van
6=0% Tax on Car w/o CO2 Emission
7=Exclusive Business use Van
|
| 30 |
GPNL_CAR_TAX_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Taxable amount for the private use of a company car
|
| 31 |
GPNL_ZVW_CNTR_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
ZVW Contribution Method
00=No Premium
01=Employee/Total
02=No Employee/Total
03=No Employee/Employer
|
| 32 |
GPNL_ZVW_CD |
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
J=Insured, Small-job Rule
J=Insured, Small-job Rule
|