RETURN TO EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse EDW Source: ETL GENERATED

Source Column Local Source Target Type Target Target Column Local Target
NA NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_STUDENT

WDT_ACCOUNTS_RECEIVABLE

WDT_DEMOGRAPHIC

WDT_FINANCIAL_AID_STATUS

WDT_FINANCIAL_AID_STATUS

WDT_TIME

WDT_TIME

WDT_TIME

WDT_ORGANIZATION

WDT_FINANCIAL_AID_STATUS

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_CAMPAIGN

WDT_DEMOGRAPHIC

WDT_ACCOUNT

WDT_TIME

WDT_TIME

WDT_TIME

WDT_GRADUATION

WDT_ACADEMIC_STUDY

WDT_GIFT

WDT_ACADEMIC_STUDY

WDT_HR_REQUISITION

WDT_SECONDARY_SCHOOL

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_CHART

WDT_DEMOGRAPHIC

WDT_PLEDGE

WDT_TIME

WDT_TIME

WDT_FUND

WDT_JOB

WDT_DESIGNATION

WDT_EMPLOYMENT_HISTORY

WDT_DEMOGRAPHIC

WDT_TIME

WDT_TIME

WDT_TIME

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_CAMPAIGN

WDT_CUSTOMER

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

WDT_SECONDARY_SCHOOL

WDT_TIME

WDT_TIME

WDT_COURSE

WDT_COURSE

WDT_MULTI_SOURCE

WDT_INSTRUCTOR

WDT_INSTRUCTOR

WDT_TIME

WDT_EMPLOYEE

WDT_PRE_STUDENT_STATUS

WDT_PROGRAM

WDT_ACADEMIC_STUDY

WDT_PRE_STUDENT_STATUS

WDT_PRE_STUDENT_STATUS

WDT_TIME

WDT_FINANCIAL_AID_STATUS

WDT_DESIGNATION

WDT_GIFT

WDT_ACCOUNT

WDT_CONSTITUENT

WDT_TIME

WDT_GIFT

WDT_HR_APPLICANT

WDT_TIME

WDT_TIME

WDT_STUDENT_APPLICATION

WDT_STUDENT_APPLICATION

WDT_SECONDARY_SCHOOL

WDT_TIME

WDT_MULTI_SOURCE

WDT_TIME

WDT_MULTI_SOURCE

WDT_INSTRUCTOR

WDT_REGISTRATION

WDT_DEMOGRAPHIC

WDT_ACCOUNTS_RECEIVABLE

WDT_CHART

WDT_PLEDGE

WDT_PRE_STUDENT_STATUS

WDT_TIME

WDT_TIME

WDT_DEMOGRAPHIC

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_POST_SECONDARY_SCHOOL

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_PRE_STUDENT

WDT_TIME

WDT_FINANCIAL_AID_FUND

WDT_DEMOGRAPHIC

WDT_HR_REQUISITION

WDT_STUDENT

WDT_TIME

WDT_POSITION

WDT_CUSTOMER

WDT_GRADUATION

WDT_SECONDARY_SCHOOL

WDT_EMPLOYMENT_HISTORY

WDT_EMPLOYMENT_HISTORY

WDT_ENROLLMENT_STATUS

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_TIME

WDT_REGISTRATION

WDT_TIME

WDT_MULTI_SOURCE

WDT_TIME

WDT_CHART

WDT_TIME

WDT_ACADEMIC_STUDY

WDT_DEMOGRAPHIC

WDT_TIME

WDT_TIME

WDT_ORGANIZATION

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_ADMINISTRATION

WDT_TIME

WDT_POSITION

WDT_TIME

WDT_TIME

WDT_ACCOUNTS_RECEIVABLE

WDT_TIME

WDT_TIME

WDT_EMPLOYMENT_HISTORY

WDT_TIME

WDT_TIME

WDT_TIME

WDT_FINANCIAL_AID_FUND

WDT_FINANCIAL_AID_FUND

WDT_DEMOGRAPHIC

WDT_CAMPAIGN

WDT_CONSTITUENT

