Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame this person applied to study at this institution.	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	The degree award category.	VARCHAR2(2)	STVDEGC	STVDEGC_ACAT_CODE
AWARD_CATEGORY_DESC	The degree award category description.	VARCHAR2(30)	STVACAT	STVACAT_DESC
CAMPUS	Curriculum Campus	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	Curriculum College	VARCHAR2(2)	SORLCUR	SORLCUR_COLL_CODE
COLLEGE_DESC	The description of the curriculum college .	VARCHAR2(30)	STVCOLL	STVCOLL_DESC
CONTINUING_EDUCATION_IND	This field indicates whether the student is a continuing education student.	VARCHAR2(1)	NA	NA
CURRENT_DATE	The current date.	DATE	NA	SYSDATE
CURRICULUM_PRIORITY	Identifies the significanct ranking for a curricula.	NUMBER(4)	SORLCUR	SORLCUR_PRIORITY_NO
CURRICULUM_SEQUENCE	Sequence number of key record.	NUMBER(4)	SORLCUR	SORLCUR_SEQNO
DEGREE	Curriculum Degree .	VARCHAR2(6)	SORLCUR	SORLCUR_DEGC_CODE
DEGREE_DESC	The description of the curriculum degree .	VARCHAR2(30)	STVDEGC	STVDEGC_DESC
DEPARTMENT	The students department for the current curriculum.	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	The students major for the current curriculum.	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(8)	SORLCUR	SORLCUR_PIDM
PRIMARY_PROGRAM_IND	This field indicates whether this is your primary program of study.	VARCHAR2(1)	NA	NA
PROGRAM	Curriculum Program	VARCHAR2(12)	SORLCUR	SORLCUR_PROGRAM
PROGRAM_CLASSIFICATION	This identifies the Classification of Institutional Programs (CIP) code for the current curriculum.	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	This field identifies the second major within the curriculum for the term.	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(2)	SORLCUR	SORLCUR_KEY_SEQNO
START_DATE	The date the curriculum starts.	DATE	SORLCUR	SORLCUR_START_DATE
STUDENT_LEVEL	Curriculum Level	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: 8.1