More information

Trigger Behaviors

Site Specific Notes

Database System Triggers and Stored Procedures

Two components of the business rules that make up the Millennium software package are the set of triggers and the stored procedures that operate on the data as it is inserted, edited and deleted from the database. These components exert much of the control over Millennium's automatic behaviors, such as the changes to a constituent's marital status in the Basic Data row when a Relationship row is created with a spousal relationship.

A stored procedure is a group of statements that are compiled into a single execution plan at the time the procedure is created. They may be thought of as a subroutines that are stored in the database for later use. A stored procedure may be called by an Millennium trigger - they are not executed as a stand alone routine.

A trigger is a special type of stored procedure that executes when an insert, update or delete statement is executed. Millennium triggers are heavily dependent on SQL. The SQL Server triggers are written in Transact SQL, and the Oracle triggers are written in PL/SQL.

There are completely independent sets of triggers for SQL Server installations and Oracle installations. SQL triggers are located in mill\tools\triggers and Oracle triggers are located in mill\tools\trigorcl. They are part of the database, not part of the software. Note that in both sets, the triggers are numbered in accordance with the table number of the data table on which they operate. (This is not the case with stored procedures.)

This document lists the system triggers and stored procedures for each kind of installation and identifies the purpose of each trigger and stored procedure. A general description of the actions that the triggers perform is found in the Trigger Behaviors topic.

SQL System Triggers

Trigger Name

Description

00.sql

Creating, editing, deleting corebio rows

01.sql

Creating, editing, deleting name rows

02.sql

Creating, editing, deleting address rows

03.sql

Creating, editing, deleting attribute rows

04.sql

Creating, editing, deleting relation rows

05.sql

Creating, editing, deleting gifts rows

06.sql

Creating, editing, deleting jobs (education) rows

07.sql

Creating, editing, deleting school (education) rows

08.sql

Creating, editing, deleting dues rows

09.sql

Creating, editing, deleting comments rows

10.sql

Creating, editing, deleting donor (tracking) rows

11.sql

Creating, editing, deleting action rows

117.sql

Creating, editing, deleting prototype_name rows

12.sql

Creating, editing, deleting tasks rows

13.sql

Creating, editing, deleting media rows

14.sql

Creating, editing, deleting screener rows

15.sql

Creating, editing, deleting rating rows

16.sql

Creating, editing, deleting plannedgifts rows

17.sql

Creating, editing, deleting death rows

18.sql

Creating, editing, deleting memories (summaries) rows

19.sql

Creating, editing, deleting finance rows

20.sql

Creating, editing, deleting demogrph rows

21.sql

Creating, editing, deleting event rows

22.sql

Creating, editing, deleting correspondence rows

23.sql

Creating, editing, deleting coverage rows

24.sql

Creating, editing, deleting receipts rows

25.sql

Creating, editing, deleting nationality rows

26.sql

Creating, editing, deleting phone rows

27.sql

Creating, editing, deleting research_source rows

28.sql

Creating, editing, deleting membership rows

2802.sql

Creating, editing membership_type rows

2803.sql

Creating, editing, deleting benefit_type rows

2804.sql

Creating, editing publication_name rows

2805.sql

Creating, editing membership_benefits rows

2806.sql

Creating, editing membership_publications rows

2807.sql

Creating, editing membership_classification rows

2808.sql

Creating, editing relation_pairs

286.sql

Editing sysinfo

29.sql

Creating, editing, deleting quidpro rows

291.sql

Creating, editing alerts rows

30.sql

Creating, editing, deleting pgrating rows

31.sql

Creating, editing, deleting securities rows

32.sql

Creating, editing, deleting giftinkind rows

33.sql

Creating, editing, deleting solicitor rows

34.sql

Creating, editing, deleting honoree rows

37.sql

Creating, editing, deleting creditcard rows

38.sql

Creating, editing, deleting payments rows

39.sql

Creating, editing, deleting subscription rows

40.sql

Creating, editing, deleting benefits rows

41.sql

Creating, editing, deleting attachments rows

42.sql

Creating, editing, deleting proposal rows

43.sql

Creating, editing, deleting serialreceipt rows

44.sql

Creating, editing,deleting serialreceipt_payment rows

5003.sql

Creating, editing event_type rows

5004.sql

Creating, editing success_rating rows

51.sql

Creating, editing, deleting expenses rows

5102.sql

Creating, editing expense_type rows

52.sql

Creating, editing, deleting activity rows

5203.sql

Creating, editing activity_type rows

53.sql

Creating, editing, deleting attendance rows

54.sql

Creating, editing, deleting event_guest rows

55.sql

Creating, editing, deleting items rows

5502.sql

Creating, editing item_name rows

5503.sql

Creating, editing item_color rows

56.sql

Creating, editing, deleting registration rows

5602.sql

Creating, editing registration_status rows

57.sql

Creating, editing, deleting guest_items rows

58.sql

Creating, editing, deleting organizer rows

5802.sql

Creating, editing organizer_type rows

59.sql

Creating, editing, deleting event_solicitor rows

5997.sql

Creating, editing, deleting matchparent rows

5998.sql

Creating, editing matchsubsidiary rows

5999.sql

Creating, editing matchfoundation rows

60.sql

Creating, editing, deleting event_income rows

61.sql

Creating, editing, deleting registration_level rows (not yet in use)

62.sql

Creating, editing, deleting other_info rows

6202.sql

Creating, editing, other_info rows

63.sql

Creating, editing, deleting benefitlevel rows

64.sql

Creating, editing, deleting subscription_level rows

65.sql

Creating, editing, deleting membershipcards rows

66.sql

Creating, editing, deleting event_actions rows

67.sql

Creating, editing, deleting speaker rows

68.sql

Creating, editing, deleting seating_layout rows

69.sql

Creating, editing, deleting custombio rows

6900.sql

Creating, editing, deleting corebio_pending rows

6901.sql

Creating, editing, deleting, name_pending rows

6902.sql

Creating, editing, deleting address_pending rows

6903.sql

Creating, editing, deleting attribute_pending rows

6904.sql

Creating, editing, deleting relation_pending rows

6906.sql

Creating, editing, deleting jobs_pending rows

6907.sql

Creating, editing, deleting school_pending rows

6909.sql

Creating, editing, deleting comments_pending rows

6910.sql

Creating, editing, deleting donor_pending rows

6913.sql

Creating, editing, deleting media_pending rows

6915.sql

Creating, editing, deleting rating_pending rows

6919.sql

Creating, editing, deleting finance_pending rows

6920.sql

Creating, editing, deleting demogrph_pending rows

6922.sql

Creating, editing, deleting correspondence_pending rows

6926.sql

Creating, editing, deleting phone_pending rows

6927.sql

Creating, editing, deleting research_source_pending rows

6928.sql

Creating, editing, deleting ecommerce_pending rows

6953.sql

Creating, editing, deleting attendance_pending rows

6954.sql

Creating, editing, deleting event_guest_pending rows

6956.sql

Creating, editing, deleting registration_pending rows

6957.sql

Creating, editing, deleting guest_items_pending rows

6960.sql

Creating, editing, deleting event_income_pending rows

6969.sql

Creating, editing, deleting custombio_pending rows

6970.sql

Creating, editing, deleting customprospect_pending rows

6981.sql

Creating, editing, deleting internetaddress_pending rows

70.sql

Creating, editing, deleting customprospect rows

71.sql

Creating, editing, deleting sustainerpayments rows

79.sql

Creating, editing, deleting contactinfo rows

80.sql

Creating, editing bookmarks

81.sql

Creating, editing, deleting internetaddress rows

94.sql

Creating, editing dues_batch_number rows

95.sql

Creating, editing gift_batch_number rows

96.sql

Creating, editing, deleting solicitations rows

97.sql

Creating, editing, deleting chart_of_accounts rows

98.sql

Creating, editing, deleting zipcodes rows

9920.sql

Creating, editing correspondence_name rows

9969.sql

Creating, editing relationships rows

def_00.sql

Insert and update of default (coretbltyp and coreacctnm), delete defined corebio default from prototype_name table.

def_03.sql

Insert and update of Attribute default (attrtypenm), delete defined attribute default from prototype_name table.

def_05.sql

Insert and update of Giving default (giftacctnm and giftsolnam), delete defined gifts default from prototype_name table.

def_07.sql

Insert and update of School default (schlinstnm), delete defined school default from prototype_name table.

def_08.sql

Insert and update of Dues default (duesacctnm and duessolnam), delete defined dues default from prototype_name table.

def_16.sql

