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 |
< OPERATING_LEDGER | i ial" SIZE="2">INSTRUCTOR_FIRST_NAME< ial" SIZE="2">INSTRUCTOR_FIRST_NAME | T
T, 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
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO 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 |
FACE="Arial" SIZE="2">FIXED_ASSET_ACCOUNTING_SOURCE 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.) |
S
SIZE="2">ORGN_FINANCIAL_MANAGER_ID ORGN_FINANCIAL SIZE="2">ORGN_FINANCIAL_MANAGER_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.) |
;
;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 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& ;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 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 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 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 NO NO NO |
SPRIDEN_LAST_NAME | NO | DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW |
g
get.html">PERSON_SENSITIVE (More Targets -- list too long to display currently.) |
0
000" FACE="Arial" SIZE="2">LAST_NAME AGENCY_N 000" FACE="Arial" SIZE="2">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 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 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 |
SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI | NO | REPORTING VIEW REPORTING VIEW REPORTING VIEW |
NA NA NA NA NA NA |
NO NO NO NO NO NO |
||
SPRIDEN_MI | NO | DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW |
A Arial" SIZE="2">GRANT_FUND | 0
00000" FACE="Arial" SIZE="2">PRINCIPAL_INVESTIGATOR_MNAME FMGR_MIDDLE_ 00000" FACE="Arial" SIZE="2">PRINCIPAL_INVESTIGATOR_MNAME |
F
FT, 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
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO 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_NAME_PREFIX | NO | |||||
SPRIDEN_NAME_SUFFIX | 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 |