Events Business Objects

Related videos

The following Membership business objects are commonly used in events-related queries. Review the descriptions to see how each can be joined with other business objects and what properties they include.

In This Article 

CsEvent

Contains event-level setup details. Returns one row per event. Summary data for Total Cancellations, Total Registrants and Total Revenue is available on this business object.

Common joins

Some common joins include:

Table 25: Viewing common joins for CsEvent
Business Object Relation
CsRegistration CsRegistration.Event Code = CsEvent.Event Code
CsFunction CsFunction.Event Code = CsEvent.Event Code

Properties

Table 26: Viewing properties for CsEvent
  Properties
Address1 IsFrMeeting Title MUF_2
Address2 LateCutoff TotalCancelations MUF_3
Address3 MaxRegistrants TotalRegistrants MUF_4
BeginDate MeetAppeal TotalRevenue MUF_5
City MeetCampaign WebEnabled MUF_6
ContactId EventCode WebViewOnly MUF_7
Coordinators MeetingImageName Zip MUF_8
Country MeetingType PublishEndDate MUF_9
Description MeetingUrl PublishStartDate MUF_10
Directions Notes RegistrationEndDate Suppress_Dir
EarlyCutoff EntityCode RegistrationStartDate Suppress_Notes
EmailRegistration RegCutoff FormDefinitionId  
EndDate StateProvince FormDefinitionSectionId  
Attendees Status MUF_1  

CsEventHistory

Contains event history information. There are likely multiple rows per iMIS ID in this BO, meaning one row for each event registration.

Common joins

Some common joins include:

Table 27: Viewing common joins for CsEventHistory
Business Object Relation
NetContactData CsEventHistory.ID = NetContactData.Id

Properties

Table 28: Viewing properties for CsEventHistory
Properties
ActivityType EventCode
Fees SequenceNumber
CompanyId SourceCode
Event EventDate
ID  

CsFunction

Contains function level details about an event. Summary data for Total Registrants and Total fees are available on this business object. There are likely multiple rows per Event in this BO, one row for each function in an event. Filter based on Event Code to get functions related to a specific event.

Common joins

Some common joins include:

Table 29: Viewing common joins for CsFunction
Business Object Relation
CsEvent CsFunction.Event Code = CsEvent.Event Code

Properties

Table 30: Viewing properties for CsFunction
Properties
DeferredIncomeAccount ActualAttendance PrintTicket
FunctionDescription AutomaticOption SequenceNumber
DefaultIncomeAccount BeginDate Settings
DefaultEarlyFees CeuAmount WebEnabled
DefaultRegularFees CeuEntered TotalFees
DefaultLateFees CeuType TotalRegistrants
ProductCode ConflictCode EventCategory
EventCode EndDate EventTrack
FunctionCode ExpectedAttendance IsEventRegistrationOption
PSTTaxable FunctionType IsFundraising
Status GuaranteedAttendance AvailableTo
VatTaxAuthority LastTicket FormDefinitionSectionId
GSTTaxable MaximumAttendance MaxQtyPerRegistrant
FairMarketValue MinimumAttendance TearDownDateTime
Title Parent SetupDateTime

CsFunctionFees

Contains pricing information for an event function. There are likely multiple rows per function in this BO, one row for each reg class with pricing on a function.

Common joins

Some common joins include:

Table 31: Viewing common joins for CsFunctionFees
Business Object Relation Notes
CsFunction CsFunctionFees.ProductCode = CsFunction.ProductCode Gets pricing details about a specific function. Filter on product code to see pricing for a specific function.

Properties

Table 32: Viewing properties for CsFunctionFees
Properties
Complimentary EarlyFees
RegistrantClass RegularFees
IncomeAccount LateFees
ProductCode RuleType

CsRegistrantClasses

Contains registrant classes for events.

Common joins

Some common joins include:

Table 33: Viewing common joins for CsRegistrantClasses
Business Object Relation Notes
CsRegistration CsRegistrantClasses.RegistrantClass = CsRegistration. RegistrantClass Gets the descriptive text of a type as opposed to the code.

Properties

Table 34: Viewing properties for CsRegistrantClasses
Properties
Description
LongDescription
RegistrantClass

CsRegistration

Contains registration data for events. One row per Registration, with multiple rows per iMIS ID likely.

Common joins

Some common joins include:

Table 35: Viewing common joins for CsRegistration
Business Object Relation
CsOrder CsRegistration.Order Number = CsOrder.Order Number
CsEvent CsRegistration.Event Code = CsEvent.Event Code
EventRegistrationReport CsRegistration.Order Number = EvenRegistrationReport.Order Number
NetContactData CsRegistration.Ship To Id = NetContactData.Id
CsRegFunction CsRegistration.Order Number = CsRegFunction.Order Number

Properties

Table 36: Viewing properties for CsRegistration
  Properties
Balance LineTotal TotalPayments
BillToId MemberType CompanyId
Company OrderDate ParentOrderNumber
CompanyMemberType OrderNumber RegisteredByID
CompanySort OrderTypeCode TotalRegistered
EventCode RegistrantClass TotalWaitlisted
FullName ShipToId ConfirmationIsSent
LastFirst Status ConfirmationSentDateTime
LineTaxable TotalCharges IsActiveRegistration

CsRegFunctions

Contains function level registration information. There are likely to be multiple rows per registration, one row per registered function, plus multiple rows per ID representing different event registrations.

Common joins

Some common joins include:

Table 37: Viewing common joins for CsRegFunctions
Business Object Relation Notes
CsOrders CsRegFunction.OrderNumber = CsOrders.OrderNumber Gets details of an order.
CsFunction CsRegFunction.ProductCode = CsFunction.ProductCode Gets details of a function.
NetContactData CsRegFunction.ST_ID = NetContactData.Id Gets details about a registrant.

Properties

Table 38: Viewing properties for CsRegFunctions
Properties
BillToId InvoiceReferenceNumber RegisteredQuantity
Company IsFrOrder ShipToId
CompanySort Note Status
Description OrderDate Tax1
ExtendedAmount OrderNumber TaxRate
FullName ProductCode UnitPrice
IncomeAccount ExtendedAmount WaitlistedQuantity
InvoiceDate InvoiceReferenceNumber AddedToWaitlist
InvoiceNumber QuantityOrdered  

Event questions

  • EventQuestion - Event questions are stored in this business object.
  • EventQuestionResponse - Responses to event questions are stored in this business object.
  • FormDefinitionFieldData - Event questions are stored in this business object.
  • FormFieldResponseData - Responses to event questions are stored in this business object.

Note: For ease of use, EventQuestion and EventQuestionResponse should used in place of FormDefinitionFieldData and FormFieldResponseData.

See Reporting on event questions for an example.

Common Joins

Use the following common joins with these two business objects:

Table 39: Viewing common joins for FormDefinitionFieldData and FormFieldResponseData
Business Object 1 Business Object 2 Relation
EventQuestion CsRegistration EventQuestion.Event Code = CsRegistration.Event Code
EventQuestionResponse NetContactData EventQuestionResponse.Registrant Id = NetContactData.Id
FormDefinitionFieldData FormFieldResponseData FormDefinitionFieldData.Form Definition Field Id = FormFieldResponseData.Form Definition Field Id

CsEvent

 FormDefinitionFieldData FormDefinitionFieldData.Form Definition Id = CsEvent.Form Definition Id
NetContactData FormFieldResponseData FormFieldResponseData.Id = NetContactData.Id

eventquestion properties

Th EventQuestion business object also includes properties from the FormDefinitionFieldData and CsFunction business objects.

Table 40: Viewing properties for FormDefinitionFieldData
  Properties
Meet_Master
MEETING TITLE ADD_GUESTS
ADDRESS_1 ADDRESS_2 ADDRESS_3
ALLOW_REG_EDIT ALLOW_REG_STRING ALLOW_REGISTRANT_CONFICTS
BEGIN_DATE CITY COMP_REG_CALCULATION
COMP_REG_REG_CLASS CONTACT_ID COORDINATORS
COUNTRY CREATEAD_BY CREATED_ON
DEFAULT_PROGRAM_ITEM_DISPLAY_MODE DESCRIPTION DIRECTIONS
DISPLAY_FUNCTION_AVAILABILITY EARLY_CUTOFF EMAIL_REGISTRATION
ENABLE_TIME_CONFLICTS END_DATE FORM_DEFINITION ID
FORM_DEFINITION_SECTION ID HEAD_COUNT HIDE_TIME_ZONE
Image_Description INTENT_TO_EDIT IS_FR_MEET
LATE_CUTOFF LOGO MAX_REGISTRANTS
MEET_APPEAL MEET_CAMPAIGN MEET_CATEGORY
MEETING_IMAGE_NAME MEETING_TYPE MEETING_URL
MUF_1 MUF_10 MUF_2
MUF_3 MUF_4 MUF_5
MUF_6 MUF_7 MUF_8
MUF_9 NOTES ORG_CODE
POST_REGISTRATION PUBLISH_END_DATE PUBLISH_START_DATE
REG_CLASS_STORED_PROC REG_CUTOFF REG_EDIT_CUTOFF
REG_OTHERS REGISTRATION_CLOSED_MESSAGE REGISTRATION_END_DATE
REGISTRATION_START_DATE SQUARE_FOOT_RULES STATE_PROVINCE
STATUS SUPPRESS_CONFIRM SUPPRESS_COOR
SUPPRESS_DIR SUPPRESS_NOTES TAX_AUTHORITY_1
TAX_BY_ADDRESS TEMPLATE_STATE_CODE TIME_STAMP
TIME_ZONE_ID TOTAL_CANCELATIONS TOTAL_REGISTRANTS
TOTAL_REVENUE UPDATED_BY UPDATED_ON
VAT_RULESET VirtualMeetingUrl WAITLIST_PERMISSIONCODE
WEB_DESC WEB_ENABLED WEB_REG_CLASS_METHOD
VEB_VIEW_ONLY ZIP  

eventquestionresponse properties

The EventQuestionResponse business also includes properties from the FormFieldReponseData business object.

Table 41: Viewing properties for FormDefinitionFieldData
  Properties
EventQuestion
EventCode EventTitle FunctionCode
FunctionProductCode FunctionTitle Question
QuestionFormDefinitionId QuestionId QuestionSequence
QuestionType SectionId SectionSequence

FormDefinitionFieldData properties

Table 42: Viewing properties for FormDefinitionFieldData
  Properties
Form Definition Field Caption Form Definition Field Id Form Definition Field Sequence
Form Definition Field Type Form Definition Id Form Definition Section Id
Form Definition Section Sequence    

FormFieldResponseData properties

Table 43: Viewing properties for FormDefinitionFieldData
  Properties
Field Boolean Value Field Date Time Value Field Decimal Value
Field Integer Value Field String Value Form Definition Field Caption
Form Definition Field Id Form Response Field Id Form Response Id
Id Response