Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 VSECONSTITUENCYCODE tinyint   Default = 0 0=Alumni, 4=Parents, 5=Current Parents, 6=Past Parents, 7=Grandparents, 8=Faculty and Staff, 9=Students, 10=Direct Governing Board, 11=Other Individuals, 12=Foundations-Personal and Family, 13=Foundations-Other, 14=Corporations, 15=Religious Organizations, 16=Fundraising Consortia, 17=Other Organizations
 SEQUENCE int   Default = 0 Used for hierarchy
 TYPECODE tinyint   Default = 0 0=Individual, 1=Organization
 USAGETYPECODE tinyint   Default = 0 0=College, 1=Secondary, 2=Both
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 VSECONSTITUENCY nvarchar(31) (Computed) CASE [VSECONSTITUENCYCODE] WHEN 0 THEN N'Alumni' WHEN 4 THEN N'Parents' WHEN 5 THEN N'Current Parents' WHEN 6 THEN N'Past Parents' WHEN 7 THEN N'Grandparents' WHEN 8 THEN N'Faculty and Staff' WHEN 9 THEN N'Students' WHEN 10 THEN N'Direct Governing Board' WHEN 11 THEN N'Other Individuals' WHEN 12 THEN N'Foundations-Personal and Family' WHEN 13 THEN N'Foundations-Other' WHEN 14 THEN N'Corporations' WHEN 15 THEN N'Religious Organizations' WHEN 16 THEN N'Fundraising Consortia' WHEN 17 THEN N'Other Organizations' END Provides a translation for the 'VSECONSTITUENCYCODE' field.
 TYPE nvarchar(12) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Individual' WHEN 1 THEN N'Organization' END Provides a translation for the 'TYPECODE' field.
 USAGETYPE nvarchar(9) (Computed) CASE [USAGETYPECODE] WHEN 0 THEN N'College' WHEN 1 THEN N'Secondary' WHEN 2 THEN N'Both' END Provides a translation for the 'USAGETYPECODE' field.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_VSECONSTITUENCY_DATEADDED DATEADDED    
 IX_VSECONSTITUENCY_DATECHANGED DATECHANGED      
 PK_VSECONSTITUENCY ID  

Trigger Name Description
 TR_VSECONSTITUENCY_DELETE
 TR_VSECONSTITUENCY_AUDIT_UPDATE
 TR_VSECONSTITUENCY_AUDIT_DELETE

Referenced by Field
 VSECONSTITUENCYMAP VSECONSTITUENCYID

Entity-Relationship diagram of this table