LM_CI_LE_TBL(SQL Table) |
Index Back |
---|---|
CI LE Relationship tableCatalog Item Learning Environment Relationships |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL |
Catalog Item ID - System Generated ID Number associated with each Catalog Item
Default Value: 0 |
|
2 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
3 | Number(10,0) | DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
Default Value: 0 Prompt Table: LM_CI_LE_VW |
|
4 | 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 |