Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person.	NUMBER			APRACTY	APRACTY_ACTC_CODE	NO	NO
ACTIVITY	Activity	Activity recorded for the student or alumnus. Activities may include leadership councils, seminars, fraternity or sorority, chess or debate clubs, etc.	VARCHAR2(63)			APRACTY	APRACTY_ACTC_CODE	NO	NO
ACTIVITY_DESC	Activity Description	Student activity description.	VARCHAR2(255)			STVACTC	STVACTC_DESC	NO	NO
ACTIVITY_TYPE	Activity Type	Specifies a type of activity that is used to group like activites together for reporting.	VARCHAR2(63)			STVACTC	STVACTC_ACTP_CODE	NO	NO
ACTIVITY_TYPE_DESC	Activity Type Description	Activity type description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_CATEGORY	Activity Category	Specifies a grouping of activities that can be used for reporting like activites together.	VARCHAR2(63)			STVACTC	STVACTC_ACCG_CODE	NO	NO
ACTIVITY_CATEGORY_DESC	Activity Category Description	Activity category description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR1	Participation Year 1	Organization-oriented identifier used to determine access authorization to this record. Institution defined.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC1	Participation Year Description 1	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR2	Participation Year 2	Year that the person participated in the activity recorded.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC2	Participation Year Description 2	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR3	Participation Year 3	Year that the person participated in the activity recorded.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC3	Participation Year Description 3	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR4	Participation Year 4	Year that the person participated in the activity recorded.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC4	Participation Year Description 4	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR5	Participation Year 5	Year that the person participated in the activity recorded.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC5	Participation Year Description 5	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR6	Participation Year 6	Year that the person participated in the activity recorded.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC6	Participation Year Description 6	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR7	Participation Year 7	Year that the person participated in the activity recorded.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC7	Participation Year Description 7	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR8	Participation Year 8	Year that the person participated in the activity recorded.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC8	Participation Year Description 8	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR9	Participation Year 9	Year that the person participated in the activity recorded.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC9	Participation Year Description 9	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
PARTICIPATION_YEAR10	Participation Year 10	Year that the person participated in the activity recorded.	VARCHAR2(63)			APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC10	Participation Year Description 10	Participation year description.	VARCHAR2(255)			NA	NA	NO	NO
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE			NA	SYSDATE	NO	NO

Ver: 9.2