RETURN TO BANNER EDW META DATA REPORTS LIST |
Source Column | Local Source | Target Type | Target | Target Column | Star Name | Local Target |
---|---|---|---|---|---|---|
SPRIDEN_ACTIVITY_DATE | NO | REPORTING VIEW |
NA NA NA |
NO NO NO |
||
SPRIDEN_CREATE_DATE | NO | REPORTING VIEW |
NA NA NA |
NO NO NO |
||
SPRIDEN_CREATE_USER | NO | REPORTING VIEW |
NA NA NA |
NO NO NO |
||
SPRIDEN_DATA_ORIGIN | NO | REPORTING VIEW |
NA NA NA |
NO NO NO |
||
SPRIDEN_ENTITY_IND | NO | REPORTING VIEW |
NA NA NA NA NA NA |
NO NO NO NO NO NO |
||
SPRIDEN_FIRST_NAME | NO | DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW |
color="#000000" face="Arial" size="2">FIXED_ASSET_FUNDING_SOURCE | / /font> | N
NOR, 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 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 NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
SPRIDEN_ID | NO | DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW DIMENSION TABLE DIMENSION TABLE |
E
EMENT FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_HISTORY (More Targets -- list too long to display currently.) (More Targets -- list too long to display currently.) (More Targets -- list too long to display currently.) |
D
DW_target.html#ID">ID<
DW_target.html#ID">ID (More Target Columns -- list too long to display currently.) (More Target Columns -- list too long to display currently.) (More Target Columns -- list too long to display currently.) |
G
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 ANALYZE FUNDRAISING, ASSIGNMENT, CONSTITUENT EVALUATION, CONTACT REPORT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, PROSPECT STAGE 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 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 NA NA NA NA NA NA NA NA NA NA NA 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&nbs 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 ANALYZE FUNDRAISING, ASSIGNMENT, CONSTITUENT EVALUATION, CONTACT REPORT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, PROSPECT STAGE 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 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 NA NA NA NA NA NA NA NA NA NA NA 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 ANALYZE FUNDRAISING, ASSIGNMENT, CONSTITUENT EVALUATION, CONTACT REPORT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, PROSPECT STAGE NA NA NA NA NA NA NA NA 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 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
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
SPRIDEN_LAST_NAME | NO | DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW |
<
PROPOSAL (More Targets -- list too long to display currently.) |
href="PLEDGE_EDW_target.html#SOLICITOR_LAST_NAME">SOLICITOR_LAST_NAME
href="PLEDGE_EDW_target.html#SOLICITOR_LAST_NAME">SOLICITOR_LAST_NAME (More Target Columns -- list too long to display currently.) |
&
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 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 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 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 NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI | NO | REPORTING VIEW REPORTING VIEW REPORTING VIEW |
S SIGN_CREATE_NAME">DELEGATE_ASSIGN_CREATE_NAME | 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 |
|
SPRIDEN_MI | NO | DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW |
i ize="2">ORGANIZATION_HIERARCHY | = ="#000000" face="Arial" size="2">MIDDLE_NAME | n
nbsp;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 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 NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
SPRIDEN_NTYP_CODE | NO | REPORTING VIEW |
NA NA |
NO NO |
||
SPRIDEN_ORIGIN | NO | REPORTING VIEW |
NA NA NA |
NO NO NO |
||
SPRIDEN_PIDM | NO | DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW |
CONTACT REPORT, MANAGE PROSPECT PIPELINE NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA CONTACT REPORT, MANAGE PROSPECT PIPELINE 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 |
||
SPRIDEN_SURNAME_PREFIX | NO | REPORTING VIEW REPORTING VIEW |
NA NA NA NA NA NA |
NO NO NO NO NO NO |
||
SPRIDEN_USER | NO | REPORTING VIEW |
NA NA NA |
NO NO NO |