EX_ER_EE_HST_VW

(SQL View)
 Index Back

Exp. Report Employee History

Expense Report Employee History View

SELECT DISTINCT ' ' , 'ER' , A.SHEET_ID , A.SHEET_ID , 'N' , 0 , 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 , ' ' , ' ' , ' ' , 0 , 0 , 0 , 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_PERSONAL_DATA C WHERE A.EMPLID = C.EMPLID AND A.SHEET_STATUS <> 'PND'

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