LM_CAT_RLAT_VW (SQL View)	Index Back
Catalog Relationships View - Defines relationship between Catalog Items.

LM_CAT_RLAT_VW

(SQL View)

Catalog Relationships

View - Defines relationship between Catalog Items.

SELECT B.LM_OBJV_ID ,A.LM_CAT_ITEM_ID ,A.LM_CAT_ITEM_ID2 ,D.LM_OBJV_ID ,D.LM_OBJV_DESC FROM PS_LM_CAT_RLAT A ,PS_LM_OBJV_DTL B ,PS_LM_OBJV_TBL C ,PS_LM_OBJV_TBL D ,PS_LM_OBJV_DTL E WHERE B.LM_OBJV_ID = C.LM_OBJV_ID AND A.LM_CAT_TYPE = B.LM_CAT_TYPE AND A.LM_CAT_ITEM_ID = B.LM_EXT_CD AND A.LM_CAT_ITEM_ID = C.LM_OBJV_CD AND A.LM_CAT_RLAT_CD = 'P' AND A.EFF_STATUS = 'A' AND B.LM_EXT_SRC_CD = 'PM' AND A.LM_CAT_ITEM_ID2 = D.LM_OBJV_CD AND D.LM_OBJV_ID = E.LM_OBJV_ID AND E.LM_EXT_SRC_CD = 'PM' AND D.LM_OBJV_CD = E.LM_EXT_CD AND A.LM_CAT_TYPE2 = E.LM_CAT_TYPE

# 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.

2 LM_CAT_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Category Item field

3 LM_CAT_ITEM_ID2 Character(15) VARCHAR2(15) NOT NULL Secondary content item id (as in a related item- such as a child or a supporting item of another item).

4 LM_OBJ_ID Number(10,0) DECIMAL(10) NOT NULL Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.

5 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.
2	LM_CAT_ITEM_ID	Character(15)	VARCHAR2(15) NOT NULL	Category Item field
3	LM_CAT_ITEM_ID2	Character(15)	VARCHAR2(15) NOT NULL	Secondary content item id (as in a related item- such as a child or a supporting item of another item).
4	LM_OBJ_ID	Number(10,0)	DECIMAL(10) NOT NULL	Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.
5	LM_OBJV_DESC	Character(100)	VARCHAR2(100) NOT NULL	Objective description.