[Home] [Help]
27: 'LOCATION_CD', location_cd,
28: 'ATTENDANCE_MODE', attendance_mode,
29: 'ATTENDANCE_TYPE', attendance_type,
30: 'STUDENT_CONFIRMED_IND', student_confirmed_ind,
31: 'COMMENCEMENT_DT', IGS_GE_DATE.IGSCHARDT(commencement_dt),
32: 'COURSE_ATTEMPT_STATUS', course_attempt_status,
33: 'DERIVED_ATT_TYPE', derived_att_type,
34: 'DERIVED_ATT_MODE', derived_att_mode,
35: 'PROVISIONAL_IND', provisional_ind,
32: 'COURSE_ATTEMPT_STATUS', course_attempt_status,
33: 'DERIVED_ATT_TYPE', derived_att_type,
34: 'DERIVED_ATT_MODE', derived_att_mode,
35: 'PROVISIONAL_IND', provisional_ind,
36: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
37: 'DISCONTINUATION_REASON_CD', discontinuation_reason_cd,
38: 'FUNDING_SOURCE', funding_source,
39: 'EXAM_LOCATION_CD', exam_location_cd,
40: 'DERIVED_COMPLETION_YR', TO_CHAR(derived_completion_yr),
42: 'NOMINATED_COMPLETION_YR', TO_CHAR(nominated_completion_yr),
43: 'NOMINATED_COMPLETION_PERD', nominated_completion_perd,
44: 'RULE_CHECK_IND', rule_check_ind,
45: 'WAIVE_OPTION_CHECK_IND', waive_option_check_ind,
46: 'LAST_RULE_CHECK_DT', IGS_GE_DATE.IGSCHARDT(last_rule_check_dt),
47: 'PUBLISH_OUTCOMES_IND', publish_outcomes_ind,
48: 'COURSE_RQRMNT_COMPLETE_IND', course_rqrmnt_complete_ind,
49: 'OVERRIDE_TIME_LIMITATION', TO_CHAR(override_time_limitation),
50: 'ADVANCED_STANDING_IND', advanced_standing_ind,
69: 'LOCATION_CD', location_cd,
70: 'ATTENDANCE_MODE', attendance_mode,
71: 'ATTENDANCE_TYPE', attendance_type,
72: 'STUDENT_CONFIRMED_IND', student_confirmed_ind,
73: 'COMMENCEMENT_DT', IGS_GE_DATE.IGSCHARDT(commencement_dt),
74: 'COURSE_ATTEMPT_STATUS', course_attempt_status,
75: 'DERIVED_ATT_TYPE', derived_att_type,
76: 'DERIVED_ATT_MODE', derived_att_mode,
77: 'PROVISIONAL_IND', provisional_ind,
74: 'COURSE_ATTEMPT_STATUS', course_attempt_status,
75: 'DERIVED_ATT_TYPE', derived_att_type,
76: 'DERIVED_ATT_MODE', derived_att_mode,
77: 'PROVISIONAL_IND', provisional_ind,
78: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
79: 'DISCONTINUATION_REASON_CD', discontinuation_reason_cd,
80: 'FUNDING_SOURCE', funding_source,
81: 'EXAM_LOCATION_CD', exam_location_cd,
82: 'DERIVED_COMPLETION_YR', TO_CHAR(derived_completion_yr),
84: 'NOMINATED_COMPLETION_YR', TO_CHAR(nominated_completion_yr),
85: 'NOMINATED_COMPLETION_PERD', nominated_completion_perd,
86: 'RULE_CHECK_IND', rule_check_ind,
87: 'WAIVE_OPTION_CHECK_IND', waive_option_check_ind,
88: 'LAST_RULE_CHECK_DT', IGS_GE_DATE.IGSCHARDT(last_rule_check_dt),
89: 'PUBLISH_OUTCOMES_IND', publish_outcomes_ind,
90: 'COURSE_RQRMNT_COMPLETE_IND', course_rqrmnt_complete_ind,
91: 'OVERRIDE_TIME_LIMITATION', TO_CHAR(override_time_limitation),
92: 'ADVANCED_STANDING_IND', advanced_standing_ind,
216: gv_other_detail := 'Parm: p_column_name - ' || p_column_name
217: || ' p_person_id - ' || TO_CHAR(p_person_id)
218: || ' p_course_cd - ' || p_course_cd
219: || ' p_course_attempt_status - ' || p_course_attempt_status
220: || ' p_hist_start_dt - ' || IGS_GE_DATE.IGSCHARDT(p_hist_start_dt);
221:
222: RAISE;
223: END enrp_get_scaeh_col;
224: --
276: -- All prior 'DISCONTINued histories are converted to match
277: -- the current student course attempt.
278: -- End the history at the same time as the current
279: -- student course attempt ie. now
280: RETURN IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(SYSDATE)||' 23:59:59');
281: ELSE -- history is not discontinued
282: -- Cannot be effectively discontinued before being
283: -- effectively enrolled.
284: -- All histories prior to discontinuation are considered
288: ELSIF v_current_cas = 'ENROLLED' THEN
289: -- All histories converted to the ENROLLED definition.
290: -- End the history at the same time as the current
291: -- student course attempt ie. now
292: RETURN IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(SYSDATE)||' 23:59:59');
293: ELSIF v_current_cas = 'UNCONFIRM' THEN
294: -- All histories converted to the UNCONFIRMed definition.
295: -- End the history at the same time as the current
296: -- student course attempt ie. now
293: ELSIF v_current_cas = 'UNCONFIRM' THEN
294: -- All histories converted to the UNCONFIRMed definition.
295: -- End the history at the same time as the current
296: -- student course attempt ie. now
297: RETURN IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(SYSDATE)||' 23:59:59');
298: ELSE
299: IF v_current_c_dt IS NOT NULL THEN
300: -- attempt to find the last enrolled history entry
301: OPEN c_last_e_scah(
327: || TO_CHAR(p_person_id)
328: || ' p_course_cd - '
329: || p_course_cd
330: || ' p_hist_end_dt - '
331: || IGS_GE_DATE.IGSCHAR(p_hist_end_dt)
332: || ' p_course_attempt_status - '
333: || p_course_attempt_status;
334:
335: RAISE;
452: || TO_CHAR(p_person_id)
453: || ' p_course_cd - '
454: || p_course_cd
455: || ' p_hist_start_dt - '
456: || IGS_GE_DATE.IGSCHARDT(p_hist_start_dt)
457: || ' p_course_attempt_status - '
458: || p_course_attempt_status;
459:
460: RAISE;