EX_TA2_SRCH_VW (SQL View)	Index Back
Travel Authorization Search Retrieves list of existing travel authorizations by employee that are pending..

EX_TA2_SRCH_VW

(SQL View)

Travel Authorization Search

Retrieves list of existing travel authorizations by employee that are pending..

SELECT a.travel_auth_id , a.travel_auth_name , b.name , a.emplid , a.travel_auth_status , a.creation_dt FROM PS_EX_TAUTH_HDR a , ps_personal_data b WHERE a.travel_auth_status = 'PND' AND b.emplid = a.emplid

# 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

#	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