RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: STVACYR - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
STVACYR_DESC NO

DIMENSION TABLE


















































REPORTING VIEW



DIMENSION TABLE


















































REPORTING VIEW

WDT_ADVANCEMENT_DEG_YEAR

WDT_ADVANCEMENT_DEG_YEAR

FACULTY_FEEDBACK_DETAIL

PHONE_ASSIGNMENT

SCHEDULE_OFFERING

STUDENT_COURSE

DEGREE

ACADEMIC_OUTCOME

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

ACADEMIC_STUDY_EXTENDED

AUDIT_STUDENT_COURSE

AUDIT_STUDENT_COURSE

BLOCK_REGISTRATION_COURSE

EXCEPTION_APPLIED

GPA_BY_TERM

ACADEMIC_STUDY

AUDIT_STUDENT_NON_COURSE

ENROLLMENT

FIELD_OF_STUDY

OFFERING_GRADE_TYPE

STUDENT_TRANSFERRED_COURSE

ACADEMIC_STUDY

AUDIT_STUDENT_BLOCK

PROJECTED_SEATS_NEEDED

ACADEMIC_OUTCOME

FACULTY_FEEDBACK

RECRUITMENT_INFORMATION

REGISTRATION_PLAN

STUDENT_COURSE_GRADE_CHANGE

CONTRACT

AUDIT_STUDENT_BLOCK

MEETING_TIME

RECRUITMENT_LEARNED

REGISTRATION_PLAN_COURSE

STUDENT_ACTIVITY

EXEMPTION

COMMUNICATION

DEGREE

AUDIT_COURSE_NEEDED

AUDIT_STUDENT_NON_COURSE

ENROLLMENT_WITHDRAWAL

GPA

MEAL_ASSIGNMENT

ROOM_ASSIGNMENT

ACADEMIC_STUDY_EXTENDED

ADMISSIONS_COHORT

AUDIT_STUDENT_BLOCK

CONTRACT_PAYMENT_DETAIL

RECEIVABLE_ACCOUNT_DETAIL

RECEIVABLE_SUMMARY

WDT_ADVANCEMENT_DEG_YEAR

WDT_ADVANCEMENT_DEG_YEAR

FACULTY_FEEDBACK_DETAIL

PHONE_ASSIGNMENT

SCHEDULE_OFFERING

STUDENT_COURSE

DEGREE

ACADEMIC_OUTCOME

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

ACADEMIC_STUDY_EXTENDED

AUDIT_STUDENT_COURSE

AUDIT_STUDENT_COURSE

BLOCK_REGISTRATION_COURSE

EXCEPTION_APPLIED

GPA_BY_TERM

ACADEMIC_STUDY

AUDIT_STUDENT_NON_COURSE

ENROLLMENT

FIELD_OF_STUDY

OFFERING_GRADE_TYPE

STUDENT_TRANSFERRED_COURSE

ACADEMIC_STUDY

AUDIT_STUDENT_BLOCK

PROJECTED_SEATS_NEEDED

ACADEMIC_OUTCOME

FACULTY_FEEDBACK

RECRUITMENT_INFORMATION

REGISTRATION_PLAN

STUDENT_COURSE_GRADE_CHANGE

CONTRACT

AUDIT_STUDENT_BLOCK

MEETING_TIME

RECRUITMENT_LEARNED

REGISTRATION_PLAN_COURSE

STUDENT_ACTIVITY

EXEMPTION

COMMUNICATION

DEGREE

AUDIT_COURSE_NEEDED

AUDIT_STUDENT_NON_COURSE

ENROLLMENT_WITHDRAWAL

GPA

MEAL_ASSIGNMENT

ROOM_ASSIGNMENT

ACADEMIC_STUDY_EXTENDED

ADMISSIONS_COHORT

AUDIT_STUDENT_BLOCK

CONTRACT_PAYMENT_DETAIL

RECEIVABLE_ACCOUNT_DETAIL

RECEIVABLE_SUMMARY

ADVANCEMENT_DEG_YEAR_LD

ADVANCEMENT_DEG_YEAR_SD

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

BULLETIN_YEAR_DESC

BULLETIN_YEAR_DESC

YEAR_ADMITTED_DESC

GRAD_YEAR_INTENDED_DESC

YEAR_ADMITTED_DESC

ACADEMIC_YEAR_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

YEAR_MATRICULATED_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

GRAD_YEAR_INTENDED_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_GRADUATION_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

CATALOG_YEAR_END_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

YEAR_MATRICULATED_DESC

ACADEMIC_YEAR_DESC

CATALOG_YEAR_START_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ADVANCEMENT_DEG_YEAR_LD

ADVANCEMENT_DEG_YEAR_SD

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

BULLETIN_YEAR_DESC

BULLETIN_YEAR_DESC

YEAR_ADMITTED_DESC

GRAD_YEAR_INTENDED_DESC

YEAR_ADMITTED_DESC

ACADEMIC_YEAR_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

YEAR_MATRICULATED_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

GRAD_YEAR_INTENDED_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_GRADUATION_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

CATALOG_YEAR_END_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

AUDIT_ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

YEAR_MATRICULATED_DESC

ACADEMIC_YEAR_DESC

CATALOG_YEAR_START_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

ADVANCEMENT DEGREE 

ADVANCEMENT DEGREE 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

ADVANCEMENT DEGREE 

ADVANCEMENT DEGREE 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

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

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: 9.0