TE_TAUTH_VW2 (SQL View)	Index Back
Travel Auth for Budget Check Travel Auth List for Budget Checking

TE_TAUTH_VW2

(SQL View)

Travel Auth for Budget Check

Travel Auth List for Budget Checking

SELECT A.BUSINESS_UNIT_GL , A.TRAVEL_AUTH_ID , A.EMPLID , A.EMPL_RCD , A.DATE_FROM , A.DATE_TO , A.CREATION_DT , A.TRAVEL_AUTH_NAME , A.TOTAL_AMT , A.CURRENCY_CD , A.REFERENCE_ID , A.COPY_TRAVEL_AUTH , A.BUDGET_HDR_STATUS , A.TRAVEL_AUTH_STATUS , A.USER_CANCEL_PB , A.ROLLOVER_STATUS FROM PS_EX_TAUTH_HDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

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

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

5 DATE_FROM Date(10) DATE Date From

6 DATE_TO Date(10) DATE Date To

7 CREATION_DT Date(10) DATE Creation Date

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

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

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

11 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID

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

13 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

14 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

15 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

16 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	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	DATE_FROM	Date(10)	DATE	Date From
6	DATE_TO	Date(10)	DATE	Date To
7	CREATION_DT	Date(10)	DATE	Creation Date
8	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.
9	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Reference ID
12	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.
13	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
14	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
15	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
16	ROLLOVER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Rollover Status A=All C=Rollover Process Completed N=Never Processed P=Rollover in Progress