AGBCSHR AGBGIFT AGBMGID AGRGCAM AGRGDES AGRGMLT AGRGMMO AGRGSOL AGRMCAM AGRMDES AGRMGIF ATVFISC ATVGACK ATVGIFT ATVPGVE

Model Gift


Model Label : BANNER Advancement Gift Processing
Path : BANNER DEV/Advancement/Advancement_ERD/Gift_ERD

List of Objects

Object Name Object Type Layer Name
AGBCSHR TABLE Default
AGBGIFT TABLE Default
AGBMGID TABLE Default
AGRGCAM TABLE Default
AGRGDES TABLE Default
AGRGMLT TABLE Default
AGRGMMO TABLE Default
AGRGSOL TABLE Default
AGRMCAM TABLE Default
AGRMDES TABLE Default
AGRMGIF TABLE Default
ATVFISC TABLE Default
ATVGACK TABLE Default
ATVGIFT TABLE Default
ATVPGVE TABLE Default

Comments

Model View

''

Table AGBCSHR

Schema Name ALUMNI
Label AGBCSHR
Server name MALDEV8_B60
Creation Date 02/11/2003 17:58:46:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGBCSHR_USER AGBCSHR_USER VARCHAR2(30) No *
AGBCSHR_SESSION_NUMBER AGBCSHR_SESSION_NUMBER NUMBER(6,0) No *
AGBCSHR_START_DATE AGBCSHR_START_DATE DATE Yes
AGBCSHR_END_DATE AGBCSHR_END_DATE DATE Yes
AGBCSHR_SESSION_IND AGBCSHR_SESSION_IND VARCHAR2(1) No
AGBCSHR_DRAWER_TOTAL AGBCSHR_DRAWER_TOTAL NUMBER(13,2) Yes
AGBCSHR_SESSION_TOTAL AGBCSHR_SESSION_TOTAL NUMBER(13,2) Yes
AGBCSHR_ACTIVITY_DATE AGBCSHR_ACTIVITY_DATE DATE No
AGBCSHR_ADJUST_TOTAL AGBCSHR_ADJUST_TOTAL NUMBER(13,2) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_AGBCSHR Unique AGBCSHR_USER
PK_AGBCSHR Unique AGBCSHR_SESSION_NUMBER

Comments

Source Code Comments

Advancement Cashier Session Table

Columns Comments for AGBCSHR_USER (1)

Source Code Comments

This system maintained field specifies the user name of the cashier.

Columns Comments for AGBCSHR_SESSION_NUMBER (2)

Source Code Comments

This system assigned field identifies the number of the cashier session.

Columns Comments for AGBCSHR_START_DATE (3)

Source Code Comments

This field specifies the date and time the cashier session begins.

Columns Comments for AGBCSHR_END_DATE (4)

Source Code Comments

This field specifies the date and time the cashier session ends.

Columns Comments for AGBCSHR_SESSION_IND (5)

Source Code Comments

This field indicates the status of the cashier review session: closed, finalized, or ready to delete.

Columns Comments for AGBCSHR_DRAWER_TOTAL (6)

Source Code Comments

This field specifies the total amount received by the cashier against which gifts and pledges are entered.

Columns Comments for AGBCSHR_SESSION_TOTAL (7)

Source Code Comments

This field specifies the total amount entered by the cashier and maintained by the system.

Columns Comments for AGBCSHR_ACTIVITY_DATE (8)

Source Code Comments

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

Columns Comments for AGBCSHR_ADJUST_TOTAL (9)

Source Code Comments

This field contains the total adjustment amount for the cashier session.

