| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| PURPOSETYPECODE |
tinyint |
|
Default = 0 |
0=Current Operations, 1=Capital Purposes |
| VSECATEGORY |
nvarchar(70) (Computed) |
yes |
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) |
yes |
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) |
yes |
CASE [PURPOSETYPECODE] WHEN 0 THEN N'Current Operations' WHEN 1 THEN N'Capital Purposes' END |
Provides a translation for the 'PURPOSETYPECODE' field. |