Model Pedge & Gift Rules

Model Label : BANNER Advancement Pledge and Gift Processing Rules
Path : Default Folder/B70/Advancement/Pedge & Gift Rules

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 S4B70
Creation Date 09/29/2003 12:12:45: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 S4B70
Creation Date 09/29/2003 12:12:45:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AGBIDRL_PIDM	AGBIDRL_PIDM	NUMBER(8,0)	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_XREF_CODE	ATVXREF_CODE	ATVXREF
AGBIDRL_PIDM	APRXREF_PIDM	APRXREF
AGBIDRL_XREF_CODE	APRXREF_XREF_CODE	APRXREF

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 S4B70
Creation Date 09/29/2003 12:12:45:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	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_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AGBPDEF_CTYP_CODE	ATVCTYP_CODE	ATVCTYP
AGBPDEF_DNAM_CODE	ATVDNAM_CODE	ATVDNAM
AGBPDEF_PCAT_CODE	ATVPCAT_CODE	ATVPCAT
AGBPDEF_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBPDEF_SCNT_CODE	ATVSCNT_CODE	ATVSCNT
AGBPDEF_SCRS_CODE	ATVSCRS_CODE	ATVSCRS

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 S4B70
Creation Date 09/29/2003 12:12:45: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 S4B70
Creation Date 09/29/2003 12:12:45: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

Column name	is Foreign Key For Column	on Table
AGRACKR_LETR_CODE_RECPT	GTVLETR_CODE	GTVLETR
AGRACKR_LETR_CODE	GTVLETR_CODE	GTVLETR
AGRACKR_LETR_CODE_EMPL	GTVLETR_CODE	GTVLETR

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 S4B70
Creation Date 09/29/2003 12:12:45:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
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 S4B70
Creation Date 09/29/2003 12:12:45: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_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	GTVLETR_CODE	GTVLETR
AGRAKCP_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR
AGRAKCP_RULE_NO	AGRACKR_RULE_NO	AGRACKR

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 S4B70
Creation Date 09/29/2003 12:12:45: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_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_CMTP_CODE	ATVCMTP_CODE	ATVCMTP
AGRAKCT_LETR_CODE	GTVLETR_CODE	GTVLETR
AGRAKCT_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR
AGRAKCT_RULE_NO	AGRACKR_RULE_NO	AGRACKR

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 S4B70
Creation Date 09/29/2003 12:12:45: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_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_DCNP_CODE	ATVDCNP_CODE	ATVDCNP
AGRAKDC_LETR_CODE	GTVLETR_CODE	GTVLETR
AGRAKDC_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR
AGRAKDC_RULE_NO	AGRACKR_RULE_NO	AGRACKR

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 S4B70
Creation Date 09/29/2003 12:12:46: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_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	GTVLETR_CODE	GTVLETR
AGRAKDG_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR
AGRAKDG_RULE_NO	AGRACKR_RULE_NO	AGRACKR

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 S4B70
Creation Date 09/29/2003 12:12:46: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_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_LETR_CODE	GTVLETR_CODE	GTVLETR
AGRAKDN_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR
AGRAKDN_RULE_NO	AGRACKR_RULE_NO	AGRACKR
AGRAKDN_DONR_CODE	ATVDONR_CODE	ATVDONR

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 S4B70
Creation Date 09/29/2003 12:12:46: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_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_LETR_CODE	GTVLETR_CODE	GTVLETR
AGRAKEX_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR
AGRAKEX_RULE_NO	AGRACKR_RULE_NO	AGRACKR
AGRAKEX_EXCL_CODE	ATVEXCL_CODE	ATVEXCL

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 S4B70
Creation Date 09/29/2003 12:12:46: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_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_LETR_CODE	GTVLETR_CODE	GTVLETR
AGRAKGC_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR
AGRAKGC_RULE_NO	AGRACKR_RULE_NO	AGRACKR
AGRAKGC_GCLS_CODE	ATVGCLS_CODE	ATVGCLS

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 S4B70
Creation Date 09/29/2003 12:12:46: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_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_GIFT_CODE	ATVGIFT_CODE	ATVGIFT
AGRAKGT_LETR_CODE	GTVLETR_CODE	GTVLETR
AGRAKGT_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR
AGRAKGT_RULE_NO	AGRACKR_RULE_NO	AGRACKR

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 S4B70
Creation Date 09/29/2003 12:12:46: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_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	GTVLETR_CODE	GTVLETR
AGRAKPC_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR
AGRAKPC_RULE_NO	AGRACKR_RULE_NO	AGRACKR

Index

Index Name	Index Type	Column Name
PK_AGRAKPC	Unique	AGRAKPC_RULE_NO
PK_AGRAKPC	Unique	AGRAKPC_LETR_CODE
PK_AGRAKPC	Unique	AGRAKPC_PREF_CLAS_FROM

Comments

Source Code Comments

Gift Acknowledgement Preferred Class Table

Columns Comments for AGRAKPC_RULE_NO (1)

Source Code Comments

This field specifies the internal generated number for rule number.

Columns Comments for AGRAKPC_LETR_CODE (2)

Source Code Comments

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

Columns Comments for AGRAKPC_PREF_CLAS_FROM (3)

Source Code Comments

This field specifies the begin range for preferred class for rule and letter code.