GPIN_HP_INC_LOS

#	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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	GPIN_POSSESSION_DT	Date(10)	DATE NOT NULL	Income/Loss from House property
5	GPIN_PROP_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Income/Loss from House property LO=Let-Out Property SO=Self-Occupied Property
6	GPIN_HP_APPR_REJ	Character(1)	VARCHAR2(1) NOT NULL	Income/Loss from House property A=Approved R=Rejected
7	GPIN_EMP_ADDRESS	Long Character(1000)	VARCHAR2(1000)	Employee Address
8	GPIN_LANDLORD_NAME	Character(50)	VARCHAR2(50) NOT NULL	Landlord Name
9	GPIN_LEND_ADDRESS	Long Character(1000)	VARCHAR2(1000)	Employee Address
10	GPIN_LEND_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.
11	GPIN_ANNUAL_VAL	Number(15,2)	DECIMAL(14,2) NOT NULL	Income/Loss from House property
12	GPIN_TAX_MUNICIPAL	Number(15,2)	DECIMAL(14,2) NOT NULL	Income/Loss from House property
13	GPIN_GROSS_ANN_VAL	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Income/Loss from House property
14	GPIN_ANN_REP_MAINT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Income/Loss from House property
15	GPIN_NET_ANN_VAL	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Income/Loss from House property
16	GPIN_INT_BORR_CAP	Number(15,2)	DECIMAL(14,2) NOT NULL	Income/Loss from House property
17	GPIN_INC_LOSS_HP	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Income/Loss from House property