TL_SRCH_SECU_VW

(SQL View)
 Index Back

Time and Labor Security for GS

Time and Labor Security Record for Global search

SELECT B.ROWSECCLASS , A.EMPLID , A.EMPL_RCD FROM PS_TL_GROUP_DTL A , PS_TL_GRP_SECURITY B , PS_TL_EMPL_DATA G WHERE A.TL_GROUP_ID = B.TL_GROUP_ID AND G.EMPLID = A.EMPLID AND G.EMPL_RCD = A.EMPL_RCD AND %EffdtCheck(TL_EMPL_DATA, G, %CurrentDateIn) UNION SELECT B.CLASSID , C.EMPLID , C.EMPL_RCD FROM PS_SJT_CLASS_ALL B , PS_SJT_PERSON C , PS_TL_EMPL_DATA 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 G.EMPLID = C.EMPLID AND G.EMPL_RCD = C.EMPL_RCD AND %EffdtCheck(TL_EMPL_DATA, G, %CurrentDateIn) UNION SELECT DISTINCT 'E:'%Concat G.EMPLID , G.EMPLID , G.EMPL_RCD FROM PS_TL_EMPL_DATA G WHERE %EffdtCheck(TL_EMPL_DATA, G, %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