COURSE SECTION_TUIT_SCHOOL Table - Data Element Index . Tables and Data Elements . Student Data Home . Data Warehouse Home

COURSE SECTION TUITION SCHOOL Table

(dwst.course_section_tuit_school)

Explanation

Contains one row per term, course section id, and school receiving any percentage of the tuition. A course section can have just one tuition school, in which case there will be only one row in this table and the percentage will be 100. Or there can be multiple schools sharing the tuition distribution, in which case the total of the percentages for all the tuition schools for any given course section id in any given term will add up to 100.

Common Uses

• Find the schools sharing tuition distribution for courses in a specified subject area.
• Find course sections that have multiple schools sharing tuition distribution in a specified term.

Schema

DWST

Primary Key	Indexed Data Elements	Related Tables
SECTION_ID, TERM, TUITION_SCHOOL	SECTION_ID, TERM, TUITION_SCHOOL	COURSE_SECTION

Cautions

• There is also a Tuition_School column in the COURSE_SECTION table. This will be populated with a value for a tuition school if that school is receiving 100% of the tuition distribution for the course section in that term. If multiple schools are sharing the tuition distribution, the Tuition_School column in COURSE_SECTION will be '.'

COURSE SECTION_TUIT_SCHOOL Table - Data Element Index . Tables and Data Elements . Student Data Home . Data Warehouse Home