| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
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
|
|
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)
|
NA
|
NA
|
|
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_IND1
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND10
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND2
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND3
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND4
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND5
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND6
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND7
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND8
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND9
|
|
VARCHAR2(1)
|
|
|
|
APPLICATION_IND_TYPE1
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_IND_TYPE10
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_IND_TYPE2
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_IND_TYPE3
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_IND_TYPE4
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_IND_TYPE5
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_IND_TYPE6
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_IND_TYPE7
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_IND_TYPE8
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_IND_TYPE9
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO1
|
This is a generic text fields for whatever extra application information is needed.
|
VARCHAR2(60)
|
NA
|
NA
|
|
APPLICATION_INFO10
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO11
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO12
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO13
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO14
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO15
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO16
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO17
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO18
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO19
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO2
|
This is a generic text fields for whatever extra application information is needed.
|
VARCHAR2(60)
|
NA
|
NA
|
|
APPLICATION_INFO20
|
|
VARCHAR2(60)
|
|
|
|
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_INFO6
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO7
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO8
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO9
|
|
VARCHAR2(60)
|
|
|
|
APPLICATION_INFO_TYPE1
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE10
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE11
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE12
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE13
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE14
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE15
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE16
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE17
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE18
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE19
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE2
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE20
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE3
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE4
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE5
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE6
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE7
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE8
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_INFO_TYPE9
|
|
VARCHAR2(20)
|
|
|
|
APPLICATION_NUMBER
|
Application number for the admission application record for a specific academic period.
|
NUMBER
|
SARADAP
|
SARADAP_APPL_NO
|
|
APPLICATION_RANKING_ORDER
|
Number dictating the hierarchical order preference among submitted applications.
|
NUMBER
|
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
|
|
APPL_FEE_WAIVER_REASON
|
|
VARCHAR2(4)
|
|
|
|
APPL_FEE_WAIVER_REASON_DESC
|
|
VARCHAR2(30)
|
|
|
|
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 is attending if the withdrawal was to attend a different 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
|
SARADAP
|
SARADAP_PIDM
|
|
POST_CODE_ADMIT
|
Postcode or postal code associated with the person at time of admission.
|
VARCHAR2(10)
|
NA
|
NA
|
|
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
|
|
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
|
Residency code for the student identifying the type of charges the student will incur.
|
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
|
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
|
|
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
|
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
|
|
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
|