Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
COMMENTS	Free form text of any comments from the reference.	VARCHAR2(4000)	PPRREFE	PPRREFE_COMMENT	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
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	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the reference.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PPRREFE	PPRREFE_PIDM	NO	NO
PHONE_AREA	Area code of the reference.	VARCHAR2(63)	PPRREFE	PPRREFE_PHONE_AREA	NO	NO
PHONE_EXTENSION	Phone extension of the reference.	VARCHAR2(63)	PPRREFE	PPRREFE_PHONE_EXT	NO	NO
PHONE_NUMBER	Phone number of the reference.	VARCHAR2(63)	PPRREFE	PPRREFE_PHONE_NUMBER	NO	NO
PHONE_NUMBER_COMBINED	All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.	VARCHAR2(63)	CALCULATION	SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
REFERENCE_NAME	Name of the Reference.	VARCHAR2(63)	PPRREFE	PPRREFE_NAME	NO	NO

Ver: 9.2