Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	Recruitment 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	Recruitment Status Description	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	Residency Indicator	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	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	Site Postal Code	Postal code associated with the site address.	VARCHAR2(30)		STVSITE	STVSITE_ZIPC
SITE_STREET_LINE1	Site Street Line 1	First line of the site address.	VARCHAR2(75)		STVSITE	STVSITE_STREET_ADDR1
SITE_STREET_LINE2	Site Street Line 2	Second line of the site address.	VARCHAR2(75)		STVSITE	STVSITE_STREET_ADDR2
SITE_STREET_LINE3	Site Street Line 3	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: