LM_ITM_PRG_LVW

(SQL View)
Index Back

Program Items view

Progm Items Language view

SELECT DISTINCT PER.OPRID , PER.LM_PERSON_ID , P.LM_PRG_ID , P.EFFDT , I.LM_OBJ_ID ,LANG.LANGUAGE_CD , LANG.LM_PRG_LONG_NM FROM PS_LM_OPRID_GRP_VW PER , PS_LM_PRG_SEC SEC , PS_LM_PRG P , PS_LM_PRG_ITEM I , PS_LM_PRG_LANG LANG WHERE 1 = 1 AND (PER.LM_LRNR_GROUP_ID = SEC.LM_LRNR_GROUP_ID OR SEC.LM_LRNR_GROUP_ID IN ( SELECT A.LM_LRNR_GROUP_ID FROM PS_LM_GROUPS_CRIT A , PS_LM_GROUP_PERSON B WHERE A.LM_FIELDNAME = 'LM_LRNR_GROUP_ID' AND B.LM_PERSON_ID=PER.LM_PERSON_ID AND A.LM_CRITERIA_VALUE = %NumToChar(B.LM_LRNR_GROUP_ID) GROUP BY A.LM_LRNR_GROUP_ID HAVING COUNT(*) = ( SELECT COUNT(*) FROM PS_LM_GROUPS_CRIT C WHERE C.LM_LRNR_GROUP_ID = A.LM_LRNR_GROUP_ID))) AND P.LM_PRG_ID = SEC.LM_PRG_ID AND P.LM_PRG_ID=LANG.LM_PRG_ID AND P.EFFDT=LANG.EFFDT AND P.LM_PRG_STATUS = '10' AND p.LM_ENRL_AUTO_REG ='Y' AND %CurrentDateIn BETWEEN P.EFFDT AND P.LM_END_EFFDT AND P.LM_PRG_ID = I.LM_PRG_ID AND I.LM_OBJ_TYPE = '10'

  • Related Language Record for LM_ITM_PRG_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    3 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 LM_OBJ_ID Number(10,0) DECIMAL(10) NOT NULL Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name