SSR_STMLSTN5SLN

(SQL View)
 Index Back

Advsr's Vw of Advsee's Mlstns

This view is used to filter milestones whose Allow Advisor Self-Service is selected and show them in Advisor Self-Service.

SELECT DISTINCT C.OPRID , A.EMPLID , A.MILESTONE , B.LANGUAGE_CD , B.DESCR FROM %Table(SSR_CARMLSTN_VW) A , %Table(SSR_CARMLSTN_LN) B , %Table(SCRTY_TBL_MLSTN) C WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.ACAD_PROG = B.ACAD_PROG AND A.ACAD_PLAN = B.ACAD_PLAN AND A.MILESTONE_NBR = B.MILESTONE_NBR AND A.INSTITUTION = C.INSTITUTION AND C.INQUIRY_USE_IND = 'Y' AND (C.MILESTONE = 'ALL' OR (A.MILESTONE = C.MILESTONE AND NOT EXISTS ( SELECT 'X' FROM %Table(SCRTY_TBL_MLSTN) C1 WHERE C1.OPRID = C.OPRID AND C1.INSTITUTION = C.INSTITUTION AND C1.MILESTONE = 'ALL' AND C1.INQUIRY_USE_IND = 'Y'))) AND A.SSR_SS_ADVSR_AVAIL = 'Y'

  • Related Language Record for SSR_STMLSTN5SVW

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 MILESTONE Character(10) VARCHAR2(10) NOT NULL Milestone
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description