EX_CA_APPR_VW

(SQL View)
 Index Back

Cash Advance Approval View

Cash Advance Approval View

SELECT DISTINCT B.OPRID , 'CA' , A.ADVANCE_ID , A.ADVANCE_ID , 'N' , CASE WHEN (B.EOAWTHREAD_ID = B.EOAWPARENT_THREAD) THEN 0 ELSE 1 END , A.ADVANCE_NAME , A.EMPLID , C.NAME , A.ADV_STATUS , A.CREATION_DT , CASE WHEN (A.RESUBMISSION_DT IS NOT NULL) THEN A.RESUBMISSION_DT ELSE A.SUBMISSION_DATE END , A.ADV_STATUS , A.TOTAL_AMT , A.CURRENCY_CD , B.SETID , B.APPRVR_TYPE , B.APPRVR_DESCR , B.STAGE_ID , 0 , 0 , ' ' , ' ' , ' ' , 'N' , 'N' , 'V' , 'N' , 'N' , 'N' , A.RISK_EXISTS_FLG FROM PS_EX_ADV_HDR A , PS_EX_CA_MGRLST_VW B , PS_PERSONAL_DATA C WHERE A.ADVANCE_ID = B.ADVANCE_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 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance 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 ADV_STATUS Character(3) VARCHAR2(3) NOT NULL Advance Status
APY=Approved for Payment
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
PD=Paid
PND=Pending
PRO=In Process
PST=Past Due Balance
RAP=Approved
RCN=Reconciled
RRT=Reroute Transaction
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 URGENCY Character(1) VARCHAR2(1) NOT NULL Urgency
H=High
L=Low
M=Medium
23 EXCEPTIONS Character(1) VARCHAR2(1) NOT NULL Exceptions
24 PB_RISK Character(1) VARCHAR2(1) NOT NULL Risk
25 OUT_OF_POLICY Character(1) VARCHAR2(1) NOT NULL Authorized Amount Exceeded
26 NO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL No Receipt
27 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
28 DUPLICATES_EXIST Character(1) VARCHAR2(1) NOT NULL Duplicates Exist
29 PREF_MRCH_NOT_USED Character(1) VARCHAR2(1) NOT NULL Non-Preferred Merchant
30 OUTSIDE_THRESHLD Character(1) VARCHAR2(1) NOT NULL Outside Threshold
31 RISK_EXISTS_FLG Character(1) VARCHAR2(1) NOT NULL Risk Exists