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(6)	SARADAP	SARADAP_TERM_CODE_ENTRY	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	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(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
ADMISSIONS_POPULATION_DESC	Admission population description.	VARCHAR2(30)	STVADMT	STVADMT_DESC	NO	NO
APPLICANT_DECLINED_IND	This indicates whether the applicant has declined offer of admission.	VARCHAR2(1)	NA	NA	NO	NO
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	NO	NO
APPLICATION_ADD_DATE	This field specifies the application add date.	DATE	SABSUPL	SABSUPL_ACTIVITY_DATE	NO	NO
APPLICATION_DATE	Application submission date.	DATE	SARADAP	SARADAP_APPL_DATE	NO	NO
APPLICATION_ESEL_CODE	This field specifies the Eligibility Factor Code.	VARCHAR2(2)	SABSUPL	SABSUPL_ESEL_CODE	NO	NO
APPLICATION_ESEL_DESC	This field specifies the description of Eligibility Factor Code.	VARCHAR2(30)	STVESEL	STVESEL_DESC	NO	NO
APPLICATION_FEE_RECEIVED_DATE	The date application fee has been assessed.	DATE	SARADAP	SARADAP_FEE_DATE	NO	NO
APPLICATION_FEE_REQUIRED_IND	Inidicates whether an application fee has been assessed.	VARCHAR2(1)	CALCULATION	NVL(SARADAP_FEE_IND,'N')	NO	NO
APPLICATION_IND1		VARCHAR2(1)				NO
APPLICATION_IND10		VARCHAR2(1)				NO
APPLICATION_IND2		VARCHAR2(1)				NO
APPLICATION_IND3		VARCHAR2(1)				NO
APPLICATION_IND4		VARCHAR2(1)				NO
APPLICATION_IND5		VARCHAR2(1)				NO
APPLICATION_IND6		VARCHAR2(1)				NO
APPLICATION_IND7		VARCHAR2(1)				NO
APPLICATION_IND8		VARCHAR2(1)				NO
APPLICATION_IND9		VARCHAR2(1)				NO
APPLICATION_IND_TYPE1		VARCHAR2(20)				NO
APPLICATION_IND_TYPE10		VARCHAR2(20)				NO
APPLICATION_IND_TYPE2		VARCHAR2(20)				NO
APPLICATION_IND_TYPE3		VARCHAR2(20)				NO
APPLICATION_IND_TYPE4		VARCHAR2(20)				NO
APPLICATION_IND_TYPE5		VARCHAR2(20)				NO
APPLICATION_IND_TYPE6		VARCHAR2(20)				NO
APPLICATION_IND_TYPE7		VARCHAR2(20)				NO
APPLICATION_IND_TYPE8		VARCHAR2(20)				NO
APPLICATION_IND_TYPE9		VARCHAR2(20)				NO
APPLICATION_INFO1	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA	NO	NO
APPLICATION_INFO10		VARCHAR2(60)				NO
APPLICATION_INFO11		VARCHAR2(60)				NO
APPLICATION_INFO12		VARCHAR2(60)				NO
APPLICATION_INFO13		VARCHAR2(60)				NO
APPLICATION_INFO14		VARCHAR2(60)				NO
APPLICATION_INFO15		VARCHAR2(60)				NO
APPLICATION_INFO16		VARCHAR2(60)				NO
APPLICATION_INFO17		VARCHAR2(60)				NO
APPLICATION_INFO18		VARCHAR2(60)				NO
APPLICATION_INFO19		VARCHAR2(60)				NO
APPLICATION_INFO2	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA	NO	NO
APPLICATION_INFO20		VARCHAR2(60)				NO
APPLICATION_INFO3	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA	NO	NO
APPLICATION_INFO4	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA	NO	NO
APPLICATION_INFO5	This is a generic text fields for whatever extra application information is needed.	VARCHAR2(60)	NA	NA	NO	NO
APPLICATION_INFO6		VARCHAR2(60)				NO
APPLICATION_INFO7		VARCHAR2(60)				NO
APPLICATION_INFO8		VARCHAR2(60)				NO
APPLICATION_INFO9		VARCHAR2(60)				NO
APPLICATION_INFO_DATE	This field specifies the Date of Insert.	DATE	SARHEAD	SARHEAD_ADD_DATE	NO	NO
APPLICATION_INFO_TYPE1		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE10		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE11		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE12		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE13		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE14		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE15		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE16		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE17		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE18		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE19		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE2		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE20		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE3		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE4		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE5		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE6		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE7		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE8		VARCHAR2(20)				NO
APPLICATION_INFO_TYPE9		VARCHAR2(20)				NO
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	SARADAP	SARADAP_APPL_NO	NO	NO
APPLICATION_RANKING_ORDER	Number dictating the hierarchical order preference among submitted applications.	NUMBER	SARADAP	SARADAP_APPL_PREFERENCE	NO	NO
APPLICATION_SOURCE	This field specifies Electronic Application Source Code.	VARCHAR2(4)	SARHEAD	SARHEAD_APLS_CODE	NO	NO
APPLICATION_SOURCE_DESC	This field specifies Electronic Appl Source Description.	VARCHAR2(30)	STVAPLS	STVAPLS_DESC	NO	NO
APPLICATION_STATUS	Most current status of the application, whether the status is determined by institution or student.	VARCHAR2(1)	SARADAP	SARADAP_APST_CODE	NO	NO
APPLICATION_STATUS_DATE	Date associated with the most current status of the application.	DATE	SARADAP	SARADAP_APST_DATE	NO	NO
APPLICATION_STATUS_DESC	Application status description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
APPLICATION_STATUS_IND	This field denotes Completion of Application Verification Requirements.	VARCHAR2(1)	SARHEAD	SARHEAD_APPL_STATUS_IND	NO	NO
APPLICATION_TYPE	This field specifies the Web Application Type.	VARCHAR2(2)	SARHEAD	SARHEAD_WAPP_CODE	NO	NO
APPLICATION_TYPE_DESC	This field specifies the Web Application Description.	VARCHAR2(30)	STVWAPP	STVWAPP_DESC	NO	NO
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	NO	NO
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	NO	NO
APPL_FEE_WAIVER_REASON		VARCHAR2(4)				NO
APPL_FEE_WAIVER_REASON_DESC		VARCHAR2(30)				NO
CITY_BIRTH_APPL	Applicant's city of birth as reported on the admissions application.	VARCHAR2(20)	SABSUPL	SABSUPL_CITY_BIRTH	NO	NO
COMPLETE_IND	Indicates if the admissions application is complete and ready for review.	VARCHAR2(1)	FUNCTION	F_ADMS_APPLICATION_STATUS	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
COUNTY_DESC_ADMIT	County associated with the county code at the time of admission.	VARCHAR2(30)	STVCNTY	STVCNTY_DESC	NO	NO
COUNTY_DESC_BIRTH_APPL	County associated with the county code at the time of birth.	VARCHAR2(30)	STVCNTY	STVCNTY_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
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	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EDUCATION_GOAL	Applicant's educational goal at the time of application.	VARCHAR2(2)	SARADAP	SARADAP_EGOL_CODE	NO	NO
EDUCATION_GOAL_DESC	Educational goal description.	VARCHAR2(30)	STVEGOL	STVEGOL_DESC	NO	NO
EDUCATION_LEVEL	Highest level of education completed by the applicant.	VARCHAR2(3)	SARADAP	SARADAP_EDLV_CODE	NO	NO
EDUCATION_LEVEL_DESC	Description of the applicant's current education level.	VARCHAR2(30)	STVEDLV	STVEDLV_DESC	NO	NO
FULL_PART_TIME_IND	Indicates whether the person intends to enroll full or part time.	VARCHAR2(1)	SARADAP	SARADAP_FULL_PART_IND	NO	NO
INCOMPLETE_IND	Indicates whether the application is incomplete.	VARCHAR2(1)	FUNCTION	F_ADMS_APPLICATION_STATUS	NO	NO
INSTITUTION_ATTENDING	Institution the student is attending if the withdrawal was to attend a different institution.	VARCHAR2(6)	SARADAP	SARADAP_SBGI_CODE	NO	NO
INSTITUTION_ATTENDING_DESC	Source/background institution name.	VARCHAR2(30)	STVSBGI	STVSBGI_DESC	NO	NO
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	NO	NO
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	NO	NO
INST_DENIED_IND	Indicates whether the institution has denied the applicant.	VARCHAR2(1)	FUNCTION	SOKODSF.F_ADMS_CHECK_STATUS	NO	NO
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	NO	NO
LATEST_DECISION	Most recent application decision value associated with the application.	VARCHAR2(2)	FUNCTION	SOKODSF.F_SARAPPD_INFO	NO	NO
LATEST_DECISION_DATE	Date most recent application decision was effective.	DATE	FUNCTION	SOKODSF.F_SARAPPD_INFO	NO	NO
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	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
NATION_ADMIT	Nation/country associated with the person at the time of admission.	VARCHAR2(5)	SABSUPL	SABSUPL_NATN_CODE_ADMIT	NO	NO
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	NO	NO
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	NO	NO
NATION_DESC_ADMIT	Nation/country associated with the nation code at the time of admission.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
PERSON_STATUS_IND	This field denotes Completion of Person Verification Requirements.	VARCHAR2(1)	SARHEAD	SARHEAD_PERS_STATUS_IND	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SARADAP	SARADAP_PIDM	NO	NO
POST_CODE_ADMIT	Postcode or postal code associated with the person at time of admission.	VARCHAR2(10)	NA	NA	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(6)	SARRSRC	SARRSRC_SBGI_CODE	NO	NO
PRIMARY_SOURCE_DESC	Source/background institution name.	VARCHAR2(30)	STVSBGI	STVSBGI_DESC	NO	NO
PROCESS_DATE	This field indicates the Date of Application Processing.	DATE	SARHEAD	SARHEAD_PROCESS_DATE	NO	NO
PROCESS_IND	This field denotes whether Application has been Processed.	VARCHAR2(1)	SARHEAD	SARHEAD_PROCESS_IND	NO	NO
RATE	Specific assessment rate assigned to the student.	VARCHAR2(5)	SARADAP	SARADAP_RATE_CODE	NO	NO
RATE_DESC	Fee assessment rate code description.	VARCHAR2(30)	STVRATE	STVRATE_DESC	NO	NO
RECRUITER	Recruiter assigned to the person's admission application record.	VARCHAR2(3)	SARADAP	SARADAP_RECR_CODE	NO	NO
RECRUITER_DESC	Assigned recruiter's name.	VARCHAR2(30)	STVRECR	STVRECR_DESC	NO	NO
RECRUIT_TYPE	Identifies the type of recruit used to classify this prospect.	VARCHAR2(2)	SARADAP	SARADAP_RTYP_CODE	NO	NO
RECRUIT_TYPE_DESC	Recruit type description.	VARCHAR2(30)	STVRTYP	STVRTYP_DESC	NO	NO
REQUIRED_INTERVIEW_STATUS	Indicates the status of the interview associated with the applicant.	VARCHAR2(1)	SARADAP	SARADAP_INTV_CODE	NO	NO
REQUIRED_INTERVIEW_STATUS_DESC	Interview status description.	VARCHAR2(30)	STVINTV	STVINTV_DESC	NO	NO
RESIDENCY	Residency code for the student identifying the type of charges the student will incur.	VARCHAR2(1)	SARADAP	SARADAP_RESD_CODE	NO	NO
RESIDENCY_DESC	Residency code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SITE	Site or location to which applicant is applying.	VARCHAR2(3)	SARADAP	SARADAP_SITE_CODE	NO	NO
SITE_CARRIER_ROUTE	Carrier route associated with the site address for barcode mailings.	VARCHAR2(4)	NA	NA	NO	NO
SITE_CITY	City, town or municipality associated with the site address.	VARCHAR2(50)	STVSITE	STVSITE_CITY	NO	NO
SITE_CORRECTION_DIGIT	Correction digit associated with the site address for barcode mailings.	VARCHAR2(1)	NA	NA	NO	NO
SITE_COUNTY_CODE	County associated with the site address.	VARCHAR2(5)	NA	NA	NO	NO
SITE_COUNTY_CODE_DESC	Descriptions of the county associated with the site address.	VARCHAR2(30)	NA	NA	NO	NO
SITE_DELIVERY_POINT	Delivery point associated with the site address for barcode mailings.	VARCHAR2(2)	NA	NA	NO	NO
SITE_DESC	Site or location name.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SITE_NATION	Nation/country code associated with the site address.	VARCHAR2(5)	STVSITE	STVSITE_NATION_CODE	NO	NO
SITE_NATION_DESC	Description for the nation/country associated with the site address.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
SITE_POSTAL_CODE	Postal code associated with the site address.	VARCHAR2(30)	STVSITE	STVSITE_ZIPC	NO	NO
SITE_STATE_PROVINCE	Identifies the state or province associated with this address.	VARCHAR2(3)	STVSITE	STVSITE_STATE	NO	NO
SITE_STATE_PROVINCE_DESC	Name of the state/province.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
SITE_STREET_LINE1	First line of the site address.	VARCHAR2(75)	STVSITE	STVSITE_STREET_ADDR1	NO	NO
SITE_STREET_LINE2	Second line of the site address.	VARCHAR2(75)	STVSITE	STVSITE_STREET_ADDR2	NO	NO
SITE_STREET_LINE3	Third line of the site address.	VARCHAR2(75)	STVSITE	STVSITE_STREET_ADDR3	NO	NO
SITE_STREET_LINE4	Fourth line of the site address.	VARCHAR2(30)	NA	NA	NO	NO
START_DATE	Non term based admissions field. Date you want to start studying.	DATE	NA	NA	NO	NO
STATE_ADMIT	State/Province associated with the person at the time of admission.	VARCHAR2(3)	SABSUPL	SABSUPL_STAT_CODE_ADMIT	NO	NO
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	NO	NO
STATE_DESC_ADMIT	State/province name.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
STATE_DESC_BIRTH_APPL	State/province name.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
STUDENT_MEETING_TIME	Student's normal attendance time. May be either day, evening, weekend, etc.	VARCHAR2(1)	SARADAP	SARADAP_SESS_CODE	NO	NO
STUDENT_MEETING_TIME_DESC	Student's meeting session description.	VARCHAR2(30)	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(1)	SARADAP	SARADAP_STYP_CODE	NO	NO
STUDENT_POPULATION_DESC	Student population or type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
SUB_ACADEMIC_PERIOD_DESC	This field specifies the session or part of the academic period associated with the session code.	VARCHAR2(30)	NA	NA	NO	NO
TERM_CODE_ENTRY	This field specifies the Application Term Code.	VARCHAR2(30)	SARHEAD	SARHEAD_TERM_CODE_ENTRY	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(2)	SARADAP	SARADAP_WRSN_CODE	NO	NO
WITHDRAWAL_REASON_DESC	Reason for withdrawal description.	VARCHAR2(30)	STVWRSN	STVWRSN_DESC	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: