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.
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:)
visits
http://www.uaex.edu/bknox/Summit_2003_p04.htm My favorite BannerAccess Query is Names - Active Employee.