1 / 20

Population Selection Tips

Population Selection Tips. Diane Garvin Itawamba Community College dlgarvin@iccms.edu Phone 662-862-8106. Most Important Tip – Know Your Data. Know the data fields, business policies and practices of the college. Example:

salome
Download Presentation

Population Selection Tips

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Population Selection Tips • Diane Garvin • Itawamba Community College • dlgarvin@iccms.edu • Phone 662-862-8106 MBUG 2005

  2. 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

  3. POPULATION SELECTIONCONCEPT People in Database Selection Rules or Criteria Selected Population of Individuals who Satisfy Rules

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. A Simplified View of SPBPERS MBUG 2005

  10. GLRSLCT MBUG 2005

  11. 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 non-person records are entered on SPAIDEN.) MBUG 2005

  12. 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

  13. GLRSLCT MBUG 2005

  14. 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

  15. GLIEXTR MBUG 2005

  16. Dates are Funny • Date columns have date AND time so you can’t select a date with ‘=‘. Use ‘>=‘ or ‘<=‘. MBUG 2005

  17. Rules – In • Takes the place of multiple OR rules. • Enclose list of values with (). Separate with “,”. MBUG 2005

  18. Rules – Like • Wild card is required. MBUG 2005

  19. Copy Population Selection • On the second page of GLRSLCT. • Can copy to a different application. MBUG 2005

  20. 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

More Related