SSR_CRSE_DEL_ES

(SQL Table)
 Index Back

Course Offer ES Delete

Elastic Search delete record for Course Offer.

  • Related Language Record: SSR_CRS_DEL_LNG

    • # 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 SSR_CRSE_TOPIC_ES Character(30) VARCHAR2(30) NOT NULL Course Topic
    9 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    10 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    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
    22 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    23 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values