CLASS_SRCH_B

(SQL View)
 Index Back

Class Search Detail

Class table scoll

SELECT A.CRSE_ID ,A.CRSE_OFFER_NBR ,A.STRM ,A.SESSION_CODE ,A.CLASS_SECTION ,A.CLASS_NBR ,A.INSTITUTION ,A.SUBJECT ,A.CATALOG_NBR ,A.DESCR ,A.SSR_COMPONENT ,A.CLASS_STAT ,A.CLASS_TYPE ,A.ENRL_STAT ,A.ENRL_TOT ,A.ENRL_CAP ,A.WAIT_TOT ,A.WAIT_CAP ,A.CRS_TOPIC_ID ,A.CONSENT ,A.ACAD_CAREER ,A.CAMPUS ,A.LOCATION ,C.MEETING_TIME_START ,C.MEETING_TIME_END ,C.STND_MTG_PAT ,C.MON ,C.TUES ,C.WED ,C.THURS ,C.FRI ,C.SAT ,C.SUN ,C.FACILITY_ID FROM PS_CLASS_TBL A ,PS_CLASS_MTG_PAT C WHERE A.CRSE_ID = C.CRSE_ID AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND A.STRM = C.STRM AND A.SESSION_CODE = C.SESSION_CODE AND A.CLASS_SECTION = C.CLASS_SECTION

  • Related Language Record: CLASSSRCHBLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    3 STRM Character(4) VARCHAR2(4) NOT NULL Term
    4 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2
    5 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    6 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    8 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    9 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
    CLN=Clinical
    CON=Continuance
    DIS=Discussion
    FLD=Field Studies
    IND=Independent Study
    LAB=Laboratory
    LEC=Lecture
    PRA=Practicum
    RSC=Research
    SEM=Seminar
    SUP=Supervision
    THE=Thesis Research
    TUT=Tutorial
    12 CLASS_STAT Character(1) VARCHAR2(1) NOT NULL Class Status
    A=Active
    S=Stop Further Enrollment
    T=Tentative Section
    X=Cancelled Section
    13 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
    E=Enrollment Section
    N=Non-Enrollment Section
    14 ENRL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Status
    C=Closed
    O=Open
    W=Wait List
    15 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    16 ENRL_CAP Number(4,0) SMALLINT NOT NULL Enrollment Capacity
    17 WAIT_TOT Number(4,0) SMALLINT NOT NULL Wait List Total
    18 WAIT_CAP Number(4,0) SMALLINT NOT NULL Wait List Capacity
    19 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    20 CONSENT Character(1) VARCHAR2(1) NOT NULL Used by Course Catalog, Class Table, and Class Permissions.
    D=Department Consent Required
    I=Instructor Consent Required
    N=No Special Consent Required
    21 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
    22 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    23 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    24 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
    25 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time
    26 STND_MTG_PAT Character(4) VARCHAR2(4) NOT NULL Standard Meeting Pattern
    27 MON Character(1) VARCHAR2(1) NOT NULL Monday
    28 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday
    29 WED Character(1) VARCHAR2(1) NOT NULL Wednesday
    30 THURS Character(1) VARCHAR2(1) NOT NULL Thursday
    31 FRI Character(1) VARCHAR2(1) NOT NULL Friday
    32 SAT Character(1) VARCHAR2(1) NOT NULL Saturday
    33 SUN Character(1) VARCHAR2(1) NOT NULL Sunday
    34 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID