CRSE_COMP_VW2

(SQL View)
 Index Back

Course Catalog Component View2


SELECT CRSE_ID , EFFDT , SSR_COMPONENT , OPTIONAL_SECTION , DEFAULT_SECT_SIZE , CONTACT_HOURS , FINAL_EXAM , EXAM_SEAT_SPACING , DYN_DT_INCLUDE , AUTO_CREATE_CMPNT , ATTEND_GENERATE , WEEK_WORKLOAD_HRS FROM PS_CRSE_COMPONENT

  • Parent record: CRSE_CATALOG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CATALOG

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 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
    4 OPTIONAL_SECTION Character(1) VARCHAR2(1) NOT NULL Optional Component

    Y/N Table Edit

    Default Value: N

    5 DEFAULT_SECT_SIZE Number(3,0) SMALLINT NOT NULL Default Section Size

    Default Value: INSTALLATION_SA.DEFAULT_SECT_SIZE

    6 CONTACT_HOURS Number(8,3) DECIMAL(7,3) NOT NULL Instructor Contact Hours
    7 FINAL_EXAM Character(2) VARCHAR2(2) NOT NULL Final Exam
    L=Last Class Meeting
    N=No
    Y=Yes
    8 EXAM_SEAT_SPACING Number(1,0) SMALLINT NOT NULL Exam Seat Spacing

    Default Value: 1

    9 DYN_DT_INCLUDE Character(1) VARCHAR2(1) NOT NULL Include in Dynamic Date Calc

    Y/N Table Edit

    Default Value: N

    10 AUTO_CREATE_CMPNT Character(1) VARCHAR2(1) NOT NULL Auto Create Component

    Y/N Table Edit

    Default Value: N

    11 ATTEND_GENERATE Character(1) VARCHAR2(1) NOT NULL Generate Class Mtg Attendance

    Y/N Table Edit

    Default Value: N

    12 WEEK_WORKLOAD_HRS Number(6,2) DECIMAL(5,2) NOT NULL Weekly Workload Hours