The audit tables track changes and deletions made to Atlas data at the database level. When enabled, updates and deletions to every type of record are tracked by the database and stored separately for faster querying and reporting.
Not all tables are audited by default. The following tables are audited for all affiliates in Atlas.
| TABLENAME |
|---|
| ADDRESS |
| ADJUSTMENT |
| ADJUSTMENTHISTORY |
| ADJUSTMENTHISTORYDETAIL |
| ADJUSTMENTREASONCODE |
| ADVOCATERDATERANGE |
| ALERTTYPE |
| ALIAS |
| ANONYMOUSEMAILPREFERENCE |
| APPEAL |
| APPEALBUSINESSUNIT |
| APPEALDESIGNATION |
| APPEALNOTE |
| APPUSER |
| APPUSERALERTSETTING |
| APPUSERALERTTYPESETTING |
| ATTRIBUTECATEGORY |
| ATTRIBUTEFORMEXTENSION |
| BOARDMEMBERDATERANGE |
| CASHPAYMENTMETHODDETAIL |
| CHARGE |
| CHARGELINEITEM |
| CHECKPAYMENTMETHODDETAIL |
| COMMITTEE |
| COMMITTEEDATERANGE |
| CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT |
| CONSTITUENCY |
| CONSTITUENCYCRITERIASPOUSE |
| CONSTITUENCYDEFINITION |
| CONSTITUENCYDISPLAYORDER |
| CONSTITUENT |
| CONSTITUENTACCOUNT |
| CONSTITUENTAPPEAL |
| CONSTITUENTAPPEALRESPONSE |
| CONSTITUENTINACTIVEDETAIL |
| CONSTITUENTMEDIALINK |
| CONSTITUENTNOTE |
| CONSTITUENTORIGINATION |
| CONSTITUENTSOLICITCODE |
| CREDITCARD |
| CREDITCARDPAYMENTMETHODDETAIL |
| DECEASEDCONSTITUENT |
| DESIGNATIONDETAILSLINK |
| DESIGNATIONGOAL |
| DIRECTDEBITPAYMENTMETHODDETAIL |
| DONOTCALLREASONCODE |
| DONOTMAILREASONCODE |
| EMAILADDRESS |
| EVENT |
| EVENTAPPEAL |
| EVENTCAMPAIGN |
| EVENTCOORDINATOR |
| EVENTDESIGNATION |
| EVENTEXPENSE |
| FINANCIALTRANSACTION |
| FINANCIALTRANSACTIONATTACHMENT |
| FINANCIALTRANSACTIONLINEITEM |
| FINANCIALTRANSACTIONMEDIALINK |
| FINANCIALTRANSACTIONNOTE |
| FINANCIALTRANSACTIONSCHEDULE |
| FUNDGROUPCODE |
| FUNDRAISERDATERANGE |
| GIFTINKINDAPPRAISAL |
| GLOBALCHANGE |
| GROUPDATA |
| GROUPGOAL |
| GROUPMEMBER |
| GROUPMEMBERDATERANGE |
| GROUPMEMBERROLE |
| HOUSEHOLDINFO |
| INSTALLMENT |
| INSTALLMENTSPLIT |
| INSTALLMENTSPLITPAYMENT |
| INSTALLMENTSPLITWRITEOFF |
| INTERACTION |
| INTERACTIONRESPONSE |
| MAILPREFERENCE |
| MERCHANTACCOUNT |
| MERGECONFIGURATION |
| NAMEFORMAT |
| NAMINGOPPORTUNITY |
| NAMINGOPPORTUNITYRECOGNITION |
| NAMINGOPPORTUNITYRECOGNITIONINSTALLEDLOCATION |
| NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT |
| OPPORTUNITY |
| OPPORTUNITYCAMPAIGN |
| OPPORTUNITYDESIGNATION |
| OPPORTUNITYDESIGNATIONCAMPAIGN |
| OPPORTUNITYDESIGNATIONFMCODE |
| OPPORTUNITYDESIGNATIONTYPECODE |
| OPPORTUNITYFUNDINGTYPE |
| OPPORTUNITYSOLICITOR |
| OPPORTUNITYTYPECODE |
| ORGANIZATIONDATA |
| ORGANIZATIONINFORMATION |
| PAGEMODEL |
| PAGEMODELITEM |
| PAYMENTORIGINALAMOUNT |
| PAYMENTSUBTYPECODE |
| PHONE |
| PHSCAPACITYCODE |
| PLANNEDGIFT |
| PLANNEDGIFTADDITION |
| PLANNEDGIFTADDITIONASSET |
| PLANNEDGIFTADDITIONASSETHOLDER |
| PLANNEDGIFTADDITIONDESIGNATION |
| PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN |
| PLANNEDGIFTADDITIONREVENUE |
| PLANNEDGIFTASSETHOLDER |
| PLANNEDGIFTATTACHMENT |
| PLANNEDGIFTBENEFICIARY |
| PLANNEDGIFTDESIGNATIONCAMPAIGN |
| PLANNEDGIFTLETTER |
| PLANNEDGIFTMEDIALINK |
| PLANNEDGIFTNOTE |
| PLANNEDGIFTRELATIONSHIP |
| PLANNEDGIFTREVENUE |
| PLANNEDGIFTREVENUESPLIT |
| PLANNEDGIFTSITE |
| PLANPARTICIPANT |
| PLANPARTICIPANTROLECODE |
| PLEDGEINSTALLMENTOPTION |
| PLEDGEORIGINALAMOUNT |
| PROSPECT |
| PROSPECTDATERANGE |
| PROSPECTFUNDINGINTEREST |
| PROSPECTFUNDINGINTERESTSITE |
| PROSPECTMANAGERHISTORY |
| PROSPECTPLAN |
| PROSPECTPLANATTACHMENT |
| PROSPECTPLANATTACHMENTTYPECODE |
| PROSPECTPLANMANAGERHISTORY |
| PROSPECTPLANMEDIALINK |
| PROSPECTPLANMEDIALINKTYPECODE |
| PROSPECTPLANNOTE |
| PROSPECTPLANNOTETYPECODE |
| PROSPECTPLANREQUEST |
| PROSPECTPLANSITE |
| PROSPECTPLANSTATUSCODE |
| PROSPECTPLANTYPECODE |
| PROSPECTRESEARCHREQUEST |
| PROSPECTRESEARCHREQUESTCONSTITUENT |
| PROSPECTTEAM |
| PROSPECTTEAMROLECODE |
| RECEIVABLECREDIT |
| RECEIVABLECREDITLINEITEM |
| RECEIVABLEPAYMENT |
| RECEIVABLEPAYMENTCHECK |
| RECEIVABLEPAYMENTCREDITCARD |
| RECEIVABLEPAYMENTDIRECTDEBIT |
| RECOGNITIONCREDIT |
| RECOGNITIONDEFAULT |
| RECOGNITIONLEVEL |
| RECOGNITIONLEVELAMOUNT |
| RECOGNITIONPROGRAM |
| RECURRINGGIFTACTIVITY |
| REGISTRANT |
| REGISTRANTREGISTRATION |
| REGISTRANTREGISTRATIONINFORMATION |
| RELATIONSHIP |
| RESPONSE |
| RESPONSECATEGORY |
| REVENUE_EXT |
| REVENUECATEGORY |
| REVENUELETTER |
| REVENUELETTERMARKETING |
| REVENUEMATCHINGGIFT |
| REVENUEPAYMENTMETHOD |
| REVENUERECEIPTMARKETING |
| REVENUERECOGNITION |
| REVENUERECOGNITIONDEFAULT |
| REVENUESCHEDULE |
| REVENUESPLIT_EXT |
| REVENUESPLITBUSINESSUNIT |
| REVENUESPLITCAMPAIGN |
| REVENUESPLITOTHER |
| SOLICITCODE |
| STAFFDATERANGE |
| STANDINGORDERPAYMENTMETHODDETAIL |
| STEWARDSHIPPLAN |
| STEWARDSHIPPLANSTEP |
| TRIBUTE |
| TRIBUTEACKNOWLEDGEE |
| USR_CONSTITUENTSOLICITCODEEXT |
| USR_DATAFORMINSTANCECATALOG_EXT |
| USR_EPIC_DEPARTMENTCAMPAIGN |
| USR_EPIC_FAMILYDEFINITION |
| USR_EPIC_FAMILYRELATIONSHIP |
| USR_MODELSCORERATINGRANK |
| USR_OPPORTUNITY_EXT |
| USR_PHS_ATTRIBUTECATEGORY_EXT |
| USR_PHS_CONSTITUENTATTACHMENT_EXT |
| USR_PHS_DONOTEMAILREASONCODE |
| USR_PHS_EMAILADDRESSEXT |
| USR_PHS_GOALTYPECODE |
| USR_PHS_ORGANIZATIONINFORMATION_EXT |
| USR_PHS_REGISTRANT_EXT |
| USR_PHS_REVENUECLASSIFICATION |
| USR_PROSPECT_EXT |
| USR_PROSPECTRESEARCHREQUEST_EXT |
| USR_PROSPECTRESEARCHREQUESTCONSTITUENT_EXT |
| USR_TRIBUTEEXT |
| TEAMFUNDRAISER |
| TEAMFUNDRAISINGTEAMMEMBER |
| USR_PHS_ATLASREPORT |
| USR_PHS_ATLASREPORTADOPTED |
| USR_PHS_ATLASREPORTCATEGORY |
| USR_PHS_ATLASREPORTDATASOURCE |
| USR_PHS_ATLASREPORTTYPE |
| EDUCATIONADDITIONALINFORMATION |
| EDUCATIONALHISTORY |
| EDUCATIONALHISTORYSTATUSHISTORY |
| REVENUEOPPORTUNITY |
| USR_BRIGHTVINEIMPORTPARAMS |
| USR_BRIGHTVINEIMPORTPARAMS_EXT |
| USR_BRIGHTVINEMGBCLASSYIMPORTCONFIGURATION |
| USR_BRIGHTVINEMGBCLASSYIMPORTPROCESS |
| USR_BVDLAPIAUTHORIZATION |
| USR_BVDLAPICONFIGURATION |
| USR_BVDLAPIPAGINGCONFIGURATION |
| USR_BVDLAPIPARAMETER |
| USR_BVDLAPISAMPLERESPONSE |
| USR_BVDLCATEGORYCODE |
| USR_BVDL_CODE_TRANSLATION |
| USR_BVDL_DYNAMICOPERATION |
| USR_BVDL_EXPORTPARAMS |
| USR_BVDL_FILEMAPPING |
| USR_BVDL_ORCHESTRATION |
Good to Know!
- The MGB Development Office will manage audit tables. To request that auditing be enabled or disabled for one or more particular tables, or to request that Audit Data be deleted, log a ticket in Mojo. This request will typically require no further approval.
- A Delete Audit Data Global Change can be used to delete unneeded data from Audit Tables as required. Affiliate Administrators also have access to this Global Change Type.
