Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
COMMENTS	Free form text of any comments from the reference.	VARCHAR2(4000)	PPRREFE	PPRREFE_COMMENT
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
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the reference.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PPRREFE	PPRREFE_PIDM
PHONE_AREA	Area code of the reference.	VARCHAR2(63)	PPRREFE	PPRREFE_PHONE_AREA
PHONE_EXTENSION	Phone extension of the reference.	VARCHAR2(63)	PPRREFE	PPRREFE_PHONE_EXT
PHONE_NUMBER	Phone number of the reference.	VARCHAR2(63)	PPRREFE	PPRREFE_PHONE_NUMBER
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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REFERENCE_NAME	Name of the Reference.	VARCHAR2(63)	PPRREFE	PPRREFE_NAME

Ver: 9.1