CONSTITUENCYSYSTEMNAME
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| DESCRIPTION | nvarchar(100) | ||
| SYSTEMDESCRIPTION | nvarchar(100) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes |
Definition
Copy
create view dbo.CONSTITUENCYSYSTEMNAME with schemabinding as
select
CONSTITUENCYDEFINITION.ID,
CONSTITUENCYDEFINITION.DESCRIPTION,
CONSTITUENCYDEFINITION.SYSTEMDESCRIPTION,
CONSTITUENCYDEFINITION.ADDEDBYID,
CONSTITUENCYDEFINITION.CHANGEDBYID,
CONSTITUENCYDEFINITION.DATEADDED,
CONSTITUENCYDEFINITION.DATECHANGED,
CONSTITUENCYDEFINITION.TS,
CONSTITUENCYDEFINITION.TSLONG
from
dbo.CONSTITUENCYDEFINITION
where
CONSTITUENCYDEFINITION.ISSYSTEM = 1