GPIN_LTA_CLAIMS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CLAIM_NBR	Character(8)	VARCHAR2(8) NOT NULL	Claim Number
3	GPIN_DT_FILED	Date(10)	DATE	This field holds the date on which the employee has filed his claim for the trip he has made. Default Value: %DATE
4	GPIN_LTA_TAX_IND	Character(1)	VARCHAR2(1) NOT NULL	This field stores information on whether the claim is taxable or non taxable. Y/N Table Edit Default Value: N
5	GPIN_LTA_REIM_AMT	Number(15,6)	DECIMAL(14,6) NOT NULL	This field the reimbursed amount.
6	DATE_FROM	Date(10)	DATE	Date From
7	DATE_TO	Date(10)	DATE	Previous Period Date To
8	GPIN_ORIGIN	Character(30)	VARCHAR2(30) NOT NULL	This field gives the origin of the employee's trip.
9	GPIN_DEST	Character(30)	VARCHAR2(30) NOT NULL	This field holds the destination to which the employee has made the trip.
10	GPIN_CLAIM_AMT	Signed Number(16,6)	DECIMAL(14,6) NOT NULL	This field stores information on the claimed amount as against his total allowance.
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
12	GPIN_TRANS_MODE	Character(2)	VARCHAR2(2) NOT NULL	This field gives details of the transportation mode of the employee when he makes his trip. 01=Train 02=Air 03=Car Rental 04=Bus 05=Ship
13	GPIN_TRAVEL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	This field gives the travel class for the employee when he makes his trip. 01=Economy 02=First Class 03=Second Class 04=Executive