Model SPRADDR

Model Label : Banner SPRADDR ERD

List of Objects

Object Name	Object Type	Layer Name
AMRINFO	TABLE	ERD
AOBORGN	TABLE	ERD
FRBGRNT	TABLE	ERD
FRRGRPI	TABLE	ERD
FTVVEND	TABLE	ERD
GORSVAS	TABLE	ERD
GORSVEI	TABLE	ERD
SORGEOR	TABLE	ERD
SPRADDR	TABLE	Default
SPRIDEN	TABLE	ERD
SPRTELE	TABLE	ERD
STVASRC	TABLE	ERD
STVATYP	TABLE	ERD
STVCNTY	TABLE	ERD
STVNATN	TABLE	ERD
STVSTAT	TABLE	ERD

Comments

Model View

Table AMRINFO

Schema Name ALUMNI
Label AMRINFO
Server name S4B70
Creation Date 09/29/2003 12:12:49:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AMRINFO_PIDM	AMRINFO_PIDM	NUMBER(8,0)	No	*
AMRINFO_REFR_CODE	AMRINFO_REFR_CODE	VARCHAR2(2)	No		*
AMRINFO_SYS_IND	AMRINFO_SYS_IND	VARCHAR2(1)	No
AMRINFO_STATUS	AMRINFO_STATUS	VARCHAR2(1)	No
AMRINFO_ACTIVITY_DATE	AMRINFO_ACTIVITY_DATE	DATE	No
AMRINFO_RATE_ENTRY_DATE	AMRINFO_RATE_ENTRY_DATE	DATE	Yes
AMRINFO_REFERENCE	AMRINFO_REFERENCE	VARCHAR2(30)	Yes
AMRINFO_PROSP_RATE	AMRINFO_PROSP_RATE	NUMBER(11,2)	Yes
AMRINFO_TARGET_ASK_DATE	AMRINFO_TARGET_ASK_DATE	DATE	Yes
AMRINFO_WEB_GIFT_IND	AMRINFO_WEB_GIFT_IND	VARCHAR2(1)	Yes
AMRINFO_WEB_PLDG_IND	AMRINFO_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMRINFO_REFR_CODE	ATVREFR_CODE	ATVREFR

Index

Index Name	Index Type	Column Name
PK_AMRINFO	Unique	AMRINFO_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
selrate	C/C++ Function	[F:\BANNER\C\APPCONS.PC]	Use(select )
selrate	C/C++ Function	[F:\BANNER\C\APPCLST.PC]	Use(select )
AMRINFO	SYNONYM	S4B70.PUBLIC	Rely on ()
AMRPRIN	TABLE	S4B70.ALUMNI	Refer( No Action )
AMRPRRT	TABLE	S4B70.ALUMNI	Refer( No Action )
AMRSTAF	TABLE	S4B70.ALUMNI	Refer( No Action )
SPRADDR	TABLE	S4B70.SATURN	Join
AA_PROSPECT_INFO	VIEW	S4B70.BANINST1	Use(select )
AMVGEOR	VIEW	S4B70.BANINST1	Use(select )
AMVINFO	VIEW	S4B70.BANINST1	Use(select )
AMVPRS1	VIEW	S4B70.BANINST1	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.AMAPROS.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.APASBIO.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.APACONT.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.AMAPROS.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.APACONT.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.APASBIO.KEY_BLOCK.ID	Use(select )
AMRINFO_TRIG	Forms Trigger	BANNER7_FORMS.APASBIO	Use(select )
AMRINFO_TRIG	Forms Trigger	BANNER7_FORMS_10G.APASBIO	Use(select )
CHECK_FORM	Forms Trigger	BANNER7_FORMS.AMAINFO	Use(select )
CHECK_FORM	Forms Trigger	BANNER7_FORMS_10G.AMAINFO	Use(select )
GIV_PROSP_IDEN_CHECK	Forms Trigger	BANNER7_FORMS_10G.AOAORGN	Use(select )
GIV_PROSP_IDEN_CHECK	Forms Trigger	BANNER7_FORMS.AOAORGN	Use(select )
MNU_OPT_BLK_AFRCTYP	Forms Trigger	BANNER7_FORMS.AMAINFO	Use(select )
MNU_OPT_BLK_AFRCTYP	Forms Trigger	BANNER7_FORMS_10G.AMAINFO	Use(select )
MNU_OPT_BLK_AMREXRT	Forms Trigger	BANNER7_FORMS.AMAINFO	Use(select )
MNU_OPT_BLK_AMREXRT	Forms Trigger	BANNER7_FORMS_10G.AMAINFO	Use(select )
MNU_OPT_BLK_AMRPRIN	Forms Trigger	BANNER7_FORMS.AMAINFO	Use(select )
MNU_OPT_BLK_AMRPRIN	Forms Trigger	BANNER7_FORMS_10G.AMAINFO	Use(select )
MNU_OPT_BLK_AMRPRRT	Forms Trigger	BANNER7_FORMS.AMAINFO	Use(select )
MNU_OPT_BLK_AMRPRRT	Forms Trigger	BANNER7_FORMS_10G.AMAINFO	Use(select )
MNU_OPT_BLK_AMRSTAF	Forms Trigger	BANNER7_FORMS.AMAINFO	Use(select )
MNU_OPT_BLK_AMRSTAF	Forms Trigger	BANNER7_FORMS_10G.AMAINFO	Use(select )
UPDATE_CALC_AMT	Forms Trigger	BANNER7_FORMS.AMAINFO	Use(update )
UPDATE_CALC_AMT	Forms Trigger	BANNER7_FORMS_10G.AMAINFO	Use(update )
UPDATE_PRIMARY_AMT	Forms Trigger	BANNER7_FORMS.AMAINFO	Use(update )
UPDATE_PRIMARY_AMT	Forms Trigger	BANNER7_FORMS_10G.AMAINFO	Use(update )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS_10G.APAEXRS	Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS.AMACONT	Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS_10G.AMACONT	Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS.APAEXRS	Use(select )
DELETE_CHECKS	Forms Trigger	BANNER7_FORMS_10G.AOAORGN.AOBORGN	Use(select )
DELETE_CHECKS	Forms Trigger	BANNER7_FORMS.AOAORGN.AOBORGN	Use(select )
KEY-NXTBLK	Forms Trigger	BANNER7_FORMS.AMAINFO.AMRINFO	Use(select )
KEY-NXTBLK	Forms Trigger	BANNER7_FORMS_10G.AMAINFO.AMRINFO	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.APACONS.APBCONS	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.APACONS.APBCONS	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS_10G.AMARSCH.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS_10G.AXAMGRN.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS_10G.AMACOMT.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS_10G.AMAPROP.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS.AXAMGRN.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS_10G.APAIGRP.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS.APAEMAL.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS.APAIGRP.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS.AMAPROP.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS.AMARSCH.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS.AMACOMT.KEY_BLOCK	Use(select )
PROSP_CHECK	Forms Trigger	BANNER7_FORMS_10G.APAEMAL.KEY_BLOCK	Use(select )
F_PROSPECT_IND	FUNCTION	S4B70.BANINST1	Use(select )
PROSPECT_EXISTS	Forms Function	BANNER7_FORMS.APACMAS	Use(select )
PROSPECT_EXISTS	Forms Function	BANNER7_FORMS.APIBRWS	Use(select )
PROSPECT_EXISTS	Forms Function	BANNER7_FORMS_10G.APIBRWS	Use(select )
PROSPECT_EXISTS	Forms Function	BANNER7_FORMS_10G.APACMAS	Use(select )
SELECT_AMRINFO_1	Forms Function	BANNER7_FORMS.AMAPLAN	Use(select )
SELECT_AMRINFO_1	Forms Function	BANNER7_FORMS_10G.AMAPLAN	Use(select )
AMRINFO_REC	Package variable	S4B70.BANINST1.BWDKPSRC	Rely on ()
AMRINFO_REC	Package variable	S4B70.BANINST1.BWDKCPRF	Rely on ()
AMRINFO_REC	Package variable	S4B70.BANINST1.BWAKPLDG	Rely on ()
AMRINFO_REC	Package variable	S4B70.BANINST1.BWDKPSRC	Rely on ()
AMRINFO_REC	Package variable	S4B70.BANINST1.BWDKCPRF	Rely on ()
AMRINFO_REC	Package variable	S4B70.BANINST1.BWAKLIBS	Rely on ()
AMRINFO_REC	Package variable	S4B70.BANINST1.BWAKLIBS	Rely on ()
AMRINFO_REC	Package variable	S4B70.BANINST1.BWAKPLDG	Rely on ()
P_BUILD_PROS_IDS_RESULTS	Package procedure	S4B70.BANINST1.BWDKPSRC	Use(select )
AMRINFOVIEWC	Package cursor	S4B70.BANINST1.BWAKPLDG	Rely on () Use(select )
AMRINFOVIEWC	Package cursor	S4B70.BANINST1.BWAKGIFT	Rely on () Use(select )
AMRINFOVIEWC	Package cursor	S4B70.BANINST1.BWDKCPRF	Rely on () Use(select )
AMRINFOVIEWC	Package cursor	S4B70.BANINST1.BWDKPSRC	Rely on () Use(select )
GETAMRINFOC	Package cursor	S4B70.BANINST1.BWAKLIBS	Rely on () Use(select )
PROSPECTVIEWC	Package cursor	S4B70.BANINST1.BWDKPCNT	Use(select )
AMRINFO_REC	Package variable	S4B70.BANINST1.BWAKGIFT	Rely on ()
AMRINFO_REC	Package variable	S4B70.BANINST1.BWAKGIFT	Rely on ()
P_ADV_PROSPECT_COUNT	Package procedure	S4B70.BANINST1.BWACBREF	Use(select )
P_ADV_PROSPECT_ROWNUM	Package procedure	S4B70.BANINST1.BWACBREF	Use(select )
P_GET_ADV_PROSPECT	Package procedure	S4B70.BANINST1.BWACBREF	Use(select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_AB_ADV_ORGANIZATION	Use(insert )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_AB_ADV_INDIVIDUAL	Use(insert )
F_ADV_PROSPECT_COUNT	Package function	S4B70.BANINST1.BWACXALU	Use(select )
F_ADV_PROSPECT_ROWNUM	Package function	S4B70.BANINST1.BWACXALU	Use(select )
F_AMRINFO_EXISTS	Package function	S4B70.BANINST1.BWAKLIBS	Rely on ()
F_AMRINFO_EXISTS	Package function	S4B70.BANINST1.BWAKLIBS	Rely on ()
F_GET_PROSPECTS_XML	Package function	S4B70.BANINST1.XCHAPERS	Use(select )
AMRINFO	Forms DataBlock	BANNER7_FORMS.AMAPOOL	Rely on () Use(select )
AMRINFO	Forms DataBlock	BANNER7_FORMS_10G.AMAPOOL	Rely on () Use(select )
AMRINFO	Forms DataBlock	BANNER7_FORMS_10G.AMAINFO	Rely on () Use(insert,update,delete,select )
AMRINFO	Forms DataBlock	BANNER7_FORMS.AMAINFO	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AMRINFO	INDEX	S4B70.ALUMNI	Rely on ()
ATVREFR	TABLE	S4B70.ALUMNI	Refer( No Action )

Comments

Source Code Comments

Prospect Information Table

Columns Comments for AMRINFO_PIDM (1)

Source Code Comments

Internal person/org identification number.

Columns Comments for AMRINFO_REFR_CODE (2)

Source Code Comments

This field specifies the reference code.

Columns Comments for AMRINFO_SYS_IND (3)

Source Code Comments

This field specifies system indicator.

Columns Comments for AMRINFO_STATUS (4)

Source Code Comments

This field specifies status.

Columns Comments for AMRINFO_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for AMRINFO_RATE_ENTRY_DATE (6)

Source Code Comments

This field specifies the date rate was entered.

Columns Comments for AMRINFO_REFERENCE (7)

Source Code Comments

This field specifies reference.

Columns Comments for AMRINFO_PROSP_RATE (8)

Source Code Comments

This field specifies manually entered or system calculated prospect amount.

Columns Comments for AMRINFO_TARGET_ASK_DATE (9)

Source Code Comments

This field specifies manually entered target asking date.

Columns Comments for AMRINFO_WEB_GIFT_IND (10)

Source Code Comments

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

Columns Comments for AMRINFO_WEB_PLDG_IND (11)

Source Code Comments

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

Table AOBORGN

Schema Name ALUMNI
Label AOBORGN
Server name S4B70
Creation Date 07/14/2004 11:35:55:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AOBORGN_PIDM	AOBORGN_PIDM	NUMBER(8,0)	No	*	*
AOBORGN_EIN	AOBORGN_EIN	VARCHAR2(9)	Yes
AOBORGN_BUSINESS	AOBORGN_BUSINESS	VARCHAR2(30)	No
AOBORGN_SICC_CODE	AOBORGN_SICC_CODE	VARCHAR2(4)	Yes		*
AOBORGN_MATCH_PCT	AOBORGN_MATCH_PCT	NUMBER(3,0)	Yes
AOBORGN_MATCH_ORG_MAX	AOBORGN_MATCH_ORG_MAX	NUMBER(11,2)	Yes
AOBORGN_MATCH_PERSON_MAX	AOBORGN_MATCH_PERSON_MAX	NUMBER(11,2)	Yes
AOBORGN_ATYP_CODE	AOBORGN_ATYP_CODE	VARCHAR2(2)	Yes		*
AOBORGN_JOBC_CODE	AOBORGN_JOBC_CODE	VARCHAR2(3)	Yes		*
AOBORGN_TITLE_CONTACT	AOBORGN_TITLE_CONTACT	VARCHAR2(60)	Yes
AOBORGN_LAST_NAME_CONTACT	AOBORGN_LAST_NAME_CONTACT	VARCHAR2(25)	Yes
AOBORGN_FIRST_NAME_CONTACT	AOBORGN_FIRST_NAME_CONTACT	VARCHAR2(15)	Yes
AOBORGN_MI_CONTACT	AOBORGN_MI_CONTACT	VARCHAR2(1)	Yes
AOBORGN_ACTIVITY_DATE	AOBORGN_ACTIVITY_DATE	DATE	No
AOBORGN_MG_PIDM	AOBORGN_MG_PIDM	NUMBER(8,0)	Yes
AOBORGN_EMPL_CNT	AOBORGN_EMPL_CNT	NUMBER(9,0)	Yes
AOBORGN_EMPL_PT_PROF	AOBORGN_EMPL_PT_PROF	NUMBER(9,0)	Yes
AOBORGN_EMPL_FT_PROF	AOBORGN_EMPL_FT_PROF	NUMBER(9,0)	Yes
AOBORGN_TOT_REVENUE	AOBORGN_TOT_REVENUE	NUMBER(12,0)	Yes
AOBORGN_TOT_ASSETS	AOBORGN_TOT_ASSETS	NUMBER(12,0)	Yes
AOBORGN_TOT_EARNINGS	AOBORGN_TOT_EARNINGS	NUMBER(12,0)	Yes
AOBORGN_PRE_TAX_PROFIT	AOBORGN_PRE_TAX_PROFIT	NUMBER(12,0)	Yes
AOBORGN_GRANT_LOW	AOBORGN_GRANT_LOW	NUMBER(12,0)	Yes
AOBORGN_GRANT_HIGH	AOBORGN_GRANT_HIGH	NUMBER(12,0)	Yes
AOBORGN_PROP_DEADLINE_MM	AOBORGN_PROP_DEADLINE_MM	VARCHAR2(2)	Yes
AOBORGN_PROP_DEADLINE_DD	AOBORGN_PROP_DEADLINE_DD	VARCHAR2(2)	Yes
AOBORGN_YEAR_INC	AOBORGN_YEAR_INC	NUMBER(4,0)	Yes
AOBORGN_BEG_FY_MM	AOBORGN_BEG_FY_MM	VARCHAR2(2)	Yes
AOBORGN_BEG_FY_DD	AOBORGN_BEG_FY_DD	VARCHAR2(2)	Yes
AOBORGN_END_FY_MM	AOBORGN_END_FY_MM	VARCHAR2(2)	Yes
AOBORGN_END_FY_DD	AOBORGN_END_FY_DD	VARCHAR2(2)	Yes
AOBORGN_OTH_ED_MG_IND	AOBORGN_OTH_ED_MG_IND	VARCHAR2(1)	Yes
AOBORGN_STATE_ASSOC_MG_IND	AOBORGN_STATE_ASSOC_MG_IND	VARCHAR2(1)	Yes
AOBORGN_DESG_MG_IND	AOBORGN_DESG_MG_IND	VARCHAR2(1)	Yes
AOBORGN_MDIS_CODE	AOBORGN_MDIS_CODE	VARCHAR2(1)	Yes		*
AOBORGN_MDIS_MM	AOBORGN_MDIS_MM	VARCHAR2(2)	Yes
AOBORGN_MDIS_DD	AOBORGN_MDIS_DD	VARCHAR2(2)	Yes
AOBORGN_MDIS_DEADLINE_MM	AOBORGN_MDIS_DEADLINE_MM	VARCHAR2(2)	Yes
AOBORGN_MDIS_DEADLINE_DD	AOBORGN_MDIS_DEADLINE_DD	VARCHAR2(2)	Yes
AOBORGN_DUPL_MG_IND	AOBORGN_DUPL_MG_IND	VARCHAR2(1)	Yes
AOBORGN_MG_ACK_IND	AOBORGN_MG_ACK_IND	VARCHAR2(1)	Yes
AOBORGN_MGMT_MG_IND	AOBORGN_MGMT_MG_IND	VARCHAR2(1)	Yes
AOBORGN_MATCH_PERS_INST_YR	AOBORGN_MATCH_PERS_INST_YR	NUMBER(11,2)	Yes
AOBORGN_MATCH_ORG_CEILING_YR	AOBORGN_MATCH_ORG_CEILING_YR	NUMBER(11,2)	Yes
AOBORGN_MATCH_ORG_EMPL_YR	AOBORGN_MATCH_ORG_EMPL_YR	NUMBER(11,2)	Yes
AOBORGN_MATCH_MINIMUM	AOBORGN_MATCH_MINIMUM	NUMBER(11,2)	Yes
AOBORGN_SOCIETY_NAME	AOBORGN_SOCIETY_NAME	VARCHAR2(60)	Yes
AOBORGN_YEAR_MG	AOBORGN_YEAR_MG	NUMBER(4,0)	Yes
AOBORGN_FINANCIALS_DATE	AOBORGN_FINANCIALS_DATE	DATE	Yes
AOBORGN_MG_LOAD_UPDATE_DATE	AOBORGN_MG_LOAD_UPDATE_DATE	DATE	Yes
AOBORGN_MG_LOAD_SOURCE	AOBORGN_MG_LOAD_SOURCE	VARCHAR2(1)	Yes
AOBORGN_MG_RECEIPT_IND	AOBORGN_MG_RECEIPT_IND	VARCHAR2(1)	Yes
AOBORGN_MATCH_MAXIMUM	AOBORGN_MATCH_MAXIMUM	NUMBER(11,2)	Yes
AOBORGN_PREFIX_CONTACT	AOBORGN_PREFIX_CONTACT	VARCHAR2(20)	Yes
AOBORGN_SUFFIX_CONTACT	AOBORGN_SUFFIX_CONTACT	VARCHAR2(20)	Yes
AOBORGN_MG_LOAD_ID	AOBORGN_MG_LOAD_ID	VARCHAR2(9)	Yes
AOBORGN_DATA_ORIGIN	AOBORGN_DATA_ORIGIN	VARCHAR2(30)	Yes
AOBORGN_USER_ID	AOBORGN_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AOBORGN_ATYP_CODE	STVATYP_CODE	STVATYP
AOBORGN_SICC_CODE	ATVSICC_CODE	ATVSICC
AOBORGN_MDIS_CODE	ATVMDIS_CODE	ATVMDIS
AOBORGN_JOBC_CODE	ATVJOBC_CODE	ATVJOBC
AOBORGN_PIDM	APREHIS_EMPR_PIDM	APREHIS

Index

Index Name	Index Type	Column Name
PK_AOBORGN	Unique	AOBORGN_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
donrorgs	C/C++ Function	[F:\BANNER\C\AFPDONR.PC]	Use(select )
driver	C/C++ Function	[F:\BANNER\C\AGPMATS.PC]	Use(select )
get_aoborgn_info	C/C++ Function	[F:\BANNER\C\APPDCLB.PC]	Use(select )
get_orgn_society_name	C/C++ Function	[F:\BANNER\C\APPDCAR.PC]	Use(select )
load_c	C/C++ Function	[F:\BANNER\C\AGPMATS.PC]	Use(update )
load_h	C/C++ Function	[F:\BANNER\C\AGPMATS.PC]	Use(update )
primary_org	C/C++ Function	[F:\BANNER\C\AGPACCT.PC]	Use(select )
read_aoborgn	C/C++ Function	[F:\BANNER\C\AGPMATC.PC]	Use(select )
rule_class_org	C/C++ Function	[F:\BANNER\C\APPDCAR.PC]	Use(select )
seladdrtype_prim	C/C++ Function	[F:\BANNER\C\AGPACCT.PC]	Use(select )
selcorp	C/C++ Function	[F:\BANNER\C\AGPGANL.PC]	Use(select )
selcorptots	C/C++ Function	[F:\BANNER\C\AGPGANL.PC]	Use(select )
selemprmatch	C/C++ Function	[F:\BANNER\C\APPDPRC.PC]	Use(select )
selmacro	C/C++ Function	[F:\BANNER\C\AGPMATG.PC]	Use(select )
selmacro_orgs	C/C++ Function	[F:\BANNER\C\ALPMSEL.PC]	Use(select )
selmacro_orgs_pop	C/C++ Function	[F:\BANNER\C\ALPMSEL.PC]	Use(select )
selmg_org	C/C++ Function	[F:\BANNER\C\AGPMATG.PC]	Use(select )
selorg_addr1	C/C++ Function	[F:\BANNER\C\AGPLYSY.PC]	Use(select )
selorg_primary	C/C++ Function	[F:\BANNER\C\AGPLYSY.PC]	Use(select )
selorgs	C/C++ Function	[F:\BANNER\C\AFPDONR.PC]	Use(select )
selorgs	C/C++ Function	[F:\BANNER\C\ALPMSEL.PC]	Use(select )
selpref_alph	C/C++ Function	[F:\BANNER\C\AGPLYSY.PC]	Use(select )
selpref_donr	C/C++ Function	[F:\BANNER\C\AGPLYSY.PC]	Use(select )
selpref_totgiv	C/C++ Function	[F:\BANNER\C\AGPLYSY.PC]	Use(select )
selrept	C/C++ Function	[F:\BANNER\C\AGPMATF.PC]	Use(select )
seltele_org	C/C++ Function	[F:\BANNER\C\AGPLYSY.PC]	Use(select )
seltele_org_add1	C/C++ Function	[F:\BANNER\C\AGPLYSY.PC]	Use(select )
update_acknowledgement	C/C++ Function	[F:\BANNER\C\AGPMATC.PC]	Use(select )
AOBORGN	SYNONYM	S4B70.PUBLIC	Rely on ()
AORCONT	TABLE	S4B70.ALUMNI	Refer( No Action )
AORFUND	TABLE	S4B70.ALUMNI	Refer( No Action )
AORJPST	TABLE	S4B70.ALUMNI	Join
AORMACC	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMAST	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMCTL	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMDEF	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMEDU	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMERQ	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMGCD	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMGCM	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMIND	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMLOC	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMLVL	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMNAT	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMNED	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMPRO	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMPUR	TABLE	S4B70.ALUMNI	Refer( No Action )
AORMRTO	TABLE	S4B70.ALUMNI	Refer( No Action )
SPRADDR	TABLE	S4B70.SATURN	Join
SPRIDEN	TABLE	S4B70.SATURN	Join
AA_ORGANIZATIONAL_CONSTITUENT	VIEW	S4B70.BANINST1	Use(select )
AA_ORGANIZATION_CONTACT	VIEW	S4B70.BANINST1	Use(select )
AA_PREVIOUS_EMPLOYMENT	VIEW	S4B70.BANINST1	Use(select )
AOVCOMP	VIEW	S4B70.BANINST1	Use(select )
AOVORG1	VIEW	S4B70.BANINST1	Use(select )
AOVORGN	VIEW	S4B70.BANINST1	Use(select )
APVBRWS	VIEW	S4B70.BANINST1	Use(select )
APVENTY	VIEW	S4B70.BANINST1	Use(select )
COMPANY_ID_TRIGGER	Forms Trigger	BANNER7_FORMS.AGAMATG.AGBMGID.EMPL_ID	Use(select )
COMPANY_ID_TRIGGER	Forms Trigger	BANNER7_FORMS.AAADUES.KEY_BLOCK.PAYOR_ID	Use(select )
COMPANY_ID_TRIGGER	Forms Trigger	BANNER7_FORMS_10G.AAADUES.KEY_BLOCK.PAYOR_ID	Use(select )
COMPANY_ID_TRIGGER	Forms Trigger	BANNER7_FORMS_10G.AGAPMAS.AGBPLDG.ID	Use(select )
COMPANY_ID_TRIGGER	Forms Trigger	BANNER7_FORMS_10G.AGAMATG.AGBMGID.EMPL_ID	Use(select )
COMPANY_ID_TRIGGER	Forms Trigger	BANNER7_FORMS.AGAPMAS.AGBPLDG.ID	Use(select )
GET_MATCH_ID	Forms Trigger	BANNER7_FORMS.AOAMTCH.KEY_BLOCK.ID	Use(select )
GET_MATCH_ID	Forms Trigger	BANNER7_FORMS_10G.AOAMTCH.KEY_BLOCK.ID	Use(select )
ORGN_ID_ADDR	Forms Trigger	BANNER7_FORMS.AGAPREC.KEY_BLOCK.ID	Rely on ()
ORGN_ID_ADDR	Forms Trigger	BANNER7_FORMS_10G.AGAGREC.KEY_BLOCK.ID	Rely on ()
ORGN_ID_ADDR	Forms Trigger	BANNER7_FORMS_10G.AGAGREC.KEY_BLOCK.ID	Use(select )
ORGN_ID_ADDR	Forms Trigger	BANNER7_FORMS_10G.AGAPREC.KEY_BLOCK.ID	Rely on ()
ORGN_ID_ADDR	Forms Trigger	BANNER7_FORMS.AGAGREC.KEY_BLOCK.ID	Rely on ()
ORGN_ID_ADDR	Forms Trigger	BANNER7_FORMS.AGAPREC.KEY_BLOCK.ID	Use(select )
ORGN_ID_ADDR	Forms Trigger	BANNER7_FORMS.AGAGREC.KEY_BLOCK.ID	Use(select )
ORGN_ID_ADDR	Forms Trigger	BANNER7_FORMS_10G.AGAPREC.KEY_BLOCK.ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.AOAORGN.AOBORGN.AOBORGN_MG_PIDM	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.AOAORGN.AOBORGN.MG_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.AOAORGN.AOBORGN.AOBORGN_MG_PIDM	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.AXAMGAJ.AXBMGID.EMPR_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.AGAMGAJ.AGBMGID.EMPR_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.AXAMGAJ.AXBMGID.EMPR_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.AAADUES.AARDUES.ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.APAEHIS.APREHIS.APREHIS_EMPR_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.AGAMGAJ.AGBMGID.EMPR_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.AAADUES.AARDUES.ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.APAEHIS.APREHIS.APREHIS_EMPR_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.AOAORGN.AOBORGN.MG_ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.ASASANG.AFRCTYP.CONTACT_ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.ASAMRES.AFRCRES.CONTACT_ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.ASASANG.AFRCTYP.CONTACT_ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.AGAMATG.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.AGAMATG.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.ASAUNCT.AFRCTYP.CONTACT_ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.ASAUNCT.AFRCTYP.CONTACT_ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.AFACSLT.AFRCTYP.CONTACT_SOLICITOR_ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.AGIMATG.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.AGIMATG.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.AFACSLT.AFRCTYP.CONTACT_SOLICITOR_ID	Use(select )
CHECK_CATG_ORG	Forms Trigger	BANNER7_FORMS_10G.AOAORGN	Use(select )
CHECK_CATG_ORG	Forms Trigger	BANNER7_FORMS.AOAORGN	Use(select )
APREHIS_RG	Forms Record Group	BANNER7_FORMS.AXAMGRN	Use(select )
APREHIS_RG	Forms Record Group	BANNER7_FORMS_10G.AXAMGRN	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.AOAORGN.AOBORGN	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.AOAORGN.AOBORGN	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.APADCLB.APRDCLB	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.AOAORGN.AORCONT	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.AAADUES.AARDUES	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.APADCLB.APRDCLB	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.AAADUES.AARDUES	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.AOAORGN.AORCONT	Use(select )
QUERY_IDEN_ORGN	Forms Trigger	BANNER7_FORMS.APAEHIS.APREHIS	Use(select )
QUERY_IDEN_ORGN	Forms Trigger	BANNER7_FORMS_10G.APAEHIS.APREHIS	Use(select )
SELECT_AOBORGN_2	Forms Procedure	BANNER7_FORMS.AOAMTCH	Use(select )
SELECT_AOBORGN_2	Forms Procedure	BANNER7_FORMS_10G.AOAMTCH	Use(select )
VALIDATE_EMPR	Forms Procedure	BANNER7_FORMS.AXAMGRN	Use(select )
VALIDATE_EMPR	Forms Procedure	BANNER7_FORMS_10G.AXAMGRN	Use(select )
F_ALUMNI_ORGANIZATION_IND	FUNCTION	S4B70.BANINST1	Use(select )
F_JOB_INFO	FUNCTION	S4B70.BANINST1	Use(select )
F_MATCHING_GIFT_COMPANY_NAME	FUNCTION	S4B70.BANINST1	Use(select )
F_MULTIPLE_RATIOS	FUNCTION	S4B70.BANINST1	Use(select )
F_ORGN_MATCH_GIFT_INFO	FUNCTION	S4B70.BANINST1	Use(select )
ORGANIZATION_EXISTS	Forms Function	BANNER7_FORMS.APACMAS	Use(select )
ORGANIZATION_EXISTS	Forms Function	BANNER7_FORMS_10G.APACMAS	Use(select )
ORG_PROFILE_EXISTS	Forms Function	BANNER7_FORMS.APIBRWS	Use(select )
ORG_PROFILE_EXISTS	Forms Function	BANNER7_FORMS_10G.APIBRWS	Use(select )
SELECT_AOBORGN_1	Forms Function	BANNER7_FORMS.AAACMEM	Use(select )
SELECT_AOBORGN_1	Forms Function	BANNER7_FORMS_10G.APACONS	Use(select )
SELECT_AOBORGN_1	Forms Function	BANNER7_FORMS.APACONS	Use(select )
SELECT_AOBORGN_1	Forms Function	BANNER7_FORMS_10G.AAACMEM	Use(select )
SELECT_AOBORGN_10	Forms Function	BANNER7_FORMS.AAACMEM	Use(select )
SELECT_AOBORGN_10	Forms Function	BANNER7_FORMS_10G.AAACMEM	Use(select )
SELECT_AOBORGN_11	Forms Function	BANNER7_FORMS_10G.AOAORGN	Use(select )
SELECT_AOBORGN_11	Forms Function	BANNER7_FORMS.APACOMB	Use(select )
SELECT_AOBORGN_11	Forms Function	BANNER7_FORMS.AOAORGN	Use(select )
SELECT_AOBORGN_11	Forms Function	BANNER7_FORMS_10G.APACOMB	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS_10G.ASAMRES	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS_10G.ASASIGN	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS_10G.AGAPYMT	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS_10G.ASASANG	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS_10G.AFACSLT	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS.ASASANG	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS.ASASIGN	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS.ASAMRES	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS.AGAPYMT	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS.AFACSLT	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS.AAADINS	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS.AAAMEMB	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS_10G.AAADINS	Use(select )
SELECT_AOBORGN_2	Forms Function	BANNER7_FORMS_10G.AAAMEMB	Use(select )
SELECT_AOBORGN_3	Forms Function	BANNER7_FORMS_10G.AGAPMEM	Use(select )
SELECT_AOBORGN_3