LM_PRG_KWDVERVW (SQL View)	Index Back
Program Keywords view Program Keywords view

LM_PRG_KWDVERVW

(SQL View)

Program Keywords view

SELECT A.LM_PRG_ID , A.LM_KWRD_ID , D.LM_KWRD FROM PS_LM_PRG_KWRD A , PS_LM_KWRD_TBL D , PS_LM_PRG C WHERE A.LM_KWRD_ID=D.LM_KWRD_ID AND A.LM_PRG_ID=C.LM_PRG_ID AND A.EFFDT=C.EFFDT AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.LM_PRG_STATUS='10'

# 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_KWRD_ID Number(10,0) DECIMAL(10) NOT NULL Keyword ID - This is a system generated number used as a unique identifier for the keyword table.

3 LM_KWRD Character(30) VARCHAR2(30) NOT NULL Keyword - Used to store all keywords

#	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_KWRD_ID	Number(10,0)	DECIMAL(10) NOT NULL	Keyword ID - This is a system generated number used as a unique identifier for the keyword table.
3	LM_KWRD	Character(30)	VARCHAR2(30) NOT NULL	Keyword - Used to store all keywords