Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic Period
|
Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_TERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic Period description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_YEAR
|
Academic Year.
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
BLOCK_REGISTRATION
|
Block Registration
|
Identifies the block registration code that was assigned to the student that had the student register for this student course.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_BLCK_CODE
|
BLOCK_REGISTRATION_DESC
|
Block Registration Description
|
Description for the block registration code.
|
VARCHAR2(255)
|
STVBLCK
|
STVBLCK_DESC
|
BLOCK_REG_SEQUENCE_NUMBER
|
Block Registration Sequence Number
|
Sequence number that uniquely identifies the rule for block assignment.
|
NUMBER
|
SFRSTCA
|
SFRSTCA_BRDH_SEQ_NUM
|
COLLEGE
|
College
|
First level of the institution organization structure that owns the student or the academic instruction for a student course.
|
VARCHAR2(63)
|
SCBCRSE SSBOVRR
|
SCBCRSE_COLL_CODE SSBOVRR_COLL_CODE
|
COLLEGE_DESC
|
College description
|
College, faculty or school name.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
COURSE_BILLING_CREDITS
|
Course Billing Credits
|
Billing units associated with this section or schedule offering.
|
NUMBER
|
SFRSTCA
|
SFRSTCA_BILL_HR
|
COURSE_CAMPUS
|
Course Campus
|
Campus the student attended this schedule offering or section.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_CAMP_CODE
|
COURSE_CAMPUS_DESC
|
Course Campus description
|
Institution campus description.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
COURSE_CREDITS
|
Course Credits
|
Credits associated with this course.
|
NUMBER
|
SFRSTCA
|
SFRSTCA_CREDIT_HR
|
COURSE_IDENTIFICATION
|
Course Identification
|
Course subject and course number combined.
|
VARCHAR2(255)
|
CALCULATION
|
SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB
|
COURSE_LEVEL
|
Course Level Code
|
Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_LEVL_CODE
|
COURSE_LEVEL_DESC
|
Course Level description
|
Course level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
COURSE_NUMBER
|
Course Number
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_CRSE_NUMB
|
COURSE_REFERENCE_NUMBER
|
Course Reference Number
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_CRN
|
COURSE_SECTION_NUMBER
|
Course Section
|
Sequence number used to associated the information about the unique course for the student.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SEQ_NUMB
|
COURSE_VERSION_NUMBER
|
Course Version Number
|
Course version number.
|
VARCHAR2(255)
|
NA
|
NA
|
DEPARTMENT
|
Department Code
|
Department responsible for the major subject area of a student course or associated with the major within the student academic study.
|
VARCHAR2(63)
|
SCBCRSE SSBOVRR
|
SCBCRSE_DEPT_CODE SSBOVRR_DEPT_CODE
|
DEPARTMENT_DESC
|
Department description
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
DIVISION
|
Division
|
Division responsible for the instructional delivery of this course or section.
|
VARCHAR2(63)
|
SCBCRSE SSBOVRR
|
SCBCRSE_DIVS_CODE SSBOVRR_DIVS_CODE
|
DIVISION_DESC
|
Division description
|
Name of the division.
|
VARCHAR2(255)
|
STVDIVS
|
STVDIVS_DESC
|
GRADE_COMMENT
|
Grade Comment
|
Value for the grade comment or result code added for this course.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_GCMT_CODE
|
GRADE_COMMENT_DESC
|
Grade Comment description
|
Grade comment descriptive text.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
GRADE_TYPE
|
Grade Type
|
Grade mode associated with this section or offering of the course.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_GMOD_CODE
|
GRADE_TYPE_DESC
|
Grade Type description
|
Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
LAST_DATE_CHANGE
|
Last Change Date
|
Date this record was last added or changed.
|
DATE
|
SFRSTCA
|
SFRSTCA_ACTIVITY_DATE
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NAME
|
Name
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PERSON_UID
|
Person_Uid
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SFRSTCA
|
SFRSTCA_PIDM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
REGISTRATION_ERROR_FLAG
|
Registration Error Flag
|
Indicates an error is associated with this section registration.
|
VARCHAR2(1)
|
SFRSTCA
|
SFRSTCA_ERROR_FLAG
|
REGISTRATION_ERROR_MESSAGE
|
Registration Error Message
|
Text of the message associated with an error for this section registration.
|
VARCHAR2(255)
|
SFRSTCA
|
SFRSTCA_MESSAGE
|
REGISTRATION_SOURCE
|
Registration Source
|
Identifies the source of the audit record as either temporary or base from the registration input form.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_SOURCE_CDE
|
REGISTRATION_STATUS
|
Registration Status
|
Course registration status associated with this section.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_RSTS_CODE
|
REGISTRATION_STATUS_DATE
|
Registration Status Date
|
Date associated with the course registration status of this section.
|
DATE
|
SFRSTCA
|
SFRSTCA_RSTS_DATE
|
REGISTRATION_STATUS_DESC
|
Registration Status description
|
Course registration status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
REGISTRATION_USER_ID
|
Registration User ID
|
Person user identification number who processed the registration request for this section.
|
VARCHAR2(63)
|
SFRSTCA
|
SFRSTCA_USER
|
SECTION_ADD_DATE
|
Section Add Date
|
Date the student registered in this section.
|
DATE
|
SFRSTCA
|
SFRSTCA_ADD_DATE
|
SEQUENCE_NUMBER
|
Sequence Number
|
Sequence number for the records for the course reference number for this student in this academic period.
|
NUMBER
|
SFRSTCA
|
SFRSTCA_SEQ_NUMBER
|
SUBJECT
|
Subject
|
Main instructional subject area for this course.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SUBJ_CODE
|
SUBJECT_DESC
|
Subject description
|
Subject code description.
|
VARCHAR2(255)
|
STVSUBJ
|
STVSUBJ_DESC
|
SUB_ACADEMIC_PERIOD
|
Sub Academic Period
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period description
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|