CLASS_ASSOC

(SQL Table)
 Index Back

Class Associations

Class Associations stores data relating to Associated Class Sections. Class Sections within the same Course ID, Course Offer Number, Term and Session are grouped by setting their Associated Class to the same number. Class Associations entries are created as Class Sections are Scheduled.

  • Parent Record Of CLASS_CMPNT_VW CLASS_CMPNT_VW2 CLASS_COMPONENT SSR_ACM_COMP_VW

    • # 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 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    6 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    7 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    8 UNITS_ACAD_PROG Number(6,2) DECIMAL(5,2) NOT NULL Academic Progress Units
    9 UNITS_FINAID_PROG Number(6,2) DECIMAL(5,2) NOT NULL Financial Aid Progress Units
    10 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)

    Prompt Table: GRADE_BASE_D_VW

    11 GRADE_ROSTER_PRINT Character(1) VARCHAR2(1) NOT NULL Grade Roster Print
    C=Component
    I=By Instructor
    N=None
    S=By Student
    12 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
    13 BILLING_FACTOR Number(6,3) DECIMAL(5,3) NOT NULL Billing Factor
    14 CRSE_CONTACT_HRS Number(6,2) DECIMAL(5,2) NOT NULL Course Contact Hours
    15 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

    Prompt Table: RQ_GRP_ENR_VW

    16 USE_CATLG_RQS Character(1) VARCHAR2(1) NOT NULL Also Use Catalog Requisite

    Y/N Table Edit

    Default Value: Y

    17 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.

    Prompt Table: RQMNT_DESIG_TBL

    18 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
    19 INSTRUCTOR_EDIT Character(2) VARCHAR2(2) NOT NULL Instructor Edit
    C=Class Instructor Table Edit
    I=Instructor/Advisor Table Edit
    N=No Enrollment Choice
    20 USE_BLIND_GRADING Character(1) VARCHAR2(1) NOT NULL Use Blind Grading

    Y/N Table Edit

    Default Value: CRSE_OFFER.USE_BLIND_GRADING

    21 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group

    Prompt Table: SEL_GROUP_IN_VW

    22 COMPONENT_PRIMARY Character(3) VARCHAR2(3) NOT NULL Primary Component

    Prompt Table: XLAT_SA_VW

    23 UPDATE_STDNT_ENRL Character(1) VARCHAR2(1) NOT NULL Update Student Enrl

    Y/N Table Edit

    Default Value: N