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
|