EX_TJ_MOD_VW

(SQL View)
 Index Back

Time Report Approval View

Time Report Approval View

SELECT ' ' , 'TJ' , A.TIME_SHEET_ID , A.TIME_SHEET_ID , A.VERSION_NUM , 'N' , 0 , 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 , ' ' , ' ' , ' ' , 0 , %DateOut(A.PERIOD_END_DT) , A.DTL_TOTAL + A.POL_TOTAL , 'MHR' , 'N' , 'N' , 'V' , 'N' , 'N' , A.OUT_OF_POLICY , A.RISK_EXISTS_FLG FROM PS_EX_TIME_HDR A , PS_PERSONAL_DATA C WHERE A.EMPLID = C.EMPLID AND A.APPR_PROCESS_FLAG = 'N' AND A.POST_STATUS_EX = 'N' AND A.TIME_SHEET_STATUS = 'APR' AND A.PROJ_MGR_FLAG = 'N' AND A.VERSION_NUM > 1 AND NOT EXISTS ( SELECT 'X' FROM PS_EX_TR_MGRLST_VW E WHERE E.TIME_SHEET_ID = A.TIME_SHEET_ID AND E.VERSION_NUM = A.VERSION_NUM )

# 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 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