TL_TR_ADM_SRCH

(SQL View)
 Index Back

Time Empl Weekly Summary View

T&L Weekly Reported Time Search View for Manager Role.

SELECT B.EMPLID ,B.EMPL_RCD ,C.THE_DATE ,C.THE_DATE ,C.THE_DATE ,B.WORKGROUP ,B.TASKGROUP ,B.ELP_TR_TMPLT_ID ,B.PCH_TR_TMPLT_ID ,B.TASK_PROFILE_ID FROM PS_TL_EMPL_DATA B , PS_TL_DATES_TBL C WHERE B.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_TL_EMPL_DATA AA WHERE AA.EMPLID = B.EMPLID AND AA.EMPL_RCD = B.EMPL_RCD AND AA.EFFDT <= C.THE_DATE) AND C.THE_DATE >= ( SELECT MIN(AAA.EFFDT) FROM PS_TL_EMPL_DATA AAA WHERE AAA.EMPLID = B.EMPLID AND AAA.EMPL_RCD = B.EMPL_RCD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: TL_ADM_NAME_VW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

Prompt Table: TL_TR_ADMRCD_VW

3 THE_DATE Date(10) DATE NOT NULL Date

Default Value: %Date

4 START_DT Date(10) DATE Start Date
5 END_DT Date(10) DATE end date
6 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup

Default Value: TL_EMPL_DATA.WORKGROUP

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

Default Value: TL_EMPL_DATA.TASKGROUP

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