SSRCRSMLSTLNSVW

(SQL View)
 Index Back

Course/Milestone Link RLang Vw

Gets Course ID, Effective Date, and Milestone from SSR_CRS_MILESTN; Institution from MILESTONE_TBL; Description of milestone from MILESTONE_LANG; and User ID from SCRTY_TBL_MLSTN

SELECT D.OPRID , B.INSTITUTION , A.CRSE_ID , A.MILESTONE , C.LANGUAGE_CD , A.EFFDT , C.DESCR FROM %Table(SSR_CRS_MILESTN) A , %Table(MILESTONE_TBL) B , %Table(MILESTONE_LANG) C , %Table(SCRTY_TBL_MLSTN) D WHERE A.MILESTONE = B.MILESTONE AND %EffdtCheck(MILESTONE_TBL B1, B, %CurrentDateIn) AND %Join(COMMON_KEYS, MILESTONE_TBL B, MILESTONE_LANG C) AND B.EFF_STATUS = 'A' AND B.INSTITUTION = D.INSTITUTION AND D.INQUIRY_USE_IND = 'Y' AND (D.MILESTONE = 'ALL' OR (B.MILESTONE = D.MILESTONE AND NOT EXISTS ( SELECT 'X' FROM %Table(SCRTY_TBL_MLSTN) D1 WHERE D1.OPRID = D.OPRID AND D1.INSTITUTION = D.INSTITUTION AND D1.MILESTONE = 'ALL' AND D1.INQUIRY_USE_IND = 'Y')))

  • Related Language Record for SSR_CRS_MLS_SVW

    • # 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    4 MILESTONE Character(10) VARCHAR2(10) NOT NULL Milestone
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 EFFDT Date(10) DATE NOT NULL Effective Date
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description