Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
ADMISSIONS_POPULATION_DESC
|
Admission population description.
|
VARCHAR2(255)
|
STVADMT
|
STVADMT_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
APPLICANT_DECLINED_IND
|
Indicates the applicant has declined this institution offer of admission.
|
VARCHAR2(1)
|
NA
|
NA
|
NO
|
NO
|
APPLICANT_WITHDRAWN_IND
|
Indicates the applicant has informed the institution they no longer wish to be considered nor attend the institution so they withdraw their application.
|
VARCHAR2(1)
|
FUNCTION
|
F_ADMS_APPLICANT_WITHDRAWN
|
NO
|
NO
|
APPLICATION_ADD_DATE
|
This field specifies the application add date.
|
DATE
|
SABSUPL
|
SABSUPL_ACTIVITY_DATE
|
NO
|
NO
|
APPLICATION_DATE
|
Application submission date.
|
DATE
|
SARADAP
|
SARADAP_APPL_DATE
|
NO
|
NO
|
APPLICATION_ESEL_CODE
|
This field specifies the Eligibility Factor Code.
|
VARCHAR2(63)
|
SABSUPL
|
SABSUPL_ESEL_CODE
|
NO
|
NO
|
APPLICATION_ESEL_DESC
|
This field specifies the description of Eligibility Factor Code.
|
VARCHAR2(255)
|
STVESEL
|
STVESEL_DESC
|
NO
|
NO
|
APPLICATION_FEE_RECEIVED_DATE
|
Date application fee has been assessed.
|
DATE
|
SARADAP
|
SARADAP_FEE_DATE
|
NO
|
NO
|
APPLICATION_FEE_REQUIRED_IND
|
Inidicates whether an application fee has been assessed.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(SARADAP_FEE_IND,'N')
|
NO
|
NO
|
APPLICATION_IND1
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG1
|
NO
|
NO
|
APPLICATION_IND10
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG10
|
NO
|
NO
|
APPLICATION_IND2
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG2
|
NO
|
NO
|
APPLICATION_IND3
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG3
|
NO
|
NO
|
APPLICATION_IND4
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG4
|
NO
|
NO
|
APPLICATION_IND5
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG5
|
NO
|
NO
|
APPLICATION_IND6
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG6
|
NO
|
NO
|
APPLICATION_IND7
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG7
|
NO
|
NO
|
APPLICATION_IND8
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG8
|
NO
|
NO
|
APPLICATION_IND9
|
Indicates whether user-defined flags are relevant for this application. User-defined flags that display on the Application Supplemental Information Form (SOASUPL) are set up on the Application User-defined Flags/Fields Form (SAAAUDF).
|
VARCHAR2(1)
|
SABSUPL
|
SABSUPL_FLAG9
|
NO
|
NO
|
APPLICATION_IND_TYPE1
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG1_DESC
|
NO
|
NO
|
APPLICATION_IND_TYPE10
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG10_DESC
|
NO
|
NO
|
APPLICATION_IND_TYPE2
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG2_DESC
|
NO
|
NO
|
APPLICATION_IND_TYPE3
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG3_DESC
|
NO
|
NO
|
APPLICATION_IND_TYPE4
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG4_DESC
|
NO
|
NO
|
APPLICATION_IND_TYPE5
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG5_DESC
|
NO
|
NO
|
APPLICATION_IND_TYPE6
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG6_DESC
|
NO
|
NO
|
APPLICATION_IND_TYPE7
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG7_DESC
|
NO
|
NO
|
APPLICATION_IND_TYPE8
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG8_DESC
|
NO
|
NO
|
APPLICATION_IND_TYPE9
|
User-defined indicator type that are set up on the Application User-defined Flags/Fields Form ( SAAAUDF) for use in the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_FLAG9_DESC
|
NO
|
NO
|
APPLICATION_INFO1
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA1
|
NO
|
NO
|
APPLICATION_INFO10
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA10
|
NO
|
NO
|
APPLICATION_INFO11
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA11
|
NO
|
NO
|
APPLICATION_INFO12
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA12
|
NO
|
NO
|
APPLICATION_INFO13
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA13
|
NO
|
NO
|
APPLICATION_INFO14
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA14
|
NO
|
NO
|
APPLICATION_INFO15
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA15
|
NO
|
NO
|
APPLICATION_INFO16
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA16
|
NO
|
NO
|
APPLICATION_INFO17
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA17
|
NO
|
NO
|
APPLICATION_INFO18
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA18
|
NO
|
NO
|
APPLICATION_INFO19
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA19
|
NO
|
NO
|
APPLICATION_INFO2
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA2
|
NO
|
NO
|
APPLICATION_INFO20
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA20
|
NO
|
NO
|
APPLICATION_INFO3
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA3
|
NO
|
NO
|
APPLICATION_INFO4
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA4
|
NO
|
NO
|
APPLICATION_INFO5
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA5
|
NO
|
NO
|
APPLICATION_INFO6
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA6
|
NO
|
NO
|
APPLICATION_INFO7
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA7
|
NO
|
NO
|
APPLICATION_INFO8
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA8
|
NO
|
NO
|
APPLICATION_INFO9
|
Institution defined information regarding the application. Extra value to capture additional application information as needed.
|
VARCHAR2(255)
|
SABSUPL
|
SABSUPL_INST_DATA9
|
NO
|
NO
|
APPLICATION_INFO_DATE
|
This field specifies the Date of Insert.
|
DATE
|
SARHEAD
|
SARHEAD_ADD_DATE
|
NO
|
NO
|
APPLICATION_INFO_TYPE1
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA1_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE10
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA10_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE11
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA11_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE12
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA12_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE13
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA13_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE14
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA14_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE15
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA15_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE16
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA16_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE17
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA17_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE18
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA18_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE19
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA19_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE2
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA2_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE20
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA20_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE3
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA3_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE4
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA4_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE5
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA5_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE6
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA6_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE7
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA7_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE8
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA8_DESC
|
NO
|
NO
|
APPLICATION_INFO_TYPE9
|
User defined data label on the Application User-defined Flags/Field Form ( SAAAUDF) and displayed on the Application Supplemental Information Form (SOASUPL).
|
VARCHAR2(63)
|
SABAUDF
|
SABAUDF_DATA9_DESC
|
NO
|
NO
|
APPLICATION_NUMBER
|
Application number for the admission application record for a specific academic period.
|
NUMBER
|
SARADAP
|
SARADAP_APPL_NO
|
NO
|
NO
|
APPLICATION_RANKING_ORDER
|
Identifies the applicant's hierarchical preference among for the applications they submitted for this academic period.
|
NUMBER
|
SARADAP
|
SARADAP_APPL_PREFERENCE
|
NO
|
NO
|
APPLICATION_SOURCE
|
This field specifies Electronic Application Source Code.
|
VARCHAR2(63)
|
SARHEAD
|
SARHEAD_APLS_CODE
|
NO
|
NO
|
APPLICATION_SOURCE_DESC
|
This field specifies Electronic Appl Source Description.
|
VARCHAR2(255)
|
STVAPLS
|
STVAPLS_DESC
|
NO
|
NO
|
APPLICATION_STATUS
|
Most current status of the application, whether the status is determined by institution or student.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_APST_CODE
|
NO
|
NO
|
APPLICATION_STATUS_DATE
|
Date associated with the most current status of the application.
|
DATE
|
SARADAP
|
SARADAP_APST_DATE
|
NO
|
NO
|
APPLICATION_STATUS_DESC
|
Application status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
APPLICATION_STATUS_IND
|
This field denotes Completion of Application Verification Requirements.
|
VARCHAR2(1)
|
SARHEAD
|
SARHEAD_APPL_STATUS_IND
|
NO
|
NO
|
APPLICATION_TYPE
|
This field specifies the Web Application Type.
|
VARCHAR2(63)
|
SARHEAD
|
SARHEAD_WAPP_CODE
|
NO
|
NO
|
APPLICATION_TYPE_DESC
|
This field specifies the Web Application Description.
|
VARCHAR2(255)
|
STVWAPP
|
STVWAPP_DESC
|
NO
|
NO
|
APPL_ACCEPT_ANY_TIME_IND
|
Indicates the applicant accepted the institution's offer of admission for this application, regardless of any subsequent action by the applicant that may decline the offer of admission.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
NO
|
NO
|
APPL_ACCEPT_CURRENT_IND
|
Indicates the institution's most recent admission decision to offer admission to the applicant into this program has been accepted by the applicaant.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
NO
|
NO
|
APPL_FEE_WAIVER_REASON
|
Application fee waiver reason.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_WAIV_CODE
|
NO
|
NO
|
APPL_FEE_WAIVER_REASON_DESC
|
Application fee waiver reason description.
|
VARCHAR2(255)
|
STVWAIV
|
STVWAIV_DESC
|
NO
|
NO
|
ATTRIBUTE_COUNT
|
Count of student attributes recorded for this admission applicant.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMISSIONS_ATTRIBUTE
|
NO
|
NO
|
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
|
NO
|
NO
|
AWARD_CATEGORY_DESC
|
Award category description.
|
VARCHAR2(255)
|
STVACAT
|
STVACAT_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
NO
|
NO
|
CITY_BIRTH_APPL
|
Applicant's city of birth as reported on the admissions application.
|
VARCHAR2(63)
|
SABSUPL
|
SABSUPL_CITY_BIRTH
|
NO
|
NO
|
COHORT_COUNT
|
Count of all the current active admission cohort codes recorded for the person.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMISSIONS_COHORT
|
NO
|
NO
|
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
|
NO
|
NO
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
NO
|
NO
|
COMPLETE_IND
|
Indicates if the admissions application is complete and ready for review.
|
VARCHAR2(1)
|
FUNCTION
|
F_ADMS_APPLICATION_STATUS
|
NO
|
NO
|
CONFIRMED_IND
|
Indicates the application has been accepted by both the student and the institution.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
COUNTY_ADMIT
|
Identifies the county of the student when they were admitted. The value is either stored in the administrative system or determined via a rule to look at a specific address and take the value.
|
VARCHAR2(63)
|
SABSUPL
|
SABSUPL_CNTY_CODE_ADMIT
|
NO
|
NO
|
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
|
NO
|
NO
|
COUNTY_DESC_ADMIT
|
County associated with the county code at the time of admission.
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
NO
|
NO
|
COUNTY_DESC_BIRTH_APPL
|
County associated with the county code at the time of birth.
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
NO
|
NO
|
CURRICULUM_ORDER
|
Unique sequence number that identifies this academic study or program for the student.
|
NUMBER
|
CALCULATION
|
ROW_NUMBER
|
NO
|
NO
|
CURRICULUM_PRIORITY_NUMBER
|
Unique sequence number that identifies this academic study or program for the student.
|
NUMBER
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
NO
|
NO
|
DECISION_COUNT
|
Count of the number of decisions recorded for this specific application number in this academic period.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADMISSIONS_DECISION
|
NO
|
NO
|
DEFERRED_IND
|
Indicates the application has been deferred. The applicant who has been offered admission chooses to not attend in this academic period but may attend in a future academic period.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
DEGREE_DESC
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
EDUCATION_GOAL
|
Applicant's educational goal at the time of application.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_EGOL_CODE
|
NO
|
NO
|
EDUCATION_GOAL_DESC
|
Educational goal description.
|
VARCHAR2(255)
|
STVEGOL
|
STVEGOL_DESC
|
NO
|
NO
|
EDUCATION_LEVEL
|
Highest level of education completed by the applicant.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_EDLV_CODE
|
NO
|
NO
|
EDUCATION_LEVEL_DESC
|
Description of the applicant's current education level.
|
VARCHAR2(255)
|
STVEDLV
|
STVEDLV_DESC
|
NO
|
NO
|
ENROLLED_IND
|
Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount.
|
VARCHAR2(1)
|
FUNCTION
|
MSKFUNC.F_ENROLLED_IND
|
NO
|
NO
|
FINAID_APPLICANT_IND
|
Indicates if this person is a financial aid applicant for the aid year associated with the admission application academic period.
|
VARCHAR2(1)
|
FUNCTION
|
F_FINAID_APPLICANT_IND
|
NO
|
NO
|
FIRST_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FIRST_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FIRST_MINOR
|
Minor subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FIRST_MINOR_DESC
|
Minor subject area description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
FOURTH_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
FOURTH_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FOURTH_MAJOR_CONC_1
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FOURTH_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_MAJOR_CONC_2
|
Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FOURTH_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_MAJOR_CONC_3
|
Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FOURTH_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
FOURTH_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
FOURTH_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
INCOMPLETE_IND
|
Indicates whether the application is incomplete.
|
VARCHAR2(1)
|
FUNCTION
|
F_ADMS_APPLICATION_STATUS
|
NO
|
NO
|
INSTITUTION_ATTENDING
|
Institution the student is attending if the withdrawal was to attend a different institution.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_SBGI_CODE
|
NO
|
NO
|
INSTITUTION_ATTENDING_DESC
|
Source/background institution name.
|
VARCHAR2(255)
|
STVSBGI
|
STVSBGI_DESC
|
NO
|
NO
|
INST_ACCEPTED_CURRENT_IND
|
Indicates the institution's most recent admission decision is to offer admission or accept the applicant into this program.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
NO
|
NO
|
INST_ADMIT_ANY_TIME_IND
|
Indicates the applicant was offered admission or accepted by the institution for this application, regardless of any subsequent admissions decision that may have revoked that offer.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
NO
|
NO
|
INST_DENIED_IND
|
Indicates the institution has denied the applicant admission under this application.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_ADMS_CHECK_STATUS
|
NO
|
NO
|
INTENDED_TIME_STATUS
|
Indicates whether the applicant intends full or part time enrollment.
|
VARCHAR2(1)
|
SARADAP
|
SARADAP_FULL_PART_IND
|
NO
|
NO
|
LATEST_DECISION
|
Most recent application decision value associated with the application.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_SARAPPD_INFO
|
NO
|
NO
|
LATEST_DECISION_DATE
|
Date most recent application decision was effective.
|
DATE
|
FUNCTION
|
SOKODSF.F_SARAPPD_INFO
|
NO
|
NO
|
LATEST_DECISION_DESC
|
Application decision (for example, applicant accepted, pending decision, quick admit) associated with the most recent decision code.
|
VARCHAR2(255)
|
STVAPDC
|
STVAPDC_DESC
|
NO
|
NO
|
MAILING_COUNT
|
Count of mailings of materials or letters to the admission applicant.
|
NUMBER
|
FUNCTION
|
MGKFUNC.F_COUNT_MAILING
|
NO
|
NO
|
MAJOR
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
MAJOR_DESC
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name middle initial).
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
NATION_ADMIT
|
Identifies the Nation/country of the student when they were admitted. The value is either stored in the administrative system or determined via a rule to look at a specific address and take the value.
|
VARCHAR2(63)
|
SABSUPL
|
SABSUPL_NATN_CODE_ADMIT
|
NO
|
NO
|
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
|
NO
|
NO
|
NATION_BIRTH_DESC_APPL
|
Nation/country description associated with the person at the time of birth as reported on the admissions application.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
NATION_DESC_ADMIT
|
Nation/country associated with the nation code at the time of admission.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
NON_TRADITIONAL_IND
|
Indicates whether the application is not for a traditional type of study at the institution such as non-degree granting or accelerated.
|
VARCHAR2(1)
|
NA
|
NA
|
NO
|
NO
|
PERSON_STATUS_IND
|
This field denotes Completion of Person Verification Requirements.
|
VARCHAR2(1)
|
SARHEAD
|
SARHEAD_PERS_STATUS_IND
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SARADAP
|
SARADAP_PIDM
|
NO
|
NO
|
POST_CODE_ADMIT
|
Identifies the Postal code of the student when they were admitted. The value is either stored in the administrative system or determined via a rule to look at a specific address and take the value.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
PRIMARY_ADVISOR_FIRST_NAME
|
Primary advisor current first name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PRIMARY_ADVISOR_ID
|
Current identification number for the primary advisor.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PRIMARY_ADVISOR_LAST_NAME
|
Primary advisor current last name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PRIMARY_ADVISOR_TYPE
|
Primary advisor current advising assignment type.
|
VARCHAR2(63)
|
SGRADVR
|
SGRADVR_ADVR_CODE
|
NO
|
NO
|
PRIMARY_ADVISOR_TYPE_DESC
|
Advisor type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PRIMARY_PROGRAM_IND
|
Indicates whether this is the primary program of study.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
PRIMARY_SOURCE_DESC
|
Source/background institution name.
|
VARCHAR2(255)
|
STVSBGI
|
STVSBGI_DESC
|
NO
|
NO
|
PROCESS_DATE
|
This field indicates the Date of Application Processing.
|
DATE
|
SARHEAD
|
SARHEAD_PROCESS_DATE
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROCESS_IND
|
This field denotes whether Application has been Processed.
|
VARCHAR2(1)
|
SARHEAD
|
SARHEAD_PROCESS_IND
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
PROGRAM_DESC
|
Program or course of study description.
|
VARCHAR2(255)
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
NO
|
NO
|
RATE
|
Specific tuition and fee assessment rate assigned to the student.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_RATE_CODE
|
NO
|
NO
|
RATE_DESC
|
Fee assessment rate code description.
|
VARCHAR2(255)
|
STVRATE
|
STVRATE_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
RECRUITER
|
Recruiter assigned to the person's admission application record.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_RECR_CODE
|
NO
|
NO
|
RECRUITER_DESC
|
Assigned recruiter's name.
|
VARCHAR2(255)
|
STVRECR
|
STVRECR_DESC
|
NO
|
NO
|
RECRUIT_TYPE
|
Identifies the type of recruit used to classify this prospect.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_RTYP_CODE
|
NO
|
NO
|
RECRUIT_TYPE_DESC
|
Recruit type description.
|
VARCHAR2(255)
|
STVRTYP
|
STVRTYP_DESC
|
NO
|
NO
|
REQUIRED_INTERVIEW_STATUS
|
Identifies the completion status associated with a required interview for an admissions applicant.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_INTV_CODE
|
NO
|
NO
|
REQUIRED_INTERVIEW_STATUS_DESC
|
Description of the required interview status.
|
VARCHAR2(255)
|
STVINTV
|
STVINTV_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
RESIDENCY
|
Residency code for the student identifying the type of charges the student will incur.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_RESD_CODE
|
NO
|
NO
|
RESIDENCY_DESC
|
Residency code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
RESIDENCY_IND
|
Identifies whether the student is considered in or out of the district for enrollment charges. Typically this indicates in or out of state or province but may also be in or out of county or in or out of the European Union, etc.
|
VARCHAR2(1)
|
STVRESD
|
STVRESD_IN_STATE_IND
|
NO
|
NO
|
SECOND_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_DEPARTMENT
|
Department responsible for the second major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
SECOND_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
SECOND_MAJOR
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_1
|
First concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_MAJOR_CONC_2
|
Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_MAJOR_CONC_3
|
Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
SECOND_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
SECOND_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
SITE
|
Site or location to which applicant is applying.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_SITE_CODE
|
NO
|
NO
|
SITE_CARRIER_ROUTE
|
Carrier route associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SITE_CITY
|
City, town or municipality associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_CITY
|
NO
|
NO
|
SITE_CORRECTION_DIGIT
|
Correction digit associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SITE_COUNTY_CODE
|
County associated with the site address.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SITE_COUNTY_CODE_DESC
|
Descriptions of the county associated with the site address.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
SITE_DELIVERY_POINT
|
Delivery point associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SITE_DESC
|
Site or location name.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_DESC
|
NO
|
NO
|
SITE_NATION
|
Nation/country code associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_NATION_CODE
|
NO
|
NO
|
SITE_NATION_DESC
|
Description for the nation/country associated with the site address.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
SITE_POSTAL_CODE
|
Postal code associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_ZIPC
|
NO
|
NO
|
SITE_STATE_PROVINCE
|
Identifies the state or province associated with this address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_STATE
|
NO
|
NO
|
SITE_STATE_PROVINCE_DESC
|
Name of the state/province.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
NO
|
NO
|
SITE_STREET_LINE1
|
First line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR1
|
NO
|
NO
|
SITE_STREET_LINE2
|
Second line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR2
|
NO
|
NO
|
SITE_STREET_LINE3
|
Third line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR3
|
NO
|
NO
|
SITE_STREET_LINE4
|
Fourth line of the site address.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
START_DATE
|
Non academic period based admissions field. Date studying is to begin.
|
DATE
|
SORLCUR
|
SORLCUR_START_DATE
|
NO
|
NO
|
STATE_ADMIT
|
Identifies the State/Province of the student when they were admitted. The value is either stored in the administrative system or determined via a rule to look at a specific address and take the value.
|
VARCHAR2(63)
|
SABSUPL
|
SABSUPL_STAT_CODE_ADMIT
|
NO
|
NO
|
STATE_BIRTH_APPL
|
State/Province associated with the person at the time of birth and reported on the admissions application.
|
VARCHAR2(63)
|
SABSUPL
|
SABSUPL_STAT_CODE_BIRTH
|
NO
|
NO
|
STATE_DESC_ADMIT
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
NO
|
NO
|
STATE_DESC_BIRTH_APPL
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
NO
|
NO
|
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
|
NO NO
|
NO
|
STUDENT_LEVEL_DESC
|
Student level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
STUDENT_MEETING_TIME
|
Student's normal attendance time. May be either day, evening, weekend, etc.
|
VARCHAR2(63)
|
SARADAP
|
SARADAP_SESS_CODE
|
NO
|
NO
|
STUDENT_MEETING_TIME_DESC
|
Student's meeting session description.
|
VARCHAR2(255)
|
STVSESS
|
STVSESS_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
STUDENT_POPULATION_DESC
|
Student population or type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
TERM_CODE_ENTRY
|
This field specifies the Application Term Code.
|
VARCHAR2(63)
|
SARHEAD
|
SARHEAD_TERM_CODE_ENTRY
|
NO
|
NO
|
THIRD_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
THIRD_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
THIRD_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MAJOR_CONC_1
|
First concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_MAJOR_CONC_2
|
Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_MAJOR_CONC_3
|
Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
THIRD_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
THIRD_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
WITHDRAWAL_REASON_DESC
|
Reason for withdrawal description.
|
VARCHAR2(255)
|
STVWRSN
|
STVWRSN_DESC
|
NO
|
NO
|