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.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. 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

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 identified by the person at their first contact with the institution as having referred the person to this institution. Usually either the secondary or post-secondary school or newspaper advertisement. 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

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 Residency code for the student identifying the type of charges the student will incur. VARCHAR2(1)

SRBRECR

SRBRECR_RESD_CODE

RESIDENCY_DESC Residency code description. VARCHAR2(30)

STVRESD

STVRESD_DESC

RESIDENCY_IND Identifies whether the student is considered in or out of the district for enrollment charges. Typically this indicates in or out of state or province but may also be in or out of county or in or out of the European Union, 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 Identifies the category this student that will be used for governmental reporting. The typical VALUES are new first time, 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 If the student withdraws for the institution this identifies the major reason for the student withdrawal defined by institution values. 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: