GPIN_LTA_CUR_VW (SQL View)	Index Back
LTA Current Claims This view contains Leave Travel Allowance Claims information.

GPIN_LTA_CUR_VW

(SQL View)

LTA Current Claims

This view contains Leave Travel Allowance Claims information.

SELECT A.EMPLID ,A.CLAIM_NBR ,A.GPIN_DT_FILED ,A.GPIN_LTA_TAX_IND ,A.GPIN_LTA_REIM_AMT ,A.DATE_FROM ,A.DATE_TO ,A.GPIN_ORIGIN ,A.GPIN_DEST ,A.GPIN_CLAIM_AMT ,A.CURRENCY_CD ,A.GPIN_TRANS_MODE ,A.GPIN_TRAVEL_CLASS FROM PS_GPIN_LTA_CLAIMS A WHERE A.EMPLID NOT IN ( SELECT B.EMPLID FROM PS_GPIN_LTA_WA B WHERE A.EMPLID = B.EMPLID AND A.CLAIM_NBR = B.CLAIM_NBR)

# 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

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

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