Added
false
207
114
Committee Mailing List
List of active committee members for a single committee with address and contact information. Click Edit Query to enter/change Committee Name filter.
Select
CommitteeMember_ProfileID As 'Committee Member Profile ID', Profile_View_Profile_Prefix As 'Profile Prefix', Profile_View_Profile_FirstName As 'Profile First Name', Profile_View_Profile_Mi As 'Profile Middle Initial', Profile_View_Profile_LastName As 'Profile Last Name', Profile_View_Profile_Suffix As 'Profile Suffix', OrgProfile_View_Profile_ReportName As 'Organization Profile Report Name', Profile_View_Profile_Title As 'Profile Title', Profile_View_Profile_Address1 As 'Profile Address 1', Profile_View_Profile_Address2 As 'Profile Address 2', Profile_View_Profile_City As 'Profile City', Profile_View_Profile_State As 'Profile State', Profile_View_Profile_Zip As 'Profile Zip', Profile_View_Profile_ZipExt As 'Profile Zip Extension', OrgProfile_View_ProfileAddress_MailingAddress1 As 'Organization Profile Mailing Address 1', OrgProfile_View_ProfileAddress_MailingAddress2 As 'Organization Profile Mailing Address 2', OrgProfile_View_ProfileAddress_MailingCity As 'Organization Profile Mailing City', OrgProfile_View_ProfileAddress_MailingState As 'Organization Profile Mailing State', OrgProfile_View_ProfileAddress_MailingZip As 'Organization Profile Mailing Zip', OrgProfile_View_ProfileAddress_MailingZipExt As 'Organization Profile Mailing Zip Extension', Profile_View_Profile_WorkPhone As 'Profile Work Phone', Profile_View_Profile_Email As 'Profile Email'
From
ProfileCommittees_View
Where
(Committee_Name = 'Board of Directors' And CommitteeMember_Active = 1)
Order By
Profile_View_Profile_LastName Asc
2016-10-05T16:23:11
2016-10-05T16:23:12
lbashaw
ProfileCommittees_View
false
0
false
Unchanged
false
0
0
false
Daily
1
1
false
2016-10-05T00:00:00-07:00
2016-10-05T00:00:00-07:00
false
false
0
Unchanged
false
0
0
1900-01-01T00:00:00
1900-01-01T00:00:00
0
false
0
false
1900-01-01T00:00:00
1900-01-01T00:00:00
0
0
false
false
false
0
Unchanged
false
0
0
1900-01-01T00:00:00
1900-01-01T00:00:00
0
false
0
false
1900-01-01T00:00:00
1900-01-01T00:00:00
0
0
false
false
Added
false
ProfileCommittees_View
CommitteeMember_ProfileID
Committee Member Profile ID
System.Int32
4
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_Prefix
Profile Prefix
System.String
100
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_FirstName
Profile First Name
System.String
200
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_Mi
Profile Middle Initial
System.String
20
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_LastName
Profile Last Name
System.String
200
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_Suffix
Profile Suffix
System.String
100
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
OrgProfile_View_Profile_ReportName
Organization Profile Report Name
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_Title
Profile Title
System.String
200
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_Address1
Profile Address 1
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_Address2
Profile Address 2
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_City
Profile City
System.String
200
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_State
Profile State
System.String
100
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_Zip
Profile Zip
System.String
100
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_ZipExt
Profile Zip Extension
System.String
20
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
OrgProfile_View_ProfileAddress_MailingAddress1
Organization Profile Mailing Address 1
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
OrgProfile_View_ProfileAddress_MailingAddress2
Organization Profile Mailing Address 2
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
OrgProfile_View_ProfileAddress_MailingCity
Organization Profile Mailing City
System.String
200
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
OrgProfile_View_ProfileAddress_MailingState
Organization Profile Mailing State
System.String
100
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
OrgProfile_View_ProfileAddress_MailingZip
Organization Profile Mailing Zip
System.String
100
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
OrgProfile_View_ProfileAddress_MailingZipExt
Organization Profile Mailing Zip Extension
System.String
20
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_WorkPhone
Profile Work Phone
System.String
100
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Profile_View_Profile_Email
Profile Email
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
Committee_Name
Committee Active Checkbox
System.String
1
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
Modified
false
true
Board of Directors
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
ProfileCommittees_View
CommitteeMember_Active
Committee Active Checkbox
System.Boolean
1
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Modified
false
False
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1
Modified
false
ProfileCommittees_View
Profile_View_Profile_LastName
Profile Email
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-05T00:00:00-07:00
0
0
Ascending
AndJoin
1