EMPLIDDATE_YEAR_VAL01=Normal housing loan
02=Long-term quality housing loan
03=Specific repair work
04=Victim of Northern JPN quake
01=Normal housing loan
02=Long-term quality housing loan
03=Specific repair work
04=Victim of Northern JPN quake
GPJP_YEA_HOUSE(SQL Table) |
Index Back |
|---|---|
YEA - Housing LoanSelf 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=Normal housing loan 02=Long-term quality housing loan 03=Specific repair work 04=Victim of Northern JPN quake |
| 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=Normal housing loan 02=Long-term quality housing loan 03=Specific repair work 04=Victim of Northern JPN quake |
| 10 | GPJP_PAYABLE_LOAN2 | Number(19,6) | DECIMAL(18,6) NOT NULL | Loan payable at year end |