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

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

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
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

FormDefinitionFieldData properties

Table 40: 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 41: 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