EX_TA_MOD_VW

(SQL View)
 Index Back

Travel Auth. Approval View

Travel Authorization Approval View

SELECT ' ' , 'TA' , A.TRAVEL_AUTH_ID , A.TRAVEL_AUTH_ID , 'N' , 0 , 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 , ' ' , ' ' , ' ' , 0 , 0 , 0 , A.OUT_OF_POLICY , 'N' , A.BUDGET_HDR_STATUS , 'N' , A.PREF_MRCH_NOT_USED , 'N' , A.RISK_EXISTS_FLG FROM PS_EX_TAUTH_HDR A , PS_PERSONAL_DATA C WHERE A.EMPLID = C.EMPLID AND A.APPR_PROCESS_FLAG = 'N' AND A.TRAVEL_AUTH_STATUS = 'APR' AND A.PROJ_MGR_FLAG = 'N' AND NOT EXISTS ( SELECT 'X' FROM PS_EX_SHEET_HDR D WHERE D.TRAVEL_AUTH_ID = A.TRAVEL_AUTH_ID) AND NOT EXISTS ( SELECT 'X' FROM PS_EX_TA_MGRLST_VW E WHERE E.TRAVEL_AUTH_ID = A.TRAVEL_AUTH_ID )

# 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 OUT_OF_POLICY Character(1) VARCHAR2(1) NOT NULL Authorized Amount Exceeded
24 NO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL No Receipt
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
26 DUPLICATES_EXIST Character(1) VARCHAR2(1) NOT NULL Duplicates Exist
27 PREF_MRCH_NOT_USED Character(1) VARCHAR2(1) NOT NULL Non-Preferred Merchant
28 OUTSIDE_THRESHLD Character(1) VARCHAR2(1) NOT NULL Outside Threshold
29 RISK_EXISTS_FLG Character(1) VARCHAR2(1) NOT NULL Risk Exists