| 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(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
|
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
|
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
|
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
|
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
|
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
|