PLU HOME
This is a repository of some
important solutions and presentations
Householding
-
Click here
to download the zip file containing all source code components used by PLU to
generate a materialized view of entity (constituent and organization) information. Using
these views for reporting, greatly enhances the speed of report generation by taking away the
necessity of running "expensive" function calls for each report request. Instead, these calls
are relegated to the daily refresh of the materialized view in the wee hours of the morning
giving our Development department quick access during the day to household membership (method
of compressing to one mailing per household), spouse, address, phone, email, class year, primary
donor type, name information, etc. , and do not need to be called again. The zip file has been
encrypted. To decrypt the information, you must enter the name in uppercase letters of the form
used in Banner which is used for submitting jobs. Related to Advancement Householding presentations given
at SunGardHG Banner Summits 2005, 2006, and 2007.
Inter-Departmental Charge Solution
-
Click
here
to download zip file containing all source code components for PLU's Inter-Departmental Charge solution as presented at Banner Summit 2004 (updated 05/17/2004)
-
Click
here
to download zip file containing Banner Summit 2004 Inter-Departmental Charges Presentation and Demo PowerPoint 2003 files.
-
Click
here
to download zip file containing Banner Summit 2004 Inter-Departmental Charges Presentation and Demo PowerPoint 95 and higher compatible files.
(5.24MB for PowerPoint 2003 version; 10.4MB for PowerPoint 95 and higher compatible versions))
-
Click
here
for web version Western Banner User's Conference presentation (Banner Web
Solution for Handling Inter-Departmental Charges).
[Download
Zipped PPT] (9MB includes embedded coding examples)
SSN to Alternative ID
-
Click
here
to download zipped file (1.5 MB) containing scripts/presentation/Access 97 files
for generating and assigning Random IDs from presentation given at Summit 2002
in Anaheim, CA. (165 - Solution for Moving from SSN to Random ID in
Banner).
Maintained By:
Lennie W. Sutton
Contact Info:
Work Tel: (253) 535-7527; PLU Computing and Telecommunication Services.
Work E-Mail: suttonlw at plu.edu
Home E-Mail: Lennie at idbguy.com
Last Update: 16-Mar-2007