V_QUERY_EDUCATIONADDITIONALINFORMATION
Provides the ability to query additional education information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| EDUCATIONALHISTORYID | uniqueidentifier | Educational history ID | |
| ACADEMICCATALOGCOLLEGEID | nvarchar(50) | yes | Academic catalog college ID |
| ACADEMICCATALOGCOLLEGE | nvarchar(150) | yes | Academic catalog college |
| ACADEMICCATALOGDIVISIONID | nvarchar(50) | yes | Academic catalog division ID |
| ACADEMICCATALOGDIVISION | nvarchar(150) | yes | Academic catalog division |
| ACADEMICCATALOGDEPARTMENTID | nvarchar(50) | yes | Academic catalog department ID |
| ACADEMICCATALOGDEPARTMENT | nvarchar(150) | yes | Academic catalog department |
| ACADEMICCATALOGSUBDEPARTMENTID | nvarchar(50) | yes | Academic catalog sub department ID |
| ACADEMICCATALOGSUBDEPARTMENT | nvarchar(150) | yes | Academic catalog sub department |
| ACADEMICCATALOGDEGREETYPEID | nvarchar(50) | yes | Academic catalog degree type ID |
| ACADEMICCATALOGDEGREETYPE | nvarchar(100) | yes | Academic catalog degree type |
| EDUCATIONALCOLLEGECODE | nvarchar(100) | yes | Educational college |
| EDUCATIONALDIVISIONCODE | nvarchar(100) | yes | Educational division |
| EDUCATIONALDEPARTMENTCODE | nvarchar(100) | yes | Educational department |
| EDUCATIONALSUBDEPARTMENTCODE | nvarchar(100) | yes | Educational sub department |
| EDUCATIONALDEGREETYPECODE | nvarchar(100) | yes | Educational degree type |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| ACADEMICCATALOGCOLLEGEISHISTORICAL | bit | yes | Academic catalog college is historical |
| ACADEMICCATALOGDEPARTMENTISHISTORICAL | bit | yes | Academic catalog department is historical |
| ACADEMICCATALOGDIVISIONISHISTORICAL | bit | yes | Academic catalog division is historical |
| ACADEMICCATALOGSUBDEPARTMENTISHISTORICAL | bit | yes | Academic catalog sub department is historical |
| EDUCATIONALDEPARTMENT_SHORTCODE | nvarchar(25) | yes | Educational department short code |
| EDUCATIONALSUBDEPARTMENT_SHORTCODE | nvarchar(25) | yes | Educational sub department short code |
| ACADEMICCATALOGDEGREETYPECODEID | uniqueidentifier | yes | |
| EDUCATIONALCOLLEGECODEID | uniqueidentifier | yes | |
| EDUCATIONALDIVISIONCODEID | uniqueidentifier | yes | |
| EDUCATIONALDEPARTMENTCODEID | uniqueidentifier | yes | |
| EDUCATIONALSUBDEPARTMENTCODEID | uniqueidentifier | yes | |
| EDUCATIONALDEGREETYPECODEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:50 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_EDUCATIONADDITIONALINFORMATION AS
select
ADDITIONALINFORMATION.ID,
ADDITIONALINFORMATION.EDUCATIONALHISTORYID,
ACADEMICCATALOGCOLLEGE.USERID as ACADEMICCATALOGCOLLEGEID,
ACADEMICCATALOGCOLLEGE.NAME as ACADEMICCATALOGCOLLEGE,
ACADEMICCATALOGDIVISION.USERID as ACADEMICCATALOGDIVISIONID,
ACADEMICCATALOGDIVISION.NAME as ACADEMICCATALOGDIVISION,
ACADEMICCATALOGDEPARTMENT.USERID as ACADEMICCATALOGDEPARTMENTID,
ACADEMICCATALOGDEPARTMENT.NAME as ACADEMICCATALOGDEPARTMENT,
ACADEMICCATALOGSUBDEPARTMENT.USERID as ACADEMICCATALOGSUBDEPARTMENTID,
ACADEMICCATALOGSUBDEPARTMENT.NAME as ACADEMICCATALOGSUBDEPARTMENT,
ACADEMICCATALOGDEGREETYPE.USERID as ACADEMICCATALOGDEGREETYPEID,
ACADEMICCATALOGDEGREETYPECODE.DESCRIPTION as ACADEMICCATALOGDEGREETYPE,
EDUCATIONALCOLLEGECODE.DESCRIPTION as EDUCATIONALCOLLEGECODE,
EDUCATIONALDIVISIONCODE.DESCRIPTION as EDUCATIONALDIVISIONCODE,
EDUCATIONALDEPARTMENTCODE.DESCRIPTION as EDUCATIONALDEPARTMENTCODE,
EDUCATIONALSUBDEPARTMENTCODE.DESCRIPTION as EDUCATIONALSUBDEPARTMENTCODE,
EDUCATIONALDEGREETYPECODE.DESCRIPTION as EDUCATIONALDEGREETYPECODE,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
ADDITIONALINFORMATION.DATEADDED,
ADDITIONALINFORMATION.DATECHANGED,
ADDITIONALINFORMATION.TSLONG,
ACADEMICCATALOGCOLLEGE.ISHISTORICAL as ACADEMICCATALOGCOLLEGEISHISTORICAL,
ACADEMICCATALOGDEPARTMENT.ISHISTORICAL as ACADEMICCATALOGDEPARTMENTISHISTORICAL,
ACADEMICCATALOGDIVISION.ISHISTORICAL as ACADEMICCATALOGDIVISIONISHISTORICAL,
ACADEMICCATALOGSUBDEPARTMENT.ISHISTORICAL as ACADEMICCATALOGSUBDEPARTMENTISHISTORICAL,
EDUCATIONALDEPARTMENTCODEEXTENSION.SHORTCODE as EDUCATIONALDEPARTMENT_SHORTCODE,
EDUCATIONALSUBDEPARTMENTCODEEXTENSION.SHORTCODE as EDUCATIONALSUBDEPARTMENT_SHORTCODE,
[ACADEMICCATALOGDEGREETYPE].[ACADEMICCATALOGDEGREETYPECODEID],
[ADDITIONALINFORMATION].[EDUCATIONALCOLLEGECODEID],
[ADDITIONALINFORMATION].[EDUCATIONALDIVISIONCODEID],
[ADDITIONALINFORMATION].[EDUCATIONALDEPARTMENTCODEID],
[ADDITIONALINFORMATION].[EDUCATIONALSUBDEPARTMENTCODEID],
[ADDITIONALINFORMATION].[EDUCATIONALDEGREETYPECODEID]
from
dbo.EDUCATIONADDITIONALINFORMATION as ADDITIONALINFORMATION
left join dbo.EDUCATIONALHISTORY as HISTORY on HISTORY.ID = ADDITIONALINFORMATION.EDUCATIONALHISTORYID
left join dbo.ACADEMICCATALOGCOLLEGE on ADDITIONALINFORMATION.ACADEMICCATALOGCOLLEGEID = ACADEMICCATALOGCOLLEGE.ID
left join dbo.ACADEMICCATALOGDIVISION on ADDITIONALINFORMATION.ACADEMICCATALOGDIVISIONID = ACADEMICCATALOGDIVISION.ID
left join dbo.ACADEMICCATALOGDEPARTMENT on ADDITIONALINFORMATION.ACADEMICCATALOGDEPARTMENTID = ACADEMICCATALOGDEPARTMENT.ID
left join dbo.ACADEMICCATALOGSUBDEPARTMENT on ADDITIONALINFORMATION.ACADEMICCATALOGSUBDEPARTMENTID = ACADEMICCATALOGSUBDEPARTMENT.ID
left join dbo.ACADEMICCATALOGDEGREETYPE on ADDITIONALINFORMATION.ACADEMICCATALOGDEGREETYPEID = ACADEMICCATALOGDEGREETYPE.ID
left join dbo.ACADEMICCATALOGDEGREETYPECODE on ACADEMICCATALOGDEGREETYPE.ACADEMICCATALOGDEGREETYPECODEID = ACADEMICCATALOGDEGREETYPECODE.ID
left join dbo.EDUCATIONALCOLLEGECODE on ADDITIONALINFORMATION.EDUCATIONALCOLLEGECODEID = EDUCATIONALCOLLEGECODE.ID
left join dbo.EDUCATIONALDIVISIONCODE on ADDITIONALINFORMATION.EDUCATIONALDIVISIONCODEID = EDUCATIONALDIVISIONCODE.ID
left join dbo.EDUCATIONALDEPARTMENTCODE on ADDITIONALINFORMATION.EDUCATIONALDEPARTMENTCODEID = EDUCATIONALDEPARTMENTCODE.ID
left join dbo.EDUCATIONALSUBDEPARTMENTCODE on ADDITIONALINFORMATION.EDUCATIONALSUBDEPARTMENTCODEID = EDUCATIONALSUBDEPARTMENTCODE.ID
left join dbo.EDUCATIONALDEGREETYPECODE on ADDITIONALINFORMATION.EDUCATIONALDEGREETYPECODEID = EDUCATIONALDEGREETYPECODE.ID
left join dbo.CHANGEAGENT as ADDEDBY on ADDEDBY.ID = ADDITIONALINFORMATION.ADDEDBYID
left join dbo.CHANGEAGENT as CHANGEDBY on CHANGEDBY.ID = ADDITIONALINFORMATION.CHANGEDBYID
left join dbo.EDUCATIONALDEPARTMENTCODEEXTENSION on EDUCATIONALDEPARTMENTCODE.ID = EDUCATIONALDEPARTMENTCODEEXTENSION.ID
left join dbo.EDUCATIONALSUBDEPARTMENTCODEEXTENSION on EDUCATIONALSUBDEPARTMENTCODE.ID = EDUCATIONALSUBDEPARTMENTCODEEXTENSION.ID