EX_TA_OUTST_VW (SQL View)	Index Back
Outstanding Travel Auth Amount Displays the balance remaining on an employees' travel authorization.

EX_TA_OUTST_VW

(SQL View)

Outstanding Travel Auth Amount

Displays the balance remaining on an employees' travel authorization.

SELECT A.EMPLID, SUM(B.MONETARY_AMOUNT), B.CURRENCY_CD FROM PS_EX_TAUTH_HDR A, PS_EX_TAUTH_LINE B WHERE B.TRAVEL_AUTH_ID = A.TRAVEL_AUTH_ID AND A.TRAVEL_AUTH_STATUS = 'PD' GROUP BY A.EMPLID, B.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Balance

3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance
3	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code