SGHE Enterprise Data Warehouse
Banner EDW Source: FUNCTION - NULL
| Source Column |
Business Definition |
Target |
Target Column |
Calculation Formula |
| ACTIVE_HOLD_IND |
|
WAT_STUDENT_PROGRESS |
ACTIVE_HOLD_IND |
|
| CASE WHEN ACADEMIC_TIME_KEY = ACADEMIC_TIME_KET THEN ACADEMIC_STUDY_KEY ELSE 0 |
|
WAT_STUDENT_PROGRESS |
ACADEMIC_STUDY_START_KEY |
|
| CASE WHEN BIRTH_DATE IS NULL THEN NULL WHEN TRUNC(MONTH_BETWEEN)<23 THEN 1 ELSE 0 |
|
WAT_STUDENT_PROGRESS |
TRADITIONAL_STUDENT_IND |
|
| CASE WHEN CHANGED_MAJOR_COUNT>0 THEN ACADEMIC_STUDY_CHANGE_IND = 1 ELSE 0 |
|
WAT_STUDENT_PROGRESS |
ACADEMIC_STUDY_CHANGE_IND |
|
| CASE WHEN VETERAN_TYPE <> MTVPARM_DESC AND VETERAN_CATEGORY <> 0 THEN 1 ELSE 0 |
|
WAT_STUDENT_PROGRESS |
VETERAN_IND |
|
| CASE WHEN VISA_TYPE <> MTVPARM_DESC AND DEMOGRAPHIC_KEY <> 0 THEN 1 ELSE 0 |
|
WAT_STUDENT_PROGRESS |
INTERNATIONAL_STUDENT_IND |
|
| COUNT(*) FROM WFT_STUDENT_COURSE |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
COURSE_IN_PROGRESS_COUNT COURSE_IN_PROGRESS_COUNT |
|
| DECODE(DFAS.FM_FULLY_MET_NEED_IND,Y, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
FM_FULLY_MET_NEED_HEADCOUNT |
|
| DECODE(DFAS.FM_NEED_ELIGIBLE_IND,Y, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS |
IM_FULLY_MET_NEED_HEADCOUNT FM_NEED_ELIGIBLE_HEADCOUNT |
|
| DECODE(DFAS.IM_NEED_ELIGIBLE_IND,Y, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
IM_NEED_ELIGIBLE_HEADCOUNT |
|
| DECODE(DS.HOUSING_IND,Y,S.PERSON_UID, NULL) |
|
WAT_STUDENT_PROGRESS |
STUDENT_HOUSING_HEADCOUNT |
|
| DECODE(DSS.ACAD_HISTORY_EXISTS_IND,1, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
GRADUATED_HEADCOUNT |
|
| DECODE(DSS.COOP_ED_PARTICIPANT_IND,1, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
RETENTION_SEQ_HEADCOUNT |
|
| DECODE(DSS.ENROLLED_IND,1,S.PERSON_UID, NULL) |
|
WAT_STUDENT_PROGRESS |
ENROLLED_HEADCOUNT |
|
| DECODE(DSS.ENROLL_BY_CENSUS_DATE1_IND,1, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
ENROLL_CENSUS_DATE1_HEADCOUNT |
|
| DECODE(DSS.ENROLL_BY_CENSUS_DATE2_IND,1, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
ENROLL_CENSUS_DATE2_HEADCOUNT |
|
| DECODE(DSS.GRADUATE_CREDIT_ELIG_IND,1, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
RETENTION_LIKE_HEADCOUNT |
|
| DECODE(DSS.MATRICULATED_IND,1, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
MATRICULATED_HEADCOUNT |
|
| DECODE(DSS.NEW_STUDENT_IND,1, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
NEW_STUDENT_HEADCOUNT |
|
| DECODE(DSS.PERMIT_REGISTRATION_IND,1, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS |
PERMIT_REGISTRATION_HEADCOUNT |
|
| DECODE(DSS.REGISTERED_IND,1, S.PERSON_UID,NULL) |
|
WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS |
REGISTERED_HEADCOUNT STUDENT_HEADCOUNT |
|
| DECODE(DSS.WITHDRAWN_IND,1,S.PERSON_UID, NULL) |
|
WAT_STUDENT_PROGRESS |
WITHDRAWN_HEADCOUNT |
|
| DECODE(MST_RACE.RACE_CATEGORY) |
|
WDT_DEMOGRAPHIC |
MINORITY_IND |
|
| DECODE(NOT_RETAINED_COLLEGE_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_C |
|
WAT_STUDENT_PROGRESS |
NON_RETENTION_LIKE_HEADCOUNT_C |
|
| DECODE(NOT_RETAINED_COLLEGE_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_C |
|
WAT_STUDENT_PROGRESS |
NON_RETENTION_SEQ_HEADCOUNT_C |
|
| DECODE(NOT_RETAINED_OVERALL_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
NON_RETENTION_LIKE_HEADCOUNT |
|
| DECODE(NOT_RETAINED_OVERALL_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
RETENTION_SEQ_HEADCOUNT_S |
|
| DECODE(NOT_RETAINED_PROGRAM_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_P |
|
WAT_STUDENT_PROGRESS |
NON_RETENTION_LIKE_HEADCOUNT_P |
|
| DECODE(NOT_RETAINED_PROGRAM_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_P |
|
WAT_STUDENT_PROGRESS |
NON_RETENTION_SEQ_HEADCOUNT_P |
|
| DECODE(NOT_RETAINED_STDLEVL_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_S, |
|
WAT_STUDENT_PROGRESS |
NON_RETENTION_LIKE_HEADCOUNT_S |
|
| DECODE(NOT_RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_S |
|
WAT_STUDENT_PROGRESS |
NON_RETENTION_SEQ_HEADCOUNT_S |
|
| DECODE(RETAINED_COLLEGE_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_C |
|
WAT_STUDENT_PROGRESS |
RETENTION_LIKE_HEADCOUNT_C |
|
| DECODE(RETAINED_COLLEGE_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_C |
|
WAT_STUDENT_PROGRESS |
RETENTION_SEQ_HEADCOUNT_C |
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
RET_LIKE_EXCLUDE_HEADCOUNT |
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_C |
|
WAT_STUDENT_PROGRESS |
RET_LIKE_EXCLUDE_HEADCOUNT_C |
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_P |
|
WAT_STUDENT_PROGRESS |
RET_LIKE_EXCLUDE_HEADCOUNT_P |
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_SXCLUDE_HEADC OUNT_S |
|
WAT_STUDENT_PROGRESS |
RET_LIKE_EXCLUDE_HEADCOUNT_S |
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
NON_RETENTION_SEQ_HEADCOUNT |
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_C |
|
WAT_STUDENT_PROGRESS |
RET_SEQ_EXCLUDE_HEADCOUNT_C |
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_P |
|
WAT_STUDENT_PROGRESS |
RET_SEQ_EXCLUDE_HEADCOUNT_P |
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_S |
|
WAT_STUDENT_PROGRESS |
RET_SEQ_EXCLUDE_HEADCOUNT_S |
|
| DECODE(RETAINED_PROGRAM_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_P |
|
WAT_STUDENT_PROGRESS |
RETENTION_LIKE_HEADCOUNT_P |
|
| DECODE(RETAINED_PROGRAM_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_P |
|
WAT_STUDENT_PROGRESS |
RETENTION_SEQ_HEADCOUNT_P |
|
| DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_S |
|
WAT_STUDENT_PROGRESS |
RETENTION_LIKE_HEADCOUNT_S |
|
| DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_S |
|
WAT_STUDENT_PROGRESS |
RET_SEQ_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR1_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR1_GRAD_EXCLUDE_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR1_GRAD_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR1_GRADUATION_IND,1,PERSON_IN, NULL) YEAR1_GRADUATION_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR1_GRADUATION_HEADCOUNT |
|
| DECODE(YEAR1_RETAINED_IND,1,PERSON_IN, NULL) |
|
WAT_STUDENT_PROGRESS |
YEAR1_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR2_GRAD_EXCLUDE_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
YEAR2_GRAD_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR2_RET_EXCLUDE_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR2_RET_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR2_GRADUATION_IND,1,PERSON_IN, NULL) YEAR2_GRADUATION_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
YEAR2_GRADUATION_HEADCOUNT |
|
| DECODE(YEAR2_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR2_NOT_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR2_NOT_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR2_RETAINED_IND,1,PERSON_IN, NULL) YEAR2_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR2_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR3_GRAD_EXCLUDE_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR3_GRAD_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR3_RET_EXCLUDE_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR3_RET_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR3_GRADUATION_IND,1,PERSON_IN, NULL) YEAR3_GRADUATION_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR3_GRADUATION_HEADCOUNT |
|
| DECODE(YEAR3_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR3_NOT_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR3_NOT_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR3_RETAINED_IND,1,PERSON_IN, NULL)YEAR3_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR3_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR4_GRAD_EXCLUDE_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR4_GRAD_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR4_RET_EXCLUDE_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR4_RET_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR4_GRADUATION_IND,1,PERSON_IN, NULL) YEAR4_GRADUATION_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR4_GRADUATION_HEADCOUNT |
|
| DECODE(YEAR4_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR4_NOT_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR4_NOT_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR4_RETAINED_IND,1,PERSON_IN, NULL)YEAR4_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR4_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR5_GRAD_EXCLUDE_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR5_GRAD_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR5_RET_EXCLUDE_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
YEAR5_RET_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR5_GRADUATION_IND,1,PERSON_IN, NULL) YEAR5_GRADUATION_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR5_GRADUATION_HEADCOUNT |
|
| DECODE(YEAR5_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR5_NOT_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR5_NOT_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR5_RETAINED_IND,1,PERSON_IN, NULL)YEAR5_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR5_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_GRAD_EXCLUDE_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
YEAR6_GRAD_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_RET_EXCLUDE_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
YEAR6_RET_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR6_GRADUATION_IND,1,PERSON_IN, NULL) YEAR6_GRADUATION_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
YEAR6_GRADUATION_HEADCOUNT |
|
| DECODE(YEAR6_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR6_NOT_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR6_NOT_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR6_RETAINED_IND,1,PERSON_IN, NULL)YEAR6_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR6_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR7_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR7_GRAD_EXCLUDE_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR7_GRAD_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR7_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR7_RET_EXCLUDE_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR7_RET_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR7_GRADUATION_IND,1,PERSON_IN, NULL) YEAR7_GRADUATION_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR7_GRADUATION_HEADCOUNT |
|
| DECODE(YEAR7_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR7_NOT_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR7_NOT_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR7_RETAINED_IND,1,PERSON_IN, NULL)YEAR7_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR7_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR8_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR8_GRAD_EXCLUDE_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
YEAR8_GRAD_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR8_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR8_RET_EXCLUDE_HEADCOUNT |
|
WAT_STUDENT_PROGRESS |
YEAR8_RET_EXCLUDE_HEADCOUNT |
|
| DECODE(YEAR8_GRADUATION_IND,1,PERSON_IN, NULL) YEAR8_GRADUATION_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR8_GRADUATION_HEADCOUNT |
|
| DECODE(YEAR8_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR8_NOT_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR8_NOT_REGISTERED_HEADCOUNT |
|
| DECODE(YEAR8_RETAINED_IND,1,PERSON_IN, NULL)YEAR8_REGISTERED_HEADCOUNT, |
|
WAT_STUDENT_PROGRESS |
YEAR8_REGISTERED_HEADCOUNT |
|
| ROKODSF.F_GET_CIPC_DESC |
|
LOAN_DISBURSEMENT |
PROGRAM_CLASSIFICATION_DESC |
|
| ROKODSF.F_GET_RORMVAL_DESC |
|
LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION AWARD_BY_PERSON LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION AWARD_BY_PERSON LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION AWARD_BY_PERSON LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT LOAN_APPLICATION LOAN_DISBURSEMENT LOAN_DISBURSEMENT AWARD_BY_PERSON AWARD_BY_PERSON LOAN_APPLICATION LOAN_DISBURSEMENT |
CREDIT_CHECK_OVERRIDDEN_DESC DEFAULT_IND_DESC PLUS_CREDIT_CHECK_STATUS_DESC PELL_AWARD_ENROLLMENT_OPT_DESC DL_MPN_STATUS_DESC LOAN_TYPE_DESC MPN_TYPE_DESC TIME_STATUS_DESC CREDIT_CHK_APPEAL_STATUS_DESC PROGRAM_OF_STUDY_DESC DEPENDENCY_STATUS_DESC DISCLOSURE_REQUIRED_IND_DESC PREP_TEACH_CERTIFICATION_DESC ACADEMIC_YEAR_OVERRIDE_DESC CREDIT_ACTION_DESC CREDIT_ACTION_STATUS_DESC DEFAULT_IND_DESC ORIGINAL_CREDIT_STATUS_DESC DISBURSEMENT_PROC_STATUS_DESC ENROLLMENT_LOAD_OPTION_DESC STUDENT_LOAN_OVERRIDE_DESC UNMET_NEED_OVERRIDE_DESC YEAR_IN_COLLEGE_DESC ENROLLMENT_STATUS_DESC |
|
| SUM(COURSE_CREDITS ) |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
TOTAL_CREDITS TOTAL_CREDITS |
|
| SUM(COURSE_CREDITS_ATTEMPTED ) TOTAL_CREDITS_ATTM, |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
TOTAL_CREDITS_ATTEMPTED TOTAL_CREDITS_ATTEMPTED |
|
| SUM(COURSE_CREDITS_EARNED ) TOTAL_CREDITS_EARN, |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
TOTAL_CREDITS_EARNED TOTAL_CREDITS_EARNED |
|
| SUM(COURSE_CREDITS_FOR_GPA ) TOT_CRED_GPA |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
TOTAL_CREDITS_FOR_GPA TOTAL_CREDITS_FOR_GPA |
|
| SUM(COURSE_CREDITS_PASSED ) TOTAL_CREDITS_PASS, |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
TOTAL_CREDITS_PASSED TOTAL_CREDITS_PASSED |
|
| SUM(FINAL_GRADE_QUALITY_POINTS ) FINAL_GRD_QLTY_PNTS, |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
TOTAL_QUALITY_POINTS TOTAL_QUALITY_POINTS |
|
| CASE WHEN (INGRP1.ATVCFAE_TYPE >= 1 AND INGRP1.ATVCFAE_TYPE < 12) THEN'CURRENT OPERATIONS' WHEN ( INGRP1.ATVCFAE_TYPE IN (20,21,32)) THEN'CAPITAL PURPOSES' WHEN (INGRP1.ATVCFAE_TYPE >= 22 AND INGRP1.ATVCFAE_TYPE < 32) THEN'ENDOWMENT RESTRICTED' END |
|
WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL |
CAE_REPORT_LINE_SD CAE_REPORT_LINE_LD |
|
| CASE WHEN INGRP1.ADRFUND_DESG = INGRP1.ADBDESG_DESG THEN 1 ELSE 0 END |
|
WDT_DESIGNATION_DETAIL |
DESIGNATION_FINAID_FUND_IND |
|
| CASE WHEN INGRP1.ADRFUND_DESG = INGRP1.ADBDESG_DESG THEN YES ELSE NO END |
|
WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL |
DESIGNATION_FINAID_FUND_IND_SD DESIGNATION_FINAID_FUND_IND_LD |
|
| SUM(F.COURSE_CREDITS_ATTEMPTED ) CUMULATIVE_CREDITS_ATTEMPTED, |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
CUMULATIVE_CREDITS_ATTEMPTED CUMULATIVE_CREDITS_ATTEMPTED |
|
| SUM(F.COURSE_CREDITS_EARNED ) CUMULATIVE_CREDITS_EARNED, |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
CUMULATIVE_CREDITS_EARNED CUMULATIVE_CREDITS_EARNED |
|
| SUM(F.COURSE_CREDITS_FOR_GPA ) CUMULATIVE_CREDITS_FOR_GPA |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
CUMULATIVE_CREDITS_FOR_GPA CUMULATIVE_CREDITS_FOR_GPA |
|
| SUM(F.COURSE_CREDITS_PASSED ) CUMULATIVE_CREDITS_PASSED, |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
CUMULATIVE_CREDITS_PASSED CUMULATIVE_CREDITS_PASSED |
|
| SUM(F.FINAL_GRADE_QUALITY_POINTS ) CUMULATIVE_QUALITY_POINTS, |
|
WAT_STUDENT_PROGRESS WFT_STUDENT |
CUMULATIVE_QUALITY_POINTS CUMULATIVE_QUALITY_POINTS |
|