Banner EDW Source: CALCULATION

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
( TRUNC(SYSDATE) - NVL( CONT_LAST_REC.CONTACT_DATE,TRUNC( SYSDATE)) );	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	LAST_CONTACT_DAYS	STUDENT PROGRESS	NO
CASE WHEN RFRASPC_DIRECT_LOAN_IND	NO	REPORTING VIEW	FINAID_FUND FINAID_FUND LOAN_APPLICATION LOAN_DISBURSEMENT LOAN_APPLICATION LOAN_DISBURSEMENT	LOAN_SOURCE LOAN_SOURCE_DESC LOAN_SOURCE LOAN_SOURCE LOAN_SOURCE_DESC LOAN_SOURCE_DESC	NA NA NA NA NA NA	NO NO NO NO NO NO
CASE WHEN RLRLAPP_DISC_NEED_PRINT_FLAG	NO	REPORTING VIEW	LOAN_APPLICATION	DISCLOSURE_REQUIRED_IND_DESC	NA	NO
CASE WHEN RPRLAPP_MODEL_CDE	NO	REPORTING VIEW	LOAN_APPLICATION	DEPENDENCY_STATUS_DESC	NA	NO
DECODE(RLRDDAS_TRANS_TYPE)	NO	REPORTING VIEW	LOAN_DISBURSEMENT	TRANSACTION_TYPE_DESC	NA	NO
DECODE(RLRDLDD_FEED_IND)	NO	REPORTING VIEW	LOAN_DISBURSEMENT	DISBURSEMENT_FEED_DESC	NA	NO
DECODE(RLRDLDD_LOAD)	NO	REPORTING VIEW	LOAN_DISBURSEMENT	ENROLLMENT_LOAD_DESC	NA	NO
NVL(RERCODS_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO)	NO	REPORTING VIEW	LOAN_APPLICATION	FIRST_NAME	NA	NO
NVL(RERCODS_MI, MGKFUNC.F_GET_PERSON_INFO)	NO	REPORTING VIEW	LOAN_APPLICATION	MIDDLE_INITIAL	NA	NO
NVL(RERCSID_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO)	NO	REPORTING VIEW	LOAN_APPLICATION	LAST_NAME	NA	NO
NVL(RERCSID_SSN, MGKFUNC.F_GET_PERSON_INFO)	NO	REPORTING VIEW	LOAN_APPLICATION	TAX_ID	NA	NO
NVL(RLRPAPP_MAX_LOAN_IND,'N')	NO	REPORTING VIEW	LOAN_APPLICATION	MAXIMUM_LOAN_REQUESTED_IND	NA	NO
NVL(RPRATRM_AIDY_CODE_FUNDS, RPRATRM_AIDY_CODE)	NO	REPORTING VIEW	AWARD_BY_PERSON	AID_YEAR	NA	NO
SIGN(SUM(NVL((SELECT 0 FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = EDW EXTRACT PARAMETERS AND MTVPARM_INTERNAL_CODE = MINORITY_IND AND MTVPARM_INTERNAL_CODE_2 = NON_MINORITY_RACE_CATEGORY AND MTVPARM_EXTERNAL_CODE = RACE_CATEGORY), 1)))	NO	DIMENSION TABLE	WDT_DEMOGRAPHIC	MINORITY_IND	ADVISOR	NO

Ver: 9.0