Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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
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		Curriculum Campus	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		Curriculum College	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(4)		SORLCUR	SORLCUR_PRIORITY_NO
CURRICULUM_SEQUENCE		System generated one-up number assigned to a student or learner for a curriculum or curriculum changes.	NUMBER(4)		SORLCUR	SORLCUR_SEQNO
DEGREE		Curriculum Degree .	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		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
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	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		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
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	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(8)		SORLCUR	SORLCUR_PIDM
PROGRAM		Curriculum Program	VARCHAR2(12)		SORLCUR	SORLCUR_PROGRAM
PROGRAM_CLASSIFICATION	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
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		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	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	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	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	Site Street Line 1	First line of the site address.	VARCHAR2(255)		STVSITE	STVSITE_STREET_ADDR1
SITE_STREET_LINE2	Site Street Line 2	Second line of the site address.	VARCHAR2(255)		STVSITE	STVSITE_STREET_ADDR2
SITE_STREET_LINE3	Site Street Line 3	Third line of the site address.	VARCHAR2(255)		STVSITE	STVSITE_STREET_ADDR3
SITE_STREET_LINE4	Site Street Line 4	Fourth line of the site address.	VARCHAR2(255)		NA	NA
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
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		This field identifies the type of student the applicant will become if admitted.	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	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	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	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: