E N D
1. Population Selection and Letter Generation Created by College Information Systems
with information from SCT Corporation’s
“Population Selection” and “Letter Generation” Workbooks
and SCT Banner.
Presented by
2. How does this thing work ?
This is a two layered process
First Step : Population Selection
Second Step : Run Letter Generation for the
selected Population
4. What do we need to know
Banner Stores all the Data in Tables and what you see in the Application is just a conveniently arranged view of that Data.
5. What do we need to know - 2
We need to know the exact column name of the variable which we are going to use in our pop. Sel criteria or in letter generation extract variable
9. Population Selection
SCT Banner Population Selection is a mechanism for selecting a group of people
or organizations, which share common data, based on specific criteria.
10. Three Easy Steps
Define your Population Selection (GLRSLCT)
Run the Pop. Selection Process ( GLBDATA)
View and Extract your results ( GLIEXTR OR GLAEXTR
23. Letter GenerationorVariable Generation
The Letter Generation module allows you generate letters or produce a download
file that can be used to produce letters with Microsoft Word or WordPerfect.
24. Two Easy Steps
Run the Letter Extract or Variable Extract Process ( GLBLSEL)
Format the result into easily usable form and extract it (GLRLETR)
25. How is a Letter Organized
Letter Name (GTVLETR )
Paragraph 1 (GTVPARA) GUAPARA
Variable 1, Variable 2 … GUALETR
Paragraph 2 GUAPARA
Variable 1, Variable 2 …
48. Merits
No External Interface Needed
Security Classes have already been identified
Users can write and execute themselves
49. Downside
Needs some initial Learning and Testing
Links
http://it.bridgew.edu/Banner/Documents/Other/Generaldocs.cfm