LM_OBJV_MET_LVW

(SQL View)

SELECT A.LM_CI_ID ,A.LM_OBJV_ID ,B.LANGUAGE_CD , B.LM_OBJV_DESC , B.LM_OBJV_LDESC FROM PS_LM_CI_OBJV_VW A , PS_LM_OBJV_LNG B ,PS_LM_OBJV_TBL C WHERE A.LM_OBJV_ID = C.LM_OBJV_ID AND B.LM_OBJV_ID = C.LM_OBJV_ID

Related Language Record for LM_OBJV_MET_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

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

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

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

5 LM_OBJV_LDESC Long Character CLOB Objective long description.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
2	LM_OBJV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Objective ID. System Generated ID Number associated with each Objective.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LM_OBJV_DESC	Character(100)	VARCHAR2(100) NOT NULL	Objective description.
5	LM_OBJV_LDESC	Long Character	CLOB	Objective long description.