Committees Business Objects

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

CsCommittee

Contains specific committee participation history. There are likely multiple rows for this BO, making it multi-instance.

To get full details of a committee you will need to join multiple committee business objects. CsCommittee provides a limited subset of information. To filter who is active in a committee you must use two filters – using two fields together will automatically create an OR situation.

Common joins

  • CsCommittee.iMIS Id = NetContactData.Id
  • CsCommittee.Position = CsCommitteePosition.Position Code
    📘

    Note

    Gets the position descriptive text and position rank for sorting.

  • CsCommittee.Committee Code = CsCommitteeCode.Code
    📘

    Note

    Gets committee details from CsCommitteeCode.

Properties

  • ActivityType
  • CompanyID
  • ID
  • CommitteeCode
  • SequenceNumber
  • Position
  • FromDate
  • ThruDate
  • Other
  • LastUpdated
  • NoMail
  • Notes

CsCommitteeCode

Contains details about the configuration of committees including code, title, description, and group. This BO returns one row per committee and is used to return committee setup information.

To get full details of a committee you will need to join multiple committee business objects. CsCommitteeCode provides a limited subset of information.

Common joins

  • CsCommitteeMember.Committee Product Code = CsCommitteeCode.Product Code

Properties

  • Description
  • ProductCode
  • PaidThruValidation
  • Code
  • TheGroup
  • StatusNote
  • Title

CsCommitteeMember

Contains committee member information. There are likely multiple rows per iMIS ID in this BO for each committee membership.

Common joins

  • CsCommitteeMember.Committee Product Code = CsCommitteeCode.Product Code

Properties

  • BillingAddress
  • CommitteeDescription
  • CommitteeGroup
  • CommitteeName
  • CommitteeProductCode
  • Email
  • Fax
  • FullName
  • HomePhone
  • ID
  • Last_First
  • MailingAddress
  • Note
  • Organization
  • Position
  • PositionRank
  • TermEnd
  • TermStart
  • Title
  • TollFreePhone
  • WorkPhone
  • ExcludeDirectory
  • Status
  • Type
  • CommitteeStatus
  • CommitteeMemberName
  • GroupMemberDetailId