Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame associated with this application requirement record.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVACYR	STVACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER(2)	SORLCUR	SORLCUR_KEY_SEQNO
APPLICATION_PRIORITY_NO	Identifies the significanct ranking for a curricula.	NUMBER(4)	SORLCUR	SORLCUR_PRIORITY_NO
APPLICATION_SEQNO	Sequence number of the source key record.	NUMBER(4)	SORLCUR	SORLCUR_SEQNO
COLLEGE	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(2)	SORLCUR	SORLCUR_COLL_CODE
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC
CONCENTRATION	Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
DEGREE	Degree or award code associated with the academic study.	VARCHAR2(6)	SORLCUR	SORLCUR_DEGC_CODE
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(30)	STVDEGC	STVDEGC_DESC
DEPARTMENT	Department responsible to verify that academic outcome requirements are completed.	VARCHAR2(4)	SORLFOS	SORLFOS_DEPT_CODE
DEPARTMENT_DESC	Department name.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC
LOAD_DATE	Date information was last updated in ODS	DATE	NA	SYSDATE
MAJOR	First subject area or major focus recorded for the student's curriculum. This may not be blank.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
MAJOR_DESC	Name of the student's major subject area.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	SORLCUR	SORLCUR_PIDM
PROGRAM	Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.	VARCHAR2(12)	SORLCUR	SORLCUR_PROGRAM
PROGRAM_DESC	Program or course of study description.	VARCHAR2(30)	SMRPRLE	SMRPRLE_PROGRAM_DESC
ROWN	Row Number	NUMBER	NA	ROWNUM
SECOND_DEPARTMENT	Department responsible to verify that academic outcome requirements are completed.	VARCHAR2(4)	SORLFOS	SORLFOS_DEPT_CODE
SECOND_DEPARTMENT_DESC	Department name.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC
SECOND_MAJOR	Second subject area or major focus recorded for the student's curriculum.	VARCHAR2(4)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_DESC	Name of the student's second major subject area.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
STUDENT_LEVEL	Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.	VARCHAR2(2)	SORLCUR	SORLCUR_LEVL_CODE
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(30)	STVLEVL	STVLEVL_DESC

Ver: