LM_ACT_CD2_VW3

(SQL View)
 Index Back

Activity Search

Activity Search View

SELECT DISTINCT Y.LM_PERSON_ID , X.LM_ACT_CD , X.LM_ACT_ID , X.LM_ACT_STATUS , X.LM_START_DT FROM PS_LM_ACT X , PS_LM_GROUP_PERSON Y , PS_LM_ACT_SEC Z WHERE X.LM_ACT_ID = Z.LM_ACT_ID AND ((Y.LM_LRNR_GROUP_ID = Z.LM_LRNR_GROUP_ID) OR (EXISTS( SELECT A.LM_LRNR_GROUP_ID FROM PS_LM_GROUPS_CRIT A , PS_LM_GROUP_PERSON B WHERE A.LM_FIELDNAME = 'LM_LRNR_GROUP_ID' AND B.LM_PERSON_ID = Y.LM_PERSON_ID AND A.LM_CRITERIA_VALUE = %NumToChar(B.LM_LRNR_GROUP_ID) AND A.LM_LRNR_GROUP_ID=Z.LM_LRNR_GROUP_ID GROUP BY A.LM_LRNR_GROUP_ID HAVING COUNT(*) = ( SELECT COUNT(*) FROM PS_LM_GROUPS_CRIT C WHERE C.LM_LRNR_GROUP_ID = A.LM_LRNR_GROUP_ID) ) ) ) AND X.LM_ACT_STATUS IN ('1', '3', '4', '5')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
2 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
3 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
4 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
1=Active
2=Inactive
3=Closed
4=Pending
5=Concluded
5 LM_START_DT Date(10) DATE Start Date