EX_CAN_TAUTH_VW (SQL View)	Index Back
Delete Travel Authorization View used to select list of travel authorizations for deletion. Only retrieves those travel authorizations whose status is 'Pending'. Used on the EX_DEL_TAUTH and EX_TA_DEL_SUMMARY panels.

EX_CAN_TAUTH_VW

(SQL View)

Delete Travel Authorization

View used to select list of travel authorizations for deletion. Only retrieves those travel authorizations whose status is 'Pending'. Used on the EX_DEL_TAUTH and EX_TA_DEL_SUMMARY panels.

SELECT A.EMPLID , A.TRAVEL_AUTH_ID , A.BUSINESS_UNIT_GL , A.USER_CANCEL_PB , A.TRAVEL_AUTH_NAME , A.BUSINESS_PURPOSE , A.DATE_FROM , A.DATE_TO , A.SETID , A.TOTAL_AMT , A.CURRENCY_CD FROM PS_EX_TAUTH_HDR A WHERE A.TRAVEL_AUTH_STATUS IN ('APR') AND A.COPY_TRAVEL_AUTH = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TRAVEL_AUTH_ID Character(10) VARCHAR2(10) NOT NULL Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.

3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

4 USER_CANCEL_PB Character(1) VARCHAR2(1) NOT NULL User Cancel Request
A=Active
C=Closed Out
D=Mark for Delete
H=Hold from Budget Checking
I=Admin Cancel
U=User Cancel

5 TRAVEL_AUTH_NAME Character(30) VARCHAR2(30) NOT NULL Field used to give a descriptive name to each travel authorization. Associated with the header information of a travel authorization and found on many records and panels within travel authorization objects.

6 BUSINESS_PURPOSE Character(5) VARCHAR2(5) NOT NULL Business Purpose
Prompt Table: EX_PURPOSE_TBL

7 DATE_FROM Date(10) DATE Date From

8 DATE_TO Date(10) DATE Date To

9 SETID Character(5) VARCHAR2(5) NOT NULL SetID

10 TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Amount

11 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	TRAVEL_AUTH_ID	Character(10)	VARCHAR2(10) NOT NULL	Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
3	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
4	USER_CANCEL_PB	Character(1)	VARCHAR2(1) NOT NULL	User Cancel Request A=Active C=Closed Out D=Mark for Delete H=Hold from Budget Checking I=Admin Cancel U=User Cancel
5	TRAVEL_AUTH_NAME	Character(30)	VARCHAR2(30) NOT NULL	Field used to give a descriptive name to each travel authorization. Associated with the header information of a travel authorization and found on many records and panels within travel authorization objects.
6	BUSINESS_PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Business Purpose Prompt Table: EX_PURPOSE_TBL
7	DATE_FROM	Date(10)	DATE	Date From
8	DATE_TO	Date(10)	DATE	Date To
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
10	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL