| INSTALLATIONNAME |
nvarchar(100) |
|
|
Can be used to differentiate between separate installations. |
| SERIALNUMBER |
nvarchar(50) |
|
|
The installation serial number |
| REPORTWSURL |
nvarchar(1024) |
|
Default = '' |
The URL for the Report Services Web Service. |
| REPORTRENDERURL |
nvarchar(1024) |
|
Default = '' |
The URL for the Report Services rendering engine. |
| REPORTDATASOURCE |
nvarchar(1024) |
|
Default = '' |
The fully qualified path to the Report Services data source for this database. |
| FISCALYEARFINALMONTH |
smallint |
|
Default = ((12)) |
The numeric value of the final month of the fiscal year (1 - 12). |
| DONORCONSTITUENCYDEFTYPECODE |
smallint |
|
Default = ((0)) |
Donor constituency exists for a constituent having given 0 - in the past x years, or 1 - since a given date. |
| DONORCONSTITUENCYDEFLASTYEARS |
int |
|
Default = 3 |
The number of years in which a constituent must have given to have the donor constituency. |
| DONORCONSTITUENCYDEFSTARTDATE |
datetime |
yes |
|
The date since which a constituent must have given to have the donor constituency. |
| BUSINESSPROCESSEXPORTFORMATDATEFORMAT |
nvarchar(50) |
|
Default = 'M/d/yyyy' |
Default date format when exporting output from a business process. |
| BUSINESSPROCESSEXPORTFORMATFUZZYDATEFORMAT |
nvarchar(50) |
|
Default = 'M/d/yyyy' |
Default fuzzy date format when exporting output from a business process. |
| BUSINESSPROCESSEXPORTFORMATMONTHDAYFORMAT |
nvarchar(50) |
|
Default = 'M/d' |
Default month/day format when exporting output from a business process. |
| BUSINESSPROCESSEXPORTFORMATHOURMINUTEFORMAT |
nvarchar(50) |
|
Default = 'hh:mm tt' |
Default hour/minute format when exporting output from a business process. |
| BUSINESSPROCESSEXPORTFORMATCURRENCYSYMBOL |
nvarchar(4) |
|
Default = '$' |
Default character or characters used to represent the currency symbol when exporting output from a business process. |
| BUSINESSPROCESSEXPORTFORMATCURRENCYGROUPSEPARATOR |
nvarchar(4) |
|
Default = ',' |
Default character or characters used to represent the currency group separator when exporting output from a business process. |
| BUSINESSPROCESSEXPORTFORMATCURRENCYDECIMALSEPARATOR |
nvarchar(4) |
|
Default = '.' |
Default character or characters used to represent the currency decimal separator when exporting output from a business process. |
| BUSINESSPROCESSEXPORTFORMATCURRENCYDECIMALDIGITS |
tinyint |
|
Default = '2' |
Default number of digits after the decimal place for currency when exporting output from a business process. |
| REPORTDBSOURCEID |
int |
|
Default = 1 |
Identifies this database when using a report database that combines multiple databases. |
| FORMATPHONES |
bit |
|
Default = 1 |
|
| PRODUCTCODE |
tinyint |
|
Default = 0 |
0 = Unknown, 1 = Blackbaud Enterprise CRM, 2 = Blackbaud Direct Marketing, 3 = Target Analytics ResearchPoint, 4 = Blackbaud Arts and Cultural |
| REPORTMODELUSERACS |
bit |
|
Default = 0 |
Determines whether report models generated by the application use record access security. |
| CLARIFYSITEID |
nvarchar(50) |
|
Default = '' |
Clarify Site ID |
| INSTALLEDPRODUCTS |
nvarchar(30) |
|
Default = '' |
|
| BLANKSINQUERYDEFAULT |
bit |
|
Default = 1 |
|
| UPDATEPRODUCTINFORMATION |
bit |
|
Default = 0 |
|
| CUSTOMALERTMESSAGESIZE |
int |
yes |
|
|
| CUSTOMALERTMESSAGESIZETOTAL |
int |
yes |
|
|
| PRODUCT |
nvarchar(30) (Computed) |
yes |
|
|
| ISHOSTED |
bit |
|
Default = 0 |
|
| SELFSERVICEPASSWORDRESETENABLED |
bit |
|
Default = 0 |
|
| SELFSERVICEPASSWORDRESETURL |
UDT_WEBADDRESS |
|
Default = '' |
|
| CSVLINEBREAKCODE |
tinyint |
|
Default = 0 |
|
| CSVLINEBREAK |
nvarchar(9) (Computed) |
yes |
|
|
| ODATAROOTURL |
nvarchar(1024) |
yes |
|
|
| AUTHSERVICETENANTID |
uniqueidentifier |
yes |
Default = (NULL) |
|
| ODATAWEBAPIROOTURL |
nvarchar(1024) |
|
Default = '' |
The Root URL for OData Web API. |
| SQLJOBSCONVERTED |
bit |
|
Default = 0 |
|
| ENVIRONMENTID |
nvarchar(100) |
yes |
|
|