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: