Model Gift_Society_Rules*

Model Label :

List of Objects

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

Model View

Table APRDCCP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRDCCP_RULE_NO	NUMBER(2,0)	No	*	*
APRDCCP_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCCP_CAMPAIGN	VARCHAR2(5)	No	*
APRDCCP_INCL_EXCL_IND	VARCHAR2(1)	No
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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRDCCP_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_APRDCCP	SQL Index	S10B80.ALUMNI	Rely On
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCCP

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:06:000	04/02/2008 13:49:18:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRDCCT_RULE_NO	NUMBER(2,0)	No	*	*
APRDCCT_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCCT_CMTP_CODE	VARCHAR2(2)	No	*	*
APRDCCT_INCL_EXCL_IND	VARCHAR2(1)	No
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_DCNP_CODE	ATVDCNP_CODE	ATVDCNP
APRDCCT_CMTP_CODE	ATVCMTP_CODE	ATVCMTP

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_APRDCCT	SQL Index	S10B80.ALUMNI	Rely On
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVCMTP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCCT

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:07:000	04/02/2008 13:49:18:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRDCDC_RULE_NO	NUMBER(2,0)	No	*	*
APRDCDC_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCDC_DONR_CODE	VARCHAR2(4)	No	*	*
APRDCDC_INCL_EXCL_IND	VARCHAR2(1)	No
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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRDCDC_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_APRDCDC	SQL Index	S10B80.ALUMNI	Rely On
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDONR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCDC

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:10:000	04/02/2008 13:49:18:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
APRDCDP_DCYR_CODE	NUMBER(4,0)	No	*
APRDCDP_DCPR_CODE	VARCHAR2(4)	No	*
APRDCDP_DCST_CODE	VARCHAR2(2)	Yes	*
APRDCDP_DCNP_CODE	VARCHAR2(4)	Yes	*
APRDCDP_DCYR_CODE_INACT	NUMBER(4,0)	Yes	*
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
APRDCDP_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
APRDCDP_DCYR_CODE_INACT	ATVDCYR_CODE	ATVDCYR

Index

Index Name	Index Type	Column Name
APRDCDP_KEY_INDEX		APRDCDP_DCYR_CODE
APRDCDP_KEY_INDEX2		APRDCDP_DCPR_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRDCDP_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
APRDCDP_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCPR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCST	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCYR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCDP

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:11:000	04/02/2008 13:49:18:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRDCDS_RULE_NO	NUMBER(2,0)	No	*	*
APRDCDS_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCDS_DESG	VARCHAR2(10)	No	*
APRDCDS_INCL_EXCL_IND	VARCHAR2(1)	No
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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRDCDS_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_APRDCDS	SQL Index	S10B80.ALUMNI	Rely On
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCDS

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:12:000	04/02/2008 13:49:18:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDCGL_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRDCGL_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
APRDCRL	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCGL

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:16:000	04/02/2008 13:49:18:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRDCGT_RULE_NO	NUMBER(2,0)	No	*	*
APRDCGT_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCGT_GIFT_CODE	VARCHAR2(2)	No	*	*
APRDCGT_INCL_EXCL_IND	VARCHAR2(1)	No
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_DCNP_CODE	ATVDCNP_CODE	ATVDCNP
APRDCGT_GIFT_CODE	ATVGIFT_CODE	ATVGIFT

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_APRDCGT	SQL Index	S10B80.ALUMNI	Rely On
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCGT

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:18:000	04/02/2008 13:49:18:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRDCPC_RULE_NO	NUMBER(2,0)	No	*	*
APRDCPC_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCPC_PREF_CLASS_START	VARCHAR2(4)	No	*
APRDCPC_PREF_CLASS_END	VARCHAR2(4)	No
APRDCPC_INCL_EXCL_IND	VARCHAR2(1)	No
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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_APRDCPC	SQL Index	S10B80.ALUMNI	Rely On
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCPC

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:27:000	04/02/2008 13:49:19:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRDCCP	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCCT	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCDC	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCDS	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCGL	SQL Table	S10B80.ALUMNI	Join
APRDCGT	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCPC	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCXR	SQL Table	S10B80.ALUMNI	Refer (no action)
AXRDCPT	SQL Table	S10B80.ALUMNI	Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_APRDCRL	SQL Index	S10B80.ALUMNI	Rely On
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCYR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCRL

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:30:000	04/02/2008 13:49:19:000

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.

