TL_SRCH_DEPSECR

(SQL View)
 Index Back

Time and Labor Security

Time and Labor Department Security

SELECT A.ROWSECCLASS , C.EMPLID , C.EMPL_RCD , G.DUR , G.SEQ_NBR FROM PSOPRDEFN A , PS_SJT_CLASS_ALL B , PS_SJT_PERSON C , PS_SJT_OPR_CLS D ,PS_TL_RPTD_TIME G WHERE C.APPT_TYPE <> '1' AND B.SCRTY_SET_CD = 'PPLJOB' AND B.SCRTY_TYPE_CD = C.SCRTY_TYPE_CD AND B.SCRTY_KEY1 = C.SCRTY_KEY1 AND B.SCRTY_KEY2 = C.SCRTY_KEY2 AND B.SCRTY_KEY3 = C.SCRTY_KEY3 AND D.OPRID = A.OPRID AND D.CLASSID = B.CLASSID AND (( B.TREE = 'Y' AND D.CLASSID = A.ROWSECCLASS AND D.SEC_RSC_FLG IN ('1','3')) OR B.TREE = 'N') AND NOT EXISTS ( SELECT F.TL_GROUP_ID FROM PS_TL_GRP_SECURITY F WHERE F.ROWSECCLASS = A.ROWSECCLASS) AND A.ROWSECCLASS<>' ' AND G.EMPLID = C.EMPLID AND G.EMPL_RCD = C.EMPL_RCD AND G.DUR BETWEEN %DateAdd(%CurrentDateIn,-91) AND %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number