SchemaSpy Analysis of odyssey_test._quest_raw - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Feb 19 10:31 EST 2014 |
| ||||||
|
odyssey_test._quest_raw contains 1335 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
check_acad_degr_subplan | acad_plan | varchar | 2147483647 | √ | null | ||
check_acad_degr_subplan | acad_sub_plan | varchar | 2147483647 | √ | null | ||
check_acad_degr_subplan | emplid | varchar | 2147483647 | √ | null | ||
check_acad_degr_subplan | stdnt_degr | varchar | 2147483647 | √ | null | ||
check_acad_plan_history | acad_career | varchar | 2147483647 | √ | null | ||
check_acad_plan_history | acad_plan | varchar | 2147483647 | √ | null | ||
check_acad_plan_history | effdt | date | 13 | √ | null | ||
check_acad_plan_history | effseq | int4 | 10 | √ | null | ||
check_acad_plan_history | emplid | varchar | 2147483647 | √ | null | ||
check_acad_plan_history | plan_sequence | int4 | 10 | √ | null | ||
check_acad_plan_history | req_term | varchar | 2147483647 | √ | null | ||
check_acad_plan_history | stdnt_car_nbr | int4 | 10 | √ | null | ||
check_acad_plan_history | stdnt_degr | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | acad_career | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | acad_load_appr | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | acad_prog | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | action_dt | date | 13 | √ | null | ||
check_acad_prog_plan | admit_term | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | campus | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | completion_term | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | data_from_adm_appl | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | effdt | date | 13 | √ | null | ||
check_acad_prog_plan | effseq | int4 | 10 | √ | null | ||
check_acad_prog_plan | emplid | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | exp_grad_term | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | institution | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | prog_action | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | prog_reason | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | prog_status | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | req_term | varchar | 2147483647 | √ | null | ||
check_acad_prog_plan | stdnt_car_nbr | int4 | 10 | √ | null | ||
check_acad_subplan_history | acad_career | varchar | 2147483647 | √ | null | ||
check_acad_subplan_history | acad_plan | varchar | 2147483647 | √ | null | ||
check_acad_subplan_history | acad_sub_plan | varchar | 2147483647 | √ | null | ||
check_acad_subplan_history | effdt | date | 13 | √ | null | ||
check_acad_subplan_history | effseq | int4 | 10 | √ | null | ||
check_acad_subplan_history | emplid | varchar | 2147483647 | √ | null | ||
check_acad_subplan_history | req_term | varchar | 2147483647 | √ | null | ||
check_acad_subplan_history | stdnt_car_nbr | int4 | 10 | √ | null | ||
check_cal_association | associated_class | int4 | 10 | √ | null | ||
check_cal_association | component_primary | varchar | 2147483647 | √ | null | ||
check_cal_association | crse_id | varchar | 2147483647 | √ | null | ||
check_cal_association | crse_offer_nbr | int4 | 10 | √ | null | ||
check_cal_association | grading_basis | varchar | 2147483647 | √ | null | ||
check_cal_association | rqmnt_designtn | varchar | 2147483647 | √ | null | ||
check_cal_association | session_code | varchar | 2147483647 | √ | null | ||
check_cal_association | ssr_component | varchar | 2147483647 | √ | null | ||
check_cal_association | strm | varchar | 2147483647 | √ | null | ||
check_cal_association | units_acad_prog | numeric | 5,2 | √ | null | ||
check_cal_association | units_minimum | numeric | 5,2 | √ | null | ||
check_cal_section | acad_career | varchar | 2147483647 | √ | null | ||
check_cal_section | acad_group | varchar | 2147483647 | √ | null | ||
check_cal_section | acad_org | varchar | 2147483647 | √ | null | ||
check_cal_section | associated_class | int4 | 10 | √ | null | ||
check_cal_section | auto_enroll_sect_1 | varchar | 2147483647 | √ | null | ||
check_cal_section | auto_enroll_sect_2 | varchar | 2147483647 | √ | null | ||
check_cal_section | campus | varchar | 2147483647 | √ | null | ||
check_cal_section | catalog_nbr | varchar | 2147483647 | √ | null | ||
check_cal_section | class_nbr | int4 | 10 | √ | null | ||
check_cal_section | class_section | varchar | 2147483647 | √ | null | ||
check_cal_section | class_stat | varchar | 2147483647 | √ | null | ||
check_cal_section | class_type | varchar | 2147483647 | √ | null | ||
check_cal_section | consent | varchar | 2147483647 | √ | null | ||
check_cal_section | crs_topic_id | int4 | 10 | √ | null | ||
check_cal_section | crse_id | varchar | 2147483647 | √ | null | ||
check_cal_section | crse_offer_nbr | int4 | 10 | √ | null | ||
check_cal_section | descr | varchar | 2147483647 | √ | null | ||
check_cal_section | enrl_cap | int4 | 10 | √ | null | ||
check_cal_section | enrl_stat | varchar | 2147483647 | √ | null | ||
check_cal_section | enrl_tot | int4 | 10 | √ | null | ||
check_cal_section | institution | varchar | 2147483647 | √ | null | ||
check_cal_section | instruction_mode | varchar | 2147483647 | √ | null | ||
check_cal_section | location | varchar | 2147483647 | √ | null | ||
check_cal_section | room_cap_request | int4 | 10 | √ | null | ||
check_cal_section | schedule_print | varchar | 2147483647 | √ | null | ||
check_cal_section | session_code | varchar | 2147483647 | √ | null | ||
check_cal_section | ssr_component | varchar | 2147483647 | √ | null | ||
check_cal_section | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
check_cal_section | strm | varchar | 2147483647 | √ | null | ||
check_cal_section | subject | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | acad_career | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | acad_group | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | acad_org | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | associated_class | int4 | 10 | √ | null | ||
check_cal_section_autoenrol | auto_enroll_sect_1 | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | auto_enroll_sect_2 | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | campus | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | catalog_nbr | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | class_nbr | int4 | 10 | √ | null | ||
check_cal_section_autoenrol | class_section | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | class_stat | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | class_type | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | consent | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | crs_topic_id | int4 | 10 | √ | null | ||
check_cal_section_autoenrol | crse_id | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | crse_offer_nbr | int4 | 10 | √ | null | ||
check_cal_section_autoenrol | descr | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | enrl_cap | int4 | 10 | √ | null | ||
check_cal_section_autoenrol | enrl_stat | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | enrl_tot | int4 | 10 | √ | null | ||
check_cal_section_autoenrol | institution | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | instruction_mode | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | location | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | room_cap_request | int4 | 10 | √ | null | ||
check_cal_section_autoenrol | schedule_print | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | session_code | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | ssr_component | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | strm | varchar | 2147483647 | √ | null | ||
check_cal_section_autoenrol | subject | varchar | 2147483647 | √ | null | ||
check_cal_section_combined | class_nbr | int4 | 10 | √ | null | ||
check_cal_section_combined | institution | varchar | 2147483647 | √ | null | ||
check_cal_section_combined | sctn_combined_id | varchar | 2147483647 | √ | null | ||
check_cal_section_combined | session_code | varchar | 2147483647 | √ | null | ||
check_cal_section_combined | strm | varchar | 2147483647 | √ | null | ||
check_cal_section_note | class_note_nbr | varchar | 2147483647 | √ | null | ||
check_cal_section_note | class_notes_seq | int4 | 10 | √ | null | ||
check_cal_section_note | class_section | varchar | 2147483647 | √ | null | ||
check_cal_section_note | crse_id | varchar | 2147483647 | √ | null | ||
check_cal_section_note | crse_offer_nbr | int4 | 10 | √ | null | ||
check_cal_section_note | descrlong | varchar | 2147483647 | √ | null | ||
check_cal_section_note | session_code | varchar | 2147483647 | √ | null | ||
check_cal_section_note | strm | varchar | 2147483647 | √ | null | ||
check_cal_section_related | acad_career | varchar | 2147483647 | √ | null | ||
check_cal_section_related | acad_group | varchar | 2147483647 | √ | null | ||
check_cal_section_related | acad_org | varchar | 2147483647 | √ | null | ||
check_cal_section_related | associated_class | int4 | 10 | √ | null | ||
check_cal_section_related | auto_enroll_sect_1 | varchar | 2147483647 | √ | null | ||
check_cal_section_related | auto_enroll_sect_2 | varchar | 2147483647 | √ | null | ||
check_cal_section_related | campus | varchar | 2147483647 | √ | null | ||
check_cal_section_related | catalog_nbr | varchar | 2147483647 | √ | null | ||
check_cal_section_related | class_nbr | int4 | 10 | √ | null | ||
check_cal_section_related | class_section | varchar | 2147483647 | √ | null | ||
check_cal_section_related | class_stat | varchar | 2147483647 | √ | null | ||
check_cal_section_related | class_type | varchar | 2147483647 | √ | null | ||
check_cal_section_related | consent | varchar | 2147483647 | √ | null | ||
check_cal_section_related | crs_topic_id | int4 | 10 | √ | null | ||
check_cal_section_related | crse_id | varchar | 2147483647 | √ | null | ||
check_cal_section_related | crse_offer_nbr | int4 | 10 | √ | null | ||
check_cal_section_related | descr | varchar | 2147483647 | √ | null | ||
check_cal_section_related | enrl_cap | int4 | 10 | √ | null | ||
check_cal_section_related | enrl_stat | varchar | 2147483647 | √ | null | ||
check_cal_section_related | enrl_tot | int4 | 10 | √ | null | ||
check_cal_section_related | institution | varchar | 2147483647 | √ | null | ||
check_cal_section_related | instruction_mode | varchar | 2147483647 | √ | null | ||
check_cal_section_related | location | varchar | 2147483647 | √ | null | ||
check_cal_section_related | room_cap_request | int4 | 10 | √ | null | ||
check_cal_section_related | schedule_print | varchar | 2147483647 | √ | null | ||
check_cal_section_related | session_code | varchar | 2147483647 | √ | null | ||
check_cal_section_related | ssr_component | varchar | 2147483647 | √ | null | ||
check_cal_section_related | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
check_cal_section_related | strm | varchar | 2147483647 | √ | null | ||
check_cal_section_related | subject | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | acad_career | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | acad_group | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | acad_org | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | associated_class | int4 | 10 | √ | null | ||
check_cal_section_topic | auto_enroll_sect_1 | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | auto_enroll_sect_2 | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | campus | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | catalog_nbr | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | class_nbr | int4 | 10 | √ | null | ||
check_cal_section_topic | class_section | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | class_stat | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | class_type | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | consent | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | crs_topic_id | int4 | 10 | √ | null | ||
check_cal_section_topic | crse_id | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | crse_offer_nbr | int4 | 10 | √ | null | ||
check_cal_section_topic | descr | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | enrl_cap | int4 | 10 | √ | null | ||
check_cal_section_topic | enrl_stat | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | enrl_tot | int4 | 10 | √ | null | ||
check_cal_section_topic | institution | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | instruction_mode | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | location | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | room_cap_request | int4 | 10 | √ | null | ||
check_cal_section_topic | schedule_print | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | session_code | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | ssr_component | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | strm | varchar | 2147483647 | √ | null | ||
check_cal_section_topic | subject | varchar | 2147483647 | √ | null | ||
check_course_combined_section_meet | class_mtg_nbr | int4 | 10 | √ | null | ||
check_course_combined_section_meet | class_nbr_1 | int4 | 10 | √ | null | ||
check_course_combined_section_meet | class_nbr_2 | int4 | 10 | √ | null | ||
check_course_combined_section_meet | sctn_combined_id | varchar | 2147483647 | √ | null | ||
check_course_combined_section_meet | strm | varchar | 2147483647 | √ | null | ||
check_course_combined_section_status | class_nbr_1 | int4 | 10 | √ | null | ||
check_course_combined_section_status | class_nbr_2 | int4 | 10 | √ | null | ||
check_course_combined_section_status | class_stat_1 | varchar | 2147483647 | √ | null | ||
check_course_combined_section_status | class_stat_2 | varchar | 2147483647 | √ | null | ||
check_course_combined_section_status | sctn_combined_id | varchar | 2147483647 | √ | null | ||
check_course_combined_section_status | strm | varchar | 2147483647 | √ | null | ||
check_course_label_duplicate | catalog_nbr | varchar | 2147483647 | √ | null | ||
check_course_label_duplicate | count | int8 | 19 | √ | null | ||
check_course_label_duplicate | crse_id | varchar | 2147483647 | √ | null | ||
check_course_label_duplicate | crse_offer_nbr | int4 | 10 | √ | null | ||
check_course_label_duplicate | effdt | date | 13 | √ | null | ||
check_course_label_duplicate | subject | varchar | 2147483647 | √ | null | ||
check_course_label_exist | acad_career | varchar | 2147483647 | √ | null | ||
check_course_label_exist | acad_group | varchar | 2147483647 | √ | null | ||
check_course_label_exist | acad_org | varchar | 2147483647 | √ | null | ||
check_course_label_exist | associated_class | int4 | 10 | √ | null | ||
check_course_label_exist | auto_enroll_sect_1 | varchar | 2147483647 | √ | null | ||
check_course_label_exist | auto_enroll_sect_2 | varchar | 2147483647 | √ | null | ||
check_course_label_exist | campus | varchar | 2147483647 | √ | null | ||
check_course_label_exist | catalog_nbr | varchar | 2147483647 | √ | null | ||
check_course_label_exist | class_nbr | int4 | 10 | √ | null | ||
check_course_label_exist | class_section | varchar | 2147483647 | √ | null | ||
check_course_label_exist | class_stat | varchar | 2147483647 | √ | null | ||
check_course_label_exist | class_type | varchar | 2147483647 | √ | null | ||
check_course_label_exist | consent | varchar | 2147483647 | √ | null | ||
check_course_label_exist | crs_topic_id | int4 | 10 | √ | null | ||
check_course_label_exist | crse_id | varchar | 2147483647 | √ | null | ||
check_course_label_exist | crse_offer_nbr | int4 | 10 | √ | null | ||
check_course_label_exist | descr | varchar | 2147483647 | √ | null | ||
check_course_label_exist | effdt | date | 13 | √ | null | ||
check_course_label_exist | enrl_cap | int4 | 10 | √ | null | ||
check_course_label_exist | enrl_stat | varchar | 2147483647 | √ | null | ||
check_course_label_exist | enrl_tot | int4 | 10 | √ | null | ||
check_course_label_exist | institution | varchar | 2147483647 | √ | null | ||
check_course_label_exist | instruction_mode | varchar | 2147483647 | √ | null | ||
check_course_label_exist | location | varchar | 2147483647 | √ | null | ||
check_course_label_exist | room_cap_request | int4 | 10 | √ | null | ||
check_course_label_exist | schedule_print | varchar | 2147483647 | √ | null | ||
check_course_label_exist | session_code | varchar | 2147483647 | √ | null | ||
check_course_label_exist | ssr_component | varchar | 2147483647 | √ | null | ||
check_course_label_exist | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
check_course_label_exist | strm | varchar | 2147483647 | √ | null | ||
check_course_label_exist | subject | varchar | 2147483647 | √ | null | ||
check_course_offer | acad_career | varchar | 2147483647 | √ | null | ||
check_course_offer | acad_group | varchar | 2147483647 | √ | null | ||
check_course_offer | acad_org | varchar | 2147483647 | √ | null | ||
check_course_offer | campus | varchar | 2147483647 | √ | null | ||
check_course_offer | catalog_nbr | varchar | 2147483647 | √ | null | ||
check_course_offer | crse_id | varchar | 2147483647 | √ | null | ||
check_course_offer | crse_offer_nbr | int4 | 10 | √ | null | ||
check_course_offer | effdt | date | 13 | √ | null | ||
check_course_offer | institution | varchar | 2147483647 | √ | null | ||
check_course_offer | rqrmnt_group | varchar | 2147483647 | √ | null | ||
check_course_offer | schedule_print | varchar | 2147483647 | √ | null | ||
check_course_offer | subject | varchar | 2147483647 | √ | null | ||
check_course_section | acad_career | varchar | 2147483647 | √ | null | ||
check_course_section | acad_group | varchar | 2147483647 | √ | null | ||
check_course_section | acad_org | varchar | 2147483647 | √ | null | ||
check_course_section | associated_class | int4 | 10 | √ | null | ||
check_course_section | auto_enroll_sect_1 | varchar | 2147483647 | √ | null | ||
check_course_section | auto_enroll_sect_2 | varchar | 2147483647 | √ | null | ||
check_course_section | campus | varchar | 2147483647 | √ | null | ||
check_course_section | catalog_nbr | varchar | 2147483647 | √ | null | ||
check_course_section | class_nbr | int4 | 10 | √ | null | ||
check_course_section | class_section | varchar | 2147483647 | √ | null | ||
check_course_section | class_stat | varchar | 2147483647 | √ | null | ||
check_course_section | class_type | varchar | 2147483647 | √ | null | ||
check_course_section | consent | varchar | 2147483647 | √ | null | ||
check_course_section | crs_topic_id | int4 | 10 | √ | null | ||
check_course_section | crse_id | varchar | 2147483647 | √ | null | ||
check_course_section | crse_offer_nbr | int4 | 10 | √ | null | ||
check_course_section | descr | varchar | 2147483647 | √ | null | ||
check_course_section | enrl_cap | int4 | 10 | √ | null | ||
check_course_section | enrl_stat | varchar | 2147483647 | √ | null | ||
check_course_section | enrl_tot | int4 | 10 | √ | null | ||
check_course_section | institution | varchar | 2147483647 | √ | null | ||
check_course_section | instruction_mode | varchar | 2147483647 | √ | null | ||
check_course_section | location | varchar | 2147483647 | √ | null | ||
check_course_section | room_cap_request | int4 | 10 | √ | null | ||
check_course_section | schedule_print | varchar | 2147483647 | √ | null | ||
check_course_section | session_code | varchar | 2147483647 | √ | null | ||
check_course_section | ssr_component | varchar | 2147483647 | √ | null | ||
check_course_section | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
check_course_section | strm | varchar | 2147483647 | √ | null | ||
check_course_section | subject | varchar | 2147483647 | √ | null | ||
check_course_section_combined | class_nbr | int4 | 10 | √ | null | ||
check_course_section_combined | institution | varchar | 2147483647 | √ | null | ||
check_course_section_combined | sctn_combined_id | varchar | 2147483647 | √ | null | ||
check_course_section_combined | session_code | varchar | 2147483647 | √ | null | ||
check_course_section_combined | strm | varchar | 2147483647 | √ | null | ||
check_course_topic | crs_topic_id | int4 | 10 | √ | null | ||
check_course_topic | crse_id | varchar | 2147483647 | √ | null | ||
check_course_topic | descr | varchar | 2147483647 | √ | null | ||
check_course_topic | descrformal | varchar | 2147483647 | √ | null | ||
check_course_topic | descrshort | varchar | 2147483647 | √ | null | ||
check_course_topic | effdt | date | 13 | √ | null | ||
check_course_topic_exist | acad_career | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | acad_group | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | acad_org | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | associated_class | int4 | 10 | √ | null | ||
check_course_topic_exist | auto_enroll_sect_1 | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | auto_enroll_sect_2 | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | campus | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | catalog_nbr | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | class_nbr | int4 | 10 | √ | null | ||
check_course_topic_exist | class_section | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | class_stat | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | class_type | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | consent | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | crs_topic_id | int4 | 10 | √ | null | ||
check_course_topic_exist | crse_id | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | crse_offer_nbr | int4 | 10 | √ | null | ||
check_course_topic_exist | descr | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | effdt | date | 13 | √ | null | ||
check_course_topic_exist | enrl_cap | int4 | 10 | √ | null | ||
check_course_topic_exist | enrl_stat | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | enrl_tot | int4 | 10 | √ | null | ||
check_course_topic_exist | institution | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | instruction_mode | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | location | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | room_cap_request | int4 | 10 | √ | null | ||
check_course_topic_exist | schedule_print | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | session_code | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | ssr_component | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | strm | varchar | 2147483647 | √ | null | ||
check_course_topic_exist | subject | varchar | 2147483647 | √ | null | ||
check_facility_unit | acad_org | varchar | 2147483647 | √ | null | ||
check_facility_unit | bldg_cd | varchar | 2147483647 | √ | null | ||
check_facility_unit | descr | varchar | 2147483647 | √ | null | ||
check_facility_unit | descrshort | varchar | 2147483647 | √ | null | ||
check_facility_unit | eff_status | varchar | 2147483647 | √ | null | ||
check_facility_unit | effdt | date | 13 | √ | null | ||
check_facility_unit | facility_group | varchar | 2147483647 | √ | null | ||
check_facility_unit | facility_id | varchar | 2147483647 | √ | null | ||
check_facility_unit | facility_partition | varchar | 2147483647 | √ | null | ||
check_facility_unit | facility_type | varchar | 2147483647 | √ | null | ||
check_facility_unit | generl_assign | varchar | 2147483647 | √ | null | ||
check_facility_unit | location | varchar | 2147483647 | √ | null | ||
check_facility_unit | room | varchar | 2147483647 | √ | null | ||
check_facility_unit | room_capacity | int4 | 10 | √ | null | ||
check_facility_unit | setid | varchar | 2147483647 | √ | null | ||
check_gpa | acad_career | varchar | 2147483647 | √ | null | ||
check_gpa | count | int8 | 19 | √ | null | ||
check_gpa | emplid | varchar | 2147483647 | √ | null | ||
check_gpa | gpa_type | varchar | 2147483647 | √ | null | ||
check_gpa | strm | varchar | 2147483647 | √ | null | ||
check_plan_degree | acad_career | varchar | 2147483647 | √ | null | ||
check_plan_degree | acad_plan | varchar | 2147483647 | √ | null | ||
check_plan_degree | acad_plan_type | varchar | 2147483647 | √ | null | ||
check_plan_degree | acad_prog | varchar | 2147483647 | √ | null | ||
check_plan_degree | degree | varchar | 2147483647 | √ | null | ||
check_plan_degree | descr | varchar | 2147483647 | √ | null | ||
check_plan_degree | descrlong | varchar | 2147483647 | √ | null | ||
check_plan_degree | descrshort | varchar | 2147483647 | √ | null | ||
check_plan_degree | diploma_descr | varchar | 2147483647 | √ | null | ||
check_plan_degree | eff_status | varchar | 2147483647 | √ | null | ||
check_plan_degree | effdt | date | 13 | √ | null | ||
check_plan_degree | first_term_valid | varchar | 2147483647 | √ | null | ||
check_plan_degree | institution | varchar | 2147483647 | √ | null | ||
check_plan_degree | ssr_last_adm_term | varchar | 2147483647 | √ | null | ||
check_plan_degree | trnscr_descr | varchar | 2147483647 | √ | null | ||
check_session_dates | acad_career | varchar | 2147483647 | √ | null | ||
check_session_dates | census_dt | date | 13 | √ | null | ||
check_session_dates | session_code | varchar | 2147483647 | √ | null | ||
check_session_dates | sixty_pct_dt | date | 13 | √ | null | ||
check_session_dates | strm | varchar | 2147483647 | √ | null | ||
check_std_term_course_transcript_note | acad_career | varchar | 2147483647 | √ | null | ||
check_std_term_course_transcript_note | class_nbr | int4 | 10 | √ | null | ||
check_std_term_course_transcript_note | emplid | varchar | 2147483647 | √ | null | ||
check_std_term_course_transcript_note | institution | varchar | 2147483647 | √ | null | ||
check_std_term_course_transcript_note | strm | varchar | 2147483647 | √ | null | ||
check_std_term_course_transcript_note | tscrpt_note254 | varchar | 2147483647 | √ | null | ||
check_std_term_course_transcript_note | tscrpt_note_seq | int4 | 10 | √ | null | ||
check_std_term_section | acad_career | varchar | 2147483647 | √ | null | ||
check_std_term_section | class_nbr | int4 | 10 | √ | null | ||
check_std_term_section | class_prmsn_nbr | int4 | 10 | √ | null | ||
check_std_term_section | crse_grade_off | varchar | 2147483647 | √ | null | ||
check_std_term_section | earn_credit | varchar | 2147483647 | √ | null | ||
check_std_term_section | emplid | varchar | 2147483647 | √ | null | ||
check_std_term_section | enrl_add_dt | date | 13 | √ | null | ||
check_std_term_section | enrl_drop_dt | date | 13 | √ | null | ||
check_std_term_section | enrl_status_reason | varchar | 2147483647 | √ | null | ||
check_std_term_section | grade_category | varchar | 2147483647 | √ | null | ||
check_std_term_section | grade_dt | date | 13 | √ | null | ||
check_std_term_section | grade_points | numeric | 9,3 | √ | null | ||
check_std_term_section | grading_basis_enrl | varchar | 2147483647 | √ | null | ||
check_std_term_section | include_in_gpa | varchar | 2147483647 | √ | null | ||
check_std_term_section | institution | varchar | 2147483647 | √ | null | ||
check_std_term_section | last_drop_dt_stmp | date | 13 | √ | null | ||
check_std_term_section | last_drop_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section | last_enrl_dt_stmp | date | 13 | √ | null | ||
check_std_term_section | last_enrl_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section | last_upd_dt_stmp | date | 13 | √ | null | ||
check_std_term_section | last_upd_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section | oprid | varchar | 2147483647 | √ | null | ||
check_std_term_section | rqmnt_designtn | varchar | 2147483647 | √ | null | ||
check_std_term_section | rqmnt_designtn_grd | varchar | 2147483647 | √ | null | ||
check_std_term_section | rsrv_cap_nbr | int4 | 10 | √ | null | ||
check_std_term_section | session_code | varchar | 2147483647 | √ | null | ||
check_std_term_section | stdnt_enrl_status | varchar | 2147483647 | √ | null | ||
check_std_term_section | strm | varchar | 2147483647 | √ | null | ||
check_std_term_section | tscrpt_note_id | varchar | 2147483647 | √ | null | ||
check_std_term_section | units_attempted | varchar | 2147483647 | √ | null | ||
check_std_term_section | unt_earned | numeric | 5,2 | √ | null | ||
check_std_term_section | unt_prgrss | numeric | 5,2 | √ | null | ||
check_std_term_section | unt_taken | numeric | 5,2 | √ | null | ||
check_std_term_section | valid_attempt | varchar | 2147483647 | √ | null | ||
check_std_term_section_career | count | int8 | 19 | √ | null | ||
check_std_term_section_career | emplid | varchar | 2147483647 | √ | null | ||
check_std_term_section_career | strm | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | acad_career | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | class_nbr | int4 | 10 | √ | null | ||
check_std_term_section_career_term | class_prmsn_nbr | int4 | 10 | √ | null | ||
check_std_term_section_career_term | crse_grade_off | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | earn_credit | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | emplid | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | enrl_add_dt | date | 13 | √ | null | ||
check_std_term_section_career_term | enrl_drop_dt | date | 13 | √ | null | ||
check_std_term_section_career_term | enrl_status_reason | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | grade_category | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | grade_dt | date | 13 | √ | null | ||
check_std_term_section_career_term | grade_points | numeric | 9,3 | √ | null | ||
check_std_term_section_career_term | grading_basis_enrl | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | include_in_gpa | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | institution | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | last_drop_dt_stmp | date | 13 | √ | null | ||
check_std_term_section_career_term | last_drop_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section_career_term | last_enrl_dt_stmp | date | 13 | √ | null | ||
check_std_term_section_career_term | last_enrl_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section_career_term | last_upd_dt_stmp | date | 13 | √ | null | ||
check_std_term_section_career_term | last_upd_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section_career_term | oprid | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | rqmnt_designtn | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | rqmnt_designtn_grd | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | rsrv_cap_nbr | int4 | 10 | √ | null | ||
check_std_term_section_career_term | session_code | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | stdnt_enrl_status | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | strm | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | tscrpt_note_id | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | units_attempted | varchar | 2147483647 | √ | null | ||
check_std_term_section_career_term | unt_earned | numeric | 5,2 | √ | null | ||
check_std_term_section_career_term | unt_prgrss | numeric | 5,2 | √ | null | ||
check_std_term_section_career_term | unt_taken | numeric | 5,2 | √ | null | ||
check_std_term_section_career_term | valid_attempt | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | acad_career | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | class_nbr | int4 | 10 | √ | null | ||
check_std_term_section_grade | class_prmsn_nbr | int4 | 10 | √ | null | ||
check_std_term_section_grade | crse_grade_off | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | earn_credit | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | emplid | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | enrl_add_dt | date | 13 | √ | null | ||
check_std_term_section_grade | enrl_drop_dt | date | 13 | √ | null | ||
check_std_term_section_grade | enrl_status_reason | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | grade_category | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | grade_dt | date | 13 | √ | null | ||
check_std_term_section_grade | grade_points | numeric | 9,3 | √ | null | ||
check_std_term_section_grade | grading_basis_enrl | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | include_in_gpa | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | institution | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | last_drop_dt_stmp | date | 13 | √ | null | ||
check_std_term_section_grade | last_drop_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section_grade | last_enrl_dt_stmp | date | 13 | √ | null | ||
check_std_term_section_grade | last_enrl_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section_grade | last_upd_dt_stmp | date | 13 | √ | null | ||
check_std_term_section_grade | last_upd_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section_grade | oprid | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | rqmnt_designtn | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | rqmnt_designtn_grd | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | rsrv_cap_nbr | int4 | 10 | √ | null | ||
check_std_term_section_grade | session_code | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | stdnt_enrl_status | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | strm | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | tscrpt_note_id | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | units_attempted | varchar | 2147483647 | √ | null | ||
check_std_term_section_grade | unt_earned | numeric | 5,2 | √ | null | ||
check_std_term_section_grade | unt_prgrss | numeric | 5,2 | √ | null | ||
check_std_term_section_grade | unt_taken | numeric | 5,2 | √ | null | ||
check_std_term_section_grade | valid_attempt | varchar | 2147483647 | √ | null | ||
check_std_term_section_reserve | class_nbr | int4 | 10 | √ | null | ||
check_std_term_section_reserve | emplid | varchar | 2147483647 | √ | null | ||
check_std_term_section_reserve | rsrv_cap_nbr | int4 | 10 | √ | null | ||
check_std_term_section_reserve | strm | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | acad_career | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | class_nbr | int4 | 10 | √ | null | ||
check_std_term_section_session | class_prmsn_nbr | int4 | 10 | √ | null | ||
check_std_term_section_session | crse_grade_off | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | earn_credit | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | emplid | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | enrl_add_dt | date | 13 | √ | null | ||
check_std_term_section_session | enrl_drop_dt | date | 13 | √ | null | ||
check_std_term_section_session | enrl_status_reason | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | grade_category | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | grade_dt | date | 13 | √ | null | ||
check_std_term_section_session | grade_points | numeric | 9,3 | √ | null | ||
check_std_term_section_session | grading_basis_enrl | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | include_in_gpa | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | institution | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | last_drop_dt_stmp | date | 13 | √ | null | ||
check_std_term_section_session | last_drop_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section_session | last_enrl_dt_stmp | date | 13 | √ | null | ||
check_std_term_section_session | last_enrl_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section_session | last_upd_dt_stmp | date | 13 | √ | null | ||
check_std_term_section_session | last_upd_tm_stmp | time | 15,6 | √ | null | ||
check_std_term_section_session | oprid | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | rqmnt_designtn | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | rqmnt_designtn_grd | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | rsrv_cap_nbr | int4 | 10 | √ | null | ||
check_std_term_section_session | session_code | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | stdnt_enrl_status | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | strm | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | tscrpt_note_id | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | units_attempted | varchar | 2147483647 | √ | null | ||
check_std_term_section_session | unt_earned | numeric | 5,2 | √ | null | ||
check_std_term_section_session | unt_prgrss | numeric | 5,2 | √ | null | ||
check_std_term_section_session | unt_taken | numeric | 5,2 | √ | null | ||
check_std_term_section_session | valid_attempt | varchar | 2147483647 | √ | null | ||
check_student_term_plan_01 | acad_career | varchar | 2147483647 | √ | null | ||
check_student_term_plan_01 | acad_plan | varchar | 2147483647 | √ | null | ||
check_student_term_plan_01 | effdt | date | 13 | √ | null | ||
check_student_term_plan_01 | effseq | int4 | 10 | √ | null | ||
check_student_term_plan_01 | emplid | varchar | 2147483647 | √ | null | ||
check_student_term_plan_01 | plan_sequence | int4 | 10 | √ | null | ||
check_student_term_plan_01 | req_term | varchar | 2147483647 | √ | null | ||
check_student_term_plan_01 | stdnt_car_nbr | int4 | 10 | √ | null | ||
check_student_term_plan_01 | stdnt_degr | varchar | 2147483647 | √ | null | ||
check_student_term_plan_02 | acad_career | varchar | 2147483647 | √ | null | ||
check_student_term_plan_02 | acad_plan | varchar | 2147483647 | √ | null | ||
check_student_term_plan_02 | effdt | date | 13 | √ | null | ||
check_student_term_plan_02 | effseq | int4 | 10 | √ | null | ||
check_student_term_plan_02 | emplid | varchar | 2147483647 | √ | null | ||
check_student_term_plan_02 | plan_sequence | int4 | 10 | √ | null | ||
check_student_term_plan_02 | req_term | varchar | 2147483647 | √ | null | ||
check_student_term_plan_02 | stdnt_car_nbr | int4 | 10 | √ | null | ||
check_student_term_plan_02 | stdnt_degr | varchar | 2147483647 | √ | null | ||
check_term_class_dates | count | int8 | 19 | √ | null | ||
check_term_class_dates | strm | varchar | 2147483647 | √ | null | ||
check_tscrpt_text_loc | acad_career | varchar | 2147483647 | √ | null | ||
check_tscrpt_text_loc | emplid | varchar | 2147483647 | √ | null | ||
check_tscrpt_text_loc | institution | varchar | 2147483647 | √ | null | ||
check_tscrpt_text_loc | milestone_nbr | int4 | 10 | √ | null | ||
check_tscrpt_text_loc | model_nbr | int4 | 10 | √ | null | ||
check_tscrpt_text_loc | print_loc | varchar | 2147483647 | √ | null | ||
check_tscrpt_text_loc | print_loc_seq | int4 | 10 | √ | null | ||
check_tscrpt_text_loc | relative_position | varchar | 2147483647 | √ | null | ||
check_tscrpt_text_loc | stdnt_degr | varchar | 2147483647 | √ | null | ||
check_tscrpt_text_loc | strm | varchar | 2147483647 | √ | null | ||
check_valid_subplans | acad_career | varchar | 2147483647 | √ | null | ||
check_valid_subplans | acad_plan | varchar | 2147483647 | √ | null | ||
check_valid_subplans | acad_sub_plan | varchar | 2147483647 | √ | null | ||
check_valid_subplans | effdt | date | 13 | √ | null | ||
check_valid_subplans | effseq | int4 | 10 | √ | null | ||
check_valid_subplans | emplid | varchar | 2147483647 | √ | null | ||
check_valid_subplans | req_term | varchar | 2147483647 | √ | null | ||
check_valid_subplans | stdnt_car_nbr | int4 | 10 | √ | null | ||
manual_term_exam_dates | first_exam_date | date | 13 | ||||
manual_term_exam_dates | last_exam_date | date | 13 | ||||
manual_term_exam_dates | strm | varchar | 2147483647 | ||||
manual_unit_group | acad_org | varchar | 2147483647 | ||||
manual_unit_group | effdt | date | 13 | ||||
manual_unit_group | group_code | text | 2147483647 | ||||
ps_acad_calses_tbl | acad_career | varchar | 2147483647 | ||||
ps_acad_calses_tbl | drop_pen_grade | varchar | 2147483647 | √ | null | ||
ps_acad_calses_tbl | drop_pen_grade_2 | varchar | 2147483647 | √ | null | ||
ps_acad_calses_tbl | drop_pen_grd_bas | varchar | 2147483647 | √ | null | ||
ps_acad_calses_tbl | drop_pen_grd_bas_2 | varchar | 2147483647 | √ | null | ||
ps_acad_calses_tbl | institution | varchar | 2147483647 | ||||
ps_acad_calses_tbl | lst_drop_dt_del | date | 13 | √ | null | ||
ps_acad_calses_tbl | lst_drop_dt_pen | date | 13 | √ | null | ||
ps_acad_calses_tbl | lst_drop_dt_pen_2 | date | 13 | √ | null | ||
ps_acad_calses_tbl | lst_drop_dt_ret | date | 13 | √ | null | ||
ps_acad_calses_tbl | session_code | varchar | 2147483647 | ||||
ps_acad_calses_tbl | strm | varchar | 2147483647 | ||||
ps_acad_degr | acad_career | varchar | 2147483647 | √ | null | ||
ps_acad_degr | acad_degr_status | varchar | 2147483647 | √ | null | ||
ps_acad_degr | completion_term | varchar | 2147483647 | √ | null | ||
ps_acad_degr | degr_confer_dt | date | 13 | √ | null | ||
ps_acad_degr | degree | varchar | 2147483647 | √ | null | ||
ps_acad_degr | emplid | varchar | 2147483647 | ||||
ps_acad_degr | institution | varchar | 2147483647 | √ | null | ||
ps_acad_degr | stdnt_degr | varchar | 2147483647 | ||||
ps_acad_degr_hons | emplid | varchar | 2147483647 | ||||
ps_acad_degr_hons | honors_award_dt | date | 13 | √ | null | ||
ps_acad_degr_hons | honors_code | varchar | 2147483647 | √ | null | ||
ps_acad_degr_hons | honors_nbr | int4 | 10 | ||||
ps_acad_degr_hons | stdnt_degr | varchar | 2147483647 | ||||
ps_acad_degr_plan | acad_career | varchar | 2147483647 | √ | null | ||
ps_acad_degr_plan | acad_plan | varchar | 2147483647 | ||||
ps_acad_degr_plan | emplid | varchar | 2147483647 | ||||
ps_acad_degr_plan | plan_sequence | int4 | 10 | √ | null | ||
ps_acad_degr_plan | stdnt_car_nbr | int4 | 10 | √ | null | ||
ps_acad_degr_plan | stdnt_degr | varchar | 2147483647 | ||||
ps_acad_degr_spln | acad_plan | varchar | 2147483647 | ||||
ps_acad_degr_spln | acad_sub_plan | varchar | 2147483647 | ||||
ps_acad_degr_spln | emplid | varchar | 2147483647 | ||||
ps_acad_degr_spln | stdnt_degr | varchar | 2147483647 | ||||
ps_acad_group_tbl | acad_group | varchar | 2147483647 | ||||
ps_acad_group_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_acad_group_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_acad_group_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_acad_group_tbl | effdt | date | 13 | ||||
ps_acad_group_tbl | institution | varchar | 2147483647 | ||||
ps_acad_org_tbl | acad_org | varchar | 2147483647 | ||||
ps_acad_org_tbl | campus | varchar | 2147483647 | √ | null | ||
ps_acad_org_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_acad_org_tbl | descrformal | varchar | 2147483647 | √ | null | ||
ps_acad_org_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_acad_org_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_acad_org_tbl | effdt | date | 13 | ||||
ps_acad_org_tbl | institution | varchar | 2147483647 | √ | null | ||
ps_acad_plan | acad_career | varchar | 2147483647 | ||||
ps_acad_plan | acad_plan | varchar | 2147483647 | ||||
ps_acad_plan | effdt | date | 13 | ||||
ps_acad_plan | effseq | int4 | 10 | ||||
ps_acad_plan | emplid | varchar | 2147483647 | ||||
ps_acad_plan | plan_sequence | int4 | 10 | √ | null | ||
ps_acad_plan | req_term | varchar | 2147483647 | √ | null | ||
ps_acad_plan | stdnt_car_nbr | int4 | 10 | ||||
ps_acad_plan | stdnt_degr | varchar | 2147483647 | √ | null | ||
ps_acad_plan_owner | acad_org | varchar | 2147483647 | ||||
ps_acad_plan_owner | acad_plan | varchar | 2147483647 | ||||
ps_acad_plan_owner | effdt | date | 13 | ||||
ps_acad_plan_owner | institution | varchar | 2147483647 | ||||
ps_acad_plan_owner | percent_owned | numeric | 6,3 | √ | null | ||
ps_acad_plan_tbl | acad_career | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | acad_plan | varchar | 2147483647 | ||||
ps_acad_plan_tbl | acad_plan_type | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | acad_prog | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | degree | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | descrlong | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | diploma_descr | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | effdt | date | 13 | ||||
ps_acad_plan_tbl | first_term_valid | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | institution | varchar | 2147483647 | ||||
ps_acad_plan_tbl | ssr_last_adm_term | varchar | 2147483647 | √ | null | ||
ps_acad_plan_tbl | trnscr_descr | varchar | 2147483647 | √ | null | ||
ps_acad_prog | acad_career | varchar | 2147483647 | ||||
ps_acad_prog | acad_load_appr | varchar | 2147483647 | √ | null | ||
ps_acad_prog | acad_prog | varchar | 2147483647 | √ | null | ||
ps_acad_prog | action_dt | date | 13 | √ | null | ||
ps_acad_prog | admit_term | varchar | 2147483647 | √ | null | ||
ps_acad_prog | campus | varchar | 2147483647 | √ | null | ||
ps_acad_prog | completion_term | varchar | 2147483647 | √ | null | ||
ps_acad_prog | data_from_adm_appl | varchar | 2147483647 | √ | null | ||
ps_acad_prog | effdt | date | 13 | ||||
ps_acad_prog | effseq | int4 | 10 | ||||
ps_acad_prog | emplid | varchar | 2147483647 | ||||
ps_acad_prog | exp_grad_term | varchar | 2147483647 | √ | null | ||
ps_acad_prog | institution | varchar | 2147483647 | √ | null | ||
ps_acad_prog | prog_action | varchar | 2147483647 | √ | null | ||
ps_acad_prog | prog_reason | varchar | 2147483647 | √ | null | ||
ps_acad_prog | prog_status | varchar | 2147483647 | √ | null | ||
ps_acad_prog | req_term | varchar | 2147483647 | √ | null | ||
ps_acad_prog | stdnt_car_nbr | int4 | 10 | ||||
ps_acad_prog_tbl | acad_career | varchar | 2147483647 | √ | null | ||
ps_acad_prog_tbl | acad_group | varchar | 2147483647 | √ | null | ||
ps_acad_prog_tbl | acad_org | varchar | 2147483647 | √ | null | ||
ps_acad_prog_tbl | acad_prog | varchar | 2147483647 | ||||
ps_acad_prog_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_acad_prog_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_acad_prog_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_acad_prog_tbl | effdt | date | 13 | ||||
ps_acad_prog_tbl | first_term_valid | varchar | 2147483647 | √ | null | ||
ps_acad_prog_tbl | institution | varchar | 2147483647 | ||||
ps_acad_prog_tbl | level_load_rule | varchar | 2147483647 | √ | null | ||
ps_acad_stactn_tbl | acad_career | varchar | 2147483647 | ||||
ps_acad_stactn_tbl | acad_stndng_actn | varchar | 2147483647 | ||||
ps_acad_stactn_tbl | acad_stndng_stat | varchar | 2147483647 | √ | null | ||
ps_acad_stactn_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_acad_stactn_tbl | descrformal | varchar | 2147483647 | √ | null | ||
ps_acad_stactn_tbl | descrinternal | varchar | 2147483647 | √ | null | ||
ps_acad_stactn_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_acad_stactn_tbl | effdt | date | 13 | ||||
ps_acad_stactn_tbl | institution | varchar | 2147483647 | ||||
ps_acad_stdng_actn | acad_career | varchar | 2147483647 | ||||
ps_acad_stdng_actn | acad_prog | varchar | 2147483647 | √ | null | ||
ps_acad_stdng_actn | acad_stndng_actn | varchar | 2147483647 | √ | null | ||
ps_acad_stdng_actn | acad_stndng_stat | varchar | 2147483647 | √ | null | ||
ps_acad_stdng_actn | action_dt | date | 13 | √ | null | ||
ps_acad_stdng_actn | effdt | date | 13 | ||||
ps_acad_stdng_actn | effseq | int4 | 10 | ||||
ps_acad_stdng_actn | emplid | varchar | 2147483647 | ||||
ps_acad_stdng_actn | institution | varchar | 2147483647 | ||||
ps_acad_stdng_actn | strm | varchar | 2147483647 | ||||
ps_acad_subplan | acad_career | varchar | 2147483647 | ||||
ps_acad_subplan | acad_plan | varchar | 2147483647 | ||||
ps_acad_subplan | acad_sub_plan | varchar | 2147483647 | ||||
ps_acad_subplan | effdt | date | 13 | ||||
ps_acad_subplan | effseq | int4 | 10 | ||||
ps_acad_subplan | emplid | varchar | 2147483647 | ||||
ps_acad_subplan | req_term | varchar | 2147483647 | √ | null | ||
ps_acad_subplan | stdnt_car_nbr | int4 | 10 | ||||
ps_acad_subpln_tbl | acad_plan | varchar | 2147483647 | ||||
ps_acad_subpln_tbl | acad_sub_plan | varchar | 2147483647 | ||||
ps_acad_subpln_tbl | acad_subplan_type | varchar | 2147483647 | √ | null | ||
ps_acad_subpln_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_acad_subpln_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_acad_subpln_tbl | diploma_descr | varchar | 2147483647 | √ | null | ||
ps_acad_subpln_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_acad_subpln_tbl | effdt | date | 13 | ||||
ps_acad_subpln_tbl | first_term_valid | varchar | 2147483647 | √ | null | ||
ps_acad_subpln_tbl | institution | varchar | 2147483647 | ||||
ps_acad_subpln_tbl | ssr_last_adm_term | varchar | 2147483647 | √ | null | ||
ps_acad_subpln_tbl | trnscr_descr | varchar | 2147483647 | √ | null | ||
ps_addresses | address1 | varchar | 2147483647 | √ | null | ||
ps_addresses | address2 | varchar | 2147483647 | √ | null | ||
ps_addresses | address3 | varchar | 2147483647 | √ | null | ||
ps_addresses | address4 | varchar | 2147483647 | √ | null | ||
ps_addresses | address_type | varchar | 2147483647 | ||||
ps_addresses | city | varchar | 2147483647 | √ | null | ||
ps_addresses | country | varchar | 2147483647 | √ | null | ||
ps_addresses | eff_status | varchar | 2147483647 | √ | null | ||
ps_addresses | effdt | date | 13 | ||||
ps_addresses | emplid | varchar | 2147483647 | ||||
ps_addresses | postal | varchar | 2147483647 | √ | null | ||
ps_addresses | state | varchar | 2147483647 | √ | null | ||
ps_bldg_tbl | bldg_cd | varchar | 2147483647 | ||||
ps_bldg_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_bldg_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_bldg_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_bldg_tbl | effdt | date | 13 | ||||
ps_campus_tbl | campus | varchar | 2147483647 | ||||
ps_campus_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_campus_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_campus_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_campus_tbl | effdt | date | 13 | ||||
ps_campus_tbl | institution | varchar | 2147483647 | ||||
ps_campus_tbl | location | varchar | 2147483647 | √ | null | ||
ps_citizen_sts_tbl | citizenship_status | varchar | 2147483647 | ||||
ps_citizen_sts_tbl | country | varchar | 2147483647 | ||||
ps_citizen_sts_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_citizen_sts_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_citizenship | citizenship_status | varchar | 2147483647 | √ | null | ||
ps_citizenship | country | varchar | 2147483647 | ||||
ps_citizenship | emplid | varchar | 2147483647 | ||||
ps_class_assoc | associated_class | int4 | 10 | ||||
ps_class_assoc | component_primary | varchar | 2147483647 | √ | null | ||
ps_class_assoc | crse_id | varchar | 2147483647 | ||||
ps_class_assoc | crse_offer_nbr | int4 | 10 | ||||
ps_class_assoc | grading_basis | varchar | 2147483647 | √ | null | ||
ps_class_assoc | rqmnt_designtn | varchar | 2147483647 | √ | null | ||
ps_class_assoc | session_code | varchar | 2147483647 | ||||
ps_class_assoc | ssr_component | varchar | 2147483647 | √ | null | ||
ps_class_assoc | strm | varchar | 2147483647 | ||||
ps_class_assoc | units_acad_prog | numeric | 5,2 | √ | null | ||
ps_class_assoc | units_minimum | numeric | 5,2 | √ | null | ||
ps_class_instr | class_mtg_nbr | int4 | 10 | ||||
ps_class_instr | class_section | varchar | 2147483647 | ||||
ps_class_instr | crse_id | varchar | 2147483647 | ||||
ps_class_instr | crse_offer_nbr | int4 | 10 | ||||
ps_class_instr | emplid | varchar | 2147483647 | √ | null | ||
ps_class_instr | instr_assign_seq | int4 | 10 | ||||
ps_class_instr | instr_role | varchar | 2147483647 | √ | null | ||
ps_class_instr | session_code | varchar | 2147483647 | ||||
ps_class_instr | strm | varchar | 2147483647 | ||||
ps_class_mtg_pat | class_mtg_nbr | int4 | 10 | ||||
ps_class_mtg_pat | class_section | varchar | 2147483647 | ||||
ps_class_mtg_pat | crse_id | varchar | 2147483647 | ||||
ps_class_mtg_pat | crse_offer_nbr | int4 | 10 | ||||
ps_class_mtg_pat | end_dt | date | 13 | √ | null | ||
ps_class_mtg_pat | facility_id | varchar | 2147483647 | √ | null | ||
ps_class_mtg_pat | fri | varchar | 2147483647 | √ | null | ||
ps_class_mtg_pat | meeting_time_end | time | 15,6 | √ | null | ||
ps_class_mtg_pat | meeting_time_start | time | 15,6 | √ | null | ||
ps_class_mtg_pat | mon | varchar | 2147483647 | √ | null | ||
ps_class_mtg_pat | sat | varchar | 2147483647 | √ | null | ||
ps_class_mtg_pat | session_code | varchar | 2147483647 | ||||
ps_class_mtg_pat | start_dt | date | 13 | √ | null | ||
ps_class_mtg_pat | stnd_mtg_pat | varchar | 2147483647 | √ | null | ||
ps_class_mtg_pat | strm | varchar | 2147483647 | ||||
ps_class_mtg_pat | sun | varchar | 2147483647 | √ | null | ||
ps_class_mtg_pat | thurs | varchar | 2147483647 | √ | null | ||
ps_class_mtg_pat | tues | varchar | 2147483647 | √ | null | ||
ps_class_mtg_pat | wed | varchar | 2147483647 | √ | null | ||
ps_class_notes | class_note_nbr | varchar | 2147483647 | √ | null | ||
ps_class_notes | class_notes_seq | int4 | 10 | ||||
ps_class_notes | class_section | varchar | 2147483647 | ||||
ps_class_notes | crse_id | varchar | 2147483647 | ||||
ps_class_notes | crse_offer_nbr | int4 | 10 | ||||
ps_class_notes | descrlong | varchar | 2147483647 | √ | null | ||
ps_class_notes | session_code | varchar | 2147483647 | ||||
ps_class_notes | strm | varchar | 2147483647 | ||||
ps_class_notes_tbl | class_note_nbr | varchar | 2147483647 | ||||
ps_class_notes_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_class_notes_tbl | descrlong | varchar | 2147483647 | √ | null | ||
ps_class_notes_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_class_notes_tbl | effdt | date | 13 | ||||
ps_class_notes_tbl | institution | varchar | 2147483647 | ||||
ps_class_rsrv_cap | class_section | varchar | 2147483647 | ||||
ps_class_rsrv_cap | crse_id | varchar | 2147483647 | ||||
ps_class_rsrv_cap | crse_offer_nbr | int4 | 10 | ||||
ps_class_rsrv_cap | enrl_cap | int4 | 10 | √ | null | ||
ps_class_rsrv_cap | rqrmnt_group | varchar | 2147483647 | √ | null | ||
ps_class_rsrv_cap | rsrv_cap_nbr | int4 | 10 | ||||
ps_class_rsrv_cap | session_code | varchar | 2147483647 | ||||
ps_class_rsrv_cap | start_dt | date | 13 | ||||
ps_class_rsrv_cap | strm | varchar | 2147483647 | ||||
ps_class_rsrv_grp | class_section | varchar | 2147483647 | ||||
ps_class_rsrv_grp | crse_id | varchar | 2147483647 | ||||
ps_class_rsrv_grp | crse_offer_nbr | int4 | 10 | ||||
ps_class_rsrv_grp | enrl_tot | int4 | 10 | √ | null | ||
ps_class_rsrv_grp | rsrv_cap_nbr | int4 | 10 | ||||
ps_class_rsrv_grp | session_code | varchar | 2147483647 | ||||
ps_class_rsrv_grp | strm | varchar | 2147483647 | ||||
ps_class_tbl | acad_career | varchar | 2147483647 | √ | null | ||
ps_class_tbl | acad_group | varchar | 2147483647 | √ | null | ||
ps_class_tbl | acad_org | varchar | 2147483647 | √ | null | ||
ps_class_tbl | associated_class | int4 | 10 | √ | null | ||
ps_class_tbl | auto_enroll_sect_1 | varchar | 2147483647 | √ | null | ||
ps_class_tbl | auto_enroll_sect_2 | varchar | 2147483647 | √ | null | ||
ps_class_tbl | campus | varchar | 2147483647 | √ | null | ||
ps_class_tbl | catalog_nbr | varchar | 2147483647 | √ | null | ||
ps_class_tbl | class_nbr | int4 | 10 | √ | null | ||
ps_class_tbl | class_section | varchar | 2147483647 | ||||
ps_class_tbl | class_stat | varchar | 2147483647 | √ | null | ||
ps_class_tbl | class_type | varchar | 2147483647 | √ | null | ||
ps_class_tbl | consent | varchar | 2147483647 | √ | null | ||
ps_class_tbl | crs_topic_id | int4 | 10 | √ | null | ||
ps_class_tbl | crse_id | varchar | 2147483647 | ||||
ps_class_tbl | crse_offer_nbr | int4 | 10 | ||||
ps_class_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_class_tbl | enrl_cap | int4 | 10 | √ | null | ||
ps_class_tbl | enrl_stat | varchar | 2147483647 | √ | null | ||
ps_class_tbl | enrl_tot | int4 | 10 | √ | null | ||
ps_class_tbl | institution | varchar | 2147483647 | √ | null | ||
ps_class_tbl | instruction_mode | varchar | 2147483647 | √ | null | ||
ps_class_tbl | location | varchar | 2147483647 | √ | null | ||
ps_class_tbl | room_cap_request | int4 | 10 | √ | null | ||
ps_class_tbl | schedule_print | varchar | 2147483647 | √ | null | ||
ps_class_tbl | session_code | varchar | 2147483647 | ||||
ps_class_tbl | ssr_component | varchar | 2147483647 | √ | null | ||
ps_class_tbl | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
ps_class_tbl | strm | varchar | 2147483647 | ||||
ps_class_tbl | subject | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | acad_career | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | acad_group | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | acad_org | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | associated_class | int4 | 10 | √ | null | ||
ps_class_tbl_as_of | auto_enroll_sect_1 | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | auto_enroll_sect_2 | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | campus | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | catalog_nbr | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | class_nbr | int4 | 10 | √ | null | ||
ps_class_tbl_as_of | class_section | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | class_stat | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | class_type | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | consent | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | crs_topic_id | int4 | 10 | √ | null | ||
ps_class_tbl_as_of | crse_id | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | crse_offer_nbr | int4 | 10 | √ | null | ||
ps_class_tbl_as_of | descr | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | effdt | date | 13 | √ | null | ||
ps_class_tbl_as_of | enrl_cap | int4 | 10 | √ | null | ||
ps_class_tbl_as_of | enrl_stat | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | enrl_tot | int4 | 10 | √ | null | ||
ps_class_tbl_as_of | institution | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | instruction_mode | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | location | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | room_cap_request | int4 | 10 | √ | null | ||
ps_class_tbl_as_of | schedule_print | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | session_code | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | ssr_component | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | strm | varchar | 2147483647 | √ | null | ||
ps_class_tbl_as_of | subject | varchar | 2147483647 | √ | null | ||
ps_country_tbl | country | varchar | 2147483647 | ||||
ps_country_tbl | country_2char | varchar | 2147483647 | √ | null | ||
ps_country_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_country_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_crse_catalog | consent | varchar | 2147483647 | √ | null | ||
ps_crse_catalog | course_title_long | varchar | 2147483647 | √ | null | ||
ps_crse_catalog | crse_id | varchar | 2147483647 | ||||
ps_crse_catalog | descr | varchar | 2147483647 | √ | null | ||
ps_crse_catalog | descrlong | varchar | 2147483647 | √ | null | ||
ps_crse_catalog | eff_status | varchar | 2147483647 | √ | null | ||
ps_crse_catalog | effdt | date | 13 | ||||
ps_crse_catalog | ssr_drop_consent | varchar | 2147483647 | √ | null | ||
ps_crse_catalog | units_acad_prog | numeric | 5,2 | √ | null | ||
ps_crse_catalog | units_minimum | numeric | 5,2 | √ | null | ||
ps_crse_offer | acad_career | varchar | 2147483647 | √ | null | ||
ps_crse_offer | acad_group | varchar | 2147483647 | √ | null | ||
ps_crse_offer | acad_org | varchar | 2147483647 | √ | null | ||
ps_crse_offer | campus | varchar | 2147483647 | √ | null | ||
ps_crse_offer | catalog_nbr | varchar | 2147483647 | √ | null | ||
ps_crse_offer | crse_id | varchar | 2147483647 | ||||
ps_crse_offer | crse_offer_nbr | int4 | 10 | ||||
ps_crse_offer | effdt | date | 13 | ||||
ps_crse_offer | institution | varchar | 2147483647 | √ | null | ||
ps_crse_offer | rqrmnt_group | varchar | 2147483647 | √ | null | ||
ps_crse_offer | schedule_print | varchar | 2147483647 | √ | null | ||
ps_crse_offer | subject | varchar | 2147483647 | √ | null | ||
ps_crse_topics | crs_topic_id | int4 | 10 | ||||
ps_crse_topics | crse_id | varchar | 2147483647 | ||||
ps_crse_topics | descr | varchar | 2147483647 | √ | null | ||
ps_crse_topics | descrformal | varchar | 2147483647 | √ | null | ||
ps_crse_topics | descrshort | varchar | 2147483647 | √ | null | ||
ps_crse_topics | effdt | date | 13 | ||||
ps_degr_honors_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_degr_honors_tbl | descrformal | varchar | 2147483647 | √ | null | ||
ps_degr_honors_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_degr_honors_tbl | diploma_print_fl | varchar | 2147483647 | √ | null | ||
ps_degr_honors_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_degr_honors_tbl | effdt | date | 13 | ||||
ps_degr_honors_tbl | honors_code | varchar | 2147483647 | ||||
ps_degr_honors_tbl | honors_type | varchar | 2147483647 | ||||
ps_degr_honors_tbl | institution | varchar | 2147483647 | ||||
ps_degr_honors_tbl | trnscr_print_fl | varchar | 2147483647 | √ | null | ||
ps_degree_tbl | degree | varchar | 2147483647 | ||||
ps_degree_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_degree_tbl | descrformal | varchar | 2147483647 | √ | null | ||
ps_degree_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_degree_tbl | education_lvl | varchar | 2147483647 | √ | null | ||
ps_degree_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_degree_tbl | effdt | date | 13 | ||||
ps_degree_tbl | internal_degree | varchar | 2147483647 | √ | null | ||
ps_degree_tbl | years_of_educatn | int4 | 10 | √ | null | ||
ps_external_system | effdt | date | 13 | ||||
ps_external_system | emplid | varchar | 2147483647 | ||||
ps_external_system | external_system | varchar | 2147483647 | ||||
ps_external_system | external_system_id | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | acad_org | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | bldg_cd | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | effdt | date | 13 | ||||
ps_facility_tbl | facility_group | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | facility_id | varchar | 2147483647 | ||||
ps_facility_tbl | facility_partition | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | facility_type | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | generl_assign | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | location | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | room | varchar | 2147483647 | √ | null | ||
ps_facility_tbl | room_capacity | int4 | 10 | √ | null | ||
ps_facility_tbl | setid | varchar | 2147483647 | ||||
ps_honor_award_cs | acad_career | varchar | 2147483647 | √ | null | ||
ps_honor_award_cs | acad_plan | varchar | 2147483647 | √ | null | ||
ps_honor_award_cs | acad_prog | varchar | 2147483647 | √ | null | ||
ps_honor_award_cs | award_code | varchar | 2147483647 | √ | null | ||
ps_honor_award_cs | comments | varchar | 2147483647 | √ | null | ||
ps_honor_award_cs | descrformal | varchar | 2147483647 | √ | null | ||
ps_honor_award_cs | dt_recvd | date | 13 | √ | null | ||
ps_honor_award_cs | emplid | varchar | 2147483647 | √ | null | ||
ps_honor_award_cs | institution | varchar | 2147483647 | √ | null | ||
ps_honor_award_cs | internal_external | varchar | 2147483647 | √ | null | ||
ps_honor_award_cs | strm | varchar | 2147483647 | √ | null | ||
ps_honor_award_tbl | award_code | varchar | 2147483647 | ||||
ps_honor_award_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_honor_award_tbl | descrformal | varchar | 2147483647 | √ | null | ||
ps_honor_award_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_honor_award_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_honor_award_tbl | effdt | date | 13 | ||||
ps_honor_award_tbl | grantor | varchar | 2147483647 | √ | null | ||
ps_honor_award_tbl | institution | varchar | 2147483647 | ||||
ps_honor_award_tbl | internal_external | varchar | 2147483647 | √ | null | ||
ps_honor_award_tbl | transcript_level | varchar | 2147483647 | √ | null | ||
ps_instruct_mode | descr | varchar | 2147483647 | √ | null | ||
ps_instruct_mode | descrshort | varchar | 2147483647 | √ | null | ||
ps_instruct_mode | eff_status | varchar | 2147483647 | √ | null | ||
ps_instruct_mode | effdt | date | 13 | ||||
ps_instruct_mode | institution | varchar | 2147483647 | ||||
ps_instruct_mode | instruction_mode | varchar | 2147483647 | ||||
ps_location_tbl | country | varchar | 2147483647 | √ | null | ||
ps_location_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_location_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_location_tbl | effdt | date | 13 | ||||
ps_location_tbl | location | varchar | 2147483647 | ||||
ps_location_tbl | setid | varchar | 2147483647 | ||||
ps_mlstn_atmpt | acad_career | varchar | 2147483647 | ||||
ps_mlstn_atmpt | acad_plan | varchar | 2147483647 | ||||
ps_mlstn_atmpt | acad_prog | varchar | 2147483647 | ||||
ps_mlstn_atmpt | attempt_nbr | int4 | 10 | ||||
ps_mlstn_atmpt | crse_grade_input | varchar | 2147483647 | √ | null | ||
ps_mlstn_atmpt | effdt | date | 13 | ||||
ps_mlstn_atmpt | emplid | varchar | 2147483647 | ||||
ps_mlstn_atmpt | grading_basis | varchar | 2147483647 | √ | null | ||
ps_mlstn_atmpt | institution | varchar | 2147483647 | ||||
ps_mlstn_atmpt | milestone_nbr | int4 | 10 | ||||
ps_names | eff_status | varchar | 2147483647 | √ | null | ||
ps_names | effdt | date | 13 | ||||
ps_names | emplid | varchar | 2147483647 | ||||
ps_names | first_name | varchar | 2147483647 | √ | null | ||
ps_names | last_name | varchar | 2147483647 | √ | null | ||
ps_names | middle_name | varchar | 2147483647 | √ | null | ||
ps_names | name_title | varchar | 2147483647 | √ | null | ||
ps_names | name_type | varchar | 2147483647 | ||||
ps_pers_data_sa_vw | birthdate | date | 13 | √ | null | ||
ps_pers_data_sa_vw | dt_of_death | date | 13 | √ | null | ||
ps_pers_data_sa_vw | emplid | varchar | 2147483647 | ||||
ps_pers_data_sa_vw | sex | varchar | 2147483647 | √ | null | ||
ps_person_sa | emplid | varchar | 2147483647 | ||||
ps_person_sa | ferpa | varchar | 2147483647 | √ | null | ||
ps_personal_phone | country_code | varchar | 2147483647 | √ | null | ||
ps_personal_phone | emplid | varchar | 2147483647 | ||||
ps_personal_phone | extension | varchar | 2147483647 | √ | null | ||
ps_personal_phone | phone | varchar | 2147483647 | √ | null | ||
ps_personal_phone | phone_type | varchar | 2147483647 | ||||
ps_personal_phone | pref_phone_flag | varchar | 2147483647 | √ | null | ||
ps_rq_grp_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_rq_grp_tbl | descr254a | varchar | 2147483647 | √ | null | ||
ps_rq_grp_tbl | descrlong | varchar | 2147483647 | √ | null | ||
ps_rq_grp_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_rq_grp_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_rq_grp_tbl | effdt | date | 13 | ||||
ps_rq_grp_tbl | rqrmnt_group | varchar | 2147483647 | ||||
ps_sctn_cmbnd | class_nbr | int4 | 10 | ||||
ps_sctn_cmbnd | institution | varchar | 2147483647 | ||||
ps_sctn_cmbnd | sctn_combined_id | varchar | 2147483647 | ||||
ps_sctn_cmbnd | session_code | varchar | 2147483647 | ||||
ps_sctn_cmbnd | strm | varchar | 2147483647 | ||||
ps_sctn_cmbnd_tbl | combination_type | varchar | 2147483647 | √ | null | ||
ps_sctn_cmbnd_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_sctn_cmbnd_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_sctn_cmbnd_tbl | enrl_cap | int4 | 10 | √ | null | ||
ps_sctn_cmbnd_tbl | enrl_tot | int4 | 10 | √ | null | ||
ps_sctn_cmbnd_tbl | institution | varchar | 2147483647 | ||||
ps_sctn_cmbnd_tbl | perm_combination | varchar | 2147483647 | √ | null | ||
ps_sctn_cmbnd_tbl | room_cap_request | int4 | 10 | √ | null | ||
ps_sctn_cmbnd_tbl | sctn_combined_id | varchar | 2147483647 | ||||
ps_sctn_cmbnd_tbl | session_code | varchar | 2147483647 | ||||
ps_sctn_cmbnd_tbl | skip_mtgpat_edit | varchar | 2147483647 | √ | null | ||
ps_sctn_cmbnd_tbl | strm | varchar | 2147483647 | ||||
ps_service_impact | descrlong | varchar | 2147483647 | √ | null | ||
ps_service_impact | effdt | date | 13 | ||||
ps_service_impact | institution | varchar | 2147483647 | ||||
ps_service_impact | service_impact | varchar | 2147483647 | ||||
ps_service_impact | srvc_ind_cd | varchar | 2147483647 | ||||
ps_service_impact | term_category | varchar | 2147483647 | ||||
ps_sess_time_perod | acad_career | varchar | 2147483647 | ||||
ps_sess_time_perod | end_dt | date | 13 | √ | null | ||
ps_sess_time_perod | institution | varchar | 2147483647 | ||||
ps_sess_time_perod | session_code | varchar | 2147483647 | ||||
ps_sess_time_perod | strm | varchar | 2147483647 | ||||
ps_sess_time_perod | time_period | varchar | 2147483647 | ||||
ps_session_tbl | acad_career | varchar | 2147483647 | ||||
ps_session_tbl | census_dt | date | 13 | √ | null | ||
ps_session_tbl | enroll_open_dt | date | 13 | √ | null | ||
ps_session_tbl | first_enrl_dt | date | 13 | √ | null | ||
ps_session_tbl | institution | varchar | 2147483647 | ||||
ps_session_tbl | last_enrl_dt | date | 13 | √ | null | ||
ps_session_tbl | last_wait_dt | date | 13 | √ | null | ||
ps_session_tbl | sess_begin_dt | date | 13 | √ | null | ||
ps_session_tbl | sess_end_dt | date | 13 | √ | null | ||
ps_session_tbl | session_code | varchar | 2147483647 | ||||
ps_session_tbl | sessn_appt_cntl | varchar | 2147483647 | √ | null | ||
ps_session_tbl | sessn_enrl_cntl | varchar | 2147483647 | √ | null | ||
ps_session_tbl | sixty_pct_dt | date | 13 | √ | null | ||
ps_session_tbl | strm | varchar | 2147483647 | ||||
ps_session_tbl | weeks_of_instruct | int4 | 10 | √ | null | ||
ps_srvc_in_rsn_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_srvc_in_rsn_tbl | descrlong | varchar | 2147483647 | √ | null | ||
ps_srvc_in_rsn_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_srvc_in_rsn_tbl | effdt | date | 13 | ||||
ps_srvc_in_rsn_tbl | institution | varchar | 2147483647 | ||||
ps_srvc_in_rsn_tbl | srvc_ind_cd | varchar | 2147483647 | ||||
ps_srvc_in_rsn_tbl | srvc_ind_reason | varchar | 2147483647 | ||||
ps_srvc_ind_cd_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_srvc_ind_cd_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_srvc_ind_cd_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_srvc_ind_cd_tbl | effdt | date | 13 | ||||
ps_srvc_ind_cd_tbl | institution | varchar | 2147483647 | ||||
ps_srvc_ind_cd_tbl | pos_srvc_indicator | varchar | 2147483647 | √ | null | ||
ps_srvc_ind_cd_tbl | scc_hold_display | varchar | 2147483647 | √ | null | ||
ps_srvc_ind_cd_tbl | srvc_ind_cd | varchar | 2147483647 | ||||
ps_srvc_ind_data | emplid | varchar | 2147483647 | ||||
ps_srvc_ind_data | institution | varchar | 2147483647 | √ | null | ||
ps_srvc_ind_data | srvc_ind_act_term | varchar | 2147483647 | √ | null | ||
ps_srvc_ind_data | srvc_ind_active_dt | date | 13 | √ | null | ||
ps_srvc_ind_data | srvc_ind_cd | varchar | 2147483647 | √ | null | ||
ps_srvc_ind_data | srvc_ind_dttm | timestamp | 29,6 | ||||
ps_srvc_ind_data | srvc_ind_reason | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_mlstn | acad_career | varchar | 2147483647 | ||||
ps_stdnt_car_mlstn | acad_plan | varchar | 2147483647 | ||||
ps_stdnt_car_mlstn | acad_prog | varchar | 2147483647 | ||||
ps_stdnt_car_mlstn | comments | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_mlstn | date_completed | date | 13 | √ | null | ||
ps_stdnt_car_mlstn | descr | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_mlstn | descrformal | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_mlstn | effdt | date | 13 | ||||
ps_stdnt_car_mlstn | emplid | varchar | 2147483647 | ||||
ps_stdnt_car_mlstn | institution | varchar | 2147483647 | ||||
ps_stdnt_car_mlstn | milestone | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_mlstn | milestone_complete | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_mlstn | milestone_nbr | int4 | 10 | ||||
ps_stdnt_car_mlstn | milestone_title | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_mlstn | transcript_level | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | acad_career | varchar | 2147483647 | ||||
ps_stdnt_car_term | acad_level_proj | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | acad_load_appr | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | acad_prog_primary | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | academic_load | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | cum_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | cum_resident_terms | numeric | 6,3 | √ | null | ||
ps_stdnt_car_term | cur_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | cur_resident_terms | numeric | 6,3 | √ | null | ||
ps_stdnt_car_term | elig_to_enroll | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | emplid | varchar | 2147483647 | ||||
ps_stdnt_car_term | form_of_study | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | grade_points | numeric | 9,3 | √ | null | ||
ps_stdnt_car_term | institution | varchar | 2147483647 | ||||
ps_stdnt_car_term | last_date_attended | date | 13 | √ | null | ||
ps_stdnt_car_term | max_nogpa_unit | numeric | 5,2 | √ | null | ||
ps_stdnt_car_term | max_total_unit | numeric | 5,2 | √ | null | ||
ps_stdnt_car_term | ovrd_max_units | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | registered | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | reset_cum_stats | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | stdnt_car_nbr | int4 | 10 | √ | null | ||
ps_stdnt_car_term | strm | varchar | 2147483647 | ||||
ps_stdnt_car_term | study_agreement | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | tot_audit | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_cumulative | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_grade_points | numeric | 9,3 | √ | null | ||
ps_stdnt_car_term | tot_inprog_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_inprog_nogpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_passd_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_passd_nogpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_passd_prgrss | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_taken_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_taken_nogpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_taken_prgrss | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | tot_trnsfr | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | trf_grade_points | numeric | 9,3 | √ | null | ||
ps_stdnt_car_term | trf_passed_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | trf_passed_nogpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | trf_resident_terms | numeric | 6,3 | √ | null | ||
ps_stdnt_car_term | trf_taken_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | trf_taken_nogpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_audit | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_inprog_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_inprog_nogpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_passd_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_passd_nogpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_passd_prgrss | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_taken_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_taken_nogpa | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_taken_prgrss | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_term_tot | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | unt_trnsfr | numeric | 8,3 | √ | null | ||
ps_stdnt_car_term | withdraw_code | varchar | 2147483647 | √ | null | ||
ps_stdnt_car_term | withdraw_date | date | 13 | √ | null | ||
ps_stdnt_car_term | withdraw_reason | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | acad_career | varchar | 2147483647 | ||||
ps_stdnt_enrl | class_nbr | int4 | 10 | ||||
ps_stdnt_enrl | class_prmsn_nbr | int4 | 10 | √ | null | ||
ps_stdnt_enrl | crse_grade_off | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | earn_credit | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | emplid | varchar | 2147483647 | ||||
ps_stdnt_enrl | enrl_add_dt | date | 13 | √ | null | ||
ps_stdnt_enrl | enrl_drop_dt | date | 13 | √ | null | ||
ps_stdnt_enrl | enrl_status_reason | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | grade_category | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | grade_dt | date | 13 | √ | null | ||
ps_stdnt_enrl | grade_points | numeric | 9,3 | √ | null | ||
ps_stdnt_enrl | grading_basis_enrl | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | include_in_gpa | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | institution | varchar | 2147483647 | ||||
ps_stdnt_enrl | last_drop_dt_stmp | date | 13 | √ | null | ||
ps_stdnt_enrl | last_drop_tm_stmp | time | 15,6 | √ | null | ||
ps_stdnt_enrl | last_enrl_dt_stmp | date | 13 | √ | null | ||
ps_stdnt_enrl | last_enrl_tm_stmp | time | 15,6 | √ | null | ||
ps_stdnt_enrl | last_upd_dt_stmp | date | 13 | √ | null | ||
ps_stdnt_enrl | last_upd_tm_stmp | time | 15,6 | √ | null | ||
ps_stdnt_enrl | oprid | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | rqmnt_designtn | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | rqmnt_designtn_grd | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | rsrv_cap_nbr | int4 | 10 | √ | null | ||
ps_stdnt_enrl | session_code | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | stdnt_enrl_status | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | strm | varchar | 2147483647 | ||||
ps_stdnt_enrl | tscrpt_note_id | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | units_attempted | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl | unt_earned | numeric | 5,2 | √ | null | ||
ps_stdnt_enrl | unt_prgrss | numeric | 5,2 | √ | null | ||
ps_stdnt_enrl | unt_taken | numeric | 5,2 | √ | null | ||
ps_stdnt_enrl | valid_attempt | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl_note | acad_career | varchar | 2147483647 | ||||
ps_stdnt_enrl_note | class_nbr | int4 | 10 | ||||
ps_stdnt_enrl_note | emplid | varchar | 2147483647 | ||||
ps_stdnt_enrl_note | institution | varchar | 2147483647 | ||||
ps_stdnt_enrl_note | strm | varchar | 2147483647 | ||||
ps_stdnt_enrl_note | tscrpt_note254 | varchar | 2147483647 | √ | null | ||
ps_stdnt_enrl_note | tscrpt_note_seq | int4 | 10 | ||||
ps_stdnt_group_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_stdnt_group_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_stdnt_group_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_stdnt_group_tbl | effdt | date | 13 | ||||
ps_stdnt_group_tbl | institution | varchar | 2147483647 | ||||
ps_stdnt_group_tbl | stdnt_group | varchar | 2147483647 | ||||
ps_stdnt_grps_hist | comments | varchar | 2147483647 | √ | null | ||
ps_stdnt_grps_hist | eff_status | varchar | 2147483647 | √ | null | ||
ps_stdnt_grps_hist | effdt | date | 13 | ||||
ps_stdnt_grps_hist | emplid | varchar | 2147483647 | ||||
ps_stdnt_grps_hist | institution | varchar | 2147483647 | ||||
ps_stdnt_grps_hist | stdnt_group | varchar | 2147483647 | ||||
ps_stdnt_spcl_gpa | acad_career | varchar | 2147483647 | ||||
ps_stdnt_spcl_gpa | acad_plan | varchar | 2147483647 | √ | null | ||
ps_stdnt_spcl_gpa | acad_prog | varchar | 2147483647 | √ | null | ||
ps_stdnt_spcl_gpa | acad_sub_plan | varchar | 2147483647 | √ | null | ||
ps_stdnt_spcl_gpa | action_dt | date | 13 | √ | null | ||
ps_stdnt_spcl_gpa | emplid | varchar | 2147483647 | ||||
ps_stdnt_spcl_gpa | gpa_type | varchar | 2147483647 | ||||
ps_stdnt_spcl_gpa | institution | varchar | 2147483647 | ||||
ps_stdnt_spcl_gpa | ls_gpa | numeric | 8,3 | √ | null | ||
ps_stdnt_spcl_gpa | seq_num | int4 | 10 | ||||
ps_stdnt_spcl_gpa | strm | varchar | 2147483647 | ||||
ps_study_agrm_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_study_agrm_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_study_agrm_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_study_agrm_tbl | effdt | date | 13 | ||||
ps_study_agrm_tbl | institution | varchar | 2147483647 | ||||
ps_study_agrm_tbl | study_agreement | varchar | 2147483647 | ||||
ps_subject_tbl | acad_org | varchar | 2147483647 | √ | null | ||
ps_subject_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_subject_tbl | descrformal | varchar | 2147483647 | √ | null | ||
ps_subject_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_subject_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_subject_tbl | effdt | date | 13 | ||||
ps_subject_tbl | institution | varchar | 2147483647 | ||||
ps_subject_tbl | subject | varchar | 2147483647 | ||||
ps_term_tbl | acad_career | varchar | 2147483647 | ||||
ps_term_tbl | acad_year | varchar | 2147483647 | √ | null | ||
ps_term_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_term_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_term_tbl | institution | varchar | 2147483647 | ||||
ps_term_tbl | strm | varchar | 2147483647 | ||||
ps_term_tbl | term_begin_dt | date | 13 | √ | null | ||
ps_term_tbl | term_end_dt | date | 13 | √ | null | ||
ps_term_tbl | weeks_of_instruct | int4 | 10 | √ | null | ||
ps_trns_crse_dtl | acad_career | varchar | 2147483647 | ||||
ps_trns_crse_dtl | articulation_term | varchar | 2147483647 | ||||
ps_trns_crse_dtl | comments | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | crse_grade_input | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | crse_grade_off | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | crse_id | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | crse_offer_nbr | int4 | 10 | √ | null | ||
ps_trns_crse_dtl | descr | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | earn_credit | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | emplid | varchar | 2147483647 | ||||
ps_trns_crse_dtl | ext_term | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | grade_category | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | grading_basis | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | include_in_gpa | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | institution | varchar | 2147483647 | ||||
ps_trns_crse_dtl | model_nbr | int4 | 10 | ||||
ps_trns_crse_dtl | rqmnt_designtn | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | school_crse_nbr | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | school_subject | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | term_year | int4 | 10 | √ | null | ||
ps_trns_crse_dtl | trnsfr_eqvlncy_grp | int4 | 10 | ||||
ps_trns_crse_dtl | trnsfr_eqvlncy_seq | int4 | 10 | ||||
ps_trns_crse_dtl | units_attempted | varchar | 2147483647 | √ | null | ||
ps_trns_crse_dtl | unt_taken | numeric | 5,2 | √ | null | ||
ps_trns_crse_dtl | unt_trnsfr | numeric | 8,3 | √ | null | ||
ps_trns_crse_dtl | valid_attempt | varchar | 2147483647 | √ | null | ||
ps_trns_crse_sch | acad_career | varchar | 2147483647 | ||||
ps_trns_crse_sch | acad_plan | varchar | 2147483647 | √ | null | ||
ps_trns_crse_sch | acad_prog | varchar | 2147483647 | √ | null | ||
ps_trns_crse_sch | comments | varchar | 2147483647 | √ | null | ||
ps_trns_crse_sch | emplid | varchar | 2147483647 | ||||
ps_trns_crse_sch | include_in_gpa | varchar | 2147483647 | √ | null | ||
ps_trns_crse_sch | institution | varchar | 2147483647 | ||||
ps_trns_crse_sch | ls_school_type | varchar | 2147483647 | √ | null | ||
ps_trns_crse_sch | model_nbr | int4 | 10 | ||||
ps_trns_crse_sch | model_status | varchar | 2147483647 | √ | null | ||
ps_trns_crse_sch | src_org_name | varchar | 2147483647 | √ | null | ||
ps_trns_crse_sch | trf_gpa | numeric | 8,3 | √ | null | ||
ps_trns_crse_sch | trf_grade_points | numeric | 9,3 | √ | null | ||
ps_trns_crse_sch | trf_passed_gpa | numeric | 8,3 | √ | null | ||
ps_trns_crse_sch | trf_passed_nogpa | numeric | 8,3 | √ | null | ||
ps_trns_crse_sch | trf_taken_gpa | numeric | 8,3 | √ | null | ||
ps_trns_crse_sch | trf_taken_nogpa | numeric | 8,3 | √ | null | ||
ps_trns_crse_sch | unt_taken | numeric | 5,2 | √ | null | ||
ps_trns_crse_sch | unt_trnsfr | numeric | 8,3 | √ | null | ||
ps_tscrpt_note_tbl | descr | varchar | 2147483647 | √ | null | ||
ps_tscrpt_note_tbl | descrshort | varchar | 2147483647 | √ | null | ||
ps_tscrpt_note_tbl | eff_status | varchar | 2147483647 | √ | null | ||
ps_tscrpt_note_tbl | effdt | date | 13 | ||||
ps_tscrpt_note_tbl | setid | varchar | 2147483647 | ||||
ps_tscrpt_note_tbl | tscrpt_note_id | varchar | 2147483647 | ||||
ps_tscrpt_text | acad_career | varchar | 2147483647 | ||||
ps_tscrpt_text | emplid | varchar | 2147483647 | ||||
ps_tscrpt_text | print_loc_seq | int4 | 10 | ||||
ps_tscrpt_text | text_seq_nbr | int4 | 10 | ||||
ps_tscrpt_text | transcript_level | varchar | 2147483647 | √ | null | ||
ps_tscrpt_text | transcript_text | varchar | 2147483647 | √ | null | ||
ps_tscrpt_text | tscrpt_type | varchar | 2147483647 | √ | null | ||
ps_tscrpt_text_loc | acad_career | varchar | 2147483647 | ||||
ps_tscrpt_text_loc | emplid | varchar | 2147483647 | ||||
ps_tscrpt_text_loc | institution | varchar | 2147483647 | √ | null | ||
ps_tscrpt_text_loc | milestone_nbr | int4 | 10 | √ | null | ||
ps_tscrpt_text_loc | model_nbr | int4 | 10 | √ | null | ||
ps_tscrpt_text_loc | print_loc | varchar | 2147483647 | √ | null | ||
ps_tscrpt_text_loc | print_loc_seq | int4 | 10 | ||||
ps_tscrpt_text_loc | relative_position | varchar | 2147483647 | √ | null | ||
ps_tscrpt_text_loc | stdnt_degr | varchar | 2147483647 | √ | null | ||
ps_tscrpt_text_loc | strm | varchar | 2147483647 | √ | null | ||
ps_uw_acstdng_rule | acad_career | varchar | 2147483647 | ||||
ps_uw_acstdng_rule | acad_stdng_rule | varchar | 2147483647 | ||||
ps_uw_acstdng_rule | academic_level | varchar | 2147483647 | √ | null | ||
ps_uw_acstdng_rule | academic_load | varchar | 2147483647 | √ | null | ||
ps_uw_acstdng_rule | descr | varchar | 2147483647 | √ | null | ||
ps_uw_acstdng_rule | descrshort | varchar | 2147483647 | √ | null | ||
ps_uw_acstdng_rule | effective_term | varchar | 2147483647 | ||||
ps_uw_acstdng_rule | institution | varchar | 2147483647 | ||||
ps_uw_cem_demand | acad_career | varchar | 2147483647 | ||||
ps_uw_cem_demand | campus | varchar | 2147483647 | √ | null | ||
ps_uw_cem_demand | class_nbr | int4 | 10 | ||||
ps_uw_cem_demand | dttm_stamp_sec | timestamp | 29,6 | √ | null | ||
ps_uw_cem_demand | emplid | varchar | 2147483647 | ||||
ps_uw_cem_demand | institution | varchar | 2147483647 | ||||
ps_uw_cem_demand | location | varchar | 2147483647 | √ | null | ||
ps_uw_cem_demand | lock_flag | varchar | 2147483647 | √ | null | ||
ps_uw_cem_demand | oprid | varchar | 2147483647 | √ | null | ||
ps_uw_cem_demand | session_code | varchar | 2147483647 | √ | null | ||
ps_uw_cem_demand | strm | varchar | 2147483647 | ||||
ps_uw_cem_demand | uw_apply_ng_grade | varchar | 2147483647 | √ | null | ||
ps_uw_cem_demand | uw_campus_optn | varchar | 2147483647 | √ | null | ||
ps_uw_cem_demand | uw_instr_mod_optn | varchar | 2147483647 | √ | null | ||
ps_uw_cem_demand | uw_instruct_mod | varchar | 2147483647 | √ | null | ||
ps_uw_cem_demand | uw_priority | int4 | 10 | √ | null | ||
ps_uw_cem_demand_p | acad_career | varchar | 2147483647 | ||||
ps_uw_cem_demand_p | emplid | varchar | 2147483647 | ||||
ps_uw_cem_demand_p | institution | varchar | 2147483647 | ||||
ps_uw_cem_demand_p | strm | varchar | 2147483647 | ||||
ps_uw_cem_demand_p | uw_prefer_evening | varchar | 2147483647 | √ | null | ||
ps_uw_coop_term | acad_career | varchar | 2147483647 | ||||
ps_uw_coop_term | emplid | varchar | 2147483647 | ||||
ps_uw_coop_term | institution | varchar | 2147483647 | ||||
ps_uw_coop_term | strm | varchar | 2147483647 | ||||
ps_uw_coop_term | uw_term_status | varchar | 2147483647 | √ | null | ||
ps_uw_coop_term | uw_wrktrm_status | varchar | 2147483647 | √ | null | ||
ps_uw_oper_data_in | emailid | varchar | 2147483647 | √ | null | ||
ps_uw_oper_data_in | emplid | varchar | 2147483647 | √ | null | ||
ps_uw_oper_data_in | oprid | varchar | 2147483647 | ||||
ps_uw_student_rank | acad_career | varchar | 2147483647 | ||||
ps_uw_student_rank | acad_plan | varchar | 2147483647 | ||||
ps_uw_student_rank | acad_prog | varchar | 2147483647 | ||||
ps_uw_student_rank | action_dt | date | 13 | √ | null | ||
ps_uw_student_rank | emplid | varchar | 2147483647 | ||||
ps_uw_student_rank | institution | varchar | 2147483647 | ||||
ps_uw_student_rank | strm | varchar | 2147483647 | ||||
ps_uw_student_rank | uw_cohort_rank_nbr | int4 | 10 | √ | null | ||
ps_uw_student_rank | uw_cohort_rank_tot | int4 | 10 | √ | null | ||
ps_uw_student_rank | uw_rank_type | varchar | 2147483647 |