Model Campaign*

Model Label :

List of Objects

Object Name	Object Type	Layer Name
AFBCAMP	SQL Table	Default
AFRCOMT	SQL Table	Default
AFRCORG	SQL Table	Default
AFRCSOL	SQL Table	Default
AFRCTYP	SQL Table	Default
AFRDESG	SQL Table	Default
AFREXPN	SQL Table	Default
AFRMAIL	SQL Table	Default
AGBWPLG	SQL Table	Default
AGRGCAM	SQL Table	Default
AGRGDES	SQL Table	Default
AGRGHDE	SQL Table	Default
AGRGSOL	SQL Table	Default
AGRPCAM	SQL Table	Default
AGRPDES	SQL Table	Default
AGRPSOL	SQL Table	Default
APRCHIS	SQL Table	Default
ATVCMTP	SQL Table	Default
AXRMDES	SQL Table	Default

Model View

Table AFBCAMP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AFBCAMP_CAMPAIGN	VARCHAR2(5)	No	*	*
AFBCAMP_NAME	VARCHAR2(30)	No
AFBCAMP_CMTP_CODE	VARCHAR2(2)	No		*
AFBCAMP_EST_DATE	DATE	Yes
AFBCAMP_END_DATE	DATE	Yes
AFBCAMP_GOAL	NUMBER(17,2)	Yes
AFBCAMP_DEFAULT_DESG	VARCHAR2(10)	Yes
AFBCAMP_ASSOC_IND	VARCHAR2(1)	Yes
AFBCAMP_PURGED_IND	VARCHAR2(1)	Yes
AFBCAMP_ACTIVITY_DATE	DATE	No
AFBCAMP_WEB_GIFT_IND	VARCHAR2(1)	Yes
AFBCAMP_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFBCAMP_CMTP_CODE	ATVCMTP_CODE	ATVCMTP
AFBCAMP_CAMPAIGN	AGRGDES_CAMPAIGN	AGRGDES

Index

Index Name	Index Type	Column Name
AFBCAMP_CMTP_INDEX		AFBCAMP_CMTP_CODE
PK_AFBCAMP	Unique	AFBCAMP_CAMPAIGN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCOMT	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRCORG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRCSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRCTYP	SQL Table	S10B80.ALUMNI	Join
AFRDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFREXPN	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRMAIL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGCAM	SQL Table	S10B80.ALUMNI	Join
AGRGHDE	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGSOL	SQL Table	S10B80.ALUMNI	Join
AGRPDES	SQL Table	S10B80.ALUMNI	Join
AGRPSOL	SQL Table	S10B80.ALUMNI	Join
APRCHIS	SQL Table	S10B80.ALUMNI	Join
AXRMDES	SQL Table	S10B80.ALUMNI	Join
AFVCAMG	SQL View	S10B80.BANINST1	Use (select)
AFVCAMO	SQL View	S10B80.BANINST1	Use (select)
AFVCMP1	SQL View	S10B80.BANINST1	Use (select)
AFVCTFY	SQL View	S10B80.BANINST1	Use (select)
AFVCTMG	SQL View	S10B80.BANINST1	Use (select)
AFVCTMO	SQL View	S10B80.BANINST1	Use (select)
AGVGFD1	SQL View	S10B80.BANINST1	Use (select)
AGVGFD2	SQL View	S10B80.BANINST1	Join
AGVGLST	SQL View	S10B80.BANINST1	Use (select)
AGVGMD1	SQL View	S10B80.BANINST1	Use (select)
AGVGMEM	SQL View	S10B80.BANINST1	Join
AGVGSOL	SQL View	S10B80.BANINST1	Use (select)
AGVPINS	SQL View	S10B80.BANINST1	Use (select)
AGVPLD1	SQL View	S10B80.BANINST1	Use (select)
AGVPLD2	SQL View	S10B80.BANINST1	Join
AGVPLST	SQL View	S10B80.BANINST1	Use (select)
AGVPSOL	SQL View	S10B80.BANINST1	Use (select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
AFBCAMP_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPSRC	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKPLDG	Rely On
ASSIGN_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKVOPP	Rely On
CAMPAIGN_GIFT_PLEDGE_REC	Oracle Package Type	S10B80.BANINST1.BWACBREF	Rely On
CAMPAIGN_NAME_GOAL_REC	Oracle Package Type	S10B80.BANINST1.BWACBREF	Rely On
CAMPAIGN_REC	Oracle Package Type	S10B80.BANINST1.BWACBREF	Rely On
CAMPAIGN_WAIT_MATCH_REC	Oracle Package Type	S10B80.BANINST1.BWACBREF	Rely On
CAMPCHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
CAMPCHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
AFBCAMP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AFBCAMP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AFBCAMP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKNHIS	Rely On
AFBCAMP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKVOPP	Rely On
AFBCAMP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AFBCAMP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCPMT	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKNGFT	Rely On
CAMPDESG_BALANCE	Oracle Package Type	S10B80.BANINST1.BWAKCPMT	Rely On
AFBCAMPC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
AFBCAMPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AFBCAMPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
AFBCAMPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AFBCAMPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNHIS	Use (select)Rely On
AFBCAMPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)Rely On
AFBCAMPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)Rely On
AFBCAMPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AFBCAMPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)
ALLAFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
ALLAFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
ASSIGNVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
CAMPCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
CAMPDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
DEFDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
DEFDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
GIVLEVELTOTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GIVLEVELTOTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
INDIVIDSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
INSTSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
AFBCAMP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
CAMP	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
GET_CAMPAIGN_NAME_GOAL_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Rely On
GET_CAMPAIGN_NAME_GOAL_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Use (select)
P_CHECK_IF_PAYABLE	Oracle Package Procedure	S10B80.BANINST1.BWAKLIBS	Use (select)
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Use (select)
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)
F_AFBCAMP_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
F_AF_FUND	Oracle Package Function	S10B80.BANINST1.AOKWEVN	Use (select)
F_GET_ADV_CAMPAIGN	Oracle Package Function	S10B80.BANINST1.BWACXCHN	Rely On
F_GET_ADV_CAMP_EDIT	Oracle Package Function	S10B80.BANINST1.BWACXCHN	Rely On
F_GET_CAMPAIGNS	Oracle Package Function	S10B80.BANINST1.BWACBREF	Use (select)
F_GET_PREF_CAMPAIGN	Oracle Package Function	S10B80.BANINST1.BWACBREF	Rely On
F_GET_PREF_CAMPAIGN	Oracle Package Function	S10B80.BANINST1.BWACBREF	Use (select)
AFBCAMP	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
AFBCAMP_CMTP_INDEX	SQL Index	S10B80.ALUMNI	Rely On
PK_AFBCAMP	SQL Index	S10B80.ALUMNI	Rely On
AGRGDES	SQL Table	S10B80.ALUMNI	Join
ATVCMTP	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AFBCAMP

