EMPLIDGPIN_TAX_YEAREFFDTDefault Value: %date
01=Metropolitan
02=Non-Metropolitan
GPIN_SS_HRA_VW(SQL View) |
Index Back |
|---|---|
Self Service HRA details.Form 12BB HRA Details. |
| SELECT A.EMPLID , A.GPIN_TAX_YEAR , A.EFFDT , A.GPIN_HRA_RENT_PAID , A.GPIN_HRA_RENT_APPR , A.GPIN_HRA_LOCATION , A.GPIN_EFFENDDT , A.GPIN_IT_PAN_NBR , A.GPIN_LANDLORD_NAME , A.GPIN_EMP_ADDRESS FROM PS_GPIN_TDS_HRA A WHERE A.GPIN_HRA_TYPE IN ('01','02') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | GPIN_TAX_YEAR |
Number(4,0) | SMALLINT NOT NULL | This field is used to store the Tax Year. |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | GPIN_HRA_RENT_PAID | Number(6,0) | INTEGER NOT NULL | Actual Rent Paid |
| 5 | GPIN_HRA_RENT_APPR | Number(6,0) | INTEGER NOT NULL | The field is used to store the Actual Rent Paid Amount. |
| 6 | GPIN_HRA_LOCATION | Character(2) | VARCHAR2(2) NOT NULL |
Location
01=Metropolitan 02=Non-Metropolitan |
| 7 | GPIN_EFFENDDT | Date(10) | DATE | End effective date |
| 8 | GPIN_IT_PAN_NBR | Character(30) | VARCHAR2(30) NOT NULL | This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Permanent Account Number. |
| 9 | GPIN_LANDLORD_NAME | Character(50) | VARCHAR2(50) NOT NULL | Landlord Name |
| 10 | GPIN_EMP_ADDRESS | Long Character(1000) | VARCHAR2(1000) | Employee Address |