TL_RPT_LNFL2_VW

(SQL View)
 Index Back

Reported time Fluid approvals

Time and Labor Reported time Fluid approvals Lines Grid data record

SELECT RT.EMPLID ,RT.EMPL_RCD ,X.EOAWDEFN_ID ,X.PUNCH_TYPE ,X.TRANSACTIONID ,RT.DUR ,%Coalesce(%TrimSubstr(RT.TRC,1,5) , 'Z!X!Z') ,'PS_CROSSOVER_M_FL' ,'N' FROM PS_TL_RPTD_TIME RT ,PS_TL_APP_RPTD_XRF X WHERE X.EMPLID=RT.EMPLID AND X.EMPL_RCD=RT.EMPL_RCD AND X.DUR=RT.DUR AND X.SEQ_NBR=RT.SEQ_NBR AND X.EOAWPARENT_THREAD <> X.EOAWTHREAD_ID AND RT.DUR IS NOT NULL AND X.TRANSACTIONID = ( SELECT MAX(TRANSACTIONID) FROM PS_TL_APP_RPTD_XRF SUB WHERE SUB.EMPLID=X.EMPLID AND SUB.EMPL_RCD=X.EMPL_RCD AND SUB.DUR=X.DUR AND SUB.SEQ_NBR=X.SEQ_NBR AND SUB.PUNCH_TYPE=X.PUNCH_TYPE) AND X.EOAWTHREAD_ID = ( SELECT MAX(EOAWTHREAD_ID) FROM PS_TL_APP_RPTD_XRF SUB WHERE SUB.EMPLID=X.EMPLID AND SUB.EMPL_RCD=X.EMPL_RCD AND SUB.DUR=X.DUR AND SUB.SEQ_NBR=X.SEQ_NBR AND SUB.PUNCH_TYPE=X.PUNCH_TYPE AND SUB.TRANSACTIONID = X.TRANSACTIONID) GROUP BY RT.EMPLID ,RT.EMPL_RCD ,X.EOAWDEFN_ID ,X.PUNCH_TYPE ,X.TRANSACTIONID ,RT.DUR,RT.TRC

# 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 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
5 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
6 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
7 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
8 EOPCIMAGE_ID Character(30) VARCHAR2(30) NOT NULL Image
9 EOPCUSE_MAP_DIR Character(1) VARCHAR2(1) NOT NULL Use MAP Image Directory