Mapping Audit Log (785 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 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 |
| 2026-07-14 17:52:15 |
rev_source_code_mapping 1123869 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
direct_mail_acquisition
match_type:
override
ngp_name:
DMAcqJuneBlue26
ngp_source_code_id:
1123869
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-13 18:17:23 |
rev_source_code_mapping 1052690 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
TelemarketingGAABX
ngp_source_code_id:
1052690
notes:
2026-07-11 Erik adjudication (pipeline-cloud UNMAPPED review): dead code (last gift <= 2022, pre-June-2026 per Erik's condition); Legacy Import 2023-01 + DMAcqJune26 pair deliberately LEFT unmapped
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-13 18:17:23 |
rev_source_code_mapping 1052695 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
Telemarketing
ngp_source_code_id:
1052695
notes:
2026-07-11 Erik adjudication (pipeline-cloud UNMAPPED review): dead code (last gift <= 2022, pre-June-2026 per Erik's condition); Legacy Import 2023-01 + DMAcqJune26 pair deliberately LEFT unmapped
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-13 18:17:23 |
rev_source_code_mapping 1052654 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
TelemarketingNPMail
ngp_source_code_id:
1052654
notes:
2026-07-11 Erik adjudication (pipeline-cloud UNMAPPED review): dead code (last gift <= 2022, pre-June-2026 per Erik's condition); Legacy Import 2023-01 + DMAcqJune26 pair deliberately LEFT unmapped
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-13 18:17:23 |
rev_source_code_mapping 1052748 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
Telemarketing22
ngp_source_code_id:
1052748
notes:
2026-07-11 Erik adjudication (pipeline-cloud UNMAPPED review): dead code (last gift <= 2022, pre-June-2026 per Erik's condition); Legacy Import 2023-01 + DMAcqJune26 pair deliberately LEFT unmapped
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-13 18:17:23 |
rev_source_code_mapping 1052689 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
TelemarketingGAOrigi
ngp_source_code_id:
1052689
notes:
2026-07-11 Erik adjudication (pipeline-cloud UNMAPPED review): dead code (last gift <= 2022, pre-June-2026 per Erik's condition); Legacy Import 2023-01 + DMAcqJune26 pair deliberately LEFT unmapped
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-13 18:17:23 |
rev_source_code_mapping 1052867 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
Telemarketing
ngp_source_code_id:
1052867
notes:
2026-07-11 Erik adjudication (pipeline-cloud UNMAPPED review): dead code (last gift <= 2022, pre-June-2026 per Erik's condition); Legacy Import 2023-01 + DMAcqJune26 pair deliberately LEFT unmapped
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-13 18:17:23 |
rev_source_code_mapping 1052655 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
misc_checks
match_type:
direct
ngp_name:
TelemaketingNPOnline
ngp_source_code_id:
1052655
notes:
2026-07-11 Erik adjudication (pipeline-cloud UNMAPPED review): dead code (last gift <= 2022, pre-June-2026 per Erik's condition); Legacy Import 2023-01 + DMAcqJune26 pair deliberately LEFT unmapped
sage_classid:
1052794
sage_dept:
2300
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-13 18:17:23 |
rev_source_code_mapping 1052777 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
calltime_major_donor
match_type:
direct
ngp_name:
Donate Link
ngp_source_code_id:
1052777
notes:
2026-07-11 Erik adjudication (pipeline-cloud UNMAPPED review): dead code (last gift <= 2022, pre-June-2026 per Erik's condition); Legacy Import 2023-01 + DMAcqJune26 pair deliberately LEFT unmapped
sage_classid:
1052799
sage_dept:
2200
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-13 18:17:23 |
rev_source_code_mapping 1052870 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
strategic_support
match_type:
direct
ngp_name:
Crypto
ngp_source_code_id:
1052870
notes:
2026-07-11 Erik adjudication (pipeline-cloud UNMAPPED review): dead code (last gift <= 2022, pre-June-2026 per Erik's condition); Legacy Import 2023-01 + DMAcqJune26 pair deliberately LEFT unmapped
sage_classid:
1052788
sage_dept:
3100
sage_function:
FR
sage_gl:
40000
sage_project:
9999
|
system:migration | migration |
| 2026-07-11 01:30:11 |
rev_source_code_mapping 1123869 |
delete |
enabled:
True
entity_scope:
all
fundraising_category:
not_applicable
match_type:
exclusion
ngp_name:
DMAcqJuneBlue26
ngp_source_code_id:
1123869
sage_classid:
9999999
sage_dept:
9999
sage_gl:
40000
|
unknown | ui |
| 2026-07-11 00:59:05 |
rev_source_code_mapping 1123869 |
insert |
enabled:
True
entity_scope:
all
fundraising_category:
not_applicable
match_type:
exclusion
ngp_name:
DMAcqJuneBlue26
ngp_source_code_id:
1123869
sage_classid:
9999999
sage_dept:
9999
sage_gl:
40000
|
unknown | ui |