V_QUERY_RELATIONSHIPJOBINFO
Job information for a constituent.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| RELATIONSHIPSETID | uniqueidentifier | Relationship set ID | |
| JOBTITLE | nvarchar(100) | Job title | |
| JOBCATEGORY | nvarchar(100) | yes | Job category |
| CAREERLEVEL | nvarchar(100) | yes | Career level |
| STARTDATE | datetime | yes | Start date |
| ENDDATE | datetime | yes | End date |
| 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 |
| JOBDEPARTMENT | nvarchar(100) | Job department | |
| JOBDIVISION | nvarchar(100) | Job division | |
| JOBSCHEDULE | nvarchar(100) | yes | Job schedule |
| JOBRESPONSIBILITY | nvarchar(250) | Job responsibilities | |
| ISPRIVATERECORD | bit | Is private | |
| JOBCATEGORYCODEID | uniqueidentifier | yes | |
| CAREERLEVELCODEID | uniqueidentifier | yes | |
| JOBSCHEDULECODEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:47 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RELATIONSHIPJOBINFO AS
select
RELATIONSHIPJOBINFO.ID,
RELATIONSHIPJOBINFO.RELATIONSHIPSETID,
RELATIONSHIPJOBINFO.JOBTITLE,
JOBCATEGORYCODE.DESCRIPTION as JOBCATEGORY,
CAREERLEVELCODE.DESCRIPTION as CAREERLEVEL,
RELATIONSHIPJOBINFO.STARTDATE,
RELATIONSHIPJOBINFO.ENDDATE,
[ADDEDBY].APPLICATIONNAME as ADDEDBY_APPLICATION,
[ADDEDBY].USERNAME as ADDEDBY_USERNAME,
[CHANGEDBY].APPLICATIONNAME as CHANGEDBY_APPLICATION,
[CHANGEDBY].USERNAME as CHANGEDBY_USERNAME,
dbo.RELATIONSHIPJOBINFO.DATEADDED,
dbo.RELATIONSHIPJOBINFO.DATECHANGED,
dbo.RELATIONSHIPJOBINFO.TSLONG,
RELATIONSHIPJOBINFO.JOBDEPARTMENT,
RELATIONSHIPJOBINFO.JOBDIVISION,
JOBSCHEDULECODE.DESCRIPTION as JOBSCHEDULE,
RELATIONSHIPJOBINFO.JOBRESPONSIBILITY,
RELATIONSHIPJOBINFO.ISPRIVATERECORD,
[RELATIONSHIPJOBINFO].[JOBCATEGORYCODEID],
[RELATIONSHIPJOBINFO].[CAREERLEVELCODEID],
[RELATIONSHIPJOBINFO].[JOBSCHEDULECODEID]
/*#EXTENSION*/
from
dbo.RELATIONSHIPJOBINFO
left join dbo.JOBCATEGORYCODE on RELATIONSHIPJOBINFO.JOBCATEGORYCODEID = JOBCATEGORYCODE.ID
left join dbo.CAREERLEVELCODE on RELATIONSHIPJOBINFO.CAREERLEVELCODEID = CAREERLEVELCODE.ID
left join dbo.JOBSCHEDULECODE on RELATIONSHIPJOBINFO.JOBSCHEDULECODEID = JOBSCHEDULECODE.ID
left outer join dbo.CHANGEAGENT as ADDEDBY on ADDEDBY.ID = RELATIONSHIPJOBINFO.ADDEDBYID
left outer join dbo.CHANGEAGENT as CHANGEDBY on CHANGEDBY.ID = RELATIONSHIPJOBINFO.CHANGEDBYID