Blackbaud Enterprise Data Warehouse Procedures

This page provides a comprehensive listing of the procedures available in Blackbaud Data Warehouse version 4.0SP40.

Procedure	Description
CREATE_OR_DROP_ALL_FK
CREATE_OR_DROP_CLUSTEREDINDEX
CREATE_OR_DROP_DIM_CONSTITUENT_STAGE_INDICES
CREATE_OR_DROP_DIM_CONSTITUENTADDRESS_INDICES
CREATE_OR_DROP_DIM_CONSTITUENTADDRESSDETAIL_INDICES
CREATE_OR_DROP_DIM_CONSTITUENTDEMOGRAPHIC_INDICES
CREATE_OR_DROP_DIM_CONSTITUENTINFORMATION_INDICES
CREATE_OR_DROP_DIM_IDSETREGISTER_INDICES
CREATE_OR_DROP_DIM_MAILPREFERENCE_INDICES
CREATE_OR_DROP_DIM_REVENUECODE_INDICES
CREATE_OR_DROP_FACT_FINANCIALTRANSACTIONLINEITEM_STAGE_INDICES
CREATE_OR_DROP_FACT_INTERACTION_INDICES
CREATE_OR_DROP_FACT_PLANNEDGIFTDESIGNATION_INDICES
CREATE_OR_DROP_FACT_PLANNEDGIFTDESIGNATION_STAGE_INDICES
CREATE_OR_DROP_INDICES
RESETETL
USP_CREATE_V_DIM_MARKETINGSOURCECODE
USP_CREATECOLUMNSTOREINDEX
USP_CREATENONCLUSTEREDCOLUMNSTOREINDEX
USP_DATAFORMTEMPLATE_VIEW_MARKETINGEFFORTPERFORMANCEREVIEWSUMMARY
USP_DATALIST_MARKETINGEFFORTPERFORMANCEREVIEWPACES
USP_DATALIST_MEMBERSHIPACTION
USP_DATALIST_MEMBERSHIPREVENUE
USP_DATALIST_OLAPDATASOURCEVALIDATIONEXCEPTIONS
USP_DROP_PRIMARYKEY
USP_DROPALLCOLUMNSTOREINDEXES
USP_DROPALLINDEXES_FORTABLE
USP_DROPCOLUMNSTOREINDEX
USP_DROPOBJECTIFEXISTS
USP_ETL_BEGINLOAD
USP_GETPACKAGEFROMQUEUE
USP_INITIALIZEQUEUE
USP_POPULATEDATEDIM
USP_POPULATETIMEDIM
USP_RAISE_ERROR
USP_REPORT_MEMBERSHIPACTIVITY
USP_REPORT_MEMBERSHIPACTIVITYDETAIL
USP_REPORT_MEMBERSHIPACTUALS
USP_REPORT_REVENUEACTUALDETAIL
USP_RESTOREALLINDEXEEXTENDEDPROPERTIES_FORTABLE
USP_RESTOREALLINDEXES_FORTABLE
USP_RPT_GIVINGLISTDETAIL
USP_RPT_RECOGNITIONGIVINGLISTDETAIL
USP_SCHEMA_TABLE_SETCOLUMNCOMMENT
USP_SCHEMA_TABLE_SETTABLECOMMENT
USP_SCHEMA_VIEW_SETCOLUMNCOMMENT
USP_SCHEMA_VIEW_SETVIEWCOMMENT
USP_UPDATEPACKAGEQUEUE
USP_VALIDATION_DEFAULTDIMENSIONROWS
USP_VALIDATION_GETDATATYPES
USP_VALIDATION_GRANULARITY
USP_VALIDATION_MISSINGCOLUMNSTOREINDEXES
USP_VALIDATION_MISSINGCOMMENTS
USP_VALIDATION_MISSINGINDEXES
USP_VALIDATION_MISSINGMETADATACOLUMNS
USP_VALIDATION_NULLSINCOLUMNS
USP_VALIDATION_REFERENTIALINTEGRITY
USP_VALIDATIONEXCEPTIONLOG