TL_DU_PT_OFF_VW

(SQL View)
 Index Back

Invalid Offsets

View to derermine invalid Offsets

SELECT A.EMPLID , A.EMPL_RCD , A.DUR , A.SEQ_NBR , A.TL_QUANTITY , A.PAYABLE_STATUS , A.RECORD_ONLY_ADJ , A.ORIG_SEQ_NBR FROM PS_TL_PAYABLE_TIME A WHERE EXISTS ( SELECT 'X' FROM PS_TL_PAYABLE_TIME C WHERE A.EMPLID =C.EMPLID AND A.EMPL_RCD =C.EMPL_RCD AND A.DUR=C.DUR AND A.ORIG_SEQ_NBR=C.SEQ_NBR AND C.ORIG_SEQ_NBR <> 0 AND C.RECORD_ONLY_ADJ = 'N' AND C.PAYABLE_STATUS NOT IN ('ES','NA') AND C.TL_QUANTITY > 0 AND NOT EXISTS ( SELECT 'X' FROM PS_TL_PAYABLE_TIME A2 WHERE A2.EMPLID =C.EMPLID AND A2.EMPL_RCD =C.EMPL_RCD AND A2.DUR=C.DUR AND A2.ORIG_SEQ_NBR=C.SEQ_NBR AND A2.TL_QUANTITY < 0) ) OR EXISTS ( SELECT 'X' FROM PS_TL_PAYABLE_TIME C1 WHERE A.EMPLID =C1.EMPLID AND A.EMPL_RCD =C1.EMPL_RCD AND A.DUR=C1.DUR AND A.ORIG_SEQ_NBR=C1.SEQ_NBR AND C1.ORIG_SEQ_NBR =0 AND C1.RECORD_ONLY_ADJ = 'N' AND C1.PAYABLE_STATUS NOT IN ('ES','NA') AND EXISTS ( SELECT 'X' FROM PS_TL_PAYABLE_TIME A1 WHERE A1.EMPLID=C1.EMPLID AND A1.EMPL_RCD =C1.EMPL_RCD AND A1.DUR=C1.DUR AND A1.TL_QUANTITY < 0 AND A1.ORIG_SEQ_NBR=C1.SEQ_NBR) )

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
6 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
7 RECORD_ONLY_ADJ Character(1) VARCHAR2(1) NOT NULL Record Only Adjustment
8 ORIG_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Original Sequence Number