RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE 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(8)

AGRPINS

AGRPINS_PIDM

INSTALLMENT_AMOUNT This field specifies the amount of the pledge installment. NUMBER(11, 2)

AGRPINS

AGRPINS_AMT

INSTALLMENT_DATE Pledge installment date. DATE

AGRPINS

AGRPINS_INSTALLMENT_DATE

INSTALLMENT_NUMBER Number of the pledge installment. NUMBER(3)

AGRPINS

AGRPINS_INSTALLMENT_NO

INSTALLMENT_PAID_AMOUNT Amount paid on the pledge installment. NUMBER

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. 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(2)

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: 3.1