SSR_REQS_DRP_VW

(SQL View)
 Index Back

PERC Drop Reason View


SELECT DISTINCT(A.ENRL_ACTION_REASON) , A.DESCR FROM PS_ENRL_RSN_TBL A WHERE A.ENRL_ACTION = 'D' AND A.EFFDT >= ( SELECT A1.EFFDT FROM PS_ENRL_RSN_TBL A1 WHERE A1.SETID = A.SETID AND A1.ACAD_CAREER = A.ACAD_CAREER AND A1.ENRL_ACTION = A.ENRL_ACTION AND A1.ENRL_ACTION_REASON = A.ENRL_ACTION_REASON AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record: SSR_REQS_DRPVWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ENRL_ACTION_REASON Character(4) VARCHAR2(4) NOT NULL Enrollment Action Reason
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description