V_QUERY_RE7_CONSTITUENTEDUCATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LOCALID | int | ||
| CONSTITUENT_LOCALID | int | ||
| SCHOOLNAME | nvarchar(100) | yes | |
| SCHOOLTYPE | nvarchar(100) | yes | |
| CAMPUS | nvarchar(50) | yes | |
| CLASSYEAR | smallint | yes | |
| DATEGRADUATED | UDT_FUZZYDATE | ||
| DATELEFT | UDT_FUZZYDATE | ||
| DEGREE | nvarchar(100) | yes | |
| FRATERNITY | nvarchar(50) | yes | |
| GPA | numeric(30, 6) | yes | |
| REGISTRATIONNUMBER | nvarchar(50) | yes | |
| SUBJECTOFSTUDY | nvarchar(100) | yes | |
| DEPARTMENT | nvarchar(100) | yes | |
| FACULTY | nvarchar(100) | yes | |
| CLASSOFDEGREE | nvarchar(100) | yes | |
| ISPRIMARY | bit | ||
| DATEENTERED | UDT_FUZZYDATE | ||
| IMPORTID | nvarchar(20) | yes | |
| STATUSCODE_LOCALID | int | yes | |
| STATUS | nvarchar(100) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:24 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_CONSTITUENTEDUCATION AS
select
[CE].[LOCALID],
[CE].[CONSTITUENT_LOCALID],
[S].[DESCRIPTION] [SCHOOLNAME],
[STC].[DESCRIPTION] [SCHOOLTYPE],
[CAMPUS],
[CLASSOF] [CLASSYEAR],
[CE].[DATEGRADUATED],
[CE].[DATELEFT],
[D].[DESCRIPTION] [DEGREE],
[FRATERNITY],
[GPA],
[REGISTRATIONNUMBER] ,
[SOS].[DESCRIPTION] [SUBJECTOFSTUDY],
[SD].[DESCRIPTION] [DEPARTMENT],
[SF].[DESCRIPTION] [FACULTY],
[COD].[DESCRIPTION] [CLASSOFDEGREE],
[CE].[ISPRIMARY],
[CE].[DATEENTERED],
[CE].[IMPORTID],
[CE].[STATUSCODE_LOCALID],
[CESC].[DESCRIPTION] [STATUS]
from [dbo].[RE7_CONSTITUENTEDUCATION] [CE]
left outer join dbo.[RE7_SCHOOLTYPECODE] [STC] on [CE].[SCHOOLTYPECODE_LOCALID] = [STC].[LOCALID]
left outer join dbo.[RE7_SCHOOLDEPARTMENTCODE] [SOS] on [CE].[SUBJECTOFSTUDYCODE_LOCALID] = [SOS].[LOCALID]
left outer join dbo.[RE7_SCHOOLCODE] [S] on [CE].[SCHOOLCODE_LOCALID] = [S].[LOCALID]
left outer join dbo.[RE7_SCHOOLFACULTYCODE] [SF] on [CE].[FACULTYCODE_LOCALID] = [SF].[LOCALID]
left outer join dbo.[RE7_CLASSOFDEGREECODE] [COD] on [CE].[CLASSOFDEGREECODE_LOCALID] = [COD].[LOCALID]
left outer join dbo.[RE7_DEGREECODE] [D] on [CE].[DEGREECODE_LOCALID] = [D].[LOCALID]
left outer join dbo.[RE7_SCHOOLDEPARTMENTCODE] [SD] on [CE].[DEPARTMENTCODE_LOCALID] = [SD].[LOCALID]
left outer join dbo.[RE7_EDUCATIONSTATUSCODE] [CESC] on [CE].[STATUSCODE_LOCALID] = [CESC].[LOCALID];