Blackbaud Enterprise Data Warehouse Functions

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

Function	Description
UFN_APPEAL_GRANTEDBYSITE_FOR_APPUSER_QUERYVIEW
UFN_APPUSER_ISSYSADMIN
UFN_CALCFISCALPERIOD
UFN_CALCQUARTER
UFN_CALCQUARTERDATE
UFN_CONSTITID_MAPFROM_REVENUESPLITID
UFN_CONSTITID_MAPFROM_REVENUETRANSACTIONID
UFN_CONSTITID_MAPFROM_TRIBUTEID
UFN_CONSTITUENT_GRANTEDBYCONSTITSECURITY_FOR_APPUSER_QUERYVIEW
UFN_CONSTITUENTAPPEAL_GRANTEDBYCONSTITSECURITY_FOR_APPUSER_QUERYVIEW
UFN_CONSTITUENTAPPEAL_GRANTEDBYSITE_FOR_APPUSER_QUERYVIEW
UFN_CONSTITUENTSBYSITE_FOR_APPUSER_QUERYVIEW
UFN_FISCALQUARTER
UFN_FISCALYEAR
UFN_GENERATE_DATES
UFN_GENERATECREATEINDEXSCRIPTS_FORTABLE
UFN_GETCOLUMNSTOREINDEXNAME
UFN_GETINDEXEXTENDEDPROPERTIES_FORTABLE
UFN_INDEXEXISTS
UFN_MEMBERSHIPPROGRAMS_FROMITEMLISTXML
UFN_MONTHEND
UFN_PROSPECTID_MAPFROM_PROSPECTPLANID
UFN_QUERY_MARKETINGEFFORTDETAILS
UFN_RETURNFISCALYEAR
UFN_REVENUE_GRANTEDBYCONSTITUENTSECURITY_FOR_APPUSER_QUERYVIEW
UFN_REVENUE_GRANTEDBYSITE_FOR_APPUSER_QUERYVIEW
UFN_SECURITY_APPUSER_GRANTED_CONSTITIDS_FORDATALIST
UFN_SECURITY_APPUSER_GRANTED_CONSTITIDS_FORFEATURE
UFN_SECURITY_APPUSER_GRANTED_CONSTITIDS_FORFORM
UFN_SECURITY_APPUSER_GRANTED_CONSTITIDS_FORQUERYVIEW
UFN_SECURITY_APPUSER_GRANTED_CONSTITIDS_FORSMARTQUERY
UFN_SECURITY_APPUSER_GRANTED_CONSTITIDS_FORSMARTQUERY_BYSITE
UFN_SECURITY_APPUSER_GRANTED_DATALIST_FORCONSTIT
UFN_SECURITY_APPUSER_GRANTED_DATALIST_IN_NONRACROLE
UFN_SECURITY_APPUSER_GRANTED_FEATURE_IN_NONRACROLE
UFN_SECURITY_APPUSER_GRANTED_QUERYVIEW_FORSITE_TVF
UFN_SECURITY_APPUSER_GRANTED_QUERYVIEW_IN_NONRACROLE
UFN_SECURITY_APPUSER_GRANTED_REPORT_IN_NONRACROLE
UFN_SECURITY_APPUSER_GRANTED_SMARTQUERY_FORSITE_TVF
UFN_SECURITY_APPUSER_GRANTED_SMARTQUERY_IN_NONRACROLE
UFN_SECURITY_APPUSER_GRANTED_SMARTQUERY_IN_NONSITEROLE
UFN_SITE_BUILDDATALISTSITEFILTER
UFN_SITEID_MAPFROM_APPEALID
UFN_SITEID_MAPFROM_CAMPAIGNID
UFN_SITEID_MAPFROM_CONSTITUENTID
UFN_SITEID_MAPFROM_DESIGNATIONID
UFN_SITEID_MAPFROM_DESIGNATIONLEVELID
UFN_SITEID_MAPFROM_EVENTID
UFN_SITEID_MAPFROM_MEMBERSHIPID
UFN_SITEID_MAPFROM_MEMBERSHIPPROGRAMID
UFN_SITEID_MAPFROM_PROSPECTPLANID
UFN_SITEID_MAPFROM_REGISTRANTID
UFN_SITEID_MAPFROM_REVENUEID
UFN_SITEID_MAPFROM_REVENUESPLITID
UFN_SITEID_MAPFROM_SEGMENTATIONID
UFN_SITEID_MAPFROM_SEGMENTATIONSEGMENTID
UFN_SITEID_MAPFROM_SEGMENTATIONTESTSEGMENTID
UFN_SITEID_MAPFROM_SEGMENTID
UFN_SITEID_MAPFROM_SOURCECODEID
UFN_SITEID_MAPFROM_SOURCECODEITEMID
UFN_SITEID_MAPFROMTRIBUTEID
UFN_SITESFORUSER
UFN_SITESFORUSERONFEATURE