63: final_unit_set VARCHAR2(100),
64: -- igs_ad_ps_appl_inst.unit_set_cd||
65: final_unit_set_course_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
66: final_unit_set_ver_num igs_ad_ps_appl_inst_all.us_version_number%TYPE,
67: prog_att_start_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
68: transfered VARCHAR2(30),
69: -- transfered will be NULL as No Mapping exists for this
70: multiple_ad_appl VARCHAR2(10),
71: atb VARCHAR2(30),
76: sap_selected_flag VARCHAR2(30), -- NULL
77: multiple_prog_d VARCHAR2(10),
78: enrl_primary_program VARCHAR2(100),
79: --igs_en_stdnt_ps_att.course_cd||
80: enrl_primary_prog_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
81: enrl_primary_prog_ver_num igs_en_stdnt_ps_att_all.version_number%TYPE,
82: enrl_program_type igs_ps_ver_all.course_type%TYPE,
83: enrl_unit_set VARCHAR2(10), -- NULL Not Mapped
84: enrl_uset_course_cd igs_as_su_setatmpt.course_cd%TYPE, -- NULL Not Mapped
77: multiple_prog_d VARCHAR2(10),
78: enrl_primary_program VARCHAR2(100),
79: --igs_en_stdnt_ps_att.course_cd||
80: enrl_primary_prog_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
81: enrl_primary_prog_ver_num igs_en_stdnt_ps_att_all.version_number%TYPE,
82: enrl_program_type igs_ps_ver_all.course_type%TYPE,
83: enrl_unit_set VARCHAR2(10), -- NULL Not Mapped
84: enrl_uset_course_cd igs_as_su_setatmpt.course_cd%TYPE, -- NULL Not Mapped
85: enrl_uset_ver_num igs_as_su_setatmpt.us_version_number%TYPE, -- NULL Not Mapped
82: enrl_program_type igs_ps_ver_all.course_type%TYPE,
83: enrl_unit_set VARCHAR2(10), -- NULL Not Mapped
84: enrl_uset_course_cd igs_as_su_setatmpt.course_cd%TYPE, -- NULL Not Mapped
85: enrl_uset_ver_num igs_as_su_setatmpt.us_version_number%TYPE, -- NULL Not Mapped
86: enrl_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
87: derived_attend_type igs_en_stdnt_ps_att_all.derived_att_type%TYPE,
88: current_gpa NUMBER, -- NULL Not Mapped
89: cumulative_gpa NUMBER, -- NULL Not Mapped
90: acheived_cr_pts NUMBER, -- NULL Not Mapped
83: enrl_unit_set VARCHAR2(10), -- NULL Not Mapped
84: enrl_uset_course_cd igs_as_su_setatmpt.course_cd%TYPE, -- NULL Not Mapped
85: enrl_uset_ver_num igs_as_su_setatmpt.us_version_number%TYPE, -- NULL Not Mapped
86: enrl_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
87: derived_attend_type igs_en_stdnt_ps_att_all.derived_att_type%TYPE,
88: current_gpa NUMBER, -- NULL Not Mapped
89: cumulative_gpa NUMBER, -- NULL Not Mapped
90: acheived_cr_pts NUMBER, -- NULL Not Mapped
91: pred_class_standing VARCHAR2(60), -- NULL ; till DLD Class Standing i1a build
89: cumulative_gpa NUMBER, -- NULL Not Mapped
90: acheived_cr_pts NUMBER, -- NULL Not Mapped
91: pred_class_standing VARCHAR2(60), -- NULL ; till DLD Class Standing i1a build
92: enrl_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE,
93: enrl_attend_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
94: enrl_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
95: enrl_total_cp NUMBER(15,2),
96: enrl_cuml_cp NUMBER(15,2),
97: enrl_cuml_trans_cp NUMBER(15,2),
90: acheived_cr_pts NUMBER, -- NULL Not Mapped
91: pred_class_standing VARCHAR2(60), -- NULL ; till DLD Class Standing i1a build
92: enrl_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE,
93: enrl_attend_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
94: enrl_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
95: enrl_total_cp NUMBER(15,2),
96: enrl_cuml_cp NUMBER(15,2),
97: enrl_cuml_trans_cp NUMBER(15,2),
98: admission_appl_number igs_ad_appl_all. admission_appl_number%TYPE