WDT_GRANT_TYPE

WDT_TIME

WDT_HR_APPLICANT_STATUS

WDT_STUDENT_APPLICATION

WDT_POST_SECONDARY_SCHOOL

WDT_GRANT_DEMOGRAPHIC

WDT_GRANT_DEMOGRAPHIC

WDT_ACADEMIC_STUDY

WDT_ENROLLMENT_STATUS

WDT_MULTI_SOURCE

WDT_TIME

WDT_TIME

WDT_EMPLOYEE

WDT_PRE_STUDENT_STATUS

WDT_ORGANIZATION

WDT_PROGRAM

WDT_TIME

WDT_ADMINISTRATION

WDT_FUND

WDT_TIME

WDT_TIME

WDT_TIME

WDT_DESIGNATION

WDT_ACCOUNT

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_STUDENT

WDT_GRANT_TYPE

WDT_TIME

WDT_TIME

WDT_CUSTOMER

WDT_HR_APPLICANT

WDT_HR_APPLICANT_STATUS

WDT_HR_APPLICANT_STATUS

WDT_GRANT_DEMOGRAPHIC

WDT_SECONDARY_SCHOOL

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_STUDENT

WDT_ACADEMIC_STUDY

WDT_FINANCIAL_AID_STATUS

WDT_TIME

WDT_PROGRAM

WDT_TIME

WDT_ADMINISTRATION

WDT_TIME

WDT_JOB

WDT_JOB

WDT_PRE_STUDENT_STATUS

WDT_TIME

WDT_TIME

WDT_DEMOGRAPHIC

WDT_POST_SECONDARY_SCHOOL

WDT_EMPLOYMENT_HISTORY

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

(More Targets -- list too long to display currently.)

ACAD_YR_LAST_EVENT_IND

AID_PER_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_PROCESS

FINANCIAL_AID_STATUS_KEY

SYSTEM_LOAD_TMSTMP

ACADEMIC_PERIOD_SEQ

ACADEMIC_PERIOD_SEQ

SYSTEM_LOAD_TMSTMP

ORGANIZATION_KEY

SYSTEM_LOAD_TMSTMP

FISCAL_PER_LAST_EVENT_IND

SYSTEM_LOAD_TMSTMP

EVENT_DATE

FISCAL_PER_LAST_EVENT_IND

SYSTEM_LOAD_TMSTMP

DEMOGRAPHIC_KEY

ACCOUNT_KEY

ACAD_YR_LAST_EVENT_IND

AID_PER_LAST_EVENT_IND

EVENT_DATE

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

HR_REQUISITION_KEY

SYSTEM_LOAD_PROCESS

MULTI_SOURCE_KEY

SYSTEM_LOAD_PROCESS

MULTI_SOURCE_KEY

CHART_KEY

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

AID_PER_LAST_EVENT_IND

EVENT

SYSTEM_LOAD_TMSTMP

JOB_KEY

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

DEMOGRAPHIC_KEY

CAL_YR_LAST_EVENT_IND

EVENT_QUALIFIER

FISCAL_PER_LAST_EVENT_IND

PRE_STUDENT_KEY

SYSTEM_LOAD_PROCESS

CAMPAIGN_KEY

CUSTOMER_KEY

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

SECONDARY_SCHOOL_KEY

ACADEMIC_PERIOD_SEQ

AID_YR_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

INSTRUCTOR_KEY

SYSTEM_LOAD_TMSTMP

ACAD_PER_LAST_EVENT_IND

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_PROCESS

ACADEMIC_STUDY_KEY

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

EVENT_DATE

FINANCIAL_AID_STATUS_KEY

SYSTEM_LOAD_TMSTMP

GIFT_KEY

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_PROCESS

EVENT_QUALIFIER

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_PROCESS

ACAD_PER_LAST_EVENT_IND

ACAD_YR_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_TMSTMP

MULTI_SOURCE_QUALIFIER

MULTI_SOURCE_KEY

MULTI_SOURCE_QUALIFIER

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

REGISTRATION_KEY

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_TMSTMP

ACAD_YR_LAST_EVENT_IND

ACAD_PER_LAST_EVENT_IND

DEMOGRAPHIC_KEY

SYSTEM_LOAD_TMSTMP

EVENT_QUALIFIER

FISCAL_QTR_LAST_EVENT_IND

EVENT_SEQ

SYSTEM_LOAD_PROCESS

TIME_KEY

SYSTEM_LOAD_PROCESS

EVENT_QUALIFIER

FISCAL_QTR_LAST_EVENT_IND

FISCAL_YR_LAST_EVENT_IND

SYSTEM_LOAD_TMSTMP

TIME_KEY

FINANCIAL_AID_FUND_KEY

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

CAL_YR_LAST_EVENT_IND

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

GRADUATION_KEY

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

ENROLLMENT_STATUS_KEY

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_TMSTMP

MULTI_SOURCE_QUALIFIER

SYSTEM_LOAD_PROCESS

MULTI_SOURCE_QUALIFIER

SYSTEM_LOAD_PROCESS

MULTI_SOURCE_QUALIFIER

SYSTEM_LOAD_TMSTMP

EVENT

SYSTEM_LOAD_PROCESS

DEMOGRAPHIC_KEY

EVENT_DATE

AID_PER_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

ACAD_YR_LAST_EVENT_IND

AID_YR_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

CAL_YR_LAST_EVENT_IND

ADMINISTRATION_KEY

SYSTEM_LOAD_PROCESS

POSITION_KEY

SYSTEM_LOAD_TMSTMP

AID_YR_LAST_EVENT_IND

ACCOUNTS_RECEIVABLE_KEY

FISCAL_QTR_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_PROCESS

FISCAL_YR_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

EVENT

SYSTEM_LOAD_PROCESS

STUDENT_APPLICATION_KEY

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

ACADEMIC_STUDY_KEY

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

ACADEMIC_PERIOD_SEQ

CAL_YR_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

PRE_STUDENT_STATUS_KEY

SYSTEM_LOAD_TMSTMP

PROGRAM_KEY

TIME_KEY

SYSTEM_LOAD_TMSTMP

SYSTEM_LOAD_PROCESS

ACAD_PER_LAST_EVENT_IND

CAL_YR_LAST_EVENT_IND

FISCAL_PER_LAST_EVENT_IND

DESIGNATION_KEY

SYSTEM_LOAD_TMSTMP

EVENT_QUALIFIER

FISCAL_PER_LAST_EVENT_IND

FISCAL_QTR_LAST_EVENT_IND

SUB_ACAD_PER_LAST_EVENT_IND

EVENT_SEQ

EVENT_DATE

FISCAL_YR_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

AID_YR_LAST_EVENT_IND

EVENT_SEQ

SYSTEM_LOAD_TMSTMP

HR_APPLICANT_KEY

HR_APPLICANT_STATUS_KEY

SYSTEM_LOAD_TMSTMP

GRANT_DEMOGRAPHIC_KEY

SECONDARY_SCHOOL_KEY

SYSTEM_LOAD_PROCESS

MULTI_SOURCE_KEY

SYSTEM_LOAD_TMSTMP

ACADEMIC_STUDY_KEY

SYSTEM_LOAD_PROCESS

AID_YR_LAST_EVENT_IND

SYSTEM_LOAD_TMSTMP

SUB_ACAD_PER_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

SUB_ACAD_PER_LAST_EVENT_IND

SYSTEM_LOAD_PROCESS

SYSTEM_LOAD_TMSTMP

PRE_STUDENT_STATUS_KEY

EVENT

EVENT_SEQ

SYSTEM_LOAD_TMSTMP

POST_SECONDARY_SCHOOL_KEY

EMPLOYMENT_HISTORY_KEY

CAL_MM_LAST_EVENT_IND

EVENT

FISCAL_QTR_LAST_EVENT_IND

FISCAL_YR_LAST_EVENT_IND

(More Target Columns -- list too long to display currently.)

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

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

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO



Ver: 3.1