SUBJ_WORKLD_VW

(SQL View)
 Index Back

Subject Workload View

To use on a work panel. Show current rows only.

SELECT INSTITUTION ,SUBJECT ,EFFDT ,SSR_COMPONENT ,COMP_MULTIPLIER FROM PS_SUBJ_COMPONENT A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SUBJ_COMPONENT A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.SUBJECT = A.SUBJECT AND A1.SSR_COMPONENT = A.SSR_COMPONENT AND A1.EFFDT <= %CurrentDateIn)

  • Parent record: SUBJECT_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Default Value: SUBJECT_TBL.SUBJECT

    Prompt Table: SUBJECT_TBL

    3 ASOF_DATE Date(10) DATE NOT NULL This field is used all over campus solutions to hold the value of an as of date to be used in different processing.

    Default Value: %date

    4 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
    5 COMP_MULTIPLIER Number(3,0) SMALLINT NOT NULL Component Multiplier %

    Default Value: 100