Insert and update of Plannedgift default (plansolnam), delete defined plannedgift default from prototype_name table.

def_42.sql

Insert and update of Proposal default (propsolnam), delete defined proposal default from prototype_name table.

SQL Stored Procedures

Procedure

Description

proc1.sql

Fix match ratio

proc2.sql

Validate credit card

proc3.sql

Get smashed name

proc4.sql

Apply gift and dues pledge payments to sustainerpayments

proc5.sql

Get usergrp

proc6.sql

Automatic names (format, sal, plural format, plural sal)

proc7.sql

Get gifttrnum, get duestrnum

proc8.sql

Match credit insert

proc9.sql

Create payments

proc10.sql

Process pledge payments

proc11.sql

Process match payments

proc12.sql

Mergeid

proc13.sql

Process totals

proc16.sql

Journal

proc17.sql

Writeoff

proc18.sql

Increase payments

proc19.sql

Batch closed update

proc20.sql

Corebio delete

proc21.sql

Journal single gifts and dues

proc22.sql

Deletes linked transactions for gift and dues transactions

proc23.sql

Deletes secondary transactions for gift and dues transactions

proc24.sql

Updates gift and dues totals when payment transactions are deleted.

proc25.sql

Resets journal and correct key (jcrkey) for deleted gift and dues transactions.

proc26.sql

Updates joint transactions when gift and dues transactions are created and edited.

proc27.sql

insert audit_gifts and audit_dues

proc28.sql

formats smashed name

proc29.sql

insert credit for other constituent for gifts and for dues

proc99.sql

Blank custom

Oracle Triggers

Oracle triggers generally include a trigger that operates on the data before it is inserted, updated or deleted from the database, another that operates after the insert, update or deletion, and another that handles package variables for that data table.

Trigger Name

Description

00.sql

corebio before insert, update, delete

00_pkg.sql

corebio package variables

00a.sql

corebio after insert, update, delete

01.sql

name before insert, update, delete

01_pkg.sql

name package variables

01a.sql

name after insert, update, delete

02.sql

address before insert, update, delete

02_pkg.sql

address package variables

02a.sql

address after insert, update, delete

03.sql

attribute before insert, update, delete

03_pkg.sql

attribute package variables

03a.sql

attribute after insert, update, delete

04.sql

relation before insert, update, delete

04_pkg.sql

relation package variables

04a.sql

relation after insert, update, delete

05.sql

gifts before insert, update, delete

05_pkg.sql

gifts package variables

05a.sql

gifts after insert or update

05b.sql

gifts after delete

06.sql

jobs (employment) before insert, update, delete

06_pkg.sql

jobs package variables

06a.sql

jobs after delete

07.sql

school (education) before insert, update, delete

08.sql

dues before insert, update, delete

08_pkg.sql

dues package variables

08a.sql

dues after insert, update

08b.sql

dues after delete

09.sql

comments before insert, update, delete

09_pkg.sql

comments package variables

09a.sql

comments after insert, update, delete

10.sql

donor (tracking) before insert, update, delete

10_pkg.sql

donor (tracking) package variables

10a.sql

donor (tracking) after insert, update, delete

100.sql

assignments before insert

101.sql

advisories before insert

11.sql

action before insert, update, delete

11_pkg.sql

action package variables

11a.sql

action after insert, update, delete

117.sql

prototype_name before insert, update

117_pkg.sql

prototype_name package variables

117a.sql

prototype_name after insert, update, delete

118.sql

online_import_mapping before insert

119.sql

account_services_log before insert

12.sql

tasks before insert, update, delete

12_pkg.sql

tasks package variables

12a.sql

tasks after insert, update, delete

13.sql

media before insert, update, delete

14.sql

screener before insert, update, delete

14_pkg.sql

screener package variables

14a.sql

screener after insert, update, delete

15.sql

rating before insert, update, delete

15_pkg.sql

rating package variables

15a.sql

rating after insert, update, delete

16.sql

plannedgift before insert, update, delete

16_pkg.sql

plannedgift package variables

16a.sql

plannedgift after insert, update, delete

17.sql

death before insert, update, delete

17_pkg.sql

death package variables

18.sql

memories (summaries) before insert, update, delete

188.sql

report_clipboard before insert

19.sql

finance before insert, update, delete

19_pkg.sql

finance package variables

19a.sql

finance after insert, update, delete

199.sql

report_agent before insert

20.sql

demogrph before insert, update, delete

20_pkg.sql

demogrph package variables

20a.sql

demogrph after insert, update, delete

21.sql

event before insert, update, delete

22.sql

correspondence before insert, update, delete

22_pkg.sql

correspondence package variables

22a.sql

correspondence after insert, update, delete

23.SQL

coverage before insert, update, delete

23_pkg.sql

coverage package variables

23A.SQL

coverage after insert, update, delete

24.sql

receipts before insert, update, delete

24_pkg.sql

receipts package variables

24a.sql

receipts after insert, update, delete

25.sql

nationality before insert, update, delete

26.sql

phone before insert, update, delete

26_pkg.sql

phone package variables

26a.sql

phone after insert, update, delete

27.sql

research_source before insert, update, delete

27a.sql

research_source after insert, update, delete

28.sql

membership before insert, update, delete

28_pkg.sql

membership package variables

28a.sql

membership after insert, update

2802.sql

membership_type before insert, update

2803.sql

benefit_type before insert, update

2804.sql

publication_name before insert, update

2805.sql

membership_benefits before insert, update

2805_pkg.sql

membership_benefits package variables

2805a.sql

membership_benefits after update, delete

2806.sql

membership_publications before insert, update

2806_pkg.sql

membership_publications package variables

2806a.sql

membership_publications after update, delete

2807.sql

membership_classification before insert, update

2808.sql

relation_pairs before insert, update

2808_pkg.sql

relation_pairs package variables

2808a.sql

relation_pairs after insert, update

286.sql

sysinfo before insert, update

286a.sql

sysinfo after insert, update

288.sql

systemplate before insert

29.sql

quidpro before insert, update, delete

29_pkg.sql

quidpro package variables

29a.sql

quidpro after insert, update, delete

291.sql

alerts before insert, update

291_pkg.sql

alerts package variables

291a.sql

alerts after insert, update, delete

292.sql

edirectoryinfo before insert

30.sql

pgrating before insert, update, delete

30_pkg.sql

pgrating package variables

30a.sql

pgrating after insert, update, delete

31.sql

securities before insert, update, delete

31_pkg.sql

securities package variables

31a.sql

securities after insert, update, delete

32.sql

giftinkind before insert, update, delete

32_pkg.sql

giftinkind package variables

32a.sql

giftinkind after insert, update, delete

33.sql

solicitor before insert, update, delete

33_pkg.sql

solicitor package variables

33a.sql

solicitor after insert, update, delete

34.sql

honoree before insert, update, delete

34_pkg.sql

honoree package variables

34a.sql

honoree after insert, update, delete

37.sql

creditcard before insert, update, delete

37_pkg.sql

creditcard package variables

37a.sql

creditcard after insert, update, delete

38.sql

payments before insert, update, delete

39.sql

subscription before insert, update, delete

40.sql

benefits before insert, update, delete

41.sql

attachments before insert, update, delete

41a.sql

attachments after insert, update, delete

42.sql

proposal before insert, update, delete

42_pkg.sql

proposal package variables

42a.sql

proposal after insert, update, delete

5003.sql

event_type before insert, update

5004.sql

success_rating before insert, update

51.sql

expenses before insert, update, delete

51_pkg.sql

expenses package variables

51a.sql

expenses after insert, update, delete

5102.sql

expense_type before insert, update

52.sql

activity before insert, update, delete

52_pkg.sql

activity package variables

52a.sql

activity after insert, update, delete

5203.sql

activity_type before insert, update

53.sql

attendance before insert, update, delete

53_pkg.sql

attendance package variables

53a.sql

attendance after insert, update, delete

54.sql

event_guest before insert, update, delete

54_pkg.sql

event_guest package variables

54a.sql

event_guest after insert, update, delete

55.sql

items before insert, update, delete

55_pkg.sql

items package variables

55a.sql

items after insert, update, delete

5502.sql

item_name before insert, update

5503.sql

item_color before insert, update

56.sql

registration before insert, update, delete

56_pkg.sql

registration package variables

56a.sql

registration after insert, update, delete

5602.sql

registration_status before insert, update

57.sql

guest_items before insert, update, delete

57_pkg.sql

guest_items package variables

57a.sql

guest_items after insert, update, delete

58.sql

organizer before insert, update, delete

58_pkg.sql

organizer package variables

58a.sql

organizer after insert, update, delete

5802.sql

organizer_type before insert, update

59.sql

event_solicitor before insert, update, delete

59_pkg.sql

event_solicitor package variables

59a.sql

event_solicitor after insert, update, delete

5997.sql

matchparent before insert, update

5998.sql

matchsubsidiary before insert, update

5999.sql

matchfoundation before insert, update

60.sql

event_income before insert, update, delete

60_pkg.sql

event_income package variables

60a.sql

event_income after insert, update, delete

61.sql

registration_level (not yet in use)

62.sql

registration_level (not yet in use)

62_pkg.sql

registration_level (not yet in use)

62a.sql

registration_level (not yet in use)

6202.sql

other_lookup before insert, update

63.sql

benefitlevel before insert, update, delete

63_pkg.sql

benefitlevel package variables

63a.sql

benefitlevel after delete

64.sql

subscriptionlevel before insert, update, delete

64_pkg.sql

subscriptionlevel package variables

64a.sql

subscriptionlevel after delete

65.sql

membershipcards before insert, update, delete

65_pkg.sql

membershipcards package variables

65a.sql

membershipcards after delete

66.sql

event_actions before insert, update, delete

66_pkg.sql

event_actions package variables

66a.sql

event_actions after insert, update, delete

67.sql

speaker before insert, update, delete

68.sql

seating_layout before insert, update, delete

68_pkg.sql

seating_layout package variables

68a.sql

seating_layout after insert, update, delete

69.sql

custombio before insert, update, delete

6900.sql

corebio_pending before insert, update, delete

6900_pkg.sql

corebio_pending package variables

6900a.sql

corebio_pending after delete

6901.sql

name_pending before insert, update, delete

6901_pkg.sql

name_pending package variables

6901a.sql

name_pending after delete

6902.sql

address_pending before insert, update, delete

6902_pkg.sql

address_pending package variables

6902a.sql

address_pending after delete

6903.sql

attribute_pending before insert, update, delete

6903_pkg.sql

attribute_pending package variables

6903a.sql

attribute_pending after delete

6904.sql

relation_pending before insert, update, delete

6904_pkg.sql

relation_pending package variables

6904a.sql

relation_pending after delete

6906.sql

jobs_pending before insert, update, delete

6906_pkg.sql

jobs_pending package variables

6906a.sql

jobs_pending after delete

6907.sql

school_pending before insert, update, delete

6907_pkg.sql

school_pending package variables

6907a.sql

school_pending after delete

6909.sql

comments_pending before insert, update, delete

6909_pkg.sql

comments_pending package variables

6909a.sql

comments_pending after delete

6910.sql

donor_pending before insert, update, delete

6910_pkg.sql

donor_pending package variables

6910a.sql

donor_pending after delete

6913.sql

media_pending before insert, update, delete

6913_pkg.sql

media_pending package variables

6913a.sql

media_pending after delete

6915.sql

rating_pending before insert, update, delete

6915_pkg.sql

rating_pending package variables

6915a.sql

rating_pending after delete

6919.sql

finance_pending before insert, update, delete

6919_pkg.sql

finance_pending package variables

6919a.sql

finance_pending after delete

6920.sql

demogrph_pending before insert, update, delete

6920_pkg.sql

demogrph_pending package variables

6920a.sql

demogrph_pending after delete

6922.sql

correspondence_pending before insert, update, delete

6922_pkg.sql

correspondence_pending package variables

6922a.sql

correspondence_pending after delete

6926.sql

phone_pending before insert, update, delete

6926_pkg.sql

phone_pending package variables

6926a.sql

phone_pending after delete

6927.sql

research_source_pending before insert, update, delete

6927_pkg.sql

research_source_pending package variables

6927a.sql

research_source_pending after delete

6928.sql

ecommerce_pending before insert, update

6953.sql

attendance_pending before insert, update, delete

6953_pkg.sql

attendance_pending package variables

6953a.sql

attendance_pending after delete

6954.sql

event_guest_pending before insert, update, delete

6954_pkg.sql

event_guest_pending package variables

6954a.sql

event_guest_pending after delete

6956.sql

registration_pending before insert, update, delete

6956_pkg.sql

registration_pending package variables

6956a.sql

registration_pending after delete

6957.sql

guest_items_pending before insert, update, delete

6957_pkg.sql

guest_items_pending package variables

6957a.sql

guest_items_pending after delete

6960.sql

event_income_pending before insert, update, delete

6960_pkg.sql

event_income_pending package variables

6960a.sql

event_income_pending after delete

6969.sql

custombio_pending before insert, update, delete

6969_pkg.sql

custombio_pending package variables

6969a.sql

custombio_pending after delete

6970.sql

customprospect_pending before insert, update, delete

6970_pkg.sql

customprospect_pending package variables

6970a.sql

customprospect_pending after delete

6981.sql

internetaddress_pending before insert, update, delete

6981_pkg.sql

internetaddress_pending package variables

6981a.sql

internetaddress_pending after delete

70.sql

customprospect before insert, update, delete

71.sql

sustainerpayments before insert, update, delete

71_pkg.sql

sustainerpayments package variables

71a.sql

sustainerpayments after delete

79.sql

contactinfo before insert, update, delete

79_pkg.sql

contactinfo package variables

79a.sql

contactinfo after delete

80.sql

bookmarks before insert, update

81.sql

internetaddress before insert, update, delete

88.sql

systemplate before insert

94.sql

dues_batch_number before insert, update, delete

94_pkg.sql

dues_batch_number package variables

94a.sql

dues_batch_number after insert, update, delete

95.sql

gift_batch_number before insert, update, delete

95_pkg.sql

gift_batch_number package variables

95a.sql

gift_batch_number after insert, update, delete

96.sql

solicitations before insert, update, delete

97.sql

chart_of_accounts before insert, update, delete

97_pkg.sql

chart_of_accounts package variables

97a.sql

chart_of_accounts after insert, update, delete

98.sql

zipcodes before insert, update, delete

9920.sql

correspondence_name before insert, update

9969.sql

relationships before insert, update

def_00.sql

def_corebio before insert and update

def_03.sql

def_attribute before insert and update

def_05.sql

def_gifts before insert and update

def_07.sql

def_school before insert and update

def_08.sql

def_dues before insert and update

def_16.sql

def_plannedgifts before insert and update

def_42.sql

def_proposal before insert and update

pkg_dels.sql

generic package variables

pkg_holder.sql

generic package holder

Oracle Stored procedures

Procedure Description

proc05c.sql

gifts journal and writeoffs

proc08c.sql

dues journal and writeoffs

proc1.sql

Get usergroup

proc2.sql

credit card validation

proc3.sql

corebio fix ratio

proc4.sql

Apply gift pledge payments to sustainerpayments

proc4a.sql

Apply dues pledge payments to sustainerpayments

proc5.sql

Creating, editing smashed name

proc6.sql

Creating, editing, formatted name

proc6a.sql

Deleting plural name

proc6b.sql

Creating, editing, singular salutation name

proc6c.sql

Creating, editing, plural salutation name

proc6d.sql

Creating, editing, plural name

proc6e.sql

Formatting name - nametype is wife preferred or husband preferred

proc6f.sql

Formatting name - nametype is wife preferred or husband preferred

proc7.sql

Get gifttrnum,

proc7a.sql

Get duestrnum

proc8.sql

Match credit insert

proc9.sql

payments create

proc10.sql

gifts pledge payments

proc10a.sql

dues pledge payments

proc11.sql

gifts match payments

proc11a.sql

dues match payments

proc12.sql

Mergeid

proc13.sql

process totals

proc14.sql

account total update

proc15.sql

solicitation total update

proc16.sql

gifts Journal

proc16a.sql

dues Journal

proc17.sql

gifts Writeoff

proc17a.sql

dues Writeoff

proc18.sql

increase payments

proc19.sql

gifts joint revocable

proc20.sql

corebio delete

proc21.sql

journal single gifts

proc21a.sql

journal single dues

proc22.sql

Deletes linked transactions for gift and dues transactions

proc22a.sql

journal single dues

proc23.sql

Deletes secondary transactions for gift and dues transactions

proc24.sql

Updates gift and dues totals when payment transactions are deleted.

proc25.sql

Resets journal and correct key (jcrkey) for deleted gift and dues transactions.

proc26.sql

Updates joint transactions when gift and dues transactions are created and edited

proc27.sql

insert audit_gifts

proc27a.sql

insert audit_dues

proc28.sql

formats smashed name

proc29.sql

insert credit for other constituent for gifts and for dues

Top of Page