Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ADMISSIONS_APPLICATION

Description Contains data specific to an application to study at the institution submitted by the person. Multiple academic years and or academic periods are available for comparison reporting.
Key & Frequency One row per person per academic period per application number per curriculum.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER
ACADEMIC_PERIOD, PERSON_UID
ACADEMIC_PERIOD, STUDENT_LEVEL, PROGRAM

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD 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 Academic period description. VARCHAR2(255)  

STVTERM

STVTERM_DESC

ACADEMIC_YEAR 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 Academic year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ADMINISTATOR_COUNT 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 Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

ADMISSIONS_POPULATION 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 Admissions Population Description Admission population description. VARCHAR2(255)  

STVADMT

STVADMT_DESC

AID_YEAR Financial 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 Applicant Declined Indicator Indicates the applicant has declined this institution offer of admission. VARCHAR2(1)  

NA

NA

APPLICANT_WITHDRAWN_IND Applicant Withdrawn Indicator 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 Date Application submission date. DATE  

SARADAP

SARADAP_APPL_DATE

APPLICATION_FEE_RECEIVED_DATE Application Fee Received Date Date application fee has been assessed. DATE  

SARADAP

SARADAP_FEE_DATE

APPLICATION_FEE_REQUIRED_IND Application Fee Required Indicator Inidicates whether an application fee has been assessed. VARCHAR2(1)  

CALCULATION

NVL(SARADAP_FEE_IND,'N')

APPLICATION_IND1 Application Indicator 1 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG1

APPLICATION_IND10 Application Indicator 10 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG10

APPLICATION_IND2 Application Indicator 2 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG2

APPLICATION_IND3 Application Indicator 3 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG3

APPLICATION_IND4 Application Indicator 4 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG4

APPLICATION_IND5 Application Indicator 5 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG5

APPLICATION_IND6 Application Indicator 6 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG6

APPLICATION_IND7 Application Indicator 7 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG7

APPLICATION_IND8 Application Indicator 8 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG8

APPLICATION_IND9 Application Indicator 9 Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF). VARCHAR2(1)  

SABSUPL

SABSUPL_FLAG9

APPLICATION_IND_TYPE1 Application Indicator Type 1 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG1_DESC

APPLICATION_IND_TYPE10 Application Indicator Type 10 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG10_DESC

APPLICATION_IND_TYPE2 Application Indicator Type 2 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG2_DESC

APPLICATION_IND_TYPE3 Application Indicator Type 3 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG3_DESC

APPLICATION_IND_TYPE4 Application Indicator Type 4 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG4_DESC

APPLICATION_IND_TYPE5 Application Indicator Type 5 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG5_DESC

APPLICATION_IND_TYPE6 Application Indicator Type 6 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG6_DESC

APPLICATION_IND_TYPE7 Application Indicator Type 7 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG7_DESC

APPLICATION_IND_TYPE8 Application Indicator Type 8 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG8_DESC

APPLICATION_IND_TYPE9 Application Indicator Type 9 User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_FLAG9_DESC

APPLICATION_INFO1 Application Information 1 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA1

APPLICATION_INFO10 Application Information 10 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA10

APPLICATION_INFO11 Application Information 11 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA11

APPLICATION_INFO12 Application Information 12 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA12

APPLICATION_INFO13 Application Information 13 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA13

APPLICATION_INFO14 Application Information 14 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA14

APPLICATION_INFO15 Application Information 15 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA15

APPLICATION_INFO16 Application Information 16 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA16

APPLICATION_INFO17 Application Information 17 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA17

APPLICATION_INFO18 Application Information 18 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA18

APPLICATION_INFO19 Application Information 19 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA19

APPLICATION_INFO2 Application Information 2 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA2

APPLICATION_INFO20 Application Information 20 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA20

APPLICATION_INFO3 Application Information 3 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA3

APPLICATION_INFO4 Application Information 4 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA4

APPLICATION_INFO5 Application Information 5 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA5

APPLICATION_INFO6 Application Information 6 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA6

APPLICATION_INFO7 Application Information 7 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA7

APPLICATION_INFO8 Application Information 8 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA8

APPLICATION_INFO9 Application Information 9 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)  

SABSUPL

SABSUPL_INST_DATA9

APPLICATION_INFO_TYPE1 Application Information Type 1 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA1_DESC

APPLICATION_INFO_TYPE10 Application Information Type 10 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA10_DESC

APPLICATION_INFO_TYPE11 Application Information Type 11 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA11_DESC

APPLICATION_INFO_TYPE12 Application Information Type 12 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA12_DESC

APPLICATION_INFO_TYPE13 Application Information Type 13 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA13_DESC

APPLICATION_INFO_TYPE14 Application Information Type 14 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA14_DESC

APPLICATION_INFO_TYPE15 Application Information Type 15 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA15_DESC

APPLICATION_INFO_TYPE16 Application Information Type 16 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA16_DESC

APPLICATION_INFO_TYPE17 Application Information Type 17 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA17_DESC

APPLICATION_INFO_TYPE18 Application Information Type 18 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA18_DESC

APPLICATION_INFO_TYPE19 Application Information Type 19 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA19_DESC

APPLICATION_INFO_TYPE2 Application Information Type 2 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA2_DESC

APPLICATION_INFO_TYPE20 Application Information Type 20 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA20_DESC

APPLICATION_INFO_TYPE3 Application Information Type 3 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA3_DESC

APPLICATION_INFO_TYPE4 Application Information Type 4 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA4_DESC

APPLICATION_INFO_TYPE5 Application Information Type 5 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA5_DESC

APPLICATION_INFO_TYPE6 Application Information Type 6 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA6_DESC

APPLICATION_INFO_TYPE7 Application Information Type 7 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA7_DESC

APPLICATION_INFO_TYPE8 Application Information Type 8 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA8_DESC

APPLICATION_INFO_TYPE9 Application Information Type 9 User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL). VARCHAR2(63)  

SABAUDF

SABAUDF_DATA9_DESC

APPLICATION_NUMBER Application Number Application number for the admission application record for a specific academic period. NUMBER  

SARADAP

SARADAP_APPL_NO

APPLICATION_RANKING_ORDER 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 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 Application Status Date Date associated with the most current status of the application. DATE  

SARADAP

SARADAP_APST_DATE

APPLICATION_STATUS_DESC Application Status Description Application status description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

APPL_ACCEPT_ANY_TIME_IND Applicant Accept Any Time Indicator Indicates the applicant accepted the institution's offer of admission for this application, regardless of any subsequent action by the applicant that may decline the offer of admission. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

APPL_ACCEPT_CURRENT_IND Applicant Accept Current Indicator Indicates the institution's most recent admission decision to offer admission to the applicant into this program has been accepted by the applicaant. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

APPL_FEE_WAIVER_REASON Application Fee Waiver Reason Application fee waiver reason. VARCHAR2(63)  

SARADAP

SARADAP_WAIV_CODE

APPL_FEE_WAIVER_REASON_DESC Application Fee Waiver Reason Description Application fee waiver reason description. VARCHAR2(255)  

STVWAIV

STVWAIV_DESC

ATTRIBUTE_COUNT Attribute Count Count of student attributes recorded for this admission applicant. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_ADMISSIONS_ATTRIBUTE

AWARD_CATEGORY 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 Award category description. VARCHAR2(255)  

STVACAT

STVACAT_DESC

CAMPUS Campus Campus to which applicant is applying. VARCHAR2(63)  

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_DESC Campus Description Institution campus name. VARCHAR2(255)  

STVCAMP

STVCAMP_DESC

CITY_BIRTH_APPL City Birth Appl Applicant's city of birth as reported on the admissions application. VARCHAR2(63)  

SABSUPL

SABSUPL_CITY_BIRTH

COHORT_COUNT Cohort Count Count of all the current active admission cohort codes recorded for the person. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_ADMISSIONS_COHORT

COLLEGE College College, faculty or school to which the academic study for the student is associated. VARCHAR2(63)  

SORLCUR

SORLCUR_COLL_CODE

COLLEGE_DESC College Description College, faculty or school name. VARCHAR2(255)  

STVCOLL

STVCOLL_DESC

COMPLETE_IND Complete Indicator Indicates if the admissions application is complete and ready for review. VARCHAR2(1)  

FUNCTION

F_ADMS_APPLICATION_STATUS

CONFIRMED_IND Confirmed Indicator Indicates the application has been accepted by both the student and the institution. VARCHAR2(255)  

NA

NA

COUNTY_ADMIT County Admitted 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 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 Description Admit County associated with the county code at the time of admission. VARCHAR2(255)  

