EX_ADV_APLYD_VW (SQL View)	Index Back
Applied Advance Amount This view returns the amount of a Cash Advance that has been applied to expense sheets.

EX_ADV_APLYD_VW

(SQL View)

Applied Advance Amount

This view returns the amount of a Cash Advance that has been applied to expense sheets.

SELECT A.EMPLID , A.ADVANCE_ID , SUM(A.AMOUNT_APPLIED) FROM PS_EX_SHEET_ADV A GROUP BY A.EMPLID , A.ADVANCE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID

3 AMOUNT_APPLIED Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Applied

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID
3	AMOUNT_APPLIED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Applied