VIEW: APPS.IGS_AD_ACADHIS_INT

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.education_id education_id, tab.org_id org_id, tab.attribute9 attribute9, tab.attribute10 attribute10, tab.attribute11 attribute11, tab.attribute12 attribute12, tab.attribute13 attribute13, tab.attribute14 attribute14, tab.attribute15 attribute15, tab.attribute16 attribute16, tab.attribute17 attribute17, tab.selfrep_rank_in_class selfrep_rank_in_class, tab.selfrep_weighted_gpa selfrep_weighted_gpa, tab.attribute8 attribute8, tab.attribute18 attribute18, tab.attribute19 attribute19, tab.attribute20 attribute20, tab.match_ind match_ind, tab.status status, tab.error_code error_code, tab.dup_acad_history_id dup_acad_history_id, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login, tab.request_id request_id, tab.program_application_id program_application_id, tab.program_id program_id, tab.program_update_date program_update_date, tab.type_of_school type_of_school, tab.interface_acadhis_id interface_acadhis_id, tab.interface_id interface_id, tab.transcript_required transcript_required, tab.institution_code institution_code, tab.current_inst current_inst, NULL, NULL, tab.program_code program_code, tab.comments comments, tab.start_date start_date, tab.end_date end_date, tab.planned_completion_date planned_completion_date, tab.selfrep_total_cp_attempted selfrep_total_cp_attempted, tab.selfrep_total_cp_earned selfrep_total_cp_earned, tab.selfrep_total_gp_units_attemp selfrep_total_gp_units_attemp, tab.selfrep_inst_gpa selfrep_inst_gpa, tab.selfrep_grading_scale_id selfrep_grading_scale_id, tab.attribute6 attribute6, tab.attribute7 attribute7, tab.selfrep_weighted_rank selfrep_weighted_rank, tab.attribute_category attribute_category, tab.attribute1 attribute1, tab.attribute2 attribute2, tab.attribute3 attribute3, tab.attribute4 attribute4, tab.attribute5 attribute5, tab.class_size, tab.update_education_id , tab.interface_run_id, tab.person_id, tab.error_text, tab.degree_attempted degree_attempted, tab.degree_earned degree_earned FROM igs_ad_acadhis_int_all tab

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.EDUCATION_ID EDUCATION_ID
, TAB.ORG_ID ORG_ID
, TAB.ATTRIBUTE9 ATTRIBUTE9
, TAB.ATTRIBUTE10 ATTRIBUTE10
, TAB.ATTRIBUTE11 ATTRIBUTE11
, TAB.ATTRIBUTE12 ATTRIBUTE12
, TAB.ATTRIBUTE13 ATTRIBUTE13
, TAB.ATTRIBUTE14 ATTRIBUTE14
, TAB.ATTRIBUTE15 ATTRIBUTE15
, TAB.ATTRIBUTE16 ATTRIBUTE16
, TAB.ATTRIBUTE17 ATTRIBUTE17
, TAB.SELFREP_RANK_IN_CLASS SELFREP_RANK_IN_CLASS
, TAB.SELFREP_WEIGHTED_GPA SELFREP_WEIGHTED_GPA
, TAB.ATTRIBUTE8 ATTRIBUTE8
, TAB.ATTRIBUTE18 ATTRIBUTE18
, TAB.ATTRIBUTE19 ATTRIBUTE19
, TAB.ATTRIBUTE20 ATTRIBUTE20
, TAB.MATCH_IND MATCH_IND
, TAB.STATUS STATUS
, TAB.ERROR_CODE ERROR_CODE
, TAB.DUP_ACAD_HISTORY_ID DUP_ACAD_HISTORY_ID
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.REQUEST_ID REQUEST_ID
, TAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TAB.PROGRAM_ID PROGRAM_ID
, TAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TAB.TYPE_OF_SCHOOL TYPE_OF_SCHOOL
, TAB.INTERFACE_ACADHIS_ID INTERFACE_ACADHIS_ID
, TAB.INTERFACE_ID INTERFACE_ID
, TAB.TRANSCRIPT_REQUIRED TRANSCRIPT_REQUIRED
, TAB.INSTITUTION_CODE INSTITUTION_CODE
, TAB.CURRENT_INST CURRENT_INST
, NULL
, NULL
, TAB.PROGRAM_CODE PROGRAM_CODE
, TAB.COMMENTS COMMENTS
, TAB.START_DATE START_DATE
, TAB.END_DATE END_DATE
, TAB.PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE
, TAB.SELFREP_TOTAL_CP_ATTEMPTED SELFREP_TOTAL_CP_ATTEMPTED
, TAB.SELFREP_TOTAL_CP_EARNED SELFREP_TOTAL_CP_EARNED
, TAB.SELFREP_TOTAL_GP_UNITS_ATTEMP SELFREP_TOTAL_GP_UNITS_ATTEMP
, TAB.SELFREP_INST_GPA SELFREP_INST_GPA
, TAB.SELFREP_GRADING_SCALE_ID SELFREP_GRADING_SCALE_ID
, TAB.ATTRIBUTE6 ATTRIBUTE6
, TAB.ATTRIBUTE7 ATTRIBUTE7
, TAB.SELFREP_WEIGHTED_RANK SELFREP_WEIGHTED_RANK
, TAB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TAB.ATTRIBUTE1 ATTRIBUTE1
, TAB.ATTRIBUTE2 ATTRIBUTE2
, TAB.ATTRIBUTE3 ATTRIBUTE3
, TAB.ATTRIBUTE4 ATTRIBUTE4
, TAB.ATTRIBUTE5 ATTRIBUTE5
, TAB.CLASS_SIZE
, TAB.UPDATE_EDUCATION_ID
, TAB.INTERFACE_RUN_ID
, TAB.PERSON_ID
, TAB.ERROR_TEXT
, TAB.DEGREE_ATTEMPTED DEGREE_ATTEMPTED
, TAB.DEGREE_EARNED DEGREE_EARNED
FROM IGS_AD_ACADHIS_INT_ALL TAB