LM_CI_OBJV_TBL (SQL Table)	Index Back
Catalog Item/Objectives Rel This table is used to relate the Catalog Item table with the Learning Objectives Table

LM_CI_OBJV_TBL

(SQL Table)

Catalog Item/Objectives Rel

This table is used to relate the Catalog Item table with the Learning Objectives Table

Parent record: LM_CI_TBL

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

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date
Prompt Table: LM_CI_EFFDT_VW

3 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

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_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
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date Prompt Table: LM_CI_EFFDT_VW
3	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
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