TL_PC_RPTSUM_VW

(SQL View)
 Index Back

Reported time Fluid Approvals

Time and Labor Reported time Fluid approvals Summary Section data

SELECT RT.EMPLID ,RT.EMPL_RCD ,X.EOAWDEFN_ID ,X.TRANSACTIONID ,X.PUNCH_TYPE ,B.NAME_DISPLAY ,MIN(X.DUR) , MAX(X.DUR) ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' FROM PS_TL_RPTD_TIME RT ,PS_TL_APP_RPT_LINE X ,PS_NAMES B 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 RT.DUR IS NOT NULL AND X.EMPLID=B.EMPLID AND B.NAME_TYPE = 'PRI' AND B.EFFDT = ( SELECT MAX (NM1.EFFDT) FROM PS_NAMES NM1 WHERE NM1.EMPLID = B.EMPLID AND NM1.NAME_TYPE = B.NAME_TYPE AND NM1.EFFDT <= %CurrentDateIn) GROUP BY RT.EMPLID ,RT.EMPL_RCD ,X.EOAWDEFN_ID ,X.TRANSACTIONID,X.PUNCH_TYPE,B.NAME_DISPLAY UNION SELECT X.EMPLID ,X.EMPL_RCD ,X.EOAWDEFN_ID ,X.TRANSACTIONID ,X.PUNCH_TYPE ,B.NAME_DISPLAY ,X.BGN_DT ,X.END_DT ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' FROM PS_TL_APP_RPT_LINE X ,PS_NAMES B WHERE X.EMPLID=B.EMPLID AND X.DUR IS NOT NULL AND X.PUNCH_TYPE='X' AND B.NAME_TYPE = 'PRI' AND B.EFFDT = ( SELECT MAX (NM1.EFFDT) FROM PS_NAMES NM1 WHERE NM1.EMPLID = B.EMPLID AND NM1.NAME_TYPE = B.NAME_TYPE AND NM1.EFFDT <= %CurrentDateIn)

# 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 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
5 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
7 FROM_DATE Date(10) DATE From Date
8 TO_DATE Date(10) DATE Latest Date to be sent to PYR
9 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
10 DESCR40_1 Character(40) VARCHAR2(40) NOT NULL Field used to hold a character field of up to length 40
11 DESCR40_2 Character(40) VARCHAR2(40) NOT NULL Field used to hold a character field of up to length 40
12 DESCR40_3 Character(40) VARCHAR2(40) NOT NULL Field used to hold a character field of up to length 40
13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
14 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
15 DESCR10 Character(10) VARCHAR2(10) NOT NULL Description field of length 10