Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
SPECIAL_PURPOSE_TYPE	Classifies a person or organization by a special purpose group type.	VARCHAR2(63)	APRPROS	APRPROS_PRTP_CODE	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_TYPE_KEY	System generated, unique, internal primary key for a special purpose type.	NUMBER				NO
SPECIAL_PURPOSE_TYPE_LD	Special purpose type long description.	VARCHAR2(255)	ATVPRTP	ATVPRTP_DESC	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_TYPE_SD	Special purpose type short description.	VARCHAR2(255)	ATVPRTP	ATVPRTP_DESC	NO	NO	SPECIAL PURPOSE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'SPECIAL_PURPOSE_TYPE_D1B'	NO	NO	SPECIAL PURPOSE
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