LM_LRNR_COMP_VW (SQL View)	Index Back
Learner Competency View Combines the LM_EVALS (HR evaluations) with the LM_LRNR_COMP (learner HR competencies) together to include the LM_EVAL_TYPE field. This view is used during message subscription processing to identify the gaps between learner competencies and the requirements of the learners job. This view only returns those rows with an evaluation type of 'A' (Official), 'R' (Supervisor/Manager), or 'S' (Self Reported).

LM_LRNR_COMP_VW

(SQL View)

Learner Competency View

Combines the LM_EVALS (HR evaluations) with the LM_LRNR_COMP (learner HR competencies) together to include the LM_EVAL_TYPE field. This view is used during message subscription processing to identify the gaps between learner competencies and the requirements of the learners job. This view only returns those rows with an evaluation type of 'A' (Official), 'R' (Supervisor/Manager), or 'S' (Self Reported).

SELECT A.LM_PERSON_ID , A.LM_EVAL_ID , A.LM_OBJV_ID , A.EFFDT , B.LM_EVAL_TYPE , A.LM_REVIEW_RATING , A.LM_EXT_SRC_CD ,A.LM_EXT_CD , A.LM_EXT_MSG_TYPE FROM PS_LM_LRNR_COMP A , PS_LM_EVALS B , PS_LM_OBJV_EXT_SRC C WHERE A.LM_PERSON_ID = B.LM_PERSON_ID AND A.LM_EVAL_ID = B.LM_EVAL_ID AND (B.LM_EVAL_TYPE = 'A' OR (B.LM_EVAL_TYPE = 'R' AND NOT EXISTS( SELECT 'X' FROM PS_LM_LRNR_COMP A1 , PS_LM_EVALS B1 WHERE A1.LM_PERSON_ID = B1.LM_PERSON_ID AND A1.LM_EVAL_ID = B1.LM_EVAL_ID AND A1.LM_OBJV_ID = A.LM_OBJV_ID AND A1.LM_PERSON_ID = A.LM_PERSON_ID AND B1.LM_EVAL_TYPE = 'A') ) OR (B.LM_EVAL_TYPE = 'S' AND NOT EXISTS( SELECT 'X' FROM PS_LM_LRNR_COMP A2 , PS_LM_EVALS B2 WHERE A2.LM_PERSON_ID = B2.LM_PERSON_ID AND A2.LM_EVAL_ID = B2.LM_EVAL_ID AND A2.LM_OBJV_ID = A.LM_OBJV_ID AND A2.LM_PERSON_ID = A.LM_PERSON_ID AND B2.LM_EVAL_TYPE IN ('A', 'R')))) AND C.LM_EXT_SRC_CD = 'HRCOMP' AND C.LM_EXT_CD = A.LM_EXT_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

2 LM_EVAL_ID Character(2) VARCHAR2(2) NOT NULL LM evaluation ID

3 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 LM_EVAL_TYPE Character(2) VARCHAR2(2) NOT NULL LM evaluation Type
A=Approved/Official
B=Subordinate
C=Customer
E=Executive Committee
L=Learning Management
M=Mentor
P=Peer
R=Supervisor/Manager
S=Self

6 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS

7 LM_EXT_SRC_CD Character(10) VARCHAR2(10) NOT NULL External Source Code

8 LM_EXT_CD Character(30) VARCHAR2(30) NOT NULL External objective code

9 LM_EXT_MSG_TYPE Character(1) VARCHAR2(1) NOT NULL External Message Type - full or incremental.
1=Full Sync
5=Incremental Sync

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
2	LM_EVAL_ID	Character(2)	VARCHAR2(2) NOT NULL	LM evaluation ID
3	LM_OBJV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Objective ID. System Generated ID Number associated with each Objective.
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	LM_EVAL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	LM evaluation Type A=Approved/Official B=Subordinate C=Customer E=Executive Committee L=Learning Management M=Mentor P=Peer R=Supervisor/Manager S=Self
6	LM_REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	REview points for Rating models from HRMS
7	LM_EXT_SRC_CD	Character(10)	VARCHAR2(10) NOT NULL	External Source Code
8	LM_EXT_CD	Character(30)	VARCHAR2(30) NOT NULL	External objective code
9	LM_EXT_MSG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	External Message Type - full or incremental. 1=Full Sync 5=Incremental Sync