GPIN_NRP_TXH_AD(SQL Table) |
Index Back |
|---|---|
General Tax InformationThis is a record that is created to store the Tax Information such as HRA, Rent, Accomodation, Number of children, etc. for Payees |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | GPIN_TAX_YEAR |
Number(4,0) | SMALLINT NOT NULL | This field is used to store the Tax Year. |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | GPIN_EFFENDDT | Date(10) | DATE | End effective date |
| 6 | GPIN_HRA_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Accomodation Type
01=House Rent 02=Company Lease 03=None Default Value: 01 |
| 7 | GPIN_HRA_LOCATION | Character(2) | VARCHAR2(2) NOT NULL |
Location
01=Metropolitan 02=Non-Metropolitan |
| 8 | GPIN_HRA_RENT_SAVD | Number(6,0) | INTEGER NOT NULL | The field is used to store the Saved Rent Amount. |
| 9 | GPIN_HRA_RENT_PAID | Number(6,0) | INTEGER NOT NULL | Actual Rent Paid |
| 10 | GPIN_HRA_RENT_APPR | Number(6,0) | INTEGER NOT NULL | The field is used to store the Actual Rent Paid Amount. |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | GPIN_TDS_VERIFIED | Character(1) | VARCHAR2(1) NOT NULL |
Verified flag
N=No Y=Yes Default Value: N |
| 13 | GPIN_TDS_VERIFY_DT | Date(10) | DATE | This date field is used to store the date when a declaration was verified;. |
| 14 | GPIN_HRA_FURN | Character(2) | VARCHAR2(2) NOT NULL |
Furnished
01=Furnished 02=Un-Furnished 03=Not Applicable Default Value: 01 |
| 15 | GPIN_SS_TD_TS | DateTime(26) | TIMESTAMP | Self Service Time Stamp |
| 16 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 17 | 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. |
| 18 | GPIN_LANDLORD_NAME | Character(50) | VARCHAR2(50) NOT NULL | Landlord Name |
| 19 | GPIN_LANPAN_EXISTS | Character(1) | VARCHAR2(1) NOT NULL |
PAN Exists?
Y/N Table Edit Default Value: Y |
| 20 | GPIN_EMP_ADDRESS | Long Character(1000) | VARCHAR2(1000) | Employee Address |