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
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
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
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
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
AWARD_CATEGORY_DESC	The degree award category description.	VARCHAR2(30)	STVACAT	STVACAT_DESC
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_ACADEMIC_PERIOD	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
CONTINUING_EDUCATION_IND	Indicates whether the course earns continuing education units instead of credits.	VARCHAR2(1)	NA	NA
CURRENT_DATE	The current date.	DATE	NA	SYSDATE
CURRICULUM_PRIORITY	Identifies the significanct ranking for a curricula.	NUMBER	SORLCUR	SORLCUR_PRIORITY_NO
CURRICULUM_SEQUENCE	Sequence number of key record.	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_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
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
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
FIRST_MAJOR_CONC_1	This field identifies the first concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
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
FIRST_MAJOR_CONC_2	This field identifies the second concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
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
FIRST_MAJOR_CONC_3	This field identifies the third concentration within the curriculum for the term.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
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
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
INQUIRER_IND	This is a Y or N field to indicate if the student has any recruiting information.	VARCHAR2(1)	FUNCTION	F_INQUIRER_FNC
LAST_ACTIVE_ACADEMIC_PERIOD	Field of study last active academic period.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_END
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
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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORLCUR	SORLCUR_PIDM
PRIMARY_PROGRAM_IND	This field indicates whether this is your primary program of study.	VARCHAR2(1)	NA	NA
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
PROSPECT_IND	This field is not currently used.	VARCHAR2(1)	FUNCTION	F_PROSPECT_FNC
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
SOURCE	The learner module code.	VARCHAR2(15)	SORLCUR	SORLCUR_LMOD_CODE
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
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
STUDENT_LEVEL_DESC	The description of the curriculum level.	VARCHAR2(30)	STVLEVL	STVLEVL_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
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: