LM_RECRTPRG_LNG

(SQL View)
 Index Back

Recertification Language Vw

Lists all recertifications available for the current certification. Related Language view for the Learner Recertification View

SELECT A.LM_PRG_ID ,A.EFFDT , C.LANGUAGE_CD , C.LM_PRG_LONG_NM FROM PS_LM_PRG A , PS_LM_PRG_LANG C WHERE A.LM_PRG_TYPE = 'CE' AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND A.LM_PRG_STATUS = '10' AND A.EFFDT = C.EFFDT AND A.LM_PRG_ID = C.LM_PRG_ID

  • Related Language Record for LM_RECERTPRG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name