Target Column	Business Definition	Database Data Type	Source Name	Source Column
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(6)	SORLCUR	SORLCUR_TERM_CODE
ACADEMIC_PERIOD_ADMITTED	This field identifies the academic period or term associated with the information on the academic study information record.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_ADMIT
ACADEMIC_PERIOD_ADMITTED_DESC	This field specifies the academic period or term associated with the academic period code.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_PERIOD_END	This field identifies the ending academic period or term associated with the information on the academic study information record.	VARCHAR2(6)	FUNCTION	SOKODSF.F_GET_END_SGBSTDN_TERM
ACADEMIC_PERIOD_MATRICULATED	The matriculation term of the student.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_MATRIC
ACADEMIC_PERIOD_MATRIC_DESC	The description of the matriculation term.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_PERIOD_START	This field identifies the starting academic period or term associated with the information on the academic study information record.	VARCHAR2(6)	SGBSTDN	SGBSTDN_TERM_CODE_EFF
ACTIVITY_DATE	Date record was inserted or updated.	DATE	SORLCUR	SORLCUR_ACTIVITY_DATE
ADMISSIONS_POPULATION	This field identifies the admission type of the applicant.	VARCHAR2(2)	SORLCUR	SORLCUR_ADMT_CODE
ADMISSIONS_POPULATION_DESC	This field specifies the admission type (e.g. early admit, mature, adult and continuing education, etc.) associated with the admission type code.	VARCHAR2(30)	STVADMT	STVADMT_DESC
AGE_ADMITTED	Age upon entry to institution.	NUMBER	FUNCTION	SOKODSF.F_CALCULATE_AGE_ADMIT
CAMPUS	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(3)	SORLCUR	SORLCUR_CAMP_CODE
CAMPUS_DESC	The description of the curriculum campus.	VARCHAR2(30)	STVCAMP	STVCAMP_DESC
CATALOG	Curriculum Catalog Term.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_CTLG
CATALOG_ACADEMIC_PERIOD_DESC	The description of the curriculum catalog term.	VARCHAR2(30)	STVTERM	STVTERM_DESC
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(2)	SORLCUR	SORLCUR_COLL_CODE
COLLEGE_DESC	The description of the curriculum college .	VARCHAR2(30)	STVCOLL	STVCOLL_DESC
CURRENT_DATE	The current date.	DATE	NA	SYSDATE
CURRICULUM_PRIORITY	Identifies the significanct ranking for a curricula.	NUMBER	SORLCUR	SORLCUR_PRIORITY_NO
CURRICULUM_SEQUENCE	System generated one-up number assigned to a student or learner for a curriculum or curriculum changes.	NUMBER	SORLCUR	SORLCUR_SEQNO
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(6)	SORLCUR	SORLCUR_DEGC_CODE
DEGREE_AWARD_CATEGORY	The degree award category.	VARCHAR2(2)	STVDEGC	STVDEGC_ACAT_CODE
DEGREE_AWARD_CATEGORY_DESC	The degree award category description.	VARCHAR2(30)	STVACAT	STVACAT_DESC
DEGREE_DESC	The description of the curriculum degree .	VARCHAR2(30)	STVDEGC	STVDEGC_DESC
DEPARTMENT	Department responsible for the major subject area of a student course or associated with the major within the student academic study.	VARCHAR2(4)	SORLFOS	SORLFOS_DEPT_CODE
DEPARTMENT_DESC	The description of the students department for the current curriculum.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
END_DATE	The date the curriculum ends.	DATE	SORLCUR	SORLCUR_END_DATE
EXPECTED_GRADUATION_DATE	The expected graduation date of the student.	DATE	CALCULATION	NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)
FIRST_CONCENTRATION	This field identifies the first concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
FIRST_CONCENTRATION_DESC	This field identifies the description of the first concentration within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
FIRST_MINOR	First minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
FIRST_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
FOURTH_DEPARTMENT	This field identifies the fourth department within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_DEPT_CODE
FOURTH_DEPARTMENT_DESC	This field identifies the description of the fourth department within the curriculum for the term.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC
FOURTH_MAJOR	This field identifies the fourth major within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_1	Concentration 1 on fourth Major of Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_1_DESC	The description of the first concentration on fourth Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_CONC_2	Concentration 2 on fourth Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_2_DESC	The description of the second concentration on fourth Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_CONC_3	Concentration 3 on fourth Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_3_DESC	The description of the third concentration on fourth Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_DESC	This field identifies the description of the fourth major within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
FOURTH_MINOR	Fourth minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
FOURTH_PROGRAM_CLASSIFICATION	This identifies the Classification of Institutional Programs (CIP) code of the fourth major within the curriculum for the term.	VARCHAR2(6)	STVMAJR	STVMAJR_CIPC_CODE
FOURTH_PROGRAM_CLASSIF_DESC	This identifies the description of the Classification of Institutional Programs (CIP) code of the fourth major within the curriculum for the term.	VARCHAR2(30)	STVCIPC	STVCIPC_DESC
GRAD_ACADEMIC_PERIOD_INTENDED	Intended academic period of graduation for the student.	VARCHAR2(6)	CALCULATION	NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD)
GRAD_ACAD_PERIOD_INTENDED_DESC	The description of the intended graduation term.	VARCHAR2(30)	STVTERM	STVTERM_DESC
GRAD_YEAR_INTENDED	Intended year of graduation.	VARCHAR2(4)	CALCULATION	NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)
GRAD_YEAR_INTENDED_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC
LAST_ACTIVE_ACADEMIC_PERIOD	Field of study last active academic period.	VARCHAR2(6)	FUNCTION	NVL(SORLCUR_TERM_CODE_END,'999999')
LEAVE_DATE_FROM	Start date of the student leave.	DATE	CALCULATION	NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE)
LEAVE_DATE_TO	Date the student leave is scheduled to or ends.	DATE	CALCULATION	NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE)
LEAVE_REASON	Leave code of the student for this academic period.	VARCHAR2(1)	CALCULATION	NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE)
LEAVE_REASON_DESC	Student's leave code description for this term.	VARCHAR2(30)	STVLEAV	STVLEAV_DESC
MAJOR	Major subject area of the person's academic study.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
MAJOR_DESC	The description of the students major for the current curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
MAJOR_ELIG_FOR_AID_IND	Indicates whether the student is eligible for financial aid based on their assigned major.	VARCHAR2(1)	STVMAJR	STVMAJR_AID_ELIGIBILITY_IND
MATRICULATED_IND	This is a Y or N field to indicate if the student is matriculated.	VARCHAR2(1)	FUNCTION	DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,'N','Y')
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA
NON_TRADITIONAL_IND	This field indicates whether this academic study is non-traditional.	VARCHAR2(1)	NA	NA
OUTCOME_NUMBER	The sequence number of the outcome created during the grade roll.	NUMBER	SORLCUR	SORLCUR_ROLLED_SEQNO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORLCUR	SORLCUR_PIDM
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(12)	SORLCUR	SORLCUR_PROGRAM
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(6)	STVMAJR	STVMAJR_CIPC_CODE
PROGRAM_CLASSIFICATION_DESC	This identifies the description of the Classification of Institutional Programs (CIP) code for the current curriculum.	VARCHAR2(30)	STVCIPC	STVCIPC_DESC
PROGRAM_DESC	Curriculum Program Description.	VARCHAR2(30)	SMRPRLE	SMRPRLE_PROGRAM_DESC
PROGRAM_LEVEL	Curriculum Level .	VARCHAR2(2)	SORLCUR	SORLCUR_LEVL_CODE
PROGRAM_LEVEL_DESC	The description of the curriculum level.	VARCHAR2(30)	STVLEVL	STVLEVL_DESC
SECOND_CONCENTRATION	This field identifies the second concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_CONCENTRATION_DESC	This field identifies the description of the second concentration within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
SECOND_DEPARTMENT	This field identifies the second department within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_DEPT_CODE
SECOND_DEPARTMENT_DESC	This field identifies the description of the second department within the curriculum for the term.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC
SECOND_MAJOR	Major subject area of the person's academic study.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_1	Concentration 1 on Second Major of Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_1_DESC	The description of the first concentration on Second Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_2	Concentration 2 on Second Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_2_DESC	The description of the second concentration on Second Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_3	Concentration 3 on Second Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_3_DESC	The description of the third concentration on Second Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_DESC	This field identifies the description of the second major within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
SECOND_MINOR	Second minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
SECOND_PROGRAM_CLASSIFICATION	This identifies the Classification of Institutional Programs (CIP) code of the second major within the curriculum for the term.	VARCHAR2(6)	STVMAJR	STVMAJR_CIPC_CODE
SECOND_PROGRAM_CLASSIF_DESC	This identifies the description of the Classification of Institutional Programs (CIP) code of the second major within the curriculum for the term.	VARCHAR2(30)	STVCIPC	STVCIPC_DESC
SITE	The site code of the student for this term.	VARCHAR2(3)	FUNCTION	NVL(SORLCUR_SITE_CODE, SGBSTDN_SITE_CODE)
SITE_CARRIER_ROUTE	Carrier route associated with the site address for barcode mailings.	VARCHAR2(4)	NA	NA
SITE_CITY	City, town or municipality associated with the site address.	VARCHAR2(63)	STVSITE	STVSITE_CITY
SITE_CORRECTION_DIGIT	Correction digit associated with the site address for barcode mailings.	VARCHAR2(1)	NA	NA
SITE_COUNTY_CODE	County associated with the site address.	VARCHAR2(5)	NA	NA
SITE_COUNTY_CODE_DESC	Descriptions of the county associated with the site address.	VARCHAR2(30)	NA	NA
SITE_DELIVERY_POINT	Delivery point associated with the site address for barcode mailings.	VARCHAR2(2)	NA	NA
SITE_DESC	Student's site or location description.	VARCHAR2(30)	STVSITE	STVSITE_DESC
SITE_NATION	Nation/country code associated with the site address.	VARCHAR2(5)	STVSITE	STVSITE_NATION_CODE
SITE_NATION_DESC	Description for the nation/country associated with the site address.	VARCHAR2(30)	STVNATN	STVNATN_NATION
SITE_POSTAL_CODE	Postal code associated with the site address.	VARCHAR2(63)	STVSITE	STVSITE_ZIPC
SITE_STATE_PROVINCE	Identifies the state or province associated with this address.	VARCHAR2(3)	STVSITE	STVSITE_STATE
SITE_STATE_PROVINCE_DESC	Name of the state/province.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC
SITE_STREET_LINE1	First line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR1
SITE_STREET_LINE2	Second line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR2
SITE_STREET_LINE3	Third line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR3
SITE_STREET_LINE4	Fourth line of the site address.	VARCHAR2(255)	NA	NA
SOURCE_SEQUENCE_NUMBER	Sequence number of the source key record.	NUMBER	SORLCUR	SORLCUR_KEY_SEQNO
START_DATE	The date the curriculum starts.	DATE	SORLCUR	SORLCUR_START_DATE
START_DATE_ADMITTED	Non term based admissions field. Date you started studying.	DATE	STVTERM	STVTERM_START_DATE
START_DATE_MATRICULATED	The matriculation start date of the student.	DATE	STVTERM	STVTERM_START_DATE
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(1)	FUNCTION	NVL(SORLCUR_STYP_CODE, SGBSTDN_STYP_CODE)
STUDENT_POPULATION_DESC	This field specifies the student type (e.g. new freshman, transfer, continuing) associated with the student type code.	VARCHAR2(30)	STVSTYP	STVSTYP_DESC
STUDENT_RATE	Identifies any specific assessment rate to be used to determine the charges for this student.	VARCHAR2(5)	CALCULATION	NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE)
STUDENT_RATE_DESC	Description for the rate code.	VARCHAR2(30)	STVRATE	STVRATE_DESC
SUB_ACADEMIC_PERIOD_ADMITTED	This field identifies the session or part of the academic period associated with the information on the academic study information record.	VARCHAR2(3)	NA	NA
SUB_ACADEMIC_PERIOD_ADMIT_DESC	This field specifies the session or part of the academic period associated with the session code.	VARCHAR2(30)	NA	NA
SUB_ACADEMIC_PERIOD_MATRIC	The matriculation sub academic period of the student.	VARCHAR2(3)	NA	NA
SUB_ACAD_PERIOD_MATRIC_DESC	The description of the sub academic period.	VARCHAR2(30)	NA	NA
THIRD_CONCENTRATION	This field identifies the third concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
THIRD_CONCENTRATION_DESC	This field identifies the description of the third concentration within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
THIRD_DEPARTMENT	This field identifies the third department within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_DEPT_CODE
THIRD_DEPARTMENT_DESC	This field identifies the description of the third department within the curriculum for the term.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC
THIRD_MAJOR	This field identifies the third major within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_1	Concentration 1 on third Major of Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_1_DESC	The description of the first concentration on third Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
THIRD_MAJOR_CONC_2	Concentration 2 on third Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_2_DESC	The description of the second concentration on third Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
THIRD_MAJOR_CONC_3	Concentration 3 on third Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_3_DESC	The description of the third concentration on third Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
THIRD_MAJOR_DESC	This field identifies the description of the third major within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
THIRD_MINOR	Third minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
THIRD_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
THIRD_PROGRAM_CLASSIFICATION	This identifies the Classification of Institutional Programs (CIP) code of the third major within the curriculum for the term.	VARCHAR2(6)	STVMAJR	STVMAJR_CIPC_CODE
THIRD_PROGRAM_CLASSIF_DESC	This identifies the description of the Classification of Institutional Programs (CIP) code of the third major within the curriculum for the term.	VARCHAR2(30)	STVCIPC	STVCIPC_DESC
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	SORLCUR	SORLCUR_USER_ID
YEAR_ADMITTED	This field identifies the academic year associated with the information on the academic study information record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE
YEAR_ADMITTED_DESC	This field specifies the academic year associated with the academic year code.	VARCHAR2(30)	STVACYR	STVACYR_DESC
YEAR_MATRICULATED	The matriculation year of the student.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE
YEAR_MATRICULATED_DESC	The matriculation year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: