std_transfer_credit_detail


Description

Transfer credit details. Some corrections are done in ps_correction.sql upon load.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_term.uw_id std_transfer_credit_detail_uw_id_fkey1R
std_transfer_credit_school.uw_id std_transfer_credit_detail_uw_id_fkeyR
career_code "_quest"."quest_career" 2147483647 null
std_transfer_credit_school.career_code std_transfer_credit_detail_uw_id_fkeyR
transfer_group int4 10 null
std_transfer_credit_school.transfer_group std_transfer_credit_detail_uw_id_fkeyR
seq_num int4 10 null
term_id "_quest"."quest_term_id" 2147483647 null
std_term.term_id std_transfer_credit_detail_uw_id_fkey1R
course_id "_quest"."quest_course_id" 2147483647 null
cal_course.course_id std_transfer_credit_detail_course_id_fkeyR
label_seq int4 10 null
external_term text 2147483647 √ null
external_subject text 2147483647 √ null
external_catalog text 2147483647 √ null
external_descr text 2147483647 √ null
external_grade text 2147483647 √ null
course_grade text 2147483647 null
earn_credit bool 1 null
include_in_gpa bool 1 null
requirement_designation text 2147483647 √ null
units_attempted_code "_quest"."quest_completion_code" 2147483647 null
student_take_units numeric 5,2 √ null
student_ap_units numeric 8,3 null
grading_basis text 2147483647 null
valid_attempt bool 1 null
grade_category text 2147483647 null

Table contained 166064 rows

Indexes

Constraint Name Type Sort Column(s)
std_transfer_credit_detail_pkey Primary key Asc/Asc/Asc/Asc uw_id + career_code + transfer_group + seq_num

Relationships

Close relationships within degrees of separation