Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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(6)
|
SHRTCKN
|
SHRTCKN_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(4)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
CAMPUS_RESTRICT_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
CAPACITY_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
CHARGES_WAIVED_IND
|
|
CHAR(1)
|
|
|
|
NO
|
CLASS_RESTRICT_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
COLLEGE_RESTRICT_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
COREQUISITE_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
COUNT_IN_GPA_IND
|
Indicates whether this course should be used in the calculation of the GPA.
|
VARCHAR2(1)
|
SHRGRDE
|
SHRGRDE_GPA_IND
|
NO
|
NO
|
COURSE_ATTEMPTED_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
COURSE_BILLING_CREDITS
|
Billing units associated with this section or schedule offering.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_BILL_HR
|
NO
|
NO
|
COURSE_BILLING_HOLD
|
Identifies the number of billing units that are being held for potential reinstatement.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_BILL_HR_HOLD
|
NO
|
NO
|
COURSE_CAMPUS
|
Campus the student attended this schedule offering or section.
|
VARCHAR2(3)
|
SHRTCKN
|
SHRTCKN_CAMP_CODE
|
NO
|
NO
|
COURSE_CAMPUS_DESC
|
Institution campus description.
|
VARCHAR2(30)
|
STVCAMP
|
STVCAMP_DESC
|
NO
|
NO
|
COURSE_COLLEGE
|
College, faculty or school provide this section instruction.
|
VARCHAR2(2)
|
SHRTCKN
|
SHRTCKN_COLL_CODE
|
NO
|
NO
|
COURSE_COLLEGE_DESC
|
College description.
|
VARCHAR2(30)
|
STVCOLL
|
STVCOLL_DESC
|
NO
|
NO
|
COURSE_COMMENT
|
This field identifies the course comment.
|
VARCHAR2(255)
|
SHRTCKN
|
SHRTCKN_COURSE_COMMENT
|
NO
|
NO
|
COURSE_CREDITS
|
Credits associated with this course.
|
NUMBER
|
SHRTCKG
|
SHRTCKG_CREDIT_HOURS
|
NO
|
NO
|
COURSE_CREDITS_HOLD
|
Identifies the number of credits that are being held for potential reinstatement.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_BILL_HR_HOLD
|
NO
|
NO
|
COURSE_DEPARTMENT
|
Department providing this instruction.
|
VARCHAR2(4)
|
SHRTCKN
|
SHRTCKN_DEPT_CODE
|
NO
|
NO
|
COURSE_DEPARTMENT_DESC
|
Department providing this instruction.
|
VARCHAR2(30)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
COURSE_DIVISION
|
Division providing this instruction.
|
VARCHAR2(4)
|
SHRTCKN
|
SHRTCKN_DIVS_CODE
|
NO
|
NO
|
COURSE_DIVISION_DESC
|
Division description.
|
VARCHAR2(30)
|
STVDIVS
|
STVDIVS_DESC
|
NO
|
NO
|
COURSE_EARNED_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
COURSE_FAILED_IND
|
|
CHAR(1)
|
|
|
|
NO
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(9)
|
|
|
|
NO
|
COURSE_LEVEL
|
Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.
|
VARCHAR2(2)
|
SHRTCKL
|
SHRTCKL_LEVL_CODE
|
NO
|
NO
|
COURSE_LEVEL_DESC
|
Course level description.
|
VARCHAR2(30)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(5)
|
SHRTCKN
|
SHRTCKN_CRSE_NUMB
|
NO
|
NO
|
COURSE_PASSED_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(5)
|
SHRTCKN
|
SHRTCKN_CRN
|
NO
|
NO
|
COURSE_REGISTER_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
COURSE_SECTION_NUMBER
|
Sequence number used to associated the information about the unique course for the student.
|
VARCHAR2(3)
|
SHRTCKN
|
SHRTCKN_SEQ_NUMB
|
NO
|
NO
|
COURSE_SEQ_NO
|
Sequence number used to associated the information about the unique course for the student.
|
NUMBER
|
SHRTCKN
|
SHRTCKN_SEQ_NO
|
NO
|
NO
|
COURSE_TITLE_LONG
|
Long title for the course.
|
VARCHAR2(100)
|
SHRTCKN
|
SHRTCKN_LONG_COURSE_TITLE
|
NO
|
NO
|
COURSE_TITLE_SHORT
|
Short title for the course.
|
VARCHAR2(30)
|
SHRTCKN
|
SHRTCKN_CRSE_TITLE
|
NO
|
NO
|
COURSE_VERSION_NO
|
Course version number.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
CREDITS_ATTEMPTED
|
Credits attempted as defined by the grading rules of the institution. In-progress or transfer courses may be defined not to add to the credits attempted.
|
NUMBER
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_ATTEMPTED_IND,'Y',1,0)
|
NO
|
NO
|
CREDITS_EARNED
|
Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.
|
NUMBER
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_COMPLETED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)
|
NO
|
NO
|
CREDITS_FOR_GPA
|
Credits used in the calculation of the average or GPA based on the rules of the institution.
|
NUMBER
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_GPA_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0,1)
|
NO
|
NO
|
CREDITS_PASSED
|
Credits passed as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.
|
NUMBER
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_PASSED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)
|
NO
|
NO
|
CREDIT_FOR_GPA_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DEGREE_RESTRICT_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
DEPARTMENT_RESTRICT_OVER_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
DUPLICATE_COURSE_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
EFF_ACADEMIC_PERIOD_OF_GRADE
|
Earliest academic period for which grade is used.
|
VARCHAR2(6)
|
SHRGRDE
|
SHRGRDE_TERM_CODE_EFFECTIVE
|
NO
|
NO
|
END_DATE
|
Date on which the instruction ended. It is either stored specifically for the open learning student or taken from the end date on the offering.
|
DATE
|
CALCULATION
|
NVL(SHRTCKN_REG_COMPLETION_DATE,SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM,SHRTCKN_TERM_CODE,SHRTCKN_CRN,SHRTCKN_PTRM_CODE,'E'))
|
NO
|
NO
|
EXTENSIONS
|
Number of extensions granted to an open learning student to complete the instruction.
|
NUMBER
|
CALCULATION
|
NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS(SHRTCKN_PIDM,SHRTCKN_TERM_CODE,SHRTCKN_CRN))
|
NO
|
NO
|
FINALIZED_COMPLETION_DATE
|
Date a student completed their study for this subject or course. This might be the final completion date for an open learning course or it might be the end date from the sub academic period end date associated with a section.
|
DATE
|
FUNCTION
|
SOKODSF.F_GET_COURSE_DATES
|
NO
|
NO
|
FINAL_GRADE
|
Final grade earned by the student for this course.
|
VARCHAR2(6)
|
SHRTCKG
|
SHRTCKG_GRDE_CODE_FINAL
|
NO
|
NO
|
FINAL_GRADE_DATE
|
Date associated with this grade.
|
DATE
|
SHRTCKG
|
SHRTCKG_FINAL_GRDE_CHG_DATE
|
NO
|
NO
|
FINAL_GRADE_ROLL_IND
|
Indicates whether the final grade has been rolled to the history tables where applicable.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y')
|
NO
|
NO
|
GRADABLE_IND
|
Indicates whether the course can be graded.
|
VARCHAR2(1)
|
SSBSECT
|
SSBSECT_GRADABLE_IND
|
NO
|
NO
|
GRADE_CHANGE_REASON
|
Institution defined grade change reason associated with this grade for this course.
|
VARCHAR2(2)
|
SHRTCKG
|
SHRTCKG_GCHG_CODE
|
NO
|
NO
|
GRADE_CHANGE_REASON_DESC
|
Grade change reason description.
|
VARCHAR2(30)
|
STVGCHG
|
STVGCHG_DESC
|
NO
|
NO
|
GRADE_COMMENT
|
|
VARCHAR2(7)
|
|
|
|
NO
|
GRADE_COMMENT_DESC
|
|
VARCHAR2(200)
|
|
|
|
NO
|
GRADE_TYPE
|
Grade mode associated with this COURSE REFERENCE NUMBER.
|
VARCHAR2(1)
|
SHRTCKG
|
SHRTCKG_GMOD_CODE
|
NO
|
NO
|
GRADE_TYPE_DESC
|
Grade type description.
|
VARCHAR2(30)
|
STVGMOD
|
STVGMOD_DESC
|
NO
|
NO
|
GRADE_VALUE
|
Numeric value assigned to a grade symbol to be used to measure course performance statistics. This will only be present if a final grade has been recorded for either in progress or grades rolled to history for the student course.
|
NUMBER
|
SHRGRDE
|
SHRGRDE_NUMERIC_VALUE
|
NO
|
NO
|
HOURS_ATTENDED
|
Number of hours the student attended this class.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_ATTEND_HR
|
NO
|
NO
|
INCOMPLETE_EXT_DATE
|
Specifies the date at which the extension for the course becomes an incomplete grade.
|
DATE
|
SHRTCKG
|
SHRTCKG_INCOMPLETE_EXT_DATE
|
NO
|
NO
|
INCOMPLETE_GRADE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
INSTITUTION_COURSE_IND
|
Indicates whether the subject or course was taken at this institution and is in academic history.
|
VARCHAR2(1)
|
CONSTANT
|
'Y'
|
NO
|
NO
|
INSTRUCTION_METHOD
|
Instructional method associated with the course.
|
VARCHAR2(5)
|
STVSCHD
|
STVSCHD_INSM_CODE
|
NO
|
NO
|
INSTRUCTION_METHOD_DESC
|
Instructional method description associated with the course.
|
VARCHAR2(30)
|
GTVINSM
|
GTVINSM_DESC
|
NO
|
NO
|
INTEGRATION_PARTNER
|
Institution defined integration code that identifies an external partner used for instruction of this schedule offering.
|
VARCHAR2(5)
|
SSBSECT
|
SSBSECT_INTG_CDE
|
NO
|
NO
|
INTEGRATION_PARTNER_DESC
|
Instruction integration partner description.
|
VARCHAR2(30)
|
GORINTG
|
GORINTG_DESC
|
NO
|
NO
|
INTEGRATION_PARTNER_SYSTEM
|
Institution defined integration system code that identifies an external partner systen used for instruction of this schedule offering.
|
VARCHAR2(5)
|
GORINTG
|
GORINTG_INTP_CODE
|
NO
|
NO
|
INTEGRATION_PARTNER_SYS_DESC
|
Instruction integration partner system description.
|
VARCHAR2(30)
|
GORINTG
|
GTVINTP_DESC
|
NO
|
NO
|
IN_PROGRESS_COURSE_IND
|
Indicates whether the course is in progress and not yet graded.
|
VARCHAR2(1)
|
CONSTANT
|
'N'
|
NO
|
NO
|
LAST_ATTEND_DATE
|
Identifies the date on which the instruction ended.
|
DATE
|
SFRSTCR
|
SFRSTCR_LAST_ATTEND
|
NO
|
NO
|
LAST_DATE_ATTEND_REQUIRED_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
LEVEL_RESTRICT_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
LINK_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
MAJOR_RESTRICT_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
MID_TERM_GRADE
|
Mid-term grade code associated with this COURSE REFERENCE NUMBER.
|
VARCHAR2(6)
|
SFRSTCR
|
SFRSTCR_GRDE_CODE_MID
|
NO
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
MUTUTAL_EXCLUSION_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SHRTCKN
|
SHRTCKN_PIDM
|
NO
|
NO
|
PREREQUISITE_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
PROGRAM_RESTRICT_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
QUALITY_POINTS
|
Quality points associated with the grade.
|
NUMBER
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*SHRGRDE_QUALITY_POINTS*DECODE(SHRGRDE_GPA_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0,1)
|
NO
|
NO
|
REGISTER_CENSUS_DATE1_IND
|
|
CHAR(1)
|
|
|
|
NO
|
REGISTER_CENSUS_DATE2_IND
|
|
CHAR(1)
|
|
|
|
NO
|
REGISTRATION_ACT_DATE
|
This identifies the activity date of the registration request.
|
DATE
|
SFRSTCR
|
SFRSTCR_ACTIVITY_DATE
|
NO
|
NO
|
REGISTRATION_ERROR_FLAG
|
Indicates an error is associated with this section registration.
|
VARCHAR2(1)
|
SFRSTCR
|
SFRSTCR_ERROR_FLAG
|
NO
|
NO
|
REGISTRATION_OVERRIDE_IND
|
|
CHAR(1)
|
|
|
|
NO
|
REGISTRATION_SEQUENCE_NUMBER
|
Sequence number system assigned to the student registration in the section.
|
NUMBER
|
SHRTCKN
|
SHRTCKN_REG_SEQ
|
NO
|
NO
|
REGISTRATION_STATUS
|
Course registration status associated with this section.
|
VARCHAR2(2)
|
SFRSTCR
|
SFRSTCR_RSTS_CODE
|
NO
|
NO
|
REGISTRATION_STATUS_DATE
|
Date associated with the course registration status of this section.
|
DATE
|
SFRSTCR
|
SFRSTCR_RSTS_DATE
|
NO
|
NO
|
REGISTRATION_STATUS_DESC
|
Course registration status description.
|
VARCHAR2(30)
|
STVRSTS
|
STVRSTS_DESC
|
NO
|
NO
|
REGISTRATION_USER_ID
|
Person user identification number who processed the registration request for this section.
|
VARCHAR2(30)
|
SFRSTCR
|
SFRSTCR_USER
|
NO
|
NO
|
REPEAT_COURSE_CREDIT_OVER_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
REPEAT_COURSE_IND
|
Indicates whether this course was registered in more than one academic period by the student.
|
VARCHAR2(1)
|
SHRTCKN
|
SHRTCKN_REPEAT_COURSE_IND
|
NO
|
NO
|
REPEAT_COURSE_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
REPEAT_EVALUATE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
SCHEDULE_TYPE
|
Instructional method or delivery type associated with the course.
|
VARCHAR2(3)
|
SHRTCKN
|
SHRTCKN_SCHD_CODE
|
NO
|
NO
|
SCHEDULE_TYPE_DESC
|
Schedule type description.
|
VARCHAR2(30)
|
STVSCHD
|
STVSCHD_DESC
|
NO
|
NO
|
SECTION_ADD_DATE
|
Date the student registered in this section.
|
DATE
|
SFRSTCR
|
SFRSTCR_ADD_DATE
|
NO
|
NO
|
SPECIAL_APPROVAL_IND
|
Indicates whether special approval was received to register in this section.
|
VARCHAR2(1)
|
SFRSTCR
|
SFRSTCR_APPR_RECEIVED_IND
|
NO
|
NO
|
SPECIAL_APPROVAL_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
START_DATE
|
Date the instruction for this course began for this student.
|
DATE
|
FUNCTION
|
SOKODSF.F_GET_COURSE_DATES
|
NO
|
NO
|
STUDENT_ATTRIBUTE_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
STUDENT_COHORT_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
STUDY_PATH_SEQUENCE
|
|
NUMBER
|
|
|
|
NO
|
SUBJECT
|
Main instructional subject area for this course.
|
VARCHAR2(4)
|
SHRTCKN
|
SHRTCKN_SUBJ_CODE
|
NO
|
NO
|
SUBJECT_DESC
|
Subject code description.
|
VARCHAR2(30)
|
STVSUBJ
|
STVSUBJ_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(3)
|
SHRTCKN
|
SHRTCKN_PTRM_CODE
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(30)
|
STVPTRM
|
STVPTRM_DESC
|
NO
|
NO
|
TEST_SCORE_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
TIME_CONFLICT_OVERRIDE_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
TRADITIONAL_IND
|
Indicates whether this grade symbol is considered a traditional type of grade.
|
VARCHAR2(1)
|
NA
|
NA
|
NO
|
NO
|
TRANSFER_COURSE_IND
|
Indicates whether this course was taken at and transferred from another post secondary institution. This is no when this is an institutional history course.
|
VARCHAR2(1)
|
CONSTANT
|
'N'
|
NO
|
NO
|
TRANSFER_COURSE_INSTITUTION
|
Identifies the post secondary institution where the transfer course was taken.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
TRANSFER_COURSE_INST_DESC
|
Name of the post secondary transfer institution.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
TRANSFER_COURSE_INST_SEQ_NO
|
Specifies the sequence number for the institution where the course was transferred.
|
NUMBER
|
NA
|
NA
|
NO
|
NO
|
WAITLIST_AVAILABLE
|
It displays a running total of remaining available waitlist seats by subtracting the waitlist actual enrollment from the maximum waitlist enrollment for the section.
|
NUMBER
|
SSBSECT
|
SSBSECT_WAIT_AVAIL
|
NO
|
NO
|
WAITLIST_CAPACITY
|
This field stores the maximum waitlist enrollment for a section.
|
NUMBER
|
SSBSECT
|
SSBSECT_WAIT_CAPACITY
|
NO
|
NO
|
WAITLIST_COUNT
|
It displays a running total of enrollments in the section which have course status with a waitlist flag set to Y on the Registration Status Code Validation Form - STVRSTS.
|
NUMBER
|
SSBSECT
|
SSBSECT_WAIT_COUNT
|
NO
|
NO
|
WAITLIST_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
WAITLIST_PRIORITY
|
This field indicates the Waitlist priority.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_WL_PRIORITY
|
NO
|
NO
|
WAITLIST_PRIORITY_ORIG
|
This field indicates the waitlist priority origin. Valid values are S-system originated, M-manually originated.
|
VARCHAR2(1)
|
SFRSTCR
|
SFRSTCR_WL_PRIORITY_ORIG
|
NO
|
NO
|
WITHDRAWN_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|