CRSE_COMPONENT (SQL Table)	Index Back
Course Catalog Component The Course Catalog Component Table contains course data relating to the type of sections that can/must be offered for the course. If a course consists of a lecture and a laboratory section, then one row exists for each of these section types in the Course Catalog Component table.

CRSE_COMPONENT

(SQL Table)

Course Catalog Component

The Course Catalog Component Table contains course data relating to the type of sections that can/must be offered for the course. If a course consists of a lecture and a laboratory section, then one row exists for each of these section types in the Course Catalog Component table.

Parent record: CRSE_CATALOG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
Prompt Table: CRSE_CATALOG

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
CLN=Clinical
CON=Continuance
DIS=Discussion
FLD=Field Studies
IND=Independent Study
LAB=Laboratory
LEC=Lecture
PRA=Practicum
RSC=Research
SEM=Seminar
SUP=Supervision
THE=Thesis Research
TUT=Tutorial

4 OPTIONAL_SECTION Character(1) VARCHAR2(1) NOT NULL Optional Component
Y/N Table Edit
Default Value: N

5 DEFAULT_SECT_SIZE Number(3,0) SMALLINT NOT NULL Default Section Size
Default Value: INSTALLATION_SA.DEFAULT_SECT_SIZE

6 CONTACT_HOURS Number(8,3) DECIMAL(7,3) NOT NULL Instructor Contact Hours

7 FINAL_EXAM Character(2) VARCHAR2(2) NOT NULL Final Exam
L=Last Class Meeting
N=No
Y=Yes

8 EXAM_SEAT_SPACING Number(1,0) SMALLINT NOT NULL Exam Seat Spacing
Default Value: 1

9 DYN_DT_INCLUDE Character(1) VARCHAR2(1) NOT NULL Include in Dynamic Date Calc
Y/N Table Edit
Default Value: N

10 AUTO_CREATE_CMPNT Character(1) VARCHAR2(1) NOT NULL Auto Create Component
Y/N Table Edit
Default Value: N

11 ATTEND_GENERATE Character(1) VARCHAR2(1) NOT NULL Generate Class Mtg Attendance
Y/N Table Edit
Default Value: N

12 WEEK_WORKLOAD_HRS Number(6,2) DECIMAL(5,2) NOT NULL Weekly Workload Hours

13 OEE_WORKLOAD_HRS Number(6,2) DECIMAL(5,2) NOT NULL OEE Crse Workload Hours - These will be the total workload hours for the entire OEE course.

14 LMS_FILE_TYPE Character(3) VARCHAR2(3) NOT NULL LMS extract file type: XML compliant, Blackboard specific, and WebCT specific
BKB=Blackboard CourseInfo 4
WCT=API Input (old WebCT format)
XML=XML V1.1 (req to authenticate)

15 LMS_PROVIDER Character(30) VARCHAR2(30) NOT NULL Provider for Authentication
Prompt Table: LMS_INT_SETUP
Set Control Field: LMS_PROVIDER

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID Prompt Table: CRSE_CATALOG
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	SSR_COMPONENT	Character(3)	VARCHAR2(3) NOT NULL	Course Component. CLN=Clinical CON=Continuance DIS=Discussion FLD=Field Studies IND=Independent Study LAB=Laboratory LEC=Lecture PRA=Practicum RSC=Research SEM=Seminar SUP=Supervision THE=Thesis Research TUT=Tutorial
4	OPTIONAL_SECTION	Character(1)	VARCHAR2(1) NOT NULL	Optional Component Y/N Table Edit Default Value: N
5	DEFAULT_SECT_SIZE	Number(3,0)	SMALLINT NOT NULL	Default Section Size Default Value: INSTALLATION_SA.DEFAULT_SECT_SIZE
6	CONTACT_HOURS	Number(8,3)	DECIMAL(7,3) NOT NULL	Instructor Contact Hours
7	FINAL_EXAM	Character(2)	VARCHAR2(2) NOT NULL	Final Exam L=Last Class Meeting N=No Y=Yes
8	EXAM_SEAT_SPACING	Number(1,0)	SMALLINT NOT NULL	Exam Seat Spacing Default Value: 1
9	DYN_DT_INCLUDE	Character(1)	VARCHAR2(1) NOT NULL	Include in Dynamic Date Calc Y/N Table Edit Default Value: N
10	AUTO_CREATE_CMPNT	Character(1)	VARCHAR2(1) NOT NULL	Auto Create Component Y/N Table Edit Default Value: N
11	ATTEND_GENERATE	Character(1)	VARCHAR2(1) NOT NULL	Generate Class Mtg Attendance Y/N Table Edit Default Value: N
12	WEEK_WORKLOAD_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Weekly Workload Hours
13	OEE_WORKLOAD_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	OEE Crse Workload Hours - These will be the total workload hours for the entire OEE course.
14	LMS_FILE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	LMS extract file type: XML compliant, Blackboard specific, and WebCT specific BKB=Blackboard CourseInfo 4 WCT=API Input (old WebCT format) XML=XML V1.1 (req to authenticate)
15	LMS_PROVIDER	Character(30)	VARCHAR2(30) NOT NULL	Provider for Authentication Prompt Table: LMS_INT_SETUP Set Control Field: LMS_PROVIDER