Banner Population Selection -- Common Population Selections


Below is a list of Common Population Selections available to PCC Banner-users. If none of the Population Selection options below fit your needs, other options are available. Please refer to the Population Selection page for guidance, or contact the TSS Training Team.

Click on the Population Selection names below for complete instructions on how to create each population.

The Top 21
Type of DataName of Population Selection Description
Admissions, new studentsADMITTEDAll new, first time students admitted during a specified range of dates, for a specified student level (credit or non-credit), term, and student campus
Admissions, new students, readmitted studentsADMITTED_FNR_ALL

All New (to PCC), First Time (in any College), and Readmitted (to PCC) students admitted to any PCC campus during a specified range of dates, for a specified term. (For a single campus, use ADMITTED_FNR)
Student enrollment into classes, based on subject and attendance methodENROLLED_STUDENTSAll students enrolled in courses with one or more specified academic subject codes, terms, and attendance methods
Ethnicity, by campus (Currently unavailable and under revision).ETHNIC_STDN_LEVELAll students with one specified ethnicity code, student campus, level (degree seeking or non-degree seeking) and term.
Faculty employeesFAC_BY_ATTN_METHAll instructors assigned to teach classes with a specified attendance method and term
Grade Point AverageGPA_TERM_xxxAll students taking at least 6 credits, earning a GPA of (you specify) or greater at least once during a specified range of terms, for a specified student campus
Graduates and certificate-earnersGRADUATESAll students awarded a degree or certificate (including High School Diploma) between a specified range of dates
Graduates and certificate-earners based on majorGRADS_MAJORAll students awarded a degree or certificate (including High School Diploma) between a specified range of dates, with a specific major code at time of graduation
Phi Theta Kappa studentsPTK_ENRLAll students from a specified student campus with a cumulative 3.5 or higher GPA and 12 or more PCC credits during a specified range of terms
Student enrollment into classes, based on attendance methodREGS_STDN_ACCTAll students enrolled in courses with one specified attendance method code for one term
Student enrollment into classes, based on campus(es)REGS_STDN_CAMPAll students enrolled in courses at one specified campus for one term.
(For more than one campus, use REGS_STDN_CAMPS)
Student enrollment into classes, based on CRN(s)REGS_STDN_CRNAll students enrolled in one specified CRN for one term.
(For more than one CRN, use REGS_STDN_CRNS)
Student enrollment into classes, based on subjectREGS_STDN_SUBJAll students enrolled in a specified academic subject for one term
International StudentsSEVIS_POPSELCreated for the International Education department
Ethnicity  (Currently unavailable and under revision).STDN_BY_ETHNICITY

All students of a specified student level (degree-seeking, non-degree-seeking, or non-credit) with a specified ethnicity code during a specified term

MajorSTUDENT_MAJORSAll active students in up to five specified majors
MajorSTUDENT_MAJORS_ALLAll students in up to five specified majors, regardless of current enrollment
Student enrollment into classes, based on CRN(s)SWRUESLAll students in up to three CRN's (within a single term)
Placement Test ScoresTESTED_AS_COAll students from a specified campus code, who took Asset and/or Compass tests within a specified range of dates
VeteransVETN_STDN_GRPSAll students with one or more specified veteran group codes for one specified term
Wait ListWAIT_LISTAll students for a specific term, waitlisted in a particular subject area which is identified by a department's 'Attendence Method' code. (originally designed for ABE/GED/ESL)

 

Other Available Common Population Selections
Population Selection TitleDescription
ADJUNCT_BY_CAMPUSAll adjunct faculty for one specified campus by one or more terms
ADMITTED_BY_HS

All students admitted for a specified term, between a range of specified dates, from a specified High School (High school codes can be accessed by using the Banner form SOISBGI)

ADM_HOLDS_AUDITAll students with a specified hold type and campus, within a specified range of dates (To view a complete list of hold codes, go to STVHLDD)
AHSD_STUDENTSAll PCC Alternative Programs students who have been identified as "AHSD" in the Degree Field of SFAREGS
CG-PTKAll Columbia Gorge students who earned a 3.25 or higher GPA (and 12 or more credits) for any term within a range of terms you specify
DEV_EDAll students tested between a specified range of dates with ASSET Scores as follows:  
AS10 - Writing Skills - score below 41 and/or AS 20 - Reading Skills - score below 42.  
(This is one way to identify Developmental Education students)
DIESEL_STUDENTSAll students registered in a class with the subject code "DS" for a specified term
F1_VISAAll students, entered in Banner, regardless of current registration activity, with an F1 Visa type (This means even students who have not attended classes for years will be selected if they are present in Banner with F1 Visa type code)
GATEWAY_TO_COLLEGE_STUDENTSStudents in Gateway to College program for a specified term.
GPA_250All full-time students earning a GPA of 2.50 or greater between a specified range of dates, for a specified term and student campus
GPA_275All full-time students earning a GPA of 2.75 or greater between a specified range of dates, for a specified term and student campus
[International Students]

SEVIS_POPSEL -- All International Students associated with a given term and campus

INTL_DEGREE_PEND -- All International Students with a pending degree during a range off dates you specify

INTL_ESOL -- All International Students enrolled in ESOL classes during the term you specify, at a campus you specify

INTL_NOTESOL -- All International Students not enrolled in ESOL classes during the term you specify, at a campus you specify

MANUALClick on the link at left for more information about the Manual Population Selection process
"NEWBERG"All students taking classes at Newberg Center
NEW_STU_WITH_REG_BY_CAMPAll new students associated with a specified (student-declared) primary campus who registered in class(es) during a specified term
OSD_ADVISORAll students with a specified advisor for a specified effective term
OSD_DISABILITYAll students with one specified disability code for a specified registration term
PAVTECAll students registered in classes which carry the "PAVTEC" attendance method, within a specified range of terms
PROJECT_ADVANCEAll students registered in classes which carry the "Project Advance" attendance method, within a specified range of terms
REGS_STDNAll students enrolled during one specified term
ROOTS_ATTRIBUTE_CODEAll students who enrolled in classes during a given term and associated with a specific student attribute code. Used by the ROOTS program
STUDENT_DEGREESAll students who have ever been awarded a specific degree (for example, Adult HS Diploma)
STDN_LEVL_GPAAll students with a specified or higher GPA for all terms
STDN_TERM_GPAAll students with a specified or higher GPA for a specified term
STUDENT_ADMIT_CODEAll students with a specified Admit Code for a specified term
STUDENT_FOLLOWUPAll students with one specified ethnicity code, gender, student type, level, and student campus, for one term
TESTED_STUDENTSAll students from a specified campus code, who took Asset Tests (Compass not included) within a specified range of dates.  See TESTED_AS_CO above for students taking Asset and/or Compass
VETN_STDNAll veteran students for one specified term

7/2018

3 Comments

  1. I notice that there are no instructions for "WAIT_LIST".  There have been several occasions where Instructors/FDC's wanted to get a list of wait-listed students (for outreach purposes).  Is there any way to get instructions for this population?

  2. Thanks so much Lezlie!  I will update this next week when I have some more time.    (thumbs up)

  3. Thanks Lezlie, I just completed it.  (big grin)