| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
LM_EXT_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
External objective code
|
| 3 |
LM_OBJV_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Objective ID. System Generated ID Number associated with each Objective.
|
| 4 |
LM_OBJV_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Objective code.
|
| 5 |
LM_REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
REview points for Rating models from HRMS
|
| 6 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 7 |
LM_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
ELM Person ID
|
| 8 |
LM_OBJV_DESC |
Character(100) |
VARCHAR2(100) NOT NULL |
Objective description.
|
| 9 |
LM_OBJV_SDESC |
Character(10) |
VARCHAR2(10) NOT NULL |
Objective short description.
|
| 10 |
LM_OBJV_LDESC |
Long Character |
CLOB |
Objective long description.
|
| 11 |
LM_ROW_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
Row Maintainted DateTime
|
| 12 |
LM_ROW_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Maintained Oprid
|
| 13 |
LM_ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
Datetime Added
|
| 14 |
LM_ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Added By
|
| 15 |
LM_EXT_OBJECTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
External Objective
|
| 16 |
LM_RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Used in Competency Sync messages
|
| 17 |
LM_OBJV_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Display objective to SS learner
|
| 18 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 19 |
LM_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 20 |
LM_COUNT1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 21 |
LM_COUNT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 22 |
LM_COUNT3 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 23 |
LM_COUNT4 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 24 |
LM_COUNT5 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 25 |
LM_COUNT6 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 26 |
LM_COUNT7 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 27 |
LM_COUNT8 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 28 |
LM_COUNT9 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 29 |
LM_COUNT10 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|
| 30 |
LM_COUNT11 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field to keep track of the count of id fields
|