RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: AOBORGN - NULL

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

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

BUSINESS

NA 

NO

AOBORGN_EIN NO

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

FEDERAL_IDENTIFICATION

NA 

NO

AOBORGN_FIRST_NAME_CONTACT NO

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_FIRST_NAME

NA 

NO

AOBORGN_JOBC_CODE NO

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

JOB_CATEGORY

NA 

NO

AOBORGN_LAST_NAME_CONTACT NO

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_LAST_NAME

NA 

NO

AOBORGN_MATCH_MAXIMUM NO

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MATCH_MAXIMUM

NA 

NO

AOBORGN_MATCH_MINIMUM NO

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MATCH_MINIMUM

NA 

NO

AOBORGN_MATCH_ORG_EMPL_YR NO

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MAX_MATCH_ORG_EMPL_YEAR

NA 

NO

AOBORGN_MATCH_ORG_MAX NO

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MAX_YEAR_DONATE_AMOUNT

NA 

NO

AOBORGN_MATCH_PCT NO

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MATCHING_GIFT_PERCENT

NA 

NO

AOBORGN_MATCH_PERSON_MAX NO

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MAX_PERSON_MATCH_AMOUNT

NA 

NO

AOBORGN_MG_PIDM NO

REPORTING VIEW

RELATIONSHIP

ORGANIZATIONAL_CONSTITUENT

CURRENT_EMPLOYMENT

RELATED_MATCHING_GIFT_UID

MATCHING_GIFT_UID

MATCHING_GIFT_COMPANY_UID

NA 

NA 

NA 

NO

NO

NO

AOBORGN_MI_CONTACT NO

REPORTING VIEW

CONSTITUENT_ENTITY

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

PRIMARY_CONTACT_MIDDLE_INITIAL

CONTACT_MIDDLE_INITIAL_1

CONTACT_MIDDLE_INITIAL_2

NA 

NA 

NA 

NO

NO

NO

AOBORGN_PIDM NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATIONAL_CONSTITUENT

ENTITY_UID

ENTITY_UID

NA 

NA 

NO

NO

AOBORGN_PREFIX_CONTACT NO

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_NAME_PREFIX

NA 

NO

AOBORGN_PREF_ATYP_CODE NO

REPORTING VIEW

CONSTITUENT_ENTITY

ORGANIZATIONAL_CONSTITUENT

PREF_ADDRESS_TYPE

PREF_ADDRESS_TYPE

NA 

NA 

NO

NO

AOBORGN_PREF_ATYP_SEQNO NO

REPORTING VIEW

CONSTITUENT_ENTITY

ORGANIZATIONAL_CONSTITUENT

PREF_ADDRESS_NUMBER

PREF_ADDRESS_NUMBER

NA 

NA 

NO

NO

AOBORGN_SICC_CODE NO

DIMENSION TABLE


REPORTING VIEW

WDT_ENTITY

ORGANIZATIONAL_CONSTITUENT

STANDARD_INDUSTRIAL_CODE

STANDARD_INDUSTRY_CODE

ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE 

NA 

NO

NO

AOBORGN_SUFFIX_CONTACT NO

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_NAME_SUFFIX

NA 

NO

AOBORGN_TITLE_CONTACT NO

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_JOB_TITLE

NA 

NO



Ver: 9.0