SGHE Banner Operational Data Store
Composite View Source: TRANSLATIONS - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| CAMPAIGN_PYRAMID_GOAL_KEY_EXPRESSION |
TBD |
|
|
|
NVL( CAMPAIGN_PYRAMID_GOAL_KEY, 0) |
| DESIGNATION_ATTRIB_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( DESIGNATION_ATTRIB_GROUP_KEY, 0) |
| DONOR_CE_TYPE_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( DONOR_CE_TYPE_GROUP_KEY, 0) |
| FIRST_GIFT_DATE_OF_RECORD_EXPRESSION |
TBD |
|
|
|
NVL(FIRST_GIFT_DATE_OF_RECORD, DEC312099) |
| FIRST_GIFT_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN ( TRANS_TYPE = 'GIFT' AND (HARD_CREDIT_AMOUNT > 0 OR SOFT_CREDIT_AMOUNT > 0) AND TRANSACTION_DATE_OF_RECORD = FIRST_GIFT_DATE_OF_RECORD ) THEN 1 ELSE 0 END |
| FIRST_GIFT_OR_PLEDGE_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN ( (TRANS_TYPE = 'GIFT' OR TRANS_TYPE = 'PLEDGE') AND (HARD_CREDIT_AMOUNT > 0 OR SOFT_CREDIT_AMOUNT > 0) AND TRANSACTION_DATE_OF_RECORD = FIRST_GIFT_OR_PLEDGE_REC_DATE ) THEN 1 ELSE 0 END |
| FIRST_GIFT_OR_PLEDGE_REC_DATE_EXPRESSION |
TBD |
|
|
|
NVL(FIRST_GIFT_OR_PLEDGE_REC_DATE, DEC312099) |
| FUNDING_PURPOSE_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( FUNDING_PURPOSE_GROUP_KEY , 0) |
| GIVING_CODE_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( GIVING_CODE_GROUP_KEY, 0) |
| MG_CREDIT_GROUP_IDENTIFIER_EXPRESSION |
TBD |
|
|
|
TO_CHAR( MG_CREDIT_GROUP_IDENTIFIER ) |
| NEW_GIFT_DONOR_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN ( TRANS_TYPE = 'GIFT' AND (HARD_CREDIT_AMOUNT > 0 OR SOFT_CREDIT_AMOUNT > 0) AND TRANSACTION_DATE_OF_RECORD = FIRST_GIFT_DATE_OF_RECORD ) THEN DONOR_ENTITY_KEY ELSE NULL END |
| NEW_GIFT_OR_PLEDGE_DONOR_COUNT_EXPRESSIO N |
TBD |
|
|
|
CASE WHEN ( (TRANS_TYPE = 'GIFT' OR TRANS_TYPE = 'PLEDGE') AND (HARD_CREDIT_AMOUNT > 0 OR SOFT_CREDIT_AMOUNT > 0) AND TRANSACTION_DATE_OF_RECORD = FIRST_GIFT_OR_PLEDGE_REC_DATE ) THEN DONOR_ENTITY_KEY ELSE NULL END |
| PLEDGE_GROUP_IDENTIFIER_EXPRESSION |
TBD |
|
|
|
TO_CHAR( PLEDGE_GROUP_IDENTIFIER ) |
| PLEDGE_WRITTEN_OFF_DATE_EXPRESSION |
TBD |
|
|
|
NVL(PLEDGE_WRITTEN_OFF_DATE, DEC312099) |
| 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) |
| SOURCE_CE_TYPE_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
NVL( SOURCE_CE_TYPE_GROUP_KEY, 0) |
| TRANSACTION_NUMBER_EXPRESSION |
TBD |
|
|
|
( TRANSACTION_NUMBER ) |
| TRANSACTION_RECEIPT_DATE_EXPRESSION |
TBD |
|
|
|
NVL(TRANSACTION_RECEIPT_DATE, DEC312099) |