Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic period or time frame this person inquired about study at this institution.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_TERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(4)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
ADMINISTRATIVE_GROUP
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
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
|
ADMISSION_POPULATION_DESC
|
Admission population description.
|
VARCHAR2(255)
|
STVADMT
|
STVADMT_DESC
|
ATTRIBUTE_COUNT
|
Count of student attributes recorded for the recruitment information.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_RECRUITMENT_ATTRIBUTES
|
AWARD_CATEGORY
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
AWARD_CATEGORY_DESC
|
Award category description.
|
VARCHAR2(255)
|
STVACAT
|
STVACAT_DESC
|
CAMPUS
|
Campus the inquirer requested information.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_CAMP_CODE
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
COHORT_COUNT
|
Count of all the current active recruitment cohort codes recorded for the person.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_COHORTS
|
COLLEGE
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_COLL_CODE
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
CURRICULUM_ORDER
|
Unique sequence number that identifies this academic study or program for the student.
|
NUMBER
|
CALCULATION
|
ROW_NUMBER
|
CURRICULUM_PRIORITY_NUMBER
|
Identifies the significanct ranking for a curricula.
|
NUMBER
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
DATE_ADDED
|
Date the record was added.
|
DATE
|
SRBRECR
|
SRBRECR_ADD_DATE
|
DEGREE
|
Degree or award code associated with the academic study.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_DEGC_CODE
|
DEGREE_DESC
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
DEPARTMENT
|
Department associated with the academic study on the recruitment information.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
EDUCATION_GOAL
|
Recruit's educational goal.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_EGOL_CODE
|
EDUCATION_GOAL_DESC
|
Educational goal description.
|
VARCHAR2(255)
|
STVEGOL
|
STVEGOL_DESC
|
EDUCATION_LEVEL
|
Highest level of education completed by the recruit.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_EDLV_CODE
|
EDUCATION_LEVEL_DESC
|
Description of the recruit's current education level.
|
VARCHAR2(255)
|
STVEDLV
|
STVEDLV_DESC
|
FIRST_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
FIRST_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
FIRST_MINOR
|
Minor subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
FIRST_MINOR_DESC
|
Minor subject area description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
FOURTH_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
FOURTH_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
FOURTH_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
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
|
FOURTH_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
FOURTH_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
FOURTH_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
FOURTH_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
FOURTH_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
FOURTH_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
ID
|
Person's identification number used to access the records associated with the person.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
INTENDED_TIME_STATUS
|
Indicates whether the prospect is a full-time (F) or part-time (P) student.
|
VARCHAR2(1)
|
SRBRECR
|
SRBRECR_FULL_PART_IND
|
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
|
LEARNED_DESC
|
Description of how the prospect learned about the institution.
|
VARCHAR2(255)
|
STVLEND
|
STVLEND_DESC
|
MAJOR
|
Major code associated with the prospect's recruiting record.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
MAJOR_DESC
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NAME
|
Name of the person (last name, first name middle initial).
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
OTHER_INSTITUTION
|
Institution attending code represents the institution the student decided to attend rather than this institution.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_SBGI_CODE
|
OTHER_INSTITUTION_DESC
|
Source/background institution name.
|
VARCHAR2(255)
|
STVSBGI
|
STVSBGI_DESC
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SRBRECR
|
SRBRECR_PIDM
|
PRIMARY_PROGRAM_IND
|
Indicates whether this is the 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(63)
|
SRRRSRC
|
SRRRSRC_SBGI_CODE
|
PRIMARY_SOURCE_DESC
|
Source/background institution name.
|
VARCHAR2(255)
|
STVSBGI
|
STVSBGI_DESC
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
PROGRAM
|
Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_PROGRAM
|
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
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
PROGRAM_DESC
|
Program or course of study description.
|
VARCHAR2(255)
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
RATE
|
Current institution designated status of this prospect.
|
VARCHAR2(63)
|
NA
|
NA
|
RATE_DESC
|
Recruitment rating status description.
|
VARCHAR2(255)
|
NA
|
NA
|
RECRUITER
|
Recruiter assigned to the prospect's recruiting record.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_RECR_CODE
|
RECRUITER_DESC
|
Assigned recruiter's name.
|
VARCHAR2(255)
|
STVRECR
|
STVRECR_DESC
|
RECRUITER_ID
|
Current identification number of 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(63)
|
SRBRECR
|
SRBRECR_RSTA_CODE
|
RECRUIT_STATUS_DESC
|
Recruit status description.
|
VARCHAR2(255)
|
STVRSTA
|
STVRSTA_DESC
|
RECRUIT_TYPE
|
Identifies the type of recruit used to classify this prospect.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_RTYP_CODE
|
RECRUIT_TYPE_DESC
|
Recruit type description.
|
VARCHAR2(255)
|
STVRTYP
|
STVRTYP_DESC
|
RESIDENCY
|
Identifies the residency classification of the applicant and may have been used to determine enrollment charges.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_RESD_CODE
|
RESIDENCY_DESC
|
Residency code description.
|
VARCHAR2(255)
|
STVRESD
|
STVRESD_DESC
|
RESIDENCY_IND
|
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
|
SECOND_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
SECOND_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
SECOND_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
SECOND_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
SECOND_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
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
|
SECOND_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
SECOND_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
SECOND_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
SECOND_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
SECOND_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
SECOND_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
SITE
|
Site or location to which recruit is applying.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_SITE_CODE
|
SITE_CARRIER_ROUTE
|
Carrier route associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
SITE_CITY
|
City, town or municipality associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_CITY
|
SITE_CORRECTION_DIGIT
|
Correction digit associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
SITE_COUNTY_CODE
|
County associated with the site address.
|
VARCHAR2(63)
|
NA
|
NA
|
SITE_COUNTY_CODE_DESC
|
County description associated with the site address.
|
VARCHAR2(255)
|
NA
|
NA
|
SITE_DELIVERY_POINT
|
Delivery point associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
SITE_DESC
|
Site or location name.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_DESC
|
SITE_NATION
|
Nation/country code associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_NATION_CODE
|
SITE_NATION_DESC
|
Nation/country description associated with the site address.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
SITE_POSTAL_CODE
|
Postal code associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_ZIPC
|
SITE_STREET_LINE1
|
First line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR1
|
SITE_STREET_LINE2
|
Second line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR2
|
SITE_STREET_LINE3
|
Third line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR3
|
SITE_STREET_LINE4
|
Fourth line of the site address.
|
VARCHAR2(255)
|
NA
|
NA
|
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
|
START_DATE
|
Date you want to begin studying. The non-term based admissions field.
|
DATE
|
SORLCUR
|
SORLCUR_START_DATE
|
STUDENT_LEVEL
|
Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_LEVL_CODE
|
STUDENT_LEVEL_DESC
|
Student level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
STUDENT_MEETING_TIME
|
Student's normal attendance time. May be either day, evening, weekend, etc.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_SESS_CODE
|
STUDENT_MEETING_TIME_DESC
|
Student's meeting session description.
|
VARCHAR2(255)
|
STVSESS
|
STVSESS_DESC
|
STUDENT_POPULATION
|
Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_STYP_CODE
|
STUDENT_POPULATION_DESC
|
Student population or type description.
|
VARCHAR2(255)
|
STVSTYP
|
STVSTYP_DESC
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|
THIRD_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
THIRD_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
THIRD_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
THIRD_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
THIRD_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
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
|
THIRD_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
THIRD_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
THIRD_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
THIRD_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
THIRD_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
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
|
THIRD_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
WITHDRAWAL_REASON
|
Reason the prospect withdraws interest in the institution.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_WRSN_CODE
|
WITHDRAWAL_REASON_DESC
|
Reason for withdrawal description.
|
VARCHAR2(255)
|
STVWRSN
|
STVWRSN_DESC
|