LM_PRGSS_NT_VW (SQL View)	Index Back
Program Note SS view used to display program notes on self service pages.

LM_PRGSS_NT_VW

(SQL View)

Program Note SS view

used to display program notes on self service pages.

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

Related Language Record: LM_PRGSS_NT_LNG

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

4 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime

#	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	LM_NOTE	Long Character	CLOB	Notes and Comments
4	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime