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			AMRINFO	AMRINFO_PIDM	NO	NO
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)			CONSTANT CONSTANT	'O' 'P'	NO 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
REFERENCE	Reference	Reference code.	VARCHAR2(63)			AMRINFO	AMRINFO_REFR_CODE	NO	NO
REFERENCE_DESC	Reference Description	Reference code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	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
PROSPECT_STATUS	Prospect Status	Identifies the reference assessment of the current state of the prospect.	VARCHAR2(63)			AMRINFO	AMRINFO_STATUS	NO	NO
PROSPECT_AMOUNT	Prospect Amount	Manually entered or system calculated prospect amount.	NUMBER			AMRINFO	AMRINFO_PROSP_RATE	NO	NO
TARGET_ASK_DATE	Target Ask Date	Manually entered target asking date.	DATE			AMRINFO	AMRINFO_TARGET_ASK_DATE	NO	NO
PRIMARY_STAFF_ASSIGN_TYPE	Primary Staff Assign Type	Primary staff type code.	VARCHAR2(63)			AMRSTAF	AMRSTAF_STFT_CODE	NO	NO
PRIMARY_STAFF_ASSIGN_TYPE_DESC	Primary Staff Assign Type Description	Primary staff type code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PRIMARY_STAFF_ASSIGN_IDEN	Primary Staff Assign ID	Primary staff identification code.	VARCHAR2(63)			AMRSTAF	AMRSTAF_IDEN_CODE	NO	NO
PRIMARY_STAFF_ASSIGN_IDEN_NAME	Primary Staff Assign ID Name	Name of the primary staff identification code.	VARCHAR2(255)			GURIDEN	GURIDEN_DESC	NO	NO
STAFF_ASSIGNMENT_COUNT	Staff Assignment Count	Count of staff assignments.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_STAFF_ASSIGNMENT	NO	NO
ADVANCEMENT_RATING_COUNT	Advancement Rating Count	Count of the recruitment ratings recorded for this person.	NUMBER			FUNCTION	MAKFUNC.F_ADVANCEMENT_RATING_COUNT	NO	NO
CONSTITUENT_CONTACT_COUNT	Constituent Contact Count	Count of the number of counts have been made by the institution and recorded for this constituent.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_CONS_CONTACT	NO	NO
PREF_GEO_REGION_ADDR_TYPE	Pref Geo Region Addr Type	Address type of the address to be used as the preferred geographic region address.	VARCHAR2(63)			APBCONS	APBCONS_ATYP_CODE_GEOR	NO	NO
PREF_GEO_REGION_ADDR_TYPE_DESC	Pref Geo Region Addr Type Description	Preferred geographic region address type.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PREF_GEOGRAPHIC_REGION_COUNT	Pref Geographic Region Count	Count of geographic regions associated with this address.	NUMBER			FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS	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
REFERENCE_COMMENT	Reference Comment	Prospect reference comment.	VARCHAR2(255)			AMRINFO	AMRINFO_REFERENCE	NO	NO
PROSPECT_STATUS_DESC	Prospect Status Description	Status description.	VARCHAR2(255)			ATVPRST	ATVPRST_DESC	NO	NO
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	NO	NO
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	NO	NO
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')	NO	NO
PROSPECT_AMOUNT_METHOD	Prospect Amount Method	Determines the method for calculating the prospect amount.	VARCHAR2(63)			AMRINFO	AMRINFO_SYS_IND	NO	NO
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(255)			FUNCTION	CASE WHEN AMRINFO_SYS_IND	NO	NO
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')	NO	NO
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')	NO	NO
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE			AMRINFO	AMRINFO_ACTIVITY_DATE	NO	NO

Ver: 9.2