LM_SRCH_ACTSEC (SQL View)	Index Back
Search: Activity Security This view will set the learner group for the classes and courses without classes. The learner group is set to 999999999999999 which is used for administrative pages. In addition, class statutes for Active, Closed and Concluded are also selected for this learner group. All others are set to the class learner group based on what is set as security. In addition, the class status must be Active.

LM_SRCH_ACTSEC

(SQL View)

Search: Activity Security

This view will set the learner group for the classes and courses without classes. The learner group is set to 999999999999999 which is used for administrative pages. In addition, class statutes for Active, Closed and Concluded are also selected for this learner group. All others are set to the class learner group based on what is set as security. In addition, the class status must be Active.

SELECT A1.LM_ACT_ID , A1.LM_CI_ID , %NumToChar(A1.LM_LRNR_GROUP_ID) FROM PS_LM_SRCH_ACTSCC1 A1 UNION SELECT 0 ,A2.LM_CI_ID , %NumToChar(A2.LM_CI_ID) %Concat ':' %Concat %NumToChar(A2.LM_LRNR_GROUP_ID) FROM PS_LM_SRCH_DTTMV8 A2 UNION SELECT 0 , C3X.LM_CI_ID , '999999999999999' FROM PS_LM_SRCH_DTTMV8 C3X

# 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_SRCHGRP_ID Character(26) VARCHAR2(26) 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_SRCHGRP_ID	Character(26)	VARCHAR2(26) NOT NULL	Learner Group ID - Business Role/ Student Group ID