EX_DEL_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_DEL_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.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 ('PND','DEN','DNA','DNU') OR (A.TRAVEL_AUTH_STATUS = 'CLS' AND A.USER_CANCEL_PB IN ('U','I')) ) AND (NOT EXISTS ( SELECT 'X' FROM PS_KK_SOURCE_HDR B WHERE B.TRAVEL_AUTH_ID = A.TRAVEL_AUTH_ID) OR (EXISTS ( SELECT 'X' FROM PS_KK_SOURCE_HDR B WHERE B.TRAVEL_AUTH_ID = A.TRAVEL_AUTH_ID) AND NOT EXISTS ( SELECT 'X' FROM PS_EX_APRVL_HIST H WHERE H.EX_DOC_ID = A.TRAVEL_AUTH_ID AND H.EX_DOC_TYPE = 'T' AND H.ACTION_NAME = 'SUB')) OR (EXISTS ( SELECT 'X' FROM PS_KK_SOURCE_HDR B WHERE B.TRAVEL_AUTH_ID = A.TRAVEL_AUTH_ID) AND EXISTS ( SELECT 'X' FROM PS_EX_APRVL_HIST H WHERE H.EX_DOC_ID = A.TRAVEL_AUTH_ID AND H.EX_DOC_TYPE = 'T' AND H.ACTION_NAME IN ('SBR','WDR','DNY') AND H.SEQ_NUM = ( SELECT MAX(H2.SEQ_NUM) FROM PS_EX_APRVL_HIST H2 WHERE H.EX_DOC_ID = H2.EX_DOC_ID AND H.EX_DOC_TYPE = H2.EX_DOC_TYPE AND H.VERSION_NUM = H2.VERSION_NUM))))

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

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

6 DATE_FROM Date(10) DATE Date From

7 DATE_TO Date(10) DATE Date To

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

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

10 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	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	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.
5	BUSINESS_PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Business Purpose Prompt Table: EX_PURPOSE_TBL
6	DATE_FROM	Date(10)	DATE	Date From
7	DATE_TO	Date(10)	DATE	Date To
8	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
9	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code