SSR_STMLSTN5SVW

(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 B.OPRID , A.EMPLID , A.MILESTONE , A.DESCR FROM %Table(SSR_CARMLSTN_VW) A , %Table(SCRTY_TBL_MLSTN) B WHERE A.INSTITUTION = B.INSTITUTION AND B.INQUIRY_USE_IND = 'Y' AND (B.MILESTONE = 'ALL' OR (A.MILESTONE = B.MILESTONE AND NOT EXISTS ( SELECT 'X' FROM %Table(SCRTY_TBL_MLSTN) B1 WHERE B1.OPRID = B.OPRID AND B1.INSTITUTION = B.INSTITUTION AND B1.MILESTONE = 'ALL' AND B1.INQUIRY_USE_IND = 'Y'))) AND A.SSR_SS_ADVSR_AVAIL = 'Y'

  • Related Language Record: SSR_STMLSTN5SLN

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description