Table AGBGIFT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGBGIFT_PIDM AGBGIFT_PIDM NUMBER(8,0) No *
AGBGIFT_PIDM AGBGIFT_PIDM NUMBER(8,0) No *
AGBGIFT_PIDM AGBGIFT_PIDM NUMBER(8,0) No *
AGBGIFT_PIDM AGBGIFT_PIDM NUMBER(8,0) No *
AGBGIFT_PIDM AGBGIFT_PIDM NUMBER(8,0) No *
AGBGIFT_PIDM AGBGIFT_PIDM NUMBER(8,0) No *
AGBGIFT_PIDM AGBGIFT_PIDM NUMBER(8,0) No *
AGBGIFT_PIDM AGBGIFT_PIDM NUMBER(8,0) No *
AGBGIFT_PIDM AGBGIFT_PIDM NUMBER(8,0) No *
AGBGIFT_GIFT_NO AGBGIFT_GIFT_NO VARCHAR2(7) No *
AGBGIFT_GIFT_NO AGBGIFT_GIFT_NO VARCHAR2(7) No *
AGBGIFT_GIFT_NO AGBGIFT_GIFT_NO VARCHAR2(7) No *
AGBGIFT_GIFT_NO AGBGIFT_GIFT_NO VARCHAR2(7) No *
AGBGIFT_GIFT_NO AGBGIFT_GIFT_NO VARCHAR2(7) No *
AGBGIFT_GIFT_NO AGBGIFT_GIFT_NO VARCHAR2(7) No *
AGBGIFT_GIFT_NO AGBGIFT_GIFT_NO VARCHAR2(7) No *
AGBGIFT_GIFT_NO AGBGIFT_GIFT_NO VARCHAR2(7) No *
AGBGIFT_AMT_TOT AGBGIFT_AMT_TOT NUMBER(11,2) No
AGBGIFT_FINAL_IND AGBGIFT_FINAL_IND VARCHAR2(1) Yes
AGBGIFT_GIFT_DATE AGBGIFT_GIFT_DATE DATE No
AGBGIFT_FISC_CODE AGBGIFT_FISC_CODE NUMBER(4,0) No *
AGBGIFT_GACK_CODE AGBGIFT_GACK_CODE VARCHAR2(2) Yes *
AGBGIFT_GCLS_CODE AGBGIFT_GCLS_CODE VARCHAR2(4) Yes *
AGBGIFT_GIFT_CODE AGBGIFT_GIFT_CODE VARCHAR2(2) No *
AGBGIFT_CARD_NO AGBGIFT_CARD_NO VARCHAR2(20) Yes
AGBGIFT_CARD_EXP_DATE AGBGIFT_CARD_EXP_DATE DATE Yes
AGBGIFT_COMMENT AGBGIFT_COMMENT VARCHAR2(300) Yes
AGBGIFT_MATCH_RECEIVED AGBGIFT_MATCH_RECEIVED VARCHAR2(1) Yes
AGBGIFT_MATCH_PROCESSED AGBGIFT_MATCH_PROCESSED VARCHAR2(1) No
AGBGIFT_ENTRY_DATE AGBGIFT_ENTRY_DATE DATE No
AGBGIFT_USER AGBGIFT_USER VARCHAR2(30) No *
AGBGIFT_ACTIVITY_DATE AGBGIFT_ACTIVITY_DATE DATE No
AGBGIFT_GACK_IND AGBGIFT_GACK_IND VARCHAR2(1) Yes
AGBGIFT_FEED_IND AGBGIFT_FEED_IND VARCHAR2(1) Yes
AGBGIFT_FEED_DATE AGBGIFT_FEED_DATE DATE Yes
AGBGIFT_FEED_DOC_CODE AGBGIFT_FEED_DOC_CODE VARCHAR2(8) Yes
AGBGIFT_ADJ_IND AGBGIFT_ADJ_IND VARCHAR2(1) Yes
AGBGIFT_RECEIPT_IND AGBGIFT_RECEIPT_IND VARCHAR2(1) Yes
AGBGIFT_RECEIPT_DATE AGBGIFT_RECEIPT_DATE DATE Yes
AGBGIFT_GIFT_DESC AGBGIFT_GIFT_DESC VARCHAR2(60) No
AGBGIFT_MG_FORMSENT_IND AGBGIFT_MG_FORMSENT_IND VARCHAR2(1) Yes
AGBGIFT_PGVE_CODE AGBGIFT_PGVE_CODE VARCHAR2(5) Yes *
AGBGIFT_GCLS_CODE_2 AGBGIFT_GCLS_CODE_2 VARCHAR2(4) Yes *
AGBGIFT_GCLS_CODE_3 AGBGIFT_GCLS_CODE_3 VARCHAR2(4) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
AGBGIFT_PGVE_CODE ATVPGVE_CODE ATVPGVE
AGBGIFT_GIFT_NO AGRMCAM_GIFT_NO AGRMCAM
AGBGIFT_PIDM AGRMCAM_EMPL_PIDM AGRMCAM
AGBGIFT_PIDM AGBMGID_EMPL_PIDM AGBMGID
AGBGIFT_GIFT_NO AGBMGID_EMPL_GIFT_NO AGBMGID
AGBGIFT_PIDM AGRGMLT_PIDM AGRGMLT
AGBGIFT_GIFT_NO AGRGMLT_GIFT_NO AGRGMLT
AGBGIFT_PIDM AGRGMMO_PIDM AGRGMMO
AGBGIFT_GIFT_NO AGRGMMO_GIFT_NO AGRGMMO
AGBGIFT_GIFT_NO AGRMDES_GIFT_NO AGRMDES
AGBGIFT_PIDM AGRMDES_EMPL_PIDM AGRMDES
AGBGIFT_FISC_CODE ATVFISC_CODE ATVFISC
AGBGIFT_PIDM AGRMGIF_EMPR_PIDM AGRMGIF
AGBGIFT_GACK_CODE ATVGACK_CODE ATVGACK
AGBGIFT_PIDM AGRGCAM_PIDM AGRGCAM
AGBGIFT_GIFT_NO AGRGCAM_GIFT_NO AGRGCAM
AGBGIFT_GIFT_CODE ATVGIFT_CODE ATVGIFT
AGBGIFT_USER AGBCSHR_USER AGBCSHR
AGBGIFT_PIDM AGRGDES_PIDM AGRGDES
AGBGIFT_GIFT_NO AGRGDES_GIFT_NO AGRGDES
AGBGIFT_GIFT_NO AGRGSOL_GIFT_NO AGRGSOL
AGBGIFT_PIDM AGRGSOL_PIDM AGRGSOL

