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_CONDITIONAL

Description Contains information pertaining to conditional pledges.
Key & Frequency One row per pidm per pledge number per sequence number.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE Date Pledge Condition was created or last updated.    

AGRPCON

AGRPCON_ACTIVITY_DATE

 
CONDITION_COMMENT Comments related to this pledge condition record.    

FUNCTION

GOKODSF.F_TRIM_LONGS

 
CONDITION_DATE Date the Pledge Condition was met or complied with.    

AGRPCON

AGRPCON_MET_DATE

 
CONDITION_MET Indicates if the Pledge Condition has been met.    

AGRPCON

AGRPCON_MET_IND

 
CONDITION_MET_DESC Description of the condition met.    

CALCULATION

DECODE(AGRPCON_MET_IND)

 
CONDITION_TYPE Pledge Condition Type Code.    

AGRPCON

AGRPCON_CTYP_CODE

 
CONDITION_TYPE_DESC Description of the Pledge condition type.    

FUNCTION

ATVCTYP_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.    

AGRPCON

AGRPCON_PIDM

 
EXPECTED_CONDITION_DATE Date the Pledge Condition is expected to be met or complied with.    

AGRPCON

AGRPCON_EXPECTED_DATE

 
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 Number of the pledge.    

AGRPCON

AGRPCON_PLEDGE_NO

 
SEQUENCE_NUMBER Sequence number of the condition of the Pledge.    

AGRPCON

AGRPCON_SEQ

 
USER_ID Unique identification code of the user who entered or last touched the transaction.    

AGRPCON

AGRPCON_USER

 
ZONE_VALUE Zone column for future use, not currently populated.    

NA

NA

 


Ver: 8.3