TE_TAUTH_VW1 (SQL View)	Index Back
Mobile Travel Auth View Mobile 8.8 Travel Auth view to show valid Travel Auth IDs.

TE_TAUTH_VW1

(SQL View)

Mobile Travel Auth View

Mobile 8.8 Travel Auth view to show valid Travel Auth IDs.

SELECT A.EMPLID , A.TRAVEL_AUTH_ID , A.DATE_FROM , A.DATE_TO , A.TRAVEL_AUTH_NAME , 0 , ' ' , A.REFERENCE_ID , A.COPY_TRAVEL_AUTH FROM PS_EX_TAUTH_HDR A

# 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 DATE_FROM Date(10) DATE Date From

4 DATE_TO Date(10) DATE Date To

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 TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Amount

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

8 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID

9 COPY_TRAVEL_AUTH Character(1) VARCHAR2(1) NOT NULL Field used to select a travel authorization to copy into a new travel authorization. Found on the EX_TAUTH_HDR record as well as the EX_TA_HDR_VW and EX_TA_HDR_WRK records. Used on the EX_COPY_TAUTH panel and EX_TAUTH_HDR_INQ panel.

#	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	DATE_FROM	Date(10)	DATE	Date From
4	DATE_TO	Date(10)	DATE	Date To
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	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Reference ID
9	COPY_TRAVEL_AUTH	Character(1)	VARCHAR2(1) NOT NULL	Field used to select a travel authorization to copy into a new travel authorization. Found on the EX_TAUTH_HDR record as well as the EX_TA_HDR_VW and EX_TA_HDR_WRK records. Used on the EX_COPY_TAUTH panel and EX_TAUTH_HDR_INQ panel.