LM_PRG_APR_LVW

(SQL View)
 Index Back

Program Approval View Rel Lang

This view is used for the Mobile Approval for Programs Related Language view.

SELECT X.LM_PRG_REG_ID , PLNG.LANGUAGE_CD , PLNG.LM_PRG_ABST , PLNG.LM_PRG_DESCR , PLNG.LM_PRG_LONG_NM FROM PS_LM_PRG_REG M , PS_LM_PRG_VW P , PS_LM_PRG_LANG PLNG , PS_LM_REG_APR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST D WHERE P.LM_PRG_ID = PLNG.LM_PRG_ID AND P.EFFDT = PLNG.EFFDT AND M.LM_PRG_ID = P.LM_PRG_ID AND M.LM_PRG_REG_ID = X.LM_PRG_REG_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND D.EOAWSTEP_INSTANCE = S.EOAWSTEP_INSTANCE

  • Related Language Record for LM_PRG_APR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_PRG_ABST Long Character CLOB Program Abstract
    4 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description
    5 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name