RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Student Reporting View Reports

SGHE 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.
Recommended Search Columns ACADEMIC_PERIOD
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 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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

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_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)

NA

SABSUPL

NA

SABSUPL_INST_DATA1

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

NA

SABSUPL

NA

SABSUPL_INST_DATA2

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

NA

SABSUPL

NA

SABSUPL_INST_DATA3

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

NA

SABSUPL

NA

SABSUPL_INST_DATA4

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

NA

SABSUPL

NA

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

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

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)

FUNCTION

GOKODSF.F_GET_DESC

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

SARADAP

SORLCUR

SARADAP_CAMP_CODE

SORLCUR_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

SARADAP

SORLCUR

SARADAP_COLL_CODE_1

SORLCUR_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

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)

SARADAP

SORLCUR

SARADAP_DEGC_CODE_1

SORLCUR_DEGC_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

SARADAP

SORLFOS

SARADAP_DEPT_CODE

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_CONC_1

SORLFOS_MAJR_CODE

FIRST_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SARADAP

SORLFOS

SARADAP_MAJR_CODE_MINR_1_1

SORLFOS_MAJR_CODE

FIRST_MINOR_DESC Minor subject area description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

INST_ACCEPTED_CURRENT_IND Indicates that the applicant's most recent admission decision is accepted by the institution. VARCHAR2(1)

FUNCTION

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

F_ADMS_CHECK_STATUS

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

FUNCTION

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

F_CONCAT_SARAPPD

LATEST_DECISION_DATE Date most recent application decision was effective. DATE

FUNCTION

F_CONCAT_SARAPPD

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

FUNCTION

GOKODSF.F_GET_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)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_1

SORLFOS_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_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(94)

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)

FUNCTION

GOKODSF.F_GET_DESC

NATION_DESC_ADMIT Nation/country associated with the nation code at the time of admission. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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

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)

FUNCTION

GOKODSF.F_GET_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)

SARADAP

SORLCUR

SARADAP_PROGRAM_1

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)

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_CONC_1_2

SORLFOS_MAJR_CODE

SECOND_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SARADAP

SORLFOS

SARADAP_DEPT_CODE_1_2

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_1_2

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)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_CONC_121

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_CONC_122

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_CONC_123

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MINOR Second minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_MINR_1_2

SORLFOS_MAJR_CODE

SECOND_MINOR_DESC Minor area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

GOKODSF.F_GET_DESC

SITE_STREET_LINE1 First line of the site address. VARCHAR2(63)

STVSITE

STVSITE_STREET_ADDR1

SITE_STREET_LINE2 Second line of the site address. VARCHAR2(63)

STVSITE

STVSITE_STREET_ADDR2

SITE_STREET_LINE3 Third line of the site address. VARCHAR2(63)

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)

FUNCTION

GOKODSF.F_GET_DESC

STATE_DESC_BIRTH_APPL State/province name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_CONC_1_3

SORLFOS_MAJR_CODE

THIRD_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 3.1