LM_MAND_FL_VW

(SQL View)
Index Back

Mandatory Find Learning View

Mandatory Find Learning View

SELECT A.LM_CI_ID , A.LM_PERSON_ID , A.LM_ACT_ID FROM PS_LM_PERS_MAND_VW A WHERE EXISTS ( SELECT 'X' FROM PS_LM_ACT_SEC B , PS_LM_PERS_LGRP_VW C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND B.LM_LRNR_GROUP_ID = C.LM_LRNR_GROUP_ID AND A.LM_PERSON_ID = C.LM_PERSON_ID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
3 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID