SGHE Banner Operational Data Store
Reporting View Source: EXPRESSION_1 - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| ACTIVE_PROGRAM_PROSPECT_COUNT_EXPRESSION |
TBD |
|
|
|
ACTIVE_PROGRAM_PROSPECT_COUNT |
| ACTIVE_PROPOSAL_COUNT_EXPRESSION |
TBD |
|
|
|
ACTIVE_PROPOSAL_COUNT |
| ACTIVE_PROSPECT_COUNT_EXPRESSION |
TBD |
|
|
|
ACTIVE_PROSPECT_COUNT |
| ADVANCEMENT_PROGRAM_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when ADVANCEMENT_PROGRAM_KEY = -1 then 0 else ADVANCEMENT_PROGRAM_KEY end,0) |
| ADVANCEMENT_PROGRAM_YEAR_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when ADVANCEMENT_PROGRAM_YEAR_KEY = -1 then 0 else ADVANCEMENT_PROGRAM_YEAR_KEY end,0) |
| CE_TYPE_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( CE_TYPE_GROUP_KEY ,0) |
| CLEARANCE_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc(CLEARANCE_START_DATE),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| CLEARANCE_STOP_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc(CLEARANCE_STOP_DATE),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| CONSTITUENT_ENTITY_ATTRIB_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when CONSTITUENT_ENTITY_ATTRIB_KEY = -1 then 0 else CONSTITUENT_ENTITY_ATTRIB_KEY end,0) |
| CURRENT_GIVING_TOTAL_KEY_EXPRESSION |
TBD |
|
|
|
NVL( GIVING_TOTAL_KEY ,0) |
| CURRENT_SP_GIVING_TOTAL_KEY_EXPRESSION |
TBD |
|
|
|
NVL( GIVING_TOTAL_KEY_1 ,0) |
| DEMOGRAPHIC_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when DEMOGRAPHIC_KEY = -1 then 0 else DEMOGRAPHIC_KEY end ,0) |
| ENTITY_ID_EXPRESSION |
TBD |
|
|
|
ENTITY_ID |
| FIRST_PROPOSAL_RESULT_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( FIRST_PROPOSAL_RESULT_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| FIRST_PROP_PURPOSE_RESULT_DATE_EXPRESSIO N |
TBD |
|
|
|
NVL( PROPOSAL_PURPOSE_RESULT_DATE , TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| GIFT_DATE_OF_RECORD_EXPRESSION |
TBD |
|
|
|
NVL(AGBGIFT_GIFT_DATE , TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| GIFT_RECEIPT_DATE_EXPRESSION |
TBD |
|
|
|
NVL( AGBGIFT_RECEIPT_DATE , TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| LAST_ENT_CRPT_ATTRIB_KEY_EXPRESSION |
TBD |
|
|
|
NVL( CONTACT_REPORT_ATTRIBUTE_KEY ,0) |
| LAST_ENT_CRPT_AUTH_STAFF_KEY_EXPRESSION |
TBD |
|
|
|
NVL( AUTHOR_STAFF_KEY ,0) |
| LAST_ENT_CRPT_KEY_EXPRESSION |
TBD |
|
|
|
NVL( CONTACT_REPORT_KEY ,0) |
| LAST_PROPOSAL_PURPOSE_ASK_DATE_EXPRESSIO N |
TBD |
|
|
|
NVL(PROPOSAL_PURPOSE_LATEST_ASK_DT, TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| LAST_PROS_CRPT_ATTRIB_KEY_EXPRESSION |
TBD |
|
|
|
NVL( CONTACT_REPORT_ATTRIBUTE_KEY_1 ,0) |
| LAST_PROS_CRPT_AUTH_STAFF_KEY_EXPRESSION |
TBD |
|
|
|
NVL( AUTHOR_STAFF_KEY_1 ,0) |
| LAST_PROS_CRPT_KEY_EXPRESSION |
TBD |
|
|
|
NVL( CONTACT_REPORT_KEY_1 ,0) |
| LATEST_ENTITY_CONTACT_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( CONTACT_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| LATEST_PROPOSAL_ASK_AMOUNT_EXPRESSION |
TBD |
|
|
|
LATEST_PROPOSAL_ASK_AMOUNT |
| LATEST_PROSPECT_CONTACT_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( CONTACT_DATE_1 ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| LG_HARD_GIVING_TOTAL_KEY_EXPRESSION |
TBD |
|
|
|
NVL( LG_HARD_GIVING_TOTAL_KEY ,0) |
| LG_HARD_SP_GIVING_TOTAL_KEY_EXPRESSION |
TBD |
|
|
|
NVL(LG_HARD_SP_GIVING_TOTAL_KEY ,0) |
| LG_SOFT_GIVING_TOTAL_KEY_EXPRESSION |
TBD |
|
|
|
NVL( LG_SOFT_GIVING_TOTAL_KEY ,0) |
| LG_SOFT_SP_GIVING_TOTAL_KEY_EXPRESSION |
TBD |
|
|
|
NVL( LG_SOFT_SP_GIVING_TOTAL_KEY ,0) |
| PGM_PROSPECT_SHARED_ATTRIB_KEY_EXPRESSIO N |
TBD |
|
|
|
NVL(case when PGM_PROSPECT_SHARED_ATTRIB_KEY = -1 then 0 else PGM_PROSPECT_SHARED_ATTRIB_KEY end,0) |
| PGM_PROSPECT_STAGE_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PGM_PROSPECT_STAGE_START_DATE) ,TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PREFERRED_ADDRESS_TYPE_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PREFERRED_ADDRESS_TYPE_KEY = -1 then 0 else PREFERRED_ADDRESS_TYPE_KEY end,0) |
| PREFERRED_CLASS_SCHOOL_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PREFERRED_CLASS_SCHOOL_KEY = -1 then 0 else PREFERRED_CLASS_SCHOOL_KEY end,0) |
| PREFERRED_POSTAL_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PREFERRED_POSTAL_KEY = -1 then 0 else PREFERRED_POSTAL_KEY end,0) |
| PREFERRED_STREET_LINE_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PREFERRED_STREET_LINE_KEY = -1 then 0 else PREFERRED_STREET_LINE_KEY end,0) |
| PRIMARY_ASSIGNMENT_ENTITY_KEY_EXPRESSION |
TBD |
|
|
|
NVL( ASSIGNMENT_ENTITY_KEY ,0) |
| PRIMARY_ASSIGNMENT_ENTITY_UID_EXPRESSION |
TBD |
|
|
|
NVL( ASSIGNMENT_ENTITY_UID ,0) |
| PRIMARY_ASSIGNMENT_KEY_EXPRESSION |
TBD |
|
|
|
NVL( ASSIGNMENT_KEY ,0) |
| PRIMARY_ASSIGNMENT_OFFICE_KEY_EXPRESSION |
TBD |
|
|
|
NVL( ASSIGNMENT_OFFICE_KEY ,0) |
| PRIMARY_ASSIGNMENT_STAFF_KEY_EXPRESSION |
TBD |
|
|
|
NVL( ASSIGNMENT_STAFF_KEY ,0) |
| PRIMARY_ASSIGNMENT_UNIT_KEY_EXPRESSION |
TBD |
|
|
|
NVL( ASSIGNMENT_UNIT_KEY ,0) |
| PRIMARY_CE_TYPE_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PRIMARY_CE_TYPE_KEY = -1 then 0 else PRIMARY_CE_TYPE_KEY end,0) |
| PRIMARY_PROSPECT_ENTITY_COUNT_EXPRESSION |
TBD |
|
|
|
PRIMARY_PROSPECT_ENTITY_COUNT |
| PROGRAM_ASSIGNMENT_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( PROGRAM_ASSIGNMENT_GROUP_KEY ,0) |
| PROGRAM_PROSPECT_ASSIGNED_IND_EXPRESSION |
TBD |
|
|
|
NVL( PROGRAM_PROSPECT_ASSIGNED_IND , 0) |
| PROGRAM_PROSPECT_ATTRIBUTE_KEY_EXPRESSIO N |
TBD |
|
|
|
NVL(case when PROGRAM_PROSPECT_ATTRIBUTE_KEY = -1 then 0 else PROGRAM_PROSPECT_ATTRIBUTE_KEY end,0) |
| PROGRAM_PROSPECT_COUNT_EXPRESSION |
TBD |
|
|
|
PROGRAM_PROSPECT_COUNT |
| PROGRAM_PROSPECT_RATED_AMOUNT_EXPRESSION |
TBD |
|
|
|
PROGRAM_PROSPECT_RATED_AMOUNT |
| PROGRAM_PROSPECT_RESULT_AMOUNT_EXPRESSIO N |
TBD |
|
|
|
PROGRAM_PROSPECT_RESULT_AMOUNT |
| PROGRAM_PROSPECT_RESULT_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PROGRAM_PROSPECT_RESULT_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROGRAM_PROSPECT_STAGE_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROGRAM_PROSPECT_STAGE_KEY_1 = -1 then 0 else PROGRAM_PROSPECT_STAGE_KEY_1 end,0) |
| PROGRAM_PROSPECT_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc(PROGRAM_PROSPECT_START_DATE),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROGRAM_PROSPECT_STOP_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc(PROGRAM_PROSPECT_STOP_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROGRAM_PROSPECT_TARGET_DATE_EXPRESSION |
TBD |
|
|
|
nvl(trunc( PROGRAM_PROSPECT_TARGET_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROGRAM_PROSPECT_UNIT_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROGRAM_PROSPECT_UNIT_KEY = -1 then 0 else PROGRAM_PROSPECT_UNIT_KEY end,0) |
| PROPOSAL_ASK_AMOUNT_EXPRESSION |
TBD |
|
|
|
PROPOSAL_ASK_AMOUNT |
| PROPOSAL_ASK_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( LATEST_PROPOSAL_ASK_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_ASK_MADE_IND_EXPRESSION |
TBD |
|
|
|
NVL(PROPOSAL_ASK_MADE_IND,0) |
| PROPOSAL_ASSIGNED_IND_EXPRESSION |
TBD |
|
|
|
NVL(PROPOSAL_ASSIGNED_IND,0) |
| PROPOSAL_ASSIGNMENT_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( PROPOSAL_ASSIGNMENT_GROUP_KEY ,0) |
| PROPOSAL_ATTRIBUTE_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROPOSAL_ATTRIBUTE_KEY = -1 then 0 else PROPOSAL_ATTRIBUTE_KEY end,0) |
| PROPOSAL_CAMPAIGN_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROPOSAL_CAMPAIGN_KEY = -1 then 0 else PROPOSAL_CAMPAIGN_KEY end,0) |
| PROPOSAL_COUNT_EXPRESSION |
TBD |
|
|
|
PROPOSAL_COUNT |
| PROPOSAL_DURATION_EXPRESSION |
TBD |
|
|
|
PROPOSAL_DURATION |
| PROPOSAL_GRANTED_AMOUNT_EXPRESSION |
TBD |
|
|
|
PROPOSAL_GRANTED_AMOUNT |
| PROPOSAL_GRANTED_IND_EXPRESSION |
TBD |
|
|
|
NVL(PROPOSAL_GRANTED_IND,0) |
| PROPOSAL_INIT_CONTRIB_AMOUNT_EXPRESSION |
TBD |
|
|
|
PROPOSAL_INIT_CONTRIB_AMOUNT |
| PROPOSAL_INIT_CONTRIB_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PROPOSAL_INIT_CONTRIB_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROPOSAL_KEY = -1 then 0 else PROPOSAL_KEY end,0) |
| PROPOSAL_ORIGINAL_ASK_AMOUNT_EXPRESSION |
TBD |
|
|
|
PROPOSAL_ORIGINAL_ASK_AMOUNT |
| PROPOSAL_PURPOSE_ACTIVE_IND_EXPRESSION |
TBD |
|
|
|
NVL( PROPOSAL_PURPOSE_ACTIVE_IND, 0) |
| PROPOSAL_PURPOSE_ASK_MADE_IND_EXPRESSION |
TBD |
|
|
|
NVL( PROPOSAL_PURPOSE_ASK_MADE_IND, 0) |
| PROPOSAL_PURPOSE_END_DATE_EXPRESSION |
TBD |
|
|
|
NVL(PROPOSAL_PURPOSE_END_DATE, TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_PURPOSE_GRANTED_IND_EXPRESSION |
TBD |
|
|
|
NVL( PROPOSAL_PURPOSE_GRANTED_IND, 0) |
| PROPOSAL_PURPOSE_RESULT_IND_EXPRESSION |
TBD |
|
|
|
NVL( PROPOSAL_PURPOSE_RESULT_IND, 0) |
| PROPOSAL_PURPOSE_STAGE_DATE_EXPRESSION |
TBD |
|
|
|
NVL( PROPOSAL_PURP_STAGE_START_DATE, TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_PURPOSE_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL(PROPOSAL_PURPOSE_START_DATE, TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_PURPOSE_TARGET_DATE_EXPRESSION |
TBD |
|
|
|
NVL( PROPOSAL_PURPOSE_TARGET_DATE, TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_RESULT_IND_EXPRESSION |
TBD |
|
|
|
--case when sign( INGRP1.PROPOSAL_PLEDGE_RESULT_AMOUNT + INGRP1.PROPOSAL_GIFT_RESULT_AMOUNT ) = 1 then 1 else 0 end CASE WHEN PROPOSAL_TOTAL_RESULT_AMOUNT > 0 THEN 1 ELSE 0 END |
| PROPOSAL_STAGE_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROPOSAL_STAGE_KEY_1 = -1 then 0 else PROPOSAL_STAGE_KEY_1 end,0) |
| PROPOSAL_STAGE_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PROPOSAL_STAGE_START_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PROPOSAL_START_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_STOP_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PROPOSAL_STOP_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_TARGET_AMOUNT_EXPRESSION |
TBD |
|
|
|
PROPOSAL_TARGET_AMOUNT |
| PROPOSAL_TARGET_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PROPOSAL_TARGET_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_TOTAL_RESULT_AMOUNT_EXPRESSION |
TBD |
|
|
|
PROPOSAL_TOTAL_RESULT_AMOUNT |
| PROPOSAL_UNIT_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROPOSAL_UNIT_KEY = -1 then 0 else PROPOSAL_UNIT_KEY end,0) |
| PROSPECT_ASSIGNED_IND_EXPRESSION |
TBD |
|
|
|
NVL( PROSPECT_ASSIGNED_IND ,0) |
| PROSPECT_ASSIGNMENT_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( PROSPECT_ASSIGNMENT_GROUP_KEY ,0) |
| PROSPECT_ATTRIBUTE_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROSPECT_ATTRIBUTE_KEY = -1 then 0 else PROSPECT_ATTRIBUTE_KEY end,0) |
| PROSPECT_CAMPAIGN_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROSPECT_CAMPAIGN_KEY = -1 then 0 else PROSPECT_CAMPAIGN_KEY end,0) |
| PROSPECT_CATEGORY_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( PROSPECT_CATEGORY_GROUP_KEY ,0) |
| PROSPECT_COUNT_EXPRESSION |
TBD |
|
|
|
PROSPECT_COUNT |
| PROSPECT_ENTITY_COUNT_EXPRESSION |
TBD |
|
|
|
PROSPECT_ENTITY_COUNT |
| PROSPECT_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROSPECT_KEY_6 = -1 then 0 else PROSPECT_KEY_6 end ,0) |
| PROSPECT_PIPELINE_GROUP_A_KEY_EXPRESSION |
TBD |
|
|
|
NVL( PROSPECT_PIPELINE_GROUP_A_KEY ,0) |
| PROSPECT_PIPELINE_GROUP_B_KEY_EXPRESSION |
TBD |
|
|
|
NVL( PROSPECT_PIPELINE_GROUP_B_KEY ,0) |
| PROSPECT_RATED_AMOUNT_EXPRESSION |
TBD |
|
|
|
PROSPECT_RATED_AMOUNT |
| PROSPECT_RATE_ENTRY_DATE_EXPRESSION |
TBD |
|
|
|
NVL( trunc(PROSPECT_RATE_ENTRY_DATE) ,TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_RESULT_AMOUNT_EXPRESSION |
TBD |
|
|
|
PROSPECT_RESULT_AMOUNT |
| PROSPECT_RESULT_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc(PROSPECT_RESULT_DATE),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_SHARED_ATTRIBUTE_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROSPECT_SHARED_ATTRIBUTE_KEY = -1 then 0 else PROSPECT_SHARED_ATTRIBUTE_KEY end ,0) |
| PROSPECT_STAGE_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROSPECT_STAGE_KEY = -1 then 0 else PROSPECT_STAGE_KEY end,0) |
| PROSPECT_STAGE_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PROSPECT_STAGE_START_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PROSPECT_START_DATE),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_STOP_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc( PROSPECT_STOP_DATE),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_TARGET_DATE_EXPRESSION |
TBD |
|
|
|
NVL(trunc(PROSPECT_TARGET_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_UNIT_KEY_EXPRESSION |
TBD |
|
|
|
NVL(case when PROSPECT_UNIT_KEY = -1 then 0 else PROSPECT_UNIT_KEY end,0) |
| PROS_INT_MEASURE_FILTER_IND_EXPRESSION |
TBD |
|
|
|
decode(ROW_NUMBER() OVER (PARTITION BY PROSPECT_KEY_6 ORDER BY sign(ACTIVE_PROPOSAL_COUNT) ASC, PROPOSAL_STOP_DATE desc, PROPOSAL_START_DATE desc, sign(PROPOSAL_COUNT) asc),1,1,0) |
| SPOUSE_ENTITY_KEY_EXPRESSION |
TBD |
|
|
|
NVL( RELATED_ENTITY_KEY ,0) |
| SPOUSE_UID_EXPRESSION |
TBD |
|
|
|
NVL( RELATED_ENTITY_UID ,0) |