Tables included in a standard Data Extraction

In some cases, MemberClicks is able to provide a standard Data Extraction service to provide you with a complete version of all the files associated within your MC Trade  database. As part of this service, the MC Trade team will run an extraction that includes individual files for all of the tables listed below.

MC Trade is a fully relational database, meaning the files below will all contained the relevant unique identifier that ties this information together in your MC Trade system. Based on your use of your MC Trade system, some of these tables may not contain any information. For more information on what is included in each table, go to Reports > Data Dictionary. From there, you can see all the fields in each table and understand more about what that field contains.

Note: this table structure is what makes the MC Trade system work correctly. If you are using this data extraction to provide your data to a 3rd party, it is your responsibility to manipulate the data for the purpose of the 3rd party. If you need data extracted in another format, you may request it as a billable service from the MC Trade Help team.

Tables included in a Standard Data Extraction:

AccountingPackages

Accounts

AddressType

Adjustments

AdjustmentType

AdjustmentTypePromoCode

AffCodeType

Affiliation

Affiliation_Related

AffinityBlockedProfiles

AffinityContent

AffinityContentRating

AffinityGroup

AffinityInvitationBatchHeader

AffinityInvitationContent

AffinityInvitations

AffinityMember

AffinityMemberType

AffinityMessages

AffinityProfileAffinityType

AffinityType

AffinityWorkGroup

AffinityWorkGroupMembers

AffPro

AlertAffCodes

Alerts

AnnonymousWebInterestType

ARB

ArticleType

AssociationInfo

AssociationVertical

AssociationVerticalType

AutoRevCalc

Banks

Banners

BannerType

Batch

BenefitType

BigcommerceAppmanCustomer

Billing

BizLinkPreferences

Blog

BlogEntry

Budget

BudgetType

CategoryLog

CCGateways

CC_Authorizations

CC_ContactInfo

CC_Payment

CC_RefundContactInfo

CC_Transaction

CertificationActivity

CertificationActivitySource

CertificationRequirement

CertificationType

CE_CreditType

CGIGoCast

Checkbooks

CivicProfileReps

CivicProfiles

ClassType

Committee

CommitteeMeeting

CommitteeMeetingAttendee

CommitteeMember

CommitteeType

ConfigSettings

Contact

ContactType

conversion_worksheet

conversion_worksheet_candelete_tmp

CostCenter

Coupon

CouponType

CustomFieldDesign

CustomFields

CustomFieldValues

DashboardReports

DashboardSettings

DataQuery

DataView

Department

DirectorySearches

dirlist.txt

EmailAddressType

Entity

EntityDomains

EntityRelation

EntityType

EventAttendeeHeader

EventAttendees

EventAttendeesHT

EventBenefit

EventCustomRegField

EventCustomRegFieldAvailValues

EventCustomRegFieldAvailValuesCreditType

EventCustomRegFieldResponses

EventFee

EventItemPaymentMethod

EventItemType

EventList

EventListHT

EventPaymentMethod

EventPrice

EventPriceAffCodes

EventPriceBenefit

EventPriceCreditType

EventPriceEventCustomRegField

EventPricePromoCode

EventPriceType

EventPromoCode

EventRegistrationHeader

EventRegistrationProfileBenefit

EventSignUpEventPricePromoCode

EventSignUpNotifications

EventSignUps

EventSignUpsHT

EventSponsors

EventTypes

ExceptionLog

ExternalSystemMap

GatewayType

GridState

HTMLTemplates

HTMLTemplateType

InformzContactsSync

InformzListsAffCodes

Invoice

InvoiceCreationLog

InvoiceLineItem

InvoiceLineItemEventFee

InvoiceLineItemOptionalRevenueItem

InvoicePayments

Jobs

JobsRun

Jobs_ReportParamValues

LevelCode

Listing

ListingCategory

ListingCategoryEntity

ListingSubCategory

ListingType

