Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ASSOCIATED_ADDRESS_TYPE	Address type code for the entity associated with this gift.	VARCHAR2(63)	AGRGASC	AGRGASC_ATYP_CODE	NO	NO
ASSOCIATED_ADDRESS_TYPE_DESC	Description for the associated address type.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ASSOCIATED_CARRIER_ROUTE	Address carrier route of the associated entity's address.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
ASSOCIATED_CITY	Address, city, town or municipality of the associated entity's address.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
ASSOCIATED_CORRECTION_DIGIT	Address correction digit.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
ASSOCIATED_COUNTY	County of the associated entity's address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
ASSOCIATED_COUNTY_DESC	County address name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ASSOCIATED_DELIVERY_POINT	Address delivery point of the associated entity's address.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
ASSOCIATED_ENTITY_IND	Indicates whether the entity is a person or an organization.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_ENTITY_UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER	AGRGASC	AGRGASC_ASSC_PIDM	NO	NO
ASSOCIATED_FIRST_NAME	First name of the associated person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_ID	Associated person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_LAST_NAME	Name of the associated organization or last name of the associated person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_MIDDLE_NAME	Middle name of the associated person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_NAME_PREFIX	Prefix used before associated person's name.	VARCHAR2(20)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_NAME_SUFFIX	Suffix for the associated person's name.	VARCHAR2(20)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_NATION	Nation/country code of the associated entity's address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
ASSOCIATED_NATION_DESC	Address' nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
ASSOCIATED_POSTAL_CODE	Address postal code of the associated entity.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
ASSOCIATED_STATE_PROVINCE	State or province of the associated entity's address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
ASSOCIATED_STATE_PROVINCE_DESC	State/province description.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
ASSOCIATED_STREET_LINE1	First line of the associated entity's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
ASSOCIATED_STREET_LINE2	Second line of the associated entity's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
ASSOCIATED_STREET_LINE3	Third line of the associated entity's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
ASSOCIATED_STREET_LINE4	Fourth line of the associated entity's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
ASSOCIATION	The type of gift association related to this entity.	VARCHAR2(63)	AGRGASC	AGRGASC_ASSC_CODE	NO	NO
ASSOCIATION_COMMENT	Comments related to the gift association.	VARCHAR2(255)	AGRGASC	AGRGASC_COMMENT	NO	NO
ASSOCIATION_DATE	Date the gift was associated to this entity.	DATE	AGRGASC	AGRGASC_ASSC_DATE	NO	NO
ASSOCIATION_DESC	The description of the association code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ENTITY_IND	Indicates whether entity is a person or an organization.	VARCHAR2(1)	CONSTANT CONSTANT	'O' 'P'	NO NO	NO
ENTITY_UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER	AGRGASC	AGRGASC_PIDM	NO	NO
GIFT_NUMBER	Gift number to which the entity is associated.	VARCHAR2(63)	AGRGASC	AGRGASC_GIFT_NO	NO	NO
GIFT_VOID_IND	Indicates if the gift has been voided.	VARCHAR2(1)	FUNCTION	AOKODSF.F_GET_VOID_IND	NO	NO
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
MULTI_SOURCE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (LFMI) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PROCESS_GROUP	The institution value of the process-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2