Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
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
ENTITY_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		AMREXRT AMRPRRT	AMREXRT_PIDM AMRPRRT_PIDM
INTERNAL_IND		Identifies whether the person rating the donor is internal.	VARCHAR2(1)		CONSTANT	DATA SOURCE IS AMRPRRT THEN 'Y'; DATA SOURCE IS AMREXRT THEN 'N'
MIF_DESC		Institution description for the record 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
PRIMARY_IND		Indicates which rate code is primary.	VARCHAR2(1)		AMRPRRT	AMRPRRT_PRIMARY_IND
RATER_NAME	Rater Name	Name of the individual doing the Advancement rating.	VARCHAR2(60)		GURIDEN	GURIDEN_DESC
RATER_UID		Internal identification number of the person associated with the rating.	VARCHAR2(40)		CALCULATION	DECODE(AMRPRRT_RATING_PIDM,NULL,AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM)
RATING		Rate code.	VARCHAR2(4)		AMREXRT AMRPRRT	AMREXRT_EXT_VALUE AMRPRRT_RATE_CODE
RATING_AMOUNT		Rate amount of the rate code.	VARCHAR2(40)		AMREXRT ATVRATE	AMREXRT_EXT_SCORE ATVRATE_RATE_AMT
RATING_DATE		Date this record was created or updated.	DATE		AMREXRT AMRPRRT	AMREXRT_ACTIVITY_DATE AMRPRRT_ACTIVITY_DATE
RATING_DESC		Rate description.	VARCHAR2(30)		ATVRATE	ATVRATE_DESC
RATING_LEVEL		Matching level of external source code.	VARCHAR2(4)		AMREXRT	AMREXRT_EXT_LEVEL
RATING_TYPE		Rating type code.	VARCHAR2(5)		AMREXRT AMRPRRT	AMREXRT_EXRS_CODE AMRPRRT_RTGT_CODE
RATING_TYPE_DESC		Rate type description.	VARCHAR2(30)		ATVEXRS ATVRTGT	ATVEXRS_DESC ATVRTGT_DESC
SCREENING		Screening code.	VARCHAR2(5)		AMRPRRT	AMRPRRT_RSCR_CODE
SCREENING_DESC		Rating screen description.	VARCHAR2(30)		ATVRSCR	ATVRSCR_DESC
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: