LAM_CLS_ACT_VW2

(SQL View)
 Index Back

Learning Activity by Component

Gradebook: Class learning activities view to select for showing a single assignment on the gradebook.

SELECT STRM , CLASS_NBR , DUE_DT , SEQUENCE_NO , DESCR , DESCRSHORT FROM PS_LAM_CLASS_ACTV WHERE COPY_GRADES = 'Y'

  • Related Language Record: LAM_CLAS_ACT_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    2 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    3 DUE_DT_SRCH Date(10) DATE Due Date
    4 SEQ_NO_SRCH Number(3,0) SMALLINT NOT NULL Seq
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description