LM_ACT_NOTE_LVW (SQL View)	Index Back
Activity Notes View Gets actvity notes related language data where the dislay to option is set to all learners.

LM_ACT_NOTE_LVW

(SQL View)

Activity Notes View

Gets actvity notes related language data where the dislay to option is set to all learners.

SELECT ACT.LM_ACT_ID , ACT.LM_NOTES_ID , ACTL.LANGUAGE_CD , ACTL.LM_NOTE FROM PS_LM_ACT_NOTE ACT , PS_LM_ACTNOTE_LANG ACTL WHERE ACT.LM_ACT_ID = ACTL.LM_ACT_ID AND ACT.LM_NOTES_ID = ACTL.LM_NOTES_ID AND ACT.LM_DISP_TYPE IN ('10','20')

Related Language Record for LM_ACT_NOTES_VW

# 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_NOTES_ID Number(10,0) DECIMAL(10) NOT NULL Notes ID - System generated unique ID for each new note entered.

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 LM_NOTES Long Character CLOB Notes - This field holds notes that are entered at the Catalog Item level.

#	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_NOTES_ID	Number(10,0)	DECIMAL(10) NOT NULL	Notes ID - System generated unique ID for each new note entered.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LM_NOTES	Long Character	CLOB	Notes - This field holds notes that are entered at the Catalog Item level.