Mapping Audit Log (697 entries)
Append-only history of every mapping-table change: who changed what, when, from what to what. Read-only — there is no revert.
| When | Table / Row | Action | Change | Actor | Source |
|---|---|---|---|---|---|
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052765 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
TYRemit
ngp_source_code_id:
1052765
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1112179 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
calltime_major_donor
match_type:
direct
ngp_name:
Advocacy
ngp_source_code_id:
1112179
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052799
sage_dept:
2200
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052684 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
website
match_type:
direct
ngp_name:
Info Responses
ngp_source_code_id:
1052684
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052772
sage_dept:
2100
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052842 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
event
match_type:
direct
ngp_name:
March 2019 Penn
ngp_source_code_id:
1052842
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052665
sage_dept:
2200
sage_function:
FR
sage_gl:
40400
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052652 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
Remit
ngp_source_code_id:
1052652
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1104595 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
direct_mail_grassroots
match_type:
direct
ngp_name:
DM0424
ngp_source_code_id:
1104595
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1117033
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052835 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
TY
ngp_source_code_id:
1052835
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052754 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
Q3TY
ngp_source_code_id:
1052754
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052596 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
event
match_type:
direct
ngp_name:
July 2019 Houston
ngp_source_code_id:
1052596
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052665
sage_dept:
2200
sage_function:
FR
sage_gl:
40400
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052658 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
middollar_email
match_type:
direct
ngp_name:
newsemail052520
ngp_source_code_id:
1052658
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052768
sage_dept:
2100
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052775 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
Mail
ngp_source_code_id:
1052775
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052778 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
direct_mail_grassroots
match_type:
direct
ngp_name:
Feb 18 mailer
ngp_source_code_id:
1052778
notes:
historical unmapped cleanup, Erik CSV review 2026-07-22 (ambiguous TY/Remit/Mail->misc_checks per preference)
sage_classid:
1117033
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1105017 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
exclusion
match_type:
exclusion
ngp_name:
Donation
ngp_source_code_id:
1105017
notes:
Internal transfer 314 Action Fund->314 Action, not booked revenue (Erik CSV review 2026-07-22)
sage_classid:
9999999
sage_dept:
9999
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1105020 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
exclusion
match_type:
exclusion
ngp_name:
Security Deposit Allocation
ngp_source_code_id:
1105020
notes:
Not contribution revenue (Erik CSV review 2026-07-22)
sage_classid:
9999999
sage_dept:
9999
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1123596 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
(blank bulk-upload)
ngp_source_code_id:
1123596
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1117087 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
(blank bulk-upload)
ngp_source_code_id:
1117087
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1117768 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
refunds
match_type:
direct
ngp_name:
REFUND
ngp_source_code_id:
1117768
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052621
sage_dept:
9999
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1115802 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
website
match_type:
direct
ngp_name:
website
ngp_source_code_id:
1115802
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052772
sage_dept:
2100
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1117950 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
texting
match_type:
direct
ngp_name:
314_SMS_TAT_PT_250904_rfk-hearing_full
ngp_source_code_id:
1117950
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052650
sage_dept:
2100
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1114092 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
event
match_type:
direct
ngp_name:
EV032725Path
ngp_source_code_id:
1114092
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052665
sage_dept:
2200
sage_function:
FR
sage_gl:
40400
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052694 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
Miscellaneous
ngp_source_code_id:
1052694
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052698 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
TY_100Letter
ngp_source_code_id:
1052698
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1114663 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
website
match_type:
direct
ngp_name:
brandt_test
ngp_source_code_id:
1114663
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052772
sage_dept:
2100
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1052676 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
Direct Mail
ngp_source_code_id:
1052676
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1114757 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
TY_100Letter
ngp_source_code_id:
1114757
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1123595 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
(blank bulk-upload)
ngp_source_code_id:
1123595
notes:
unmapped-cleanup 2026-07-22 (Erik): DM/TY/blank->misc_checks; brandt_test->website
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1124197 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
exclusion
match_type:
exclusion
ngp_name:
Pan VF
ngp_source_code_id:
1124197
notes:
Dr. Richard Pan Stop RFK Jr. Committee (VF, renamed) — not tracked in Sage Intacct (Erik 2026-07-22)
sage_classid:
9999999
sage_dept:
9999
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1124198 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
exclusion
match_type:
exclusion
ngp_name:
Shah VF
ngp_source_code_id:
1124198
notes:
Dr. Amish Shah Science Victory Fund — new NGP designation, not tracked in Sage Intacct (Erik 2026-07-22)
sage_classid:
9999999
sage_dept:
9999
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-22 16:44:04 |
rev_source_code_mapping 1124186 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
exclusion
match_type:
exclusion
ngp_name:
Clark VF
ngp_source_code_id:
1124186
notes:
Dr. Jasmine Clark Science Victory Fund — new NGP designation, not tracked in Sage Intacct (Erik 2026-07-22)
sage_classid:
9999999
sage_dept:
9999
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-16 20:37:12 |
rev_dm_project_mapping MT-01 |
update |
sage_function:
PRO
→ PRO-IE
|
unknown | ui |
| 2026-07-15 20:04:38 |
rev_slate_bank_mapping 314325 |
insert |
assignment_source:
auto-pattern
batch_id:
314325
batch_name:
Slate P26Q2 AB 07122026
location_id:
403
sage_project_id:
JF-2026-Q2-PRIORITY
|
unknown | ui |
| 2026-07-15 18:00:20 |
rev_dm_project_mapping ME-GOV |
update |
reclass_location_id:
→ 310-ME
|
unknown | ui |
| 2026-07-15 16:48:56 |
rev_reconcile_ack 2026-05|310-ME |
insert |
acknowledged_difference:
-190000.00
entity_key:
310-ME
month_key:
2026-05
reason:
$190k of May Maine receipts reclassed to a transfer in Sage (not contribution revenue); NGP still counts it as contributions — permanent reconciling item
|
unknown | ui |
| 2026-07-15 02:33:49 |
rev_slate_bank_mapping 309144 |
update |
location_id:
301
→ 401
|
unknown | ui |
| 2026-07-15 00:07:40 |
rev_slate_bank_mapping 314233 |
insert |
assignment_source:
rule: IS Operating
batch_id:
314233
batch_name:
IS Operating CDC 07092026 B
location_id:
401
sage_project_id:
9999
|
unknown | ui |
| 2026-07-15 00:07:40 |
rev_slate_bank_mapping 314232 |
insert |
assignment_source:
rule: IS Operating
batch_id:
314232
batch_name:
IS Operating CDC 07092026 A
location_id:
401
sage_project_id:
9999
|
unknown | ui |
| 2026-07-14 20:29:24 |
candidate_mapping 224207 |
insert |
actblue_entity_id:
224207
candidate_id:
bock-wi-2026
committee_name:
Friends of Brian Bock
function:
PRO
project_id:
2026-LEG-WI
vendor_id:
V01823
|
unknown | ui |
| 2026-07-14 20:29:00 |
candidate_mapping 225311 |
insert |
actblue_entity_id:
225311
candidate_id:
wayne-mi-2026
committee_name:
Shannon Dare Wayne for State Representative
function:
PRO
project_id:
2026-LEG-MI
vendor_id:
V99998
|
unknown | ui |
| 2026-07-14 20:28:35 |
candidate_mapping 210078 |
insert |
actblue_entity_id:
210078
candidate_id:
knoke-wi-2026
committee_name:
Kevin Knoke for Assembly
function:
PRO
project_id:
2026-LEG-WI
vendor_id:
V99998
|
unknown | ui |
| 2026-07-14 20:28:12 |
candidate_mapping 212643 |
insert |
actblue_entity_id:
212643
candidate_id:
fredrickson-wi-2026
committee_name:
Jeremiah Fredrickson for State Assembly
function:
PRO
project_id:
2026-LEG-WI
vendor_id:
V99998
|
unknown | ui |
| 2026-07-14 20:27:23 |
candidate_mapping 230029 |
insert |
actblue_entity_id:
230029
candidate_id:
jones-fl-2026
committee_name:
Shevrin for Congress
function:
PRO
project_id:
2026-DEM-SEATS
vendor_id:
V99998
|
unknown | ui |
| 2026-07-14 20:26:20 |
candidate_mapping 204483 |
insert |
actblue_entity_id:
204483
candidate_id:
fuller-ga-2026
committee_name:
Beth Fuller for Georgia
function:
PRO
project_id:
2026-LEG-NTGT-SWING
vendor_id:
V99998
|
unknown | ui |
| 2026-07-14 20:08:45 |
rev_slate_bank_mapping 309144 |
insert |
assignment_source:
human
batch_id:
309144
batch_name:
Slate Conduit Activity
location_id:
301
sage_project_id:
9999
|
unknown | ui |
| 2026-07-14 20:08:34 |
rev_designation_exclusion Dr. Jasmine Clark Science Victory Fund |
update |
reason:
Not in sage
→
|
unknown | ui |
| 2026-07-14 20:08:21 |
rev_slate_bank_mapping 313557 |
insert |
assignment_source:
human
batch_id:
313557
batch_name:
Slate P26June 2026 06
location_id:
403
sage_project_id:
JF-2026-JUN-PRIORITY
|
unknown | ui |
| 2026-07-14 20:07:41 |
rev_slate_bank_mapping 313606 |
insert |
assignment_source:
human
batch_id:
313606
batch_name:
Slate Transfer In 06032026
excluded:
True
exclusion_reason:
Transfer in
|
unknown | ui |
| 2026-07-14 20:05:43 |
rev_designation_exclusion Dr. Amish Shah Science Victory Fund |
insert |
ngp_designation:
Dr. Amish Shah Science Victory Fund
reason:
Not in sage
|
unknown | ui |
| 2026-07-14 20:05:34 |
rev_designation_exclusion Dr. Jasmine Clark Science Victory Fund |
insert |
ngp_designation:
Dr. Jasmine Clark Science Victory Fund
reason:
Not in sage
|
unknown | ui |
| 2026-07-14 17:53:14 |
rev_source_code_mapping 1123870 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
direct_mail_acquisition
match_type:
override
ngp_name:
DMAcqJuneCand26
ngp_source_code_id:
1123870
notes:
Quick-added from results page
sage_classid:
1118169
sage_dept:
2300
sage_function:
FR-ACQ
sage_gl:
40000
sage_project:
9999
|
unknown | ui |
| 2026-07-14 17:52:23 |
rev_source_code_mapping 1123594 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
hd_direct_mail
match_type:
override
ngp_name:
DMHDQ4NOV22
ngp_source_code_id:
1123594
notes:
Quick-added from results page
sage_classid:
1117034
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
unknown | ui |