LM_PRGSS_NT_LNG (SQL View)	Index Back
Program Note SS view Used to display program notes on self service pages. Related Language Table.

LM_PRGSS_NT_LNG

(SQL View)

Program Note SS view

Used to display program notes on self service pages. Related Language Table.

SELECT A.LM_PRG_ID , A.LM_NOTES_ID , C.LANGUAGE_CD , C.LM_NOTE FROM PS_LM_PRG_NOTE A , PS_LM_PRG B , PS_LM_PRG_NOTE_LNG C WHERE A.LM_PRG_ID = B.LM_PRG_ID AND A.LM_PRG_ID = C.LM_PRG_ID AND A.EFFDT = B.EFFDT AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND A.LM_NOTES_ID = C.LM_NOTES_ID AND A.EFFDT = C.EFFDT AND A.LM_SS_NOTE_DISP = 'Y'

Related Language Record for LM_PRGSS_NT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

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_NOTE Long Character CLOB Notes and Comments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
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_NOTE	Long Character	CLOB	Notes and Comments