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
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