Composite View Target: AA_PLEDGE

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.

Target Column Business Definition Database Data Type Source Name Source Column

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE
NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)
NA

NA

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

AGRPINS_PIDM

INSTALLMENT_AMOUNT This field specifies the amount of the pledge installment. NUMBER
AGRPINS

AGRPINS_AMT

INSTALLMENT_DATE Pledge installment date. DATE
AGRPINS

AGRPINS_INSTALLMENT_DATE

INSTALLMENT_NUMBER Number of the pledge installment. NUMBER
AGRPINS

AGRPINS_INSTALLMENT_NO

INSTALLMENT_PAID_AMOUNT Amount paid on the pledge installment. NUMBER

MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)
NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)
NA

NA

PLEDGE_DURATION Pledge installment plan duration. VARCHAR2(1)
AGBPINS

AGBPINS_PDUR_CODE

PLEDGE_DURATION_DESC Pledge duration description. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

PLEDGE_NUMBER Number of the pledge. VARCHAR2(7)
AGRPINS

AGRPINS_PLEDGE_NO

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

AGRPINS_REM_COUNT

REMINDER_DATE Date of the last installment reminder. DATE
AGRPINS

AGRPINS_REM_DATE

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

AGBPINS_FREQ_CODE

REMINDER_FREQUENCY_DESC Pledge reminder frequency description. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

REMINDER_TYPE Pledge reminder code. VARCHAR2(2)
AGRPINS

AGRPINS_PRMD_CODE

REMINDER_TYPE_DESC Pledge reminder code description. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)
NA

NA

Ver:

Target Column	Business Definition	Database Data Type	Source Name	Source Column
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AGRPINS	AGRPINS_PIDM
INSTALLMENT_AMOUNT	This field specifies the amount of the pledge installment.	NUMBER	AGRPINS	AGRPINS_AMT
INSTALLMENT_DATE	Pledge installment date.	DATE	AGRPINS	AGRPINS_INSTALLMENT_DATE
INSTALLMENT_NUMBER	Number of the pledge installment.	NUMBER	AGRPINS	AGRPINS_INSTALLMENT_NO
INSTALLMENT_PAID_AMOUNT	Amount paid on the pledge installment.	NUMBER
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
PLEDGE_DURATION	Pledge installment plan duration.	VARCHAR2(1)	AGBPINS	AGBPINS_PDUR_CODE
PLEDGE_DURATION_DESC	Pledge duration description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
PLEDGE_NUMBER	Number of the pledge.	VARCHAR2(7)	AGRPINS	AGRPINS_PLEDGE_NO
REMINDER_COUNT	Number of pledge reminders produced by the system to date.	NUMBER	AGRPINS	AGRPINS_REM_COUNT
REMINDER_DATE	Date of the last installment reminder.	DATE	AGRPINS	AGRPINS_REM_DATE
REMINDER_FREQUENCY	Pledge payments/reminders frequency (ex. monthly, quarterly, etc.) for the duration of installment plan.	VARCHAR2(2)	AGBPINS	AGBPINS_FREQ_CODE
REMINDER_FREQUENCY_DESC	Pledge reminder frequency description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
REMINDER_TYPE	Pledge reminder code.	VARCHAR2(2)	AGRPINS	AGRPINS_PRMD_CODE
REMINDER_TYPE_DESC	Pledge reminder code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA