| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
DATE_YEAR_VAL |
Number(4,0) |
SMALLINT NOT NULL |
Date Year Value
|
| 3 |
GPJP_YEA_EEINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
GPJP YEA Employee salary expected income
|
| 4 |
GPJP_YEA_SALINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
YEA - Salaryl Income
|
| 5 |
GPJP_YEA_SALLEGIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA, Spouse Salary Legitimate Expense or deduction
|
| 6 |
GPJP_YEA_BUSINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Spouse Business Income
|
| 7 |
GPJP_YEA_BUSLEGIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Spouse Business Income Legitimate Deduction or Expense
|
| 8 |
GPJP_YEA_MISINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Spouse Misc. Income
|
| 9 |
GPJP_YEA_MISLEGIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Spouse's Misc. Income Legitimate Deduction or Expense
|
| 10 |
GPJP_YEA_DIVINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Divident Income
|
| 11 |
GPJP_YEA_DIVLEGIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Divident Legitimate Deduction or Expense
|
| 12 |
GPJP_YEA_RSINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Real Estate income
|
| 13 |
GPJP_YEA_RSLEGIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Real Estate Legitimate Deduction / Expense
|
| 14 |
GPJP_YEA_RETINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Retirement Income
|
| 15 |
GPJP_YEA_RETLEGIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS yEA - Retirement Income Legitimate Deduction / Expense
|
| 16 |
GPJP_YEA_OCCINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Accasional Income
|
| 17 |
GPJP_YEA_OCCLEGIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Occasional Legitiamte Deduction / Expense
|
| 18 |
GPJP_YEA_LTAINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Lonmg Term Assignment Income
|
| 19 |
GPJP_YEA_LTALEGIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Long Term Income Legitimate Deduction/ Expense
|
| 20 |
GPJP_YEA_OTHINC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Other Income
|
| 21 |
GPJP_YEA_SPCDED |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Special Deduction
|
| 22 |
GPJP_YEA_OTHLEGIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Other Income Legitimate Deduction / Expense
|
| 23 |
GPJP_YEA_EEINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
GPJP YEA Employee salary expected income
|
| 24 |
GPJP_YEA_SALINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
YEA - Salaryl Income
|
| 25 |
GPJP_YEA_SALINC_E1 |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
YEA - Salaryl Income
|
| 26 |
GPJP_YEA_SALLEGITE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA, Spouse Salary Legitimate Expense or deduction
|
| 27 |
GPJP_YEA_BUSINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Spouse Business Income
|
| 28 |
GPJP_YEA_BUSLEGITE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Spouse Business Income Legitimate Deduction or Expense
|
| 29 |
GPJP_YEA_MISINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Spouse Misc. Income
|
| 30 |
GPJP_YEA_MISLEGITE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Spouse's Misc. Income Legitimate Deduction or Expense
|
| 31 |
GPJP_YEA_DIVINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Divident Income
|
| 32 |
GPJP_YEA_DIVLEGITE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Divident Legitimate Deduction or Expense
|
| 33 |
GPJP_YEA_RSINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Real Estate income
|
| 34 |
GPJP_YEA_RSLEGIT_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Real Estate Legitimate Deduction / Expense
|
| 35 |
GPJP_YEA_RETINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Retirement Income
|
| 36 |
GPJP_YEA_RETLEGITE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS yEA - Retirement Income Legitimate Deduction / Expense
|
| 37 |
GPJP_YEA_OCCINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Accasional Income
|
| 38 |
GPJP_YEA_OCCLEGITE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Occasional Legitiamte Deduction / Expense
|
| 39 |
GPJP_YEA_LTAINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Lonmg Term Assignment Income
|
| 40 |
GPJP_YEA_LTALEGITE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Long Term Income Legitimate Deduction/ Expense
|
| 41 |
GPJP_YEA_OTHINC_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Other Income
|
| 42 |
GPJP_YEA_OTHLEGITE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SS YEA - Other Income Legitimate Deduction / Expense
|
| 43 |
GPJP_YEA_SPCDED_E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Special Deduction
|
| 44 |
GPJP_YEA_TOT10E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total field used in YEA Self Service feature
|
| 45 |
GPJP_YEA_TOT10 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total field used in YEA Self Service feature
|
| 46 |
GPJP_YEA_TOT11E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total field used in YEA Self Service feature
|
| 47 |
GPJP_YEA_TOT11 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total field used in YEA Self Service feature
|
| 48 |
GPJP_YEA_TOT6E |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total field used in YEA Self Service feature
|
| 49 |
GPJP_YEA_TOT6 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total field used in YEA Self Service feature
|