LM_CATG_LE_TBL (SQL Table)	Index Back
Category - LE Relationship TBL This table is used to Relate the Category table to the Learning Environment Table

LM_CATG_LE_TBL

(SQL Table)

Category - LE Relationship TBL

This table is used to Relate the Category table to the Learning Environment Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.
Default Value: 0

2 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
Default Value: 0
Prompt Table: LM_CI_LE_VW

3 LM_PRM_LE Character(2) VARCHAR2(2) NOT NULL Primary Learning Environment - This is a Yes/No field that signifies if the learning environment on the current row is the primary learning environment for the accompanying object (i.e. Catalog Item, Category)
Y/N Table Edit
Default Value: N

4 LM_PRM_CATG Character(2) VARCHAR2(2) NOT NULL Primary Category - This represents the default high level node for a given Learning Environment. The user's catalog will only start from this node, based on their Learning Environment, in V1.
Y/N Table Edit
Default Value: N

5 LM_HIGH_LVL_CATG Character(1) VARCHAR2(1) NOT NULL High Level Category Node - This Node is represents the starting point of a catalog for this Learning Environment, this allows for multiple catalogs per Learning Environment, however this functionality will not be used currently
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_CATG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Category ID - System generated number used to uniquely identify a Category. Default Value: 0
2	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number Default Value: 0 Prompt Table: LM_CI_LE_VW
3	LM_PRM_LE	Character(2)	VARCHAR2(2) NOT NULL	Primary Learning Environment - This is a Yes/No field that signifies if the learning environment on the current row is the primary learning environment for the accompanying object (i.e. Catalog Item, Category) Y/N Table Edit Default Value: N
4	LM_PRM_CATG	Character(2)	VARCHAR2(2) NOT NULL	Primary Category - This represents the default high level node for a given Learning Environment. The user's catalog will only start from this node, based on their Learning Environment, in V1. Y/N Table Edit Default Value: N
5	LM_HIGH_LVL_CATG	Character(1)	VARCHAR2(1) NOT NULL	High Level Category Node - This Node is represents the starting point of a catalog for this Learning Environment, this allows for multiple catalogs per Learning Environment, however this functionality will not be used currently Y/N Table Edit Default Value: N