Model SPRIDEN

Model Label : SPRIDEN table called links
Path : Default Folder/B70/Common/SPRIDEN

List of Objects

Object Name	Object Type	Layer Name
AFRCSLT	TABLE	Default
AFRCTYP	TABLE	Default
AMRPRRT	TABLE	Default
AMRSTAF	TABLE	Default
AORCONT	TABLE	Default
APRCSPS	TABLE	Default
FPBPOHD	TABLE	Default
PARAPST	TABLE	Default
REBPAYV	TABLE	Default
ROBALOG	TABLE	Default
SERDTGL	TABLE	Default
SERDTND	TABLE	Default
SERDTSR	TABLE	Default
SGRADVR	TABLE	Default
SHBCOMI	TABLE	Default
SHRCOMM	TABLE	Default
SHRGCOL	TABLE	Default
SLRRASG	TABLE	Default
SMBGOGN	TABLE	Default
SPRADDR	TABLE	Default
SPRIDEN	TABLE	Default

Comments

Model View

Table AFRCSLT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AFRCSLT_CAMPAIGN	AFRCSLT_CAMPAIGN	VARCHAR2(5)	No
AFRCSLT_SOLC_CODE	AFRCSLT_SOLC_CODE	VARCHAR2(8)	Yes
AFRCSLT_SOL_ORG	AFRCSLT_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCSLT_PIDM	AFRCSLT_PIDM	NUMBER(8,0)	No	*
AFRCSLT_GOAL	AFRCSLT_GOAL	NUMBER(13,2)	Yes
AFRCSLT_ACTIVITY_DATE	AFRCSLT_ACTIVITY_DATE	DATE	No
AFRCSLT_REPORT_TO_PIDM	AFRCSLT_REPORT_TO_PIDM	NUMBER(8,0)	Yes
AFRCSLT_MAX_CONTACTS	AFRCSLT_MAX_CONTACTS	NUMBER(3,0)	Yes
AFRCSLT_SSTA_CODE	AFRCSLT_SSTA_CODE	VARCHAR2(1)	Yes	*
AFRCSLT_SSTA_DATE	AFRCSLT_SSTA_DATE	DATE	Yes
AFRCSLT_UPD_WEB_IND	AFRCSLT_UPD_WEB_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCSLT_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AFRCSLT_SSTA_CODE	ATVSSTA_CODE	ATVSSTA
AFRCSLT_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_CAMPAIGN
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_SOLC_CODE
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_SOL_ORG
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_PIDM
AFRCSLT_KEY_INDEX2		AFRCSLT_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
all_camp_no_orgs_cons	C/C++ Function	[F:\BANNER\C\ASPSOLB.PC]	Use(select )
all_camp_orgs_cons	C/C++ Function	[F:\BANNER\C\ASPSOLB.PC]	Use(select )
camp_orgs	C/C++ Function	[F:\BANNER\C\ASPSOLB.PC]	Use()
check_cpidm	C/C++ Function	[F:\BANNER\C\AGPTLMK.PC]	Use(select )
check_cpidm1	C/C++ Function	[F:\BANNER\C\AGPTLMK.PC]	Use(select )
ins_afrcslt	C/C++ Function	[F:\BANNER\C\ASPSOLA.PC]	Use(insert )
selmacro	C/C++ Function	[F:\BANNER\C\AFPSOLC.PC]	Use(select )
solcactc	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcdcat	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcempl	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcpcla	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcpcol	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcprsp	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcpsta	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solczipc	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
AFRCSLT	SYNONYM	S4B70.PUBLIC	Rely on ()
APVCSLT	VIEW	S4B70.BANINST1	Use(select )
ASVCAMP	VIEW	S4B70.BANINST1	Use(select )
ASVCSTA	VIEW	S4B70.BANINST1	Use(select )
POST_CHANGE_VOID	Forms Trigger	BANNER7_FORMS.AXAMGAJ.AXRMSOL.AXRMSOL_SOL_ORG	Use(select )
POST_CHANGE_VOID	Forms Trigger	BANNER7_FORMS_10G.AXAMGAJ.AXRMSOL.AXRMSOL_SOL_ORG	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.AFACAMP.AFBCAMP.AFBCAMP_GOAL	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.AFACAMP.AFBCAMP.AFBCAMP_GOAL	Use(select )
CHECK_CAMP_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS.AFACSLT	Use(select )
CHECK_CAMP_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS_10G.AFACSLT	Use(select )
CHECK_ORG_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS_10G.AFACORG	Use(select )
CHECK_ORG_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS_10G.AFACSLT	Use(select )
CHECK_ORG_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS_10G.ASACORG	Use(select )
CHECK_ORG_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS.AFACORG	Use(select )
CHECK_ORG_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS.ASACORG	Use(select )
CHECK_ORG_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS.AFACSLT	Use(select )
CHECK_SOLC_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS.AFACSLT	Use(select )
CHECK_SOLC_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS.AFACSOL	Use(select )
CHECK_SOLC_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS_10G.AFACSLT	Use(select )
CHECK_SOLC_VS_SOLICITOR	Forms Trigger	BANNER7_FORMS_10G.AFACSOL	Use(select )
VALIDATE_ENTRY_GDES_VOID	Forms Trigger	BANNER7_FORMS_10G.AGAGIFT	Use(select )
VALIDATE_ENTRY_GDES_VOID	Forms Trigger	BANNER7_FORMS.AGAGIFT	Use(select )
VALIDATE_ENTRY_VOID	Forms Trigger	BANNER7_FORMS_10G.AGAGIFT	Use(select )
VALIDATE_ENTRY_VOID	Forms Trigger	BANNER7_FORMS.AGAGIFT	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS.ASAASCT	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS.AOQOLIB	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS.ASAMRES	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS.AFACSLT	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS.ASASIGN	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS_10G.ASASIGN	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS_10G.AFACSLT	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS_10G.ASAASCT	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS_10G.ASAMRES	Use(select )
AFRCSLT_RG	Forms Record Group	BANNER7_FORMS_10G.AOQOLIB	Use(select )
AFRCSLT_RG_OLD	Forms Record Group	BANNER7_FORMS_10G.AOQOLIB	Use(select )
AFRCSLT_RG_OLD	Forms Record Group	BANNER7_FORMS.AOQOLIB	Use(select )
TYPE_ORG_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.AFACSLT	Use(select )
TYPE_ORG_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.ASAUNCT	Use(select )
TYPE_ORG_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.AFACSLT	Use(select )
TYPE_ORG_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.ASAUNCT	Use(select )
TYPE_ORG_RG	Forms Record Group	BANNER7_FORMS.AFACSLT	Use(select )
TYPE_ORG_RG	Forms Record Group	BANNER7_FORMS_10G.AFACSLT	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.ASAASCT	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.ASASIGN	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAPSOL	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAPMAS	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.ASAASCT	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.ASASIGN	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.ASIPOOL	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.AGAPMAS	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.ASAMRES	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.AGAWPLG	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.ASAUNCT	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.ASAUNCT	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAWPLG	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAGSOL	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.AOQOLIB	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.AGAGSOL	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS.AGAPSOL	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.ASIPOOL	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.AOQOLIB	Use(select )
TYPE_ORG_SOL_4_CAMP_RG	Forms Record Group	BANNER7_FORMS_10G.ASAMRES	Use(select )
DELETE_CHECKS	Forms Trigger	BANNER7_FORMS_10G.AOAORGN.AOBORGN	Use(select )
DELETE_CHECKS	Forms Trigger	BANNER7_FORMS.AOAORGN.AOBORGN	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.AFACORG.AFRCORG	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.AFACORG.AFRCORG	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.ASASORG.ASBSORG	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.ASASORG.ASRSORG	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.ASASORG.ASBSORG	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.ASASORG.ASRSORG	Use(select )
POST-DELETE	Forms Trigger	BANNER7_FORMS.AFACSOL.AFRCSOL	Use(delete )
POST-DELETE	Forms Trigger	BANNER7_FORMS_10G.AFACSOL.AFRCSOL	Use(delete )
POST-INSERT	Forms Trigger	BANNER7_FORMS_10G.AFACORG.AFRCORG	Use(insert )
POST-INSERT	Forms Trigger	BANNER7_FORMS.AFACORG.AFRCORG	Use(insert )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.AFACAMP.AFBCAMP	Use(delete )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.APACONS.APBCONS	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.AFACAMP.AFBCAMP	Use(delete )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.APACONS.APBCONS	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.AFACSLT.AFRCSLT	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.AFACSLT.AFRCSLT	Use(select )
REDO_EMPL_CAMP_DESG	Forms Trigger	BANNER7_FORMS.AGAMATG.AGBMGID	Use(select )
REDO_EMPL_CAMP_DESG	Forms Trigger	BANNER7_FORMS_10G.AGAMATG.AGBMGID	Use(select )
VALIDATE_ENTRY_VOID	Forms Trigger	BANNER7_FORMS_10G.AGAGSOL.AGRGSOL	Use(select )
VALIDATE_ENTRY_VOID	Forms Trigger	BANNER7_FORMS_10G.AGAPDEF.AGBPDEF	Use(select )
VALIDATE_ENTRY_VOID	Forms Trigger	BANNER7_FORMS_10G.AGAPSOL.AGRPSOL	Use(select )
VALIDATE_ENTRY_VOID	Forms Trigger	BANNER7_FORMS.AGAPDEF.AGBPDEF	Use(select )
VALIDATE_ENTRY_VOID	Forms Trigger	BANNER7_FORMS.AGAGSOL.AGRGSOL	Use(select )
VALIDATE_ENTRY_VOID	Forms Trigger	BANNER7_FORMS.AGAPSOL.AGRPSOL	Use(select )
VALID_SOL_VOID	Forms Trigger	BANNER7_FORMS.AGAMGAJ.AGRMSOL	Use(select )
VALID_SOL_VOID	Forms Trigger	BANNER7_FORMS.AXAMGAJ.AXRMSOL	Use(select )
VALID_SOL_VOID	Forms Trigger	BANNER7_FORMS_10G.AGAMGAJ.AGRMSOL	Use(select )
VALID_SOL_VOID	Forms Trigger	BANNER7_FORMS_10G.AXAMGAJ.AXRMSOL	Use(select )
COUNT_CAMP_SOLS	Forms Procedure	BANNER7_FORMS_10G.ASASIGN	Use(select )
COUNT_CAMP_SOLS	Forms Procedure	BANNER7_FORMS.ASASIGN	Use(select )
CREATE_CAMP_SOLS_WITH_MAX	Forms Procedure	BANNER7_FORMS_10G.ASASIGN	Use(select )
CREATE_CAMP_SOLS_WITH_MAX	Forms Procedure	BANNER7_FORMS.ASASIGN	Use(select )
UPDATE_AFRCSLT	Forms Procedure	BANNER7_FORMS_10G.ASASIGN	Use(update )
UPDATE_AFRCSLT	Forms Procedure	BANNER7_FORMS.ASASIGN	Use(update )
AFRCSLT_EXISTS	Forms Function	BANNER7_FORMS.AGAWPLG	Use(select )
AFRCSLT_EXISTS	Forms Function	BANNER7_FORMS_10G.AGAWPLG	Use(select )
SELECT_AFRCSLT_1	Forms Function	BANNER7_FORMS_10G.ASAMRES	Use(select )
SELECT_AFRCSLT_1	Forms Function	BANNER7_FORMS_10G.ASASIGN	Use(select )
SELECT_AFRCSLT_1	Forms Function	BANNER7_FORMS_10G.ASAASCT	Use(select )
SELECT_AFRCSLT_1	Forms Function	BANNER7_FORMS.ASAASCT	Use(select )
SELECT_AFRCSLT_1	Forms Function	BANNER7_FORMS.ASASIGN	Use(select )
SELECT_AFRCSLT_1	Forms Function	BANNER7_FORMS.ASAMRES	Use(select )
SELECT_AFRCSLT_25	Forms Function	BANNER7_FORMS.AGAPMAS	Use(select )
SELECT_AFRCSLT_25	Forms Function	BANNER7_FORMS_10G.AGAPMAS	Use(select )
SELECT_AFRCSLT_26	Forms Function	BANNER7_FORMS.AGAPMAS	Use(select )
SELECT_AFRCSLT_26	Forms Function	BANNER7_FORMS_10G.AGAPMAS	Use(select )
SELECT_AFRCSLT_27	Forms Function	BANNER7_FORMS.AGAPMAS	Use(select )
SELECT_AFRCSLT_27	Forms Function	BANNER7_FORMS_10G.AGAPMAS	Use(select )
SELECT_AFRCSLT_28	Forms Function	BANNER7_FORMS.AGAPMAS	Use(select )
SELECT_AFRCSLT_28	Forms Function	BANNER7_FORMS_10G.AGAPMAS	Use(select )
A$_CHECK_ACTIVE_CAMP_SOL	Forms Function	BANNER7_FORMS.AOQVOLM	Use(select )
A$_CHECK_ACTIVE_CAMP_SOL	Forms Function	BANNER7_FORMS_10G.AOQVOLM	Use(select )
A$_CHECK_SOL_ID	Forms Function	BANNER7_FORMS.AOQVOLM	Use(select )
A$_CHECK_SOL_ID	Forms Function	BANNER7_FORMS_10G.AOQVOLM	Use(select )
A$_CHECK_SOL_ORG	Forms Function	BANNER7_FORMS.AOQVOLM	Use(select )
A$_CHECK_SOL_ORG	Forms Function	BANNER7_FORMS_10G.AOQVOLM	Use(select )
A$_CHECK_SOL_ORG_ID	Forms Function	BANNER7_FORMS.AOQVOLM	Use(select )
A$_CHECK_SOL_ORG_ID	Forms Function	BANNER7_FORMS_10G.AOQVOLM	Use(select )
A$_CHECK_VALID_AFRCSLT	Forms Function	BANNER7_FORMS.AOQVOLM	Use(select )
A$_CHECK_VALID_AFRCSLT	Forms Function	BANNER7_FORMS_10G.AOQVOLM	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 )
AFRCTYPVIEWC	Package cursor	S4B70.BANINST1.BWAKVOPP	Use(select )
AFRCSLT	Forms DataBlock	BANNER7_FORMS.AGCCSLT	Rely on () Use(insert,update,delete,select )
AFRCSLT	Forms DataBlock	BANNER7_FORMS.AFCCSLT	Rely on () Use(insert,update,delete,select )
AFRCSLT	Forms DataBlock	BANNER7_FORMS_10G.AFCCSLT	Rely on () Use(insert,update,delete,select )
AFRCSLT	Forms DataBlock	BANNER7_FORMS_10G.AGCCSLT	Rely on () Use(insert,update,delete,select )
AFRCSLT	Forms DataBlock	BANNER7_FORMS_10G.AFACSLT	Rely on () Use(insert,update,delete,select )
AFRCSLT	Forms DataBlock	BANNER7_FORMS.AFACSLT	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCSLT_KEY_INDEX	INDEX	S4B70.ALUMNI	Rely on ()
AFRCSLT_KEY_INDEX2	INDEX	S4B70.ALUMNI	Rely on ()
ASBSORG	TABLE	S4B70.ALUMNI	Refer( No Action )
ATVSSTA	TABLE	S4B70.ALUMNI	Refer( No Action )
SPRIDEN	TABLE	S4B70.SATURN	Join

Comments

Source Code Comments

Campaign Solicitor Repeating Table

Columns Comments for AFRCSLT_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCSLT_SOLC_CODE (2)

Source Code Comments

This field specifies the type of campaign solicitations a specific solicitor organization is using for the campaign.

Columns Comments for AFRCSLT_SOL_ORG (3)

Source Code Comments

This field specifies a particular solicitor organization.

Columns Comments for AFRCSLT_PIDM (4)

Source Code Comments

This field specifies the internal system generated identification number for a specific solicitor.

Columns Comments for AFRCSLT_GOAL (5)

Source Code Comments

This field identifies the dollar amount goal for each solicitor.

Columns Comments for AFRCSLT_ACTIVITY_DATE (6)

Source Code Comments

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

Columns Comments for AFRCSLT_REPORT_TO_PIDM (7)

Source Code Comments

The Internal ID of the Solicitor at the next level up to which this Solicitor must report.

Columns Comments for AFRCSLT_MAX_CONTACTS (8)

Source Code Comments

The maximum number of contacts that a solicitor may have for the combination of Campaign, Solicitor Code and Solicitor Organization.

Columns Comments for AFRCSLT_SSTA_CODE (9)

Source Code Comments

The status of the solicitor for the combination of Campaign, Solicitor Code and Solicitor Organization.