Index

Index Name Index Type Column Name
AGBGIFT_KEY_INDEX Unique AGBGIFT_PIDM
AGBGIFT_KEY_INDEX Unique AGBGIFT_GIFT_NO
AGBGIFT_KEY_INDEX2 AGBGIFT_ENTRY_DATE
AGBGIFT_KEY_INDEX2 AGBGIFT_USER
AGBGIFT_KEY_INDEX3 AGBGIFT_GIFT_DATE
AGBGIFT_MATCH_INDEX Unique AGBGIFT_MATCH_PROCESSED
AGBGIFT_MATCH_INDEX Unique AGBGIFT_PIDM
AGBGIFT_MATCH_INDEX Unique AGBGIFT_GIFT_NO

Comments

Source Code Comments

Gift/Pledge Payment Base Table

Columns Comments for AGBGIFT_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGBGIFT_GIFT_NO (2)

Source Code Comments

This field specifies the system assigned number of the gift.

Columns Comments for AGBGIFT_AMT_TOT (3)

Source Code Comments

This field specifies the total amount of the gift or pledge payment.

Columns Comments for AGBGIFT_FINAL_IND (4)

Source Code Comments

This field specifies whether a gift has been finalized in the Cashier Review Session.

Columns Comments for AGBGIFT_GIFT_DATE (5)

Source Code Comments

This field specifies the date a gift is received. The date defaults to the system date if no date is entered.

Columns Comments for AGBGIFT_FISC_CODE (6)

Source Code Comments

This field specifies the code for the fiscal year.

Columns Comments for AGBGIFT_GACK_CODE (7)

Source Code Comments

Gift Range Code associated with the gift amount.

Columns Comments for AGBGIFT_GCLS_CODE (8)

Source Code Comments

This field specifies the category of the gift - anonymous, memorial, etc.

Columns Comments for AGBGIFT_GIFT_CODE (9)

Source Code Comments

This field specifies the type of gift or method of payment, i.e., check, credit card, bequest, property.

Columns Comments for AGBGIFT_CARD_NO (10)

Source Code Comments

This field specifies the credit card number of the donor.

Columns Comments for AGBGIFT_CARD_EXP_DATE (11)

Source Code Comments

This field specifies the credit card expiration date.

Columns Comments for AGBGIFT_COMMENT (12)

Source Code Comments

This field specifies the comment related to the gift.

Columns Comments for AGBGIFT_MATCH_RECEIVED (13)

Source Code Comments

This field specifies whether a matching gift form has been received for a gift.

Columns Comments for AGBGIFT_MATCH_PROCESSED (14)

Source Code Comments

This field specifies whether a matching gift has been processed for a gift.

Columns Comments for AGBGIFT_ENTRY_DATE (15)

Source Code Comments

This system maintained field specifies the date the gift is entered.

Columns Comments for AGBGIFT_USER (16)

Source Code Comments

This system maintained field specifies the user name.

Columns Comments for AGBGIFT_ACTIVITY_DATE (17)

Source Code Comments

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

Columns Comments for AGBGIFT_GACK_IND (18)

Source Code Comments

Gift acknowledgment indicator updated when gift is acknowledged.

Columns Comments for AGBGIFT_FEED_IND (19)

Source Code Comments

Gift feed indicator is updated when gift has been fed to Finance.

Columns Comments for AGBGIFT_FEED_DATE (20)

Source Code Comments

Gift feed date is the date the gift was fed to Finance.

Columns Comments for AGBGIFT_FEED_DOC_CODE (21)

Source Code Comments

Gift feed document code.

Columns Comments for AGBGIFT_ADJ_IND (22)

Source Code Comments

This field indicates that adjustments have been made to this gift via the gift/pledge adjustment form.

Columns Comments for AGBGIFT_RECEIPT_IND (23)

Source Code Comments

This field specifies if a receipt is required for this gift record.

Columns Comments for AGBGIFT_RECEIPT_DATE (24)

Source Code Comments

Date a receipt was processed through AGPACKN - Gift/Pledge Acknowledgement Process.

Columns Comments for AGBGIFT_GIFT_DESC (25)

Source Code Comments

Description for the gift.

Columns Comments for AGBGIFT_MG_FORMSENT_IND (26)

Source Code Comments

(Y) - Yes, The MG Form has been sent to the Employer. (N) - No, The MG Form has NOT been sent to the Employer. Null - No, The MG Form has NOT been sent to the Employer.

Columns Comments for AGBGIFT_PGVE_CODE (27)

Source Code Comments

The Pledge Gift Vehicle Code associated with this gift.

Columns Comments for AGBGIFT_GCLS_CODE_2 (28)

Source Code Comments

This field specifies the second category of the gift - anonymous, memorial, etc.

Columns Comments for AGBGIFT_GCLS_CODE_3 (29)

Source Code Comments

This field specifies the third category of the gift - anonymous, memorial, etc.

Table AGBMGID

Schema Name ALUMNI
Label AGBMGID
Server name MALDEV8_B60
Creation Date 08/15/2002 09:15:52:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGBMGID_EMPR_PIDM AGBMGID_EMPR_PIDM NUMBER(8,0) No *
AGBMGID_EMPL_PIDM AGBMGID_EMPL_PIDM NUMBER(8,0) No *
AGBMGID_EMPL_GIFT_NO AGBMGID_EMPL_GIFT_NO VARCHAR2(7) No *
AGBMGID_AMT AGBMGID_AMT NUMBER(11,2) No
AGBMGID_AMT_PAID AGBMGID_AMT_PAID NUMBER(11,2) No
AGBMGID_STATUS AGBMGID_STATUS VARCHAR2(1) Yes
AGBMGID_DELETE_IND AGBMGID_DELETE_IND VARCHAR2(1) Yes
AGBMGID_ACTIVITY_DATE AGBMGID_ACTIVITY_DATE DATE No
AGBMGID_MG_FORMSENT_IND AGBMGID_MG_FORMSENT_IND VARCHAR2(1) Yes
AGBMGID_SPOUSE_PIDM AGBMGID_SPOUSE_PIDM NUMBER(8,0) Yes
AGBMGID_QUALIFY_AMT AGBMGID_QUALIFY_AMT NUMBER(11,2) Yes
AGBMGID_PGVE_CODE AGBMGID_PGVE_CODE VARCHAR2(5) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
AGBMGID_KEY_INDEX2 AGBMGID_EMPL_PIDM
AGBMGID_KEY_INDEX2 AGBMGID_EMPL_GIFT_NO
AGBMGID_KEY_INDEX3 AGBMGID_EMPR_PIDM
AGBMGID_KEY_INDEX3 AGBMGID_ACTIVITY_DATE
AGBMGID_KEY_INDEX3 AGBMGID_STATUS
PK_AGBMGID Unique AGBMGID_EMPR_PIDM
PK_AGBMGID Unique AGBMGID_EMPL_GIFT_NO
PK_AGBMGID Unique AGBMGID_EMPL_PIDM

Comments

Source Code Comments

Matching Gift Waiting Id Base Table

Columns Comments for AGBMGID_EMPR_PIDM (1)

Source Code Comments

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

Columns Comments for AGBMGID_EMPL_PIDM (2)

Source Code Comments

This field specifies the internal system generated identification number for the employee.

Columns Comments for AGBMGID_EMPL_GIFT_NO (3)

Source Code Comments

This field specifies the gift number of the gift to be matched.

Columns Comments for AGBMGID_AMT (4)

Source Code Comments

This field specifies the amount of the gift to be matched.

Columns Comments for AGBMGID_AMT_PAID (5)

Source Code Comments

This field specifies the amount paid toward the match.

Columns Comments for AGBMGID_STATUS (6)

Source Code Comments

This system maintained field specifies whether a gift has been matched.

Columns Comments for AGBMGID_DELETE_IND (7)

Source Code Comments

This field specifies whether a matching gift is deleted or restored.

Columns Comments for AGBMGID_ACTIVITY_DATE (8)

Source Code Comments

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

Columns Comments for AGBMGID_MG_FORMSENT_IND (9)

Source Code Comments

(Y) - Yes, The MG Form has been sent to the Employer. (N) - No, The MG Form has NOT been sent to the Employer. Null - No, The MG Form has NOT been sent to the Employer.

Columns Comments for AGBMGID_SPOUSE_PIDM (10)

Source Code Comments

The Internal ID of the spouse of the person making the gift that will be matched.

Columns Comments for AGBMGID_QUALIFY_AMT (11)

Source Code Comments

The amount of the gift that qualifies to be matched.

Table AGRGCAM

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRGCAM_PIDM AGRGCAM_PIDM NUMBER(8,0) No * *
AGRGCAM_PIDM AGRGCAM_PIDM NUMBER(8,0) No * *
AGRGCAM_PIDM AGRGCAM_PIDM NUMBER(8,0) No * *
AGRGCAM_PIDM AGRGCAM_PIDM NUMBER(8,0) No * *
AGRGCAM_PIDM AGRGCAM_PIDM NUMBER(8,0) No * *
AGRGCAM_GIFT_NO AGRGCAM_GIFT_NO VARCHAR2(7) No * *
AGRGCAM_GIFT_NO AGRGCAM_GIFT_NO VARCHAR2(7) No * *
AGRGCAM_GIFT_NO AGRGCAM_GIFT_NO VARCHAR2(7) No * *
AGRGCAM_PLEDGE_NO AGRGCAM_PLEDGE_NO VARCHAR2(7) No * *
AGRGCAM_CAMPAIGN AGRGCAM_CAMPAIGN VARCHAR2(5) No * *
AGRGCAM_CAMPAIGN AGRGCAM_CAMPAIGN VARCHAR2(5) No * *
AGRGCAM_AMT AGRGCAM_AMT NUMBER(11,2) No
AGRGCAM_ACTIVITY_DATE AGRGCAM_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRGCAM_CAMPAIGN AGRMCAM_CAMPAIGN AGRMCAM
AGRGCAM_GIFT_NO AGRMCAM_GIFT_NO AGRMCAM
AGRGCAM_PIDM AGBMGID_EMPL_PIDM AGBMGID
AGRGCAM_CAMPAIGN AFBCAMP_CAMPAIGN AFBCAMP
AGRGCAM_PIDM AXBMGID_EMPR_PIDM AXBMGID
AGRGCAM_PLEDGE_NO AXBMGID_PLEDGE_NO AXBMGID
AGRGCAM_PIDM AXBMGID_PIDM AXBMGID
AGRGCAM_GIFT_NO AGRMGIF_EMPR_GIFT_NO AGRMGIF
AGRGCAM_PIDM AGRMGIF_EMPR_PIDM AGRMGIF
AGRGCAM_GIFT_NO AGRMGIF_GIFT_NO AGRMGIF
AGRGCAM_PIDM AGRMGIF_PIDM AGRMGIF

