[Home] [Help]
142:
143: /*********************** Unit Version Record ************************/
144:
145: TYPE unit_ver_rec_type IS RECORD (
146: unit_cd igs_ps_unit_ver_all.unit_cd%type,
147: version_number igs_ps_unit_ver_all.version_number%type,
148: start_dt igs_ps_unit_ver_all.start_dt%type,
149: review_dt igs_ps_unit_ver_all.review_dt%type,
150: expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
143: /*********************** Unit Version Record ************************/
144:
145: TYPE unit_ver_rec_type IS RECORD (
146: unit_cd igs_ps_unit_ver_all.unit_cd%type,
147: version_number igs_ps_unit_ver_all.version_number%type,
148: start_dt igs_ps_unit_ver_all.start_dt%type,
149: review_dt igs_ps_unit_ver_all.review_dt%type,
150: expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
151: end_dt igs_ps_unit_ver_all.end_dt%type,
144:
145: TYPE unit_ver_rec_type IS RECORD (
146: unit_cd igs_ps_unit_ver_all.unit_cd%type,
147: version_number igs_ps_unit_ver_all.version_number%type,
148: start_dt igs_ps_unit_ver_all.start_dt%type,
149: review_dt igs_ps_unit_ver_all.review_dt%type,
150: expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
151: end_dt igs_ps_unit_ver_all.end_dt%type,
152: unit_status igs_ps_unit_ver_all.unit_status%type,
145: TYPE unit_ver_rec_type IS RECORD (
146: unit_cd igs_ps_unit_ver_all.unit_cd%type,
147: version_number igs_ps_unit_ver_all.version_number%type,
148: start_dt igs_ps_unit_ver_all.start_dt%type,
149: review_dt igs_ps_unit_ver_all.review_dt%type,
150: expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
151: end_dt igs_ps_unit_ver_all.end_dt%type,
152: unit_status igs_ps_unit_ver_all.unit_status%type,
153: title igs_ps_unit_ver_all.title%type,
146: unit_cd igs_ps_unit_ver_all.unit_cd%type,
147: version_number igs_ps_unit_ver_all.version_number%type,
148: start_dt igs_ps_unit_ver_all.start_dt%type,
149: review_dt igs_ps_unit_ver_all.review_dt%type,
150: expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
151: end_dt igs_ps_unit_ver_all.end_dt%type,
152: unit_status igs_ps_unit_ver_all.unit_status%type,
153: title igs_ps_unit_ver_all.title%type,
154: short_title igs_ps_unit_ver_all.short_title%type,
147: version_number igs_ps_unit_ver_all.version_number%type,
148: start_dt igs_ps_unit_ver_all.start_dt%type,
149: review_dt igs_ps_unit_ver_all.review_dt%type,
150: expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
151: end_dt igs_ps_unit_ver_all.end_dt%type,
152: unit_status igs_ps_unit_ver_all.unit_status%type,
153: title igs_ps_unit_ver_all.title%type,
154: short_title igs_ps_unit_ver_all.short_title%type,
155: title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
148: start_dt igs_ps_unit_ver_all.start_dt%type,
149: review_dt igs_ps_unit_ver_all.review_dt%type,
150: expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
151: end_dt igs_ps_unit_ver_all.end_dt%type,
152: unit_status igs_ps_unit_ver_all.unit_status%type,
153: title igs_ps_unit_ver_all.title%type,
154: short_title igs_ps_unit_ver_all.short_title%type,
155: title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
156: abbreviation igs_ps_unit_ver_all.abbreviation%type,
149: review_dt igs_ps_unit_ver_all.review_dt%type,
150: expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
151: end_dt igs_ps_unit_ver_all.end_dt%type,
152: unit_status igs_ps_unit_ver_all.unit_status%type,
153: title igs_ps_unit_ver_all.title%type,
154: short_title igs_ps_unit_ver_all.short_title%type,
155: title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
156: abbreviation igs_ps_unit_ver_all.abbreviation%type,
157: unit_level igs_ps_unit_ver_all.unit_level%type,
150: expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
151: end_dt igs_ps_unit_ver_all.end_dt%type,
152: unit_status igs_ps_unit_ver_all.unit_status%type,
153: title igs_ps_unit_ver_all.title%type,
154: short_title igs_ps_unit_ver_all.short_title%type,
155: title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
156: abbreviation igs_ps_unit_ver_all.abbreviation%type,
157: unit_level igs_ps_unit_ver_all.unit_level%type,
158: credit_point_descriptor igs_ps_unit_ver_all.credit_point_descriptor%type,
151: end_dt igs_ps_unit_ver_all.end_dt%type,
152: unit_status igs_ps_unit_ver_all.unit_status%type,
153: title igs_ps_unit_ver_all.title%type,
154: short_title igs_ps_unit_ver_all.short_title%type,
155: title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
156: abbreviation igs_ps_unit_ver_all.abbreviation%type,
157: unit_level igs_ps_unit_ver_all.unit_level%type,
158: credit_point_descriptor igs_ps_unit_ver_all.credit_point_descriptor%type,
159: enrolled_credit_points igs_ps_unit_ver_all.enrolled_credit_points%type,
152: unit_status igs_ps_unit_ver_all.unit_status%type,
153: title igs_ps_unit_ver_all.title%type,
154: short_title igs_ps_unit_ver_all.short_title%type,
155: title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
156: abbreviation igs_ps_unit_ver_all.abbreviation%type,
157: unit_level igs_ps_unit_ver_all.unit_level%type,
158: credit_point_descriptor igs_ps_unit_ver_all.credit_point_descriptor%type,
159: enrolled_credit_points igs_ps_unit_ver_all.enrolled_credit_points%type,
160: points_override_ind igs_ps_unit_ver_all. points_override_ind%type,
153: title igs_ps_unit_ver_all.title%type,
154: short_title igs_ps_unit_ver_all.short_title%type,
155: title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
156: abbreviation igs_ps_unit_ver_all.abbreviation%type,
157: unit_level igs_ps_unit_ver_all.unit_level%type,
158: credit_point_descriptor igs_ps_unit_ver_all.credit_point_descriptor%type,
159: enrolled_credit_points igs_ps_unit_ver_all.enrolled_credit_points%type,
160: points_override_ind igs_ps_unit_ver_all. points_override_ind%type,
161: supp_exam_permitted_ind igs_ps_unit_ver_all.supp_exam_permitted_ind%type,
154: short_title igs_ps_unit_ver_all.short_title%type,
155: title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
156: abbreviation igs_ps_unit_ver_all.abbreviation%type,
157: unit_level igs_ps_unit_ver_all.unit_level%type,
158: credit_point_descriptor igs_ps_unit_ver_all.credit_point_descriptor%type,
159: enrolled_credit_points igs_ps_unit_ver_all.enrolled_credit_points%type,
160: points_override_ind igs_ps_unit_ver_all. points_override_ind%type,
161: supp_exam_permitted_ind igs_ps_unit_ver_all.supp_exam_permitted_ind%type,
162: coord_person_number igs_pe_person_base_v.person_number%type,
155: title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
156: abbreviation igs_ps_unit_ver_all.abbreviation%type,
157: unit_level igs_ps_unit_ver_all.unit_level%type,
158: credit_point_descriptor igs_ps_unit_ver_all.credit_point_descriptor%type,
159: enrolled_credit_points igs_ps_unit_ver_all.enrolled_credit_points%type,
160: points_override_ind igs_ps_unit_ver_all. points_override_ind%type,
161: supp_exam_permitted_ind igs_ps_unit_ver_all.supp_exam_permitted_ind%type,
162: coord_person_number igs_pe_person_base_v.person_number%type,
163: owner_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%type,
156: abbreviation igs_ps_unit_ver_all.abbreviation%type,
157: unit_level igs_ps_unit_ver_all.unit_level%type,
158: credit_point_descriptor igs_ps_unit_ver_all.credit_point_descriptor%type,
159: enrolled_credit_points igs_ps_unit_ver_all.enrolled_credit_points%type,
160: points_override_ind igs_ps_unit_ver_all. points_override_ind%type,
161: supp_exam_permitted_ind igs_ps_unit_ver_all.supp_exam_permitted_ind%type,
162: coord_person_number igs_pe_person_base_v.person_number%type,
163: owner_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%type,
164: award_course_only_ind igs_ps_unit_ver_all.award_course_only_ind%type,
157: unit_level igs_ps_unit_ver_all.unit_level%type,
158: credit_point_descriptor igs_ps_unit_ver_all.credit_point_descriptor%type,
159: enrolled_credit_points igs_ps_unit_ver_all.enrolled_credit_points%type,
160: points_override_ind igs_ps_unit_ver_all. points_override_ind%type,
161: supp_exam_permitted_ind igs_ps_unit_ver_all.supp_exam_permitted_ind%type,
162: coord_person_number igs_pe_person_base_v.person_number%type,
163: owner_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%type,
164: award_course_only_ind igs_ps_unit_ver_all.award_course_only_ind%type,
165: research_unit_ind igs_ps_unit_ver_all.research_unit_ind%type,
159: enrolled_credit_points igs_ps_unit_ver_all.enrolled_credit_points%type,
160: points_override_ind igs_ps_unit_ver_all. points_override_ind%type,
161: supp_exam_permitted_ind igs_ps_unit_ver_all.supp_exam_permitted_ind%type,
162: coord_person_number igs_pe_person_base_v.person_number%type,
163: owner_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%type,
164: award_course_only_ind igs_ps_unit_ver_all.award_course_only_ind%type,
165: research_unit_ind igs_ps_unit_ver_all.research_unit_ind%type,
166: industrial_ind igs_ps_unit_ver_all.industrial_ind%type,
167: practical_ind igs_ps_unit_ver_all.practical_ind%type,
160: points_override_ind igs_ps_unit_ver_all. points_override_ind%type,
161: supp_exam_permitted_ind igs_ps_unit_ver_all.supp_exam_permitted_ind%type,
162: coord_person_number igs_pe_person_base_v.person_number%type,
163: owner_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%type,
164: award_course_only_ind igs_ps_unit_ver_all.award_course_only_ind%type,
165: research_unit_ind igs_ps_unit_ver_all.research_unit_ind%type,
166: industrial_ind igs_ps_unit_ver_all.industrial_ind%type,
167: practical_ind igs_ps_unit_ver_all.practical_ind%type,
168: repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
161: supp_exam_permitted_ind igs_ps_unit_ver_all.supp_exam_permitted_ind%type,
162: coord_person_number igs_pe_person_base_v.person_number%type,
163: owner_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%type,
164: award_course_only_ind igs_ps_unit_ver_all.award_course_only_ind%type,
165: research_unit_ind igs_ps_unit_ver_all.research_unit_ind%type,
166: industrial_ind igs_ps_unit_ver_all.industrial_ind%type,
167: practical_ind igs_ps_unit_ver_all.practical_ind%type,
168: repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
169: assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
162: coord_person_number igs_pe_person_base_v.person_number%type,
163: owner_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%type,
164: award_course_only_ind igs_ps_unit_ver_all.award_course_only_ind%type,
165: research_unit_ind igs_ps_unit_ver_all.research_unit_ind%type,
166: industrial_ind igs_ps_unit_ver_all.industrial_ind%type,
167: practical_ind igs_ps_unit_ver_all.practical_ind%type,
168: repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
169: assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
170: achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
163: owner_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%type,
164: award_course_only_ind igs_ps_unit_ver_all.award_course_only_ind%type,
165: research_unit_ind igs_ps_unit_ver_all.research_unit_ind%type,
166: industrial_ind igs_ps_unit_ver_all.industrial_ind%type,
167: practical_ind igs_ps_unit_ver_all.practical_ind%type,
168: repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
169: assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
170: achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
171: points_increment igs_ps_unit_ver_all.points_increment%type,
164: award_course_only_ind igs_ps_unit_ver_all.award_course_only_ind%type,
165: research_unit_ind igs_ps_unit_ver_all.research_unit_ind%type,
166: industrial_ind igs_ps_unit_ver_all.industrial_ind%type,
167: practical_ind igs_ps_unit_ver_all.practical_ind%type,
168: repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
169: assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
170: achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
171: points_increment igs_ps_unit_ver_all.points_increment%type,
172: points_min igs_ps_unit_ver_all.points_min%type,
165: research_unit_ind igs_ps_unit_ver_all.research_unit_ind%type,
166: industrial_ind igs_ps_unit_ver_all.industrial_ind%type,
167: practical_ind igs_ps_unit_ver_all.practical_ind%type,
168: repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
169: assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
170: achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
171: points_increment igs_ps_unit_ver_all.points_increment%type,
172: points_min igs_ps_unit_ver_all.points_min%type,
173: points_max igs_ps_unit_ver_all.points_max%type,
166: industrial_ind igs_ps_unit_ver_all.industrial_ind%type,
167: practical_ind igs_ps_unit_ver_all.practical_ind%type,
168: repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
169: assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
170: achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
171: points_increment igs_ps_unit_ver_all.points_increment%type,
172: points_min igs_ps_unit_ver_all.points_min%type,
173: points_max igs_ps_unit_ver_all.points_max%type,
174: unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
167: practical_ind igs_ps_unit_ver_all.practical_ind%type,
168: repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
169: assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
170: achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
171: points_increment igs_ps_unit_ver_all.points_increment%type,
172: points_min igs_ps_unit_ver_all.points_min%type,
173: points_max igs_ps_unit_ver_all.points_max%type,
174: unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
175: subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
168: repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
169: assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
170: achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
171: points_increment igs_ps_unit_ver_all.points_increment%type,
172: points_min igs_ps_unit_ver_all.points_min%type,
173: points_max igs_ps_unit_ver_all.points_max%type,
174: unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
175: subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
176: approval_date igs_ps_unit_ver_all.approval_date%type,
169: assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
170: achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
171: points_increment igs_ps_unit_ver_all.points_increment%type,
172: points_min igs_ps_unit_ver_all.points_min%type,
173: points_max igs_ps_unit_ver_all.points_max%type,
174: unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
175: subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
176: approval_date igs_ps_unit_ver_all.approval_date%type,
177: lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
170: achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
171: points_increment igs_ps_unit_ver_all.points_increment%type,
172: points_min igs_ps_unit_ver_all.points_min%type,
173: points_max igs_ps_unit_ver_all.points_max%type,
174: unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
175: subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
176: approval_date igs_ps_unit_ver_all.approval_date%type,
177: lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
178: lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
171: points_increment igs_ps_unit_ver_all.points_increment%type,
172: points_min igs_ps_unit_ver_all.points_min%type,
173: points_max igs_ps_unit_ver_all.points_max%type,
174: unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
175: subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
176: approval_date igs_ps_unit_ver_all.approval_date%type,
177: lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
178: lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
179: other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
172: points_min igs_ps_unit_ver_all.points_min%type,
173: points_max igs_ps_unit_ver_all.points_max%type,
174: unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
175: subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
176: approval_date igs_ps_unit_ver_all.approval_date%type,
177: lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
178: lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
179: other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
180: clock_hours igs_ps_unit_ver_all.clock_hours%type,
173: points_max igs_ps_unit_ver_all.points_max%type,
174: unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
175: subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
176: approval_date igs_ps_unit_ver_all.approval_date%type,
177: lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
178: lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
179: other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
180: clock_hours igs_ps_unit_ver_all.clock_hours%type,
181: work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
174: unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
175: subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
176: approval_date igs_ps_unit_ver_all.approval_date%type,
177: lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
178: lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
179: other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
180: clock_hours igs_ps_unit_ver_all.clock_hours%type,
181: work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
182: work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
175: subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
176: approval_date igs_ps_unit_ver_all.approval_date%type,
177: lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
178: lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
179: other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
180: clock_hours igs_ps_unit_ver_all.clock_hours%type,
181: work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
182: work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
183: continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
176: approval_date igs_ps_unit_ver_all.approval_date%type,
177: lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
178: lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
179: other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
180: clock_hours igs_ps_unit_ver_all.clock_hours%type,
181: work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
182: work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
183: continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
184: enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
177: lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
178: lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
179: other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
180: clock_hours igs_ps_unit_ver_all.clock_hours%type,
181: work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
182: work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
183: continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
184: enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
185: enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
178: lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
179: other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
180: clock_hours igs_ps_unit_ver_all.clock_hours%type,
181: work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
182: work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
183: continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
184: enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
185: enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
186: enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
179: other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
180: clock_hours igs_ps_unit_ver_all.clock_hours%type,
181: work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
182: work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
183: continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
184: enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
185: enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
186: enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
187: advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
180: clock_hours igs_ps_unit_ver_all.clock_hours%type,
181: work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
182: work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
183: continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
184: enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
185: enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
186: enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
187: advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
188: state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
181: work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
182: work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
183: continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
184: enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
185: enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
186: enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
187: advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
188: state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
189: federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
182: work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
183: continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
184: enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
185: enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
186: enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
187: advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
188: state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
189: federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
190: institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
183: continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
184: enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
185: enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
186: enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
187: advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
188: state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
189: federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
190: institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
191: same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
184: enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
185: enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
186: enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
187: advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
188: state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
189: federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
190: institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
191: same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
192: max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
185: enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
186: enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
187: advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
188: state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
189: federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
190: institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
191: same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
192: max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
193: max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
186: enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
187: advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
188: state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
189: federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
190: institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
191: same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
192: max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
193: max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
194: max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
187: advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
188: state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
189: federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
190: institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
191: same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
192: max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
193: max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
194: max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
195: same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
188: state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
189: federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
190: institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
191: same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
192: max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
193: max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
194: max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
195: same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
196: same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
189: federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
190: institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
191: same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
192: max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
193: max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
194: max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
195: same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
196: same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
197: attribute_category igs_ps_unit_ver_all.attribute_category%type,
190: institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
191: same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
192: max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
193: max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
194: max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
195: same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
196: same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
197: attribute_category igs_ps_unit_ver_all.attribute_category%type,
198: attribute1 igs_ps_unit_ver_all.attribute1%type,
191: same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
192: max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
193: max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
194: max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
195: same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
196: same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
197: attribute_category igs_ps_unit_ver_all.attribute_category%type,
198: attribute1 igs_ps_unit_ver_all.attribute1%type,
199: attribute2 igs_ps_unit_ver_all.attribute2%type,
192: max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
193: max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
194: max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
195: same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
196: same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
197: attribute_category igs_ps_unit_ver_all.attribute_category%type,
198: attribute1 igs_ps_unit_ver_all.attribute1%type,
199: attribute2 igs_ps_unit_ver_all.attribute2%type,
200: attribute3 igs_ps_unit_ver_all.attribute3%type,
193: max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
194: max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
195: same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
196: same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
197: attribute_category igs_ps_unit_ver_all.attribute_category%type,
198: attribute1 igs_ps_unit_ver_all.attribute1%type,
199: attribute2 igs_ps_unit_ver_all.attribute2%type,
200: attribute3 igs_ps_unit_ver_all.attribute3%type,
201: attribute4 igs_ps_unit_ver_all.attribute4%type,
194: max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
195: same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
196: same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
197: attribute_category igs_ps_unit_ver_all.attribute_category%type,
198: attribute1 igs_ps_unit_ver_all.attribute1%type,
199: attribute2 igs_ps_unit_ver_all.attribute2%type,
200: attribute3 igs_ps_unit_ver_all.attribute3%type,
201: attribute4 igs_ps_unit_ver_all.attribute4%type,
202: attribute5 igs_ps_unit_ver_all.attribute5%type,
195: same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
196: same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
197: attribute_category igs_ps_unit_ver_all.attribute_category%type,
198: attribute1 igs_ps_unit_ver_all.attribute1%type,
199: attribute2 igs_ps_unit_ver_all.attribute2%type,
200: attribute3 igs_ps_unit_ver_all.attribute3%type,
201: attribute4 igs_ps_unit_ver_all.attribute4%type,
202: attribute5 igs_ps_unit_ver_all.attribute5%type,
203: attribute6 igs_ps_unit_ver_all.attribute6%type,
196: same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
197: attribute_category igs_ps_unit_ver_all.attribute_category%type,
198: attribute1 igs_ps_unit_ver_all.attribute1%type,
199: attribute2 igs_ps_unit_ver_all.attribute2%type,
200: attribute3 igs_ps_unit_ver_all.attribute3%type,
201: attribute4 igs_ps_unit_ver_all.attribute4%type,
202: attribute5 igs_ps_unit_ver_all.attribute5%type,
203: attribute6 igs_ps_unit_ver_all.attribute6%type,
204: attribute7 igs_ps_unit_ver_all.attribute7%type,
197: attribute_category igs_ps_unit_ver_all.attribute_category%type,
198: attribute1 igs_ps_unit_ver_all.attribute1%type,
199: attribute2 igs_ps_unit_ver_all.attribute2%type,
200: attribute3 igs_ps_unit_ver_all.attribute3%type,
201: attribute4 igs_ps_unit_ver_all.attribute4%type,
202: attribute5 igs_ps_unit_ver_all.attribute5%type,
203: attribute6 igs_ps_unit_ver_all.attribute6%type,
204: attribute7 igs_ps_unit_ver_all.attribute7%type,
205: attribute8 igs_ps_unit_ver_all.attribute8%type,
198: attribute1 igs_ps_unit_ver_all.attribute1%type,
199: attribute2 igs_ps_unit_ver_all.attribute2%type,
200: attribute3 igs_ps_unit_ver_all.attribute3%type,
201: attribute4 igs_ps_unit_ver_all.attribute4%type,
202: attribute5 igs_ps_unit_ver_all.attribute5%type,
203: attribute6 igs_ps_unit_ver_all.attribute6%type,
204: attribute7 igs_ps_unit_ver_all.attribute7%type,
205: attribute8 igs_ps_unit_ver_all.attribute8%type,
206: attribute9 igs_ps_unit_ver_all.attribute9%type,
199: attribute2 igs_ps_unit_ver_all.attribute2%type,
200: attribute3 igs_ps_unit_ver_all.attribute3%type,
201: attribute4 igs_ps_unit_ver_all.attribute4%type,
202: attribute5 igs_ps_unit_ver_all.attribute5%type,
203: attribute6 igs_ps_unit_ver_all.attribute6%type,
204: attribute7 igs_ps_unit_ver_all.attribute7%type,
205: attribute8 igs_ps_unit_ver_all.attribute8%type,
206: attribute9 igs_ps_unit_ver_all.attribute9%type,
207: attribute10 igs_ps_unit_ver_all.attribute10%type,
200: attribute3 igs_ps_unit_ver_all.attribute3%type,
201: attribute4 igs_ps_unit_ver_all.attribute4%type,
202: attribute5 igs_ps_unit_ver_all.attribute5%type,
203: attribute6 igs_ps_unit_ver_all.attribute6%type,
204: attribute7 igs_ps_unit_ver_all.attribute7%type,
205: attribute8 igs_ps_unit_ver_all.attribute8%type,
206: attribute9 igs_ps_unit_ver_all.attribute9%type,
207: attribute10 igs_ps_unit_ver_all.attribute10%type,
208: attribute11 igs_ps_unit_ver_all.attribute11%type,
201: attribute4 igs_ps_unit_ver_all.attribute4%type,
202: attribute5 igs_ps_unit_ver_all.attribute5%type,
203: attribute6 igs_ps_unit_ver_all.attribute6%type,
204: attribute7 igs_ps_unit_ver_all.attribute7%type,
205: attribute8 igs_ps_unit_ver_all.attribute8%type,
206: attribute9 igs_ps_unit_ver_all.attribute9%type,
207: attribute10 igs_ps_unit_ver_all.attribute10%type,
208: attribute11 igs_ps_unit_ver_all.attribute11%type,
209: attribute12 igs_ps_unit_ver_all.attribute12%type,
202: attribute5 igs_ps_unit_ver_all.attribute5%type,
203: attribute6 igs_ps_unit_ver_all.attribute6%type,
204: attribute7 igs_ps_unit_ver_all.attribute7%type,
205: attribute8 igs_ps_unit_ver_all.attribute8%type,
206: attribute9 igs_ps_unit_ver_all.attribute9%type,
207: attribute10 igs_ps_unit_ver_all.attribute10%type,
208: attribute11 igs_ps_unit_ver_all.attribute11%type,
209: attribute12 igs_ps_unit_ver_all.attribute12%type,
210: attribute13 igs_ps_unit_ver_all.attribute13%type,
203: attribute6 igs_ps_unit_ver_all.attribute6%type,
204: attribute7 igs_ps_unit_ver_all.attribute7%type,
205: attribute8 igs_ps_unit_ver_all.attribute8%type,
206: attribute9 igs_ps_unit_ver_all.attribute9%type,
207: attribute10 igs_ps_unit_ver_all.attribute10%type,
208: attribute11 igs_ps_unit_ver_all.attribute11%type,
209: attribute12 igs_ps_unit_ver_all.attribute12%type,
210: attribute13 igs_ps_unit_ver_all.attribute13%type,
211: attribute14 igs_ps_unit_ver_all.attribute14%type,
204: attribute7 igs_ps_unit_ver_all.attribute7%type,
205: attribute8 igs_ps_unit_ver_all.attribute8%type,
206: attribute9 igs_ps_unit_ver_all.attribute9%type,
207: attribute10 igs_ps_unit_ver_all.attribute10%type,
208: attribute11 igs_ps_unit_ver_all.attribute11%type,
209: attribute12 igs_ps_unit_ver_all.attribute12%type,
210: attribute13 igs_ps_unit_ver_all.attribute13%type,
211: attribute14 igs_ps_unit_ver_all.attribute14%type,
212: attribute15 igs_ps_unit_ver_all.attribute15%type,
205: attribute8 igs_ps_unit_ver_all.attribute8%type,
206: attribute9 igs_ps_unit_ver_all.attribute9%type,
207: attribute10 igs_ps_unit_ver_all.attribute10%type,
208: attribute11 igs_ps_unit_ver_all.attribute11%type,
209: attribute12 igs_ps_unit_ver_all.attribute12%type,
210: attribute13 igs_ps_unit_ver_all.attribute13%type,
211: attribute14 igs_ps_unit_ver_all.attribute14%type,
212: attribute15 igs_ps_unit_ver_all.attribute15%type,
213: attribute16 igs_ps_unit_ver_all.attribute16%type,
206: attribute9 igs_ps_unit_ver_all.attribute9%type,
207: attribute10 igs_ps_unit_ver_all.attribute10%type,
208: attribute11 igs_ps_unit_ver_all.attribute11%type,
209: attribute12 igs_ps_unit_ver_all.attribute12%type,
210: attribute13 igs_ps_unit_ver_all.attribute13%type,
211: attribute14 igs_ps_unit_ver_all.attribute14%type,
212: attribute15 igs_ps_unit_ver_all.attribute15%type,
213: attribute16 igs_ps_unit_ver_all.attribute16%type,
214: attribute17 igs_ps_unit_ver_all.attribute17%type,
207: attribute10 igs_ps_unit_ver_all.attribute10%type,
208: attribute11 igs_ps_unit_ver_all.attribute11%type,
209: attribute12 igs_ps_unit_ver_all.attribute12%type,
210: attribute13 igs_ps_unit_ver_all.attribute13%type,
211: attribute14 igs_ps_unit_ver_all.attribute14%type,
212: attribute15 igs_ps_unit_ver_all.attribute15%type,
213: attribute16 igs_ps_unit_ver_all.attribute16%type,
214: attribute17 igs_ps_unit_ver_all.attribute17%type,
215: attribute18 igs_ps_unit_ver_all.attribute18%type,
208: attribute11 igs_ps_unit_ver_all.attribute11%type,
209: attribute12 igs_ps_unit_ver_all.attribute12%type,
210: attribute13 igs_ps_unit_ver_all.attribute13%type,
211: attribute14 igs_ps_unit_ver_all.attribute14%type,
212: attribute15 igs_ps_unit_ver_all.attribute15%type,
213: attribute16 igs_ps_unit_ver_all.attribute16%type,
214: attribute17 igs_ps_unit_ver_all.attribute17%type,
215: attribute18 igs_ps_unit_ver_all.attribute18%type,
216: attribute19 igs_ps_unit_ver_all.attribute19%type,
209: attribute12 igs_ps_unit_ver_all.attribute12%type,
210: attribute13 igs_ps_unit_ver_all.attribute13%type,
211: attribute14 igs_ps_unit_ver_all.attribute14%type,
212: attribute15 igs_ps_unit_ver_all.attribute15%type,
213: attribute16 igs_ps_unit_ver_all.attribute16%type,
214: attribute17 igs_ps_unit_ver_all.attribute17%type,
215: attribute18 igs_ps_unit_ver_all.attribute18%type,
216: attribute19 igs_ps_unit_ver_all.attribute19%type,
217: attribute20 igs_ps_unit_ver_all.attribute20%type,
210: attribute13 igs_ps_unit_ver_all.attribute13%type,
211: attribute14 igs_ps_unit_ver_all.attribute14%type,
212: attribute15 igs_ps_unit_ver_all.attribute15%type,
213: attribute16 igs_ps_unit_ver_all.attribute16%type,
214: attribute17 igs_ps_unit_ver_all.attribute17%type,
215: attribute18 igs_ps_unit_ver_all.attribute18%type,
216: attribute19 igs_ps_unit_ver_all.attribute19%type,
217: attribute20 igs_ps_unit_ver_all.attribute20%type,
218: ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
211: attribute14 igs_ps_unit_ver_all.attribute14%type,
212: attribute15 igs_ps_unit_ver_all.attribute15%type,
213: attribute16 igs_ps_unit_ver_all.attribute16%type,
214: attribute17 igs_ps_unit_ver_all.attribute17%type,
215: attribute18 igs_ps_unit_ver_all.attribute18%type,
216: attribute19 igs_ps_unit_ver_all.attribute19%type,
217: attribute20 igs_ps_unit_ver_all.attribute20%type,
218: ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
219: ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
212: attribute15 igs_ps_unit_ver_all.attribute15%type,
213: attribute16 igs_ps_unit_ver_all.attribute16%type,
214: attribute17 igs_ps_unit_ver_all.attribute17%type,
215: attribute18 igs_ps_unit_ver_all.attribute18%type,
216: attribute19 igs_ps_unit_ver_all.attribute19%type,
217: attribute20 igs_ps_unit_ver_all.attribute20%type,
218: ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
219: ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
220: work_load_other igs_ps_unit_ver_all.work_load_other%type,
213: attribute16 igs_ps_unit_ver_all.attribute16%type,
214: attribute17 igs_ps_unit_ver_all.attribute17%type,
215: attribute18 igs_ps_unit_ver_all.attribute18%type,
216: attribute19 igs_ps_unit_ver_all.attribute19%type,
217: attribute20 igs_ps_unit_ver_all.attribute20%type,
218: ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
219: ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
220: work_load_other igs_ps_unit_ver_all.work_load_other%type,
221: contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
214: attribute17 igs_ps_unit_ver_all.attribute17%type,
215: attribute18 igs_ps_unit_ver_all.attribute18%type,
216: attribute19 igs_ps_unit_ver_all.attribute19%type,
217: attribute20 igs_ps_unit_ver_all.attribute20%type,
218: ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
219: ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
220: work_load_other igs_ps_unit_ver_all.work_load_other%type,
221: contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
222: contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
215: attribute18 igs_ps_unit_ver_all.attribute18%type,
216: attribute19 igs_ps_unit_ver_all.attribute19%type,
217: attribute20 igs_ps_unit_ver_all.attribute20%type,
218: ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
219: ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
220: work_load_other igs_ps_unit_ver_all.work_load_other%type,
221: contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
222: contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
223: contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
216: attribute19 igs_ps_unit_ver_all.attribute19%type,
217: attribute20 igs_ps_unit_ver_all.attribute20%type,
218: ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
219: ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
220: work_load_other igs_ps_unit_ver_all.work_load_other%type,
221: contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
222: contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
223: contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
224: non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
217: attribute20 igs_ps_unit_ver_all.attribute20%type,
218: ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
219: ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
220: work_load_other igs_ps_unit_ver_all.work_load_other%type,
221: contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
222: contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
223: contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
224: non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
225: exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
218: ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
219: ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
220: work_load_other igs_ps_unit_ver_all.work_load_other%type,
221: contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
222: contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
223: contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
224: non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
225: exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
226: record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
219: ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
220: work_load_other igs_ps_unit_ver_all.work_load_other%type,
221: contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
222: contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
223: contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
224: non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
225: exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
226: record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
227: ss_display_ind igs_ps_unit_ver_all.ss_display_ind%type,
220: work_load_other igs_ps_unit_ver_all.work_load_other%type,
221: contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
222: contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
223: contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
224: non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
225: exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
226: record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
227: ss_display_ind igs_ps_unit_ver_all.ss_display_ind%type,
228: enrol_load_alt_cd igs_ca_inst_all.alternate_code%type,
221: contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
222: contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
223: contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
224: non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
225: exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
226: record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
227: ss_display_ind igs_ps_unit_ver_all.ss_display_ind%type,
228: enrol_load_alt_cd igs_ca_inst_all.alternate_code%type,
229: offer_load_alt_cd igs_ca_inst_all.alternate_code%type,
222: contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
223: contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
224: non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
225: exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
226: record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
227: ss_display_ind igs_ps_unit_ver_all.ss_display_ind%type,
228: enrol_load_alt_cd igs_ca_inst_all.alternate_code%type,
229: offer_load_alt_cd igs_ca_inst_all.alternate_code%type,
230: override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%type,
223: contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
224: non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
225: exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
226: record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
227: ss_display_ind igs_ps_unit_ver_all.ss_display_ind%type,
228: enrol_load_alt_cd igs_ca_inst_all.alternate_code%type,
229: offer_load_alt_cd igs_ca_inst_all.alternate_code%type,
230: override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%type,
231: repeat_code igs_ps_rpt_fmly_all.repeat_code%type,
226: record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
227: ss_display_ind igs_ps_unit_ver_all.ss_display_ind%type,
228: enrol_load_alt_cd igs_ca_inst_all.alternate_code%type,
229: offer_load_alt_cd igs_ca_inst_all.alternate_code%type,
230: override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%type,
231: repeat_code igs_ps_rpt_fmly_all.repeat_code%type,
232: level_code igs_ps_unit_type_lvl.level_code%type,
233: special_permission_ind igs_ps_unit_ver_all.special_permission_ind%type,
234: rev_account_cd igs_ps_unit_ver_all.rev_account_cd%type,
229: offer_load_alt_cd igs_ca_inst_all.alternate_code%type,
230: override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%type,
231: repeat_code igs_ps_rpt_fmly_all.repeat_code%type,
232: level_code igs_ps_unit_type_lvl.level_code%type,
233: special_permission_ind igs_ps_unit_ver_all.special_permission_ind%type,
234: rev_account_cd igs_ps_unit_ver_all.rev_account_cd%type,
235: claimable_hours igs_ps_unit_ver_all.claimable_hours%type,
236: anon_unit_grading_ind igs_ps_unit_ver_all.anon_unit_grading_ind%type,
237: anon_assess_grading_ind igs_ps_unit_ver_all.anon_assess_grading_ind%type,
230: override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%type,
231: repeat_code igs_ps_rpt_fmly_all.repeat_code%type,
232: level_code igs_ps_unit_type_lvl.level_code%type,
233: special_permission_ind igs_ps_unit_ver_all.special_permission_ind%type,
234: rev_account_cd igs_ps_unit_ver_all.rev_account_cd%type,
235: claimable_hours igs_ps_unit_ver_all.claimable_hours%type,
236: anon_unit_grading_ind igs_ps_unit_ver_all.anon_unit_grading_ind%type,
237: anon_assess_grading_ind igs_ps_unit_ver_all.anon_assess_grading_ind%type,
238: subtitle igs_ps_unit_subtitle.subtitle%type,
231: repeat_code igs_ps_rpt_fmly_all.repeat_code%type,
232: level_code igs_ps_unit_type_lvl.level_code%type,
233: special_permission_ind igs_ps_unit_ver_all.special_permission_ind%type,
234: rev_account_cd igs_ps_unit_ver_all.rev_account_cd%type,
235: claimable_hours igs_ps_unit_ver_all.claimable_hours%type,
236: anon_unit_grading_ind igs_ps_unit_ver_all.anon_unit_grading_ind%type,
237: anon_assess_grading_ind igs_ps_unit_ver_all.anon_assess_grading_ind%type,
238: subtitle igs_ps_unit_subtitle.subtitle%type,
239: subtitle_approved_ind igs_ps_unit_subtitle.approved_ind%type,
232: level_code igs_ps_unit_type_lvl.level_code%type,
233: special_permission_ind igs_ps_unit_ver_all.special_permission_ind%type,
234: rev_account_cd igs_ps_unit_ver_all.rev_account_cd%type,
235: claimable_hours igs_ps_unit_ver_all.claimable_hours%type,
236: anon_unit_grading_ind igs_ps_unit_ver_all.anon_unit_grading_ind%type,
237: anon_assess_grading_ind igs_ps_unit_ver_all.anon_assess_grading_ind%type,
238: subtitle igs_ps_unit_subtitle.subtitle%type,
239: subtitle_approved_ind igs_ps_unit_subtitle.approved_ind%type,
240: subtitle_closed_ind igs_ps_unit_subtitle.closed_ind%type,
233: special_permission_ind igs_ps_unit_ver_all.special_permission_ind%type,
234: rev_account_cd igs_ps_unit_ver_all.rev_account_cd%type,
235: claimable_hours igs_ps_unit_ver_all.claimable_hours%type,
236: anon_unit_grading_ind igs_ps_unit_ver_all.anon_unit_grading_ind%type,
237: anon_assess_grading_ind igs_ps_unit_ver_all.anon_assess_grading_ind%type,
238: subtitle igs_ps_unit_subtitle.subtitle%type,
239: subtitle_approved_ind igs_ps_unit_subtitle.approved_ind%type,
240: subtitle_closed_ind igs_ps_unit_subtitle.closed_ind%type,
241: curriculum_id igs_ps_unt_crclm_all.curriculum_id%type,
240: subtitle_closed_ind igs_ps_unit_subtitle.closed_ind%type,
241: curriculum_id igs_ps_unt_crclm_all.curriculum_id%type,
242: curriculum_description igs_ps_unt_crclm_all.description%type,
243: curriculum_closed_ind igs_ps_unt_crclm_all.closed_ind%type,
244: auditable_ind igs_ps_unit_ver_all.auditable_ind%type,
245: audit_permission_ind igs_ps_unit_ver_all.audit_permission_ind%type,
246: max_auditors_allowed igs_ps_unit_ver_all.max_auditors_allowed%type,
247: billing_credit_points igs_ps_unit_ver_all.billing_credit_points%type,
248: ovrd_wkld_val_flag igs_ps_unit_ver_all.ovrd_wkld_val_flag%type,
241: curriculum_id igs_ps_unt_crclm_all.curriculum_id%type,
242: curriculum_description igs_ps_unt_crclm_all.description%type,
243: curriculum_closed_ind igs_ps_unt_crclm_all.closed_ind%type,
244: auditable_ind igs_ps_unit_ver_all.auditable_ind%type,
245: audit_permission_ind igs_ps_unit_ver_all.audit_permission_ind%type,
246: max_auditors_allowed igs_ps_unit_ver_all.max_auditors_allowed%type,
247: billing_credit_points igs_ps_unit_ver_all.billing_credit_points%type,
248: ovrd_wkld_val_flag igs_ps_unit_ver_all.ovrd_wkld_val_flag%type,
249: workload_val_code igs_ps_unit_ver_all.workload_val_code%type,
242: curriculum_description igs_ps_unt_crclm_all.description%type,
243: curriculum_closed_ind igs_ps_unt_crclm_all.closed_ind%type,
244: auditable_ind igs_ps_unit_ver_all.auditable_ind%type,
245: audit_permission_ind igs_ps_unit_ver_all.audit_permission_ind%type,
246: max_auditors_allowed igs_ps_unit_ver_all.max_auditors_allowed%type,
247: billing_credit_points igs_ps_unit_ver_all.billing_credit_points%type,
248: ovrd_wkld_val_flag igs_ps_unit_ver_all.ovrd_wkld_val_flag%type,
249: workload_val_code igs_ps_unit_ver_all.workload_val_code%type,
250: billing_hrs igs_ps_unit_ver_all.billing_hrs%type,
243: curriculum_closed_ind igs_ps_unt_crclm_all.closed_ind%type,
244: auditable_ind igs_ps_unit_ver_all.auditable_ind%type,
245: audit_permission_ind igs_ps_unit_ver_all.audit_permission_ind%type,
246: max_auditors_allowed igs_ps_unit_ver_all.max_auditors_allowed%type,
247: billing_credit_points igs_ps_unit_ver_all.billing_credit_points%type,
248: ovrd_wkld_val_flag igs_ps_unit_ver_all.ovrd_wkld_val_flag%type,
249: workload_val_code igs_ps_unit_ver_all.workload_val_code%type,
250: billing_hrs igs_ps_unit_ver_all.billing_hrs%type,
251: interface_id NUMBER(15),
244: auditable_ind igs_ps_unit_ver_all.auditable_ind%type,
245: audit_permission_ind igs_ps_unit_ver_all.audit_permission_ind%type,
246: max_auditors_allowed igs_ps_unit_ver_all.max_auditors_allowed%type,
247: billing_credit_points igs_ps_unit_ver_all.billing_credit_points%type,
248: ovrd_wkld_val_flag igs_ps_unit_ver_all.ovrd_wkld_val_flag%type,
249: workload_val_code igs_ps_unit_ver_all.workload_val_code%type,
250: billing_hrs igs_ps_unit_ver_all.billing_hrs%type,
251: interface_id NUMBER(15),
252: msg_from NUMBER(6),
245: audit_permission_ind igs_ps_unit_ver_all.audit_permission_ind%type,
246: max_auditors_allowed igs_ps_unit_ver_all.max_auditors_allowed%type,
247: billing_credit_points igs_ps_unit_ver_all.billing_credit_points%type,
248: ovrd_wkld_val_flag igs_ps_unit_ver_all.ovrd_wkld_val_flag%type,
249: workload_val_code igs_ps_unit_ver_all.workload_val_code%type,
250: billing_hrs igs_ps_unit_ver_all.billing_hrs%type,
251: interface_id NUMBER(15),
252: msg_from NUMBER(6),
253: msg_to NUMBER(6),
246: max_auditors_allowed igs_ps_unit_ver_all.max_auditors_allowed%type,
247: billing_credit_points igs_ps_unit_ver_all.billing_credit_points%type,
248: ovrd_wkld_val_flag igs_ps_unit_ver_all.ovrd_wkld_val_flag%type,
249: workload_val_code igs_ps_unit_ver_all.workload_val_code%type,
250: billing_hrs igs_ps_unit_ver_all.billing_hrs%type,
251: interface_id NUMBER(15),
252: msg_from NUMBER(6),
253: msg_to NUMBER(6),
254: status VARCHAR2(1)
398: msg_from NUMBER(6),
399: msg_to NUMBER(6),
400: status VARCHAR2(1),
401: not_multiple_section_flag igs_ps_unit_ofr_opt_all.not_multiple_section_flag%TYPE,
402: sup_unit_cd igs_ps_unit_ver_all.unit_cd%type,
403: sup_version_number igs_ps_unit_ver_all.version_number%type,
404: sup_teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
405: sup_location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
406: sup_unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
399: msg_to NUMBER(6),
400: status VARCHAR2(1),
401: not_multiple_section_flag igs_ps_unit_ofr_opt_all.not_multiple_section_flag%TYPE,
402: sup_unit_cd igs_ps_unit_ver_all.unit_cd%type,
403: sup_version_number igs_ps_unit_ver_all.version_number%type,
404: sup_teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
405: sup_location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
406: sup_unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
407: default_enroll_flag igs_ps_unit_ofr_opt_all.default_enroll_flag%type,
413:
414: /*********************** Unit Section Grading Schema ************************/
415:
416: TYPE usec_gs_rec_type IS RECORD (
417: unit_cd igs_ps_unit_ver_all.unit_cd%type,
418: version_number igs_ps_unit_ver_all.version_number%type,
419: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
420: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
421: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
414: /*********************** Unit Section Grading Schema ************************/
415:
416: TYPE usec_gs_rec_type IS RECORD (
417: unit_cd igs_ps_unit_ver_all.unit_cd%type,
418: version_number igs_ps_unit_ver_all.version_number%type,
419: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
420: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
421: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
422: grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%type,
434: /*********************** Unit Section Occurrences ************************/
435:
436:
437: TYPE uso_rec_type IS RECORD (
438: unit_cd igs_ps_unit_ver_all.unit_cd%type,
439: version_number igs_ps_unit_ver_all.version_number%type,
440: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
441: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
442: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
435:
436:
437: TYPE uso_rec_type IS RECORD (
438: unit_cd igs_ps_unit_ver_all.unit_cd%type,
439: version_number igs_ps_unit_ver_all.version_number%type,
440: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
441: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
442: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
443: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
493: /*********************** Reference Codes ************************/
494:
495: TYPE unit_ref_rec_type IS RECORD (
496: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
497: unit_cd igs_ps_unit_ver_all.unit_cd%type,
498: version_number igs_ps_unit_ver_all.version_number%type,
499: data_type varchar2(10),
500: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
501: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
494:
495: TYPE unit_ref_rec_type IS RECORD (
496: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
497: unit_cd igs_ps_unit_ver_all.unit_cd%type,
498: version_number igs_ps_unit_ver_all.version_number%type,
499: data_type varchar2(10),
500: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
501: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
502: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
516: /********************** Unit Section Occurrence Instructor ************/
517: TYPE uso_ins_rec_type IS RECORD (
518: instructor_person_number hz_parties.party_number%TYPE,
519: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
520: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
521: version_number igs_ps_unit_ver_all.version_number%TYPE,
522: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
523: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
524: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
517: TYPE uso_ins_rec_type IS RECORD (
518: instructor_person_number hz_parties.party_number%TYPE,
519: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
520: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
521: version_number igs_ps_unit_ver_all.version_number%TYPE,
522: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
523: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
524: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
525: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
541: TYPE uso_ins_tbl_type IS TABLE OF uso_ins_rec_type INDEX BY BINARY_INTEGER;
542:
543: /********************** Unit Section Occurrence facilities ************/
544: TYPE usec_occurs_facility_rec_type IS RECORD (
545: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
546: version_number igs_ps_unit_ver_all.version_number%TYPE,
547: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
548: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
549: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
542:
543: /********************** Unit Section Occurrence facilities ************/
544: TYPE usec_occurs_facility_rec_type IS RECORD (
545: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
546: version_number igs_ps_unit_ver_all.version_number%TYPE,
547: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
548: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
549: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
550: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
558: TYPE usec_occurs_facility_tbl_type IS TABLE OF usec_occurs_facility_rec_type INDEX BY BINARY_INTEGER;
559:
560: /********************** Unit Section Teaching Responsibility Overrides ************/
561: TYPE usec_teach_resp_ovrd_rec_type IS RECORD (
562: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
563: version_number igs_ps_unit_ver_all.version_number%TYPE,
564: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
565: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
566: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
559:
560: /********************** Unit Section Teaching Responsibility Overrides ************/
561: TYPE usec_teach_resp_ovrd_rec_type IS RECORD (
562: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
563: version_number igs_ps_unit_ver_all.version_number%TYPE,
564: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
565: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
566: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
567: org_unit_cd igs_ps_tch_resp_ovrd_all.org_unit_cd%TYPE,
575: TYPE usec_teach_resp_ovrd_tbl_type IS TABLE OF usec_teach_resp_ovrd_rec_type INDEX BY BINARY_INTEGER;
576:
577: /********************** Unit Section Notes ************/
578: TYPE usec_notes_rec_type IS RECORD (
579: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
580: version_number igs_ps_unit_ver_all.version_number%TYPE,
581: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
582: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
583: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
576:
577: /********************** Unit Section Notes ************/
578: TYPE usec_notes_rec_type IS RECORD (
579: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
580: version_number igs_ps_unit_ver_all.version_number%TYPE,
581: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
582: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
583: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
584: reference_number igs_ps_unt_ofr_opt_n.reference_number%TYPE,
592: TYPE usec_notes_tbl_type IS TABLE OF usec_notes_rec_type INDEX BY BINARY_INTEGER;
593:
594: /********************** Unit Section Assessment ************/
595: TYPE usec_assmnt_rec_type IS RECORD (
596: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
597: version_number igs_ps_unit_ver_all.version_number%TYPE,
598: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
599: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
600: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
593:
594: /********************** Unit Section Assessment ************/
595: TYPE usec_assmnt_rec_type IS RECORD (
596: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
597: version_number igs_ps_unit_ver_all.version_number%TYPE,
598: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
599: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
600: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
601: final_exam_date igs_ps_usec_as.final_exam_date%TYPE,
612: TYPE usec_assmnt_tbl_type IS TABLE OF usec_assmnt_rec_type INDEX BY BINARY_INTEGER;
613:
614: /********************** Unit Section Plus Hours ************/
615: TYPE usec_plus_hr_rec_type IS RECORD (
616: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
617: version_number igs_ps_unit_ver_all.version_number%TYPE,
618: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
619: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
620: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
613:
614: /********************** Unit Section Plus Hours ************/
615: TYPE usec_plus_hr_rec_type IS RECORD (
616: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
617: version_number igs_ps_unit_ver_all.version_number%TYPE,
618: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
619: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
620: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
621: activity_type_code igs_ps_usec_act_type.activity_type_code%TYPE,
634: TYPE usec_plus_hr_tbl_type IS TABLE OF usec_plus_hr_rec_type INDEX BY BINARY_INTEGER;
635:
636: /********************** Unit Section categories ************/
637: TYPE usec_cat_rec_type IS RECORD (
638: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
639: version_number igs_ps_unit_ver_all.version_number%TYPE,
640: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
641: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
642: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
635:
636: /********************** Unit Section categories ************/
637: TYPE usec_cat_rec_type IS RECORD (
638: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
639: version_number igs_ps_unit_ver_all.version_number%TYPE,
640: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
641: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
642: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
643: unit_cat igs_ps_usec_category.unit_cat%TYPE,
649: TYPE usec_cat_tbl_type IS TABLE OF usec_cat_rec_type INDEX BY BINARY_INTEGER;
650:
651: /********************** Unit Section Rules ************/
652: TYPE usec_rule_rec_type IS RECORD (
653: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
654: version_number igs_ps_unit_ver_all.version_number%TYPE,
655: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
656: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
657: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
650:
651: /********************** Unit Section Rules ************/
652: TYPE usec_rule_rec_type IS RECORD (
653: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
654: version_number igs_ps_unit_ver_all.version_number%TYPE,
655: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
656: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
657: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
658: s_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE,
665: TYPE usec_rule_tbl_type IS TABLE OF usec_rule_rec_type INDEX BY BINARY_INTEGER;
666:
667: /********************** Unit Section Cross Listed Groups ************/
668: TYPE usec_cross_group_rec_type IS RECORD (
669: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
670: version_number igs_ps_unit_ver_all.version_number%TYPE,
671: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
672: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
673: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
666:
667: /********************** Unit Section Cross Listed Groups ************/
668: TYPE usec_cross_group_rec_type IS RECORD (
669: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
670: version_number igs_ps_unit_ver_all.version_number%TYPE,
671: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
672: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
673: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
674: usec_x_listed_group_name igs_ps_usec_x_grp.usec_x_listed_group_name%TYPE,
684: TYPE usec_cross_group_tbl_type IS TABLE OF usec_cross_group_rec_type INDEX BY BINARY_INTEGER;
685:
686: /********************** Unit Section Meet With Groups ************/
687: TYPE usec_meet_with_rec_type IS RECORD (
688: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
689: version_number igs_ps_unit_ver_all.version_number%TYPE,
690: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
691: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
692: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
685:
686: /********************** Unit Section Meet With Groups ************/
687: TYPE usec_meet_with_rec_type IS RECORD (
688: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
689: version_number igs_ps_unit_ver_all.version_number%TYPE,
690: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
691: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
692: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
693: class_meet_group_name igs_ps_uso_cm_grp.class_meet_group_name%TYPE,
702: TYPE usec_meet_with_tbl_type IS TABLE OF usec_meet_with_rec_type INDEX BY BINARY_INTEGER;
703:
704: /********************** Unit Section Waitlist Priorities and Preferences ************/
705: TYPE usec_waitlist_rec_type IS RECORD (
706: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
707: version_number igs_ps_unit_ver_all.version_number%TYPE,
708: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
709: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
710: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
703:
704: /********************** Unit Section Waitlist Priorities and Preferences ************/
705: TYPE usec_waitlist_rec_type IS RECORD (
706: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
707: version_number igs_ps_unit_ver_all.version_number%TYPE,
708: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
709: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
710: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
711: priority_number igs_ps_usec_wlst_pri.priority_number%TYPE,
721: TYPE usec_waitlist_tbl_type IS TABLE OF usec_waitlist_rec_type INDEX BY BINARY_INTEGER;
722:
723: /********************** Unit Section Reserve Seating Priorities and Preferences ************/
724: TYPE usec_res_seat_rec_type IS RECORD (
725: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
726: version_number igs_ps_unit_ver_all.version_number%TYPE,
727: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
728: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
729: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
722:
723: /********************** Unit Section Reserve Seating Priorities and Preferences ************/
724: TYPE usec_res_seat_rec_type IS RECORD (
725: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
726: version_number igs_ps_unit_ver_all.version_number%TYPE,
727: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
728: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
729: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
730: priority_order igs_ps_rsv_usec_pri.priority_order%TYPE,
741: TYPE usec_res_seat_tbl_type IS TABLE OF usec_res_seat_rec_type INDEX BY BINARY_INTEGER;
742:
743: /********************** Unit Section Special Fees ************/
744: TYPE usec_sp_fee_rec_type IS RECORD (
745: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
746: version_number igs_ps_unit_ver_all.version_number%TYPE,
747: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
748: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
749: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
742:
743: /********************** Unit Section Special Fees ************/
744: TYPE usec_sp_fee_rec_type IS RECORD (
745: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
746: version_number igs_ps_unit_ver_all.version_number%TYPE,
747: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
748: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
749: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
750: fee_type igs_ps_usec_sp_fees.fee_type%TYPE,
758: TYPE usec_sp_fee_tbl_type IS TABLE OF usec_sp_fee_rec_type INDEX BY BINARY_INTEGER;
759:
760: /********************** Unit Section Retention ************/
761: TYPE usec_ret_rec_type IS RECORD (
762: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
763: version_number igs_ps_unit_ver_all.version_number%TYPE,
764: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
765: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
766: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
759:
760: /********************** Unit Section Retention ************/
761: TYPE usec_ret_rec_type IS RECORD (
762: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
763: version_number igs_ps_unit_ver_all.version_number%TYPE,
764: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
765: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
766: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
767: definition_level igs_ps_nsus_rtn.definition_code%TYPE,
777: TYPE usec_ret_tbl_type IS TABLE OF usec_ret_rec_type INDEX BY BINARY_INTEGER;
778:
779: /********************** Unit Section Retention Details ************/
780: TYPE usec_ret_dtl_rec_type IS RECORD (
781: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
782: version_number igs_ps_unit_ver_all.version_number%TYPE,
783: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
784: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
785: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
778:
779: /********************** Unit Section Retention Details ************/
780: TYPE usec_ret_dtl_rec_type IS RECORD (
781: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
782: version_number igs_ps_unit_ver_all.version_number%TYPE,
783: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
784: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
785: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
786: definition_level igs_ps_nsus_rtn.definition_code%TYPE,
798: TYPE usec_ret_dtl_tbl_type IS TABLE OF usec_ret_dtl_rec_type INDEX BY BINARY_INTEGER;
799:
800: /********************** Unit Section Enrollment Deadline ************/
801: TYPE usec_enr_dead_rec_type IS RECORD (
802: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
803: version_number igs_ps_unit_ver_all.version_number%TYPE,
804: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
805: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
806: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
799:
800: /********************** Unit Section Enrollment Deadline ************/
801: TYPE usec_enr_dead_rec_type IS RECORD (
802: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
803: version_number igs_ps_unit_ver_all.version_number%TYPE,
804: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
805: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
806: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
807: function_name igs_en_nstd_usec_dl.function_name%TYPE,
814: TYPE usec_enr_dead_tbl_type IS TABLE OF usec_enr_dead_rec_type INDEX BY BINARY_INTEGER;
815:
816: /********************** Unit Section Enrollment Discontinuation ************/
817: TYPE usec_enr_dis_rec_type IS RECORD (
818: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
819: version_number igs_ps_unit_ver_all.version_number%TYPE,
820: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
821: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
822: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
815:
816: /********************** Unit Section Enrollment Discontinuation ************/
817: TYPE usec_enr_dis_rec_type IS RECORD (
818: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
819: version_number igs_ps_unit_ver_all.version_number%TYPE,
820: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
821: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
822: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
823: administrative_unit_status igs_en_usec_disc_dl.administrative_unit_status%TYPE,
830: TYPE usec_enr_dis_tbl_type IS TABLE OF usec_enr_dis_rec_type INDEX BY BINARY_INTEGER;
831:
832: /********************** Unit Section Teaching Responsibility ************/
833: TYPE usec_teach_resp_rec_type IS RECORD (
834: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
835: version_number igs_ps_unit_ver_all.version_number%TYPE,
836: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
837: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
838: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
831:
832: /********************** Unit Section Teaching Responsibility ************/
833: TYPE usec_teach_resp_rec_type IS RECORD (
834: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
835: version_number igs_ps_unit_ver_all.version_number%TYPE,
836: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
837: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
838: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
839: instructor_person_number hz_parties.party_number%TYPE,
851: TYPE usec_teach_resp_tbl_type IS TABLE OF usec_teach_resp_rec_type INDEX BY BINARY_INTEGER;
852:
853: /********************** Unit Section Assessment Item Group ************/
854: TYPE usec_ass_item_grp_rec_type IS RECORD (
855: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
856: version_number igs_ps_unit_ver_all.version_number%TYPE,
857: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
858: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
859: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
852:
853: /********************** Unit Section Assessment Item Group ************/
854: TYPE usec_ass_item_grp_rec_type IS RECORD (
855: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
856: version_number igs_ps_unit_ver_all.version_number%TYPE,
857: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
858: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
859: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
860: group_name igs_as_us_ai_group.group_name%TYPE,