FACT_EVENTREGISTRANTBENEFITTOTAL
Intermediate storage table for benefits.
Primary Key
Primary Key |
Field Type |
EVENTREGISTRANTBENEFITTOTALFACTID |
int |
Fields
Field |
Field Type |
Null |
Notes |
Description |
EVENTREGISTRANTTOTALBENEFITSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[FAFREGISTRANTBENEFITSUMMARY].[ID] |
EVENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[FAFREGISTRANTBENEFITSUMMARY].[EVENTID] |
EVENTDIMID |
int |
yes |
|
Reference key to the event dimension derived from dbo.[FAFREGISTRANTBENEFITSUMMARY][EVENTID] |
CONSTITUENTSYTEMID |
uniqueidentifier |
yes |
|
[dbo].[FAFREGISTRANTBENEFITSUMMARY].[CONSTITUENTID] |
CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension table derived from [dbo].[FAFREGISTRANTBENEFITSUMMARY].[CONSTITUENTID] |
EVENTREGISTRANTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[REGISTRANT].[ID] |
EVENTREGISTRANTFACTID |
int |
yes |
|
Reference key to the constituent dimension table derived from [dbo].[FAFREGISTRANTBENEFITSUMMARY].[CONSTITUENTID] |
BENEFITLIST |
nvarchar(500) |
yes |
|
dbo.[FAFREGISTRANTBENEFITSUMMARY].[BENEFITS] |
TOTALVALUE |
money |
yes |
|
[dbo].[FAFREGISTRANTBENEFITSUMMARY].[TOTALVALUE] |
BENEFITTYPEDIMID |
int |
yes |
|
Reference key to the benefit type dimension derived from [dbo].[FAFREGISTRANTBENEFITSUMMARY].[BENEFITTYPE] |
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. |
BENEFITTYPE |
int |
yes |
|
[dbo].[FAFREGISTRANTBENEFITSUMMARY].[BENEFITTYPE] |
Indexes
Index Name |
Fields |
Unique |
Primary |
Clustered |
PK_FACT_EVENTREGISTRANTBENEFITTOTAL |
EVENTREGISTRANTBENEFITTOTALFACTID |
yes |
yes |
yes |