Index

Index Name Index Type Column Name
AGRGCAM_KEY_INDEX2 AGRGCAM_CAMPAIGN
AGRGCAM_KEY_INDEX2 AGRGCAM_GIFT_NO
AGRGCAM_KEY_INDEX2 AGRGCAM_AMT
PK_AGRGCAM Unique AGRGCAM_PIDM
PK_AGRGCAM Unique AGRGCAM_GIFT_NO
PK_AGRGCAM Unique AGRGCAM_PLEDGE_NO
PK_AGRGCAM Unique AGRGCAM_CAMPAIGN

Comments

Source Code Comments

Gift Campaign Repeating Table

Columns Comments for AGRGCAM_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRGCAM_GIFT_NO (2)

Source Code Comments

This field specifies the number of the gift.

Columns Comments for AGRGCAM_PLEDGE_NO (3)

Source Code Comments

This field specifies the number of the pledge.

Columns Comments for AGRGCAM_CAMPAIGN (4)

Source Code Comments

This field specifies the campaign associated with the gift.

Columns Comments for AGRGCAM_AMT (5)

Source Code Comments

This field specifies the amount of the gift.

Columns Comments for AGRGCAM_ACTIVITY_DATE (6)

Source Code Comments

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

Table AGRGDES

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRGDES_PIDM AGRGDES_PIDM NUMBER(8,0) No * *
AGRGDES_PIDM AGRGDES_PIDM NUMBER(8,0) No * *
AGRGDES_PIDM AGRGDES_PIDM NUMBER(8,0) No * *
AGRGDES_PIDM AGRGDES_PIDM NUMBER(8,0) No * *
AGRGDES_PIDM AGRGDES_PIDM NUMBER(8,0) No * *
AGRGDES_PIDM AGRGDES_PIDM NUMBER(8,0) No * *
AGRGDES_PIDM AGRGDES_PIDM NUMBER(8,0) No * *
AGRGDES_PIDM AGRGDES_PIDM NUMBER(8,0) No * *
AGRGDES_GIFT_NO AGRGDES_GIFT_NO VARCHAR2(7) No * *
AGRGDES_GIFT_NO AGRGDES_GIFT_NO VARCHAR2(7) No * *
AGRGDES_GIFT_NO AGRGDES_GIFT_NO VARCHAR2(7) No * *
AGRGDES_GIFT_NO AGRGDES_GIFT_NO VARCHAR2(7) No * *
AGRGDES_GIFT_NO AGRGDES_GIFT_NO VARCHAR2(7) No * *
AGRGDES_GIFT_NO AGRGDES_GIFT_NO VARCHAR2(7) No * *
AGRGDES_PLEDGE_NO AGRGDES_PLEDGE_NO VARCHAR2(7) No * *
AGRGDES_PLEDGE_NO AGRGDES_PLEDGE_NO VARCHAR2(7) No * *
AGRGDES_PLEDGE_NO AGRGDES_PLEDGE_NO VARCHAR2(7) No * *
AGRGDES_PLEDGE_NO AGRGDES_PLEDGE_NO VARCHAR2(7) No * *
AGRGDES_CAMPAIGN AGRGDES_CAMPAIGN VARCHAR2(5) No * *
AGRGDES_CAMPAIGN AGRGDES_CAMPAIGN VARCHAR2(5) No * *
AGRGDES_CAMPAIGN AGRGDES_CAMPAIGN VARCHAR2(5) No * *
AGRGDES_CAMPAIGN AGRGDES_CAMPAIGN VARCHAR2(5) No * *
AGRGDES_DESG AGRGDES_DESG VARCHAR2(10) No * *
AGRGDES_DESG AGRGDES_DESG VARCHAR2(10) No * *
AGRGDES_DESG AGRGDES_DESG VARCHAR2(10) No * *
AGRGDES_AMT AGRGDES_AMT NUMBER(11,2) No
AGRGDES_ACTIVITY_DATE AGRGDES_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRGDES_PIDM AGBMGID_EMPL_PIDM AGBMGID
AGRGDES_PIDM AGRGMLT_PIDM AGRGMLT
AGRGDES_PLEDGE_NO AGRGMLT_PLEDGE_NO AGRGMLT
AGRGDES_GIFT_NO AGRGMLT_GIFT_NO AGRGMLT
AGRGDES_CAMPAIGN AGRGMLT_CAMPAIGN AGRGMLT
AGRGDES_DESG AGRGMLT_DESG AGRGMLT
AGRGDES_PIDM AGRGMMO_PIDM AGRGMMO
AGRGDES_PLEDGE_NO AGRGMMO_PLEDGE_NO AGRGMMO
AGRGDES_GIFT_NO AGRGMMO_GIFT_NO AGRGMMO
AGRGDES_CAMPAIGN AGRGMMO_CAMPAIGN AGRGMMO
AGRGDES_DESG AGRGMMO_DESG AGRGMMO
AGRGDES_DESG AGRMDES_DESG AGRMDES
AGRGDES_GIFT_NO AGRMDES_GIFT_NO AGRMDES
AGRGDES_CAMPAIGN AGRMDES_CAMPAIGN AGRMDES
AGRGDES_PIDM AXBMGID_EMPR_PIDM AXBMGID
AGRGDES_PLEDGE_NO AXBMGID_PLEDGE_NO AXBMGID
AGRGDES_PIDM AXBMGID_PIDM AXBMGID
AGRGDES_GIFT_NO AGRMGIF_EMPR_GIFT_NO AGRMGIF
AGRGDES_PIDM AGRMGIF_EMPR_PIDM AGRMGIF
AGRGDES_GIFT_NO AGRMGIF_GIFT_NO AGRMGIF
AGRGDES_PIDM AGRMGIF_PIDM AGRMGIF
AGRGDES_PIDM AGRGCAM_PIDM AGRGCAM
AGRGDES_GIFT_NO AGRGCAM_GIFT_NO AGRGCAM
AGRGDES_PLEDGE_NO AGRGCAM_PLEDGE_NO AGRGCAM
AGRGDES_CAMPAIGN AGRGCAM_CAMPAIGN AGRGCAM

