LM_CI_EQUIV_VW (SQL View)	Index Back
Catalog Item/Equivalency Tbl This table relates two catalog Items and determines if they are equivalent.

LM_CI_EQUIV_VW

(SQL View)

Catalog Item/Equivalency Tbl

This table relates two catalog Items and determines if they are equivalent.

SELECT A.LM_CI_ID , A.LM_OBJ_ID ,A.LM_EQUIV_OBJ_TYPE FROM PS_LM_CI_EQUIV_TBL A , PS_LM_CI_TBL B WHERE A.LM_CI_ID=B.LM_CI_ID AND A.EFFDT=B.EFFDT AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT

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

2 LM_EQUIV_ID Number(10,0) DECIMAL(10) NOT NULL Equivalent ID - This ID represents a Catalog Item that is equivalent to another Catalog Item in the Catalog. They meet the same requirements.
Prompt Table: %EDITTABLE

3 LM_EQUIV_OBJ_TYPE Character(3) VARCHAR2(3) NOT NULL Equivalent Object Type
10=Course
20=Program
Default Value: 10

#	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 Default Value: 0
2	LM_EQUIV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Equivalent ID - This ID represents a Catalog Item that is equivalent to another Catalog Item in the Catalog. They meet the same requirements. Prompt Table: %EDITTABLE
3	LM_EQUIV_OBJ_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Equivalent Object Type 10=Course 20=Program Default Value: 10