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