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(63)	SRBRECR	SRBRECR_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	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(63)	SORLCUR	SORLCUR_ADMT_CODE	NO	NO
ADMISSION_POPULATION_DESC	Admission population description.	VARCHAR2(255)	STVADMT	STVADMT_DESC	NO	NO
ATTRIBUTE_COUNT	Count of student attributes recorded for the recruitment information.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_RECRUITMENT_ATTRIBUTES	NO	NO
AWARD_CATEGORY	Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc.	VARCHAR2(63)	STVDEGC	STVDEGC_ACAT_CODE	NO	NO
AWARD_CATEGORY_DESC	Award category description.	VARCHAR2(255)	STVACAT	STVACAT_DESC	NO	NO
CAMPUS	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(63)	SORLCUR	SORLCUR_CAMP_CODE	NO	NO
CAMPUS_DESC	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC	NO	NO
COHORT_COUNT	Count of all the current active recruitment cohort codes recorded for the person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_COHORTS	NO	NO
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(63)	SORLCUR	SORLCUR_COLL_CODE	NO	NO
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
CURRICULUM_ORDER	Unique sequence number that identifies this academic study or program for the student.	NUMBER	CALCULATION	ROW_NUMBER	NO	NO
CURRICULUM_PRIORITY_NUMBER	Identifies the significanct ranking for a curricula.	NUMBER	SORLCUR	SORLCUR_PRIORITY_NO	NO	NO
DATE_ADDED	Date the record was added.	DATE	SRBRECR	SRBRECR_ADD_DATE	NO	NO
DEGREE	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.	VARCHAR2(63)	SORLCUR	SORLCUR_DEGC_CODE	NO	NO
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC	NO	NO
DEPARTMENT	Department responsible for the major subject area of a student course or associated with the major within the student academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO
EDUCATION_GOAL	Recruit's educational goal.	VARCHAR2(63)	SRBRECR	SRBRECR_EGOL_CODE	NO	NO
EDUCATION_GOAL_DESC	Educational goal description.	VARCHAR2(255)	STVEGOL	STVEGOL_DESC	NO	NO
EDUCATION_LEVEL	Highest level of education completed by the recruit.	VARCHAR2(63)	SRBRECR	SRBRECR_EDLV_CODE	NO	NO
EDUCATION_LEVEL_DESC	Description of the recruit's current education level.	VARCHAR2(255)	STVEDLV	STVEDLV_DESC	NO	NO
FIRST_CONCENTRATION	Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FIRST_CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
FIRST_MINOR	Minor subject area of the person's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FIRST_MINOR_DESC	Minor subject area description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_DEPARTMENT	Department responsible for the major or subject area of academic instruction.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
FOURTH_DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO
FOURTH_MAJOR	Subject area or major focus recorded for the student's academic study. This may be blank.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MAJOR_CONC_1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MAJOR_CONC_1_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_MAJOR_CONC_2	Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MAJOR_CONC_2_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_MAJOR_CONC_3	Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MAJOR_CONC_3_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_MINOR	Fourth minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MINOR_DESC	Minor area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for the academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE	NO	NO
FOURTH_PROGRAM_CLASSIF_DESC	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
INTENDED_TIME_STATUS	Indicates whether the prospect is a full-time (F) or part-time (P) student.	VARCHAR2(1)	SRBRECR	SRBRECR_FULL_PART_IND	NO	NO
LEARNED	Specifies how the prospect learned about the institution. If multiple learned records exist for this recruitment record, this will reflect the most recently recorded value based on activity date.	VARCHAR2(63)	SRRLEND	SRRLEND_LEND_CODE	NO	NO
LEARNED_DESC	Description of how the prospect learned about the institution.	VARCHAR2(255)	STVLEND	STVLEND_DESC	NO	NO
MAJOR	Major subject area of the person's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
MAJOR_DESC	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name middle initial).	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
OTHER_INSTITUTION	Institution attending code represents the institution the student decided to attend rather than this institution.	VARCHAR2(63)	SRBRECR	SRBRECR_SBGI_CODE	NO	NO
OTHER_INSTITUTION_DESC	Source/background institution name.	VARCHAR2(255)	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	Indicates whether this is the 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(63)	SRRRSRC	SRRRSRC_SBGI_CODE	NO	NO
PRIMARY_SOURCE_DESC	Source/background institution name.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(63)	SORLCUR	SORLCUR_PROGRAM	NO	NO
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE	NO	NO
PROGRAM_CLASSIFICATION_DESC	Program classification description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC	NO	NO
PROGRAM_DESC	Program or course of study description.	VARCHAR2(255)	SMRPRLE	SMRPRLE_PROGRAM_DESC	NO	NO
RATE	Current institution designated status of this prospect.	VARCHAR2(63)	NA	NA	NO	NO
RATE_DESC	Recruitment rating status description.	VARCHAR2(255)	NA	NA	NO	NO
RECRUITER	Recruiter assigned to the prospect's recruiting record.	VARCHAR2(63)	SRBRECR	SRBRECR_RECR_CODE	NO	NO
RECRUITER_DESC	Assigned recruiter's name.	VARCHAR2(255)	STVRECR	STVRECR_DESC	NO	NO
RECRUITER_ID	Current identification number of 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(63)	SRBRECR	SRBRECR_RSTA_CODE	NO	NO
RECRUIT_STATUS_DESC	Recruit status description.	VARCHAR2(255)	STVRSTA	STVRSTA_DESC	NO	NO
RECRUIT_TYPE	Identifies the type of recruit used to classify this prospect.	VARCHAR2(63)	SRBRECR	SRBRECR_RTYP_CODE	NO	NO
RECRUIT_TYPE_DESC	Recruit type description.	VARCHAR2(255)	STVRTYP	STVRTYP_DESC	NO	NO
RESIDENCY	Residency code for the student identifying the type of charges the student will incur.	VARCHAR2(63)	SRBRECR	SRBRECR_RESD_CODE	NO	NO
RESIDENCY_DESC	Residency code description.	VARCHAR2(255)	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
SECOND_CONCENTRATION	Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_DEPARTMENT	Department responsible for the major or subject area of academic instruction.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
SECOND_DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO
SECOND_MAJOR	Major subject area of the person's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_1_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MAJOR_CONC_2	Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_2_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MAJOR_CONC_3	Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_3_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MINOR	Second minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MINOR_DESC	Minor area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for the academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE	NO	NO
SECOND_PROGRAM_CLASSIF_DESC	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC	NO	NO
SITE	Site or location to which recruit is applying.	VARCHAR2(63)	SRBRECR	SRBRECR_SITE_CODE	NO	NO
SITE_CARRIER_ROUTE	Carrier route associated with the site address for barcode mailings.	VARCHAR2(63)	NA	NA	NO	NO
SITE_CITY	City, town or municipality associated with the site address.	VARCHAR2(63)	STVSITE	STVSITE_CITY	NO	NO
SITE_CORRECTION_DIGIT	Correction digit associated with the site address for barcode mailings.	VARCHAR2(63)	NA	NA	NO	NO
SITE_COUNTY_CODE	County associated with the site address.	VARCHAR2(63)	NA	NA	NO	NO
SITE_COUNTY_CODE_DESC	County description associated with the site address.	VARCHAR2(255)	NA	NA	NO	NO
SITE_DELIVERY_POINT	Delivery point associated with the site address for barcode mailings.	VARCHAR2(63)	NA	NA	NO	NO
SITE_DESC	Site or location name.	VARCHAR2(255)	STVSITE	STVSITE_DESC	NO	NO
SITE_NATION	Nation/country code associated with the site address.	VARCHAR2(63)	STVSITE	STVSITE_NATION_CODE	NO	NO
SITE_NATION_DESC	Nation/country description associated with the site address.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
SITE_POSTAL_CODE	Postal code associated with the site address.	VARCHAR2(63)	STVSITE	STVSITE_ZIPC	NO	NO
SITE_STREET_LINE1	First line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR1	NO	NO
SITE_STREET_LINE2	Second line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR2	NO	NO
SITE_STREET_LINE3	Third line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR3	NO	NO
SITE_STREET_LINE4	Fourth line of the site address.	VARCHAR2(255)	NA	NA	NO	NO
SOURCE_COUNT	Count of sources recorded for this inquiry. Included might be secondary school recruiter visit, newspaper advertisement, friend referral, etc.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_RECRUITMENT_SOURCES	NO	NO
START_DATE	Date you want to begin studying. The non-term based admissions field.	DATE	SORLCUR	SORLCUR_START_DATE	NO	NO
STUDENT_LEVEL	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(63)	SORLCUR	SORLCUR_LEVL_CODE	NO	NO
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC	NO	NO
STUDENT_MEETING_TIME	Student's normal attendance time. May be either day, evening, weekend, etc.	VARCHAR2(63)	SRBRECR	SRBRECR_SESS_CODE	NO	NO
STUDENT_MEETING_TIME_DESC	Student's meeting session description.	VARCHAR2(255)	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(63)	SRBRECR	SRBRECR_STYP_CODE	NO	NO
STUDENT_POPULATION_DESC	Student population or type description.	VARCHAR2(255)	STVSTYP	STVSTYP_DESC	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA	NO	NO
THIRD_CONCENTRATION	Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_DEPARTMENT	Department responsible for the major or subject area of academic instruction.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
THIRD_DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO
THIRD_MAJOR	Subject area or major focus recorded for the student's academic study. This may be blank.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MAJOR_CONC_1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MAJOR_CONC_1_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_MAJOR_CONC_2	Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MAJOR_CONC_2_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_MAJOR_CONC_3	Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MAJOR_CONC_3_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_MINOR	Third minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MINOR_DESC	Minor area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for the academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE	NO	NO
THIRD_PROGRAM_CLASSIF_DESC	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC	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(63)	SRBRECR	SRBRECR_WRSN_CODE	NO	NO
WITHDRAWAL_REASON_DESC	Reason for withdrawal description.	VARCHAR2(255)	STVWRSN	STVWRSN_DESC	NO	NO

Ver: 9.2