LM_OBJTBLVW4_LG (SQL View)	Index Back
Objectives Table The Objectives Table is where ELM Objectives are defined. The Objective ID field is used for purposes of attaching Objectives to the Catalog

LM_OBJTBLVW4_LG

(SQL View)

Objectives Table

The Objectives Table is where ELM Objectives are defined. The Objective ID field is used for purposes of attaching Objectives to the Catalog

SELECT A.LM_OBJV_ID , B.LANGUAGE_CD , B.LM_OBJV_DESC FROM PS_LM_OBJV_VW A , PS_LM_OBJV_LNG_VW B WHERE A.LM_OBJV_ID = B.LM_OBJV_ID

Related Language Record for LM_OBJV_TBL_VW4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_OBJV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Objective ID. System Generated ID Number associated with each Objective.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LM_OBJV_DESC	Character(100)	VARCHAR2(100) NOT NULL	Objective description.