Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_ADDRESS_IND	Indicates whether this address is active.	NUMBER	EXPRESSION	ACTIVE_ADDRESS_IND_EXPRESSION	NO	NO	ADDRESS
ADDRESS_COUNT	Count of all address records for the constituent.	NUMBER	EXPRESSION_1	ADDRESS_COUNT_EXPRESSION	NO	NO	ADDRESS
ADDRESS_CURRENT_GROUP_KEY		NUMBER	NO SOURCE	NO SOURCE	NO	NO
ADDRESS_GEO_GROUP_KEY		NUMBER	EXPRESSION_2	ADDRESS_GEO_GROUP_KEY_EXPRESSION	NO	NO	ADDRESS
ADDRESS_GROUP_KEY		NUMBER	EXPRESSION_1	ADDRESS_GROUP_KEY_EXPRESSION	NO	NO	ADDRESS
ADDRESS_START_DATE	Beginning date to use for this address.	DATE	EXPRESSION	ADDRESS_START_DATE_EXPRESSION	NO	NO	ADDRESS
ADDRESS_START_DATE_PARTIAL	Start date of the address. May be partial date in cases of seasonal address.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
ADDRESS_STOP_DATE	Ending date to use for this address.	DATE	EXPRESSION	ADDRESS_STOP_DATE_EXPRESSION	NO	NO	ADDRESS
ADDRESS_STOP_DATE_PARTIAL	Stop date of the address. May be partial date in cases of seasonal address.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
ADDRESS_TYPE_KEY	System generated, unique, internal primary key for an address type.	NUMBER	CLN_ADDRESS_TYPE	ADDRESS_TYPE_KEY	NO	NO	ADDRESS
BUSINESS_ADDRESS_IND	Indicates if this is a business address as classified by the HBS Address Type extract parameter.	NUMBER	EXPRESSION	BUSINESS_ADDRESS_IND_EXPRESSION	NO	NO	ADDRESS
CURRENT_ADDRESS_COUNT	Count of current addresses for the constituent.	NUMBER	EXPRESSION_1	CURRENT_ADDRESS_COUNT_EXPRESSION	NO	NO	ADDRESS
CURRENT_ADDRESS_IND	Indicates whether this address is current.	NUMBER	EXPRESSION_1	CURRENT_ADDRESS_IND_EXPRESSION	NO	NO	ADDRESS
CURRENT_SEASONAL_ADDRESS_COUNT	Count of current seasonal addresses for the constituent.	NUMBER	EXPRESSION_1	CURRENT_SEASONAL_ADDRESS_COUNT_EXPRESSION	NO	NO	ADDRESS
DEFAULT_GEO_REGION_ATYP_IND	Parameter Map defined for assigning a default geo region address type	NUMBER	EXPRESSION	DEFAULT_GEO_REGION_ATYP_IND_EXPRESSION	NO	NO	ADDRESS
ENTITY_KEY	System generated, unique, internal primary key for a constituent entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	ADDRESS
ENTITY_UID	System generated unique internal identification number assigned to this person or organization.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	ADDRESS
HOME_ADDRESS_IND	Indicates if this is a home address as classified by the HBS Address Type extract parameter.	NUMBER	EXPRESSION	HOME_ADDRESS_IND_EXPRESSION	NO	NO	ADDRESS
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	ADDRESS
POSTAL_KEY	System generated, unique, internal primary key for a postal zip code.	NUMBER	CLN_POSTAL	POSTAL_KEY	NO	NO	ADDRESS
PREFERRED_ADDRESS_IND	Indicates whether this is the preferred address.	NUMBER	EXPRESSION_1	PREFERRED_ADDRESS_IND_EXPRESSION	NO	NO	ADDRESS
PREFERRED_GEO_REGION_IND	Indicates whether this address is in the preferred Geographic Region address.	NUMBER	EXPRESSION	PREFERRED_GEO_REGION_IND_EXPRESSION	NO	NO	ADDRESS
PREF_ADDRESS_GROUP_KEY		NUMBER	NO SOURCE	NO SOURCE	NO	NO
SEASONAL_ADDRESS_EXISTS_IND	Indicates if the constituent has 1 or more current seasonal addresses.	NUMBER	EXPRESSION_1	SEASONAL_ADDRESS_EXISTS_IND_EXPRESSION	NO	NO	ADDRESS
SEASONAL_ADDRESS_IND	Indicates if this is a seasonal address as classified by the HBS Address Type extract parameter.	NUMBER	EXPRESSION	SEASONAL_ADDRESS_IND_EXPRESSION	NO	NO	ADDRESS
STREET_LINE_KEY	System generated, unique, internal primary key for street address.	NUMBER	CLN_STREET_ADDRESS	STREET_ADDRESS_KEY	NO	NO	ADDRESS
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'ADDRESS_F1B'	NO	NO	ADDRESS
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
XSEQUENCE	Sequence used to identify different addresses within the same address type.	NUMBER	EXPRESSION	XSEQUENCE_EXPRESSION	NO	NO	ADDRESS

Ver: 9.0