Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ADVANCEMENT_RATING_COUNT	Count of the recruitment ratings recorded for this person.	NUMBER	FUNCTION	MAKFUNC.F_ADVANCEMENT_RATING_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
ENTITY_IND	Indicates whether the entity is a person or an organization.	VARCHAR2(1)	CONSTANT CONSTANT	'O' 'P'
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AMRINFO	AMRINFO_PIDM
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PREF_GEOGRAPHIC_REGION_COUNT	Count of geographic regions associated with this address.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS
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
PREF_GEO_REGION_ADDR_TYPE_DESC	Preferred geographic region address type.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_STAFF_ASSIGN_IDEN	Primary staff identification code.	VARCHAR2(63)	AMRSTAF	AMRSTAF_IDEN_CODE
PRIMARY_STAFF_ASSIGN_IDEN_NAME	Name of the primary staff identification code.	VARCHAR2(255)	GURIDEN	GURIDEN_DESC
PRIMARY_STAFF_ASSIGN_TYPE	Primary staff type code.	VARCHAR2(63)	AMRSTAF	AMRSTAF_STFT_CODE
PRIMARY_STAFF_ASSIGN_TYPE_DESC	Primary staff type code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROSPECT_AMOUNT	Manually entered or system calculated prospect amount.	NUMBER	AMRINFO	AMRINFO_PROSP_RATE
PROSPECT_STATUS	Status.	VARCHAR2(63)	AMRINFO	AMRINFO_STATUS
REFERENCE	Reference code.	VARCHAR2(63)	AMRINFO	AMRINFO_REFR_CODE
REFERENCE_DESC	Reference code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
STAFF_ASSIGNMENT_COUNT	Count of staff assignments.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_STAFF_ASSIGNMENT
TARGET_ASK_DATE	Manually entered target asking date.	DATE	AMRINFO	AMRINFO_TARGET_ASK_DATE

Ver: 8.1