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_INSTALLMENT

Description Source composite view contains details on each scheduled payment for any pledge set up on an installment plan basis for a person or organization.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity.    

AGRPINS

AGRPINS_PIDM

 
INSTALLMENT_AMOUNT This field specifies the amount of the pledge installment.    

AGRPINS

AGRPINS_AMT

 
INSTALLMENT_DATE Pledge installment date.    

AGRPINS

AGRPINS_INSTALLMENT_DATE

 
INSTALLMENT_NUMBER Number of the pledge installment.    

AGRPINS

AGRPINS_INSTALLMENT_NO

 
INSTALLMENT_PAID_AMOUNT Amount paid on the pledge installment.    

CALCULATION

AGRGPAY_AMT + A$_3RD_PARTY_CREDIT NOT TO EXCEED AGRPINS_AMT

 
MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
PLEDGE_DURATION Pledge installment plan duration.    

AGBPINS

AGBPINS_PDUR_CODE

 
PLEDGE_DURATION_DESC Pledge duration description.    

FUNCTION

GOKODSF.F_GET_DESC

 
PLEDGE_NUMBER Number of the pledge.    

AGRPINS

AGRPINS_PLEDGE_NO

 
REMINDER_COUNT Number of pledge reminders produced by the system to date.    

AGRPINS

AGRPINS_REM_COUNT

 
REMINDER_DATE Date of the last installment reminder.    

AGRPINS

AGRPINS_REM_DATE

 
REMINDER_FREQUENCY Pledge payments/reminders frequency (ex. monthly, quarterly, etc.) for the duration of installment plan.    

AGBPINS

AGBPINS_FREQ_CODE

 
REMINDER_FREQUENCY_DESC Pledge reminder frequency description.    

FUNCTION

GOKODSF.F_GET_DESC

 
REMINDER_TYPE Pledge reminder code.    

AGRPINS

AGRPINS_PRMD_CODE

 
REMINDER_TYPE_DESC Pledge reminder code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3