STVCNTY

STVCNTY_DESC

COUNTY_DESC_BIRTH_APPL County Description Birth Appl County associated with the county code at the time of birth. VARCHAR2(255)  

STVCNTY

STVCNTY_DESC

CURRICULUM_ORDER Curriculum Order Unique sequence number that identifies this academic study or program for the student. NUMBER  

CALCULATION

ROW_NUMBER

CURRICULUM_PRIORITY_NUMBER Curriculum Priority Number Unique sequence number that identifies this academic study or program for the student. NUMBER  

SORLCUR

SORLCUR_PRIORITY_NO

DECISION_COUNT 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 Deferred Indicator 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 Degree or award code associated with the academic study. VARCHAR2(63)  

SORLCUR

SORLCUR_DEGC_CODE

DEGREE_DESC Degree Description Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)  

STVDEGC

STVDEGC_DESC

DEPARTMENT Department Department associated with the academic study on the admission application. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department Description Department name. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

EDUCATION_GOAL Education Goal Applicant's educational goal at the time of application. VARCHAR2(63)  

SARADAP

SARADAP_EGOL_CODE

EDUCATION_GOAL_DESC Education Goal Description Educational goal description. VARCHAR2(255)  

STVEGOL

STVEGOL_DESC

EDUCATION_LEVEL Education Level Highest level of education completed by the applicant. VARCHAR2(63)  

SARADAP

SARADAP_EDLV_CODE

EDUCATION_LEVEL_DESC Education Level Description Description of the applicant's current education level. VARCHAR2(255)  

STVEDLV

STVEDLV_DESC

ENROLLED_IND Enrolled Indicator Indicates whether the student's enrollment status includes them in headcounts. VARCHAR2(1)  

FUNCTION

MSKFUNC.F_ENROLLED_IND

FINAID_APPLICANT_IND Financial Aid Applicant Indicator 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 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 First Concentration Description Concentration or study emphasis description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FIRST_MINOR First Minor Minor subject area of the person's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

FIRST_MINOR_DESC First Minor Description Minor subject area description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_DEPARTMENT Fourth Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

FOURTH_DEPARTMENT_DESC Fourth Department Description Department name. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

FOURTH_MAJOR 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 Fourth Major Concentration 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 Fourth Major Concentration 1 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_MAJOR_CONC_2 Fourth Major Concentration 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 Fourth Major Concentration 2 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_MAJOR_CONC_3 Fourth Major Concentration 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 Fourth Major Concentration 3 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_MAJOR_DESC Fourth Major Description Major or subject area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_MINOR 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 Fourth Minor Description Minor area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

FOURTH_PROGRAM_CLASSIFICATION 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 Fourth Program Classification Description Program classification code description. VARCHAR2(255)  

STVCIPC

STVCIPC_DESC

ID ID Person's identification number used to access the records associated with the person. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INCOMPLETE_IND Incomplete Indicator Indicates whether the application is incomplete. VARCHAR2(1)  

FUNCTION

F_ADMS_APPLICATION_STATUS

INSTITUTION_ATTENDING Institution Attending Institution the student decided to attend rather than the home institution. VARCHAR2(63)  

SARADAP

SARADAP_SBGI_CODE

INSTITUTION_ATTENDING_DESC Institution Attending Description Source/background institution name. VARCHAR2(255)  

STVSBGI

STVSBGI_DESC

INST_ACCEPTED_CURRENT_IND Institution Accepted Current Indicator Indicates the institution's most recent admission decision is to offer admission or accept the applicant into this program. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

INST_ADMIT_ANY_TIME_IND Institution Admitted Any Time Indicator Indicates the applicant was offered admission or accepted by the institution for this application, regardless of any subsequent admissions decision that may have revoked that offer. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

INST_DENIED_IND Institution Denied Indicator Indicates the institution has denied the applicant admission under this application. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

INTENDED_TIME_STATUS Intended Time Status Indicates whether the applicant intends full or part time enrollment. VARCHAR2(1)  

SARADAP

SARADAP_FULL_PART_IND

LATEST_DECISION Latest Decision Most recent application decision value associated with the application. VARCHAR2(63)  

FUNCTION

SOKODSF.F_SARAPPD_INFO

LATEST_DECISION_DATE Latest Decision Date Date most recent application decision was effective. DATE  

