LM_ITM_PRG_VW

(SQL View)
 Index Back

Program Items view

Progm Items view

SELECT DISTINCT PER.OPRID , PER.LM_PERSON_ID , P.LM_PRG_ID , P.EFFDT , I.LM_OBJ_ID , P.LM_PRG_CD , P.LM_PRG_LONG_NM , P.LM_PRG_TYPE , X.XLATLONGNAME ,P.LM_INT_PRICE ,P.LM_EXT_PRICE ,P.LM_TRNG_UT ,P.LM_INT_DP_PRICE ,P.LM_EXT_DP_PRICE ,P.LM_DP_TRNG_UT ,P.CURRENCY_CD FROM PS_LM_OPRID_GRP_VW PER , PS_LM_PRG_SEC SEC , PS_LM_PRG P , PS_LM_PRG_ITEM I , XLATTABLE_VW X 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_STATUS = '10' AND p.LM_ENRL_AUTO_REG ='Y' AND %CurrentDateIn BETWEEN P.EFFDT AND P.LM_END_EFFDT AND X.FIELDNAME IN ('LM_PRG_TYPE') AND X.FIELDVALUE = P.LM_PRG_TYPE AND P.LM_PRG_ID = I.LM_PRG_ID AND I.LM_OBJ_TYPE = '10'

  • Related Language Record: LM_ITM_PRG_LVW

    • # 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 LM_PRG_CD Character(30) VARCHAR2(30) NOT NULL Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.
    7 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    8 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
    CE=Certification
    CU=Curriculum
    9 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    10 LM_INT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Price
    11 LM_EXT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Price
    12 LM_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Training Units - Price
    13 LM_INT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Drop Price
    14 LM_EXT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Drop Price
    15 LM_DP_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Drop Training Units
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL