Banner EDW Source: APREHIS

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
APREHIS_ATYP_CODE	NO
APREHIS_ATYP_SEQNO	NO
APREHIS_COMMENT	NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_COMMENT EMPLOYER_COMMENT	NA NA	NO NO
APREHIS_EMPL_POSITION	NO	REPORTING VIEW	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT	POSITION_TITLE2 POSITION_TITLE1 POSITION_TITLE POSITION_TITLE3 POSITION_TITLE POSITION_TITLE4	NA NA NA NA NA NA	NO NO NO NO NO NO
APREHIS_EMPR_NAME	NO	DIMENSION TABLE REPORTING VIEW	WDT_NON_ENTITY_RELATION CURRENT_EMPLOYMENT	RELATION_NAME EMPLOYER_NAME	ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP NA	NO NO
APREHIS_EMPR_PIDM	NO	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_UID EMPLOYER_UID	NA NA	NO NO
APREHIS_EMPS_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_CONST_EMPLOYMENT_JOB CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYMENT_STATUS EMPLOYMENT_STATUS EMPLOYMENT_STATUS	CONSTITUENT EMPLOYMENT NA NA	NO NO NO
APREHIS_FROM_DATE	NO	REPORTING VIEW	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT	END_DATE4 END_DATE1 START_DATE END_DATE2 END_DATE END_DATE3	NA NA NA NA NA NA	NO NO NO NO NO NO
APREHIS_JOBC_CODE	NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY EMPLOYER_CATEGORY	NA NA	NO NO
APREHIS_JOBC_CODE2	NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY2 EMPLOYER_CATEGORY2	NA NA	NO NO
APREHIS_JOBC_CODE3	NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY3 EMPLOYER_CATEGORY3	NA NA	NO NO
APREHIS_JOBC_CODE4	NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY4 EMPLOYER_CATEGORY4	NA NA	NO NO
APREHIS_MG_IND	NO	REPORTING VIEW	CURRENT_EMPLOYMENT	MATCHING_GIFT_IND	NA	NO
APREHIS_PIDM	NO	REPORTING VIEW	PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	PERSON_UID PERSON_UID PERSON_UID	NA NA NA	NO NO NO
APREHIS_PRIMARY_IND	NO	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	PRIMARY_EMPLOYMENT_IND PRIMARY_EMPLOYMENT_IND	NA NA	NO NO
APREHIS_SEQ_NO	NO	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYMENT_ORDER EMPLOYMENT_ORDER	NA NA	NO NO
APREHIS_SICC_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_NON_ENTITY_RELATION CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT	STANDARD_INDUSTRIAL_CODE EMPLOYER_INDUSTRIAL_TYPE EMPLOYER_TYPE1 EMPLOYER_TYPE3 EMPLOYER_TYPE2 EMPLOYER_INDUSTRIAL_TYPE EMPLOYER_TYPE4	ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP NA NA NA NA NA NA	NO NO NO NO NO NO NO
APREHIS_TO_DATE	NO	REPORTING VIEW	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT	START_DATE4 START_DATE2 START_DATE3 START_DATE START_DATE1	NA NA NA NA NA	NO NO NO NO NO
APREHIS_WKLY_HOURS	NO	FACT TABLE REPORTING VIEW	WFT_CONSTITUENT_EMPLOYMENT CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYEE_WEEKLY_HRS WEEKLY_HOURS WEEKLY_HOURS	CONSTITUENT EMPLOYMENT NA NA	NO NO NO

Ver: 9.0