Index

Index Name Index Type Column Name
AGRGDES_KEY_INDEX2 AGRGDES_DESG
AGRGDES_KEY_INDEX2 AGRGDES_GIFT_NO
AGRGDES_KEY_INDEX2 AGRGDES_AMT
AGRGDES_KEY_INDEX3 AGRGDES_PIDM
AGRGDES_KEY_INDEX3 AGRGDES_PLEDGE_NO
AGRGDES_KEY_INDEX4 AGRGDES_CAMPAIGN
AGRGDES_KEY_INDEX4 AGRGDES_DESG
PK_AGRGDES Unique AGRGDES_PIDM
PK_AGRGDES Unique AGRGDES_GIFT_NO
PK_AGRGDES Unique AGRGDES_PLEDGE_NO
PK_AGRGDES Unique AGRGDES_CAMPAIGN
PK_AGRGDES Unique AGRGDES_DESG

Comments

Source Code Comments

Gift Designation Repeating Table

Columns Comments for AGRGDES_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRGDES_GIFT_NO (2)

Source Code Comments

This field specifies the number of the gift.

Columns Comments for AGRGDES_PLEDGE_NO (3)

Source Code Comments

This field specifies the number of the pledge.

Columns Comments for AGRGDES_CAMPAIGN (4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRGDES_DESG (5)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRGDES_AMT (6)

Source Code Comments

This field specifies the amount of the gift designation.

Columns Comments for AGRGDES_ACTIVITY_DATE (7)

Source Code Comments

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

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 AGRGSOL

Schema Name ALUMNI
Label AGRGSOL
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
AGRGSOL_PIDM AGRGSOL_PIDM NUMBER(8,0) No *
AGRGSOL_GIFT_NO AGRGSOL_GIFT_NO VARCHAR2(7) No *
AGRGSOL_PLEDGE_NO AGRGSOL_PLEDGE_NO VARCHAR2(7) No *
AGRGSOL_CAMPAIGN AGRGSOL_CAMPAIGN VARCHAR2(5) No *
AGRGSOL_CAMPAIGN AGRGSOL_CAMPAIGN VARCHAR2(5) No *
AGRGSOL_SOLC_CODE AGRGSOL_SOLC_CODE VARCHAR2(8) Yes *