LM_LRNR_OBJ_VW3

(SQL View)
 Index Back

Learner Objectives

Learner Objectives table.

SELECT A.LM_LRNR_OBJV_ID , A.LM_PERSON_ID , A.LM_OBJV_ID , A.LM_OBJV_ASSIGN_CD , A.LM_REVIEW_RATING , A.LM_OBJV_STATUS , B.LM_RATING_MODEL , C.DESCR FROM PS_LM_LRNR_OBJV A ,PS_LM_OBJV_TBL_VW1 B , PS_LM_RVW_RTNG_VW C WHERE A.LM_OBJV_ID = B.LM_OBJV_ID AND C.LM_RATING_MODEL = B.LM_RATING_MODEL AND C.LM_REVIEW_RATING = A.LM_REVIEW_RATING AND A.LM_OBJV_ASGN_DT BETWEEN C.EFFDT AND C.LM_END_EFFDT

  • Related Language Record: LM_LRNROB_VW_LG

    • # 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_ASSIGN_CD Character(3) VARCHAR2(3) NOT NULL Internal assignment of Objectives
    ADH=Adhoc Assigned
    CAT=Catalogue Assigned
    EXT=External System
    HPC=HR Person Comp Assigned
    HRS=HR Assigned
    JOB=Job Objectives Assigned
    MAS=Mass Assigned
    MGR=Manager Assigned
    POS=Position Objectives Assigned
    PRG=Program Assigned
    SLF=Self Assigned
    5 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS
    6 LM_OBJV_STATUS Character(2) VARCHAR2(2) NOT NULL Learner Objective status.
    10=Needed
    20=Planned
    30=In-Progress
    40=Met
    7 LM_RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Used in Competency Sync messages
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description