EX_TJ_ERROR_VW

(SQL View)
 Index Back

Time Adjustment Appr Error Vw

Time Adjustment Approval Errors View

SELECT DISTINCT B.OPRID , 'TJ' , A.TIME_SHEET_ID , A.TIME_SHEET_ID , A.VERSION_NUM , 'N' , CASE WHEN (B.EOAWTHREAD_ID = B.EOAWPARENT_THREAD) THEN 0 ELSE 1 END , A.PERIOD_END_DT , A.EMPLID , C.NAME , A.TIME_SHEET_STATUS , A.CREATION_DT , CASE WHEN (A.RESUBMISSION_DT IS NOT NULL) THEN A.RESUBMISSION_DT ELSE A.SUBMISSION_DATE END , A.TIME_SHEET_STATUS , A.DTL_TOTAL , A.POL_TOTAL , B.SETID , B.APPRVR_TYPE , B.APPRVR_DESCR , B.STAGE_ID , %DateOut(A.PERIOD_END_DT) , A.DTL_TOTAL + A.POL_TOTAL , 'MHR' , D.SOURCE_COMPONENT , D.MESSAGE_TEXT_254 , 'N' , 'N' , 'V' , 'N' , 'N' , A.OUT_OF_POLICY , A.RISK_EXISTS_FLG FROM PS_EX_TIME_HDR A , PS_EX_TR_MGRLST_VW B , PS_PERSONAL_DATA C , PS_EX_SUM_APPR_ERR D WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND B.TIME_SHEET_ID = D.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND B.VERSION_NUM = D.VERSION_NUM AND D.APPR_TRANS_TYPE = 'TJ' AND A.VERSION_NUM > 1 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 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
5 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
6 LINE_SELECT_CB Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

7 AWLEVEL Number(1,0) SMALLINT NOT NULL Level e.g. Header = 0, Line = 1.
0=Header
1=Line
8 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 NAME Character(50) VARCHAR2(50) NOT NULL Name
11 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
12 TRANSACTION_DATE Date(10) DATE Transaction Date
13 SUBMISSION_DATE Date(10) DATE Submission Date
14 TIME_SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Time Sheet Status
ADJ=Adjusted
APR=Approved
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Project Manager
HDA=Hold by Approver
HDU=Hold by Project Manager
HLD=Hold
MFS=Marked for Submit
PAR=Approvals in Process
PND=Pending
PRO=In Process
SFA=Submission in Process
SUB=Submitted for Approval
XML=Submitted, Pending Validation
15 DTL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL Total
16 POL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL PolTotal
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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
22 TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Amount
23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
24 SOURCE_COMPONENT Character(3) VARCHAR2(3) NOT NULL Source Component
MOD=Modify Approved Transactions
SUM=Summary Approvals
25 MESSAGE_TEXT_254 Character(254) VARCHAR2(254) NOT NULL Message Text
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