SSR_REQS_DRPVWL

(SQL View)
 Index Back

Rel Lang for SSR_REQS_DRP_VW


SELECT DISTINCT(A.ENRL_ACTION_REASON) , A.LANGUAGE_CD , A.DESCR FROM PS_ENRL_RSN_LANG A WHERE A.ENRL_ACTION = 'D' AND A.EFFDT >= ( SELECT A1.EFFDT FROM PS_ENRL_RSN_LANG 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 for SSR_REQS_DRP_VW

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