EX_TA_HDR_AW_V2

(SQL View)
 Index Back

Travel Auth Header View

Additional header information with descriptions

SELECT A.TRAVEL_AUTH_ID , A.EMPLID , B.FIRST_NAME || ' ' || B.LAST_NAME , C.DESCR , CASE WHEN A.TRAVEL_FROM <> ' ' THEN D1.DESCR ELSE ' ' END , CASE WHEN A.TXN_LOCATION <> ' ' THEN D.DESCR ELSE ' ' END , CASE WHEN A.TXN_LOCATION <> ' ' THEN D.DESCR ELSE ' ' END , A.DATE_FROM , A.DATE_TO FROM PS_EX_TAUTH_HDR A LEFT OUTER JOIN PS_EX_CUR_LOC_VW D1 ON A.SETID = D1.SETID AND A.TRAVEL_FROM = D1.TXN_LOCATION LEFT OUTER JOIN PS_EX_CUR_LOC_VW D ON A.SETID = D.SETID AND A.TXN_LOCATION = D.TXN_LOCATION , PS_PERSONAL_DATA B , PS_EX_PURPOSE_TBL C , PS_SET_CNTRL_REC CTL WHERE A.EMPLID = B.EMPLID AND CTL.SETCNTRLVALUE = A.BUSINESS_UNIT_GL AND CTL.RECNAME = 'EX_PURPOSE_TBL' AND CTL.SETID = C.SETID AND A.BUSINESS_PURPOSE = C.BUSINESS_PURPOSE AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_EX_PURPOSE_TBL X WHERE X.SETID = C.SETID AND X.BUSINESS_PURPOSE = C.BUSINESS_PURPOSE AND X.EFF_STATUS = 'A' AND X.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.

Default Value: NEXT

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 NAME_60 Character(61) VARCHAR2(61) NOT NULL Name
4 BUS_PURP_DESCR Character(30) VARCHAR2(30) NOT NULL Business Purpose
5 TRAVEL_FROM_LOC Character(30) VARCHAR2(30) NOT NULL Orignating Location
6 TXN_LOC Character(30) VARCHAR2(30) NOT NULL Destination Location
7 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location
8 DATE_FROM Date(10) DATE Date From
9 DATE_TO Date(10) DATE Date To