RAE_EVENT

(SQL Table)
 Index Back

Marketing Event Record

Stores all Marketing Event program information, such as name, start and end dates, relationship to a parent (roll up), overall status, objective and description. .

  • Related Language Record: RAE_EVENT_LANG

  • Audit Record: RA_CMPGN_AUDIT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

    Prompt Table: SP_BU_RA_NONVW

    2 RAE_EVENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.

    Default Value: NEXT

    3 RAE_EVENT_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 RA_ROLLUP_CMPGN_ID Character(15) VARCHAR2(15) NOT NULL Campaign - Roll Up (Parent) Campaign Identification

    Prompt Table: RA_PGM_ROLUP_VW

    6 RAE_EVENTSTATUS_CD Character(4) VARCHAR2(4) NOT NULL Valid Campaign and Wave Status Codes
    APPR=Approved
    CMPL=Completed
    DCLN=Declined
    EXEC=Executing
    IREV=In Review
    NEW=New
    STOP=Stopped

    Default Value: NEW

    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Default Value: BUS_UNIT_TBL_RA.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    8 START_DATE Date(10) DATE NOT NULL Campaign Start Date
    9 START_TIME Time(15) TIMESTAMP Start of Shift
    10 END_DATE Date(10) DATE NOT NULL End date field to store an end date.
    11 END_TIME Time(15) TIMESTAMP End of Shift
    12 RAE_RSVP_DATE Date(10) DATE Sub Event - RSVP Date
    13 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    14 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
    15 BO_ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID
    16 RA_OBJECTIVE_CD Character(4) VARCHAR2(4) NOT NULL Objective code of the campaign

    Prompt Table: RA_UD_CMPGN_OBJ

    17 RAE_PRIVATE_YN Character(1) VARCHAR2(1) NOT NULL Private or Public switch indicator
    N=No
    Y=Yes

    Default Value: N

    18 RAE_CAPACITY Number(9,0) DECIMAL(9) NOT NULL Events / Sub Events Capacity field
    19 BO_ID_COMPANY Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    20 BO_ROLE_TYPE_ID_2 Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID_2
    21 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    22 BO_ROLE_TYPE_ID_4 Number(12,0) DECIMAL(12) NOT NULL ROLE TYPE ID 4
    23 BO_ID_ORG Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    24 BO_ROLE_TYPE_ID_6 Number(12,0) DECIMAL(12) NOT NULL ROLE TYPE ID 6
    25 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID

    Prompt Table: RAE_AUD_070_VW

    26 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

    Prompt Table: RAE_DIALOG_VW

    27 RA_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Content ID

    Prompt Table: RA_CONTENT

    28 RAE_SUBEVENT_TYPE Character(4) VARCHAR2(4) NOT NULL Events - sub events - event types
    A001=Auction
    B001=Break
    B002=Benefit
    B003=Breakfast
    C001=Conference
    C002=Conference Call
    D001=Demonstration
    D002=Dinner
    D003=Drinks
    E001=Entertainment
    F001=Fundraiser
    K001=Keynote
    L001=Lecture
    L002=Lunch
    M001=Meeting
    P001=Panel
    P002=Presentation
    PC01=Partner Conference
    R001=Recreation
    S001=Seminar
    T001=Tradeshow
    V001=VIP Event
    W001=Workshop
    29 RAE_FEE_AMOUNT Number(9,2) DECIMAL(8,2) NOT NULL Fee amount for events and participant fees
    30 BO_ID_RECIPIENT Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    31 BO_ROLE_TYPE_ID_3 Number(12,0) DECIMAL(12) NOT NULL Role Type id 3
    32 RAE_SECURE_EVT Character(1) VARCHAR2(1) NOT NULL Checkbox for securing Event.
    N=No
    Y=Yes

    Default Value: N

    33 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.

    Prompt Table: INSTITUTION_TBL

    34 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic career field coming from campus solution system.
    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
    35 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL stores information about term attending.

    Prompt Table: TERM_TBL

    36 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    37 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    38 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    39 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    40 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    41 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time