LM_PRG_OBJVERVW (SQL View)	Index Back
Program Objectives Program Objectives

LM_PRG_OBJVERVW

(SQL View)

Program Objectives

SELECT A.LM_PRG_ID , A.LM_OBJV_ID ,B.LM_OBJV_DESC , B.LM_OBJV_CD FROM PS_LM_PRG_OBJV A ,PS_LM_OBJV_TBL B , PS_LM_PRG C WHERE A.LM_PRG_ID=C.LM_PRG_ID AND A.LM_OBJV_ID=B.LM_OBJV_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_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.

3 LM_OBJV_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.

4 LM_OBJV_CD Character(30) VARCHAR2(30) NOT NULL Objective code.

#	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_OBJV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Objective ID. System Generated ID Number associated with each Objective.
3	LM_OBJV_DESC	Character(100)	VARCHAR2(100) NOT NULL	Objective description.
4	LM_OBJV_CD	Character(30)	VARCHAR2(30) NOT NULL	Objective code.