ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACADEMIC_PERIOD	Academic period or time frame this person applied to study at this institution.			SARADAP	SARADAP_TERM_CODE_ENTRY
ACADEMIC_PERIOD_DESC	Academic period description.			STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.			FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic year description.			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.			SARADAP	SARADAP_ADMT_CODE
ADMISSIONS_POPULATION_DESC	Admission population description.			STVADMT	STVADMT_DESC
APPLICANT_DECLINED_IND	This indicates whether the applicant has declined offer of admission.			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.			FUNCTION	F_ADMS_APPLICANT_WITHDRAWN
APPLICATION_DATE	Application submission date.			SARADAP	SARADAP_APPL_DATE
APPLICATION_FEE_RECEIVED_DATE	The date application fee has been assessed.			SARADAP	SARADAP_FEE_DATE
APPLICATION_FEE_REQUIRED_IND	Inidicates whether an application fee has been assessed.			CALCULATION	NVL(SARADAP_FEE_IND,'N')
APPLICATION_INFO1	This is a generic text fields for whatever extra application information is needed.			NA	NA
APPLICATION_INFO2	This is a generic text fields for whatever extra application information is needed.			NA	NA
APPLICATION_INFO3	This is a generic text fields for whatever extra application information is needed.			NA	NA
APPLICATION_INFO4	This is a generic text fields for whatever extra application information is needed.			NA	NA
APPLICATION_INFO5	This is a generic text fields for whatever extra application information is needed.			NA	NA
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.			SARADAP	SARADAP_APPL_NO
APPLICATION_RANKING_ORDER	Number dictating the hierarchical order preference among submitted applications.			SARADAP	SARADAP_APPL_PREFERENCE
APPLICATION_STATUS	Most current status of the application, whether the status is determined by institution or student.			SARADAP	SARADAP_APST_CODE
APPLICATION_STATUS_DATE	Date associated with the most current status of the application.			SARADAP	SARADAP_APST_DATE
APPLICATION_STATUS_DESC	Application status description.			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.			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.			FUNCTION	SOKODSF.F_ADMS_CHECK_STATUS
CITY_BIRTH_APPL	Applicant's city of birth as reported on the admissions application.			SABSUPL	SABSUPL_CITY_BIRTH
COMPLETE_IND	Indicates if the admissions application is complete and ready for review.			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.			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.			SABSUPL	SABSUPL_CNTY_CODE_ADMIT
COUNTY_BIRTH_APPL	County associated with the person at the time of birth as reported on the admissions application.			SABSUPL	SABSUPL_CNTY_CODE_BIRTH
COUNTY_DESC_ADMIT	County associated with the county code at the time of admission.			STVCNTY	STVCNTY_DESC
COUNTY_DESC_BIRTH_APPL	County associated with the county code at the time of birth.			STVCNTY	STVCNTY_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			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.			NA	NA
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
EDUCATION_GOAL	Applicant's educational goal at the time of application.			SARADAP	SARADAP_EGOL_CODE
EDUCATION_GOAL_DESC	Educational goal description.			STVEGOL	STVEGOL_DESC
EDUCATION_LEVEL	Highest level of education completed by the applicant.			SARADAP	SARADAP_EDLV_CODE
EDUCATION_LEVEL_DESC	Description of the applicant's current education level.			STVEDLV	STVEDLV_DESC
FULL_PART_TIME_IND	Indicates whether the person intends to enroll full or part time.			SARADAP	SARADAP_FULL_PART_IND
INCOMPLETE_IND	Indicates whether the application is incomplete.			FUNCTION	F_ADMS_APPLICATION_STATUS
INSTITUTION_ATTENDING	Institution the student decided to attend rather than the home institution.			SARADAP	SARADAP_SBGI_CODE
INSTITUTION_ATTENDING_DESC	Source/background institution name.			STVSBGI	STVSBGI_DESC
INST_ACCEPTED_CURRENT_IND	Indicates that the applicants most recent decision is that they were accepted by the institution.			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.			FUNCTION	SOKODSF.F_ADMS_CHECK_STATUS
INST_DENIED_IND	Indicates whether the institution has denied the applicant.			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.			STVRESD	STVRESD_IN_STATE_IND
LATEST_DECISION	Most recent application decision value associated with the application.			FUNCTION	SOKODSF.F_SARAPPD_INFO
LATEST_DECISION_DATE	Date most recent application decision was effective.			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.			STVAPDC	STVAPDC_DESC
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
NATION_ADMIT	Nation/country associated with the person at the time of admission.			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.			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.			STVNATN	STVNATN_NATION
NATION_DESC_ADMIT	Nation/country associated with the nation code at the time of admission.			STVNATN	STVNATN_NATION
PERSON_UID	System generated, unique, internal identification number assigned to this person.			SARADAP	SARADAP_PIDM
POST_CODE_ADMIT	Postcode or postal code associated with the person at time of admission.			NA	NA
PRIMARY_SOURCE	Primary source for the application.			SARRSRC	SARRSRC_SBGI_CODE
PRIMARY_SOURCE_DESC	Source/background institution name.			STVSBGI	STVSBGI_DESC
RATE	Specific assessment rate assigned to the student.			SARADAP	SARADAP_RATE_CODE
RATE_DESC	Fee assessment rate code description.			STVRATE	STVRATE_DESC
RECRUITER	Recruiter assigned to the person's admission application record.			SARADAP	SARADAP_RECR_CODE
RECRUITER_DESC	Assigned recruiter's name.			STVRECR	STVRECR_DESC
RECRUIT_TYPE	Identifies the type of recruit used to classify this prospect.			SARADAP	SARADAP_RTYP_CODE
RECRUIT_TYPE_DESC	Recruit type description.			STVRTYP	STVRTYP_DESC
REQUIRED_INTERVIEW_STATUS	Indicates the status of the interview associated with the applicant.			SARADAP	SARADAP_INTV_CODE
REQUIRED_INTERVIEW_STATUS_DESC	Interview status description.			STVINTV	STVINTV_DESC
RESIDENCY	Identifies the residency classification of the applicant and may have been used to determine enrollment charges.			SARADAP	SARADAP_RESD_CODE
RESIDENCY_DESC	Residency code description.			FUNCTION	GOKODSF.F_GET_DESC
SITE	Site or location to which applicant is applying.			SARADAP	SARADAP_SITE_CODE
SITE_CARRIER_ROUTE	Carrier route associated with the site address for barcode mailings.			NA	NA
SITE_CITY	City, town or municipality associated with the site address.			STVSITE	STVSITE_CITY
SITE_CORRECTION_DIGIT	Correction digit associated with the site address for barcode mailings.			NA	NA
SITE_COUNTY_CODE	County associated with the site address.			NA	NA
SITE_COUNTY_CODE_DESC	Descriptions of the county associated with the site address.			NA	NA
SITE_DELIVERY_POINT	Delivery point associated with the site address for barcode mailings.			NA	NA
SITE_DESC	Site or location name.			FUNCTION	GOKODSF.F_GET_DESC
SITE_NATION	Nation/country code associated with the site address.			STVSITE	STVSITE_NATION_CODE
SITE_NATION_DESC	Description for the nation/country associated with the site address.			STVNATN	STVNATN_NATION
SITE_POSTAL_CODE	Postal code associated with the site address.			STVSITE	STVSITE_ZIPC
SITE_STATE_PROVINCE	Identifies the state or province associated with this address.			STVSITE	STVSITE_STATE
SITE_STATE_PROVINCE_DESC	Name of the state/province.			STVSTAT	STVSTAT_DESC
SITE_STREET_LINE1	First line of the site address.			STVSITE	STVSITE_STREET_ADDR1
SITE_STREET_LINE2	Second line of the site address.			STVSITE	STVSITE_STREET_ADDR2
SITE_STREET_LINE3	Third line of the site address.			STVSITE	STVSITE_STREET_ADDR3
SITE_STREET_LINE4	Fourth line of the site address.			NA	NA
START_DATE	Non term based admissions field. Date you want to start studying.			NA	NA
STATE_ADMIT	State/Province associated with the person at the time of admission.			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.			SABSUPL	SABSUPL_STAT_CODE_BIRTH
STATE_DESC_ADMIT	State/province name.			STVSTAT	STVSTAT_DESC
STATE_DESC_BIRTH_APPL	State/province name.			STVSTAT	STVSTAT_DESC
STUDENT_MEETING_TIME	Student's normal attendance time. May be either day, evening, weekend, etc.			SARADAP	SARADAP_SESS_CODE
STUDENT_MEETING_TIME_DESC	Student's meeting session description.			STVSESS	STVSESS_DESC
STUDENT_POPULATION	Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc.			SARADAP	SARADAP_STYP_CODE
STUDENT_POPULATION_DESC	Student population or type description.			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.			NA	NA
SUB_ACADEMIC_PERIOD_DESC	This field specifies the session or part of the academic period associated with the session code.			NA	NA
WITHDRAWAL_REASON	Reason the applicant withdraws an application or chooses not to attend this institution.			SARADAP	SARADAP_WRSN_CODE
WITHDRAWAL_REASON_DESC	Reason for withdrawal description.			STVWRSN	STVWRSN_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3