Object Dates

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

Source Code Comments

Campaign Base Table

Columns Comments for AFBCAMP_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code. When a new campaign code is added, the Campaign List Form is automatically updated.

Columns Comments for AFBCAMP_NAME (# 2)

Source Code Comments

This field specifies contains the name of the campaign.

Columns Comments for AFBCAMP_CMTP_CODE (# 3)

Source Code Comments

This field specifies the campaign type for a specific campaign.

Columns Comments for AFBCAMP_EST_DATE (# 4)

Source Code Comments

This field specifies the start date of the campaign.

Columns Comments for AFBCAMP_END_DATE (# 5)

Source Code Comments

This field specifies the end date of the campaign.

Columns Comments for AFBCAMP_GOAL (# 6)

Source Code Comments

This field specifies the dollar amount of the campaign goal.

Columns Comments for AFBCAMP_DEFAULT_DESG (# 7)

Source Code Comments

This field specifies the default designation to be used when pledges for the campaign are created.

Columns Comments for AFBCAMP_ASSOC_IND (# 8)

Source Code Comments

This field specifies whether the monies received for this campaign are used in the calculation of a constituents giving level.

Columns Comments for AFBCAMP_PURGED_IND (# 9)

Source Code Comments

This field no longer used as of release 1.7.

Columns Comments for AFBCAMP_ACTIVITY_DATE (# 10)

Source Code Comments

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

Columns Comments for AFBCAMP_WEB_GIFT_IND (# 11)

Source Code Comments

Web Gift Indicator, Y indicates that gifts for this Campaign will be accepted from the Web.

Columns Comments for AFBCAMP_WEB_PLDG_IND (# 12)

Source Code Comments

Web Pledge Indicator, Y indicates that pledges for this Campaign will be accepted from the Web.

Table AFRCOMT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AFRCOMT_CAMPAIGN	VARCHAR2(5)	No	*
AFRCOMT_SEQ_NO	NUMBER(23,20)	No
AFRCOMT_COMMENT	VARCHAR2(60)	No
AFRCOMT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCOMT_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP

Index

Index Name	Index Type	Column Name
AFRCOMT_KEY_INDEX		AFRCOMT_CAMPAIGN

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCOMT_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AFRCOMT

Object Dates

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

Source Code Comments

Campaign Comment Repeating Table

Columns Comments for AFRCOMT_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCOMT_SEQ_NO (# 2)

Source Code Comments

This field specifies the internal campaign comment sequence number.

Columns Comments for AFRCOMT_COMMENT (# 3)

Source Code Comments

This field specifies the free-form campaign comments.

Columns Comments for AFRCOMT_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table AFRCORG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AFRCORG_CAMPAIGN	VARCHAR2(5)	No	*
AFRCORG_SOLC_CODE	VARCHAR2(8)	Yes	*
AFRCORG_SOL_ORG	VARCHAR2(5)	No	*
AFRCORG_INDEX	VARCHAR2(5)	Yes
AFRCORG_SEQ_NO	VARCHAR2(5)	No
AFRCORG_LEVEL	VARCHAR2(2)	No
AFRCORG_GOAL	NUMBER(17,2)	Yes
AFRCORG_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCORG_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AFRCORG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFRCORG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
AFRCORG_KEY_INDEX	Unique	AFRCORG_CAMPAIGN
AFRCORG_KEY_INDEX	Unique	AFRCORG_SOLC_CODE
AFRCORG_KEY_INDEX	Unique	AFRCORG_SOL_ORG

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCORG_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	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.AFRCORG

Object Dates

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

Source Code Comments

Campaign Organization Repeating Table

Columns Comments for AFRCORG_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCORG_SOLC_CODE (# 2)

Source Code Comments

This field specifies the type of solicitation(s) being performed for a specific campaign.

Columns Comments for AFRCORG_SOL_ORG (# 3)

Source Code Comments

This field specifies the five character solicitor organization code associated with the fund raising efforts of a specific campaign.

Columns Comments for AFRCORG_INDEX (# 4)

Source Code Comments

This field specifies the hierarchical level of the solicitor organization.

Columns Comments for AFRCORG_SEQ_NO (# 5)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for AFRCORG_LEVEL (# 6)

Source Code Comments

This field specifies the code used to define a hierarchical level within the solicitor organization.

Columns Comments for AFRCORG_GOAL (# 7)

Source Code Comments

This field specifies the dollar amount goal of the solicitor organization for a specific campaign.

Columns Comments for AFRCORG_ACTIVITY_DATE (# 8)

Source Code Comments

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

Table AFRCSOL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AFRCSOL_CAMPAIGN	VARCHAR2(5)	No	*	*
AFRCSOL_SOLC_CODE	VARCHAR2(8)	No	*	*
AFRCSOL_GOAL	NUMBER(13,2)	Yes
AFRCSOL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCSOL_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AFRCSOL_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP

Index

Index Name	Index Type	Column Name
PK_AFRCSOL	Unique	AFRCSOL_CAMPAIGN
PK_AFRCSOL	Unique	AFRCSOL_SOLC_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AFRCSOL	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	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.AFRCSOL

Object Dates

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

Source Code Comments

Campaign Solicitation Type Repeating Table

Columns Comments for AFRCSOL_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCSOL_SOLC_CODE (# 2)

Source Code Comments

This field specifies the type of solicitation used in a specific campaign.

Columns Comments for AFRCSOL_GOAL (# 3)

Source Code Comments

This field specifies the campaign goal for each individual campaign solicitation type.

Columns Comments for AFRCSOL_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table AFRCTYP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AFRCTYP_CAMPAIGN	VARCHAR2(5)	Yes	*
AFRCTYP_SOLC_CODE	VARCHAR2(8)	Yes	*
AFRCTYP_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCTYP_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_SEQ_NO	NUMBER(5,0)	No	*
AFRCTYP_CONSTITUENT_PIDM	NUMBER(8,0)	Yes
AFRCTYP_ACTIVITY_DATE	DATE	No
AFRCTYP_USER	VARCHAR2(30)	No
AFRCTYP_RATE_CODE	VARCHAR2(2)	Yes	*
AFRCTYP_RSCR_CODE	VARCHAR2(5)	Yes	*
AFRCTYP_RATER_PIDM	NUMBER(8,0)	Yes
AFRCTYP_ASK_AMOUNT	NUMBER(11,2)	Yes
AFRCTYP_ASK_DATE	DATE	Yes
AFRCTYP_COMMENT	VARCHAR2(2000)	Yes
AFRCTYP_ASSIGN_DATE	DATE	Yes
AFRCTYP_DCYR_CODE	NUMBER(4,0)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCTYP_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
AFRCTYP_RATE_CODE	ATVRATE_CODE	ATVRATE
AFRCTYP_RSCR_CODE	ATVRSCR_CODE	ATVRSCR
AFRCTYP_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AFRCTYP_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AFRCTYP_PIDM	AFRCRES_PIDM	AFRCRES
AFRCTYP_SEQ_NO	AFRCRES_CTYP_SEQ_NO	AFRCRES
AFRCTYP_PIDM	ASRSORG_PIDM	ASRSORG
AFRCTYP_SOL_ORG	ASRSORG_SOL_ORG	ASRSORG
AFRCTYP_SOLC_CODE	AFRCSLT_SOLC_CODE	AFRCSLT
AFRCTYP_SOL_ORG	AFRCSLT_SOL_ORG	AFRCSLT
AFRCTYP_PIDM	AFRCSLT_PIDM	AFRCSLT
AFRCTYP_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP

Index

Index Name	Index Type	Column Name
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_CAMPAIGN
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_SOLC_CODE
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_SOL_ORG
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_PIDM
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_SEQ_NO
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_DCYR_CODE
AFRCTYP_KEY_INDEX2		AFRCTYP_PIDM
AFRCTYP_KEY_INDEX3		AFRCTYP_CONSTITUENT_PIDM
AFRCTYP_KEY_INDEX4		AFRCTYP_SOL_ORG
AFRCTYP_KEY_INDEX4		AFRCTYP_DCYR_CODE
AFRCTYP_KEY_INDEX4		AFRCTYP_PIDM
AFRCTYP_KEY_INDEX4		AFRCTYP_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SPRIDEN	SQL Table	S10B80.SATURN	Join
APVCTYP	SQL View	S10B80.BANINST1	Use (select)
APVSRES	SQL View	S10B80.BANINST1	Use (select)
ASVASCT	SQL View	S10B80.BANINST1	Use (select)
ASVCCMP	SQL View	S10B80.BANINST1	Use (select)
ASVCYER	SQL View	S10B80.BANINST1	Use (select)
AFRCTYP_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKVOPP	Rely On
ASSIGN_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKVOPP	Rely On
CONTACT_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKVOPP	Rely On
DCYR_CODE_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPSRC	Rely On
AFRCTYP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AFBCAMPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
AFRCTYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
ASSIGNVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
CONTACTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
DCYRCODEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
RATECODEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
SOLCCODEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
SOLORGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
AFRCTYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
F_CAMP_CONTACTS_ASSIGNED	Oracle Package Function	S10B80.BANINST1.ASKSIGN	Use (select)
F_YEAR_CONTACTS_ASSIGNED	Oracle Package Function	S10B80.BANINST1.ASKSIGN	Use (select)
AFRCTYP	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
AFRCTYP_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AFRCTYP_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AFRCTYP_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
AFRCTYP_KEY_INDEX4	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AFRCRES	SQL Table	S10B80.ALUMNI	Join
AFRCSLT	SQL Table	S10B80.ALUMNI	Join
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSORG	SQL Table	S10B80.ALUMNI	Join
ATVDCYR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVRATE	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVRSCR	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.AFRCTYP

Object Dates

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

Source Code Comments

Campaign Contact Repeating Table

Columns Comments for AFRCTYP_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCTYP_SOLC_CODE (# 2)

Source Code Comments

This field specifies the type of solicitations used for the campaign.

Columns Comments for AFRCTYP_SOL_ORG (# 3)

Source Code Comments

This field specifies the type of solicitor organization code.

Columns Comments for AFRCTYP_PIDM (# 4)

Source Code Comments

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

Columns Comments for AFRCTYP_SEQ_NO (# 5)

Source Code Comments

This field identifies the internal sequence number of the solicitor.

Columns Comments for AFRCTYP_CONSTITUENT_PIDM (# 6)

Source Code Comments

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

Columns Comments for AFRCTYP_ACTIVITY_DATE (# 7)

Source Code Comments

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

Columns Comments for AFRCTYP_USER (# 8)

Source Code Comments

User ID of the user that created or last updated the record

Columns Comments for AFRCTYP_RATE_CODE (# 9)

Source Code Comments

Rating code given the contact by the rater.

Columns Comments for AFRCTYP_RSCR_CODE (# 10)

Source Code Comments

Rater type code for the person rating the contact.

Columns Comments for AFRCTYP_RATER_PIDM (# 11)

Source Code Comments

Internal ID of the person rating the contact.

Columns Comments for AFRCTYP_ASK_AMOUNT (# 12)

Source Code Comments

Amount the solicitor asked the contact to give or pledge

Columns Comments for AFRCTYP_ASK_DATE (# 13)

Source Code Comments

Date that the solicitor asked the contact to commit to.

Columns Comments for AFRCTYP_COMMENT (# 14)

Source Code Comments

2000 Character free-form comment associated with the contact.

Columns Comments for AFRCTYP_ASSIGN_DATE (# 15)

Source Code Comments

Date that the contact was assigned to the solicitor.

Columns Comments for AFRCTYP_DCYR_CODE (# 16)

Source Code Comments

Year for which the solicitation should be made, may be blank.

Table AFRDESG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AFRDESG_CAMPAIGN	VARCHAR2(5)	No	*	*
AFRDESG_DESG	VARCHAR2(10)	No	*	*
AFRDESG_GOAL	NUMBER(13,2)	Yes
AFRDESG_AMT_PLEDGED	NUMBER(13,2)	Yes
AFRDESG_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
AFRDESG_AMT_GIFT	NUMBER(13,2)	Yes
AFRDESG_ACTIVITY_DATE	DATE	No
AFRDESG_DSTA_CODE	VARCHAR2(1)	Yes		*
AFRDESG_WEB_GIFT_IND	VARCHAR2(1)	Yes
AFRDESG_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRDESG_DSTA_CODE	ATVDSTA_CODE	ATVDSTA
AFRDESG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFRDESG_DESG	ADBDESG_DESG	ADBDESG
AFRDESG_CAMPAIGN	AGRPDES_CAMPAIGN	AGRPDES
AFRDESG_DESG	AGRPDES_DESG	AGRPDES

Index

Index Name	Index Type	Column Name
PK_AFRDESG	Unique	AFRDESG_CAMPAIGN
PK_AFRDESG	Unique	AFRDESG_DESG

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKPLDG	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCPMT	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKNGFT	Rely On
AFRDESGC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)
ALLAFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
ALLAFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
DEFDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
DEFDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
P_GIVINGSUMMARY	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (update)
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
AFRDESG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
GET_GIFT_PLEDGE_AMTS_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Rely On
GET_GIFT_PLEDGE_AMTS_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Use (select)
P_CHECK_IF_PAYABLE	Oracle Package Procedure	S10B80.BANINST1.BWAKLIBS	Use (select)
F_AFRDESG_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
AFRDESG	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_AFRDESG	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPDES	SQL Table	S10B80.ALUMNI	Join
ATVDSTA	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AFRDESG

Object Dates

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

Source Code Comments

Designation In Campaign Repeating Table

Columns Comments for AFRDESG_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRDESG_DESG (# 2)

Source Code Comments

This field specifies the designations that are associated with a specific campaign.

Columns Comments for AFRDESG_GOAL (# 3)

Source Code Comments

This field contains the dollar amount goal of the designation associated with a specific campaign.

Columns Comments for AFRDESG_AMT_PLEDGED (# 4)

Source Code Comments

This field specifies the amount of pledges associated with the designation.

Columns Comments for AFRDESG_AMT_PLEDGED_PAID (# 5)

Source Code Comments

This field identifies the amount of pledge payments for the designation.

Columns Comments for AFRDESG_AMT_GIFT (# 6)

Source Code Comments

This field identifies the amount of gifts and pledge payments for the designation.

Columns Comments for AFRDESG_ACTIVITY_DATE (# 7)

Source Code Comments

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

Columns Comments for AFRDESG_DSTA_CODE (# 8)

Source Code Comments

Designation Status Code indicates the status of the designation.

Columns Comments for AFRDESG_WEB_GIFT_IND (# 9)

Source Code Comments

Web Gift Indicator, Y indicates that gifts for this Campaign and Designation will be accepted from the Web.

Columns Comments for AFRDESG_WEB_PLDG_IND (# 10)

Source Code Comments

Web Pledge Indicator, Y indicates that pledges for this Campaign and Desgination will be accepted from the Web.

Table AFREXPN

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AFREXPN_CAMPAIGN	VARCHAR2(5)	No	*	*
AFREXPN_SEQ_NO	NUMBER(5,0)	No	*
AFREXPN_EXPN_CODE	VARCHAR2(2)	No		*
AFREXPN_REASON	VARCHAR2(30)	No
AFREXPN_EXPN_DATE	DATE	Yes
AFREXPN_AMT	NUMBER(11,2)	Yes
AFREXPN_CHECK_NO	VARCHAR2(10)	Yes
AFREXPN_FISC_CODE	NUMBER(4,0)	Yes		*
AFREXPN_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFREXPN_FISC_CODE	ATVFISC_CODE	ATVFISC
AFREXPN_EXPN_CODE	GTVEXPN_CODE	GTVEXPN
AFREXPN_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP

Index

Index Name	Index Type	Column Name
PK_AFREXPN	Unique	AFREXPN_CAMPAIGN
PK_AFREXPN	Unique	AFREXPN_SEQ_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AFREXPN	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVEXPN	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AFREXPN

Object Dates

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

Source Code Comments

Campaign Expense Repeating Table

Columns Comments for AFREXPN_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFREXPN_SEQ_NO (# 2)

Source Code Comments

This field specifies the internal sequence number for campaign expenses.

Columns Comments for AFREXPN_EXPN_CODE (# 3)

Source Code Comments

This field specifies the expense code of the campaign expense.

Columns Comments for AFREXPN_REASON (# 4)

Source Code Comments

This field specifies the expense code description of the campaign expense.

Columns Comments for AFREXPN_EXPN_DATE (# 5)

Source Code Comments

This field specifies the date of the campaign expense.

Columns Comments for AFREXPN_AMT (# 6)

Source Code Comments

This field specifies the amount of the campaign expense.

Columns Comments for AFREXPN_CHECK_NO (# 7)

Source Code Comments

This field specifies the check number of the campaign expense.

Columns Comments for AFREXPN_FISC_CODE (# 8)

Source Code Comments

This field specifies the fiscal year of the campaign expense.

Columns Comments for AFREXPN_ACTIVITY_DATE (# 9)

Source Code Comments

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

Table AFRMAIL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AFRMAIL_CAMPAIGN	VARCHAR2(5)	No	*	*
AFRMAIL_MAIL_CODE	VARCHAR2(3)	No	*	*
AFRMAIL_ACTIVITY_DATE	DATE	No
AFRMAIL_MAIL_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRMAIL_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFRMAIL_MAIL_CODE	GTVMAIL_CODE	GTVMAIL

Index

Index Name	Index Type	Column Name
PK_AFRMAIL	Unique	AFRMAIL_CAMPAIGN
PK_AFRMAIL	Unique	AFRMAIL_MAIL_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AFRMAIL	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVMAIL	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AFRMAIL

Object Dates

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

Source Code Comments

Campaign Mail Code Repeating Table

Columns Comments for AFRMAIL_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRMAIL_MAIL_CODE (# 2)

Source Code Comments

This field specifies the type of mailings to be used with the associated campaign.

Columns Comments for AFRMAIL_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for AFRMAIL_MAIL_DATE (# 4)

Source Code Comments

This field indicates the date the item was mailed.

Table AGBWPLG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AGBWPLG_PIDM	NUMBER(8,0)	No
AGBWPLG_AMOUNT	NUMBER(11,2)	No
AGBWPLG_PLDG_DATE	DATE	No
AGBWPLG_CAMPAIGN	VARCHAR2(5)	No	*
AGBWPLG_DESG	VARCHAR2(10)	No	*
AGBWPLG_ACTIVITY_DATE	DATE	No
AGBWPLG_USER	VARCHAR2(30)	No
AGBWPLG_ACCEPTED_IND	VARCHAR2(1)	No
AGBWPLG_PLDG_CODE	VARCHAR2(2)	Yes	*
AGBWPLG_PGVE_CODE	VARCHAR2(5)	Yes	*
AGBWPLG_SOLC_CODE	VARCHAR2(8)	Yes	*
AGBWPLG_SOL_ORG	VARCHAR2(5)	Yes	*
AGBWPLG_DCYR_CODE	NUMBER(4,0)	Yes	*
AGBWPLG_SOLICITOR_PIDM	NUMBER(8,0)	Yes
AGBWPLG_SPS_SPLIT_IND	VARCHAR2(1)	Yes
AGBWPLG_PDUR_CODE	VARCHAR2(1)	Yes	*
AGBWPLG_FREQ_CODE	VARCHAR2(2)	Yes	*
AGBWPLG_BILL_DATE	DATE	Yes
AGBWPLG_COMMENT	VARCHAR2(300)	Yes
AGBWPLG_CAMPAIGN_2	VARCHAR2(5)	Yes	*
AGBWPLG_DESIGNATION_2	VARCHAR2(10)	Yes	*
AGBWPLG_CAMPAIGN_3	VARCHAR2(5)	Yes	*
AGBWPLG_DESIGNATION_3	VARCHAR2(10)	Yes	*
AGBWPLG_AMOUNT_2	NUMBER(11,2)	Yes
AGBWPLG_AMOUNT_3	NUMBER(11,2)	Yes
AGBWPLG_SCNT_CODE	VARCHAR2(3)	Yes	*
AGBWPLG_SCRS_CODE	VARCHAR2(3)	Yes	*
AGBWPLG_ASK_AMOUNT	NUMBER(11,2)	Yes
AGBWPLG_ASK_DATE	DATE	Yes
AGBWPLG_LETR_CODE	VARCHAR2(15)	Yes	*
AGBWPLG_PLDG_PRMD_CODE	VARCHAR2(2)	Yes
AGBWPLG_PINS_PRMD_CODE	VARCHAR2(2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBWPLG_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBWPLG_LETR_CODE	GTVLETR_CODE	GTVLETR
AGBWPLG_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AGBWPLG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
AGBWPLG_FREQ_CODE	ATVFREQ_CODE	ATVFREQ
AGBWPLG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGBWPLG_CAMPAIGN_3	AFBCAMP_CAMPAIGN	AFBCAMP
AGBWPLG_CAMPAIGN_2	AFBCAMP_CAMPAIGN	AFBCAMP
AGBWPLG_PLDG_CODE	ATVPLDG_CODE	ATVPLDG
AGBWPLG_PDUR_CODE	ATVPDUR_CODE	ATVPDUR
AGBWPLG_SCNT_CODE	ATVSCNT_CODE	ATVSCNT
AGBWPLG_SCRS_CODE	ATVSCRS_CODE	ATVSCRS
AGBWPLG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AGBWPLG_DESG	ADBDESG_DESG	ADBDESG
AGBWPLG_DESIGNATION_3	ADBDESG_DESG	ADBDESG
AGBWPLG_DESIGNATION_2	ADBDESG_DESG	ADBDESG

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_INSERT_THE_PLEDGE	Oracle Package Procedure	S10B80.BANINST1.BWAKPLDG	Use (Insert)
AGBWPLG	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
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCYR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVFREQ	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPDUR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPGVE	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSCNT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSCRS	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSOLC	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBWPLG

Object Dates

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

Source Code Comments

Web Pledge Header Table. Collects information for pledges from the Web.

Columns Comments for AGBWPLG_PIDM (# 1)

Source Code Comments

Internal ID of the Web user making the pledge.

Columns Comments for AGBWPLG_AMOUNT (# 2)

Source Code Comments

Amount of the pledge.

Columns Comments for AGBWPLG_PLDG_DATE (# 3)

Source Code Comments

Date the pledge was entered via the Web.

Columns Comments for AGBWPLG_CAMPAIGN (# 4)

Source Code Comments

The first Campaign to which the pledge was made.

Columns Comments for AGBWPLG_DESG (# 5)

Source Code Comments

The first Designation to which the pledge was made.

Columns Comments for AGBWPLG_ACTIVITY_DATE (# 6)

Source Code Comments

The date this record was added or last modified.

Columns Comments for AGBWPLG_USER (# 7)

Source Code Comments

The user who added or last modified this record.

Columns Comments for AGBWPLG_ACCEPTED_IND (# 8)

Source Code Comments

Accepted Indicator, Y indicates the pledge has been reviewed and accepted.

Columns Comments for AGBWPLG_PLDG_CODE (# 9)

Source Code Comments

The pledge code to be associated with the pledge.

Columns Comments for AGBWPLG_PGVE_CODE (# 10)

Source Code Comments

The Pledge Giving Vehicle Code to be associated eith the pledge.

Columns Comments for AGBWPLG_SOLC_CODE (# 11)

Source Code Comments

The Solicitation Code to be associated with the pledge.

Columns Comments for AGBWPLG_SOL_ORG (# 12)

Source Code Comments

The SOlicitor Organization to be associated with the pledge.

Columns Comments for AGBWPLG_DCYR_CODE (# 13)

Source Code Comments

The Gift Society Year to be associated with the pledge.

Columns Comments for AGBWPLG_SOLICITOR_PIDM (# 14)

Source Code Comments

The Internal ID of the Solicitor to be associated with the pledge.

Columns Comments for AGBWPLG_SPS_SPLIT_IND (# 15)

Source Code Comments

Spouse Split Indicator, Y indicates that the pledge should be split with the spouse

Columns Comments for AGBWPLG_PDUR_CODE (# 16)

Source Code Comments

The Pledge Duration code to be associated with the pledge.

Columns Comments for AGBWPLG_FREQ_CODE (# 17)

Source Code Comments

The Frequency Code to be associated with the pledge.

Columns Comments for AGBWPLG_BILL_DATE (# 18)

Source Code Comments

The date the first installment will be due.

Columns Comments for AGBWPLG_COMMENT (# 19)

Source Code Comments

Free-form text containing information abnout the pledge.

Columns Comments for AGBWPLG_CAMPAIGN_2 (# 20)

Source Code Comments

The second Campaign to which the pledge was made.

Columns Comments for AGBWPLG_DESIGNATION_2 (# 21)

Source Code Comments

The second Designation to which the pledge was made.

Columns Comments for AGBWPLG_CAMPAIGN_3 (# 22)

Source Code Comments

The third Campaign to which the pledge was made.

Columns Comments for AGBWPLG_DESIGNATION_3 (# 23)

Source Code Comments

The third Designation to which the pledge was made.

Columns Comments for AGBWPLG_SCNT_CODE (# 26)

Source Code Comments

Type of solicitation contact used to contact a specific constituent.

Columns Comments for AGBWPLG_SCRS_CODE (# 27)

Source Code Comments

Type of response from the constituent for a specific solicitation.

Columns Comments for AGBWPLG_ASK_AMOUNT (# 28)

Source Code Comments

Amount that the contact was asked to contribute during this contact.

Columns Comments for AGBWPLG_ASK_DATE (# 29)

Source Code Comments

Date to which the solicitor asked the contact to commit.

Columns Comments for AGBWPLG_LETR_CODE (# 30)

Source Code Comments

Letter sent to the contact

Columns Comments for AGBWPLG_PLDG_PRMD_CODE (# 31)

Source Code Comments

Pledge Header pledge reminder code; this field will be stored on the agbpldg record when a pledge is created via the AGAWPLG form.

Columns Comments for AGBWPLG_PINS_PRMD_CODE (# 32)

Source Code Comments

Pledge Installment pledge reminder code; this field will be stored on the agrpins record when a pledge with installments is created via the AGAWPLG form.

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 AGRGHDE

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AGRGHDE_ID	VARCHAR2(9)	No	*
AGRGHDE_GIFT_NO	VARCHAR2(7)	No	*
AGRGHDE_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGHDE_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGHDE_DESG	VARCHAR2(10)	No	*	*
AGRGHDE_AMT	NUMBER(11,2)	No
AGRGHDE_ACTIVITY_DATE	DATE	No
AGRGHDE_USER	VARCHAR2(30)	No
AGRGHDE_PIDM	NUMBER(8,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGHDE_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGRGHDE_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_AGRGHDE	Unique	AGRGHDE_ID
PK_AGRGHDE	Unique	AGRGHDE_GIFT_NO
PK_AGRGHDE	Unique	AGRGHDE_PLEDGE_NO
PK_AGRGHDE	Unique	AGRGHDE_CAMPAIGN
PK_AGRGHDE	Unique	AGRGHDE_DESG

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
CAMP_DESG_REC	Oracle Package Type	S10B80.BANINST1.AGKGIFT	Rely On
AGRGHDEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNHIS	Use (select)Rely On
P_INSERT_GIFT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Use (Insert)
AGRGHDE_REC	Oracle Package Variable	S10B80.BANINST1.BWAKNHIS	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Use (select)
AGRGHDE	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_AGRGHDE	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGHDE

Object Dates

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

Source Code Comments

Web Gift Detail Hold Table.

Columns Comments for AGRGHDE_ID (# 1)

Source Code Comments

Web ID created by a user not found in Banner.

Columns Comments for AGRGHDE_GIFT_NO (# 2)

Source Code Comments

Gift number of gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_PLEDGE_NO (# 3)

Source Code Comments

Pledge Number associated with gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_CAMPAIGN (# 4)

Source Code Comments

Campaign Code of gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_DESG (# 5)

Source Code Comments

Designation Code of gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_AMT (# 6)

Source Code Comments

Designation amount of gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_ACTIVITY_DATE (# 7)

Source Code Comments

Date the gift was created or changed.

Columns Comments for AGRGHDE_USER (# 8)

Source Code Comments

User who created or changed the gift information.

Columns Comments for AGRGHDE_PIDM (# 9)

Source Code Comments

Intenal ID of user who created the gift, once user id given an ID in Banner.

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 AGRPCAM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPDES	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVPCAM	SQL View	S10B80.BANINST1	Use (select)
P_UPDATE_AGRPCAM	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATE_AGRPCAM	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (update)
GET_DONORS_COUNT_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
AGRPCAM	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPCAM_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRPCAM	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPCAM

Object Dates

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

Source Code Comments

Pledge Campaign Repeating Table

Columns Comments for AGRPCAM_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGRPCAM_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPCAM_CAMPAIGN (# 3)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRPCAM_AMT (# 4)

Source Code Comments

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

Columns Comments for AGRPCAM_AMT_PAID (# 5)

Source Code Comments

This field specifies the amount paid toward the pledge.

Columns Comments for AGRPCAM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table AGRPDES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRDESG	SQL Table	S10B80.ALUMNI	Join
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGVPCRD	SQL View	S10B80.BANINST1	Use (select)
AGVPINS	SQL View	S10B80.BANINST1	Use (select)
AGVPLD2	SQL View	S10B80.BANINST1	Use (select)
AGVPLST	SQL View	S10B80.BANINST1	Use (select)
AGVPMEM	SQL View	S10B80.BANINST1	Use (select)
AGVPMLT	SQL View	S10B80.BANINST1	Use (select)
AGVPSCR	SQL View	S10B80.BANINST1	Use (select)
AGVPSFT	SQL View	S10B80.BANINST1	Use (select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.AGKGIFT	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKLIBS	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKCPRF	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKGIFT	Rely On
BALANCE_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPPRF	Rely On
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
CAMPDESG_BALANCE	Oracle Package Type	S10B80.BANINST1.BWAKCPMT	Rely On
AGRPDESC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
AGRPDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)
BALANCEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)
CAMPDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
P_PLPAYCAMPDESG	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATEPLEDGESTATUS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATE_AGRPDES	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_UPDATE_AGRPDES	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (update)
AGRPDES_REC	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
CAMP	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
DESG	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
P_CHECK_IF_PAYABLE	Oracle Package Procedure	S10B80.BANINST1.BWAKLIBS	Use (select)
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
P_GIFT_BY_FISCAL_YR	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
P_PLEDGE_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Rely On
F_CALC_PDES_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Use (select)
F_CALC_PINS_AMT	Oracle Package Function	S10B80.BANINST1.AGKCPAP	Use (select)
AGRPDES	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPDES_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRPDES	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Join
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGRGDES	SQL Table	S10B80.ALUMNI	Join
AGRPCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPMLT	SQL Table	S10B80.ALUMNI	Join
AGRPMMO	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPDES

Object Dates

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

Source Code Comments

Pledge Designation Repeating Table

Columns Comments for AGRPDES_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGRPDES_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPDES_CAMPAIGN (# 3)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRPDES_DESG (# 4)

Source Code Comments

This field specifies the designation code associated with the campaign.

Columns Comments for AGRPDES_AMT (# 5)

Source Code Comments

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

Columns Comments for AGRPDES_AMT_PAID (# 6)

Source Code Comments

This field specifies the amount paid toward the pledge designation.

Columns Comments for AGRPDES_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table AGRPSOL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AXRMSOL	SQL Table	S10B80.ALUMNI	Join
AGVPLD1	SQL View	S10B80.BANINST1	Use (select)
AGVPSOL	SQL View	S10B80.BANINST1	Use (select)
F_PLEDGE_SOLICITOR	SQL Function	S10B80.BANINST1	Use (select)
F_PLEDGE_SOLICITOR_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_PLEDGE_SOLICITOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
AGRPSOL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRPSOL_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGRPSOL_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGRPCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSOLC	SQL Table	S10B80.ALUMNI	Refer (no action)
A$_AGRPSOL_EXPMG_UPD_TRG	SQL Trigger	S10B80.ALUMNI	Fire (Insert,update,delete,after,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPSOL

Object Dates

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

Source Code Comments

Pledge Solicitor Repeating Table

Columns Comments for AGRPSOL_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRPSOL_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned pledge number.

Columns Comments for AGRPSOL_CAMPAIGN (# 3)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRPSOL_SOLC_CODE (# 4)

Source Code Comments

This field specifies the solicitation code.

Columns Comments for AGRPSOL_SOL_ORG (# 5)

Source Code Comments

This field specifies the solicitor organization code.

Columns Comments for AGRPSOL_SOL_PIDM (# 6)

Source Code Comments

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

Columns Comments for AGRPSOL_AMT (# 7)

Source Code Comments

This field specifies the amount of the pledge.

Columns Comments for AGRPSOL_AMT_PAID (# 8)

Source Code Comments

This field specifies the amount paid toward the pledge.

Columns Comments for AGRPSOL_ACTIVITY_DATE (# 9)

Source Code Comments

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

Columns Comments for AGRPSOL_CREDIT_PIDM (# 10)

Source Code Comments

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

Table APRCHIS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRCHIS_PIDM	NUMBER(8,0)	No	*
APRCHIS_CAMPAIGN	VARCHAR2(5)	No	*	*
APRCHIS_FISC_CODE	NUMBER(4,0)	No	*	*
APRCHIS_AMT_PLEDGED	NUMBER(13,2)	Yes
APRCHIS_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
APRCHIS_AMT_GIFT	NUMBER(13,2)	Yes
APRCHIS_AMT_MEMO	NUMBER(13,2)	Yes
APRCHIS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRCHIS_FISC_CODE	ATVFISC_CODE	ATVFISC
APRCHIS_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP

Index

Index Name	Index Type	Column Name
APRCHIS_KEY_INDEX2		APRCHIS_FISC_CODE
APRCHIS_KEY_INDEX2		APRCHIS_PIDM
APRCHIS_KEY_INDEX3		APRCHIS_CAMPAIGN
PK_APRCHIS	Unique	APRCHIS_PIDM
PK_APRCHIS	Unique	APRCHIS_CAMPAIGN
PK_APRCHIS	Unique	APRCHIS_FISC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APBCONS	SQL Table	S10B80.ALUMNI	Join
APRCSPS	SQL Table	S10B80.ALUMNI	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
AFVCMP1	SQL View	S10B80.BANINST1	Use (select)
AFVCTFY	SQL View	S10B80.BANINST1	Use (select)
AGVCHIS	SQL View	S10B80.BANINST1	Use (select)
AGVFGIV	SQL View	S10B80.BANINST1	Use (select)
AGVFISC	SQL View	S10B80.BANINST1	Use (select)
F_CAMPAIGN_GIVING	SQL Function	S10B80.BANINST1	Use (select)
F_DONOR_IND	SQL Function	S10B80.BANINST1	Use (select)
F_LIFE_TOTAL_COMMITMENT	SQL Function	S10B80.BANINST1	Use (select)
F_LIFE_TOTAL_GIVING	SQL Function	S10B80.BANINST1	Use (select)
F_LIFE_TOTAL_PLEDGED_AMOUNT	SQL Function	S10B80.BANINST1	Use (select)
F_LIFE_TOTAL_PLEDGE_PAYMENT	SQL Function	S10B80.BANINST1	Use (select)
F_SPOUSE_CAMP_GIVING_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_GIVING_YEAR	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)
CAMPCHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
CAMPCHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
FISCHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
FISCHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
APRCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKLIBS	Use (select)Rely On
APRCHIS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
APRCHIS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPSRC	Rely On
APRCHIS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKLIBS	Rely On
APRCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKSRCH	Use (select)Rely On
APRCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
APRCHIS_1	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
APRCHIS_1	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
CAMPCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CAMPCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
CHIS_CURSOR	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CHIS_CURSOR	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
COMCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
COMCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
CONTACTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
CONTACTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
FISCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
FISCHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GIVLEVELTOTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GIVLEVELTOTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
XREF_CHIS_CURSOR	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
XREF_CHIS_CURSOR	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
P_APRCHIS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_APRCHIS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,update,select)
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)
APRCHIS	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
APRCHIS_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
APRCHIS_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_APRCHIS	SQL Index	S10B80.ALUMNI	Rely On
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRCHIS

Object Dates

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

Source Code Comments

Giving History By Campaign Repeating Table

Columns Comments for APRCHIS_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRCHIS_CAMPAIGN (# 2)

Source Code Comments

This field specifies the campaign(s) the constituent has responded to with a gift or pledge payment.

Columns Comments for APRCHIS_FISC_CODE (# 3)

Source Code Comments

This field specifies the fiscal year associated with the campaign.

Columns Comments for APRCHIS_AMT_PLEDGED (# 4)

Source Code Comments

This field specifies the amount the constituent pledged to a specific campaign.

Columns Comments for APRCHIS_AMT_PLEDGED_PAID (# 5)

Source Code Comments

This field specifies the amount of pledge payments received from the constituent for a specific campaign.

Columns Comments for APRCHIS_AMT_GIFT (# 6)

Source Code Comments

This field specifies the amount of gift money received from the constituent for a specific campaign.

Columns Comments for APRCHIS_AMT_MEMO (# 7)

Source Code Comments

This field specifies the dollar amount of memo credit (soft dollars) the constituent has been credited with for a specific campaign.

Columns Comments for APRCHIS_ACTIVITY_DATE (# 8)

Source Code Comments

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

Table ATVCMTP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVCMTP	Unique	ATVCMTP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRIDRL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRSPRL	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCCT	SQL Table	S10B80.ALUMNI	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVCMTPC	Oracle Package Cursor	S10B80.BANINST1.ATKCMTP	Use (select)Rely On
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVCMTP	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVCMTP

Object Dates

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

Source Code Comments

Campaign Type Validation Table

Columns Comments for ATVCMTP_CODE (# 1)

Source Code Comments

This field specifies the code for the type of campaign.

Columns Comments for ATVCMTP_DESC (# 2)

Source Code Comments

This field specifies the description of the campaign code.

Columns Comments for ATVCMTP_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for ATVCMTP_CAPITAL_IND (# 4)

Source Code Comments

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

Table AXRMDES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AXBMGID	SQL Table	S10B80.ALUMNI	Join
A$_AGBPLDG_EXPMG_DEL_TRG	SQL Trigger	S10B80.ALUMNI	Use (delete,select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (Insert)
F_XMG_DESG_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_DESG_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AXRMDES	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AXRMDES_PIDM_INDEX	SQL Index	S10B80.ALUMNI	Rely On
PK_AXRMDES	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Join
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AXRMCAM	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AXRMDES

Object Dates

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

Source Code Comments

Expected Matching Gift Designation repeating table.

Columns Comments for AXRMDES_PIDM (# 1)

Source Code Comments

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

Columns Comments for AXRMDES_EMPR_PIDM (# 2)

Source Code Comments

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

Columns Comments for AXRMDES_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AXRMDES_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AXRMDES_DESG (# 5)

Source Code Comments

This field specifies the ten character alphanumeric designation code.

Columns Comments for AXRMDES_AMT (# 6)

Source Code Comments

This field specifies the amount of the designation.

Columns Comments for AXRMDES_ACTIVITY_DATE (# 7)

Source Code Comments

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

Link between AGRGSOL and AFBCAMP

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVGSOL

Link List

Link Type	Link	Project
Join	Link Between AGRGSOL and AFBCAMP	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGSOL	AFBCAMP

Link between AFBCAMP and AGRGDES

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVGLST scope-procedure : S10B80.BANINST1.BWAKGIFT.P_DONATION_RECEIPT

Link List

Link Type	Link	Project
Join	Link Between AFBCAMP and AGRGDES	ALUMNI

List of Real links

Link type	Between	And
Join	AFBCAMP	AGRGDES

Link between AGRPDES and AFBCAMP

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVPINS schema-view : S10B80.BANINST1.AGVPLST schema-view : S10B80.BANINST1.AXVPINS scope-cursor : S10B80.BANINST1.BWAKCPMT.CAMPDESGVIEWC

Link List

Link Type	Link	Project
Join	Link Between AGRPDES and AFBCAMP	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPDES	AFBCAMP

Link between AGRPSOL and AFBCAMP

Join Information

Objects list
schema-view : S10B80.BANINST1.AGVPSOL

Link List

Link Type	Link	Project
Join	Link Between AGRPSOL and AFBCAMP	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPSOL	AFBCAMP

Link between AXRMDES and AFBCAMP

Join Information

Objects list
schema-view : S10B80.BANINST1.AXVPINS

Link List

Link Type	Link	Project
Join	Link Between AXRMDES and AFBCAMP	ALUMNI

List of Real links

Link type	Between	And
Join	AXRMDES	AFBCAMP

Link between APRCHIS and AFBCAMP

Join Information

Objects list
schema-view : S10B80.BANINST1.AFVCTFY schema-view : S10B80.BANINST1.AFVCMP1 scope-cursor : S10B80.BANINST1.BWAKCHIS.CAMPCHISVIEWC scope-cursor : S10B80.BANINST1.BWDKGHIS.CAMPCHISVIEWC

Link List

Link Type	Link	Project
Join	Link Between APRCHIS and AFBCAMP	ALUMNI

List of Real links

Link type	Between	And
Join	APRCHIS	AFBCAMP

Link between AGRGCAM and AFBCAMP

Join Information

Objects list
scope-function : S10B80.BANINST1.AOKWEVN.F_AF_FUND

Link List

Link Type	Link	Project
Join	Link Between AGRGCAM and AFBCAMP	ALUMNI

List of Real links

Link type	Between	And
Join	AGRGCAM	AFBCAMP

Link between AGRPDES and AGRGDES

Join Information

Objects list
scope-procedure : S10B80.BANINST1.AGKGIFT.P_PLEDGE_SPLIT

Link List

Link Type	Link	Project
Join	Link Between AGRPDES and AGRGDES	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPDES	AGRGDES

Link between AFRCTYP and AFBCAMP

Join Information

Objects list
scope-cursor : S10B80.BANINST1.BWAKVOPP.ASSIGNVIEWC

Link List

Link Type	Link	Project
Join	Link Between AFRCTYP and AFBCAMP	ALUMNI

List of Real links

Link type	Between	And
Join	AFRCTYP	AFBCAMP

Link between AFRDESG and AGRPDES

Join Information

Objects list
scope-procedure : S10B80.BANINST1.BWAKLIBS.P_CHECK_IF_PAYABLE

Link List

Link Type	Link	Project
Join	Link Between AFRDESG and AGRPDES	ALUMNI

List of Real links

Link type	Between	And
Join	AFRDESG	AGRPDES

Link between AGRPDES and AGRPCAM

Link List

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

Foreign Key information

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

Link between AGRPSOL and AGRPCAM

Link List

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

Foreign Key information

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

Link between AFRCOMT and AFBCAMP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCOMT and AFBCAMP (FK1_AFRCOMT_INV_AFBCAMP_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCOMT	AFRCOMT_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP	(1,1)-(0,n)

Link between AFRCORG and AFBCAMP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCORG and AFBCAMP (FK1_AFRCORG_INV_AFBCAMP_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCORG	AFRCORG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP	(1,1)-(0,n)

Link between AFRCSOL and AFBCAMP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCSOL and AFBCAMP (FK1_AFRCSOL_INV_AFBCAMP_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCSOL	AFRCSOL_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP	(1,1)-(0,n)

Link between AFRDESG and AFBCAMP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRDESG and AFBCAMP (FK1_AFRDESG_INV_AFBCAMP_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRDESG	AFRDESG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP	(1,1)-(0,n)

Link between AFREXPN and AFBCAMP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFREXPN and AFBCAMP (FK1_AFREXPN_INV_AFBCAMP_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFREXPN	AFREXPN_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP	(1,1)-(0,n)

Link between AFRMAIL and AFBCAMP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRMAIL and AFBCAMP (FK1_AFRMAIL_INV_AFBCAMP_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRMAIL	AFRMAIL_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP	(1,1)-(0,n)

Link between AGBWPLG and AFBCAMP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBWPLG and AFBCAMP (FK1_AGBWPLG_INV_AFBCAMP_KEY)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGBWPLG and AFBCAMP (FK2_AGBWPLG_INV_AFBCAMP_KEY)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGBWPLG and AFBCAMP (FK3_AGBWPLG_INV_AFBCAMP_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBWPLG	AGBWPLG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBWPLG	AGBWPLG_CAMPAIGN_3	AFBCAMP_CAMPAIGN	AFBCAMP	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBWPLG	AGBWPLG_CAMPAIGN_2	AFBCAMP_CAMPAIGN	AFBCAMP	(0,1)-(0,n)

Link between AGRGHDE and AFBCAMP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRGHDE and AFBCAMP (FK1_AGRGHDE_INV_AFBCAMP_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRGHDE	AGRGHDE_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP	(1,1)-(0,n)

Link between AFBCAMP and ATVCMTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFBCAMP and ATVCMTP (FK1_AFBCAMP_INV_ATVCMTP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFBCAMP	AFBCAMP_CMTP_CODE	ATVCMTP_CODE	ATVCMTP	(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)