Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ACADEMIC_PERIOD_END
|
|
Ending academic period or time frame for the course to apply at this level.
|
VARCHAR2(6)
|
|
FUNCTION
|
SOKODSF.F_GET_END_SCRLEVL_TERM
|
ACADEMIC_PERIOD_END_DESC
|
|
Academic period description.
|
VARCHAR2(30)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_PERIOD_START
|
|
Academic period or time frame when the course levels are available for sections of this course.
|
VARCHAR2(6)
|
|
SCRLEVL
|
SCRLEVL_EFF_TERM
|
ACADEMIC_PERIOD_START_DESC
|
|
Academic period description.
|
VARCHAR2(30)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_YEAR
|
|
Academic year associated with the academic period on this record.
|
VARCHAR2(0)
|
|
STVTERM
|
STVTERM_ACYR_CODE
|
ACADEMIC_YEAR_DESC
|
|
Academic year description.
|
VARCHAR2(0)
|
|
NA
|
NA
|
COURSE_IDENTIFICATION
|
|
Combined subject code and course number that identifies the instructional content of this course.
|
VARCHAR2(9)
|
|
CALCULATION
|
SCRLEVL_SUBJ_CODE||SCRLEVL_CRSE_NUMB
|
COURSE_LEVEL
|
|
Authorized level of credit for which this course may be offered. Each course must be offered for at least one level. Course can be authorized for an unlimited number of levels.
|
VARCHAR2(2)
|
|
SCRLEVL
|
SCRLEVL_LEVL_CODE
|
COURSE_NUMBER
|
|
Course number associated with the subject for the course.
|
VARCHAR2(5)
|
|
SCRLEVL
|
SCRLEVL_CRSE_NUMB
|
CURRENT_DATE
|
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
|
NA
|
SYSDATE
|
DOMAIN_VALUE
|
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
|
NA
|
NA
|
LEVEL_DESC
|
|
Student level (e.g., undergraduate, graduate, professional) associated with the student level code.
|
VARCHAR2(30)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
MIF_DESC
|
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
|
NA
|
NA
|
MIF_VALUE
|
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
|
NA
|
NA
|
SUBJECT
|
|
Main instructional subject area for this course.
|
VARCHAR2(4)
|
|
SCRLEVL
|
SCRLEVL_SUBJ_CODE
|
SUBJECT_DESC
|
|
Subject code description.
|
VARCHAR2(30)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
SUB_ACADEMIC_PERIOD
|
|
A session, portion or part of the academic period.
|
VARCHAR2(0)
|
|
NA
|
NA
|
SUB_ACADEMIC_PERIOD_DESC
|
|
Sub academic period description.
|
VARCHAR2(0)
|
|
NA
|
NA
|
ZONE_VALUE
|
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
|
NA
|
NA
|