LM_DUMMYOBJV_VW (SQL View)	Index Back
Catalog UI View Prompt view used for searching on objectives

LM_DUMMYOBJV_VW

(SQL View)

Catalog UI View

Prompt view used for searching on objectives

SELECT DISTINCT LM_OBJV_ID , LM_OBJV_DESC FROM PS_LM_OBJV_VW WHERE LM_OBJV_ID =0

# 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.
Default Value: 0

2 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. Default Value: 0
2	LM_OBJV_DESC	Character(100)	VARCHAR2(100) NOT NULL	Objective description.