Go To View:  -- Select a View -- AA_ADVANCEMENT_RATING AA_ANNUAL_GIVING AA_CAMPAIGN AA_CAMPAIGN_COMMENT AA_CAMPAIGN_DESIGNATION AA_CAMPAIGN_EXPENSE AA_CAMPAIGN_FUNDRAISER AA_CAMPAIGN_GIVING_HISTORY AA_CAMPAIGN_MAIL AA_CAMPAIGN_SOLICITATION AA_CONSTITUENT AA_CONSTITUENT_CONTACT AA_CONSTITUENT_CONTACT_KSU AA_CONSTITUENT_PLAN AA_CONSTITUENT_STAFF_ASSIGN AA_CONST_STF_ASSN_ADL_INFO_KSU AA_CON_CONF_COMMENT_SUBJ AA_CON_ENTITY_CONF_COMMENT AA_DEGREE AA_DESIGNATION AA_DESIGNATION_ADJUSTMENT AA_DESIGNATION_ATTRIBUTE AA_DESIGNATION_CLASS_YEAR AA_DESIGNATION_COMMENT AA_DESIGNATION_COMMENT_SUBJ AA_DESIGNATION_FINAID_FUND AA_DESIGNATION_GIVING_HISTORY AA_DESIGNATION_ID AA_DONOR_CATEGORY AA_EVENT_COMMENTS_KSU AA_EXCLUSION AA_FUNDING_INTEREST AA_GEO_REGION_KSU AA_GIFT AA_GIFT_ASSOCIATED_ENTITY AA_GIFT_AUXILIARY AA_GIFT_MATCHING AA_GIFT_MEMO AA_GIFT_MULTIPLE AA_GIFT_SOCIETY AA_GIFT_SOC_ADDL_INFO_KSU AA_GIVING AA_INTEREST AA_MAIL AA_MEMBERSHIP AA_MEMBERSHIP_DUES AA_MEMBERSHIP_INTEREST AA_ORGANIZATIONAL_CONSTITUENT AA_ORGANIZATION_CONTACT AA_ORGANIZATION_FUNDING_AREA AA_PLEDGE AA_PLEDGE_ASSOCIATED_ENTITY AA_PLEDGE_AUXILIARY AA_PLEDGE_CONDITIONAL AA_PLEDGE_CONDITION_KSU AA_PLEDGE_INSTALLMENT AA_PLEDGE_MATCHING AA_PREVIOUS_EMPLOYMENT AA_PROJECT_INTEREST AA_PROSPECT_CONF_COMMENT AA_PROSPECT_CONF_COMMENT_SUBJ AA_PROSPECT_CONTACT_EXPENSE AA_PROSPECT_INFO AA_PROSPECT_MOVES_MANAGEMENT AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_RESULT AA_PROSPECT_STAFF_ASSIGNMENT AA_RELATIONSHIP AA_SALUTATION AA_SOLICITOR AA_SOLICITOR_ASSIGNMENT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_CONTACT_KSU AA_SOLICITOR_ORGANIZATION AA_SOLICITOR_ORG_COMMENT AA_SOLICITOR_ORG_FUNDRAISER AA_SOL_ORG_FUNDRAISER_GOAL AA_SOL_ORG_GOAL AA_SPECIAL_ACTIVITY AA_SPECIAL_ACTIVITY_YEAR AA_SPECIAL_PURPOSE_GROUP AA_VALIDATION AA_YEAR_TYPE_DEFINITION AB_COMMUNICATION AB_EM_CAMPAIGN AB_EM_ORGANIZATION AB_INTERACTION AB_RA_VALIDATION AE_ACCOUNTING AE_APPROVAL_HISTORY AE_AUTHORIZATION AE_CIRC_HEADER_STEP AE_CIRC_RECIP_NOTIF AE_DELEGATE_ASSIGNMENT AE_EXPENSE_ITEM AE_EXPENSE_ITEM_TAX AE_ITINERARY AE_PORTFOLIO AE_PROFILE AE_REIMBURSEMENT AE_STATUS_HISTORY AF_ACCOUNT_ATTRIBUTES_ODS AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_INDEX AF_ACCOUNT_TYPE_ATTRIBUTES_ODS AF_ACTIVITY_ATTRIBUTES_ODS AF_ATTRIBUTE_SETS_ODS AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_CHART_ATTRIBUTES_ODS AF_CHECKS AF_CLAUSE AF_ENCUMBRANCE AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_LEDGER AF_ENDOWMENT AF_ENDOWMENT_ATTRIBUTES AF_ENDOWMENT_DIST AF_ENDOWMENT_MARKET_VALUES AF_ENDOWMENT_UNITS AF_FISCAL_PERIOD AF_FIXED_ASSET_ADJUSTMENT AF_FIXED_ASSET_ATTRIBUTES AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_FIXED_ASSET_ITEM AF_FUND_ATTRIBUTES_ODS AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_TYPE_ATTRIBUTES_ODS AF_GENERAL_LEDGER AF_GRANT AF_GRANT_ADDL_INFO_KSU AF_GRANT_ATTRIBUTES_ODS AF_GRANT_BILLING_DETAIL AF_GRANT_DEFERRED_COST AF_GRANT_EVENT AF_GRANT_EVENT_STATUS AF_GRANT_FUND AF_GRANT_LEDGER AF_GRANT_PERSONNEL AF_INVOICE AF_INVOICE_ACCOUNTING AF_INVOICE_CHECK AF_INVOICE_ITEM AF_INVOICE_TAX_RATE AF_LOCATION_ATTRIBUTES_ODS AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL AF_OPERATING_LEDGER AF_ORGANIZATION_ATTRIBUTES_ODS AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL AF_PROGRAM_ATTRIBUTES_ODS AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_PROPOSAL AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ITEM AF_PURCHASE_ORDER_TAX_RATE AF_RECEIVED_ITEM AF_RETURNED_ITEM AF_TEXT AF_TRANSACTION_HISTORY AF_VALIDATION AF_VENDOR AF_VENDOR_ADDL_INFO_KSU AF_VENDOR_MULT_INVOICE_KSU AF_VENDOR_TAXABLE_REPORTING AG_ALTERNATIVE_ID AG_COMMUNICATION AG_DIRECT_DEPOSIT_KSU AG_EMAIL_KSU AG_EVENT AG_EVENT_INVITEE AG_GEOGRAPHIC_REGION AG_GEOGRAPHIC_REGION_INST AG_INTERNET_ADDRESS AG_PERSON_EMAIL_KSU AG_VALIDATION AN_EMPLOYEE_POSITION AN_FISCAL_YEAR AN_FMLA_LEAVE_COMMENT AN_JOB_FTE_TRACKING AN_LABOR_COST_DISTRIBUTION AN_PAYROLL_DISTRIBUTION AN_PERSONNEL_ACTION AN_PERSONNEL_ACTION_COMMENT AN_PERSONNEL_ACTION_EARNING AN_PERSONNEL_ACTION_GENERAL AN_PERSONNEL_ACTION_LABOR_DIST AN_POSITION_BUDGET AN_POSITION_DEFINITION AN_POSITION_LABOR_DISTRIBUTION AN_SALARY_RATE AN_SUPERVISOR AN_VALIDATION AP_BARGAINING_UNIT AP_BENEFICIARY_DEPENDENT AP_BENEFICIARY_DEPENDENT_KSU AP_BENEFIT_DEDUCTION AP_CERTIFICATION AP_EARNING_TOTALS_CY AP_EARNING_TOTALS_FY AP_EMPLOYEE AP_EMPLOYEE_ADDL_INFO_KSU AP_EMPLOYEE_EARNING_CY AP_EMPLOYEE_EARNING_FY AP_FACULTY_APPOINTMENT_HISTORY AP_FACULTY_RANK_HISTORY AP_FACULTY_SABBATICAL_HISTORY AP_FAMILY_MEDICAL_LEAVE_HIST AP_FEE_WAIVER_KSU AP_HR_APPLICATION AP_HR_APPLICATION_STATUS AP_HR_REQUISITION AP_INTERVIEW AP_LEAVE_ACCRUAL AP_LEAVE_BALANCE AP_MONTHLY_DEDUCTION AP_PAST_EMPLOYMENT AP_PAYROLL_ATTENDANCE AP_PAYROLL_DEDUCTION AP_PAYROLL_DOCUMENT AP_PAYROLL_EARNING AP_PAYROLL_EMPLOYEE_POSITION AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_TIMESHEET AP_POSITION_CLASS_KSU AP_PYRL_EMP_POSN_KSU AP_REFERENCE AP_REVIEW AP_SKILL AP_TAX AP_VALIDATION AP_WEB_LEAVE_REPORTING_KSU AP_YEARLY_DEDUCTION AR_APPLICANT_NEED AR_APPLICANT_RESOURCE AR_AWARD_BY_AID_YEAR AR_AWARD_BY_FUND AR_AWARD_BY_PERSON AR_AWARD_DISBURSEMENT AR_FINAID_APPLICANT_STATUS AR_FINAID_APPLICATION1 AR_FINAID_APPLICATION2 AR_FINAID_APPLICATION3 AR_FINAID_APPLICATION4 AR_FINAID_BUDGET_COMPONENT AR_FINAID_COMMENTS AR_FINAID_COMMENTS_KSU AR_FINAID_ENROLLMENT AR_FINAID_FUND AR_FINAID_HOLD AR_FINAID_MESSAGE AR_FINAID_RESOURCES_KSU AR_FINAID_TRACKING_REQUIREMENT AR_FUND_MESSAGE_RULE AR_LOAN_AGGREGATES AR_LOAN_APPLICATION AR_LOAN_DISBURSEMENT AR_NEED_ANALYSIS_ADDL_INFO_KSU AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_OVERRIDE AR_NEED_ANALYSIS_PROFILE_SPEC AR_SATISFACTORY_ACAD_PROGRESS AR_STUDENT_PERIOD_DEFINITION AR_USER_DEFINED_FIELDS AR_VALIDATION AR_YEAR_TYPE_DEFINITION AS_ACADEMIC_HISTORY_EVENT AS_ACADEMIC_OUTCOME AS_ACADEMIC_STANDING AS_ACTIVE_TERMS AS_ADDRESS AS_ADMINISTRATOR AS_ADMISSIONS_ADDL_INFO_KSU AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_ATTRIBUTE AS_ADMISSIONS_COHORT AS_ADMISSIONS_DECISION AS_ADMISSIONS_FIRSTAPP_KSU AS_ADMISSIONS_RATING AS_ADMISSIONS_REQUIREMENT AS_ADMISSIONS_SOURCE AS_ADVISOR AS_APP_QUESTIONS_KSU AS_COMP_TERM_WITHDRAWAL_KSU AS_CONTACT AS_COURSE_ATTRIBUTE AS_COURSE_CATALOG AS_COURSE_COREQ AS_COURSE_LEVEL AS_COURSE_OFFERING AS_COURSE_OFFERING_FEES AS_COURSE_PREREQ AS_COURSE_SCHEDULE AS_COURSE_SUPPLEMENTAL AS_COURSE_TEXT_KSU AS_CURRICULUM AS_CURRICULUM_FOS AS_DESTINATION_KENT_KSU AS_DISABILITY_INFORMATION AS_EMERGENCY_CONTACT_KSU AS_ENROLLMENT AS_ENROLLMENT_HISTORY AS_ENROLLMENT_WITHDRAWAL AS_FACULTY AS_FACULTY_ATTRIBUTE AS_FACULTY_CONTRACT AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK_DETAIL AS_FIELD_OF_STUDY AS_GENERAL_STUDENT AS_GENSTU_END_TERM AS_GPA_LEVEL AS_GPA_TERM AS_HOLD AS_INSTITUTION AS_INSTITUTION_CHARACTERISTIC AS_INSTITUTION_DEMOGRAPHIC AS_INSTRUCTIONAL_ASSIGNMENT AS_INTEREST AS_LEARNER_CURRICULUM_FOS AS_MEAL_ASSIGNMENT AS_MEDICAL_INFORMATION AS_MEETING_TIME AS_NONINSTRUCTIONAL_ASSIGNMENT AS_OFFERING_COREQ AS_OFFERING_GRADE_MODE AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_ORGANIZATION_ENTITY AS_OUTCOME_HONOR_DEPT AS_OUTCOME_HONOR_INST AS_PERSON AS_PHONE_ASSIGNMENT AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_HSCH AS_PREVIOUS_EDUCATION_PCOL AS_PRE_STUDENT AS_RACE AS_RECRUITMENT_ATTRIBUTE AS_RECRUITMENT_COHORT AS_RECRUITMENT_INFORMATION AS_RECRUITMENT_LEARNED AS_RECRUITMENT_SOURCE AS_REGISTRATION_HOLD_OVRD_KSU AS_ROOM_ASSIGNMENT AS_SCHEDULE_ATTRIBUTE AS_SECONDARY_SCHOOL_SUBJECT AS_SECTION_TEXT_KSU AS_SPORT AS_STUDENT_ACTIVITY AS_STUDENT_ADDL_INFO_KSU AS_STUDENT_ATTRIBUTE AS_STUDENT_CLASSIFICATION AS_STUDENT_COHORT AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_ATTR_TRANS AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_REG_AUDIT AS_STUDENT_COURSE_TRANSFER AS_STUDENT_CRSE_GRDCHGUSR_KSU AS_STUDENT_TRANSFERRED_COURSE AS_STUDENT_WORK_EXPERIENCE AS_TELEPHONE AS_TEST AS_TRANSCRIPT_LEVEL_COMMENT AS_TRANSCRIPT_TERM_COMMENT AS_VALIDATION AS_VETERAN_CERTIFICATION AS_VISA AS_YEAR_TYPE_DEFINITION AT_ACCOUNT AT_ACCOUNT_ADDL_INFO_KSU AT_ACCOUNT_DETAIL AT_APPLICATION_OF_PAYMENT AT_AR_DEPOSIT AT_BURSAR_QUEUE_KSU AT_CONTRACT AT_CONTRACT_PAYMENT_DETAIL AT_DETAIL_CODE_KSU AT_EXEMPTION AT_GRANT_ACCOUNT_DETAIL AT_GRANT_APPLICATION_PAYMENT AT_INSTALLMENT_PLAN AT_LEDGER_ACCOUNTING AT_MEMO AT_MISCELLANEOUS_TRANSACTION AT_STUDENT_TAX_NOTIFICATION AT_TBRCCHG_KSU AT_VALIDATION

RETURN TO COMPOSITE VIEW REPORTS LIST

Reporting View Source: EXPRESSION Common

SGHE Banner Operational Data Store

Composite View Source: EXPRESSION - NULL

Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
(CAMPAIGN_SOLICITOR_GOAL / CAMPAIGN_GOAL * 100)	TBD
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
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
DECODE (APRIGRP_DISP_WEB_IND, 'Y', 'Y', 'N')	TBD
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
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

Ver: