LM_ENR_APR_LVW

(SQL View)
 Index Back

Enrollment Approval View Rel L

This view is used for the Mobile Approval for Class Enrollment related language view.

SELECT X.LM_ENRLMT_ID , CLNG.LANGUAGE_CD , CLNG.LM_CS_DESCR , CLNG.LM_CS_LONG_NM , DLNG.LM_DM_LONG_NM FROM PS_LM_ENRLMT M , PS_LM_ACT A , PS_LM_CI_VW C , PS_LM_CI_VW_LNG CLNG , PS_LM_DMTH_TYP_TBL T , PS_LM_DMTH_TYP_LNG DLNG , PS_LM_ENR_APR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST D WHERE M.LM_ACT_ID = A.LM_ACT_ID AND A.LM_CI_ID = C.LM_CI_ID AND C.LM_CI_ID = CLNG.LM_CI_ID AND A.LM_DMTHD_TYPE_ID = T.LM_DMTHD_TYPE_ID AND T.LM_DMTHD_TYPE_ID = DLNG.LM_DMTHD_TYPE_ID AND DLNG.LANGUAGE_CD = CLNG.LANGUAGE_CD AND M.LM_ENRLMT_ID = X.LM_ENRLMT_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 UNION SELECT X.LM_ENRLMT_ID , CLNG.LANGUAGE_CD , CLNG.LM_CS_DESCR , CLNG.LM_CS_LONG_NM , T.LM_DM_LONG_NM FROM PS_LM_ENRLMT M , PS_LM_ACT A , PS_LM_CI_VW C , PS_LM_CI_VW_LNG CLNG , PS_LM_DMTH_TYP_TBL T , PS_LM_ENR_APR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST D WHERE M.LM_ACT_ID = A.LM_ACT_ID AND A.LM_CI_ID = C.LM_CI_ID AND C.LM_CI_ID = CLNG.LM_CI_ID AND A.LM_DMTHD_TYPE_ID = T.LM_DMTHD_TYPE_ID AND M.LM_ENRLMT_ID = X.LM_ENRLMT_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 AND NOT EXISTS ( SELECT 1 FROM PS_LM_DMTH_TYP_LNG DLNG WHERE T.LM_DMTHD_TYPE_ID = DLNG.LM_DMTHD_TYPE_ID AND DLNG.LANGUAGE_CD = CLNG.LANGUAGE_CD) UNION SELECT X.LM_ENRLMT_ID , DLNG.LANGUAGE_CD , C.LM_CS_DESCR , C.LM_CS_LONG_NM , DLNG.LM_DM_LONG_NM FROM PS_LM_ENRLMT M , PS_LM_ACT A , PS_LM_CI_VW C , PS_LM_DMTH_TYP_TBL T , PS_LM_DMTH_TYP_LNG DLNG , PS_LM_ENR_APR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST D WHERE M.LM_ACT_ID = A.LM_ACT_ID AND A.LM_CI_ID = C.LM_CI_ID AND A.LM_DMTHD_TYPE_ID = T.LM_DMTHD_TYPE_ID AND T.LM_DMTHD_TYPE_ID = DLNG.LM_DMTHD_TYPE_ID AND M.LM_ENRLMT_ID = X.LM_ENRLMT_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 AND NOT EXISTS ( SELECT 1 FROM PS_LM_CI_VW_LNG CLNG WHERE C.LM_CI_ID = CLNG.LM_CI_ID AND CLNG.LANGUAGE_CD = DLNG.LANGUAGE_CD)

  • Related Language Record for LM_ENR_APR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail
    4 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    5 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type