v_DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT
Contains set used for constituent relationships.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID | int | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID] | |
| CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID] |
| CONSTITUENTRELATIONSHIPSETDIMID | int | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID] |
| JOBTITLE | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID] |
| JOBCATEGORY | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID] |
| CAREERLEVEL | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID] |
| JOBSCHEDULE | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID] |
| JOBDIVISION | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID] |
| JOBDEPARTMENT | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID] |
| JOBRESPONSIBILITY | nvarchar(250) | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID] |
| STARTDATEDIMID | int | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID] |
| STARTDATE | datetime | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID] |
| ENDDATEDIMID | int | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID] |
| ENDDATE | datetime | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID] |
| ISPRIVATERECORD | bit | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID] |
| ISCURRENTEMPLOYMENT | bit | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT].[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT] as
select
ce.[CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID],
ce.[CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID],
ce.[CONSTITUENTRELATIONSHIPSETDIMID],
ce.[JOBTITLE],
ce.[JOBCATEGORY],
ce.[CAREERLEVEL],
ce.[JOBSCHEDULE],
ce.[JOBDIVISION],
ce.[JOBDEPARTMENT],
ce.[JOBRESPONSIBILITY],
ce.[STARTDATEDIMID],
ce.[STARTDATE],
ce.[ENDDATEDIMID],
ce.[ENDDATE],
ce.[ISPRIVATERECORD],
ce.[ISCURRENTEMPLOYMENT]
from BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT] ce