Model Solicitor_Organization*

Model Label :

List of Objects

Object Name	Object Type	Layer Name
AFRCORG	SQL Table	Default
AFRCRES	SQL Table	Default
AFRCSLT	SQL Table	Default
AFRCTYP	SQL Table	Default
AGBPDEF	SQL Table	Default
AGBWPLG	SQL Table	Default
AGRGSOL	SQL Table	Default
AGRMSOL	SQL Table	Default
AGRPSOL	SQL Table	Default
ASBSORG	SQL Table	Default
ASRCOMT	SQL Table	Default
ASRCONT	SQL Table	Default
ASRCORG	SQL Table	Default
ASRSOAG	SQL Table	Default
ASRSORG	SQL Table	Default
ASRSSAG	SQL Table	Default
ATVDCYR	SQL Table	Default
ATVSOTP	SQL Table	Default
ATVSSTA	SQL Table	Default
AXRMSOL	SQL Table	Default
STVATYP	SQL Table	Default
STVCOLL	SQL Table	Default

Model View

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 AFRCRES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AFRCRES_CAMPAIGN	VARCHAR2(5)	Yes
AFRCRES_SOLC_CODE	VARCHAR2(8)	Yes	*
AFRCRES_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCRES_PIDM	NUMBER(8,0)	No
AFRCRES_CTYP_SEQ_NO	NUMBER(5,0)	No
AFRCRES_SEQ_NO	NUMBER(5,0)	No
AFRCRES_SCNT_CODE	VARCHAR2(3)	Yes	*
AFRCRES_SCRS_CODE	VARCHAR2(3)	Yes	*
AFRCRES_PLEDGE_NO	VARCHAR2(7)	Yes
AFRCRES_DATE	DATE	Yes
AFRCRES_ACTIVITY_DATE	DATE	No
AFRCRES_USER	VARCHAR2(30)	No
AFRCRES_GIFT_NO	VARCHAR2(7)	Yes
AFRCRES_COMMENT	VARCHAR2(2000)	Yes
AFRCRES_DCYR_CODE	NUMBER(4,0)	Yes	*
AFRCRES_ASK_AMOUNT	NUMBER(11,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCRES_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AFRCRES_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
AFRCRES_SCNT_CODE	ATVSCNT_CODE	ATVSCNT
AFRCRES_SCRS_CODE	ATVSCRS_CODE	ATVSCRS
AFRCRES_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
AFRCRES_KEY_INDEX	Unique	AFRCRES_CAMPAIGN
AFRCRES_KEY_INDEX	Unique	AFRCRES_SOLC_CODE
AFRCRES_KEY_INDEX	Unique	AFRCRES_SOL_ORG
AFRCRES_KEY_INDEX	Unique	AFRCRES_DCYR_CODE
AFRCRES_KEY_INDEX	Unique	AFRCRES_PIDM
AFRCRES_KEY_INDEX	Unique	AFRCRES_CTYP_SEQ_NO
AFRCRES_KEY_INDEX	Unique	AFRCRES_SEQ_NO
AFRCRES_KEY_INDEX2		AFRCRES_SOL_ORG
AFRCRES_KEY_INDEX2		AFRCRES_DCYR_CODE
AFRCRES_KEY_INDEX2		AFRCRES_PIDM
AFRCRES_KEY_INDEX2		AFRCRES_CTYP_SEQ_NO
AFRCRES_KEY_INDEX2		AFRCRES_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCTYP	SQL Table	S10B80.ALUMNI	Join
APVSRES	SQL View	S10B80.BANINST1	Use (select)
MAX_SEQ_NO_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKVOPP	Rely On
RESULT_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKVOPP	Rely On
AFRCRESMAXSEQNOC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
AFRCRESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
P_INSERTCONTACT_RESULTS	Oracle Package Procedure	S10B80.BANINST1.BWAKVOPP	Use (Insert)
AFRCRES	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
AFRCRES_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AFRCRES_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCYR	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)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AFRCRES

Object Dates

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

Source Code Comments

Campaign Result Repeating Table

Columns Comments for AFRCRES_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCRES_SOLC_CODE (# 2)

Source Code Comments

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

Columns Comments for AFRCRES_SOL_ORG (# 3)

Source Code Comments

This field specifies the solicitor organization.

Columns Comments for AFRCRES_PIDM (# 4)

Source Code Comments

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

Columns Comments for AFRCRES_CTYP_SEQ_NO (# 5)

Source Code Comments

This field specifies the internal sequence for solicitors.

Columns Comments for AFRCRES_SEQ_NO (# 6)

Source Code Comments

This field specifies the internal sequence number for constituent respondents.

Columns Comments for AFRCRES_SCNT_CODE (# 7)

Source Code Comments

This field specifies the type of solicitation contact used to contact a specific constituent.

Columns Comments for AFRCRES_SCRS_CODE (# 8)

Source Code Comments

This field specifies the type of response from the constituent for a specific solicitation.

Columns Comments for AFRCRES_PLEDGE_NO (# 9)

Source Code Comments

This field specifies the number of the pledge received from the constituent for a specific solicitation.

Columns Comments for AFRCRES_DATE (# 10)

Source Code Comments

This field specifies the date the constituent was contacted for a solicitation.

Columns Comments for AFRCRES_ACTIVITY_DATE (# 11)

Source Code Comments

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

Columns Comments for AFRCRES_USER (# 12)

Source Code Comments

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

Columns Comments for AFRCRES_GIFT_NO (# 13)

Source Code Comments

Gift Number associated with the result of the contact

Columns Comments for AFRCRES_COMMENT (# 14)

Source Code Comments

2000 Character free-form comment associated with the result.

Columns Comments for AFRCRES_DCYR_CODE (# 15)

Source Code Comments

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

Columns Comments for AFRCRES_ASK_AMOUNT (# 16)

Source Code Comments

The amount that the contact was asked to contribute during this contact.

Table AFRCSLT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AFRCSLT_CAMPAIGN	VARCHAR2(5)	No
AFRCSLT_SOLC_CODE	VARCHAR2(8)	Yes
AFRCSLT_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCSLT_PIDM	NUMBER(8,0)	No
AFRCSLT_GOAL	NUMBER(13,2)	Yes
AFRCSLT_ACTIVITY_DATE	DATE	No
AFRCSLT_REPORT_TO_PIDM	NUMBER(8,0)	Yes
AFRCSLT_MAX_CONTACTS	NUMBER(3,0)	Yes
AFRCSLT_SSTA_CODE	VARCHAR2(1)	Yes	*
AFRCSLT_SSTA_DATE	DATE	Yes
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

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
AFRCTYP	SQL Table	S10B80.ALUMNI	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
APVCSLT	SQL View	S10B80.BANINST1	Use (select)
ASVCAMP	SQL View	S10B80.BANINST1	Use (select)
ASVCSTA	SQL View	S10B80.BANINST1	Use (select)
AFRCTYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
AFRCSLT	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
AFRCSLT_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AFRCSLT_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSSTA	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AFRCSLT

Object Dates

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

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

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 AGBPDEF

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AGBPDEF_USER	VARCHAR2(30)	No
AGBPDEF_CAMPAIGN	VARCHAR2(5)	Yes
AGBPDEF_DESG	VARCHAR2(10)	Yes
AGBPDEF_ACTIVITY_DATE	DATE	No
AGBPDEF_GIFT_CODE	VARCHAR2(2)	Yes
AGBPDEF_GCLS_CODE	VARCHAR2(4)	Yes
AGBPDEF_GIFT_PLDG_IND	VARCHAR2(1)	Yes
AGBPDEF_MATCH_RECEIVED	VARCHAR2(1)	Yes
AGBPDEF_PSTA_CODE	VARCHAR2(1)	Yes
AGBPDEF_PLDG_CODE	VARCHAR2(2)	Yes
AGBPDEF_PCLS_CODE	VARCHAR2(4)	Yes
AGBPDEF_PDUR_CODE	VARCHAR2(1)	Yes
AGBPDEF_FREQ_CODE	VARCHAR2(2)	Yes
AGBPDEF_PRMD_CODE	VARCHAR2(2)	Yes
AGBPDEF_DEFAULT_DATE	DATE	Yes
AGBPDEF_SOLC_CODE	VARCHAR2(8)	Yes
AGBPDEF_SOL_ORG	VARCHAR2(5)	Yes	*
AGBPDEF_SOL_PIDM	NUMBER(8,0)	Yes
AGBPDEF_PCAT_CODE	VARCHAR2(5)	Yes	*
AGBPDEF_CTYP_CODE	VARCHAR2(5)	Yes	*
AGBPDEF_SCNT_CODE	VARCHAR2(3)	Yes	*
AGBPDEF_SCRS_CODE	VARCHAR2(3)	Yes	*
AGBPDEF_PGVE_CODE	VARCHAR2(5)	Yes	*
AGBPDEF_DNAM_CODE	VARCHAR2(10)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBPDEF_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AGBPDEF_CTYP_CODE	ATVCTYP_CODE	ATVCTYP
AGBPDEF_DNAM_CODE	ATVDNAM_CODE	ATVDNAM
AGBPDEF_PCAT_CODE	ATVPCAT_CODE	ATVPCAT
AGBPDEF_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBPDEF_SCNT_CODE	ATVSCNT_CODE	ATVSCNT
AGBPDEF_SCRS_CODE	ATVSCRS_CODE	ATVSCRS

Index

No Result

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
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVCTYP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDNAM	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPCAT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPGVE	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSCNT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSCRS	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGBPDEF

Object Dates

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

Source Code Comments

Pledge/Gift Default Camp/Desg

Columns Comments for AGBPDEF_USER (# 1)

Source Code Comments

This system maintained field specifies the user name.

Columns Comments for AGBPDEF_CAMPAIGN (# 2)

Source Code Comments

This field specifies the campaign to which a designation is defaulted.

Columns Comments for AGBPDEF_DESG (# 3)

Source Code Comments

This field specifies the designation which is defaulted to an associated campaign.

Columns Comments for AGBPDEF_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for AGBPDEF_GIFT_CODE (# 5)

Source Code Comments

Default gift type.

Columns Comments for AGBPDEF_GCLS_CODE (# 6)

Source Code Comments

Default gift class on the gift form.

Columns Comments for AGBPDEF_GIFT_PLDG_IND (# 7)

Source Code Comments

Default value for gift/pledge indicator. Used to determine defaults for gift form.

Columns Comments for AGBPDEF_MATCH_RECEIVED (# 8)

Source Code Comments

Default matching gift form received indicator.

Columns Comments for AGBPDEF_PSTA_CODE (# 9)

Source Code Comments

Default pledge status when creating a new pledge on the gift form.

Columns Comments for AGBPDEF_PLDG_CODE (# 10)

Source Code Comments

Default pledge type on the gift form.

Columns Comments for AGBPDEF_PCLS_CODE (# 11)

Source Code Comments

Default pledge class on the gift form when a pledge is created.

Columns Comments for AGBPDEF_PDUR_CODE (# 12)

Source Code Comments

Default pledge installment duration on the gift form when installments are being created.

Columns Comments for AGBPDEF_FREQ_CODE (# 13)

Source Code Comments

Default pledge installment frequency code on gift form when pledge installment are created.

Columns Comments for AGBPDEF_PRMD_CODE (# 14)

Source Code Comments

Default pledge installment reminder code on the gift form when pledge installments are created.

Columns Comments for AGBPDEF_DEFAULT_DATE (# 15)

Source Code Comments

Default date for pledge/gift on gift form.

Columns Comments for AGBPDEF_SOLC_CODE (# 16)

Source Code Comments

Default solicitaion type on the gift form for pledges and gifts that are created.

Columns Comments for AGBPDEF_SOL_ORG (# 17)

Source Code Comments

Default solicitation organization for pledges and gifts created on the gift form.

Columns Comments for AGBPDEF_SOL_PIDM (# 18)

Source Code Comments

Default solicitor pidm for pledge and gift solicitaion created on the gift form.

Columns Comments for AGBPDEF_PCAT_CODE (# 19)

Source Code Comments

Default Pledge Category Code.

Columns Comments for AGBPDEF_CTYP_CODE (# 20)

Source Code Comments

Default Condition Type Code.

Columns Comments for AGBPDEF_SCNT_CODE (# 21)

Source Code Comments

Default Solicitor Contact Code

Columns Comments for AGBPDEF_SCRS_CODE (# 22)

Source Code Comments

Default Solicitor Contact Result Code

Columns Comments for AGBPDEF_PGVE_CODE (# 23)

Source Code Comments

The default Pledge Gift Vehicle Code for the User ID.

Columns Comments for AGBPDEF_DNAM_CODE (# 24)

Source Code Comments

The Default Name Code associated with this users Pledge defaults.

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 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 AGRMSOL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
AGRMSOL_EMPR_PIDM	NUMBER(8,0)	No	*
AGRMSOL_EMPL_PIDM	NUMBER(8,0)	No	*
AGRMSOL_GIFT_NO	VARCHAR2(7)	No	*
AGRMSOL_CAMPAIGN	VARCHAR2(5)	No	*
AGRMSOL_SOLC_CODE	VARCHAR2(8)	Yes	*
AGRMSOL_SOL_ORG	VARCHAR2(5)	Yes	*
AGRMSOL_SOL_PIDM	NUMBER(8,0)	Yes
AGRMSOL_AMT	NUMBER(11,2)	No
AGRMSOL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRMSOL_EMPR_PIDM	AGRMCAM_EMPR_PIDM	AGRMCAM
AGRMSOL_EMPL_PIDM	AGRMCAM_EMPL_PIDM	AGRMCAM
AGRMSOL_GIFT_NO	AGRMCAM_GIFT_NO	AGRMCAM
AGRMSOL_CAMPAIGN	AGRMCAM_CAMPAIGN	AGRMCAM
AGRMSOL_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AGRMSOL_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
AGRMSOL_KEY_INDEX	Unique	AGRMSOL_EMPR_PIDM
AGRMSOL_KEY_INDEX	Unique	AGRMSOL_EMPL_PIDM
AGRMSOL_KEY_INDEX	Unique	AGRMSOL_GIFT_NO
AGRMSOL_KEY_INDEX	Unique	AGRMSOL_CAMPAIGN
AGRMSOL_KEY_INDEX	Unique	AGRMSOL_SOLC_CODE
AGRMSOL_KEY_INDEX	Unique	AGRMSOL_SOL_ORG
AGRMSOL_KEY_INDEX	Unique	AGRMSOL_SOL_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (Insert)
AGRMSOL	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
AGRMSOL_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGRMCAM	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.AGRMSOL

Object Dates

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

Source Code Comments

Matching Gift Solicitor Repeating Table

Columns Comments for AGRMSOL_EMPR_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGRMSOL_EMPL_PIDM (# 2)

Source Code Comments

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

Columns Comments for AGRMSOL_GIFT_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the gift.

Columns Comments for AGRMSOL_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRMSOL_SOLC_CODE (# 5)

Source Code Comments

This field specifies the solicitor code.

Columns Comments for AGRMSOL_SOL_ORG (# 6)

Source Code Comments

This field specifies the solicitor organization code.

Columns Comments for AGRMSOL_SOL_PIDM (# 7)

Source Code Comments

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

Columns Comments for AGRMSOL_AMT (# 8)

Source Code Comments

This field specifies the amount of the gift.

Columns Comments for AGRMSOL_ACTIVITY_DATE (# 9)

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 ASBSORG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ASBSORG_SOL_ORG	VARCHAR2(5)	No	*
ASBSORG_NAME	VARCHAR2(60)	No
ASBSORG_SOTP_CODE	VARCHAR2(2)	No		*
ASBSORG_CONTACT_PIDM	NUMBER(8,0)	Yes
ASBSORG_ATYP_CODE	VARCHAR2(2)	Yes		*
ASBSORG_ACTIVITY_DATE	DATE	No
ASBSORG_DOLLAR_GOAL	NUMBER(11,2)	Yes
ASBSORG_PARTICIPATION_GOAL	NUMBER(6,0)	Yes
ASBSORG_DONOR_COUNT_GOAL	NUMBER(6,0)	Yes
ASBSORG_SSTA_CODE	VARCHAR2(1)	Yes		*
ASBSORG_SSTA_DATE	DATE	Yes
ASBSORG_COLL_CODE	VARCHAR2(2)	Yes		*
ASBSORG_YEAR	NUMBER(4,0)	Yes		*
ASBSORG_UPD_WEB_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ASBSORG_YEAR	ATVDCYR_CODE	ATVDCYR
ASBSORG_SOTP_CODE	ATVSOTP_CODE	ATVSOTP
ASBSORG_SSTA_CODE	ATVSSTA_CODE	ATVSSTA
ASBSORG_COLL_CODE	STVCOLL_CODE	STVCOLL
ASBSORG_ATYP_CODE	STVATYP_CODE	STVATYP

Index

Index Name	Index Type	Column Name
ASBSORG_KEY_INDEX		ASBSORG_SOL_ORG
ASBSORG_KEY_INDEX		ASBSORG_CONTACT_PIDM
PK_ASBSORG	Unique	ASBSORG_SOL_ORG

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCORG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRCRES	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRCSLT	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRCTYP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBPDEF	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRMSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRCOMT	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRCONT	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRCORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSOAG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSSAG	SQL Table	S10B80.ALUMNI	Refer (no action)
AXRMSOL	SQL Table	S10B80.ALUMNI	Refer (no action)
ASSIGN_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKVOPP	Rely On
ASBSORG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
ASBSORG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPSRC	Rely On
ASBSORG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKVOPP	Rely On
ASBSORG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
ASBSORGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)Rely On
ASBSORGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
ASSIGNVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
SOLORGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
AFRCTYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
F_ASBSORG_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
ASBSORG	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
ASBSORG_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
PK_ASBSORG	SQL Index	S10B80.ALUMNI	Rely On
ATVDCYR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSOTP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSSTA	SQL Table	S10B80.ALUMNI	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ASBSORG

Object Dates

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

Source Code Comments

Solicitor Organization Base Table

Columns Comments for ASBSORG_SOL_ORG (# 1)

Source Code Comments

This field specifies the five character alphanumeric solicitor organization code. When a new solicitor organization is added, the Solicitor Organization list form is automatically updated.

Columns Comments for ASBSORG_NAME (# 2)

Source Code Comments

This field specifies the solicitor organization name.

Columns Comments for ASBSORG_SOTP_CODE (# 3)

Source Code Comments

This field specifies the code that identifies the type of solicitor organization.

Columns Comments for ASBSORG_CONTACT_PIDM (# 4)

Source Code Comments

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

Columns Comments for ASBSORG_ATYP_CODE (# 5)

Source Code Comments

This field specifies the address type to use for a specific solicitor.

Columns Comments for ASBSORG_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for ASBSORG_DOLLAR_GOAL (# 7)

Source Code Comments

The dollar goal for the solicitor organization.

Columns Comments for ASBSORG_PARTICIPATION_GOAL (# 8)

Source Code Comments

The goal participation percentage of donors for the solicitor organization.

Columns Comments for ASBSORG_DONOR_COUNT_GOAL (# 9)

Source Code Comments

The goal number of donors for the solicitor organization.

Columns Comments for ASBSORG_SSTA_CODE (# 10)

Source Code Comments

Solicitor/Orgnaization Status Code

Columns Comments for ASBSORG_SSTA_DATE (# 11)

Source Code Comments

Date the Solicitor/Orgnaization Status Code was added or changed

Columns Comments for ASBSORG_COLL_CODE (# 12)

Source Code Comments

College code associated with the Solicitor Organization.

Columns Comments for ASBSORG_YEAR (# 13)

Source Code Comments

Year code associated with the Solicitor Organization.

Columns Comments for ASBSORG_UPD_WEB_IND (# 14)

Source Code Comments

Update Web Indicator, Y indicates that information about this Solicitor Organization can be updated via the Web.

Table ASRCOMT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
ASRCOMT_SOL_ORG	VARCHAR2(5)	No	*
ASRCOMT_SEQ_NO	NUMBER(23,20)	No
ASRCOMT_COMMENT	VARCHAR2(60)	No
ASRCOMT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ASRCOMT_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
ASRCOMT_KEY_INDEX		ASRCOMT_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
ASRCOMT_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ASRCOMT

Object Dates

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

Source Code Comments

Solicitor Organization Comment Repeating Table

Columns Comments for ASRCOMT_SOL_ORG (# 1)

Source Code Comments

This field specifies the code for the solicitor organization.

Columns Comments for ASRCOMT_SEQ_NO (# 2)

Source Code Comments

This field specifies the internal sequence number for the solicitor organization comments.

Columns Comments for ASRCOMT_COMMENT (# 3)

Source Code Comments

This field specifies the free-form solicitor organization comments.

Columns Comments for ASRCOMT_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table ASRCONT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
ASRCONT_SOL_ORG	VARCHAR2(5)	No	*
ASRCONT_PIDM	NUMBER(8,0)	No
ASRCONT_CONT_CODE	VARCHAR2(4)	No	*
ASRCONT_CONT_VALUE	VARCHAR2(19)	Yes
ASRCONT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ASRCONT_CONT_CODE	ATVCONT_CODE	ATVCONT
ASRCONT_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
ASRCONT_KEY_INDEX	Unique	ASRCONT_SOL_ORG
ASRCONT_KEY_INDEX	Unique	ASRCONT_PIDM
ASRCONT_KEY_INDEX	Unique	ASRCONT_CONT_CODE
ASRCONT_KEY_INDEX	Unique	ASRCONT_CONT_VALUE

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
ASRCONT_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVCONT	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ASRCONT

Object Dates

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

Source Code Comments

Solicitor Contact Types Repeating Table

Columns Comments for ASRCONT_SOL_ORG (# 1)

Source Code Comments

This field specifies the solicitor organization code.

Columns Comments for ASRCONT_PIDM (# 2)

Source Code Comments

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

Columns Comments for ASRCONT_CONT_CODE (# 3)

Source Code Comments

This field specifies the contact type(s) to use when selecting the constituents to assign to a specific solicitor.

Columns Comments for ASRCONT_CONT_VALUE (# 4)

Source Code Comments

This field specifies the values to use when running the batch process to assign constituents to a specific solicitor.

Columns Comments for ASRCONT_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table ASRCORG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
ASRCORG_SOL_ORG_KEY	VARCHAR2(5)	No	*
ASRCORG_SOL_ORG	VARCHAR2(5)	No	*
ASRCORG_SOL_ORG_UP	VARCHAR2(5)	Yes	*
ASRCORG_LEVEL	VARCHAR2(5)	No
ASRCORG_DCYR_CODE	NUMBER(4,0)	No	*
ASRCORG_ACTIVITY_DATE	DATE	No
ASRCORG_USER	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ASRCORG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
ASRCORG_SOL_ORG_KEY	ASBSORG_SOL_ORG	ASBSORG
ASRCORG_SOL_ORG_UP	ASBSORG_SOL_ORG	ASBSORG
ASRCORG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
ASRCORG_KEY_INDEX		ASRCORG_SOL_ORG_KEY
ASRCORG_KEY_INDEX		ASRCORG_SOL_ORG
ASRCORG_KEY_INDEX		ASRCORG_SOL_ORG_UP
ASRCORG_KEY_INDEX		ASRCORG_LEVEL

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
ASRCORG_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCYR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ASRCORG

Object Dates

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

Source Code Comments

Solicitor Organization Hierarchy Table

Columns Comments for ASRCORG_SOL_ORG_KEY (# 1)

Source Code Comments

The top level Solicitor Organization in a hierarchy.

Columns Comments for ASRCORG_SOL_ORG (# 2)

Source Code Comments

The Solicitor Organization for which the hierarchy level is being defined.

Columns Comments for ASRCORG_SOL_ORG_UP (# 3)

Source Code Comments

The Solicitor Organization one level higher up than the level being defined.

Columns Comments for ASRCORG_LEVEL (# 4)

Source Code Comments

The level of the Solicitor Organization being defined in the hierarchy.

Columns Comments for ASRCORG_DCYR_CODE (# 5)

Source Code Comments

The Gift Society Year code associated with this Solicitor Organization.

Columns Comments for ASRCORG_ACTIVITY_DATE (# 6)

Source Code Comments

Date the record was created or last updated

Columns Comments for ASRCORG_USER (# 7)

Source Code Comments

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

Table ASRSOAG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ASRSOAG_SOL_ORG	VARCHAR2(5)	No	*	*
ASRSOAG_DCYR_CODE	NUMBER(4,0)	No	*	*
ASRSOAG_ACTIVITY_DATE	DATE	No
ASRSOAG_USER	VARCHAR2(30)	No
ASRSOAG_DOLLAR_GOAL	NUMBER(11,2)	Yes
ASRSOAG_PARTICIPATION_GOAL	NUMBER(6,0)	Yes
ASRSOAG_DONOR_COUNT_GOAL	NUMBER(6,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ASRSOAG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
ASRSOAG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
PK_ASRSOAG	Unique	ASRSOAG_SOL_ORG
PK_ASRSOAG	Unique	ASRSOAG_DCYR_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_ASRSOAG	SQL Index	S10B80.ALUMNI	Rely On
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCYR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ASRSOAG

Object Dates

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

Source Code Comments

Solicitor Organization Annual Goals Table

Columns Comments for ASRSOAG_SOL_ORG (# 1)

Source Code Comments

Solicitor Organization for which the goals have been set.

Columns Comments for ASRSOAG_DCYR_CODE (# 2)

Source Code Comments

Year for which organization goals have been set.

Columns Comments for ASRSOAG_ACTIVITY_DATE (# 3)

Source Code Comments

Date the record was created or last updated

Columns Comments for ASRSOAG_USER (# 4)

Source Code Comments

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

Columns Comments for ASRSOAG_DOLLAR_GOAL (# 5)

Source Code Comments

Goal dollar amount set for the Solicitor Organization.

Columns Comments for ASRSOAG_PARTICIPATION_GOAL (# 6)

Source Code Comments

Goal percentage of contacts who donate set for the Solicitor Organization.

Columns Comments for ASRSOAG_DONOR_COUNT_GOAL (# 7)

Source Code Comments

Goal number of donors set for the Solicitor Organization.

Table ASRSORG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ASRSORG_SOL_ORG	VARCHAR2(5)	No	*	*
ASRSORG_PIDM	NUMBER(8,0)	No	*	*
ASRSORG_SOLT_CODE	VARCHAR2(4)	No		*
ASRSORG_ATYP_CODE	VARCHAR2(2)	Yes		*
ASRSORG_MAX_CONTACTS	NUMBER(3,0)	Yes
ASRSORG_ACTIVITY_DATE	DATE	No
ASRSORG_DOLLAR_GOAL	NUMBER(11,2)	Yes
ASRSORG_PARTICIPATION_GOAL	NUMBER(6,0)	Yes
ASRSORG_DONOR_COUNT_GOAL	NUMBER(6,0)	Yes
ASRSORG_SSTA_CODE	VARCHAR2(1)	Yes		*
ASRSORG_SSTA_DATE	DATE	Yes
ASRSORG_UPD_WEB_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ASRSORG_SOLT_CODE	ATVSOLT_CODE	ATVSOLT
ASRSORG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
ASRSORG_SSTA_CODE	ATVSSTA_CODE	ATVSSTA
ASRSORG_ATYP_CODE	STVATYP_CODE	STVATYP
ASRSORG_PIDM	ASRSSAG_PIDM	ASRSSAG
ASRSORG_SOL_ORG	ASRSSAG_SOL_ORG	ASRSSAG

Index

Index Name	Index Type	Column Name
PK_ASRSORG	Unique	ASRSORG_SOL_ORG
PK_ASRSORG	Unique	ASRSORG_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCTYP	SQL Table	S10B80.ALUMNI	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ASVSORG	SQL View	S10B80.BANINST1	Use (select)
ASVSSAG	SQL View	S10B80.BANINST1	Use (select)
ASVSSTA	SQL View	S10B80.BANINST1	Use (select)
AFRCTYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKVOPP	Use (select)
ASRSORG	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_ASRSORG	SQL Index	S10B80.ALUMNI	Rely On
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSSAG	SQL Table	S10B80.ALUMNI	Join
ATVSOLT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSSTA	SQL Table	S10B80.ALUMNI	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ASRSORG

Object Dates

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

Source Code Comments

Solicitor Organization Repeating Table

Columns Comments for ASRSORG_SOL_ORG (# 1)

Source Code Comments

This field specifies the five character alphanumeric solicitor organization code.

Columns Comments for ASRSORG_PIDM (# 2)

Source Code Comments

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

Columns Comments for ASRSORG_SOLT_CODE (# 3)

Source Code Comments

This field specifies the solicitor type code for a specific solicitor.

Columns Comments for ASRSORG_ATYP_CODE (# 4)

Source Code Comments

This field specifies the address type to use for a specific solicitor.

Columns Comments for ASRSORG_MAX_CONTACTS (# 5)

Source Code Comments

This field specifies the maximum number of constituent contacts that can be assigned to a specific solicitor.

Columns Comments for ASRSORG_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for ASRSORG_DOLLAR_GOAL (# 7)

Source Code Comments

The dollar goal for the solicitor.

Columns Comments for ASRSORG_PARTICIPATION_GOAL (# 8)

Source Code Comments

The goal participation percentage of donors for the solicitor.

Columns Comments for ASRSORG_DONOR_COUNT_GOAL (# 9)

Source Code Comments

The goal number of donors for the solicitor.

Columns Comments for ASRSORG_SSTA_CODE (# 10)

Source Code Comments

Solicitor/Orgnaization Status Code

Columns Comments for ASRSORG_SSTA_DATE (# 11)

Source Code Comments

Date the Solicitor/Orgnaization Status Code was added or changed

Columns Comments for ASRSORG_UPD_WEB_IND (# 12)

Source Code Comments

Update Web Indicator, Y indicates that information about this Solicitor Organization can be updated via the Web.

Table ASRSSAG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ASRSSAG_SOL_ORG	VARCHAR2(5)	No	*	*
ASRSSAG_PIDM	NUMBER(8,0)	No	*	*
ASRSSAG_DCYR_CODE	NUMBER(4,0)	No	*	*
ASRSSAG_ACTIVITY_DATE	DATE	No
ASRSSAG_USER	VARCHAR2(30)	No
ASRSSAG_DOLLAR_GOAL	NUMBER(11,2)	Yes
ASRSSAG_PARTICIPATION_GOAL	NUMBER(6,0)	Yes
ASRSSAG_DONOR_COUNT_GOAL	NUMBER(6,0)	Yes
ASRSSAG_REPORT_TO_PIDM	NUMBER(8,0)	Yes
ASRSSAG_MAX_CONTACTS	NUMBER(3,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ASRSSAG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
ASRSSAG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
ASRSSAG_PIDM	APBCONS_PIDM	APBCONS

Index

Index Name	Index Type	Column Name
PK_ASRSSAG	Unique	ASRSSAG_SOL_ORG
PK_ASRSSAG	Unique	ASRSSAG_PIDM
PK_ASRSSAG	Unique	ASRSSAG_DCYR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ASRSORG	SQL Table	S10B80.ALUMNI	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ASVSSAG	SQL View	S10B80.BANINST1	Use (select)
ASVYEAR	SQL View	S10B80.BANINST1	Use (select)
ASRSSAG	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_ASRSSAG	SQL Index	S10B80.ALUMNI	Rely On
APBCONS	SQL Table	S10B80.ALUMNI	Join
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCYR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ASRSSAG

Object Dates

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

Source Code Comments

Solicitor Annual Goals Table

Columns Comments for ASRSSAG_SOL_ORG (# 1)

Source Code Comments

Solicitor Organization to which the solicitor belongs.

Columns Comments for ASRSSAG_PIDM (# 2)

Source Code Comments

Internal Id of the solicitor.

Columns Comments for ASRSSAG_DCYR_CODE (# 3)

Source Code Comments

Year for which the goals of the solicitor are being set.

Columns Comments for ASRSSAG_ACTIVITY_DATE (# 4)

Source Code Comments

Date the record was created or last updated

Columns Comments for ASRSSAG_USER (# 5)

Source Code Comments

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

Columns Comments for ASRSSAG_DOLLAR_GOAL (# 6)

Source Code Comments

Goal dollar amount set for the Solicitor.

Columns Comments for ASRSSAG_PARTICIPATION_GOAL (# 7)

Source Code Comments

Goal percentage of contacts who donate set for the Solicitor.

Columns Comments for ASRSSAG_DONOR_COUNT_GOAL (# 8)

Source Code Comments

Goal number of donors set for the Solicitor.

Columns Comments for ASRSSAG_REPORT_TO_PIDM (# 9)

Source Code Comments

The Internal ID of the person this Solicitor reports to.

Columns Comments for ASRSSAG_MAX_CONTACTS (# 10)

Source Code Comments

The maximum number of contacts that can be assigned to this Solicitor.

Table ATVDCYR

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVDCYR_CODE	NUMBER(4,0)	No	*
ATVDCYR_DESC	VARCHAR2(30)	No
ATVDCYR_START_DATE	DATE	No
ATVDCYR_END_DATE	DATE	No
ATVDCYR_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVDCYR	Unique	ATVDCYR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCRES	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRCTYP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCCM	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCDP	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCLB	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCPR	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCRL	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRCORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSOAG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSSAG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCNP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVGSOL	SQL View	S10B80.BANINST1	Use (select)
AGVPSOL	SQL View	S10B80.BANINST1	Use (select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
F_GIFT_SOCIETY_INFO	SQL Function	S10B80.BANINST1	Use (select)
ATVDCYRC	Oracle Package Cursor	S10B80.BANINST1.ATKDCYR	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
F_ATVDCYR_LIKE	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
ATVDCYR	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_ATVDCYR	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVDCYR

Object Dates

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

Source Code Comments

Gift Society Year Validation Table

Columns Comments for ATVDCYR_CODE (# 1)

Source Code Comments

This field specifies the code for a gift society year.

Columns Comments for ATVDCYR_DESC (# 2)

Source Code Comments

This field specifies the description of the gift society club year.

Columns Comments for ATVDCYR_START_DATE (# 3)

Source Code Comments

This field specifies the beginning date of the gift society year.

Columns Comments for ATVDCYR_END_DATE (# 4)

Source Code Comments

This field specifies the ending date of the gift society year.

Columns Comments for ATVDCYR_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table ATVSOTP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVSOTP_CODE	VARCHAR2(2)	No	*
ATVSOTP_DESC	VARCHAR2(30)	No
ATVSOTP_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVSOTP	Unique	ATVSOTP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSOTPC	Oracle Package Cursor	S10B80.BANINST1.ATKSOTP	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVSOTP	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_ATVSOTP	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVSOTP

Object Dates

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

Source Code Comments

Solicitor Org Type Validation Table

Columns Comments for ATVSOTP_CODE (# 1)

Source Code Comments

This field specifies the code for the type of solicitor organization.

Columns Comments for ATVSOTP_DESC (# 2)

Source Code Comments

This field specifies the description of the solicitor organization code.

Columns Comments for ATVSOTP_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table ATVSSTA

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVSSTA_CODE	VARCHAR2(1)	No	*
ATVSSTA_DESC	VARCHAR2(30)	No
ATVSSTA_ACTIVE_IND	VARCHAR2(1)	No
ATVSSTA_ACTIVITY_DATE	DATE	No
ATVSSTA_USER	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVSSTA	Unique	ATVSSTA_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRCSLT	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASVCSTA	SQL View	S10B80.BANINST1	Use (select)
ASVSORG	SQL View	S10B80.BANINST1	Use (select)
ASVSSTA	SQL View	S10B80.BANINST1	Use (select)
ATVSSTA	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_ATVSSTA	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVSSTA

Object Dates

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

Source Code Comments

Solicitor/Organization Status Validation Table

Columns Comments for ATVSSTA_CODE (# 1)

Source Code Comments

Solicitor/Orgnaization Status Code

Columns Comments for ATVSSTA_DESC (# 2)

Source Code Comments

Description of them Solicitor/Orgnaization Status Code

Columns Comments for ATVSSTA_ACTIVE_IND (# 3)

Source Code Comments

Indicator used to determine if the value of the status code means active. Y indicates active, N indicates inactive.

Columns Comments for ATVSSTA_ACTIVITY_DATE (# 4)

Source Code Comments

Date the code was created or last updated

Columns Comments for ATVSSTA_USER (# 5)

Source Code Comments

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

Table AXRMSOL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
A$_AGBPLDG_EXPMG_DEL_TRG	SQL Trigger	S10B80.ALUMNI	Use (delete,select)
A$_AGRPSOL_EXPMG_UPD_TRG	SQL Trigger	S10B80.ALUMNI	Use (Insert,update,delete,select)Rely On
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (Insert)
AXRMSOL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AXRMSOL_KEY_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AXRMSOL_PIDM_INDEX	SQL Index	S10B80.ALUMNI	Rely On
AGBPLDG	SQL Table	S10B80.ALUMNI	Join
AGRPSOL	SQL Table	S10B80.ALUMNI	Join
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
AXRMCAM	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AXRMSOL

Object Dates

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

Source Code Comments

Expected Matching Gift Solicitation repeating table.

Columns Comments for AXRMSOL_PIDM (# 1)

Source Code Comments

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

Columns Comments for AXRMSOL_EMPR_PIDM (# 2)

Source Code Comments

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

Columns Comments for AXRMSOL_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AXRMSOL_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AXRMSOL_AMT (# 5)

Source Code Comments

This field specifies the amount of the pledge.

Columns Comments for AXRMSOL_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for AXRMSOL_SOLC_CODE (# 7)

Source Code Comments

This field specifies the solicitor code.

Columns Comments for AXRMSOL_SOL_ORG (# 8)

Source Code Comments

This field specifies the solicitor organization code.

Columns Comments for AXRMSOL_SOL_PIDM (# 9)

Source Code Comments

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

Table STVATYP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
STVATYP_CODE	VARCHAR2(2)	No	*
STVATYP_DESC	VARCHAR2(30)	Yes
STVATYP_ACTIVITY_DATE	DATE	No
STVATYP_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVATYP_TELE_CODE	VARCHAR2(4)	Yes		*
STVATYP_UPDATE_WEB_IND	RAW(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVATYP_TELE_CODE	STVTELE_CODE	STVTELE

Index

Index Name	Index Type	Column Name
PK_STVATYP	Unique	STVATYP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AABDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMEMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGASC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPASC	SQL Table	S10B80.ALUMNI	Refer (no action)
AMBMAIL	SQL Table	S10B80.ALUMNI	Refer (no action)
AOBORGN	SQL Table	S10B80.ALUMNI	Refer (no action)
AORCONT	SQL Table	S10B80.ALUMNI	Refer (no action)
APBCONS	SQL Table	S10B80.ALUMNI	Refer (no action)
APBWIDN	SQL Table	S10B80.ALUMNI	Refer (no action)
APRCHLD	SQL Table	S10B80.ALUMNI	Refer (no action)
APRMAIL	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
GERATTD	SQL Table	S10B80.GENERAL	Refer (no action)
GERPART	SQL Table	S10B80.GENERAL	Refer (no action)
GOBSEVS	SQL Table	S10B80.GENERAL	Refer (no action)
GORADRL	SQL Table	S10B80.GENERAL	Join
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVAS	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVEI	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSDAX	SQL Table	S10B80.GENERAL	Join
GURAPAY	SQL Table	S10B80.GENERAL	Refer (no action)
PXR1099	SQL Table	S10B80.PAYROLL	Refer (no action)
PXRMTTN	SQL Table	S10B80.PAYROLL	Refer (no action)
RHRRQST	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWAPP	SQL Table	S10B80.SATURN	Refer (no action)
SORFOLK	SQL Table	S10B80.SATURN	Refer (no action)
SORMSTA	SQL Table	S10B80.SATURN	Refer (no action)
SORXREF	SQL Table	S10B80.SATURN	Join
SPRADDR	SQL Table	S10B80.SATURN	Refer (no action)
SPREMRG	SQL Table	S10B80.SATURN	Refer (no action)
SPRTELE	SQL Table	S10B80.SATURN	Refer (no action)
SRBWPRO	SQL Table	S10B80.SATURN	Refer (no action)
SRTADDR	SQL Table	S10B80.SATURN	Refer (no action)
SRTTELE	SQL Table	S10B80.SATURN	Refer (no action)
APVADRS	SQL View	S10B80.BANINST1	Use (select)
PPVADRS	SQL View	S10B80.BANINST1	Use (select)
RPVADDR	SQL View	S10B80.BANINST1	Use (select)
RPVADRS	SQL View	S10B80.BANINST1	Use (select)
RPVFDRS	SQL View	S10B80.BANINST1	Use (select)
SAVADRS	SQL View	S10B80.BANINST1	Use (select)
SGVADRS	SQL View	S10B80.BANINST1	Use (select)
SPVADDF	SQL View	S10B80.BANINST1	Use (select)
SPVADDI	SQL View	S10B80.BANINST1	Use (select)
SPVADDI_OJ	SQL View	S10B80.BANINST1	Use (select)
SPVADDS	SQL View	S10B80.BANINST1	Use (select)
SPVADRS	SQL View	S10B80.BANINST1	Use (select)
SRVADRS	SQL View	S10B80.BANINST1	Use (select)
F_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ADDRESS_LINK_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
ADDRESS_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKPREF	Rely On
ADDR_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKMAIL	Rely On
MAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKMAIL	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPREF	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKPREF	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
GETALLATYPC	Oracle Package Cursor	S10B80.BANINST1.BWDKPREF	Use (select)
GETALLATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
GETSTVATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKPREF	Use (select)
GETSTVATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
SPRADDRLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDR_ACTIVE_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Use (select)
SPRADDR_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
SPRADDR_ALL_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Use (select)
SPRADDR_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKRQST	Use (select)
SPRADDR_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
STVATYPUPDATEC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWLKOSAD	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
P_DEFAULT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)
P_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
ATYP	Oracle Package Variable	S10B80.BANINST1.BWSKAADR	Rely On
GV_ATYP_CODE1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_ATYP_CODE2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_ATYP_CODE3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_FRN_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
GV_US_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWLKOSAD	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
F_BUILD_STUDENT	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_STUDENT_COLLECTION	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_CHK_SPRADDR	Oracle Package Function	S10B80.BANINST1.SAKL050	Use (select)
F_GETQUALIFIERS	Oracle Package Function	S10B80.BANINST1.BWSKAPAR	Rely On
F_GETQUALIFIERS	Oracle Package Function	S10B80.BANINST1.BWSKAPAR	Use (select)
F_GETQUALIFIERS	Oracle Package Function	S10B80.BANINST1.BWSKAADR	Use (select)
F_GET_ADDR_TYPE	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Use (select)
F_GET_MAX_ADDRESS_SEQNO	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
APRMAILGETVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
APRMAILVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
SPRADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
STVATYPC	Oracle Package Cursor	S10B80.BANINST1.STKATYP	Use (select)Rely On
STVATYP_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVATYP	Rely On
STVATYP_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVATYP	Use (select)Rely On
P_APTADDR_IN_USE	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Rely On
P_DELETE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_DELETE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (delete)
P_DISPSTATUSSARADAP	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Use (select)
P_DISP_TRANSCRIPT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (select)
P_INSERT_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_INSERT_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (Insert)
P_LOOKUP	Oracle Package Procedure	S10B80.BANINST1.BWFKPROC	Rely On
P_LOOKUP	Oracle Package Procedure	S10B80.BANINST1.BWFKPROC	Use (select)
P_PA_STVATYP_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PA_STVATYP_HIERARCHY_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PREF_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWAKPREF	Use (select)
P_PROCESS_HOUSEHOLD_ADDR_RECS	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Use (select)
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_STVATYP_PRTY	Oracle Package Procedure	S10B80.BANINST1.SOKPVAL	Use (select)
P_UPDATE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_UPDATE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (update)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.TOKPVAL	Rely On
P_VALIDATEDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Rely On
P_VALIDATEDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (select)
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Rely On
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_TELEPHONE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_MEMO	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_CUSTOMER_PROFILE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_ORGANIZATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISPLAY_OPTIONS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISP_HIER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_RECEIVABLE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_RULES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_ADDRESS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EFDTEST	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_ENTITY_ADDRESS	Use (Insert,update)
F_ADDRESS_TELEPHONE_VALUE	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_ADDRESS_VALUE	Oracle Package Function	S10B80.BANINST1.P_ADDR_TELE	Rely On
F_ADD_ENTITY_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STVATYP	Rely On
F_EXPIRE_ENTITY_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_STVATYP	Rely On
F_GET_STUDENT_DATA	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_GET_VALID_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Rely On
F_GET_VALID_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
STVATYP	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_STVATYP	SQL Index	S10B80.SATURN	Rely On
STVTELE	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVATYP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:48:46:000	04/02/2008 21:18:11:000

Source Code Comments

Address Type Validation Table

Columns Comments for STVATYP_CODE (# 1)

Source Code Comments

A code used throughout all BANNER systems to identify the type of address for which information is maintained (for example; Mailing, Permanent, or Billing).

Columns Comments for STVATYP_DESC (# 2)

Source Code Comments

This field identifies the address type associated with the type code.

Columns Comments for STVATYP_ACTIVITY_DATE (# 3)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for STVATYP_SYSTEM_REQ_IND (# 4)

Source Code Comments

System Required Indicator

Columns Comments for STVATYP_TELE_CODE (# 5)

Source Code Comments

Default Telephone type code for telephone number.

Columns Comments for STVATYP_UPDATE_WEB_IND (# 6)

Source Code Comments

Web update indicator. This column is now obsolete. Refer to table goradrl

Table STVCOLL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
STVCOLL_CODE	VARCHAR2(2)	No	*
STVCOLL_DESC	VARCHAR2(30)	No
STVCOLL_ADDR_STREET_LINE1	VARCHAR2(75)	Yes
STVCOLL_ADDR_STREET_LINE2	VARCHAR2(75)	Yes
STVCOLL_ADDR_STREET_LINE3	VARCHAR2(75)	Yes
STVCOLL_ADDR_CITY	VARCHAR2(50)	Yes
STVCOLL_ADDR_STATE	VARCHAR2(2)	Yes
STVCOLL_ADDR_COUNTRY	VARCHAR2(28)	Yes
STVCOLL_ADDR_ZIP_CODE	VARCHAR2(10)	Yes
STVCOLL_ACTIVITY_DATE	DATE	Yes
STVCOLL_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVCOLL_VR_MSG_NO	NUMBER(6,0)	Yes
STVCOLL_STATSCAN_CDE3	VARCHAR2(6)	Yes
STVCOLL_DICD_CODE	VARCHAR2(3)	Yes
STVCOLL_HOUSE_NUMBER	VARCHAR2(10)	Yes
STVCOLL_ADDR_STREET_LINE4	VARCHAR2(75)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVCOLL	Unique	STVCOLL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AABMINT	SQL Table	S10B80.ALUMNI	Refer (no action)
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
APBCONS	SQL Table	S10B80.ALUMNI	Refer (no action)
APRADEG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVEMPH	SQL Table	S10B80.GENERAL	Refer (no action)
PEBEMPL	SQL Table	S10B80.PAYROLL	Refer (no action)
PERFASG	SQL Table	S10B80.PAYROLL	Refer (no action)
PERFNIO	SQL Table	S10B80.PAYROLL	Refer (no action)
PERFNIS	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRSCHD	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRSCLV	SQL Table	S10B80.PAYROLL	Refer (no action)
SARADAP	SQL Table	S10B80.SATURN	Refer (no action)
SARCHKB	SQL Table	S10B80.SATURN	Refer (no action)
SARDCSN	SQL Table	S10B80.SATURN	Refer (no action)
SARQKER	SQL Table	S10B80.SATURN	Refer (no action)
SARRRFT	SQL Table	S10B80.SATURN	Refer (no action)
SARWAAD	SQL Table	S10B80.SATURN	Refer (no action)
SARWADF	SQL Table	S10B80.SATURN	Refer (no action)
SCBCDEP	SQL Table	S10B80.SATURN	Refer (no action)
SCBCDTL	SQL Table	S10B80.SATURN	Refer (no action)
SCBCRSE	SQL Table	S10B80.SATURN	Refer (no action)
SCRCDTX	SQL Table	S10B80.SATURN	Refer (no action)
SCRFEES	SQL Table	S10B80.SATURN	Refer (no action)
SCRRCOL	SQL Table	S10B80.SATURN	Refer (no action)
SDBPROG	SQL Table	S10B80.SATURN	Refer (no action)
SFRMHRS	SQL Table	S10B80.SATURN	Refer (no action)
SFRRGFE	SQL Table	S10B80.SATURN	Refer (no action)
SFRTMSL	SQL Table	S10B80.SATURN	Refer (no action)
SFRTMST	SQL Table	S10B80.SATURN	Refer (no action)
SGBSTDN	SQL Table	S10B80.SATURN	Refer (no action)
SGRASSI	SQL Table	S10B80.SATURN	Refer (no action)
SHBCOMI	SQL Table	S10B80.SATURN	Refer (no action)
SHBGADS	SQL Table	S10B80.SATURN	Refer (no action)
SHBGELR	SQL Table	S10B80.SATURN	Refer (no action)
SHBGSCH	SQL Table	S10B80.SATURN	Refer (no action)
SHRASDL	SQL Table	S10B80.SATURN	Refer (no action)
SHRASGE	SQL Table	S10B80.SATURN	Refer (no action)
SHRASTR	SQL Table	S10B80.SATURN	Refer (no action)
SHRCAST	SQL Table	S10B80.SATURN	Refer (no action)
SHRCOMM	SQL Table	S10B80.SATURN	Refer (no action)
SHRDGMR	SQL Table	S10B80.SATURN	Refer (no action)
SHRPREV	SQL Table	S10B80.SATURN	Refer (no action)
SHRPRGE	SQL Table	S10B80.SATURN	Refer (no action)
SHRTCKN	SQL Table	S10B80.SATURN	Refer (no action)
SIRDPCL	SQL Table	S10B80.SATURN	Refer (no action)
SIRNIST	SQL Table	S10B80.SATURN	Refer (no action)
SIRNLVA	SQL Table	S10B80.SATURN	Refer (no action)
SMRACAA	SQL Table	S10B80.SATURN	Refer (no action)
SMRAQUA	SQL Table	S10B80.SATURN	Refer (no action)
SMRAREX	SQL Table	S10B80.SATURN	Refer (no action)
SMRARSA	SQL Table	S10B80.SATURN	Refer (no action)
SMRARUL	SQL Table	S10B80.SATURN	Refer (no action)
SMRGCAA	SQL Table	S10B80.SATURN	Refer (no action)
SMRGREX	SQL Table	S10B80.SATURN	Refer (no action)
SMRGRSA	SQL Table	S10B80.SATURN	Refer (no action)
SMRGRUL	SQL Table	S10B80.SATURN	Refer (no action)
SMRIECO	SQL Table	S10B80.SATURN	Refer (no action)
SMRPCRS	SQL Table	S10B80.SATURN	Refer (no action)
SMRPRLE	SQL Table	S10B80.SATURN	Refer (no action)
SMRPRRQ	SQL Table	S10B80.SATURN	Refer (no action)
SMRPRSA	SQL Table	S10B80.SATURN	Refer (no action)
SMRRQCM	SQL Table	S10B80.SATURN	Refer (no action)
SMRSACA	SQL Table	S10B80.SATURN	Refer (no action)
SMRSARE	SQL Table	S10B80.SATURN	Refer (no action)
SMRSARS	SQL Table	S10B80.SATURN	Refer (no action)
SMRSARU	SQL Table	S10B80.SATURN	Refer (no action)
SMRSGCA	SQL Table	S10B80.SATURN	Refer (no action)
SMRSGRE	SQL Table	S10B80.SATURN	Refer (no action)
SMRSGRS	SQL Table	S10B80.SATURN	Refer (no action)
SMRSGRU	SQL Table	S10B80.SATURN	Refer (no action)
SMRSPRS	SQL Table	S10B80.SATURN	Refer (no action)
SMTPRRQ	SQL Table	S10B80.SATURN	Refer (no action)
SOBCSPR	SQL Table	S10B80.SATURN	Refer (no action)
SOBCURR	SQL Table	S10B80.SATURN	Refer (no action)
SOBEXCR	SQL Table	S10B80.SATURN	Refer (no action)
SOBODTE	SQL Table	S10B80.SATURN	Refer (no action)
SOBROPR	SQL Table	S10B80.SATURN	Refer (no action)
SORCCOL	SQL Table	S10B80.SATURN	Refer (no action)
SORCOMM	SQL Table	S10B80.SATURN	Refer (no action)
SORDEGR	SQL Table	S10B80.SATURN	Refer (no action)
SOREQUI	SQL Table	S10B80.SATURN	Refer (no action)
SOREXTN	SQL Table	S10B80.SATURN	Refer (no action)
SORLCDF	SQL Table	S10B80.SATURN	Refer (no action)
SORLCUR	SQL Table	S10B80.SATURN	Refer (no action)
SORRFND	SQL Table	S10B80.SATURN	Refer (no action)
SORRSTS	SQL Table	S10B80.SATURN	Refer (no action)
SORWDSP	SQL Table	S10B80.SATURN	Join
SRBPRED	SQL Table	S10B80.SATURN	Refer (no action)
SRBRECR	SQL Table	S10B80.SATURN	Refer (no action)
SRTPREL	SQL Table	S10B80.SATURN	Refer (no action)
SSBDFEE	SQL Table	S10B80.SATURN	Refer (no action)
SSBOVRR	SQL Table	S10B80.SATURN	Refer (no action)
SSRFEES	SQL Table	S10B80.SATURN	Refer (no action)
SSRRCOL	SQL Table	S10B80.SATURN	Refer (no action)
SSRRESV	SQL Table	S10B80.SATURN	Refer (no action)
ST_STVCOLL_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
AG_EVENTS_AND_FUNCTIONS	SQL View	S10B80.BANINST1	Use (select)
GEVEVN1	SQL View	S10B80.BANINST1	Join
SAVADMT	SQL View	S10B80.BANINST1	Use (select)
SOVCOLL	SQL View	S10B80.BANINST1	Use (select)
SOVDATA	SQL View	S10B80.BANINST1	Use (select)
SOVDEGR	SQL View	S10B80.BANINST1	Use (select)
SOVDGMR	SQL View	S10B80.BANINST1	Use (select)
SOVDGMR_OJ	SQL View	S10B80.BANINST1	Use (select)
SOVSTDN	SQL View	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
COLLEGE_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSCKCOM	Rely On
COLL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKSRCH	Rely On
SORCMJRC	Oracle Package Cursor	S10B80.BANINST1.BWSKXMIS	Use (select)
STVCOLLVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKLIBS	Use (select)Rely On
STVCOLL_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.SOKTABS	Rely On
STVCOLL_REC	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
STVCOLL_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPSRC	Rely On
STVCOLL_REC	Oracle Package Variable	S10B80.BANINST1.BWDKLIBS	Rely On
STVCOLL_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
COLLEGE_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSCKLDI	Rely On
GT_CURRICULUM_REC	Oracle Package Type	S10B80.BANINST1.SP_HOUSING_PROFILE	Rely On
GETSTVCOLLC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
PREFCOLLVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKSRCH	Use (select)Rely On
PREFCOLLVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
STVCOLLVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKSRCH	Use (select)Rely On
STVCOLLVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
STVCOLLVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
STVCOLL_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Rely On
STVCOLL_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
STVCOLL_C	Oracle Package Cursor	S10B80.BANINST1.BWCKSMDS	Use (select)
STVCOLL_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
P_CREATE_APPL	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Rely On
P_DELETE_ALL	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR	Use (delete,select)
P_LEARNER_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Rely On
P_LEARNER_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.TS_SB_GRADEROLL	Rely On
P_LEARNER_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Rely On
P_LEARNER_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Rely On
P_LEARNER_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
P_ONETIMEVALUES	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Rely On
P_ONETIMEVALUES	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
P_PRINT_COLLEGES	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_PROC_SET_INFO	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_SFRRGFE	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Rely On
P_SFRRGFE	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Rely On
P_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBC	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBT	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_GRADEROLL	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_DD	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Use (Insert)
P_VALIDATION_DATA	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_SWAPPING	Use (Insert)
TESTCASE_CC	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Rely On
STVCOLL_REC	Oracle Package Variable	S10B80.BANINST1.BWSKRSTA	Rely On
STVCOLL_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
APBCONSCOLLSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKSRCH	Use (select)
STVCOLLC	Oracle Package Cursor	S10B80.BANINST1.STKCOLL	Use (select)Rely On
STVCOLL_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVCOLL	Rely On
STVCOLL_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVCOLL	Use (select)Rely On
STVCOLL_WDSP_C	Oracle Package Cursor	S10B80.BANINST1.BWCKLIBS	Use (select)Rely On
P_CAT_SEARCH	Oracle Package Procedure	S10B80.BANINST1.BWCKCTLG	Rely On
P_CHECKBASE	Oracle Package Procedure	S10B80.BANINST1.SOKCURR	Rely On
P_CHECKCURRICULUM	Oracle Package Procedure	S10B80.BANINST1.SOKCURR	Rely On
P_CHECKPROGRAMMAJOR	Oracle Package Procedure	S10B80.BANINST1.SOKCURR	Rely On
P_CREATE_SECTION_DFT_RULES	Oracle Package Procedure	S10B80.BANINST1.SSKOLRP	Rely On
P_DELETE_STVCOLL	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_DELETE_STVCOLL	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (delete)
P_DISPCURRENT_TABLE	Oracle Package Procedure	S10B80.BANINST1.BWCKCAPP	Rely On
P_DISPLAY_COURSES	Oracle Package Procedure	S10B80.BANINST1.SB_COURSE_CATALOG	Rely On
P_DISPLAY_COURSES	Oracle Package Procedure	S10B80.BANINST1.BWCKCTLG	Rely On
P_DISPLAY_INFO	Oracle Package Procedure	S10B80.BANINST1.BWCKCTLG	Rely On
P_DISPLAY_INFO	Oracle Package Procedure	S10B80.BANINST1.BWCKCTLG	Use (select)Rely On
P_DISPLAY_STEP_EIGHT	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_DISPLAY_STEP_FIVE	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_DISPLAY_STEP_FOUR	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_DISPLAY_STEP_NINE	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_DISPLAY_STEP_SEVEN	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_DISPLAY_STEP_SIX	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_DISPLAY_STEP_THREE	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_DISPLAY_STEP_THREE	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Use (select)Rely On
P_DISP_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_PAYMENT_TYPE	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANSCRIPT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANSCRIPT_REQUEST_DATA	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANSCRIPT_REQUEST_TYPE	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANS_REQUEST_CHARGES	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DO_WHATIF_CAPP	Oracle Package Procedure	S10B80.BANINST1.BWCKCMPL	Rely On
P_FACCLAWAITSUM	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FACSCHED	Oracle Package Procedure	S10B80.BANINST1.BWLKIFAC	Rely On
P_FORMAT_BASE_CURR	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_GETACCESSIBLECOLLDEPT	Oracle Package Procedure	S10B80.BANINST1.SOKEPRT	Use (select)
P_GET_SMBPOGN	Oracle Package Procedure	S10B80.BANINST1.SMKXAPI	Rely On
P_GET_SMRAOSA	Oracle Package Procedure	S10B80.BANINST1.SMKXAPI	Rely On
P_GET_SMRDOEX	Oracle Package Procedure	S10B80.BANINST1.SMKXAPI	Rely On
P_GET_SMRGOSA	Oracle Package Procedure	S10B80.BANINST1.SMKXAPI	Rely On
P_GET_SMRPOSA	Oracle Package Procedure	S10B80.BANINST1.SMKXAPI	Rely On
P_GET_SMRRQCM	Oracle Package Procedure	S10B80.BANINST1.SMKXAPI	Rely On
P_GET_STVCOLL_ROW	Oracle Package Procedure	S10B80.BANINST1.STKSELS	Rely On
P_INSERT_STVCOLL	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_INSERT_STVCOLL	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (Insert)
P_INSERT_WHATIF_SMRRQCM	Oracle Package Procedure	S10B80.BANINST1.BWCKCMPL	Rely On
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_PRINT_CRSE_INFO_WINDOW	Oracle Package Procedure	S10B80.BANINST1.BWPKFLDT	Rely On
P_SAVE_COLLEGE	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SEND_COLLEGE	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_UPDATE_STVCOLL	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_UPDATE_STVCOLL	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (update)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
P_VERIFYDATA	Oracle Package Procedure	S10B80.BANINST1.SOKCURR	Rely On
P_WHATIF_FINAL_STEP	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_WHATIF_NEXT_STEP	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_WHATIF_SUBMIT	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FIELDOFSTUDY	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_GRADAPP_ELIGIBLE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CLASSTIMES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_LEARNERMODULE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_TRANSCRIPT_REQ_NAME	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_BLDGDEFINITION	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_GRADAPP_SELRULE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_INSTITUTION_ROLE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_PCOL_DEGREE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_SECTION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_FAC_SCHRATE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_FAC_NISTCOMP	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_CURRICULUM	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_COURSE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_FAC_SCLRATE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_BLDGDEFINITION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_WL_NOTIFICATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_WL_REORDERING	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_COURSE_LABOR	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDICOURSE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_LEARNER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_WL_EXCLUSION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_FAC_NIOLCOMP	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_TRANSFER_CRSE	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_TRANSFER_CRSE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_CRSE_SELECT_PRI	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_SECTION_LABOR	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FACASSIGNMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FACULTY	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_WL_COLLECTOR	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_WL_SECTION_CTRL	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_LEARNEROUTCOME	Use (Insert,select)
UT_TEARDOWN	Oracle Package Procedure	S10B80.BANINST1.UT_SB_BLDGDEFINITION	Use (delete)
F_CHECKCURRICULUM	Oracle Package Function	S10B80.BANINST1.SAKDCRV	Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STVCOLL	Rely On
F_COLL_CHK	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
F_FTE_FACTOR	Oracle Package Function	S10B80.BANINST1.SIKLOAD	Rely On
F_GETCODEDESCRIPTION	Oracle Package Function	S10B80.BANINST1.BWLKSECR	Use (select)
F_GET_COLLEGE	Oracle Package Function	S10B80.BANINST1.ICSCKLDI	Rely On
F_GET_COLLEGE	Oracle Package Function	S10B80.BANINST1.ICSCKCOM	Rely On
F_GET_COLLEGE	Oracle Package Function	S10B80.BANINST1.ICSCKCOM	Use (select)
F_GET_COLL_DESC	Oracle Package Function	S10B80.BANINST1.STVFUNC	Rely On
F_GET_COLL_DESC	Oracle Package Function	S10B80.BANINST1.STVFUNC	Use (select)
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_STVCOLL	Rely On
F_MATCH_CURRICULUM	Oracle Package Function	S10B80.BANINST1.SOKCCUR	Rely On
F_NIST_COMPENSATION_APPLIED	Oracle Package Function	S10B80.BANINST1.SIKAFLA	Rely On
F_NIST_COMPENSATION_EXTRACTED	Oracle Package Function	S10B80.BANINST1.SIKAFLA	Rely On
F_STVCOLL_LIKE	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
GET_COLL_DESC	Oracle Package Function	S10B80.BANINST1.BWCKSMDS	Rely On
GET_COLL_DESC	Oracle Package Function	S10B80.BANINST1.BWCKSMDS	Use (select)
GET_COLL_DESC	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Rely On
GET_COLL_DESC	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Use (select)
GET_COLL_DESC	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Rely On
GET_COLL_DESC	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Use (select)
STVCOLL	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_STVCOLL	SQL Index	S10B80.SATURN	Rely On
ST_STVCOLL_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_STVCOLL_AS_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVCOLL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:50:54:000	04/02/2008 21:18:13:000

Source Code Comments

College Validation Table

Columns Comments for STVCOLL_CODE (# 1)

Source Code Comments

This field identifies the college code referenced in the Catalog, Class Schedule, Recruiting, Admissions, General Student, Registration, Academic History and Degree Audit Modules. Reqd value: 00 - No College Designated.

Columns Comments for STVCOLL_DESC (# 2)

Source Code Comments

This field specifies the college or school (i.e. **Banner"s** highest administrative unit) associated with the college code.

Columns Comments for STVCOLL_ADDR_STREET_LINE1 (# 3)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STREET_LINE2 (# 4)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STREET_LINE3 (# 5)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_CITY (# 6)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STATE (# 7)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_COUNTRY (# 8)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_ZIP_CODE (# 9)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ACTIVITY_DATE (# 10)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for STVCOLL_SYSTEM_REQ_IND (# 11)

Source Code Comments

System Required Indicator

Columns Comments for STVCOLL_VR_MSG_NO (# 12)

Source Code Comments

The Voice Response message number assigned to the recorded message that describes the college code.

Columns Comments for STVCOLL_STATSCAN_CDE3 (# 13)

Source Code Comments

Statistics Canadian reporting institution specific code.

Columns Comments for STVCOLL_DICD_CODE (# 14)

Source Code Comments

MIS DISTRICT/DIVISION CODE: This field indicates equivalent district or division associated with an Institution.

Columns Comments for STVCOLL_HOUSE_NUMBER (# 15)

Source Code Comments

HOUSE NUMBER: Building or lot number on a street or in an area.

Columns Comments for STVCOLL_ADDR_STREET_LINE4 (# 16)

Source Code Comments

This field is not currently in use.

Link between AFRCTYP and AFRCRES

Join Information

Objects list
schema-view : S10B80.BANINST1.APVSRES

Link List

Link Type	Link	Project
Join	Link Between AFRCTYP and AFRCRES	ALUMNI

List of Real links

Link type	Between	And
Join	AFRCTYP	AFRCRES

Link between ASRSORG and ASRSSAG

Join Information

Objects list
schema-view : S10B80.BANINST1.ASVSSAG

Link List

Link Type	Link	Project
Join	Link Between ASRSORG and ASRSSAG	ALUMNI

List of Real links

Link type	Between	And
Join	ASRSORG	ASRSSAG

Link between AFRCTYP and ASRSORG

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between AFRCTYP and ASRSORG	ALUMNI

List of Real links

Link type	Between	And
Join	AFRCTYP	ASRSORG

Link between AFRCTYP and AFRCSLT

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between AFRCTYP and AFRCSLT	ALUMNI

List of Real links

Link type	Between	And
Join	AFRCTYP	AFRCSLT

Link between AFRCORG and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCORG and ASBSORG (FK1_AFRCORG_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCORG	AFRCORG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(1,1)-(0,n)

Link between AFRCRES and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCRES and ASBSORG (FK1_AFRCRES_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCRES	AFRCRES_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Link between AFRCSLT and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCSLT and ASBSORG (FK1_AFRCSLT_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCSLT	AFRCSLT_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Link between AFRCTYP and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCTYP and ASBSORG (FK1_AFRCTYP_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCTYP	AFRCTYP_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Link between AGBWPLG and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBWPLG and ASBSORG (FK1_AGBWPLG_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBWPLG	AGBWPLG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Link between AGRMSOL and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRMSOL and ASBSORG (FK1_AGRMSOL_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRMSOL	AGRMSOL_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Link between AGRPSOL and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRPSOL and ASBSORG (FK1_AGRPSOL_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRPSOL	AGRPSOL_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Link between ASRCOMT and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRCOMT and ASBSORG (FK1_ASRCOMT_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRCOMT	ASRCOMT_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(1,1)-(0,n)

Link between ASRCONT and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRCONT and ASBSORG (FK1_ASRCONT_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRCONT	ASRCONT_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(1,1)-(0,n)

Link between ASRCORG and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRCORG and ASBSORG (FK1_ASRCORG_INV_ASBSORG_KEY)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between ASRCORG and ASBSORG (FK2_ASRCORG_INV_ASBSORG_KEY)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between ASRCORG and ASBSORG (FK3_ASRCORG_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRCORG	ASRCORG_SOL_ORG_KEY	ASBSORG_SOL_ORG	ASBSORG	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRCORG	ASRCORG_SOL_ORG_UP	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRCORG	ASRCORG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(1,1)-(0,n)

Link between ASRSOAG and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRSOAG and ASBSORG (FK1_ASRSOAG_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRSOAG	ASRSOAG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(1,1)-(0,n)

Link between ASRSORG and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRSORG and ASBSORG (FK1_ASRSORG_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRSORG	ASRSORG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(1,1)-(0,n)

Link between ASRSSAG and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRSSAG and ASBSORG (FK1_ASRSSAG_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRSSAG	ASRSSAG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(1,1)-(0,n)

Link between AXRMSOL and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AXRMSOL and ASBSORG (FK1_AXRMSOL_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AXRMSOL	AXRMSOL_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Link between ASBSORG and ATVSOTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASBSORG and ATVSOTP (FK1_ASBSORG_INV_ATVSOTP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASBSORG	ASBSORG_SOTP_CODE	ATVSOTP_CODE	ATVSOTP	(1,1)-(0,n)

Link between AFRCSLT and ATVSSTA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCSLT and ATVSSTA (FK1_AFRCSLT_INV_ATVSSTA_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCSLT	AFRCSLT_SSTA_CODE	ATVSSTA_CODE	ATVSSTA	(0,1)-(0,n)

Link between ASBSORG and ATVSSTA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASBSORG and ATVSSTA (FK1_ASBSORG_INV_ATVSSTA_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASBSORG	ASBSORG_SSTA_CODE	ATVSSTA_CODE	ATVSSTA	(0,1)-(0,n)

Link between ASRSORG and ATVSSTA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRSORG and ATVSSTA (FK1_ASRSORG_INV_ATVSSTA_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRSORG	ASRSORG_SSTA_CODE	ATVSSTA_CODE	ATVSSTA	(0,1)-(0,n)

Link between AGBPDEF and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBPDEF and ASBSORG (FK1_AGBPDEF_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBPDEF	AGBPDEF_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Link between AFRCRES and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCRES and ATVDCYR (FK1_AFRCRES_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCRES	AFRCRES_DCYR_CODE	ATVDCYR_CODE	ATVDCYR	(0,1)-(0,n)

Link between AFRCTYP and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRCTYP and ATVDCYR (FK1_AFRCTYP_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRCTYP	AFRCTYP_DCYR_CODE	ATVDCYR_CODE	ATVDCYR	(0,1)-(0,n)

Link between AGBWPLG and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBWPLG and ATVDCYR (FK1_AGBWPLG_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBWPLG	AGBWPLG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR	(0,1)-(0,n)

Link between ASBSORG and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASBSORG and ATVDCYR (FK1_ASBSORG_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASBSORG	ASBSORG_YEAR	ATVDCYR_CODE	ATVDCYR	(0,1)-(0,n)

Link between ASRCORG and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRCORG and ATVDCYR (FK1_ASRCORG_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRCORG	ASRCORG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR	(1,1)-(0,n)

Link between ASRSOAG and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRSOAG and ATVDCYR (FK1_ASRSOAG_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRSOAG	ASRSOAG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR	(1,1)-(0,n)

Link between ASRSSAG and ATVDCYR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRSSAG and ATVDCYR (FK1_ASRSSAG_INV_ATVDCYR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRSSAG	ASRSSAG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR	(1,1)-(0,n)

Link between AGRGSOL and ASBSORG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRGSOL and ASBSORG (FK1_AGRGSOL_INV_ASBSORG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRGSOL	AGRGSOL_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG	(0,1)-(0,n)

Link between AXRMSOL and AGRPSOL

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between AXRMSOL and AGRPSOL	ALUMNI

List of Real links

Link type	Between	And
Join	AXRMSOL	AGRPSOL

Link between ASBSORG and STVATYP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASBSORG and STVATYP (FK1_ASBSORG_INV_STVATYP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASBSORG	ASBSORG_ATYP_CODE	STVATYP_CODE	STVATYP	(0,1)-(0,n)

Link between ASRSORG and STVATYP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASRSORG and STVATYP (FK1_ASRSORG_INV_STVATYP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASRSORG	ASRSORG_ATYP_CODE	STVATYP_CODE	STVATYP	(0,1)-(0,n)

Link between ASBSORG and STVCOLL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ASBSORG and STVCOLL (FK1_ASBSORG_INV_STVCOLL_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ASBSORG	ASBSORG_COLL_CODE	STVCOLL_CODE	STVCOLL	(0,1)-(0,n)