GetQueryDefinition
|
Initial Build |
2007.01 |
|
xWEB |
Web Method |
|
Response Type |
XML Node |
This web method is used to document the List Table setup for a specific Facade Object to use the GetQuery web method most effectively. This method first appears in 2007.01.
In order to use GetQuery, you will need to know which tables and columns are available, and in the case where a single Table is represented more than once in a List Table setup (which is a common occurance), you will need to know the table alias to use in your GetQuery calls to avoid "ambiguous column name" errors.
This web method returns all that information in a XmlNode.
You will need to pass the Facade Object name as a parameter (for example, Individual or Organization).
Note: This web method is not intended to be used in production, but only as a reference or for documentation.
Only Tables and Columns the xWeb User is authorized to select will be returned, based on the underlying netFORUM group table/column security model.
Please see Xweb Laboratory for an interactive web site developed by Avectra that provides a visual, interactive result of GetQueryDefinition.
Parameters
szObjectName (string). The Object name. See XWeb:GetFacadeObjectList#Object_Name for more direction on this parameter.
Response
XML Node
Sample Request
Pass the Object name in szObjectName.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ns="http://www.avectra.com/2005/">
<soapenv:Header>
<ns:AuthorizationToken>
<ns:Token>77497299-ab40-43f3-9cc0-d38b23e82d18</ns:Token>
</ns:AuthorizationToken>
</soapenv:Header>
<soapenv:Body>
<ns:GetQueryDefinition>
<ns:szObjectName>Individual</ns:szObjectName>
</ns:GetQueryDefinition>
</soapenv:Body>
</soapenv:Envelope>
Sample Response
Example of GetQueryDefinition response in the Xweb Laboratory. The outermost node ("EventsRegistrant") is the overall List Table. The next set of nodes are its From Tables. The single expanded From Table ("ev_registrant_type") shows the columns in that table that are available in GetQuery.
Shortened for brevity (as explained in comments).
Here is a condensed response structure with elements omitted:
<Object>
<ListTable>
<ListFromTables>
<ListFromTable>
<Columns>
<Column/>
<Column/>
</Columns>
<ListFromTableColumns>
<ListFromTableColumn />
<ListFromTableColumn />
</ListFromTableColumns>
</ListFromTable>
<ListFromTable>
<Columns>
<Column />
<Column />
</Columns>
</ListFromTable>
</ListFromTables>
</ListTable>
</Object>
The single <Object> root node contains the description of the object, based on the szObjectName parameter passed in.
Within the <Object> node is a single <ListTable> node contains the name of the main Table associated with the Object, as well as a <ListFromTables> node.
The <ListFromTables> node will contain a collection of one or more <ListFromTable> nodes.
Each <ListFromTable> node contain the name of the table in <lsf_from_table> as well as the alias, if any (<lsf_from_alias>). You will need to use the alias when referencing this table in GetQuery. Additionally, the join type and join expression are included for additional detail, as well as the table description (<mdt_description>).
Also within <ListFromTable> are two collections, <Columns> and <ListFromTableColumns>.
The <Columns> node will contain one or more <Column> nodes, one for each column in that table that is available in GetQuery. Each <Column> node contains the column name and additional information.
The <ListFromTableColumns> node, which may be empty, contains any default columns that are returned by the default list result if szColumnList is passed without a parameter. These are returned in one or more <ListFromTableColumn> nodes.
Here is a more complete response, with some nodes clipped for brevity (as explained in the code).
<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>1a05b44f-42a3-472b-94b6-12ccc54005f2</Token>
</AuthorizationToken>
</soap:Header>
<soap:Body>
<GetQueryDefinitionResponse xmlns="http://www.avectra.com/2005/">
<GetQueryDefinitionResult>
<Object xmlns="">
<obj_key>F41B6E06-299B-4022-BE6F-0641BA87DE59</obj_key>
<obj_name>Individual</obj_name>
<obj_description>Individual</obj_description>
<ListTable>
<lst_mdt_name>co_individual</lst_mdt_name>
<lst_select_distinct>1</lst_select_distinct>
<mdt_description>Individual</mdt_description>
<ListFromTables>
<ListFromTable>
<lsf_from_table>co_individual</lsf_from_table>
<lsf_from_alias xsi:nil="true"/>
<lsf_from_join_type xsi:nil="true"/>
<lsf_from_join xsi:nil="true"/>
<mdt_description>Individual</mdt_description>
<Columns>
<Column>
<mdc_name>ind_cst_key</mdc_name>
<mdc_description>Primary Key</mdc_description>
<mdc_data_type>av_key</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>co_individual</mdc_table_name>
<mdc_width_max>16</mdc_width_max>
</Column>
<Column>
<mdc_name>ind_prf_code</mdc_name>
<mdc_description>Prefix</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>1</mdc_nullable>
<mdc_table_name>co_individual</mdc_table_name>
<mdc_width_max>20</mdc_width_max>
</Column>
<!-- additional "Column" nodes removed for brevity -->
</Columns>
<ListFromTableColumns>
<ListFromTableColumn>
<lsc_mdc_name>ind_first_name</lsc_mdc_name>
<lsc_name_alias>First</lsc_name_alias>
<lsc_order>1</lsc_order>
</ListFromTableColumn>
<ListFromTableColumn>
<lsc_mdc_name>ind_last_name</lsc_mdc_name>
<lsc_name_alias>Last</lsc_name_alias>
<lsc_order>5</lsc_order>
</ListFromTableColumn>
</ListFromTableColumns>
</ListFromTable>
<ListFromTable>
<lsf_from_table>co_customer</lsf_from_table>
<lsf_from_alias xsi:nil="true"/>
<lsf_from_join_type>Join</lsf_from_join_type>
<lsf_from_join>
cst_key=ind_cst_key and ind_delete_flag=0
and ind_deceased_flag=0
</lsf_from_join>
<mdt_description>Customer</mdt_description>
<Columns>
<Column>
<mdc_name>cst_key</mdc_name>
<mdc_description>Customer Key</mdc_description>
<mdc_data_type>av_key</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>co_customer</mdc_table_name>
<mdc_width_max>16</mdc_width_max>
</Column>
<Column>
<mdc_name>cst_type</mdc_name>
<mdc_description>Customer Type</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>co_customer</mdc_table_name>
<mdc_width_max>20</mdc_width_max>
</Column>
<!-- additional "Column" nodes removed for brevity -->
</Columns>
<ListFromTableColumns>
<ListFromTableColumn>
<lsc_mdc_name>cst_org_name_dn</lsc_mdc_name>
<lsc_name_alias>Organization</lsc_name_alias>
<lsc_order>40</lsc_order>
</ListFromTableColumn>
<ListFromTableColumn>
<lsc_mdc_name>cst_eml_address_dn</lsc_mdc_name>
<lsc_name_alias>E-mail</lsc_name_alias>
<lsc_order>45</lsc_order>
</ListFromTableColumn>
<ListFromTableColumn>
<lsc_mdc_name>cst_no_email_flag</lsc_mdc_name>
<lsc_name_alias xsi:nil="true"/>
<lsc_order>200</lsc_order>
</ListFromTableColumn>
</ListFromTableColumns>
</ListFromTable>
<ListFromTable>
<lsf_from_table>co_customer_x_address</lsf_from_table>
<lsf_from_alias xsi:nil="true"/>
<lsf_from_join_type>Left Join</lsf_from_join_type>
<lsf_from_join>cst_cxa_key=cxa_key</lsf_from_join>
<mdt_description>Customer Address</mdt_description>
<Columns>
<Column>
<mdc_name>cxa_cst_key</mdc_name>
<mdc_description>Customer Key</mdc_description>
<mdc_data_type>av_key</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>co_customer_x_address</mdc_table_name>
<mdc_width_max>16</mdc_width_max>
</Column>
<Column>
<mdc_name>cxa_adr_key</mdc_name>
<mdc_description>Address Key</mdc_description>
<mdc_data_type>av_key</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>co_customer_x_address</mdc_table_name>
<mdc_width_max>16</mdc_width_max>
</Column>
<!-- additional "Column" nodes removed for brevity -->
</Columns>
</ListFromTable>
<!-- Additional "ListFromTable" nodes removed for brevity -->
<ListFromTable>
<lsf_from_table>co_organization</lsf_from_table>
<lsf_from_alias xsi:nil="true"/>
<lsf_from_join_type>Left Join</lsf_from_join_type>
<lsf_from_join>ixo_org_cst_key=org_cst_key</lsf_from_join>
<mdt_description>Organization</mdt_description>
<Columns>
<Column>
<mdc_name>org_cst_key</mdc_name>
<mdc_description>Organization Key</mdc_description>
<mdc_data_type>av_key</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>co_organization</mdc_table_name>
<mdc_width_max>16</mdc_width_max>
</Column>
<Column>
<mdc_name>org_name</mdc_name>
<mdc_description>Organization Name</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>co_organization</mdc_table_name>
<mdc_width_max>150</mdc_width_max>
</Column>
<!-- additional "Column" nodes removed for brevity -->
</Columns>
</ListFromTable>
<ListFromTable>
<lsf_from_table>mb_membership</lsf_from_table>
<lsf_from_alias>Membership</lsf_from_alias>
<lsf_from_join_type>Left Join</lsf_from_join_type>
<lsf_from_join>ind_cst_key = Membership.mbr_cst_key and Membership.mbr_delete_flag=0 and Membership.mbr_terminate_date is null and Membership.mbr_chp_cst_key is null</lsf_from_join>
<mdt_description>Membership</mdt_description>
<Columns>
<Column>
<mdc_name>mbr_src_code</mdc_name>
<mdc_description>Source Code</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>1</mdc_nullable>
<mdc_table_name>mb_membership</mdc_table_name>
<mdc_width_max>50</mdc_width_max>
</Column>
<Column>
<mdc_name>mbr_asn_code</mdc_name>
<mdc_description>Association</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>mb_membership</mdc_table_name>
<mdc_width_max>10</mdc_width_max>
</Column>
<Column>
<mdc_name>mbr_join_date</mdc_name>
<mdc_description>Join Date</mdc_description>
<mdc_data_type>av_date_small</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>1</mdc_nullable>
<mdc_table_name>mb_membership</mdc_table_name>
<mdc_width_max>16</mdc_width_max>
</Column>
<!-- additional "Column" nodes removed for brevity -->
</Columns>
</ListFromTable>
<ListFromTable>
<lsf_from_table>mb_member_type</lsf_from_table>
<lsf_from_alias xsi:nil="true"/>
<lsf_from_join_type>Left Join</lsf_from_join_type>
<lsf_from_join>Membership.mbr_mbt_key=mbt_key</lsf_from_join>
<mdt_description>Member Type</mdt_description>
<Columns>
<Column>
<mdc_name>mbt_key</mdc_name>
<mdc_description>Unique Key</mdc_description>
<mdc_data_type>av_key</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>mb_member_type</mdc_table_name>
<mdc_width_max>16</mdc_width_max>
</Column>
<Column>
<mdc_name>mbt_code</mdc_name>
<mdc_description>Member Type</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>mb_member_type</mdc_table_name>
<mdc_width_max>50</mdc_width_max>
</Column>
<!-- additional "Column" nodes removed for brevity -->
</Columns>
</ListFromTable>
<ListFromTable>
<lsf_from_table>mb_membership</lsf_from_table>
<lsf_from_alias>ChapterMembership</lsf_from_alias>
<lsf_from_join_type>Left Join</lsf_from_join_type>
<lsf_from_join>ind_cst_key = ChapterMembership.mbr_cst_key and ChapterMembership.mbr_delete_flag=0 and ChapterMembership.mbr_terminate_date is null and ChapterMembership.mbr_chp_cst_key is not null</lsf_from_join>
<mdt_description>Membership</mdt_description>
<Columns>
<Column>
<mdc_name>mbr_src_code</mdc_name>
<mdc_description>Source Code</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>1</mdc_nullable>
<mdc_table_name>mb_membership</mdc_table_name>
<mdc_width_max>50</mdc_width_max>
</Column>
<Column>
<mdc_name>mbr_asn_code</mdc_name>
<mdc_description>Association</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>mb_membership</mdc_table_name>
<mdc_width_max>10</mdc_width_max>
</Column>
<!-- additional "Column" nodes removed for brevity -->
</Columns>
</ListFromTable>
<ListFromTable>
<lsf_from_table>mb_membership</lsf_from_table>
<lsf_from_alias>OrgMembership</lsf_from_alias>
<lsf_from_join_type>Left Join</lsf_from_join_type>
<lsf_from_join>org_cst_key=OrgMembership.mbr_cst_key and OrgMembership.mbr_delete_flag=0 and OrgMembership.mbr_terminate_date is null and OrgMembership.mbr_chp_cst_key is null</lsf_from_join>
<mdt_description>Membership</mdt_description>
<Columns>
<Column>
<mdc_name>mbr_src_code</mdc_name>
<mdc_description>Source Code</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>1</mdc_nullable>
<mdc_table_name>mb_membership</mdc_table_name>
<mdc_width_max>50</mdc_width_max>
</Column>
<Column>
<mdc_name>mbr_asn_code</mdc_name>
<mdc_description>Association</mdc_description>
<mdc_data_type>nvarchar</mdc_data_type>
<mdc_ext>0</mdc_ext>
<mdc_nullable>0</mdc_nullable>
<mdc_table_name>mb_membership</mdc_table_name>
<mdc_width_max>10</mdc_width_max>
</Column>
<!-- additional "Column" nodes removed for brevity -->
</Columns>
</ListFromTable>
<!-- Additional "ListFromTable" nodes removed for brevity -->
</ListFromTables>
</ListTable>
</Object>
</GetQueryDefinitionResult>
</GetQueryDefinitionResponse>
</soap:Body>
</soap:Envelope>
JSON Method
POST /xWeb/JSON/GetQueryDefinition
Copy
DATA: JSON
{
"GetQueryDefinition" : {
"szObjectName" : "mb_committee_x_customer"
}
}
Copy
SAMPLE RESULT
HTTP STATUS: 200
DATA: JSON
{
"obj_key": "4777BE72-E0B5-4B3C-8FBD-836333CA08C2",
"obj_name": "mb_committee_x_customer",
"obj_description": "Committee Participation",
"ListTable": {
"lst_mdt_name": "mb_committee_x_customer",
"lst_select_distinct": "1",
"mdt_description": "Committee Participant",
"ListFromTables": [
{
"lsf_from_table": "mb_committee_x_customer",
"lsf_from_alias": "",
"lsf_from_join_type": "",
"lsf_from_join": "",
"Columns": [
{
"mdc_name": "cmc_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_start_date",
"mdc_description": "Start Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_end_date",
"mdc_description": "End Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_cst_key",
"mdc_description": "Member Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "64"
},
{
"mdc_name": "cmc_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "64"
},
{
"mdc_name": "cmc_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cmc_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_customer_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_status",
"mdc_description": "Status",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "20"
},
{
"mdc_name": "cmc_voting_flag",
"mdc_description": "Voting",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cmc_cmt_key",
"mdc_description": "committee",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_cxa_key",
"mdc_description": "Address",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_cph_key",
"mdc_description": "Phone",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_eml_key",
"mdc_description": "E-Mail",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_cfx_key",
"mdc_description": "Fax",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_url_key",
"mdc_description": "URL",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_pref_comm_meth",
"mdc_description": "Pref. Communication",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "10"
},
{
"mdc_name": "cmc_rank",
"mdc_description": "Rank",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "4"
},
{
"mdc_name": "cmc_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_funded_flag",
"mdc_description": "Funded",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cmc_status_date",
"mdc_description": "Status Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_renewable_flag",
"mdc_description": "Renewable",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cmc_nom_key",
"mdc_description": "Nomination",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_cop_key",
"mdc_description": "Position",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cmc_csu_key",
"mdc_description": "Assignment Subject",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_customer",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "co_customer",
"lsf_from_alias": "",
"lsf_from_join_type": "",
"lsf_from_join": "cst_key=cmc_cst_key",
"Columns": [
{
"mdc_name": "cst_key",
"mdc_description": "Customer Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_type",
"mdc_description": "Customer Type",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "20"
},
{
"mdc_name": "cst_name_cp",
"mdc_description": "Name (Calculated)",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "150"
},
{
"mdc_name": "cst_sort_name_dn",
"mdc_description": "Customer Sort Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "150"
},
{
"mdc_name": "cst_ind_full_name_dn",
"mdc_description": "Full Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "150"
},
{
"mdc_name": "cst_org_name_dn",
"mdc_description": "Organization Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "150"
},
{
"mdc_name": "cst_ixo_title_dn",
"mdc_description": "Title",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "150"
},
{
"mdc_name": "cst_pref_comm_meth",
"mdc_description": "Comm Method",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "10"
},
{
"mdc_name": "cst_bio",
"mdc_description": "Biographical Information",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "cst_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "64"
},
{
"mdc_name": "cst_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "64"
},
{
"mdc_name": "cst_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_recno",
"mdc_description": "Record Number",
"mdc_data_type": "av_recno",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "8"
},
{
"mdc_name": "cst_id",
"mdc_description": "Customer ID",
"mdc_data_type": "char",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "10"
},
{
"mdc_name": "cst_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_email_text_only",
"mdc_description": "Send Only Plain Text E-mail",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_credit_limit",
"mdc_description": "credit limit",
"mdc_data_type": "av_currency",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "21"
},
{
"mdc_name": "cst_src_key",
"mdc_description": "Source",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_src_code",
"mdc_description": "Source Code",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "50"
},
{
"mdc_name": "cst_tax_exempt_flag",
"mdc_description": "Tax Exempt",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_tax_id",
"mdc_description": "Tax Id",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "30"
},
{
"mdc_name": "cst_no_email_flag",
"mdc_description": "Do Not Contact by Email",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_cxa_key",
"mdc_description": "Preferred Mailing Address",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_cxa_billing_key",
"mdc_description": "Billing Address",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_eml_address_dn",
"mdc_description": "Primary E-Mail",
"mdc_data_type": "av_email",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "80"
},
{
"mdc_name": "cst_eml_key",
"mdc_description": "Primary E-Mail Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_no_phone_flag",
"mdc_description": "Do Not Contact By Phone",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_phn_number_complete_dn",
"mdc_description": "Primary Phone",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "55"
},
{
"mdc_name": "cst_cph_key",
"mdc_description": "Primary Phone Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_no_fax_flag",
"mdc_description": "Do Not Contact By Fax",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_fax_number_complete_dn",
"mdc_description": "Primary Fax",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "55"
},
{
"mdc_name": "cst_cfx_key",
"mdc_description": "Primary Fax Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_ixo_key",
"mdc_description": "Primary Organization Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_oldid",
"mdc_description": "oldid",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "15"
},
{
"mdc_name": "cst_no_web_flag",
"mdc_description": "Do Not Make Available Online",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_member_flag",
"mdc_description": "Member Flag",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_url_code_dn",
"mdc_description": "Primary Website",
"mdc_data_type": "av_url",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "200"
},
{
"mdc_name": "cst_parent_cst_key",
"mdc_description": "Customer",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_url_key",
"mdc_description": "Primary Website Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_no_msg_flag",
"mdc_description": "Do Not Contact By Instant Mess",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_msg_handle_dn",
"mdc_description": "Primary Instant Messaging Hand",
"mdc_data_type": "av_messaging_name",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "30"
},
{
"mdc_name": "cst_web_login",
"mdc_description": "Web Login",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "80"
},
{
"mdc_name": "cst_web_password",
"mdc_description": "Web Password",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "50"
},
{
"mdc_name": "cst_msg_key",
"mdc_description": "Primary Instant Messaging Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_web_start_date",
"mdc_description": "Web Login Start Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_no_mail_flag",
"mdc_description": "Do Not Contact By Mail",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_web_end_date",
"mdc_description": "Web Login End Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_web_force_password_change",
"mdc_description": "Force User to Change Password",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_web_login_disabled_flag",
"mdc_description": "Web Login Disabled",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_comment",
"mdc_description": "Comments",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "cst_credit_hold_flag",
"mdc_description": "Credit Hold Flag",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_credit_hold_reason",
"mdc_description": "Credit Hold Reason",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "50"
},
{
"mdc_name": "cst_web_forgot_password_status",
"mdc_description": "Forgot Password Status",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_old_cxa_key",
"mdc_description": "Old Primary Address",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_last_email_date",
"mdc_description": "last email date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_no_publish_flag",
"mdc_description": "Do not publish to other systems?",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_sin_key",
"mdc_description": "industry",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_ttl_key",
"mdc_description": "title",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_jfn_key",
"mdc_description": "job function",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_cur_key",
"mdc_description": "Currency",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_attribute_1",
"mdc_description": "price attribute 1",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "510"
},
{
"mdc_name": "cst_attribute_2",
"mdc_description": "price attribute 2",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "510"
},
{
"mdc_name": "cst_salutation_1",
"mdc_description": "customer Salutation 1",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "100"
},
{
"mdc_name": "cst_salutation_2",
"mdc_description": "customer Salutation 2",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "100"
},
{
"mdc_name": "cst_salutation_3",
"mdc_description": "customer Salutation 3",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "100"
},
{
"mdc_name": "cst_merge_cst_key",
"mdc_description": "Merged Customer Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_salutation_4",
"mdc_description": "customer Salutation 4",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "100"
},
{
"mdc_name": "cst_default_recognize_as",
"mdc_description": "default recognize as",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "200"
},
{
"mdc_name": "cst_score",
"mdc_description": "Score",
"mdc_data_type": "av_decimal4",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "21"
},
{
"mdc_name": "cst_score_normalized",
"mdc_description": "Normalized Score",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "4"
},
{
"mdc_name": "cst_score_trend",
"mdc_description": "Scoring Trend",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "4"
},
{
"mdc_name": "cst_vault_account",
"mdc_description": "Vault Customer Account",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "25"
},
{
"mdc_name": "cst_exclude_from_social_flag",
"mdc_description": "Exclude from Social",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_social_score",
"mdc_description": "Social Score",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "4"
},
{
"mdc_name": "cst_ptin",
"mdc_description": "PTIN",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "9"
},
{
"mdc_name": "cst_aicpa_member_id",
"mdc_description": "AICPA Member ID",
"mdc_data_type": "av_recno",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "8"
},
{
"mdc_name": "cst_vendor_code",
"mdc_description": "Vendor Code",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "50"
},
{
"mdc_name": "cst_sca_key",
"mdc_description": "Primary A-Score Scale",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_salt",
"mdc_description": "Salt",
"mdc_data_type": "varchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "-1"
},
{
"mdc_name": "cst_iterations",
"mdc_description": "Iterations",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "4"
},
{
"mdc_name": "cst_web_password_change_date",
"mdc_description": "Web Password Change Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "16"
},
{
"mdc_name": "cst_web_failed_login_count",
"mdc_description": "Web Failed Login Count",
"mdc_data_type": "tinyint",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
},
{
"mdc_name": "cst_web_last_failed_login_date",
"mdc_description": "Web Last Failed Login Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "24"
},
{
"mdc_name": "cst_web_login_locked_flag",
"mdc_description": "Web Login Locked",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer",
"mdc_width_max": "1"
}
]
},
{
"lsf_from_table": "mb_committee",
"lsf_from_alias": "",
"lsf_from_join_type": "",
"lsf_from_join": "cmt_key=cmc_cmt_key",
"Columns": [
{
"mdc_name": "cmt_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee",
"mdc_width_max": "16"
},
{
"mdc_name": "cmt_asn_code",
"mdc_description": "Association",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "10"
},
{
"mdc_name": "cmt_code",
"mdc_description": "Committee Code",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee",
"mdc_width_max": "10"
},
{
"mdc_name": "cmt_ctp_code",
"mdc_description": "Type Code",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee",
"mdc_width_max": "30"
},
{
"mdc_name": "cmt_name",
"mdc_description": "Committee Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee",
"mdc_width_max": "80"
},
{
"mdc_name": "cmt_begin_date",
"mdc_description": "Begin Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "24"
},
{
"mdc_name": "cmt_end_date",
"mdc_description": "End Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "24"
},
{
"mdc_name": "cmt_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee",
"mdc_width_max": "16"
},
{
"mdc_name": "cmt_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee",
"mdc_width_max": "64"
},
{
"mdc_name": "cmt_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "16"
},
{
"mdc_name": "cmt_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "64"
},
{
"mdc_name": "cmt_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee",
"mdc_width_max": "1"
},
{
"mdc_name": "cmt_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cmt_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "16"
},
{
"mdc_name": "cmt_parent_key",
"mdc_description": "Parent Committee",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "16"
},
{
"mdc_name": "cmt_description",
"mdc_description": "Description",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "cmt_region",
"mdc_description": "Region",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "50"
},
{
"mdc_name": "cmt_html_description",
"mdc_description": "html description",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "cmt_cst_key",
"mdc_description": "Customer Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "co_individual",
"lsf_from_alias": "",
"lsf_from_join_type": "",
"lsf_from_join": "ind_cst_key=cmc_cst_key",
"Columns": [
{
"mdc_name": "ind_cst_key",
"mdc_description": "Primary Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_individual",
"mdc_width_max": "16"
},
{
"mdc_name": "ind_prf_code",
"mdc_description": "Prefix",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "20"
},
{
"mdc_name": "ind_first_name",
"mdc_description": "First Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_individual",
"mdc_width_max": "30"
},
{
"mdc_name": "ind_mid_name",
"mdc_description": "Middle Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "30"
},
{
"mdc_name": "ind_last_name",
"mdc_description": "Last Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_individual",
"mdc_width_max": "30"
},
{
"mdc_name": "ind_sfx_code",
"mdc_description": "Suffix",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "20"
},
{
"mdc_name": "ind_designation",
"mdc_description": "Designation",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "50"
},
{
"mdc_name": "ind_dob",
"mdc_description": "Date of Birth",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "24"
},
{
"mdc_name": "ind_gender",
"mdc_description": "Gender",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "30"
},
{
"mdc_name": "ind_full_name_cp",
"mdc_description": "Full Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_individual",
"mdc_width_max": "187"
},
{
"mdc_name": "ind_salutation_cp",
"mdc_description": "Salutation",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_individual",
"mdc_width_max": "51"
},
{
"mdc_name": "ind_cst_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_individual_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "ind_ssn",
"mdc_description": "social security number",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "80"
},
{
"mdc_name": "ind_spouse_name",
"mdc_description": "Spouse's Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "100"
},
{
"mdc_name": "ind_age_cp",
"mdc_description": "age",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "4"
},
{
"mdc_name": "ind_salary",
"mdc_description": "annual salary",
"mdc_data_type": "av_currency",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "21"
},
{
"mdc_name": "ind_ethnicity",
"mdc_description": "ethnicity",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "50"
},
{
"mdc_name": "ind_badge_name",
"mdc_description": "badge name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "30"
},
{
"mdc_name": "ind_license_number",
"mdc_description": "license number",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "20"
},
{
"mdc_name": "ind_entered_field_date",
"mdc_description": "date first entered field",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "16"
},
{
"mdc_name": "ind_num_years_in_field_cp",
"mdc_description": "number of years in field",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "4"
},
{
"mdc_name": "ind_grad_date",
"mdc_description": "Graduation Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "16"
},
{
"mdc_name": "ind_political_party",
"mdc_description": "political party",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "20"
},
{
"mdc_name": "ind_deceased_flag",
"mdc_description": "deceased",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_individual",
"mdc_width_max": "1"
},
{
"mdc_name": "ind_int_code",
"mdc_description": "Individual Type",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "50"
},
{
"mdc_name": "ind_ixo_key",
"mdc_description": "Primary Relationship",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "16"
},
{
"mdc_name": "ind_marital_status",
"mdc_description": "Marital Status",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "10"
},
{
"mdc_name": "ind_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_individual",
"mdc_width_max": "16"
},
{
"mdc_name": "ind_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "16"
},
{
"mdc_name": "ind_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_individual",
"mdc_width_max": "64"
},
{
"mdc_name": "ind_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "16"
},
{
"mdc_name": "ind_cst_passcode_ext",
"mdc_description": "cst passcode ext",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "20"
},
{
"mdc_name": "ind_sample_multi",
"mdc_description": "sample multi",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "20"
},
{
"mdc_name": "ind_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "64"
},
{
"mdc_name": "ind_maiden_name",
"mdc_description": "Former Last Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "30"
},
{
"mdc_name": "ind_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_individual",
"mdc_width_max": "1"
},
{
"mdc_name": "ind_progress_ext",
"mdc_description": "Progress Ext",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "30"
},
{
"mdc_name": "ind_ssn_display",
"mdc_description": "SSN (Last Four digit)",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "11"
},
{
"mdc_name": "ind_aicpa_id",
"mdc_description": "AICPA ID",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "15"
},
{
"mdc_name": "ind_deceased_date",
"mdc_description": "Deceased Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "24"
},
{
"mdc_name": "ind_prn_code",
"mdc_description": "Preferred Pronouns",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "50"
},
{
"mdc_name": "ind_popup",
"mdc_description": "Popup",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "ind_anonymization_status",
"mdc_description": "Anonymization Status",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_individual",
"mdc_width_max": "50"
}
]
},
{
"lsf_from_table": "mb_committee_x_position",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cop_key = cmc_cop_key",
"Columns": [
{
"mdc_name": "cop_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "16"
},
{
"mdc_name": "cop_cmt_key",
"mdc_description": "Committee",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "16"
},
{
"mdc_name": "cop_cpo_key",
"mdc_description": "Position",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "16"
},
{
"mdc_name": "cop_order",
"mdc_description": "Order",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "4"
},
{
"mdc_name": "cop_term",
"mdc_description": "Term",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "20"
},
{
"mdc_name": "cop_funded_flag",
"mdc_description": "Funded?",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "1"
},
{
"mdc_name": "cop_renewable_flag",
"mdc_description": "Renewable?",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "1"
},
{
"mdc_name": "cop_voting_flag",
"mdc_description": "Voting?",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "1"
},
{
"mdc_name": "cop_admin_flag",
"mdc_description": "Admin?",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "1"
},
{
"mdc_name": "cop_chapter_flag",
"mdc_description": "Chapter?",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "1"
},
{
"mdc_name": "cop_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "64"
},
{
"mdc_name": "cop_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "24"
},
{
"mdc_name": "cop_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "64"
},
{
"mdc_name": "cop_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "24"
},
{
"mdc_name": "cop_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "1"
},
{
"mdc_name": "cop_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_position",
"mdc_width_max": "16"
},
{
"mdc_name": "cop_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_position_ext",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "mb_committee_position",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cpo_key=cop_cpo_key",
"Columns": [
{
"mdc_name": "cpo_code",
"mdc_description": "Position Code",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "50"
},
{
"mdc_name": "cpo_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "64"
},
{
"mdc_name": "cpo_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "16"
},
{
"mdc_name": "cpo_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "64"
},
{
"mdc_name": "cpo_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "16"
},
{
"mdc_name": "cpo_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "1"
},
{
"mdc_name": "cpo_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "16"
},
{
"mdc_name": "cpo_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_position_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cpo_chapter_flag",
"mdc_description": "Chapter Position",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "1"
},
{
"mdc_name": "cpo_description",
"mdc_description": "Description",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "80"
},
{
"mdc_name": "cpo_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_position",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "co_email",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "eml_key=cmc_eml_key",
"Columns": [
{
"mdc_name": "eml_key",
"mdc_description": "Email Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_email",
"mdc_width_max": "16"
},
{
"mdc_name": "eml_address",
"mdc_description": "E-Mail Address",
"mdc_data_type": "av_email",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_email",
"mdc_width_max": "80"
},
{
"mdc_name": "eml_cst_key",
"mdc_description": "Customer Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_email",
"mdc_width_max": "16"
},
{
"mdc_name": "eml_type",
"mdc_description": "e-mail type",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_email",
"mdc_width_max": "20"
},
{
"mdc_name": "eml_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_email",
"mdc_width_max": "64"
},
{
"mdc_name": "eml_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_email",
"mdc_width_max": "24"
},
{
"mdc_name": "eml_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_email",
"mdc_width_max": "64"
},
{
"mdc_name": "eml_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_email",
"mdc_width_max": "24"
},
{
"mdc_name": "eml_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_email",
"mdc_width_max": "1"
},
{
"mdc_name": "eml_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_email_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "eml_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_email",
"mdc_width_max": "16"
},
{
"mdc_name": "eml_invalid_flag",
"mdc_description": "Invalid E-mail Address",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_email",
"mdc_width_max": "1"
},
{
"mdc_name": "eml_invalid_reason",
"mdc_description": "Invalid E-mail Address Reason",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_email",
"mdc_width_max": "50"
},
{
"mdc_name": "eml_unlisted_flag",
"mdc_description": "do not list my email",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_email",
"mdc_width_max": "1"
}
]
},
{
"lsf_from_table": "co_customer_x_phone",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cph_key=cmc_cph_key",
"Columns": [
{
"mdc_name": "cph_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "16"
},
{
"mdc_name": "cph_cst_key",
"mdc_description": "Customer",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "16"
},
{
"mdc_name": "cph_phn_key",
"mdc_description": "Phone",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "16"
},
{
"mdc_name": "cph_pht_key",
"mdc_description": "Phone Type",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "16"
},
{
"mdc_name": "cph_cst_link_key",
"mdc_description": "Linked Phone Customer",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "16"
},
{
"mdc_name": "cph_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "64"
},
{
"mdc_name": "cph_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "24"
},
{
"mdc_name": "cph_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "64"
},
{
"mdc_name": "cph_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "24"
},
{
"mdc_name": "cph_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "1"
},
{
"mdc_name": "cph_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_phone_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cph_unlisted_flag",
"mdc_description": "Unlisted Phone",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "1"
},
{
"mdc_name": "cph_phn_number_complete",
"mdc_description": "Phone Number",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "55"
},
{
"mdc_name": "cph_extension",
"mdc_description": "ph. ext.",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "10"
},
{
"mdc_name": "cph_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_phone",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "co_phone",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "phn_key=cph_phn_key",
"Columns": [
{
"mdc_name": "phn_key",
"mdc_description": "Phone Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_phone",
"mdc_width_max": "16"
},
{
"mdc_name": "phn_cst_key_owner",
"mdc_description": "Phone Owner",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_phone",
"mdc_width_max": "16"
},
{
"mdc_name": "phn_number",
"mdc_description": "Phone Number",
"mdc_data_type": "av_phone",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_phone",
"mdc_width_max": "30"
},
{
"mdc_name": "phn_number_display",
"mdc_description": "Formatted Phone Number",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_phone",
"mdc_width_max": "40"
},
{
"mdc_name": "phn_cty_key",
"mdc_description": "Country",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_phone",
"mdc_width_max": "16"
},
{
"mdc_name": "phn_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_phone",
"mdc_width_max": "64"
},
{
"mdc_name": "phn_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_phone",
"mdc_width_max": "24"
},
{
"mdc_name": "phn_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_phone",
"mdc_width_max": "64"
},
{
"mdc_name": "phn_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_phone",
"mdc_width_max": "24"
},
{
"mdc_name": "phn_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_phone",
"mdc_width_max": "1"
},
{
"mdc_name": "phn_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_phone_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "phn_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_phone",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "co_customer_x_fax",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cfx_key = cmc_cfx_key",
"Columns": [
{
"mdc_name": "cfx_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "16"
},
{
"mdc_name": "cfx_cst_key",
"mdc_description": "Customer",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "16"
},
{
"mdc_name": "cfx_fax_key",
"mdc_description": "Fax",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "16"
},
{
"mdc_name": "cfx_fxt_key",
"mdc_description": "Fax Type",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "16"
},
{
"mdc_name": "cfx_cst_link_key",
"mdc_description": "Linked Fax Customer",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "16"
},
{
"mdc_name": "cfx_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "64"
},
{
"mdc_name": "cfx_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "24"
},
{
"mdc_name": "cfx_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "64"
},
{
"mdc_name": "cfx_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "24"
},
{
"mdc_name": "cfx_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "1"
},
{
"mdc_name": "cfx_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cfx_unlisted_flag",
"mdc_description": "Unlisted Fax",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "1"
},
{
"mdc_name": "cfx_fax_number_complete",
"mdc_description": "fax number complete",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "55"
},
{
"mdc_name": "cfx_extension",
"mdc_description": "Fax Extension",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "10"
},
{
"mdc_name": "cfx_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_fax",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "co_fax",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "fax_key = cfx_fax_key",
"Columns": [
{
"mdc_name": "fax_key",
"mdc_description": "Fax Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_fax",
"mdc_width_max": "16"
},
{
"mdc_name": "fax_cst_key_owner",
"mdc_description": "Fax Owner",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_fax",
"mdc_width_max": "16"
},
{
"mdc_name": "fax_number",
"mdc_description": "Fax Number",
"mdc_data_type": "av_fax",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_fax",
"mdc_width_max": "30"
},
{
"mdc_name": "fax_number_display",
"mdc_description": "Formatted Fax Number",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_fax",
"mdc_width_max": "40"
},
{
"mdc_name": "fax_cty_key",
"mdc_description": "Country",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_fax",
"mdc_width_max": "16"
},
{
"mdc_name": "fax_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_fax",
"mdc_width_max": "64"
},
{
"mdc_name": "fax_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_fax",
"mdc_width_max": "24"
},
{
"mdc_name": "fax_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_fax",
"mdc_width_max": "64"
},
{
"mdc_name": "fax_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_fax",
"mdc_width_max": "24"
},
{
"mdc_name": "fax_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_fax",
"mdc_width_max": "1"
},
{
"mdc_name": "fax_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_fax_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "fax_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_fax",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "co_customer_x_address",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cmc_cxa_key=cxa_key",
"Columns": [
{
"mdc_name": "cxa_cst_key",
"mdc_description": "Customer Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_adr_key",
"mdc_description": "Address Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "64"
},
{
"mdc_name": "cxa_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "64"
},
{
"mdc_name": "cxa_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "1"
},
{
"mdc_name": "cxa_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_address_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_on_hold_flag",
"mdc_description": "Address On Hold Flag",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "1"
},
{
"mdc_name": "cxa_adh_key",
"mdc_description": "On Hold Type Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_seasonal_from_date",
"mdc_description": "Seasonal From Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_adt_key",
"mdc_description": "Address Type",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_mailing_label",
"mdc_description": "Mailing Label",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "450"
},
{
"mdc_name": "cxa_seasonal_through_date",
"mdc_description": "Seasonal Through Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_mail_stop",
"mdc_description": "Mailstop",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "50"
},
{
"mdc_name": "cxa_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_on_hold_from",
"mdc_description": "Hold From",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
},
{
"mdc_name": "cxa_mailing_label_html",
"mdc_description": "Mailing Label HTML",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "450"
},
{
"mdc_name": "cxa_on_hold_through",
"mdc_description": "On Hold Until Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_customer_x_address",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "co_website",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "url_key=cmc_url_key",
"Columns": [
{
"mdc_name": "url_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_website",
"mdc_width_max": "16"
},
{
"mdc_name": "url_code",
"mdc_description": "Website Url",
"mdc_data_type": "av_url_long",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_website",
"mdc_width_max": "400"
},
{
"mdc_name": "url_cst_key",
"mdc_description": "Customer",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_website",
"mdc_width_max": "16"
},
{
"mdc_name": "url_type",
"mdc_description": "Website Type",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_website",
"mdc_width_max": "20"
},
{
"mdc_name": "url_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_website",
"mdc_width_max": "64"
},
{
"mdc_name": "url_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_website",
"mdc_width_max": "24"
},
{
"mdc_name": "url_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_website",
"mdc_width_max": "64"
},
{
"mdc_name": "url_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_website",
"mdc_width_max": "24"
},
{
"mdc_name": "url_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_website",
"mdc_width_max": "1"
},
{
"mdc_name": "url_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_website_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "url_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_website",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "mb_committee_minutes",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cmn_cmt_key=cmt_key",
"Columns": [
{
"mdc_name": "cmn_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "16"
},
{
"mdc_name": "cmn_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "64"
},
{
"mdc_name": "cmn_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "24"
},
{
"mdc_name": "cmn_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "64"
},
{
"mdc_name": "cmn_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "24"
},
{
"mdc_name": "cmn_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "1"
},
{
"mdc_name": "cmn_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_minutes_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cmn_cmt_key",
"mdc_description": "Committee",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "16"
},
{
"mdc_name": "cmn_minutes",
"mdc_description": "Minutes",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "cmn_date",
"mdc_description": "Meeting Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "24"
},
{
"mdc_name": "cmn_location",
"mdc_description": "Location",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "50"
},
{
"mdc_name": "cmn_doc_key",
"mdc_description": "Document",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "16"
},
{
"mdc_name": "cmn_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_minutes",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "mb_committee_x_document",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cmd_cmt_key=cmt_key",
"Columns": [
{
"mdc_name": "cmd_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_document",
"mdc_width_max": "16"
},
{
"mdc_name": "cmd_cmt_key",
"mdc_description": "Committee",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_document",
"mdc_width_max": "16"
},
{
"mdc_name": "cmd_doc_key",
"mdc_description": "Document",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_document",
"mdc_width_max": "16"
},
{
"mdc_name": "cmd_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_document",
"mdc_width_max": "64"
},
{
"mdc_name": "cmd_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_document",
"mdc_width_max": "24"
},
{
"mdc_name": "cmd_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_document",
"mdc_width_max": "64"
},
{
"mdc_name": "cmd_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_document",
"mdc_width_max": "24"
},
{
"mdc_name": "cmd_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_document",
"mdc_width_max": "1"
},
{
"mdc_name": "cmd_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_document_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cmd_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_document",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "co_document",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cmd_doc_key=doc_key",
"Columns": [
{
"mdc_name": "doc_key",
"mdc_description": "Primary Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "16"
},
{
"mdc_name": "doc_number",
"mdc_description": "Document Code",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "100"
},
{
"mdc_name": "doc_summary",
"mdc_description": "Document Summary",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "60"
},
{
"mdc_name": "doc_description",
"mdc_description": "Document Description",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "500"
},
{
"mdc_name": "doc_url",
"mdc_description": "Url",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "1000"
},
{
"mdc_name": "doc_file_name",
"mdc_description": "File Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "1000"
},
{
"mdc_name": "doc_display_name",
"mdc_description": "Display Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "100"
},
{
"mdc_name": "doc_distrib_email_flag",
"mdc_description": "Send via e-mail",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "1"
},
{
"mdc_name": "doc_distrib_fax_flag",
"mdc_description": "Send via fax",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "1"
},
{
"mdc_name": "doc_distrib_mail_flag",
"mdc_description": "Send via regular mail",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "1"
},
{
"mdc_name": "doc_distrib_online_flag",
"mdc_description": "Send web link",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "1"
},
{
"mdc_name": "doc_send_always_flag",
"mdc_description": "Send Always",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "1"
},
{
"mdc_name": "doc_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "16"
},
{
"mdc_name": "doc_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "64"
},
{
"mdc_name": "doc_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "16"
},
{
"mdc_name": "doc_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "64"
},
{
"mdc_name": "doc_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "1"
},
{
"mdc_name": "doc_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "co_document_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "doc_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "16"
},
{
"mdc_name": "doc_author",
"mdc_description": "Author",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "200"
},
{
"mdc_name": "doc_source",
"mdc_description": "Document Source",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "200"
},
{
"mdc_name": "doc_category",
"mdc_description": "Category",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "200"
},
{
"mdc_name": "doc_allow_search",
"mdc_description": "Allow Search",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "co_document",
"mdc_width_max": "1"
},
{
"mdc_name": "doc_text",
"mdc_description": "Document Text",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "doc_original_doc_key",
"mdc_description": "Original Version Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "16"
},
{
"mdc_name": "doc_type",
"mdc_description": "Document Type",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "co_document",
"mdc_width_max": "50"
}
]
},
{
"lsf_from_table": "mb_committee_x_dg_topic_group",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "ctg_cmt_key = cmt_key",
"Columns": [
{
"mdc_name": "ctg_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_dg_topic_group",
"mdc_width_max": "16"
},
{
"mdc_name": "ctg_cmt_key",
"mdc_description": "Committee",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_dg_topic_group",
"mdc_width_max": "16"
},
{
"mdc_name": "ctg_dtg_key",
"mdc_description": "Topic Group",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_dg_topic_group",
"mdc_width_max": "16"
},
{
"mdc_name": "ctg_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_dg_topic_group",
"mdc_width_max": "64"
},
{
"mdc_name": "ctg_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_dg_topic_group",
"mdc_width_max": "24"
},
{
"mdc_name": "ctg_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_dg_topic_group",
"mdc_width_max": "64"
},
{
"mdc_name": "ctg_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_dg_topic_group",
"mdc_width_max": "24"
},
{
"mdc_name": "ctg_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_dg_topic_group",
"mdc_width_max": "1"
},
{
"mdc_name": "ctg_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_dg_topic_group",
"mdc_width_max": "16"
},
{
"mdc_name": "ctg_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_dg_topic_group_ext",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "dg_topic_group",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "ctg_dtg_key=dtg_key",
"Columns": [
{
"mdc_name": "dtg_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "16"
},
{
"mdc_name": "dtg_name",
"mdc_description": "Name",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "150"
},
{
"mdc_name": "dtg_description",
"mdc_description": "Description",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "dtg_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "64"
},
{
"mdc_name": "dtg_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "24"
},
{
"mdc_name": "dtg_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "64"
},
{
"mdc_name": "dtg_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "24"
},
{
"mdc_name": "dtg_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "1"
},
{
"mdc_name": "dtg_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "16"
},
{
"mdc_name": "dtg_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "dg_topic_group_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "dtg_image_url",
"mdc_description": "Image Url",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "250"
},
{
"mdc_name": "dtg_record_object",
"mdc_description": "Record Object",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "50"
},
{
"mdc_name": "dtg_record_key",
"mdc_description": "Record_key Order Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "16"
},
{
"mdc_name": "dtg_topic_count_dn",
"mdc_description": "Associated Topic Count",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "4"
},
{
"mdc_name": "dtg_ind_count_dn",
"mdc_description": "Associated Individual Count",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "4"
},
{
"mdc_name": "dtg_doc_count_dn",
"mdc_description": "Associated Resource Count",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "4"
},
{
"mdc_name": "dtg_mls_key",
"mdc_description": "",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "dg_topic_group",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "mb_committee_x_event",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cxe_cmt_key = cmt_key",
"Columns": [
{
"mdc_name": "cxe_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_event",
"mdc_width_max": "16"
},
{
"mdc_name": "cxe_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_event",
"mdc_width_max": "64"
},
{
"mdc_name": "cxe_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_event",
"mdc_width_max": "24"
},
{
"mdc_name": "cxe_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_event",
"mdc_width_max": "64"
},
{
"mdc_name": "cxe_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_event",
"mdc_width_max": "24"
},
{
"mdc_name": "cxe_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_event",
"mdc_width_max": "1"
},
{
"mdc_name": "cxe_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_event_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "cxe_cmt_key",
"mdc_description": "Committee",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_event",
"mdc_width_max": "16"
},
{
"mdc_name": "cxe_evt_key",
"mdc_description": "Event",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "mb_committee_x_event",
"mdc_width_max": "16"
},
{
"mdc_name": "cxe_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "mb_committee_x_event",
"mdc_width_max": "16"
}
]
},
{
"lsf_from_table": "ev_event",
"lsf_from_alias": "",
"lsf_from_join_type": "Left Join",
"lsf_from_join": "cxe_evt_key = evt_key",
"Columns": [
{
"mdc_name": "evt_key",
"mdc_description": "Unique Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_code",
"mdc_description": "Event Code",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "10"
},
{
"mdc_name": "evt_etp_key",
"mdc_description": "Event Type",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_title",
"mdc_description": "Event Title",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "200"
},
{
"mdc_name": "evt_capacity",
"mdc_description": "Capacity",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "4"
},
{
"mdc_name": "evt_registrant_goal",
"mdc_description": "registration goal",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "4"
},
{
"mdc_name": "evt_revenue_goal",
"mdc_description": "revenue goal",
"mdc_data_type": "av_currency",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "21"
},
{
"mdc_name": "evt_display_order",
"mdc_description": "display order",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "4"
},
{
"mdc_name": "evt_wait_list_flag",
"mdc_description": "allow wait list",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_auto_register_wait_list",
"mdc_description": "auto register from wait list",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_check_wait_list_flag",
"mdc_description": "no reg if wait list",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_registration_required",
"mdc_description": "registration required",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_group_reg_based_on_ind",
"mdc_description": "Group Registration Pricing Bas",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_estimated_attendance",
"mdc_description": "estimated attendance",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "4"
},
{
"mdc_name": "evt_guaranteed_attendance",
"mdc_description": "guaranteed attendance",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "4"
},
{
"mdc_name": "evt_restricted",
"mdc_description": "Restricted?",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_short_description",
"mdc_description": "Short Description",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "400"
},
{
"mdc_name": "evt_description",
"mdc_description": "Description",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "evt_description_html",
"mdc_description": "Description (HTML)",
"mdc_data_type": "av_text",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "2147483646"
},
{
"mdc_name": "evt_start_date",
"mdc_description": "Start Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_start_time",
"mdc_description": "Start Time",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "10"
},
{
"mdc_name": "evt_end_date",
"mdc_description": "End Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_end_time",
"mdc_description": "End Time",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "10"
},
{
"mdc_name": "evt_early_registration_date",
"mdc_description": "early registration cutoff",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_late_registration_date",
"mdc_description": "late registration cutoff",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_time_format",
"mdc_description": "time format",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "20"
},
{
"mdc_name": "evt_date_format",
"mdc_description": "date format",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "20"
},
{
"mdc_name": "evt_cutoff_date",
"mdc_description": "Cut-Off Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_post_to_web_date",
"mdc_description": "post to web date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_remove_from_web_date",
"mdc_description": "remove from web date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_event_url",
"mdc_description": "Event URL",
"mdc_data_type": "av_url",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "200"
},
{
"mdc_name": "evt_add_user",
"mdc_description": "Add User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "64"
},
{
"mdc_name": "evt_add_date",
"mdc_description": "Add Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "24"
},
{
"mdc_name": "evt_change_user",
"mdc_description": "Change User",
"mdc_data_type": "av_user",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "64"
},
{
"mdc_name": "evt_change_date",
"mdc_description": "Change Date",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "24"
},
{
"mdc_name": "evt_delete_flag",
"mdc_description": "Delete Flag",
"mdc_data_type": "av_delete_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_asn_code",
"mdc_description": "Association Code",
"mdc_data_type": "char",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "10"
},
{
"mdc_name": "evt_key_ext",
"mdc_description": "Extender Key",
"mdc_data_type": "av_key",
"mdc_ext": "1",
"mdc_nullable": "0",
"mdc_table_name": "ev_event_ext",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_sponsor_limit",
"mdc_description": "Max Sponsors Allowed",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "4"
},
{
"mdc_name": "evt_pre_registration_date",
"mdc_description": "pre registration cutoff",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_entity_key",
"mdc_description": "Entity Key",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_evt_key",
"mdc_description": "Parent Event",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_cct_key",
"mdc_description": "Confirmation Template",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_tzn_key",
"mdc_description": "time zone",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_etc_key",
"mdc_description": "Event Category",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_abstract_flag",
"mdc_description": "Abstract",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_abstract_member_option",
"mdc_description": "abstract member option",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "50"
},
{
"mdc_name": "evt_abstract_deadline",
"mdc_description": "Abstract Deadline",
"mdc_data_type": "av_date",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "24"
},
{
"mdc_name": "evt_closed_flag",
"mdc_description": "Closed?",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_free_event_flag",
"mdc_description": "Free Event",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_regid_counter",
"mdc_description": "reg ID counter",
"mdc_data_type": "av_recno",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "8"
},
{
"mdc_name": "evt_guest_limit",
"mdc_description": "Max Guests allowed",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "4"
},
{
"mdc_name": "evt_free_guest_flag",
"mdc_description": "free guest",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_fpc_prd_key",
"mdc_description": "fundraising product",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_wait_list_limit",
"mdc_description": "wait list limit",
"mdc_data_type": "av_integer",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "4"
},
{
"mdc_name": "evt_charity_event_flag",
"mdc_description": "charity event",
"mdc_data_type": "av_flag",
"mdc_ext": "0",
"mdc_nullable": "0",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
},
{
"mdc_name": "evt_expense_generated_date",
"mdc_description": "Expense Generated Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_narrative_template",
"mdc_description": "Narrative template",
"mdc_data_type": "nvarchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "0"
},
{
"mdc_name": "evt_video_url",
"mdc_description": "Video URL",
"mdc_data_type": "av_url",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "200"
},
{
"mdc_name": "evt_cancellation_cutoff_date",
"mdc_description": "Event Cancellation Cutoff Date",
"mdc_data_type": "av_date_small",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_cct_cancellation_key",
"mdc_description": "Cancellation Correspondence Template",
"mdc_data_type": "av_key",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "16"
},
{
"mdc_name": "evt_ceu_earn_date_field",
"mdc_description": "CEU Earn Date Field",
"mdc_data_type": "varchar",
"mdc_ext": "0",
"mdc_nullable": "1",
"mdc_table_name": "ev_event",
"mdc_width_max": "1"
}
]
}
]
}
}