EX_ALERT_TA_VW

(SQL View)
Index Back

Travel Authorization Inquiry


SELECT a.travel_auth_id , a.travel_auth_name , b.name , a.emplid , a.travel_auth_status , a.creation_dt , a.date_from ,a.date_to ,a.business_purpose ,a.oprid_last_updt ,a.currency_cd ,a.business_unit_gl , c.authorized_oprid FROM PS_EX_TAUTH_HDR a , ps_personal_data b , ps_ex_ee_auth_tbl c WHERE b.emplid = a.emplid AND c.emplid = a.emplid AND a.travel_auth_status = 'APR' AND a.copy_travel_auth = 'N'

# 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.
2 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.
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: EX_EE_AUTH_VW

5 TRAVEL_AUTH_STATUS Character(3) VARCHAR2(3) NOT NULL Describes the current status of the travel authorization - whether pending, submitted or approved. This field is associated with the header record of travel authorizations and is found on many records and panels within travel authorization objects. The status will change depending on the action taken upon the travel authorization. PeopleCode is used to update the status.
APR=Approved
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
HDA=On Hold, with Approver
HDU=On Hold, with Auditor
HLD=On Hold
PAR=Approvals in Process
PND=Pending
PRO=In Process
RCN=Reconciled
RRT=Transaction Rerouted
SFA=Submission in Process
STG=Staged
SUB=Submitted for Approval
XML=Submitted, Pending Validation
6 CREATION_DT Date(10) DATE Creation Date
7 DATE_FROM Date(10) DATE Date From
8 DATE_TO Date(10) DATE Date To
9 BUSINESS_PURPOSE Character(5) VARCHAR2(5) NOT NULL Business Purpose
10 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL

13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).