• Replies 1 reply
  • Subscribers 412 subscribers
  • Views 62 views
  • Users 0 members are here
Related

Elevated Events without a Status

Ben Lasser
$organization

We recently discovered that at least one or two RSVPs for an elevated event had been taken without recording a "status."

We would love to double check that this didn't happen in more cases, but we're struggling to find a way to determine that, beyond manually looking at every individual consituent that was invited to the event. Here's what we have tried:

  1. the Event Listing report
  2. a few custom reports we use for events
  3. building a list using only that Event name
  4. Looking in the elevated event setup utility "Attendees" tab

 

In each case, the test account that we've put in without a status fails to show up. Does anyone out there know if there's a good way to pull a list of households associated with an event, even if that household has unintentionally not received an event status? Or does this have to be a manual operation?

Parents
  • $organization

    I guess the easiest is to do a manual edit in list manager and select from tx_event_extract.

    Example:

    select distinct customer_no
    from TX_EVENT_EXTRACT
    where inv_status is null  and reserve_ind = 'N' and campaign_no = ####

     

    TX_EVENT_EXTRACT
    The TX_EVENT_EXTRACT table contains one row for each patron invited, attending, etc. to an event.
    1.1.    Primary Key: evex_no
    1.2.    Columns:
    1.2.1.    evex_no int NOT NULL
    1.2.2.    campaign_no int NOT NULL (from t_campaign)
    1.2.3.    customer_no int NOT NULL (from t_customer)
    1.2.4.    source_no int NOT NULL (from tx_appeal_media_type)
    1.2.5.    inv_status int NULL (from tr_invitation_status
    1.2.5.1.    From tr_invitation_status, Currently:
    1.2.5.1.1.    1    Invited
    1.2.5.1.2.    2    Paid
    1.2.5.1.3.    3    Attending
    1.2.5.1.4.    4    Default
    1.2.6.    reserve_ind char (1) NULL
    1.2.7.    recd_amt money NULL
    1.2.8.    num_attendees int NULL
    1.2.9.    notes char (255) NULL
    1.2.10.    mir_lock int NULL (0 unless this event record is locked in a controlled batch)
    1.2.11.    created_by char (8) NOT NULL
    1.2.12.    create_dt datetime NOT NULL
    1.2.13.    last_updated_by char (8) NOT NULL
    1.2.14.    last_update_dt datetime NOT NULL
    1.2.15.    create_loc varchar (16) NULL

     

    You can clean this up to make it work for you, but that will give you the idea.

     

    Travis



    [edited by: Travis Armbuster at 3:28 PM (GMT -6) on 24 Feb 2017]
Reply
  • $organization

    I guess the easiest is to do a manual edit in list manager and select from tx_event_extract.

    Example:

    select distinct customer_no
    from TX_EVENT_EXTRACT
    where inv_status is null  and reserve_ind = 'N' and campaign_no = ####

     

    TX_EVENT_EXTRACT
    The TX_EVENT_EXTRACT table contains one row for each patron invited, attending, etc. to an event.
    1.1.    Primary Key: evex_no
    1.2.    Columns:
    1.2.1.    evex_no int NOT NULL
    1.2.2.    campaign_no int NOT NULL (from t_campaign)
    1.2.3.    customer_no int NOT NULL (from t_customer)
    1.2.4.    source_no int NOT NULL (from tx_appeal_media_type)
    1.2.5.    inv_status int NULL (from tr_invitation_status
    1.2.5.1.    From tr_invitation_status, Currently:
    1.2.5.1.1.    1    Invited
    1.2.5.1.2.    2    Paid
    1.2.5.1.3.    3    Attending
    1.2.5.1.4.    4    Default
    1.2.6.    reserve_ind char (1) NULL
    1.2.7.    recd_amt money NULL
    1.2.8.    num_attendees int NULL
    1.2.9.    notes char (255) NULL
    1.2.10.    mir_lock int NULL (0 unless this event record is locked in a controlled batch)
    1.2.11.    created_by char (8) NOT NULL
    1.2.12.    create_dt datetime NOT NULL
    1.2.13.    last_updated_by char (8) NOT NULL
    1.2.14.    last_update_dt datetime NOT NULL
    1.2.15.    create_loc varchar (16) NULL

     

    You can clean this up to make it work for you, but that will give you the idea.

     

    Travis



    [edited by: Travis Armbuster at 3:28 PM (GMT -6) on 24 Feb 2017]
Children
No Data