Model Gift*

Model Label :

List of Objects

Object Name	Object Type	Layer Name
AGBCSHR	SQL Table	Default
AGBGIFT	SQL Table	Default
AGBMGID	SQL Table	Default
AGRAGDS	SQL Table	Default
AGRAGIF	SQL Table	Default
AGRGAUX	SQL Table	Default
AGRGCAM	SQL Table	Default
AGRGDES	SQL Table	Default
AGRGMEM	SQL Table	Default
AGRGMLT	SQL Table	Default
AGRGMMO	SQL Table	Default
AGRGPAY	SQL Table	Default
AGRGSOL	SQL Table	Default
AGRMCAM	SQL Table	Default
AGRMDES	SQL Table	Default
AGRMGIF	SQL Table	Default
ATVFISC	SQL Table	Default
ATVGACK	SQL Table	Default
ATVGCLS	SQL Table	Default
ATVGIFT	SQL Table	Default
ATVPGVE	SQL Table	Default

Model View

Table AGBCSHR

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
AGBCSHR_USER	VARCHAR2(30)	No	*
AGBCSHR_SESSION_NUMBER	NUMBER(6,0)	No	*
AGBCSHR_START_DATE	DATE	Yes
AGBCSHR_END_DATE	DATE	Yes
AGBCSHR_SESSION_IND	VARCHAR2(1)	No
AGBCSHR_DRAWER_TOTAL	NUMBER(13,2)	Yes
AGBCSHR_SESSION_TOTAL	NUMBER(13,2)	Yes
AGBCSHR_ACTIVITY_DATE	DATE	No
AGBCSHR_ADJUST_TOTAL	NUMBER(13,2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_AGBCSHR	Unique	AGBCSHR_USER
PK_AGBCSHR	Unique	AGBCSHR_SESSION_NUMBER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGVCSHR	SQL View	S10B80.BANINST1	Use (select)
AGVGLST	SQL View	S10B80.BANINST1	Use (select)
AGBCSHR	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_AGBCSHR	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBCSHR

Object Dates

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

Source Code Comments

Advancement Cashier Session Table

Columns Comments for AGBCSHR_USER (# 1)

Source Code Comments

This system maintained field specifies the user name of the cashier.

Columns Comments for AGBCSHR_SESSION_NUMBER (# 2)

Source Code Comments

This system assigned field identifies the number of the cashier session.

Columns Comments for AGBCSHR_START_DATE (# 3)

Source Code Comments

This field specifies the date and time the cashier session begins.

Columns Comments for AGBCSHR_END_DATE (# 4)

Source Code Comments

This field specifies the date and time the cashier session ends.

Columns Comments for AGBCSHR_SESSION_IND (# 5)

Source Code Comments

This field indicates the status of the cashier review session: closed, finalized, or ready to delete.

Columns Comments for AGBCSHR_DRAWER_TOTAL (# 6)

Source Code Comments

This field specifies the total amount received by the cashier against which gifts and pledges are entered.

Columns Comments for AGBCSHR_SESSION_TOTAL (# 7)

Source Code Comments

This field specifies the total amount entered by the cashier and maintained by the system.

Columns Comments for AGBCSHR_ACTIVITY_DATE (# 8)

Source Code Comments

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

Columns Comments for AGBCSHR_ADJUST_TOTAL (# 9)

Source Code Comments

This field contains the total adjustment amount for the cashier session.

Table AGBGIFT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AGBGIFT_PIDM	NUMBER(8,0)	No	*
AGBGIFT_GIFT_NO	VARCHAR2(7)	No	*
AGBGIFT_AMT_TOT	NUMBER(11,2)	No
AGBGIFT_FINAL_IND	VARCHAR2(1)	Yes
AGBGIFT_GIFT_DATE	DATE	No
AGBGIFT_FISC_CODE	NUMBER(4,0)	No	*
AGBGIFT_GACK_CODE	VARCHAR2(2)	Yes	*
AGBGIFT_GCLS_CODE	VARCHAR2(4)	Yes	*
AGBGIFT_GIFT_CODE	VARCHAR2(2)	No	*
AGBGIFT_CARD_NO	VARCHAR2(20)	Yes
AGBGIFT_CARD_EXP_DATE	DATE	Yes
AGBGIFT_COMMENT	VARCHAR2(300)	Yes
AGBGIFT_MATCH_RECEIVED	VARCHAR2(1)	Yes
AGBGIFT_MATCH_PROCESSED	VARCHAR2(1)	No
AGBGIFT_ENTRY_DATE	DATE	No
AGBGIFT_USER	VARCHAR2(30)	No	*
AGBGIFT_ACTIVITY_DATE	DATE	No
AGBGIFT_GACK_IND	VARCHAR2(1)	Yes
AGBGIFT_FEED_IND	VARCHAR2(1)	Yes
AGBGIFT_FEED_DATE	DATE	Yes
AGBGIFT_FEED_DOC_CODE	VARCHAR2(8)	Yes
AGBGIFT_ADJ_IND	VARCHAR2(1)	Yes
AGBGIFT_RECEIPT_IND	VARCHAR2(1)	Yes
AGBGIFT_RECEIPT_DATE	DATE	Yes
AGBGIFT_GIFT_DESC	VARCHAR2(60)	No
AGBGIFT_MG_FORMSENT_IND	VARCHAR2(1)	Yes
AGBGIFT_PGVE_CODE	VARCHAR2(5)	Yes	*
AGBGIFT_GCLS_CODE_2	VARCHAR2(4)	Yes	*
AGBGIFT_GCLS_CODE_3	VARCHAR2(4)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBGIFT_FISC_CODE	ATVFISC_CODE	ATVFISC
AGBGIFT_GCLS_CODE	ATVGCLS_CODE	ATVGCLS
AGBGIFT_GCLS_CODE_2	ATVGCLS_CODE	ATVGCLS
AGBGIFT_GCLS_CODE_3	ATVGCLS_CODE	ATVGCLS
AGBGIFT_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBGIFT_GACK_CODE	ATVGACK_CODE	ATVGACK
AGBGIFT_GIFT_CODE	ATVGIFT_CODE	ATVGIFT
AGBGIFT_GIFT_NO	AGRGSOL_GIFT_NO	AGRGSOL
AGBGIFT_PIDM	AGRGSOL_PIDM	AGRGSOL
AGBGIFT_GIFT_NO	AGRGDES_GIFT_NO	AGRGDES
AGBGIFT_PIDM	AGRGDES_PIDM	AGRGDES
AGBGIFT_USER	AGBCSHR_USER	AGBCSHR
AGBGIFT_GIFT_NO	AGRGMMO_GIFT_NO	AGRGMMO
AGBGIFT_PIDM	AGRGMMO_PIDM	AGRGMMO
AGBGIFT_PIDM	AGRGMLT_PIDM	AGRGMLT
AGBGIFT_GIFT_NO	AGRGMLT_GIFT_NO	AGRGMLT
AGBGIFT_PIDM	AGBMGID_EMPL_PIDM	AGBMGID
AGBGIFT_GIFT_NO	AGBMGID_EMPL_GIFT_NO	AGBMGID
AGBGIFT_PIDM	AGRGCAM_PIDM	AGRGCAM
AGBGIFT_GIFT_NO	AGRGCAM_GIFT_NO	AGRGCAM
AGBGIFT_PIDM	AGRMCAM_EMPL_PIDM	AGRMCAM
AGBGIFT_GIFT_NO	AGRMCAM_GIFT_NO	AGRMCAM
AGBGIFT_GIFT_NO	AGRMDES_GIFT_NO	AGRMDES
AGBGIFT_PIDM	AGRMDES_EMPL_PIDM	AGRMDES
AGBGIFT_PIDM	AGRGMEM_PIDM	AGRGMEM
AGBGIFT_GIFT_NO	AGRGMEM_GIFT_NO	AGRGMEM
AGBGIFT_PIDM	AGRGPAY_PIDM	AGRGPAY
AGBGIFT_GIFT_NO	AGRGPAY_GIFT_NO	AGRGPAY
AGBGIFT_PIDM	AGRAGIF_PIDM	AGRAGIF
AGBGIFT_GIFT_NO	AGRAGIF_GIFT_NO	AGRAGIF
AGBGIFT_PIDM	AGRAGDS_PIDM	AGRAGDS
AGBGIFT_GIFT_NO	AGRAGDS_GIFT_NO	AGRAGDS

Index

Index Name	Index Type	Column Name
AGBGIFT_KEY_INDEX	Unique	AGBGIFT_PIDM
AGBGIFT_KEY_INDEX	Unique	AGBGIFT_GIFT_NO
AGBGIFT_KEY_INDEX2		AGBGIFT_ENTRY_DATE
AGBGIFT_KEY_INDEX2		AGBGIFT_USER
AGBGIFT_KEY_INDEX3		AGBGIFT_GIFT_DATE
AGBGIFT_MATCH_INDEX	Unique	AGBGIFT_MATCH_PROCESSED
AGBGIFT_MATCH_INDEX	Unique	AGBGIFT_PIDM
AGBGIFT_MATCH_INDEX	Unique	AGBGIFT_GIFT_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRGAUX	SQL Table	S10B80.ALUMNI	Join
AGVCSHR	SQL View	S10B80.BANINST1	Use (select)
AGVDONR	SQL View	S10B80.BANINST1	Use (select)
AGVGCAM	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)
AGVGLST	SQL View	S10B80.BANINST1	Use (select)
AGVGMEM	SQL View	S10B80.BANINST1	Use (select)
AGVGMLT	SQL View	S10B80.BANINST1	Use (select)
AGVGSCR	SQL View	S10B80.BANINST1	Use (select)
AGVGSFT	SQL View	S10B80.BANINST1	Use (select)
AGVGSOL	SQL View	S10B80.BANINST1	Use (select)
AGVMGID	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_GET_AGRGAUX_AMOUNT	SQL Function	S10B80.BANINST1	Use (select)
F_HIGH_GIFT_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_MOST_RECENT_GIFT_AMOUNT	SQL Function	S10B80.BANINST1	Use (select)
F_NUMBER_GIFT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_NON_MAT_GIFT_MEMO	SQL Function	S10B80.BANINST1	Use (select)
ALLGIFT_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
ALLGIFT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
GIFTPLDG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
GIFTPLDG_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKCPRF	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPPRF	Rely On
AGBGIFT_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGBGIFT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPSRC	Rely On
AGBGIFT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGBGIFT_REC	Oracle Package Variable	S10B80.BANINST1.BWAKVOPP	Rely On
AGBGIFT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGBGIFT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGBGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGBGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
AGBGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGBGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)Rely On
AGBGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGBGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
AGBMGID_1	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
AGBMGID_1	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
AGBMGID_5	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
AGBMGID_5	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
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)
CAMPEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPEMPLWAITMGVIEWC	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)
CAMPEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPEMPRWAITMGVIEWC	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)
DESGEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
DESGEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
DESGEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPRWAITMGVIEWC	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)
FISCEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
FISCEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
FISCEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
FISCEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
FISCEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
FISCEMPRWAITMGVIEWC	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_APBGHIS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
P_DISP_FISCAL	Oracle Package Procedure	S10B80.BANINST1.BWAKCHIS	Use (select)
P_DISP_FISCAL	Oracle Package Procedure	S10B80.BANINST1.BWDKGHIS	Use (select)
P_EXPECTED_MATCHING_GIFTS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_EXPECTED_MATCHING_GIFTS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert)
P_INSERT_GIFT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
P_PLPAYCAMPDESG	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_PROCESSSPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
GIFT_CODE	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
GIFT_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
GIFT_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
PPAY_AMT	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
SPLIT_AMOUNT	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
P_AGBGIFTNEWGIFT	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Rely On
P_AGBGIFT_ADR	Oracle Package Procedure	S10B80.BANINST1.EOKARTS	Rely On
P_AGBGIFT_AIR	Oracle Package Procedure	S10B80.BANINST1.EOKARTS	Rely On
P_AGBGIFT_AUR	Oracle Package Procedure	S10B80.BANINST1.EOKARTS	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_CREATEGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	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	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_AF_FUND	Oracle Package Function	S10B80.BANINST1.AOKWEVN	Use (select)
F_GET_PROSPECTS_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GIFTEXISTS	Oracle Package Function	S10B80.BANINST1.AOKWEVN	Use (select)
F_PLANNED_GIFT	Oracle Package Function	S10B80.BANINST1.AOKWEVN	Use (select)
F_UPDATE_SOBSEQN	Oracle Package Function	S10B80.BANINST1.AGKGIFT	Rely On
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)
AGBGIFT	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
AGBGIFT_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGBGIFT_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGBGIFT_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
AGBGIFT_MATCH_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGBCSHR	SQL Table	S10B80.ALUMNI	Join
AGBMGID	SQL Table	S10B80.ALUMNI	Join
AGRAGDS	SQL Table	S10B80.ALUMNI	Join
AGRAGIF	SQL Table	S10B80.ALUMNI	Join
AGRGCAM	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Join
AGRGMEM	SQL Table	S10B80.ALUMNI	Join
AGRGMLT	SQL Table	S10B80.ALUMNI	Join
AGRGMMO	SQL Table	S10B80.ALUMNI	Join
AGRGPAY	SQL Table	S10B80.ALUMNI	Join
AGRGSOL	SQL Table	S10B80.ALUMNI	Join
AGRMCAM	SQL Table	S10B80.ALUMNI	Join
AGRMDES	SQL Table	S10B80.ALUMNI	Join
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGACK	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGCLS	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPGVE	SQL Table	S10B80.ALUMNI	Refer (no action)
A_WFAIR_NEWGIFT_INSERT	SQL Trigger	S10B80.ALUMNI	Fire (Insert,after,each row)
ET_AGBGIFT_ADR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (delete,after,each row)
ET_AGBGIFT_AIR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (Insert,after,each row)
ET_AGBGIFT_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.AGBGIFT

Object Dates

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

Source Code Comments

Gift/Pledge Payment Base Table

Columns Comments for AGBGIFT_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGBGIFT_GIFT_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the gift.

Columns Comments for AGBGIFT_AMT_TOT (# 3)

Source Code Comments

This field specifies the total amount of the gift or pledge payment.

Columns Comments for AGBGIFT_FINAL_IND (# 4)

Source Code Comments

This field specifies whether a gift has been finalized in the Cashier Review Session.

Columns Comments for AGBGIFT_GIFT_DATE (# 5)

Source Code Comments

This field specifies the date a gift is received. The date defaults to the system date if no date is entered.

Columns Comments for AGBGIFT_FISC_CODE (# 6)

Source Code Comments

This field specifies the code for the fiscal year.

Columns Comments for AGBGIFT_GACK_CODE (# 7)

Source Code Comments

Gift Range Code associated with the gift amount.

Columns Comments for AGBGIFT_GCLS_CODE (# 8)

Source Code Comments

This field specifies the category of the gift - anonymous, memorial, etc.

Columns Comments for AGBGIFT_GIFT_CODE (# 9)

Source Code Comments

This field specifies the type of gift or method of payment, i.e., check, credit card, bequest, property.

Columns Comments for AGBGIFT_CARD_NO (# 10)

Source Code Comments

This field specifies the credit card number of the donor.

Columns Comments for AGBGIFT_CARD_EXP_DATE (# 11)

Source Code Comments

This field specifies the credit card expiration date.

Columns Comments for AGBGIFT_COMMENT (# 12)

Source Code Comments

This field specifies the comment related to the gift.

Columns Comments for AGBGIFT_MATCH_RECEIVED (# 13)

Source Code Comments

This field specifies whether a matching gift form has been received for a gift.

Columns Comments for AGBGIFT_MATCH_PROCESSED (# 14)

Source Code Comments

This field specifies whether a matching gift has been processed for a gift.

Columns Comments for AGBGIFT_ENTRY_DATE (# 15)

Source Code Comments

This system maintained field specifies the date the gift is entered.

Columns Comments for AGBGIFT_USER (# 16)

Source Code Comments

This system maintained field specifies the user name.

Columns Comments for AGBGIFT_ACTIVITY_DATE (# 17)

Source Code Comments

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

Columns Comments for AGBGIFT_GACK_IND (# 18)

Source Code Comments

Gift acknowledgment indicator updated when gift is acknowledged.

Columns Comments for AGBGIFT_FEED_IND (# 19)

Source Code Comments

Gift feed indicator is updated when gift has been fed to Finance.

Columns Comments for AGBGIFT_FEED_DATE (# 20)

Source Code Comments

Gift feed date is the date the gift was fed to Finance.

Columns Comments for AGBGIFT_FEED_DOC_CODE (# 21)

Source Code Comments

Gift feed document code.

Columns Comments for AGBGIFT_ADJ_IND (# 22)

Source Code Comments

This field indicates that adjustments have been made to this gift via the gift/pledge adjustment form.

Columns Comments for AGBGIFT_RECEIPT_IND (# 23)

Source Code Comments

This field specifies if a receipt is required for this gift record.

Columns Comments for AGBGIFT_RECEIPT_DATE (# 24)

Source Code Comments

Date a receipt was processed through AGPACKN - Gift/Pledge Acknowledgement Process.

Columns Comments for AGBGIFT_GIFT_DESC (# 25)

Source Code Comments

Description for the gift.

Columns Comments for AGBGIFT_MG_FORMSENT_IND (# 26)

Source Code Comments

(Y) - Yes, The MG Form has been sent to the Employer. (N) - No, The MG Form has NOT been sent to the Employer. Null - No, The MG Form has NOT been sent to the Employer.

Columns Comments for AGBGIFT_PGVE_CODE (# 27)

Source Code Comments

The Pledge Gift Vehicle Code associated with this gift.

Columns Comments for AGBGIFT_GCLS_CODE_2 (# 28)

Source Code Comments

This field specifies the second category of the gift - anonymous, memorial, etc.

Columns Comments for AGBGIFT_GCLS_CODE_3 (# 29)

Source Code Comments

This field specifies the third category of the gift - anonymous, memorial, etc.

Table AGBMGID

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
AGBMGID_EMPR_PIDM	NUMBER(8,0)	No	*
AGBMGID_EMPL_PIDM	NUMBER(8,0)	No	*
AGBMGID_EMPL_GIFT_NO	VARCHAR2(7)	No	*
AGBMGID_AMT	NUMBER(11,2)	No
AGBMGID_AMT_PAID	NUMBER(11,2)	No
AGBMGID_STATUS	VARCHAR2(1)	Yes
AGBMGID_DELETE_IND	VARCHAR2(1)	Yes
AGBMGID_ACTIVITY_DATE	DATE	No
AGBMGID_MG_FORMSENT_IND	VARCHAR2(1)	Yes
AGBMGID_SPOUSE_PIDM	NUMBER(8,0)	Yes
AGBMGID_QUALIFY_AMT	NUMBER(11,2)	Yes
AGBMGID_PGVE_CODE	VARCHAR2(5)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
AGBMGID_KEY_INDEX2		AGBMGID_EMPL_PIDM
AGBMGID_KEY_INDEX2		AGBMGID_EMPL_GIFT_NO
AGBMGID_KEY_INDEX3		AGBMGID_EMPR_PIDM
AGBMGID_KEY_INDEX3		AGBMGID_ACTIVITY_DATE
AGBMGID_KEY_INDEX3		AGBMGID_STATUS
PK_AGBMGID	Unique	AGBMGID_EMPR_PIDM
PK_AGBMGID	Unique	AGBMGID_EMPL_GIFT_NO
PK_AGBMGID	Unique	AGBMGID_EMPL_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRGCAM	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Join
AGRMCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRMDES	SQL Table	S10B80.ALUMNI	Join
AGRMGIF	SQL Table	S10B80.ALUMNI	Refer (no action)
SPRIDEN	SQL Table	S10B80.SATURN	Join
AGVMGID	SQL View	S10B80.BANINST1	Use (select)
F_MATCHING_GIFT	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)
AGBMGID_1	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
AGBMGID_1	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
AGBMGID_5	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
AGBMGID_5	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
CAMPEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
CAMPEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
DESGEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
DESGEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
DESGEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
FISCEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
FISCEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
FISCEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
FISCEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
P_DISP_FISCAL	Oracle Package Procedure	S10B80.BANINST1.BWAKCHIS	Use (select)
P_DISP_FISCAL	Oracle Package Procedure	S10B80.BANINST1.BWDKGHIS	Use (select)
GET_WAIT_MATCH_GIFT_AMT_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	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)
AGBMGID	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
AGBMGID_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGBMGID_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_AGBMGID	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBMGID

Object Dates

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

Source Code Comments

Matching Gift Waiting Id Base Table

Columns Comments for AGBMGID_EMPR_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGBMGID_EMPL_PIDM (# 2)

Source Code Comments

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

Columns Comments for AGBMGID_EMPL_GIFT_NO (# 3)

Source Code Comments

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

Columns Comments for AGBMGID_AMT (# 4)

Source Code Comments

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

Columns Comments for AGBMGID_AMT_PAID (# 5)

Source Code Comments

This field specifies the amount paid toward the match.

Columns Comments for AGBMGID_STATUS (# 6)

Source Code Comments

This system maintained field specifies whether a gift has been matched.

Columns Comments for AGBMGID_DELETE_IND (# 7)

Source Code Comments

This field specifies whether a matching gift is deleted or restored.

Columns Comments for AGBMGID_ACTIVITY_DATE (# 8)

Source Code Comments

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

Columns Comments for AGBMGID_MG_FORMSENT_IND (# 9)

Source Code Comments

(Y) - Yes, The MG Form has been sent to the Employer. (N) - No, The MG Form has NOT been sent to the Employer. Null - No, The MG Form has NOT been sent to the Employer.

Columns Comments for AGBMGID_SPOUSE_PIDM (# 10)

Source Code Comments

The Internal ID of the spouse of the person making the gift that will be matched.

Columns Comments for AGBMGID_QUALIFY_AMT (# 11)

Source Code Comments

The amount of the gift that qualifies to be matched.

Table AGRAGDS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRAGDS_PIDM	NUMBER(8,0)	No	*	*
AGRAGDS_GIFT_NO	VARCHAR2(7)	No	*	*
AGRAGDS_AGIF_SEQ_NO	NUMBER(3,0)	No	*	*
AGRAGDS_SEQ_NO	NUMBER(3,0)	No	*
AGRAGDS_PLEDGE_NO	VARCHAR2(7)	No
AGRAGDS_CAMPAIGN	VARCHAR2(5)	No
AGRAGDS_DESG	VARCHAR2(10)	No
AGRAGDS_AMT	NUMBER(11,2)	No
AGRAGDS_USER	VARCHAR2(30)	Yes
AGRAGDS_GIFT_DATE	DATE	Yes
AGRAGDS_FISC_CODE	NUMBER(4,0)	Yes		*
AGRAGDS_GIFT_CODE	VARCHAR2(2)	Yes		*
AGRAGDS_PLEDGE_NO_ADJ	VARCHAR2(7)	Yes
AGRAGDS_CAMPAIGN_ADJ	VARCHAR2(5)	Yes
AGRAGDS_DESG_ADJ	VARCHAR2(10)	Yes
AGRAGDS_AMT_ADJ	NUMBER(11,2)	Yes
AGRAGDS_USER_ADJ	VARCHAR2(30)	No
AGRAGDS_ENTRY_DATE_ADJ	DATE	No
AGRAGDS_GIFT_DATE_ADJ	DATE	Yes
AGRAGDS_FISC_CODE_ADJ	NUMBER(4,0)	Yes		*
AGRAGDS_GIFT_CODE_ADJ	VARCHAR2(2)	Yes		*
AGRAGDS_NEED_TO_FEED_IND	VARCHAR2(1)	Yes
AGRAGDS_FEED_IND_ADJ	VARCHAR2(1)	Yes
AGRAGDS_FEED_DATE_ADJ	DATE	Yes
AGRAGDS_FEED_DOC_CODE_ADJ	VARCHAR2(8)	Yes
AGRAGDS_FINAL_IND_ADJ	VARCHAR2(1)	Yes
AGRAGDS_USER_CASH	VARCHAR2(30)	Yes
AGRAGDS_ENTRY_DATE_CASH	DATE	Yes
AGRAGDS_SESSION_NUMBER	NUMBER(6,0)	Yes
AGRAGDS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRAGDS_FISC_CODE_ADJ	ATVFISC_CODE	ATVFISC
AGRAGDS_FISC_CODE	ATVFISC_CODE	ATVFISC
AGRAGDS_GIFT_CODE	ATVGIFT_CODE	ATVGIFT
AGRAGDS_GIFT_CODE_ADJ	ATVGIFT_CODE	ATVGIFT
AGRAGDS_PIDM	AGRAGIF_PIDM	AGRAGIF
AGRAGDS_GIFT_NO	AGRAGIF_GIFT_NO	AGRAGIF
AGRAGDS_AGIF_SEQ_NO	AGRAGIF_SEQ_NO	AGRAGIF

Index

Index Name	Index Type	Column Name
AGRAGDS_KEY_INDEX2		AGRAGDS_ENTRY_DATE_ADJ
AGRAGDS_KEY_INDEX3		AGRAGDS_USER_CASH
AGRAGDS_KEY_INDEX3		AGRAGDS_ENTRY_DATE_CASH
PK_AGRAGDS	Unique	AGRAGDS_PIDM
PK_AGRAGDS	Unique	AGRAGDS_GIFT_NO
PK_AGRAGDS	Unique	AGRAGDS_AGIF_SEQ_NO
PK_AGRAGDS	Unique	AGRAGDS_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGVAGDS	SQL View	S10B80.BANINST1	Use (select)
AGRAGDS	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
AGRAGDS_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGRAGDS_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRAGDS	SQL Index	S10B80.ALUMNI	Rely On
AGRAGIF	SQL Table	S10B80.ALUMNI	Join
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAGDS

Object Dates

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

Source Code Comments

Gift/Pledge Payment Adjustment Designation Table

Columns Comments for AGRAGDS_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRAGDS_GIFT_NO (# 2)

Source Code Comments

This field specifies the number of the gift being adjusted.

Columns Comments for AGRAGDS_AGIF_SEQ_NO (# 3)

Source Code Comments

This field specifies the corresponding gift agdjustment sequence number from the Gift/Pledge Payment Adjustment Table, AGRAGIF.

Columns Comments for AGRAGDS_SEQ_NO (# 4)

Source Code Comments

This field specifies the sequence of adjustments to the gift.

Columns Comments for AGRAGDS_PLEDGE_NO (# 5)

Source Code Comments

This field specifies the number of the pledge associated with the payment.

Columns Comments for AGRAGDS_CAMPAIGN (# 6)

Source Code Comments

This field specifies the campaign code.

Columns Comments for AGRAGDS_DESG (# 7)

Source Code Comments

This field specifies the designation code.

Columns Comments for AGRAGDS_AMT (# 8)

Source Code Comments

This field specifies the amount of the gift for the campaign/designation.

Columns Comments for AGRAGDS_USER (# 9)

Source Code Comments

This field specifies the user that entered the original gift.

Columns Comments for AGRAGDS_GIFT_DATE (# 10)

Source Code Comments

This field specifies the date of the gift being adjusted.

Columns Comments for AGRAGDS_FISC_CODE (# 11)

Source Code Comments

This field specifies the fiscal year of the gift being adjusted.

Columns Comments for AGRAGDS_GIFT_CODE (# 12)

Source Code Comments

This field specifies the gift code of the gift being adjusted.

Columns Comments for AGRAGDS_PLEDGE_NO_ADJ (# 13)

Source Code Comments

This field specifies the new pledge number associated with the gift.

Columns Comments for AGRAGDS_CAMPAIGN_ADJ (# 14)

Source Code Comments

This field specifies the new campaign associated with the gift.

Columns Comments for AGRAGDS_DESG_ADJ (# 15)

Source Code Comments

This field specifies the new designation associated with the gift.

Columns Comments for AGRAGDS_AMT_ADJ (# 16)

Source Code Comments

This field specifies the new amount associated with the campaign/designation of the gift.

Columns Comments for AGRAGDS_USER_ADJ (# 17)

Source Code Comments

This field specifies the user that entered the adjusted gift entry.

Columns Comments for AGRAGDS_ENTRY_DATE_ADJ (# 18)

Source Code Comments

This field specifies the date and time of the gift adjustment.

Columns Comments for AGRAGDS_GIFT_DATE_ADJ (# 19)

Source Code Comments

This field specifies the new date of the gift entered as an adjustment.

Columns Comments for AGRAGDS_FISC_CODE_ADJ (# 20)

Source Code Comments

This field specifies the new fiscal year of the gift which was generated as a result of a change to the gift date.

Columns Comments for AGRAGDS_GIFT_CODE_ADJ (# 21)

Source Code Comments

This field specifies the new gift code associated with the adjusted gift.

Columns Comments for AGRAGDS_NEED_TO_FEED_IND (# 22)

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 AGRAGDS_FEED_IND_ADJ (# 23)

Source Code Comments

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

Columns Comments for AGRAGDS_FEED_DATE_ADJ (# 24)

Source Code Comments

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

Columns Comments for AGRAGDS_FEED_DOC_CODE_ADJ (# 25)

Source Code Comments

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

Columns Comments for AGRAGDS_FINAL_IND_ADJ (# 26)

Source Code Comments

This field specifies the cashier session status associated with this gift adjustment.

Columns Comments for AGRAGDS_USER_CASH (# 27)

Source Code Comments

This field specifies the cashier associated with this gift adjustment.

Columns Comments for AGRAGDS_ENTRY_DATE_CASH (# 28)

Source Code Comments

This field specifies the date and time of the adjustment associated with a cashier session.

Columns Comments for AGRAGDS_SESSION_NUMBER (# 29)

Source Code Comments

This field specifies the cashier session number for the adjustment.

Columns Comments for AGRAGDS_ACTIVITY_DATE (# 30)

Source Code Comments

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

Table AGRAGIF

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRAGIF_PIDM	NUMBER(8,0)	No	*
AGRAGIF_GIFT_NO	VARCHAR2(7)	No	*
AGRAGIF_SEQ_NO	NUMBER(3,0)	No	*
AGRAGIF_AMT_TOT	NUMBER(11,2)	No
AGRAGIF_GIFT_DATE	DATE	No
AGRAGIF_FISC_CODE	NUMBER(4,0)	No		*
AGRAGIF_GIFT_CODE	VARCHAR2(2)	No		*
AGRAGIF_GACK_CODE	VARCHAR2(2)	Yes		*
AGRAGIF_GACK_IND	VARCHAR2(1)	Yes
AGRAGIF_GCLS_CODE	VARCHAR2(4)	Yes		*
AGRAGIF_CARD_NO	VARCHAR2(20)	Yes
AGRAGIF_CARD_EXP_DATE	DATE	Yes
AGRAGIF_COMMENT	VARCHAR2(300)	Yes
AGRAGIF_ENTRY_DATE	DATE	No
AGRAGIF_USER	VARCHAR2(30)	No
AGRAGIF_FINAL_IND	VARCHAR2(1)	Yes
AGRAGIF_FEED_IND	VARCHAR2(1)	Yes
AGRAGIF_FEED_DATE	DATE	Yes
AGRAGIF_FEED_DOC_CODE	VARCHAR2(8)	Yes
AGRAGIF_AMT_TOT_ADJ	NUMBER(11,2)	Yes
AGRAGIF_GIFT_DATE_ADJ	DATE	Yes
AGRAGIF_FISC_CODE_ADJ	NUMBER(4,0)	Yes		*
AGRAGIF_GIFT_CODE_ADJ	VARCHAR2(2)	Yes		*
AGRAGIF_GACK_CODE_ADJ	VARCHAR2(2)	Yes		*
AGRAGIF_GACK_IND_ADJ	VARCHAR2(1)	Yes
AGRAGIF_GCLS_CODE_ADJ	VARCHAR2(4)	Yes		*
AGRAGIF_CARD_NO_ADJ	VARCHAR2(20)	Yes
AGRAGIF_CARD_EXP_DATE_ADJ	DATE	Yes
AGRAGIF_COMMENT_ADJ	VARCHAR2(300)	Yes
AGRAGIF_ENTRY_DATE_ADJ	DATE	No
AGRAGIF_USER_ADJ	VARCHAR2(30)	No
AGRAGIF_FINAL_IND_ADJ	VARCHAR2(1)	Yes
AGRAGIF_SESSION_NUMBER	NUMBER(6,0)	Yes
AGRAGIF_SEND_TO_CASH_IND	VARCHAR2(1)	Yes
AGRAGIF_ENTRY_DATE_CASH	DATE	Yes
AGRAGIF_USER_CASH	VARCHAR2(30)	Yes
AGRAGIF_NEED_TO_FEED_IND	VARCHAR2(1)	Yes
AGRAGIF_FEED_IND_ADJ	VARCHAR2(1)	Yes
AGRAGIF_FEED_DATE_ADJ	DATE	Yes
AGRAGIF_FEED_DOC_CODE_ADJ	VARCHAR2(8)	Yes
AGRAGIF_ACTIVITY_DATE	DATE	No
AGRAGIF_GIFT_DESC	VARCHAR2(60)	Yes
AGRAGIF_GIFT_DESC_ADJ	VARCHAR2(60)	Yes
AGRAGIF_PGVE_CODE	VARCHAR2(5)	Yes		*
AGRAGIF_PGVE_CODE_ADJ	VARCHAR2(5)	Yes		*
AGRAGIF_GCLS_CODE_2	VARCHAR2(4)	Yes		*
AGRAGIF_GCLS_CODE_3	VARCHAR2(4)	Yes		*
AGRAGIF_GCLS_CODE_2_ADJ	VARCHAR2(4)	Yes		*
AGRAGIF_GCLS_CODE_3_ADJ	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRAGIF_FISC_CODE_ADJ	ATVFISC_CODE	ATVFISC
AGRAGIF_FISC_CODE	ATVFISC_CODE	ATVFISC
AGRAGIF_GCLS_CODE_ADJ	ATVGCLS_CODE	ATVGCLS
AGRAGIF_GCLS_CODE	ATVGCLS_CODE	ATVGCLS
AGRAGIF_GCLS_CODE_2	ATVGCLS_CODE	ATVGCLS
AGRAGIF_GCLS_CODE_3	ATVGCLS_CODE	ATVGCLS
AGRAGIF_GCLS_CODE_2_ADJ	ATVGCLS_CODE	ATVGCLS
AGRAGIF_GCLS_CODE_3_ADJ	ATVGCLS_CODE	ATVGCLS
AGRAGIF_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGRAGIF_PGVE_CODE_ADJ	ATVPGVE_CODE	ATVPGVE
AGRAGIF_GACK_CODE_ADJ	ATVGACK_CODE	ATVGACK
AGRAGIF_GACK_CODE	ATVGACK_CODE	ATVGACK
AGRAGIF_GIFT_CODE_ADJ	ATVGIFT_CODE	ATVGIFT
AGRAGIF_GIFT_CODE	ATVGIFT_CODE	ATVGIFT

Index

Index Name	Index Type	Column Name
AGRAGIF_KEY_INDEX2		AGRAGIF_USER_CASH
AGRAGIF_KEY_INDEX2		AGRAGIF_ENTRY_DATE_CASH
PK_AGRAGIF	Unique	AGRAGIF_PIDM
PK_AGRAGIF	Unique	AGRAGIF_GIFT_NO
PK_AGRAGIF	Unique	AGRAGIF_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRAGDS	SQL Table	S10B80.ALUMNI	Join
AGVAGDS	SQL View	S10B80.BANINST1	Use (select)
AGRAGIF	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
AGRAGIF_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRAGIF	SQL Index	S10B80.ALUMNI	Rely On
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGACK	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGCLS	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPGVE	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRAGIF

Object Dates

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

Source Code Comments

Gift/Pledge Payment Adjustment Table

Columns Comments for AGRAGIF_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number for the gift being adjusted.

Columns Comments for AGRAGIF_GIFT_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the gift.

Columns Comments for AGRAGIF_SEQ_NO (# 3)

Source Code Comments

This field specifies the system assigned sequence number of the gift adjustment.

Columns Comments for AGRAGIF_AMT_TOT (# 4)

Source Code Comments

This field specifies the total amount of the gift or pledge payment being adjusted.

Columns Comments for AGRAGIF_GIFT_DATE (# 5)

Source Code Comments

This field specifies the gift date of the gift being adjusted.

Columns Comments for AGRAGIF_FISC_CODE (# 6)

Source Code Comments

This field specifies the fiscal year of the gift being adjusted.

Columns Comments for AGRAGIF_GIFT_CODE (# 7)

Source Code Comments

This field specifies the type of gift or method of payment of the gift being adjusted, i.e., check, credit card, bequest, property.

Columns Comments for AGRAGIF_GACK_CODE (# 8)

Source Code Comments

This field specifies the code for the acknowledgement type associated with the gift being adjusted.

Columns Comments for AGRAGIF_GACK_IND (# 9)

Source Code Comments

This field specifies the acknowledgement indicator associated with the gift being adjusted.

Columns Comments for AGRAGIF_GCLS_CODE (# 10)

Source Code Comments

This field specifies the category of the gift being adjusted- anonymous, memorial, etc.

Columns Comments for AGRAGIF_CARD_NO (# 11)

Source Code Comments

This field specifies the credit card number used to pay the gift being adjusted.

Columns Comments for AGRAGIF_CARD_EXP_DATE (# 12)

Source Code Comments

This field specifies the credit card expiration date of the card used to pay the gift that is being adjusted.

Columns Comments for AGRAGIF_COMMENT (# 13)

Source Code Comments

This field specifies the comment related to the gift being adjusted.

Columns Comments for AGRAGIF_ENTRY_DATE (# 14)

Source Code Comments

This system maintained field specifies the date the gift being adjusted was entered.

Columns Comments for AGRAGIF_USER (# 15)

Source Code Comments

This system maintained field specifies the user name that entered the gift being adjusted.

Columns Comments for AGRAGIF_FINAL_IND (# 16)

Source Code Comments

This field specifies the session status of the cashier session associated with the gift being adjusted.

Columns Comments for AGRAGIF_FEED_IND (# 17)

Source Code Comments

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

Columns Comments for AGRAGIF_FEED_DATE (# 18)

Source Code Comments

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

Columns Comments for AGRAGIF_FEED_DOC_CODE (# 19)

Source Code Comments

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

Columns Comments for AGRAGIF_AMT_TOT_ADJ (# 20)

Source Code Comments

This field specifies the total amount of the adjusted gift or pledge payment.

Columns Comments for AGRAGIF_GIFT_DATE_ADJ (# 21)

Source Code Comments

This field specifies the adjusted date of the gift.

Columns Comments for AGRAGIF_FISC_CODE_ADJ (# 22)

Source Code Comments

This field specifies the new fiscal year associated with the adjusted gift updated as a result of a change to the gift date.

Columns Comments for AGRAGIF_GIFT_CODE_ADJ (# 23)

Source Code Comments

This field specifies the new gift code associated with the adjusted gift.

Columns Comments for AGRAGIF_GACK_CODE_ADJ (# 24)

Source Code Comments

This field specifies the new gift acknowledgement code associated with the adjusted gift.

Columns Comments for AGRAGIF_GACK_IND_ADJ (# 25)

Source Code Comments

This field specifies the new gift acknowledgement indicator associated with the adjusted gift.

Columns Comments for AGRAGIF_GCLS_CODE_ADJ (# 26)

Source Code Comments

This field specifies the new gift class code associated with the adjusted gift.

Columns Comments for AGRAGIF_CARD_NO_ADJ (# 27)

Source Code Comments

This field specifies the new credit card number associated with the adjusted gift.

Columns Comments for AGRAGIF_CARD_EXP_DATE_ADJ (# 28)

Source Code Comments

This field specifies the new credit card expiration date associated with the adjusted gift.

Columns Comments for AGRAGIF_COMMENT_ADJ (# 29)

Source Code Comments

This field specifies the new comment associated with the adjusted gift.

Columns Comments for AGRAGIF_ENTRY_DATE_ADJ (# 30)

Source Code Comments

This field specifies the date and time this gift adjustment was made.

Columns Comments for AGRAGIF_USER_ADJ (# 31)

Source Code Comments

This field specifies the user id that made this gift adjustment.

Columns Comments for AGRAGIF_FINAL_IND_ADJ (# 32)

Source Code Comments

This field specifies the cashier session status for this gift adjustment.

Columns Comments for AGRAGIF_SESSION_NUMBER (# 33)

Source Code Comments

This field specifies the cashier session number of the gift adjustment.

Columns Comments for AGRAGIF_SEND_TO_CASH_IND (# 34)

Source Code Comments

This field specifies that this gift adjustment affects cashiering.

Columns Comments for AGRAGIF_ENTRY_DATE_CASH (# 35)

Source Code Comments

This field specifies the entry date and time of this adjustment for cashiering purposes.

Columns Comments for AGRAGIF_USER_CASH (# 36)

Source Code Comments

This field specifies which cashier is associated with this adjustment.

Columns Comments for AGRAGIF_NEED_TO_FEED_IND (# 37)

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 AGRAGIF_FEED_IND_ADJ (# 38)

Source Code Comments

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

Columns Comments for AGRAGIF_FEED_DATE_ADJ (# 39)

Source Code Comments

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

Columns Comments for AGRAGIF_FEED_DOC_CODE_ADJ (# 40)

Source Code Comments

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

Columns Comments for AGRAGIF_ACTIVITY_DATE (# 41)

Source Code Comments

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

Columns Comments for AGRAGIF_GIFT_DESC (# 42)

Source Code Comments

The previous description of the gift type.

Columns Comments for AGRAGIF_GIFT_DESC_ADJ (# 43)

Source Code Comments

The new description of the gift type.

Columns Comments for AGRAGIF_PGVE_CODE (# 44)

Source Code Comments

The original Pledge Gift Vehicle Code associated with this gift.

Columns Comments for AGRAGIF_PGVE_CODE_ADJ (# 45)

Source Code Comments

The adjusted Pledge Gift Vehicle Code associated with this gift.

Columns Comments for AGRAGIF_GCLS_CODE_2 (# 46)

Source Code Comments

Second Gift class code on gift before the adjustment.

Columns Comments for AGRAGIF_GCLS_CODE_3 (# 47)

Source Code Comments

Third Gift class code on gift before the adjustment.

Columns Comments for AGRAGIF_GCLS_CODE_2_ADJ (# 48)

Source Code Comments

Second Gift class code on adjusted gift.

Columns Comments for AGRAGIF_GCLS_CODE_3_ADJ (# 49)

Source Code Comments

Third Gift class code on adjusted gift.

Table AGRGAUX

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AGRGAUX_PIDM	NUMBER(8,0)	No	*
AGRGAUX_GIFT_NO	VARCHAR2(7)	No
AGRGAUX_AUXL_CODE	VARCHAR2(5)	No	*
AGRGAUX_AUXL_DESC	VARCHAR2(60)	No
AGRGAUX_DCPR_COST	NUMBER(11,2)	No
AGRGAUX_ACTIVITY_DATE	DATE	No
AGRGAUX_DCPR_CODE	VARCHAR2(4)	Yes	*
AGRGAUX_ISSUE_DATE	DATE	Yes
AGRGAUX_DCPR_VALUE	NUMBER(11,2)	Yes
AGRGAUX_DESC	VARCHAR2(60)	Yes
AGRGAUX_ACC_REJ_IND	VARCHAR2(1)	Yes
AGRGAUX_ACC_REJ_DATE	DATE	Yes
AGRGAUX_GIFT_ADJ_VOID_IND	VARCHAR2(1)	Yes
AGRGAUX_DONR_CODE	VARCHAR2(4)	Yes	*
AGRGAUX_PREF_CLAS	VARCHAR2(4)	Yes
AGRGAUX_USER	VARCHAR2(30)	Yes
AGRGAUX_DEDUCT_FOR_TAXES	VARCHAR2(1)	Yes
AGRGAUX_COMMENT	LONG	Yes
AGRGAUX_AUXL_VALUE_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGAUX_DCPR_CODE	ATVDCPR_CODE	ATVDCPR
AGRGAUX_AUXL_CODE	ATVAUXL_CODE	ATVAUXL
AGRGAUX_DONR_CODE	ATVDONR_CODE	ATVDONR
AGRGAUX_PIDM	AGBGIFT_PIDM	AGBGIFT

Index

Index Name	Index Type	Column Name
AGRGAUX_KEY_INDEX		AGRGAUX_PIDM
AGRGAUX_KEY_INDEX		AGRGAUX_GIFT_NO
AGRGAUX_KEY_INDEX		AGRGAUX_AUXL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_GET_AGRGAUX_AMOUNT	SQL Function	S10B80.BANINST1	Use (select)
F_INLONG_AGRGAUX	Oracle Package Function	S10B80.BANINST1.AOKLONG	Use (select)
F_LONGTOCHAR_AGRGAUX	Oracle Package Function	S10B80.BANINST1.AOKLONG	Use (select)
AGRGAUX	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
AGRGAUX_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
ATVAUXL	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCPR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDONR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGAUX

Object Dates

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

Source Code Comments

Gift Auxiliary Amount Table.

Columns Comments for AGRGAUX_PIDM (# 1)

Source Code Comments

Internal system generated identification number.

Columns Comments for AGRGAUX_GIFT_NO (# 2)

Source Code Comments

The system assigned number for the gift.

Columns Comments for AGRGAUX_AUXL_CODE (# 3)

Source Code Comments

Auxiliary code associated with the gift.

Columns Comments for AGRGAUX_AUXL_DESC (# 4)

Source Code Comments

Description for the auxiliary code for the gift.

Columns Comments for AGRGAUX_DCPR_COST (# 5)

Source Code Comments

Actual cost to institution of benefit/premium.

Columns Comments for AGRGAUX_ACTIVITY_DATE (# 6)

Source Code Comments

System maintained field specifying the date the record was
created or updated.

Columns Comments for AGRGAUX_DCPR_CODE (# 7)

Source Code Comments

Benefit/premium associated with the gift.

Columns Comments for AGRGAUX_ISSUE_DATE (# 8)

Source Code Comments

Date the benefit/premium was issued.

Columns Comments for AGRGAUX_DCPR_VALUE (# 9)

Source Code Comments

Market value of benefit/premium.

Columns Comments for AGRGAUX_DESC (# 10)

Source Code Comments

Brief description.

Columns Comments for AGRGAUX_ACC_REJ_IND (# 11)

Source Code Comments

Indicator for whether benefit/premium was accepted/rejected.

Columns Comments for AGRGAUX_ACC_REJ_DATE (# 12)

Source Code Comments

Date benefit/premium was accepted/rejected.

Columns Comments for AGRGAUX_GIFT_ADJ_VOID_IND (# 13)

Source Code Comments

Indicator for whether gift was adjusted/voided.

Columns Comments for AGRGAUX_DONR_CODE (# 14)

Source Code Comments

Donor category code for ID associated with gift.

Columns Comments for AGRGAUX_PREF_CLAS (# 15)

Source Code Comments

Preferred class year for ID.

Columns Comments for AGRGAUX_USER (# 16)

Source Code Comments

System maintained field specifying user name.

Columns Comments for AGRGAUX_DEDUCT_FOR_TAXES (# 17)

Source Code Comments

Indicator for whether premium is to be deducted for taxes.

Columns Comments for AGRGAUX_COMMENT (# 18)

Source Code Comments

Free format comment for associated amount/benefit/premium.

Table AGRGCAM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRGCAM_PIDM	NUMBER(8,0)	No	*	*
AGRGCAM_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGCAM_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRGCAM_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGCAM_AMT	NUMBER(11,2)	No
AGRGCAM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGCAM_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGRGCAM_PIDM	AXBMGID_EMPR_PIDM	AXBMGID
AGRGCAM_PLEDGE_NO	AXBMGID_PLEDGE_NO	AXBMGID
AGRGCAM_PIDM	AXBMGID_PIDM	AXBMGID
AGRGCAM_GIFT_NO	AGRMGIF_EMPR_GIFT_NO	AGRMGIF
AGRGCAM_PIDM	AGRMGIF_EMPR_PIDM	AGRMGIF
AGRGCAM_GIFT_NO	AGRMGIF_GIFT_NO	AGRMGIF
AGRGCAM_PIDM	AGRMGIF_PIDM	AGRMGIF
AGRGCAM_PIDM	AGBMGID_EMPL_PIDM	AGBMGID
AGRGCAM_CAMPAIGN	AGRMCAM_CAMPAIGN	AGRMCAM
AGRGCAM_GIFT_NO	AGRMCAM_GIFT_NO	AGRMCAM

Index

Index Name	Index Type	Column Name
AGRGCAM_KEY_INDEX2		AGRGCAM_CAMPAIGN
AGRGCAM_KEY_INDEX2		AGRGCAM_GIFT_NO
AGRGCAM_KEY_INDEX2		AGRGCAM_AMT
PK_AGRGCAM	Unique	AGRGCAM_PIDM
PK_AGRGCAM	Unique	AGRGCAM_GIFT_NO
PK_AGRGCAM	Unique	AGRGCAM_PLEDGE_NO
PK_AGRGCAM	Unique	AGRGCAM_CAMPAIGN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVGCAM	SQL View	S10B80.BANINST1	Use (select)
GETAGRGCAMC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Rely On
GETAGRGCAMC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
P_INSERT_AGRGCAM	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_AGRGCAM	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,update)
P_NEWGIFTCAMPDESG	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_PLPAYCAMPDESG	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
GET_DONORS_COUNT_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Rely On
GET_DONORS_COUNT_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	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 (select)
F_AF_FUND	Oracle Package Function	S10B80.BANINST1.AOKWEVN	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)
AGRGCAM	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
AGRGCAM_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRGCAM	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGBMGID	SQL Table	S10B80.ALUMNI	Join
AGRMCAM	SQL Table	S10B80.ALUMNI	Join
AGRMGIF	SQL Table	S10B80.ALUMNI	Join
AXBMGID	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGCAM

Object Dates

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

Source Code Comments

Gift Campaign Repeating Table

Columns Comments for AGRGCAM_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRGCAM_GIFT_NO (# 2)

Source Code Comments

This field specifies the number of the gift.

Columns Comments for AGRGCAM_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the number of the pledge.

Columns Comments for AGRGCAM_CAMPAIGN (# 4)

Source Code Comments

This field specifies the campaign associated with the gift.

Columns Comments for AGRGCAM_AMT (# 5)

Source Code Comments

This field specifies the amount of the gift.

Columns Comments for AGRGCAM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table AGRGDES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRGDES_PIDM	NUMBER(8,0)	No	*	*
AGRGDES_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRGDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGDES_DESG	VARCHAR2(10)	No	*	*
AGRGDES_AMT	NUMBER(11,2)	No
AGRGDES_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGDES_PIDM	AGRGCAM_PIDM	AGRGCAM
AGRGDES_GIFT_NO	AGRGCAM_GIFT_NO	AGRGCAM
AGRGDES_PLEDGE_NO	AGRGCAM_PLEDGE_NO	AGRGCAM
AGRGDES_CAMPAIGN	AGRGCAM_CAMPAIGN	AGRGCAM
AGRGDES_PIDM	AGRGMMO_PIDM	AGRGMMO
AGRGDES_PLEDGE_NO	AGRGMMO_PLEDGE_NO	AGRGMMO
AGRGDES_GIFT_NO	AGRGMMO_GIFT_NO	AGRGMMO
AGRGDES_CAMPAIGN	AGRGMMO_CAMPAIGN	AGRGMMO
AGRGDES_DESG	AGRGMMO_DESG	AGRGMMO
AGRGDES_PIDM	AGRGMLT_PIDM	AGRGMLT
AGRGDES_PLEDGE_NO	AGRGMLT_PLEDGE_NO	AGRGMLT
AGRGDES_GIFT_NO	AGRGMLT_GIFT_NO	AGRGMLT
AGRGDES_CAMPAIGN	AGRGMLT_CAMPAIGN	AGRGMLT
AGRGDES_DESG	AGRGMLT_DESG	AGRGMLT
AGRGDES_PIDM	AXBMGID_EMPR_PIDM	AXBMGID
AGRGDES_PLEDGE_NO	AXBMGID_PLEDGE_NO	AXBMGID
AGRGDES_PIDM	AXBMGID_PIDM	AXBMGID
AGRGDES_GIFT_NO	AGRMGIF_EMPR_GIFT_NO	AGRMGIF
AGRGDES_PIDM	AGRMGIF_EMPR_PIDM	AGRMGIF
AGRGDES_GIFT_NO	AGRMGIF_GIFT_NO	AGRMGIF
AGRGDES_PIDM	AGRMGIF_PIDM	AGRMGIF
AGRGDES_PIDM	AGBMGID_EMPL_PIDM	AGBMGID
AGRGDES_DESG	AGRMDES_DESG	AGRMDES
AGRGDES_GIFT_NO	AGRMDES_GIFT_NO	AGRMDES
AGRGDES_CAMPAIGN	AGRMDES_CAMPAIGN	AGRMDES

Index

Index Name	Index Type	Column Name
AGRGDES_KEY_INDEX2		AGRGDES_DESG
AGRGDES_KEY_INDEX2		AGRGDES_GIFT_NO
AGRGDES_KEY_INDEX2		AGRGDES_AMT
AGRGDES_KEY_INDEX3		AGRGDES_PIDM
AGRGDES_KEY_INDEX3		AGRGDES_PLEDGE_NO
AGRGDES_KEY_INDEX4		AGRGDES_CAMPAIGN
AGRGDES_KEY_INDEX4		AGRGDES_DESG
PK_AGRGDES	Unique	AGRGDES_PIDM
PK_AGRGDES	Unique	AGRGDES_GIFT_NO
PK_AGRGDES	Unique	AGRGDES_PLEDGE_NO
PK_AGRGDES	Unique	AGRGDES_CAMPAIGN
PK_AGRGDES	Unique	AGRGDES_DESG

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Join
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRPDES	SQL Table	S10B80.ALUMNI	Join
AGTGTCR	SQL Table	S10B80.ALUMNI	Join
AGVCSHR	SQL View	S10B80.BANINST1	Use (select)
AGVDONR	SQL View	S10B80.BANINST1	Use (select)
AGVGCRD	SQL View	S10B80.BANINST1	Use (select)
AGVGFD2	SQL View	S10B80.BANINST1	Use (select)
AGVGLST	SQL View	S10B80.BANINST1	Use (select)
AGVGMEM	SQL View	S10B80.BANINST1	Use (select)
AGVGMLT	SQL View	S10B80.BANINST1	Use (select)
AGVGSCR	SQL View	S10B80.BANINST1	Use (select)
AGVGSFT	SQL View	S10B80.BANINST1	Use (select)
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKCPRF	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPPRF	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKLIBS	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGRGDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGRGDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGRGDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGRGDESVIEWC	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)
PLDGPAYVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
PLDGPAYVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
P_INSERT_AGRGDES	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_AGRGDES	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert)
P_INSERT_AGRGPAY	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_GIFT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_NEWGIFTCAMPDESG	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
P_PLPAYCAMPDESG	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_CREATEGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	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)
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)
AGRGDES	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
AGRGDES_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGRGDES_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
AGRGDES_KEY_INDEX4	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRGDES	SQL Index	S10B80.ALUMNI	Rely On
AGBMGID	SQL Table	S10B80.ALUMNI	Join
AGRGCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGMLT	SQL Table	S10B80.ALUMNI	Join
AGRGMMO	SQL Table	S10B80.ALUMNI	Join
AGRMDES	SQL Table	S10B80.ALUMNI	Join
AGRMGIF	SQL Table	S10B80.ALUMNI	Join
AXBMGID	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGDES

Object Dates

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

Source Code Comments

Gift Designation Repeating Table

Columns Comments for AGRGDES_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRGDES_GIFT_NO (# 2)

Source Code Comments

This field specifies the number of the gift.

Columns Comments for AGRGDES_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the number of the pledge.

Columns Comments for AGRGDES_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRGDES_DESG (# 5)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRGDES_AMT (# 6)

Source Code Comments

This field specifies the amount of the gift designation.

Columns Comments for AGRGDES_ACTIVITY_DATE (# 7)

Source Code Comments

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

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 AGRGPAY

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
AGRGPAY_PIDM	NUMBER(8,0)	No	*
AGRGPAY_GIFT_NO	VARCHAR2(7)	No	*
AGRGPAY_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGPAY_AMT	NUMBER(11,2)	No
AGRGPAY_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_AGRGPAY	Unique	AGRGPAY_PIDM
PK_AGRGPAY	Unique	AGRGPAY_GIFT_NO
PK_AGRGPAY	Unique	AGRGPAY_PLEDGE_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRGMEM	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVPPAY	SQL View	S10B80.BANINST1	Use (select)
PAY_TOTAL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
PAY_TOTAL_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
PAY_TOTAL_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKCPRF	Rely On
PAY_TOTAL_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPPRF	Rely On
TPPPYMT_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKLIBS	Rely On
GETAGRGPAYC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Rely On
GETAGRGPAYC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
GETGPAYTOTALC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GETGPAYTOTALC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GETGPAYTOTALC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)
GETGPAYTOTALC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)
P_INSERT_AGRGPAY	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,update)
P_AGRGPAY_ADR	Oracle Package Procedure	S10B80.BANINST1.EOKARTS	Rely On
P_AGRGPAY_AIR	Oracle Package Procedure	S10B80.BANINST1.EOKARTS	Rely On
P_AGRGPAY_AUR	Oracle Package Procedure	S10B80.BANINST1.EOKARTS	Rely On
P_GET_GIFT_INFO	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Rely On
P_GET_GIFT_INFO	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Use (select)
AGRGPAY	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_AGRGPAY	SQL Index	S10B80.ALUMNI	Rely On
ET_AGRGPAY_ADR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (delete,after,each row)
ET_AGRGPAY_AIR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (Insert,after,each row)
ET_AGRGPAY_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.AGRGPAY

Object Dates

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

Source Code Comments

Gift/Pledge Payment Repeating Table

Columns Comments for AGRGPAY_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGRGPAY_GIFT_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the gift.

Columns Comments for AGRGPAY_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the number of the pledge. For a one time gift, entering zero in this field will assign a pledge number of 0000000.

Columns Comments for AGRGPAY_AMT (# 4)

Source Code Comments

This field indicates the total amount of the gift for the pledge.

Columns Comments for AGRGPAY_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table AGRGSOL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AGRGSOL_PIDM	NUMBER(8,0)	No	*
AGRGSOL_GIFT_NO	VARCHAR2(7)	No	*
AGRGSOL_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGSOL_CAMPAIGN	VARCHAR2(5)	No	*
AGRGSOL_SOLC_CODE	VARCHAR2(8)	Yes	*
AGRGSOL_SOL_ORG	VARCHAR2(5)	Yes	*
AGRGSOL_SOL_PIDM	NUMBER(8,0)	Yes
AGRGSOL_AMT	NUMBER(11,2)	No
AGRGSOL_ACTIVITY_DATE	DATE	No
AGRGSOL_CREDIT_PIDM	NUMBER(8,0)	No
AGRGSOL_3PP_PLEDGE_NO	VARCHAR2(7)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGSOL_PIDM	AGRGCAM_PIDM	AGRGCAM
AGRGSOL_GIFT_NO	AGRGCAM_GIFT_NO	AGRGCAM
AGRGSOL_PLEDGE_NO	AGRGCAM_PLEDGE_NO	AGRGCAM
AGRGSOL_CAMPAIGN	AGRGCAM_CAMPAIGN	AGRGCAM
AGRGSOL_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AGRGSOL_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AGRGSOL_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP

Index

Index Name	Index Type	Column Name
AGRGSOL_INDEX_03		AGRGSOL_GIFT_NO
AGRGSOL_INDEX_03		AGRGSOL_PLEDGE_NO
AGRGSOL_INDEX_03		AGRGSOL_CAMPAIGN
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_PIDM
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_GIFT_NO
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_PLEDGE_NO
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_CAMPAIGN
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_SOLC_CODE
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_SOL_ORG
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_SOL_PIDM
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_CREDIT_PIDM
AGRGSOL_KEY_INDEX2		AGRGSOL_CAMPAIGN
AGRGSOL_KEY_INDEX2		AGRGSOL_SOLC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGVGFD1	SQL View	S10B80.BANINST1	Use (select)
AGVGSOL	SQL View	S10B80.BANINST1	Use (select)
F_GIFT_SOLICITOR	SQL Function	S10B80.BANINST1	Use (select)
F_GIFT_SOLICITOR_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_GIFT_SOLICITOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
GETAGRGSOLC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Rely On
GETAGRGSOLC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
P_INSERT_UPDATE_AGRGSOL	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_UPDATE_AGRGSOL	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,update)
P_CREATEGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (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)
AGRGSOL	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
AGRGSOL_INDEX_03	SQL Index	S10B80.ALUMNI	Rely On
AGRGSOL_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGRGSOL_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGRGCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSOLC	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGSOL

Object Dates

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

Source Code Comments

Gift Solicitor Repeating Table

Columns Comments for AGRGSOL_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGRGSOL_GIFT_NO (# 2)

Source Code Comments

This field specifies the system assigned gift number.

Columns Comments for AGRGSOL_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the system assigned pledge number.

Columns Comments for AGRGSOL_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRGSOL_SOLC_CODE (# 5)

Source Code Comments

This field specifies the type of solicitation.

Columns Comments for AGRGSOL_SOL_ORG (# 6)

Source Code Comments

This field specifies the solicitor organization to which a solicitor is assigned.

Columns Comments for AGRGSOL_SOL_PIDM (# 7)

Source Code Comments

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

Columns Comments for AGRGSOL_AMT (# 8)

Source Code Comments

This field specifies the amount of the gift.

Columns Comments for AGRGSOL_ACTIVITY_DATE (# 9)

Source Code Comments

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

Columns Comments for AGRGSOL_CREDIT_PIDM (# 10)

Source Code Comments

The Internal ID of the person receiving the third party credit.

Columns Comments for AGRGSOL_3PP_PLEDGE_NO (# 11)

Source Code Comments

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

Table AGRMCAM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRMCAM_EMPR_PIDM	NUMBER(8,0)	No	*	*
AGRMCAM_EMPL_PIDM	NUMBER(8,0)	No	*	*
AGRMCAM_GIFT_NO	VARCHAR2(7)	No	*	*
AGRMCAM_CAMPAIGN	VARCHAR2(5)	No	*
AGRMCAM_AMT	NUMBER(11,2)	No
AGRMCAM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRMCAM_EMPR_PIDM	AGBMGID_EMPR_PIDM	AGBMGID
AGRMCAM_GIFT_NO	AGBMGID_EMPL_GIFT_NO	AGBMGID
AGRMCAM_EMPL_PIDM	AGBMGID_EMPL_PIDM	AGBMGID

Index

Index Name	Index Type	Column Name
AGRMCAM_KEY_INDEX2		AGRMCAM_EMPL_PIDM
AGRMCAM_KEY_INDEX2		AGRMCAM_GIFT_NO
AGRMCAM_KEY_INDEX2		AGRMCAM_CAMPAIGN
AGRMCAM_KEY_INDEX3		AGRMCAM_CAMPAIGN
PK_AGRMCAM	Unique	AGRMCAM_EMPR_PIDM
PK_AGRMCAM	Unique	AGRMCAM_EMPL_PIDM
PK_AGRMCAM	Unique	AGRMCAM_GIFT_NO
PK_AGRMCAM	Unique	AGRMCAM_CAMPAIGN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRGCAM	SQL Table	S10B80.ALUMNI	Join
AGRMDES	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRMSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
CAMPEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
CAMPEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GET_WAIT_MATCH_GIFT_AMT_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	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)
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)
AGRMCAM	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
AGRMCAM_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGRMCAM_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRMCAM	SQL Index	S10B80.ALUMNI	Rely On
AGBMGID	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRMCAM

Object Dates

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

Source Code Comments

Matching Gift Campaign Repeating Table

Columns Comments for AGRMCAM_EMPR_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGRMCAM_EMPL_PIDM (# 2)

Source Code Comments

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

Columns Comments for AGRMCAM_GIFT_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the gift.

Columns Comments for AGRMCAM_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRMCAM_AMT (# 5)

Source Code Comments

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

Columns Comments for AGRMCAM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table AGRMDES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRMDES_EMPR_PIDM	NUMBER(8,0)	No	*	*
AGRMDES_EMPL_PIDM	NUMBER(8,0)	No	*	*
AGRMDES_GIFT_NO	VARCHAR2(7)	No	*	*
AGRMDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRMDES_DESG	VARCHAR2(10)	No	*
AGRMDES_AMT	NUMBER(11,2)	No
AGRMDES_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRMDES_EMPR_PIDM	AGRMCAM_EMPR_PIDM	AGRMCAM
AGRMDES_EMPL_PIDM	AGRMCAM_EMPL_PIDM	AGRMCAM
AGRMDES_GIFT_NO	AGRMCAM_GIFT_NO	AGRMCAM
AGRMDES_CAMPAIGN	AGRMCAM_CAMPAIGN	AGRMCAM
AGRMDES_EMPR_PIDM	AGBMGID_EMPR_PIDM	AGBMGID
AGRMDES_GIFT_NO	AGBMGID_EMPL_GIFT_NO	AGBMGID
AGRMDES_EMPL_PIDM	AGBMGID_EMPL_PIDM	AGBMGID

Index

Index Name	Index Type	Column Name
AGRMDES_KEY_INDEX2		AGRMDES_EMPL_PIDM
AGRMDES_KEY_INDEX2		AGRMDES_GIFT_NO
AGRMDES_KEY_INDEX2		AGRMDES_CAMPAIGN
AGRMDES_KEY_INDEX2		AGRMDES_DESG
AGRMDES_KEY_INDEX3		AGRMDES_DESG
PK_AGRMDES	Unique	AGRMDES_EMPR_PIDM
PK_AGRMDES	Unique	AGRMDES_EMPL_PIDM
PK_AGRMDES	Unique	AGRMDES_GIFT_NO
PK_AGRMDES	Unique	AGRMDES_CAMPAIGN
PK_AGRMDES	Unique	AGRMDES_DESG

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Join
AGRMGIF	SQL Table	S10B80.ALUMNI	Join
AGVMDES	SQL View	S10B80.BANINST1	Use (select)
DESGEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPLWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
DESGEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
DESGEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGEMPRWAITMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GET_WAIT_MATCH_GIFT_AMT_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Rely On
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)
AGRMDES	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
AGRMDES_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGRMDES_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRMDES	SQL Index	S10B80.ALUMNI	Rely On
AGBMGID	SQL Table	S10B80.ALUMNI	Join
AGRMCAM	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRMDES

Object Dates

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

Source Code Comments

Matching Gift Designation Repeating Table

Columns Comments for AGRMDES_EMPR_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGRMDES_EMPL_PIDM (# 2)

Source Code Comments

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

Columns Comments for AGRMDES_GIFT_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the gift.

Columns Comments for AGRMDES_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRMDES_DESG (# 5)

Source Code Comments

This field specifies the five character alphanumeric designation code.

Columns Comments for AGRMDES_AMT (# 6)

Source Code Comments

This field specifies the amount of the designation.

Columns Comments for AGRMDES_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table AGRMGIF

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRMGIF_PIDM	NUMBER(8,0)	No	*	*
AGRMGIF_GIFT_NO	VARCHAR2(7)	No	*	*
AGRMGIF_EMPR_GIFT_NO	VARCHAR2(7)	No	*
AGRMGIF_ACTIVITY_DATE	DATE	No
AGRMGIF_GIFT_AMT	NUMBER(11,2)	No
AGRMGIF_EMPR_PIDM	NUMBER(8,0)	No		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRMGIF_EMPR_PIDM	AGBMGID_EMPR_PIDM	AGBMGID
AGRMGIF_GIFT_NO	AGBMGID_EMPL_GIFT_NO	AGBMGID
AGRMGIF_PIDM	AGBMGID_EMPL_PIDM	AGBMGID
AGRMGIF_PIDM	AGRMDES_EMPL_PIDM	AGRMDES
AGRMGIF_GIFT_NO	AGRMDES_GIFT_NO	AGRMDES
AGRMGIF_EMPR_PIDM	AGRMDES_EMPR_PIDM	AGRMDES

Index

Index Name	Index Type	Column Name
AGRMGIF_KEY_INDEX2		AGRMGIF_EMPR_PIDM
AGRMGIF_KEY_INDEX2		AGRMGIF_EMPR_GIFT_NO
PK_AGRMGIF	Unique	AGRMGIF_PIDM
PK_AGRMGIF	Unique	AGRMGIF_GIFT_NO
PK_AGRMGIF	Unique	AGRMGIF_EMPR_GIFT_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRGCAM	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Join
AXBMGID	SQL Table	S10B80.ALUMNI	Join
AFVCAMG	SQL View	S10B80.BANINST1	Use (select)
AFVCAMO	SQL View	S10B80.BANINST1	Use (select)
AFVCTMG	SQL View	S10B80.BANINST1	Use (select)
AFVCTMO	SQL View	S10B80.BANINST1	Use (select)
AGVDONR	SQL View	S10B80.BANINST1	Use (select)
AGVGSFT	SQL View	S10B80.BANINST1	Use (select)
AGVMDES	SQL View	S10B80.BANINST1	Use (select)
AGVMEMO	SQL View	S10B80.BANINST1	Use (select)
AGVMGCR	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_MEMO_DETAIL_MATCHING_GIFT	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_NON_MAT_GIFT_MEMO	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)
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)
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)
FISCEMPRMGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	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)
AGRMGIF	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
AGRMGIF_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRMGIF	SQL Index	S10B80.ALUMNI	Rely On
AGBMGID	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRMDES	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRMGIF

Object Dates

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

Source Code Comments

Matching Gift Ident Repeating Table

Columns Comments for AGRMGIF_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGRMGIF_GIFT_NO (# 2)

Source Code Comments

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

Columns Comments for AGRMGIF_EMPR_GIFT_NO (# 3)

Source Code Comments

This field specifies the number of the employers matching gift.

Columns Comments for AGRMGIF_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for AGRMGIF_GIFT_AMT (# 5)

Source Code Comments

This field identifies the amount of the corporate gift applied to the employee gift.

Columns Comments for AGRMGIF_EMPR_PIDM (# 6)

Source Code Comments

This field identifies the employers pidm that matched the employee gift.

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 ATVGACK

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVGACK_CODE	VARCHAR2(2)	No	*
ATVGACK_DESC	VARCHAR2(30)	No
ATVGACK_LOW_LEVEL	NUMBER(11,2)	No
ATVGACK_HIGH_LEVEL	NUMBER(11,2)	No
ATVGACK_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVGACK	Unique	ATVGACK_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGIF	SQL Table	S10B80.ALUMNI	Refer (no action)
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
ATVGACKC	Oracle Package Cursor	S10B80.BANINST1.ATKGACK	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVGACK	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_ATVGACK	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVGACK

Object Dates

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

Source Code Comments

Gift Range Validation Table

Columns Comments for ATVGACK_CODE (# 1)

Source Code Comments

Code for the type of gift range.

Columns Comments for ATVGACK_DESC (# 2)

Source Code Comments

Description of the gift range.

Columns Comments for ATVGACK_LOW_LEVEL (# 3)

Source Code Comments

Bottom dollar range associated with the gift range.

Columns Comments for ATVGACK_HIGH_LEVEL (# 4)

Source Code Comments

Top dollar range associated with the gift range.

Columns Comments for ATVGACK_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table ATVGCLS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVGCLS_CODE	VARCHAR2(4)	No	*
ATVGCLS_DESC	VARCHAR2(30)	No
ATVGCLS_ANONYMOUS_IND	VARCHAR2(1)	No
ATVGCLS_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVGCLS	Unique	ATVGCLS_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)
AGRAGIF	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGC	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSRCE	SQL Table	S10B80.ALUMNI	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
GETALLGCLSC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
ATVGCLS	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_ATVGCLS	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVGCLS

Object Dates

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

Source Code Comments

Gift Classification Validation Table

Columns Comments for ATVGCLS_CODE (# 1)

Source Code Comments

This field specifies the code for the class of the gift.

Columns Comments for ATVGCLS_DESC (# 2)

Source Code Comments

This field specifies the description of the gift class code.

Columns Comments for ATVGCLS_ANONYMOUS_IND (# 3)

Source Code Comments

This field specifies whether a gift is to be anonymous (Values = Y or N).

Columns Comments for ATVGCLS_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table ATVGIFT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVGIFT_CODE	VARCHAR2(2)	No	*
ATVGIFT_DESC	VARCHAR2(30)	No
ATVGIFT_CREDIT_CARD_IND	VARCHAR2(1)	Yes
ATVGIFT_MATCH_IND	VARCHAR2(1)	Yes
ATVGIFT_CFAE_GIFT_CATG	VARCHAR2(1)	Yes
ATVGIFT_GIFT_GROUP	VARCHAR2(1)	Yes
ATVGIFT_GIFT_GROUP_DESC	VARCHAR2(10)	Yes
ATVGIFT_ACTIVITY_DATE	DATE	No
ATVGIFT_RUCL_CODE	VARCHAR2(4)	Yes
ATVGIFT_DB_GL_ACCT	VARCHAR2(60)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVGIFT	Unique	ATVGIFT_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)
AGBGHLD	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGDS	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGIF	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGT	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCGT	SQL Table	S10B80.ALUMNI	Refer (no action)
APRTCFA	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSRCE	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVGFD1	SQL View	S10B80.BANINST1	Use (select)
AGVGFD2	SQL View	S10B80.BANINST1	Join
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
GETGIFTDESCC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
ATVGIFT_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
GIFT_DESC	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
ATVGIFTC	Oracle Package Cursor	S10B80.BANINST1.ATKGIFT	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
F_PLANNED_GIFT	Oracle Package Function	S10B80.BANINST1.AOKWEVN	Use (select)
ATVGIFT	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_ATVGIFT	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVGIFT

Object Dates

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

Source Code Comments

Gift Type Validation Table

Columns Comments for ATVGIFT_CODE (# 1)

Source Code Comments

This field specifies the code for the instrument of payment for a gift.

Columns Comments for ATVGIFT_DESC (# 2)

Source Code Comments

This field specifies the description of the gift type code.

Columns Comments for ATVGIFT_CREDIT_CARD_IND (# 3)

Source Code Comments

This field specifies whether a gift type is associated with credit card payment.

Columns Comments for ATVGIFT_MATCH_IND (# 4)

Source Code Comments

This field specifies whether a gift type is associated with a matching payment.

Columns Comments for ATVGIFT_CFAE_GIFT_CATG (# 5)

Source Code Comments

This field specifies the Council for Financial Aid to Education category associated with the gift type which is used for reporting purposes.

Columns Comments for ATVGIFT_GIFT_GROUP (# 6)

Source Code Comments

This field specifies the gift category associated with the gift type which is used for reporting purposes.

Columns Comments for ATVGIFT_GIFT_GROUP_DESC (# 7)

Source Code Comments

This field specifies the description of the gift category associated with the gift type.

Columns Comments for ATVGIFT_ACTIVITY_DATE (# 8)

Source Code Comments

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

Columns Comments for ATVGIFT_RUCL_CODE (# 9)

Source Code Comments

This is the rule class code used for the finance interface to the BANNER finance system.

Columns Comments for ATVGIFT_DB_GL_ACCT (# 10)

Source Code Comments

This is a debit account number for non-Banner Finance users.

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.

Link between AGBGIFT and AGRGSOL

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVGSOL

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGRGSOL	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRGSOL

Link between AGRAGDS and AGRAGIF

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVAGDS

Link List

Link Type	Link	Project
Join	Link Between AGRAGDS and AGRAGIF	ALUMNI

List of Real links

Link type	Between	And
Join	AGRAGDS	AGRAGIF

Link between AGBGIFT and AGRGDES

Join Information

Objects list

schema-view : S10B80.BANINST1.AGVGLST
schema-view : S10B80.BANINST1.AGVGFD2
schema-view : S10B80.BANINST1.AGVDONR
schema-view : S10B80.BANINST1.AGVCSHR
schema-view : S10B80.BANINST1.AGVGCRD
schema-view : S10B80.BANINST1.AGVGSCR
schema-view : S10B80.BANINST1.AGVGSFT
scope-cursor : S10B80.BANINST1.BWAKCHIS.PAYMENTVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.PAYMENTVIEWC
scope-procedure : S10B80.BANINST1.AGKGRPT.P_GIFT_BY_FISCAL_YR
scope-cursor : S10B80.BANINST1.BWDKCPRF.PAYMENTVIEWC
scope-cursor : S10B80.BANINST1.BWDKPPRF.PAYMENTVIEWC

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGRGDES	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRGDES

Link between AGBGIFT and AGBCSHR

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVGLST schema-view : S10B80.BANINST1.AGVCSHR

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGBCSHR	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGBCSHR

Link between AGRGDES and AGRGMMO

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVGMEM schema-view : S10B80.BANINST1.AGVGSCR schema-view : S10B80.BANINST1.AGVGSFT

Link List

Link Type	Link	Project
Join	Link Between AGRGDES and AGRGMMO	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGDES	AGRGMMO

Link between AGBGIFT and AGRGMMO

Join Information

Objects list

schema-view : S10B80.BANINST1.AGVGMEM
schema-function : S10B80.BANINST1.F_DESIGNATION_MATCHING_GIFT
schema-function : S10B80.BANINST1.F_DESIGNATION_MEMO_CREDIT
schema-function : S10B80.BANINST1.F_TOTAL_NON_MAT_GIFT_MEMO
schema-function : S10B80.BANINST1.F_CAMPAIGN_MATCHING_GIFT
schema-function : S10B80.BANINST1.F_CAMPAIGN_MEMO_CREDIT
schema-view : S10B80.BANINST1.AGVGSCR
scope-cursor : S10B80.BANINST1.BWAKCHIS.ALLGIFTVIEWC
scope-cursor : S10B80.BANINST1.BWAKCHIS.GIFTPLDGVIEWC
scope-cursor : S10B80.BANINST1.BWAKCHIS.PAYMENTVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.ALLGIFTVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.GIFTPLDGVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.PAYMENTVIEWC
scope-procedure : S10B80.BANINST1.AGKGRPT.P_GIFT_BY_FISCAL_YR
scope-cursor : S10B80.BANINST1.BWDKCPRF.PAYMENTVIEWC
scope-cursor : S10B80.BANINST1.BWDKPPRF.PAYMENTVIEWC

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGRGMMO	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRGMMO

Link between AGBGIFT and AGRGMLT

Join Information

Objects list

schema-view : S10B80.BANINST1.AGVGFD2
schema-view : S10B80.BANINST1.AGVGMLT
schema-view : S10B80.BANINST1.AGVGGIF
schema-function : S10B80.BANINST1.F_NUMBER_GIFT_YEAR
schema-function : S10B80.BANINST1.F_HIGH_GIFT_AMOUNT_YEAR
scope-cursor : S10B80.BANINST1.BWAKCHIS.ALLGIFTVIEWC
scope-cursor : S10B80.BANINST1.BWAKCHIS.GIFTPLDGVIEWC
scope-cursor : S10B80.BANINST1.BWAKCHIS.PAYMENTVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.ALLGIFTVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.GIFTPLDGVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.PAYMENTVIEWC
scope-procedure : S10B80.BANINST1.AGKGRPT.P_GIFT_BY_FISCAL_YR
scope-cursor : S10B80.BANINST1.BWDKCPRF.PAYMENTVIEWC
scope-cursor : S10B80.BANINST1.BWDKPPRF.PAYMENTVIEWC

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGRGMLT	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRGMLT

Link between AGRGDES and AGRGMLT

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVGMLT schema-view : S10B80.BANINST1.AGVGCRD

Link List

Link Type	Link	Project
Join	Link Between AGRGDES and AGRGMLT	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGDES	AGRGMLT

Link between AGRMGIF and AGRMDES

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVMDES

Link List

Link Type	Link	Project
Join	Link Between AGRMGIF and AGRMDES	ALUMNI

List of Real links

Link type	Between	And
Join	AGRMGIF	AGRMDES

Link between AGBGIFT and AGBMGID

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVMGID

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGBMGID	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGBMGID

Link between AGBGIFT and AGRGCAM

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVGCAM scope-function : S10B80.BANINST1.AOKWEVN.F_AF_FUND

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGRGCAM	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRGCAM

Link between AGBGIFT and AGRGMEM

Join Information

Objects list
User link

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGRGMEM	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRGMEM

Link between AGBGIFT and AGRGPAY

Join Information

Objects list
User link

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGRGPAY	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRGPAY

Link between AGBGIFT and AGRAGIF

Join Information

Objects list
User link

Link List

Link Type	Link	Project
Join	Link Between AGBGIFT and AGRAGIF	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRAGIF

Link between AGRGAUX and AGBGIFT

Join Information

Objects list
schema-function : S10B80.BANINST1.F_GET_AGRGAUX_AMOUNT

Link List

Link Type	Link	Project
Join	Link Between AGRGAUX and AGBGIFT	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGAUX	AGBGIFT

Link between AGRMDES and AGBMGID

Join Information

Objects list

scope-cursor : S10B80.BANINST1.BWAKCHIS.DESGEMPRMGVIEWC
scope-cursor : S10B80.BANINST1.BWAKCHIS.DESGEMPLWAITMGVIEWC
scope-cursor : S10B80.BANINST1.BWAKCHIS.DESGEMPRWAITMGVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.DESGEMPRMGVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.DESGEMPLWAITMGVIEWC
scope-cursor : S10B80.BANINST1.BWDKGHIS.DESGEMPRWAITMGVIEWC
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 AGRMDES and AGBMGID	ALUMNI

List of Real links

Link type	Between	And
Join	AGRMDES	AGBMGID

Link between AGRGCAM and AGRMGIF

Join Information

Objects list
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 AGRGCAM and AGRMGIF	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGCAM	AGRMGIF

Link between AGBGIFT and AGRMCAM

Join Information

Objects list
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 AGBGIFT and AGRMCAM	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRMCAM

Link between AGRGCAM and AGBMGID

Join Information

Objects list
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 AGRGCAM and AGBMGID	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGCAM	AGBMGID

Link between AGRGCAM and AGRMCAM

Join Information

Objects list
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 AGRGCAM and AGRMCAM	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGCAM	AGRMCAM

Link between AGRGDES and AGRMGIF

Join Information

Objects list
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 AGRGDES and AGRMGIF	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGDES	AGRMGIF

Link between AGBGIFT and AGRMDES

Join Information

Objects list
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 AGBGIFT and AGRMDES	ALUMNI

List of Real links

Link type	Between	And
Join	AGBGIFT	AGRMDES

Link between AGRGDES and AGBMGID

Join Information

Objects list
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 AGRGDES and AGBMGID	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGDES	AGBMGID

Link between AGRGDES and AGRMDES

Join Information

Objects list
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 AGRGDES and AGRMDES	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGDES	AGRMDES

Link between AGRAGIF and ATVGCLS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGCLS (FK1_AGRAGIF_INV_ATVGCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGCLS (FK2_AGRAGIF_INV_ATVGCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGCLS (FK3_AGRAGIF_INV_ATVGCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGCLS (FK4_AGRAGIF_INV_ATVGCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGCLS (FK5_AGRAGIF_INV_ATVGCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGCLS (FK6_AGRAGIF_INV_ATVGCLS_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GCLS_CODE_ADJ	ATVGCLS_CODE	ATVGCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GCLS_CODE	ATVGCLS_CODE	ATVGCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GCLS_CODE_2	ATVGCLS_CODE	ATVGCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GCLS_CODE_3	ATVGCLS_CODE	ATVGCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GCLS_CODE_2_ADJ	ATVGCLS_CODE	ATVGCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GCLS_CODE_3_ADJ	ATVGCLS_CODE	ATVGCLS	(0,1)-(0,n)

Link between AGBGIFT and ATVGCLS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBGIFT and ATVGCLS (FK1_AGBGIFT_INV_ATVGCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGBGIFT and ATVGCLS (FK2_AGBGIFT_INV_ATVGCLS_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGBGIFT and ATVGCLS (FK3_AGBGIFT_INV_ATVGCLS_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBGIFT	AGBGIFT_GCLS_CODE	ATVGCLS_CODE	ATVGCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBGIFT	AGBGIFT_GCLS_CODE_2	ATVGCLS_CODE	ATVGCLS	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBGIFT	AGBGIFT_GCLS_CODE_3	ATVGCLS_CODE	ATVGCLS	(0,1)-(0,n)

Link between AGBGIFT and ATVPGVE

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBGIFT and ATVPGVE (FK1_AGBGIFT_INV_ATVPGVE_CODE)	ALUMNI

Foreign Key information

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

Link between AGRAGIF and ATVPGVE

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVPGVE (FK1_AGRAGIF_INV_ATVPGVE_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVPGVE (FK2_AGRAGIF_INV_ATVPGVE_CODE)	ALUMNI

Foreign Key information

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

Foreign Key information

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

Link between AGRMCAM and AGBMGID

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRMCAM and AGBMGID (FK1_AGRMCAM_INV_AGBMGID_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRMCAM	AGRMCAM_EMPR_PIDM	AGBMGID_EMPR_PIDM	AGBMGID	(1,1)-(0,n)
AGRMCAM	AGRMCAM_EMPL_PIDM	AGBMGID_EMPL_PIDM	AGBMGID	(1,1)-(0,n)
AGRMCAM	AGRMCAM_GIFT_NO	AGBMGID_EMPL_GIFT_NO	AGBMGID	(1,1)-(0,n)

Link between AGRMDES and AGRMCAM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRMDES and AGRMCAM (FK1_AGRMDES_INV_AGRMCAM_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRMDES	AGRMDES_EMPR_PIDM	AGRMCAM_EMPR_PIDM	AGRMCAM	(1,1)-(0,n)
AGRMDES	AGRMDES_EMPL_PIDM	AGRMCAM_EMPL_PIDM	AGRMCAM	(1,1)-(0,n)
AGRMDES	AGRMDES_GIFT_NO	AGRMCAM_GIFT_NO	AGRMCAM	(1,1)-(0,n)
AGRMDES	AGRMDES_CAMPAIGN	AGRMCAM_CAMPAIGN	AGRMCAM	(1,1)-(0,n)

Link between AGBGIFT and ATVFISC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBGIFT and ATVFISC (FK1_AGBGIFT_INV_ATVFISC_CODE)	ALUMNI

Foreign Key information

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

Link between AGRAGDS and ATVFISC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAGDS and ATVFISC (FK1_AGRAGDS_INV_ATVFISC_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGDS and ATVFISC (FK2_AGRAGDS_INV_ATVFISC_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGDS	AGRAGDS_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
AGRAGDS	AGRAGDS_FISC_CODE	ATVFISC_CODE	ATVFISC	(0,1)-(0,n)

Link between AGRAGIF and ATVFISC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVFISC (FK1_AGRAGIF_INV_ATVFISC_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVFISC (FK2_AGRAGIF_INV_ATVFISC_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_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
AGRAGIF	AGRAGIF_FISC_CODE	ATVFISC_CODE	ATVFISC	(1,1)-(0,n)

Link between AGRGMEM and AGRGPAY

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRGMEM and AGRGPAY (FK1_AGRGMEM_INV_AGRGPAY_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRGMEM	AGRGMEM_PIDM	AGRGPAY_PIDM	AGRGPAY	(1,1)-(0,n)
AGRGMEM	AGRGMEM_GIFT_NO	AGRGPAY_GIFT_NO	AGRGPAY	(1,1)-(0,n)
AGRGMEM	AGRGMEM_PLEDGE_NO	AGRGPAY_PLEDGE_NO	AGRGPAY	(1,1)-(0,n)

Link between AGRMGIF and AGBMGID

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRMGIF and AGBMGID (FK1_AGRMGIF_INV_AGBMGID_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRMGIF	AGRMGIF_PIDM	AGBMGID_EMPL_PIDM	AGBMGID	(1,1)-(0,n)
AGRMGIF	AGRMGIF_GIFT_NO	AGBMGID_EMPL_GIFT_NO	AGBMGID	(1,1)-(0,n)
AGRMGIF	AGRMGIF_EMPR_PIDM	AGBMGID_EMPR_PIDM	AGBMGID	(1,1)-(0,n)

Link between AGBGIFT and ATVGACK

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBGIFT and ATVGACK (FK1_AGBGIFT_INV_ATVGACK_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBGIFT	AGBGIFT_GACK_CODE	ATVGACK_CODE	ATVGACK	(0,1)-(0,n)

Link between AGRAGIF and ATVGACK

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGACK (FK1_AGRAGIF_INV_ATVGACK_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGACK (FK2_AGRAGIF_INV_ATVGACK_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GACK_CODE_ADJ	ATVGACK_CODE	ATVGACK	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GACK_CODE	ATVGACK_CODE	ATVGACK	(0,1)-(0,n)

Link between AGBGIFT and ATVGIFT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBGIFT and ATVGIFT (FK1_AGBGIFT_INV_ATVGIFT_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBGIFT	AGBGIFT_GIFT_CODE	ATVGIFT_CODE	ATVGIFT	(1,1)-(0,n)

Link between AGRAGDS and ATVGIFT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAGDS and ATVGIFT (FK1_AGRAGDS_INV_ATVGIFT_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGDS and ATVGIFT (FK2_AGRAGDS_INV_ATVGIFT_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGDS	AGRAGDS_GIFT_CODE	ATVGIFT_CODE	ATVGIFT	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGDS	AGRAGDS_GIFT_CODE_ADJ	ATVGIFT_CODE	ATVGIFT	(0,1)-(0,n)

Link between AGRAGIF and ATVGIFT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGIFT (FK1_AGRAGIF_INV_ATVGIFT_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGRAGIF and ATVGIFT (FK2_AGRAGIF_INV_ATVGIFT_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GIFT_CODE_ADJ	ATVGIFT_CODE	ATVGIFT	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRAGIF	AGRAGIF_GIFT_CODE	ATVGIFT_CODE	ATVGIFT	(1,1)-(0,n)

Link between AGRGDES and AGRGCAM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRGDES and AGRGCAM (FK1_AGRGDES_INV_AGRGCAM_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRGDES	AGRGDES_PIDM	AGRGCAM_PIDM	AGRGCAM	(1,1)-(0,n)
AGRGDES	AGRGDES_GIFT_NO	AGRGCAM_GIFT_NO	AGRGCAM	(1,1)-(0,n)
AGRGDES	AGRGDES_PLEDGE_NO	AGRGCAM_PLEDGE_NO	AGRGCAM	(1,1)-(0,n)
AGRGDES	AGRGDES_CAMPAIGN	AGRGCAM_CAMPAIGN	AGRGCAM	(1,1)-(0,n)

Link between AGRGSOL and AGRGCAM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRGSOL and AGRGCAM (FK1_AGRGSOL_INV_AGRGCAM_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRGSOL	AGRGSOL_PIDM	AGRGCAM_PIDM	AGRGCAM	(1,1)-(0,n)
AGRGSOL	AGRGSOL_GIFT_NO	AGRGCAM_GIFT_NO	AGRGCAM	(1,1)-(0,n)
AGRGSOL	AGRGSOL_PLEDGE_NO	AGRGCAM_PLEDGE_NO	AGRGCAM	(1,1)-(0,n)
AGRGSOL	AGRGSOL_CAMPAIGN	AGRGCAM_CAMPAIGN	AGRGCAM	(1,1)-(0,n)