Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVE_PROSPECT_IND	Active Prospect Indicator	Prospect status active indicator determining if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)		ATVPRST	ATVPRST_ACTIVE_IND
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE		AMRINFO	AMRINFO_ACTIVITY_DATE
ALLOW_WEB_GIFT_IND	Allow Web Gift Indicator	Determines if gifts from this prospect will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web.	VARCHAR2(1)		CALCULATION	NVL(AMRINFO_WEB_GIFT_IND,'N')
ALLOW_WEB_PLEDGE_IND	Allow Web Pledge Indicator	Determines if pledges from this prospect will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web.	VARCHAR2(1)		CALCULATION	NVL(AMRINFO_WEB_PLDG_IND,'N')
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)		AMRINFO	AMRINFO_PIDM
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
PREF_GEO_REGION_ADDR_TYPE		Address type of the address to be used as the preferred geographic region address.	VARCHAR2(2)		APBCONS	APBCONS_ATYP_CODE_GEOR
PREF_GEO_REGION_ADDR_TYPE_DESC		Preferred geographic region address type.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_STAFF_ASSIGN_IDEN_CODE		Primary staff identification code.	VARCHAR2(5)		AMRSTAF	AMRSTAF_IDEN_CODE
PRIMARY_STAFF_ASSIGN_IDEN_DESC		Name of the primary staff identification code.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_STAFF_ASSIGN_TYPE		Primary staff type code.	VARCHAR2(4)		AMRSTAF	AMRSTAF_STFT_CODE
PRIMARY_STAFF_ASSIGN_TYPE_DESC		Primary staff type code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PROSPECT_AMOUNT		Manually entered or system calculated prospect amount.	NUMBER(11, 2)		AMRINFO	AMRINFO_PROSP_RATE
PROSPECT_AMOUNT_ENTRY_DATE	Prospect Amount Entry Date	Date the rating amount for the prospect was calculated or entered.	DATE		AMRINFO	AMRINFO_RATE_ENTRY_DATE
PROSPECT_AMOUNT_METHOD	Prospect Amount Method	Determines the method for calculating the prospect amount.	VARCHAR2(1)		AMRINFO	AMRINFO_SYS_IND
PROSPECT_AMOUNT_METHOD_DESC	Prospect Amount Method Description	Prospect amount method description. Explains how the prospect asking amount is calculated. If the value is 'N', the amount is manually entered and cannot be overridden. If the value is 'S', the amount is system calculated either from a primary indicated rate, or weighted-average of rate values.	VARCHAR2(30)		FUNCTION	CASE WHEN AMRINFO_SYS_IND
PROSPECT_STATUS		Status.	VARCHAR2(6)		AMRINFO	AMRINFO_STATUS
PROSPECT_STATUS_DESC	Prospect Status Description	Prospect status description.	VARCHAR2(30)		ATVPRST	ATVPRST_DESC
REFERENCE		Reference code.	VARCHAR2(2)		AMRINFO	AMRINFO_REFR_CODE
REFERENCE_COMMENT	Reference Comment	Prospect reference comment.	VARCHAR2(30)		AMRINFO	AMRINFO_REFERENCE
REFERENCE_DESC		Reference code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
SOLICITOR_IND	Solicitor Indicator	Determines if the staff person is a solicitor (Y)es or not a solicitor (N)o.	VARCHAR2(1)		CALCULATION	NVL(AMRSTAF_SOLICIT_IND,'N')
TARGET_ASK_DATE		Manually entered target asking date.	DATE		AMRINFO	AMRINFO_TARGET_ASK_DATE
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: