Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: EXPRESSIONS Advancement
Banner Operational Data Store Composite View Source: EXPRESSIONS - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
ASIAN_IND_EXPRESSION        
BLACK_OR_AFRICAN_IND_EXPRESSION        
CITIZENSHIP_IND_EXPRESSION       STVCITZ_CITIZEN_IND
DECEASED_IND_EXPRESSION       SPBPERS_DEAD_IND
FIRST_PROPOSAL_RESULT_DATE_EXPRESSION       AMRPRRS_RESULT_DATE
GENDER_LD_EXPRESSION       SPBPERS_SEX
GENDER_SD_EXPRESSION       SPBPERS_SEX
HOME_INSTITUTION_IND_EXPRESSION       AUBINST_SBGI_CODE
LATEST_PROPOSAL_ASK_AMOUNT_EXPRESSION        
LATEST_PROPOSAL_ASK_DATE_EXPRESSION        
LIFETIME_GIFT_SOCIETY_IND_EXPRESSION       APRDCLB_DCYR_CODE
MINORITY_IND_EXPRESSION        
NON_RESIDENT_IND_EXPRESSION       STVVTYP_NON_RES_IND
PACIFIC_ISLANDER_IND_EXPRESSION       PACIFIC_ISLANDER_IND
PRIMARY_DISABILITY_EXPRESSION       SPRMEDI_DISB_IND, SPRMEDI_DISA_CODE
PRIMARY_DISABILITY_LD_EXPRESSION       SPRMEDI_DISB_IND, STVDISA_DESC
PRIMARY_DISABILITY_SD_EXPRESSION       SPRMEDI_DISB_IND, STVDISA_DESC
PROFILE_DATE_EXPRESSION       AMREXRT_ACTIVITY_DATE
PROPOSAL_ASK_AMOUNT_EXPRESSION        
PROPOSAL_ASK_MADE_IND_EXPRESSION        
PROPOSAL_ASSIGNED_IND_EXPRESSION       AMBPROP_STAFF_IDEN_CODE, AMBPROP_STAFF_PIDM
PROPOSAL_DURATION_EXPRESSION       AMBPROP_CREATE_DATE
PROPOSAL_START_DATE_EXPRESSION       AMBPROP_CREATE_DATE
PROPOSAL_STOP_DATE_EXPRESSION        
PROPOSAL_TARGET_DATE_EXPRESSION       AMBPROP_DUE_DATE
PROPOSAL_TOTAL_RESULT_AMOUNT_EXPRESSION        
PROSPECT_INT_ACTIVE_IND_EXPRESSION       ATVPRST_ACTIVE_IND
PROSPECT_INT_ASK_AMOUNT_EXPRESSION       SUM_ASK_AMT
PROSPECT_INT_END_DATE_EXPRESSION       AMRPRIN_PROJ_EFF_TO_DATE
PROSPECT_INT_LATEST_ASK_DATE_EXPRESSION        
PROSPECT_INT_LATEST_ASK_EXPRESSION        
PROSPECT_INT_START_DATE_EXPRESSION       AMRPRIN_PROJ_EFF_FROM_DATE
PROSPECT_INT_STATUS_DATE_EXPRESSION       AMRPRIN_PRST_DATE
PROSPECT_INT_TARGET_AMOUNT_EXPRESSION       AMRPRIN_TARGET_ASK_AMT
PROSPECT_INT_TARGET_DATE_EXPRESSION       AMRPRIN_TARGET_ASK_DATE
RACE_ETHNICITY_CONFIRM_IND_EXPRESSION       SPBPERS_CONFIRMED_RE_CDE
RACE_ETHNICITY_UNKNOWN_IND_EXPRESSION       SPBPERS_ETHN_CODE, STVVTYP_NON_RES_IND
TWO_OR_MORE_IND_EXPRESSION        
VETERAN_CATEGORY_LD_EXPRESSION       SPBPERS_VERA_IND
VETERAN_CATEGORY_SD_EXPRESSION       SPBPERS_VERA_IND
WHITE_IND_EXPRESSION        


Ver: