CLASS_TBL_SCTY

(SQL View)
 Index Back

Class Table Security Search

Use this search record to restrict operator access to the Class Table. This view retrieves class sections offered by Academic Organizations an operator is granted access to.

SELECT A.INSTITUTION , A.STRM , A.SUBJECT , A.CATALOG_NBR , A.ACAD_CAREER , A.CAMPUS , C.OPRID , A.CRSE_ID , A.DESCR , A.CRSE_ID , A.CRSE_OFFER_NBR , A.ACAD_ORG , C.ACCESS_CD , A.CRS_TOPIC_ID FROM PS_CLASS_TBL A , PS_TERM_VAL_TBL B , PS_SCRTY_TBL_ACAD C WHERE A.STRM = B.STRM AND C.ACCESS_CD='Y' AND EXISTS ( SELECT 'X' FROM PSTREENODE E WHERE E.SETID=' ' AND E.TREE_NAME='ACAD_ORGANIZATION' AND E.EFFDT=C.TREE_EFFDT AND E.TREE_NODE=A.ACAD_ORG AND E.TREE_NODE_NUM BETWEEN C.TREE_NODE_NUM AND C.TREE_NODE_NUM_END AND NOT EXISTS ( SELECT 'X' FROM PS_SCRTY_TBL_ACAD G WHERE C.OPRID=G.OPRID AND C.TREE_NODE_NUM<>G.TREE_NODE_NUM AND E.TREE_NODE_NUM BETWEEN G.TREE_NODE_NUM AND G.TREE_NODE_NUM_END AND G.TREE_NODE_NUM BETWEEN C.TREE_NODE_NUM AND C.TREE_NODE_NUM_END))

  • Related Language Record: CLASS_TBL_SLNG

    • # 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 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_VAL_TBL

    3 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Default Value: OPR_DEF_TBL_CS.SUBJECT

    Prompt Table: SUBJECT_TBL_VW

    4 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    5 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
    6 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 CRSE_ID_SRCH Character(6) VARCHAR2(6) NOT NULL Course ID
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CATALOG

    11 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

    Prompt Table: CRSE_OFFER

    12 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    13 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    Y=Read/Write Access
    14 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID