GPJP_YEA_HOUSE (SQL Table)	Index Back
YEA - Housing Loan Self Service YEA - Housing Loan

GPJP_YEA_HOUSE

(SQL Table)

YEA - Housing Loan

Self Service YEA - Housing Loan

# 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_HOUSE_DED Signed Number(20,6) DECIMAL(18,6) NOT NULL YEA - Special decution for Housing

4 GPJP_NO_HOUSE_LOAN Number(1,0) SMALLINT NOT NULL YEA - Number of housing loans applicable for housing loan deduction

5 GPJP_YEA_HOUSE_DAT Date(10) DATE SS YEA - Housing Loan, Start Date of Residence

6 GPJP_APP_CLASS1 Character(2) VARCHAR2(2) NOT NULL Applied class of first housing loan
01=01 Normal housing loan
02=02 Long-term housing loan
03=03 Specific repair work
04=04 Victim of North JPN quake
11=11 General (Spec Acquisition)
12=12 Long-term(Spec Acquisition)
13=13 Spec Repair work (Spec Acq)
21=21 General (SS Acqisition)
22=22 Long-term (SS Acquisition)
24=24 North JPN quake (SS Acq)
31=31 General (SSS Acquisition)
32=32 Long-term (SSS Acquisition)
34=34 North JPN quake (SSS Acq)
41=41 General (Spec Resi House)
42=42 Long-term (Spec Cert House)
44=44 North JPN quake (Spec Resi)

7 GPJP_PAYABLE_LOAN1 Number(19,6) DECIMAL(18,6) NOT NULL Loan payable at year end

8 GPJP_HOUSE_DATE2 Date(10) DATE SS YEA - Housing Loan, Start Date of Residence

9 GPJP_APP_CLASS2 Character(2) VARCHAR2(2) NOT NULL Applied class of second housing loan
01=01 Normal housing loan
02=02 Long-term housing loan
03=03 Specific repair work
04=04 Victim of North JPN quake
11=11 General (Spec Acquisition)
12=12 Long-term(Spec Acquisition)
13=13 Spec Repair work (Spec Acq)
21=21 General (SS Acqisition)
22=22 Long-term (SS Acquisition)
24=24 North JPN quake (SS Acq)
31=31 General (SSS Acquisition)
32=32 Long-term (SSS Acquisition)
34=34 North JPN quake (SSS Acq)
41=41 General (Spec Resi House)
42=42 Long-term (Spec Cert House)
44=44 North JPN quake (Spec Resi)

10 GPJP_PAYABLE_LOAN2 Number(19,6) DECIMAL(18,6) NOT NULL Loan payable at year end

#	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_HOUSE_DED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	YEA - Special decution for Housing
4	GPJP_NO_HOUSE_LOAN	Number(1,0)	SMALLINT NOT NULL	YEA - Number of housing loans applicable for housing loan deduction
5	GPJP_YEA_HOUSE_DAT	Date(10)	DATE	SS YEA - Housing Loan, Start Date of Residence
6	GPJP_APP_CLASS1	Character(2)	VARCHAR2(2) NOT NULL	Applied class of first housing loan 01=01 Normal housing loan 02=02 Long-term housing loan 03=03 Specific repair work 04=04 Victim of North JPN quake 11=11 General (Spec Acquisition) 12=12 Long-term(Spec Acquisition) 13=13 Spec Repair work (Spec Acq) 21=21 General (SS Acqisition) 22=22 Long-term (SS Acquisition) 24=24 North JPN quake (SS Acq) 31=31 General (SSS Acquisition) 32=32 Long-term (SSS Acquisition) 34=34 North JPN quake (SSS Acq) 41=41 General (Spec Resi House) 42=42 Long-term (Spec Cert House) 44=44 North JPN quake (Spec Resi)
7	GPJP_PAYABLE_LOAN1	Number(19,6)	DECIMAL(18,6) NOT NULL	Loan payable at year end
8	GPJP_HOUSE_DATE2	Date(10)	DATE	SS YEA - Housing Loan, Start Date of Residence
9	GPJP_APP_CLASS2	Character(2)	VARCHAR2(2) NOT NULL	Applied class of second housing loan 01=01 Normal housing loan 02=02 Long-term housing loan 03=03 Specific repair work 04=04 Victim of North JPN quake 11=11 General (Spec Acquisition) 12=12 Long-term(Spec Acquisition) 13=13 Spec Repair work (Spec Acq) 21=21 General (SS Acqisition) 22=22 Long-term (SS Acquisition) 24=24 North JPN quake (SS Acq) 31=31 General (SSS Acquisition) 32=32 Long-term (SSS Acquisition) 34=34 North JPN quake (SSS Acq) 41=41 General (Spec Resi House) 42=42 Long-term (Spec Cert House) 44=44 North JPN quake (Spec Resi)
10	GPJP_PAYABLE_LOAN2	Number(19,6)	DECIMAL(18,6) NOT NULL	Loan payable at year end