Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_RECRUITMENT_INFORMATION

Description Source composite view contains recruiting information for a person.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_PERIOD Academic period or time frame this person inquired about study at this institution.    

SRBRECR

SRBRECR_TERM_CODE

 
ACADEMIC_PERIOD_DESC Academic period description.    

STVTERM

STVTERM_DESC

 
ACADEMIC_YEAR Academic year associated with the academic period on this record.    

STVTERM

STVTERM_ACYR_CODE

 
ACADEMIC_YEAR_DESC Academic year description.    

STVACYR

STVACYR_DESC

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

SRBRECR

SRBRECR_ADMT_CODE

 
ADMISSION_POPULATION_DESC Admission population description.    

STVADMT

STVADMT_DESC

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DATE_ADDED Date the record was added.    

SRBRECR

SRBRECR_ADD_DATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
EDUCATION_GOAL Recruit's educational goal.    

SRBRECR

SRBRECR_EGOL_CODE

 
EDUCATION_GOAL_DESC Educational goal description.    

STVEGOL

STVEGOL_DESC

 
EDUCATION_LEVEL Highest level of education completed by the recruit.    

SRBRECR

SRBRECR_EDLV_CODE

 
EDUCATION_LEVEL_DESC Description of the recruit's current education level.    

STVEDLV

STVEDLV_DESC

 
FULL_PART_TIME_IND Indicates whether the person intends to enroll full or part time.    

SRBRECR

SRBRECR_FULL_PART_IND

 
LEARNED Code that defines how the prospect learned of the institution.    

SRRLEND

SRRLEND_LEND_CODE

 
LEARNED_DESC Description that defines how the prospect learned of the institution.    

STVLEND

STVLEND_DESC

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
OTHER_INSTITUTION Institution attending code which represents the institution the student decided to attend rather than the home institution.    

SRBRECR

SRBRECR_SBGI_CODE

 
OTHER_INSTITUTION_DESC Source/background institution name.    

STVSBGI

STVSBGI_DESC

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

SRBRECR

SRBRECR_PIDM

 
PRIMARY_PROGRAM_IND This field indicates whether this is your primary program of study.    

NA

NA

 
PRIMARY_RECRUIT_RECORD_IND Indicates whether this record is the current or most recent recruiting record. Only one record per term may be selected.    

SRBRECR

SRBRECR_SELECT_IND

 
PRIMARY_SOURCE Source of the recruit which is flagged as the primary source.    

SRRRSRC

SRRRSRC_SBGI_CODE

 
PRIMARY_SOURCE_DESC Source/background institution name.    

STVSBGI

STVSBGI_DESC

 
RATE Status of the prospect associated with the recruiting record.    

SRBRECR

SRBRECR_RSTA_CODE

 
RATE_DESC Recruitment rating status description.    

STVRSTA

STVRSTA_DESC

 
RECRUITER Recruiter assigned to the prospect's recruiting record.    

SRBRECR

SRBRECR_RECR_CODE

 
RECRUITER_DESC Assigned recruiter's name.    

STVRECR

STVRECR_DESC

 
RECRUITER_ID This field specifies the recruiter ID associated with the recruiter.    

NA

NA

 
RECRUIT_NUMBER Internal sequence number for the academic period.    

SRBRECR

SRBRECR_ADMIN_SEQNO

 
RECRUIT_STATUS Current status of this recruitment record, whether the status is determined by the institution or prospective student.    

SRBRECR

SRBRECR_RSTA_CODE

 
RECRUIT_STATUS_DESC The recruit status description.    

STVRSTA

STVRSTA_DESC

 
RECRUIT_TYPE Identifies the type of recruit used to classify this prospect.    

SRBRECR

SRBRECR_RTYP_CODE

 
RECRUIT_TYPE_DESC Recruit type description.    

STVRTYP

STVRTYP_DESC

 
RESIDENCY Identifies the residency classification of the applicant and may have been used to determine enrollment charges.    

SRBRECR

SRBRECR_RESD_CODE

 
RESIDENCY_DESC Residency code description.    

STVRESD

STVRESD_DESC

 
RESIDENCY_IND Indicates whether residency is in or out of area. May represent in or out of state/province, in or out of EU, etc.    

STVRESD

STVRESD_IN_STATE_IND

 
SITE Site or location to which recruit is applying.    

SRBRECR

SRBRECR_SITE_CODE

 
SITE_CARRIER_ROUTE Carrier route associated with the site address for barcode mailings.    

NA

NA

 
SITE_CITY City, town or municipality associated with the site address.    

STVSITE

STVSITE_CITY

 
SITE_CORRECTION_DIGIT Correction digit associated with the site address for barcode mailings.    

NA

NA

 
SITE_COUNTY_CODE County associated with the site address.    

NA

NA

 
SITE_COUNTY_CODE_DESC Descriptions of the county associated with the site address.    

NA

NA

 
SITE_DELIVERY_POINT Delivery point associated with the site address for barcode mailings.    

NA

NA

 
SITE_DESC Site or location name.    

STVSITE

STVSITE_DESC

 
SITE_NATION Nation/country code associated with the site address.    

STVSITE

STVSITE_NATION_CODE

 
SITE_NATION_DESC Description for the nation/country associated with the site address.    

STVNATN

STVNATN_NATION

 
SITE_POSTAL_CODE Postal code associated with the site address.    

STVSITE

STVSITE_ZIPC

 
SITE_STREET_LINE1 First line of the site address.    

STVSITE

STVSITE_STREET_ADDR1

 
SITE_STREET_LINE2 Second line of the site address.    

STVSITE

STVSITE_STREET_ADDR2

 
SITE_STREET_LINE3 Third line of the site address.    

STVSITE

STVSITE_STREET_ADDR3

 
SITE_STREET_LINE4 Fourth line of the site address.    

NA

NA

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

NA

NA

 
STUDENT_MEETING_TIME Student's normal attendance time. May be either day, evening, weekend, etc.    

SRBRECR

SRBRECR_SESS_CODE

 
STUDENT_MEETING_TIME_DESC Student's meeting session description.    

STVSESS

STVSESS_DESC

 
STUDENT_POPULATION Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc.    

SRBRECR

SRBRECR_STYP_CODE

 
STUDENT_POPULATION_DESC Student population or type description.    

STVSTYP

STVSTYP_DESC

 
SUB_ACADEMIC_PERIOD This field identifies the session or part of the academic period associated with the information on the recruit information record.    

NA

NA

 
SUB_ACADEMIC_PERIOD_DESC This field specifies the session or part of the academic period associated with the session code.    

NA

NA

 
WITHDRAWAL_REASON Reason the prospect withdraws interest in the institution.    

SRBRECR

SRBRECR_WRSN_CODE

 
WITHDRAWAL_REASON_DESC Reason for withdrawal description.    

STVWRSN

STVWRSN_DESC

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3