Transcript Population Selection

Population Selection Tips
• Diane Garvin
• Itawamba Community
College
• [email protected]
• Phone
662-862-8106
MBUG 2005
1
Most Important Tip –
Know Your Data
• Know the data fields, business policies
and practices of the college.
Example:
• If you want to find the number of female applicants, you need to
know
– How an applicant is entered in Banner?
– How a person’s gender is entered in Banner?
• It takes time and experience to gain knowledge of the system.
MBUG 2005
2
POPULATION SELECTION
CONCEPT
People in
Database
Selection Rules
or Criteria
Selected Population of
Individuals who
Satisfy Rules
THE SELECTED POPULATION
• May be used in letter generation.
• May be used in some Banner reports.
– Example: Student schedules
• May be used for “simple” reports.
MBUG 2005
4
Examples
• General Person
– Find the number of (or get a list of) person
records with missing birth dates.
• Recruiting
– Find the number of (or get a list of) recruits
from a particular high school.
• Academic History
– Find the number of students graduating with
honors.
MBUG 2005
5
• Admissions
– Find the number of applicants of a particular
gender or ethnicity.
• Location Management
– Find the number of students requesting
housing in a particular dormitory.
• General Student
– Find the number of students in a particular
major.
• Accounts Receivable
– Find the number of students who have been
charged a parking fine.
MBUG 2005
6
Interactive Help
• Normally, a table corresponds to a block of a Banner form.
• Use Dynamic Help from the Banner form
– Put cursor on the data item
– Select Help, then Dynamic Help Query
– Field name is the column name
MBUG 2005
7
Visualizing a Table
• Think of a table as a grid having rows and
columns–similar to a spreadsheet.
• Each row of the grid corresponds to a
record.
• Each column of the grid corresponds to a
field in the record.
MBUG 2005
8
A Simplified View of SPBPERS
PIDM GEN- CONFIBIRTH
DER DENTIALITY DATE
12345
12346
12347
12348
12349
F
F
M
F
M
Y
Y
ETHNIC CITIZEN- MARITAL
CODE SHIP
STATUS
04-Jul-81
06-Nov-75
03-Dec-72
15-Mar-68
1
2
1
2
MBUG 2005
Y
Y
Y
N
Y
S
S
M
D
9
GLRSLCT
MBUG 2005
10
Select
• Population Selection uses the SQL select
statement.
• In a population selection you can select
only PIDMs. (A Personal IDentification
Master is an internal identification number
that is created when person and nonperson records are entered on SPAIDEN.)
MBUG 2005
11
From
• The From clause indicates which table in
the database contains the information
being used in the selection.
– The From clause must include the table used
in the Select clause.
– The From clause also must include any other
table(s) involved in the Where clause.
MBUG 2005
12
GLRSLCT
MBUG 2005
13
Simple Steps
• GLRSCLT – complete and save the form.
• GLBDATA – Run through job submission.
• View results on GLIEXTR.
• Can be used in any job that has the
population selection variables.
MBUG 2005
14
GLIEXTR
MBUG 2005
15
Dates are Funny
• Date columns have date AND time so you can’t
select a date with ‘=‘. Use ‘>=‘ or ‘<=‘.
MBUG 2005
16
Rules – In
• Takes the place of multiple OR rules.
• Enclose list of values with (). Separate with “,”.
MBUG 2005
17
Rules – Like
• Wild card is required.
MBUG 2005
18
Copy Population Selection
• On the second page of GLRSLCT.
• Can copy to a different application.
MBUG 2005
19
Summary
• The most important tip is KNOW YOUR
DATA
• The second most important is CHECK
YOUR RESULTS
• The best way to learn is to do. Try some
for yourself
MBUG 2005
20