Composite View Target: AS_COURSE_TEXT

Go To View:	RETURN TO BANNER COMP META DATA REPORTS LIST
	Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_COURSE_TEXT_KSU

Description Source composite view contains course text for a specific course and academic period.

Target Column Business Definition Database Data Type Source Name Source Column

ACADEMIC_PERIOD_START Academic period or time frame associated with the start of this course VARCHAR2(6)
SCBDESC

SCBDESC_TERM_CODE_EFF

COURSE_IDENTIFICATION Course ID VARCHAR2(9)
CALCULATION

SCBDESC_SUBJ_CODE || SCBDESC_CRSE_NUMB

COURSE_NUMBER Course Number VARCHAR2(5)
SCBDESC

SCBDESC_CRSE_NUMB

COURSE_TEXT Course Text VARCHAR2(60)
SCRTEXT

SCRTEXT_TEXT

COURSE_TEXT_SEQNO Course Text Sequence Number NUMBER(23, 20)
SCRTEXT

SCRTEXT_SEQNO

LOAD_DATE Date information was last updated in ODS DATE
NA

SYSDATE

SUBJECT Subject VARCHAR2(4)
SCBDESC

SCBDESC_SUBJ_CODE

Ver:

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD_START	Academic period or time frame associated with the start of this course	VARCHAR2(6)	SCBDESC	SCBDESC_TERM_CODE_EFF
COURSE_IDENTIFICATION	Course ID	VARCHAR2(9)	CALCULATION	SCBDESC_SUBJ_CODE \|\| SCBDESC_CRSE_NUMB
COURSE_NUMBER	Course Number	VARCHAR2(5)	SCBDESC	SCBDESC_CRSE_NUMB
COURSE_TEXT	Course Text	VARCHAR2(60)	SCRTEXT	SCRTEXT_TEXT
COURSE_TEXT_SEQNO	Course Text Sequence Number	NUMBER(23, 20)	SCRTEXT	SCRTEXT_SEQNO
LOAD_DATE	Date information was last updated in ODS	DATE	NA	SYSDATE
SUBJECT	Subject	VARCHAR2(4)	SCBDESC	SCBDESC_SUBJ_CODE