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 |