LM_OBJV_CI_VW1 (SQL View)	Index Back
Catalog Item/Objectives Rel This view is used in Objectives Definitions and Mapping page, since we need objective id to be the first key

LM_OBJV_CI_VW1

(SQL View)

Catalog Item/Objectives Rel

This view is used in Objectives Definitions and Mapping page, since we need objective id to be the first key

SELECT A.LM_OBJV_ID , A.LM_CI_ID , A.EFFDT , A.LM_REVIEW_RATING , A.LM_PRIMARY_OBJV FROM PS_LM_CI_OBJV_TBL A

Parent record: LM_CI_TBL

# 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.
Prompt Table: LM_CS_OBJV_VW

2 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
Prompt Table: LM_CI_ALL_VW

3 LM_EFFDT Date(10) DATE NOT NULL Effective Date
Prompt Table: LM_CI_EFFDT_VW1

4 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS
Prompt Table: LM_RVW_RTNG_VW

5 LM_PRIMARY_OBJV Character(1) VARCHAR2(1) NOT NULL Indicates whether the global objective is the primary global object.
Y/N Table Edit
Default Value: N

#	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. Prompt Table: LM_CS_OBJV_VW
2	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item Prompt Table: LM_CI_ALL_VW
3	LM_EFFDT	Date(10)	DATE NOT NULL	Effective Date Prompt Table: LM_CI_EFFDT_VW1
4	LM_REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	REview points for Rating models from HRMS Prompt Table: LM_RVW_RTNG_VW
5	LM_PRIMARY_OBJV	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether the global objective is the primary global object. Y/N Table Edit Default Value: N