GPIN_NRP_TXH_VW(SQL View) |
Index Back |
|---|---|
HRA InformationHRA Information |
| SELECT EMPLID ,GPIN_TAX_YEAR ,EFFDT ,GPIN_EFFENDDT ,GPIN_HRA_TYPE ,GPIN_HRA_LOCATION ,GPIN_HRA_RENT_SAVD ,GPIN_HRA_RENT_PAID , GPIN_HRA_RENT_APPR ,CURRENCY_CD ,GPIN_TDS_VERIFIED ,GPIN_TDS_VERIFY_DT ,GPIN_HRA_FURN ,GPIN_SS_TD_TS , PIN_NUM+50000000 ,GPIN_IT_PAN_NBR ,GPIN_LANDLORD_NAME ,GPIN_LANPAN_EXISTS ,GPIN_EMP_ADDRESS FROM PS_GPIN_TDS_HRA |
| # | 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 NOT NULL |
Effective Date
Default Value: %date |
| 4 | GPIN_EFFENDDT | Date(10) | DATE | End effective date |
| 5 | GPIN_HRA_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Accomodation Type
01=House Rent 02=Company Lease 03=None Default Value: 01 |
| 6 | GPIN_HRA_LOCATION | Character(2) | VARCHAR2(2) NOT NULL |
Location
01=Metropolitan 02=Non-Metropolitan |
| 7 | GPIN_HRA_RENT_SAVD | Number(6,0) | INTEGER NOT NULL | The field is used to store the Saved Rent Amount. |
| 8 | GPIN_HRA_RENT_PAID | Number(6,0) | INTEGER NOT NULL | Actual Rent Paid |
| 9 | GPIN_HRA_RENT_APPR | Number(6,0) | INTEGER NOT NULL | The field is used to store the Actual Rent Paid Amount. |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 11 | GPIN_TDS_VERIFIED | Character(1) | VARCHAR2(1) NOT NULL |
Verified flag
N=No Y=Yes Default Value: N |
| 12 | GPIN_TDS_VERIFY_DT | Date(10) | DATE | This date field is used to store the date when a declaration was verified;. |
| 13 | GPIN_HRA_FURN | Character(2) | VARCHAR2(2) NOT NULL |
Furnished
01=Furnished 02=Un-Furnished 03=Not Applicable Default Value: 01 |
| 14 | GPIN_SS_TD_TS | DateTime(26) | TIMESTAMP | Self Service Time Stamp |
| 15 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 16 | 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. |
| 17 | GPIN_LANDLORD_NAME | Character(50) | VARCHAR2(50) NOT NULL | Landlord Name |
| 18 | GPIN_LANPAN_EXISTS | Character(1) | VARCHAR2(1) NOT NULL |
PAN Exists?
Y/N Table Edit Default Value: Y |
| 19 | GPIN_EMP_ADDRESS | Long Character(1000) | VARCHAR2(1000) | Employee Address |