| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
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
|
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
|
Administrative-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
|
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
|
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_ADD_DATE
|
|
This field specifies the application add date.
|
DATE
|
SABSUPL
|
SABSUPL_ACTIVITY_DATE
|
|
APPLICATION_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
|
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_DATE
|
|
This field specifies the Date of Insert.
|
DATE
|
SARHEAD
|
SARHEAD_ADD_DATE
|
|
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_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
|
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
|
|
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
|
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
|
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
|
Award category description.
|
VARCHAR2(255)
|
STVACAT
|
STVACAT_DESC
|
|
CAMPUS
|
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
|
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
|
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 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
|
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 Description
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
|
DEPARTMENT
|
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 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 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
|
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
|
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
|
Incomplete Indicator
|
Indicates whether the application is incomplete.
|
VARCHAR2(1)
|
FUNCTION
|
F_ADMS_APPLICATION_STATUS
|
|
INSTITUTION_ATTENDING
|
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
|
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
|
Major subject area of the person's academic study.
|
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_STATUS_IND
|
|
This field denotes Completion of Person Verification Requirements.
|
VARCHAR2(1)
|
SARHEAD
|
SARHEAD_PERS_STATUS_IND
|
|
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
|
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
|
Primary Source Description
|
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 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
|
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
|
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
|
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
|
Residency code for the student identifying the type of charges the student will incur.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_RESD_CODE
|
|
RESIDENCY_DESC
|
Residency Description
|
Residency code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
RESIDENCY_IND
|
Residency Indicator
|
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
|
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
|
Major subject area of the person's academic study.
|
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
|
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
|
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
|
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 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
|
|
TERM_CODE_ENTRY
|
|
This field specifies the Application Term Code.
|
VARCHAR2(63)
|
SARHEAD
|
SARHEAD_TERM_CODE_ENTRY
|
|
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
|
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
|
Withdrawal Reason Description
|
Reason for withdrawal description.
|
VARCHAR2(255)
|
STVWRSN
|
STVWRSN_DESC
|