Go To View:  RETURN TO COMPOSITE VIEW 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.

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

SRBRECR

SRBRECR_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

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. VARCHAR2(2)

SRBRECR

SRBRECR_ADMT_CODE

ADMISSION_POPULATION_DESC Admission population description. VARCHAR2(30)

STVADMT

STVADMT_DESC

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

NA

SYSDATE

DATE_ADDED Date the record was added. DATE

SRBRECR

SRBRECR_ADD_DATE

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

NA

NA

EDUCATION_GOAL Recruit's educational goal. VARCHAR2(2)

SRBRECR

SRBRECR_EGOL_CODE

EDUCATION_GOAL_DESC Educational goal description. VARCHAR2(30)

STVEGOL

STVEGOL_DESC

EDUCATION_LEVEL Highest level of education completed by the recruit. VARCHAR2(3)

SRBRECR

SRBRECR_EDLV_CODE

EDUCATION_LEVEL_DESC Description of the recruit's current education level. VARCHAR2(30)

STVEDLV

STVEDLV_DESC

FULL_PART_TIME_IND Indicates whether the person intends to enroll full or part time. VARCHAR2(1)

SRBRECR

SRBRECR_FULL_PART_IND

LEARNED Code that defines how the prospect learned of the institution. VARCHAR2(10)

SRRLEND

SRRLEND_LEND_CODE

LEARNED_DESC Description that defines how the prospect learned of the institution. VARCHAR2(30)

STVLEND

STVLEND_DESC

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

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

NA

NA

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

SRBRECR

SRBRECR_SBGI_CODE

OTHER_INSTITUTION_DESC Source/background institution name. VARCHAR2(30)

STVSBGI

STVSBGI_DESC

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

SRBRECR

SRBRECR_PIDM

PRIMARY_PROGRAM_IND This field indicates whether this is your primary program of study. VARCHAR2(1)

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. VARCHAR2(1)

SRBRECR

SRBRECR_SELECT_IND

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

SRRRSRC

SRRRSRC_SBGI_CODE

PRIMARY_SOURCE_DESC Source/background institution name. VARCHAR2(30)

STVSBGI

STVSBGI_DESC

RATE Status of the prospect associated with the recruiting record. VARCHAR2(2)

SRBRECR

SRBRECR_RSTA_CODE

RATE_DESC Recruitment rating status description. VARCHAR2(30)

STVRSTA

STVRSTA_DESC

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

SRBRECR

SRBRECR_RECR_CODE

RECRUITER_DESC Assigned recruiter's name. VARCHAR2(30)

STVRECR

STVRECR_DESC

RECRUITER_ID This field specifies the recruiter ID associated with the recruiter. VARCHAR2(9)

NA

NA

RECRUIT_NUMBER Internal sequence number for the academic period. NUMBER(2)

SRBRECR

SRBRECR_ADMIN_SEQNO

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

SRBRECR

SRBRECR_RSTA_CODE

RECRUIT_STATUS_DESC The recruit status description. VARCHAR2(30)

STVRSTA

STVRSTA_DESC

RECRUIT_TYPE Identifies the type of recruit used to classify this prospect. VARCHAR2(2)

SRBRECR

SRBRECR_RTYP_CODE

RECRUIT_TYPE_DESC Recruit type description. VARCHAR2(30)

STVRTYP

STVRTYP_DESC

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

SRBRECR

SRBRECR_RESD_CODE

RESIDENCY_DESC Residency code description. VARCHAR2(30)

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. VARCHAR2(1)

STVRESD

STVRESD_IN_STATE_IND

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

SRBRECR

SRBRECR_SITE_CODE

SITE_CARRIER_ROUTE Carrier route associated with the site address for barcode mailings. VARCHAR2(4)

NA

NA

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

STVSITE

STVSITE_CITY

SITE_CORRECTION_DIGIT Correction digit associated with the site address for barcode mailings. VARCHAR2(1)

NA

NA

SITE_COUNTY_CODE County associated with the site address. VARCHAR2(5)

NA

NA

SITE_COUNTY_CODE_DESC Descriptions of the county associated with the site address. VARCHAR2(30)

NA

NA

SITE_DELIVERY_POINT Delivery point associated with the site address for barcode mailings. VARCHAR2(2)

NA

NA

SITE_DESC Site or location name. VARCHAR2(30)

STVSITE

STVSITE_DESC

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

STVSITE

STVSITE_NATION_CODE

SITE_NATION_DESC Description for the nation/country associated with the site address. VARCHAR2(30)

STVNATN

STVNATN_NATION

SITE_POSTAL_CODE Postal code associated with the site address. VARCHAR2(30)

STVSITE

STVSITE_ZIPC

SITE_STREET_LINE1 First line of the site address. VARCHAR2(75)

STVSITE

STVSITE_STREET_ADDR1

SITE_STREET_LINE2 Second line of the site address. VARCHAR2(75)

STVSITE

STVSITE_STREET_ADDR2

SITE_STREET_LINE3 Third line of the site address. VARCHAR2(75)

STVSITE

STVSITE_STREET_ADDR3

SITE_STREET_LINE4 Fourth line of the site address. VARCHAR2(30)

NA

NA

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

NA

NA

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

SRBRECR

SRBRECR_SESS_CODE

STUDENT_MEETING_TIME_DESC Student's meeting session description. VARCHAR2(30)

STVSESS

STVSESS_DESC

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

SRBRECR

SRBRECR_STYP_CODE

STUDENT_POPULATION_DESC Student population or type description. VARCHAR2(30)

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. VARCHAR2(3)

NA

NA

SUB_ACADEMIC_PERIOD_DESC This field specifies the session or part of the academic period associated with the session code. VARCHAR2(30)

NA

NA

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

SRBRECR

SRBRECR_WRSN_CODE

WITHDRAWAL_REASON_DESC Reason for withdrawal description. VARCHAR2(30)

STVWRSN

STVWRSN_DESC

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

NA

NA



Ver: 8.0