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
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
ADMIT_IND	This is a Y or N field to indicate if the student has been admitted to the institution for the associated term and level.	VARCHAR2(1)	FUNCTION	F_LEVEL_ADMITTED_FNC	NO	NO
APPLICANT_IND	This is a Y or N field to indicate if the student has applied for admissions for the associated term and level.	VARCHAR2(1)	FUNCTION	F_LEVEL_APPL_FNC	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(2)	STVDEGC	STVDEGC_ACAT_CODE	NO	NO
AWARD_CATEGORY_DESC	The degree award category description.	VARCHAR2(30)	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(3)	SORLCUR	SORLCUR_CAMP_CODE	NO	NO
CAMPUS_DESC	The description of the curriculum campus.	VARCHAR2(30)	STVCAMP	STVCAMP_DESC	NO	NO
CATALOG_ACADEMIC_PERIOD	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
CONTINUING_EDUCATION_IND	Indicates whether the course earns continuing education units instead of credits.	VARCHAR2(1)	NA	NA	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	Sequence number of key record.	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_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
DEPOSIT_IND	This is a Y or N field to indicate if the student has paid an admissions deposit.	VARCHAR2(1)	FUNCTION	F_PAID_ADMISSIONS_DEPOSIT	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
FIRST_MAJOR_CONC_1	This field identifies the first concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FIRST_MAJOR_CONC_1_DESC	This field identifies the description of the first concentration within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
FIRST_MAJOR_CONC_2	This field identifies the second concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FIRST_MAJOR_CONC_2_DESC	This field identifies the description of the second concentration within the curriculum for the term.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
FIRST_MAJOR_CONC_3	This field identifies the third concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
FIRST_MAJOR_CONC_3_DESC	This field identifies the description of the third 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
INQUIRER_IND	This is a Y or N field to indicate if the student has any recruiting information.	VARCHAR2(1)	FUNCTION	F_INQUIRER_FNC	NO	NO
LAST_ACTIVE_ACADEMIC_PERIOD	Field of study last active academic period.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_END	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
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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORLCUR	SORLCUR_PIDM	NO	NO
PRIMARY_PROGRAM_IND	This field indicates whether this is your primary program of study.	VARCHAR2(1)	NA	NA	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
PROSPECT_IND	This field is not currently used.	VARCHAR2(1)	FUNCTION	F_PROSPECT_FNC	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
SOURCE	The learner module code.	VARCHAR2(15)	SORLCUR	SORLCUR_LMOD_CODE	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
STUDENT_LEVEL	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(2)	SORLCUR	SORLCUR_LEVL_CODE	NO	NO
STUDENT_LEVEL_DESC	The description of the curriculum level.	VARCHAR2(30)	STVLEVL	STVLEVL_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
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: