Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: RECRUITMENT_INFORMATION

Description Contains data for all inquiries made by persons considering or planning to study at the institution. Details include the type of contact, dates and academic study or program of interest, etc.
Key & Frequency One row per person per academic period per recruit number.
Recommended Search Columns ACADEMIC_PERIOD, PERSON_UID, RECRUIT_NUMBER
COLLEGE
MAJOR, SECOND_MAJOR
RATE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD Academic Period Academic period or time frame this person inquired about study at this institution. VARCHAR2(63)  

SRBRECR

SRBRECR_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)  

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic Year Academic year associated with the academic period on this record. VARCHAR2(4)  

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)  

STVACYR

STVACYR_DESC

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

ADMISSION_POPULATION Admission Population Identifies an admission population (e.g., early admit, mature, adult and continuing education, etc.) associated with the person and recruitment information. VARCHAR2(63)  

SORLCUR

SORLCUR_ADMT_CODE

ADMISSION_POPULATION_DESC Admission Population Description Admission population description. VARCHAR2(255)  

STVADMT

STVADMT_DESC

ATTRIBUTE_COUNT Attribute Count Count of student attributes recorded for the recruitment information. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_RECRUITMENT_ATTRIBUTES

AWARD_CATEGORY Award Category Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards. VARCHAR2(63)  

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC Award Category Description Award category description. VARCHAR2(255)  

STVACAT

STVACAT_DESC

CAMPUS Campus Campus the inquirer requested information. VARCHAR2(63)  

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_DESC Campus Description Institution campus name. VARCHAR2(255)  

STVCAMP

STVCAMP_DESC

COHORT_COUNT Cohort Count Count of all the current active recruitment cohort codes recorded for the person. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_COHORTS

COLLEGE College College, faculty or school to which the academic study for the student is associated. VARCHAR2(63)  

SORLCUR

SORLCUR_COLL_CODE

COLLEGE_DESC College Description College, faculty or school name. VARCHAR2(255)  

STVCOLL

STVCOLL_DESC

CURRICULUM_ORDER Curriculum Order Unique sequence number that identifies this academic study or program for the student. NUMBER  

CALCULATION

ROW_NUMBER

CURRICULUM_PRIORITY_NUMBER Curriculum Priority Number Identifies the significanct ranking for a curricula. NUMBER  

SORLCUR

SORLCUR_PRIORITY_NO

DATE_ADDED Date Added Date the record was added. DATE  

SRBRECR

SRBRECR_ADD_DATE

DEGREE Degree Degree or award code associated with the academic study. VARCHAR2(63)  

SORLCUR

SORLCUR_DEGC_CODE

DEGREE_DESC Degree Description Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)  

STVDEGC

STVDEGC_DESC

DEPARTMENT Department Department associated with the academic study on the recruitment information. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department Description Department name. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

EDUCATION_GOAL Education Goal Recruit's educational goal. VARCHAR2(63)  

SRBRECR

SRBRECR_EGOL_CODE

EDUCATION_GOAL_DESC Education Goal Description Educational goal description. VARCHAR2(255)  

STVEGOL

STVEGOL_DESC

EDUCATION_LEVEL Education Level Highest level of education completed by the recruit. VARCHAR2(63)  

SRBRECR

SRBRECR_EDLV_CODE

EDUCATION_LEVEL_DESC Education Level Description Description of the recruit's current education level. VARCHAR2(255)  

STVEDLV

STVEDLV_DESC

FIRST_CONCENTRATION First Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

FIRST_CONCENTRATION_DESC First Concentration Description Concentration or study emphasis description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FIRST_MINOR First Minor Minor subject area of the person's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

FIRST_MINOR_DESC First Minor Description Minor subject area description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_DEPARTMENT Fourth Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

FOURTH_DEPARTMENT_DESC Fourth Department Description Department name. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

FOURTH_MAJOR Fourth Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_1 Fourth Major Concentration 1 First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_1_DESC Fourth Major Concentration 1 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_MAJOR_CONC_2 Fourth Major Concentration 2 Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_2_DESC Fourth Major Concentration 2 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_MAJOR_CONC_3 Fourth Major Concentration 3 Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_3_DESC Fourth Major Concentration 3 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_MAJOR_DESC Fourth Major Description Major or subject area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_MINOR Fourth Minor Fourth minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MINOR_DESC Fourth Minor Description Minor area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_PROGRAM_CLASSIFICATION Fourth Program Classification Program classification associated with the major subject area of study for the academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government. VARCHAR2(63)  

STVMAJR

STVMAJR_CIPC_CODE

FOURTH_PROGRAM_CLASSIF_DESC Fourth Program Classification Description Program classification code description. VARCHAR2(255)  

STVCIPC

STVCIPC_DESC

ID ID Person's identification number used to access the records associated with the person. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

INTENDED_TIME_STATUS Intended Time Status Indicates whether the prospect is a full-time (F) or part-time (P) student. VARCHAR2(1)  

SRBRECR

SRBRECR_FULL_PART_IND

LEARNED Learned Specifies how the prospect learned about the institution. If multiple learned records exist for this recruitment record, this will reflect the most recently recorded value based on activity date. VARCHAR2(63)  

SRRLEND

SRRLEND_LEND_CODE

LEARNED_DESC Learned Description Description of how the prospect learned about the institution. VARCHAR2(255)  

STVLEND

STVLEND_DESC

MAJOR Major Major code associated with the prospect's recruiting record. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_DESC Major Description Name of the student's major subject area. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

NAME Name Name of the person (last name, first name middle initial). VARCHAR2(255)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OTHER_INSTITUTION Other Institution Institution attending code represents the institution the student decided to attend rather than this institution. VARCHAR2(63)  

SRBRECR

SRBRECR_SBGI_CODE

OTHER_INSTITUTION_DESC Other Institution Description Source/background institution name. VARCHAR2(255)  

STVSBGI

STVSBGI_DESC

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER  

SRBRECR

SRBRECR_PIDM

PRIMARY_PROGRAM_IND Primary Program Indicator Indicates whether this is the primary program of study. VARCHAR2(1)  

NA

NA

PRIMARY_RECRUIT_RECORD_IND Primary Recruit Record Indicator Indicates whether this record is the current or most recent recruiting record. Only one record per term may be selected. VARCHAR2(1)  

SRBRECR

SRBRECR_SELECT_IND

PRIMARY_SOURCE Primary Source Source of the recruit which is flagged as the primary source. VARCHAR2(63)  

SRRRSRC

SRRRSRC_SBGI_CODE

PRIMARY_SOURCE_DESC Primary Source Description Source/background institution name. VARCHAR2(255)  

STVSBGI

STVSBGI_DESC

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

PROGRAM Program Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements. VARCHAR2(63)  

SORLCUR

SORLCUR_PROGRAM

PROGRAM_CLASSIFICATION Program Classification Program classification associated with the major subject area of study for the academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government. VARCHAR2(63)  

STVMAJR

STVMAJR_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC Program Classification Description Program classification description. VARCHAR2(255)  

STVCIPC

STVCIPC_DESC

PROGRAM_DESC Program Description Program or course of study description. VARCHAR2(255)  

SMRPRLE

SMRPRLE_PROGRAM_DESC

RATE Rate Current institution designated status of this prospect. VARCHAR2(63)  

NA

NA

RATE_DESC Rate Description Recruitment rating status description. VARCHAR2(255)  

NA

NA

RECRUITER Recruiter Recruiter assigned to the prospect's recruiting record. VARCHAR2(63)  

SRBRECR

SRBRECR_RECR_CODE

RECRUITER_DESC Recruiter Description Assigned recruiter's name. VARCHAR2(255)  

STVRECR

STVRECR_DESC

RECRUITER_ID Recruiter ID Current identification number of the recruiter. VARCHAR2(9)  

NA

NA

RECRUIT_NUMBER Recruit Number Internal sequence number for the academic period. NUMBER  

SRBRECR

SRBRECR_ADMIN_SEQNO

RECRUIT_STATUS Recruitment Status Current status of this recruitment record, whether the status is determined by the institution or prospective student. VARCHAR2(63)  

SRBRECR

SRBRECR_RSTA_CODE

RECRUIT_STATUS_DESC Recruitment Status Description Recruit status description. VARCHAR2(255)  

STVRSTA

STVRSTA_DESC

RECRUIT_TYPE Recruit Type Identifies the type of recruit used to classify this prospect. VARCHAR2(63)  

SRBRECR

SRBRECR_RTYP_CODE

RECRUIT_TYPE_DESC Recruit Type Description Recruit type description. VARCHAR2(255)  

STVRTYP

STVRTYP_DESC

RESIDENCY Residency Identifies the residency classification of the applicant and may have been used to determine enrollment charges. VARCHAR2(63)  

SRBRECR

SRBRECR_RESD_CODE

RESIDENCY_DESC Residency Description Residency code description. VARCHAR2(255)  

STVRESD

STVRESD_DESC

RESIDENCY_IND Residency Indicator Indicates whether residency is in or out of area. May represent in or out of state/province, in or out of EU, etc. VARCHAR2(1)  

STVRESD

STVRESD_IN_STATE_IND

SECOND_CONCENTRATION Second Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECOND_CONCENTRATION_DESC Second Concentratin Description Concentration or study emphasis description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_DEPARTMENT Second Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Second Department Description Department name. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

SECOND_MAJOR Second Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1 Second Major Concentration 1 First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1_DESC Second Major Concentration 1 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_2 Second Major Concentration 2 Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_2_DESC Second Major Concentration 2 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_3 Second Major Concentration 3 Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_3_DESC Second Major Concentration 3 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_DESC Second Major Description Major or subject area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_MINOR Second Minor Second minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MINOR_DESC Second Minor Description Minor area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_PROGRAM_CLASSIFICATION Second Program Classification Program classification associated with the major subject area of study for the academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government. VARCHAR2(63)  

STVMAJR

STVMAJR_CIPC_CODE

