TL_TR_WEEK_SRCH

(SQL View)
 Index Back

Time Empl Weekly Summary View

T&L Weekly Reported Time Search View

SELECT A.OPRID ,A.EMPLID ,A.EMPL_RCD ,C.THE_DATE ,C.THE_DATE ,C.THE_DATE ,P.NAME ,A.WORKGROUP ,A.TASKGROUP ,A.ELP_TR_TMPLT_ID ,A.PCH_TR_TMPLT_ID ,A.TASK_PROFILE_ID FROM PS_TL_TR_ESS_VW A , PS_TL_DATES_TBL C , PS_PERSON_NAME P WHERE A.EMPLID = P.EMPLID AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_TL_TR_ESS_VW AA WHERE AA.EMPLID = A.EMPLID AND AA.EMPL_RCD = A.EMPL_RCD AND AA.EFFDT <= C.THE_DATE) AND C.THE_DATE >= ( SELECT MIN(AAA.EFFDT) FROM PS_TL_TR_ESS_VW AAA WHERE AAA.EMPLID = A.EMPLID AND AAA.EMPL_RCD = A.EMPL_RCD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

Prompt Table: TL_TR_ESSRCD_VW

4 THE_DATE Date(10) DATE NOT NULL Date

Default Value: %Date

5 START_DT Date(10) DATE Start Date
6 END_DT Date(10) DATE end date
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup

Default Value: TL_EMPL_DATA.WORKGROUP

9 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

Default Value: TL_EMPL_DATA.TASKGROUP

10 ELP_TR_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Elapsed Reporting Template
11 PCH_TR_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Punch Reporting Template
12 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID