Model Gift Society Rules

Model Label : BANNER Advancement Gift Society Rules
Path : BANNER DEV/Advancement/Advancement_ERD/GiftSocietyRules_ERD

List of Objects

Object Name	Object Type	Layer Name
APRDCCP	TABLE	Default
APRDCCT	TABLE	Default
APRDCDC	TABLE	Default
APRDCDP	TABLE	Default
APRDCDS	TABLE	Default
APRDCGL	TABLE	Default
APRDCGT	TABLE	Default
APRDCPC	TABLE	Default
APRDCRL	TABLE	Default
APRDCXR	TABLE	Default
ATVDCNP	TABLE	Default
ATVDCYR	TABLE	Default
AXRDCPT	TABLE	Default

Comments

Model View

Table APRDCCP

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRDCCP_RULE_NO	APRDCCP_RULE_NO	NUMBER(2,0)	No	*	*
APRDCCP_DCNP_CODE	APRDCCP_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCCP_DCNP_CODE	APRDCCP_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCCP_CAMPAIGN	APRDCCP_CAMPAIGN	VARCHAR2(5)	No	*
APRDCCP_INCL_EXCL_IND	APRDCCP_INCL_EXCL_IND	VARCHAR2(1)	No
APRDCCP_ACTIVITY_DATE	APRDCCP_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCCP_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL
APRDCCP_RULE_NO	APRDCRL_RULE_NO	APRDCRL
APRDCCP_DCNP_CODE	ATVDCNP_CODE	ATVDCNP

Index

Index Name	Index Type	Column Name
APRDCCP_KEY_INDEX2		APRDCCP_CAMPAIGN
PK_APRDCCP	Unique	APRDCCP_RULE_NO
PK_APRDCCP	Unique	APRDCCP_DCNP_CODE
PK_APRDCCP	Unique	APRDCCP_CAMPAIGN

Comments

Source Code Comments

Gift Society Campaign Rule Table

Columns Comments for APRDCCP_RULE_NO (1)

Source Code Comments

This field specifies the rule number by which the member qualified for the gift society.

Columns Comments for APRDCCP_DCNP_CODE (2)

Source Code Comments

This field specifies the gift society code.

Columns Comments for APRDCCP_CAMPAIGN (3)

Source Code Comments

This field specifies the campaigns to be included or excluded with the society rule.

Columns Comments for APRDCCP_INCL_EXCL_IND (4)

Source Code Comments

This field indicates if contributions to the campaign are to be included or excluded in the amount totalled for the society rule.

Columns Comments for APRDCCP_ACTIVITY_DATE (5)

Source Code Comments

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

Table APRDCCT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRDCCT_RULE_NO	APRDCCT_RULE_NO	NUMBER(2,0)	No	*	*
APRDCCT_DCNP_CODE	APRDCCT_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCCT_DCNP_CODE	APRDCCT_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCCT_CMTP_CODE	APRDCCT_CMTP_CODE	VARCHAR2(2)	No	*	*
APRDCCT_INCL_EXCL_IND	APRDCCT_INCL_EXCL_IND	VARCHAR2(1)	No
APRDCCT_ACTIVITY_DATE	APRDCCT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCCT_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL
APRDCCT_RULE_NO	APRDCRL_RULE_NO	APRDCRL
APRDCCT_CMTP_CODE	ATVCMTP_CODE	ATVCMTP
APRDCCT_DCNP_CODE	ATVDCNP_CODE	ATVDCNP

Index

Index Name	Index Type	Column Name
PK_APRDCCT	Unique	APRDCCT_RULE_NO
PK_APRDCCT	Unique	APRDCCT_DCNP_CODE
PK_APRDCCT	Unique	APRDCCT_CMTP_CODE

Comments

Source Code Comments

Gift Society Campaign Type Rule Table

Columns Comments for APRDCCT_RULE_NO (1)

Source Code Comments

This field specifies the rule number by which the member qualified for the gift society.

Columns Comments for APRDCCT_DCNP_CODE (2)

Source Code Comments

This field specifies the gift society name for the campaign type of the society rule.

Columns Comments for APRDCCT_CMTP_CODE (3)

Source Code Comments

This field specifies the campaign types for the society rule.

Columns Comments for APRDCCT_INCL_EXCL_IND (4)

Source Code Comments

This field indicates if campaign types specified are to be included or excluded when calculating totals for gift society rule.

Columns Comments for APRDCCT_ACTIVITY_DATE (5)

Source Code Comments

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

Table APRDCDC

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRDCDC_RULE_NO	APRDCDC_RULE_NO	NUMBER(2,0)	No	*	*
APRDCDC_DCNP_CODE	APRDCDC_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCDC_DCNP_CODE	APRDCDC_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCDC_DONR_CODE	APRDCDC_DONR_CODE	VARCHAR2(4)	No	*	*
APRDCDC_INCL_EXCL_IND	APRDCDC_INCL_EXCL_IND	VARCHAR2(1)	No
APRDCDC_ACTIVITY_DATE	APRDCDC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCDC_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL
APRDCDC_RULE_NO	APRDCRL_RULE_NO	APRDCRL
APRDCDC_DONR_CODE	ATVDONR_CODE	ATVDONR
APRDCDC_DCNP_CODE	ATVDCNP_CODE	ATVDCNP

Index

Index Name	Index Type	Column Name
APRDCDC_KEY_INDEX2		APRDCDC_DONR_CODE
PK_APRDCDC	Unique	APRDCDC_RULE_NO
PK_APRDCDC	Unique	APRDCDC_DCNP_CODE
PK_APRDCDC	Unique	APRDCDC_DONR_CODE

Comments

Source Code Comments

Gift Society Donor Code Rule Table

Columns Comments for APRDCDC_RULE_NO (1)

Source Code Comments

This field specifies the rule number by which the member qualified for the gift society.

Columns Comments for APRDCDC_DCNP_CODE (2)

Source Code Comments

This field specifies the gift society code.

Columns Comments for APRDCDC_DONR_CODE (3)

Source Code Comments

This field specifies the donor codes to be associated with the society rule.

Columns Comments for APRDCDC_INCL_EXCL_IND (4)

Source Code Comments

This field indicates if the donor codes are to be included or excluded when summing amounts for the society rule.

Columns Comments for APRDCDC_ACTIVITY_DATE (5)

Source Code Comments

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

Table APRDCDP

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
APRDCDP_DCYR_CODE	APRDCDP_DCYR_CODE	NUMBER(4,0)	No	*
APRDCDP_DCPR_CODE	APRDCDP_DCPR_CODE	VARCHAR2(4)	No	*
APRDCDP_DCST_CODE	APRDCDP_DCST_CODE	VARCHAR2(2)	Yes	*
APRDCDP_DCNP_CODE	APRDCDP_DCNP_CODE	VARCHAR2(4)	Yes	*
APRDCDP_DCYR_CODE_INACT	APRDCDP_DCYR_CODE_INACT	NUMBER(4,0)	Yes	*
APRDCDP_ACTIVITY_DATE	APRDCDP_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCDP_DCNP_CODE	ATVDCNP_CODE	ATVDCNP
APRDCDP_DCPR_CODE	ATVDCPR_CODE	ATVDCPR
APRDCDP_DCST_CODE	ATVDCST_CODE	ATVDCST

Index

Index Name	Index Type	Column Name
APRDCDP_KEY_INDEX		APRDCDP_DCYR_CODE
APRDCDP_KEY_INDEX2		APRDCDP_DCPR_CODE

Comments

Source Code Comments

Gift Society Donor Club Default Premiums Table

Columns Comments for APRDCDP_DCYR_CODE (1)

Source Code Comments

This field specifies the beginning effective society year code.

Columns Comments for APRDCDP_DCPR_CODE (2)

Source Code Comments

This field specifies the premium code to be automatically associated with the gift society based on the society type, effective society year and the gift society name.

Columns Comments for APRDCDP_DCST_CODE (3)

Source Code Comments

This field specifies the society type code.

Columns Comments for APRDCDP_DCNP_CODE (4)

Source Code Comments

This field specifies the gift society code.

Columns Comments for APRDCDP_DCYR_CODE_INACT (5)

Source Code Comments

This field specifies the society year code in which the premium rule becomes inactive and will no longer be automatically assigned.

Columns Comments for APRDCDP_ACTIVITY_DATE (6)

Source Code Comments

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

Table APRDCDS

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRDCDS_RULE_NO	APRDCDS_RULE_NO	NUMBER(2,0)	No	*	*
APRDCDS_DCNP_CODE	APRDCDS_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCDS_DCNP_CODE	APRDCDS_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCDS_DESG	APRDCDS_DESG	VARCHAR2(10)	No	*
APRDCDS_INCL_EXCL_IND	APRDCDS_INCL_EXCL_IND	VARCHAR2(1)	No
APRDCDS_ACTIVITY_DATE	APRDCDS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCDS_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL
APRDCDS_RULE_NO	APRDCRL_RULE_NO	APRDCRL
APRDCDS_DCNP_CODE	ATVDCNP_CODE	ATVDCNP

Index

Index Name	Index Type	Column Name
APRDCDS_KEY_INDEX2		APRDCDS_DESG
PK_APRDCDS	Unique	APRDCDS_RULE_NO
PK_APRDCDS	Unique	APRDCDS_DCNP_CODE
PK_APRDCDS	Unique	APRDCDS_DESG

Comments

Source Code Comments

Gift Society Designation Rule Table

Columns Comments for APRDCDS_RULE_NO (1)

Source Code Comments

This field specifies the rule number by which the member qualified for the gift society.

Columns Comments for APRDCDS_DCNP_CODE (2)

Source Code Comments

This field specifies the gift society code.

Columns Comments for APRDCDS_DESG (3)

Source Code Comments

This field specifies the designation associated with the society rule.

Columns Comments for APRDCDS_INCL_EXCL_IND (4)

Source Code Comments

This field indicates if the designation is to be included or excluded when calculating the total for the society rule.

Columns Comments for APRDCDS_ACTIVITY_DATE (5)

Source Code Comments

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

Table APRDCGL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL
APRDCGL_DCYR_CODE	APRDCGL_DCYR_CODE	NUMBER(4,0)	No
APRDCGL_DCST_CODE	APRDCGL_DCST_CODE	VARCHAR2(2)	No
APRDCGL_DCNP_CODE	APRDCGL_DCNP_CODE	VARCHAR2(4)	No
APRDCGL_CFAE_TYPE_1	APRDCGL_CFAE_TYPE_1	VARCHAR2(1)	No
APRDCGL_CFAE_TYPE_2	APRDCGL_CFAE_TYPE_2	VARCHAR2(1)	Yes
APRDCGL_GOAL_NEW	APRDCGL_GOAL_NEW	NUMBER(13,2)	Yes
APRDCGL_GOAL_RENEWED	APRDCGL_GOAL_RENEWED	NUMBER(13,2)	Yes
APRDCGL_USER	APRDCGL_USER	VARCHAR2(30)	No
APRDCGL_ACTIVITY_DATE	APRDCGL_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
APRDCGL_KEY_INDEX		APRDCGL_DCYR_CODE
APRDCGL_KEY_INDEX		APRDCGL_DCST_CODE
APRDCGL_KEY_INDEX		APRDCGL_CFAE_TYPE_1
APRDCGL_KEY_INDEX		APRDCGL_CFAE_TYPE_2
APRDCGL_KEY_INDEX		APRDCGL_DCNP_CODE

Comments

Source Code Comments

Gift Society Member Goal repeating table.

Columns Comments for APRDCGL_DCYR_CODE (1)

Source Code Comments

Gift society year for the rule being defined. Created on ATVDCYR.

Columns Comments for APRDCGL_DCST_CODE (2)

Source Code Comments

Gift society type code for the rule being defined. Created on ATVDCST.

Columns Comments for APRDCGL_DCNP_CODE (3)

Source Code Comments

Gift society code for the rule being defined. Created on ATVDCNP.

Columns Comments for APRDCGL_CFAE_TYPE_1 (4)

Source Code Comments

CFAE Code 1 for the rule being defined. Codes found on ATVDONR in the CFAE column.

Columns Comments for APRDCGL_CFAE_TYPE_2 (5)

Source Code Comments

CFAE Code 2 for the rule being defined. Codes found on ATVDONR in the CFAE 2 column.

Columns Comments for APRDCGL_GOAL_NEW (6)

Source Code Comments

Goal for new members of the gift society in the society year for the identifiedconstituency group.

Columns Comments for APRDCGL_GOAL_RENEWED (7)

Source Code Comments

Goal for renewed members of the gift society in the society year for the identified constituency group.

Columns Comments for APRDCGL_USER (8)

Source Code Comments

User ID that created the rule.

Columns Comments for APRDCGL_ACTIVITY_DATE (9)

Source Code Comments

Date that the rule was either added or last updated.

Table APRDCGT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRDCGT_RULE_NO	APRDCGT_RULE_NO	NUMBER(2,0)	No	*	*
APRDCGT_DCNP_CODE	APRDCGT_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCGT_DCNP_CODE	APRDCGT_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCGT_GIFT_CODE	APRDCGT_GIFT_CODE	VARCHAR2(2)	No	*	*
APRDCGT_INCL_EXCL_IND	APRDCGT_INCL_EXCL_IND	VARCHAR2(1)	No
APRDCGT_ACTIVITY_DATE	APRDCGT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCGT_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL
APRDCGT_RULE_NO	APRDCRL_RULE_NO	APRDCRL
APRDCGT_GIFT_CODE	ATVGIFT_CODE	ATVGIFT
APRDCGT_DCNP_CODE	ATVDCNP_CODE	ATVDCNP

Index

Index Name	Index Type	Column Name
PK_APRDCGT	Unique	APRDCGT_RULE_NO
PK_APRDCGT	Unique	APRDCGT_DCNP_CODE
PK_APRDCGT	Unique	APRDCGT_GIFT_CODE

Comments

Source Code Comments

Gift Society Gift Code Rule Table

Columns Comments for APRDCGT_RULE_NO (1)

Source Code Comments

This field specifies the rule number by which the member qualified for the gift society.

Columns Comments for APRDCGT_DCNP_CODE (2)

Source Code Comments

This field specifies the gift society code.

Columns Comments for APRDCGT_GIFT_CODE (3)

Source Code Comments

This field specifies the gift code associated with the society rule.

Columns Comments for APRDCGT_INCL_EXCL_IND (4)

Source Code Comments

This field indicates if the gift code is to be included or excluded from the society rule.

Columns Comments for APRDCGT_ACTIVITY_DATE (5)

Source Code Comments

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

Table APRDCPC

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRDCPC_RULE_NO	APRDCPC_RULE_NO	NUMBER(2,0)	No	*	*
APRDCPC_DCNP_CODE	APRDCPC_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCPC_DCNP_CODE	APRDCPC_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCPC_PREF_CLASS_START	APRDCPC_PREF_CLASS_START	VARCHAR2(4)	No	*
APRDCPC_PREF_CLASS_END	APRDCPC_PREF_CLASS_END	VARCHAR2(4)	No
APRDCPC_INCL_EXCL_IND	APRDCPC_INCL_EXCL_IND	VARCHAR2(1)	No
APRDCPC_ACTIVITY_DATE	APRDCPC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCPC_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL
APRDCPC_RULE_NO	APRDCRL_RULE_NO	APRDCRL
APRDCPC_DCNP_CODE	ATVDCNP_CODE	ATVDCNP

Index

Index Name	Index Type	Column Name
PK_APRDCPC	Unique	APRDCPC_RULE_NO
PK_APRDCPC	Unique	APRDCPC_DCNP_CODE
PK_APRDCPC	Unique	APRDCPC_PREF_CLASS_START

Comments

Source Code Comments

Gift Society Preferred Year Rule Table

Columns Comments for APRDCPC_RULE_NO (1)

Source Code Comments

This field specifies the rule number by which the member qualified for the gift society.

Columns Comments for APRDCPC_DCNP_CODE (2)

Source Code Comments

This field specifies the gift society code.

Columns Comments for APRDCPC_PREF_CLASS_START (3)

Source Code Comments

This field specifies the starting class year in a range to be associated with the society rule.

Columns Comments for APRDCPC_PREF_CLASS_END (4)

Source Code Comments

This field specifies the ending class year in a range to be associated with the society rule.

Columns Comments for APRDCPC_INCL_EXCL_IND (5)

Source Code Comments

This field indicates if constituents within the range of class years are to be included or excluded from the society rule.

Columns Comments for APRDCPC_ACTIVITY_DATE (6)

Source Code Comments

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

