Events Business Objects
The following Events 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.
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
- CsRegistration.Event Code = CsEvent.Event Code
- CsFunction.Event Code = CsEvent.Event Code
Properties
- Address1
- Address2
- Address3
- BeginDate
- City
- ContactId
- Coordinators
- Country
- Description
- Directions
- EarlyCutoff
- EmailRegistration
- EndDate
- Attendees
- IsFrMeeting
- LateCutoff
- MaxRegistrants
- MeetAppeal
- MeetCampaign
- EventCode
- MeetingImageName
- MeetingType
- MeetingUrl
- Notes
- EntityCode
- RegCutoff
- StateProvince
- Status
- Title
- TotalCancelations
- TotalRegistrants
- TotalRevenue
- WebEnabled
- WebViewOnly
- Zip
- PublishEndDate
- PublishStartDate
- RegistrationEndDate
- RegistrationStartDate
- FormDefinitionId
- FormDefinitionSectionId
- MUF_1
- MUF_2
- MUF_3
- MUF_4
- MUF_5
- MUF_6
- MUF_7
- MUF_8
- MUF_9
- MUF_10
- Suppress_Dir
- Suppress_Notes
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
- CsEventHistory.ID = NetContactData.Id
Properties
- ActivityType
- Fees
- CompanyId
- Event
- ID
- EventCode
- SequenceNumber
- SourceCode
- EventDate
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
- CsFunction.Event Code = CsEvent.Event Code
Properties
- DeferredIncomeAccount
- FunctionDescription
- DefaultIncomeAccount
- DefaultEarlyFees
- DefaultRegularFees
- DefaultLateFees
- ProductCode
- EventCode
- FunctionCode
- PSTTaxable
- Status
- VatTaxAuthority
- GSTTaxable
- FairMarketValue
- Title
- ActualAttendance
- AutomaticOption
- BeginDate
- CeuAmount
- CeuEntered
- CeuType
- ConflictCode
- EndDate
- ExpectedAttendance
- FunctionType
- GuaranteedAttendance
- LastTicket
- MaximumAttendance
- MinimumAttendance
- Parent
- PrintTicket
- SequenceNumber
- Settings
- WebEnabled
- TotalFees
- TotalRegistrants
- EventCategory
- EventTrack
- IsEventRegistrationOption
- IsFundraising
- AvailableTo
- FormDefinitionSectionId
- MaxQtyPerRegistrant
- TearDownDateTime
- 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
- CsFunctionFees.ProductCode = CsFunction.ProductCode
- Gets pricing details about a specific function. Filter on product code to see pricing for a specific function.
Properties
- Complimentary
- RegistrantClass
- IncomeAccount
- ProductCode
- EarlyFees
- RegularFees
- LateFees
- RuleType
CsRegistrantClasses
Contains registrant classes for events.
Common joins
- CsRegistrantClasses.RegistrantClass = CsRegistration.RegistrantClass
- Gets the descriptive text of a type as opposed to the code.
Properties
- Description
- LongDescription
- RegistrantClass
CsRegistration
Contains registration data for events. One row per Registration, with multiple rows per iMIS ID likely.
Common joins
- CsRegistration.Order Number = CsOrder.Order Number
- CsRegistration.Event Code = CsEvent.Event Code
- CsRegistration.Order Number = EvenRegistrationReport.Order Number
- CsRegistration.Ship To Id = NetContactData.Id
- CsRegistration.Order Number = CsRegFunction.Order Number
Properties
- Balance
- BillToId
- Company
- CompanyMemberType
- CompanySort
- EventCode
- FullName
- LastFirst
- LineTaxable
- LineTotal
- MemberType
- OrderDate
- OrderNumber
- OrderTypeCode
- RegistrantClass
- ShipToId
- Status
- TotalCharges
- TotalPayments
- CompanyId
- ParentOrderNumber
- RegisteredByID
- TotalRegistered
- TotalWaitlisted
- ConfirmationIsSent
- ConfirmationSentDateTime
- 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
- CsRegFunction.OrderNumber = CsOrders.OrderNumber
- Gets details of an order.
- CsRegFunction.ProductCode = CsFunction.ProductCode
- Gets details of a function.
- CsRegFunction.ST_ID = NetContactData.Id
- Gets details about a registrant.
Properties
- BillToId
- Company
- CompanySort
- Description
- ExtendedAmount
- FullName
- IncomeAccount
- InvoiceDate
- InvoiceNumber
- InvoiceReferenceNumber
- IsFrOrder
- Note
- OrderDate
- OrderNumber
- ProductCode
- QuantityOrdered
- RegisteredQuantity
- ShipToId
- Status
- Tax1
- TaxRate
- UnitPrice
- WaitlistedQuantity
- AddedToWaitlist
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.
NoteFor ease of use, EventQuestion and EventQuestionResponse should used in place of FormDefinitionFieldData and FormFieldResponseData.
See Reporting on event questions for an example.
Common joins
- EventQuestion.Event Code = CsRegistration.Event Code
- EventQuestionResponse.Registrant Id = NetContactData.Id
- FormDefinitionFieldData.Form Definition Field Id = FormFieldResponseData.Form Definition Field Id
- FormDefinitionFieldData.Form Definition Id = CsEvent.Form Definition Id
- FormFieldResponseData.Id = NetContactData.Id
EventQuestion properties
The EventQuestion business object also includes properties from the FormDefinitionFieldData and CsFunction business objects.
- Meet_Master
- MEETING
- ADDRESS_1
- ALLOW_REG_EDIT
- BEGIN_DATE
- COMP_REG_REG_CLASS
- COUNTRY
- DEFAULT_PROGRAM_ITEM_DISPLAY_MODE
- DISPLAY_FUNCTION_AVAILABILITY
- ENABLE_TIME_CONFLICTS
- FORM_DEFINITION_SECTION_ID
- Image_Description
- LATE_CUTOFF
- MEET_APPEAL
- MEETING_IMAGE_NAME
- MUF_1
- MUF_3
- MUF_6
- MUF_9
- POST_REGISTRATION
- REG_CLASS_STORED_PROC
- REG_OTHERS
- REGISTRATION_START_DATE
- STATUS
- SUPPRESS_DIR
- TAX_BY_ADDRESS
- TIME_ZONE_ID
- TOTAL_REVENUE
- VAT_RULESET
- WEB_DESC
- VEB_VIEW_ONLY
- TITLE
- ADDRESS_2
- ALLOW_REG_STRING
- CITY
- CONTACT_ID
- CREATEAD_BY
- DESCRIPTION
- EARLY_CUTOFF
- END_DATE
- HEAD_COUNT
- INTENT_TO_EDIT
- LOGO
- MEET_CAMPAIGN
- MEETING_TYPE
- MUF_10
- MUF_4
- MUF_7
- NOTES
- PUBLISH_END_DATE
- REG_CUTOFF
- REGISTRATION_CLOSED_MESSAGE
- SQUARE_FOOT_RULES
- SUPPRESS_CONFIRM
- SUPPRESS_NOTES
- TEMPLATE_STATE_CODE
- TOTAL_CANCELATIONS
- UPDATED_BY
- VirtualMeetingUrl
- WEB_ENABLED
- ZIP
- ADD_GUESTS
- ADDRESS_3
- ALLOW_REGISTRANT_CONFICTS
- COMP_REG_CALCULATION
- COORDINATORS
- CREATED_ON
- DIRECTIONS
- EMAIL_REGISTRATION
- FORM_DEFINITION_ID
- HIDE_TIME_ZONE
- IS_FR_MEET
- MAX_REGISTRANTS
- MEET_CATEGORY
- MEETING_URL
- MUF_2
- MUF_5
- MUF_8
- ORG_CODE
- PUBLISH_START_DATE
- REG_EDIT_CUTOFF
- REGISTRATION_END_DATE
- STATE_PROVINCE
- SUPPRESS_COOR
- TAX_AUTHORITY_1
- TIME_STAMP
- TOTAL_REGISTRANTS
- UPDATED_ON
- WAITLIST_PERMISSIONCODE
- WEB_REG_CLASS_METHOD
EventQuestionResponse properties
The EventQuestionResponse business also includes properties from the FormFieldReponseData business object.
- EventQuestion
- EventCode
- FunctionProductCode
- QuestionFormDefinitionId
- QuestionType
- EventTitle
- FunctionTitle
- QuestionId
- SectionId
- FunctionCode
- Question
- QuestionSequence
- SectionSequence
FormDefinitionFieldData properties
- Form Definition Field Caption
- Form Definition Field Type
- Form Definition Section Sequence
- Form Definition Field Id
- Form Definition Id
- Form Definition Field Sequence
- Form Definition Section Id
FormFieldResponseData properties
- Field Boolean Value
- Field Integer Value
- Form Definition Field Id
- Id
- Field Date Time Value
- Field String Value
- Form Response Field Id
- Response
- Field Decimal Value
- Form Definition Field Caption
- Form Response Id