GPJP_IT_PYE_TAX

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number Prompt Table: GPJP_TAXESIT_VW
5	GPJP_IT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Used in Income Tax Data. 10=KOU 20=OTSU 30=Designated Rate Default Value: 10
6	TAX_RT	Signed Number(12,10)	DECIMAL(10,10) NOT NULL	Tax Rate (after form)
7	GPJP_IT_EMPTYPE	Character(2)	VARCHAR2(2) NOT NULL	Used in Income Tax Data. 10=Ordinary 20=Working Student 30=Elderly 30=Elderly 40=Ordinary Widow or Widower 50=Special Widow 60=Working Student and Elderly 60=Working Student and Elderly 70=Wrking Std and Ord Widow/er 80=Working Std and Special Widow Default Value: 10
8	GPJP_IT_EMPDIS	Character(2)	VARCHAR2(2) NOT NULL	Used in Income Tax Data. 10=No Disability 20=Disabled 30=Special Disability Default Value: 10
9	GPJP_IT_HOH	Character(1)	VARCHAR2(1) NOT NULL	Used in Income Tax Data. Y/N Table Edit Default Value: Y
10	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
11	GPJP_IT_HOHREL	Character(2)	VARCHAR2(2) NOT NULL	Used in Income Tax Data 10=Self A=Aunt B=Brother D=Daughter E=Employee FA=Father FI=Father-in-Law FR=Friend GC=Grandchild GF=Grandfather GM=Grandmother M=Mother MI=Mother-in-Law N=Neighbor NA=Domestic Partner Adult ND=Domestic Partner Daughter NE=Nephew NI=Niece NS=Domestic Partner Son O=Other R=Other Relative RO=Roommate S=Son SI=Sister SP=Spouse T=Estate U=Uncle X=ExSpouse Default Value: 10
12	GPJP_DIS_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Disability Description
13	GPJP_DIS_RCHAN	Character(50)	VARCHAR2(50) NOT NULL	Reason of Disability Change
14	GPJP_INC_AMT_DED	Character(1)	VARCHAR2(1) NOT NULL	Subject to Income Amount Deduction N=No Y=Yes Default Value: N
15	GPJP_LT_EMPTYPE	Character(2)	VARCHAR2(2) NOT NULL	Used in Income Tax Data. 40=Widow 50=Single Parent