Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 VSECATEGORYCODE tinyint   Default = 0 0=Current Operations - Unrestricted, 1=Current Operations - Restricted, 2=Current Operations - Academic Divisions, 3=Current Operations - Faculty and Staff, 4=Current Operations - Research, 5=Current Operations - Public Service and Extension, 6=Current Operations - Library, 7=Current Operations - Op and Maint of Plant, 8=Current Operations - Student Financial Aid, 9=Current Operations - Athletics, 10=Current Operations - Other Restricted, 12=Capital Purposes - Property, Building, Equipment, 13=Capital Purposes - Endowment Unrestricted, 14=Capital Purposes - Endowment Restricted, 15=Capital Purposes - Loan Funds, 18=Capital Purposes - Endowment Restricted - Academic Divisions, 19=Capital Purposes - Endowment Restricted - Faculty and Staff, 20=Capital Purposes - Endowment Restricted - Research, 21=Capital Purposes - Endowment Restricted - Public Service and Extension, 22=Capital Purposes - Endowment Restricted - Library, 23=Capital Purposes - Endowment Restricted - Op and Maint of Plant, 24=Capital Purposes - Endowment Restricted - Student Financial Aid, 25=Capital Purposes - Endowment Restricted - Athletics, 26=Capital Purposes - Endowment Restricted - Other
 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.
 PURPOSETYPECODE tinyint   Default = 0 0=Current Operations, 1=Capital Purposes
 VSECATEGORY nvarchar(70) (Computed) CASE [VSECATEGORYCODE] WHEN 0 THEN N'Current Operations - Unrestricted' WHEN 1 THEN N'Current Operations - Restricted' WHEN 2 THEN N'Current Operations - Academic Divisions' WHEN 3 THEN N'Current Operations - Faculty and Staff' WHEN 4 THEN N'Current Operations - Research' WHEN 5 THEN N'Current Operations - Public Service and Extension' WHEN 6 THEN N'Current Operations - Library' WHEN 7 THEN N'Current Operations - Op and Maint of Plant' WHEN 8 THEN N'Current Operations - Student Financial Aid' WHEN 9 THEN N'Current Operations - Athletics' WHEN 10 THEN N'Current Operations - Other Restricted' WHEN 12 THEN N'Capital Purposes - Property, Building, Equipment' WHEN 13 THEN N'Capital Purposes - Endowment Unrestricted' WHEN 14 THEN N'Capital Purposes - Endowment Restricted' WHEN 15 THEN N'Capital Purposes - Loan Funds' WHEN 18 THEN N'Capital Purposes - Endowment Restricted - Academic Divisions' WHEN 19 THEN N'Capital Purposes - Endowment Restricted - Faculty and Staff' WHEN 20 THEN N'Capital Purposes - Endowment Restricted - Research' WHEN 21 THEN N'Capital Purposes - Endowment Restricted - Public Service and Extension' WHEN 22 THEN N'Capital Purposes - Endowment Restricted - Library' WHEN 23 THEN N'Capital Purposes - Endowment Restricted - Op and Maint of Plant' WHEN 24 THEN N'Capital Purposes - Endowment Restricted - Student Financial Aid' WHEN 25 THEN N'Capital Purposes - Endowment Restricted - Athletics' WHEN 26 THEN N'Capital Purposes - Endowment Restricted - Other' END Provides a translation for the 'VSECATEGORYCODE' 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.
 PURPOSETYPE nvarchar(18) (Computed) CASE [PURPOSETYPECODE] WHEN 0 THEN N'Current Operations' WHEN 1 THEN N'Capital Purposes' END Provides a translation for the 'PURPOSETYPECODE' 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_VSECATEGORY_DATEADDED DATEADDED    
 IX_VSECATEGORY_DATECHANGED DATECHANGED      
 PK_VSECATEGORY ID  

Trigger Name Description
 TR_VSECATEGORY_DELETE
 TR_VSECATEGORY_AUDIT_UPDATE
 TR_VSECATEGORY_AUDIT_DELETE

Referenced by Field
 DESIGNATION VSECATEGORYID
 VSESUBCATEGORY VSECATEGORYID

Entity-Relationship diagram of this table