Banner EDW Source: RECRUITMENT_INFORMATION

	RETURN TO BANNER EDW META DATA REPORTS LIST
	(Banner ODS Target Report)

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ACADEMIC_PERIOD	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_PERIOD	ADMISSIONS RECRUITMENT	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	ADMISSIONS RECRUITMENT	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
ADMISSION_POPULATION	NO	DIMENSION TABLE	WDT_STUDENT	ADMISSIONS_POPULATION	ADMISSIONS RECRUITMENT	NO
ADMISSION_POPULATION_DESC	NO	DIMENSION TABLE	WDT_STUDENT WDT_STUDENT	ADMISSIONS_POPULATION_LD ADMISSIONS_POPULATION_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
AWARD_CATEGORY	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	AWARD_CATEGORY	ADMISSIONS RECRUITMENT	NO
AWARD_CATEGORY_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	AWARD_CATEGORY_SD AWARD_CATEGORY_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
CAMPUS	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	CAMPUS	ADMISSIONS RECRUITMENT	NO
CAMPUS_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	CAMPUS_SD CAMPUS_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
COLLEGE	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	COLLEGE	ADMISSIONS RECRUITMENT	NO
COLLEGE_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	COLLEGE_SD COLLEGE_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
DATE_ADDED	NO	FACT TABLE	WFT_ADMISSIONS_RECRUITMENT	RECRUIT_ADD_DATE	ADMISSIONS RECRUITMENT	NO
DEGREE	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	DEGREE	ADMISSIONS RECRUITMENT	NO
DEGREE_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	DEGREE_SD DEGREE_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
DEPARTMENT	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	DEPARTMENT	ADMISSIONS RECRUITMENT	NO
DEPARTMENT_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	DEPARTMENT_LD DEPARTMENT_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
EDUCATION_GOAL	NO	DIMENSION TABLE	WDT_STUDENT	EDUCATION_GOAL	ADMISSIONS RECRUITMENT	NO
EDUCATION_GOAL_DESC	NO	DIMENSION TABLE	WDT_STUDENT WDT_STUDENT	EDUCATION_GOAL_LD EDUCATION_GOAL_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
EDUCATION_LEVEL	NO	DIMENSION TABLE	WDT_STUDENT	EDUCATION_LEVEL	ADMISSIONS RECRUITMENT	NO
EDUCATION_LEVEL_DESC	NO	DIMENSION TABLE	WDT_STUDENT WDT_STUDENT	EDUCATION_LEVEL_SD EDUCATION_LEVEL_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
FUNCTION	NO	DIMENSION TABLE	WDT_PRE_STUDENT_STATUS WDT_FINANCIAL_AID_STATUS	INQUIRED_IND FINANCIAL_AID_APPLICANT_IND	FINANCIAL AID PRE STUDENT ADMISSIONS RECRUITMENT	NO NO
INTENDED_TIME_STATUS	NO	DIMENSION TABLE	WDT_STUDENT	INTENDED_TIME_STATUS	ADMISSIONS RECRUITMENT	NO
MAJOR	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	MAJOR	ADMISSIONS RECRUITMENT	NO
MAJOR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	MAJOR_SD MAJOR_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
OTHER_INSTITUTION	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT	INSTITUTION_ATTENDING	ADMISSIONS RECRUITMENT	NO
OTHER_INSTITUTION_DESC	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT WDT_STUDENT_RECRUITMENT	INSTITUTION_ATTENDING_LD INSTITUTION_ATTENDING_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
PERSON_UID	NO	DIMENSION TABLE FACT TABLE	WDT_PERSON WFT_PROSPECTIVE_STUDENT WFT_ADMISSIONS_RECRUITMENT	PERSON_UID PERSON_UID PERSON_UID	ADMISSIONS RECRUITMENT PROSPECTIVE STUDENT ADMISSIONS RECRUITMENT	NO NO NO
PRIMARY_RECRUIT_RECORD_IND	NO	FACT TABLE	WFT_ADMISSIONS_RECRUITMENT	PRIMARY_RECRUIT_RECORD_IND	ADMISSIONS RECRUITMENT	NO
PRIMARY_SOURCE	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT WDT_STUDENT_APPLICATION	PRIMARY_SOURCE PRIMARY_SOURCE	ADMISSIONS RECRUITMENT RECRUITING AND ADMISSION	NO NO
PRIMARY_SOURCE_DESC	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT WDT_STUDENT_RECRUITMENT WDT_STUDENT_APPLICATION	PRIMARY_SOURCE_SD PRIMARY_SOURCE_LD PRIMARY_SOURCE_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT RECRUITING AND ADMISSION	NO NO NO
PROGRAM	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	PROGRAM	ADMISSIONS RECRUITMENT	NO
PROGRAM_CLASSIFICATION	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	PROGRAM_CLASSIFICATION	ADMISSIONS RECRUITMENT	NO
PROGRAM_CLASSIFICATION_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	PROGRAM_CLASSIFICATION_SD PROGRAM_CLASSIFICATION_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
PROGRAM_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	PROGRAM_LD PROGRAM_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
RATE	NO	DIMENSION TABLE	WDT_STUDENT	RATE	ADMISSIONS RECRUITMENT	NO
RATE_DESC	NO	DIMENSION TABLE	WDT_STUDENT WDT_STUDENT	RATE_SD RATE_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
RECRUITER	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT	RECRUITER	ADMISSIONS RECRUITMENT	NO
RECRUITER_DESC	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT WDT_STUDENT_RECRUITMENT	RECRUITER_LD RECRUITER_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
RECRUIT_STATUS	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT	RECRUIT_STATUS	ADMISSIONS RECRUITMENT	NO
RECRUIT_STATUS_DESC	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT WDT_STUDENT_RECRUITMENT	RECRUIT_STATUS_LD RECRUIT_STATUS_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
RECRUIT_TYPE	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT	RECRUIT_TYPE	ADMISSIONS RECRUITMENT	NO
RECRUIT_TYPE_DESC	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT WDT_STUDENT_RECRUITMENT	RECRUIT_TYPE_SD RECRUIT_TYPE_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
SECOND_DEPARTMENT	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	SECOND_DEPARTMENT	ADMISSIONS RECRUITMENT	NO
SECOND_DEPARTMENT_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	SECOND_DEPARTMENT_SD SECOND_DEPARTMENT_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
SECOND_MAJOR	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	SECOND_MAJOR	ADMISSIONS RECRUITMENT	NO
SECOND_MAJOR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	SECOND_MAJOR_LD SECOND_MAJOR_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
SECOND_PROGRAM_CLASSIFICATION	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	SECOND_PROG_CLASSIFICATION	ADMISSIONS RECRUITMENT	NO
SECOND_PROGRAM_CLASSIF_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	SECOND_PROG_CLASSIFICATION_LD SECOND_PROG_CLASSIFICATION_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
SITE	NO	DIMENSION TABLE	WDT_STUDENT	SITE	ADMISSIONS RECRUITMENT	NO
SITE_DESC	NO	DIMENSION TABLE	WDT_STUDENT WDT_STUDENT	SITE_SD SITE_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
STUDENT_LEVEL	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	STUDENT_LEVEL	ADMISSIONS RECRUITMENT	NO
STUDENT_LEVEL_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	STUDENT_LEVEL_LD STUDENT_LEVEL_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
STUDENT_POPULATION	NO	DIMENSION TABLE	WDT_STUDENT	STUDENT_POPULATION	ADMISSIONS RECRUITMENT	NO
STUDENT_POPULATION_DESC	NO	DIMENSION TABLE	WDT_STUDENT WDT_STUDENT	STUDENT_POPULATION_LD STUDENT_POPULATION_SD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO
WITHDRAWAL_REASON	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT	WITHDRAWAL_REASON	ADMISSIONS RECRUITMENT	NO
WITHDRAWAL_REASON_DESC	NO	DIMENSION TABLE	WDT_STUDENT_RECRUITMENT WDT_STUDENT_RECRUITMENT	WITHDRAWAL_REASON_SD WITHDRAWAL_REASON_LD	ADMISSIONS RECRUITMENT ADMISSIONS RECRUITMENT	NO NO

Ver: 9.0