LM_PRG_REL_LVW

(SQL View)
 Index Back

Program View

Rel Language View for LM_PRG_REL_VW - For maintaining Parent child relationship in the page

SELECT PRG.LM_PRG_ID , PRG.EFFDT , PRG.LM_PRG_ID , PRG.LANGUAGE_CD , PRG.LM_PRG_LONG_NM , PRG.LM_PRG_SHORT_NM , PRG.LM_PRG_DESCR , PRG.LM_EXTRNL_INFO , PRG.LM_TARGET_AUD , PRG.LM_PRG_ABST FROM PS_LM_PRG_LANG PRG , PS_LM_PRG PRG1 WHERE PRG.LM_PRG_ID = PRG1.LM_PRG_ID AND PRG.EFFDT = PRG1.EFFDT AND %CurrentDateIn BETWEEN PRG1.EFFDT AND PRG1.LM_END_EFFDT

  • Related Language Record for LM_PRG_REL_VW

  • Parent record: LM_PRG

    • # 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 LM_PRG_REL_ID Number(10,0) DECIMAL(10) NOT NULL New Field to hold to hold the nested relationship Program ID. Clone of Program ID /** Bug #33233658 **/
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    6 LM_PRG_SHORT_NM Character(10) VARCHAR2(10) NOT NULL Program Short Name
    7 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description
    8 LM_EXTRNL_INFO Character(30) VARCHAR2(30) NOT NULL External Information - This field is populated by external user/vendor and is user defined.
    9 LM_TARGET_AUD Character(254) VARCHAR2(254) NOT NULL Target Audience
    10 LM_PRG_ABST Long Character CLOB Program Abstract