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.
In This Article
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
Some common joins include:
| Business Object | Relation | Notes |
|---|---|---|
| NetContactData | CsCommittee.iMIS Id = NetContactData.Id | |
| CsCommitteePosition | CsCommittee.Position = CsCommitteePosition.Position Code | Gets the position descriptive text and position rank for sorting. |
| CsCommitteeCode | CsCommittee.Committee Code = CsCommitteeCode.Code | Gets committee details from CsCommitteeCode. |
Properties
|
Properties |
|
|---|---|
| ActivityType | FromDate |
| CompanyID | ThruDate |
| ID | Other |
| CommitteeCode | LastUpdated |
| SequenceNumber | NoMail |
| Position | 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
Some common joins include:
| Business Object | Relation | Notes |
|---|---|---|
| CsCommitteeMember | CsCommitteeMember.Committee Product Code = CsCommitteeCode.Product Code | Gets committee membership and details |
Properties
| Properties | |
|---|---|
| Description | ProductCode |
| PaidThruValidation | Code |
| TheGroup | Status |
| Note | Title |
CsCommitteeMember
Contains committee member information. There are likely multiple rows per iMIS ID in this BO for each committee membership.
Common joins
Some common joins include:
| Business Object | Relation | Notes |
|---|---|---|
| CsCommitteeCode | CsCommitteeMember.Committee Product Code = CsCommitteeCode.Product Code | Gets committee member details. |
Properties
| Properties | ||
|---|---|---|
| BillingAddress | ID | Title |
| CommitteeDescription | Last_First | TollFreePhone |
| CommitteeGroup | MailingAddress | WorkPhone |
| CommitteeName | Note | ExcludeDirectory |
| CommitteeProductCode | Organization | Status |
| Position | Type | |
| Fax | PositionRank | CommitteeStatus |
| FullName | TermEnd | CommitteeMemberName |
| HomePhone | TermStart | GroupMemberDetailId |