FUNCTION

SOKODSF.F_SARAPPD_INFO

LATEST_DECISION_DESC Latest Decision Description Application decision (for example, applicant accepted, pending decision, quick admit) associated with the most recent decision code. VARCHAR2(255)  

STVAPDC

STVAPDC_DESC

MAILING_COUNT Mailing Count Count of mailings of materials or letters to the admission applicant. NUMBER  

FUNCTION

MGKFUNC.F_COUNT_MAILING

MAJOR Major First major to which applicant is applying. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_DESC Major Description Name of the student's major subject area. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

NAME Name Name of the person (last name, first name middle initial). VARCHAR2(255)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NATION_ADMIT Nation Admitted 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 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 Birth Description 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 Description Admit Nation/country associated with the nation code at the time of admission. VARCHAR2(255)  

STVNATN

STVNATN_NATION

NON_TRADITIONAL_IND Non Traditional Indicator 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 Person UID System generated, unique, internal identification number assigned to this person. NUMBER  

SARADAP

SARADAP_PIDM

POST_CODE_ADMIT Post Code Admitted 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 First Name Primary advisor current first name. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PRIMARY_ADVISOR_ID Primary Advisor ID Current identification number for the primary advisor. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PRIMARY_ADVISOR_LAST_NAME Primary Advisor Last Name Primary advisor current last name. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PRIMARY_ADVISOR_TYPE Primary Advisor Type Primary advisor current advising assignment type. VARCHAR2(63)  

SGRADVR

SGRADVR_ADVR_CODE

PRIMARY_ADVISOR_TYPE_DESC Primary Advisor Type Description Advisor type description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

PRIMARY_PROGRAM_IND Primary Program Indicator Indicates whether this is the primary program of study. VARCHAR2(255)  

NA

NA

PRIMARY_SOURCE Primary Source Primary source for the application. VARCHAR2(63)  

SARRSRC

SARRSRC_SBGI_CODE

PRIMARY_SOURCE_DESC Primary Source Description Source/background institution name. VARCHAR2(255)  

STVSBGI

STVSBGI_DESC

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

PROGRAM 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 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 Program classification description. VARCHAR2(255)  

STVCIPC

STVCIPC_DESC

PROGRAM_DESC Program Description Program or course of study description. VARCHAR2(255)  

SMRPRLE

SMRPRLE_PROGRAM_DESC

RATE Rate Specific tuition and fee assessment rate assigned to the student. VARCHAR2(63)  

SARADAP

SARADAP_RATE_CODE

RATE_DESC Rate Description Fee assessment rate code description. VARCHAR2(255)  

STVRATE

STVRATE_DESC

RATING_COUNT 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 Recruiter assigned to the person's admission application record. VARCHAR2(63)  

SARADAP

SARADAP_RECR_CODE

RECRUITER_DESC Recruiter Description Assigned recruiter's name. VARCHAR2(255)  

STVRECR

STVRECR_DESC

RECRUIT_TYPE Recruit Type Identifies the type of recruit used to classify this prospect. VARCHAR2(63)  

SARADAP

SARADAP_RTYP_CODE

RECRUIT_TYPE_DESC Recruit Type Description Recruit type description. VARCHAR2(255)  

STVRTYP

STVRTYP_DESC

REQUIRED_INTERVIEW_STATUS 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 Required Interview Status Description Description of the required interview status. VARCHAR2(255)  

STVINTV

STVINTV_DESC

REQUIREMENT_COUNT 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 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 Description Residency code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

RESIDENCY_IND Residency Indicator 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 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 Second Concentration Description Concentration or study emphasis description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_DEPARTMENT Second Department Department responsible for the second major or subject area of academic instruction. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Second Department Description Department name. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

SECOND_MAJOR 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 Second Major Concentration 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 Second Major Concentration 1 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_2 Second Major Concentration 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 Second Major Concentration 2 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_3 Second Major Concentration 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 Second Major Concentration 3 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_DESC Second Major Description Major or subject area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_MINOR 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 Second Minor Description Minor area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

SECOND_PROGRAM_CLASSIFICATION 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 Second Program Classif Description Program classification code description. VARCHAR2(255)  

STVCIPC

STVCIPC_DESC

SITE Site Site or location to which applicant is applying. VARCHAR2(63)  

SARADAP

SARADAP_SITE_CODE

SITE_CARRIER_ROUTE Site Carrier Route Carrier route associated with the site address for barcode mailings. VARCHAR2(63)  

NA

NA

SITE_CITY Site City City, town or municipality associated with the site address. VARCHAR2(63)  

STVSITE

STVSITE_CITY

SITE_CORRECTION_DIGIT Site Correction Digit Correction digit associated with the site address for barcode mailings. VARCHAR2(63)  

NA

NA

SITE_COUNTY_CODE Site County Code County associated with the site address. VARCHAR2(63)  

NA

NA

SITE_COUNTY_CODE_DESC Site County Code Description Descriptions of the county associated with the site address. VARCHAR2(255)  

NA

NA

SITE_DELIVERY_POINT Site Delivery Point Delivery point associated with the site address for barcode mailings. VARCHAR2(63)  

NA

NA

SITE_DESC Site Description Site or location name. VARCHAR2(255)  

STVSITE

STVSITE_DESC

SITE_NATION Site Nation Nation/country code associated with the site address. VARCHAR2(63)  

STVSITE

STVSITE_NATION_CODE

SITE_NATION_DESC Site Nation Description Description for the nation/country associated with the site address. VARCHAR2(255)  

STVNATN

STVNATN_NATION

SITE_POSTAL_CODE Site Postal Code Postal code associated with the site address. VARCHAR2(63)  

STVSITE

STVSITE_ZIPC

SITE_STATE_PROVINCE Site State Province Identifies the state or province associated with this address. VARCHAR2(63)  

STVSITE

STVSITE_STATE

SITE_STATE_PROVINCE_DESC Site State Province Description Name of the state/province. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

SITE_STREET_LINE1 Site Street Line 1 First line of the site address. VARCHAR2(255)  

STVSITE

STVSITE_STREET_ADDR1

SITE_STREET_LINE2 Site Street Line 2 Second line of the site address. VARCHAR2(255)  

STVSITE

STVSITE_STREET_ADDR2

SITE_STREET_LINE3 Site Street Line 3 Third line of the site address. VARCHAR2(255)  

STVSITE

STVSITE_STREET_ADDR3

SITE_STREET_LINE4 Site Street Line 4 Fourth line of the site address. VARCHAR2(255)  

NA

NA

SOURCE_COUNT 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 Start Date Non academic period based admissions field. Date studying is to begin. DATE  

SORLCUR

SORLCUR_START_DATE

STATE_ADMIT State Admitted 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 or Province Birth Applicant 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 or Province Description Admitted State/province name. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

STATE_DESC_BIRTH_APPL State Description Birth Appl State/province name. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

STUDENT_LEVEL 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 Student level description. VARCHAR2(255)  

STVLEVL

STVLEVL_DESC

STUDENT_MEETING_TIME 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 Meeting Time Description Student's meeting session description. VARCHAR2(255)  

STVSESS

STVSESS_DESC

STUDENT_POPULATION 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 Description Student population or type description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SUB_ACADEMIC_PERIOD Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)  

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description Sub academic period description. VARCHAR2(255)  

NA

NA

THIRD_CONCENTRATION 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 Third Concentration Description Concentration or study emphasis description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_DEPARTMENT Third Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

THIRD_DEPARTMENT_DESC Third Department Description Department name. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

THIRD_MAJOR 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 Third Major Concentration 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 Third Major Concentration 1 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_MAJOR_CONC_2 Third Major Concentration 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 Third Major Concentration 2 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_MAJOR_CONC_3 Third Major Concentration 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 Third Major Concentration 3 Description Student's concentration description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_MAJOR_DESC Third Major Description Major or subject area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_MINOR 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 Third Minor Description Minor area of study description. VARCHAR2(255)  

STVMAJR

STVMAJR_DESC

THIRD_PROGRAM_CLASSIFICATION 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 Third Program Classification Description Program classification code description. VARCHAR2(255)  

STVCIPC

STVCIPC_DESC

WITHDRAWAL_REASON Withdrawal Reason Reason the applicant withdraws an application or chooses not to attend this institution. VARCHAR2(63)  

SARADAP

SARADAP_WRSN_CODE

WITHDRAWAL_REASON_DESC Withdrawal Reason Description Reason for withdrawal description. VARCHAR2(255)  

STVWRSN

STVWRSN_DESC



Ver: 9.0