GPJP_YEA_SPSDED

#	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