Columns Comments for APRDCRL_PAYMENT_SAME_YEAR_IND (# 28)

Source Code Comments

Indicates whether Pledge Payments are included in the calculation of the Gift Society totals in the same year as the pledge, Y=Include, N=Do not Include.

Table APRDCXR

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRDCXR_RULE_NO	NUMBER(2,0)	No	*	*
APRDCXR_DCNP_CODE	VARCHAR2(4)	No	*	*
APRDCXR_XREF_CODE	VARCHAR2(3)	No	*	*
APRDCXR_CREATE_MEMBER_IND	VARCHAR2(1)	Yes
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_DCNP_CODE	ATVDCNP_CODE	ATVDCNP
APRDCXR_XREF_CODE	ATVXREF_CODE	ATVXREF

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRDCXR_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_APRDCXR	SQL Index	S10B80.ALUMNI	Rely On
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVXREF	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDCXR

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:42:000	04/02/2008 13:49:19:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ATVDCNP_CODE	VARCHAR2(4)	No	*
ATVDCNP_DESC	VARCHAR2(30)	No
ATVDCNP_PRIORITY_IND	NUMBER(2,0)	No
ATVDCNP_DELETE_IND	VARCHAR2(1)	No
ATVDCNP_ACTIVITY_DATE	DATE	No
ATVDCNP_DCST_CODE	VARCHAR2(2)	No		*
ATVDCNP_MANL_ENTRY_IND	VARCHAR2(1)	Yes
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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRAKDC	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCCM	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCCP	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCCT	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCDC	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCDP	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCDS	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCGT	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCLB	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCPC	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCPR	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCTM	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCXR	SQL Table	S10B80.ALUMNI	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
F_GIFT_SOCIETY_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_LIFE_GIFT_SOCIETY	SQL Function	S10B80.BANINST1	Use (select)
ATVDCNP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
ATVDCNPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
ATVDCNPC	Oracle Package Cursor	S10B80.BANINST1.ATKDCNP	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVDCNP	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_ATVDCNP	SQL Index	S10B80.ALUMNI	Rely On
ATVDCST	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCYR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVDCNP

Object Dates

Creation Date	Analysis Date
04/02/2008 13:47:09:000	04/02/2008 13:49:23:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVDCYR	Unique	ATVDCYR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCRES	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRCTYP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCCM	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCDP	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCLB	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCPR	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRCORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSOAG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSSAG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVGSOL	SQL View	S10B80.BANINST1	Use (select)
AGVPSOL	SQL View	S10B80.BANINST1	Use (select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
F_GIFT_SOCIETY_INFO	SQL Function	S10B80.BANINST1	Use (select)
ATVDCYRC	Oracle Package Cursor	S10B80.BANINST1.ATKDCYR	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
F_ATVDCYR_LIKE	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
ATVDCYR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_ATVDCYR	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVDCYR

Object Dates

Creation Date	Analysis Date
04/02/2008 13:47:23:000	04/02/2008 13:49:23:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AXRDCPT_RULE_NO	NUMBER(2,0)	No	*	*
AXRDCPT_DCNP_CODE	VARCHAR2(4)	No	*	*
AXRDCPT_PLDG_CODE	VARCHAR2(2)	No	*	*
AXRDCPT_INCL_EXCL_IND	VARCHAR2(1)	No
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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AXRDCPT	SQL Index	S10B80.ALUMNI	Rely On
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AXRDCPT

Object Dates

Creation Date	Analysis Date
04/02/2008 13:42:15:000	04/02/2008 13:49:17:000

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 APRDCGL and APRDCRL

Join Information

Objects list
User link

Link List

Link Type	Link	Project
Join	Link Between APRDCGL and APRDCRL	ALUMNI

List of Real links

Link type	Between	And
Join	APRDCGL	APRDCRL

Link between APRDCCP and APRDCRL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCCP and APRDCRL (FK1_APRDCCP_INV_APRDCRL_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCCP	APRDCCP_RULE_NO	APRDCRL_RULE_NO	APRDCRL	(1,1)-(0,n)
APRDCCP	APRDCCP_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL	(1,1)-(0,n)

Link between APRDCCT and APRDCRL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCCT and APRDCRL (FK1_APRDCCT_INV_APRDCRL_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCCT	APRDCCT_RULE_NO	APRDCRL_RULE_NO	APRDCRL	(1,1)-(0,n)
APRDCCT	APRDCCT_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL	(1,1)-(0,n)

Link between APRDCDC and APRDCRL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCDC and APRDCRL (FK1_APRDCDC_INV_APRDCRL_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCDC	APRDCDC_RULE_NO	APRDCRL_RULE_NO	APRDCRL	(1,1)-(0,n)
APRDCDC	APRDCDC_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL	(1,1)-(0,n)

Link between APRDCDS and APRDCRL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCDS and APRDCRL (FK1_APRDCDS_INV_APRDCRL_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCDS	APRDCDS_RULE_NO	APRDCRL_RULE_NO	APRDCRL	(1,1)-(0,n)
APRDCDS	APRDCDS_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL	(1,1)-(0,n)

Link between APRDCGT and APRDCRL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCGT and APRDCRL (FK1_APRDCGT_INV_APRDCRL_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCGT	APRDCGT_RULE_NO	APRDCRL_RULE_NO	APRDCRL	(1,1)-(0,n)
APRDCGT	APRDCGT_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL	(1,1)-(0,n)

Link between APRDCPC and APRDCRL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCPC and APRDCRL (FK1_APRDCPC_INV_APRDCRL_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCPC	APRDCPC_RULE_NO	APRDCRL_RULE_NO	APRDCRL	(1,1)-(0,n)
APRDCPC	APRDCPC_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL	(1,1)-(0,n)

Link between AXRDCPT and APRDCRL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AXRDCPT and APRDCRL (FK1_AXRDCPT_INV_APRDCRL_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AXRDCPT	AXRDCPT_RULE_NO	APRDCRL_RULE_NO	APRDCRL	(1,1)-(0,n)
AXRDCPT	AXRDCPT_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL	(1,1)-(0,n)

Link between APRDCXR and APRDCRL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCXR and APRDCRL (FK1_APRDCXR_INV_APRDCRL_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCXR	APRDCXR_RULE_NO	APRDCRL_RULE_NO	APRDCRL	(1,1)-(0,n)
APRDCXR	APRDCXR_DCNP_CODE	APRDCRL_DCNP_CODE	APRDCRL	(1,1)-(0,n)

Link between APRDCCP and ATVDCNP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCCP and ATVDCNP (FK1_APRDCCP_INV_ATVDCNP_CODE)	ALUMNI

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)

Link between APRDCCT and ATVDCNP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCCT and ATVDCNP (FK1_APRDCCT_INV_ATVDCNP_CODE)	ALUMNI

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)

Link between APRDCDC and ATVDCNP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCDC and ATVDCNP (FK1_APRDCDC_INV_ATVDCNP_CODE)	ALUMNI

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)

Link between APRDCDP and ATVDCNP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCDP and ATVDCNP (FK1_APRDCDP_INV_ATVDCNP_CODE)	ALUMNI

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)

Link between APRDCDS and ATVDCNP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCDS and ATVDCNP (FK1_APRDCDS_INV_ATVDCNP_CODE)	ALUMNI

Foreign Key information

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

Link between APRDCGT and ATVDCNP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCGT and ATVDCNP (FK1_APRDCGT_INV_ATVDCNP_CODE)	ALUMNI

Foreign Key information

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

Link between APRDCPC and ATVDCNP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCPC and ATVDCNP (FK1_APRDCPC_INV_ATVDCNP_CODE)	ALUMNI

Foreign Key information

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

Link between APRDCRL and ATVDCNP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCRL and ATVDCNP (FK1_APRDCRL_INV_ATVDCNP_CODE)	ALUMNI

Foreign Key information

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

Link between APRDCXR and ATVDCNP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCXR and ATVDCNP (FK1_APRDCXR_INV_ATVDCNP_CODE)	ALUMNI

Foreign Key information

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

Link between APRDCDP and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCDP and ATVDCYR (FK1_APRDCDP_INV_ATVDCYR_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between APRDCDP and ATVDCYR (FK2_APRDCDP_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCDP	APRDCDP_DCYR_CODE	ATVDCYR_CODE	ATVDCYR	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCDP	APRDCDP_DCYR_CODE_INACT	ATVDCYR_CODE	ATVDCYR	(0,1)-(0,n)

Link between APRDCRL and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRDCRL and ATVDCYR (FK1_APRDCRL_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRDCRL	APRDCRL_DCYR_CODE_QUALIFY	ATVDCYR_CODE	ATVDCYR	(0,1)-(0,n)

Link between ATVDCNP and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ATVDCNP and ATVDCYR (FK1_ATVDCNP_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ATVDCNP	ATVDCNP_DCYR_CODE	ATVDCYR_CODE	ATVDCYR	(0,1)-(0,n)