LM_SRCH_CI_SEC (SQL View)	Index Back
Search: CI Security Search: CI Security The LM_LRNR_GROUP_ID = 999999999999999 is joined on the SQL. This is needed if you want to get all the catalog items / activities regardless of the catalog item / activity security group.

LM_SRCH_CI_SEC

(SQL View)

Search: CI Security

Search: CI Security The LM_LRNR_GROUP_ID = 999999999999999 is joined on the SQL. This is needed if you want to get all the catalog items / activities regardless of the catalog item / activity security group.

SELECT A1.LM_CI_ID , A1.LM_LRNR_GROUP_ID FROM PS_LM_CI_SEC_TBL A1 , PS_LM_CI_TBL C1 WHERE A1.LM_CI_ID = C1.LM_CI_ID AND A1.EFFDT = C1.EFFDT AND %CurrentDateIn BETWEEN C1.EFFDT AND C1.LM_END_EFFDT AND C1.LM_CI_STATUS = '10' UNION SELECT A1.LM_CI_ID , 999999999999999 FROM PS_LM_CI_SEC_TBL A1 , PS_LM_CI_TBL C1 WHERE A1.LM_CI_ID = C1.LM_CI_ID AND A1.EFFDT = C1.EFFDT AND %CurrentDateIn BETWEEN C1.EFFDT AND C1.LM_END_EFFDT AND C1.LM_CI_STATUS = '10'

# 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_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_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
2	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID