| CONSTITUENTRELATIONSHIPSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[RELATIONSHIP].[ID] |
| CONSTITUENTRELATIONSHIPSETDIMID |
int |
yes |
|
Reference key to the constituent relationship set dimension, derived using [dbo].[RELATIONSHIP].[RELATIONSHIPSETID]. Use this column to relate to BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT]. |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived using [dbo].[RELATIONSHIP].[RELATIONSHIPCONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[RELATIONSHIP].[RELATIONSHIPCONSTITUENTID] |
| CONSTITUENTRELATIONSHIPTYPEDIMID |
int |
yes |
|
Reference key to the constituent relationship type dimension, derived using [dbo].[RELATIONSHIP].[RELATIONSHIPTYPECODEID] |
| RECIPROCALCONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived using [dbo].[RELATIONSHIP].[RECIPROCALCONSTITUENTID] |
| RECIPROCALCONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[RELATIONSHIP].[RECIPROCALCONSTITUENTID] |
| RECIPROCALCONSTITUENTRELATIONSHIPTYPEDIMID |
int |
yes |
|
Reference key to the constituent relationship type dimension, derived using [dbo].[RELATIONSHIP].[RECIPROCALTYPECODEID] |
| CONSTITUENTRELATIONSHIPFLAGDIMID |
int |
yes |
|
Reference key to the constituent relationship flag dimension, derived using [dbo].[RELATIONSHIP].[ISSPOUSE] [bit], [dbo].[RELATIONSHIP].[ISPRIMARYBUSINESS], [dbo].[RELATIONSHIP].[ISCONTACT], [dbo].[RELATIONSHIP].[ISPRIMARYCONTACT], [dbo].[RELATIONSHIP].[ISMATCHINGGIFTRELATIONSHIP], [dbo].[RELATIONSHIP].[ISEMERGENCYCONTACT], and [dbo].[RELATIONSHIP].[ISCURRENTRELATIONSHIP] |
| CONTACTTYPEDIMID |
int |
yes |
|
Reference key to the contact type dimension, derived using [dbo].[RELATIONSHIP].[CONTACTTYPECODEID] |
| STARTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived using [dbo].[RELATIONSHIP].[STARTDATE] |
| STARTDATE |
datetime |
yes |
|
[dbo].[RELATIONSHIP].[STARTDATE] |
| ENDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived using [dbo].[RELATIONSHIP].[ENDDATE] |
| ENDDATE |
datetime |
yes |
|
[dbo].[RELATIONSHIP].[ENDDATE] |
| POSITION |
nvarchar(100) |
yes |
|
[dbo].[RELATIONSHIP].[POSITION] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |