GPIN_MDA_CLAIMS (SQL Table)	Index Back
MDA Claims This record captures the Medical Allowance claims information for payees.

GPIN_MDA_CLAIMS

(SQL Table)

MDA Claims

This record captures the Medical Allowance claims information for payees.

# 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
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
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 Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL