AGBCTRL AGBIDRL AGBPDEF AGBSPRL AGRACKR AGRADJR AGRAKCP AGRAKCT AGRAKDC AGRAKDG AGRAKDN AGRAKEX AGRAKGC AGRAKGT AGRAKPC AGRIDRL AGRSPRL APRXREF ATVXREF AUBCTRL

Model Pedge & Gift Rules


Model Label : BANNER Advancement Pledge and Gift Processing Rules
Path : BANNER DEV/Advancement/Advancement_ERD/PedgeGiftRules_ERD

List of Objects

Object Name Object Type Layer Name
AGBCTRL TABLE Default
AGBIDRL TABLE Default
AGBPDEF TABLE Default
AGBSPRL TABLE Default
AGRACKR TABLE Default
AGRADJR TABLE Default
AGRAKCP TABLE Default
AGRAKCT TABLE Default
AGRAKDC TABLE Default
AGRAKDG TABLE Default
AGRAKDN TABLE Default
AGRAKEX TABLE Default
AGRAKGC TABLE Default
AGRAKGT TABLE Default
AGRAKPC TABLE Default
AGRIDRL TABLE Default
AGRSPRL TABLE Default
APRXREF TABLE Default
ATVXREF TABLE Default
AUBCTRL TABLE Default

Comments

Model View

''

Table AGBCTRL

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGBCTRL_USER AGBCTRL_USER VARCHAR2(30) No *
AGBCTRL_ACTIVITY_DATE AGBCTRL_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_AGBCTRL Unique AGBCTRL_USER

Comments

Source Code Comments

Control Defaults Table

Columns Comments for AGBCTRL_USER (1)

Source Code Comments

This field specifies the user id for the cashiering supervisor.

Columns Comments for AGBCTRL_ACTIVITY_DATE (2)

Source Code Comments

This field specifies the date of last change.

Table AGBIDRL

Schema Name ALUMNI
Label AGBIDRL
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
AGBIDRL_PIDM AGBIDRL_PIDM NUMBER(8,0) No *
AGBIDRL_XREF_CODE AGBIDRL_XREF_CODE VARCHAR2(3) No *
AGBIDRL_XREF_CODE AGBIDRL_XREF_CODE VARCHAR2(3) No *
AGBIDRL_XREF_PRIORITY AGBIDRL_XREF_PRIORITY NUMBER(5,2) No
AGBIDRL_NO_SPLIT_IND AGBIDRL_NO_SPLIT_IND VARCHAR2(1) No
AGBIDRL_ACTIVITY_DATE AGBIDRL_ACTIVITY_DATE DATE No
AGBIDRL_PERCENT_DFLT AGBIDRL_PERCENT_DFLT NUMBER(5,2) No
AGBIDRL_MULT_MEM_IND AGBIDRL_MULT_MEM_IND VARCHAR2(1) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
AGBIDRL_PIDM APRXREF_PIDM APRXREF
AGBIDRL_XREF_CODE APRXREF_XREF_CODE APRXREF
AGBIDRL_XREF_CODE ATVXREF_CODE ATVXREF

Index

Index Name Index Type Column Name
AGBIDRL_KEY_INDEX Unique AGBIDRL_PIDM
AGBIDRL_KEY_INDEX Unique AGBIDRL_XREF_PRIORITY
AGBIDRL_KEY_INDEX2 Unique AGBIDRL_PIDM
AGBIDRL_KEY_INDEX2 Unique AGBIDRL_XREF_CODE

Comments

Source Code Comments

Split Pledge/Gift Rule for ID Base Table

Columns Comments for AGBIDRL_PIDM (1)

Source Code Comments

Internal system generated identification number.

Columns Comments for AGBIDRL_XREF_CODE (2)

Source Code Comments

Cross reference code of ID for rule for multiple or memo information.

Columns Comments for AGBIDRL_XREF_PRIORITY (3)

Source Code Comments

Cross reference priority number of ID for multiple or memo.

Columns Comments for AGBIDRL_NO_SPLIT_IND (4)

Source Code Comments

No split indicator if set to yes will not allow splits for the individual specified.

Columns Comments for AGBIDRL_ACTIVITY_DATE (5)

Source Code Comments

Date this record was inserted or last updated.

Columns Comments for AGBIDRL_PERCENT_DFLT (6)

