SSR_COMPONENTVW

(SQL View)
 Index Back

Course Component View

This record contains valid course component values used for prompting valid component values in activity management.

SELECT DISTINCT A.CRSE_ID , A.SSR_COMPONENT FROM PS_CRSE_COMPONENT A , PS_CRSE_CATALOG B WHERE A.CRSE_ID = B.CRSE_ID AND A.EFFDT = B.EFFDT

  • 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 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