CRSE_COMP_VW3

(SQL View)
 Index Back

Course Catalog Component View2


SELECT CRSE_ID , EFFDT , SSR_COMPONENT , OPTIONAL_SECTION 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
    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