Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
COMBINED_PHONE	Combined Phone	Complete telephone number for the person that combines the telephone area, number and extension.	VARCHAR2(28)		CALCULATION	PPRREFE_PHONE_AREA||PPRREFE_PHONE_NUMBER||PPRREFE_PHONE_EXT
COMMENTS		Free form text of any comments from the reference.	VARCHAR2(4000)		PPRREFE	PPRREFE_COMMENT
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
NAME		Name of the reference.	VARCHAR2(60)		PPRREFE	PPRREFE_NAME
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		PPRREFE	PPRREFE_PIDM
PHONE_AREA	Phone Area	Area code of the reference.	VARCHAR2(6)		PPRREFE	PPRREFE_PHONE_AREA
PHONE_EXTENSION	Phone Extension	Phone extension of the reference.	VARCHAR2(10)		PPRREFE	PPRREFE_PHONE_EXT
PHONE_NUMBER	Phone Number	Phone number of the reference.	VARCHAR2(12)		PPRREFE	PPRREFE_PHONE_NUMBER
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: