Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period or time frame associated with the student's courses granted transfer credit.	VARCHAR2(6)		SHRTRCE	SHRTRCE_TERM_CODE_EFF
ACADEMIC_PERIOD_DESC		Academic period description.	VARCHAR2(30)		STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(4)		STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC		Academic year description.	VARCHAR2(30)		STVACYR	STVACYR_DESC
CAMPUS_RESTRICT_OVERRIDE_IND	Campus Restrict Override Indicator		VARCHAR2(1)
CAPACITY_OVERRIDE_IND	Capacity Override Indicator		VARCHAR2(1)
CHARGES_WAIVED_IND	Charges Waived Indicator		VARCHAR2(1)
CLASS_RESTRICT_OVERRIDE_IND	Class Restrict Override Indicator		VARCHAR2(1)
COLLEGE_RESTRICT_OVERRIDE_IND	College Restrict Override Indicator		VARCHAR2(1)
COREQUISITE_OVERRIDE_IND	Corequisite Override Indicator		VARCHAR2(1)
COUNT_IN_GPA_IND		Indicates whether this course should be used in the calculation of the GPA.	VARCHAR2(1)		SHRTRCE	SHRTRCE_COUNT_IN_GPA_IND
COURSE_ATTEMPTED_IND	Course Attempted Indicator		VARCHAR2(1)
COURSE_BILLING_CREDITS		Billing units associated with this section or schedule offering.	NUMBER		NA	NA
COURSE_BILLING_HOLD		Identifies the number of billing units that are being held for potential reinstatement. Not valid for transfer courses.	NUMBER		NA	NA
COURSE_CAMPUS		Campus the student attended this schedule offering or section.	VARCHAR2(63)		NA	NA
COURSE_CAMPUS_DESC		Institution campus description.	VARCHAR2(255)		NA	NA
COURSE_COLLEGE		College, faculty or school provide this section instruction.	VARCHAR2(2)		SCBCRSE	SCBCRSE_COLL_CODE
COURSE_COLLEGE_DESC		College description.	VARCHAR2(30)		STVCOLL	STVCOLL_DESC
COURSE_CREDITS		Credits associated with this course.	NUMBER(7, 3)		SHRTRCE	SHRTRCE_CREDIT_HOURS
COURSE_CREDITS_HOLD		Identifies the number of credits that are being held for potential reinstatement.	NUMBER		NA	NA
COURSE_DEPARTMENT		Department providing this instruction.	VARCHAR2(4)		SCBCRSE	SCBCRSE_DEPT_CODE
COURSE_DEPARTMENT_DESC		Department providing this instruction.	VARCHAR2(30)		STVDEPT	STVDEPT_DESC
COURSE_DIVISION		Division providing this instruction.	VARCHAR2(4)		SCBCRSE	SCBCRSE_DIVS_CODE
COURSE_DIVISION_DESC		Division description.	VARCHAR2(30)		STVDIVS	STVDIVS_DESC
COURSE_EARNED_IND	Course Earned Indicator		VARCHAR2(1)
COURSE_FAILED_IND	Course Failed Indicator		CHAR(1)
COURSE_IDENTIFICATION		Combined subject code and course number that identifies the instructional content of this course.	VARCHAR2(9)
COURSE_LEVEL		Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.	VARCHAR2(2)		SHRTRCE	SHRTRCE_LEVL_CODE
COURSE_LEVEL_DESC		Course level description.	VARCHAR2(30)		STVLEVL	STVLEVL_DESC
COURSE_NUMBER		Course number associated with the subject for the course.	VARCHAR2(5)		SHRTRCE	SHRTRCE_CRSE_NUMB
COURSE_PASSED_IND	Course Passed Indicator		VARCHAR2(1)
COURSE_REFERENCE_NUMBER		Unique number used to identify the transfer course.	VARCHAR2(51)		CALCULATION NA	SHRTRCE_TRIT_SEQ_NO||TO_CHAR(SHRTRCE_TRAM_SEQ_NO,'FM09')||TO_CHAR(NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009')||TO_CHAR(SHRTRCE_SEQ_NO,'FM009') NA
COURSE_REGISTER_IND	Course Register Indicator		VARCHAR2(1)
COURSE_SECTION_NUMBER		Sequence number used to associated the information about the unique course for the student.	VARCHAR2(40)		SHRTRCE	SHRTRCE_SEQ_NO
COURSE_SEQ_NO		Sequence number used to associated the information about the unique course for the student.	NUMBER(3)		SHRTRCE	SHRTRCE_SEQ_NO
COURSE_TITLE_LONG		Long title for the course.	VARCHAR2(255)		NA	NA
COURSE_TITLE_SHORT		Short title for the course.	VARCHAR2(30)		SHRTRCE	SHRTRCE_CRSE_TITLE
COURSE_VERSION_NO		Course version number.	VARCHAR2(255)		NA	NA
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		NA	NA
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		NA	NA
CREDITS_FOR_GPA		Credits used in the calculation of the average or GPA based on the rules of the institution.	NUMBER		NA	NA
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		NA	NA
CREDIT_FOR_GPA_IND	Credit For GPA - Grade Point Average or Average Indicator		VARCHAR2(1)
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DEGREE_RESTRICT_OVERRIDE_IND	Degree Restrict Override Indicator		VARCHAR2(1)
DEPARTMENT_RESTRICT_OVER_IND	Department Restrict Over Indicator		VARCHAR2(1)
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
DUPLICATE_COURSE_OVERRIDE_IND	Duplicate Course Override Indicator		VARCHAR2(1)
EFF_ACADEMIC_PERIOD_OF_GRADE		Earliest academic period for which grade is used.	VARCHAR2(6)		NA	NA
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		NA	NA
EXTENSIONS		Number of extensions granted to an open learning student to complete the instruction.	NUMBER		NA	NA
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		NA	NA
FINAL_GRADE		Final grade earned by the student for this course.	VARCHAR2(6)		SHRTRCE	SHRTRCE_GRDE_CODE
FINAL_GRADE_DATE		Date associated with this grade.	DATE		NA	NA
FINAL_GRADE_ROLL_IND		Indicates whether the final grade has been rolled to the history tables where applicable.	VARCHAR2(1)		NA	NA
GRADABLE_IND		Indicates whether the course can be graded.	VARCHAR2(1)		NA	NA
GRADE_CHANGE_REASON		Institution defined grade change reason associated with this grade for this course.	VARCHAR2(63)		NA	NA
GRADE_CHANGE_REASON_DESC		Grade change reason description.	VARCHAR2(255)		NA	NA
GRADE_COMMENT	Grade Comment		VARCHAR2(63)
GRADE_COMMENT_DESC	Grade Comment Description		VARCHAR2(255)
GRADE_TYPE		Grade mode associated with this COURSE REFERENCE NUMBER.	VARCHAR2(1)		NA	NA
GRADE_TYPE_DESC		Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code.	VARCHAR2(30)		NA	NA
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		NA	NA
HOURS_ATTENDED		Number of hours the student attended this class.	NUMBER		NA	NA
INCOMPLETE_EXT_DATE		Specifies the date at which the extension for the course becomes an incomplete grade.	DATE		NA	NA
INCOMPLETE_GRADE_IND	Incomplete Grade Indicator		VARCHAR2(1)
INSTITUTION_COURSE_IND		Indicates whether the subject or course was taken at this institution.	VARCHAR2(1)		CONSTANT	'N'
INSTRUCTION_METHOD		Instructional method used for the section.	VARCHAR2(63)		NA	NA
INSTRUCTION_METHOD_DESC		Instructional method description for the section.	VARCHAR2(255)		NA	NA
INTEGRATION_PARTNER	Integration Partner	Institution defined integration code that identifies an external partner used for instruction of this schedule offering.	VARCHAR2(63)		SSBSECT	SSBSECT_INTG_CDE
INTEGRATION_PARTNER_DESC	Integration Partner Description	Instruction integration partner description.	VARCHAR2(255)		GORINTG	GORINTG_DESC
INTEGRATION_PARTNER_SYSTEM	Integration Partner System	Institution defined integration system code that identifies an external partner systen used for instruction of this schedule offering.	VARCHAR2(63)		GORINTG	GORINTG_INTP_CODE
INTEGRATION_PARTNER_SYS_DESC	Integration Partner System Description	Instruction integration partner system description.	VARCHAR2(255)		GORINTG	GTVINTP_DESC
IN_PROGRESS_COURSE_IND		Indicates whether the course is in progress and not yet graded.	VARCHAR2(1)		CONSTANT	'N'
LAST_ATTEND_DATE		Identifies the date on which the instruction ended.	DATE		NA	NA
LAST_DATE_ATTEND_REQUIRED_IND	Last Date Attend Required Indicator		VARCHAR2(1)
LEVEL_RESTRICT_OVERRIDE_IND	Level Restrict Override Indicator		VARCHAR2(1)
LINK_OVERRIDE_IND	Link Override Indicator		VARCHAR2(1)
MAJOR_RESTRICT_OVERRIDE_IND	Major Restrict Override Indicator		VARCHAR2(1)
MID_TERM_GRADE		Mid-term grade code associated with this COURSE REFERENCE NUMBER.	VARCHAR2(63)		NA	NA
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
MUTUTAL_EXCLUSION_OVERRIDE_IND	Mututal Exclusion Override Indicator		VARCHAR2(1)
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		SHRTRCE	SHRTRCE_PIDM
PREREQUISITE_OVERRIDE_IND	Prerequisite Override Indicator		VARCHAR2(1)
PROGRAM_RESTRICT_OVERRIDE_IND	Program Restrict Override Indicator		VARCHAR2(1)
QUALITY_POINTS		Quality points associated with the grade.	NUMBER		NA	NA
REGISTER_CENSUS_DATE1_IND	Register Census Date 1 Indicator		VARCHAR2(1)
REGISTER_CENSUS_DATE2_IND	Register Census Date 2 Indicator		VARCHAR2(1)
REGISTRATION_ERROR_FLAG		Indicates an error is associated with the registration of this COURSE REFERENCE NUMBER.	VARCHAR2(1)		NA	NA
REGISTRATION_OVERRIDE_IND	Registration Override Indicator		VARCHAR2(1)
REGISTRATION_SEQUENCE_NUMBER		Registration sequence number.	NUMBER		NA	NA
REGISTRATION_STATUS		Course registration status associated with this COURSE REFERENCE NUMBER.	VARCHAR2(63)		NA	NA
REGISTRATION_STATUS_DATE		Date associated with the course registration status of this COURSE REFERENCE NUMBER.	DATE		NA	NA
REGISTRATION_STATUS_DESC		Course registration status description associated with the code.	VARCHAR2(255)		NA	NA
REGISTRATION_USER_ID		User identification number of the person who entered the registration request.	VARCHAR2(63)		NA	NA
REPEAT_COURSE_CREDIT_OVER_IND	Repeat Course Credit Over Indicator		VARCHAR2(1)
REPEAT_COURSE_IND		Repeat Course Indicator. Indicates whether the course was taken as a repeat course by the student.	VARCHAR2(1)		NA	NA
REPEAT_COURSE_OVERRIDE_IND	Repeat Course Override Indicator		VARCHAR2(1)
REPEAT_EVALUATE_IND	Repeat Evaluate Indicator		VARCHAR2(1)
SCHEDULE_TYPE		Instructional type associated with the course.	VARCHAR2(63)		NA	NA
SCHEDULE_TYPE_DESC		Instructional type description associated with the course.	VARCHAR2(255)		NA	NA
SECTION_ADD_DATE		Add date when the student registered in this COURSE REFERENCE NUMBER.	DATE		NA	NA
SPECIAL_APPROVAL_IND		Indicates whether special approval has been received for this COURSE REFERENCE NUMBER.	VARCHAR2(1)		NA	NA
SPECIAL_APPROVAL_OVERRIDE_IND	Special Approval Override Indicator		VARCHAR2(1)
START_DATE		Date the instruction for this course began for this student.	DATE		NA	NA
STUDENT_ATTRIBUTE_OVERRIDE_IND	Student Attribute Override Indicator		VARCHAR2(1)
STUDENT_COHORT_OVERRIDE_IND	Student Cohort Override Indicator		VARCHAR2(1)
STUDY_PATH_SEQUENCE	Study Path Sequence		NUMBER
SUBJECT		Main instructional subject area for this course.	VARCHAR2(4)		SHRTRCE	SHRTRCE_SUBJ_CODE
SUBJECT_DESC		Subject code description.	VARCHAR2(30)		STVSUBJ	STVSUBJ_DESC
SUB_ACADEMIC_PERIOD		A session, portion or part of the academic period.	VARCHAR2(63)		NA	NA
SUB_ACADEMIC_PERIOD_DESC		Sub academic period description.	VARCHAR2(255)		NA	NA
TEST_SCORE_OVERRIDE_IND	Test Score Override Indicator		VARCHAR2(1)
TIME_CONFLICT_OVERRIDE_IND	Time Conflict Override Indicator		VARCHAR2(1)
TRADITIONAL_IND		Indicates whether this grade symbol is considered a traditional type of grade.	VARCHAR2(1)		NA	NA
TRANSFER_COURSE_IND		Indicates whether this course was taken at and transferred from another post secondary institution. This is yes when this is a transfer course.	VARCHAR2(1)		CONSTANT	'Y'
TRANSFER_COURSE_INSTITUTION		Identifies the post secondary institution where the transfer course was taken.	VARCHAR2(6)		SHRTRIT	SHRTRIT_SBGI_CODE
TRANSFER_COURSE_INST_DESC		Name of the post secondary transfer institution.	VARCHAR2(30)		STVSBGI	STVSBGI_DESC
TRANSFER_COURSE_INST_SEQ_NO		Specifies the sequence number for the institution where the course was transferred.	NUMBER(2)		SHRTRIT	SHRTRIT_SEQ_NO
WAITLIST_IND	Waitlist Indicator		VARCHAR2(1)
WITHDRAWN_IND	Withdrawn Indicator		VARCHAR2(1)
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: