LM_SRCH_LC1 (SQL View)	Index Back
Multiple Learning Comp Flag 1 Returns a flag where there are multiple learning components.

LM_SRCH_LC1

(SQL View)

Multiple Learning Comp Flag 1

Returns a flag where there are multiple learning components.

( SELECT LM_ACT_ID ,COUNT(LM_LC_ID) ,'Y' FROM PS_LM_LC GROUP BY LM_ACT_ID HAVING COUNT(LM_LC_ID)>1) UNION ( SELECT LM_ACT_ID ,COUNT(LM_LC_ID) ,'N' FROM PS_LM_LC GROUP BY LM_ACT_ID HAVING COUNT(LM_LC_ID)=1)

# 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_COUNT Number(10,0) DECIMAL(10) NOT NULL Field to keep track of the count of id fields

3 LM_SRCH_MULT_LC Character(1) VARCHAR2(1) NOT NULL Set a flag value Y/N to indicate whether multiple Learning Components exist for an Activity.

#	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_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Field to keep track of the count of id fields
3	LM_SRCH_MULT_LC	Character(1)	VARCHAR2(1) NOT NULL	Set a flag value Y/N to indicate whether multiple Learning Components exist for an Activity.