RETURN TO BANNER EDW META DATA REPORTS LIST
Constituent Employment Star  Relationship Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_RELATIONSHIP

Description 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.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
CONVERSE_RELATION The converse relationship. VARCHAR2(63)

ATVXREF

ATVXREF_REVERSE_XREF

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
CONVERSE_RELATION_LD Converse relationship long description. VARCHAR2(255)

ATVXREF

ATVXREF_DESC

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
CONVERSE_RELATION_SD Converse relationship short description. VARCHAR2(255)

ATVXREF

ATVXREF_DESC

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATIONSHIP System generated, unique, internal primary key for a relationship. VARCHAR2(63)

ATVXREF

ATVXREF_CODE

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATIONSHIP_KEY System generated, unique, internal primary key for a type of relationship. NUMBER       NO
RELATIONSHIP_LD Relationship long description. VARCHAR2(255)

ATVXREF

ATVXREF_DESC

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATIONSHIP_SD Relationship short description. VARCHAR2(255)

ATVXREF

ATVXREF_DESC

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_EMPLOYER_IND Determines whether the relationship is considered to be an employer. NUMBER

EXPRESSION

RELATION_EMPLOYER_IND_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_EMPLOYER_IND_LD Relationship employer indicator long description. VARCHAR2(255)

EXPRESSION

RELATION_EMPLOYER_IND_LD_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_EMPLOYER_IND_SD Relationship employer indicator short description. VARCHAR2(255)

EXPRESSION

RELATION_EMPLOYER_IND_SD_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_HOUSEHOLD_IND Determines whether the relationship is considered to be a household member living at the same address. NUMBER

EXPRESSION

RELATION_HOUSEHOLD_IND_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_HOUSEHOLD_IND_LD Relationship household indicator long description. VARCHAR2(255)

EXPRESSION

RELATION_HOUSEHOLD_IND_LD_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_HOUSEHOLD_IND_SD Relationship household indicator short description. VARCHAR2(255)

EXPRESSION

RELATION_HOUSEHOLD_IND_SD_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_MATCH_GIFT_IND Determines whether the relationship has a matching gift associated to it. NUMBER

EXPRESSION

RELATION_MATCH_GIFT_IND_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_MATCH_GIFT_IND_LD Relationship matching gift indicator long description. VARCHAR2(255)

EXPRESSION

RELATION_MATCH_GIFT_IND_LD_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_MATCH_GIFT_IND_SD Relationship matching gift indicator short description. VARCHAR2(255)

EXPRESSION

RELATION_MATCH_GIFT_IND_SD_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_SPOUSE_IND Determines whether the relationship is a spouse. NUMBER

EXPRESSION

RELATION_SPOUSE_IND_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_SPOUSE_IND_LD Relationship spouse indicator short description. VARCHAR2(255)

EXPRESSION

RELATION_SPOUSE_IND_LD_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
RELATION_SPOUSE_IND_SD Relationship spouse indicator short description. VARCHAR2(255)

EXPRESSION

RELATION_SPOUSE_IND_SD_EXPRESSION

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

SYSTEM_LOAD_PROCESS

'RELATIONSHIP_D1B'

NO

NO CONSTITUENT EMPLOYMENT, RELATIONSHIP
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO


Ver: 9.0