TL_UNPROC_PY_VW

(SQL View)
Index Back

Unporcessed Payable TIme


SELECT EMPLID , EMPL_RCD , DUR , PAYABLE_STATUS , TRC , TL_QUANTITY , PAY_SYSTEM ,TL_PYBL_REASON_CD FROM PS_TL_PAYABLE_TIME WHERE PAYABLE_STATUS IN ('NA','AP', 'ES', 'RP','SP','TP') AND RT_SOURCE <> 'AM'

# 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 Rcd Nbr
3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
4 PAYABLE_STATUS Character(2) VARCHAR2(2) NOT NULL Payable Status
AP=Approved
CL=Closed
DL=Diluted
ES=Estimated
IG=Ignore
NA=Needs Approval
NP=No Pay
OE=Online Estimate
PD=Distributed
RP=Rejected by Payroll
RV=Reversed Check
SP=Sent to Payroll
TP=Taken by Payroll
5 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
6 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
7 PAY_SYSTEM Character(4) VARCHAR2(4) NOT NULL Payroll System
GP=Global Payroll
NA=North American 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