Columns Comments for AFRCSLT_SSTA_DATE (10)

Source Code Comments

The date the Solicitor Status was changed.

Columns Comments for AFRCSLT_UPD_WEB_IND (11)

Source Code Comments

Update Web Indicator, Indicates that the solicitor can enter Contact information through the Web

Table AFRCTYP

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

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
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_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
AFRCTYP_CONSTITUENT_PIDM	SPRIDEN_PIDM	SPRIDEN
AFRCTYP_PIDM	SPRIDEN_PIDM	SPRIDEN
AFRCTYP_RATER_PIDM	SPRIDEN_PIDM	SPRIDEN

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
checkcons	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
ctyp_camp_exists	C/C++ Function	[F:\BANNER\C\AGPTLMK.PC]	Use(select )
ctyp_camp_seq	C/C++ Function	[F:\BANNER\C\AGPTLMK.PC]	Use(select )
ctyp_year_exists	C/C++ Function	[F:\BANNER\C\AGPTLMK.PC]	Use(select )
ctyp_year_seq	C/C++ Function	[F:\BANNER\C\AGPTLMK.PC]	Use(select )
get_max	C/C++ Function	[F:\BANNER\C\ASPSOLA.PC]	Use(select )
get_max_con	C/C++ Function	[F:\BANNER\C\ASPSOLA.PC]	Use(select )
getseqno	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
ins_afrctyp	C/C++ Function	[F:\BANNER\C\ASPSOLA.PC]	Use(insert )
ins_afrctyp_camp	C/C++ Function	[F:\BANNER\C\ASPSOLA.PC]	Use(insert )
ins_cctyp	C/C++ Function	[F:\BANNER\C\AGPTLMK.PC]	Use(insert )
ins_yctyp	C/C++ Function	[F:\BANNER\C\AGPTLMK.PC]	Use(insert )
selmacr1	C/C++ Function	[F:\BANNER\C\AFPTELF.PC]	Use(select )
selmacr1_pop	C/C++ Function	[F:\BANNER\C\AFPTELF.PC]	Use(select )
selsolorgmacro	C/C++ Function	[F:\BANNER\C\APPDPRC.PC]	Use(select )
selsolorgmacro_pop	C/C++ Function	[F:\BANNER\C\APPDPRC.PC]	Use(select )
solcactc	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcdcat	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcempl	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcpcla	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcpcol	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcprsp	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcpsta	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
solcselc	C/C++ Function	[F:\BANNER\C\AFPSOLB.PC]	Use(select )
solcselc	C/C++ Function	[F:\BANNER\C\AFPSOLC.PC]	Use(select )
solczipc	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(select )
updasolc	C/C++ Function	[F:\BANNER\C\AFPSOLA.PC]	Use(insert )
AFRCTYP	SYNONYM	S4B70.PUBLIC	Rely on ()
AFBCAMP	TABLE	S4B70.ALUMNI	Join
APVCTYP	VIEW	S4B70.BANINST1	Use(select )
APVSRES	VIEW	S4B70.BANINST1	Use(select )
ASVASCT	VIEW	S4B70.BANINST1	Use(select )
ASVCCMP	VIEW	S4B70.BANINST1	Use(select )
ASVCYER	VIEW	S4B70.BANINST1	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.ASAMRES.AFRCRES.CONTACT_ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.ASAMRES.AFRCRES.CONTACT_ID	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.AOQOLIB	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.AGAWPLG	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAMGAJ	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAGIFT	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.AXAMGAJ	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAPSOL	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAPMAS	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.APASBIO	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.AMAINFO	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.AGAPMAS	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.APASBIO	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.AGAMGAJ	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.AGAGIFT	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.AGAPSOL	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.AXAMGAJ	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.AMAINFO	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAWPLG	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS_10G.AGAGSOL	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.AOQOLIB	Use(select )
AFRCTYP_RG	Forms Record Group	BANNER7_FORMS.AGAGSOL	Use(select )
CAMP_ORG_SOL_RG	Forms Record Group	BANNER7_FORMS_10G.ASAMRES	Use(select )
CAMP_ORG_SOL_RG	Forms Record Group	BANNER7_FORMS_10G.AOQOLIB	Use(select )
CAMP_ORG_SOL_RG	Forms Record Group	BANNER7_FORMS_10G.ASASIGN	Use(select )
CAMP_ORG_SOL_RG	Forms Record Group	BANNER7_FORMS.ASASIGN	Use(select )
CAMP_ORG_SOL_RG	Forms Record Group	BANNER7_FORMS.ASAMRES	Use(select )
CAMP_ORG_SOL_RG	Forms Record Group	BANNER7_FORMS.AOQOLIB	Use(select )
CONTACT_RG	Forms Record Group	BANNER7_FORMS_10G.ASAMRES	Use(select )
CONTACT_RG	Forms Record Group	BANNER7_FORMS.ASAMRES	Use(select )
ORG_YR_SOL_RG	Forms Record Group	BANNER7_FORMS_10G.ASAMRES	Use(select )
ORG_YR_SOL_RG	Forms Record Group	BANNER7_FORMS_10G.AOQOLIB	Use(select )
ORG_YR_SOL_RG	Forms Record Group	BANNER7_FORMS.ASAMRES	Use(select )
ORG_YR_SOL_RG	Forms Record Group	BANNER7_FORMS.ASASIGN	Use(select )
ORG_YR_SOL_RG	Forms Record Group	BANNER7_FORMS_10G.ASASIGN	Use(select )
ORG_YR_SOL_RG	Forms Record Group	BANNER7_FORMS.AOQOLIB	Use(select )
SOL_CONTACT_RG	Forms Record Group	BANNER7_FORMS.AGAPMAS	Use(select )
SOL_CONTACT_RG	Forms Record Group	BANNER7_FORMS_10G.AGAPMAS	Use(select )
DELETE_CHECKS	Forms Trigger	BANNER7_FORMS_10G.AOAORGN.AOBORGN	Use(select )
DELETE_CHECKS	Forms Trigger	BANNER7_FORMS.AOAORGN.AOBORGN	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.ASASANG.ASRSSAG	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.ASASORG.ASBSORG	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.ASASORG.ASBSORG	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.AFACSLT.AFRCSLT	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.AFACSLT.AFRCSLT	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.ASASANG.ASRSSAG	Use(select )
POST-DELETE	Forms Trigger	BANNER7_FORMS.AFACSOL.AFRCSOL	Use(delete )
POST-DELETE	Forms Trigger	BANNER7_FORMS_10G.AFACSOL.AFRCSOL	Use(delete )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.ASIPOOL.ORG_GOALS	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.ASIPOOL.SOL_GOALS	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.ASIPOOL.SOL_GOALS	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.ASIPOOL.ORG_GOALS	Use(select )
PRE-BLOCK	Forms Trigger	BANNER7_FORMS.APASBIO.NAVIGATION	Use(select )
PRE-BLOCK	Forms Trigger	BANNER7_FORMS_10G.APASBIO.NAVIGATION	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.AFACAMP.AFBCAMP	Use(delete )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.AFACAMP.AFBCAMP	Use(delete )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.APACONS.APBCONS	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.APACONS.APBCONS	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.ASASANG.AFRCTYP	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.ASAUNCT.AFRCTYP	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.ASAUNCT.AFRCTYP	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.ASASANG.AFRCTYP	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS.ASAASCT.AFRCTYP	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS_10G.ASAUNCT.AFRCTYP	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS.ASAUNCT.AFRCTYP	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS_10G.ASAASCT.AFRCTYP	Use(select )
COUNT_EXISTING_CONTACTS	Forms Procedure	BANNER7_FORMS_10G.ASASIGN	Use(select )
COUNT_EXISTING_CONTACTS	Forms Procedure	BANNER7_FORMS.ASAASCT	Use(select )
COUNT_EXISTING_CONTACTS	Forms Procedure	BANNER7_FORMS_10G.ASAASCT	Use(select )
COUNT_EXISTING_CONTACTS	Forms Procedure	BANNER7_FORMS.ASASIGN	Use(select )
CREATE_AFRCTYP	Forms Procedure	BANNER7_FORMS.AGAWPLG	Use(insert )
CREATE_AFRCTYP	Forms Procedure	BANNER7_FORMS_10G.AGAWPLG	Use(insert )
CREATE_CAMP_SOLS_WITH_MAX	Forms Procedure	BANNER7_FORMS_10G.ASASIGN	Use(select )
CREATE_CAMP_SOLS_WITH_MAX	Forms Procedure	BANNER7_FORMS.ASASIGN	Use(select )
CREATE_YEAR_SOLS_WITH_MAX	Forms Procedure	BANNER7_FORMS_10G.ASASIGN	Use(select )
CREATE_YEAR_SOLS_WITH_MAX	Forms Procedure	BANNER7_FORMS.ASASIGN	Use(select )
INSERT_AFRCTYP	Forms Procedure	BANNER7_FORMS_10G.ASASIGN	Use(insert )
INSERT_AFRCTYP	Forms Procedure	BANNER7_FORMS.ASASIGN	Use(insert )
SELECT_AFRCTYP_SEQ_NO_CAMP	Forms Procedure	BANNER7_FORMS.AGAWPLG	Use(select )
SELECT_AFRCTYP_SEQ_NO_CAMP	Forms Procedure	BANNER7_FORMS_10G.AGAWPLG	Use(select )
SELECT_AFRCTYP_SEQ_NO_DCYR	Forms Procedure	BANNER7_FORMS.AGAWPLG	Use(select )
SELECT_AFRCTYP_SEQ_NO_DCYR	Forms Procedure	BANNER7_FORMS_10G.AGAWPLG	Use(select )
UPDATE_AFRCTYP	Forms Procedure	BANNER7_FORMS.ASAASCT	Use(update )
UPDATE_AFRCTYP	Forms Procedure	BANNER7_FORMS_10G.ASAASCT	Use(update )
AFRCTYP_CAMP_EXISTS	Forms Function	BANNER7_FORMS.AGAWPLG	Use(select )
AFRCTYP_CAMP_EXISTS	Forms Function	BANNER7_FORMS_10G.AGAWPLG	Use(select )
AFRCTYP_YEAR_EXISTS	Forms Function	BANNER7_FORMS.AGAWPLG	Use(select )
AFRCTYP_YEAR_EXISTS	Forms Function	BANNER7_FORMS_10G.AGAWPLG	Use(select )
CHECK_AFRCTYP_EXISTS	Forms Function	BANNER7_FORMS.ASAASCT	Use(select )
CHECK_AFRCTYP_EXISTS	Forms Function