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 or organization entity.	NUMBER			AMREXRT AMRPRRT	AMREXRT_PIDM AMRPRRT_PIDM	NO NO	NO
INTERNAL_IND	Internal Indicator	Identifies whether the person rating the donor is internal.	VARCHAR2(1)			CONSTANT	DATA SOURCE IS AMRPRRT THEN 'Y'; DATA SOURCE IS AMREXRT THEN 'N'	NO	NO
ID	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
RATING_TYPE	Rating Type	Rating type.	VARCHAR2(63)			AMREXRT AMRPRRT	AMREXRT_EXRS_CODE AMRPRRT_RTGT_CODE	NO NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
RATING_TYPE_DESC	Rating Type Description	Rating type description.	VARCHAR2(255)			ATVEXRS ATVRTGT	ATVEXRS_DESC ATVRTGT_DESC	NO NO	NO
RATING	Rating	Rating.	VARCHAR2(63)			AMREXRT AMRPRRT	AMREXRT_EXT_VALUE AMRPRRT_RATE_CODE	NO NO	NO
RATING_DESC	Rating Description	Rating description.	VARCHAR2(255)			ATVRATE	ATVRATE_DESC	NO	NO
RATING_AMOUNT	Rating Amount	Targeted or potential 'ask' or dollar amount associated with this rating code.	VARCHAR2(63)			AMREXRT ATVRATE	AMREXRT_EXT_SCORE ATVRATE_RATE_AMT	NO NO	NO
SCREENING	Screening	Screening method.	VARCHAR2(63)			AMRPRRT	AMRPRRT_RSCR_CODE	NO	NO
SCREENING_DESC	Screening Description	Screening method description.	VARCHAR2(255)			ATVRSCR	ATVRSCR_DESC	NO	NO
PRIMARY_IND	Primary Indicator	Indicates which rate code is primary.	VARCHAR2(1)			AMRPRRT	AMRPRRT_PRIMARY_IND	NO	NO
RATER_UID	Rater UID	System generated, unique, internal identification number assigned to this rater.	VARCHAR2(63)			CALCULATION	DECODE(AMRPRRT_RATING_PIDM,NULL,AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM)	NO	NO
RATER_NAME	Rater Name	Name of the individual doing the advancement rating.	VARCHAR2(255)			GURIDEN	GURIDEN_DESC	NO	NO
RATING_LEVEL	Rating Level	Matching level of external source.	VARCHAR2(63)			AMREXRT	AMREXRT_EXT_LEVEL	NO	NO
RATER_ID	Rater ID	Rater's current identification number.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
RATING_DATE	Rating Date	Date this record was created or updated.	DATE			AMREXRT AMRPRRT	AMREXRT_ACTIVITY_DATE AMRPRRT_ACTIVITY_DATE	NO 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

Ver: 9.2