SGHE Banner Operational Data Store
Reporting View Source: EXPRESSION - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| (CAMPAIGN_SOLICITOR_GOAL / CAMPAIGN_GOAL * 100) |
TBD |
REPORTING VIEW |
CAMPAIGN_FUNDRAISER |
SOLICITOR_PCT_OF_CAMPAIGN_GOAL |
|
| ACTIVE_ADDRESS_IND_EXPRESSION |
TBD |
|
|
|
case when SPRADDR_STATUS_IND is null Or SPRADDR_STATUS_IND = 'A' then 1 else 0 end |
| ACTIVE_PROPOSAL_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVPRST_ACTIVE_IND = 'Y' THEN 1 ELSE 0 END |
| ACTIVE_PROPOSAL_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE ATVPRST_ACTIVE_IND WHEN 'Y' THEN 'Yes' ELSE 'No' END |
| ACTIVE_PROPOSAL_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE ATVPRST_ACTIVE_IND WHEN 'Y' THEN 'Yes' ELSE 'No' END |
| ACTIVE_PROPOSAL_PURPOSE_COUNT_EXPRESSION |
TBD |
|
|
|
DECODE( PROPOSAL_PURPOSE_ACTIVE_IND, 1, PROPOSAL_PURPOSE_COUNT ,NULL) |
| ACTIVE_PROSPECT_IND_EXPRESSION |
TBD |
|
|
|
case when ATVPRST_ACTIVE_IND = null or ATVPRST_ACTIVE_IND ='Y' then 1 else 0 end |
| ADDRESS_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL(SPRADDR_FROM_DATE, TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| ADDRESS_STOP_DATE_EXPRESSION |
TBD |
|
|
|
NVL(SPRADDR_TO_DATE, TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| ADDRESS_TYPE_EXPRESSION |
TBD |
|
|
|
STVATYP_CODE |
| ADDRESS_TYPE_LD_EXPRESSION |
TBD |
|
|
|
STVATYP_DESC |
| ADDRESS_TYPE_SD_EXPRESSION |
TBD |
|
|
|
STVATYP_DESC |
| ADDR_PREF_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN (SPRADDR_PIDM = APBCONS_PIDM And SPRADDR_ATYP_CODE = APBCONS_ATYP_CODE_PREF And SPRADDR_SEQNO = SPRADDR_SEQNO_1 And NVL(SPRADDR_STATUS_IND,'~') = NVL(SPRADDR_STATUS_IND_1,'~')) THEN 1 ELSE 0 END |
| ALL_PROSPECT_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN APBCONS_AOBORGN_PIDM = AMRINFO_PIDM THEN 1 ELSE 0 END |
| ALL_PROSPECT_IND_LD_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AMRINFO_PIDM THEN 'Yes' ELSE 'No' END |
| ALL_PROSPECT_IND_SD_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AMRINFO_PIDM THEN 'Yes' ELSE 'No' END |
| ALUMNUS_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVDONR_ALUM_IND = 'Y' THEN 1 ELSE 0 END |
| ALUMNUS_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVDONR_ALUM_IND = 'Y' THEN 'YES' ELSE 'NO' END |
| ALUMNUS_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVDONR_ALUM_IND = 'Y' THEN 'YES' ELSE 'NO' END |
| ASSIGNMENT_TYPE_LD_EXPRESSION |
TBD |
|
|
|
initcap( ATVSTFT_DESC ) |
| ASSIGNMENT_TYPE_SD_EXPRESSION |
TBD |
|
|
|
initcap( ATVSTFT_DESC ) |
| CAMPAIGN_ACTIVE_IND_EXPRESSION |
NA |
|
|
|
|
| CAMPAIGN_ACTIVE_IND_LD_EXPRESSION |
NA |
|
|
|
|
| CAMPAIGN_ACTIVE_IND_SD_EXPRESSION |
NA |
|
|
|
|
| CAMP_INCLUDE_IN_GIVING_IND_EXPRESSION |
NA |
|
|
|
|
| CAMP_INCLUDE_IN_GIVING_IND_LD_EXPRESSION |
NA |
|
|
|
|
| CAMP_INCLUDE_IN_GIVING_IND_SD_EXPRESSION |
NA |
|
|
|
|
| CAPITAL_CAMPAIGN_IND_EXPRESSION |
NA |
|
|
|
|
| CAPITAL_CAMPAIGN_IND_LD_EXPRESSION |
NA |
|
|
|
|
| CAPITAL_CAMPAIGN_IND_SD_EXPRESSION |
NA |
|
|
|
|
| CASE WHEN (CAMPAIGN_GOAL > 0 |
TBD |
REPORTING VIEW |
CAMPAIGN_FUNDRAISER |
PCT_SOLC_PROGRESS_CAMP_GOAL |
|
| CE_TYPE_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
ENTITY_UID + (MULTI_SOURCE_KEY * .01) |
| CONTACT_DATE_EXPRESSION |
TBD |
|
|
|
NVL( trunc(AMRCONT_CONTACT_DATE) ,TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| CONTACT_REPORT_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN APBCONS_AOBORGN_PIDM = AMRCONT_PIDM then 1 else 0 end |
| CONTACT_REPORT_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN APBCONS_AOBORGN_PIDM = AMRCONT_PIDM THEN 'Yes' ELSE 'No' END |
| CONTACT_REPORT_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN APBCONS_AOBORGN_PIDM = AMRCONT_PIDM THEN 'Yes' ELSE 'No' END |
| CREDIT_CARD_PAYMENT_IND_EXPRESSION |
NA |
|
|
|
|
| CREDIT_CARD_PAYMENT_IND_LD_EXPRESSION |
NA |
|
|
|
|
| CREDIT_CARD_PAYMENT_IND_SD_EXPRESSION |
NA |
|
|
|
|
| DECODE (AMRPLAN_PROJ_CODE, AMRCONT_PROJ_CODE |
TBD |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PRIMARY_PROJECT_IND |
|
| DECODE (APRIGRP_DISP_WEB_IND, 'Y', 'Y', 'N') |
TBD |
REPORTING VIEW |
INTEREST |
DISPLAY_WEB_IND |
|
| DESIGNATION_ATTRIB_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
( DESIGNATION_DETAIL_KEY * 100) + MULTI_SOURCE_KEY |
| DONOR_ASSOCIATION_LD_EXPRESSION |
TBD |
|
|
|
CASE (DONOR_ASSOCIATION) WHEN 'PD' THEN 'Primary Donor' WHEN 'HR' THEN 'Hard Credit Recipient' WHEN 'SR' THEN 'Soft Credit Recipient' WHEN 'MD' THEN 'Match Claim Donor' ELSE 'Unknown' END |
| DONOR_ASSOCIATION_SD_EXPRESSION |
TBD |
|
|
|
CASE (DONOR_ASSOCIATION) WHEN 'PD' THEN 'Primary Donor' WHEN 'HR' THEN 'Hard Credit Recipient' WHEN 'SR' THEN 'Soft Credit Recipient' WHEN 'MD' THEN 'Match Claim Donor' ELSE 'Unknown' END |
| DONOR_IND_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AGRGMMO_AGRGMLT_AGRGDES_PIDM then 1 else 0 end |
| DONOR_IND_LD_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AGRGMMO_AGRGMLT_AGRGDES_PIDM THEN 'Yes' ELSE 'No' END |
| DONOR_IND_SD_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AGRGMMO_AGRGMLT_AGRGDES_PIDM THEN 'Yes' ELSE 'No' END |
| FIRST_PROPOSAL_PURP_RESULT_IND_EXPRESSIO N |
TBD |
|
|
|
CASE WHEN (row_number() over (partition by AMRPRRS_PIDM, AMRPRRS_PROP_CODE, AMRPRRS_PROP_SEQ_NO, AMRPRRS_PROJ_CODE order by AMRPRRS_RESULT_DATE)= 1) THEN 1 ELSE 0 END |
| GIFT_ACKNOWLEDGED_IND_EXPRESSION |
NA |
|
|
|
|
| GIFT_ACKNOWLEDGED_IND_LD_EXPRESSION |
NA |
|
|
|
|
| GIFT_ACKNOWLEDGED_IND_SD_EXPRESSION |
NA |
|
|
|
|
| GIFT_ADJUSTED_IND_EXPRESSION |
NA |
|
|
|
|
| GIFT_ADJUSTED_IND_LD_EXPRESSION |
NA |
|
|
|
|
| GIFT_ADJUSTED_IND_SD_EXPRESSION |
NA |
|
|
|
|
| GIFT_ANONYMOUS_IND_EXPRESSION |
NA |
|
|
|
|
| GIFT_ANONYMOUS_IND_LD_EXPRESSION |
NA |
|
|
|
|
| GIFT_ANONYMOUS_IND_SD_EXPRESSION |
NA |
|
|
|
|
| GIFT_BATCH_NUMBER_EXPRESSION |
TBD |
|
|
|
NVL(GIFT_BATCH_NUMBER, '0') |
| GIFT_CAE_TYPE_LD_EXPRESSION |
NA |
|
|
|
|
| GIFT_CAE_TYPE_SD_EXPRESSION |
NA |
|
|
|
|
| GIFT_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN TRANSACTION_TYPE ='PP' THEN 1 ELSE 0 END |
| GIFT_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN TRANSACTION_TYPE ='PP' THEN 'Yes' ELSE 'No' END |
| GIFT_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN TRANSACTION_TYPE ='PP' THEN 'Yes' ELSE 'No' END |
| GIFT_NUMBER_EXPRESSION |
TBD |
|
|
|
AGBMGID_EMPL_GIFT_NO |
| INITIAL_ENTITY_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case when INITIAL_ENTITY_CONTACT_DATE = 1 then 1 else 0 end |
| INITIAL_INTEREST_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case WHEN INITIAL_INTEREST_CONTACT_DATE = 1 then 1 else 0 end |
| INITIAL_PROPOSAL_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case when INITIAL_PROPOSAL_CONTACT_DATE = 1 then 1 else 0 end |
| INITIAL_PROP_PURP_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case when INITIAL_PROP_PURP_CONTACT_DATE = 1 then 1 else 0 end |
| INITIAL_PROSPECT_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case when INITIAL_PROSPECT_CONTACT_DATE = 1 then 1 else 0 end |
| LAST_PROPOSAL_PURP_RESULT_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN (row_number() over (partition by AMRPRRS_PIDM, AMRPRRS_PROP_CODE, AMRPRRS_PROP_SEQ_NO, AMRPRRS_PROJ_CODE order by AMRPRRS_RESULT_DATE desc) = 1) THEN 1 ELSE 0 END |
| LATEST_ENTITY_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case when LATEST_ENTITY_CONTACT_DATE = 1 then 1 else 0 end |
| LATEST_INTEREST_ASK_IND_EXPRESSION |
TBD |
|
|
|
case WHEN LATEST_INTEREST_ASK_DATE = 1 then 1 else 0 end |
| LATEST_INTEREST_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case WHEN LATEST_INTEREST_CONTACT_DATE = 1 then 1 else 0 end |
| LATEST_PROPOSAL_ASK_IND_EXPRESSION |
TBD |
|
|
|
case when LATEST_PROPOSAL_ASK_DATE = 1 then 1 else 0 end |
| LATEST_PROPOSAL_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case when LATEST_PROPOSAL_CONTACT_DATE = 1 then 1 else 0 end |
| LATEST_PROP_PURP_ASK_IND_EXPRESSION |
TBD |
|
|
|
case when LATEST_PROP_PURP_ASK_DATE = 1 then 1 else 0 end |
| LATEST_PROP_PURP_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case when LATEST_PROP_PURP_CONTACT_DATE = 1 then 1 else 0 end |
| LATEST_PROSPECT_CONTACT_IND_EXPRESSION |
TBD |
|
|
|
case when LATEST_PROSPECT_CONTACT_DATE = 1 then 1 else 0 end |
| LATEST_PROSPECT_STAGE_IND_EXPRESSION |
TBD |
|
|
|
1 |
| MATCHING_CLAIM_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN MATCHING_CLAIM_IND = 1 THEN 'Yes' ELSE 'No' END |
| MATCHING_CLAIM_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN MATCHING_CLAIM_IND = 1 THEN 'Yes' ELSE 'No' END |
| MATCHING_GIFT_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN MATCHING_GIFT_IND = 1 THEN 'Yes' ELSE 'No' END |
| MATCHING_GIFT_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN MATCHING_GIFT_IND = 1 THEN 'Yes' ELSE 'No' END |
| MATCH_CLAIM_AMOUNT_EXPRESSION |
TBD |
|
|
|
nvl( AGRMDES_AMT ,0) |
| MATCH_CLAIM_EXISTS_IND_EXPRESSION |
NA |
|
|
|
|
| MATCH_CLAIM_EXISTS_IND_LD_EXPRESSION |
NA |
|
|
|
|
| MATCH_CLAIM_EXISTS_IND_SD_EXPRESSION |
NA |
|
|
|
|
| MATCH_GIFT_EXISTS_IND_EXPRESSION |
NA |
|
|
|
|
| MATCH_GIFT_EXISTS_IND_LD_EXPRESSION |
NA |
|
|
|
|
| MATCH_GIFT_EXISTS_IND_SD_EXPRESSION |
NA |
|
|
|
|
| NVL(CASE WHEN(CAMPAIGN_SOLICITOR_GOAL > 0 |
TBD |
REPORTING VIEW |
CAMPAIGN_FUNDRAISER |
PCT_PROGRESS_SOLICITOR_GOAL |
|
| PERSON_OR_ORGANIZATION_EXPRESSION |
TBD |
|
|
|
PERSON_OR_ORGANIZATION |
| PERSON_OR_ORGANIZATION_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN PERSON_OR_ORGANIZATION = 'P' THEN 'Person' WHEN PERSON_OR_ORGANIZATION = 'O' THEN 'Organization' END |
| PERSON_OR_ORGANIZATION_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN PERSON_OR_ORGANIZATION = 'P' THEN 'Person' WHEN PERSON_OR_ORGANIZATION = 'O' THEN 'Organization' END |
| PLDG_INCLUDE_IN_GIVING_IND_EXPRESSION |
NA |
|
|
|
|
| PLDG_INCLUDE_IN_GIVING_IND_LD_EXPRESSION |
NA |
|
|
|
|
| PLDG_INCLUDE_IN_GIVING_IND_SD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_ACTIVE_IND_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_ACTIVE_IND_LD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_ACTIVE_IND_SD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_ADJUSTED_IND_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_ADJUSTED_IND_LD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_ADJUSTED_IND_SD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_ANONYMOUS_IND_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_ANONYMOUS_IND_LD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_ANONYMOUS_IND_SD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_CAE_TYPE_LD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_CAE_TYPE_SD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_CONDITIONAL_IND_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_CONDITIONAL_IND_LD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_CONDITIONAL_IND_SD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN PLEDGE_IND = 1 THEN 'Yes' ELSE 'No' END |
| PLEDGE_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN PLEDGE_IND = 1 THEN 'Yes' ELSE 'No' END |
| PLEDGE_PAID_STATUS_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_PAID_STATUS_LD_EXPRESSION |
NA |
|
|
|
|
| PLEDGE_PAID_STATUS_SD_EXPRESSION |
NA |
|
|
|
|
| POSTAL_CODE_EXPRESSION |
TBD |
|
|
|
case when SPRADDR_ZIP is not null then SPRADDR_ZIP else 'No Postal Code' end |
| PROPOSAL_ID_EXPRESSION |
TBD |
|
|
|
SPRIDEN_ID ||AMBPROP_PROP_CODE ||AMBPROP_PROP_SEQ_NO |
| PROPOSAL_PURPOSE_DESCRIPTION_EXPRESSION |
TBD |
|
|
|
CASE WHEN AMRPROP_PROJ_TEXT IS NOT NULL THEN AMRPROP_PROJ_TEXT ELSE 'No Data' END |
| PROPOSAL_PURPOSE_RESULT_AMOUNT_EXPRESSIO N |
TBD |
|
|
|
SUM_VALUE |
| PROPOSAL_PURPOSE_RESULT_DATE_EXPRESSION |
TBD |
|
|
|
NVL(AMRPRRS_RESULT_DATE,TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_PURP_STAGE_START_DATE_EXPRESSIO N |
TBD |
|
|
|
NVL( AMRPROP_PRST_DATE ,TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROPOSAL_STAGE_START_DATE_EXPRESSION |
TBD |
|
|
|
NVL( AMBPROP_PRST_DATE ,TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_IND_EXPRESSION |
TBD |
|
|
|
case when (ATVPRST_ACTIVE_IND = 'Y') then 1 else 0 end |
| PROSPECT_IND_LD_EXPRESSION |
TBD |
|
|
|
case when (ATVPRST_ACTIVE_IND = 'Y') then 'Yes' else 'No' end |
| PROSPECT_IND_SD_EXPRESSION |
TBD |
|
|
|
case when (ATVPRST_ACTIVE_IND = 'Y') then 'Yes' else 'No' end |
| PROSPECT_INTEREST_ID_EXPRESSION |
TBD |
|
|
|
PROSPECT_KEY || FUNDRAISING_INITIATIVE_KEY |
| PROSPECT_NAME_EXPRESSION |
TBD |
|
|
|
SPRIDEN_LAST_NAME || ', ' || SPRIDEN_FIRST_NAME || ' ' || SUBSTR(SPRIDEN_MI, 1, 1) || '.' |
| PROSPECT_NAME_SORT_EXPRESSION |
TBD |
|
|
|
SPRIDEN_LAST_NAME || ', ' || SPRIDEN_FIRST_NAME || ' ' || SUBSTR(SPRIDEN_MI, 1, 1) || '.' |
| PROSPECT_RATING_LD_EXPRESSION |
TBD |
|
|
|
ATVRATE_DESC |
| PROSPECT_RATING_SD_EXPRESSION |
TBD |
|
|
|
ATVRATE_DESC |
| PROSPECT_STAGE_END_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |
| PROSPECT_STAGE_START_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |
| PROSPECT_STATUS_LD_EXPRESSION |
TBD |
|
|
|
ATVPRST_DESC |
| PROSPECT_STATUS_SD_EXPRESSION |
TBD |
|
|
|
ATVPRST_DESC |
| RATED_ENTITY_IND_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AMRINFO_PIDM and AMRINFO_PROSP_RATE > 0 or AMRINFO_PROSP_RATE is not NULL then 1 else 0 end |
| RATED_ENTITY_IND_LD_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AMRINFO_PIDM and AMRINFO_PROSP_RATE > 0 or AMRINFO_PROSP_RATE is not NULL THEN 'Yes' ELSE 'No' END |
| RATED_ENTITY_IND_SD_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AMRINFO_PIDM and AMRINFO_PROSP_RATE > 0 or AMRINFO_PROSP_RATE is not NULL THEN 'Yes' ELSE 'No' END |
| RATED_PROSPECT_IND_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AMRINFO_PIDM and AMRINFO_PROSP_RATE > 0 or AMRINFO_PROSP_RATE is not NULL then 1 else 0 end |
| RATED_PROSPECT_IND_LD_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AMRINFO_PIDM and AMRINFO_PROSP_RATE > 0 or AMRINFO_PROSP_RATE is not NULL THEN 'Yes' ELSE 'No' END |
| RATED_PROSPECT_IND_SD_EXPRESSION |
TBD |
|
|
|
case when APBCONS_AOBORGN_PIDM = AMRINFO_PIDM and AMRINFO_PROSP_RATE > 0 or AMRINFO_PROSP_RATE is not NULL THEN 'Yes' ELSE 'No' END |
| RECEIPT_REQUIRED_IND_EXPRESSION |
NA |
|
|
|
|
| RECEIPT_REQUIRED_IND_LD_EXPRESSION |
NA |
|
|
|
|
| RECEIPT_REQUIRED_IND_SD_EXPRESSION |
NA |
|
|
|
|
| RELATION_EMPLOYER_IND_EXPRESSION |
TBD |
|
|
|
CASE ATVXREF_EMPLOYER_IND WHEN 'Y' THEN 1 ELSE 0 END |
| RELATION_EMPLOYER_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVXREF_EMPLOYER_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| RELATION_EMPLOYER_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVXREF_EMPLOYER_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| RELATION_HOUSEHOLD_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVXREF_HOUSEHOLD_IND = 'Y' THEN 1 ELSE 0 END |
| RELATION_HOUSEHOLD_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVXREF_HOUSEHOLD_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| RELATION_HOUSEHOLD_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVXREF_HOUSEHOLD_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| RELATION_MATCH_GIFT_IND_EXPRESSION |
TBD |
|
|
|
CASE ATVXREF_MATCH_GIFT_IND WHEN 'Y' THEN 1 ELSE 0 END |
| RELATION_MATCH_GIFT_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVXREF_MATCH_GIFT_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| RELATION_MATCH_GIFT_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVXREF_MATCH_GIFT_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| RELATION_SPOUSE_IND_EXPRESSION |
TBD |
|
|
|
CASE ATVXREF_SPOUSE_IND WHEN 'Y' THEN 1 ELSE 0 END |
| RELATION_SPOUSE_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVXREF_SPOUSE_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| RELATION_SPOUSE_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVXREF_SPOUSE_IND = 'Y' THEN 'Yes' ELSE 'No' END |
| SCHOOL_LD_EXPRESSION |
TBD |
|
|
|
STVCOLL_DESC |
| SCHOOL_SD_EXPRESSION |
TBD |
|
|
|
STVCOLL_DESC |
| SOLICITOR_ASSIGNED_IND_EXPRESSION |
TBD |
|
|
|
NVL(AMRSTAF_SOLICIT_IND, 0) |
| SOLICITOR_ASSIGNED_IND_LD_EXPRESSION |
TBD |
|
|
|
case when AMRSTAF_SOLICIT_IND = 1 THEN 'Yes' ELSE 'No' end |
| SOLICITOR_ASSIGNED_IND_SD_EXPRESSION |
TBD |
|
|
|
case when AMRSTAF_SOLICIT_IND = 1 THEN 'Yes' ELSE 'No' end |
| STAGE_ID_EXPRESSION |
TBD |
|
|
|
1 |
| STRATEGY_PLAN_EXISTS_IND_EXPRESSION |
TBD |
|
|
|
case when ( AMRINFO_PIDM = AMRPLAN_PIDM ) then 1 else 0 end |
| STRATEGY_PLAN_EXISTS_IND_LD_EXPRESSION |
TBD |
|
|
|
case when ( AMRINFO_PIDM = AMRPLAN_PIDM ) then 'Yes' else 'No' end |
| STRATEGY_PLAN_EXISTS_IND_SD_EXPRESSION |
TBD |
|
|
|
case when ( AMRINFO_PIDM = AMRPLAN_PIDM ) then 'Yes' else 'No' end |
| STREET_LINE1_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPRADDR_STREET_LINE1 IS NOT NULL THEN SPRADDR_STREET_LINE1 ELSE 'Data Not Available' END |
| STREET_LINE2_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPRADDR_STREET_LINE2 IS NOT NULL THEN SPRADDR_STREET_LINE2 ELSE ' ' END |
| STREET_LINE3_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPRADDR_STREET_LINE3 IS NOT NULL THEN SPRADDR_STREET_LINE3 ELSE ' ' END |
| STREET_LINE4_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPRADDR_STREET_LINE4 IS NOT NULL THEN SPRADDR_STREET_LINE4 ELSE ' ' END |
| TRANSACTION_TYPE_LD_EXPRESSION |
TBD |
|
|
|
CASE (TRANSACTION_TYPE) WHEN 'PL' THEN 'Pledge' WHEN 'GF' THEN 'Outright Gift' WHEN 'PP' THEN 'Pledge Payment' WHEN 'MG' THEN 'Matching Gift' WHEN 'MC' THEN 'Matching Claim' ELSE 'Unknown' END |
| TRANSACTION_TYPE_SD_EXPRESSION |
TBD |
|
|
|
CASE (TRANSACTION_TYPE) WHEN 'PL' THEN 'Pledge' WHEN 'GF' THEN 'Outright Gift' WHEN 'PP' THEN 'Pledge Payment' WHEN 'MG' THEN 'Matching Gift' WHEN 'MC' THEN 'Matching Claim' ELSE 'Unknown' END |
| XSEQUENCE_EXPRESSION |
TBD |
|
|
|
SPRADDR_SEQNO |