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(24)	SORLCUR	SORLCUR_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(120)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(16)	STVACYR	STVACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(120)	STVACYR	STVACYR_DESC
ADM_COLLEGE	Admitted College, faculty or school to which the academic study for the student is associated.	VARCHAR2(252)	SORLCUR	SORLCUR_COLL_CODE
ADM_COLLEGE_DESC	Admitted College, faculty or school name.	VARCHAR2(1020)	STVCOLL	STVCOLL_DESC
ADM_CONCENTRATION	Admitted Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(252)	SORLFOS	SORLFOS_MAJR_CODE
ADM_CONCENTRATION_DESC	Admitted Concentration or study emphasis description.	VARCHAR2(1020)	STVMAJR	STVMAJR_DESC
ADM_DEGREE	Admitted Degree or award code associated with the academic study.	VARCHAR2(252)	SORLCUR	SORLCUR_DEGC_CODE
ADM_DEGREE_DESC	Admitted Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(1020)	STVDEGC	STVDEGC_DESC
ADM_DEPARTMENT	Admitted Department responsible to verify that academic outcome requirements are completed.	VARCHAR2(252)	SORLFOS	SORLFOS_DEPT_CODE
ADM_DEPARTMENT_DESC	Admitted Department name.	VARCHAR2(1020)	STVDEPT	STVDEPT_DESC
ADM_MAJOR	Admitted First subject area or major focus recorded for the student's curriculum. This may not be blank.	VARCHAR2(252)	SORLFOS	SORLFOS_MAJR_CODE
ADM_MAJOR_DESC	Admitted Name of the student's major subject area.	VARCHAR2(1020)	STVMAJR	STVMAJR_DESC
ADM_PROGRAM	Admitted 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(252)	SORLCUR	SORLCUR_PROGRAM
ADM_PROGRAM_DESC		VARCHAR2(1020)
ADM_SECOND_DEPARTMENT	Admitted Department responsible to verify that academic outcome requirements are completed.	VARCHAR2(252)	SORLFOS	SORLFOS_DEPT_CODE
ADM_SECOND_DEPARTMENT_DESC	Admitted Department name.	VARCHAR2(1020)	STVDEPT	STVDEPT_DESC
ADM_SECOND_MAJOR	Admitted Second subject area or major focus recorded for the student's curriculum.	VARCHAR2(252)	SORLFOS	SORLFOS_MAJR_CODE
ADM_SECOND_MAJOR_DESC	Admitted Name of the student's second major subject area.	VARCHAR2(1020)	STVMAJR	STVMAJR_DESC
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	SORLCUR	SORLCUR_KEY_SEQNO
APPLICATION_PRIORITY_NO	Identifies the significant ranking for a curricula.	NUMBER	SORLCUR	SORLCUR_PRIORITY_NO
APPLICATION_SEQNO	Sequence number of the source key record.	NUMBER	SORLCUR	SORLCUR_SEQNO
APP_COLLEGE	Applied to College, faculty or school to which the academic study for the student is associated	VARCHAR2(8)	SORLCUR	SORLCUR_COLL_CODE
APP_COLLEGE_DESC	Applied to College, faculty or school name.	VARCHAR2(120)	STVCOLL	STVCOLL_DESC
APP_CONCENTRATION	Applied to Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(16)	SORLFOS	SORLFOS_MAJR_CODE
APP_CONCENTRATION_DESC	Applied to Concentration or study emphasis description.	VARCHAR2(120)	STVMAJR	STVMAJR_DESC
APP_DEGREE	Applied to Degree or award code associated with the academic study.	VARCHAR2(24)	SORLCUR	SORLCUR_DEGC_CODE
APP_DEGREE_DESC	Applied to Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(120)	STVDEGC	STVDEGC_DESC
APP_DEPARTMENT	Applied to Department responsible to verify that academic outcome requirements are completed.	VARCHAR2(16)	SORLFOS	SORLFOS_DEPT_CODE
APP_DEPARTMENT_DESC	Applied to Department name	VARCHAR2(120)	STVDEPT	STVDEPT_DESC
APP_MAJOR	Applied to First subject area or major focus recorded for the student's curriculum. This may not be blank.	VARCHAR2(16)	SORLFOS	SORLFOS_MAJR_CODE
APP_MAJOR_DESC	Applied to Name of the student's major subject area.	VARCHAR2(120)	STVMAJR	STVMAJR_DESC
APP_PROGRAM	Applied to 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(48)	SORLCUR	SORLCUR_PROGRAM
APP_PROGRAM_DESC	Applied to Program or course of study description.	VARCHAR2(120)	SMRPRLE	SMRPRLE_PROGRAM_DESC
APP_SECOND_DEPARTMENT	Applied to Second Department responsible to verify that academic outcome requirements are completed.	VARCHAR2(16)	SORLFOS	SORLFOS_DEPT_CODE
APP_SECOND_DEPARTMENT_DESC	Applied to Second Department name.	VARCHAR2(120)	STVDEPT	STVDEPT_DESC
APP_SECOND_MAJOR	Applied to Second subject area or major focus recorded for the student's curriculum.	VARCHAR2(16)	SORLFOS	SORLFOS_MAJR_CODE
APP_SECOND_MAJOR_DESC	Applied to Name of the student's second major subject area.	VARCHAR2(120)	STVMAJR	STVMAJR_DESC
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORLCUR	SORLCUR_PIDM
STUDENT_LEVEL	Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.	VARCHAR2(8)	SORLCUR	SORLCUR_LEVL_CODE
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(120)	STVLEVL	STVLEVL_DESC

Ver: 8.4.1