EX_TA_HDR_AW_VW (SQL View)	Index Back
Travel Authorization Header This record contains the general information required to create a travel authorization.

EX_TA_HDR_AW_VW

(SQL View)

Travel Authorization Header

This record contains the general information required to create a travel authorization.

SELECT TRAVEL_AUTH_ID , EMPLID , TRAVEL_AUTH_STATUS , PROJ_MGR_FLAG , CREATION_DT , APPROVAL_DT , SUBMISSION_DATE , RESUBMISSION_DT , LASTUPDDTTM , OPRID_LAST_UPDT , TRAVEL_AUTH_NAME , OPRID_ENTERED_BY , SETID , BUSINESS_UNIT_GL , ACCOUNTING_DT , BUSINESS_PURPOSE , TOTAL_AMT , (SELECT %COALESCE(SUM(PS_EX_TAUTH_LINE.MONETARY_AMOUNT),0) FROM PS_EX_TAUTH_LINE WHERE PS_EX_TAUTH_LINE.TRAVEL_AUTH_ID = PS_EX_TAUTH_HDR.TRAVEL_AUTH_ID AND (PS_EX_TAUTH_LINE.REIMBURSEMENT_CD = 'N' OR PS_EX_TAUTH_LINE.REIMB_ACTION <> ' ')) , (TOTAL_AMT - ( SELECT %COALESCE(SUM(PS_EX_TAUTH_LINE.MONETARY_AMOUNT),0) FROM PS_EX_TAUTH_LINE WHERE PS_EX_TAUTH_LINE.TRAVEL_AUTH_ID = PS_EX_TAUTH_HDR.TRAVEL_AUTH_ID AND (PS_EX_TAUTH_LINE.REIMBURSEMENT_CD = 'N' OR PS_EX_TAUTH_LINE.REIMB_ACTION <> ' '))) , CURRENCY_CD FROM PS_EX_TAUTH_HDR

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 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
Default Value: PND

4 PROJ_MGR_FLAG Character(1) VARCHAR2(1) NOT NULL Project Manager Review

5 CREATION_DT Date(10) DATE Creation Date
Default Value: %date

6 APPROVAL_DT Date(10) DATE Date of Approval

7 SUBMISSION_DATE Date(10) DATE Submission Date

8 RESUBMISSION_DT Date(10) DATE Resubmission Date

9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

10 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

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

12 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

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

14 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL

15 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

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

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

18 TOTAL_NONREIMB_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Personal Expenses

19 TOTAL_REIMB_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Due Employee

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

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	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 Default Value: PND
4	PROJ_MGR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Project Manager Review
5	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %date
6	APPROVAL_DT	Date(10)	DATE	Date of Approval
7	SUBMISSION_DATE	Date(10)	DATE	Submission Date
8	RESUBMISSION_DT	Date(10)	DATE	Resubmission Date
9	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
11	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.
12	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
13	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
14	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL
15	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
16	BUSINESS_PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Business Purpose Prompt Table: EX_PURPOSE_TBL
17	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
18	TOTAL_NONREIMB_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Personal Expenses
19	TOTAL_REIMB_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Due Employee
20	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code