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