WDT_CONST_EMPLOYMENT_JOB - Const Employment Job Dimension
| Constituent employment job dimension table provides employer and employment attributes for a constituent. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_CONST_EMPLOYMENT_POSITION - Const Employment Position Dimension
| Constituent employment position dimension table provides information about the employment position for a constituent. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_ENTITY - Entity Dimension
| Entity dimension table provides information about a person or organization. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_MULTI_SOURCE - Multi Source Dimension
| Multi Source Dimension table provides an institution source value when the optional multi-source feature has been applied. Institution source VALUES have a short and long description. Data in this dimension may optionally include a process-oriented identifier and an administrative-oriented identifier for the record used to determine access authorization to this record. The cleansing rules are used in the EDW for the short and long descriptions. | | |
WDT_NON_ENTITY_RELATION - Non Entity Relation Dimension
| Non-Entity Relation dimension table provides information about a person or organization who is a non-entity. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_RELATIONSHIP - Relationship Dimension
| Relationship dimension table provides attributes about a constituent's relationships such as the relationship description and spouse, household, employer, matching gift indicators. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_CONSTITUENT_EMPLOYMENT - Constituent Employment Fact Table
| Constituent employment fact table provides measures related to all employment information for a constituent. | | |