LM_SRCH_DTTMV8 (SQL View)	Index Back
Last update for Catg and Act Last update datestamp for Catalog Items and Activities Use this view for multi LG courses which do not have classes for any one of the LGs associated with teh course

LM_SRCH_DTTMV8

(SQL View)

Last update for Catg and Act

Last update datestamp for Catalog Items and Activities Use this view for multi LG courses which do not have classes for any one of the LGs associated with teh course

SELECT 0 , A.LM_CI_ID , B.LM_LRNR_GROUP_ID FROM PS_LM_CI_TBL A , PS_LM_CI_SEC_TBL B WHERE A.LM_CI_ID = B.LM_CI_ID AND A.LM_CI_STATUS = '10' AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND B.EFFDT = A.EFFDT AND NOT EXISTS ( SELECT 'X' FROM PS_LM_ACT_SEC A2 , PS_LM_ACT A3 WHERE A3.LM_CI_ID = A.LM_CI_ID AND A3.LM_ACT_STATUS IN ('1','3','5') AND A2.LM_ACT_ID = A3.LM_ACT_ID AND A2.LM_LRNR_GROUP_ID = B.LM_LRNR_GROUP_ID ) AND EXISTS ( SELECT 'X' FROM PS_LM_ACT A1 WHERE A1.LM_CI_ID = A.LM_CI_ID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

2 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

3 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
2	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
3	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID