CRSE_OFFER_SLNG

(SQL View)
 Index Back

Course Offer Security Search

CRSE_OFFER_SLNG is the related language view for the Schedule New Course security view CRSE_OFFER_SCTY. The acad org security logic has been removed from the related language view, since the logic already exists in the base view and there is no need to duplicate it. Joined to the SUBJECT_TBL to disallow the scheduling of an inactive subject.

SELECT B.INSTITUTION ,A.STRM ,B.SUBJECT ,B.CATALOG_NBR ,B.ACAD_CAREER ,B.CAMPUS ,D.OPRID ,C.CRSE_ID ,Z.LANGUAGE_CD ,Z.DESCR FROM PS_TERM_TBL A , PS_SUBJECT_TBL E , PS_CRSE_OFFER B , PS_CRSE_CATALOG C , PS_CRSE_CATLG_LNG Z , PS_OPR_DEF_TBL_CS D WHERE B.INSTITUTION = A.INSTITUTION AND B.ACAD_CAREER = A.ACAD_CAREER AND B.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CRSE_OFFER D1 WHERE D1.CRSE_ID = B.CRSE_ID AND D1.EFFDT <= A.TERM_BEGIN_DT) AND B.COURSE_APPROVED = 'A' AND B.SCHEDULE_COURSE = 'Y' AND B.INSTITUTION = E.INSTITUTION AND B.SUBJECT = E.SUBJECT AND E.EFF_STATUS <> 'I' AND E.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SUBJECT_TBL E1 WHERE E.INSTITUTION = E1.INSTITUTION AND E.SUBJECT = E1.SUBJECT AND E1.EFFDT <= A.TERM_BEGIN_DT) AND B.CRSE_ID = C.CRSE_ID AND B.EFFDT = C.EFFDT AND C.EFF_STATUS = 'A' AND C.CRSE_ID = Z.CRSE_ID AND C.EFFDT = Z.EFFDT

  • Related Language Record for CRSE_OFFER_SCTY

  • Parent record: ACAD_GROUP_TBL

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description