SECOND_PROGRAM_CLASSIF_DESC Second Program Classification Description Program classification code description. VARCHAR2(255)  

STVCIPC

STVCIPC_DESC

SITE Site Site or location to which recruit is applying. VARCHAR2(63)  

SRBRECR

SRBRECR_SITE_CODE

SITE_CARRIER_ROUTE Site Carrier Route Carrier route associated with the site address for barcode mailings. VARCHAR2(63)  

NA

NA

SITE_CITY Site City City, town or municipality associated with the site address. VARCHAR2(63)  

STVSITE

STVSITE_CITY

SITE_CORRECTION_DIGIT Site Correction Digit Correction digit associated with the site address for barcode mailings. VARCHAR2(63)  

NA

NA

SITE_COUNTY_CODE Site County Code County associated with the site address. VARCHAR2(63)  

NA

NA

SITE_COUNTY_CODE_DESC Site County Code Description County description associated with the site address. VARCHAR2(255)  

NA

NA

SITE_DELIVERY_POINT Site Delivery Point Delivery point associated with the site address for barcode mailings. VARCHAR2(63)  

NA

NA

SITE_DESC Site Description Site or location name. VARCHAR2(255)  

STVSITE

STVSITE_DESC

SITE_NATION Site Nation Nation/country code associated with the site address. VARCHAR2(63)  

STVSITE

STVSITE_NATION_CODE

SITE_NATION_DESC Site Nation Description Nation/country description associated with the site address. VARCHAR2(255)  

STVNATN

STVNATN_NATION

SITE_POSTAL_CODE Site Postal Code Postal code associated with the site address. VARCHAR2(63)  

STVSITE

STVSITE_ZIPC

SITE_STREET_LINE1 Site Street Line 1 First line of the site address. VARCHAR2(255)  

STVSITE

STVSITE_STREET_ADDR1

SITE_STREET_LINE2 Site Street Line 2 Second line of the site address. VARCHAR2(255)  

STVSITE

STVSITE_STREET_ADDR2

SITE_STREET_LINE3 Site Street Line 3 Third line of the site address. VARCHAR2(255)  

STVSITE

STVSITE_STREET_ADDR3

SITE_STREET_LINE4 Site Street Line 4 Fourth line of the site address. VARCHAR2(255)  

NA

NA

SOURCE_COUNT Source Count Count of sources recorded for this inquiry. Included might be secondary school recruiter visit, newspaper advertisement, friend referral, etc. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_RECRUITMENT_SOURCES

START_DATE Start Date Date you want to begin studying. The non-term based admissions field. DATE  

SORLCUR

SORLCUR_START_DATE

STUDENT_LEVEL Student Level Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(63)  

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student Level Description Student level description. VARCHAR2(255)  

STVLEVL

STVLEVL_DESC

STUDENT_MEETING_TIME Student Meeting Time Student's normal attendance time. May be either day, evening, weekend, etc. VARCHAR2(63)  

SRBRECR

SRBRECR_SESS_CODE

STUDENT_MEETING_TIME_DESC Student Meeting Time Description Student's meeting session description. VARCHAR2(255)  

STVSESS

STVSESS_DESC

STUDENT_POPULATION Student Population Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc. VARCHAR2(63)  

SRBRECR

SRBRECR_STYP_CODE

STUDENT_POPULATION_DESC Student Population Description Student population or type description. VARCHAR2(255)  

STVSTYP

STVSTYP_DESC

SUB_ACADEMIC_PERIOD Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)  

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description Sub academic period description. VARCHAR2(255)  

NA

NA

THIRD_CONCENTRATION Third Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

THIRD_CONCENTRATION_DESC Third Concentration Description Concentration or study emphasis description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_DEPARTMENT Third Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

THIRD_DEPARTMENT_DESC Third Department Description Department name. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

THIRD_MAJOR Third Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_1 Third Major Concentration 1 First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_1_DESC Third Major Concentration 1 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_MAJOR_CONC_2 Third Major Concentration 2 Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_2_DESC Third Major Concentration 2 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_MAJOR_CONC_3 Third Major Concentration 3 Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_3_DESC Third Major Concentration 3 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_MAJOR_DESC Third Major Description Major or subject area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_MINOR Third Minor Third minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MINOR_DESC Third Minor Description Minor area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_PROGRAM_CLASSIFICATION Third Program Classification Program classification associated with the major subject area of study for the academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government. VARCHAR2(63)  

STVMAJR

STVMAJR_CIPC_CODE

THIRD_PROGRAM_CLASSIF_DESC Third Program Classification Description Program classification code description. VARCHAR2(255)  

STVCIPC

STVCIPC_DESC

WITHDRAWAL_REASON Withdrawal Reason Reason the prospect withdraws interest in the institution. VARCHAR2(63)  

SRBRECR

SRBRECR_WRSN_CODE

WITHDRAWAL_REASON_DESC Withdrawal Reason Description Reason for withdrawal description. VARCHAR2(255)  

STVWRSN

STVWRSN_DESC



Ver: 9.0