SSR_CRS_DEL_LNG

(SQL Table)
Index Back

Course Offer ES Del Rel Lang

Elastic Search related language delete record for Course Offer.

  • Related Language Record for SSR_CRSE_DEL_ES
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 CRSE_ATTR Character(4) VARCHAR2(4) NOT NULL Course Attribute
    5 CRSE_ATTR_VALUE Character(10) VARCHAR2(10) NOT NULL Course Attribute Value
    6 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    7 SSR_COMPO_DESCR_ES Character(30) VARCHAR2(30) NOT NULL Component Description
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 SSR_CRSE_TOPIC_ES Character(30) VARCHAR2(30) NOT NULL Course Topic
    10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    11 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    12 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    13 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    14 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    15 SSR_CRSE_TYPOFF_CD Character(10) VARCHAR2(10) NOT NULL Course Typically Offered
    16 SSR_GRADING_BASIS Character(30) VARCHAR2(30) NOT NULL Grading Basis
    17 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
    18 SSR_OEE_IND_DESCR Character(3) VARCHAR2(3) NOT NULL Open Entry/Exit Indicator Description
    19 SSR_CAREER_DESC_ES Character(30) VARCHAR2(30) NOT NULL Career Description
    20 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    21 SSR_ACAD_ORG_DESCR Character(30) VARCHAR2(30) NOT NULL Academic Organization Description