LM_LRNR_OBJV_ID10=Needed
20=Planned
30=In-Progress
40=Met
LM_LRNR_OBJ_MSG(SQL View) |
Index Back |
|---|---|
Learner Objectives MessageLearner Objectives message record for outbound Learner Objectives |
| SELECT A.LM_LRNR_OBJV_ID , A.LM_PERSON_ID , A.LM_OBJV_ID , A.LM_OBJV_STATUS , A.LM_OBJV_STAT_DTTM , B.LM_HR_EMPLID , A.LM_EXT_SRC_CD , A.LM_REVIEW_RATING FROM PS_LM_LRNR_OBJV A , PS_LM_PERSON B WHERE A.LM_PERSON_ID = B.LM_PERSON_ID AND LM_OBJV_STATUS = '40' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_LRNR_OBJV_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Learner Objective ID. System Generated ID Number associated with each Learner Objective. |
| 2 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_OBJV_ID | Number(10,0) | DECIMAL(10) NOT NULL | Objective ID. System Generated ID Number associated with each Objective. |
| 4 | LM_OBJV_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Learner Objective status.
10=Needed 20=Planned 30=In-Progress 40=Met |
| 5 | LM_OBJV_STAT_DTTM | DateTime(26) | TIMESTAMP | Learner Objective status datetime. |
| 6 | LM_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 7 | LM_EXT_SRC_CD | Character(10) | VARCHAR2(10) NOT NULL | External Source Code |
| 8 | LM_REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | REview points for Rating models from HRMS |