V_QUERY_RESEARCHGROUPADDMEMBERS_ANYPRIMARY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CONSTITUENTID | uniqueidentifier | ||
| CLASSOF | UDT_YEAR | ||
| EDUCATIONALCOLLEGECODE | nvarchar(100) | yes | |
| EDUCATIONALDEGREE | nvarchar(100) | yes | |
| EDUCATIONALDEGREETYPECODE | nvarchar(100) | yes | |
| EDUCATIONALDEPARTMENTCODE | nvarchar(100) | yes | |
| EDUCATIONALDIVISIONCODE | nvarchar(100) | yes | |
| EDUCATIONALINSTITUTIONNAME | nvarchar(154) | yes | |
| EDUCATIONALINVOLVEMENTNAME | nvarchar(150) | yes | |
| EDUCATIONALPROGRAM | nvarchar(100) | yes | |
| EDUCATIONALSUBDEPARTMENTCODE | nvarchar(100) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:10:11 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RESEARCHGROUPADDMEMBERS_ANYPRIMARY AS
select
EDUCATIONALHISTORY.ID,
EDUCATIONALHISTORY.CONSTITUENTID,
EDUCATIONALHISTORY.CLASSOF,
EDUCATIONALCOLLEGECODE.DESCRIPTION as EDUCATIONALCOLLEGECODE,
EDUCATIONALDEGREECODE.DESCRIPTION as EDUCATIONALDEGREE,
EDUCATIONALDEGREETYPECODE.DESCRIPTION as EDUCATIONALDEGREETYPECODE,
EDUCATIONALDEPARTMENTCODE.DESCRIPTION as EDUCATIONALDEPARTMENTCODE,
EDUCATIONALDIVISIONCODE.DESCRIPTION as EDUCATIONALDIVISIONCODE,
EDUCATIONINSTITUTION.NAME as EDUCATIONALINSTITUTIONNAME,
EDUCATIONALINVOLVEMENTNAME.NAME EDUCATIONALINVOLVEMENTNAME,
EDUCATIONALPROGRAMCODE.DESCRIPTION as EDUCATIONALPROGRAM,
EDUCATIONALSUBDEPARTMENTCODE.DESCRIPTION as EDUCATIONALSUBDEPARTMENTCODE
from dbo.EDUCATIONALHISTORY
left join dbo.EDUCATIONADDITIONALINFORMATION on EDUCATIONADDITIONALINFORMATION.EDUCATIONALHISTORYID = EDUCATIONALHISTORY.ID
left join dbo.EDUCATIONALCOLLEGECODE on EDUCATIONADDITIONALINFORMATION.EDUCATIONALCOLLEGECODEID = EDUCATIONALCOLLEGECODE.ID
left join dbo.EDUCATIONALDEGREECODE on EDUCATIONALHISTORY.EDUCATIONALDEGREECODEID = EDUCATIONALDEGREECODE.ID
left join dbo.EDUCATIONALDIVISIONCODE on EDUCATIONADDITIONALINFORMATION.EDUCATIONALDIVISIONCODEID = EDUCATIONALDIVISIONCODE.ID
left join dbo.EDUCATIONALDEPARTMENTCODE on EDUCATIONADDITIONALINFORMATION.EDUCATIONALDEPARTMENTCODEID = EDUCATIONALDEPARTMENTCODE.ID
left join dbo.EDUCATIONALSUBDEPARTMENTCODE on EDUCATIONADDITIONALINFORMATION.EDUCATIONALSUBDEPARTMENTCODEID = EDUCATIONALSUBDEPARTMENTCODE.ID
left join dbo.EDUCATIONALDEGREETYPECODE on EDUCATIONADDITIONALINFORMATION.EDUCATIONALDEGREETYPECODEID = EDUCATIONALDEGREETYPECODE.ID
left join dbo.EDUCATIONALPROGRAMCODE on EDUCATIONALHISTORY.EDUCATIONALPROGRAMCODEID = EDUCATIONALPROGRAMCODE.ID
left join dbo.EDUCATIONALINVOLVEMENT on EDUCATIONALINVOLVEMENT.CONSTITUENTID = EDUCATIONALHISTORY.CONSTITUENTID
left join dbo.EDUCATIONALINVOLVEMENTNAME on EDUCATIONALINVOLVEMENT.EDUCATIONALINVOLVEMENTNAMEID = EDUCATIONALINVOLVEMENTNAME.ID
left join dbo.CONSTITUENT EDUCATIONINSTITUTION on EDUCATIONINSTITUTION.ID = EDUCATIONALHISTORY.EDUCATIONALINSTITUTIONID
where EDUCATIONALHISTORY.ISPRIMARYRECORD = 1