Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CONST_EMPLOYMENT_JOB_KEY		NUMBER				NO
EMPLOYMENT_DATA_SOURCE	The source from which the employment data originated.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
EMPLOYMENT_DATA_SOURCE_LD	The long description for the data source	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
EMPLOYMENT_DATA_SOURCE_SD	The short description for the data source	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
EMPLOYMENT_STATUS	Current employment status with this employer.	VARCHAR2(63)	APREHIS	APREHIS_EMPS_CODE	NO	NO	CONSTITUENT EMPLOYMENT
EMPLOYMENT_STATUS_LD	The long description for the employment Status Code	VARCHAR2(255)	ATVEMPS	ATVEMPS_DESC	NO	NO	CONSTITUENT EMPLOYMENT
EMPLOYMENT_STATUS_SD	The short description for the employment Status Code	VARCHAR2(255)	ATVEMPS	ATVEMPS_DESC	NO	NO	CONSTITUENT EMPLOYMENT
JOB_ID	System generated, unique, internal primary key for an employment record.	VARCHAR2(63)	LKP_EXPRESSION	JOB_ID_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
JOB_TITLE	The constituent's job title.	VARCHAR2(63)	LKP_EXPRESSION	JOB_TITLE_EXPRESSION	NO	NO	CONSTITUENT EMPLOYMENT
NATURE_OF_BUSINESS	This text field describes the nature of the business associated with this constituent and organization.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
OCCUPATIONAL_NAME	Occupational name of the constituent for this employment.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PLACE_OF_WORK	Identifies where this constituent works (main headquarters, division, etc.).	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PLACE_OF_WORK_LD	Long description for the constituent's place of work.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PLACE_OF_WORK_SD	Short description for the constituent's place of work.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
POSITION_COMMENT	Description of how the constituent describes their position within the employment	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'CONSTITUENT_EMPLOYMENT_JOB_D1B'	NO	NO	CONSTITUENT EMPLOYMENT
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