| 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)
|
SRBRECR
|
SRBRECR_TERM_CODE
|
|
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(4)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
ADMISSION_POPULATION
|
Admission Population
|
Identifies an admission population (e.g., early admit, mature, adult and continuing education, etc.) associated with the person and recruitment information.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_ADMT_CODE
|
|
ADMISSION_POPULATION_DESC
|
Admission Population Description
|
Admission population description.
|
VARCHAR2(255)
|
STVADMT
|
STVADMT_DESC
|
|
ATTRIBUTE_COUNT
|
Attribute Count
|
Count of student attributes recorded for the recruitment information.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_RECRUITMENT_ATTRIBUTES
|
|
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
|
|
COHORT_COUNT
|
Cohort Count
|
Count of all the current active recruitment cohort codes recorded for the person.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_COHORTS
|
|
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
|
|
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
|
Identifies the significanct ranking for a curricula.
|
NUMBER
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
|
DATE_ADDED
|
Date Added
|
Date the record was added.
|
DATE
|
SRBRECR
|
SRBRECR_ADD_DATE
|
|
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
|
Recruit's educational goal.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_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 recruit.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_EDLV_CODE
|
|
EDUCATION_LEVEL_DESC
|
Education Level Description
|
Description of the recruit's current education level.
|
VARCHAR2(255)
|
STVEDLV
|
STVEDLV_DESC
|
|
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 the academic outcome. This may be the Classification of Institutional Program (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)
|
SPRIDEN
|
SPRIDEN_ID
|
|
INTENDED_TIME_STATUS
|
Intended Time Status
|
Indicates whether the prospect is a full-time (F) or part-time (P) student.
|
VARCHAR2(1)
|
SRBRECR
|
SRBRECR_FULL_PART_IND
|
|
LEARNED
|
Learned
|
Specifies how the prospect learned about the institution. If multiple learned records exist for this recruitment record, this will reflect the most recently recorded value based on activity date.
|
VARCHAR2(63)
|
SRRLEND
|
SRRLEND_LEND_CODE
|
|
LEARNED_DESC
|
Learned Description
|
Description of how the prospect learned about the institution.
|
VARCHAR2(255)
|
STVLEND
|
STVLEND_DESC
|
|
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
|
|
OTHER_INSTITUTION
|
Other Institution
|
Institution attending code represents the institution the student decided to attend rather than this institution.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_SBGI_CODE
|
|
OTHER_INSTITUTION_DESC
|
Other Institution Description
|
Source/background institution name.
|
VARCHAR2(255)
|
STVSBGI
|
STVSBGI_DESC
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SRBRECR
|
SRBRECR_PIDM
|
|
PRIMARY_PROGRAM_IND
|
Primary Program Indicator
|
Indicates whether this is the primary program of study.
|
VARCHAR2(1)
|
NA
|
NA
|
|
PRIMARY_RECRUIT_RECORD_IND
|
Primary Recruit Record Indicator
|
Indicates whether this record is the current or most recent recruiting record. Only one record per term may be selected.
|
VARCHAR2(1)
|
SRBRECR
|
SRBRECR_SELECT_IND
|
|
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)
|
SRRRSRC
|
SRRRSRC_SBGI_CODE
|
|
PRIMARY_SOURCE_DESC
|
Primary Source Description
|
Source/background institution name.
|
VARCHAR2(255)
|
STVSBGI
|
STVSBGI_DESC
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PROGRAM
|
Program
|
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
|
Current institution designated status of this prospect.
|
VARCHAR2(63)
|
NA
|
NA
|
|
RATE_DESC
|
Rate Description
|
Recruitment rating status description.
|
VARCHAR2(255)
|
NA
|
NA
|
|
RECRUITER
|
Recruiter
|
Recruiter assigned to the prospect's recruiting record.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_RECR_CODE
|
|
RECRUITER_DESC
|
Recruiter Description
|
Assigned recruiter's name.
|
VARCHAR2(255)
|
STVRECR
|
STVRECR_DESC
|
|
RECRUITER_ID
|
Recruiter ID
|
Current identification number of the recruiter.
|
VARCHAR2(9)
|
NA
|
NA
|
|
RECRUIT_NUMBER
|
Recruit Number
|
Internal sequence number for the academic period.
|
NUMBER
|
SRBRECR
|
SRBRECR_ADMIN_SEQNO
|
|
RECRUIT_STATUS
|
Recruitment Status
|
Current status of this recruitment record, whether the status is determined by the institution or prospective student.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_RSTA_CODE
|
|
RECRUIT_STATUS_DESC
|
Recruitment Status Description
|
Recruit status description.
|
VARCHAR2(255)
|
STVRSTA
|
STVRSTA_DESC
|
|
RECRUIT_TYPE
|
Recruit Type
|
Identifies the type of recruit used to classify this prospect.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_RTYP_CODE
|
|
RECRUIT_TYPE_DESC
|
Recruit Type Description
|
Recruit type description.
|
VARCHAR2(255)
|
STVRTYP
|
STVRTYP_DESC
|
|
RESIDENCY
|
Residency
|
Residency code for the student identifying the type of charges the student will incur.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_RESD_CODE
|
|
RESIDENCY_DESC
|
Residency Description
|
Residency code description.
|
VARCHAR2(255)
|
STVRESD
|
STVRESD_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 Concentratin Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
SECOND_DEPARTMENT
|
Second Department
|
Department responsible for the 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 concentrations 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 concentrations 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 concentrations 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 the academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
|
SECOND_PROGRAM_CLASSIF_DESC
|
Second Program Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
|
SITE
|
Site
|
Site or location to which recruit is applying.
|
VARCHAR2(63)
|
SRBRECR
|
SRBRECR_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
|
County description 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
|
Nation/country description 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_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 this inquiry. Included might be secondary school recruiter visit, newspaper advertisement, friend referral, etc.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_RECRUITMENT_SOURCES
|
|
START_DATE
|
Start Date
|
Date you want to begin studying. The non-term based admissions field.
|
DATE
|
SORLCUR
|
SORLCUR_START_DATE
|
|
STUDENT_LEVEL
|
Student Level
|
Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.
|
VARCHAR2(63)
|
SORLCUR
|
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)
|
SRBRECR
|
SRBRECR_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)
|
SRBRECR
|
SRBRECR_STYP_CODE
|
|
STUDENT_POPULATION_DESC
|
Student Population Description
|
Student population or type description.
|
VARCHAR2(255)
|
STVSTYP
|
STVSTYP_DESC
|
|
SUB_ACADEMIC_PERIOD
|
Sub Academic Period
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period Description
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|
|
THIRD_CONCENTRATION
|
Third Concentration
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
THIRD_CONCENTRATION_DESC
|
Third Concentration Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
THIRD_DEPARTMENT
|
Third Department
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
THIRD_DEPARTMENT_DESC
|
Third Department Description
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
|
THIRD_MAJOR
|
Third Major
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
THIRD_MAJOR_CONC_1
|
Third Major Concentration 1
|
First concentration or focus of study within this student's major. This may be blank when concentrations 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 concentrations 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 concentrations 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 the academic outcome. This may be the Classification of Institutional Program (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)
|
SRBRECR
|
SRBRECR_WRSN_CODE
|
|
WITHDRAWAL_REASON_DESC
|
Withdrawal Reason Description
|
Reason for withdrawal description.
|
VARCHAR2(255)
|
STVWRSN
|
STVWRSN_DESC
|