Member

MemberActivity

MemberActivityType

MemberArchive

MemberBusDirections

MemberBusLocation

MemberDirectoryDescr

MemberGenBusInfo

MemberGuaranteePolicy

MemberPaymentAccepted

MemberProductsAndServices

MemberReferralInquiries

MemberReferrals

MembershipLevel

MembershipLevelAffCode

MembershipLevelBenefit

MembershipLevelBillingSetting

MembershipLevelProcess

MembershipLevelProcessProfile

MembershipLevelRelatedProfileAffCode

MemberSource

MemberType

NAICS

NAICSCode

NewsArticles

PaymentHeader

PaymentsHT

PaymentSource

PaymentTypes

PhoneType

Pledge

PledgeCampaign

PledgeCampaignType

PledgeLevel

Profile

ProfileAddress

ProfileAffCodeHT

ProfileBenefit

ProfileBenefitActivity

ProfileCertificationType

ProfileCustomFields

ProfileEmailAddress

ProfileHT

ProfileImage

ProfileNotes

ProfilePermission

ProfilePermissionType

ProfilePhone

ProfileRelationRole

ProfileRelations

ProfileType

ProfileTypes

ProfileUpdateHT

ProfileURL

ProfileWidgets

Project

ProjectStatus

ProjectTemplate

ProjectType

PromoCode

RelationType

RestrictedFeatureAccessLog

RevenueGroup

RevenueItems

RevenueItemsOptional

RevenueItemsOptionalProfileSettings

RevenueItemTaxItems

RoleSecurity

RoomAvailability

RoomAvailabilityProfile

SalesOpportunity

SalesOpportunityHistory

SalesOpportunityLostReason

SalesOpportunityProbability

SalesOpportunitySource

SerializedSettings

Settings

ShortCuts

SIC

SocialMedia

SocialMediaSettings

SocialMediaType

StandardCategoryDescr

SubDepartment

Survey

SurveyAnswers

SurveyQuestionPickList

SurveyQuestions

SystemURLCache

Tasks

TasksUserTime

TaskType

TimeZoneMaster

Title

Tokens

Transactions

TwitterSettings

UnappliedPayments

URLType

UserData

UserRoleQuickTasks

UserRoles

Users

UserSettings

VertAptAssoc_HousingCategoryType

VertAptAssoc_HousingType

VertAptAssoc_LocationClassType

VertAptAssoc_OtherAssociation

VertAptAssoc_OwnerStatusType

VertAptAssoc_ProfileDesignation

VertAptAssoc_ProfileType_Individual

VertAptAssoc_ProfileType_Individual_Designation

VertAptAssoc_ProfileType_Individual_OtherAssociation

VertAptAssoc_ProfileType_ManagementCompany

VertAptAssoc_ProfileType_Owner

VertAptAssoc_ProfileType_Property

VertAptAssoc_PropertyClassType

VertAptAssoc_PropertyType

VertAptAssoc_TaxData

VertHBA_AddressTypes

VertHBA_BusinessActivities

VertHBA_DollarVolume

VertHBA_MembershipStatus

VertHBA_MembershipTypes

VertHBA_NAHBBatch

VertHBA_NAHBExport

VertHBA_NumberOfUnits

VertHBA_ProfileData

VertHBA_Titles

VertHBA_TranTypeFormulas

VertHBA_TranTypes

VirtualURLs

VoterVoiceDistricts

VoterVoiceGovernments

VoterVoiceOffices

VoterVoiceOfficials

VoterVoiceProfile

WebClientSettings

WebContent

WebContentAffCodes

WebContentAnnonymousWebInterestTypes

WebContentDataExportParameters

WebContentReportParameters

WebContentType

WebContentViews

WebInput

WebInputContent

WebInputResponseID

WebMenu

WebMenuStyle

WebPreferences

WebProfile

WebServiceExternalUsers

WebSettings

WidgetType

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request