GetDynamicQueryDefinition
|
Initial Build |
2007.01 |
|
xWEB |
Web Method |
|
Response Type |
XML Node |
This web method is a companion web method to GetDynamicQuery. This method provides additional information about ask-at-runtime parameters of a query. It can be used in a real-time application to define how a query is presented to a user, or it can be used for informational purposes during application development.
Parameters
| Name | Type | Occurs | Description |
|---|---|---|---|
| szObjectName | string | 1..1 |
The object name. You can obtain the name by using the GetFacadeObjectList method. |
| szQueryName | string | 1..1 | The name of the query. |
Response
The response for GetDynamicQueryDefinition gives you every ask-at-runtime parameter. The ParameterName must be passed back when you actually call GetDynamicQuery and set the Parameter/Name.
<ParameterName>bbcdb8c8-3811-4f6b-9549-4b92badeda9b_0</ParameterName>
The 36-character GUID corresponds to underlying application metadata for the query definition, and the integer counter suffix is a further internal definition.
Each <QueryParameter> node is an ask-at-runtime parameter. The additional elements in this node can be used to present a graphical user interface to a user who will want to call this method, or for the developer to understand what each parameter is when constructing an integration.
The request returns the following information:
- que_key - Key of the query
- que_description - the name of the query
- szObjectName - object of the query
- Parameters - a single node. The <Parameters> node contains one or more <QueryParameter> nodes.
- QueryParameter - the <QueryParameter> node contains the following elements:
- ParameterName - the name of the parameter. This must be passed back when calling GetDynamicQuery
- ParameterDescription - description of parameter
- Operator - see list above for operators
- ControlClass - the Control Class of the column. See Control Class for descriptions of these values.
- DataType - see Data Type for descriptions. Example: String, Integer, Date, etc.
- Description - the plain English Column description. Example, "First Name" is the description of the ind_first_name column.
- IsExtended - if this is a column in an Extender Table then true, else false.
- IsNullable - if nullable then true else false.
- Name - the underlying columnName.
If the parameter can contain a list of certain fixed values (that is, a DropDownList or ListBox) then the allowable values are listed within the <ListOptionCollection> node, as <Value> / <Text> pairs in one or more <ListOption> node(s). Whatever is in the <Value> element will need to be passed back in the Parameters/Parameter/Value element when GetDynamicQuery is called. The <Text> is the description of that particular code, which should be presented to an end-user.
- ListOptionCollection - a node containing one or more <ListOption> nodes.
- ListOption - a node that contains a <Value> and <Text> element.
- Value - the internal value; this needs to be passed back to the Parameter/Value in GetDynamicQuery.
- Text - the plain English value that should be shown to the end user.
In most cases, these <ListOption> values are derived from an underlying database table. For example, the Prefix codes (Mr., Mrs., Dr., etc.) are derived from the co_prefix database table. For these kinds of <ListOption> values, the following three addition elements are populated in the <QueryParameter> node:
- TableName - name of the Table from which the allowable values are drawn.
- TableDescription - plain English description of the table.
- TableAlias - alias of the table, if any, that drives the allowable values of the column. This might be blank.
Sample Request
Here is the request to get the definition of a specific query (within a particular object):
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ns="http://www.avectra.com/2005/">
<soapenv:Header>
<ns:AuthorizationToken>
<ns:Token>21ac575e-6f17-441e-9570-aba6cc263585</ns:Token>
</ns:AuthorizationToken>
</soapenv:Header>
<soapenv:Body>
<ns:GetDynamicQueryDefinition>
<ns:szObjectName>Individual</ns:szObjectName>
<ns:szQueryName>Individuals on Committee</ns:szQueryName>
</ns:GetDynamicQueryDefinition>
</soapenv:Body>
</soapenv:Envelope>
Sample Response
Here is the SOAP definition or the response. Note the repeating <QueryParameter> node(s) within the <Parameters> node.
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Header>
<AuthorizationToken xmlns="http://www.avectra.com/2005/">
<Token>string</Token>
</AuthorizationToken>
</soap:Header>
<soap:Body>
<GetDynamicQueryDefinitionResponse xmlns="http://www.avectra.com/2005/">
<GetDynamicQueryDefinitionResult>
<que_key>string</que_key>
<que_description>string</que_description>
<szObjectName>string</szObjectName>
<Parameters>
<QueryParameter>
<ParameterName>string</ParameterName>
<ParameterDescription>string</ParameterDescription>
<Operator>Like or NotLike or Equals or NotEquals or GreaterThan or LessThan or GreaterThanOrEqualTo or LessThanOrEqualTo or IsIn or IsNotIn or IsNull or IsNotNull or SoundsLike or BeginsWith or DoesNotBeginWith or Contains or DoesNotContain or EndsWith or DoesNotEndWith</Operator>
<ControlClass>string</ControlClass>
<DataType>string</DataType>
<Description>string</Description>
<IsExtended>boolean</IsExtended>
<IsNullable>boolean</IsNullable>
<Name>string</Name>
<TableAlias>string</TableAlias>
<TableDescription>string</TableDescription>
<TableName>string</TableName>
<ListOptionCollection xsi:nil="true" />
</QueryParameter>
<QueryParameter>
<ParameterName>string</ParameterName>
<ParameterDescription>string</ParameterDescription>
<Operator>Like or NotLike or Equals or NotEquals or GreaterThan or LessThan or GreaterThanOrEqualTo or LessThanOrEqualTo or IsIn or IsNotIn or IsNull or IsNotNull or SoundsLike or BeginsWith or DoesNotBeginWith or Contains or DoesNotContain or EndsWith or DoesNotEndWith</Operator>
<ControlClass>string</ControlClass>
<DataType>string</DataType>
<Description>string</Description>
<IsExtended>boolean</IsExtended>
<IsNullable>boolean</IsNullable>
<Name>string</Name>
<TableAlias>string</TableAlias>
<TableDescription>string</TableDescription>
<TableName>string</TableName>
<ListOptionCollection xsi:nil="true" />
</QueryParameter>
</Parameters>
</GetDynamicQueryDefinitionResult>
</GetDynamicQueryDefinitionResponse>
</soap:Body>
</soap:Envelope>
Example of a parameter that should contain a list of Events in a drop-down list:
<QueryParameter>
<ParameterName>e6b7af49-eb96-4db3-875e-9eef859d1d31_1</ParameterName>
<ParameterDescription>[Event Registrant::Event] Is Equal To [] (Ask At Run-Time)</ParameterDescription>
<Operator>Equals</Operator>
<ControlClass>DropDownList</ControlClass>
<DataType>av_key</DataType>
<Description>Event</Description>
<IsExtended>false</IsExtended>
<IsNullable>false</IsNullable>
<Name>reg_evt_key</Name>
<TableAlias/>
<TableDescription>Event Registrant</TableDescription>
<TableName>ev_registrant</TableName>
<ListOptionCollection>
<ListOption>
<Value>72db64c1-63d2-4f70-88cb-cc38003e0beb</Value>
<Text>2007 Government Affairs Conference</Text>
</ListOption>
<ListOption>
<Value>a55cba19-6f87-40b9-a488-0a5f84e390a7</Value>
<Text>2007 Annual Seminar</Text>
</ListOption>
<ListOption>
<Value>8309eaa5-a60b-43bb-9b7f-87b53d9c118f</Value>
<Text>2007 Leaders Summit</Text>
</ListOption>
</ListOptionCollection>
</QueryParameter>
If you were to render this result as a DropDownList to an end user, the html would be like this:
Event:
<select name = "e6b7af49-eb96-4db3-875e-9eef859d1d31_1">
<option value="" selected>-- Select --</option>
<option value="72db64c1-63d2-4f70-88cb-cc38003e0beb">2007 Government Affairs Conference</option>
<option value="a55cba19-6f87-40b9-a488-0a5f84e390a7">2007 Annual Seminar</option>
<option value="8309eaa5-a60b-43bb-9b7f-87b53d9c118f">2007 Leaders Summit</option>
</select>
Here is a complete sample response with some repeating nodes shortened for brevity:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soap:Header>
<AuthorizationToken xmlns="http://www.avectra.com/2005/">
<Token>975e0480-9b56-47d8-a936-4598eded3ae7</Token>
</AuthorizationToken>
</soap:Header>
<soap:Body>
<GetDynamicQueryDefinitionResponse xmlns="http://www.avectra.com/2005/">
<GetDynamicQueryDefinitionResult>
<que_key>40794c6e-a417-4c7c-859b-3bc580adbe5d</que_key>
<que_description>Individuals on Committee</que_description>
<szObjectName>Individual</szObjectName>
<Parameters>
<QueryParameter>
<ParameterName>bbcdb8c8-3811-4f6b-9549-4b92badeda9b_0</ParameterName>
<ParameterDescription>[Committee Participant::committee] Is Equal To [] (Ask At Run-Time)</ParameterDescription>
<Operator>Equals</Operator>
<ControlClass>DropDownList</ControlClass>
<DataType>av_key</DataType>
<Description>committee</Description>
<IsExtended>false</IsExtended>
<IsNullable>false</IsNullable>
<Name>cmc_cmt_key</Name>
<TableAlias/>
<TableDescription>Committee Participant</TableDescription>
<TableName>mb_committee_x_customer</TableName>
<ListOptionCollection>
<ListOption>
<Value>b9ae781c-b9c1-4636-a05c-f61835be49c2</Value>
<Text>Test Committee</Text>
</ListOption>
</ListOptionCollection>
</QueryParameter>
<QueryParameter>
<ParameterName>e6b7af49-eb96-4db3-875e-9eef859d1d31_1</ParameterName>
<ParameterDescription>[Event Registrant::Event] Is Equal To [] (Ask At Run-Time)</ParameterDescription>
<Operator>Equals</Operator>
<ControlClass>DropDownList</ControlClass>
<DataType>av_key</DataType>
<Description>Event</Description>
<IsExtended>false</IsExtended>
<IsNullable>false</IsNullable>
<Name>reg_evt_key</Name>
<TableAlias/>
<TableDescription>Event Registrant</TableDescription>
<TableName>ev_registrant</TableName>
<ListOptionCollection>
<ListOption>
<Value>72db64c1-63d2-4f70-88cb-cc38003e0beb</Value>
<Text>2007 .01 event</Text>
</ListOption>
<ListOption>
<Value>a55cba19-6f87-40b9-a488-0a5f84e390a7</Value>
<Text>2007 Annual Seminar</Text>
</ListOption>
<ListOption>
<Value>8309eaa5-a60b-43bb-9b7f-87b53d9c118f</Value>
<Text>2007 Event</Text>
</ListOption>
<ListOption>
<Value>ae23c888-a790-41a2-8b62-03f4fcffd414</Value>
<Text>Avectra event</Text>
</ListOption>
<ListOption>
<Value>7f18b35a-b70c-479c-9e61-73fa9861fda6</Value>
<Text>WsMeeting</Text>
</ListOption>
</ListOptionCollection>
</QueryParameter>
<QueryParameter>
<ParameterName>40794c6e-a417-4c7c-859b-3bc580adbe5d_2</ParameterName>
<ParameterDescription>[Individual::Last Name] Begins With [Enter Value] (Ask At Run-Time)</ParameterDescription>
<Operator>Equals</Operator>
<ControlClass>TextBox</ControlClass>
<DataType>nvarchar</DataType>
<Description>Last Name</Description>
<IsExtended>false</IsExtended>
<IsNullable>false</IsNullable>
<Name>ind_last_name</Name>
<TableAlias/>
<TableDescription>Individual</TableDescription>
<TableName>co_individual</TableName>
<ListOptionCollection/>
</QueryParameter>
<QueryParameter>
<ParameterName>40794c6e-a417-4c7c-859b-3bc580adbe5d_3</ParameterName>
<ParameterDescription>[Customer::Record Number] Greater Than or Equal To [Enter Value] (Ask At Run-Time)</ParameterDescription>
<Operator>GreaterThanOrEqualTo</Operator>
<ControlClass>TextBox</ControlClass>
<DataType>av_recno</DataType>
<Description>Record Number</Description>
<IsExtended>false</IsExtended>
<IsNullable>false</IsNullable>
<Name>cst_recno</Name>
<TableAlias/>
<TableDescription>Customer</TableDescription>
<TableName>co_customer</TableName>
<ListOptionCollection/>
</QueryParameter>
</Parameters>
</GetDynamicQueryDefinitionResult>
</GetDynamicQueryDefinitionResponse>
</soap:Body>
</soap:Envelope>
Example with Columns
GetDynamicQueryDefinition includes the columns that are returned in the results set, including the raw SQL name, the friendly name, the data type and which table the column is coming from.
<GetDynamicQueryDefinitionResponse xmlns="http://www.avectra.com/2005/">
<GetDynamicQueryDefinitionResult>
<que_key>6bed2f0e-abc3-460d-adf1-ad6a1083fdb4</que_key>
<que_description>**Inactive Individuals</que_description>
<szObjectName>Individual</szObjectName>
<Parameters/>
<Columns>
<QueryColumn>
<Name>ind_full_name_cp</Name>
<Description>Full Name</Description>
<DataType>nvarchar</DataType>
<TableAlias/>
<TableDescription>Individual</TableDescription>
<TableName>co_individual</TableName>
</QueryColumn>
<QueryColumn>
<Name>ind_int_code</Name>
<Description>Individual Type</Description>
<DataType>nvarchar</DataType>
<TableAlias/>
<TableDescription>Individual</TableDescription>
<TableName>co_individual</TableName>
</QueryColumn>
<QueryColumn>
<Name>ind_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias/>
<TableDescription>Individual</TableDescription>
<TableName>co_individual</TableName>
</QueryColumn>
<QueryColumn>
<Name>cst_ind_full_name_dn</Name>
<Description>Full Name</Description>
<DataType>nvarchar</DataType>
<TableAlias/>
<TableDescription>Customer</TableDescription>
<TableName>co_customer</TableName>
</QueryColumn>
<QueryColumn>
<Name>cst_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias/>
<TableDescription>Customer</TableDescription>
<TableName>co_customer</TableName>
</QueryColumn>
<QueryColumn>
<Name>cxa_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias/>
<TableDescription>Customer Address</TableDescription>
<TableName>co_customer_x_address</TableName>
</QueryColumn>
<QueryColumn>
<Name>adt_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Address Type</TableDescription>
<TableName>co_address_type</TableName>
</QueryColumn>
<QueryColumn>
<Name>adr_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Address</TableDescription>
<TableName>co_address</TableName>
</QueryColumn>
<QueryColumn>
<Name>ixo_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias/>
<TableDescription>Affiliation</TableDescription>
<TableName>co_individual_x_organization</TableName>
</QueryColumn>
<QueryColumn>
<Name>org_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Organization</TableDescription>
<TableName>co_organization</TableName>
</QueryColumn>
<QueryColumn>
<Name>dmv_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias>Demographics</TableAlias>
<TableDescription>Demographic Value</TableDescription>
<TableName>co_demographic_value</TableName>
</QueryColumn>
<QueryColumn>
<Name>mbr_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias>Membership</TableAlias>
<TableDescription>Membership</TableDescription>
<TableName>mb_membership</TableName>
</QueryColumn>
<QueryColumn>
<Name>mbt_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias/>
<TableDescription>Member Type</TableDescription>
<TableName>mb_member_type</TableName>
</QueryColumn>
<QueryColumn>
<Name>mbr_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias>ChapterMembership</TableAlias>
<TableDescription>Membership</TableDescription>
<TableName>mb_membership</TableName>
</QueryColumn>
<QueryColumn>
<Name>mbr_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias>OrgMembership</TableAlias>
<TableDescription>Membership</TableDescription>
<TableName>mb_membership</TableName>
</QueryColumn>
<QueryColumn>
<Name>cmc_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias/>
<TableDescription>Committee Participant</TableDescription>
<TableName>mb_committee_x_customer</TableName>
</QueryColumn>
<QueryColumn>
<Name>reg_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias/>
<TableDescription>Event Registrant</TableDescription>
<TableName>ev_registrant</TableName>
</QueryColumn>
<QueryColumn>
<Name>mld_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Mailing List Detail</TableDescription>
<TableName>mk_mailing_list_detail</TableName>
</QueryColumn>
<QueryColumn>
<Name>eml_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias>emlMld</TableAlias>
<TableDescription>Email</TableDescription>
<TableName>co_email</TableName>
</QueryColumn>
<QueryColumn>
<Name>fac_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Event Faculty</TableDescription>
<TableName>ev_event_faculty</TableName>
</QueryColumn>
<QueryColumn>
<Name>eml_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Email</TableDescription>
<TableName>co_email</TableName>
</QueryColumn>
<QueryColumn>
<Name>cal_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Customer Alias</TableDescription>
<TableName>co_customer_alias</TableName>
</QueryColumn>
<QueryColumn>
<Name>rgt_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Registrant Type</TableDescription>
<TableName>ev_registrant_type</TableName>
</QueryColumn>
<QueryColumn>
<Name>rca_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Customer x Related Association</TableDescription>
<TableName>co_customer_x_related_association</TableName>
</QueryColumn>
<QueryColumn>
<Name>rla_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Related Association</TableDescription>
<TableName>co_related_association</TableName>
</QueryColumn>
<QueryColumn>
<Name>itr_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Interest</TableDescription>
<TableName>co_interest</TableName>
</QueryColumn>
<QueryColumn>
<Name>itc_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Interest Code</TableDescription>
<TableName>co_interest_code</TableName>
</QueryColumn>
<QueryColumn>
<Name>sta_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias/>
<TableDescription>State Territory</TableDescription>
<TableName>co_state_territory</TableName>
</QueryColumn>
<QueryColumn>
<Name>rgn_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Region</TableDescription>
<TableName>co_region</TableName>
</QueryColumn>
<QueryColumn>
<Name>vst_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date_small</DataType>
<TableAlias/>
<TableDescription>Customer Receives Member Benefits (view)</TableDescription>
<TableName>vw_customer_member_flag</TableName>
</QueryColumn>
<QueryColumn>
<Name>phn_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Phone</TableDescription>
<TableName>co_phone</TableName>
</QueryColumn>
<QueryColumn>
<Name>inv_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Invoice</TableDescription>
<TableName>ac_invoice</TableName>
</QueryColumn>
<QueryColumn>
<Name>pay_change_date</Name>
<Description>Change Date</Description>
<DataType>av_date</DataType>
<TableAlias/>
<TableDescription>Payment</TableDescription>
<TableName>ac_payment</TableName>
</QueryColumn>
</Columns>
</GetDynamicQueryDefinitionResult>
</GetDynamicQueryDefinitionResponse>
JSON Method
POST /xWeb/JSON/GetDynamicQueryDefinition
Copy
DATA: JSON
{
"GetDynamicQueryDefinition" : {
"szObjectName" : "individual",
"szQueryName" : "**Individuals receiving Organization Member Benefits (by Member Type)",
"que_key" : ""
}
}
Copy
SAMPLE RESULT
HTTP STATUS: 200
DATA: JSON
{
"que_key": "c9ecd99e-d9b0-47bc-8a25-d8be6c490b72",
"que_description": "**Individuals receiving Organization Member Benefits (by Member Type)",
"szObjectName": "Individual",
"Parameters": [
{
"Name": "c9ecd99e-d9b0-47bc-8a25-d8be6c490b72_1",
"Description": "[Membership(OrgMembership)::Member Type] Is Equal To [Please select] (Ask At Run-Time)",
"Operator": 2,
"ColumnName": "mbr_mbt_key",
"ColumnDescription": "Member Type",
"ControlClass": "DropDownList",
"DataType": "av_key",
"IsExtended": false,
"IsNullable": false,
"TableAlias": "OrgMembership",
"TableDescription": "Membership",
"TableName": "mb_membership",
"ListOptions": [
{
"Value": "71d24394-bc70-462c-b2b7-cfb39edde05f",
"Text": ""
},
{
"Value": "85dac719-020b-475e-898e-36a29d3b83d4",
"Text": "132951_ASC : PK_132951"
},
{
"Value": "66705f33-a72f-437b-97ba-e19909d0c767",
"Text": "132951_ASC : Test"
},
{
"Value": "c9394413-5258-4ac5-acfc-65269e98c7ee",
"Text": "ABC Assoc : 135259 member dhana"
},
{
"Value": "f39c170d-1d67-4a28-9eb2-91920900537d",
"Text": "ABC Assoc : 135559MemberType"
},
{
"Value": "dbc40d85-b70e-453d-9279-b58b47fd6d73",
"Text": "ABC Assoc : 15years"
},
{
"Value": "f8ff51d5-afe9-4178-8be4-dd86906fbfee",
"Text": "ABC Assoc : 5 year member"
},
{
"Value": "603c09b6-b6a0-498b-b338-b57ad59d817c",
"Text": "ABC Assoc : AB Member Type"
},
{
"Value": "1bea6f52-40ca-453d-8816-641f8c775058",
"Text": "ABC Assoc : ABC ANNIV Member Type"
},
{
"Value": "bfbc731b-37a0-4a45-9745-31fe651c6ab8",
"Text": "ABC Assoc : ABC CHAPTER Member Type (calendar)"
},
{
"Value": "6b65814f-9ea0-4e88-b01d-2886ec5ccdbe",
"Text": "ABC Assoc : ABC CHAPTER2 Member Type (calendar)"
},
{
"Value": "0d77d844-df34-4cd8-a721-4b634e5c3ef6",
"Text": "ABC Assoc : ABC Collective Dues_Member Type (calendar)"
},
{
"Value": "50db464e-6c03-4b25-b126-553aa3df9c91",
"Text": "ABC Assoc : ABC Collective Dues2_Member Type (calendar) "
},
{
"Value": "710a8bc4-fe4b-4d41-952e-c13d1fd96e3d",
"Text": "ABC Assoc : ABC DEF REG Type (calendar)"
},
{
"Value": "2af03e73-6518-40c5-8487-c1f4b2427578",
"Text": "ABC Assoc : ABC FLOWDOWN Member Type (calendar)"
},
{
"Value": "9b5e35ca-dd76-4c97-a54f-9d08fbd7de8b",
"Text": "ABC Assoc : ABC REG Member Type (calendar TEST)"
},
{
"Value": "69f8f9c3-9e5c-4fe7-80a5-aba30eebd340",
"Text": "ABC Assoc : ABC REG Member Type (calendar)"
},
{
"Value": "c3e82922-eafc-428e-89a1-35d650db3a7f",
"Text": "ABC Assoc : ABC REG Type (calender)"
},
{
"Value": "7e1ac0fe-d3eb-4537-807e-8eeee0f154fb",
"Text": "ABC Assoc : ABC REG2 member Type"
},
{
"Value": "0a6f2bf0-dd99-46dc-b0ba-e1ef2afe6c9d",
"Text": "ABC Assoc : ABC REG2 Member Type (calendar)"
},
{
"Value": "7b5bfc64-d53f-45df-8057-dfd0f43099b8",
"Text": "ABC Assoc : ABC TFS134472_MemberType"
},
{
"Value": "5bda035c-1d73-4901-ac0d-85f8e66c21ee",
"Text": "ABC Assoc : ABC_PercentPaid_ Member Type"
},
{
"Value": "14073cec-0be1-43e5-92b8-948cc9f43115",
"Text": "ABC Assoc : anniversary"
},
{
"Value": "b1702e87-b2f2-4add-9a47-32741dd03d15",
"Text": "ABC Assoc : Auto"
},
{
"Value": "6c7b33ca-c249-4aab-a2d1-c742d7ebe7a1",
"Text": "ABC Assoc : BBC REG Member Type (calendar)"
},
{
"Value": "9483f713-b6c0-4b9b-9d87-5fad912a99f0",
"Text": "ABC Assoc : changestatus"
},
{
"Value": "b2c0fc0a-d2e7-4122-b83f-8ea236d3392f",
"Text": "ABC Assoc : Def_Normal"
},
{
"Value": "284a8e40-45f4-4309-9226-28ac17c44537",
"Text": "ABC Assoc : dhana member type A"
},
{
"Value": "e32720b6-0231-43cf-961e-c551f4945583",
"Text": "ABC Assoc : dhana member type B"
},
{
"Value": "57dd6eda-9533-48f7-98ca-b829455a3ddc",
"Text": "ABC Assoc : ExpireMemberA"
},
{
"Value": "c1044601-b192-4597-a24f-3126734dd257",
"Text": "ABC Assoc : ExpireMemberB"
},
{
"Value": "2cbe2fb7-6ed5-474a-a8df-d002dababec1",
"Text": "ABC Assoc : ExpireYearly"
},
{
"Value": "2bfd1fdd-184a-4642-9b50-bbd2234845a9",
"Text": "ABC Assoc : InvoiceBatchClosed"
},
{
"Value": "cc203d9a-556e-430c-a69d-56efbb0b11e0",
"Text": "ABC Assoc : less than year member"
},
{
"Value": "76bf2832-5476-4b62-8b5a-32a0f12ba243",
"Text": "ABC Assoc : MemberType_137646"
},
{
"Value": "6cf2b7b7-c16c-4a9c-ac68-229fcc1dd36a",
"Text": "ABC Assoc : MemberType_137648"
},
{
"Value": "3764fb8c-a594-40f6-b35a-f8fb9f9b57c2",
"Text": "ABC Assoc : Nik Member type 1"
},
{
"Value": "d51acdd1-583c-4624-a3a7-1453fef55140",
"Text": "ABC Assoc : PercentPaid"
},
{
"Value": "330c4e94-19ed-4c4b-9ab1-890717b7447f",
"Text": "ABC Assoc : pooja member"
},
{
"Value": "cbe04471-01db-4ab9-9671-cfc582dc43cc",
"Text": "ABC Assoc : TA_Type"
},
{
"Value": "05af1a25-9d61-41ad-9ae5-e9d6330266a4",
"Text": "ABC Assoc : TC137647_MemberType_1stPayment"
},
{
"Value": "a373e8c1-d43d-4a3c-92d6-99d1ea8063db",
"Text": "ABC Assoc : TC137649_MemberType"
},
{
"Value": "ad415a7b-27fb-4ac3-9ded-7a13377763e6",
"Text": "ABC Assoc : Trans Expire Calender A"
},
{
"Value": "4a46a801-31da-4418-bbd1-025eb56768ed",
"Text": "ABC Assoc : Trans Expire Calender B"
},
{
"Value": "e8f829ae-d85a-4c1d-8b78-7588151915a0",
"Text": "Abila Asso : 135559AbilaMemberType"
},
{
"Value": "d2c6bb55-8b62-4aa3-bafc-88261a6c009a",
"Text": "Abila Asso : AB Member Type"
},
{
"Value": "aa1af831-f781-4788-b8a1-67917e0b8bcc",
"Text": "Abila Asso : ABC MemberType"
},
{
"Value": "56a3f6eb-3764-4ccd-ae5c-0745b1a03412",
"Text": "Abila Asso : ABC type"
},
{
"Value": "223f1689-2c82-445d-ab82-6bc864af349e",
"Text": "Abila Asso : Abila ANNIV Member Type"
},
{
"Value": "fd64b3cc-ab02-4f32-8390-4be13ab6ff0a",
"Text": "Abila Asso : Abila CHAPTER Member Type (calendar)"
},
{
"Value": "28c61bba-7794-4086-9f02-b500de7b4da3",
"Text": "Abila Asso : Abila CHAPTER2 Member Type (calendar)"
},
{
"Value": "ab7a131c-6627-400a-970d-2708d09b6f2b",
"Text": "Abila Asso : Abila Collective Dues_Member Type (calendar)"
},
{
"Value": "51bcdfad-563e-4c88-bc67-a1afb9a36c60",
"Text": "Abila Asso : Abila Collective Dues2_Member Type (calendar)"
},
{
"Value": "51f831f0-1b7b-42d1-a440-4cdb6be28861",
"Text": "Abila Asso : Abila FLOWDOWN Member Type (calendar)"
},
{
"Value": "9b7e0a43-2ee2-4868-885c-9ca6f0c53dee",
"Text": "Abila Asso : Abila REG Member Type (calendar)"
},
{
"Value": "5db7b5e5-cd25-476c-a103-d56b08545753",
"Text": "Abila Asso : Abila REG2 Member Type (calendar)"
},
{
"Value": "9102fdb0-3952-4479-a098-f92c105977e7",
"Text": "Abila Asso : Deepti Member calendar"
},
{
"Value": "9814e2d5-5787-4195-b331-464c46c0ca29",
"Text": "Abila Asso : Deepti_mamber_134084"
},
{
"Value": "f256efdd-5ad0-470d-a850-3ac70135e4c7",
"Text": "Abila Asso : Deepti_member_110286"
},
{
"Value": "0620bb03-02fa-4ba2-b8ea-96c47cf0a2d4",
"Text": "Abila Asso : Deepti_Member_132951"
},
{
"Value": "24314e7e-017f-4d1f-8133-ce389890a741",
"Text": "Abila Asso : Deepti_Member_132986"
},
{
"Value": "3afba0d7-67cd-4848-8b2b-101bd353cadd",
"Text": "Abila Asso : jls_anniv"
},
{
"Value": "164c1e4c-8471-4234-8807-56cd1334b8d0",
"Text": "Abila Asso : jls_cal"
},
{
"Value": "a221cc78-b145-434c-8b28-2295bd55903d",
"Text": "Abila Asso : jls_collective dues"
},
{
"Value": "7fde913b-a910-4a26-9a1d-9b8c83a5a358",
"Text": "Abila Asso : Member01"
},
{
"Value": "c21960f8-b8aa-4d25-8a68-90c23d10932e",
"Text": "Abila Asso : monika"
},
{
"Value": "6cba7e48-575e-49fa-9bb2-066e85793d6d",
"Text": "Abila Asso : SwapChapterMembership"
},
{
"Value": "91f116a5-6cab-4ad9-be7d-b52b19036657",
"Text": "Abila Asso : termina"
},
{
"Value": "d716c2fb-ef56-41a8-ac4a-82c448f100cd",
"Text": "AFA : Professional"
},
{
"Value": "110fda24-aa3a-4329-8b66-60630fc80abb",
"Text": "AFA : Student"
},
{
"Value": "706d0fa6-516d-4c31-8c73-a13e25512a31",
"Text": "ASSO1234 : PP_MembarType"
},
{
"Value": "b92aaf96-7b4e-43d7-9eec-904d33f6894c",
"Text": "ASSO1234 : PP3"
},
{
"Value": "4e28d3a1-c1a1-429b-b860-2a1ca1fece6d",
"Text": "BBC Assoc : BBC REG Member Type (calendar)"
},
{
"Value": "df720c10-8038-43e7-85f7-5bdb892467d5",
"Text": "Bell Assoc : 134656 Member type"
},
{
"Value": "be99ba7b-9160-4c6b-a721-597a201e9c68",
"Text": "Bell Assoc : 134870 Member Type"
},
{
"Value": "ed630f83-8ea6-43ae-a537-c06eeaed0f75",
"Text": "Bell Assoc : 134870 memebr type"
},
{
"Value": "2bf609ca-16cc-4a78-ba14-7ba5c0fda212",
"Text": "Bell Assoc : 135086- Calendar Type"
},
{
"Value": "f2ec3b49-f18d-4164-b23c-b1849ceb5b98",
"Text": "Bell Assoc : Bell ANNIV Member Type"
},
{
"Value": "cc32531f-198d-49c0-a86b-0e7f7c855386",
"Text": "Bell Assoc : Bell CHAPTER Member Type (calendar)"
},
{
"Value": "c54d703a-d150-45ea-8b75-c39651932fed",
"Text": "Bell Assoc : Bell CHAPTER2 Member Type (calendar)"
},
{
"Value": "09a6c93c-0e99-410a-8ffb-c68ae570b0b8",
"Text": "Bell Assoc : Bell Collective Dues_Member Type (calendar)"
},
{
"Value": "201b2561-a044-4a04-9394-795d342f8899",
"Text": "Bell Assoc : Bell Collective Dues2_Member Type (calendar)"
},
{
"Value": "5a255636-03e9-4bda-b29c-1d98ecbfe741",
"Text": "Bell Assoc : Bell FLOWDOWN Member Type (calendar)"
},
{
"Value": "d150d6ea-73a7-4204-a5f0-3ca55e8173ec",
"Text": "Bell Assoc : Bell REG Member Type (calendar)"
},
{
"Value": "d4d9f9ec-4146-48dd-95e7-c309716cb950",
"Text": "Bell Assoc : Bell REG2 Member Type (calendar)"
},
{
"Value": "2cd1083b-2c68-4e77-8429-0866ce1950e3",
"Text": "Bell Assoc : jls_116474"
},
{
"Value": "6d47f8e9-f454-419e-8c7a-06af3f8e0ccd",
"Text": "Cisco Asso : 134508 Ani"
},
{
"Value": "66185497-3bc3-477f-9bb1-6c09b073ab05",
"Text": "Cisco Asso : Cisco ANNIV Member Type"
},
{
"Value": "cce18b9f-50b0-45df-99c2-20c006eebdf4",
"Text": "Cisco Asso : Cisco CHAPTER Member Type (calendar)"
},
{
"Value": "20364c90-a068-4078-b146-5d2aa9474b46",
"Text": "Cisco Asso : Cisco Chapter type"
},
{
"Value": "02b6b362-a6bd-45a5-a6c3-66e5dcb6106f",
"Text": "Cisco Asso : Cisco CHAPTER2 Member Type (calendar)"
},
{
"Value": "7bdc23fa-308c-4c81-8b2b-9e06a64073ff",
"Text": "Cisco Asso : Cisco Collective Dues_Member Type (calendar)"
},
{
"Value": "f8fb9859-f379-4d39-acac-6f8f0fbf8c10",
"Text": "Cisco Asso : Cisco Collective Dues2_Member Type (calendar)"
},
{
"Value": "3275b8e3-7851-4585-868e-b2a112ba6a67",
"Text": "Cisco Asso : Cisco FLOWDOWN Member Type (calendar)"
},
{
"Value": "61a625ad-0365-4544-a485-033cbee2f6c3",
"Text": "Cisco Asso : Cisco REG Member Type (calendar)"
},
{
"Value": "f9df7386-dbbe-4abb-b800-ce7dda197216",
"Text": "Cisco Asso : Cisco REG2 Member Type (calendar)"
},
{
"Value": "56cbd5e3-f036-4b1d-a8e5-30f2afbdbb37",
"Text": "CricketASC : Bronze_Chapte"
},
{
"Value": "6d963bb6-aaa6-4425-9db9-94276b345c3e",
"Text": "CricketASC : Gold_Calendar"
},
{
"Value": "53f14568-fbb2-4ed0-be20-8fe499425015",
"Text": "CricketASC : Silver_Anniversary"
},
{
"Value": "d54bdb90-7f7a-4001-87f3-5f1943a6383c",
"Text": "DeeptiAs01 : Calendar_Member_132951"
},
{
"Value": "357cc40f-d086-4f5f-a015-ac41eff8abe3",
"Text": "DELL Assoc : DELL ANNIV Member Type"
},
{
"Value": "20c8105b-cf3f-40e5-82d5-c2c340da7c60",
"Text": "DELL Assoc : DELL CHAPTER Member Type (calendar)"
},
{
"Value": "a20e9c24-21de-42fe-ae0a-445f540bd136",
"Text": "DELL Assoc : DELL CHAPTER2 Member Type (calendar)"
},
{
"Value": "cb342282-18a5-486c-b44b-081dc7355a2b",
"Text": "DELL Assoc : DELL Collective Dues_Member Type (calendar)"
},
{
"Value": "096d1dd2-d597-4007-a696-d6658c10f7c4",
"Text": "DELL Assoc : DELL Collective Dues2_Member Type (calendar)"
},
{
"Value": "f6ded8c7-3de4-4b72-bf44-770c31b595c3",
"Text": "DELL Assoc : DELL FLOWDOWN Member Type (calendar)"
},
{
"Value": "41c32bd6-1542-4d6e-855a-52206339b42b",
"Text": "DELL Assoc : DELL REG Member Type (calendar)"
},
{
"Value": "32be69f4-27fb-4e15-af73-c76e9e08f200",
"Text": "DELL Assoc : DELL REG2 Member Type (calendar)"
},
{
"Value": "3537546f-3ed8-4090-a819-33dcaf1dd89d",
"Text": "Discount36 : Member_Type"
},
{
"Value": "d1b55052-3241-4880-92ab-955c220e324f",
"Text": "INTACCT As : INTACCT ANNIV Member Type"
},
{
"Value": "7239313f-3e64-4ebe-aaaf-237fc75243a5",
"Text": "INTACCT As : INTACCT CHAPTER Member Type (calendar)"
},
{
"Value": "41cc5da9-905e-4a3c-ab2c-7955259aa0d0",
"Text": "INTACCT As : INTACCT CHAPTER2 Member Type (calendar)"
},
{
"Value": "56c6ae03-4062-4a9a-80a9-3b5d37510a45",
"Text": "INTACCT As : INTACCT Collective Dues_Member Type (calendar)"
},
{
"Value": "b2a2bab4-c4c2-4a14-b2a3-6e7cac69fb44",
"Text": "INTACCT As : INTACCT Collective Dues2_Member Type (calendar)"
},
{
"Value": "860e9e27-2b70-44cb-a2e1-d36a3ee51f7e",
"Text": "INTACCT As : INTACCT FLOWDOWN Member Type (calendar)"
},
{
"Value": "d8faceb3-789a-4a4e-90d1-bd0435c38755",
"Text": "INTACCT As : INTACCT REG Member Type (calendar)"
},
{
"Value": "b6a7d4ee-7fa1-45cf-9ea1-f4cbdb6d3902",
"Text": "INTACCT As : INTACCT REG2 Member Type (calendar)"
},
{
"Value": "09becf46-00c3-40e9-8255-ce1f76d0d332",
"Text": "JUVE : GROOM3 TYPE "
},
{
"Value": "7cfbcc0b-2cd2-4f41-ab7f-e916928b20b4",
"Text": "MCurr Asso : MultiCurr ANNIV Member Type"
},
{
"Value": "4769a6f4-6512-4a26-b886-bd93ba155378",
"Text": "MCurr Asso : MultiCurr CHAPTER Member Type (calendar)"
},
{
"Value": "8fb7cf85-3d2a-4e59-b381-06896834c29e",
"Text": "MCurr Asso : MultiCurr CHAPTER2 Member Type (calendar)"
},
{
"Value": "f59ce613-1717-48e5-9667-24d77b67413a",
"Text": "MCurr Asso : MultiCurr Collective Dues_Member Type (calendar)"
},
{
"Value": "dc3f9dc1-a69a-4117-83a2-77bcaeffe163",
"Text": "MCurr Asso : MultiCurr Collective Dues2_Member Type (calendar)"
},
{
"Value": "6cba4f49-f503-475f-8def-46d2b179b266",
"Text": "MCurr Asso : MultiCurr FLOWDOWN Member Type (calendar)"
},
{
"Value": "2185b162-8bb9-4a44-bec2-b2a93bca8811",
"Text": "MCurr Asso : MultiCurr REG Member Type (calendar)"
},
{
"Value": "6989ac84-bd98-472e-a98e-84561be5ab19",
"Text": "MCurr Asso : MultiCurr REG2 Member Type (calendar)"
},
{
"Value": "aa2ea785-a5b5-4cae-ac3d-a1b6da00ab2d",
"Text": "NA09pnVg : Newest Member Type09pnVg"
},
{
"Value": "e8797926-baf5-4996-8a65-c61d5cffd6ba",
"Text": "NA0hg87V : Newest Member Type0hg87V"
},
{
"Value": "f23e9f20-a1b8-4f2f-88e9-6e82d4957815",
"Text": "NA0KJ2CB : Newest Member Type0KJ2CB"
},
{
"Value": "6d5fd4da-e791-4dd3-8190-6f9aa0d2d6db",
"Text": "NA0loYdu : Newest Member Type0loYdu"
},
{
"Value": "7493e058-b0b3-4109-881c-60ac6ebfccc0",
"Text": "NA0n6hWh : Newest Member Type0n6hWh"
},
{
"Value": "b1d6e959-0dd4-4a4b-bd97-8c74693b7db2",
"Text": "NA0rJkCn : Newest Member Type0rJkCn"
},
{
"Value": "53479285-9a08-4078-993e-a1cf9298d824",
"Text": "NA0xOdYJ : Newest Member Type0xOdYJ"
},
{
"Value": "cc408af6-c6b0-4a3c-8f2f-085295b1a147",
"Text": "NA12M1cL : Newest Member Type12M1cL"
},
{
"Value": "0aa8d5e4-435a-454e-b8dc-e58219d40107",
"Text": "NA13zYkP : Newest Member Type13zYkP"
},
{
"Value": "c476eeed-d427-4402-b8e9-63a41e742cbe",
"Text": "NA1FvHSE : Newest Member TypeInvBatchCl1FvHSE"
},
{
"Value": "aca218d4-0d68-406d-a741-e9c369bc2f2f",
"Text": "NA1tF3wp : Newest Member Type1tF3wp"
},
{
"Value": "56cd1c39-a770-432f-935f-9f697dafa656",
"Text": "NA2T078C : Newest Member Type2T078C"
},
{
"Value": "4ec889de-045f-4084-9153-ef08e3426eba",
"Text": "NA37F19w : Newest Member Type37F19w"
},
{
"Value": "173a0d88-5cee-47e1-bc44-5377da3dabb4",
"Text": "NA3EzPT1 : Newest Member Type3EzPT1"
},
{
"Value": "f8a024a2-4796-4eb6-b946-bf06cd063a7a",
"Text": "NA3FkzFq : Newest Member Type3FkzFq"
},
{
"Value": "022a3f67-350d-4376-843b-cc967acc953b",
"Text": "NA3JIgoC : Newest Member Type3JIgoC"
},
{
"Value": "23e03fc0-015c-4610-a9fc-68a563e10152",
"Text": "NA3nS1WS : Newest Member Type3nS1WS"
},
{
"Value": "4bd8731f-eabb-4021-bd3a-90a17f717320",
"Text": "NA3UtFEz : Newest Member Type3UtFEz"
},
{
"Value": "ccb35702-444e-48fb-98da-6974071540e0",
"Text": "NA3WDVnA : Newest Member Type3WDVnA"
},
{
"Value": "90112d36-85bc-42a8-8b36-b4341ee678aa",
"Text": "NA3zX83J : Newest Member TypeFirstPay3zX83J"
},
{
"Value": "9bb6985a-aa07-426d-82ee-2b59c9dfbf16",
"Text": "NA3zX83J : Newest Member TypePercentPaid3zX83J"
},
{
"Value": "ccc8d425-611d-4e1c-965d-9de279c4d10e",
"Text": "NA4LUGJG : e1e64a4eb41c96d4"
},
{
"Value": "c9405113-3bb9-43ed-8c07-c5870a4b2da9",
"Text": "NA4LUGJG : Newest Member Type4LUGJG"
},
{
"Value": "fedbf6c9-729d-457f-8223-3f1545351bf3",
"Text": "NA4OSeyK : Newest Member Type4OSeyK"
},
{
"Value": "16364304-754a-42e4-ac5f-a0efa5ba2f40",
"Text": "NA4rqBK7 : Newest Member Type4rqBK7"
},
{
"Value": "01a096ff-fd3b-4bae-831f-a5e2c0414be4",
"Text": "NA4tAcOT : Newest Member Type4tAcOT"
},
{
"Value": "7dd9fb38-9e1b-4370-aefc-e95f3d14a425",
"Text": "NA4ua25p : Newest Member Type4ua25p"
},
{
"Value": "2ff95a7f-9217-42ce-8b07-22851fee66d8",
"Text": "NA597zzg : Newest Member Type597zzg"
},
{
"Value": "68c7e7e3-68ed-4e5a-9141-53611642f565",
"Text": "NA5B1eeH : Newest Member Type5B1eeH"
},
{
"Value": "6367d9fe-3ba4-492c-aaf8-6a33bd553bd3",
"Text": "NA5MyVRs : Newest Member Type5MyVRs"
},
{
"Value": "4a34e0e5-5262-4f99-956a-77df6faff8c0",
"Text": "NA64j5Og : Newest Member Type64j5Og"
},
{
"Value": "19efdd73-9137-4f4d-a88a-3992351f68ef",
"Text": "NA6CrGmm : Newest Member Type6CrGmm"
},
{
"Value": "a8cce489-e0a2-4804-a49f-b8edfc21ee91",
"Text": "NA6DK0Re : Newest Member Type6DK0Re"
},
{
"Value": "6a5b1cdc-471a-4c1a-97cb-39ba38ec2506",
"Text": "NA6iyDCk : Newest Member Type6iyDCk"
},
{
"Value": "e7b314af-660a-498a-ac3d-082d31ebb8da",
"Text": "NA6m6dIN : Newest Member Type6m6dIN"
},
{
"Value": "1bc0dfc7-fb84-4d0c-9ee3-4a545289ad83",
"Text": "NA6pVbrG : Newest Member Type6pVbrG"
},
{
"Value": "c7cbe923-d587-4136-8dfb-b2025763a3d3",
"Text": "NA6szrQG : Newest Member Type6szrQG"
},
{
"Value": "ee7c0bdb-161f-4ea7-8f5f-86a66bf6c553",
"Text": "NA6txwUx : Newest Member Type6txwUx"
},
{
"Value": "1af95d60-24fc-46ec-adce-20b14345ab3d",
"Text": "NA6ty7j7 : Newest Member TypeInvBatchCl6ty7j7"
},
{
"Value": "a68d4e01-aac6-496e-bf25-63ed4af931a9",
"Text": "NA6X9QbW : ac236ce4e976126f"
},
{
"Value": "ee0bb92c-9d63-4382-b85d-8e6b90508fc9",
"Text": "NA6X9QbW : Newest Member Type6X9QbW"
},
{
"Value": "13d1f579-73b0-4177-a31c-05f763822ab1",
"Text": "NA78bQ3y : Newest Member Type78bQ3y"
},
{
"Value": "4cada7da-e157-4fb3-9191-e137b9491a46",
"Text": "NA78bQ3y : Newest Member TypebQvvdW"
},
{
"Value": "93b5a684-b6d5-4559-a825-c25e79029ff7",
"Text": "NA7F6lPv : Newest Member Type7F6lPv"
},
{
"Value": "5bd3ec8f-b45e-4e9d-b6a5-2851bb6dc79d",
"Text": "NA7m1kaT : Newest Member Type7m1kaT"
},
{
"Value": "aabe4408-04d1-4825-8afb-9a3e8be0585b",
"Text": "NA7MLEQQ : Newest Member Type7MLEQQ"
},
{
"Value": "5d7522c8-50ec-4d6c-ab65-6a205da7d35b",
"Text": "NA7tmyU7 : Newest Member Type7tmyU7"
},
{
"Value": "57e0c717-1eb1-4a75-83bb-14aba4ed35c8",
"Text": "NA8ADZl9 : Newest Member Type8ADZl9"
},
{
"Value": "efb3bdd1-b594-40f6-88f6-b75e93711c26",
"Text": "NA8aUGdC : Newest Member Type8aUGdC"
},
{
"Value": "e30f95f1-e060-48ba-9d81-9f3a2b6ac840",
"Text": "NA8pk3Ne : Newest Member Type8pk3Ne"
},
{
"Value": "d468039b-73ce-43ac-b3bd-54fcc48e2170",
"Text": "NA90EdOk : Newest Member Type90EdOk"
},
{
"Value": "250191a6-345b-4495-a18c-9c5251ca01dd",
"Text": "NA94oqMV : Newest Member Type94oqMV"
},
{
"Value": "1aae8194-8912-4eae-a1ce-aa9cc6f2ae3c",
"Text": "NA97y66W : Newest Member Type3Ftchr"
},
{
"Value": "97f90533-eb47-4bfe-9bf0-eebcd1c41bb8",
"Text": "NA97y66W : Newest Member Type97y66W"
},
{
"Value": "9358388d-e5b3-4b5e-988e-1b735199967b",
"Text": "NA99E0Pq : Newest Member Type99E0Pq"
},
{
"Value": "2f018f7d-4e71-4d53-85cf-fbb228750938",
"Text": "NA9c1fFz : Newest Member Type9c1fFz"
},
{
"Value": "2c745c98-3923-4552-8bdc-1fb2bd771d10",
"Text": "NA9D0xvQ : Newest Member Type9D0xvQ"
},
{
"Value": "ceb74f9b-9ad1-4652-a25e-072ba85b5d39",
"Text": "NA9IzNs4 : Newest Member Type9IzNs4"
},
{
"Value": "9f595869-6e15-4696-b105-5caa394104ce",
"Text": "NA9IzNs4 : Newest Member Typep5ZCHQ"
},
{
"Value": "9bdc57e4-27c4-4ce8-8c8b-eca2b9031192",
"Text": "NA9mDvdN : Newest Member Type9mDvdN"
},
{
"Value": "8da59480-f628-4ea7-b983-174b464894b0",
"Text": "NA9mDvdN : Newest Member TypeLTuKhm"
},
{
"Value": "fbcafe08-61ee-48cd-9ab7-f79d773941d5",
"Text": "NA9pHg9F : Newest Member Type9pHg9F"
},
{
"Value": "6424f646-3954-4413-80b3-6c52d459f956",
"Text": "NA9xdmhk : Newest Member Type9xdmhk"
},
{
"Value": "48f31eb8-2057-40bc-9ad2-7aaf4a8106a2",
"Text": "NA9yQ0M0 : Newest Member Type9yQ0M0"
},
{
"Value": "e9b87b00-1c28-4cc9-aec3-a382125a719c",
"Text": "NAa1cf4M : 860bf419483180c7"
},
{
"Value": "15c2da4a-1189-4332-978f-d38f17ce5e9e",
"Text": "NAa1cf4M : Newest Member Typea1cf4M"
},
{
"Value": "2df565e8-ffb7-4fd7-8e96-fe0abfc6f485",
"Text": "NAA5RTjH : Newest Member TypeA5RTjH"
},
{
"Value": "a7f3ff42-6eb5-4f19-acf9-bccc92cb6b18",
"Text": "NAA6NdqB : Newest Member TypeA6NdqB"
},
{
"Value": "481418d8-0bf5-4c82-90bd-b346b4a132ec",
"Text": "NAA8Csao : Newest Member TypeA8Csao"
},
{
"Value": "35a04462-4138-41da-8775-88c6e03d03ae",
"Text": "NAaBbqqR : Newest Member TypeaBbqqR"
},
{
"Value": "b5324146-d0f8-45c8-bc46-d9919c5c839d",
"Text": "NAaDYvxm : Newest Member TypeFirstPayaDYvxm"
},
{
"Value": "208a31f5-b8a9-4640-927f-cfcc0e7137d7",
"Text": "NAaDYvxm : Newest Member TypePercentPaidaDYvxm"
},
{
"Value": "a269c549-8813-4ac8-bab3-c33e66c2ac08",
"Text": "NAajJDAR : Newest Member TypeajJDAR"
},
{
"Value": "c978ffcf-157f-4c72-8ba5-465132aae54e",
"Text": "NAajJDAR : Newest Member TypeZTQ4KL"
},
{
"Value": "87a06115-390b-477d-96eb-f5ab7b357b02",
"Text": "NAAmgkQM : Newest Member TypeAmgkQM"
},
{
"Value": "9bba328b-7d9a-4882-9a4e-5ed2b67e0053",
"Text": "NAaXGvFu : Newest Member TypeaXGvFu"
},
{
"Value": "33d61bfb-f118-43c5-b257-c7d3095d2b4d",
"Text": "NAAzPLoH : Newest Member TypeAzPLoH"
},
{
"Value": "105dde5c-3aae-45b2-8fc6-11f0000d4c74",
"Text": "NAB2kkcX : Newest Member TypeB2kkcX"
},
{
"Value": "ac1fe879-5a0c-422b-991c-f09ba6904c77",
"Text": "NAB4zkwJ : 4b3ebdbaf1cac28d"
},
{
"Value": "f7c4fcd6-a6bb-4580-9c0b-88c7e3a08fb0",
"Text": "NAB4zkwJ : Newest Member TypeB4zkwJ"
},
{
"Value": "1e13560c-fa81-4c0c-a58a-a32fd212857e",
"Text": "NAb8OSfJ : Newest Member Typeb8OSfJ"
},
{
"Value": "5ab8db3e-6d51-4a4b-a2a3-63aa7a4e4f12",
"Text": "NAbaHjgE : Newest Member TypebaHjgE"
},
{
"Value": "17abc444-872f-4739-bb57-5fb31d2acdae",
"Text": "NAbHKips : Newest Member TypebHKips"
},
{
"Value": "787a3f84-33c8-4903-bbeb-db6699644b98",
"Text": "NABHldpu : Newest Member TypeBHldpu"
},
{
"Value": "da0685ae-e50b-46eb-ba18-57565664a245",
"Text": "NAbhZ8kV : Newest Member TypebhZ8kV"
},
{
"Value": "e9d9de38-511a-4c63-8e4c-2da42de236cc",
"Text": "NABJHZCs : Newest Member TypeInvBatchClBJHZCs"
},
{
"Value": "98f0bcfd-ae3d-472e-97b8-c339d0c63d9a",
"Text": "NAbqww9G : Newest Member Typebqww9G"
},
{
"Value": "57ad42e4-0993-4937-abf8-92e709407687",
"Text": "NAc7cyb9 : Newest Member Typec7cyb9"
},
{
"Value": "67d31388-0540-47ba-a854-6cde2bdda0f0",
"Text": "NACCfrUv : Newest Member TypeCCfrUv"
},
{
"Value": "feef13d6-4081-4d59-bcf8-e674f0b14a5f",
"Text": "NAcfqkEh : Newest Member TypecfqkEh"
},
{
"Value": "eb54358f-84dd-4577-9163-b199ce6677d1",
"Text": "NACIxF1Z : Newest Member TypeCIxF1Z"
},
{
"Value": "2a6723cb-3de5-4ee6-b713-71cae6ec4aa9",
"Text": "NACkmhOs : Newest Member Type61x0gB"
},
{
"Value": "5c9fed26-708c-435c-8a37-f4740f372c00",
"Text": "NACNooWk : Newest Member TypeCNooWk"
},
{
"Value": "e5f17d61-a9aa-4e7f-8933-21fb1d38a7de",
"Text": "NAcOJ73q : Newest Member TypecOJ73q"
},
{
"Value": "4015be76-1965-41db-a96f-8acec63ad5fa",
"Text": "NAcRhbee : Newest Member TypecRhbee"
},
{
"Value": "de584894-d33d-4567-8f56-d2ab556c477e",
"Text": "NAcvu2uR : Newest Member Typecvu2uR"
},
{
"Value": "ef7652f5-ab9b-4d67-8c27-7050b8f7268a",
"Text": "NAcwGCWB : Newest Member TypecwGCWB"
},
{
"Value": "ec1219e7-5185-4b0d-8169-17ad40430ba9",
"Text": "NACyRQEE : Newest Member TypeCyRQEE"
},
{
"Value": "40fa80ce-14a4-49e5-8c5d-87e3f0c005c3",
"Text": "NAD0N8bN : Newest Member TypeD0N8bN"
},
{
"Value": "d3efcb47-299e-4328-830a-39d98d2703af",
"Text": "NAD3eSHw : Newest Member Typef83IJ0"
},
{
"Value": "88e3a4cc-6b26-4503-a4bf-47fcaaff7afc",
"Text": "NAdCeenN : Newest Member TypedCeenN"
},
{
"Value": "4436bbe7-735b-4cb1-88eb-aa7e4a268a53",
"Text": "NADMHoyt : 30028cd23b444f3"
},
{
"Value": "60f6e47c-c7f7-4d1e-b01d-dd839020dafe",
"Text": "NADMHoyt : Newest Member TypeDMHoyt"
},
{
"Value": "b2108cfb-ed08-43bc-a49c-ce348112a924",
"Text": "NAdRxz1t : Newest Member TypedRxz1t"
},
{
"Value": "20a77e82-487b-4a4c-8b02-018e25410890",
"Text": "NADwSbTu : Newest Member TypeDwSbTu"
},
{
"Value": "01d6fd9d-ff55-43ed-aa81-1f647edf2613",
"Text": "NAE2sl2V : Newest Member TypeE2sl2V"
},
{
"Value": "a11b6db4-effd-45b2-acad-a35f7fd072fd",
"Text": "NAE8ukj2 : Newest Member TypeE8ukj2"
},
{
"Value": "8ac4c0e4-74c3-4cb7-bc5f-6dc2ca229207",
"Text": "NAeNRIBj : Newest Member TypeeNRIBj"
},
{
"Value": "88339544-19f8-4f89-a795-564bf21acf03",
"Text": "NAePVu0H : 9fa10136f3885ee0"
},
{
"Value": "3b22edfd-a4b3-4221-9b70-66c94a9e3125",
"Text": "NAePVu0H : Newest Member TypeePVu0H"
},
{
"Value": "1e461b90-689f-42fc-98d0-283c9c7a58a4",
"Text": "NAErj6ZS : Newest Member TypeFirstPayErj6ZS"
},
{
"Value": "ef8f2336-627f-4f26-b2ca-031750e2c3ca",
"Text": "NAErj6ZS : Newest Member TypePercentPaidErj6ZS"
},
{
"Value": "247f0ead-1421-497b-b04c-a0ef91168854",
"Text": "NAERXYWw : Newest Member TypeERXYWw"
},
{
"Value": "9dd46200-f269-4063-82b0-b6871773e1ac",
"Text": "NAEvj7aH : Newest Member TypeEvj7aH"
},
{
"Value": "685b2018-11df-4242-ba7f-b434882ab9d3",
"Text": "NAeZ2GJe : Newest Member Type5bKxE1"
},
{
"Value": "f26c9c51-73fc-41d0-87bd-c6c98a778646",
"Text": "NAF6tU5C : Newest Member TypeF6tU5C"
},
{
"Value": "dab20c4f-e0d1-42ba-8f01-fbc890b0717a",
"Text": "NAfaJgOP : Newest Member TypexgMBhy"
},
{
"Value": "c1f8a62d-9b2f-408b-8639-b900d28072a5",
"Text": "NAFbNi3Z : Newest Member TypeFbNi3Z"
},
{
"Value": "cd190a5b-2cdf-4725-885e-078e560ed473",
"Text": "NAFBSZCa : Newest Member TypeFBSZCa"
},
{
"Value": "b8d17bf1-9b6d-423a-88b1-e82e3d6167ca",
"Text": "NAfcJ7En : Newest Member TypefcJ7En"
},
{
"Value": "4b3f24f4-a492-4c5e-abbb-74c3daf16373",
"Text": "NAfIoJvP : Newest Member TypefIoJvP"
},
{
"Value": "4e86f2c0-6c34-454f-9544-9729855f2ac2",
"Text": "NAFnDU8P : Newest Member TypeFnDU8P"
},
{
"Value": "d9c8c5a1-40c0-45c0-91df-91db53adbcc6",
"Text": "NAfVoEV8 : Newest Member TypefVoEV8"
},
{
"Value": "bf1ddb26-d1ef-4c67-8c52-bac8cab5fe83",
"Text": "NAg85E3n : Newest Member Typeg85E3n"
},
{
"Value": "67285918-2eee-456b-9fe1-fb94e443ed26",
"Text": "NAG8QmTP : Newest Member TypeG8QmTP"
},
{
"Value": "ba85c696-99f5-4b23-b73c-c78662f1f8ed",
"Text": "NAgkBUva : Newest Member TypegkBUva"
},
{
"Value": "7d751c6c-916c-4a53-a3bf-df3b73cf7754",
"Text": "NAGkli6i : Newest Member TypeGkli6i"
},
{
"Value": "a43db04f-ed45-4dda-bcf8-f9c2482b9709",
"Text": "NAGOjwUW : Newest Member TypeGOjwUW"
},
{
"Value": "43865c53-bc31-4399-a95c-646722af2d39",
"Text": "NAgtoNfj : Newest Member TypegtoNfj"
},
{
"Value": "7a748806-11be-4ac3-ba41-771099281082",
"Text": "NAGuZmC8 : 69a4478f09041d2f"
},
{
"Value": "462544df-a846-45ef-81e2-1674604a0972",
"Text": "NAGuZmC8 : Newest Member TypeGuZmC8"
},
{
"Value": "aeeb440b-973f-49d2-8029-0c90470d2370",
"Text": "NAH7o6jG : Newest Member TypeH7o6jG"
},
{
"Value": "01e4a34f-ba65-4179-bc82-743b24f08b26",
"Text": "NAHaHImz : Newest Member TypeHaHImz"
},
{
"Value": "85c75bfd-82dc-4ebe-a0e8-df7e5d54d812",
"Text": "NAhBGFW4 : Newest Member TypehBGFW4"
},
{
"Value": "162b39aa-3015-4779-8d3d-f74aa998c874",
"Text": "NAHgx63O : Newest Member TypeHgx63O"
},
{
"Value": "c55380f2-e917-4ca8-9bdc-f0b6bbe6db90",
"Text": "NAHQoxCC : Newest Member TypeHQoxCC"
},
{
"Value": "4dfb9769-87af-4d0f-829c-0b447f184a6d",
"Text": "NAhtBWQg : Newest Member TypehtBWQg"
},
{
"Value": "54696ea2-7e6e-4a8c-9d7b-6b94d22b7400",
"Text": "NAhXuxiP : Newest Member TypehXuxiP"
},
{
"Value": "dbceb92e-41d1-458b-92d5-6a0f00b1377a",
"Text": "NAi6VUy8 : Newest Member Typei6VUy8"
},
{
"Value": "38cf22c6-8a14-4b43-8c21-c619546a5cbf",
"Text": "NAI7Mwcc : Newest Member TypeI7Mwcc"
},
{
"Value": "2d91722a-14f4-44da-9707-036135cd5c75",
"Text": "NAI8Jh8L : Newest Member TypeI8Jh8L"
},
{
"Value": "00093990-a522-4537-b40a-fe243b2fc195",
"Text": "NAiEAwxs : Newest Member TypeiEAwxs"
},
{
"Value": "23012400-04b7-4995-a50b-506addf0bda1",
"Text": "NAIgPOXw : Newest Member TypeIgPOXw"
},
{
"Value": "9efa343b-cbf2-41b6-8d4e-1954d10b9ab4",
"Text": "NAIitCiR : Newest Member TypeIitCiR"
},
{
"Value": "ffa43dcf-0c60-4589-a60a-1ba39391d3ac",
"Text": "NAIkbuCo : Newest Member TypeIkbuCo"
},
{
"Value": "5c4dc488-0c77-48fd-9cfb-7778ad32f0d5",
"Text": "NAIko4GB : Newest Member TypeIko4GB"
},
{
"Value": "d17e282c-4256-490e-846c-c308b3f1c392",
"Text": "NAisx8zM : Newest Member Typeisx8zM"
},
{
"Value": "d3328d84-f852-4119-b7b8-210dbf952a23",
"Text": "NAivzSDv : Newest Member TypeivzSDv"
},
{
"Value": "77ebb17c-0d5e-4e77-a6f7-c280f02200f2",
"Text": "NAIYUYAi : Newest Member TypeIYUYAi"
},
{
"Value": "b8e148e3-0faf-4b18-bc87-180bd0c8ba86",
"Text": "NAj6iSPM : Newest Member Typej6iSPM"
},
{
"Value": "1ac92a0f-6e53-4a3f-8fa5-058fb6ceb2f7",
"Text": "NAjA7LiB : Newest Member TypejA7LiB"
},
{
"Value": "f1889731-51b9-460d-b38d-c101f9f44ccd",
"Text": "NAJAo34a : Newest Member TypeJAo34a"
},
{
"Value": "159bfdf7-cdc4-4f11-889d-7252e9e79615",
"Text": "NAJImkMl : Newest Member TypeJImkMl"
},
{
"Value": "6011c1c0-7752-4bd9-89b8-b72f480d91a3",
"Text": "NAjLSeCU : Newest Member TypejLSeCU"
},
{
"Value": "fe86e25b-80b7-430a-b300-29d604dc01a1",
"Text": "NAJptzyV : Newest Member TypeJptzyV"
},
{
"Value": "5630d46a-22ec-4252-9cbb-1db9b36c624c",
"Text": "NAjpytJY : Newest Member TypejpytJY"
},
{
"Value": "1a9e8dd0-9955-4a6d-9c81-0f8f5db9a1b2",
"Text": "NAjQrcXo : Newest Member TypejQrcXo"
},
{
"Value": "a9e5c6d8-4ab1-4d9f-bc7f-814bed5796eb",
"Text": "NAJt5N75 : Newest Member TypeFirstPayJt5N75"
},
{
"Value": "d11c5488-1420-4861-a071-b1e410e6971d",
"Text": "NAJt5N75 : Newest Member TypePercentPaidJt5N75"
},
{
"Value": "87384de0-d965-4d42-a3fd-bb585bb1c304",
"Text": "NAjuS6Ur : Newest Member TypejuS6Ur"
},
{
"Value": "9fce8161-dd70-4f59-8c43-3a404a0384dc",
"Text": "NAJVchD2 : Newest Member TypeJVchD2"
},
{
"Value": "78c23c94-4ed1-4a2c-a325-3050becc6981",
"Text": "NAjxENWr : Newest Member TypejxENWr"
},
{
"Value": "44193b56-3c4b-40e9-8ac4-4fe8baa160e1",
"Text": "NAK66DUK : Newest Member TypeK66DUK"
},
{
"Value": "4895a43c-a4ec-45ad-a9ff-35db495b00dd",
"Text": "NAkCX4gZ : Newest Member TypekCX4gZ"
},
{
"Value": "2a6a0889-f3a5-41fc-b3b7-c99e80e1d38b",
"Text": "NAkgHDsS : Newest Member TypekgHDsS"
},
{
"Value": "45f97cb4-712d-42b7-84fb-dfcafcbfe70a",
"Text": "NAKJmlUL : Newest Member TypeKJmlUL"
},
{
"Value": "86cf45ee-29b9-41ce-b0fe-a5dbdbf182a0",
"Text": "NAkMvY2t : Newest Member TypekMvY2t"
},
{
"Value": "e1a0dbf5-bf57-41c4-909d-26fed6d6b5fc",
"Text": "NAKrQ68K : Newest Member TypeKrQ68K"
},
{
"Value": "b9281fed-efaa-4319-b1b5-6a8749242f7f",
"Text": "NAkvIDCU : Newest Member TypekvIDCU"
},
{
"Value": "91a6d75f-adfd-47f5-8893-23bf94247882",
"Text": "NAl1DShO : Newest Member Typel1DShO"
},
{
"Value": "25fcbf8d-cc28-491a-bfee-65e37a2b9248",
"Text": "NAL2WMmP : Newest Member TypeL2WMmP"
},
{
"Value": "bac5cbde-4c7b-4f92-a09c-cadfb63da9ad",
"Text": "NAL6qMFF : Newest Member TypeL6qMFF"
},
{
"Value": "185ca5bd-c244-4f3c-8236-d6b63ced22b8",
"Text": "NALBicHr : Newest Member TypeLBicHr"
},
{
"Value": "2c0aa49d-d1fe-4c32-94aa-1b5b50915d8a",
"Text": "NALbiKi5 : Newest Member TypeLbiKi5"
},
{
"Value": "065d47f0-c183-40de-823a-951832efbf16",
"Text": "NAlCwhPa : Newest Member TypelCwhPa"
},
{
"Value": "96c8e0c1-7dbd-469b-8481-17da4082ea69",
"Text": "NAlcZGCp : Newest Member TypelcZGCp"
},
{
"Value": "252530d9-280d-4776-a869-ab96d5d9e453",
"Text": "NALdHHuq : Newest Member TypeLdHHuq"
},
{
"Value": "8c448e07-5eba-47c7-a35b-6d8b8e5f271e",
"Text": "NALdHHuq : Newest Member Typexr6fmk"
},
{
"Value": "a392be51-aae6-446f-aaa7-0d4ace9877f2",
"Text": "NAlFGbfy : Newest Member TypeFirstPaylFGbfy"
},
{
"Value": "5a7d8e60-b86b-463c-9c74-63ca3cb0f5e4",
"Text": "NAlFGbfy : Newest Member TypePercentPaidlFGbfy"
},
{
"Value": "fadf99b6-7811-4ce7-938c-c287a8057d7f",
"Text": "NAlfquEj : 747260abe5d83fc9"
},
{
"Value": "274801d7-f182-4eda-9974-8d894eed3200",
"Text": "NAlfquEj : Newest Member TypelfquEj"
},
{
"Value": "52fc81fd-5680-4367-ba3c-b90f40ebc048",
"Text": "NALi3yil : Newest Member Type1upXpz"
},
{
"Value": "e74ef521-ff55-4c77-93e8-d07430f6dbf8",
"Text": "NALi3yil : Newest Member Type5osSwh"
},
{
"Value": "d5841732-d34b-47fd-8c00-eb82374e5054",
"Text": "NALi3yil : Newest Member Type6BSxLG"
},
{
"Value": "2efe0b4b-5198-479e-a635-28b1c3fe3af8",
"Text": "NALi3yil : Newest Member TypeB5rNwS"
},
{
"Value": "b8485bb4-6090-4bcb-83c6-ef2337dd9ecf",
"Text": "NALi3yil : Newest Member TypeEH04h9"
},
{
"Value": "af1ed511-8829-4909-bf92-ea150409fc44",
"Text": "NALi3yil : Newest Member TypeFdxyWc"
},
{
"Value": "54017660-7590-407c-a339-98d2eb31ccdf",
"Text": "NALi3yil : Newest Member TypeFkifZ5"
},
{
"Value": "04e6a64b-2902-4865-a927-c52234ea85d8",
"Text": "NALi3yil : Newest Member Typeflphe8"
},
{
"Value": "dcbdc2f6-730f-4453-867c-2926570bc4d0",
"Text": "NALi3yil : Newest Member Typegn3wxm"
},
{
"Value": "6fafeeb3-bb18-4dfa-89bf-257815c1f573",
"Text": "NALi3yil : Newest Member TypehB42hK"
},
{
"Value": "47b22457-c86c-4595-b8c3-9d7c450f50d7",
"Text": "NALi3yil : Newest Member Typehgv2gL"
},
{
"Value": "396d9ecf-07d1-48f8-bac7-c9fb996984f6",
"Text": "NALi3yil : Newest Member TypeIhoBLp"
},
{
"Value": "330abc60-5187-4f96-8978-adb43761d71b",
"Text": "NALi3yil : Newest Member Typej88WJY"
},
{
"Value": "80faca4e-1e4e-485f-b0db-4bf849d0f388",
"Text": "NALi3yil : Newest Member TypeKL9XbR"
},
{
"Value": "4d926f6b-bcb8-4ec0-85f6-b1d87ef2c5db",
"Text": "NALi3yil : Newest Member TypeKNQMVH"
},
{
"Value": "5d637d88-542e-4c00-aa2f-87d5ec6ed9bd",
"Text": "NALi3yil : Newest Member TypeoGTeyi"
},
{
"Value": "3b298d80-605e-401a-b864-1524222829d3",
"Text": "NALi3yil : Newest Member TypeOi3Oi5"
},
{
"Value": "db08c9d2-0e1d-48dc-a090-c00af3496c6b",
"Text": "NALi3yil : Newest Member Typep0YBxg"
},
{
"Value": "dde2b2a9-654f-490c-84c0-3178b5a4a5d6",
"Text": "NALi3yil : Newest Member Typep5HfLb"
},
{
"Value": "ea96ba51-63d4-4cbd-93fa-2c1f634f91a9",
"Text": "NALi3yil : Newest Member Typep8PKjC"
},
{
"Value": "6d28718e-5f42-4355-a6c3-7531b050a4a3",
"Text": "NALi3yil : Newest Member TypeQtWaAt"
},
{
"Value": "ca1d36ee-08b9-442d-b917-bb366f706ec9",
"Text": "NALi3yil : Newest Member TypeS1oTzm"
},
{
"Value": "2ac34cfa-844d-4e7a-900b-dacf85e83567",
"Text": "NALi3yil : Newest Member TypeSKpw9A"
},
{
"Value": "bba7cc39-5f92-4d20-9ef9-2221fe8c8b01",
"Text": "NALi3yil : Newest Member TypeVE0Gch"
},
{
"Value": "fa421554-e1fd-47f7-9695-639be456a514",
"Text": "NAlooSWa : Newest Member TypelooSWa"
},
{
"Value": "130a7936-7a0e-4ace-a507-0fa12911521c",
"Text": "NALpkBp2 : Newest Member TypeKuCTEp"
},
{
"Value": "a27375fb-c414-4e5d-b8c7-994882c7ca92",
"Text": "NAlPRyfl : Newest Member TypelPRyfl"
},
{
"Value": "fbcd8224-a4c7-444b-99b8-3048284cd8a9",
"Text": "NALQl1Bf : Newest Member TypeLQl1Bf"
},
{
"Value": "e9b6c1fe-2d7e-4649-ad71-0779b911911f",
"Text": "NALV8AFU : Newest Member TypeLV8AFU"
},
{
"Value": "30a6e215-cda7-4160-8948-701507522b53",
"Text": "NALxwAAP : Newest Member TypeLxwAAP"
},
{
"Value": "0a4a5fe2-b985-419c-bf04-b03682edf749",
"Text": "NALziAfu : Newest Member TypeLziAfu"
},
{
"Value": "8543fd22-2307-4edf-8c97-2783ef52bebe",
"Text": "NALzWNjE : Newest Member TypeLzWNjE"
},
{
"Value": "bc354fb4-a0d8-4649-879b-b947669758e2",
"Text": "NAM3Twlh : Newest Member TypeM3Twlh"
},
{
"Value": "a83e1d52-6511-47b6-800b-32006c70b2f0",
"Text": "NAMgJumK : Newest Member TypeMgJumK"
},
{
"Value": "6efe7472-decb-4922-855a-3f8ee95b57ce",
"Text": "NAMgykpn : Newest Member TypeMgykpn"
},
{
"Value": "e50fe976-d2a8-4579-8e8f-b7954f5d3ce3",
"Text": "NAmhj14B : 1ca7b0f29d7206c8"
},
{
"Value": "a78faa3d-e596-4c69-ad3f-d557766b2f3b",
"Text": "NAmhj14B : Newest Member Typemhj14B"
},
{
"Value": "07abf1bf-d147-4301-937b-efbe0af5517d",
"Text": "NAMIh78S : Newest Member TypeMIh78S"
},
{
"Value": "6712e352-0daa-4f39-a386-889a06211626",
"Text": "NAMKBzQB : Newest Member TypeMKBzQB"
},
{
"Value": "784a4948-18cb-4295-8a28-21b8a08901d6",
"Text": "NAMnYRty : Newest Member TypeMnYRty"
},
{
"Value": "4388dde6-a717-403e-94ea-1d00fafc65cc",
"Text": "NAMrtaZk : Newest Member TypeMrtaZk"
},
{
"Value": "b29b4c5c-d6a0-41fe-9667-69a284f7daee",
"Text": "NAMUPvnK : Newest Member TypeMUPvnK"
},
{
"Value": "2dd5ae28-8baf-46fa-b819-681e55582046",
"Text": "NAMWD5xB : Newest Member TypeMWD5xB"
},
{
"Value": "91e144e5-d3f2-4470-925e-ecf1b7253c0d",
"Text": "NAMZKtqH : a2daf1bed408595c"
},
{
"Value": "e0bd1735-f46a-455c-8f1e-cd3e69b47b01",
"Text": "NAMZKtqH : Newest Member TypeMZKtqH"
},
{
"Value": "a5fb8fd6-da2c-4bea-9b3e-5cd113bf834c",
"Text": "NAN4U5li : Newest Member TypeN4U5li"
},
{
"Value": "1517099f-c21e-4049-9b95-925374de6360",
"Text": "NAn8MPYf : Newest Member Typen8MPYf"
},
{
"Value": "7bd968c1-9ebe-452a-8315-c1e1c194cbbe",
"Text": "NANfxiBB : Newest Member TypeInvBatchClNfxiBB"
},
{
"Value": "ff7ccca7-3df1-406d-b2f8-0ee6c2208ea1",
"Text": "NANgE8qT : Newest Member TypeNgE8qT"
},
{
"Value": "08766e94-88a7-4239-b78c-8e571cb3368e",
"Text": "NAniPD2r : Newest Member TypejHuD4B"
},
{
"Value": "d92bda06-86f1-43ed-bfa3-16a425a3b4c8",
"Text": "NANMZzQ4 : Newest Member TypeNMZzQ4"
},
{
"Value": "12a5a65b-1023-4c92-baff-ca8b6b388871",
"Text": "NAnnTaOy : Newest Member TypennTaOy"
},
{
"Value": "8f911b1e-45e1-4589-beb2-cd0a4a039c7b",
"Text": "NAnOoEdl : Newest Member TypenOoEdl"
},
{
"Value": "886377fb-a462-423b-b168-e68d709ea42a",
"Text": "NANoxR7N : Newest Member TypeNoxR7N"
},
{
"Value": "c0441683-a1cc-4b19-aa5b-56be21c57183",
"Text": "NANpBQbP : Newest Member TypeNpBQbP"
},
{
"Value": "744abc20-d5dd-4b88-8a2b-e1d669f3ab9d",
"Text": "NANrbsUE : Newest Member TypeNrbsUE"
},
{
"Value": "7ab55cf9-345d-4e06-9f27-85f9f0ba1031",
"Text": "NAoCOSaz : Newest Member TypeoCOSaz"
},
{
"Value": "d4b29d56-199d-4050-a5c0-091af0f57920",
"Text": "NAoEh4xj : Newest Member TypeoTz7Mo"
},
{
"Value": "a5d907d4-0bfa-464d-b976-a94d76ce4196",
"Text": "NAoJf2TH : Newest Member TypeoJf2TH"
},
{
"Value": "7ecc1e72-afff-4172-877c-5f7ff1a26c84",
"Text": "NAoLIcKi : Newest Member TypeoLIcKi"
},
{
"Value": "32328c42-1258-478a-9d8f-edae72cc1d7e",
"Text": "NAoLoSxj : Newest Member TypeoLoSxj"
},
{
"Value": "2ff666d4-ae77-4337-ad9e-80cdf2103f34",
"Text": "NAOnW8BZ : Newest Member TypeFirstPayOnW8BZ"
},
{
"Value": "39b0d311-027c-46c0-8420-d3b0f209cd67",
"Text": "NAOnW8BZ : Newest Member TypePercentPaidOnW8BZ"
},
{
"Value": "99e171f0-af11-4894-baf4-c430e69816c0",
"Text": "NAOoEsx8 : Newest Member TypeOoEsx8"
},
{
"Value": "c093395a-c047-491a-854a-056d4eb9a40c",
"Text": "NAoOKqvG : Newest Member TypeoOKqvG"
},
{
"Value": "7758a36a-41e3-4231-b55f-9ccc60a2a700",
"Text": "NAoPCKB0 : Newest Member TypeoPCKB0"
},
{
"Value": "59356cd2-32ae-49d3-a36f-e4fcf02daadb",
"Text": "NAoQty3Q : Newest Member TypeoQty3Q"
},
{
"Value": "5cb30cb5-403f-4f3e-a47a-65e0c36f3f24",
"Text": "NAOS9Q9i : Newest Member TypeOS9Q9i"
},
{
"Value": "e4c79416-fc72-41fc-acf5-be7d90d70d24",
"Text": "NAOT3sac : Newest Member TypeOT3sac"
},
{
"Value": "56ce6e3d-1106-4429-8d74-1e1947d27e63",
"Text": "NAoV5jng : Newest Member TypeoV5jng"
},
{
"Value": "b29a1cc5-1f5f-46e1-bcce-94279d760229",
"Text": "NAoZwV2b : Newest Member TypeoZwV2b"
},
{
"Value": "fc4a327e-5e33-4adc-8945-f7ac5a909b6b",
"Text": "NAP7aM1e : Newest Member TypeP7aM1e"
},
{
"Value": "d3b8d66a-6426-478d-a454-24b45af3e691",
"Text": "NAP8kZ2m : Newest Member TypeP8kZ2m"
},
{
"Value": "cd85324e-5f9a-4998-afad-9f62c927c9c9",
"Text": "NApBRFUQ : Newest Member TypepBRFUQ"
},
{
"Value": "b6033791-157c-45e1-abe6-4c0a3db75edc",
"Text": "NApgwWUL : Newest Member TypepgwWUL"
},
{
"Value": "99c98952-c95f-4440-840e-fae6a666d658",
"Text": "NApiVb0E : 489d30ecaa3dac5b"
},
{
"Value": "4d1fffcb-df31-4057-b840-38eeadce5097",
"Text": "NApiVb0E : Newest Member TypepiVb0E"
},
{
"Value": "ea65b497-5d35-412a-8f85-649d27308107",
"Text": "NAQce5fC : Newest Member TypeQce5fC"
},
{
"Value": "fd303117-287b-4518-9b01-c72c6d409cbc",
"Text": "NAqCfUOx : Newest Member TypeqCfUOx"
},
{
"Value": "40478bf3-cb8b-42f2-9c9e-a87e22fcd1f5",
"Text": "NAQi1VoL : Newest Member TypeQi1VoL"
},
{
"Value": "cb5b6e66-675d-4c30-86ca-caffad813e5f",
"Text": "NAQI99JB : Newest Member TypegKMHxS"
},
{
"Value": "3800c99c-e21e-4d2c-b2c1-205e9e2b8b20",
"Text": "NAQLMTs8 : Newest Member TypeQLMTs8"
},
{
"Value": "61161210-43bb-46da-9060-ce21c8fd64e3",
"Text": "NAqPeNlC : Newest Member TypeqPeNlC"
},
{
"Value": "b4ab8528-3bbe-41ca-be02-1614d0ca4f58",
"Text": "NAqrdqT3 : Newest Member TypeqrdqT3"
},
{
"Value": "252f4b7f-a92d-4681-9d19-9969d27b77ac",
"Text": "NAQTw4Cr : Newest Member TypeQTw4Cr"
},
{
"Value": "a2c5c3ff-f02f-483e-a20d-1e7937a97a36",
"Text": "NAqylDBq : Newest Member TypeqylDBq"
},
{
"Value": "12b45c2f-4f6d-4f37-b5a5-e939254b0dcf",
"Text": "NAqylDBq : Newest Member TypesQTWRQ"
},
{
"Value": "1dcff80b-7368-4180-99da-c69a5eba4e9d",
"Text": "NAr8uYrN : Newest Member TypeFirstPayr8uYrN"
},
{
"Value": "cb19f8b7-44f6-4e12-a5f0-455895126add",
"Text": "NAr8uYrN : Newest Member TypePercentPaidr8uYrN"
},
{
"Value": "4073704a-8185-4022-b31e-50a7b91bdeba",
"Text": "NARcAfkC : Newest Member TypeRcAfkC"
},
{
"Value": "d50d9ded-bdcc-4d82-9e79-c86d392243d5",
"Text": "NArfzmuG : Newest Member TyperfzmuG"
},
{
"Value": "e292a458-8fab-40fd-97a4-eef064939943",
"Text": "NArGMWP7 : Newest Member TyperGMWP7"
},
{
"Value": "394aec0f-782b-441d-b866-5e9cc183a519",
"Text": "NARhhfcT : Newest Member TypePbtiYN"
},
{
"Value": "8509bf42-00ab-46ee-bebc-0603f1b91bbf",
"Text": "NARhhfcT : Newest Member TypeRhhfcT"
},
{
"Value": "299fcd20-6c92-4393-b27b-a8bc7acc161f",
"Text": "NArHrMcf : Newest Member TyperHrMcf"
},
{
"Value": "5d258f08-b3ff-47a3-bcd3-1c4ad39fecfd",
"Text": "NArkFOKZ : Newest Member TyperkFOKZ"
},
{
"Value": "6e77bc73-3ca5-41f3-895c-d240b68cd3b2",
"Text": "NArSSyDt : Newest Member TyperSSyDt"
},
{
"Value": "10576a8e-28dd-47d2-8394-78702ce661f8",
"Text": "NARUCQne : Newest Member TypeRUCQne"
},
{
"Value": "2b8c7f07-5a93-4523-919a-e0cf51e3fa40",
"Text": "NArY4HUM : Newest Member TyperY4HUM"
},
{
"Value": "1fcae0ca-4c66-485d-9079-b7d7707516cc",
"Text": "NAS0NWFi : Newest Member TypeS0NWFi"
},
{
"Value": "33643f2a-2a2b-4749-8b74-60baaa22dd3f",
"Text": "NAs7CiMv : Newest Member TypeTTilrr"
},
{
"Value": "4933600c-7041-49a5-9b3c-736fb5d41cd1",
"Text": "NAs9OyDo : Newest Member Type09WKw1"
},
{
"Value": "1fb9cd6a-648f-4a7b-a2a1-f4f1da968107",
"Text": "NAs9OyDo : Newest Member Types9OyDo"
},
{
"Value": "1d8f193f-9da2-4065-8668-42da663a621a",
"Text": "NAsBUjri : Newest Member TypesBUjri"
},
{
"Value": "717bd471-a327-4255-af02-8a7969c6414c",
"Text": "NAsFFKbC : Newest Member TypesFFKbC"
},
{
"Value": "040e3c4c-7207-4e73-8dcc-075758db8fd0",
"Text": "NAsHDuyK : Newest Member TypesHDuyK"
},
{
"Value": "54f611a3-a485-499d-b8dc-b208ff90c798",
"Text": "NASmaW8q : 32bfea4cd5702765"
},
{
"Value": "fd1c1aeb-544e-4e23-9ff8-698c68cf63bf",
"Text": "NASmaW8q : Newest Member TypeSmaW8q"
},
{
"Value": "d02d5936-3077-4b6c-89ff-11b914f1ae1c",
"Text": "NASnMtUP : Newest Member TypeSnMtUP"
},
{
"Value": "2a8aeee9-6cdd-47d8-819a-d9bf54ad8eaa",
"Text": "NAsT4o4S : Newest Member TypesT4o4S"
},
{
"Value": "a000e485-2252-4ca5-a996-c1a68fb68158",
"Text": "NASuF8K4 : Newest Member TypeSuF8K4"
},
{
"Value": "2d301537-8268-4e92-b26b-c47be2cc326c",
"Text": "NASugekK : Newest Member TypeSugekK"
},
{
"Value": "3188ac6f-6e58-4b11-a093-2af8f2642dc3",
"Text": "NAsy5VHR : Newest Member TypeOcZNNj"
},
{
"Value": "354d92bd-f924-4632-a294-54670c902992",
"Text": "NAsy5VHR : Newest Member Typesy5VHR"
},
{
"Value": "9a6ae12d-e123-4329-a113-9f4711662635",
"Text": "NAT4mn4N : Newest Member TypeT4mn4N"
},
{
"Value": "f7d95feb-8eff-4231-8f8b-86397bb5d017",
"Text": "NATbynvN : Newest Member TypeTbynvN"
},
{
"Value": "359eaf13-dc0b-4550-857d-1c266b8462d0",
"Text": "NAtkJLPo : Newest Member TypetkJLPo"
},
{
"Value": "e8a4f473-5240-473a-a4b1-89ad4a353c8e",
"Text": "NATkOVat : Newest Member TypeoALV5j"
},
{
"Value": "cd944d1a-e143-48bc-be89-51b9050a5842",
"Text": "NATkOVat : Newest Member TypeTkOVat"
},
{
"Value": "8a36cb4c-ef01-431d-90bc-cb67730655c2",
"Text": "NATLHkLc : Newest Member TypeTLHkLc"
},
{
"Value": "8dedde2e-4d94-4da1-93aa-6c1405456ad6",
"Text": "NATlUlLm : Newest Member TypeTlUlLm"
},
{
"Value": "04debdba-6d69-4ed6-a86d-fa755dcbe4e8",
"Text": "NAttoIPa : 9cb5f44ba6f1c70c"
},
{
"Value": "965e6318-4a2a-4191-97d8-79c097894ef8",
"Text": "NAttoIPa : Newest Member TypettoIPa"
},
{
"Value": "5638ae37-3746-4168-b19f-a0d92de53d93",
"Text": "NAtUJ6jf : Newest Member TypetUJ6jf"
},
{
"Value": "9c67dc19-e4e1-44f2-89fd-ec57ec928aa1",
"Text": "NAtwT0Hd : Newest Member TypetwT0Hd"
},
{
"Value": "92cd5d4e-ad69-49c4-b0a5-782a8905dda5",
"Text": "NAtXAghj : Newest Member TypetXAghj"
},
{
"Value": "5a1f0b75-9860-4d55-bd75-b8682be80ca9",
"Text": "NAtXIVWQ : Newest Member TypeCw8b90"
},
{
"Value": "43feb852-5c08-4200-86ed-9c798e79db01",
"Text": "NATzjWlR : Newest Member TypeTzjWlR"
},
{
"Value": "9e134fcd-e3af-408a-8097-7b321d1fa5ea",
"Text": "NAU7IhTG : Newest Member TypeU7IhTG"
},
{
"Value": "e3e92a32-aed6-4150-882b-8971ce482ce4",
"Text": "NAuFWi57 : Newest Member TypeuFWi57"
},
{
"Value": "67753a0b-b19a-4ceb-889b-5f82b8b2e1e1",
"Text": "NAUrHqzn : 9c2f1297ceb376a3"
},
{
"Value": "25b99300-f3a7-4b94-81ab-b81a4d174cb7",
"Text": "NAUrHqzn : Newest Member TypeUrHqzn"
},
{
"Value": "592e5845-a254-4ead-b202-f3bf3ecb09c0",
"Text": "NAuzBMgl : Newest Member TypeuzBMgl"
},
{
"Value": "b273b70a-d66f-438a-9153-c41c15cbc328",
"Text": "NAv4buh8 : Newest Member Typev4buh8"
},
{
"Value": "a75b5e10-a4ad-4442-bc28-7eb91a5cd10c",
"Text": "NAv8TuxR : Newest Member Typev8TuxR"
},
{
"Value": "030cbb21-d880-4503-b9b2-50ec57ef2045",
"Text": "NAvhisdu : Newest Member Typevhisdu"
},
{
"Value": "2628ca7a-6f9c-4a92-a43d-d2fe8dc6acc3",
"Text": "NAvijnKE : Newest Member TypevijnKE"
},
{
"Value": "f562ded2-cf50-4c97-8e8b-ebfb56cee34b",
"Text": "NAviQeDx : Newest Member Typen63Qd9"
},
{
"Value": "9c5d4946-38c9-4204-b7d9-f3d6eb044b5f",
"Text": "NAviQeDx : Newest Member TypeviQeDx"
},
{
"Value": "28182b50-737a-4100-b8fb-0354496ad19a",
"Text": "NAvNDzGM : Newest Member TypevNDzGM"
},
{
"Value": "d783f2b2-4098-4095-995a-1b97f35cf90a",
"Text": "NAVp9kNq : Newest Member TypeVp9kNq"
},
{
"Value": "50d84056-f726-4995-bc00-dbda8c3da101",
"Text": "NAVPXsq3 : Newest Member TypeVPXsq3"
},
{
"Value": "d1c1ba69-9896-4071-978f-9f2671c7e7a3",
"Text": "NAvqnDpG : Newest Member TypevqnDpG"
},
{
"Value": "7dbf3361-d9af-4854-8345-2ea91809369c",
"Text": "NAvUwKWf : Newest Member TypeFirstPayvUwKWf"
},
{
"Value": "c67e9ecc-4cd9-458f-a3a6-3f588a5f8e88",
"Text": "NAvUwKWf : Newest Member TypePercentPaidvUwKWf"
},
{
"Value": "b87e834d-96be-4262-b24e-b22df4a2cbdc",
"Text": "NAVy1Ey0 : Newest Member TypeVy1Ey0"
},
{
"Value": "e318ed22-2588-4e60-aafc-62c5d95ce556",
"Text": "NAwcHmI6 : Newest Member TypeIPYs9t"
},
{
"Value": "61ee00d3-3c90-45c6-b1a8-3ea1075ad9ae",
"Text": "NAwcHmI6 : Newest Member TypewcHmI6"
},
{
"Value": "ad6f8191-fb10-4635-bb91-5f69a3004131",
"Text": "NAWeA31l : Newest Member TypeWeA31l"
},
{
"Value": "495d9240-8140-4ef4-b025-fe6e8e23164f",
"Text": "NAWeXjBa : Newest Member TypeWeXjBa"
},
{
"Value": "e67f4461-f56e-4594-8933-f985d2850aad",
"Text": "NAwFhp5L : Newest Member TypewFhp5L"
},
{
"Value": "ef56ed83-f0ee-4879-b735-84661ec02847",
"Text": "NAWh57XQ : Newest Member TypeWh57XQ"
},
{
"Value": "5ca7c899-546c-4105-932c-82d7d59e9e34",
"Text": "NAwi7MrG : 32f7b1f9883dc29a"
},
{
"Value": "2af9e3db-6c67-4e98-96a6-d36c1bab8e03",
"Text": "NAwi7MrG : Newest Member Typewi7MrG"
},
{
"Value": "e043b726-4357-4d18-bdac-743f5d7f681e",
"Text": "NAWiaRFk : Newest Member TypeWiaRFk"
},
{
"Value": "075e882b-2a84-477e-a782-028ac06a8383",
"Text": "NAwmxllC : Newest Member TypewmxllC"
},
{
"Value": "f641ae6d-c236-4c44-b85d-93f11c05ea34",
"Text": "NAWPZyAh : Newest Member TypeFirstPayWPZyAh"
},
{
"Value": "3bb20341-6ebc-4562-b728-df4b7afa782e",
"Text": "NAWPZyAh : Newest Member TypePercentPaidWPZyAh"
},
{
"Value": "1fb23b2e-8c5b-4e15-b076-838f3931990a",
"Text": "NAWQYUkU : Newest Member TypeWQYUkU"
},
{
"Value": "f9f0bed9-128d-4e45-bc2a-6910a5f901ca",
"Text": "NAx4D50Y : Newest Member Typex4D50Y"
},
{
"Value": "d0d2a9b6-4283-4fa6-b3bf-6a05903db445",
"Text": "NAXfh19d : Newest Member TypeXfh19d"
},
{
"Value": "bd0ffe54-868c-4632-90b7-913f08059426",
"Text": "NAxnGgwu : 7ff197665a4e685e"
},
{
"Value": "3180220e-7eab-4ada-92aa-729b9f940627",
"Text": "NAxnGgwu : Newest Member TypexnGgwu"
},
{
"Value": "38d9a2a8-9129-4b35-99fa-d9a0687d8fde",
"Text": "NAXogE1n : Newest Member TypeFirstPayXogE1n"
},
{
"Value": "785fcfad-d0c3-428f-a551-1ac5b89be179",
"Text": "NAXogE1n : Newest Member TypePercentPaidXogE1n"
},
{
"Value": "34366d00-00ba-4b9a-9759-74395795198b",
"Text": "NAXtxnUy : Newest Member TypeXtxnUy"
},
{
"Value": "0b5115c8-153b-4991-bcc1-24759b092b70",
"Text": "NAxvREGK : Newest Member TypexvREGK"
},
{
"Value": "734dd2ba-f49b-4461-8ae1-a5582037bab2",
"Text": "NAY7q9DD : Newest Member TypeY7q9DD"
},
{
"Value": "abebc143-b43f-4521-b927-6b65b0af50e3",
"Text": "NAYAWnL6 : Newest Member TypeYAWnL6"
},
{
"Value": "e914c111-c8b1-4891-bc22-2d89be13c297",
"Text": "NAYb95rA : Newest Member TypeYb95rA"
},
{
"Value": "94e0e6d6-9cfd-45f7-8b15-430b974a7d8a",
"Text": "NAYFNCRI : Newest Member TypeYFNCRI"
},
{
"Value": "3b0c0075-67fa-474b-8acf-f69c9335e7e1",
"Text": "NAYg2Vdn : Newest Member TypeYg2Vdn"
},
{
"Value": "aab87d35-3b84-452f-8caa-345f18645e24",
"Text": "NAympNUe : Newest Member TypeympNUe"
},
{
"Value": "20ca8864-66b3-4eb8-9d60-fb06c87e19c6",
"Text": "NAYNMh5g : Newest Member TypeYNMh5g"
},
{
"Value": "b42fa7ed-86c8-47d9-82f8-493d7239c284",
"Text": "NAYR0IxG : Newest Member TypeYR0IxG"
},
{
"Value": "090e0541-d337-4b93-8179-3b166e2c0925",
"Text": "NAYRG3cN : Newest Member TypeYRG3cN"
},
{
"Value": "d3439c50-5672-4a8a-9104-050ed5d1e390",
"Text": "NAywrjmV : Newest Member TypeywrjmV"
},
{
"Value": "efa1b492-1ec1-4f9d-8694-6b46c2ec48e8",
"Text": "NAyWU3N7 : Newest Member TypeyWU3N7"
},
{
"Value": "7b89efd6-d6fc-4085-afed-63fc10fc2fc2",
"Text": "NAyzCePT : Newest Member TypeyzCePT"
},
{
"Value": "5025389c-8400-4f7b-9e34-fd64003de188",
"Text": "NAZ6pcoy : Newest Member TypeZ6pcoy"
},
{
"Value": "37f76dd4-4828-4b2e-8910-c2bf1686de25",
"Text": "NAz8KC4v : 75a806aa02696a69"
},
{
"Value": "460461ee-a683-4676-a65f-f05fb1254509",
"Text": "NAz8KC4v : Newest Member Typez8KC4v"
},
{
"Value": "581a76fe-1350-4d4d-9912-28b51ec9ef1a",
"Text": "NAZBnReM : Newest Member TypeZBnReM"
},
{
"Value": "84063bff-2e7f-471e-87c3-f34495fff1c0",
"Text": "NAZDjLcq : Newest Member Type48fk9P"
},
{
"Value": "201add3e-6866-4a8b-9372-04648a05e09c",
"Text": "NAZDjLcq : Newest Member TypeZDjLcq"
},
{
"Value": "06ecbaa8-f1c8-4c90-8af3-f091266510db",
"Text": "NAzDOfi6 : Newest Member TypezDOfi6"
},
{
"Value": "97cd9191-a38f-42b5-b03a-c86ec9d5b75c",
"Text": "NAzeKlq7 : Newest Member TypeFirstPayzeKlq7"
},
{
"Value": "c1d5b16e-ca63-4231-a293-656b53f30ddd",
"Text": "NAzeKlq7 : Newest Member TypePercentPaidzeKlq7"
},
{
"Value": "c33bfe0e-0290-4e99-8ede-b248a07aaf70",
"Text": "NAzeZPHo : Newest Member TypeFirstPayzeZPHo"
},
{
"Value": "e4cd39b9-eccb-42ed-85a5-80286974d942",
"Text": "NAzeZPHo : Newest Member TypePercentPaidzeZPHo"
},
{
"Value": "a38679d0-803e-417f-9f80-4687ded259dc",
"Text": "NAZIw8v7 : Newest Member TypeZIw8v7"
},
{
"Value": "b95f2135-be35-4781-bb34-93702d3e825e",
"Text": "NAzkdQOX : Newest Member TypezkdQOX"
},
{
"Value": "37f9628b-56f8-44fa-9da9-2ac76c5acd8e",
"Text": "NAzmjKXg : Newest Member TypezmjKXg"
},
{
"Value": "be664cf5-1cd4-4215-ba7c-c019d7dcede5",
"Text": "NAzrVju0 : Newest Member TypeFirstPayzrVju0"
},
{
"Value": "263e5fe5-5608-4e4c-a274-991d14ce28c5",
"Text": "NAzrVju0 : Newest Member TypePercentPaidzrVju0"
},
{
"Value": "df202614-febd-40c7-8562-64305283a1ef",
"Text": "NAzUsXct : Newest Member TypezUsXct"
},
{
"Value": "ba23175c-e666-4700-90d5-cf2793615c65",
"Text": "NAZXo7FR : Newest Member TypeZXo7FR"
},
{
"Value": "78500af1-09cf-4fe9-994b-6fbfda1d334a",
"Text": "NAZYLMmy : Newest Member TypeFtEHnx"
},
{
"Value": "6a2eecf3-582e-4843-94f3-eb4fec5ea325",
"Text": "NAZYLMmy : Newest Member TypeZYLMmy"
},
{
"Value": "bc6c77c8-0115-40ee-a515-718c5adfbc95",
"Text": "NAzzFpFj : Newest Member TypezzFpFj"
},
{
"Value": "52413985-7021-4b30-b5ad-0567d8e30969",
"Text": "NFE Assoc : NFE_REG_Type calender"
},
{
"Value": "82f6d87d-79d5-4f28-b6dc-790ee63ddd2f",
"Text": "PR123 : ABC member type"
},
{
"Value": "66430f21-7674-4d0a-b5ff-dbc588a24201",
"Text": "PSG : GROOM TYPE"
},
{
"Value": "7c0f6af2-7916-4354-953f-618552cf87f7",
"Text": "RMA : GROOM 2 TYPE"
},
{
"Value": "57fb4932-22cd-44f9-baa5-c687436f808d",
"Text": "Sept Assoc : PD VIP Sept"
}
]
}
],
"Columns": [
{
"Name": "ind_last_name",
"Description": "Last Name",
"DataType": "nvarchar",
"TableAlias": "",
"TableDescription": "Individual",
"TableName": "co_individual"
},
{
"Name": "ind_first_name",
"Description": "First Name",
"DataType": "nvarchar",
"TableAlias": "",
"TableDescription": "Individual",
"TableName": "co_individual"
},
{
"Name": "ind_mid_name",
"Description": "Middle Name",
"DataType": "nvarchar",
"TableAlias": "",
"TableDescription": "Individual",
"TableName": "co_individual"
},
{
"Name": "cst_org_name_dn",
"Description": "Organization Name",
"DataType": "nvarchar",
"TableAlias": "",
"TableDescription": "Customer",
"TableName": "co_customer"
},
{
"Name": "cst_eml_address_dn",
"Description": "Primary E-Mail",
"DataType": "av_email",
"TableAlias": "",
"TableDescription": "Customer",
"TableName": "co_customer"
},
{
"Name": "adr_line1",
"Description": "Address Line 1",
"DataType": "nvarchar",
"TableAlias": "",
"TableDescription": "Address",
"TableName": "co_address"
},
{
"Name": "adr_city_state_code",
"Description": "City, State, Post Code",
"DataType": "nvarchar",
"TableAlias": "",
"TableDescription": "Address",
"TableName": "co_address"
},
{
"Name": "cst_no_email_flag",
"Description": "Do Not Contact by Email",
"DataType": "av_flag",
"TableAlias": "",
"TableDescription": "Customer",
"TableName": "co_customer"
}
]
}