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

EX_TAUTH_HDR_VW

(SQL View)

Travel Authorization Header

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

SELECT A.EMPLID , A.TRAVEL_AUTH_ID , A.TRAVEL_AUTH_STATUS , A.EX_ORIGIN , A.USER_CANCEL_PB , A.REFERENCE_ID , A.APPROVAL_LEVEL , A.CREATION_DT , A.APPROVAL_DT , A.SUBMISSION_DATE , A.RESUBMISSION_DT , A.LASTUPDDTTM , A.OPRID_LAST_UPDT , A.DST_CNTRL_ID , A.TRAVEL_AUTH_NAME , A.TXN_LOCATION , A.TRAVEL_FROM , A.TEMPLATE , A.OPRID_ENTERED_BY , A.SETID , A.BUSINESS_UNIT_GL , A.EMPL_RCD , A.DATE_FROM , A.DATE_TO , A.BUDGET_HDR_STATUS , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID , A.KK_TRAN_OVER_DTTM , A.KK_AMOUNT_TYPE , A.ACCOUNTING_DT , A.PROCESS_INSTANCE , A.PROCESS_FLAG , A.BUSINESS_PURPOSE , A.ADVANCE_ID , A.COUNTRY , A.PROJ_MGR_FLAG , A.COPY_TRAVEL_AUTH , A.COMMENTS , A.TOTAL_AMT , A.CURRENCY_CD , A.PREF_MRCH_NOT_USED , A.OUT_OF_POLICY , A.MULT_PER_DIEM , A.RISK_EXISTS_FLG , A.ROLLOVER_STATUS 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 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 EX_ORIGIN Character(1) VARCHAR2(1) NOT NULL Origin of Entry (Expenses)
A=Asset Lifecycle Management
H=Mobile Hand Held Device
M=Mobile Time and Expense
N=NUI
P=Primavera P6
W=Web

5 USER_CANCEL_PB Character(1) VARCHAR2(1) NOT NULL User Cancel Request
A=Active
C=Closed Out
D=Mark for Delete
H=Hold from Budget Checking
I=Admin Cancel
U=User Cancel

6 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID
Prompt Table: EX_REFERENCE

7 APPROVAL_LEVEL Character(1) VARCHAR2(1) NOT NULL Approval Level
A=Approver Only
B=Pre- and Post-Pay Audit
E=Approver & Pre-Pay Auditor
I=Approve, Pre- & Post-Pay Audit
N=None
S=Approver & Post-Pay Auditor
T=Auditor Only - Post-Payment
U=Auditor Only - Pre-Payment
Default Value: A

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

9 APPROVAL_DT Date(10) DATE Date of Approval

10 SUBMISSION_DATE Date(10) DATE Submission Date

11 RESUBMISSION_DT Date(10) DATE Resubmission Date

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

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

14 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
Default Value: BUS_UNIT_TBL_EX.DST_CNTRL_ID
Prompt Table: DST_CNTRL_TBL

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

16 TXN_LOCATION Character(5) VARCHAR2(5) NOT NULL Expense Location

17 TRAVEL_FROM Character(5) VARCHAR2(5) NOT NULL Used to indicate the starting point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_TO field to track the cost of flights to and from various locals.

18 TEMPLATE Character(8) VARCHAR2(8) NOT NULL Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash advances, expense sheets and travel authorizations.

19 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

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

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

22 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

23 DATE_FROM Date(10) DATE Date From

24 DATE_TO Date(10) DATE Date To

25 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
Default Value: N

26 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
Y/N Table Edit

27 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator

28 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime

29 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic

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

31 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

32 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
Default Value: N

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

34 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID

35 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

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

37 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.
Y/N Table Edit
Default Value: N

38 COMMENTS Long Character CLOB Comment

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

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

41 PREF_MRCH_NOT_USED Character(1) VARCHAR2(1) NOT NULL Non-Preferred Merchant

42 OUT_OF_POLICY Character(1) VARCHAR2(1) NOT NULL Authorized Amount Exceeded

43 MULT_PER_DIEM Character(1) VARCHAR2(1) NOT NULL Multip Per Diem Exist Per Day

44 RISK_EXISTS_FLG Character(1) VARCHAR2(1) NOT NULL Risk Exists
Y/N Table Edit
Default Value: N

45 ROLLOVER_STATUS Character(1) VARCHAR2(1) NOT NULL Rollover Status
A=All
C=Rollover Process Completed
N=Never Processed
P=Rollover in Progress

#	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	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	EX_ORIGIN	Character(1)	VARCHAR2(1) NOT NULL	Origin of Entry (Expenses) A=Asset Lifecycle Management H=Mobile Hand Held Device M=Mobile Time and Expense N=NUI P=Primavera P6 W=Web
5	USER_CANCEL_PB	Character(1)	VARCHAR2(1) NOT NULL	User Cancel Request A=Active C=Closed Out D=Mark for Delete H=Hold from Budget Checking I=Admin Cancel U=User Cancel
6	REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Reference ID Prompt Table: EX_REFERENCE
7	APPROVAL_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Approval Level A=Approver Only B=Pre- and Post-Pay Audit E=Approver & Pre-Pay Auditor I=Approve, Pre- & Post-Pay Audit N=None S=Approver & Post-Pay Auditor T=Auditor Only - Post-Payment U=Auditor Only - Pre-Payment Default Value: A
8	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %date
9	APPROVAL_DT	Date(10)	DATE	Date of Approval
10	SUBMISSION_DATE	Date(10)	DATE	Submission Date
11	RESUBMISSION_DT	Date(10)	DATE	Resubmission Date
12	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.
13	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
14	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Default Value: BUS_UNIT_TBL_EX.DST_CNTRL_ID Prompt Table: DST_CNTRL_TBL
15	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.
16	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location
17	TRAVEL_FROM	Character(5)	VARCHAR2(5) NOT NULL	Used to indicate the starting point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_TO field to track the cost of flights to and from various locals.
18	TEMPLATE	Character(8)	VARCHAR2(8) NOT NULL	Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash advances, expense sheets and travel authorizations.
19	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
20	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
21	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL
22	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
23	DATE_FROM	Date(10)	DATE	Date From
24	DATE_TO	Date(10)	DATE	Date To
25	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid Default Value: N
26	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes Y/N Table Edit
27	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
28	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
29	KK_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Amount Type 0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic
30	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
31	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
32	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least Default Value: N
33	BUSINESS_PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Business Purpose Prompt Table: EX_PURPOSE_TBL
34	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID
35	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
36	PROJ_MGR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Project Manager Review
37	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. Y/N Table Edit Default Value: N
38	COMMENTS	Long Character	CLOB	Comment
39	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
40	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
41	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant
42	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded
43	MULT_PER_DIEM	Character(1)	VARCHAR2(1) NOT NULL	Multip Per Diem Exist Per Day
44	RISK_EXISTS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Risk Exists Y/N Table Edit Default Value: N
45	ROLLOVER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Rollover Status A=All C=Rollover Process Completed N=Never Processed P=Rollover in Progress