EX_TA_APPR_VW (SQL View)	Index Back
Travel Auth. Approval View Travel Authorization Approval View

EX_TA_APPR_VW

(SQL View)

Travel Auth. Approval View

Travel Authorization Approval View

SELECT DISTINCT B.OPRID , 'TA' , A.TRAVEL_AUTH_ID , A.TRAVEL_AUTH_ID , 'N' , CASE WHEN (B.EOAWTHREAD_ID = B.EOAWPARENT_THREAD) THEN 0 ELSE 1 END , A.TRAVEL_AUTH_NAME , A.EMPLID , C.NAME , A.TRAVEL_AUTH_STATUS , A.CREATION_DT , CASE WHEN (A.RESUBMISSION_DT IS NOT NULL) THEN A.RESUBMISSION_DT ELSE A.SUBMISSION_DATE END , A.TRAVEL_AUTH_STATUS , A.TOTAL_AMT , A.CURRENCY_CD , A.DATE_FROM , B.SETID , B.APPRVR_TYPE , B.APPRVR_DESCR , B.STAGE_ID , 0 , 0 , ' ' , ' ' , ' ' , A.OUT_OF_POLICY , 'N' , A.BUDGET_HDR_STATUS , 'N' , A.PREF_MRCH_NOT_USED , 'N' , A.RISK_EXISTS_FLG , CASE WHEN (A.RESUBMISSION_DT IS NOT NULL) THEN A.RESUBMISSION_DT ELSE A.SUBMISSION_DATE END FROM PS_EX_TAUTH_HDR A , PS_EX_TA_MGRLST_VW B , PS_PERSONAL_DATA C WHERE A.TRAVEL_AUTH_ID = B.TRAVEL_AUTH_ID AND A.EMPLID = C.EMPLID AND A.APPR_PROCESS_FLAG = 'N' AND A.PROCESS_FLAG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.

2 APPR_TRANS_TYPE Character(4) VARCHAR2(4) NOT NULL Approval Transaction Type.
CA=Cash Advance
ER=Expense Report
TA=Travel Authorization
TJ=Time Adjustment
TR=Time Report

3 TRANSACTION_ID Character(10) VARCHAR2(10) NOT NULL Transaction ID

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

5 LINE_SELECT_CB Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit

6 AWLEVEL Number(1,0) SMALLINT NOT NULL Level e.g. Header = 0, Line = 1.
0=Header
1=Line

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

9 NAME Character(50) VARCHAR2(50) NOT NULL Name

10 TRANS_STATUS Character(3) VARCHAR2(3) NOT NULL Status
APR=Approved
APY=Approved for Payment
CLS=Closed
DEN=Denied
HLD=On Hold
PAR=Approvals in Process
PD=Paid
PND=Pending
RCN=Reconciled
STG=Staged
SUB=Submitted for Approval

11 TRANSACTION_DATE Date(10) DATE Transaction Date

12 SUBMISSION_DATE Date(10) DATE Submission Date

13 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

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

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

16 DATE_FROM Date(10) DATE Date From

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

18 APPRVR_TYPE Character(10) VARCHAR2(10) NOT NULL Approver type used to cross reference an AWE process id and stage.

19 APPRVR_DESCR Character(30) VARCHAR2(30) NOT NULL Approver Type Description

20 STAGE_ID Number(15,0) DECIMAL(15) NOT NULL Unique stage identifier

21 DTL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL Total

22 POL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL PolTotal

23 URGENCY Character(1) VARCHAR2(1) NOT NULL Urgency
H=High
L=Low
M=Medium

24 EXCEPTIONS Character(1) VARCHAR2(1) NOT NULL Exceptions

25 PB_RISK Character(1) VARCHAR2(1) NOT NULL Risk

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

27 NO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL No Receipt

28 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

29 DUPLICATES_EXIST Character(1) VARCHAR2(1) NOT NULL Duplicates Exist

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

31 OUTSIDE_THRESHLD Character(1) VARCHAR2(1) NOT NULL Outside Threshold

32 RISK_EXISTS_FLG Character(1) VARCHAR2(1) NOT NULL Risk Exists

33 CREATION_DT Date(10) DATE Creation Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
2	APPR_TRANS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Approval Transaction Type. CA=Cash Advance ER=Expense Report TA=Travel Authorization TJ=Time Adjustment TR=Time Report
3	TRANSACTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction ID
4	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.
5	LINE_SELECT_CB	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit
6	AWLEVEL	Number(1,0)	SMALLINT NOT NULL	Level e.g. Header = 0, Line = 1. 0=Header 1=Line
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
10	TRANS_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Status APR=Approved APY=Approved for Payment CLS=Closed DEN=Denied HLD=On Hold PAR=Approvals in Process PD=Paid PND=Pending RCN=Reconciled STG=Staged SUB=Submitted for Approval
11	TRANSACTION_DATE	Date(10)	DATE	Transaction Date
12	SUBMISSION_DATE	Date(10)	DATE	Submission Date
13	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
14	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	DATE_FROM	Date(10)	DATE	Date From
17	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
18	APPRVR_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Approver type used to cross reference an AWE process id and stage.
19	APPRVR_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Approver Type Description
20	STAGE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Unique stage identifier
21	DTL_TOTAL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total
22	POL_TOTAL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	PolTotal
23	URGENCY	Character(1)	VARCHAR2(1) NOT NULL	Urgency H=High L=Low M=Medium
24	EXCEPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Exceptions
25	PB_RISK	Character(1)	VARCHAR2(1) NOT NULL	Risk
26	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded
27	NO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	No Receipt
28	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
29	DUPLICATES_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Duplicates Exist
30	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant
31	OUTSIDE_THRESHLD	Character(1)	VARCHAR2(1) NOT NULL	Outside Threshold
32	RISK_EXISTS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Risk Exists
33	CREATION_DT	Date(10)	DATE	Creation Date