LM_ATTR_CODE01=String
02=Number
1=No Values
2=SQL
3=Free
LM_ATTRB_SETUP(SQL Table) |
Index Back |
|---|---|
Attribute Setup tableAttribute Setup table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ATTR_CODE |
Number(5,0) | INTEGER NOT NULL | Attribute Code |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 3 | LM_ATTR_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Attribute Datatype indicates whether it is string or number. We do not support other datatypes currently.
01=String 02=Number |
| 4 | LM_ATTR_VALS_FROM | Character(1) | VARCHAR2(1) NOT NULL |
Attribute Datatype indicates whether it is string or number. We do not support other datatypes currently.
1=No Values 2=SQL 3=Free |
| 5 | LM_ATTR_LABEL | Character(254) | VARCHAR2(254) NOT NULL | Attribute Name |
| 6 | LM_ATTR_VALS_RECNM | Character(20) | VARCHAR2(20) NOT NULL | Record name for attribute values |
| 7 | LM_ATTVAL_NM_COLNM | Character(20) | VARCHAR2(20) NOT NULL | Column name for attribute value name column |
| 8 | LM_ATTVAL_VL_COLNM | Character(20) | VARCHAR2(20) NOT NULL | Column name for attribute value 'value' column |
| 9 | LM_ATTR_VALS_SQL | Long Character | CLOB | stores SQL Text for fetching all the attribute values |
| 10 | LM_ENRLMT_SQL_ID | Character(30) | VARCHAR2(30) NOT NULL | Enrollment SQL Id |
| 11 | LM_LRQ_SQL_ID | Character(30) | VARCHAR2(30) NOT NULL | Learning Request SQL Id |