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
|
APPLICATION_NUMBER
|
Applied to Application number for the admission application record for a specific academic period.
|
NUMBER
|
SORLCUR
|
SORLCUR_KEY_SEQNO
|
APPLICATION_PRIORITY_NO
|
Identifies the significanct ranking for a curricula.
|
NUMBER
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
APPLICATION_SEQNO
|
Applied to Sequence number of the source key record.
|
NUMBER
|
SORLCUR
|
SORLCUR_SEQNO
|
COLLEGE
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(8)
|
SORLCUR
|
SORLCUR_COLL_CODE
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(120)
|
STVCOLL
|
STVCOLL_DESC
|
DEGREE
|
Degree or award code associated with the academic study.
|
VARCHAR2(24)
|
SORLCUR
|
SORLCUR_DEGC_CODE
|
DEGREE_DESC
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(120)
|
STVDEGC
|
STVDEGC_DESC
|
DEPARTMENT
|
Department responsible to verify that academic outcome requirements are completed.
|
VARCHAR2(16)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(120)
|
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(16)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
MAJOR_DESC
|
Name of the student's major subject area.
|
VARCHAR2(120)
|
STVMAJR
|
STVMAJR_DESC
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
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(48)
|
SORLCUR
|
SORLCUR_PROGRAM
|
PROGRAM_DESC
|
Program or course of study description.
|
VARCHAR2(120)
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
SECOND_DEPARTMENT
|
Department responsible to verify that academic outcome requirements are completed.
|
VARCHAR2(16)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
SECOND_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(120)
|
STVDEPT
|
STVDEPT_DESC
|
SECOND_MAJOR
|
Second subject area or major focus recorded for the student's curriculum.
|
VARCHAR2(16)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
SECOND_MAJOR_DESC
|
Name of the student's second major subject area.
|
VARCHAR2(120)
|
STVMAJR
|
STVMAJR_DESC
|
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
|