Population Selection and Letter Generation

1
Population Selection and Letter Generation

• Created by College Information Systems
• with information from SCT Corporations
• 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

3
(No Transcript)
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

6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
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

11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
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

26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
(No Transcript)
34
(No Transcript)
35
(No Transcript)
36
(No Transcript)
37
(No Transcript)
38
(No Transcript)
39
(No Transcript)
40
(No Transcript)
41
(No Transcript)
42
(No Transcript)
43
(No Transcript)
44
(No Transcript)
45
(No Transcript)
46
(No Transcript)
47
(No Transcript)
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/Gener
  aldocs.cfm