V_INSTALLED_KPICATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CONTEXTRECORDTYPEID | uniqueidentifier | yes | |
| NAME | nvarchar(255) | ||
| DESCRIPTION | nvarchar(max) | ||
| SPNAME | nvarchar(100) | ||
| GOALSPNAME | nvarchar(100) | ||
| ASSEMBLYNAME | nvarchar(100) | ||
| CLASSNAME | nvarchar(150) | ||
| IMPLEMENTATIONTYPECODE | tinyint | ||
| GOALRETRIEVALTYPECODE | tinyint | ||
| GOALTYPECODE | tinyint | ||
| UIFOLDER | nvarchar(255) | ||
| SECURITYUIFOLDER | nvarchar(255) | ||
| SPECXML | xml | ||
| CONTEXTRECORDIDPARAMETER | nvarchar(255) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| DECIMALPLACES | tinyint | ||
| IMPLEMENTATIONTYPE | nvarchar(3) | yes | |
| GOALRETRIEVALTYPE | nvarchar(9) | yes | |
| GOALTYPE | nvarchar(7) | yes | |
| HASSITEFILTER | bit |
Definition
Copy
CREATE view dbo.V_INSTALLED_KPICATALOG as
select
KPICATALOG.ID,
KPICATALOG.CONTEXTRECORDTYPEID,
KPICATALOG.NAME,
KPICATALOG.DESCRIPTION,
KPICATALOG.SPNAME,
KPICATALOG.GOALSPNAME,
KPICATALOG.ASSEMBLYNAME,
KPICATALOG.CLASSNAME,
KPICATALOG.IMPLEMENTATIONTYPECODE,
KPICATALOG.GOALRETRIEVALTYPECODE,
KPICATALOG.GOALTYPECODE,
KPICATALOG.UIFOLDER,
KPICATALOG.SECURITYUIFOLDER,
KPICATALOG.SPECXML,
KPICATALOG.CONTEXTRECORDIDPARAMETER,
KPICATALOG.ADDEDBYID,
KPICATALOG.CHANGEDBYID,
KPICATALOG.DATEADDED,
KPICATALOG.DATECHANGED,
KPICATALOG.TS,
KPICATALOG.TSLONG,
KPICATALOG.DECIMALPLACES,
KPICATALOG.IMPLEMENTATIONTYPE,
KPICATALOG.GOALRETRIEVALTYPE,
KPICATALOG.GOALTYPE,
KPICATALOG.HASSITEFILTER
from
dbo.KPICATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = KPICATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 25
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1