ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACTIVITY_DATE	Date this record was entered or last updated in the system.			AGRPASC	AGRPASC_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.			NA	NA
ASSOCIATED_ADDRESS_TYPE	The Address Type Code associated with this association.			AGRPASC	AGRPASC_ATYP_CODE
ASSOCIATED_ADDRESS_TYPE_DESC	Address type description.			STVATYP	STVATYP_DESC
ASSOCIATED_CARRIER_ROUTE	Address carrier route of the associated entity's address.			SPRADDR	SPRADDR_CARRIER_ROUTE
ASSOCIATED_CITY	Address, city, town or municipality of the associated entity's address.			SPRADDR	SPRADDR_CITY
ASSOCIATED_CORRECTION_DIGIT	Address correction digit.			SPRADDR	SPRADDR_CORRECTION_DIGIT
ASSOCIATED_COUNTY	County of the associated entity's address.			SPRADDR	SPRADDR_CNTY_CODE
ASSOCIATED_COUNTY_DESC	County address name.			STVCNTY	STVCNTY_DESC
ASSOCIATED_DELIVERY_POINT	Address delivery point of the associated entity's address.			SPRADDR	SPRADDR_DELIVERY_POINT
ASSOCIATED_ENTITY_IND	Indicates whether associated entity is a person or an organization.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ASSOCIATED_ENTITY_UID	System generated unique internal identification number assigned to this person or organization entity.			AGRPASC	AGRPASC_ASSC_PIDM
ASSOCIATED_FIRST_NAME	Indicates the first name of the associated entity.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ASSOCIATED_ID	Associated person's or organization's current identification number.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ASSOCIATED_LAST_NAME	Indicates the last name of the associated entity.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ASSOCIATED_MIDDLE_NAME	Indicates the middle name of the associated entity.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ASSOCIATED_NAME_PREFIX	Indicates the prefix of the associated entity.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ASSOCIATED_NAME_SUFFIX	Indicates the suffix of the associated entity.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ASSOCIATED_NATION	Nation/country code of the associated entity's address.			SPRADDR	SPRADDR_NATN_CODE
ASSOCIATED_NATION_DESC	Address' nation/country description.			STVNATN	STVNATN_NATION
ASSOCIATED_POSTAL_CODE	Address postal code of the associated entity.			SPRADDR	SPRADDR_ZIP
ASSOCIATED_STATE_PROVINCE	State or province of the associated entity's address.			SPRADDR	SPRADDR_STAT_CODE
ASSOCIATED_STATE_PROVINCE_DESC	State/province description.			STVSTAT	STVSTAT_DESC
ASSOCIATED_STREET_LINE1	First line of the associated entity's address.			SPRADDR	SPRADDR_STREET_LINE1
ASSOCIATED_STREET_LINE2	Second line of the associated entity's address.			SPRADDR	SPRADDR_STREET_LINE2
ASSOCIATED_STREET_LINE3	Third line of the associated entity's address.			SPRADDR	SPRADDR_STREET_LINE3
ASSOCIATED_STREET_LINE4	Fourth line of the associated entity's address.			SPRADDR	SPRADDR_STREET_LINE4
ASSOCIATION	The type of pledge association related to this entity.			AGRPASC	AGRPASC_ASSC_CODE
ASSOCIATION_COMMENT	Comments related to the pledge association.			AGRPASC	AGRPASC_COMMENT
ASSOCIATION_DATE	Date the gift was associated to this entity.			AGRPASC	AGRPASC_ASSC_DATE
ASSOCIATION_DESC	Pledge association description.			ATVASSC	ATVASSC_DESC
ENTITY_IND	Indicates whether entity is a person or an organization.			FUNCTION	MAKFUNC.F_GET_ENTITY_IND
ENTITY_UID	System generated unique internal identification number assigned to this person or organization entity.			AGRPASC	AGRPASC_PIDM
ID	Person's or organization's current identification number.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.			NA	NA
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.			NA	NA
NAME	Name of the person (LFMI) or organization.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PLEDGE_NUMBER	Pledge number to which the entity is associated.			AGRPASC	AGRPASC_PLEDGE_NO
PROCESS_GROUP	The institution value of the process-oriented identifier for the record used to determine access authorization to this record.			NA	NA
USER_ID	Unique identification code of the user who entered or last touched the transaction.			AGRPASC	AGRPASC_USER

Ver: 8.3