SGHE Banner Operational Data Store
Composite View Source: EXPRESSION_0 - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| ACTIVE_MATCHING_CLAIM_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN MATCHING_CLAIM_ACTIVE_IND = 1 THEN AGRMDES_GIFT_NO END |
| ALL_PROSPECT_ENTITY_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN ALL_PROSPECT_IND = 1 THEN WAREHOUSE_ENTITY_UID ELSE NULL END |
| ALUM_ENTITY_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVDONR_ALUM_IND = 'Y' THEN WAREHOUSE_ENTITY_UID ELSE NULL END |
| ASSIGNED_ENTITY_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN ASSIGNED_IND = 1 THEN WAREHOUSE_ENTITY_UID ELSE NULL END |
| CONTACTED_ENTITY_COUNT_EXPRESSION |
TBD |
|
|
|
case when CONTACT_REPORT_IND = 1 then WAREHOUSE_ENTITY_UID else NULL end |
| DESIGNATION_COUNT_EXPRESSION |
TBD |
|
|
|
to_number( AGRMDES_GIFT_NO ) + ( DESIGNATION_DETAIL_KEY * .0001) |
| ENTITY_CONTACT_COUNT_EXPRESSION |
TBD |
|
|
|
DECODE( ENTITY_KEY ,NULL ,NULL , CONTACT_REPORT_KEY ) |
| MINORITY_IND_EXPRESSION |
TBD |
|
|
|
SIGN( SUM_MINORITY_IND ) |
| PLEDGE_BATCH_NUMBER_EXPRESSION |
TBD |
|
|
|
NVL( AGBPLDG_FEED_DOC_CODE, 'Not Available') |
| PRIMARY_PROSPECT_ENTITY_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN PRIMARY_PROSPECT_ENTITY_IND = 1 THEN WAREHOUSE_ENTITY_UID ELSE NULL END |
| PROPOSAL_CONTACT_COUNT_EXPRESSION |
TBD |
|
|
|
decode(PROPOSAL_KEY, 0, NULL, CONTACT_REPORT_KEY) |
| PROSPECT_CONTACT_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN AMRCONT_GEN_CONTACT_IND ='N' THEN CONTACT_REPORT_KEY ELSE NULL END |
| PROSPECT_ENTITY_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN PROSPECT_IND = 1 THEN WAREHOUSE_ENTITY_UID ELSE NULL END |
| RATED_PROSPECT_ENTITY_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN RATED_PROSPECT_IND = 1 THEN WAREHOUSE_ENTITY_UID ELSE NULL END |
| SOLICITOR_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN AMRSTAF_SOLICIT_IND = 'Y' THEN 1 ELSE 0 END |
| SOLICITOR_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AMRSTAF_SOLICIT_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| SOLICITOR_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AMRSTAF_SOLICIT_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| SPOUSE_GROUP_IDENTIFIER_EXPRESSION |
TBD |
|
|
|
CASE WHEN RELATION_SPOUSE_IND = 1 THEN LEAST(WAREHOUSE_ENTITY_UID_1, WAREHOUSE_ENTITY_UID) || '.' || GREATEST(WAREHOUSE_ENTITY_UID_1, WAREHOUSE_ENTITY_UID) ELSE NULL END |