Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CONST_EMPLOYMENT_COUNT_KEY		NUMBER	GROUP_KEY_EXPRESSION	CONST_EMPLOYMENT_COUNT_KEY_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
CONST_EMPLOYMENT_GROUP_KEY		NUMBER	GROUP_KEY_EXPRESSION	CONST_EMPLOYMENT_GROUP_KEY_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
CONST_EMPLOYMENT_JOB_KEY		NUMBER	CLN_CONST_EMPLOYMENT_JOB	CONST_EMPLOYMENT_JOB_KEY	NO	NO	CONSTITUENT EMPLOYMENT
CONST_EMPLOYMENT_POSITION_KEY		NUMBER	CONSTANT_0	0	NO	NO	CONSTITUENT EMPLOYMENT
COOP_INTERN_IND	Indicates employment is an internship or a cooperative education experience.	NUMBER	EXPRESSION	COOP_INTERN_IND_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
CURRENT_EMPLOYMENT_IND	Indicates if this is a current employment association.	NUMBER	EXPRESSION	CURRENT_EMPLOYMENT_IND_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
EMPLOYEE_START_DATE	Start date of this employment or affiliation	DATE	EXPRESSION	EMPLOYEE_START_DATE_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
EMPLOYEE_START_DATE_PARTIAL	Start date of this employment or affiliation	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
EMPLOYEE_STOP_DATE	Stop date of this employment or affiliation	DATE	EXPRESSION	EMPLOYEE_STOP_DATE_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
EMPLOYEE_STOP_DATE_PARTIAL	Stop date of this employment or affiliation	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
EMPLOYEE_WEEKLY_HRS	Hours worked per week; for part time employees, used in matching gift qualification.	NUMBER	APREHIS	APREHIS_WKLY_HOURS	NO	NO	CONSTITUENT EMPLOYMENT
EMPLOYER_ENTITY_IND	Indicates if this employer is an entity cross referenced to the constituent.	NUMBER	EXPRESSION	EMPLOYER_ENTITY_IND_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
EMPLOYER_KEY		NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	CONSTITUENT EMPLOYMENT
EMPLOYER_UID	System generated unique internal identification number assigned to the employing organization for the constituent, only if the organization has a record in the database.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	CONSTITUENT EMPLOYMENT
EMPLR_REL_ACTIVE_IND	Indicates if the employee/employer relationship is active.	NUMBER	CONSTANT_0	1	NO	NO	CONSTITUENT EMPLOYMENT
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	CONSTITUENT EMPLOYMENT
ENTITY_UID	System generated unique internal identification number assigned to this constituent or organization.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	CONSTITUENT EMPLOYMENT
MATCH_STATUS_IND		NUMBER	EXPRESSION	MATCH_STATUS_IND_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
MULTI_SOURCE_KEY		NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	CONSTITUENT EMPLOYMENT
NON_ENTITY_RELATION_KEY		NUMBER	CLN_NON_ENTITY_RELATION	NON_ENTITY_RELATION_KEY	NO	NO	CONSTITUENT EMPLOYMENT
PRIMARY_EMPLOYMENT_IND	Indicates if this is the primary employment association.	NUMBER	EXPRESSION	PRIMARY_EMPLOYMENT_IND_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
RELATIONSHIP_KEY		NUMBER	CLN_EMPLOYMENT_RELATIONSHIP	EMPLOYMENT_RELATIONSHIP_KEY	NO	NO	CONSTITUENT EMPLOYMENT
RETIRED_IND	Parameter Map - based on Employment Status codes	NUMBER	RETIRED_IND_EXPR	RETIRED_IND_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
SELF_EMPLOYED_IND	Indicates self-employment.	NUMBER	CONSTANT_0	1	NO	NO	CONSTITUENT EMPLOYMENT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	LOAD_PROCESS	'CONSTITUENT_EMPLOYMENT_F1B'	NO	NO	CONSTITUENT EMPLOYMENT
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