Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_PLEDGE_ASSOCIATED_ENTITY

Description List of all entities and related information associated with a pledge or payment.
Key & Frequency One row per entity per pledge per associated entity.

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

 


Ver: 8.3