Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: GIFT_ASSOCIATED_ENTITY

Description Contains all entities associated with a gift or payment including description, comments and details for an active associated entity address if applicable. .
Key & Frequency One row per entity per gift number per association per associated UID.
Recommended Search Columns ENTITY_UID, GIFT_NUMBER
ASSOCIATED_ENTITY_UID
ASSOCIATION
GIFT_NUMBER
ADDRESS_TYPE
ENTITY_UID, ADDRESS_TYPE

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    

AGRGASC

AGRGASC_PIDM

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
NAME Name Name of the person (LFMI) or organization. VARCHAR2(255)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ENTITY_IND Entity Indicator Indicates whether entity is a person or an organization. VARCHAR2(1)    

CONSTANT

CONSTANT

'O'

'P'

NO

NO

NO
GIFT_NUMBER Gift Number Gift number to which the entity is associated. VARCHAR2(63)    

AGRGASC

AGRGASC_GIFT_NO

NO

NO
GIFT_VOID_IND Gift Void Indicator Indicates if the gift has been voided. VARCHAR2(1)    

FUNCTION

AOKODSF.F_GET_VOID_IND

NO

NO
ASSOCIATION Association The type of gift association related to this entity. VARCHAR2(63)    

AGRGASC

AGRGASC_ASSC_CODE

NO

NO
ASSOCIATION_DESC Association Description The description of the association code. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ASSOCIATION_COMMENT Association Comment Comments related to the gift association. VARCHAR2(255)    

AGRGASC

AGRGASC_COMMENT

NO

NO
ASSOCIATED_ADDRESS_TYPE 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 Associated Address Type Description Description for the associated address type. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ASSOCIATION_DATE Association Date Date the gift was associated to this entity. DATE    

AGRGASC

AGRGASC_ASSC_DATE

NO

NO
ASSOCIATED_ENTITY_UID Associated Entity UID System generated unique internal identification number assigned to this person or organization entity. NUMBER    

AGRGASC

AGRGASC_ASSC_PIDM

NO

NO
ASSOCIATED_ID Associated ID Associated person's or organization's current identification number. VARCHAR2(63)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ASSOCIATED_ENTITY_IND Associated Entity Indicator Indicates whether the entity is a person or an organization. VARCHAR2(1)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ASSOCIATED_LAST_NAME 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_FIRST_NAME Associated First Name First name of the associated person. VARCHAR2(63)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ASSOCIATED_MIDDLE_NAME Associated Middle Name Middle name of the associated person. VARCHAR2(63)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ASSOCIATED_NAME_PREFIX Associated Name Prefix Prefix used before associated person's name. VARCHAR2(20)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ASSOCIATED_NAME_SUFFIX Associated Name Suffix Suffix for the associated person's name. VARCHAR2(20)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ASSOCIATED_STREET_LINE1 Associated Street Line 1 First line of the associated entity's address. VARCHAR2(255)    

SPRADDR

SPRADDR_STREET_LINE1

NO

NO
ASSOCIATED_STREET_LINE2 Associated Street Line 2 Second line of the associated entity's address. VARCHAR2(255)    

SPRADDR

SPRADDR_STREET_LINE2

NO

NO
ASSOCIATED_STREET_LINE3 Associated Street Line 3 Third line of the associated entity's address. VARCHAR2(255)    

SPRADDR

SPRADDR_STREET_LINE3

NO

NO
ASSOCIATED_STREET_LINE4 Associated Street Line 4 Fourth line of the associated entity's address. VARCHAR2(255)    

SPRADDR

SPRADDR_STREET_LINE4

NO

NO
ASSOCIATED_CITY Associated City Address, city, town or municipality of the associated entity's address. VARCHAR2(63)    

SPRADDR

SPRADDR_CITY

NO

NO
ASSOCIATED_COUNTY Associated County County of the associated entity's address. VARCHAR2(63)    

SPRADDR

SPRADDR_CNTY_CODE

NO

NO
ASSOCIATED_COUNTY_DESC Associated County Description County address name. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ASSOCIATED_STATE_PROVINCE Associated State Province State or province of the associated entity's address. VARCHAR2(63)    

SPRADDR

SPRADDR_STAT_CODE

NO

NO
ASSOCIATED_STATE_PROVINCE_DESC Associated State Province Description State/province description. VARCHAR2(255)    

STVSTAT

STVSTAT_DESC

NO

NO
ASSOCIATED_POSTAL_CODE Associated Postal Code Address postal code of the associated entity. VARCHAR2(63)    

SPRADDR

SPRADDR_ZIP

NO

NO
ASSOCIATED_NATION Associated Nation Nation/country code of the associated entity's address. VARCHAR2(63)    

SPRADDR

SPRADDR_NATN_CODE

NO

NO
ASSOCIATED_NATION_DESC Associated Nation Description Address' nation/country description. VARCHAR2(255)    

STVNATN

STVNATN_NATION

NO

NO
ASSOCIATED_DELIVERY_POINT Associated Delivery Point Address delivery point of the associated entity's address. NUMBER    

SPRADDR

SPRADDR_DELIVERY_POINT

NO

NO
ASSOCIATED_CORRECTION_DIGIT Associated Correction Digit Address correction digit. NUMBER    

SPRADDR

SPRADDR_CORRECTION_DIGIT

NO

NO
ASSOCIATED_CARRIER_ROUTE Associated Carrier Route Address carrier route of the associated entity's address. VARCHAR2(4)    

SPRADDR

SPRADDR_CARRIER_ROUTE

NO

NO
MULTI_SOURCE 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 Multi Source Description 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
PROCESS_GROUP 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
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


Ver: 9.2