LM_MGR_OVRD_VW

(SQL View)
 Index Back

Manager Orevdue View

Manager Orevdue View

SELECT B.LM_MANAGER_ID , D.LM_NAME_DISPLAY , C.LM_CS_LONG_NM , B.LM_NUM_DAYS FROM PS_LM_MAND_NOT1_VW B , PS_LM_PERSON_NAME D , PS_LM_CI_VW2 C , PS_LM_ENRLMT A WHERE B.LM_PERSON_ID = D.LM_PERSON_ID AND A.LM_ENRLMT_ID = B.LM_ENRLMT_ID 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_NUM_DAYS Number(3,0) SMALLINT NOT NULL Number of days