Source Code Comments

Cross reference percentage of pledge/gift for ID that is multipled or memoed.

Columns Comments for AGBIDRL_MULT_MEM_IND (7)

Source Code Comments

Multiple (H) Memo (S) indicator to assign hard or soft credit to the split.

Table AGBPDEF

Schema Name ALUMNI
Label AGBPDEF
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
AGBPDEF_USER AGBPDEF_USER VARCHAR2(30) No
AGBPDEF_CAMPAIGN AGBPDEF_CAMPAIGN VARCHAR2(5) Yes
AGBPDEF_DESG AGBPDEF_DESG VARCHAR2(10) Yes
AGBPDEF_ACTIVITY_DATE AGBPDEF_ACTIVITY_DATE DATE No
AGBPDEF_GIFT_CODE AGBPDEF_GIFT_CODE VARCHAR2(2) Yes
AGBPDEF_GCLS_CODE AGBPDEF_GCLS_CODE VARCHAR2(4) Yes
AGBPDEF_GIFT_PLDG_IND AGBPDEF_GIFT_PLDG_IND VARCHAR2(1) Yes
AGBPDEF_MATCH_RECEIVED AGBPDEF_MATCH_RECEIVED VARCHAR2(1) Yes
AGBPDEF_PSTA_CODE AGBPDEF_PSTA_CODE VARCHAR2(1) Yes
AGBPDEF_PLDG_CODE AGBPDEF_PLDG_CODE VARCHAR2(2) Yes
AGBPDEF_PCLS_CODE AGBPDEF_PCLS_CODE VARCHAR2(4) Yes
AGBPDEF_PDUR_CODE AGBPDEF_PDUR_CODE VARCHAR2(1) Yes
AGBPDEF_FREQ_CODE AGBPDEF_FREQ_CODE VARCHAR2(2) Yes
AGBPDEF_PRMD_CODE AGBPDEF_PRMD_CODE VARCHAR2(2) Yes
AGBPDEF_DEFAULT_DATE AGBPDEF_DEFAULT_DATE DATE Yes
AGBPDEF_SOLC_CODE AGBPDEF_SOLC_CODE VARCHAR2(8) Yes
AGBPDEF_SOL_ORG AGBPDEF_SOL_ORG VARCHAR2(5) Yes *
AGBPDEF_SOL_PIDM AGBPDEF_SOL_PIDM NUMBER(8,0) Yes
AGBPDEF_PCAT_CODE AGBPDEF_PCAT_CODE VARCHAR2(5) Yes *
AGBPDEF_CTYP_CODE AGBPDEF_CTYP_CODE VARCHAR2(5) Yes *
AGBPDEF_SCNT_CODE AGBPDEF_SCNT_CODE VARCHAR2(3) Yes *
AGBPDEF_SCRS_CODE AGBPDEF_SCRS_CODE VARCHAR2(3) Yes *
AGBPDEF_PGVE_CODE AGBPDEF_PGVE_CODE VARCHAR2(5) Yes *
AGBPDEF_DNAM_CODE AGBPDEF_DNAM_CODE VARCHAR2(10) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
AGBPDEF_PGVE_CODE ATVPGVE_CODE ATVPGVE
AGBPDEF_DNAM_CODE ATVDNAM_CODE ATVDNAM
AGBPDEF_PCAT_CODE ATVPCAT_CODE ATVPCAT
AGBPDEF_SCNT_CODE ATVSCNT_CODE ATVSCNT
AGBPDEF_SCRS_CODE ATVSCRS_CODE ATVSCRS
AGBPDEF_SOL_ORG ASBSORG_SOL_ORG ASBSORG
AGBPDEF_CTYP_CODE ATVCTYP_CODE ATVCTYP

Index

No Result

Comments

Source Code Comments

Pledge/Gift Default Camp/Desg

Columns Comments for AGBPDEF_USER (1)

Source Code Comments

This system maintained field specifies the user name.

Columns Comments for AGBPDEF_CAMPAIGN (2)

Source Code Comments

This field specifies the campaign to which a designation is defaulted.

Columns Comments for AGBPDEF_DESG (3)

Source Code Comments

This field specifies the designation which is defaulted to an associated campaign.

Columns Comments for AGBPDEF_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for AGBPDEF_GIFT_CODE (5)

Source Code Comments

Default gift type.

Columns Comments for AGBPDEF_GCLS_CODE (6)

Source Code Comments

Default gift class on the gift form.

Columns Comments for AGBPDEF_GIFT_PLDG_IND (7)

Source Code Comments

Default value for gift/pledge indicator. Used to determine defaults for gift form.

Columns Comments for AGBPDEF_MATCH_RECEIVED (8)

Source Code Comments

Default matching gift form received indicator.

Columns Comments for AGBPDEF_PSTA_CODE (9)

Source Code Comments

Default pledge status when creating a new pledge on the gift form.

Columns Comments for AGBPDEF_PLDG_CODE (10)

Source Code Comments

Default pledge type on the gift form.

Columns Comments for AGBPDEF_PCLS_CODE (11)

Source Code Comments

Default pledge class on the gift form when a pledge is created.

Columns Comments for AGBPDEF_PDUR_CODE (12)

Source Code Comments

Default pledge installment duration on the gift form when installments are being created.

Columns Comments for AGBPDEF_FREQ_CODE (13)

Source Code Comments

Default pledge installment frequency code on gift form when pledge installment are created.

Columns Comments for AGBPDEF_PRMD_CODE (14)

Source Code Comments

Default pledge installment reminder code on the gift form when pledge installments are created.

Columns Comments for AGBPDEF_DEFAULT_DATE (15)

Source Code Comments

Default date for pledge/gift on gift form.

Columns Comments for AGBPDEF_SOLC_CODE (16)

Source Code Comments

Default solicitaion type on the gift form for pledges and gifts that are created.

Columns Comments for AGBPDEF_SOL_ORG (17)

Source Code Comments

Default solicitation organization for pledges and gifts created on the gift form.

Columns Comments for AGBPDEF_SOL_PIDM (18)

Source Code Comments

Default solicitor pidm for pledge and gift solicitaion created on the gift form.

Columns Comments for AGBPDEF_PCAT_CODE (19)

Source Code Comments

Default Pledge Category Code.

Columns Comments for AGBPDEF_CTYP_CODE (20)

Source Code Comments

Default Condition Type Code.

Columns Comments for AGBPDEF_SCNT_CODE (21)

Source Code Comments

Default Solicitor Contact Code

Columns Comments for AGBPDEF_SCRS_CODE (22)

Source Code Comments

Default Solicitor Contact Result Code

Columns Comments for AGBPDEF_PGVE_CODE (23)

Source Code Comments

The default Pledge Gift Vehicle Code for the User ID.

Columns Comments for AGBPDEF_DNAM_CODE (24)

Source Code Comments

The Default Name Code associated with this users Pledge defaults.

Table AGBSPRL

Schema Name ALUMNI
Label AGBSPRL
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
AGBSPRL_XREF_CODE AGBSPRL_XREF_CODE VARCHAR2(3) No * *
AGBSPRL_XREF_PRIORITY AGBSPRL_XREF_PRIORITY NUMBER(5,2) No *
AGBSPRL_PERCENT_DFLT AGBSPRL_PERCENT_DFLT NUMBER(5,2) No
AGBSPRL_MULT_MEM_IND AGBSPRL_MULT_MEM_IND VARCHAR2(1) No
AGBSPRL_ACTIVITY_DATE AGBSPRL_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGBSPRL_XREF_CODE ATVXREF_CODE ATVXREF

Index

Index Name Index Type Column Name
PK_AGBSPRL Unique AGBSPRL_XREF_CODE
PK_AGBSPRL Unique AGBSPRL_XREF_PRIORITY

Comments

Source Code Comments

Split Pledge/GifT Rule Base Table

Columns Comments for AGBSPRL_XREF_CODE (1)

Source Code Comments

Cross reference code of rule for multiple or memo information.

Columns Comments for AGBSPRL_XREF_PRIORITY (2)

Source Code Comments

Cross reference priority number for multiple or memo.

Columns Comments for AGBSPRL_PERCENT_DFLT (3)

Source Code Comments

Cross reference percentage of pledge/gift that is multipled or memoed.

Columns Comments for AGBSPRL_MULT_MEM_IND (4)

Source Code Comments

Multiple (H) Memo (S) indicator to assign hard or soft credit to the split.

Columns Comments for AGBSPRL_ACTIVITY_DATE (5)

Source Code Comments

Date this record was inserted or last updated.

Table AGRACKR

Schema Name ALUMNI
Label AGRACKR
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
AGRACKR_RULE_NO AGRACKR_RULE_NO NUMBER(2,0) No *
AGRACKR_RULE_PRTY AGRACKR_RULE_PRTY NUMBER(2,0) No
AGRACKR_LETR_CODE AGRACKR_LETR_CODE VARCHAR2(15) No * *
AGRACKR_DOLLAR_FROM AGRACKR_DOLLAR_FROM NUMBER(13,2) Yes
AGRACKR_DOLLAR_TO AGRACKR_DOLLAR_TO NUMBER(13,2) Yes
AGRACKR_GIFT_PLDG_IND AGRACKR_GIFT_PLDG_IND VARCHAR2(1) Yes
AGRACKR_PLEDGE_IND AGRACKR_PLEDGE_IND VARCHAR2(1) Yes
AGRACKR_MTCH_GIFT_IND AGRACKR_MTCH_GIFT_IND VARCHAR2(1) Yes
AGRACKR_LETR_CODE_EMPL AGRACKR_LETR_CODE_EMPL VARCHAR2(15) Yes *
AGRACKR_LETR_IND AGRACKR_LETR_IND VARCHAR2(1) Yes
AGRACKR_RECPT_IND AGRACKR_RECPT_IND VARCHAR2(1) Yes
AGRACKR_LETR_CODE_RECPT AGRACKR_LETR_CODE_RECPT VARCHAR2(15) Yes *
AGRACKR_RULE_STATUS AGRACKR_RULE_STATUS VARCHAR2(1) Yes
AGRACKR_RULE_DATE AGRACKR_RULE_DATE DATE Yes
AGRACKR_ACTIVITY_DATE AGRACKR_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_AGRACKR Unique AGRACKR_LETR_CODE
PK_AGRACKR Unique AGRACKR_RULE_NO

Comments

Source Code Comments

Gift Acknowledgement Rules Table

Columns Comments for AGRACKR_RULE_NO (1)

Source Code Comments

This field specifies the internal system generated rule number.

Columns Comments for AGRACKR_RULE_PRTY (2)

Source Code Comments

This field specifies the priority order of rule number.

Columns Comments for AGRACKR_LETR_CODE (3)

Source Code Comments

This field specifies the letter code.

Columns Comments for AGRACKR_DOLLAR_FROM (4)

Source Code Comments

This field specifies begin range of dollar amounts for gift acknowledgement.

Columns Comments for AGRACKR_DOLLAR_TO (5)

Source Code Comments

This field specifies the end range of dollar amounts for gift acknowledgement.

Columns Comments for AGRACKR_GIFT_PLDG_IND (6)

Source Code Comments

This field specifies a gift, pledge payment, or both for gift acknowledgment.

Columns Comments for AGRACKR_PLEDGE_IND (7)

Source Code Comments

This field specifies a pledge for gift acknowledgement.

Columns Comments for AGRACKR_MTCH_GIFT_IND (8)

Source Code Comments

This field specifies if employee matching gift qualified for gift acknowledgement.

Columns Comments for AGRACKR_LETR_CODE_EMPL (9)

Source Code Comments

This field specifies which letter an employee gets if there is a matching gift.

Columns Comments for AGRACKR_LETR_IND (10)

Source Code Comments

This field specifies if a letter is associated with rule.

Columns Comments for AGRACKR_RECPT_IND (11)

Source Code Comments

This field specifies if a receipt is associated with rule.

Columns Comments for AGRACKR_LETR_CODE_RECPT (12)

Source Code Comments

This field specifies which receipt is associated with rule.

Columns Comments for AGRACKR_RULE_STATUS (13)

Source Code Comments

This field specifies if a rule is active or inactive.

Columns Comments for AGRACKR_RULE_DATE (14)

Source Code Comments

This field specifies the date the rule is inactive.

Columns Comments for AGRACKR_ACTIVITY_DATE (15)

Source Code Comments

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

Table AGRADJR

Schema Name ALUMNI
Label AGRADJR
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
AGRADJR_FIELD_NAME AGRADJR_FIELD_NAME VARCHAR2(20) No *
AGRADJR_DESC AGRADJR_DESC VARCHAR2(30) No
AGRADJR_ADJ_PLDG_IND AGRADJR_ADJ_PLDG_IND VARCHAR2(1) No
AGRADJR_ADJ_GIFT_IND AGRADJR_ADJ_GIFT_IND VARCHAR2(1) No
AGRADJR_ACTIVITY_DATE AGRADJR_ACTIVITY_DATE DATE No
AGRADJR_ADJ_DUES_IND AGRADJR_ADJ_DUES_IND VARCHAR2(1) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_AGRADJR Unique AGRADJR_FIELD_NAME

Comments

Source Code Comments

Prior Years Adjustment Rule Table

Columns Comments for AGRADJR_FIELD_NAME (1)

Source Code Comments

Gift/Pledge Adjustment field name to be adjusted.

Columns Comments for AGRADJR_DESC (2)

Source Code Comments

This field is the decription of the adjustment field.

Columns Comments for AGRADJR_ADJ_PLDG_IND (3)

Source Code Comments

Adjust pledge fields indicator.

Columns Comments for AGRADJR_ADJ_GIFT_IND (4)

Source Code Comments

Adjust gift fields indicator.

Columns Comments for AGRADJR_ACTIVITY_DATE (5)

Source Code Comments

Date of last change.

Columns Comments for AGRADJR_ADJ_DUES_IND (6)

Source Code Comments

Adjust dues fields indicator.

Table AGRAKCP

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRAKCP_RULE_NO AGRAKCP_RULE_NO NUMBER(2,0) No * *
AGRAKCP_LETR_CODE AGRAKCP_LETR_CODE VARCHAR2(15) No * *
AGRAKCP_LETR_CODE AGRAKCP_LETR_CODE VARCHAR2(15) No * *
AGRAKCP_CAMPAIGN AGRAKCP_CAMPAIGN VARCHAR2(5) No *
AGRAKCP_INCL_EXCL_IND AGRAKCP_INCL_EXCL_IND VARCHAR2(1) No
AGRAKCP_ACTIVITY_DATE AGRAKCP_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRAKCP_LETR_CODE AGRACKR_LETR_CODE AGRACKR
AGRAKCP_RULE_NO AGRACKR_RULE_NO AGRACKR
AGRAKCP_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_AGRAKCP Unique AGRAKCP_RULE_NO
PK_AGRAKCP Unique AGRAKCP_LETR_CODE
PK_AGRAKCP Unique AGRAKCP_CAMPAIGN

Comments

Source Code Comments

Gift Acknowledgement Campaign Table

Columns Comments for AGRAKCP_RULE_NO (1)

Source Code Comments

This field specifies an internal system genenerated number for rule number.

Columns Comments for AGRAKCP_LETR_CODE (2)

Source Code Comments

This field specifies letter code associated with rule number.

Columns Comments for AGRAKCP_CAMPAIGN (3)

Source Code Comments

This field specifies the campaign associated with rule and letter code.

Columns Comments for AGRAKCP_INCL_EXCL_IND (4)

Source Code Comments

This field specifies whether to include or exclude the campaign.

Columns Comments for AGRAKCP_ACTIVITY_DATE (5)

Source Code Comments

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

Table AGRAKCT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRAKCT_RULE_NO AGRAKCT_RULE_NO NUMBER(2,0) No * *
AGRAKCT_LETR_CODE AGRAKCT_LETR_CODE VARCHAR2(15) No * *
AGRAKCT_LETR_CODE AGRAKCT_LETR_CODE VARCHAR2(15) No * *
AGRAKCT_CMTP_CODE AGRAKCT_CMTP_CODE VARCHAR2(2) No * *
AGRAKCT_INCL_EXCL_IND AGRAKCT_INCL_EXCL_IND VARCHAR2(1) No
AGRAKCT_ACTIVITY_DATE AGRAKCT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRAKCT_LETR_CODE AGRACKR_LETR_CODE AGRACKR
AGRAKCT_RULE_NO AGRACKR_RULE_NO AGRACKR
AGRAKCT_CMTP_CODE ATVCMTP_CODE ATVCMTP
AGRAKCT_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_AGRAKCT Unique AGRAKCT_RULE_NO
PK_AGRAKCT Unique AGRAKCT_LETR_CODE
PK_AGRAKCT Unique AGRAKCT_CMTP_CODE

Comments

Source Code Comments

Gift Acknowledgement Campaign Types Table

Columns Comments for AGRAKCT_RULE_NO (1)

Source Code Comments

This field specifies the internal generated number for rule number.

Columns Comments for AGRAKCT_LETR_CODE (2)

Source Code Comments

This field specifies the letter code.

Columns Comments for AGRAKCT_CMTP_CODE (3)

Source Code Comments

This field specifies the campaign type associated with rule and letter code.

Columns Comments for AGRAKCT_INCL_EXCL_IND (4)

Source Code Comments

This field specifies whether to include or exclude campaign type for rule and letter code.

Columns Comments for AGRAKCT_ACTIVITY_DATE (5)

Source Code Comments

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

Table AGRAKDC

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRAKDC_RULE_NO AGRAKDC_RULE_NO NUMBER(2,0) No * *
AGRAKDC_LETR_CODE AGRAKDC_LETR_CODE VARCHAR2(15) No * *
AGRAKDC_LETR_CODE AGRAKDC_LETR_CODE VARCHAR2(15) No * *
AGRAKDC_DCNP_CODE AGRAKDC_DCNP_CODE VARCHAR2(4) No * *
AGRAKDC_INCL_EXCL_IND AGRAKDC_INCL_EXCL_IND VARCHAR2(1) No
AGRAKDC_ACTIVITY_DATE AGRAKDC_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRAKDC_LETR_CODE AGRACKR_LETR_CODE AGRACKR
AGRAKDC_RULE_NO AGRACKR_RULE_NO AGRACKR
AGRAKDC_DCNP_CODE ATVDCNP_CODE ATVDCNP
AGRAKDC_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_AGRAKDC Unique AGRAKDC_RULE_NO
PK_AGRAKDC Unique AGRAKDC_LETR_CODE
PK_AGRAKDC Unique AGRAKDC_DCNP_CODE

Comments

Source Code Comments

Gift Acknowledgement Donor Club Table

Columns Comments for AGRAKDC_RULE_NO (1)

Source Code Comments

This field specifies the internal generated rule number.

Columns Comments for AGRAKDC_LETR_CODE (2)

Source Code Comments

This field specifies the letter code for the rule number.

Columns Comments for AGRAKDC_DCNP_CODE (3)

Source Code Comments

This field specifies the donor club associated with rule and letter code.

Columns Comments for AGRAKDC_INCL_EXCL_IND (4)

Source Code Comments

This field specifies to include or exclude donor club for rule and letter code.

Columns Comments for AGRAKDC_ACTIVITY_DATE (5)

Source Code Comments

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

Table AGRAKDG

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRAKDG_RULE_NO AGRAKDG_RULE_NO NUMBER(2,0) No * *
AGRAKDG_LETR_CODE AGRAKDG_LETR_CODE VARCHAR2(15) No * *
AGRAKDG_LETR_CODE AGRAKDG_LETR_CODE VARCHAR2(15) No * *
AGRAKDG_DESG AGRAKDG_DESG VARCHAR2(10) No *
AGRAKDG_INCL_EXCL_IND AGRAKDG_INCL_EXCL_IND VARCHAR2(1) No
AGRAKDG_ACTIVITY_DATE AGRAKDG_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRAKDG_LETR_CODE AGRACKR_LETR_CODE AGRACKR
AGRAKDG_RULE_NO AGRACKR_RULE_NO AGRACKR
AGRAKDG_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_AGRAKDG Unique AGRAKDG_RULE_NO
PK_AGRAKDG Unique AGRAKDG_LETR_CODE
PK_AGRAKDG Unique AGRAKDG_DESG

Comments

Source Code Comments

Gift Acknowledgement Designation Table

Columns Comments for AGRAKDG_RULE_NO (1)

Source Code Comments

This field specifies the internal generated rule number.

Columns Comments for AGRAKDG_LETR_CODE (2)

Source Code Comments

This field specifies the letter code associated with rule number.

Columns Comments for AGRAKDG_DESG (3)

Source Code Comments

This field specifies the designation associated with the rule and letter code.

Columns Comments for AGRAKDG_INCL_EXCL_IND (4)

Source Code Comments

This field specifies to include or exclude designation for rule and letter code.

Columns Comments for AGRAKDG_ACTIVITY_DATE (5)

Source Code Comments

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

Table AGRAKDN

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRAKDN_RULE_NO AGRAKDN_RULE_NO NUMBER(2,0) No * *
AGRAKDN_LETR_CODE AGRAKDN_LETR_CODE VARCHAR2(15) No * *
AGRAKDN_LETR_CODE AGRAKDN_LETR_CODE VARCHAR2(15) No * *
AGRAKDN_DONR_CODE AGRAKDN_DONR_CODE VARCHAR2(4) No * *
AGRAKDN_INCL_EXCL_IND AGRAKDN_INCL_EXCL_IND VARCHAR2(1) No
AGRAKDN_ACTIVITY_DATE AGRAKDN_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRAKDN_DONR_CODE ATVDONR_CODE ATVDONR
AGRAKDN_LETR_CODE AGRACKR_LETR_CODE AGRACKR
AGRAKDN_RULE_NO AGRACKR_RULE_NO AGRACKR
AGRAKDN_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_AGRAKDN Unique AGRAKDN_RULE_NO
PK_AGRAKDN Unique AGRAKDN_LETR_CODE
PK_AGRAKDN Unique AGRAKDN_DONR_CODE

Comments

Source Code Comments

Gift Acknowledgement Donor Categories Table

Columns Comments for AGRAKDN_RULE_NO (1)

Source Code Comments

This field specifies the internal generated number for rule number.

Columns Comments for AGRAKDN_LETR_CODE (2)

Source Code Comments

This field specifies the letter code associated with rule number.

Columns Comments for AGRAKDN_DONR_CODE (3)

Source Code Comments

This field specifies the donor code associated with rule and letter code.

Columns Comments for AGRAKDN_INCL_EXCL_IND (4)

Source Code Comments

This field specifies to include or exclude donor code for rule and letter code.

Columns Comments for AGRAKDN_ACTIVITY_DATE (5)

Source Code Comments

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

Table AGRAKEX

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRAKEX_RULE_NO AGRAKEX_RULE_NO NUMBER(2,0) No * *
AGRAKEX_LETR_CODE AGRAKEX_LETR_CODE VARCHAR2(15) No * *
AGRAKEX_LETR_CODE AGRAKEX_LETR_CODE VARCHAR2(15) No * *
AGRAKEX_EXCL_CODE AGRAKEX_EXCL_CODE VARCHAR2(3) No * *
AGRAKEX_INCL_EXCL_IND AGRAKEX_INCL_EXCL_IND VARCHAR2(1) No
AGRAKEX_ACTIVITY_DATE AGRAKEX_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRAKEX_EXCL_CODE ATVEXCL_CODE ATVEXCL
AGRAKEX_LETR_CODE AGRACKR_LETR_CODE AGRACKR
AGRAKEX_RULE_NO AGRACKR_RULE_NO AGRACKR
AGRAKEX_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_AGRAKEX Unique AGRAKEX_RULE_NO
PK_AGRAKEX Unique AGRAKEX_LETR_CODE
PK_AGRAKEX Unique AGRAKEX_EXCL_CODE

Comments

Source Code Comments

Gift Acknowledgement Exclusion Code Table

Columns Comments for AGRAKEX_RULE_NO (1)

Source Code Comments

This field specifies the internal generated number for rule number.

Columns Comments for AGRAKEX_LETR_CODE (2)

Source Code Comments

This field specifies the letter code associated with rule number.

Columns Comments for AGRAKEX_EXCL_CODE (3)

Source Code Comments

This field specifies the exclusion code associated with rule and letter code.

Columns Comments for AGRAKEX_INCL_EXCL_IND (4)

Source Code Comments

This field specifies to include or exclude exclusion code for rule and letter code.

Columns Comments for AGRAKEX_ACTIVITY_DATE (5)

Source Code Comments

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

Table AGRAKGC

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRAKGC_RULE_NO AGRAKGC_RULE_NO NUMBER(2,0) No * *
AGRAKGC_LETR_CODE AGRAKGC_LETR_CODE VARCHAR2(15) No * *
AGRAKGC_LETR_CODE AGRAKGC_LETR_CODE VARCHAR2(15) No * *
AGRAKGC_GCLS_CODE AGRAKGC_GCLS_CODE VARCHAR2(4) No * *
AGRAKGC_INCL_EXCL_IND AGRAKGC_INCL_EXCL_IND VARCHAR2(1) No
AGRAKGC_ACTIVITY_DATE AGRAKGC_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRAKGC_GCLS_CODE ATVGCLS_CODE ATVGCLS
AGRAKGC_LETR_CODE AGRACKR_LETR_CODE AGRACKR
AGRAKGC_RULE_NO AGRACKR_RULE_NO AGRACKR
AGRAKGC_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_AGRAKGC Unique AGRAKGC_RULE_NO
PK_AGRAKGC Unique AGRAKGC_LETR_CODE
PK_AGRAKGC Unique AGRAKGC_GCLS_CODE

Comments

Source Code Comments

Gift Acknowledgement Gift Class Table

Columns Comments for AGRAKGC_RULE_NO (1)

Source Code Comments

This field specifies the internal generated number for rule number.

Columns Comments for AGRAKGC_LETR_CODE (2)

Source Code Comments

This field specifies the letter code associated with the rule number.

Columns Comments for AGRAKGC_GCLS_CODE (3)

Source Code Comments

This field specifies the gift class associated with rule and letter code.

Columns Comments for AGRAKGC_INCL_EXCL_IND (4)

Source Code Comments

This field specifies to include or exclude gift class for rule and letter code.

Columns Comments for AGRAKGC_ACTIVITY_DATE (5)

Source Code Comments

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

Table AGRAKGT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRAKGT_RULE_NO AGRAKGT_RULE_NO NUMBER(2,0) No * *
AGRAKGT_LETR_CODE AGRAKGT_LETR_CODE VARCHAR2(15) No * *
AGRAKGT_LETR_CODE AGRAKGT_LETR_CODE VARCHAR2(15) No * *
AGRAKGT_GIFT_CODE AGRAKGT_GIFT_CODE VARCHAR2(2) No * *
AGRAKGT_INCL_EXCL_IND AGRAKGT_INCL_EXCL_IND VARCHAR2(1) No
AGRAKGT_ACTIVITY_DATE AGRAKGT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRAKGT_LETR_CODE AGRACKR_LETR_CODE AGRACKR
AGRAKGT_RULE_NO AGRACKR_RULE_NO AGRACKR
AGRAKGT_GIFT_CODE ATVGIFT_CODE ATVGIFT
AGRAKGT_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_AGRAKGT Unique AGRAKGT_RULE_NO
PK_AGRAKGT Unique AGRAKGT_LETR_CODE
PK_AGRAKGT Unique AGRAKGT_GIFT_CODE

Comments

Source Code Comments

Gift Acknowledgement Gift Type Table

Columns Comments for AGRAKGT_RULE_NO (1)

Source Code Comments

This field specifies the internal generated number for rule number.

Columns Comments for AGRAKGT_LETR_CODE (2)

Source Code Comments

This field specifies the letter code associated with the rule number.

Columns Comments for AGRAKGT_GIFT_CODE (3)

Source Code Comments

This field specifies the gift type associated with the rule and letter code.

Columns Comments for AGRAKGT_INCL_EXCL_IND (4)

Source Code Comments

This field specifies to include or exclude gift type for rule and letter code.

Columns Comments for AGRAKGT_ACTIVITY_DATE (5)

Source Code Comments

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

Table AGRAKPC

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRAKPC_RULE_NO AGRAKPC_RULE_NO NUMBER(2,0) No * *
AGRAKPC_LETR_CODE AGRAKPC_LETR_CODE VARCHAR2(15) No * *
AGRAKPC_LETR_CODE AGRAKPC_LETR_CODE VARCHAR2(15) No * *
AGRAKPC_PREF_CLAS_FROM AGRAKPC_PREF_CLAS_FROM VARCHAR2(4) No *
AGRAKPC_PREF_CLAS_TO AGRAKPC_PREF_CLAS_TO VARCHAR2(4) No
AGRAKPC_INCL_EXCL_IND AGRAKPC_INCL_EXCL_IND VARCHAR2(1) No
AGRAKPC_ACTIVITY_DATE AGRAKPC_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AGRAKPC_LETR_CODE AGRACKR_LETR_CODE AGRACKR
AGRAKPC_RULE_NO AGRACKR_RULE_NO AGRACKR <