Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
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	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC	NO	NO
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	NO	NO
ADMISSION_POPULATION_DESC	Admission population description.	VARCHAR2(30)	STVADMT	STVADMT_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DATE_ADDED	Date the record was added.	DATE	SRBRECR	SRBRECR_ADD_DATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EDUCATION_GOAL	Recruit's educational goal.	VARCHAR2(2)	SRBRECR	SRBRECR_EGOL_CODE	NO	NO
EDUCATION_GOAL_DESC	Educational goal description.	VARCHAR2(30)	STVEGOL	STVEGOL_DESC	NO	NO
EDUCATION_LEVEL	Highest level of education completed by the recruit.	VARCHAR2(3)	SRBRECR	SRBRECR_EDLV_CODE	NO	NO
EDUCATION_LEVEL_DESC	Description of the recruit's current education level.	VARCHAR2(30)	STVEDLV	STVEDLV_DESC	NO	NO
FULL_PART_TIME_IND	Indicates whether the person intends to enroll full or part time.	VARCHAR2(1)	SRBRECR	SRBRECR_FULL_PART_IND	NO	NO
LEARNED	Code that defines how the prospect learned of the institution.	VARCHAR2(10)	SRRLEND	SRRLEND_LEND_CODE	NO	NO
LEARNED_DESC	Description that defines how the prospect learned of the institution.	VARCHAR2(30)	STVLEND	STVLEND_DESC	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
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	NO	NO
OTHER_INSTITUTION_DESC	Source/background institution name.	VARCHAR2(30)	STVSBGI	STVSBGI_DESC	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SRBRECR	SRBRECR_PIDM	NO	NO
PRIMARY_PROGRAM_IND	This field indicates whether this is your primary program of study.	VARCHAR2(1)	NA	NA	NO	NO
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	NO	NO
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	NO	NO
PRIMARY_SOURCE_DESC	Source/background institution name.	VARCHAR2(30)	STVSBGI	STVSBGI_DESC	NO	NO
RATE	Status of the prospect associated with the recruiting record.	VARCHAR2(2)	SRBRECR	SRBRECR_RSTA_CODE	NO	NO
RATE_DESC	Recruitment rating status description.	VARCHAR2(30)	STVRSTA	STVRSTA_DESC	NO	NO
RECRUITER	Recruiter assigned to the prospect's recruiting record.	VARCHAR2(3)	SRBRECR	SRBRECR_RECR_CODE	NO	NO
RECRUITER_DESC	Assigned recruiter's name.	VARCHAR2(30)	STVRECR	STVRECR_DESC	NO	NO
RECRUITER_ID	This field specifies the recruiter ID associated with the recruiter.	VARCHAR2(9)	NA	NA	NO	NO
RECRUIT_NUMBER	Internal sequence number for the academic period.	NUMBER	SRBRECR	SRBRECR_ADMIN_SEQNO	NO	NO
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	NO	NO
RECRUIT_STATUS_DESC	The recruit status description.	VARCHAR2(30)	STVRSTA	STVRSTA_DESC	NO	NO
RECRUIT_TYPE	Identifies the type of recruit used to classify this prospect.	VARCHAR2(2)	SRBRECR	SRBRECR_RTYP_CODE	NO	NO
RECRUIT_TYPE_DESC	Recruit type description.	VARCHAR2(30)	STVRTYP	STVRTYP_DESC	NO	NO
RESIDENCY	Residency code for the student identifying the type of charges the student will incur.	VARCHAR2(1)	SRBRECR	SRBRECR_RESD_CODE	NO	NO
RESIDENCY_DESC	Residency code description.	VARCHAR2(30)	STVRESD	STVRESD_DESC	NO	NO
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	NO	NO
SITE	Site or location to which recruit is applying.	VARCHAR2(3)	SRBRECR	SRBRECR_SITE_CODE	NO	NO
SITE_CARRIER_ROUTE	Carrier route associated with the site address for barcode mailings.	VARCHAR2(4)	NA	NA	NO	NO
SITE_CITY	City, town or municipality associated with the site address.	VARCHAR2(50)	STVSITE	STVSITE_CITY	NO	NO
SITE_CORRECTION_DIGIT	Correction digit associated with the site address for barcode mailings.	VARCHAR2(1)	NA	NA	NO	NO
SITE_COUNTY_CODE	County associated with the site address.	VARCHAR2(5)	NA	NA	NO	NO
SITE_COUNTY_CODE_DESC	Descriptions of the county associated with the site address.	VARCHAR2(30)	NA	NA	NO	NO
SITE_DELIVERY_POINT	Delivery point associated with the site address for barcode mailings.	VARCHAR2(2)	NA	NA	NO	NO
SITE_DESC	Site or location name.	VARCHAR2(30)	STVSITE	STVSITE_DESC	NO	NO
SITE_NATION	Nation/country code associated with the site address.	VARCHAR2(5)	STVSITE	STVSITE_NATION_CODE	NO	NO
SITE_NATION_DESC	Description for the nation/country associated with the site address.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
SITE_POSTAL_CODE	Postal code associated with the site address.	VARCHAR2(30)	STVSITE	STVSITE_ZIPC	NO	NO
SITE_STREET_LINE1	First line of the site address.	VARCHAR2(75)	STVSITE	STVSITE_STREET_ADDR1	NO	NO
SITE_STREET_LINE2	Second line of the site address.	VARCHAR2(75)	STVSITE	STVSITE_STREET_ADDR2	NO	NO
SITE_STREET_LINE3	Third line of the site address.	VARCHAR2(75)	STVSITE	STVSITE_STREET_ADDR3	NO	NO
SITE_STREET_LINE4	Fourth line of the site address.	VARCHAR2(30)	NA	NA	NO	NO
START_DATE	Date you want to begin studying. The non-term based admissions field.	DATE	NA	NA	NO	NO
STUDENT_MEETING_TIME	Student's normal attendance time. May be either day, evening, weekend, etc.	VARCHAR2(1)	SRBRECR	SRBRECR_SESS_CODE	NO	NO
STUDENT_MEETING_TIME_DESC	Student's meeting session description.	VARCHAR2(30)	STVSESS	STVSESS_DESC	NO	NO
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	NO	NO
STUDENT_POPULATION_DESC	Student population or type description.	VARCHAR2(30)	STVSTYP	STVSTYP_DESC	NO	NO
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	NO	NO
SUB_ACADEMIC_PERIOD_DESC	This field specifies the session or part of the academic period associated with the session code.	VARCHAR2(30)	NA	NA	NO	NO
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	NO	NO
WITHDRAWAL_REASON_DESC	Reason for withdrawal description.	VARCHAR2(30)	STVWRSN	STVWRSN_DESC	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: