Model Pledge_and_Gift_Rules*

Model Label :

List of Objects

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

Model View

Table AGBCTRL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_AGBCTRL	Unique	AGBCTRL_USER

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_AGBCTRL	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBCTRL

Object Dates

Creation Date	Analysis Date
04/02/2008 13:41:14:000	04/02/2008 13:49:16:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AGBIDRL_PIDM	NUMBER(8,0)	No	*
AGBIDRL_XREF_CODE	VARCHAR2(3)	No	*
AGBIDRL_XREF_PRIORITY	NUMBER(5,2)	No
AGBIDRL_NO_SPLIT_IND	VARCHAR2(1)	No
AGBIDRL_ACTIVITY_DATE	DATE	No
AGBIDRL_PERCENT_DFLT	NUMBER(5,2)	No
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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
INDIVIDSPLITINFOC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
INDIVIDSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
INSTSPLITINFOC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
INSTSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
SPLITINDIVIDC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
SPLITINSTC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
AGBIDRL	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
AGBIDRL_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGBIDRL_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
APRXREF	SQL Table	S10B80.ALUMNI	Join
ATVXREF	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBIDRL

Object Dates

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

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

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
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVCTYP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDNAM	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPCAT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPGVE	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSCNT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSCRS	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBPDEF

Object Dates

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

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGBSPRL_XREF_CODE	VARCHAR2(3)	No	*	*
AGBSPRL_XREF_PRIORITY	NUMBER(5,2)	No	*
AGBSPRL_PERCENT_DFLT	NUMBER(5,2)	No
AGBSPRL_MULT_MEM_IND	VARCHAR2(1)	No
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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRXREF	SQL Table	S10B80.ALUMNI	Join
INSTSPLITINFOC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
SPLITINSTC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
MULT_MEM_IND	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
XREF_CODE	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
XREF_PERCENT	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
XREF_PRIORITY	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
AGBSPRL	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_AGBSPRL	SQL Index	S10B80.ALUMNI	Rely On
ATVXREF	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBSPRL

Object Dates

Creation Date	Analysis Date
04/02/2008 13:45:57:000	04/02/2008 13:49:21:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRACKR_RULE_NO	NUMBER(2,0)	No	*
AGRACKR_RULE_PRTY	NUMBER(2,0)	No
AGRACKR_LETR_CODE	VARCHAR2(15)	No	*	*
AGRACKR_DOLLAR_FROM	NUMBER(13,2)	Yes
AGRACKR_DOLLAR_TO	NUMBER(13,2)	Yes
AGRACKR_GIFT_PLDG_IND	VARCHAR2(1)	Yes
AGRACKR_PLEDGE_IND	VARCHAR2(1)	Yes
AGRACKR_MTCH_GIFT_IND	VARCHAR2(1)	Yes
AGRACKR_LETR_CODE_EMPL	VARCHAR2(15)	Yes		*
AGRACKR_LETR_IND	VARCHAR2(1)	Yes
AGRACKR_RECPT_IND	VARCHAR2(1)	Yes
AGRACKR_LETR_CODE_RECPT	VARCHAR2(15)	Yes		*
AGRACKR_RULE_STATUS	VARCHAR2(1)	Yes
AGRACKR_RULE_DATE	DATE	Yes
AGRACKR_ACTIVITY_DATE	DATE	No

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRAKCP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKPC	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_AGRACKR	SQL Index	S10B80.ALUMNI	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRACKR

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:31:000	04/02/2008 13:49:20:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
AGRADJR_FIELD_NAME	VARCHAR2(20)	No	*
AGRADJR_DESC	VARCHAR2(30)	No
AGRADJR_ADJ_PLDG_IND	VARCHAR2(1)	No
AGRADJR_ADJ_GIFT_IND	VARCHAR2(1)	No
AGRADJR_ACTIVITY_DATE	DATE	No
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

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_AGRADJR	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRADJR

Object Dates

Creation Date	Analysis Date
04/02/2008 13:45:40:000	04/02/2008 13:49:21:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

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_AGRAKCP	SQL Index	S10B80.ALUMNI	Rely On
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAKCP

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:41:000	04/02/2008 13:49:20:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

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

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_AGRAKCT	SQL Index	S10B80.ALUMNI	Rely On
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVCMTP	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAKCT

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:42:000	04/02/2008 13:49:20:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRAKDC_RULE_NO	NUMBER(2,0)	No	*	*
AGRAKDC_LETR_CODE	VARCHAR2(15)	No	*	*
AGRAKDC_DCNP_CODE	VARCHAR2(4)	No	*	*
AGRAKDC_INCL_EXCL_IND	VARCHAR2(1)	No
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	AGRACKR_LETR_CODE	AGRACKR
AGRAKDC_RULE_NO	AGRACKR_RULE_NO	AGRACKR
AGRAKDC_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

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

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_AGRAKDC	SQL Index	S10B80.ALUMNI	Rely On
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAKDC

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:44:000	04/02/2008 13:49:20:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

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_AGRAKDG	SQL Index	S10B80.ALUMNI	Rely On
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAKDG

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:45:000	04/02/2008 13:49:20:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

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_AGRAKDN	SQL Index	S10B80.ALUMNI	Rely On
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDONR	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAKDN

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:46:000	04/02/2008 13:49:20:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

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_AGRAKEX	SQL Index	S10B80.ALUMNI	Rely On
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVEXCL	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAKEX

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:49:000	04/02/2008 13:49:20:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

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_AGRAKGC	SQL Index	S10B80.ALUMNI	Rely On
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGCLS	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAKGC

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:53:000	04/02/2008 13:49:20:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

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

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_AGRAKGT	SQL Index	S10B80.ALUMNI	Rely On
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAKGT

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:54:000	04/02/2008 13:49:20:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

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

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_AGRAKPC	SQL Index	S10B80.ALUMNI	Rely On
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAKPC

Object Dates

Creation Date	Analysis Date
04/02/2008 13:45:13:000	04/02/2008 13:49:21:000

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.

Columns Comments for AGRAKPC_PREF_CLAS_TO (# 4)

Source Code Comments

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

Columns Comments for AGRAKPC_INCL_EXCL_IND (# 5)

Source Code Comments

This field specifies to include or exclude range of preferred class year for rule and letter code.

Columns Comments for AGRAKPC_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table AGRIDRL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRIDRL_PIDM	NUMBER(8,0)	No	*	*
AGRIDRL_XREF_CODE	VARCHAR2(3)	No	*	*
AGRIDRL_RULE_PRIORITY	NUMBER(5,2)	No	*
AGRIDRL_XREF_PRIORITY	NUMBER(5,2)	No
AGRIDRL_XREF_PERCENT	NUMBER(5,2)	No
AGRIDRL_MULT_MEM_IND	VARCHAR2(1)	No
AGRIDRL_ACTIVITY_DATE	DATE	No
AGRIDRL_CMTP_CODE	VARCHAR2(2)	Yes		*
AGRIDRL_CAMPAIGN	VARCHAR2(5)	Yes
AGRIDRL_DSTP_CODE	VARCHAR2(5)	Yes		*
AGRIDRL_DESG	VARCHAR2(10)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRIDRL_DSTP_CODE	ATVDSTP_CODE	ATVDSTP
AGRIDRL_XREF_CODE	ATVXREF_CODE	ATVXREF
AGRIDRL_CMTP_CODE	ATVCMTP_CODE	ATVCMTP
AGRIDRL_PIDM	APRXREF_PIDM	APRXREF
AGRIDRL_XREF_CODE	APRXREF_XREF_CODE	APRXREF

Index

Index Name	Index Type	Column Name
PK_AGRIDRL	Unique	AGRIDRL_PIDM
PK_AGRIDRL	Unique	AGRIDRL_XREF_CODE
PK_AGRIDRL	Unique	AGRIDRL_RULE_PRIORITY

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
INDIVIDSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
AGRIDRL	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_AGRIDRL	SQL Index	S10B80.ALUMNI	Rely On
APRXREF	SQL Table	S10B80.ALUMNI	Join
ATVCMTP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDSTP	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.AGRIDRL

Object Dates

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

Source Code Comments

Split Pledges/Gifts for ID Rule Table

Columns Comments for AGRIDRL_PIDM (# 1)

Source Code Comments

Internal system generated id no for the person/organization.

Columns Comments for AGRIDRL_XREF_CODE (# 2)

Source Code Comments

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

Columns Comments for AGRIDRL_RULE_PRIORITY (# 3)

Source Code Comments

Priority number associated with the rule for a cross reference code of an ID.

Columns Comments for AGRIDRL_XREF_PRIORITY (# 4)

Source Code Comments

Cross reference priority number of ID for multiple or memo.

Columns Comments for AGRIDRL_XREF_PERCENT (# 5)

Source Code Comments

Percent of the pledge/gift of ID that is to be multipled or memoed for the cross refence.

Columns Comments for AGRIDRL_MULT_MEM_IND (# 6)

Source Code Comments

Multiple (H) or memo (S) indicator to distinguish which the rule is for.

Columns Comments for AGRIDRL_ACTIVITY_DATE (# 7)

Source Code Comments

Date this record was inserted or last updated.

Columns Comments for AGRIDRL_CMTP_CODE (# 8)

Source Code Comments

Campaign type code of ID for the multiple or memo rule.

Columns Comments for AGRIDRL_CAMPAIGN (# 9)

Source Code Comments

Campaign code of ID for the multiple or memo rule.

Columns Comments for AGRIDRL_DSTP_CODE (# 10)

Source Code Comments

Designation type code of ID for the multiple or memo rule.

Columns Comments for AGRIDRL_DESG (# 11)

Source Code Comments

Designation code of ID for the multiple or memo rule.

Table AGRSPRL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRSPRL_XREF_CODE	VARCHAR2(3)	No	*	*
AGRSPRL_XREF_PRIORITY	NUMBER(5,2)	No	*
AGRSPRL_RULE_PRIORITY	NUMBER(5,2)	No	*
AGRSPRL_XREF_PERCENT	NUMBER(5,2)	No
AGRSPRL_MULT_MEM_IND	VARCHAR2(1)	No
AGRSPRL_ACTIVITY_DATE	DATE	No
AGRSPRL_CMTP_CODE	VARCHAR2(2)	Yes		*
AGRSPRL_CAMPAIGN	VARCHAR2(5)	Yes
AGRSPRL_DSTP_CODE	VARCHAR2(5)	Yes		*
AGRSPRL_DESG	VARCHAR2(10)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRSPRL_DSTP_CODE	ATVDSTP_CODE	ATVDSTP
AGRSPRL_XREF_CODE	ATVXREF_CODE	ATVXREF
AGRSPRL_CMTP_CODE	ATVCMTP_CODE	ATVCMTP
AGRSPRL_XREF_CODE	APRXREF_XREF_CODE	APRXREF

Index

Index Name	Index Type	Column Name
PK_AGRSPRL	Unique	AGRSPRL_XREF_CODE
PK_AGRSPRL	Unique	AGRSPRL_XREF_PRIORITY
PK_AGRSPRL	Unique	AGRSPRL_RULE_PRIORITY

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
INSTSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
RULE_PRIORITY	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
AGRSPRL	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_AGRSPRL	SQL Index	S10B80.ALUMNI	Rely On
APRXREF	SQL Table	S10B80.ALUMNI	Join
ATVCMTP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDSTP	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.AGRSPRL

Object Dates

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

Source Code Comments

Split Pledges/Gifts Rule Table

Columns Comments for AGRSPRL_XREF_CODE (# 1)

Source Code Comments

Cross reference code of rule for multiple or memo.

Columns Comments for AGRSPRL_XREF_PRIORITY (# 2)

Source Code Comments

Cross reference priority number for multiple or memo.

Columns Comments for AGRSPRL_RULE_PRIORITY (# 3)

Source Code Comments

Priority number associated with the rule for a cross reference code.

Columns Comments for AGRSPRL_XREF_PERCENT (# 4)

Source Code Comments

Percent of the pledge/gift that is to be multipled or memoed for the cross reference.

Columns Comments for AGRSPRL_MULT_MEM_IND (# 5)

Source Code Comments

Multiple (H) or memo (S) indicator to distinguish which the rule is for.

Columns Comments for AGRSPRL_ACTIVITY_DATE (# 6)

Source Code Comments

Date this record was inserted or last updated.

Columns Comments for AGRSPRL_CMTP_CODE (# 7)

Source Code Comments

Campaign type code for the multiple or memo rule.

Columns Comments for AGRSPRL_CAMPAIGN (# 8)

Source Code Comments

Campaign code for the multiple or memo rule.

Columns Comments for AGRSPRL_DSTP_CODE (# 9)

Source Code Comments

Designation type code for the multiple or memo rule.

Columns Comments for AGRSPRL_DESG (# 10)

Source Code Comments

Designation code for the multiple or memo rule.

Table APRXREF

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRXREF_PIDM	NUMBER(8,0)	No	*
APRXREF_XREF_CODE	VARCHAR2(3)	No	*	*
APRXREF_XREF_PIDM	NUMBER(8,0)	No	*	*
APRXREF_ACTIVITY_DATE	DATE	No
APRXREF_CM_PRI_IND	VARCHAR2(1)	Yes
APRXREF_HOUSEHOLD_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRXREF_XREF_CODE	ATVXREF_CODE	ATVXREF
APRXREF_XREF_PIDM	APBCONS_PIDM	APBCONS
APRXREF_XREF_PIDM	SPBPERS_PIDM	SPBPERS
APRXREF_XREF_CODE	AGBSPRL_XREF_CODE	AGBSPRL

Index

Index Name	Index Type	Column Name
PK_APRXREF	Unique	APRXREF_PIDM
PK_APRXREF	Unique	APRXREF_XREF_CODE
PK_APRXREF	Unique	APRXREF_XREF_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBIDRL	SQL Table	S10B80.ALUMNI	Join
AGRIDRL	SQL Table	S10B80.ALUMNI	Join
AGRSPRL	SQL Table	S10B80.ALUMNI	Join
APREHIS	SQL Table	S10B80.ALUMNI	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
APVSHR1	SQL View	S10B80.BANINST1	Use (select)
APVXREF	SQL View	S10B80.BANINST1	Use (select)
F_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
F_CROSS_REFERENCE_INFO	SQL Function	S10B80.BANINST1	Use (select)
DISXREF_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
DISXREF_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
APRXREF_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
APRXREF_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
APRXREF_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
APRXREFSPOUSEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
APRXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
APRXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
APRXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
COMCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
DISXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DISXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
INDIVIDSPLITINFOC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
INDIVIDSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
INSTSPLITINFOC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
INSTSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
SPLITINDIVIDC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
SPLITINSTC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
XREF_CHIS_CURSOR	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
XREF_CHIS_CURSOR	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
P_INSERT_AGTOGIV_DATA	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
SPOUSE_PIDM	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
P_APTADDR_IN_USE	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
P_LOAD_APRXREF	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Rely On
P_LOAD_APRXREF	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Use (Insert,select)
F_GET_PRIMARY_SPS_PIDM	Oracle Package Function	S10B80.BANINST1.AOKLIBS	Use (select)
F_HOUSEHOLD_COUNT	Oracle Package Function	S10B80.BANINST1.AOKHHLD	Use (select)
F_HOUSEHOLD_PIDM	Oracle Package Function	S10B80.BANINST1.AOKHHLD	Use (select)
APRXREF	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_APRXREF	SQL Index	S10B80.ALUMNI	Rely On
AGBSPRL	SQL Table	S10B80.ALUMNI	Join
APBCONS	SQL Table	S10B80.ALUMNI	Join
ATVXREF	SQL Table	S10B80.ALUMNI	Refer (no action)
SPBPERS	SQL Table	S10B80.SATURN	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRXREF

Object Dates

Creation Date	Analysis Date
04/02/2008 13:41:27:000	04/02/2008 13:49:16:000

Source Code Comments

Cross Reference Repeating View

Columns Comments for APRXREF_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRXREF_XREF_CODE (# 2)

Source Code Comments

This field specifies the code that identifies the relationship to the cross-referenced constituent.

Columns Comments for APRXREF_XREF_PIDM (# 3)

Source Code Comments

This field specifies the internal system generated identification number of the constituent that is cross-referenced.

Columns Comments for APRXREF_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for APRXREF_CM_PRI_IND (# 5)

Source Code Comments

This field indicates the relationship of the pidm to the xref pidm for spousal relations.

Columns Comments for APRXREF_HOUSEHOLD_IND (# 6)

Source Code Comments

Indicator identifies whether or not person with this XREF lives at the same address as one identified by reverse. Indicator should always be the same for both XREF and reverse. Defaults to value on ATVXREF, but may be overrideen by user.

Table ATVCMTP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVCMTP_CODE	VARCHAR2(2)	No	*
ATVCMTP_DESC	VARCHAR2(30)	No
ATVCMTP_ACTIVITY_DATE	DATE	No
ATVCMTP_CAPITAL_IND	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVCMTP	Unique	ATVCMTP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRIDRL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRSPRL	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCCT	SQL Table	S10B80.ALUMNI	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVCMTPC	Oracle Package Cursor	S10B80.BANINST1.ATKCMTP	Use (select)Rely On
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVCMTP	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_ATVCMTP	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVCMTP

Object Dates

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

Source Code Comments

Campaign Type Validation Table

Columns Comments for ATVCMTP_CODE (# 1)

Source Code Comments

This field specifies the code for the type of campaign.

Columns Comments for ATVCMTP_DESC (# 2)

Source Code Comments

This field specifies the description of the campaign code.

Columns Comments for ATVCMTP_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for ATVCMTP_CAPITAL_IND (# 4)

Source Code Comments

Capital campaign indicator. Valid values are Y for capital campaigns or blank.

Table ATVDSTP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVDSTP_CODE	VARCHAR2(5)	No	*
ATVDSTP_DESC	VARCHAR2(30)	No
ATVDSTP_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVDSTP	Unique	ATVDSTP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRIDRL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRSPRL	SQL Table	S10B80.ALUMNI	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVDSTPC	Oracle Package Cursor	S10B80.BANINST1.ATKDSTP	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVDSTP	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_ATVDSTP	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVDSTP

Object Dates

Creation Date	Analysis Date
04/02/2008 13:41:24:000	04/02/2008 13:49:16:000

Source Code Comments

Designation Type Validation Table

Columns Comments for ATVDSTP_CODE (# 1)

Source Code Comments

This field specifies the code for the type of designation.

Columns Comments for ATVDSTP_DESC (# 2)

Source Code Comments

This field specifies the description of the designation code.

Columns Comments for ATVDSTP_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table ATVXREF

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVXREF_CODE	VARCHAR2(3)	No	*
ATVXREF_DESC	VARCHAR2(30)	No
ATVXREF_REVERSE_XREF	VARCHAR2(3)	Yes
ATVXREF_SPOUSE_IND	VARCHAR2(1)	Yes
ATVXREF_EMPLOYER_IND	VARCHAR2(1)	Yes
ATVXREF_MATCH_GIFT_IND	VARCHAR2(1)	Yes
ATVXREF_ACTIVITY_DATE	DATE	No
ATVXREF_HOUSEHOLD_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVXREF	Unique	ATVXREF_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBIDRL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBSPRL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRIDRL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRSPRL	SQL Table	S10B80.ALUMNI	Refer (no action)
APRCHLD	SQL Table	S10B80.ALUMNI	Refer (no action)
APRCSPS	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCXR	SQL Table	S10B80.ALUMNI	Refer (no action)
APREHIS	SQL Table	S10B80.ALUMNI	Refer (no action)
APRXREF	SQL Table	S10B80.ALUMNI	Refer (no action)
APVXREF	SQL View	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
DISXREF_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
DISXREF_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
ATVXREF_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
ATVXREF_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
ATVXREF_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
APRXREFSPOUSEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
ATVXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
ATVXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
ATVXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
DISXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DISXREFVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GETALLXREFC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
ATVXREFC	Oracle Package Cursor	S10B80.BANINST1.ATKXREF	Use (select)Rely On
P_APTADDR_IN_USE	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Rely On
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
P_LOAD_APRXREF	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Use (select)
P_LOAD_SPOUSE	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Rely On
P_LOAD_SPOUSE	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL	Use (Insert,select)
F_GET_PRIMARY_SPS_PIDM	Oracle Package Function	S10B80.BANINST1.AOKLIBS	Use (select)
F_HOUSEHOLD_COUNT	Oracle Package Function	S10B80.BANINST1.AOKHHLD	Use (select)
F_HOUSEHOLD_PIDM	Oracle Package Function	S10B80.BANINST1.AOKHHLD	Rely On
F_HOUSEHOLD_PIDM	Oracle Package Function	S10B80.BANINST1.AOKHHLD	Use (select)
ATVXREF	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_ATVXREF	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVXREF

Object Dates

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

Source Code Comments

Cross Reference Validation Table

Columns Comments for ATVXREF_CODE (# 1)

Source Code Comments

This field specifies the type of cross reference, i.e., spouse, employer, employee, parent, etc.

Columns Comments for ATVXREF_DESC (# 2)

Source Code Comments

This field specifies the description of the cross reference code.

Columns Comments for ATVXREF_REVERSE_XREF (# 3)

Source Code Comments

This field specifies the reverse of the initial reference, i.e., employer is the reverse cross reference of employee.

Columns Comments for ATVXREF_SPOUSE_IND (# 4)

Source Code Comments

This field specifies whether a cross reference code has a spousal relationship associated with it.

Columns Comments for ATVXREF_EMPLOYER_IND (# 5)

Source Code Comments

This field specifies whether a cross reference code has an employer associated with it.

Columns Comments for ATVXREF_MATCH_GIFT_IND (# 6)

Source Code Comments

This field specifies whether a cross reference code has a matching gift associated with it.

Columns Comments for ATVXREF_ACTIVITY_DATE (# 7)

Source Code Comments

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

Columns Comments for ATVXREF_HOUSEHOLD_IND (# 8)

Source Code Comments

Default indicator to use on APAPXREF, APACONS, and APACHLD. Indicator identifies whether or not person with this XREF lives the same address as one identified by reverse. Indicator should be the same for both XREF and reverse.

Table AUBCTRL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AUBCTRL_USER		VARCHAR2(30)	No	*
AUBCTRL_ACTIVITY_DATE		DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_AUBCTRL	Unique	AUBCTRL_USER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AMVPCMT	SQL View	S10B80.BANINST1	Use (select)
AUBCTRL	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_AUBCTRL	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AUBCTRL

Object Dates

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

Source Code Comments

Supervisor Control Table

Columns Comments for AUBCTRL_USER (# 1)

Source Code Comments

This field specifies user id for supervisor.

Columns Comments for AUBCTRL_ACTIVITY_DATE (# 2)

Source Code Comments

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

Table GTVLETR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GTVLETR_CODE	VARCHAR2(15)	No	*
GTVLETR_ACTIVITY_DATE	DATE	No
GTVLETR_DUPL_IND	VARCHAR2(1)	No
GTVLETR_DESC	VARCHAR2(30)	Yes
GTVLETR_PRINT_COMMAND	VARCHAR2(10)	Yes
GTVLETR_LETR_CODE_ALT	VARCHAR2(15)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVLETR_LETR_CODE_ALT	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_GTVLETR	Unique	GTVLETR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVLETR	Oracle Synonym	S10B80.FAISMGR	Rely On
AABDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AABMSHP	SQL Table	S10B80.ALUMNI	Refer (no action)
AARACKN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKIN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AARDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMEMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AARRLET	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRACKN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKPC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRALET	SQL Table	S10B80.ALUMNI	Refer (no action)
AUBINST	SQL Table	S10B80.ALUMNI	Refer (no action)
GEBFUNC	SQL Table	S10B80.GENERAL	Refer (no action)
GERFCOR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCALC	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCOLR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRORDR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GUBLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GUBPPRF	SQL Table	S10B80.GENERAL	Refer (no action)
GURMAIL	SQL Table	S10B80.GENERAL	Refer (no action)
RBRGMSG	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRMESG	SQL Table	S10B80.FAISMGR	Refer (no action)
RORSTRF	SQL Table	S10B80.FAISMGR	Refer (no action)
RRRTMSG	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVSAPR	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWALT	SQL Table	S10B80.SATURN	Refer (no action)
SFREPRT	SQL Table	S10B80.SATURN	Refer (no action)
SHBGADR	SQL Table	S10B80.SATURN	Refer (no action)
SHRTPRT	SQL Table	S10B80.SATURN	Refer (no action)
SOBMATL	SQL Table	S10B80.SATURN	Refer (no action)
SORELTL	SQL Table	S10B80.SATURN	Refer (no action)
F_STUDENT_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
CHK_GURMAIL_DUPS_BY_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
CHK_GURMAIL_DUPS_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
P_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
GTVLETRC	Oracle Package Cursor	S10B80.BANINST1.GTKLETR	Use (select)Rely On
GTVLETR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVLETR	Rely On
GTVLETR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVLETR	Use (select)Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (select)
P_PA_GTVLETR_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
P_VALIDATE_GLBLSEL	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_WL_REORDERING	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_GRADAPP_DISPLAYRULE	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVLETR	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVLETR	Rely On
F_GTVLETR_LIKE	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
GTVLETR	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_GTVLETR	SQL Index	S10B80.GENERAL	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVLETR

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:09:000	04/02/2008 21:17:50:000

Source Code Comments

Letter Process Letter Validation Table

Columns Comments for GTVLETR_CODE (# 1)

Source Code Comments

This field identifies the letter code referenced on the Recruiting Material Control Form (SRAMATL) and the Letter Process Form (GUALETR).

Columns Comments for GTVLETR_ACTIVITY_DATE (# 2)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for GTVLETR_DUPL_IND (# 3)

Source Code Comments

Y = Duplicates may be printed for this letter code, N = no dups.

Columns Comments for GTVLETR_DESC (# 4)

Source Code Comments

This field specifies the recruiting letter/material associated with the letter code.

Columns Comments for GTVLETR_PRINT_COMMAND (# 5)

Source Code Comments

This field identifies alternate print command code (e.g. PL - Print Landscape) for associated letter/material.

Columns Comments for GTVLETR_LETR_CODE_ALT (# 6)

Source Code Comments

Alternate Letter code for letter codes that do not allow duplicates.

Link between AGBIDRL and APRXREF

Join Information

Objects list
scope-cursor : S10B80.BANINST1.AGKGIFT.INDIVIDSPLITINFOC scope-cursor : S10B80.BANINST1.BWAKCPMT.SPLITINDIVIDC

Link List

Link Type	Link	Project
Join	Link Between AGBIDRL and APRXREF	ALUMNI

List of Real links

Link type	Between	And
Join	AGBIDRL	APRXREF

Link between AGRIDRL and APRXREF

Join Information

Objects list
scope-cursor : S10B80.BANINST1.AGKGIFT.INDIVIDSPLITRULEC

Link List

Link Type	Link	Project
Join	Link Between AGRIDRL and APRXREF	ALUMNI

List of Real links

Link type	Between	And
Join	AGRIDRL	APRXREF

Link between APRXREF and AGBSPRL

Join Information

Objects list
scope-cursor : S10B80.BANINST1.AGKGIFT.INSTSPLITINFOC scope-cursor : S10B80.BANINST1.BWAKCPMT.SPLITINSTC

Link List

Link Type	Link	Project
Join	Link Between APRXREF and AGBSPRL	ALUMNI

List of Real links

Link type	Between	And
Join	APRXREF	AGBSPRL

Link between AGRSPRL and APRXREF

Join Information

Objects list
scope-cursor : S10B80.BANINST1.AGKGIFT.INSTSPLITRULEC

Link List

Link Type	Link	Project
Join	Link Between AGRSPRL and APRXREF	ALUMNI

List of Real links

Link type	Between	And
Join	AGRSPRL	APRXREF

Link between AGRSPRL and ATVDSTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRSPRL and ATVDSTP (FK1_AGRSPRL_INV_ATVDSTP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRSPRL	AGRSPRL_DSTP_CODE	ATVDSTP_CODE	ATVDSTP	(0,1)-(0,n)

Link between AGRACKR and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRACKR and GTVLETR (FK1_AGRACKR_INV_GTVLETR_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRACKR and GTVLETR (FK2_AGRACKR_INV_GTVLETR_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRACKR and GTVLETR (FK3_AGRACKR_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRACKR	AGRACKR_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRACKR	AGRACKR_LETR_CODE_EMPL	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRACKR	AGRACKR_LETR_CODE_RECPT	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Link between AGRAKCP and AGRACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKCP and AGRACKR (FK1_AGRAKCP_INV_AGRACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKCP	AGRAKCP_RULE_NO	AGRACKR_RULE_NO	AGRACKR	(1,1)-(0,n)
AGRAKCP	AGRAKCP_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR	(1,1)-(0,n)

Link between AGRAKCP and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKCP and GTVLETR (FK1_AGRAKCP_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKCP	AGRAKCP_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AGRAKCT and AGRACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKCT and AGRACKR (FK1_AGRAKCT_INV_AGRACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKCT	AGRAKCT_RULE_NO	AGRACKR_RULE_NO	AGRACKR	(1,1)-(0,n)
AGRAKCT	AGRAKCT_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR	(1,1)-(0,n)

Link between AGRAKCT and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKCT and GTVLETR (FK1_AGRAKCT_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKCT	AGRAKCT_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AGRAKDC and AGRACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKDC and AGRACKR (FK1_AGRAKDC_INV_AGRACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKDC	AGRAKDC_RULE_NO	AGRACKR_RULE_NO	AGRACKR	(1,1)-(0,n)
AGRAKDC	AGRAKDC_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR	(1,1)-(0,n)

Link between AGRAKDC and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKDC and GTVLETR (FK1_AGRAKDC_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKDC	AGRAKDC_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AGRAKDG and AGRACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKDG and AGRACKR (FK1_AGRAKDG_INV_AGRACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKDG	AGRAKDG_RULE_NO	AGRACKR_RULE_NO	AGRACKR	(1,1)-(0,n)
AGRAKDG	AGRAKDG_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR	(1,1)-(0,n)

Link between AGRAKDG and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKDG and GTVLETR (FK1_AGRAKDG_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKDG	AGRAKDG_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AGRAKDN and AGRACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKDN and AGRACKR (FK1_AGRAKDN_INV_AGRACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKDN	AGRAKDN_RULE_NO	AGRACKR_RULE_NO	AGRACKR	(1,1)-(0,n)
AGRAKDN	AGRAKDN_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR	(1,1)-(0,n)

Link between AGRAKDN and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKDN and GTVLETR (FK1_AGRAKDN_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKDN	AGRAKDN_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AGRAKEX and AGRACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKEX and AGRACKR (FK1_AGRAKEX_INV_AGRACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKEX	AGRAKEX_RULE_NO	AGRACKR_RULE_NO	AGRACKR	(1,1)-(0,n)
AGRAKEX	AGRAKEX_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR	(1,1)-(0,n)

Link between AGRAKEX and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKEX and GTVLETR (FK1_AGRAKEX_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKEX	AGRAKEX_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AGRAKGC and AGRACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKGC and AGRACKR (FK1_AGRAKGC_INV_AGRACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKGC	AGRAKGC_RULE_NO	AGRACKR_RULE_NO	AGRACKR	(1,1)-(0,n)
AGRAKGC	AGRAKGC_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR	(1,1)-(0,n)

Link between AGRAKGC and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKGC and GTVLETR (FK1_AGRAKGC_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKGC	AGRAKGC_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AGRAKGT and AGRACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKGT and AGRACKR (FK1_AGRAKGT_INV_AGRACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKGT	AGRAKGT_RULE_NO	AGRACKR_RULE_NO	AGRACKR	(1,1)-(0,n)
AGRAKGT	AGRAKGT_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR	(1,1)-(0,n)

Link between AGRAKGT and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKGT and GTVLETR (FK1_AGRAKGT_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKGT	AGRAKGT_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AGRAKPC and AGRACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKPC and AGRACKR (FK1_AGRAKPC_INV_AGRACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKPC	AGRAKPC_RULE_NO	AGRACKR_RULE_NO	AGRACKR	(1,1)-(0,n)
AGRAKPC	AGRAKPC_LETR_CODE	AGRACKR_LETR_CODE	AGRACKR	(1,1)-(0,n)

Link between AGRAKPC and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKPC and GTVLETR (FK1_AGRAKPC_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKPC	AGRAKPC_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AGBIDRL and ATVXREF

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBIDRL and ATVXREF (FK1_AGBIDRL_INV_ATVXREF_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBIDRL	AGBIDRL_XREF_CODE	ATVXREF_CODE	ATVXREF	(1,1)-(0,n)

Link between AGRSPRL and ATVXREF

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRSPRL and ATVXREF (FK1_AGRSPRL_INV_ATVXREF_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRSPRL	AGRSPRL_XREF_CODE	ATVXREF_CODE	ATVXREF	(1,1)-(0,n)

Link between APRXREF and ATVXREF

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APRXREF and ATVXREF (FK1_APRXREF_INV_ATVXREF_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APRXREF	APRXREF_XREF_CODE	ATVXREF_CODE	ATVXREF	(1,1)-(0,n)

Link between AGBSPRL and ATVXREF

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBSPRL and ATVXREF (FK1_AGBSPRL_INV_ATVXREF_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBSPRL	AGBSPRL_XREF_CODE	ATVXREF_CODE	ATVXREF	(1,1)-(0,n)

Link between AGRIDRL and ATVDSTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRIDRL and ATVDSTP (FK1_AGRIDRL_INV_ATVDSTP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRIDRL	AGRIDRL_DSTP_CODE	ATVDSTP_CODE	ATVDSTP	(0,1)-(0,n)

Link between AGRIDRL and ATVXREF

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRIDRL and ATVXREF (FK1_AGRIDRL_INV_ATVXREF_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRIDRL	AGRIDRL_XREF_CODE	ATVXREF_CODE	ATVXREF	(1,1)-(0,n)

Link between AGRAKCT and ATVCMTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAKCT and ATVCMTP (FK1_AGRAKCT_INV_ATVCMTP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAKCT	AGRAKCT_CMTP_CODE	ATVCMTP_CODE	ATVCMTP	(1,1)-(0,n)

Link between AGRIDRL and ATVCMTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRIDRL and ATVCMTP (FK1_AGRIDRL_INV_ATVCMTP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRIDRL	AGRIDRL_CMTP_CODE	ATVCMTP_CODE	ATVCMTP	(0,1)-(0,n)

Link between AGRSPRL and ATVCMTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRSPRL and ATVCMTP (FK1_AGRSPRL_INV_ATVCMTP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRSPRL	AGRSPRL_CMTP_CODE	ATVCMTP_CODE	ATVCMTP	(0,1)-(0,n)

Link between GTVLETR and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GTVLETR and GTVLETR (FK1_GTVLETR_INV_GTVLETR_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GTVLETR	GTVLETR_LETR_CODE_ALT	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)