TL_RPTD_THRD_VW

(SQL View)
 Index Back

Reported time Fluid approvals

Time and Labor Reported time Fluid approvals. Application record for pupulating the Line Grid

SELECT A.EMPLID ,A.EMPL_RCD ,A.EOAWDEFN_ID ,A.EOAWPRCS_ID ,A.EOAWPARENT_THREAD ,A.TRANSACTIONID ,A.PUNCH_TYPE ,A.DUR ,%Coalesce(%TrimSubstr(B.TRC,1,5) , 'Z!X!Z') ,A.EOAWTHREAD_ID ,A.EOAWTHREAD_STATUS ,B.TL_QUANTITY ,B.TL_WAIVE_MEAL FROM PS_TL_APP_RPTD_XRF A ,PS_TL_RPTD_TIME B WHERE A.EMPLID=B.EMPLID AND A.EMPL_RCD=B.EMPL_RCD AND A.DUR=B.DUR AND A.SEQ_NBR=B.SEQ_NBR AND A.EOAWPARENT_THREAD <> A.EOAWTHREAD_ID AND A.TRANSACTIONID = ( SELECT MAX(TRANSACTIONID) FROM PS_TL_APP_RPTD_XRF SUB WHERE SUB.EMPLID=A.EMPLID AND SUB.EMPL_RCD=A.EMPL_RCD AND SUB.DUR=A.DUR AND SUB.SEQ_NBR=A.SEQ_NBR AND SUB.PUNCH_TYPE=A.PUNCH_TYPE) AND A.EOAWTHREAD_ID = ( SELECT MAX(EOAWTHREAD_ID) FROM PS_TL_APP_RPTD_XRF SUB WHERE SUB.EMPLID=A.EMPLID AND SUB.EMPL_RCD=A.EMPL_RCD AND SUB.DUR=A.DUR AND SUB.SEQ_NBR=A.SEQ_NBR AND SUB.PUNCH_TYPE=A.PUNCH_TYPE AND SUB.TRANSACTIONID = A.TRANSACTIONID) UNION ALL SELECT A.EMPLID ,A.EMPL_RCD ,A.EOAWDEFN_ID ,A.EOAWPRCS_ID ,A.EOAWPARENT_THREAD ,A.TRANSACTIONID ,A.PUNCH_TYPE ,A.DUR , 'Z!X!Z' ,A.EOAWTHREAD_ID ,A.EOAWTHREAD_STATUS ,0 ,'' FROM PS_TL_APP_RPTD_XRF A ,PS_TL_APP_RPT_LINE B WHERE A.EMPLID=B.EMPLID AND A.EMPL_RCD=B.EMPL_RCD AND A.DUR=B.DUR AND A.SEQ_NBR=B.SEQ_NBR AND A.EOAWPARENT_THREAD <> A.EOAWTHREAD_ID AND A.TRANSACTIONID = ( SELECT MAX(TRANSACTIONID) FROM PS_TL_APP_RPTD_XRF SUB WHERE SUB.EMPLID=A.EMPLID AND SUB.EMPL_RCD=A.EMPL_RCD AND SUB.DUR=A.DUR AND SUB.SEQ_NBR=A.SEQ_NBR AND SUB.PUNCH_TYPE=A.PUNCH_TYPE) AND A.EOAWTHREAD_ID = ( SELECT MAX(EOAWTHREAD_ID) FROM PS_TL_APP_RPTD_XRF SUB WHERE SUB.EMPLID=A.EMPLID AND SUB.EMPL_RCD=A.EMPL_RCD AND SUB.DUR=A.DUR AND SUB.SEQ_NBR=A.SEQ_NBR AND SUB.PUNCH_TYPE=A.PUNCH_TYPE AND SUB.TRANSACTIONID = A.TRANSACTIONID) AND B.PUNCH_TYPE='X'

# 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 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
4 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
5 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
6 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
7 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
8 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
9 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
10 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
11 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
A=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Awaiting Further Approvals
T=Terminated
W=Canceled
X=Suspended/Pending Denial
12 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
13 TL_WAIVE_MEAL Character(1) VARCHAR2(1) NOT NULL Waive off Meal