| 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(63)
|
SARADAP
|
SARADAP_TERM_CODE_ENTRY
|
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ADMINISTATOR_COUNT
|
Count of people identified as administrators and associated with this student. The administrator may be a formal or informal role required to rate or rank this application.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMINISTRATOR
|
|
ADMINISTRATIVE_GROUP
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
ADMISSIONS_POPULATION
|
Identifies an admission population such as early admit, mature, adult and continuing education, etc., associated with the person and application.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_ADMT_CODE
|
|
ADMISSIONS_POPULATION_DESC
|
Admission population description.
|
VARCHAR2(255)
|
STVADMT
|
STVADMT_DESC
|
|
AID_YEAR
|
Aid year associated with the academic period information for this admission application record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_FA_PROC_YR
|
|
APPLICANT_DECLINED_IND
|
Indicates the applicant has declined this institution offer of admission.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
|
APPLICANT_WITHDRAWN_IND
|
Indicates the applicant has informed the institution they no longer wish to be considered nor attend the institution so they withdraw their application.
|
VARCHAR2(1)
|
FUNCTION
|
F_ADMS_APPLICANT_WITHDRAWN
|
|
APPLICATION_DATE
|
Application submission date.
|
DATE
|
SARADAP
|
SARADAP_APPL_DATE
|
|
APPLICATION_FEE_RECEIVED_DATE
|
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
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA1
|
|
APPLICATION_INFO2
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA2
|
|
APPLICATION_INFO3
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA3
|
|
APPLICATION_INFO4
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA4
|
|
APPLICATION_INFO5
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA5
|
|
APPLICATION_NUMBER
|
Application number for the admission application record for a specific academic period.
|
NUMBER
|
SARADAP
|
SARADAP_APPL_NO
|
|
APPLICATION_RANKING_ORDER
|
Identifies the applicant's hierarchical preference among for the applications they submitted for this academic period.
|
NUMBER
|
SARADAP
|
SARADAP_APPL_PREFERENCE
|
|
APPLICATION_STATUS
|
Most current status of the application, whether the status is determined by institution or student.
|
VARCHAR2(63)
|
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(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
APPL_ACCEPT_ANY_TIME_IND
|
Indicates whether the applicant has ever accepted the offer of admission to the institution regardless of the current admission decision.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
|
APPL_ACCEPT_CURRENT_IND
|
Indicates the applicant's most recent decision is to accept the institution's offer of admission.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
|
ATTRIBUTE_COUNT
|
Count of student attributes recorded for this admission applicant.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMISSIONS_ATTRIBUTE
|
|
AWARD_CATEGORY
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
|
AWARD_CATEGORY_DESC
|
Award category description.
|
VARCHAR2(255)
|
STVACAT
|
STVACAT_DESC
|
|
CAMPUS
|
Campus to which applicant is applying.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_CAMP_CODE
|
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
|
CITY_BIRTH_APPL
|
Applicant's city of birth as reported on the admissions application.
|
VARCHAR2(63)
|
SABSUPL
|
SABSUPL_CITY_BIRTH
|
|
COHORT_COUNT
|
Count of all the current active admission cohort codes recorded for the person.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMISSIONS_COHORT
|
|
COLLEGE
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_COLL_CODE
|
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
|
COMPLETE_IND
|
Indicates if the admissions application is complete and ready for review.
|
VARCHAR2(1)
|
FUNCTION
|
F_ADMS_APPLICATION_STATUS
|
|
CONFIRMED_IND
|
Indicates the application has been accepted by both the student and the institution.
|
VARCHAR2(255)
|
NA
|
NA
|
|
COUNTY_ADMIT
|
Identifies the county 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(63)
|
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(63)
|
SABSUPL
|
SABSUPL_CNTY_CODE_BIRTH
|
|
COUNTY_DESC_ADMIT
|
County associated with the county code at the time of admission.
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
|
COUNTY_DESC_BIRTH_APPL
|
County associated with the county code at the time of birth.
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
|
CURRICULUM_ORDER
|
Unique sequence number that identifies this academic study or program for the student.
|
NUMBER
|
CALCULATION
|
ROW_NUMBER
|
|
CURRICULUM_PRIORITY_NUMBER
|
Unique sequence number that identifies this academic study or program for the student.
|
NUMBER
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
|
DECISION_COUNT
|
Count of the number of decisions recorded for this specific application number in this academic period.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMISSIONS_DECISION
|
|
DEFERRED_IND
|
Indicates the application has been deferred. The applicant who has been offered admission chooses to not attend in this academic period but may attend in a future academic period.
|
VARCHAR2(255)
|
NA
|
NA
|
|
DEGREE
|
Degree or award code associated with the academic study.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_DEGC_CODE
|
|
DEGREE_DESC
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
|
DEPARTMENT
|
Department associated with the academic study on the admission application.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
|
EDUCATION_GOAL
|
Applicant's educational goal at the time of application.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_EGOL_CODE
|
|
EDUCATION_GOAL_DESC
|
Educational goal description.
|
VARCHAR2(255)
|
STVEGOL
|
STVEGOL_DESC
|
|
EDUCATION_LEVEL
|
Highest level of education completed by the applicant.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_EDLV_CODE
|
|
EDUCATION_LEVEL_DESC
|
Description of the applicant's current education level.
|
VARCHAR2(255)
|
STVEDLV
|
STVEDLV_DESC
|
|
ENROLLED_IND
|
Indicates whether the student's enrollment status includes them in headcounts.
|
VARCHAR2(1)
|
FUNCTION
|
MSKFUNC.F_ENROLLED_IND
|
|
FINAID_APPLICANT_IND
|
Indicates if this person is a financial aid applicant for the aid year associated with the admission application academic period.
|
VARCHAR2(1)
|
FUNCTION
|
F_FINAID_APPLICANT_IND
|
|
FIRST_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
FIRST_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
FIRST_MINOR
|
Minor subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
FIRST_MINOR_DESC
|
Minor subject area description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
FOURTH_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
FOURTH_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
|
FOURTH_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
FOURTH_MAJOR_CONC_1
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
FOURTH_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
FOURTH_MAJOR_CONC_2
|
Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
FOURTH_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
FOURTH_MAJOR_CONC_3
|
Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
FOURTH_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
FOURTH_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
FOURTH_MINOR
|
Fourth minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
FOURTH_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
FOURTH_PROGRAM_CLASSIFICATION
|
Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting to the federal government.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
|
FOURTH_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
|
ID
|
Person's identification number used to access the records associated with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
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(63)
|
SARADAP
|
SARADAP_SBGI_CODE
|
|
INSTITUTION_ATTENDING_DESC
|
Source/background institution name.
|
VARCHAR2(255)
|
STVSBGI
|
STVSBGI_DESC
|
|
INST_ACCEPTED_CURRENT_IND
|
Indicates that the applicant's most recent admission decision is 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 and the current admissions decision.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
|
INST_DENIED_IND
|
Indicates the institution has denied the applicant admission under this application.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
|
INTENDED_TIME_STATUS
|
Indicates whether the applicant intends full or part time enrollment.
|
VARCHAR2(1)
|
SARADAP
|
SARADAP_FULL_PART_IND
|
|
LATEST_DECISION
|
Most recent application decision value associated with the application.
|
VARCHAR2(63)
|
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(255)
|
STVAPDC
|
STVAPDC_DESC
|
|
MAILING_COUNT
|
Count of mailings of materials or letters to the admission applicant.
|
NUMBER
|
FUNCTION
|
MGKFUNC.F_COUNT_MAILING
|
|
MAJOR
|
First major to which applicant is applying.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_DESC
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
NAME
|
Name of the person (last name, first name middle initial).
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
NATION_ADMIT
|
Identifies the Nation/country 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(63)
|
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(63)
|
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(255)
|
STVNATN
|
STVNATN_NATION
|
|
NATION_DESC_ADMIT
|
Nation/country associated with the nation code at the time of admission.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
|
NON_TRADITIONAL_IND
|
Indicates whether the application is not for a traditional type of study at the institution such as non-degree granting or accelerated.
|
VARCHAR2(1)
|
NA
|
NA
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SARADAP
|
SARADAP_PIDM
|
|
POST_CODE_ADMIT
|
Identifies the Postal 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(63)
|
NA
|
NA
|
|
PRIMARY_ADVISOR_FIRST_NAME
|
Primary advisor current first name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PRIMARY_ADVISOR_ID
|
Current identification number for the primary advisor.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PRIMARY_ADVISOR_LAST_NAME
|
Primary advisor current last name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PRIMARY_ADVISOR_TYPE
|
Primary advisor current advising assignment type.
|
VARCHAR2(63)
|
SGRADVR
|
SGRADVR_ADVR_CODE
|
|
PRIMARY_ADVISOR_TYPE_DESC
|
Advisor type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PRIMARY_PROGRAM_IND
|
Indicates whether this is the primary program of study.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PRIMARY_SOURCE
|
Primary source for the application.
|
VARCHAR2(63)
|
SARRSRC
|
SARRSRC_SBGI_CODE
|
|
PRIMARY_SOURCE_DESC
|
Source/background institution name.
|
VARCHAR2(255)
|
STVSBGI
|
STVSBGI_DESC
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PROGRAM
|
Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_PROGRAM
|
|
PROGRAM_CLASSIFICATION
|
Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
|
PROGRAM_DESC
|
Program or course of study description.
|
VARCHAR2(255)
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
|
RATE
|
Specific tuition and fee assessment rate assigned to the student.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_RATE_CODE
|
|
RATE_DESC
|
Fee assessment rate code description.
|
VARCHAR2(255)
|
STVRATE
|
STVRATE_DESC
|
|
RATING_COUNT
|
Count of the number of ratings recorded for this admission application regardless of the administer or type of rating recorded.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMISSIONS_RATING
|
|
RECRUITER
|
Recruiter assigned to the person's admission application record.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_RECR_CODE
|
|
RECRUITER_DESC
|
Assigned recruiter's name.
|
VARCHAR2(255)
|
STVRECR
|
STVRECR_DESC
|
|
RECRUIT_TYPE
|
Identifies the type of recruit used to classify this prospect.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_RTYP_CODE
|
|
RECRUIT_TYPE_DESC
|
Recruit type description.
|
VARCHAR2(255)
|
STVRTYP
|
STVRTYP_DESC
|
|
REQUIRED_INTERVIEW_STATUS
|
Identifies the completion status associated with a required interview for an admissions applicant.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_INTV_CODE
|
|
REQUIRED_INTERVIEW_STATUS_DESC
|
Description of the required interview status.
|
VARCHAR2(255)
|
STVINTV
|
STVINTV_DESC
|
|
REQUIREMENT_COUNT
|
Count of the documents or other types of requirements to complete the admission application. This does not consider whether or not the requirement has been completed.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMISSIONS_REQUIREMENT
|
|
RESIDENCY
|
Identifies the residency classification of the applicant and may have been used to determine enrollment charges.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_RESD_CODE
|
|
RESIDENCY_DESC
|
Residency code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
RESIDENCY_IND
|
Indicates whether the residency is in or out area. May represent in or out of state/province, in or out of the EU, etc.
|
VARCHAR2(1)
|
STVRESD
|
STVRESD_IN_STATE_IND
|
|
SECOND_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECOND_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
SECOND_DEPARTMENT
|
Department responsible for the second major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
SECOND_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
|
SECOND_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECOND_MAJOR_CONC_1
|
First concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECOND_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
SECOND_MAJOR_CONC_2
|
Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECOND_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
SECOND_MAJOR_CONC_3
|
Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECOND_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
SECOND_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
SECOND_MINOR
|
Second minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECOND_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
SECOND_PROGRAM_CLASSIFICATION
|
Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting to the federal government.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
|
SECOND_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
|
SITE
|
Site or location to which applicant is applying.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_SITE_CODE
|
|
SITE_CARRIER_ROUTE
|
Carrier route associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
|
SITE_CITY
|
City, town or municipality associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_CITY
|
|
SITE_CORRECTION_DIGIT
|
Correction digit associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
|
SITE_COUNTY_CODE
|
County associated with the site address.
|
VARCHAR2(63)
|
NA
|
NA
|
|
SITE_COUNTY_CODE_DESC
|
Descriptions of the county associated with the site address.
|
VARCHAR2(255)
|
NA
|
NA
|
|
SITE_DELIVERY_POINT
|
Delivery point associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
|
SITE_DESC
|
Site or location name.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_DESC
|
|
SITE_NATION
|
Nation/country code associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_NATION_CODE
|
|
SITE_NATION_DESC
|
Description for the nation/country associated with the site address.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
|
SITE_POSTAL_CODE
|
Postal code associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_ZIPC
|
|
SITE_STATE_PROVINCE
|
Identifies the state or province associated with this address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_STATE
|
|
SITE_STATE_PROVINCE_DESC
|
Name of the state/province.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
|
SITE_STREET_LINE1
|
First line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR1
|
|
SITE_STREET_LINE2
|
Second line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR2
|
|
SITE_STREET_LINE3
|
Third line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR3
|
|
SITE_STREET_LINE4
|
Fourth line of the site address.
|
VARCHAR2(255)
|
NA
|
NA
|
|
SOURCE_COUNT
|
Count of sources recorded for the submission of this application for admission. Included might be secondary school recruiter visit, newspaper advertisement, friend referral, etc.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMISSIONS_SOURCE
|
|
START_DATE
|
Non academic period based admissions field. Date studying is to begin.
|
DATE
|
SORLCUR
|
SORLCUR_START_DATE
|
|
STATE_ADMIT
|
Identifies the State/Province 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(63)
|
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(63)
|
SABSUPL
|
SABSUPL_STAT_CODE_BIRTH
|
|
STATE_DESC_ADMIT
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
|
STATE_DESC_BIRTH_APPL
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
|
STUDENT_LEVEL
|
Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.
|
VARCHAR2(63)
|
SARADAP SORLCUR
|
SARADAP_LEVL_CODE SORLCUR_LEVL_CODE
|
|
STUDENT_LEVEL_DESC
|
Student level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
|
STUDENT_MEETING_TIME
|
Student's normal attendance time. May be either day, evening, weekend, etc.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_SESS_CODE
|
|
STUDENT_MEETING_TIME_DESC
|
Student's meeting session description.
|
VARCHAR2(255)
|
STVSESS
|
STVSESS_DESC
|
|
STUDENT_POPULATION
|
Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_STYP_CODE
|
|
STUDENT_POPULATION_DESC
|
Student population or type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|
|
THIRD_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
THIRD_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
THIRD_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
THIRD_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
|
THIRD_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
THIRD_MAJOR_CONC_1
|
First concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
THIRD_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
THIRD_MAJOR_CONC_2
|
Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
THIRD_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
THIRD_MAJOR_CONC_3
|
Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
THIRD_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
THIRD_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
THIRD_MINOR
|
Third minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
THIRD_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
THIRD_PROGRAM_CLASSIFICATION
|
Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting to the federal government.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
|
THIRD_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
|
WITHDRAWAL_REASON
|
Reason the applicant withdraws an application or chooses not to attend this institution.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_WRSN_CODE
|
|
WITHDRAWAL_REASON_DESC
|
Reason for withdrawal description.
|
VARCHAR2(255)
|
STVWRSN
|
STVWRSN_DESC
|