Model Pledge

Model Label : BANNER Advancement Pledge Processing
Path : BANNER DEV/Advancement/Advancement_ERD/Pledge_ERD

List of Objects

Object Name	Object Type	Layer Name
AGBPINS	TABLE	Default
AGBPLDG	TABLE	Default
AGRGIDS	TABLE	Default
AGRGMEM	TABLE	Default
AGRGMLT	TABLE	Default
AGRGMMO	TABLE	Default
AGRPCAM	TABLE	Default
AGRPDES	TABLE	Default
AGRPIDS	TABLE	Default
AGRPINS	TABLE	Default
AGRPMEM	TABLE	Default
AGRPMLT	TABLE	Default
AGRPMMO	TABLE	Default
AGRPSOL	TABLE	Default
ATVFISC	TABLE	Default
ATVPACK	TABLE	Default
ATVPCAT	TABLE	Default
ATVPGVE	TABLE	Default
ATVPLDG	TABLE	Default
ATVPRMD	TABLE	Default
ATVPSTA	TABLE	Default
AXBMGID	TABLE	Default
AXRMCAM	TABLE	Default
AXRMDES	TABLE	Default

Comments

Model View

Table AGBPINS

Schema Name ALUMNI
Label AGBPINS
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:57:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGBPINS_PIDM	AGBPINS_PIDM	NUMBER(8,0)	No	*	*
AGBPINS_PLEDGE_NO	AGBPINS_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGBPINS_PDUR_CODE	AGBPINS_PDUR_CODE	VARCHAR2(1)	Yes		*
AGBPINS_FREQ_CODE	AGBPINS_FREQ_CODE	VARCHAR2(2)	No		*
AGBPINS_BILL_DATE	AGBPINS_BILL_DATE	DATE	No
AGBPINS_ACTIVITY_DATE	AGBPINS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBPINS_FREQ_CODE	ATVFREQ_CODE	ATVFREQ
AGBPINS_PDUR_CODE	ATVPDUR_CODE	ATVPDUR
AGBPINS_PIDM	AGBPLDG_PIDM	AGBPLDG
AGBPINS_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
PK_AGBPINS	Unique	AGBPINS_PIDM
PK_AGBPINS	Unique	AGBPINS_PLEDGE_NO

Comments

Source Code Comments

Pledge Installment Base Table

Columns Comments for AGBPINS_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGBPINS_PLEDGE_NO (2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGBPINS_PDUR_CODE (3)

Source Code Comments

This field specifies the duration of the pledge.

Columns Comments for AGBPINS_FREQ_CODE (4)

Source Code Comments

This field specifies the frequency for installment reminders for the pledge.

Columns Comments for AGBPINS_BILL_DATE (5)

Source Code Comments

This field specifies the first billing date for the pledge.

Columns Comments for AGBPINS_ACTIVITY_DATE (6)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table AGBPLDG

Schema Name ALUMNI
Label AGBPLDG
Server name MALDEV8_B60
Creation Date 07/30/2003 15:21:01:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGBPLDG_PIDM	AGBPLDG_PIDM	NUMBER(8,0)	No	*	*
AGBPLDG_PIDM	AGBPLDG_PIDM	NUMBER(8,0)	No	*	*
AGBPLDG_PIDM	AGBPLDG_PIDM	NUMBER(8,0)	No	*	*
AGBPLDG_PIDM	AGBPLDG_PIDM	NUMBER(8,0)	No	*	*
AGBPLDG_PLEDGE_NO	AGBPLDG_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGBPLDG_PLEDGE_NO	AGBPLDG_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGBPLDG_PLEDGE_NO	AGBPLDG_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGBPLDG_PLEDGE_NO	AGBPLDG_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGBPLDG_PLEDGE_DATE	AGBPLDG_PLEDGE_DATE	DATE	No
AGBPLDG_AMT_PLEDGED	AGBPLDG_AMT_PLEDGED	NUMBER(11,2)	No
AGBPLDG_FISC_CODE	AGBPLDG_FISC_CODE	NUMBER(4,0)	No		*
AGBPLDG_PSTA_CODE	AGBPLDG_PSTA_CODE	VARCHAR2(1)	No		*
AGBPLDG_PACK_CODE	AGBPLDG_PACK_CODE	VARCHAR2(2)	Yes		*
AGBPLDG_PRMD_CODE	AGBPLDG_PRMD_CODE	VARCHAR2(2)	Yes		*
AGBPLDG_REM_COUNT	AGBPLDG_REM_COUNT	NUMBER(2,0)	Yes
AGBPLDG_REM_DATE	AGBPLDG_REM_DATE	DATE	Yes
AGBPLDG_ACTIVITY_DATE	AGBPLDG_ACTIVITY_DATE	DATE	No
AGBPLDG_ADJ_IND	AGBPLDG_ADJ_IND	VARCHAR2(1)	Yes
AGBPLDG_PACK_IND	AGBPLDG_PACK_IND	VARCHAR2(1)	Yes
AGBPLDG_RECEIPT_IND	AGBPLDG_RECEIPT_IND	VARCHAR2(1)	Yes
AGBPLDG_RECEIPT_DATE	AGBPLDG_RECEIPT_DATE	DATE	Yes
AGBPLDG_PLDG_CODE	AGBPLDG_PLDG_CODE	VARCHAR2(2)	Yes		*
AGBPLDG_PCLS_CODE	AGBPLDG_PCLS_CODE	VARCHAR2(4)	Yes		*
AGBPLDG_COMMENT	AGBPLDG_COMMENT	VARCHAR2(300)	Yes
AGBPLDG_PCAT_CODE	AGBPLDG_PCAT_CODE	VARCHAR2(5)	Yes		*
AGBPLDG_ENTRY_DATE	AGBPLDG_ENTRY_DATE	DATE	No
AGBPLDG_USER	AGBPLDG_USER	VARCHAR2(30)	No
AGBPLDG_MATCH_PROCESSED	AGBPLDG_MATCH_PROCESSED	VARCHAR2(1)	Yes
AGBPLDG_MATCH_FORM_IND	AGBPLDG_MATCH_FORM_IND	VARCHAR2(1)	Yes
AGBPLDG_MGFORM_READYTOSEND	AGBPLDG_MGFORM_READYTOSEND	VARCHAR2(1)	Yes
AGBPLDG_FEED_IND	AGBPLDG_FEED_IND	VARCHAR2(1)	Yes
AGBPLDG_FEED_DATE	AGBPLDG_FEED_DATE	DATE	Yes
AGBPLDG_FEED_DOC_CODE	AGBPLDG_FEED_DOC_CODE	VARCHAR2(8)	Yes
AGBPLDG_PGVE_CODE	AGBPLDG_PGVE_CODE	VARCHAR2(5)	Yes		*
AGBPLDG_PCLS_CODE_2	AGBPLDG_PCLS_CODE_2	VARCHAR2(4)	Yes		*
AGBPLDG_PCLS_CODE_3	AGBPLDG_PCLS_CODE_3	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBPLDG_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBPLDG_PIDM	AGRPINS_PIDM	AGRPINS
AGBPLDG_PLEDGE_NO	AGRPINS_PLEDGE_NO	AGRPINS
AGBPLDG_PACK_CODE	ATVPACK_CODE	ATVPACK
AGBPLDG_PLEDGE_NO	AGRPDES_PLEDGE_NO	AGRPDES
AGBPLDG_PIDM	AGRPDES_PIDM	AGRPDES
AGBPLDG_FISC_CODE	ATVFISC_CODE	ATVFISC
AGBPLDG_PCAT_CODE	ATVPCAT_CODE	ATVPCAT
AGBPLDG_PRMD_CODE	ATVPRMD_CODE	ATVPRMD
AGBPLDG_PLEDGE_NO	AXRMCAM_PLEDGE_NO	AXRMCAM
AGBPLDG_PIDM	AXRMCAM_PIDM	AXRMCAM
AGBPLDG_PSTA_CODE	ATVPSTA_CODE	ATVPSTA
AGBPLDG_PLDG_CODE	ATVPLDG_CODE	ATVPLDG
AGBPLDG_PLEDGE_NO	AXRMDES_PLEDGE_NO	AXRMDES
AGBPLDG_PIDM	AXRMDES_PIDM	AXRMDES

Index

Index Name	Index Type	Column Name
AGBPLDG_KEY_INDEX2		AGBPLDG_PLEDGE_DATE
AGBPLDG_KEY_INDEX3		AGBPLDG_ACTIVITY_DATE
PK_AGBPLDG	Unique	AGBPLDG_PIDM
PK_AGBPLDG	Unique	AGBPLDG_PLEDGE_NO

Comments

Source Code Comments

Pledge Base Table

Columns Comments for AGBPLDG_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGBPLDG_PLEDGE_NO (2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGBPLDG_PLEDGE_DATE (3)

Source Code Comments

This field specifies the date of the pledge.

Columns Comments for AGBPLDG_AMT_PLEDGED (4)

Source Code Comments

This field specifies the amount of the pledge.

Columns Comments for AGBPLDG_FISC_CODE (5)

Source Code Comments

This field specifies the fiscal year associated with the pledge.

Columns Comments for AGBPLDG_PSTA_CODE (6)

Source Code Comments

This field specifies the status of the pledge.

Columns Comments for AGBPLDG_PACK_CODE (7)

Source Code Comments

Pledge Range Code associated with the pledge amount.

Columns Comments for AGBPLDG_PRMD_CODE (8)

Source Code Comments

This field specifies the reminder type for the pledge.

Columns Comments for AGBPLDG_REM_COUNT (9)

Source Code Comments

This system maintained field specifies the number of reminders produced by the system to date.

Columns Comments for AGBPLDG_REM_DATE (10)

Source Code Comments

This field specifies the date of the last reminder.

Columns Comments for AGBPLDG_ACTIVITY_DATE (11)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for AGBPLDG_ADJ_IND (12)

Source Code Comments

This field indicates a pledge has been adjusted via the Gift Pledge Adjustment Form.

Columns Comments for AGBPLDG_PACK_IND (13)

Source Code Comments

Pledge Acknowledgement indicator updated when a pledge is acknowledged.

Columns Comments for AGBPLDG_RECEIPT_IND (14)

Source Code Comments

Pledge Acknowledgement indicator updated when a receipt is to be sent.

Columns Comments for AGBPLDG_RECEIPT_DATE (15)

Source Code Comments

Pledge Acknowledgement receipt date.

Columns Comments for AGBPLDG_PLDG_CODE (16)

Source Code Comments

Code for the pledge type.

Columns Comments for AGBPLDG_PCLS_CODE (17)

Source Code Comments

Class for the pledge.

Columns Comments for AGBPLDG_COMMENT (18)

Source Code Comments

Comments pertaining to the pledge.

Columns Comments for AGBPLDG_PCAT_CODE (19)

Source Code Comments

Pledge Category Code.

Columns Comments for AGBPLDG_ENTRY_DATE (20)

Source Code Comments

Date the Pledge was entered into the system.

Columns Comments for AGBPLDG_USER (21)

Source Code Comments

User ID of the person who created/updated the record.

Columns Comments for AGBPLDG_MATCH_PROCESSED (22)

Source Code Comments

(Y) = Yes, this pledge has had the MG evaluation processed. (N) = No, this pledge has NOT had the MG eval process done. Null = No, this pledge has NOT had the MG eval process done. (D) = This means that at one time the AXBMGID row existed, but was (D)

Columns Comments for AGBPLDG_MATCH_FORM_IND (23)

Source Code Comments

(P) = per Payment. MG form required for each Payment. (F) = when Fulfilled. MG form required when pledge Fulfilled. (I) = Intermittant. Send MG form based on column AXBMGID_COMMENT. Null = UNKNOWN.

Columns Comments for AGBPLDG_MGFORM_READYTOSEND (24)

Source Code Comments

(Y) = Yes, the MG Form is Ready To Send to the Employer. (N) = No, the MG Form is NOT Ready To Send to the Employer. Null = No, the MG Form is NOT Ready To Send to the Employer.

Columns Comments for AGBPLDG_FEED_IND (25)

Source Code Comments

Gift feed indicator updated when a pledge is fed to Finance.

Columns Comments for AGBPLDG_FEED_DATE (26)

Source Code Comments

This field specifies the date this pledge record has been fed to finance.

Columns Comments for AGBPLDG_FEED_DOC_CODE (27)

Source Code Comments

Pledge feed document code for the pledge being adjusted, updated when the pledge was fed to Finance.

Columns Comments for AGBPLDG_PGVE_CODE (28)

Source Code Comments

The Pledge Gift Vehicle Code associated with this pledge.

Columns Comments for AGBPLDG_PCLS_CODE_2 (29)

Source Code Comments

Class Code two for the Pledge.

Columns Comments for AGBPLDG_PCLS_CODE_3 (30)

Source Code Comments

Class Code three for the Pledge.

Table AGRGIDS

Schema Name ALUMNI
Label AGRGIDS
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:59:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRGIDS_PIDM	AGRGIDS_PIDM	NUMBER(8,0)	No	*
AGRGIDS_GIFT_NO	AGRGIDS_GIFT_NO	VARCHAR2(7)	No	*
AGRGIDS_PLEDGE_NO	AGRGIDS_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGIDS_XREF_PIDM	AGRGIDS_XREF_PIDM	NUMBER(8,0)	No	*
AGRGIDS_AMT	AGRGIDS_AMT	NUMBER(11,2)	No
AGRGIDS_ACTIVITY_DATE	AGRGIDS_ACTIVITY_DATE	DATE	No
AGRGIDS_3PP_AMT	AGRGIDS_3PP_AMT	NUMBER(11,2)	No
AGRGIDS_3PP_PLEDGE_NO	AGRGIDS_3PP_PLEDGE_NO	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGIDS_3PP_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRGIDS_KEY_INDEX2		AGRGIDS_XREF_PIDM
AGRGIDS_KEY_INDEX3		AGRGIDS_3PP_PLEDGE_NO
AGRGIDS_KEY_INDEX3		AGRGIDS_3PP_AMT
PK_AGRGIDS	Unique	AGRGIDS_PIDM
PK_AGRGIDS	Unique	AGRGIDS_GIFT_NO
PK_AGRGIDS	Unique	AGRGIDS_PLEDGE_NO
PK_AGRGIDS	Unique	AGRGIDS_XREF_PIDM

Comments

Source Code Comments

Gift Multiple Id Repeating Table

Columns Comments for AGRGIDS_PIDM (1)

Source Code Comments

This field is the internal system generated identification number.

Columns Comments for AGRGIDS_GIFT_NO (2)

Source Code Comments

This field specifies the system assigned number of the gift.

Columns Comments for AGRGIDS_PLEDGE_NO (3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRGIDS_XREF_PIDM (4)

Source Code Comments

This field specifies the internal system generated number of the cross reference.

Columns Comments for AGRGIDS_AMT (5)

Source Code Comments

Amount of the gift associated with the cross reference pidm. Amount must be less than or equal to the total gift amount.

Columns Comments for AGRGIDS_ACTIVITY_DATE (6)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for AGRGIDS_3PP_AMT (7)

Source Code Comments

The amount of the payment that is going to a third party.

Columns Comments for AGRGIDS_3PP_PLEDGE_NO (8)

Source Code Comments

The pledge number to which the third party payment will be applied.

Table AGRGMEM

Schema Name ALUMNI
Label AGRGMEM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:59:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRGMEM_PIDM	AGRGMEM_PIDM	NUMBER(8,0)	No	*	*
AGRGMEM_GIFT_NO	AGRGMEM_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGMEM_PLEDGE_NO	AGRGMEM_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRGMEM_MEMO_PIDM	AGRGMEM_MEMO_PIDM	NUMBER(8,0)	No	*
AGRGMEM_AMT	AGRGMEM_AMT	NUMBER(11,2)	No
AGRGMEM_ACTIVITY_DATE	AGRGMEM_ACTIVITY_DATE	DATE	No
AGRGMEM_3PP_AMT	AGRGMEM_3PP_AMT	NUMBER(11,2)	No
AGRGMEM_3PP_PLEDGE_NO	AGRGMEM_3PP_PLEDGE_NO	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGMEM_PIDM	AGRGPAY_PIDM	AGRGPAY
AGRGMEM_GIFT_NO	AGRGPAY_GIFT_NO	AGRGPAY
AGRGMEM_PLEDGE_NO	AGRGPAY_PLEDGE_NO	AGRGPAY
AGRGMEM_3PP_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRGMEM_KEY_INDEX2		AGRGMEM_MEMO_PIDM
AGRGMEM_KEY_INDEX3		AGRGMEM_3PP_PLEDGE_NO
AGRGMEM_KEY_INDEX3		AGRGMEM_3PP_AMT
PK_AGRGMEM	Unique	AGRGMEM_PIDM
PK_AGRGMEM	Unique	AGRGMEM_GIFT_NO
PK_AGRGMEM	Unique	AGRGMEM_PLEDGE_NO
PK_AGRGMEM	Unique	AGRGMEM_MEMO_PIDM

Comments

Source Code Comments

Gift Memo Id Repeating Table

Columns Comments for AGRGMEM_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRGMEM_GIFT_NO (2)

Source Code Comments

This field specifies the system assigned number of gift.

Columns Comments for AGRGMEM_PLEDGE_NO (3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRGMEM_MEMO_PIDM (4)

Source Code Comments

This field specifies the identification number of the person or organization to whom a memo gift is credited.

Columns Comments for AGRGMEM_AMT (5)

Source Code Comments

This field specifies the amount of the memo gift.

Columns Comments for AGRGMEM_ACTIVITY_DATE (6)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for AGRGMEM_3PP_AMT (7)

Source Code Comments

The amount of the payment that is going to a third party.

Columns Comments for AGRGMEM_3PP_PLEDGE_NO (8)

Source Code Comments

The pledge number to which the third party payment will be applied.

Table AGRGMLT

Schema Name ALUMNI
Label AGRGMLT
Server name MALDEV8_B60
Creation Date 12/20/2002 10:42:37:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRGMLT_PIDM	AGRGMLT_PIDM	NUMBER(8,0)	No	*
AGRGMLT_XREF_PIDM	AGRGMLT_XREF_PIDM	NUMBER(8,0)	No	*
AGRGMLT_GIFT_NO	AGRGMLT_GIFT_NO	VARCHAR2(7)	No	*
AGRGMLT_PLEDGE_NO	AGRGMLT_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGMLT_CAMPAIGN	AGRGMLT_CAMPAIGN	VARCHAR2(5)	No	*
AGRGMLT_DESG	AGRGMLT_DESG	VARCHAR2(10)	No	*
AGRGMLT_ACTIVITY_DATE	AGRGMLT_ACTIVITY_DATE	DATE	No
AGRGMLT_CREDIT	AGRGMLT_CREDIT	NUMBER(11,2)	Yes
AGRGMLT_3PP_AMT	AGRGMLT_3PP_AMT	NUMBER(11,2)	No
AGRGMLT_3PP_PLEDGE_NO	AGRGMLT_3PP_PLEDGE_NO	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGMLT_3PP_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRGMLT_KEY_INDEX2		AGRGMLT_XREF_PIDM
AGRGMLT_KEY_INDEX2		AGRGMLT_GIFT_NO
AGRGMLT_KEY_INDEX3		AGRGMLT_PIDM
AGRGMLT_KEY_INDEX3		AGRGMLT_PLEDGE_NO
AGRGMLT_KEY_INDEX3		AGRGMLT_XREF_PIDM
AGRGMLT_KEY_INDEX4		AGRGMLT_3PP_PLEDGE_NO
AGRGMLT_KEY_INDEX4		AGRGMLT_3PP_AMT
PK_AGRGMLT	Unique	AGRGMLT_PIDM
PK_AGRGMLT	Unique	AGRGMLT_GIFT_NO
PK_AGRGMLT	Unique	AGRGMLT_PLEDGE_NO
PK_AGRGMLT	Unique	AGRGMLT_CAMPAIGN
PK_AGRGMLT	Unique	AGRGMLT_DESG
PK_AGRGMLT	Unique	AGRGMLT_XREF_PIDM

Comments

Source Code Comments

Detail Gift Multiple Credit Table

Columns Comments for AGRGMLT_PIDM (1)

Source Code Comments

Internal identification number for person/organization associated with the gift.

Columns Comments for AGRGMLT_XREF_PIDM (2)

Source Code Comments

Internal identification number for person/organization receiving the multiple credit.

Columns Comments for AGRGMLT_GIFT_NO (3)

Source Code Comments

Gift number from which multiple credit is being disbursed.

Columns Comments for AGRGMLT_PLEDGE_NO (4)

Source Code Comments

Pledge no associated with the gift from which multiple credit is being disbursed.

Columns Comments for AGRGMLT_CAMPAIGN (5)

Source Code Comments

Campaign associated with the gift from which multiple credit is being disbursed.

Columns Comments for AGRGMLT_DESG (6)

Source Code Comments

Designation associated with the gift from which multiple credit is being disbursed.

Columns Comments for AGRGMLT_ACTIVITY_DATE (7)

Source Code Comments

Date this record was inserted or last updated.

Columns Comments for AGRGMLT_CREDIT (8)

Source Code Comments

Dollar amount of the gift being disbursed to the xref pidm from the pledge for the designation.

Columns Comments for AGRGMLT_3PP_AMT (9)

Source Code Comments

The amount of the payment that is going to a third party.

Columns Comments for AGRGMLT_3PP_PLEDGE_NO (10)

Source Code Comments

The pledge number to which the third party payment will be applied.

Table AGRGMMO

Schema Name ALUMNI
Label AGRGMMO
Server name MALDEV8_B60
Creation Date 12/20/2002 10:42:37:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRGMMO_PIDM	AGRGMMO_PIDM	NUMBER(8,0)	No	*
AGRGMMO_XREF_PIDM	AGRGMMO_XREF_PIDM	NUMBER(8,0)	No	*
AGRGMMO_GIFT_NO	AGRGMMO_GIFT_NO	VARCHAR2(7)	No	*
AGRGMMO_PLEDGE_NO	AGRGMMO_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGMMO_CAMPAIGN	AGRGMMO_CAMPAIGN	VARCHAR2(5)	No	*
AGRGMMO_DESG	AGRGMMO_DESG	VARCHAR2(10)	No	*
AGRGMMO_ACTIVITY_DATE	AGRGMMO_ACTIVITY_DATE	DATE	No
AGRGMMO_CREDIT	AGRGMMO_CREDIT	NUMBER(11,2)	Yes
AGRGMMO_3PP_AMT	AGRGMMO_3PP_AMT	NUMBER(11,2)	No
AGRGMMO_3PP_PLEDGE_NO	AGRGMMO_3PP_PLEDGE_NO	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGMMO_3PP_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRGMMO_KEY_INDEX2		AGRGMMO_XREF_PIDM
AGRGMMO_KEY_INDEX2		AGRGMMO_GIFT_NO
AGRGMMO_KEY_INDEX3		AGRGMMO_PIDM
AGRGMMO_KEY_INDEX3		AGRGMMO_PLEDGE_NO
AGRGMMO_KEY_INDEX3		AGRGMMO_XREF_PIDM
AGRGMMO_KEY_INDEX4		AGRGMMO_3PP_PLEDGE_NO
AGRGMMO_KEY_INDEX4		AGRGMMO_3PP_AMT
PK_AGRGMMO	Unique	AGRGMMO_PIDM
PK_AGRGMMO	Unique	AGRGMMO_GIFT_NO
PK_AGRGMMO	Unique	AGRGMMO_PLEDGE_NO
PK_AGRGMMO	Unique	AGRGMMO_CAMPAIGN
PK_AGRGMMO	Unique	AGRGMMO_DESG
PK_AGRGMMO	Unique	AGRGMMO_XREF_PIDM

Comments

Source Code Comments

Detail Gift Memo Credit Table

Columns Comments for AGRGMMO_PIDM (1)

Source Code Comments

Internal identification number for person/organization associated with the gift.

Columns Comments for AGRGMMO_XREF_PIDM (2)

Source Code Comments

Internal identification number for person/organization receiving the memo credit.

Columns Comments for AGRGMMO_GIFT_NO (3)

Source Code Comments

Gift number from which memo credit is being disbursed.

Columns Comments for AGRGMMO_PLEDGE_NO (4)

Source Code Comments

Pledge no associated with the gift from which memo credit is being disbursed.

Columns Comments for AGRGMMO_CAMPAIGN (5)

Source Code Comments

Campaign associated with the gift from which memo credit is being disbursed.

Columns Comments for AGRGMMO_DESG (6)

Source Code Comments

Designation associated with the gift from which memo credit is being disbursed.

Columns Comments for AGRGMMO_ACTIVITY_DATE (7)

Source Code Comments

Date this record was inserted or last updated.

Columns Comments for AGRGMMO_CREDIT (8)

Source Code Comments

Percentage of the gift being disbursed to the xref pidm from the pledge for the designation.

Columns Comments for AGRGMMO_3PP_AMT (9)

Source Code Comments

The amount of the payment that is going to a third party.

Columns Comments for AGRGMMO_3PP_PLEDGE_NO (10)

Source Code Comments

The pledge number to which the third party payment will be applied.

Table AGRPCAM

Schema Name ALUMNI
Label AGRPCAM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:00:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRPCAM_PIDM	AGRPCAM_PIDM	NUMBER(8,0)	No	*	*
AGRPCAM_PLEDGE_NO	AGRPCAM_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPCAM_CAMPAIGN	AGRPCAM_CAMPAIGN	VARCHAR2(5)	No	*
AGRPCAM_AMT	AGRPCAM_AMT	NUMBER(11,2)	No
AGRPCAM_AMT_PAID	AGRPCAM_AMT_PAID	NUMBER(11,2)	No
AGRPCAM_ACTIVITY_DATE	AGRPCAM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPCAM_PIDM	AGBPLDG_PIDM	AGBPLDG
AGRPCAM_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRPCAM_KEY_INDEX2		AGRPCAM_CAMPAIGN
AGRPCAM_KEY_INDEX2		AGRPCAM_PLEDGE_NO
PK_AGRPCAM	Unique	AGRPCAM_PIDM
PK_AGRPCAM	Unique	AGRPCAM_PLEDGE_NO
PK_AGRPCAM	Unique	AGRPCAM_CAMPAIGN

Comments

Source Code Comments

Pledge Campaign Repeating Table

Columns Comments for AGRPCAM_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRPCAM_PLEDGE_NO (2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPCAM_CAMPAIGN (3)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRPCAM_AMT (4)

Source Code Comments

This field specifies the amount pledged to the campaign. This amount defaults to the pledge amount.

Columns Comments for AGRPCAM_AMT_PAID (5)

Source Code Comments

This field specifies the amount paid toward the pledge.

Columns Comments for AGRPCAM_ACTIVITY_DATE (6)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table AGRPDES

Schema Name ALUMNI
Label AGRPDES
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:00:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRPDES_PIDM	AGRPDES_PIDM	NUMBER(8,0)	No	*	*
AGRPDES_PIDM	AGRPDES_PIDM	NUMBER(8,0)	No	*	*
AGRPDES_PIDM	AGRPDES_PIDM	NUMBER(8,0)	No	*	*
AGRPDES_PIDM	AGRPDES_PIDM	NUMBER(8,0)	No	*	*
AGRPDES_PLEDGE_NO	AGRPDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPDES_PLEDGE_NO	AGRPDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPDES_PLEDGE_NO	AGRPDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPDES_PLEDGE_NO	AGRPDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPDES_CAMPAIGN	AGRPDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRPDES_CAMPAIGN	AGRPDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRPDES_CAMPAIGN	AGRPDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRPDES_CAMPAIGN	AGRPDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRPDES_CAMPAIGN	AGRPDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRPDES_DESG	AGRPDES_DESG	VARCHAR2(10)	No	*	*
AGRPDES_DESG	AGRPDES_DESG	VARCHAR2(10)	No	*	*
AGRPDES_DESG	AGRPDES_DESG	VARCHAR2(10)	No	*	*
AGRPDES_DESG	AGRPDES_DESG	VARCHAR2(10)	No	*	*
AGRPDES_AMT	AGRPDES_AMT	NUMBER(11,2)	No
AGRPDES_AMT_PAID	AGRPDES_AMT_PAID	NUMBER(11,2)	No
AGRPDES_ACTIVITY_DATE	AGRPDES_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPDES_PIDM	AGRPCAM_PIDM	AGRPCAM
AGRPDES_PLEDGE_NO	AGRPCAM_PLEDGE_NO	AGRPCAM
AGRPDES_CAMPAIGN	AGRPCAM_CAMPAIGN	AGRPCAM
AGRPDES_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGRPDES_PIDM	AGRPMLT_PIDM	AGRPMLT
AGRPDES_PLEDGE_NO	AGRPMLT_PLEDGE_NO	AGRPMLT
AGRPDES_CAMPAIGN	AGRPMLT_CAMPAIGN	AGRPMLT
AGRPDES_DESG	AGRPMLT_DESG	AGRPMLT
AGRPDES_PIDM	AGRPMMO_PIDM	AGRPMMO
AGRPDES_PLEDGE_NO	AGRPMMO_PLEDGE_NO	AGRPMMO
AGRPDES_CAMPAIGN	AGRPMMO_CAMPAIGN	AGRPMMO
AGRPDES_DESG	AGRPMMO_DESG	AGRPMMO
AGRPDES_DESG	ADBDESG_DESG	ADBDESG
AGRPDES_PIDM	AGRGDES_PIDM	AGRGDES
AGRPDES_PLEDGE_NO	AGRGDES_PLEDGE_NO	AGRGDES
AGRPDES_CAMPAIGN	AGRGDES_CAMPAIGN	AGRGDES
AGRPDES_DESG	AGRGDES_DESG	AGRGDES

Index

Index Name	Index Type	Column Name
AGRPDES_KEY_INDEX2		AGRPDES_DESG
AGRPDES_KEY_INDEX2		AGRPDES_PLEDGE_NO
PK_AGRPDES	Unique	AGRPDES_PIDM
PK_AGRPDES	Unique	AGRPDES_PLEDGE_NO
PK_AGRPDES	Unique	AGRPDES_CAMPAIGN
PK_AGRPDES	Unique	AGRPDES_DESG

Comments

Source Code Comments

Pledge Designation Repeating Table

Columns Comments for AGRPDES_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRPDES_PLEDGE_NO (2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPDES_CAMPAIGN (3)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRPDES_DESG (4)

Source Code Comments

This field specifies the designation code associated with the campaign.

Columns Comments for AGRPDES_AMT (5)

Source Code Comments

This field specifies the amount of the pledge designation. This field defaults to the campaign amount.

Columns Comments for AGRPDES_AMT_PAID (6)

Source Code Comments

This field specifies the amount paid toward the pledge designation.

Columns Comments for AGRPDES_ACTIVITY_DATE (7)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table AGRPIDS

Schema Name ALUMNI
Label AGRPIDS
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:00:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRPIDS_PIDM	AGRPIDS_PIDM	NUMBER(8,0)	No	*	*
AGRPIDS_PLEDGE_NO	AGRPIDS_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPIDS_XREF_PIDM	AGRPIDS_XREF_PIDM	NUMBER(8,0)	No	*
AGRPIDS_AMT	AGRPIDS_AMT	NUMBER(11,2)	No
AGRPIDS_AMT_PAID	AGRPIDS_AMT_PAID	NUMBER(11,2)	No
AGRPIDS_ACTIVITY_DATE	AGRPIDS_ACTIVITY_DATE	DATE	No
AGRPIDS_3PP_AMT	AGRPIDS_3PP_AMT	NUMBER(11,2)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPIDS_PIDM	AGBPLDG_PIDM	AGBPLDG
AGRPIDS_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRPIDS_KEY_INDEX2		AGRPIDS_XREF_PIDM
PK_AGRPIDS	Unique	AGRPIDS_PIDM
PK_AGRPIDS	Unique	AGRPIDS_PLEDGE_NO
PK_AGRPIDS	Unique	AGRPIDS_XREF_PIDM

Comments

Source Code Comments

Pledge Multiple Id Repeating Table

Columns Comments for AGRPIDS_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRPIDS_PLEDGE_NO (2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPIDS_XREF_PIDM (3)

Source Code Comments

This field specifies the internal system generated identification number of the cross reference.

Columns Comments for AGRPIDS_AMT (4)

Source Code Comments

This field specifies the amount of the pledge associated with the cross reference. This amount must be less than or equal to the pledge amount.

Columns Comments for AGRPIDS_AMT_PAID (5)

Source Code Comments

This field specifies the amount paid toward the pledge.

Columns Comments for AGRPIDS_ACTIVITY_DATE (6)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for AGRPIDS_3PP_AMT (7)

Source Code Comments

The amount of the payment that is used for Third Party Credit

Table AGRPINS

Schema Name ALUMNI
Label AGRPINS
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:00:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRPINS_PIDM	AGRPINS_PIDM	NUMBER(8,0)	No	*	*
AGRPINS_PLEDGE_NO	AGRPINS_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPINS_INSTALLMENT_NO	AGRPINS_INSTALLMENT_NO	NUMBER(3,0)	No	*
AGRPINS_INSTALLMEN