Model Pledge*

Model Label :

List of Objects

Object Name	Object Type	Layer Name
AGBPINS	SQL Table	Default
AGBPLDG	SQL Table	Default
AGRAPDS	SQL Table	Default
AGRAPLG	SQL Table	Default
AGRGIDS	SQL Table	Default
AGRGMEM	SQL Table	Default
AGRGMLT	SQL Table	Default
AGRGMMO	SQL Table	Default
AGRPCAM	SQL Table	Default
AGRPDES	SQL Table	Default
AGRPIDS	SQL Table	Default
AGRPINS	SQL Table	Default
AGRPMEM	SQL Table	Default
AGRPMLT	SQL Table	Default
AGRPMMO	SQL Table	Default
AGRPSOL	SQL Table	Default
ATVFISC	SQL Table	Default
ATVPACK	SQL Table	Default
ATVPCAT	SQL Table	Default
ATVPCLS	SQL Table	Default
ATVPGVE	SQL Table	Default
ATVPLDG	SQL Table	Default
ATVPRMD	SQL Table	Default
ATVPSTA	SQL Table	Default
AXBMGID	SQL Table	Default
AXRMCAM	SQL Table	Default
AXRMDES	SQL Table	Default
AXRMGRN	SQL Table	Default
AXRMSOL	SQL Table	Default

Model View

Table AGBPINS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGBPINS_PIDM	NUMBER(8,0)	No	*	*
AGBPINS_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGBPINS_PDUR_CODE	VARCHAR2(1)	Yes		*
AGBPINS_FREQ_CODE	VARCHAR2(2)	No		*
AGBPINS_BILL_DATE	DATE	No
AGBPINS_ACTIVITY_DATE	DATE	No
AGBPINS_LAST_BILL_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBPINS_PIDM	AGBPLDG_PIDM	AGBPLDG
AGBPINS_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG
AGBPINS_FREQ_CODE	ATVFREQ_CODE	ATVFREQ
AGBPINS_PDUR_CODE	ATVPDUR_CODE	ATVPDUR

Index

Index Name	Index Type	Column Name
PK_AGBPINS	Unique	AGBPINS_PIDM
PK_AGBPINS	Unique	AGBPINS_PLEDGE_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPINS	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_AGBPINS	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVFREQ	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPDUR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBPINS

Object Dates

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

Source Code Comments

Pledge Installment Base Table

