Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame this person applied to study at this institution.	VARCHAR2(6)	SARADAP	SARADAP_TERM_CODE_ENTRY
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)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
ADMISSIONS_POPULATION	Identifies an admission population such as early admit, mature, adult and continuing education, etc., associated with the person and application.	VARCHAR2(2)	SARADAP	SARADAP_ADMT_CODE
ADMISSIONS_POPULATION_DESC	Admission population description.	VARCHAR2(30)	STVADMT	STVADMT_DESC
APPLICANT_DECLINED_IND	This indicates whether the applicant has declined offer of admission.	VARCHAR2(1)	FUNCTION	SOKODSF.F_ADMS_CHECK_STATUS
APPLICANT_WITHDRAWN_IND	Indicates whether the applicant has informed the institution they no longer wish to attend and withdraw their application.	VARCHAR2(1)	FUNCTION	F_ADMS_APPLICANT_WITHDRAWN
APPLICATION_DATE	Application submission date.	DATE	SARADAP	SARADAP_APPL_DATE
APPLICATION_FEE_RECEIVED_DATE	The date application fee has been assessed.	DATE	SARADAP	SARADAP_FEE_DATE
APPLICATION_FEE_REQUIRED_IND	Inidicates whether an application fee has been assessed.	VARCHAR2(1)	CALCULATION	NVL(SARADAP_FEE_IND,'N')
APPLICATION_INFO1	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA
APPLICATION_INFO2	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA
APPLICATION_INFO3	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA
APPLICATION_INFO4	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA
APPLICATION_INFO5	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER(2)	SARADAP	SARADAP_APPL_NO
APPLICATION_RANKING_ORDER	Number dictating the hierarchical order preference among submitted applications.	NUMBER(2)	SARADAP	SARADAP_APPL_PREFERENCE
APPLICATION_STATUS	Most current status of the application, whether the status is determined by institution or student.	VARCHAR2(1)	SARADAP	SARADAP_APST_CODE
APPLICATION_STATUS_DATE	Date associated with the most current status of the application.	DATE	SARADAP	SARADAP_APST_DATE
APPLICATION_STATUS_DESC	Application status description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
APPL_ACCEPT_ANY_TIME_IND	Admission population description. Indicates whether the applicant has ever replied to accept the institution's offer of admission.	VARCHAR2(1)	FUNCTION	SOKODSF.F_ADMS_CHECK_STATUS
APPL_ACCEPT_CURRENT_IND	Indicates whether the applicant's most recent decision is to accept the institution's offer of admission.	VARCHAR2(1)	FUNCTION	SOKODSF.F_ADMS_CHECK_STATUS
CITY_BIRTH_APPL	Applicant's city of birth as reported on the admissions application.	VARCHAR2(20)	SABSUPL	SABSUPL_CITY_BIRTH
COMPLETE_IND	Indicates if the admissions application is complete and ready for review.	VARCHAR2(1)	FUNCTION	F_ADMS_APPLICATION_STATUS
CONFIRMED_IND	This indicates whether the application has been accepted by both the student and the institution by receipt of a deposit.	VARCHAR2(1)	NA	NA
COUNTY_ADMIT	Indicates the county code of the student when they were admitted. The value is either stored in the administrative system or determined via a rule to look at a specific address and take the value.	VARCHAR2(5)	SABSUPL	SABSUPL_CNTY_CODE_ADMIT
COUNTY_BIRTH_APPL	County associated with the person at the time of birth as reported on the admissions application.	VARCHAR2(5)	SABSUPL	SABSUPL_CNTY_CODE_BIRTH
COUNTY_DESC_ADMIT	County associated with the county code at the time of admission.	VARCHAR2(30)	STVCNTY	STVCNTY_DESC
COUNTY_DESC_BIRTH_APPL	County associated with the county code at the time of birth.	VARCHAR2(30)	STVCNTY	STVCNTY_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DEFERRED_IND	This indicates whether the application has been deferred, I.e. when an accepted applicant chooses to not attend in this academic period but attend in a future academic period.	VARCHAR2(1)	NA	NA
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
EDUCATION_GOAL	Applicant's educational goal at the time of application.	VARCHAR2(2)	SARADAP	SARADAP_EGOL_CODE
EDUCATION_GOAL_DESC	Educational goal description.	VARCHAR2(30)	STVEGOL	STVEGOL_DESC
EDUCATION_LEVEL	Highest level of education completed by the applicant.	VARCHAR2(3)	SARADAP	SARADAP_EDLV_CODE
EDUCATION_LEVEL_DESC	Description of the applicant'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)	SARADAP	SARADAP_FULL_PART_IND
INCOMPLETE_IND	Indicates whether the application is incomplete.	VARCHAR2(1)	FUNCTION	F_ADMS_APPLICATION_STATUS
INSTITUTION_ATTENDING	Institution the student decided to attend rather than the home institution.	VARCHAR2(6)	SARADAP	SARADAP_SBGI_CODE
INSTITUTION_ATTENDING_DESC	Source/background institution name.	VARCHAR2(30)	STVSBGI	STVSBGI_DESC
INST_ACCEPTED_CURRENT_IND	Indicates that the applicants most recent decision is that they were accepted by the institution.	VARCHAR2(1)	FUNCTION	SOKODSF.F_ADMS_CHECK_STATUS
INST_ADMIT_ANY_TIME_IND	Indicates whether the applicant has ever been accepted by the institution, regardless of the date of the acceptance.	VARCHAR2(1)	FUNCTION	SOKODSF.F_ADMS_CHECK_STATUS
INST_DENIED_IND	Indicates whether the institution has denied the applicant.	VARCHAR2(1)	FUNCTION	SOKODSF.F_ADMS_CHECK_STATUS
IN_OUT_STATE_IND	Indicates whether residency is in or out of state. Required values: I - In-state residency, O - Out-of-state residency.	VARCHAR2(1)	STVRESD	STVRESD_IN_STATE_IND
LATEST_DECISION	Most recent application decision value associated with the application.	VARCHAR2(2)	FUNCTION	SOKODSF.F_SARAPPD_INFO
LATEST_DECISION_DATE	Date most recent application decision was effective.	DATE	FUNCTION	SOKODSF.F_SARAPPD_INFO
LATEST_DECISION_DESC	Application decision (for example, applicant accepted, pending decision, quick admit) associated with the most recent decision code.	VARCHAR2(30)	STVAPDC	STVAPDC_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
NATION_ADMIT	Nation/country associated with the person at the time of admission.	VARCHAR2(5)	SABSUPL	SABSUPL_NATN_CODE_ADMIT
NATION_BIRTH_APPL	Nation/country associated with the person at the time of birth as reported on the admissions application.	VARCHAR2(5)	SABSUPL	SABSUPL_NATN_CODE_BIRTH
NATION_BIRTH_DESC_APPL	Nation/country description associated with the person at the time of birth as reported on the admissions application.	VARCHAR2(30)	STVNATN	STVNATN_NATION
NATION_DESC_ADMIT	Nation/country associated with the nation code at the time of admission.	VARCHAR2(30)	STVNATN	STVNATN_NATION
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	SARADAP	SARADAP_PIDM
POST_CODE_ADMIT	Postcode or postal code associated with the person at time of admission.	VARCHAR2(10)	NA	NA
PRIMARY_SOURCE	Primary source for the application.	VARCHAR2(6)	SARRSRC	SARRSRC_SBGI_CODE
PRIMARY_SOURCE_DESC	Source/background institution name.	VARCHAR2(30)	STVSBGI	STVSBGI_DESC
RATE	Specific assessment rate assigned to the student.	VARCHAR2(5)	SARADAP	SARADAP_RATE_CODE
RATE_DESC	Fee assessment rate code description.	VARCHAR2(30)	STVRATE	STVRATE_DESC
RECRUITER	Recruiter assigned to the person's admission application record.	VARCHAR2(3)	SARADAP	SARADAP_RECR_CODE
RECRUITER_DESC	Assigned recruiter's name.	VARCHAR2(30)	STVRECR	STVRECR_DESC
RECRUIT_TYPE	Identifies the type of recruit used to classify this prospect.	VARCHAR2(2)	SARADAP	SARADAP_RTYP_CODE
RECRUIT_TYPE_DESC	Recruit type description.	VARCHAR2(30)	STVRTYP	STVRTYP_DESC
REQUIRED_INTERVIEW_STATUS	Indicates the status of the interview associated with the applicant.	VARCHAR2(1)	SARADAP	SARADAP_INTV_CODE
REQUIRED_INTERVIEW_STATUS_DESC	Interview status description.	VARCHAR2(30)	STVINTV	STVINTV_DESC
RESIDENCY	Identifies the residency classification of the applicant and may have been used to determine enrollment charges.	VARCHAR2(1)	SARADAP	SARADAP_RESD_CODE
RESIDENCY_DESC	Residency code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
SITE	Site or location to which applicant is applying.	VARCHAR2(3)	SARADAP	SARADAP_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)	FUNCTION	GOKODSF.F_GET_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_STATE_PROVINCE	Identifies the state or province associated with this address.	VARCHAR2(3)	STVSITE	STVSITE_STATE
SITE_STATE_PROVINCE_DESC	Name of the state/province.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC
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	Non term based admissions field. Date you want to start studying.	DATE	NA	NA
STATE_ADMIT	State/Province associated with the person at the time of admission.	VARCHAR2(3)	SABSUPL	SABSUPL_STAT_CODE_ADMIT
STATE_BIRTH_APPL	State/Province associated with the person at the time of birth and reported on the admissions application.	VARCHAR2(3)	SABSUPL	SABSUPL_STAT_CODE_BIRTH
STATE_DESC_ADMIT	State/province name.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC
STATE_DESC_BIRTH_APPL	State/province name.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC
STUDENT_MEETING_TIME	Student's normal attendance time. May be either day, evening, weekend, etc.	VARCHAR2(1)	SARADAP	SARADAP_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)	SARADAP	SARADAP_STYP_CODE
STUDENT_POPULATION_DESC	Student population or type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
SUB_ACADEMIC_PERIOD	This field identifies the session or part of the academic period associated with the information on the application record.	VARCHAR2(6)	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 applicant withdraws an application or chooses not to attend this institution.	VARCHAR2(2)	SARADAP	SARADAP_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: 8.1