Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CHILD_COUNT	Count of children (entity and non-entity)	NUMBER	EXPRESSION	CHILD_COUNT_EXPRESSION	NO	NO	RELATIONSHIP
CHILD_SEQ_NUMBER	Sequence used to uniquely identify different children for this person.	NUMBER	CONSTANT_0	NULL	NO	NO	RELATIONSHIP
COMBINED_SPOUSE_PRIORITY	Designates if the entity in context is the primary or secondary spouse for combined mailing purposes. For cross referenced relationships only. Valid values are P for primary and S for secondary.	VARCHAR2(255)	EXPRESSION	COMBINED_SPOUSE_PRIORITY_EXPRESSION	NO	NO	RELATIONSHIP
CONSTITUENT_ENTITY_ATTRIB_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	CONSTITUENT_ENTITY_ATTRIB_KEY	NO	NO	RELATIONSHIP
CURRENT_SPOUSE_IND	Determines whether this is the current spouse of the constituent entity.	NUMBER	EXPRESSION	CURRENT_SPOUSE_IND_EXPRESSION	NO	NO	RELATIONSHIP
ENTITY_KEY	System generated, unique, internal primary key for a constituent entity that has one or more relationships.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	RELATIONSHIP
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity that has a relationship of some kind.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	RELATIONSHIP
MARRIAGE_CHANGE_DATE	Date on which the marital status for this couple changed or ended.	DATE	CONSTANT_0	NULL	NO	NO	RELATIONSHIP
MARRIAGE_CHANGE_DATE_PARTIAL	Date on which the marital status for this couple changed or ended - may be partial date.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
MARRIAGE_DATE	Date on which this couple was married.	DATE	CONSTANT_0	NULL	NO	NO	RELATIONSHIP
MARRIAGE_DATE_PARTIAL	Date on which this couple was married - may be partial date.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	RELATIONSHIP
NON_ENTITY_RELATION_KEY		NUMBER	CLN_NON_ENTITY_RELATION	NON_ENTITY_RELATION_KEY_EXPRESSION	NO	NO	RELATIONSHIP
PREFERRED_CLASS_SCHOOL_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PREFERRED_CLASS_SCHOOL_KEY	NO	NO	RELATIONSHIP
PRIMARY_CE_TYPE_KEY	System generated, unique, internal primary key for an entity relation's primary entity type.	NUMBER	WFT_CONSTITUENT_ENTITY	PRIMARY_CE_TYPE_KEY	NO	NO	RELATIONSHIP
RELATED_ENTITY_KEY	System generated, unique, internal primary key for a related constituent entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	RELATIONSHIP
RELATED_ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity that is related in some fashion to the constituent entity.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	RELATIONSHIP
RELATIONSHIP_GROUP_KEY		NUMBER	EXPRESSION	RELATIONSHIP_GROUP_KEY_EXPRESSION	NO	NO	RELATIONSHIP
RELATIONSHIP_KEY	System generated, unique, internal primary key for a type of relationship.	NUMBER	CLN_RELATIONSHIP	RELATIONSHIP_KEY	NO	NO	RELATIONSHIP
RELATION_COUNT	Count of (entity and non-entity) relationships. For entity relationships this is a distinct count of related entities.	NUMBER	EXPRESSION	RELATION_COUNT_EXPRESSION	NO	NO	RELATIONSHIP
RELATION_DEMOGRAPHIC_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	DEMOGRAPHIC_KEY	NO	NO	RELATIONSHIP
RELATION_ENTITY_IND	Indicates if this relation is an entity cross referenced to the constituent.	NUMBER	EXPRESSION	RELATION_ENTITY_IND_EXPRESSION	NO	NO	RELATIONSHIP
RELATION_HOUSEHOLD_IND		NUMBER	CLN_RELATIONSHIP	RELATION_HOUSEHOLD_IND_EXPRESSION	NO	NO	RELATIONSHIP
RELATION_SOURCE	Origin of relation from source system for cross referenced entity or non entity relationships; Spouse, Child or Other Relation. Also includes Former Spouse for Advance.	VARCHAR2(63)	CONSTANT_0	'OTHER RELATION'	NO	NO
SPOUSE_GROUP_IDENTIFIER	System generated, unique, internal primary key for grouping spouse relationships.	VARCHAR2(255)	EXPRESSION	SPOUSE_GROUP_IDENTIFIER_EXPRESSION	NO	NO	RELATIONSHIP
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'RELATIONSHIP_F1B'	NO	NO	RELATIONSHIP
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_01		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_02		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_03		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_04		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_05		NUMBER	NO SOURCE	NO SOURCE	NO	NO

Ver: 9.0