EX_ER_ERROR_VW

(SQL View)
 Index Back

Expense Report Appr Error View

Expense Report Approval Errors View

SELECT DISTINCT B.OPRID , 'ER' , A.SHEET_ID , A.SHEET_ID , 'N' , CASE WHEN (B.EOAWTHREAD_ID = B.EOAWPARENT_THREAD) THEN 0 ELSE 1 END , A.SHEET_NAME , A.EMPLID , C.NAME , A.SHEET_STATUS , A.CREATION_DT , CASE WHEN (A.RESUBMISSION_DT IS NOT NULL) THEN A.RESUBMISSION_DT ELSE A.SUBMISSION_DATE END , A.SHEET_STATUS , A.TOTAL_AMT , A.CURRENCY_CD , B.SETID , B.APPRVR_TYPE , B.APPRVR_DESCR , B.STAGE_ID , 0 , 0 , D.SOURCE_COMPONENT , D.MESSAGE_TEXT_254 , A.OUT_OF_POLICY , A.NO_RECEIPT_FLG , A.BUDGET_HDR_STATUS , A.DUPLICATES_EXIST , A.PREF_MRCH_NOT_USED , 'N' , A.RISK_EXISTS_FLG , A.OLDER_TRANSACTION FROM PS_EX_SHEET_HDR A , PS_EX_ER_MGRLST_VW B , PS_PERSONAL_DATA C , PS_EX_SUM_APPR_ERR D WHERE A.SHEET_ID = B.SHEET_ID AND B.SHEET_ID = D.SHEET_ID AND D.APPR_TRANS_TYPE = 'ER' AND A.EMPLID = C.EMPLID AND A.APPR_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 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
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 SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Report Status
APY=Approved for Payment
APZ=Approved For Zero Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=On Hold, with Approver
HDU=On Hold, with Auditor
HLD=On Hold
MFS=Marked for Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
17 APPRVR_TYPE Character(10) VARCHAR2(10) NOT NULL Approver type used to cross reference an AWE process id and stage.
18 APPRVR_DESCR Character(30) VARCHAR2(30) NOT NULL Approver Type Description
19 STAGE_ID Number(15,0) DECIMAL(15) NOT NULL Unique stage identifier
20 DTL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL Total
21 POL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL PolTotal
22 SOURCE_COMPONENT Character(3) VARCHAR2(3) NOT NULL Source Component
MOD=Modify Approved Transactions
SUM=Summary Approvals
23 MESSAGE_TEXT_254 Character(254) VARCHAR2(254) NOT NULL Message Text
24 OUT_OF_POLICY Character(1) VARCHAR2(1) NOT NULL Authorized Amount Exceeded
25 NO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL No Receipt
26 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
27 DUPLICATES_EXIST Character(1) VARCHAR2(1) NOT NULL Duplicates Exist
28 PREF_MRCH_NOT_USED Character(1) VARCHAR2(1) NOT NULL Non-Preferred Merchant
29 OUTSIDE_THRESHLD Character(1) VARCHAR2(1) NOT NULL Outside Threshold
30 RISK_EXISTS_FLG Character(1) VARCHAR2(1) NOT NULL Risk Exists
31 OLDER_TRANSACTION Character(1) VARCHAR2(1) NOT NULL Older Transactions