LM_MGR_NOTIF_VW

(SQL View)
 Index Back

Manager Notif View

Manager Notif View

SELECT DISTINCT B.LM_MANAGER_ID , D.LM_NAME_DISPLAY , C.LM_CS_LONG_NM , B.LM_DUE_DATE FROM PS_LM_MGR_NOTF_TBL B , PS_LM_PERSON_NAME D , PS_LM_CI_VW2 C , PS_LM_ENRLMT_VW E WHERE B.LM_PERSON_ID = D.LM_PERSON_ID AND B.LM_ENRLMT_ID = E.LM_ENRLMT_ID AND E.LM_STTS IN ('ENRL', 'INPO') AND B.LM_CI_ID = C.LM_CI_ID AND D.LM_DISPLAY_FLAG = 'Y' AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND ((D.LM_NAME_TYPE = 'PRF') OR (D.LM_NAME_TYPE = 'PRI' AND NOT EXISTS ( SELECT LM_NAME_TYPE FROM PS_LM_PERSON_NAME WHERE LM_PERSON_ID = D.LM_PERSON_ID AND LM_NAME_TYPE = 'PRF' AND %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
2 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
3 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
4 LM_DUE_DATE Date(10) DATE Due Date