Columns Comments for AGBPINS_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGBPINS_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGBPINS_PDUR_CODE (# 3)

Source Code Comments

This field specifies the duration of the pledge.

Columns Comments for AGBPINS_FREQ_CODE (# 4)

Source Code Comments

This field specifies the frequency for installment reminders for the pledge.

Columns Comments for AGBPINS_BILL_DATE (# 5)

Source Code Comments

This field specifies the first billing date for the pledge.

Columns Comments for AGBPINS_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for AGBPINS_LAST_BILL_DATE (# 7)

Source Code Comments

The last billing date for the pledge installment.

Table AGBPLDG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGBPLDG_PIDM	NUMBER(8,0)	No	*	*
AGBPLDG_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGBPLDG_PLEDGE_DATE	DATE	No
AGBPLDG_AMT_PLEDGED	NUMBER(11,2)	No
AGBPLDG_FISC_CODE	NUMBER(4,0)	No		*
AGBPLDG_PSTA_CODE	VARCHAR2(1)	No		*
AGBPLDG_PACK_CODE	VARCHAR2(2)	Yes		*
AGBPLDG_PRMD_CODE	VARCHAR2(2)	Yes		*
AGBPLDG_REM_COUNT	NUMBER(2,0)	Yes
AGBPLDG_REM_DATE	DATE	Yes
AGBPLDG_ACTIVITY_DATE	DATE	No
AGBPLDG_ADJ_IND	VARCHAR2(1)	Yes
AGBPLDG_PACK_IND	VARCHAR2(1)	Yes
AGBPLDG_RECEIPT_IND	VARCHAR2(1)	Yes
AGBPLDG_RECEIPT_DATE	DATE	Yes
AGBPLDG_PLDG_CODE	VARCHAR2(2)	Yes		*
AGBPLDG_PCLS_CODE	VARCHAR2(4)	Yes		*
AGBPLDG_COMMENT	VARCHAR2(300)	Yes
AGBPLDG_PCAT_CODE	VARCHAR2(5)	Yes		*
AGBPLDG_ENTRY_DATE	DATE	No
AGBPLDG_USER	VARCHAR2(30)	No
AGBPLDG_MATCH_PROCESSED	VARCHAR2(1)	Yes
AGBPLDG_MATCH_FORM_IND	VARCHAR2(1)	Yes
AGBPLDG_MGFORM_READYTOSEND	VARCHAR2(1)	Yes
AGBPLDG_FEED_IND	VARCHAR2(1)	Yes
AGBPLDG_FEED_DATE	DATE	Yes
AGBPLDG_FEED_DOC_CODE	VARCHAR2(8)	Yes
AGBPLDG_PGVE_CODE	VARCHAR2(5)	Yes		*
AGBPLDG_PCLS_CODE_2	VARCHAR2(4)	Yes		*
AGBPLDG_PCLS_CODE_3	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBPLDG_FISC_CODE	ATVFISC_CODE	ATVFISC
AGBPLDG_PACK_CODE	ATVPACK_CODE	ATVPACK
AGBPLDG_PCAT_CODE	ATVPCAT_CODE	ATVPCAT
AGBPLDG_PCLS_CODE	ATVPCLS_CODE	ATVPCLS
AGBPLDG_PCLS_CODE_2	ATVPCLS_CODE	ATVPCLS
AGBPLDG_PCLS_CODE_3	ATVPCLS_CODE	ATVPCLS
AGBPLDG_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBPLDG_PLDG_CODE	ATVPLDG_CODE	ATVPLDG
AGBPLDG_PRMD_CODE	ATVPRMD_CODE	ATVPRMD
AGBPLDG_PSTA_CODE	ATVPSTA_CODE	ATVPSTA
AGBPLDG_PIDM	AGRPINS_PIDM	AGRPINS
AGBPLDG_PLEDGE_NO	AGRPINS_PLEDGE_NO	AGRPINS
AGBPLDG_PLEDGE_NO	AGRPDES_PLEDGE_NO	AGRPDES
AGBPLDG_PIDM	AGRPDES_PIDM	AGRPDES

Index

Index Name	Index Type	Column Name
AGBPLDG_KEY_INDEX2		AGBPLDG_PLEDGE_DATE
AGBPLDG_KEY_INDEX3		AGBPLDG_ACTIVITY_DATE
PK_AGBPLDG	Unique	AGBPLDG_PIDM
PK_AGBPLDG	Unique	AGBPLDG_PLEDGE_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBPINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGIDS	SQL Table	S10B80.ALUMNI	Join
AGRGMEM	SQL Table	S10B80.ALUMNI	Join
AGRGMLT	SQL Table	S10B80.ALUMNI	Join
AGRGMMO	SQL Table	S10B80.ALUMNI	Join
AGRPCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPIDS	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPMEM	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPMLT	SQL Table	S10B80.ALUMNI	Join
AGRPMMO	SQL Table	S10B80.ALUMNI	Join
AGRPSOL	SQL Table	S10B80.ALUMNI	Join
AXBMGID	SQL Table	S10B80.ALUMNI	Join
AXRMCAM	SQL Table	S10B80.ALUMNI	Join
AXRMDES	SQL Table	S10B80.ALUMNI	Join
AXRMGRN	SQL Table	S10B80.ALUMNI	Join
AXRMSOL	SQL Table	S10B80.ALUMNI	Join
AGV3DTL	SQL View	S10B80.BANINST1	Use (select)
AGV3PAY	SQL View	S10B80.BANINST1	Use (select)
AGVGLST	SQL View	S10B80.BANINST1	Join
AGVPCAM	SQL View	S10B80.BANINST1	Use (select)
AGVPCRD	SQL View	S10B80.BANINST1	Use (select)
AGVPINS	SQL View	S10B80.BANINST1	Use (select)
AGVPLD2	SQL View	S10B80.BANINST1	Use (select)
AGVPLDG	SQL View	S10B80.BANINST1	Use (select)
AGVPLST	SQL View	S10B80.BANINST1	Use (select)
AGVPMEM	SQL View	S10B80.BANINST1	Use (select)
AGVPMLT	SQL View	S10B80.BANINST1	Use (select)
AGVPSCR	SQL View	S10B80.BANINST1	Use (select)
AGVPSFT	SQL View	S10B80.BANINST1	Use (select)
AGVPSOL	SQL View	S10B80.BANINST1	Use (select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
F_HIGH_PLEDGE_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_MOST_RECENT_PLEDGE_AMOUNT	SQL Function	S10B80.BANINST1	Use (select)
F_NUMBER_PLEDGE_YEAR	SQL Function	S10B80.BANINST1	Use (select)
ALLPLDG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
ALLPLDG_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
AGBPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGBPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGBPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKLIBS	Rely On
AGBPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKVOPP	Rely On
AGBPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGBPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)Rely On
AGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
AGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
ALLPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
ALLPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
LARGEAGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
LARGEAGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
PLEDGECOUNTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
PLEDGECOUNTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
RECENTAGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
RECENTAGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATEPLEDGESTATUS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATEPLEDGESTATUS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (update,select)
AGBPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
PLDG_NO	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
P_AGBPLDG_ADR	Oracle Package Procedure	S10B80.BANINST1.EOKARTS	Rely On
P_AGBPLDG_AIR	Oracle Package Procedure	S10B80.BANINST1.EOKARTS	Rely On
P_AGBPLDG_AUR	Oracle Package Procedure	S10B80.BANINST1.EOKARTS	Rely On
P_CHECK_IF_PAYABLE	Oracle Package Procedure	S10B80.BANINST1.BWAKLIBS	Use (select)
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)Rely On
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (update,select)
P_GET_GIFT_INFO	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Rely On
P_GET_GIFT_INFO	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Use (select)
P_GIFT_BY_FISCAL_YR	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
P_PLEDGE_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Rely On
F_CALC_PDES_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Use (select)
F_CALC_PINS_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Use (select)
F_XMG_CAMP_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_CAMP_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_DESG_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_DESG_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AGBPLDG	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
AGBPLDG_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_AGBPLDG	SQL Index	S10B80.ALUMNI	Rely On
AGRPDES	SQL Table	S10B80.ALUMNI	Join
AGRPINS	SQL Table	S10B80.ALUMNI	Join
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPACK	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPCAT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPCLS	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPGVE	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPRMD	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPSTA	SQL Table	S10B80.ALUMNI	Refer (no action)
A$_AGBPLDG_DATE_UPD_TRG	SQL Trigger	S10B80.ALUMNI	Fire (Insert,before,each row)
A$_AGBPLDG_EXPMG_DEL_TRG	SQL Trigger	S10B80.ALUMNI	Fire (delete,after,each row)
ET_AGBPLDG_ADR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (delete,after,each row)
ET_AGBPLDG_AIR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (Insert,after,each row)
ET_AGBPLDG_AUR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (update,after,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBPLDG

Object Dates

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

Source Code Comments

Pledge Base Table

Columns Comments for AGBPLDG_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGBPLDG_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGBPLDG_PLEDGE_DATE (# 3)

Source Code Comments

This field specifies the date of the pledge.

Columns Comments for AGBPLDG_AMT_PLEDGED (# 4)

Source Code Comments

This field specifies the amount of the pledge.

Columns Comments for AGBPLDG_FISC_CODE (# 5)

Source Code Comments

This field specifies the fiscal year associated with the pledge.

Columns Comments for AGBPLDG_PSTA_CODE (# 6)

Source Code Comments

This field specifies the status of the pledge.

Columns Comments for AGBPLDG_PACK_CODE (# 7)

Source Code Comments

Pledge Range Code associated with the pledge amount.

Columns Comments for AGBPLDG_PRMD_CODE (# 8)

Source Code Comments

This field specifies the reminder type for the pledge.

Columns Comments for AGBPLDG_REM_COUNT (# 9)

Source Code Comments

This system maintained field specifies the number of reminders produced by the system to date.

Columns Comments for AGBPLDG_REM_DATE (# 10)

Source Code Comments

This field specifies the date of the last reminder.

Columns Comments for AGBPLDG_ACTIVITY_DATE (# 11)

Source Code Comments

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

Columns Comments for AGBPLDG_ADJ_IND (# 12)

Source Code Comments

This field indicates a pledge has been adjusted via the Gift Pledge Adjustment Form.

Columns Comments for AGBPLDG_PACK_IND (# 13)

Source Code Comments

Pledge Acknowledgement indicator updated when a pledge is acknowledged.

Columns Comments for AGBPLDG_RECEIPT_IND (# 14)

Source Code Comments

Pledge Acknowledgement indicator updated when a receipt is to be sent.

Columns Comments for AGBPLDG_RECEIPT_DATE (# 15)

Source Code Comments

Pledge Acknowledgement receipt date.

Columns Comments for AGBPLDG_PLDG_CODE (# 16)

Source Code Comments

Code for the pledge type.

Columns Comments for AGBPLDG_PCLS_CODE (# 17)

Source Code Comments

Class for the pledge.

Columns Comments for AGBPLDG_COMMENT (# 18)

Source Code Comments

Comments pertaining to the pledge.

Columns Comments for AGBPLDG_PCAT_CODE (# 19)

Source Code Comments

Pledge Category Code.

Columns Comments for AGBPLDG_ENTRY_DATE (# 20)

Source Code Comments

Date the Pledge was entered into the system.

Columns Comments for AGBPLDG_USER (# 21)

Source Code Comments

User ID of the person who created/updated the record.

Columns Comments for AGBPLDG_MATCH_PROCESSED (# 22)

Source Code Comments

(Y) = Yes, this pledge has had the MG evaluation processed. (N) = No, this pledge has NOT had the MG eval process done. Null = No, this pledge has NOT had the MG eval process done. (D) = This means that at one time the AXBMGID row existed, but was (D)

Columns Comments for AGBPLDG_MATCH_FORM_IND (# 23)

Source Code Comments

(P) = per Payment. MG form required for each Payment. (F) = when Fulfilled. MG form required when pledge Fulfilled. (I) = Intermittant. Send MG form based on column AXBMGID_COMMENT. Null = UNKNOWN.

Columns Comments for AGBPLDG_MGFORM_READYTOSEND (# 24)

Source Code Comments

(Y) = Yes, the MG Form is Ready To Send to the Employer. (N) = No, the MG Form is NOT Ready To Send to the Employer. Null = No, the MG Form is NOT Ready To Send to the Employer.

Columns Comments for AGBPLDG_FEED_IND (# 25)

Source Code Comments

Gift feed indicator updated when a pledge is fed to Finance.

Columns Comments for AGBPLDG_FEED_DATE (# 26)

Source Code Comments

This field specifies the date this pledge record has been fed to finance.

Columns Comments for AGBPLDG_FEED_DOC_CODE (# 27)

Source Code Comments

Pledge feed document code for the pledge being adjusted, updated when the pledge was fed to Finance.

Columns Comments for AGBPLDG_PGVE_CODE (# 28)

Source Code Comments

The Pledge Gift Vehicle Code associated with this pledge.

Columns Comments for AGBPLDG_PCLS_CODE_2 (# 29)

Source Code Comments

Class Code two for the Pledge.

Columns Comments for AGBPLDG_PCLS_CODE_3 (# 30)

Source Code Comments

Class Code three for the Pledge.

Table AGRAPDS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRAPDS_PIDM	NUMBER(8,0)	No	*	*
AGRAPDS_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRAPDS_APLG_SEQ_NO	NUMBER(3,0)	No	*	*
AGRAPDS_SEQ_NO	NUMBER(3,0)	No	*
AGRAPDS_CAMPAIGN	VARCHAR2(5)	No
AGRAPDS_DESG	VARCHAR2(10)	No
AGRAPDS_AMT	NUMBER(11,2)	No
AGRAPDS_USER_ADJ	VARCHAR2(30)	No
AGRAPDS_CAMPAIGN_ADJ	VARCHAR2(5)	Yes
AGRAPDS_DESG_ADJ	VARCHAR2(10)	Yes
AGRAPDS_AMT_ADJ	NUMBER(11,2)	Yes
AGRAPDS_ACTIVITY_DATE	DATE	No
AGRAPDS_NEED_TO_FEED_IND	VARCHAR2(1)	Yes
AGRAPDS_FEED_IND_ADJ	VARCHAR2(1)	Yes
AGRAPDS_FEED_DATE_ADJ	DATE	Yes
AGRAPDS_FEED_DOC_CODE_ADJ	VARCHAR2(8)	Yes
AGRAPDS_ENTRY_DATE	DATE	No
AGRAPDS_ENTRY_DATE_ADJ	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRAPDS_PIDM	AGRAPLG_PIDM	AGRAPLG
AGRAPDS_PLEDGE_NO	AGRAPLG_PLEDGE_NO	AGRAPLG
AGRAPDS_APLG_SEQ_NO	AGRAPLG_SEQ_NO	AGRAPLG

Index

Index Name	Index Type	Column Name
PK_AGRAPDS	Unique	AGRAPDS_PIDM
PK_AGRAPDS	Unique	AGRAPDS_PLEDGE_NO
PK_AGRAPDS	Unique	AGRAPDS_APLG_SEQ_NO
PK_AGRAPDS	Unique	AGRAPDS_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGVAPDS	SQL View	S10B80.BANINST1	Use (select)
AGRAPDS	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_AGRAPDS	SQL Index	S10B80.ALUMNI	Rely On
AGRAPLG	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAPDS

Object Dates

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

Source Code Comments

Adjustment Pledge Designation Table

Columns Comments for AGRAPDS_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRAPDS_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRAPDS_APLG_SEQ_NO (# 3)

Source Code Comments

This field specifies the corresponding pledge adjustment sequence number from the AGRAPLG table.

Columns Comments for AGRAPDS_SEQ_NO (# 4)

Source Code Comments

This field specifies the sequence number of the pledge adjustment.

Columns Comments for AGRAPDS_CAMPAIGN (# 5)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRAPDS_DESG (# 6)

Source Code Comments

This field specifies the designation code associated with the campaign.

Columns Comments for AGRAPDS_AMT (# 7)

Source Code Comments

This field specifies the amount of the pledge designation. This field defaults to the campaign amount.

Columns Comments for AGRAPDS_USER_ADJ (# 8)

Source Code Comments

This field specifies the user id associated with the pledge designation adjustment.

Columns Comments for AGRAPDS_CAMPAIGN_ADJ (# 9)

Source Code Comments

This field specifies the new campaign code associated with the pledge.

Columns Comments for AGRAPDS_DESG_ADJ (# 10)

Source Code Comments

This field specifies the new designation code associated with the campaign.

Columns Comments for AGRAPDS_AMT_ADJ (# 11)

Source Code Comments

This field specifies the new amount of the pledge designation.

Columns Comments for AGRAPDS_ACTIVITY_DATE (# 12)

Source Code Comments

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

Columns Comments for AGRAPDS_NEED_TO_FEED_IND (# 13)

Source Code Comments

This field indicates that the gift being adjusted was fed to finance and the adjustments must also be fed to finance.

Columns Comments for AGRAPDS_FEED_IND_ADJ (# 14)

Source Code Comments

This field indicates if the gift adjustments have been fed to finance.

Columns Comments for AGRAPDS_FEED_DATE_ADJ (# 15)

Source Code Comments

This field specifies the date the gift adjustments have been fed to finance.

Columns Comments for AGRAPDS_FEED_DOC_CODE_ADJ (# 16)

Source Code Comments

This field specifies the document number of the feed program that included this gift adjustment.

Columns Comments for AGRAPDS_ENTRY_DATE (# 17)

Source Code Comments

The original date the pledge was entered.

Columns Comments for AGRAPDS_ENTRY_DATE_ADJ (# 18)

Source Code Comments

The adjusted date the pledge was entered.

Table AGRAPLG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRAPLG_PIDM	NUMBER(8,0)	No	*
AGRAPLG_PLEDGE_NO	VARCHAR2(7)	No	*
AGRAPLG_SEQ_NO	NUMBER(3,0)	No	*
AGRAPLG_PLEDGE_DATE	DATE	No
AGRAPLG_AMT_PLEDGED	NUMBER(11,2)	No
AGRAPLG_FISC_CODE	NUMBER(4,0)	No		*
AGRAPLG_PSTA_CODE	VARCHAR2(1)	No		*
AGRAPLG_PACK_CODE	VARCHAR2(2)	Yes		*
AGRAPLG_PRMD_CODE	VARCHAR2(2)	Yes		*
AGRAPLG_REM_DATE	DATE	Yes
AGRAPLG_USER_ADJ	VARCHAR2(30)	No
AGRAPLG_PLEDGE_DATE_ADJ	DATE	Yes
AGRAPLG_AMT_PLEDGED_ADJ	NUMBER(11,2)	Yes
AGRAPLG_FISC_CODE_ADJ	NUMBER(4,0)	Yes		*
AGRAPLG_PSTA_CODE_ADJ	VARCHAR2(1)	Yes		*
AGRAPLG_PACK_CODE_ADJ	VARCHAR2(2)	Yes		*
AGRAPLG_PRMD_CODE_ADJ	VARCHAR2(2)	Yes		*
AGRAPLG_REM_DATE_ADJ	DATE	Yes
AGRAPLG_COMMENT_ADJ	VARCHAR2(300)	Yes
AGRAPLG_ACTIVITY_DATE	DATE	No
AGRAPLG_PLDG_CODE	VARCHAR2(2)	Yes		*
AGRAPLG_PCLS_CODE	VARCHAR2(4)	Yes		*
AGRAPLG_COMMENT	VARCHAR2(300)	Yes
AGRAPLG_PLDG_CODE_ADJ	VARCHAR2(2)	Yes		*
AGRAPLG_PCLS_CODE_ADJ	VARCHAR2(4)	Yes		*
AGRAPLG_PCAT_CODE	VARCHAR2(5)	Yes		*
AGRAPLG_PCAT_CODE_ADJ	VARCHAR2(5)	Yes		*
AGRAPLG_ENTRY_DATE	DATE	No
AGRAPLG_NEED_TO_FEED_IND	VARCHAR2(1)	Yes
AGRAPLG_FEED_IND	VARCHAR2(1)	Yes
AGRAPLG_FEED_DATE	DATE	Yes
AGRAPLG_FEED_DOC_CODE	VARCHAR2(8)	Yes
AGRAPLG_FEED_IND_ADJ	VARCHAR2(1)	Yes
AGRAPLG_FEED_DATE_ADJ	DATE	Yes
AGRAPLG_FEED_DOC_CODE_ADJ	VARCHAR2(8)	Yes
AGRAPLG_ENTRY_DATE_ADJ	DATE	No
AGRAPLG_PGVE_CODE	VARCHAR2(5)	Yes		*
AGRAPLG_PGVE_CODE_ADJ	VARCHAR2(5)	Yes		*
AGRAPLG_PCLS_CODE_2	VARCHAR2(4)	Yes		*
AGRAPLG_PCLS_CODE_3	VARCHAR2(4)	Yes		*
AGRAPLG_PCLS_CODE_2_ADJ	VARCHAR2(4)	Yes		*
AGRAPLG_PCLS_CODE_3_ADJ	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRAPLG_FISC_CODE_ADJ	ATVFISC_CODE	ATVFISC
AGRAPLG_FISC_CODE	ATVFISC_CODE	ATVFISC
AGRAPLG_PCAT_CODE_ADJ	ATVPCAT_CODE	ATVPCAT
AGRAPLG_PCAT_CODE	ATVPCAT_CODE	ATVPCAT
AGRAPLG_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGRAPLG_PGVE_CODE_ADJ	ATVPGVE_CODE	ATVPGVE
AGRAPLG_PACK_CODE_ADJ	ATVPACK_CODE	ATVPACK
AGRAPLG_PACK_CODE	ATVPACK_CODE	ATVPACK
AGRAPLG_PRMD_CODE_ADJ	ATVPRMD_CODE	ATVPRMD
AGRAPLG_PRMD_CODE	ATVPRMD_CODE	ATVPRMD
AGRAPLG_PCLS_CODE_ADJ	ATVPCLS_CODE	ATVPCLS
AGRAPLG_PCLS_CODE	ATVPCLS_CODE	ATVPCLS
AGRAPLG_PCLS_CODE_2	ATVPCLS_CODE	ATVPCLS
AGRAPLG_PCLS_CODE_3	ATVPCLS_CODE	ATVPCLS
AGRAPLG_PCLS_CODE_2_ADJ	ATVPCLS_CODE	ATVPCLS
AGRAPLG_PCLS_CODE_3_ADJ	ATVPCLS_CODE	ATVPCLS
AGRAPLG_PSTA_CODE	ATVPSTA_CODE	ATVPSTA
AGRAPLG_PSTA_CODE_ADJ	ATVPSTA_CODE	ATVPSTA
AGRAPLG_PLDG_CODE_ADJ	ATVPLDG_CODE	ATVPLDG
AGRAPLG_PLDG_CODE	ATVPLDG_CODE	ATVPLDG

Index

Index Name	Index Type	Column Name
PK_AGRAPLG	Unique	AGRAPLG_PIDM
PK_AGRAPLG	Unique	AGRAPLG_PLEDGE_NO
PK_AGRAPLG	Unique	AGRAPLG_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRAPDS	SQL Table	S10B80.ALUMNI	Join
AGVAPDS	SQL View	S10B80.BANINST1	Use (select)
AGRAPLG	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_AGRAPLG	SQL Index	S10B80.ALUMNI	Rely On
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPACK	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPCAT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPCLS	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPGVE	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPRMD	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPSTA	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAPLG

Object Dates

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

Source Code Comments

Adjustment Pledge Base Table

Columns Comments for AGRAPLG_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRAPLG_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRAPLG_SEQ_NO (# 3)

Source Code Comments

Peldge adjustment sequence number.

Columns Comments for AGRAPLG_PLEDGE_DATE (# 4)

Source Code Comments

This field specifies the date of the pledge.

Columns Comments for AGRAPLG_AMT_PLEDGED (# 5)

Source Code Comments

This field specifies the amount of the pledge.

Columns Comments for AGRAPLG_FISC_CODE (# 6)

Source Code Comments

This field specifies the fiscal year associated with the pledge.

Columns Comments for AGRAPLG_PSTA_CODE (# 7)

Source Code Comments

This field specifies the status of the pledge.

Columns Comments for AGRAPLG_PACK_CODE (# 8)

Source Code Comments

This field specifies the type of acknowledgement associated with the pledge.

Columns Comments for AGRAPLG_PRMD_CODE (# 9)

Source Code Comments

This field specifies the reminder type for the pledge.

Columns Comments for AGRAPLG_REM_DATE (# 10)

Source Code Comments

This field specifies the date of the last reminder.

Columns Comments for AGRAPLG_USER_ADJ (# 11)

Source Code Comments

This field specifies the user that entered the pledge adjustment.

Columns Comments for AGRAPLG_PLEDGE_DATE_ADJ (# 12)

Source Code Comments

This field specifies the new date of the adjusted pledge.

Columns Comments for AGRAPLG_AMT_PLEDGED_ADJ (# 13)

Source Code Comments

This field specifies the new amount of the adjusted pledge.

Columns Comments for AGRAPLG_FISC_CODE_ADJ (# 14)

Source Code Comments

This field specifies the new fiscal year associated with the pledge updated when the pledge date was adjusted.

Columns Comments for AGRAPLG_PSTA_CODE_ADJ (# 15)

Source Code Comments

This field specifies the new status of the pledge as adjusted on the adjustment form.

Columns Comments for AGRAPLG_PACK_CODE_ADJ (# 16)

Source Code Comments

This field specifies the new type of acknowledgement associated with the pledge.

Columns Comments for AGRAPLG_PRMD_CODE_ADJ (# 17)

Source Code Comments

This field specifies the new reminder type for the pledge.

Columns Comments for AGRAPLG_REM_DATE_ADJ (# 18)

Source Code Comments

This field specifies the new date of the last reminder.

Columns Comments for AGRAPLG_COMMENT_ADJ (# 19)

Source Code Comments

This field specifies a comment for the adjusted pledge.

Columns Comments for AGRAPLG_ACTIVITY_DATE (# 20)

Source Code Comments

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

Columns Comments for AGRAPLG_PLDG_CODE (# 21)

Source Code Comments

Code for the pledge type.

Columns Comments for AGRAPLG_PCLS_CODE (# 22)

Source Code Comments

Class for the pledge.

Columns Comments for AGRAPLG_COMMENT (# 23)

Source Code Comments

Comments pertaining to the pledge.

Columns Comments for AGRAPLG_PLDG_CODE_ADJ (# 24)

Source Code Comments

Code for the adjusted pledge type.

Columns Comments for AGRAPLG_PCLS_CODE_ADJ (# 25)

Source Code Comments

Adjusted class for the pledge.

Columns Comments for AGRAPLG_PCAT_CODE (# 26)

Source Code Comments

Pledge Category Code.

Columns Comments for AGRAPLG_PCAT_CODE_ADJ (# 27)

Source Code Comments

Adjusted Pledge Category Code.

Columns Comments for AGRAPLG_ENTRY_DATE (# 28)

Source Code Comments

Entry Date of the Adjustment.

Columns Comments for AGRAPLG_NEED_TO_FEED_IND (# 29)

Source Code Comments

This field indicates that the gift has been fed to Finance and if the adjustments affect Finance, they must also be fed.

Columns Comments for AGRAPLG_FEED_IND (# 30)

Source Code Comments

Gift feed indicator updated when a gift being adjusted was fed to Finance.

Columns Comments for AGRAPLG_FEED_DATE (# 31)

Source Code Comments

Gift feed date is the date the gift being adjusted was fed to the finance system

Columns Comments for AGRAPLG_FEED_DOC_CODE (# 32)

Source Code Comments

Gift feed document code for the gift being adjusted, updated when the gift was fed to Finance.

Columns Comments for AGRAPLG_FEED_IND_ADJ (# 33)

Source Code Comments

This field incidates that the adjustment records have been fed to finance.

Columns Comments for AGRAPLG_FEED_DATE_ADJ (# 34)

Source Code Comments

This field specifies the date this adjustment record has been fed to finance.

Columns Comments for AGRAPLG_FEED_DOC_CODE_ADJ (# 35)

Source Code Comments

This field specifies the feed document code that includes this adjustment.

Columns Comments for AGRAPLG_ENTRY_DATE_ADJ (# 36)

Source Code Comments

The adjusted entry date associated with this pledge.

Columns Comments for AGRAPLG_PGVE_CODE (# 37)

Source Code Comments

The original Pledge Gift Vehicle Code associated with this pledge.

Columns Comments for AGRAPLG_PGVE_CODE_ADJ (# 38)

Source Code Comments

The adjusted Pledge Gift Vehicle Code associated with this pledge.

Columns Comments for AGRAPLG_PCLS_CODE_2 (# 39)

Source Code Comments

Second pledge class code on pledge before the adjustment.

Columns Comments for AGRAPLG_PCLS_CODE_3 (# 40)

Source Code Comments

Third pledge class code on pledge before the adjustment.

Columns Comments for AGRAPLG_PCLS_CODE_2_ADJ (# 41)

Source Code Comments

Second pledge class code on adjusted pledge.

Columns Comments for AGRAPLG_PCLS_CODE_3_ADJ (# 42)

Source Code Comments

Third pledge class code on adjusted pledge.

Table AGRGIDS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRGIDS_PIDM	NUMBER(8,0)	No	*
AGRGIDS_GIFT_NO	VARCHAR2(7)	No	*
AGRGIDS_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGIDS_XREF_PIDM	NUMBER(8,0)	No	*
AGRGIDS_AMT	NUMBER(11,2)	No
AGRGIDS_ACTIVITY_DATE	DATE	No
AGRGIDS_3PP_AMT	NUMBER(11,2)	No
AGRGIDS_3PP_PLEDGE_NO	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGIDS_3PP_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRGIDS_KEY_INDEX2		AGRGIDS_XREF_PIDM
AGRGIDS_KEY_INDEX3		AGRGIDS_3PP_PLEDGE_NO
AGRGIDS_KEY_INDEX3		AGRGIDS_3PP_AMT
PK_AGRGIDS	Unique	AGRGIDS_PIDM
PK_AGRGIDS	Unique	AGRGIDS_GIFT_NO
PK_AGRGIDS	Unique	AGRGIDS_PLEDGE_NO
PK_AGRGIDS	Unique	AGRGIDS_XREF_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGV3PAY	SQL View	S10B80.BANINST1	Use (select)
AGVDONR	SQL View	S10B80.BANINST1	Use (select)
THIRD_PARTY_MULT	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
THIRD_PARTY_MULT	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
P_SPLITGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert)
TOTAL_3PP_MEMO_CREDIT	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
TOTAL_3PP_MEMO_CREDIT	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
TOTAL_3PP_MULT_CREDIT	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
TOTAL_3PP_MULT_CREDIT	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
TPP_MEMO_CREDIT	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
TPP_MULT_CREDIT	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
F_3RD_PARTY_CREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AGRGIDS	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
AGRGIDS_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGRGIDS_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRGIDS	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGIDS

Object Dates

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

Source Code Comments

Gift Multiple Id Repeating Table

Columns Comments for AGRGIDS_PIDM (# 1)

Source Code Comments

This field is the internal system generated identification number.

Columns Comments for AGRGIDS_GIFT_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the gift.

Columns Comments for AGRGIDS_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRGIDS_XREF_PIDM (# 4)

Source Code Comments

This field specifies the internal system generated number of the cross reference.

Columns Comments for AGRGIDS_AMT (# 5)

Source Code Comments

Amount of the gift associated with the cross reference pidm. Amount must be less than or equal to the total gift amount.

Columns Comments for AGRGIDS_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for AGRGIDS_3PP_AMT (# 7)

Source Code Comments

The amount of the payment that is going to a third party.

Columns Comments for AGRGIDS_3PP_PLEDGE_NO (# 8)

Source Code Comments

The pledge number to which the third party payment will be applied.

Table AGRGMEM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRGMEM_PIDM	NUMBER(8,0)	No	*	*
AGRGMEM_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGMEM_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRGMEM_MEMO_PIDM	NUMBER(8,0)	No	*
AGRGMEM_AMT	NUMBER(11,2)	No
AGRGMEM_ACTIVITY_DATE	DATE	No
AGRGMEM_3PP_AMT	NUMBER(11,2)	No
AGRGMEM_3PP_PLEDGE_NO	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGMEM_PIDM	AGRGPAY_PIDM	AGRGPAY
AGRGMEM_GIFT_NO	AGRGPAY_GIFT_NO	AGRGPAY
AGRGMEM_PLEDGE_NO	AGRGPAY_PLEDGE_NO	AGRGPAY
AGRGMEM_3PP_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRGMEM_KEY_INDEX2		AGRGMEM_MEMO_PIDM
AGRGMEM_KEY_INDEX3		AGRGMEM_3PP_PLEDGE_NO
AGRGMEM_KEY_INDEX3		AGRGMEM_3PP_AMT
PK_AGRGMEM	Unique	AGRGMEM_PIDM
PK_AGRGMEM	Unique	AGRGMEM_GIFT_NO
PK_AGRGMEM	Unique	AGRGMEM_PLEDGE_NO
PK_AGRGMEM	Unique	AGRGMEM_MEMO_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGV3PAY	SQL View	S10B80.BANINST1	Use (select)
THIRD_PARTY_MEMO	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
THIRD_PARTY_MEMO	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
P_SPLITGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert)
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
F_3RD_PARTY_CREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AGRGMEM	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
AGRGMEM_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGRGMEM_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRGMEM	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGRGPAY	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGMEM

Object Dates

Creation Date	Analysis Date
04/02/2008 13:41:58:000	04/02/2008 13:49:17:000

Source Code Comments

Gift Memo Id Repeating Table

Columns Comments for AGRGMEM_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRGMEM_GIFT_NO (# 2)

Source Code Comments

This field specifies the system assigned number of gift.

Columns Comments for AGRGMEM_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRGMEM_MEMO_PIDM (# 4)

Source Code Comments

This field specifies the identification number of the person or organization to whom a memo gift is credited.

Columns Comments for AGRGMEM_AMT (# 5)

Source Code Comments

This field specifies the amount of the memo gift.

Columns Comments for AGRGMEM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for AGRGMEM_3PP_AMT (# 7)

Source Code Comments

The amount of the payment that is going to a third party.

Columns Comments for AGRGMEM_3PP_PLEDGE_NO (# 8)

Source Code Comments

The pledge number to which the third party payment will be applied.

Table AGRGMLT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRGMLT_PIDM	NUMBER(8,0)	No	*
AGRGMLT_XREF_PIDM	NUMBER(8,0)	No	*
AGRGMLT_GIFT_NO	VARCHAR2(7)	No	*
AGRGMLT_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGMLT_CAMPAIGN	VARCHAR2(5)	No	*
AGRGMLT_DESG	VARCHAR2(10)	No	*
AGRGMLT_ACTIVITY_DATE	DATE	No
AGRGMLT_CREDIT	NUMBER(11,2)	Yes
AGRGMLT_3PP_AMT	NUMBER(11,2)	No
AGRGMLT_3PP_PLEDGE_NO	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGMLT_3PP_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRGMLT_KEY_INDEX2		AGRGMLT_XREF_PIDM
AGRGMLT_KEY_INDEX2		AGRGMLT_GIFT_NO
AGRGMLT_KEY_INDEX3		AGRGMLT_PIDM
AGRGMLT_KEY_INDEX3		AGRGMLT_PLEDGE_NO
AGRGMLT_KEY_INDEX3		AGRGMLT_XREF_PIDM
AGRGMLT_KEY_INDEX4		AGRGMLT_3PP_PLEDGE_NO
AGRGMLT_KEY_INDEX4		AGRGMLT_3PP_AMT
PK_AGRGMLT	Unique	AGRGMLT_PIDM
PK_AGRGMLT	Unique	AGRGMLT_GIFT_NO
PK_AGRGMLT	Unique	AGRGMLT_PLEDGE_NO
PK_AGRGMLT	Unique	AGRGMLT_CAMPAIGN
PK_AGRGMLT	Unique	AGRGMLT_DESG
PK_AGRGMLT	Unique	AGRGMLT_XREF_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Join
AGTGTCR	SQL Table	S10B80.ALUMNI	Join
AGV3DTL	SQL View	S10B80.BANINST1	Use (select)
AGVGCRD	SQL View	S10B80.BANINST1	Use (select)
AGVGFD2	SQL View	S10B80.BANINST1	Use (select)
AGVGGIF	SQL View	S10B80.BANINST1	Use (select)
AGVGMLT	SQL View	S10B80.BANINST1	Use (select)
F_CALC_CREDIT	SQL Function	S10B80.BANINST1	Use (select)
F_GIFT_HARD_CREDIT	SQL Function	S10B80.BANINST1	Use (select)
F_HIGH_GIFT_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_NUMBER_GIFT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
AGRGMLT_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGRGMLT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGRGMLT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGRGMLT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGRGMLTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGRGMLTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGRGMLTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGRGMLTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
ALLGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
ALLGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)
P_SPLITGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert)
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
P_GIFT_BY_FISCAL_YR	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
F_GETHARDGIFTCREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_GETHARDGIFTDESGCREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AGRGMLT	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
AGRGMLT_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGRGMLT_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
AGRGMLT_KEY_INDEX4	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRGMLT	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGMLT

Object Dates

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

Source Code Comments

Detail Gift Multiple Credit Table

Columns Comments for AGRGMLT_PIDM (# 1)

Source Code Comments

Internal identification number for person/organization associated with the gift.

Columns Comments for AGRGMLT_XREF_PIDM (# 2)

Source Code Comments

Internal identification number for person/organization receiving the multiple credit.

Columns Comments for AGRGMLT_GIFT_NO (# 3)

Source Code Comments

Gift number from which multiple credit is being disbursed.

Columns Comments for AGRGMLT_PLEDGE_NO (# 4)

Source Code Comments

Pledge no associated with the gift from which multiple credit is being disbursed.

Columns Comments for AGRGMLT_CAMPAIGN (# 5)

Source Code Comments

Campaign associated with the gift from which multiple credit is being disbursed.

Columns Comments for AGRGMLT_DESG (# 6)

Source Code Comments

Designation associated with the gift from which multiple credit is being disbursed.

Columns Comments for AGRGMLT_ACTIVITY_DATE (# 7)

Source Code Comments

Date this record was inserted or last updated.

Columns Comments for AGRGMLT_CREDIT (# 8)

Source Code Comments

Dollar amount of the gift being disbursed to the xref pidm from the pledge for the designation.

Columns Comments for AGRGMLT_3PP_AMT (# 9)

Source Code Comments

The amount of the payment that is going to a third party.

Columns Comments for AGRGMLT_3PP_PLEDGE_NO (# 10)

Source Code Comments

The pledge number to which the third party payment will be applied.

Table AGRGMMO

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRGMMO_PIDM	NUMBER(8,0)	No	*
AGRGMMO_XREF_PIDM	NUMBER(8,0)	No	*
AGRGMMO_GIFT_NO	VARCHAR2(7)	No	*
AGRGMMO_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGMMO_CAMPAIGN	VARCHAR2(5)	No	*
AGRGMMO_DESG	VARCHAR2(10)	No	*
AGRGMMO_ACTIVITY_DATE	DATE	No
AGRGMMO_CREDIT	NUMBER(11,2)	Yes
AGRGMMO_3PP_AMT	NUMBER(11,2)	No
AGRGMMO_3PP_PLEDGE_NO	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGMMO_3PP_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRGMMO_KEY_INDEX2		AGRGMMO_XREF_PIDM
AGRGMMO_KEY_INDEX2		AGRGMMO_GIFT_NO
AGRGMMO_KEY_INDEX3		AGRGMMO_PIDM
AGRGMMO_KEY_INDEX3		AGRGMMO_PLEDGE_NO
AGRGMMO_KEY_INDEX3		AGRGMMO_XREF_PIDM
AGRGMMO_KEY_INDEX4		AGRGMMO_3PP_PLEDGE_NO
AGRGMMO_KEY_INDEX4		AGRGMMO_3PP_AMT
PK_AGRGMMO	Unique	AGRGMMO_PIDM
PK_AGRGMMO	Unique	AGRGMMO_GIFT_NO
PK_AGRGMMO	Unique	AGRGMMO_PLEDGE_NO
PK_AGRGMMO	Unique	AGRGMMO_CAMPAIGN
PK_AGRGMMO	Unique	AGRGMMO_DESG
PK_AGRGMMO	Unique	AGRGMMO_XREF_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Join
AGTGTCR	SQL Table	S10B80.ALUMNI	Join
AGV3DTL	SQL View	S10B80.BANINST1	Use (select)
AGVGMEM	SQL View	S10B80.BANINST1	Use (select)
AGVGSCR	SQL View	S10B80.BANINST1	Use (select)
AGVGSFT	SQL View	S10B80.BANINST1	Use (select)
F_CAMPAIGN_MATCHING_GIFT	SQL Function	S10B80.BANINST1	Use (select)
F_CAMPAIGN_MEMO_CREDIT	SQL Function	S10B80.BANINST1	Use (select)
F_DESIGNATION_MATCHING_GIFT	SQL Function	S10B80.BANINST1	Use (select)
F_DESIGNATION_MEMO_CREDIT	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_NON_MAT_GIFT_MEMO	SQL Function	S10B80.BANINST1	Use (select)
AGRGMMO_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGRGMMO_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGRGMMO_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGRGMMO_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGRGMMOVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGRGMMOVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGRGMMOVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGRGMMOVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
AGRGMMO_2	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
AGRGMMO_2	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
AGRGMMO_4	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
AGRGMMO_4	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
ALLGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
ALLGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
CAMPEMPLMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPEMPLMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
CAMPEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
DESGEMPLMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPLMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
FISCEMPLMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
FISCEMPLMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
FISCEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)
P_SPLITGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert)
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
P_GIFT_BY_FISCAL_YR	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
F_GETSOFTGIFTCREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_GETSOFTGIFTDESGCREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AGRGMMO	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
AGRGMMO_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGRGMMO_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
AGRGMMO_KEY_INDEX4	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRGMMO	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGMMO

Object Dates

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

Source Code Comments

Detail Gift Memo Credit Table

Columns Comments for AGRGMMO_PIDM (# 1)

Source Code Comments

Internal identification number for person/organization associated with the gift.

Columns Comments for AGRGMMO_XREF_PIDM (# 2)

Source Code Comments

Internal identification number for person/organization receiving the memo credit.

Columns Comments for AGRGMMO_GIFT_NO (# 3)

Source Code Comments

Gift number from which memo credit is being disbursed.

Columns Comments for AGRGMMO_PLEDGE_NO (# 4)

Source Code Comments

Pledge no associated with the gift from which memo credit is being disbursed.

Columns Comments for AGRGMMO_CAMPAIGN (# 5)

Source Code Comments

Campaign associated with the gift from which memo credit is being disbursed.

Columns Comments for AGRGMMO_DESG (# 6)

Source Code Comments

Designation associated with the gift from which memo credit is being disbursed.

Columns Comments for AGRGMMO_ACTIVITY_DATE (# 7)

Source Code Comments

Date this record was inserted or last updated.

Columns Comments for AGRGMMO_CREDIT (# 8)

Source Code Comments

Percentage of the gift being disbursed to the xref pidm from the pledge for the designation.

Columns Comments for AGRGMMO_3PP_AMT (# 9)

Source Code Comments

The amount of the payment that is going to a third party.

Columns Comments for AGRGMMO_3PP_PLEDGE_NO (# 10)

Source Code Comments

The pledge number to which the third party payment will be applied.

Table AGRPCAM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRPCAM_PIDM	NUMBER(8,0)	No	*	*
AGRPCAM_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPCAM_CAMPAIGN	VARCHAR2(5)	No	*
AGRPCAM_AMT	NUMBER(11,2)	No
AGRPCAM_AMT_PAID	NUMBER(11,2)	No
AGRPCAM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPCAM_PIDM	AGBPLDG_PIDM	AGBPLDG
AGRPCAM_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRPCAM_KEY_INDEX2		AGRPCAM_CAMPAIGN
AGRPCAM_KEY_INDEX2		AGRPCAM_PLEDGE_NO
PK_AGRPCAM	Unique	AGRPCAM_PIDM
PK_AGRPCAM	Unique	AGRPCAM_PLEDGE_NO
PK_AGRPCAM	Unique	AGRPCAM_CAMPAIGN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPDES	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVPCAM	SQL View	S10B80.BANINST1	Use (select)
P_UPDATE_AGRPCAM	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATE_AGRPCAM	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (update)
GET_DONORS_COUNT_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
AGRPCAM	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
AGRPCAM_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRPCAM	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPCAM

Object Dates

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

Source Code Comments

Pledge Campaign Repeating Table

Columns Comments for AGRPCAM_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRPCAM_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPCAM_CAMPAIGN (# 3)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRPCAM_AMT (# 4)

Source Code Comments

This field specifies the amount pledged to the campaign. This amount defaults to the pledge amount.

Columns Comments for AGRPCAM_AMT_PAID (# 5)

Source Code Comments

This field specifies the amount paid toward the pledge.

Columns Comments for AGRPCAM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table AGRPDES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRPDES_PIDM	NUMBER(8,0)	No	*	*
AGRPDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRPDES_DESG	VARCHAR2(10)	No	*	*
AGRPDES_AMT	NUMBER(11,2)	No
AGRPDES_AMT_PAID	NUMBER(11,2)	No
AGRPDES_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPDES_PIDM	AGRPCAM_PIDM	AGRPCAM
AGRPDES_PLEDGE_NO	AGRPCAM_PLEDGE_NO	AGRPCAM
AGRPDES_CAMPAIGN	AGRPCAM_CAMPAIGN	AGRPCAM
AGRPDES_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGRPDES_DESG	ADBDESG_DESG	ADBDESG
AGRPDES_PIDM	AGRPMLT_PIDM	AGRPMLT
AGRPDES_PLEDGE_NO	AGRPMLT_PLEDGE_NO	AGRPMLT
AGRPDES_CAMPAIGN	AGRPMLT_CAMPAIGN	AGRPMLT
AGRPDES_DESG	AGRPMLT_DESG	AGRPMLT
AGRPDES_PIDM	AGRPMMO_PIDM	AGRPMMO
AGRPDES_PLEDGE_NO	AGRPMMO_PLEDGE_NO	AGRPMMO
AGRPDES_CAMPAIGN	AGRPMMO_CAMPAIGN	AGRPMMO
AGRPDES_DESG	AGRPMMO_DESG	AGRPMMO
AGRPDES_PIDM	AGRGDES_PIDM	AGRGDES
AGRPDES_PLEDGE_NO	AGRGDES_PLEDGE_NO	AGRGDES
AGRPDES_CAMPAIGN	AGRGDES_CAMPAIGN	AGRGDES
AGRPDES_DESG	AGRGDES_DESG	AGRGDES

Index

Index Name	Index Type	Column Name
AGRPDES_KEY_INDEX2		AGRPDES_DESG
AGRPDES_KEY_INDEX2		AGRPDES_PLEDGE_NO
PK_AGRPDES	Unique	AGRPDES_PIDM
PK_AGRPDES	Unique	AGRPDES_PLEDGE_NO
PK_AGRPDES	Unique	AGRPDES_CAMPAIGN
PK_AGRPDES	Unique	AGRPDES_DESG

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRDESG	SQL Table	S10B80.ALUMNI	Join
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGVPCRD	SQL View	S10B80.BANINST1	Use (select)
AGVPINS	SQL View	S10B80.BANINST1	Use (select)
AGVPLD2	SQL View	S10B80.BANINST1	Use (select)
AGVPLST	SQL View	S10B80.BANINST1	Use (select)
AGVPMEM	SQL View	S10B80.BANINST1	Use (select)
AGVPMLT	SQL View	S10B80.BANINST1	Use (select)
AGVPSCR	SQL View	S10B80.BANINST1	Use (select)
AGVPSFT	SQL View	S10B80.BANINST1	Use (select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.AGKGIFT	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKLIBS	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKCPRF	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKGIFT	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPPRF	Rely On
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
CAMPDESG_BALANCE	Oracle Package Type	S10B80.BANINST1.BWAKCPMT	Rely On
AGRPDESC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)
CAMPDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
P_PLPAYCAMPDESG	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATEPLEDGESTATUS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATE_AGRPDES	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATE_AGRPDES	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (update)
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
CAMP	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
DESG	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
P_CHECK_IF_PAYABLE	Oracle Package Procedure	S10B80.BANINST1.BWAKLIBS	Use (select)
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
P_GIFT_BY_FISCAL_YR	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
P_PLEDGE_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Rely On
F_CALC_PDES_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Use (select)
F_CALC_PINS_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Use (select)
AGRPDES	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
AGRPDES_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRPDES	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Join
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Join
AGRPCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPMLT	SQL Table	S10B80.ALUMNI	Join
AGRPMMO	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPDES

Object Dates

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

Source Code Comments

Pledge Designation Repeating Table

Columns Comments for AGRPDES_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRPDES_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPDES_CAMPAIGN (# 3)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRPDES_DESG (# 4)

Source Code Comments

This field specifies the designation code associated with the campaign.

Columns Comments for AGRPDES_AMT (# 5)

Source Code Comments

This field specifies the amount of the pledge designation. This field defaults to the campaign amount.

Columns Comments for AGRPDES_AMT_PAID (# 6)

Source Code Comments

This field specifies the amount paid toward the pledge designation.

Columns Comments for AGRPDES_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table AGRPIDS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRPIDS_PIDM	NUMBER(8,0)	No	*	*
AGRPIDS_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPIDS_XREF_PIDM	NUMBER(8,0)	No	*
AGRPIDS_AMT	NUMBER(11,2)	No
AGRPIDS_AMT_PAID	NUMBER(11,2)	No
AGRPIDS_ACTIVITY_DATE	DATE	No
AGRPIDS_3PP_AMT	NUMBER(11,2)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPIDS_PIDM	AGBPLDG_PIDM	AGBPLDG
AGRPIDS_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRPIDS_KEY_INDEX2		AGRPIDS_XREF_PIDM
PK_AGRPIDS	Unique	AGRPIDS_PIDM
PK_AGRPIDS	Unique	AGRPIDS_PLEDGE_NO
PK_AGRPIDS	Unique	AGRPIDS_XREF_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPMLT	SQL Table	S10B80.ALUMNI	Refer (no action)
P_AGRPIDS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_AGRPIDS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,update)
AGRPIDS	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
AGRPIDS_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRPIDS	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPIDS

Object Dates

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

Source Code Comments

Pledge Multiple Id Repeating Table

Columns Comments for AGRPIDS_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRPIDS_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPIDS_XREF_PIDM (# 3)

Source Code Comments

This field specifies the internal system generated identification number of the cross reference.

Columns Comments for AGRPIDS_AMT (# 4)

Source Code Comments

This field specifies the amount of the pledge associated with the cross reference. This amount must be less than or equal to the pledge amount.

Columns Comments for AGRPIDS_AMT_PAID (# 5)

Source Code Comments

This field specifies the amount paid toward the pledge.

Columns Comments for AGRPIDS_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for AGRPIDS_3PP_AMT (# 7)

Source Code Comments

The amount of the payment that is used for Third Party Credit

Table AGRPINS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRPINS_PIDM	NUMBER(8,0)	No	*	*
AGRPINS_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPINS_INSTALLMENT_NO	NUMBER(3,0)	No	*
AGRPINS_INSTALLMENT_DATE	DATE	No
AGRPINS_AMT	NUMBER(11,2)	No
AGRPINS_REM_DATE	DATE	Yes
AGRPINS_PRMD_CODE	VARCHAR2(2)	Yes		*
AGRPINS_REM_COUNT	NUMBER(2,0)	Yes
AGRPINS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPINS_PRMD_CODE	ATVPRMD_CODE	ATVPRMD
AGRPINS_PIDM	AGBPINS_PIDM	AGBPINS
AGRPINS_PLEDGE_NO	AGBPINS_PLEDGE_NO	AGBPINS

Index

Index Name	Index Type	Column Name
AGRPINS_KEY_INDEX2		AGRPINS_INSTALLMENT_DATE
PK_AGRPINS	Unique	AGRPINS_PIDM
PK_AGRPINS	Unique	AGRPINS_PLEDGE_NO
PK_AGRPINS	Unique	AGRPINS_INSTALLMENT_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGVPINS	SQL View	S10B80.BANINST1	Use (select)
AGVPLDG	SQL View	S10B80.BANINST1	Use (select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
AGRPINS_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGRPINS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGRPINS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGRPINS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGRPINSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGRPINSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGRPINSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGRPINSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
P_PLEDGE_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Rely On
P_PLEDGE_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
F_CALC_PDES_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Rely On
F_CALC_PDES_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Use (select)
F_CALC_PINS_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Rely On
F_CALC_PINS_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Use (select)
AGRPINS	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
AGRPINS_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRPINS	SQL Index	S10B80.ALUMNI	Rely On
AGBPINS	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPRMD	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPINS

Object Dates

Creation Date	Analysis Date
04/02/2008 13:41:54:000	04/02/2008 13:49:17:000

Source Code Comments

Pledge Installment Repeating Table

Columns Comments for AGRPINS_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRPINS_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPINS_INSTALLMENT_NO (# 3)

Source Code Comments

This field specifies the number of the pledge installment.

Columns Comments for AGRPINS_INSTALLMENT_DATE (# 4)

Source Code Comments

This field specifies the pledge installment date.

Columns Comments for AGRPINS_AMT (# 5)

Source Code Comments

This field specifies the amount of the pledge installment.

Columns Comments for AGRPINS_REM_DATE (# 6)

Source Code Comments

This field specifies the date of the last installment reminder.

Columns Comments for AGRPINS_PRMD_CODE (# 7)

Source Code Comments

This field specifies the pledge reminder code.

Columns Comments for AGRPINS_REM_COUNT (# 8)

Source Code Comments

This field specifies the number of pledge reminders produced by the system to date.

Columns Comments for AGRPINS_ACTIVITY_DATE (# 9)

Source Code Comments

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

Table AGRPMEM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRPMEM_PIDM	NUMBER(8,0)	No	*	*
AGRPMEM_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPMEM_MEMO_PIDM	NUMBER(8,0)	No	*
AGRPMEM_AMT	NUMBER(11,2)	No
AGRPMEM_AMT_PAID	NUMBER(11,2)	No
AGRPMEM_ACTIVITY_DATE	DATE	No
AGRPMEM_3PP_AMT	NUMBER(11,2)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPMEM_PIDM	AGBPLDG_PIDM	AGBPLDG
AGRPMEM_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRPMEM_KEY_INDEX2		AGRPMEM_MEMO_PIDM
PK_AGRPMEM	Unique	AGRPMEM_PIDM
PK_AGRPMEM	Unique	AGRPMEM_PLEDGE_NO
PK_AGRPMEM	Unique	AGRPMEM_MEMO_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPMMO	SQL Table	S10B80.ALUMNI	Refer (no action)
P_AGRPMEM	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_AGRPMEM	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,update)
AGRPMEM	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
AGRPMEM_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRPMEM	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPMEM

Object Dates

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

Source Code Comments

Pledge Memo Id Repeating Table

Columns Comments for AGRPMEM_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the pledger.

Columns Comments for AGRPMEM_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPMEM_MEMO_PIDM (# 3)

Source Code Comments

This field specifies the internal system generated identification number of the person receiving credit for the memo pledge.

Columns Comments for AGRPMEM_AMT (# 4)

Source Code Comments

This field specifies the amount of the memo pledge.

Columns Comments for AGRPMEM_AMT_PAID (# 5)

Source Code Comments

This field specifies the amount paid toward the memo pledge.

Columns Comments for AGRPMEM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for AGRPMEM_3PP_AMT (# 7)

Source Code Comments

The amount of the payment that is used for Third Party Credit

Table AGRPMLT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRPMLT_PIDM	NUMBER(8,0)	No	*	*
AGRPMLT_XREF_PIDM	NUMBER(8,0)	No	*	*
AGRPMLT_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPMLT_CAMPAIGN	VARCHAR2(5)	No	*
AGRPMLT_DESG	VARCHAR2(10)	No	*
AGRPMLT_ACTIVITY_DATE	DATE	No
AGRPMLT_CREDIT	NUMBER(11,2)	Yes
AGRPMLT_3PP_AMT	NUMBER(11,2)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPMLT_PIDM	AGRPIDS_PIDM	AGRPIDS
AGRPMLT_PLEDGE_NO	AGRPIDS_PLEDGE_NO	AGRPIDS
AGRPMLT_XREF_PIDM	AGRPIDS_XREF_PIDM	AGRPIDS
AGRPMLT_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG
AGRPMLT_PIDM	AGBPLDG_PIDM	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRPMLT_KEY_INDEX2		AGRPMLT_XREF_PIDM
AGRPMLT_KEY_INDEX2		AGRPMLT_PLEDGE_NO
PK_AGRPMLT	Unique	AGRPMLT_PIDM
PK_AGRPMLT	Unique	AGRPMLT_PLEDGE_NO
PK_AGRPMLT	Unique	AGRPMLT_CAMPAIGN
PK_AGRPMLT	Unique	AGRPMLT_DESG
PK_AGRPMLT	Unique	AGRPMLT_XREF_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPDES	SQL Table	S10B80.ALUMNI	Join
AGVPCRD	SQL View	S10B80.BANINST1	Use (select)
AGVPLD2	SQL View	S10B80.BANINST1	Use (select)
AGVPMLT	SQL View	S10B80.BANINST1	Use (select)
F_HIGH_PLEDGE_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_NUMBER_PLEDGE_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_PLEDGE_HARD_CREDIT	SQL Function	S10B80.BANINST1	Use (select)
AGRPMLT_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGRPMLT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGRPMLT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGRPMLT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGRPMLTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGRPMLTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGRPMLTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGRPMLTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
ALLPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
ALLPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,select)
P_GIFT_BY_FISCAL_YR	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
F_GETHARDPLDGCREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_GETHARDPLDGDESGCREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AGRPMLT	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
AGRPMLT_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRPMLT	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGRPIDS	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPMLT

Object Dates

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

Source Code Comments

Detail Pledge Multiple Credit Table

Columns Comments for AGRPMLT_PIDM (# 1)

Source Code Comments

Internal identification number for person/organization associated with the pledge.

Columns Comments for AGRPMLT_XREF_PIDM (# 2)

Source Code Comments

Internal identification number for person/organization receiving the multiple credit.

Columns Comments for AGRPMLT_PLEDGE_NO (# 3)

Source Code Comments

Pledge no associated with the pledge from which multiple credit is being disbursed.

Columns Comments for AGRPMLT_CAMPAIGN (# 4)

Source Code Comments

Campaign associated with the pledge from which multiple credit is being disbursed.

Columns Comments for AGRPMLT_DESG (# 5)

Source Code Comments

Designation associated with the pledge from which multiple credit is being disbursed.

Columns Comments for AGRPMLT_ACTIVITY_DATE (# 6)

Source Code Comments

Date this record was inserted or last updated.

Columns Comments for AGRPMLT_CREDIT (# 7)

Source Code Comments

Percentage of the pledge being disbursed to the xref pidm from the pledge for the designation.

Columns Comments for AGRPMLT_3PP_AMT (# 8)

Source Code Comments

The amount of the payment that is used for Third Party Credit

Table AGRPMMO

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRPMMO_PIDM	NUMBER(8,0)	No	*	*
AGRPMMO_XREF_PIDM	NUMBER(8,0)	No	*	*
AGRPMMO_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRPMMO_CAMPAIGN	VARCHAR2(5)	No	*
AGRPMMO_DESG	VARCHAR2(10)	No	*
AGRPMMO_ACTIVITY_DATE	DATE	No
AGRPMMO_CREDIT	NUMBER(11,2)	Yes
AGRPMMO_3PP_AMT	NUMBER(11,2)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPMMO_PIDM	AGRPMEM_PIDM	AGRPMEM
AGRPMMO_PLEDGE_NO	AGRPMEM_PLEDGE_NO	AGRPMEM
AGRPMMO_XREF_PIDM	AGRPMEM_MEMO_PIDM	AGRPMEM
AGRPMMO_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG
AGRPMMO_PIDM	AGBPLDG_PIDM	AGBPLDG

Index

Index Name	Index Type	Column Name
AGRPMMO_KEY_INDEX2		AGRPMMO_XREF_PIDM
AGRPMMO_KEY_INDEX2		AGRPMMO_PLEDGE_NO
PK_AGRPMMO	Unique	AGRPMMO_PIDM
PK_AGRPMMO	Unique	AGRPMMO_PLEDGE_NO
PK_AGRPMMO	Unique	AGRPMMO_CAMPAIGN
PK_AGRPMMO	Unique	AGRPMMO_DESG
PK_AGRPMMO	Unique	AGRPMMO_XREF_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPDES	SQL Table	S10B80.ALUMNI	Join
AGVPMEM	SQL View	S10B80.BANINST1	Use (select)
AGVPSCR	SQL View	S10B80.BANINST1	Use (select)
AGVPSFT	SQL View	S10B80.BANINST1	Use (select)
AGRPMMO_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGRPMMO_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGRPMMO_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGRPMMO_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGRPMMOVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGRPMMOVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGRPMMOVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGRPMMOVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
ALLPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
ALLPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,select)
F_GETSOFTPLDGCREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_GETSOFTPLDGDESGCREDIT	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AGRPMMO	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
AGRPMMO_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRPMMO	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGRPMEM	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPMMO

Object Dates

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

Source Code Comments

Detail Pledge Memo Credit Table

Columns Comments for AGRPMMO_PIDM (# 1)

Source Code Comments

Internal identification number for person/organization associated with the pledge.

Columns Comments for AGRPMMO_XREF_PIDM (# 2)

Source Code Comments

Internal identification number for person/organization receiving the memo credit.

Columns Comments for AGRPMMO_PLEDGE_NO (# 3)

Source Code Comments

Pledge no associated with the pledge from which memo credit is being disbursed.

Columns Comments for AGRPMMO_CAMPAIGN (# 4)

Source Code Comments

Campaign associated with the pledge from which memo credit is being disbursed.

Columns Comments for AGRPMMO_DESG (# 5)

Source Code Comments

Designation associated with the pledge from which memo credit is being disbursed.

Columns Comments for AGRPMMO_ACTIVITY_DATE (# 6)

Source Code Comments

Date this record was inserted or last updated.

Columns Comments for AGRPMMO_CREDIT (# 7)

Source Code Comments

Percentage of the pledge being disbursed to the xref pidm from the pledge for the designation.

Columns Comments for AGRPMMO_3PP_AMT (# 8)

Source Code Comments

The amount of the payment that is used for Third Party Credit

Table AGRPSOL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AGRPSOL_PIDM	NUMBER(8,0)	No	*
AGRPSOL_PLEDGE_NO	VARCHAR2(7)	No	*
AGRPSOL_CAMPAIGN	VARCHAR2(5)	No	*
AGRPSOL_SOLC_CODE	VARCHAR2(8)	Yes	*
AGRPSOL_SOL_ORG	VARCHAR2(5)	Yes	*
AGRPSOL_SOL_PIDM	NUMBER(8,0)	Yes
AGRPSOL_AMT	NUMBER(11,2)	No
AGRPSOL_AMT_PAID	NUMBER(11,2)	No
AGRPSOL_ACTIVITY_DATE	DATE	No
AGRPSOL_CREDIT_PIDM	NUMBER(8,0)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRPSOL_PIDM	AGRPCAM_PIDM	AGRPCAM
AGRPSOL_PLEDGE_NO	AGRPCAM_PLEDGE_NO	AGRPCAM
AGRPSOL_CAMPAIGN	AGRPCAM_CAMPAIGN	AGRPCAM
AGRPSOL_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AGRPSOL_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AGRPSOL_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG
AGRPSOL_PIDM	AGBPLDG_PIDM	AGBPLDG
AGRPSOL_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP

Index

Index Name	Index Type	Column Name
AGRPSOL_KEY_INDEX	Unique	AGRPSOL_PIDM
AGRPSOL_KEY_INDEX	Unique	AGRPSOL_PLEDGE_NO
AGRPSOL_KEY_INDEX	Unique	AGRPSOL_CAMPAIGN
AGRPSOL_KEY_INDEX	Unique	AGRPSOL_SOLC_CODE
AGRPSOL_KEY_INDEX	Unique	AGRPSOL_SOL_ORG
AGRPSOL_KEY_INDEX	Unique	AGRPSOL_SOL_PIDM
AGRPSOL_KEY_INDEX	Unique	AGRPSOL_CREDIT_PIDM
AGRPSOL_KEY_INDEX2		AGRPSOL_CAMPAIGN
AGRPSOL_KEY_INDEX2		AGRPSOL_SOLC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AXRMSOL	SQL Table	S10B80.ALUMNI	Join
AGVPLD1	SQL View	S10B80.BANINST1	Use (select)
AGVPSOL	SQL View	S10B80.BANINST1	Use (select)
F_PLEDGE_SOLICITOR	SQL Function	S10B80.BANINST1	Use (select)
F_PLEDGE_SOLICITOR_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_PLEDGE_SOLICITOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
AGRPSOL	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
AGRPSOL_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGRPSOL_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGRPCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSOLC	SQL Table	S10B80.ALUMNI	Refer (no action)
A$_AGRPSOL_EXPMG_UPD_TRG	SQL Trigger	S10B80.ALUMNI	Fire (Insert,update,delete,after,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPSOL

Object Dates

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

Source Code Comments

Pledge Solicitor Repeating Table

Columns Comments for AGRPSOL_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRPSOL_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned pledge number.

Columns Comments for AGRPSOL_CAMPAIGN (# 3)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRPSOL_SOLC_CODE (# 4)

Source Code Comments

This field specifies the solicitation code.

Columns Comments for AGRPSOL_SOL_ORG (# 5)

Source Code Comments

This field specifies the solicitor organization code.

Columns Comments for AGRPSOL_SOL_PIDM (# 6)

Source Code Comments

This field specifies the internal system generated identification number of the solicitor.

Columns Comments for AGRPSOL_AMT (# 7)

Source Code Comments

This field specifies the amount of the pledge.

Columns Comments for AGRPSOL_AMT_PAID (# 8)

Source Code Comments

This field specifies the amount paid toward the pledge.

Columns Comments for AGRPSOL_ACTIVITY_DATE (# 9)

Source Code Comments

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

Columns Comments for AGRPSOL_CREDIT_PIDM (# 10)

Source Code Comments

The Internal ID of the Solicitor who is receiving credit for the pledge.

Table ATVFISC

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVFISC_CODE	NUMBER(4,0)	No	*
ATVFISC_DESC	VARCHAR2(30)	No
ATVFISC_START_DATE	DATE	No
ATVFISC_END_DATE	DATE	No
ATVFISC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVFISC	Unique	ATVFISC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AABDUES	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAJBD	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAJIN	SQL Table	S10B80.ALUMNI	Refer (no action)
ADRADAJ	SQL Table	S10B80.ALUMNI	Refer (no action)
ADRSUMM	SQL Table	S10B80.ALUMNI	Refer (no action)
AFREXPN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBGHLD	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGDS	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGIF	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
APBGHIS	SQL Table	S10B80.ALUMNI	Refer (no action)
APRCHIS	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCTM	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDHIS	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVPINS	SQL View	S10B80.BANINST1	Use (select)
F_FISC_CODE	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
F_HIGH_GIFT_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_HIGH_PLEDGE_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_NUMBER_GIFT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_NUMBER_PLEDGE_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_ANT_MAT_GIFT_ONE_PAY	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_ANT_MAT_GIFT_PAY	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_GIVING_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_NON_MAT_GIFT_MEMO	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_PLEDGED_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_PLEDGE_PAYMENT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_RLZ_MAT_GIFT_ONE_PAY	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_RLZ_MAT_GIFT_PAY	SQL Function	S10B80.BANINST1	Use (select)
ATVFISC_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
ATVFISC_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
ATVFISC_REC	Oracle Package Variable	S10B80.BANINST1.BWAKNHIS	Rely On
ATVFISC_REC	Oracle Package Variable	S10B80.BANINST1.BWAKPLDG	Rely On
ATVFISCVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
ATVFISCVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
ATVFISCVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNHIS	Use (select)Rely On
GETCURRFISCCODEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
GETCURRFISCCODEC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
FISC_CODE	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
FISC_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
FISC_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
ATVFISCC	Oracle Package Cursor	S10B80.BANINST1.ATKFISC	Use (select)Rely On
P_CALC_CURR_DATE	Oracle Package Procedure	S10B80.BANINST1.AGKPINS	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVFISC	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_ATVFISC	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVFISC

Object Dates

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

Source Code Comments

Fiscal Year Validation Table

Columns Comments for ATVFISC_CODE (# 1)

Source Code Comments

This field specifies the code for the fiscal year.

Columns Comments for ATVFISC_DESC (# 2)

Source Code Comments

This field specifies the description of the fiscal year code.

Columns Comments for ATVFISC_START_DATE (# 3)

Source Code Comments

This field specifies the start date for the fiscal year.

Columns Comments for ATVFISC_END_DATE (# 4)

Source Code Comments

This field specifies the end date for the fiscal year.

Columns Comments for ATVFISC_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table ATVPACK

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVPACK_CODE	VARCHAR2(2)	No	*
ATVPACK_DESC	VARCHAR2(30)	No
ATVPACK_LOW_LEVEL	NUMBER(11,2)	No
ATVPACK_HIGH_LEVEL	NUMBER(11,2)	No
ATVPACK_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVPACK	Unique	ATVPACK_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAPLG	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_ATVPACK	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVPACK

Object Dates

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

Source Code Comments

Pledge Range Validation Table

Columns Comments for ATVPACK_CODE (# 1)

Source Code Comments

Code for the type of pledge range.

Columns Comments for ATVPACK_DESC (# 2)

Source Code Comments

Description of the pledge range.

Columns Comments for ATVPACK_LOW_LEVEL (# 3)

Source Code Comments

Bottom dollar range associated with the pledge range.

Columns Comments for ATVPACK_HIGH_LEVEL (# 4)

Source Code Comments

Top dollar range associated with the pledge range.

Columns Comments for ATVPACK_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table ATVPCAT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVPCAT_CODE	VARCHAR2(5)	No	*
ATVPCAT_DESC	VARCHAR2(30)	No
ATVPCAT_COND_IND	VARCHAR2(1)	No
ATVPCAT_ACTIVITY_DATE	DATE	No
ATVPCAT_USER	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVPCAT	Unique	ATVPCAT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBPDEF	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AUBINST	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPCATC	Oracle Package Cursor	S10B80.BANINST1.ATKPCAT	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVPCAT	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_ATVPCAT	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVPCAT

Object Dates

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

Source Code Comments

Pledge Category Code Validation Table

Columns Comments for ATVPCAT_CODE (# 1)

Source Code Comments

Pledge Category Code.

Columns Comments for ATVPCAT_DESC (# 2)

Source Code Comments

Pledge Category Code Description.

Columns Comments for ATVPCAT_COND_IND (# 3)

Source Code Comments

Pledge Category Code Conditional Indicator.

Columns Comments for ATVPCAT_ACTIVITY_DATE (# 4)

Source Code Comments

Date the Pledge Category Code was inserted or last modified.

Columns Comments for ATVPCAT_USER (# 5)

Source Code Comments

User ID of the person who created/updated the record.

Table ATVPCLS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVPCLS_CODE	VARCHAR2(4)	No	*
ATVPCLS_DESC	VARCHAR2(30)	No
ATVPCLS_ACTIVITY_DATE	DATE	No
ATVPCLS_ANONYMOUS_IND	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVPCLS	Unique	ATVPCLS_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVPCLSC	Oracle Package Cursor	S10B80.BANINST1.ATKPCLS	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVPCLS	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_ATVPCLS	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVPCLS

Object Dates

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

Source Code Comments

Pledge Classification Validation Table

Columns Comments for ATVPCLS_CODE (# 1)

Source Code Comments

Code for the class of the pledge.

Columns Comments for ATVPCLS_DESC (# 2)

Source Code Comments

Description of the pledge class code.

Columns Comments for ATVPCLS_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for ATVPCLS_ANONYMOUS_IND (# 4)

Source Code Comments

Specifies if the pledge is to be anonymous.

Table ATVPGVE

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVPGVE_CODE	VARCHAR2(5)	No	*
ATVPGVE_DESC	VARCHAR2(30)	No
ATVPGVE_3PP_IND	VARCHAR2(1)	No
ATVPGVE_ACTIVITY_DATE	DATE	No
ATVPGVE_USER	VARCHAR2(30)	No
ATVPGVE_VSE	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVPGVE	Unique	ATVPGVE_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGHLD	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBPDEF	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGIF	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AUBINST	SQL Table	S10B80.ALUMNI	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVPGVE_REC	Oracle Package Variable	S10B80.BANINST1.BWAKPLDG	Rely On
ATVPGVEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)Rely On
GETALLPGVEC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
PGVE_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
PGVE_CODE	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
PGVE_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKPLDG	Rely On
ATVPGVE	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_ATVPGVE	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVPGVE

Object Dates

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

Source Code Comments

Pledge Gift Vehicle Code Validation Table.

Columns Comments for ATVPGVE_CODE (# 1)

Source Code Comments

Pledge Gift Vehicle Code.

Columns Comments for ATVPGVE_DESC (# 2)

Source Code Comments

Description of the Pledge Gift Vehicle Code.

Columns Comments for ATVPGVE_3PP_IND (# 3)

Source Code Comments

Third Party Payment indicator, Y indicates that this code is for Third Party Payments.

Columns Comments for ATVPGVE_ACTIVITY_DATE (# 4)

Source Code Comments

The date that this record was created or last modified.

Columns Comments for ATVPGVE_USER (# 5)

Source Code Comments

The User ID of the person who created or last modified this record.

Table ATVPLDG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVPLDG_CODE	VARCHAR2(2)	No	*
ATVPLDG_DESC	VARCHAR2(30)	No
ATVPLDG_ACTIVITY_DATE	DATE	No
ATVPLDG_PAYROLL_DED_IND	VARCHAR2(1)	Yes
ATVPLDG_PAY_DED_CODE	VARCHAR2(3)	Yes
ATVPLDG_CFAE_PLDG_CATG	VARCHAR2(1)	Yes
ATVPLDG_RUCL_CODE	VARCHAR2(4)	Yes
ATVPLDG_DB_GL_ACCT	VARCHAR2(60)	Yes
ATVPLDG_DISP_WEB_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVPLDG	Unique	ATVPLDG_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AUBINST	SQL Table	S10B80.ALUMNI	Refer (no action)
AXRDCPT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVPLD1	SQL View	S10B80.BANINST1	Use (select)
AGVPLD2	SQL View	S10B80.BANINST1	Join
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
ATVPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
ATVPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKPLDG	Rely On
ATVPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
ATVPLDG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)
ATVPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
ATVPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
ATVPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)Rely On
ATVPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
ATVPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
PLDG_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKPLDG	Rely On
ATVPLDGC	Oracle Package Cursor	S10B80.BANINST1.ATKPLDG	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVPLDG	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_ATVPLDG	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVPLDG

Object Dates

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

Source Code Comments

Pledge Type Validation Table

Columns Comments for ATVPLDG_CODE (# 1)

Source Code Comments

Code for the type of pledge.

Columns Comments for ATVPLDG_DESC (# 2)

Source Code Comments

Description of the pledge type code.

Columns Comments for ATVPLDG_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for ATVPLDG_PAYROLL_DED_IND (# 4)

Source Code Comments

Specifies if a pledge type is associated with a payroll deduction.

Columns Comments for ATVPLDG_PAY_DED_CODE (# 5)

Source Code Comments

Payroll deduction code.

Columns Comments for ATVPLDG_CFAE_PLDG_CATG (# 6)

Source Code Comments

Specifies the Council for Financial Aid to Education category associated with the pledge type which is used for reporting purposes.

Columns Comments for ATVPLDG_RUCL_CODE (# 7)

Source Code Comments

Rule class code used for the finance interface to the BANNER finance system.

Columns Comments for ATVPLDG_DB_GL_ACCT (# 8)

Source Code Comments

Debit account number for non-Banner Finance users.

Columns Comments for ATVPLDG_DISP_WEB_IND (# 9)

Source Code Comments

Display on the Web Indicator, Y indicates that this code can be displayed on the Web.

Table ATVPRMD

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVPRMD_CODE	VARCHAR2(2)	No	*
ATVPRMD_DESC	VARCHAR2(30)	No
ATVPRMD_LETTER_TYPE	VARCHAR2(2)	Yes
ATVPRMD_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVPRMD	Unique	ATVPRMD_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPINS	SQL Table	S10B80.ALUMNI	Refer (no action)
GETALLPRMDC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
P_INSERT_THE_PLEDGE	Oracle Package Procedure	S10B80.BANINST1.BWAKPLDG	Rely On
ATVPRMDC	Oracle Package Cursor	S10B80.BANINST1.ATKPRMD	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVPRMD	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_ATVPRMD	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVPRMD

Object Dates

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

Source Code Comments

Pledge Reminder Type Validation Table

Columns Comments for ATVPRMD_CODE (# 1)

Source Code Comments

This field specifies the code for the type of pledge reminder.

Columns Comments for ATVPRMD_DESC (# 2)

Source Code Comments

This field specifies the description of the pledge reminder code.

Columns Comments for ATVPRMD_LETTER_TYPE (# 3)

Source Code Comments

This field specifies the letter type associated with the pledge reminder type code.

Columns Comments for ATVPRMD_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table ATVPSTA

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVPSTA_CODE	VARCHAR2(1)	No	*
ATVPSTA_DESC	VARCHAR2(30)	No
ATVPSTA_ACTIVE_IND	VARCHAR2(1)	Yes
ATVPSTA_CHG_ACTIVE	VARCHAR2(1)	Yes
ATVPSTA_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVPSTA	Unique	ATVPSTA_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVPLDG	SQL View	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVPSTA_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
ATVPSTA_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
ATVPSTA_REC	Oracle Package Variable	S10B80.BANINST1.BWAKPLDG	Rely On
ATVPSTA_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
ATVPSTA_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGBPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)
ATVPSTAVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
ATVPSTAVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
ATVPSTAVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)Rely On
ATVPSTAVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
ATVPSTAVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
GETALLPSTAC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
P_UPDATEPLEDGESTATUS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
PSTA_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKPLDG	Rely On
ATVPSTAC	Oracle Package Cursor	S10B80.BANINST1.ATKPSTA	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVPSTA	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_ATVPSTA	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVPSTA

Object Dates

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

Source Code Comments

Pledge Status Validation Table

Columns Comments for ATVPSTA_CODE (# 1)

Source Code Comments

This field specifies the code indicating the status of a pledge.

Columns Comments for ATVPSTA_DESC (# 2)

Source Code Comments

This field specifies the description of the pledge status code.

Columns Comments for ATVPSTA_ACTIVE_IND (# 3)

Source Code Comments

This field specifies whether a pledge is active or inactive (Values = Y or N).

Columns Comments for ATVPSTA_CHG_ACTIVE (# 4)

Source Code Comments

This field specifies the code to use when changing the active status.

Columns Comments for ATVPSTA_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table AXBMGID

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AXBMGID_PIDM	NUMBER(8,0)	No	*	*
AXBMGID_EMPR_PIDM	NUMBER(8,0)	No	*	*
AXBMGID_PLEDGE_NO	VARCHAR2(7)	No	*	*
AXBMGID_TOTAL_EXPECTED_AMT	NUMBER(11,2)	No
AXBMGID_ACTIVITY_DATE	DATE	No
AXBMGID_MATCH_FORM_IND	VARCHAR2(1)	Yes
AXBMGID_COMMENT	VARCHAR2(1000)	Yes
AXBMGID_FORM_RECEIVED_IND	VARCHAR2(1)	Yes
AXBMGID_MGFORM_READYTOSEND	VARCHAR2(1)	Yes
AXBMGID_VOID_IND	VARCHAR2(1)	Yes
AXBMGID_TEMP_IND	VARCHAR2(1)	Yes
AXBMGID_SPOUSE_PIDM	NUMBER(8,0)	Yes
AXBMGID_QUALIFY_AMT	NUMBER(11,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AXBMGID_PIDM	AGBPLDG_PIDM	AGBPLDG
AXBMGID_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG
AXBMGID_PLEDGE_NO	AXRMDES_PLEDGE_NO	AXRMDES
AXBMGID_EMPR_PIDM	AXRMDES_EMPR_PIDM	AXRMDES
AXBMGID_PIDM	AGRMGIF_PIDM	AGRMGIF

Index

Index Name	Index Type	Column Name
AXBMGID_PIDM_INDEX		AXBMGID_PIDM
AXBMGID_PIDM_INDEX		AXBMGID_PLEDGE_NO
PK_AXBMGID	Unique	AXBMGID_EMPR_PIDM
PK_AXBMGID	Unique	AXBMGID_PLEDGE_NO
PK_AXBMGID	Unique	AXBMGID_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRGCAM	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Join
AXRMCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
A$_AGBPLDG_EXPMG_DEL_TRG	SQL Trigger	S10B80.ALUMNI	Use (delete,select)
A$_AGRPSOL_EXPMG_UPD_TRG	SQL Trigger	S10B80.ALUMNI	Use (select)Rely On
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (Insert,select)
F_XMG_CAMP_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_CAMP_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_DESG_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_DESG_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AXBMGID	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
AXBMGID_PIDM_INDEX	SQL Index	S10B80.ALUMNI	Rely On
PK_AXBMGID	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGRMGIF	SQL Table	S10B80.ALUMNI	Join
AXRMDES	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AXBMGID

Object Dates

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

Source Code Comments

Expected Matching Gift Waiting ID base table.

Columns Comments for AXBMGID_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number for the employee.

Columns Comments for AXBMGID_EMPR_PIDM (# 2)

Source Code Comments

This field specifies the internal system generated identification number of the employer.

Columns Comments for AXBMGID_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the pledge number of the pledge to be matched.

Columns Comments for AXBMGID_TOTAL_EXPECTED_AMT (# 4)

Source Code Comments

This field specifies the amount of the pledge to be matched.

Columns Comments for AXBMGID_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for AXBMGID_MATCH_FORM_IND (# 6)

Source Code Comments

This field specifies how the Matching Gift Form affects the Pledge (P/F/I).

Columns Comments for AXBMGID_COMMENT (# 7)

Source Code Comments

This is a free format comment about a condition that must be met prior to sending the matching Gift Form to the Employer.

Columns Comments for AXBMGID_FORM_RECEIVED_IND (# 8)

Source Code Comments

This field specifies whether the Matching Gift form has been received (Y/N).

Columns Comments for AXBMGID_MGFORM_READYTOSEND (# 9)

Source Code Comments

This field specifies whether the Matching Gift form is ready to send (Y/N).

Columns Comments for AXBMGID_VOID_IND (# 10)

Source Code Comments

This field specifies whether the expected match has been Voided (V).

Columns Comments for AXBMGID_TEMP_IND (# 11)

Source Code Comments

This field is not currently used.

Columns Comments for AXBMGID_SPOUSE_PIDM (# 12)

Source Code Comments

This field specifies the internal system generated identification number of the Spouse of the employee.

Columns Comments for AXBMGID_QUALIFY_AMT (# 13)

Source Code Comments

This field specifies the Amount of the Pledge that Qualifies for a match from an Employer

Table AXRMCAM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AXRMCAM_PIDM	NUMBER(8,0)	No	*	*
AXRMCAM_EMPR_PIDM	NUMBER(8,0)	No	*	*
AXRMCAM_PLEDGE_NO	VARCHAR2(7)	No	*	*
AXRMCAM_CAMPAIGN	VARCHAR2(5)	No	*
AXRMCAM_AMT	NUMBER(11,2)	No
AXRMCAM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AXRMCAM_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG
AXRMCAM_PIDM	AGBPLDG_PIDM	AGBPLDG
AXRMCAM_EMPR_PIDM	AXBMGID_EMPR_PIDM	AXBMGID
AXRMCAM_PLEDGE_NO	AXBMGID_PLEDGE_NO	AXBMGID
AXRMCAM_PIDM	AXBMGID_PIDM	AXBMGID

Index

Index Name	Index Type	Column Name
AXRMCAM_PIDM_INDEX		AXRMCAM_PIDM
AXRMCAM_PIDM_INDEX		AXRMCAM_PLEDGE_NO
PK_AXRMCAM	Unique	AXRMCAM_EMPR_PIDM
PK_AXRMCAM	Unique	AXRMCAM_PIDM
PK_AXRMCAM	Unique	AXRMCAM_PLEDGE_NO
PK_AXRMCAM	Unique	AXRMCAM_CAMPAIGN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AXRMDES	SQL Table	S10B80.ALUMNI	Refer (no action)
AXRMSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
A$_AGBPLDG_EXPMG_DEL_TRG	SQL Trigger	S10B80.ALUMNI	Use (delete,select)
A$_AGRPSOL_EXPMG_UPD_TRG	SQL Trigger	S10B80.ALUMNI	Use (select)Rely On
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (Insert)
F_XMG_CAMP_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_CAMP_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AXRMCAM	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
AXRMCAM_PIDM_INDEX	SQL Index	S10B80.ALUMNI	Rely On
PK_AXRMCAM	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AXBMGID	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AXRMCAM

Object Dates

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

Source Code Comments

Expected Matching Gift Campaign repeating table.

Columns Comments for AXRMCAM_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the employee.

Columns Comments for AXRMCAM_EMPR_PIDM (# 2)

Source Code Comments

This field specifies the internal system generated identification number of the employer.

Columns Comments for AXRMCAM_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AXRMCAM_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AXRMCAM_AMT (# 5)

Source Code Comments

This field specifies the amount of the pledge to be matched.

Columns Comments for AXRMCAM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table AXRMDES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AXRMDES_PIDM	NUMBER(8,0)	No	*	*
AXRMDES_EMPR_PIDM	NUMBER(8,0)	No	*	*
AXRMDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AXRMDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AXRMDES_DESG	VARCHAR2(10)	No	*	*
AXRMDES_AMT	NUMBER(11,2)	No
AXRMDES_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AXRMDES_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG
AXRMDES_PIDM	AGBPLDG_PIDM	AGBPLDG
AXRMDES_EMPR_PIDM	AXRMCAM_EMPR_PIDM	AXRMCAM
AXRMDES_PIDM	AXRMCAM_PIDM	AXRMCAM
AXRMDES_PLEDGE_NO	AXRMCAM_PLEDGE_NO	AXRMCAM
AXRMDES_CAMPAIGN	AXRMCAM_CAMPAIGN	AXRMCAM
AXRMDES_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AXRMDES_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
AXRMDES_PIDM_INDEX		AXRMDES_PIDM
AXRMDES_PIDM_INDEX		AXRMDES_PLEDGE_NO
PK_AXRMDES	Unique	AXRMDES_EMPR_PIDM
PK_AXRMDES	Unique	AXRMDES_PIDM
PK_AXRMDES	Unique	AXRMDES_PLEDGE_NO
PK_AXRMDES	Unique	AXRMDES_CAMPAIGN
PK_AXRMDES	Unique	AXRMDES_DESG

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AXBMGID	SQL Table	S10B80.ALUMNI	Join
A$_AGBPLDG_EXPMG_DEL_TRG	SQL Trigger	S10B80.ALUMNI	Use (delete,select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (Insert)
F_XMG_DESG_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_DESG_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AXRMDES	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
AXRMDES_PIDM_INDEX	SQL Index	S10B80.ALUMNI	Rely On
PK_AXRMDES	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Join
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AXRMCAM	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AXRMDES

Object Dates

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

Source Code Comments

Expected Matching Gift Designation repeating table.

Columns Comments for AXRMDES_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the employee.

Columns Comments for AXRMDES_EMPR_PIDM (# 2)

Source Code Comments

This field specifies the internal system generated identification number of the employer.

Columns Comments for AXRMDES_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AXRMDES_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AXRMDES_DESG (# 5)

Source Code Comments

This field specifies the ten character alphanumeric designation code.

Columns Comments for AXRMDES_AMT (# 6)

Source Code Comments

This field specifies the amount of the designation.

Columns Comments for AXRMDES_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table AXRMGRN

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AXRMGRN_PIDM	NUMBER(8,0)	No	*	*
AXRMGRN_EMPR_PIDM	NUMBER(8,0)	No	*
AXRMGRN_GP_IND	VARCHAR2(1)	No	*
AXRMGRN_GP_NO	VARCHAR2(7)	No	*	*
AXRMGRN_REASON_TEXT	VARCHAR2(60)	No
AXRMGRN_REASON_IND	VARCHAR2(1)	No
AXRMGRN_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AXRMGRN_PIDM	AGBPLDG_PIDM	AGBPLDG
AXRMGRN_GP_NO	AGBPLDG_PLEDGE_NO	AGBPLDG

Index

Index Name	Index Type	Column Name
PK_AXRMGRN	Unique	AXRMGRN_PIDM
PK_AXRMGRN	Unique	AXRMGRN_EMPR_PIDM
PK_AXRMGRN	Unique	AXRMGRN_GP_IND
PK_AXRMGRN	Unique	AXRMGRN_GP_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
A$_AGBPLDG_EXPMG_DEL_TRG	SQL Trigger	S10B80.ALUMNI	Use (delete,select)
P_AXRMGRN_UPDATE	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (Insert,delete,select)
AXRMGRN	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_AXRMGRN	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AXRMGRN

Object Dates

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

Source Code Comments

Matching Gift Reason table.

Columns Comments for AXRMGRN_PIDM (# 1)

Source Code Comments

This field is the internal system generated identification number of the employee.

Columns Comments for AXRMGRN_EMPR_PIDM (# 2)

Source Code Comments

This field is the internal system generated identification number for the employer.

Columns Comments for AXRMGRN_GP_IND (# 3)

Source Code Comments

This field specifies either (G) for gift or (P) for Pledge.

Columns Comments for AXRMGRN_GP_NO (# 4)

Source Code Comments

This field contains either the Gift or Pledge number.

Columns Comments for AXRMGRN_REASON_TEXT (# 5)

Source Code Comments

This field contains the reason why the gift or pledge was not matched.

Columns Comments for AXRMGRN_REASON_IND (# 6)

Source Code Comments

This field contains either a (S) for system generated reason or (U) for a user generated reason.

Columns Comments for AXRMGRN_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table AXRMSOL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AXRMSOL_PIDM	NUMBER(8,0)	No	*
AXRMSOL_EMPR_PIDM	NUMBER(8,0)	No	*
AXRMSOL_PLEDGE_NO	VARCHAR2(7)	No	*
AXRMSOL_CAMPAIGN	VARCHAR2(5)	No	*
AXRMSOL_AMT	NUMBER(11,2)	No
AXRMSOL_ACTIVITY_DATE	DATE	No
AXRMSOL_SOLC_CODE	VARCHAR2(8)	Yes
AXRMSOL_SOL_ORG	VARCHAR2(5)	Yes	*
AXRMSOL_SOL_PIDM	NUMBER(8,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AXRMSOL_PIDM	AGRPSOL_PIDM	AGRPSOL
AXRMSOL_PLEDGE_NO	AGRPSOL_PLEDGE_NO	AGRPSOL
AXRMSOL_CAMPAIGN	AGRPSOL_CAMPAIGN	AGRPSOL
AXRMSOL_PIDM	AGBPLDG_PIDM	AGBPLDG
AXRMSOL_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG
AXRMSOL_EMPR_PIDM	AXRMCAM_EMPR_PIDM	AXRMCAM
AXRMSOL_PIDM	AXRMCAM_PIDM	AXRMCAM
AXRMSOL_PLEDGE_NO	AXRMCAM_PLEDGE_NO	AXRMCAM
AXRMSOL_CAMPAIGN	AXRMCAM_CAMPAIGN	AXRMCAM
AXRMSOL_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
AXRMSOL_KEY_INDEX	Unique	AXRMSOL_EMPR_PIDM
AXRMSOL_KEY_INDEX	Unique	AXRMSOL_PIDM
AXRMSOL_KEY_INDEX	Unique	AXRMSOL_PLEDGE_NO
AXRMSOL_KEY_INDEX	Unique	AXRMSOL_CAMPAIGN
AXRMSOL_KEY_INDEX	Unique	AXRMSOL_SOLC_CODE
AXRMSOL_KEY_INDEX	Unique	AXRMSOL_SOL_ORG
AXRMSOL_KEY_INDEX	Unique	AXRMSOL_SOL_PIDM
AXRMSOL_PIDM_INDEX		AXRMSOL_PIDM
AXRMSOL_PIDM_INDEX		AXRMSOL_PLEDGE_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
A$_AGBPLDG_EXPMG_DEL_TRG	SQL Trigger	S10B80.ALUMNI	Use (delete,select)
A$_AGRPSOL_EXPMG_UPD_TRG	SQL Trigger	S10B80.ALUMNI	Use (Insert,update,delete,select)Rely On
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (Insert)
AXRMSOL	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
AXRMSOL_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AXRMSOL_PIDM_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGRPSOL	SQL Table	S10B80.ALUMNI	Join
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
AXRMCAM	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AXRMSOL

Object Dates

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

Source Code Comments

Expected Matching Gift Solicitation repeating table.

Columns Comments for AXRMSOL_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number of the employee.

Columns Comments for AXRMSOL_EMPR_PIDM (# 2)

Source Code Comments

This field specifies the internal system generated identification number of the employer.

Columns Comments for AXRMSOL_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AXRMSOL_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AXRMSOL_AMT (# 5)

Source Code Comments

This field specifies the amount of the pledge.

Columns Comments for AXRMSOL_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for AXRMSOL_SOLC_CODE (# 7)

Source Code Comments

This field specifies the solicitor code.

Columns Comments for AXRMSOL_SOL_ORG (# 8)

Source Code Comments

This field specifies the solicitor organization code.

Columns Comments for AXRMSOL_SOL_PIDM (# 9)

Source Code Comments

This field specifies the internal system generated identification number of the solicitor.

Link between AGRGIDS and AGBPLDG

Join Information

Objects list
schema-view : S10B80.BANINST1.AGV3PAY

Link List

Link Type	Link	Project
Join	Link Between AGRGIDS and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGIDS	AGBPLDG

Link between AGRGMEM and AGBPLDG

Join Information

Objects list
schema-view : S10B80.BANINST1.AGV3PAY

Link List

Link Type	Link	Project
Join	Link Between AGRGMEM and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGMEM	AGBPLDG

Link between AGBPLDG and AGRPINS

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVPINS schema-view : S10B80.BANINST1.AGVPLDG schema-view : S10B80.BANINST1.AXVPINS scope-function : S10B80.BANINST1.AGKCPAP.F_CALC_PINS_AMT scope-function : S10B80.BANINST1.AGKCPAP.F_CALC_PDES_AMT

Link List

Link Type	Link	Project
Join	Link Between AGBPLDG and AGRPINS	ALUMNI

List of Real links

Link type	Between	And
Join	AGBPLDG	AGRPINS

Link between AGBPLDG and AGRPDES

Join Information

Objects list

schema-view : S10B80.BANINST1.AGVPINS
schema-view : S10B80.BANINST1.AGVPLD2
schema-view : S10B80.BANINST1.AGVPCRD
schema-view : S10B80.BANINST1.AGVPSCR
schema-view : S10B80.BANINST1.AGVPSFT
schema-view : S10B80.BANINST1.AGVPLST
schema-view : S10B80.BANINST1.AXVPINS
scope-function : S10B80.BANINST1.AGKCPAP.F_CALC_PINS_AMT
scope-function : S10B80.BANINST1.AGKCPAP.F_CALC_PDES_AMT
scope-procedure : S10B80.BANINST1.AGKGRPT.P_GIFT_BY_FISCAL_YR

Link List

Link Type	Link	Project
Join	Link Between AGBPLDG and AGRPDES	ALUMNI

List of Real links

Link type	Between	And
Join	AGBPLDG	AGRPDES

Link between AGRAPDS and AGRAPLG

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVAPDS

Link List

Link Type	Link	Project
Join	Link Between AGRAPDS and AGRAPLG	ALUMNI

List of Real links

Link type	Between	And
Join	AGRAPDS	AGRAPLG

Link between AGRGMMO and AGBPLDG

Join Information

Objects list
schema-view : S10B80.BANINST1.AGV3DTL

Link List

Link Type	Link	Project
Join	Link Between AGRGMMO and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGMMO	AGBPLDG

Link between AGRGMLT and AGBPLDG

Join Information

Objects list
schema-view : S10B80.BANINST1.AGV3DTL

Link List

Link Type	Link	Project
Join	Link Between AGRGMLT and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGMLT	AGBPLDG

Link between AGRPMLT and AGBPLDG

Join Information

Objects list

schema-view : S10B80.BANINST1.AGVPLD2
schema-view : S10B80.BANINST1.AGVPMLT
schema-function : S10B80.BANINST1.F_NUMBER_PLEDGE_YEAR
schema-function : S10B80.BANINST1.F_HIGH_PLEDGE_AMOUNT_YEAR
scope-cursor : S10B80.BANINST1.BWAKCHIS.ALLPLDGVIEWC
scope-cursor : S10B80.BANINST1.BWAKCHIS.GIFTPLDGVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.ALLPLDGVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.GIFTPLDGVIEWC
scope-procedure : S10B80.BANINST1.AGKGRPT.P_GIFT_BY_FISCAL_YR

Link List

Link Type	Link	Project
Join	Link Between AGRPMLT and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPMLT	AGBPLDG

Link between AGRPDES and AGRPMLT

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVPCRD schema-view : S10B80.BANINST1.AGVPMLT

Link List

Link Type	Link	Project
Join	Link Between AGRPDES and AGRPMLT	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPDES	AGRPMLT

Link between AGRPDES and AGRPMMO

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVPSCR schema-view : S10B80.BANINST1.AGVPSFT schema-view : S10B80.BANINST1.AGVPMEM

Link List

Link Type	Link	Project
Join	Link Between AGRPDES and AGRPMMO	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPDES	AGRPMMO

Link between AGRPSOL and AGBPLDG

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVPSOL

Link List

Link Type	Link	Project
Join	Link Between AGRPSOL and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPSOL	AGBPLDG

Link between AGRPMMO and AGBPLDG

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVPMEM scope-cursor : S10B80.BANINST1.BWAKCHIS.ALLPLDGVIEWC scope-cursor : S10B80.BANINST1.BWAKCHIS.GIFTPLDGVIEWC scope-cursor : S10B80.BANINST1.BWDKGHIS.ALLPLDGVIEWC scope-cursor : S10B80.BANINST1.BWDKGHIS.GIFTPLDGVIEWC

Link List

Link Type	Link	Project
Join	Link Between AGRPMMO and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPMMO	AGBPLDG

Link between AXBMGID and AXRMDES

Join Information

Objects list
schema-view : S10B80.BANINST1.AXVPINS scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_DESG_CALC_EMPL scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_DESG_CALC_EMPR scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_FISC_CALC_EMPL scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_FISC_CALC_EMPR

Link List

Link Type	Link	Project
Join	Link Between AXBMGID and AXRMDES	ALUMNI

List of Real links

Link type	Between	And
Join	AXBMGID	AXRMDES

Link between AGRAPLG and ATVPGVE

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPGVE (FK1_AGRAPLG_INV_ATVPGVE_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPGVE (FK2_AGRAPLG_INV_ATVPGVE_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PGVE_CODE	ATVPGVE_CODE	ATVPGVE	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PGVE_CODE_ADJ	ATVPGVE_CODE	ATVPGVE	(0,1)-(0,n)

Link between AGRAPLG and ATVPACK

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPACK (FK1_AGRAPLG_INV_ATVPACK_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPACK (FK2_AGRAPLG_INV_ATVPACK_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PACK_CODE_ADJ	ATVPACK_CODE	ATVPACK	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PACK_CODE	ATVPACK_CODE	ATVPACK	(0,1)-(0,n)

Link between AGRPDES and AGRPCAM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPDES and AGRPCAM (FK1_AGRPDES_INV_AGRPCAM_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPDES	AGRPDES_PIDM	AGRPCAM_PIDM	AGRPCAM	(1,1)-(0,n)
AGRPDES	AGRPDES_PLEDGE_NO	AGRPCAM_PLEDGE_NO	AGRPCAM	(1,1)-(0,n)
AGRPDES	AGRPDES_CAMPAIGN	AGRPCAM_CAMPAIGN	AGRPCAM	(1,1)-(0,n)

Link between AGRPSOL and AGRPCAM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPSOL and AGRPCAM (FK1_AGRPSOL_INV_AGRPCAM_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPSOL	AGRPSOL_PIDM	AGRPCAM_PIDM	AGRPCAM	(1,1)-(0,n)
AGRPSOL	AGRPSOL_PLEDGE_NO	AGRPCAM_PLEDGE_NO	AGRPCAM	(1,1)-(0,n)
AGRPSOL	AGRPSOL_CAMPAIGN	AGRPCAM_CAMPAIGN	AGRPCAM	(1,1)-(0,n)

Link between AGRAPLG and ATVFISC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVFISC (FK1_AGRAPLG_INV_ATVFISC_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVFISC (FK2_AGRAPLG_INV_ATVFISC_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_FISC_CODE_ADJ	ATVFISC_CODE	ATVFISC	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_FISC_CODE	ATVFISC_CODE	ATVFISC	(1,1)-(0,n)

Link between AGRAPLG and ATVPCAT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPCAT (FK1_AGRAPLG_INV_ATVPCAT_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPCAT (FK2_AGRAPLG_INV_ATVPCAT_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PCAT_CODE_ADJ	ATVPCAT_CODE	ATVPCAT	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PCAT_CODE	ATVPCAT_CODE	ATVPCAT	(0,1)-(0,n)

Link between AGRAPLG and ATVPRMD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPRMD (FK1_AGRAPLG_INV_ATVPRMD_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPRMD (FK2_AGRAPLG_INV_ATVPRMD_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PRMD_CODE_ADJ	ATVPRMD_CODE	ATVPRMD	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PRMD_CODE	ATVPRMD_CODE	ATVPRMD	(0,1)-(0,n)

Link between AGRPINS and ATVPRMD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPINS and ATVPRMD (FK1_AGRPINS_INV_ATVPRMD_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPINS	AGRPINS_PRMD_CODE	ATVPRMD_CODE	ATVPRMD	(0,1)-(0,n)

Link between AGRAPLG and ATVPCLS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPCLS (FK1_AGRAPLG_INV_ATVPCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPCLS (FK2_AGRAPLG_INV_ATVPCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPCLS (FK3_AGRAPLG_INV_ATVPCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPCLS (FK4_AGRAPLG_INV_ATVPCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPCLS (FK5_AGRAPLG_INV_ATVPCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPCLS (FK6_AGRAPLG_INV_ATVPCLS_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PCLS_CODE_ADJ	ATVPCLS_CODE	ATVPCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PCLS_CODE	ATVPCLS_CODE	ATVPCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PCLS_CODE_2	ATVPCLS_CODE	ATVPCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PCLS_CODE_3	ATVPCLS_CODE	ATVPCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PCLS_CODE_2_ADJ	ATVPCLS_CODE	ATVPCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PCLS_CODE_3_ADJ	ATVPCLS_CODE	ATVPCLS	(0,1)-(0,n)

Link between AGRPINS and AGBPINS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPINS and AGBPINS (FK1_AGRPINS_INV_AGBPINS_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPINS	AGRPINS_PIDM	AGBPINS_PIDM	AGBPINS	(1,1)-(0,n)
AGRPINS	AGRPINS_PLEDGE_NO	AGBPINS_PLEDGE_NO	AGBPINS	(1,1)-(0,n)

Link between AXRMCAM and AXBMGID

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AXRMCAM and AXBMGID (FK1_AXRMCAM_INV_AXBMGID_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AXRMCAM	AXRMCAM_PIDM	AXBMGID_PIDM	AXBMGID	(1,1)-(0,n)
AXRMCAM	AXRMCAM_EMPR_PIDM	AXBMGID_EMPR_PIDM	AXBMGID	(1,1)-(0,n)
AXRMCAM	AXRMCAM_PLEDGE_NO	AXBMGID_PLEDGE_NO	AXBMGID	(1,1)-(0,n)

Link between AGRPMLT and AGRPIDS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPMLT and AGRPIDS (FK1_AGRPMLT_INV_AGRPIDS_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPMLT	AGRPMLT_PIDM	AGRPIDS_PIDM	AGRPIDS	(1,1)-(0,n)
AGRPMLT	AGRPMLT_XREF_PIDM	AGRPIDS_XREF_PIDM	AGRPIDS	(1,1)-(0,n)
AGRPMLT	AGRPMLT_PLEDGE_NO	AGRPIDS_PLEDGE_NO	AGRPIDS	(1,1)-(0,n)

Link between AGRPMMO and AGRPMEM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPMMO and AGRPMEM (FK1_AGRPMMO_INV_AGRPMEM_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPMMO	AGRPMMO_PIDM	AGRPMEM_PIDM	AGRPMEM	(1,1)-(0,n)
AGRPMMO	AGRPMMO_XREF_PIDM	AGRPMEM_MEMO_PIDM	AGRPMEM	(1,1)-(0,n)
AGRPMMO	AGRPMMO_PLEDGE_NO	AGRPMEM_PLEDGE_NO	AGRPMEM	(1,1)-(0,n)

Link between AGRAPLG and ATVPSTA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPSTA (FK1_AGRAPLG_INV_ATVPSTA_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPSTA (FK2_AGRAPLG_INV_ATVPSTA_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PSTA_CODE	ATVPSTA_CODE	ATVPSTA	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PSTA_CODE_ADJ	ATVPSTA_CODE	ATVPSTA	(0,1)-(0,n)

Link between AGRAPLG and ATVPLDG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPLDG (FK1_AGRAPLG_INV_ATVPLDG_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAPLG and ATVPLDG (FK2_AGRAPLG_INV_ATVPLDG_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PLDG_CODE_ADJ	ATVPLDG_CODE	ATVPLDG	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAPLG	AGRAPLG_PLDG_CODE	ATVPLDG_CODE	ATVPLDG	(0,1)-(0,n)

Link between AXRMDES and AXRMCAM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AXRMDES and AXRMCAM (FK1_AXRMDES_INV_AXRMCAM_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AXRMDES	AXRMDES_PIDM	AXRMCAM_PIDM	AXRMCAM	(1,1)-(0,n)
AXRMDES	AXRMDES_EMPR_PIDM	AXRMCAM_EMPR_PIDM	AXRMCAM	(1,1)-(0,n)
AXRMDES	AXRMDES_PLEDGE_NO	AXRMCAM_PLEDGE_NO	AXRMCAM	(1,1)-(0,n)
AXRMDES	AXRMDES_CAMPAIGN	AXRMCAM_CAMPAIGN	AXRMCAM	(1,1)-(0,n)

Link between AXRMSOL and AXRMCAM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AXRMSOL and AXRMCAM (FK1_AXRMSOL_INV_AXRMCAM_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AXRMSOL	AXRMSOL_PIDM	AXRMCAM_PIDM	AXRMCAM	(1,1)-(0,n)
AXRMSOL	AXRMSOL_EMPR_PIDM	AXRMCAM_EMPR_PIDM	AXRMCAM	(1,1)-(0,n)
AXRMSOL	AXRMSOL_PLEDGE_NO	AXRMCAM_PLEDGE_NO	AXRMCAM	(1,1)-(0,n)
AXRMSOL	AXRMSOL_CAMPAIGN	AXRMCAM_CAMPAIGN	AXRMCAM	(1,1)-(0,n)

Link between AGBPINS and AGBPLDG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPINS and AGBPLDG (FK1_AGBPINS_INV_AGBPLDG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPINS	AGBPINS_PIDM	AGBPLDG_PIDM	AGBPLDG	(1,1)-(0,1)
AGBPINS	AGBPINS_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG	(1,1)-(0,1)

Link between AGRPCAM and AGBPLDG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPCAM and AGBPLDG (FK1_AGRPCAM_INV_AGBPLDG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPCAM	AGRPCAM_PIDM	AGBPLDG_PIDM	AGBPLDG	(1,1)-(0,n)
AGRPCAM	AGRPCAM_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG	(1,1)-(0,n)

Link between AGRPIDS and AGBPLDG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPIDS and AGBPLDG (FK1_AGRPIDS_INV_AGBPLDG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPIDS	AGRPIDS_PIDM	AGBPLDG_PIDM	AGBPLDG	(1,1)-(0,n)
AGRPIDS	AGRPIDS_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG	(1,1)-(0,n)

Link between AGRPMEM and AGBPLDG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPMEM and AGBPLDG (FK1_AGRPMEM_INV_AGBPLDG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPMEM	AGRPMEM_PIDM	AGBPLDG_PIDM	AGBPLDG	(1,1)-(0,n)
AGRPMEM	AGRPMEM_PLEDGE_NO	AGBPLDG_PLEDGE_NO	AGBPLDG	(1,1)-(0,n)

Link between AGBPLDG and ATVFISC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVFISC (FK1_AGBPLDG_INV_ATVFISC_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_FISC_CODE	ATVFISC_CODE	ATVFISC	(1,1)-(0,n)

Link between AGBPLDG and ATVPACK

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVPACK (FK1_AGBPLDG_INV_ATVPACK_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_PACK_CODE	ATVPACK_CODE	ATVPACK	(0,1)-(0,n)

Link between AGBPLDG and ATVPCAT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVPCAT (FK1_AGBPLDG_INV_ATVPCAT_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_PCAT_CODE	ATVPCAT_CODE	ATVPCAT	(0,1)-(0,n)

Link between AGBPLDG and ATVPCLS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVPCLS (FK1_AGBPLDG_INV_ATVPCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVPCLS (FK2_AGBPLDG_INV_ATVPCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVPCLS (FK3_AGBPLDG_INV_ATVPCLS_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_PCLS_CODE	ATVPCLS_CODE	ATVPCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_PCLS_CODE_2	ATVPCLS_CODE	ATVPCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_PCLS_CODE_3	ATVPCLS_CODE	ATVPCLS	(0,1)-(0,n)

Link between AGBPLDG and ATVPGVE

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVPGVE (FK1_AGBPLDG_INV_ATVPGVE_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_PGVE_CODE	ATVPGVE_CODE	ATVPGVE	(0,1)-(0,n)

Link between AGBPLDG and ATVPLDG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVPLDG (FK1_AGBPLDG_INV_ATVPLDG_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_PLDG_CODE	ATVPLDG_CODE	ATVPLDG	(0,1)-(0,n)

Link between AGBPLDG and ATVPRMD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVPRMD (FK1_AGBPLDG_INV_ATVPRMD_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_PRMD_CODE	ATVPRMD_CODE	ATVPRMD	(0,1)-(0,n)

Link between AGBPLDG and ATVPSTA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPLDG and ATVPSTA (FK1_AGBPLDG_INV_ATVPSTA_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPLDG	AGBPLDG_PSTA_CODE	ATVPSTA_CODE	ATVPSTA	(1,1)-(0,n)

Link between AXRMSOL and AGRPSOL

Join Information

Objects list
schema-trigger : S10B80.ALUMNI.A$_AGRPSOL_EXPMG_UPD_TRG

Link List

Link Type	Link	Project
Join	Link Between AXRMSOL and AGRPSOL	ALUMNI

List of Real links

Link type	Between	And
Join	AXRMSOL	AGRPSOL

Link between AXRMDES and AGBPLDG

Join Information

Objects list
schema-trigger : S10B80.ALUMNI.A$_AGBPLDG_EXPMG_DEL_TRG schema-view : S10B80.BANINST1.AXVPINS scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_DESG_CALC_EMPL scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_DESG_CALC_EMPR scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_FISC_CALC_EMPL scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_FISC_CALC_EMPR

Link List

Link Type	Link	Project
Join	Link Between AXRMDES and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AXRMDES	AGBPLDG

Link between AXRMSOL and AGBPLDG

Join Information

Objects list
schema-trigger : S10B80.ALUMNI.A$_AGBPLDG_EXPMG_DEL_TRG

Link List

Link Type	Link	Project
Join	Link Between AXRMSOL and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AXRMSOL	AGBPLDG

Link between AXRMCAM and AGBPLDG

Join Information

Objects list
schema-trigger : S10B80.ALUMNI.A$_AGBPLDG_EXPMG_DEL_TRG scope-procedure : S10B80.BANINST1.BWDKLIBS.P_DISP_OVERALL_TOTALS scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_CAMP_CALC_EMPL scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_CAMP_CALC_EMPR

Link List

Link Type	Link	Project
Join	Link Between AXRMCAM and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AXRMCAM	AGBPLDG

Link between AXBMGID and AGBPLDG

Join Information

Objects list

schema-trigger : S10B80.ALUMNI.A$_AGBPLDG_EXPMG_DEL_TRG
scope-procedure : S10B80.BANINST1.BWDKLIBS.P_DISP_OVERALL_TOTALS
scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_CAMP_CALC_EMPL
scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_CAMP_CALC_EMPR
scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_DESG_CALC_EMPL
scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_DESG_CALC_EMPR
scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_FISC_CALC_EMPL
scope-function : S10B80.BANINST1.BWAKLIBS.F_XMG_FISC_CALC_EMPR

Link List

Link Type	Link	Project
Join	Link Between AXBMGID and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AXBMGID	AGBPLDG

Link between AXRMGRN and AGBPLDG

Join Information

Objects list
schema-trigger : S10B80.ALUMNI.A$_AGBPLDG_EXPMG_DEL_TRG

Link List

Link Type	Link	Project
Join	Link Between AXRMGRN and AGBPLDG	ALUMNI

List of Real links

Link type	Between	And
Join	AXRMGRN	AGBPLDG