SSR_CRS_GRP_HDR

(SQL Table)
Index Back

Course Group Header

Use this table to define and describe Course Groups.

  • Related Language Record: SSR_CRSGRP_H_LN
  • Parent Record Of SSR_CRSGRP_D_LN SSR_CRSGRP_SRCH SSR_CRSGRP_SRLN SSR_CRS_GRP_DTL SSR_CRS_GRP_FLD
  • # 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 SSR_CRS_GRP_ID Character(9) VARCHAR2(9) NOT NULL Course Group ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 END_EFFDT Date(10) DATE End Effdt
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 SSR_AUTO_PROCESS Character(1) VARCHAR2(1) NOT NULL If Y, will be picked up by the PE Block Enrollment process.

    Y/N Table Edit

    Default Value: Y

    8 SSR_FLTR_SBJ Character(1) VARCHAR2(1) NOT NULL Subject

    Y/N Table Edit

    Default Value: N

    9 SSR_FLTR_CAR Character(1) VARCHAR2(1) NOT NULL Career

    Y/N Table Edit

    Default Value: N

    10 SSR_FLTR_CMP Character(1) VARCHAR2(1) NOT NULL Campus

    Y/N Table Edit

    Default Value: N

    11 SSR_FLTR_ORG Character(1) VARCHAR2(1) NOT NULL Academic Organization

    Y/N Table Edit

    Default Value: N

    12 SSR_FLTR_AGR Character(1) VARCHAR2(1) NOT NULL Academic Group

    Y/N Table Edit

    Default Value: N

    13 SSR_FLTR_CAF Character(1) VARCHAR2(1) NOT NULL Academic Item Attribute

    Y/N Table Edit

    Default Value: N

    14 DESCRLONG Long Character CLOB Long Description
    15 SAA_WHERE_CLAUSE Long Character CLOB This field contains the where clause used in different processes in academic advisement.
    16 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    17 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    18 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    19 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time