RD_USR_PRG_VW

(SQL View)
 Index Back

Academic Program Security

This is a clone of ACAD_PROG_SCTY2. Prompt view which enforces Academic Program operator security and also checks to see if the programs are valid for the Admit Term and the the Admit Term is greater than the Last Admit Term for a Program.

SELECT DISTINCT SP.OPRID , P.INSTITUTION , P.ACAD_CAREER , P.ACAD_PROG , SP.ACCESS_CD , P.CAMPUS , P.ACAD_PLAN , P.FIRST_TERM_VALID , P.SSR_LAST_ADM_TERM , P.SSR_LAST_PRS_DT , P.DESCR FROM PS_ACAD_PROG_TBL P , PS_SCRTY_TBL_PROG SP WHERE P.INSTITUTION = SP.INSTITUTION AND P.ACAD_CAREER = SP.ACAD_CAREER AND (%CurrentDateIn <= P.SSR_LAST_PRS_DT OR P.SSR_LAST_PRS_DT IS NULL) AND (P.ACAD_PROG = SP.ACAD_PROG OR SP.ACAD_PROG = 'ALL') AND NOT EXISTS ( SELECT 1 FROM PS_SCRTY_TBL_PROG SP2 WHERE SP.OPRID = SP2.OPRID AND SP.INSTITUTION = SP2.INSTITUTION AND SP.ACAD_CAREER = SP2.ACAD_CAREER AND SP.ACAD_PROG = SP2.ACAD_PROG AND SP2.ACCESS_CD = 'N') AND %EffdtCheck(ACAD_PROG_TBL, P, %CurrentDateIn) AND P.EFF_STATUS <> 'I'

  • Related Language Record: RD_USR_PRG_LVW

    • # 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 Institution field to store institution information in campus solution system.

    Prompt Table: INSTITUTION_TBL

    3 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic career field coming from campus solution system.
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: ACAD_CAR_TBL

    4 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic program field coming from campus solution system.

    Prompt Table: ACAD_PROG_TBL

    5 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    R=Read Only Access
    Y=Read/Write Access
    6 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    7 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan field coming from campus solution system
    8 FIRST_TERM_VALID Character(4) VARCHAR2(4) NOT NULL This field is used to indicate first valid term.
    9 SSR_LAST_ADM_TERM Character(4) VARCHAR2(4) NOT NULL This field stores the Last Admitted Term.
    10 SSR_LAST_PRS_DT Date(10) DATE Field used to store the Last Prospect Date values.
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description