TL_UNPROC_PY_VW

(SQL View)
Index Back

Unprocessed Payable Time

View used to bring in unprocessed payable time. Blank columns are being formatted upon upload.

SELECT P.EMPLID , P.EMPL_RCD , P.DUR , P.TRC , T.TRC_TYPE , P.TL_QUANTITY , P.PAYABLE_STATUS , P.TL_PYBL_REASON_CD ,' ' ,' ' ,' ' FROM PS_TL_PAYABLE_TIME P , PS_TL_TRC_TBL T WHERE P.PAYABLE_STATUS IN ('NA','AP', 'ES', 'RP','SP','TP','PB') AND P.RT_SOURCE <> 'AM' AND P.TRC = T.TRC AND T.EFFDT = ( SELECT MAX(S.EFFDT) FROM PS_TL_TRC_TBL S WHERE S.TRC=T.TRC AND S.EFFDT <= P.DUR)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
4 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

Prompt Table: TL_TRC_TBL

5 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL This defines TRC Type of Hours,Amounts ,Units
A=Amount
H=Hours
U=Units
6 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
7 PAYABLE_STATUS Character(2) VARCHAR2(2) NOT NULL Payable Status
AP=Approved
CL=Closed
DL=Diluted
DN=Denied
ES=Estimated
IG=Ignore
NA=Needs Approval
NP=No Pay
OE=Online Estimate
PB=Pushed Back
PD=Distributed
RP=Rejected by Payroll
RV=Reversed Check
SP=Sent to Payroll
TP=Taken by Payroll
8 TL_PYBL_REASON_CD Character(3) VARCHAR2(3) NOT NULL Payable Reason Code
CAN=Cancelled
CRV=Reversed
MRJ=Manual Reject
NDS=Not Distributed
NOP=Not OK to Pay
NSP=Not Sent to Payroll
NUS=Not Used
PNP=Not Processed in Payroll
PPS=Prior Period Adjustment
RAJ=Record Adjustment
9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
10 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
11 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description