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(6)	SORLCUR	SORLCUR_TERM_CODE	NO	NO
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	NO	NO
ACADEMIC_PERIOD_ADMITTED_DESC	This field specifies the academic period or term associated with the academic period code.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
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	NO	NO
ACADEMIC_PERIOD_MATRICULATED	The matriculation term of the student.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_MATRIC	NO	NO
ACADEMIC_PERIOD_MATRIC_DESC	The description of the matriculation term.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
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	NO	NO
ACTIVITY_DATE	Date record was inserted or updated.	DATE	SORLCUR	SORLCUR_ACTIVITY_DATE	NO	NO
ADMISSIONS_POPULATION	This field identifies the admission type of the applicant.	VARCHAR2(2)	SORLCUR	SORLCUR_ADMT_CODE	NO	NO
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	NO	NO
AGE_ADMITTED	Age upon entry to institution.	NUMBER	FUNCTION	SOKODSF.F_CALCULATE_AGE_ADMIT	NO	NO
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	NO	NO
CAMPUS_DESC	The description of the curriculum campus.	VARCHAR2(30)	STVCAMP	STVCAMP_DESC	NO	NO
CATALOG	Curriculum Catalog Term.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_CTLG	NO	NO
CATALOG_ACADEMIC_PERIOD_DESC	The description of the curriculum catalog term.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
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	NO	NO
COLLEGE_DESC	The description of the curriculum college .	VARCHAR2(30)	STVCOLL	STVCOLL_DESC	NO	NO
CURRENT_DATE	The current date.	DATE	NA	SYSDATE	NO	NO
CURRICULUM_PRIORITY	Identifies the significanct ranking for a curricula.	NUMBER	SORLCUR	SORLCUR_PRIORITY_NO	NO	NO
CURRICULUM_SEQUENCE	System generated one-up number assigned to a student or learner for a curriculum or curriculum changes.	NUMBER	SORLCUR	SORLCUR_SEQNO	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(6)	SORLCUR	SORLCUR_DEGC_CODE	NO	NO
DEGREE_AWARD_CATEGORY	The degree award category.	VARCHAR2(2)	STVDEGC	STVDEGC_ACAT_CODE	NO	NO
DEGREE_AWARD_CATEGORY_DESC	The degree award category description.	VARCHAR2(30)	STVACAT	STVACAT_DESC	NO	NO
DEGREE_DESC	The description of the curriculum degree .	VARCHAR2(30)	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(4)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
DEPARTMENT_DESC	The description of the students department for the current curriculum.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
END_DATE	The date the curriculum ends.	DATE	SORLCUR	SORLCUR_END_DATE	NO	NO
EXPECTED_GRADUATION_DATE	The expected graduation date of the student.	DATE	CALCULATION	NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)	NO	NO
FIRST_CONCENTRATION	This field identifies the first concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FIRST_CONCENTRATION_DESC	This field identifies the description of the first concentration within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
FIRST_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_DEPARTMENT	This field identifies the fourth department within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
FOURTH_DEPARTMENT_DESC	This field identifies the description of the fourth department within the curriculum for the term.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC	NO	NO
FOURTH_MAJOR	This field identifies the fourth major within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MAJOR_CONC_1	Concentration 1 on fourth Major of Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MAJOR_CONC_1_DESC	The description of the first concentration on fourth Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_MAJOR_CONC_2	Concentration 2 on fourth Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MAJOR_CONC_2_DESC	The description of the second concentration on fourth Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_MAJOR_CONC_3	Concentration 3 on fourth Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MAJOR_CONC_3_DESC	The description of the third concentration on fourth Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
FOURTH_MAJOR_DESC	This field identifies the description of the fourth major within the curriculum for the term.	VARCHAR2(30)	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(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FOURTH_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
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	NO	NO
GRAD_ACADEMIC_PERIOD_INTENDED	Intended academic period of graduation for the student.	VARCHAR2(6)	CALCULATION	NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD)	NO	NO
GRAD_ACAD_PERIOD_INTENDED_DESC	The description of the intended graduation term.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
GRAD_YEAR_INTENDED	Intended year of graduation.	VARCHAR2(4)	CALCULATION	NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)	NO	NO
GRAD_YEAR_INTENDED_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC	NO	NO
LAST_ACTIVE_ACADEMIC_PERIOD	Field of study last active academic period.	VARCHAR2(6)	FUNCTION	NVL(SORLCUR_TERM_CODE_END,'999999')	NO	NO
LEAVE_DATE_FROM	Start date of the student leave.	DATE	CALCULATION	NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE)	NO	NO
LEAVE_DATE_TO	Date the student leave is scheduled to or ends.	DATE	CALCULATION	NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE)	NO	NO
LEAVE_REASON	Leave code of the student for this academic period.	VARCHAR2(1)	CALCULATION	NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE)	NO	NO
LEAVE_REASON_DESC	Student's leave code description for this term.	VARCHAR2(30)	STVLEAV	STVLEAV_DESC	NO	NO
MAJOR	Major subject area of the person's academic study.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
MAJOR_DESC	The description of the students major for the current curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
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')	NO	NO
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	NO	NO
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	NO	NO
NON_TRADITIONAL_IND	This field indicates whether this academic study is non-traditional.	VARCHAR2(1)	NA	NA	NO	NO
OUTCOME_NUMBER	The sequence number of the outcome created during the grade roll.	NUMBER	SORLCUR	SORLCUR_ROLLED_SEQNO	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORLCUR	SORLCUR_PIDM	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(12)	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(6)	STVMAJR	STVMAJR_CIPC_CODE	NO	NO
PROGRAM_CLASSIFICATION_DESC	This identifies the description of the Classification of Institutional Programs (CIP) code for the current curriculum.	VARCHAR2(30)	STVCIPC	STVCIPC_DESC	NO	NO
PROGRAM_DESC	Curriculum Program Description.	VARCHAR2(30)	SMRPRLE	SMRPRLE_PROGRAM_DESC	NO	NO
PROGRAM_LEVEL	Curriculum Level .	VARCHAR2(2)	SORLCUR	SORLCUR_LEVL_CODE	NO	NO
PROGRAM_LEVEL_DESC	The description of the curriculum level.	VARCHAR2(30)	STVLEVL	STVLEVL_DESC	NO	NO
SECOND_CONCENTRATION	This field identifies the second concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_CONCENTRATION_DESC	This field identifies the description of the second concentration within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_DEPARTMENT	This field identifies the second department within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
SECOND_DEPARTMENT_DESC	This field identifies the description of the second department within the curriculum for the term.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC	NO	NO
SECOND_MAJOR	Major subject area of the person's academic study.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_1	Concentration 1 on Second Major of Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_1_DESC	The description of the first concentration on Second Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MAJOR_CONC_2	Concentration 2 on Second Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_2_DESC	The description of the second concentration on Second Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MAJOR_CONC_3	Concentration 3 on Second Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_3_DESC	The description of the third concentration on Second Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MAJOR_DESC	This field identifies the description of the second major within the curriculum for the term.	VARCHAR2(30)	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(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
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	NO	NO
SITE	The site code of the student for this term.	VARCHAR2(3)	FUNCTION	NVL(SORLCUR_SITE_CODE, SGBSTDN_SITE_CODE)	NO	NO
SITE_CARRIER_ROUTE	Carrier route associated with the site address for barcode mailings.	VARCHAR2(4)	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(1)	NA	NA	NO	NO
SITE_COUNTY_CODE	County associated with the site address.	VARCHAR2(5)	NA	NA	NO	NO
SITE_COUNTY_CODE_DESC	Descriptions of the county associated with the site address.	VARCHAR2(30)	NA	NA	NO	NO
SITE_DELIVERY_POINT	Delivery point associated with the site address for barcode mailings.	VARCHAR2(2)	NA	NA	NO	NO
SITE_DESC	Student's site or location description.	VARCHAR2(30)	STVSITE	STVSITE_DESC	NO	NO
SITE_NATION	Nation/country code associated with the site address.	VARCHAR2(5)	STVSITE	STVSITE_NATION_CODE	NO	NO
SITE_NATION_DESC	Description for the nation/country associated with the site address.	VARCHAR2(30)	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(3)	STVSITE	STVSITE_STATE	NO	NO
SITE_STATE_PROVINCE_DESC	Name of the state/province.	VARCHAR2(30)	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_SEQUENCE_NUMBER	Sequence number of the source key record.	NUMBER	SORLCUR	SORLCUR_KEY_SEQNO	NO	NO
START_DATE	The date the curriculum starts.	DATE	SORLCUR	SORLCUR_START_DATE	NO	NO
START_DATE_ADMITTED	Non term based admissions field. Date you started studying.	DATE	STVTERM	STVTERM_START_DATE	NO	NO
START_DATE_MATRICULATED	The matriculation start date of the student.	DATE	STVTERM	STVTERM_START_DATE	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(1)	FUNCTION	NVL(SORLCUR_STYP_CODE, SGBSTDN_STYP_CODE)	NO	NO
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	NO	NO
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)	NO	NO
STUDENT_RATE_DESC	Description for the rate code.	VARCHAR2(30)	STVRATE	STVRATE_DESC	NO	NO
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	NO	NO
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	NO	NO
SUB_ACADEMIC_PERIOD_MATRIC	The matriculation sub academic period of the student.	VARCHAR2(3)	NA	NA	NO	NO
SUB_ACAD_PERIOD_MATRIC_DESC	The description of the sub academic period.	VARCHAR2(30)	NA	NA	NO	NO
THIRD_CONCENTRATION	This field identifies the third concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_CONCENTRATION_DESC	This field identifies the description of the third concentration within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_DEPARTMENT	This field identifies the third department within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
THIRD_DEPARTMENT_DESC	This field identifies the description of the third department within the curriculum for the term.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC	NO	NO
THIRD_MAJOR	This field identifies the third major within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MAJOR_CONC_1	Concentration 1 on third Major of Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MAJOR_CONC_1_DESC	The description of the first concentration on third Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_MAJOR_CONC_2	Concentration 2 on third Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MAJOR_CONC_2_DESC	The description of the second concentration on third Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_MAJOR_CONC_3	Concentration 3 on third Major on Curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MAJOR_CONC_3_DESC	The description of the third concentration on third Major on Curriculum.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
THIRD_MAJOR_DESC	This field identifies the description of the third major within the curriculum for the term.	VARCHAR2(30)	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(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
THIRD_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
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	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	SORLCUR	SORLCUR_USER_ID	NO	NO
YEAR_ADMITTED	This field identifies the academic year associated with the information on the academic study information record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
YEAR_ADMITTED_DESC	This field specifies the academic year associated with the academic year code.	VARCHAR2(30)	STVACYR	STVACYR_DESC	NO	NO
YEAR_MATRICULATED	The matriculation year of the student.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
YEAR_MATRICULATED_DESC	The matriculation year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: