Using
SQLPass-Though Queries for Banner Reporting
by Bruce Knox bknox
@t uaex.edu
Oracle Database Programmer/Analyst
date last updated 05/13/2009
My favorite BannerAccess
Query is Names - Active Employee. It saves me a lot of time.
This Query includes the most frequently used Name Fields combined in a useful format. It includes the Preferred Name and Checks PEBEMPL for Active Employees. You may never need to code SPRIDEN_CHANGE_IND IS NULL again:)
Behind the Query:
This Query's code is bespoken. Yep, I wrote every line from scratch. Something I rarely do these days. But we will come back to that later (there is a better way for getting most of your code:)
Next: Predefined Queries as Building Blocks.
This is a personal site maintained by Bruce Knox ( bknox at uaex.edu ) documenting University of Arkansas, Division of Agriculture, Cooperative Extension Service IT projects.
Disclaimer
Use this information and these scripts at your own risk. As
a condition of using these scripts and information from this site, you
agree to hold harmless both the University of Arkansas Cooperative
Extension Service and Bruce Knox for any problems that they may cause or
other situations that may arise from their use, and that neither the
Extension Service nor I will be held liable for those consequences. The
scripts and information are provided "as is" without warranty, implied
or otherwise. Limitation of liability will be the amount paid to the
University of Arkansas specifically for this information. (It was free:)
Any University of Arkansas Division of Agriculture website Disclaimer
terms found in conflict with terms of this disclaimer shall over ride
and replace the conflicting terms found herein.
Other personal pages/sites that I
maintain:
http://www.openMosix.org the
website for the openMosix (Open
Source) Project hosted
on .
Note: The openMosix Project officially closed March
1, 2008. The source code and mail lists archives will continue to
be available on SourceForge as reference materials. Archive
Links are: FAQ HowTo Wiki SourceForge
Most of the works of art on my pages other than the Extension banner
are
used by permission of J.
Wilson Spence.
http://betwinx.com is
my personal site. betwinx?
This site is largely oriented to Oracle Reporting Solutions in the
context of generating bespoken reports from SunGard Higher Education's
Banner product. My university site is a more restrained version which
cannot contain endorsements of products or companies.
(I maintain a number of special topic pages with links from this primary
site.)
Near mirror at http://www.uaex.edu/bknox/ which is my university work site.
mirror page http://www.uaex.edu/bknox/Summit_2003_p04.htm My favorite BannerAccess Query is Names - Active Employee.