Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Student Reporting View Reports

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
PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER
ACADEMIC_PERIOD, PERSON_UID
ACADEMIC_PERIOD, STUDENT_LEVEL, PROGRAM

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(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 Administrative-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 Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)

STVTERM

STVTERM_FA_PROC_YR

APPLICANT_DECLINED_IND Indicates the applicant has declined this institution offer of admission. VARCHAR2(1)

NA

NA

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_ADD_DATE This field specifies the application add date. DATE

SABSUPL

SABSUPL_ACTIVITY_DATE

APPLICATION_DATE Application submission date. DATE

SARADAP

SARADAP_APPL_DATE

APPLICATION_ESEL_CODE This field specifies the Eligibility Factor Code. VARCHAR2(63)

SABSUPL

SABSUPL_ESEL_CODE

APPLICATION_ESEL_DESC This field specifies the description of Eligibility Factor Code. VARCHAR2(255)

STVESEL

STVESEL_DESC

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_IND1 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)

SABSUPL

SABSUPL_INST_DATA1

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

SABSUPL

SABSUPL_INST_DATA10

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

SABSUPL

SABSUPL_INST_DATA11

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

SABSUPL

SABSUPL_INST_DATA12

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

SABSUPL

SABSUPL_INST_DATA13

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

SABSUPL

SABSUPL_INST_DATA14

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

SABSUPL

SABSUPL_INST_DATA15

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

SABSUPL

SABSUPL_INST_DATA16

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

SABSUPL

SABSUPL_INST_DATA17

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

SABSUPL

SABSUPL_INST_DATA18

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

SABSUPL

SABSUPL_INST_DATA19

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

SABSUPL

SABSUPL_INST_DATA2

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

SABSUPL

SABSUPL_INST_DATA20

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_INFO6 Institution defined information regarding the application. Extra value to capture additional application information as needed. VARCHAR2(255)

SABSUPL

SABSUPL_INST_DATA6

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

SABSUPL

SABSUPL_INST_DATA7

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

SABSUPL

SABSUPL_INST_DATA8

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

SABSUPL

SABSUPL_INST_DATA9

APPLICATION_INFO_DATE This field specifies the Date of Insert. DATE

SARHEAD

SARHEAD_ADD_DATE

APPLICATION_INFO_TYPE1 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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_SOURCE This field specifies Electronic Application Source Code. VARCHAR2(63)

SARHEAD

SARHEAD_APLS_CODE

APPLICATION_SOURCE_DESC This field specifies Electronic Appl Source Description. VARCHAR2(255)

STVAPLS

STVAPLS_DESC

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

APPLICATION_STATUS_IND This field denotes Completion of Application Verification Requirements. VARCHAR2(1)

SARHEAD

SARHEAD_APPL_STATUS_IND

APPLICATION_TYPE This field specifies the Web Application Type. VARCHAR2(63)

SARHEAD

SARHEAD_WAPP_CODE

APPLICATION_TYPE_DESC This field specifies the Web Application Description. VARCHAR2(255)

STVWAPP

STVWAPP_DESC

APPL_ACCEPT_ANY_TIME_IND 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 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. VARCHAR2(63)

SARADAP

SARADAP_WAIV_CODE

APPL_FEE_WAIVER_REASON_DESC Application fee waiver reason description. VARCHAR2(255)

STVWAIV

STVWAIV_DESC

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

FUNCTION

MSKFUNC.F_COUNT_ADMISSIONS_ATTRIBUTE

AWARD_CATEGORY Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc. VARCHAR2(63)

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC Award category description. VARCHAR2(255)

STVACAT

STVACAT_DESC

CAMPUS Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. 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 First level of the institution organization structure that owns the student or the academic instruction for a student course. 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 Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme. 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 responsible for the major subject area of a student course or associated with the major within the student academic study. 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 has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount. 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 Identification number assigned to a person that is used externally for all communication and correspondence 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 is attending if the withdrawal was to attend a different institution. VARCHAR2(63)

SARADAP

SARADAP_SBGI_CODE

INSTITUTION_ATTENDING_DESC Source/background institution name. VARCHAR2(255)

STVSBGI

STVSBGI_DESC

INST_ACCEPTED_CURRENT_IND 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 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 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 Major subject area of the person's academic study. 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_STATUS_IND This field denotes Completion of Person Verification Requirements. VARCHAR2(1)

SARHEAD

SARHEAD_PERS_STATUS_IND

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 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(63)

SARRSRC

SARRSRC_SBGI_CODE

PRIMARY_SOURCE_DESC Source/background institution name. VARCHAR2(255)

STVSBGI

STVSBGI_DESC

PROCESS_DATE This field indicates the Date of Application Processing. DATE

SARHEAD

SARHEAD_PROCESS_DATE

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

NA

NA

PROCESS_IND This field denotes whether Application has been Processed. VARCHAR2(1)

SARHEAD

SARHEAD_PROCESS_IND

PROGRAM Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(63)

SORLCUR

SORLCUR_PROGRAM

PROGRAM_CLASSIFICATION Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. 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 Residency code for the student identifying the type of charges the student will incur. VARCHAR2(63)

SARADAP

SARADAP_RESD_CODE

RESIDENCY_DESC Residency code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

RESIDENCY_IND Identifies whether the student is considered in or out of the district for enrollment charges. Typically this indicates in or out of state or province but may also be in or out of county or in or out of the European Union, 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 Major subject area of the person's academic study. 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 Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, 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 Identifies the category this student that will be used for governmental reporting. The typical VALUES are new first time, 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

TERM_CODE_ENTRY This field specifies the Application Term Code. VARCHAR2(63)

SARHEAD

SARHEAD_TERM_CODE_ENTRY

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 If the student withdraws for the institution this identifies the major reason for the student withdrawal defined by institution values. VARCHAR2(63)

SARADAP

SARADAP_WRSN_CODE

WITHDRAWAL_REASON_DESC Reason for withdrawal description. VARCHAR2(255)

STVWRSN

STVWRSN_DESC



Ver: 9.1