Table APRDCRL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRDCRL_DCNP_CODE	APRDCRL_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCRL_RULE_NO	APRDCRL_RULE_NO	NUMBER(2,0)	No	*
APRDCRL_PRIORITY_IND	APRDCRL_PRIORITY_IND	NUMBER(2,0)	No
APRDCRL_MEMBER_DURATION	APRDCRL_MEMBER_DURATION	NUMBER(2,0)	No
APRDCRL_MIN_GIVING	APRDCRL_MIN_GIVING	NUMBER(13,2)	Yes
APRDCRL_MAX_GIVING	APRDCRL_MAX_GIVING	NUMBER(13,2)	Yes
APRDCRL_MIN_SINGLE_AMT	APRDCRL_MIN_SINGLE_AMT	NUMBER(13,2)	Yes
APRDCRL_QUALIFY_YEARS	APRDCRL_QUALIFY_YEARS	VARCHAR2(2)	Yes
APRDCRL_DCYR_CODE_QUALIFY	APRDCRL_DCYR_CODE_QUALIFY	NUMBER(4,0)	Yes		*
APRDCRL_INACT_IND	APRDCRL_INACT_IND	VARCHAR2(1)	Yes
APRDCRL_INACT_DATE	APRDCRL_INACT_DATE	DATE	Yes
APRDCRL_PAYMENT_IND	APRDCRL_PAYMENT_IND	VARCHAR2(1)	Yes
APRDCRL_PAYMENT_MEMO_IND	APRDCRL_PAYMENT_MEMO_IND	VARCHAR2(1)	Yes
APRDCRL_PAYMENT_MULT_IND	APRDCRL_PAYMENT_MULT_IND	VARCHAR2(1)	Yes
APRDCRL_PLEDGE_IND	APRDCRL_PLEDGE_IND	VARCHAR2(1)	Yes
APRDCRL_PLEDGE_MEMO_IND	APRDCRL_PLEDGE_MEMO_IND	VARCHAR2(1)	Yes
APRDCRL_PLEDGE_MULT_IND	APRDCRL_PLEDGE_MULT_IND	VARCHAR2(1)	Yes
APRDCRL_MG_IND	APRDCRL_MG_IND	VARCHAR2(1)	Yes
APRDCRL_WAIT_MG_IND	APRDCRL_WAIT_MG_IND	VARCHAR2(1)	Yes
APRDCRL_SPS_IND	APRDCRL_SPS_IND	VARCHAR2(1)	Yes
APRDCRL_SPS_MG_IND	APRDCRL_SPS_MG_IND	VARCHAR2(1)	Yes
APRDCRL_SPS_WAIT_MG_IND	APRDCRL_SPS_WAIT_MG_IND	VARCHAR2(1)	Yes
APRDCRL_OTH_XREF_IND	APRDCRL_OTH_XREF_IND	VARCHAR2(1)	Yes
APRDCRL_OTH_XREF_MG_IND	APRDCRL_OTH_XREF_MG_IND	VARCHAR2(1)	Yes
APRDCRL_OTH_XREF_WAIT_MG_IND	APRDCRL_OTH_XREF_WAIT_MG_IND	VARCHAR2(1)	Yes
APRDCRL_ACTIVITY_DATE	APRDCRL_ACTIVITY_DATE	DATE	No
APRDCRL_INCL_EXP_MG_IND	APRDCRL_INCL_EXP_MG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCRL_DCNP_CODE	ATVDCNP_CODE	ATVDCNP
APRDCRL_DCYR_CODE_QUALIFY	ATVDCYR_CODE	ATVDCYR

Index

Index Name	Index Type	Column Name
PK_APRDCRL	Unique	APRDCRL_DCNP_CODE
PK_APRDCRL	Unique	APRDCRL_RULE_NO

Comments

Source Code Comments

Gift Society Rule Table

Columns Comments for APRDCRL_DCNP_CODE (1)

Source Code Comments

This field specifies the gift society code.

Columns Comments for APRDCRL_RULE_NO (2)

Source Code Comments

This field specifies the rule number by which the member qualified for the gift society.

Columns Comments for APRDCRL_PRIORITY_IND (3)

Source Code Comments

This field specifies the rule priority. The lower the number, the higher the priority. The highest priority rule will be processed first.

Columns Comments for APRDCRL_MEMBER_DURATION (4)

Source Code Comments

This field specifies the number of years for which membership is created.

Columns Comments for APRDCRL_MIN_GIVING (5)

Source Code Comments

This field specifies the minimum amount required to achieve membership.

Columns Comments for APRDCRL_MAX_GIVING (6)

Source Code Comments

This field specifies the maximum amount for the gift society. This amount is no functional in the automated gift society process.

Columns Comments for APRDCRL_MIN_SINGLE_AMT (7)

Source Code Comments

This field specifies the minimum amount required for each item added to the total giving amount.

Columns Comments for APRDCRL_QUALIFY_YEARS (8)

Source Code Comments

This field specifies the number of years of giving that will be counted to qualify for the membership.

Columns Comments for APRDCRL_DCYR_CODE_QUALIFY (9)

Source Code Comments

This field specifies the society year in which the giving will start being counted to qualify for the membership. This is optional.

Columns Comments for APRDCRL_INACT_IND (10)

Source Code Comments

This field indicates if a rule is inactive.

Columns Comments for APRDCRL_INACT_DATE (11)

Source Code Comments

This field indicates the date the rule became inactive.

Columns Comments for APRDCRL_PAYMENT_IND (12)

Source Code Comments

This field specifies if the gift/pledge payment was included in the sum qualifying the member for the minimum giving level.

Columns Comments for APRDCRL_PAYMENT_MEMO_IND (13)

Source Code Comments

This field specifies if the payment memo amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_PAYMENT_MULT_IND (14)

Source Code Comments

This field specifies if the payment multiple id amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_PLEDGE_IND (15)

Source Code Comments

This field specifies if the pledge amount was included in the sum qualifying the member for the minimum giving level.

Columns Comments for APRDCRL_PLEDGE_MEMO_IND (16)

Source Code Comments

This field specifies if the pledge memo amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_PLEDGE_MULT_IND (17)

Source Code Comments

This field specifies if the pledge multiple id amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_MG_IND (18)

Source Code Comments

This field specifies if the matching gift amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_WAIT_MG_IND (19)

Source Code Comments

This field specifies if the anticipated matching gift amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_SPS_IND (20)

Source Code Comments

This field specifies if the spouses pledges and/or gifts are included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_SPS_MG_IND (21)

Source Code Comments

This field specifies if the spouse matching gift amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_SPS_WAIT_MG_IND (22)

Source Code Comments

This field specifies if the spouse anticipated matching gift amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_OTH_XREF_IND (23)

Source Code Comments

This field specifies if cross references, other than spouses, pledges and/or gifts are included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_OTH_XREF_MG_IND (24)

Source Code Comments

This field specifies if the other xref matching gift amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_OTH_XREF_WAIT_MG_IND (25)

Source Code Comments

This field specifies if the other xref anticipated matching gift amount was included in the sum qualifying the member for the society based on the dollar range.

Columns Comments for APRDCRL_ACTIVITY_DATE (26)

Source Code Comments

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

Columns Comments for APRDCRL_INCL_EXP_MG_IND (27)

Source Code Comments

(Y) - Yes, include expected matching gifts based on pledges. (N) - No, do not include expected matching gifts based on pledges. Null - No, do not include expected matching gifts based on pledges.

Table APRDCXR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRDCXR_RULE_NO	APRDCXR_RULE_NO	NUMBER(2,0)	No	*	*
APRDCXR_DCNP_CODE	APRDCXR_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCXR_DCNP_CODE	APRDCXR_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCXR_XREF_CODE	APRDCXR_XREF_CODE	VARCHAR2(3)	No	*	*
APRDCXR_CREATE_MEMBER_IND	APRDCXR_CREATE_MEMBER_IND	VARCHAR2(1)	Yes
APRDCXR_ACTIVITY_DATE	APRDCXR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCXR_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL
APRDCXR_RULE_NO	APRDCRL_RULE_NO	APRDCRL
APRDCXR_XREF_CODE	ATVXREF_CODE	ATVXREF
APRDCXR_DCNP_CODE	ATVDCNP_CODE	ATVDCNP

Index

Index Name	Index Type	Column Name
APRDCXR_KEY_INDEX2		APRDCXR_XREF_CODE
PK_APRDCXR	Unique	APRDCXR_RULE_NO
PK_APRDCXR	Unique	APRDCXR_DCNP_CODE
PK_APRDCXR	Unique	APRDCXR_XREF_CODE

Comments

Source Code Comments

Gift Society Cross Reference Rule Table

Columns Comments for APRDCXR_RULE_NO (1)

Source Code Comments

This field specifies the rule number by which the member qualified for the gift society.

Columns Comments for APRDCXR_DCNP_CODE (2)

Source Code Comments

This field specifies the gift society code.

Columns Comments for APRDCXR_XREF_CODE (3)

Source Code Comments

This field specifies the cross reference codes to be included or excluded in the society rule.

Columns Comments for APRDCXR_CREATE_MEMBER_IND (4)

Source Code Comments

This field indicates if memberships should be created for the xref codes.

Columns Comments for APRDCXR_ACTIVITY_DATE (5)

Source Code Comments

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

Table ATVDCNP

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ATVDCNP_CODE	ATVDCNP_CODE	VARCHAR2(4)	No	*
ATVDCNP_DESC	ATVDCNP_DESC	VARCHAR2(30)	No
ATVDCNP_PRIORITY_IND	ATVDCNP_PRIORITY_IND	NUMBER(2,0)	No
ATVDCNP_DELETE_IND	ATVDCNP_DELETE_IND	VARCHAR2(1)	No
ATVDCNP_ACTIVITY_DATE	ATVDCNP_ACTIVITY_DATE	DATE	No
ATVDCNP_DCST_CODE	ATVDCNP_DCST_CODE	VARCHAR2(2)	No		*
ATVDCNP_MANL_ENTRY_IND	ATVDCNP_MANL_ENTRY_IND	VARCHAR2(1)	Yes
ATVDCNP_DCYR_CODE	ATVDCNP_DCYR_CODE	NUMBER(4,0)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
ATVDCNP_DCST_CODE	ATVDCST_CODE	ATVDCST
ATVDCNP_DCYR_CODE	ATVDCYR_CODE	ATVDCYR

Index

Index Name	Index Type	Column Name
PK_ATVDCNP	Unique	ATVDCNP_CODE

Comments

Source Code Comments

Gift Society Validation Table

Columns Comments for ATVDCNP_CODE (1)

Source Code Comments

This field specifies the code for a gift society.

Columns Comments for ATVDCNP_DESC (2)

Source Code Comments

This field specifies the description of the gift society.

Columns Comments for ATVDCNP_PRIORITY_IND (3)

Source Code Comments

This field specifies the unique priority indicator of the gift society. The lowest number is the highest priority.

Columns Comments for ATVDCNP_DELETE_IND (4)

Source Code Comments

This field specifies if a member may be deleted from the gift society.

Columns Comments for ATVDCNP_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for ATVDCNP_DCST_CODE (6)

Source Code Comments

This field specifies a category of gift societies.

Columns Comments for ATVDCNP_MANL_ENTRY_IND (7)

Source Code Comments

This field indicates that gift society members must be entered into this society manually, not computer calculated.

Columns Comments for ATVDCNP_DCYR_CODE (8)

Source Code Comments

This field specifies the ending society year of the gift society. No members will be allowed after this year.

Table ATVDCYR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
ATVDCYR_CODE	ATVDCYR_CODE	NUMBER(4,0)	No	*
ATVDCYR_DESC	ATVDCYR_DESC	VARCHAR2(30)	No
ATVDCYR_START_DATE	ATVDCYR_START_DATE	DATE	No
ATVDCYR_END_DATE	ATVDCYR_END_DATE	DATE	No
ATVDCYR_ACTIVITY_DATE	ATVDCYR_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVDCYR	Unique	ATVDCYR_CODE

Comments

Source Code Comments

Gift Society Year Validation Table

Columns Comments for ATVDCYR_CODE (1)

Source Code Comments

This field specifies the code for a gift society year.

Columns Comments for ATVDCYR_DESC (2)

Source Code Comments

This field specifies the description of the gift society club year.

Columns Comments for ATVDCYR_START_DATE (3)

Source Code Comments

This field specifies the beginning date of the gift society year.

Columns Comments for ATVDCYR_END_DATE (4)

Source Code Comments

This field specifies the ending date of the gift society year.

Columns Comments for ATVDCYR_ACTIVITY_DATE (5)

Source Code Comments

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

Table AXRDCPT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AXRDCPT_RULE_NO	AXRDCPT_RULE_NO	NUMBER(2,0)	No	*	*
AXRDCPT_DCNP_CODE	AXRDCPT_DCNP_CODE	VARCHAR2(4)	No	*	*
AXRDCPT_PLDG_CODE	AXRDCPT_PLDG_CODE	VARCHAR2(2)	No	*	*
AXRDCPT_INCL_EXCL_IND	AXRDCPT_INCL_EXCL_IND	VARCHAR2(1)	No
AXRDCPT_ACTIVITY_DATE	AXRDCPT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AXRDCPT_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL
AXRDCPT_RULE_NO	APRDCRL_RULE_NO	APRDCRL
AXRDCPT_PLDG_CODE	ATVPLDG_CODE	ATVPLDG

Index

Index Name	Index Type	Column Name
PK_AXRDCPT	Unique	AXRDCPT_RULE_NO
PK_AXRDCPT	Unique	AXRDCPT_DCNP_CODE
PK_AXRDCPT	Unique	AXRDCPT_PLDG_CODE

Comments

Source Code Comments

Gift Society Pledge Type Rule table.

Columns Comments for AXRDCPT_RULE_NO (1)

Source Code Comments

This field specifies the internal system generated rule number.

Columns Comments for AXRDCPT_DCNP_CODE (2)

Source Code Comments

This field specifies the Gift Society Code for the rule.

Columns Comments for AXRDCPT_PLDG_CODE (3)

Source Code Comments

This field specifies the Pledge Type Code to include or exclude for the rule.

Columns Comments for AXRDCPT_INCL_EXCL_IND (4)

Source Code Comments

This field specifies whether to Include or Exclude the Pledge type specified.

Columns Comments for AXRDCPT_ACTIVITY_DATE (5)

Source Code Comments

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

Link between APRDCCP and ATVDCNP

Caller : APRDCCP
Called : ATVDCNP

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between APRDCCP and ATVDCNP	ALUMNI

Link Foreign Key Between APRDCCP and ATVDCNP

Caller : APRDCCP
Called : ATVDCNP
Link Type : Refer(No Action )
Link : Link Foreign Key Between APRDCCP and ATVDCNP

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCCP	APRDCCP_DCNP_CODE	ATVDCNP_CODE	ATVDCNP	(1,1)-(0,n)

Comments

Link between APRDCCT and ATVDCNP

Caller : APRDCCT
Called : ATVDCNP

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between APRDCCT and ATVDCNP	ALUMNI

Link Foreign Key Between APRDCCT and ATVDCNP

Caller : APRDCCT
Called : ATVDCNP
Link Type : Refer(No Action )
Link : Link Foreign Key Between APRDCCT and ATVDCNP

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCCT	APRDCCT_DCNP_CODE	ATVDCNP_CODE	ATVDCNP	(1,1)-(0,n)

Comments

Link between APRDCDC and ATVDCNP

Caller : APRDCDC
Called : ATVDCNP

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between APRDCDC and ATVDCNP	ALUMNI

Link Foreign Key Between APRDCDC and ATVDCNP

Caller : APRDCDC
Called : ATVDCNP
Link Type : Refer(No Action )
Link : Link Foreign Key Between APRDCDC and ATVDCNP

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCDC	APRDCDC_DCNP_CODE	ATVDCNP_CODE	ATVDCNP	(1,1)-(0,n)

Comments

Link between APRDCDP and ATVDCNP

Caller : APRDCDP
Called : ATVDCNP

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between APRDCDP and ATVDCNP	ALUMNI

Link Foreign Key Between APRDCDP and ATVDCNP

Caller : APRDCDP
Called : ATVDCNP
Link Type : Refer(No Action )
Link : Link Foreign Key Between APRDCDP and ATVDCNP

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCDP	APRDCDP_DCNP_CODE	ATVDCNP_CODE	ATVDCNP	(0,1)-(0,n)

Comments

Link between APRDCDS and ATVDCNP

Caller : APRDCDS
Called : ATVDCNP

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between APRDCDS and ATVDCNP