Banner EDW Source: EDW CLEANSING PROCESS

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
NA	NO	DIMENSION TABLE FACT TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE WDT_MULTI_SOURCE WDT_MULTI_SOURCE WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_TIME WDT_TIME WDT_TIME WDT_TIME WDT_TIME WDT_TIME WDT_TIME WDT_TIME WDT_TIME WDT_TIME WDT_TIME WDT_GRANT_TYPE WDT_GRANT_TYPE WDT_TIME WDT_EMPLOYEE WDT_EMPLOYEE WDT_EMPLOYEE WDT_EMPLOYEE WDT_EMPLOYEE WDT_EMPLOYEE WDT_JOB WDT_JOB WDT_POSITION WDT_POSITION WDT_POSITION WDT_TIME WDT_STUDENT WDT_STUDENT WDT_APPLICATION_DECISION WDT_APPLICATION_DECISION WDT_INDICATOR WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_PRE_STUDENT WDT_SECONDARY_SCHOOL_SUBJECT WDT_SECONDARY_SCHOOL_SUBJECT WFT_ENROLLMENT	ADMINISTRATIVE_GROUP_LD ADMINISTRATIVE_GROUP_SD PROCESS_GROUP_LD PROCESS_GROUP_SD FINAL_INSTALL_MONTH_LD FINAL_INSTALL_MONTH_SD FINAL_INSTALL_YEAR_LD FINAL_INSTALL_YEAR_SD ORIGINAL_PLEDGE_RANGE ORIGINAL_PLEDGE_RANGE_LD ORIGINAL_PLEDGE_RANGE_SD OUTSTANDING_PLEDGE_RANGE OUTSTANDING_PLEDGE_RANGE_LD OUTSTANDING_PLEDGE_RANGE_SD CALENDAR_MONTH_LD CALENDAR_MONTH_SD CALENDAR_YEAR_LD CALENDAR_YEAR_SD EVENT_LD EVENT_SD FISCAL_PERIOD_LD FISCAL_PERIOD_SD FISCAL_QUARTER_LD FISCAL_QUARTER_SD FISCAL_YEAR_LD RESEARCH_PURPOSE_LD RESEARCH_PURPOSE_SD FISCAL_YEAR_SD ANNUAL_SALARY_RANGE ANNUAL_SALARY_RANGE_LD ANNUAL_SALARY_RANGE_SD YEARS_OF_SERVICE_RANGE YEARS_OF_SERVICE_RANGE_LD YEARS_OF_SERVICE_RANGE_SD JOB_SUFFIX_LD JOB_SUFFIX_SD PROGRAM_CLASSIFICATION PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_SD FISCAL_YEAR INTENDED_TIME_STATUS_LD INTENDED_TIME_STATUS_SD DECISION_SOURCE_LD DECISION_SOURCE_SD INDICATOR ACADEMIC_PERCENTILE_RANGE ACADEMIC_PERCENTILE_RANGE_LD ACADEMIC_PERCENTILE_RANGE_SD TEST1_SCORE_RANGE TEST1_SCORE_RANGE_LD TEST1_SCORE_RANGE_SD TEST2_SCORE_RANGE TEST2_SCORE_RANGE_LD TEST2_SCORE_RANGE_SD TEST3_SCORE_RANGE TEST3_SCORE_RANGE_LD TEST3_SCORE_RANGE_SD TEST4_SCORE_RANGE TEST4_SCORE_RANGE_LD TEST4_SCORE_RANGE_SD TEST5_SCORE_RANGE TEST5_SCORE_RANGE_LD TEST5_SCORE_RANGE_SD TEST6_SCORE_RANGE TEST6_SCORE_RANGE_LD TEST6_SCORE_RANGE_SD TEST7_SCORE_RANGE TEST7_SCORE_RANGE_LD TEST7_SCORE_RANGE_SD SECONDARY_SUBJECT_GPA_RANGE_LD SECONDARY_SUBJECT_GPA_RANGE_SD FTE_DENOMINATOR	ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION GRANT AND PROJECT GRANT AND PROJECT ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE DEGREE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION APPLICATION DECISION APPLICATION DECISION ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, POST SECONDARY SCHOOL RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION RECRUITING AND ADMISSION SECONDARY SCHOOL SUBJECT SECONDARY SCHOOL SUBJECT ENROLLMENT	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO

Ver: 8.1