GPIN_MDA_CUR_VW (SQL View)	Index Back
MDA Current Claims This view contains current Medical Allowance Claims for employees.

GPIN_MDA_CUR_VW

(SQL View)

MDA Current Claims

This view contains current Medical Allowance Claims for employees.

SELECT A.EMPLID ,A.CLAIM_NBR ,A.GPIN_DT_FILED ,A.GPIN_CLAIM_AMT ,A.CURRENCY_CD FROM PS_GPIN_MDA_CLAIMS A WHERE A.EMPLID NOT IN ( SELECT B.EMPLID FROM PS_GPIN_MDA_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.

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

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

#	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.
4	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.
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL