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
|
|
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_ENTITY_UID
|
System generated unique internal identification number assigned to this person or organization entity.
|
|
|
AGRPASC
|
AGRPASC_ASSC_PIDM
|
|
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
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
|
|
NA
|
SYSDATE
|
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
|
|
NA
|
NA
|
|
ENTITY_UID
|
System generated unique internal identification number assigned to this person or organization entity.
|
|
|
AGRPASC
|
AGRPASC_PIDM
|
|
MIF_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
|
|
MIF_VALUE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
|
|
NA
|
NA
|
|
PLEDGE_NUMBER
|
Pledge number to which the entity is associated.
|
|
|
AGRPASC
|
AGRPASC_PLEDGE_NO
|
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
|
|
AGRPASC
|
AGRPASC_USER
|
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
|
|
NA
|
NA
|
|