QCK_ADM_PROG_LN

(SQL View)
 Index Back

Academic Program Security Vw

Prompt view of the Academic ProgramTable and Quick Admit Temp table which enforces Programl security by operator. This is the related language record for QCK_ADM_PROG_VW.

SELECT DISTINCT A.INSTITUTION ,A.ACAD_CAREER ,A.ACAD_PROG ,B.OPRID ,A1.LANGUAGE_CD ,A.EFFDT ,A1.DESCR FROM PS_ACAD_PROG_TBL A ,PS_ACAD_PROG_LANG A1 ,PS_SCRTY_TBL_PROG B ,PS_QCK_ADM_TEMP C WHERE B.ACCESS_CD = 'Y' AND A.INSTITUTION = A1.INSTITUTION AND A.ACAD_PROG = A1.ACAD_PROG AND A.EFFDT = A1.EFFDT AND A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND (A.ACAD_PROG = B.ACAD_PROG OR B.ACAD_PROG = 'ALL') AND NOT EXISTS ( SELECT 'X' FROM PS_SCRTY_TBL_PROG C WHERE C.ACCESS_CD = 'N' AND C.OPRID = B.OPRID AND C.INSTITUTION = B.INSTITUTION AND C.ACAD_CAREER = B.ACAD_CAREER AND C.ACAD_PROG = A.ACAD_PROG) AND A.INSTITUTION = C.INSTITUTION AND A.ACAD_PROG = C.ACAD_PROG

  • Related Language Record for QCK_ADM_PROG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    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

    3 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description