View odyssey_test._quest_raw.check_std_term_section_session
Student class section enrolments in which the session code does not match the session code of the class section

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
emplid varchar 2147483647  √  null
ps_person_sa.emplid Implied Constraint R
acad_career varchar 2147483647  √  null
institution varchar 2147483647  √  null
strm varchar 2147483647  √  null
manual_term_exam_dates.strm Implied Constraint R
class_nbr int4 10  √  null
session_code varchar 2147483647  √  null
stdnt_enrl_status varchar 2147483647  √  null
enrl_status_reason varchar 2147483647  √  null
enrl_add_dt date 13  √  null
enrl_drop_dt date 13  √  null
unt_taken numeric 5,2  √  null
unt_prgrss numeric 5,2  √  null
grading_basis_enrl varchar 2147483647  √  null
crse_grade_off varchar 2147483647  √  null
grade_dt date 13  √  null
class_prmsn_nbr int4 10  √  null
earn_credit varchar 2147483647  √  null
include_in_gpa varchar 2147483647  √  null
units_attempted varchar 2147483647  √  null
grade_points numeric 9,3  √  null
rsrv_cap_nbr int4 10  √  null
rqmnt_designtn varchar 2147483647  √  null
rqmnt_designtn_grd varchar 2147483647  √  null
oprid varchar 2147483647  √  null
ps_uw_oper_data_in.oprid Implied Constraint R
tscrpt_note_id varchar 2147483647  √  null
valid_attempt varchar 2147483647  √  null
grade_category varchar 2147483647  √  null
unt_earned numeric 5,2  √  null
last_upd_dt_stmp date 13  √  null
last_upd_tm_stmp time 15,6  √  null
last_enrl_dt_stmp date 13  √  null
last_enrl_tm_stmp time 15,6  √  null
last_drop_dt_stmp date 13  √  null
last_drop_tm_stmp time 15,6  √  null

Analyzed at Wed Feb 19 10:31 EST 2014


Close relationships: