SSR_PE_CRSAT_VW

(SQL View)
 Index Back

Course Attribute Value View

The Course Attribute Value Table defines the valid values within a Course Attribute. An attribute value must be assigned to each attribute a course is given.

SELECT CRSE_ATTR ,EFFDT ,CRSE_ATTR_VALUE ,DESCR ,DESCRFORMAL ,CATALOG_PRINT ,SCHEDULE_PRINT FROM PS_CRSE_ATTR_VALUE WHERE SCHEDULE_PRINT = 'Y'

  • Related Language Record: SSR_PE_CRSAT_LN

  • Parent record: CRSE_ATTR_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ATTR Character(4) VARCHAR2(4) NOT NULL Course Attribute
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 CRSE_ATTR_VALUE Character(10) VARCHAR2(10) NOT NULL Course Attribute Value
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field

    Default Value: CRSE_ATTR_VALUE.DESCR

    6 CATALOG_PRINT Character(1) VARCHAR2(1) NOT NULL Catalog Print

    Y/N Table Edit

    Default Value: Y

    7 SCHEDULE_PRINT Character(1) VARCHAR2(1) NOT NULL Schedule Print
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N