Model Designation*

Model Label :

List of Objects

Object Name	Object Type	Layer Name
ADBDESG	SQL Table	Default
ADRADAJ	SQL Table	Default
ADRATTR	SQL Table	Default
ADRCONF	SQL Table	Default
ADRDIDS	SQL Table	Default
ADRFUND	SQL Table	Default
ADRSUMM	SQL Table	Default
AFRDESG	SQL Table	Default
AGBWPLG	SQL Table	Default
AGRGDES	SQL Table	Default
AGRGHDE	SQL Table	Default
AGRPDES	SQL Table	Default
AMRDESG	SQL Table	Default
APRDHIS	SQL Table	Default
ATVCFAE	SQL Table	Default
ATVCMTP	SQL Table	Default
ATVDGRP	SQL Table	Default
ATVDSTA	SQL Table	Default
ATVDSTP	SQL Table	Default
AXRMDES	SQL Table	Default
STVCOLL	SQL Table	Default
STVDEPT	SQL Table	Default

Model View

Table ADBDESG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ADBDESG_DESG	VARCHAR2(10)	No	*	*
ADBDESG_NAME	VARCHAR2(60)	No
ADBDESG_GL_NO_CREDIT	VARCHAR2(60)	Yes
ADBDESG_GL_NO_DEBIT	VARCHAR2(60)	Yes
ADBDESG_RESTR_IND	VARCHAR2(1)	No
ADBDESG_COLL_CODE	VARCHAR2(2)	Yes		*
ADBDESG_CMTP_CODE	VARCHAR2(2)	Yes		*
ADBDESG_CFAE_CODE	VARCHAR2(5)	No		*
ADBDESG_AMT_PLEDGED	NUMBER(13,2)	Yes
ADBDESG_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
ADBDESG_AMT_GIFT	NUMBER(13,2)	Yes
ADBDESG_ACTIVITY_DATE	DATE	No
ADBDESG_COAS_CODE	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE	VARCHAR2(6)	Yes
ADBDESG_DSTP_CODE	VARCHAR2(5)	No		*
ADBDESG_COAS_CODE_PLDG	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_GL_NO_CREDIT_PLDG	VARCHAR2(60)	Yes
ADBDESG_USER	VARCHAR2(30)	No
ADBDESG_START_DATE	DATE	Yes
ADBDESG_END_DATE	DATE	Yes
ADBDESG_DSTA_CODE	VARCHAR2(1)	Yes		*
ADBDESG_DGRP_CODE	VARCHAR2(5)	Yes		*
ADBDESG_DEPT_CODE	VARCHAR2(4)	Yes		*
ADBDESG_COAS_CODE_EXPND	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_GL_NO_CREDIT_EXPND	VARCHAR2(60)	Yes
ADBDESG_COAS_CODE_PYMNT	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_GL_NO_CREDIT_PYMNT	VARCHAR2(60)	Yes
ADBDESG_WEB_GIFT_IND	VARCHAR2(1)	Yes
ADBDESG_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADBDESG_CFAE_CODE	ATVCFAE_CODE	ATVCFAE
ADBDESG_CMTP_CODE	ATVCMTP_CODE	ATVCMTP
ADBDESG_DGRP_CODE	ATVDGRP_CODE	ATVDGRP
ADBDESG_DSTA_CODE	ATVDSTA_CODE	ATVDSTA
ADBDESG_DSTP_CODE	ATVDSTP_CODE	ATVDSTP
ADBDESG_COLL_CODE	STVCOLL_CODE	STVCOLL
ADBDESG_DEPT_CODE	STVDEPT_CODE	STVDEPT
ADBDESG_DESG	AGRGDES_DESG	AGRGDES
ADBDESG_DESG	APRDHIS_DESG	APRDHIS

Index

Index Name	Index Type	Column Name
PK_ADBDESG	Unique	ADBDESG_DESG

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADRADAJ	SQL Table	S10B80.ALUMNI	Refer (no action)
ADRATTR	SQL Table	S10B80.ALUMNI	Refer (no action)
ADRCONF	SQL Table	S10B80.ALUMNI	Refer (no action)
ADRDIDS	SQL Table	S10B80.ALUMNI	Refer (no action)
ADRFUND	SQL Table	S10B80.ALUMNI	Refer (no action)
ADRSUMM	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGHDE	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPDES	SQL Table	S10B80.ALUMNI	Join
AMRDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AXRMDES	SQL Table	S10B80.ALUMNI	Join
ADVAWRD	SQL View	S10B80.BANINST1	Use (select)
ADVDSG1	SQL View	S10B80.BANINST1	Use (select)
AGVGFD1	SQL View	S10B80.BANINST1	Use (select)
AGVGFD2	SQL View	S10B80.BANINST1	Join
AGVGLST	SQL View	S10B80.BANINST1	Use (select)
AGVGMD1	SQL View	S10B80.BANINST1	Use (select)
AGVGMEM	SQL View	S10B80.BANINST1	Join
AGVPINS	SQL View	S10B80.BANINST1	Use (select)
AGVPLD1	SQL View	S10B80.BANINST1	Use (select)
AGVPLD2	SQL View	S10B80.BANINST1	Join
AGVPLST	SQL View	S10B80.BANINST1	Use (select)
AXVPINS	SQL View	S10B80.BANINST1	Use (select)
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKPLDG	Rely On
DESGDHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
DESGDHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
ADBDESG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
ADBDESG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
ADBDESG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
ADBDESG_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCPMT	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKNGFT	Rely On
CAMPDESG_BALANCE	Oracle Package Type	S10B80.BANINST1.BWAKCPMT	Rely On
ADBDESGC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
ADBDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
ADBDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
ADBDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNHIS	Use (select)Rely On
ADBDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)Rely On
ADBDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
ADBDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)
ALLAFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
ALLAFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
CAMPDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
DEFDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
DEFDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
DESGDHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGDHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
INDIVIDSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
INSTSPLITRULEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
P_GIVINGSUMMARY	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (update)
ADBDESG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKNHIS	Rely On
ADBDESG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
DESG	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
P_CHECK_IF_PAYABLE	Oracle Package Procedure	S10B80.BANINST1.BWAKLIBS	Use (select)
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Use (select)
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
F_ADBDESG_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
ADBDESG	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_ADBDESG	SQL Index	S10B80.ALUMNI	Rely On
AGRGDES	SQL Table	S10B80.ALUMNI	Join
APRDHIS	SQL Table	S10B80.ALUMNI	Join
ATVCFAE	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVCMTP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDGRP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDSTA	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDSTP	SQL Table	S10B80.ALUMNI	Refer (no action)
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ADBDESG

Object Dates

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

Source Code Comments

Designation Base Table

Columns Comments for ADBDESG_DESG (# 1)

Source Code Comments

This field specifies the five character alphanumeric designation code. Upon entry of this code, the Designation List Form is automatically updated.

Columns Comments for ADBDESG_NAME (# 2)

Source Code Comments

This field specifies the name of the designation. The name automatically defaults to this field.

Columns Comments for ADBDESG_GL_NO_CREDIT (# 3)

Source Code Comments

This field specifies the general ledger credit account number associated with the designation.

Columns Comments for ADBDESG_GL_NO_DEBIT (# 4)

Source Code Comments

General ledger debit account number is entered on ATVGIFT-Gift Type Validation Form. Not Used.

Columns Comments for ADBDESG_RESTR_IND (# 5)

Source Code Comments

This field indicates if the designation is retricted to transfer of pledges and/or gifts across fiscal years.

Columns Comments for ADBDESG_COLL_CODE (# 6)

Source Code Comments

This field specifies the college code associated with the designation.

Columns Comments for ADBDESG_CMTP_CODE (# 7)

Source Code Comments

This field specifies the type of campaign to which the designation is associated.

Columns Comments for ADBDESG_CFAE_CODE (# 8)

Source Code Comments

This field specifies the Council for Financial Aid to Education code associated with the designation. This code specifies the purpose for which gifts and grants have been made for CFAE reporting.

Columns Comments for ADBDESG_AMT_PLEDGED (# 9)

Source Code Comments

This system maintained field specifies the total amount pledged for a specific designation.

Columns Comments for ADBDESG_AMT_PLEDGED_PAID (# 10)

Source Code Comments

This system maintained field specifies the total amount of pledge payments for a specific designation.

Columns Comments for ADBDESG_AMT_GIFT (# 11)

Source Code Comments

This system maintained field specifies the amount of gifts and pledge payments for a specific designation.

Columns Comments for ADBDESG_ACTIVITY_DATE (# 12)

Source Code Comments

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

Columns Comments for ADBDESG_COAS_CODE (# 13)

Source Code Comments

Banner Finance Chart of Accounts Code.

Columns Comments for ADBDESG_ACCI_CODE (# 14)

Source Code Comments

Banner Finance Account Index Code.

Columns Comments for ADBDESG_FUND_CODE (# 15)

Source Code Comments

Banner Finance Fund Code.

Columns Comments for ADBDESG_ORGN_CODE (# 16)

Source Code Comments

Banner Finance Organization Code.

Columns Comments for ADBDESG_ACCT_CODE (# 17)

Source Code Comments

Banner Finance Account Code.

Columns Comments for ADBDESG_PROG_CODE (# 18)

Source Code Comments

Banner Finance Program Code.

Columns Comments for ADBDESG_ACTV_CODE (# 19)

Source Code Comments

Banner Finance Activity Code.

Columns Comments for ADBDESG_LOCN_CODE (# 20)

Source Code Comments

Banner Finance Location Code.

Columns Comments for ADBDESG_DSTP_CODE (# 21)

Source Code Comments

This field indicates the designation type.

Columns Comments for ADBDESG_COAS_CODE_PLDG (# 22)

Source Code Comments

BANNER Finance Chart of Accounts Code for the Pledge.

Columns Comments for ADBDESG_ACCI_CODE_PLDG (# 23)

Source Code Comments

BANNER Finance Account Index Code for the Pledge.

Columns Comments for ADBDESG_FUND_CODE_PLDG (# 24)

Source Code Comments

BANNER Finance Fund Code for the Pledge.

Columns Comments for ADBDESG_ORGN_CODE_PLDG (# 25)

Source Code Comments

BANNER Finance Organization Code for the Pledge.

Columns Comments for ADBDESG_ACCT_CODE_PLDG (# 26)

Source Code Comments

BANNER Finance Account Code for the Pledge.

Columns Comments for ADBDESG_PROG_CODE_PLDG (# 27)

Source Code Comments

BANNER Finance Program Code for the Pledge.

Columns Comments for ADBDESG_ACTV_CODE_PLDG (# 28)

Source Code Comments

BANNER Finance Activity Code for the Pledge.

Columns Comments for ADBDESG_LOCN_CODE_PLDG (# 29)

Source Code Comments

BANNER Finance Location Code for the Pledge.

Columns Comments for ADBDESG_GL_NO_CREDIT_PLDG (# 30)

Source Code Comments

Non-BANNER Finance General Ledge Credit Number for the Pledge.

Columns Comments for ADBDESG_USER (# 31)

Source Code Comments

User code of person adding or changing the record.

Columns Comments for ADBDESG_START_DATE (# 32)

Source Code Comments

Designation Start Date indicates the date which the designation becomes active.

Columns Comments for ADBDESG_END_DATE (# 33)

Source Code Comments

Designation End Date indicates the date which the designation is no longer active.

Columns Comments for ADBDESG_DSTA_CODE (# 34)

Source Code Comments

Designation Status Code indicates the status of the designation.

Columns Comments for ADBDESG_DGRP_CODE (# 35)

Source Code Comments

Designation Group Code is used to indicate designations which have a similar purpose of function.

Columns Comments for ADBDESG_DEPT_CODE (# 36)

Source Code Comments

Designation Department Code indicates the department associated with the designation.

Columns Comments for ADBDESG_COAS_CODE_EXPND (# 37)

Source Code Comments

Banner Finance Chart of Accounts Code for the Expenditure.

Columns Comments for ADBDESG_ACCI_CODE_EXPND (# 38)

Source Code Comments

Banner Finance Account Index Code for the Expenditure.

Columns Comments for ADBDESG_FUND_CODE_EXPND (# 39)

Source Code Comments

Banner Finance Fund Code for the Expenditure.

Columns Comments for ADBDESG_ORGN_CODE_EXPND (# 40)

Source Code Comments

Banner Finance Organization Code for the Expenditure.

Columns Comments for ADBDESG_ACCT_CODE_EXPND (# 41)

Source Code Comments

Banner Finance Account Code for the Expenditure.

Columns Comments for ADBDESG_PROG_CODE_EXPND (# 42)

Source Code Comments

Banner Finance Program Code for the Expenditure.

Columns Comments for ADBDESG_ACTV_CODE_EXPND (# 43)

Source Code Comments

Banner Finance Activity Code for the Expenditure.

Columns Comments for ADBDESG_LOCN_CODE_EXPND (# 44)

Source Code Comments

Banner Finance Location Code for the Expenditure.

Columns Comments for ADBDESG_GL_NO_CREDIT_EXPND (# 45)

Source Code Comments

This field specifies the General Ledger Credit account number associated with the Designation for the Expenditure.

Columns Comments for ADBDESG_COAS_CODE_PYMNT (# 46)

Source Code Comments

Banner Finance Chart of Accounts Code for the Payment.

Columns Comments for ADBDESG_ACCI_CODE_PYMNT (# 47)

Source Code Comments

Banner Finance Account Index Code for the Payment.

Columns Comments for ADBDESG_FUND_CODE_PYMNT (# 48)

Source Code Comments

Banner Finance Fund Code for the Payment.

Columns Comments for ADBDESG_ORGN_CODE_PYMNT (# 49)

Source Code Comments

Banner Finance Organization Code for the Payment.

Columns Comments for ADBDESG_ACCT_CODE_PYMNT (# 50)

Source Code Comments

Banner Finance Account Code for the Payment.

Columns Comments for ADBDESG_PROG_CODE_PYMNT (# 51)

Source Code Comments

Banner Finance Program Code for the Payment.

Columns Comments for ADBDESG_ACTV_CODE_PYMNT (# 52)

Source Code Comments

Banner Finance Activity Code for the Payment.

Columns Comments for ADBDESG_LOCN_CODE_PYMNT (# 53)

Source Code Comments

Banner Finance Location Code for the Payment.

Columns Comments for ADBDESG_GL_NO_CREDIT_PYMNT (# 54)

Source Code Comments

This field specifies the General Ledger Credit account number associated with the Designation for the Payment.

Columns Comments for ADBDESG_WEB_GIFT_IND (# 55)

Source Code Comments

Web Gift Indicator, Y indicates the gifts will be accepted via the Web.

Columns Comments for ADBDESG_WEB_PLDG_IND (# 56)

Source Code Comments

Web Pledge Indicator, Y indicates the pledges will be accepted via the Web.

Table ADRADAJ

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ADRADAJ_DESG	VARCHAR2(10)	No	*	*
ADRADAJ_SEQ_NO	NUMBER(5,0)	No	*
ADRADAJ_ADJT_CODE	VARCHAR2(2)	No		*
ADRADAJ_REASON	VARCHAR2(60)	Yes
ADRADAJ_DATE	DATE	No
ADRADAJ_AMT	NUMBER(11,2)	No
ADRADAJ_FISC_CODE	NUMBER(4,0)	No		*
ADRADAJ_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRADAJ_FISC_CODE	ATVFISC_CODE	ATVFISC
ADRADAJ_ADJT_CODE	ATVADJT_CODE	ATVADJT
ADRADAJ_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_ADRADAJ	Unique	ADRADAJ_DESG
PK_ADRADAJ	Unique	ADRADAJ_SEQ_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_ADRADAJ	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVADJT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ADRADAJ

Object Dates

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

Source Code Comments

Designation Adjustment Repeating Table

Columns Comments for ADRADAJ_DESG (# 1)

Source Code Comments

This field specifies the five character alphanumeric designation code.

Columns Comments for ADRADAJ_SEQ_NO (# 2)

Source Code Comments

This field specifies the internal sequence number for designation adjustments.

Columns Comments for ADRADAJ_ADJT_CODE (# 3)

Source Code Comments

This field specifies the type of adjustment that is associated with a specific designaton.

Columns Comments for ADRADAJ_REASON (# 4)

Source Code Comments

This field specifies the description of the adjustment type code. This description defaults from the Designation Adjustment Code Validation Form.

Columns Comments for ADRADAJ_DATE (# 5)

Source Code Comments

This field specifies the date associated with the posting of the adjustment to the designation.

Columns Comments for ADRADAJ_AMT (# 6)

Source Code Comments

This field specifies the amount of the designation adjustment.

Columns Comments for ADRADAJ_FISC_CODE (# 7)

Source Code Comments

This field specifies the fiscal year of the designation adjustment.

Columns Comments for ADRADAJ_ACTIVITY_DATE (# 8)

Source Code Comments

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

Table ADRATTR

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ADRATTR_DESG	VARCHAR2(10)	No	*	*
ADRATTR_DATR_CODE	VARCHAR2(4)	No	*	*
ADRATTR_ACTIVITY_DATE	DATE	No
ADRATTR_USER	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRATTR_DATR_CODE	ATVDATR_CODE	ATVDATR
ADRATTR_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_ADRATTR	Unique	ADRATTR_DESG
PK_ADRATTR	Unique	ADRATTR_DATR_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_ADRATTR	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDATR	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ADRATTR

Object Dates

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

Source Code Comments

Designation Attributes Table

Columns Comments for ADRATTR_DESG (# 1)

Source Code Comments

Designation Attribute Designation.

Columns Comments for ADRATTR_DATR_CODE (# 2)

Source Code Comments

Designation Attribute Code.

Columns Comments for ADRATTR_ACTIVITY_DATE (# 3)

Source Code Comments

Date the Designation Attribute Code was inserted or last modified.

Columns Comments for ADRATTR_USER (# 4)

Source Code Comments

User that inserted or last modified the Designation Attribute Code.

Table ADRCONF

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ADRCONF_DESG	VARCHAR2(10)	No	*	*
ADRCONF_IDEN_CODE	VARCHAR2(5)	No	*	*
ADRCONF_USER_ID	VARCHAR2(30)	No
ADRCONF_GRP_SEQ_NO	NUMBER(15,0)	No	*
ADRCONF_ACTIVITY_DATE	DATE	No
ADRCONF_ENTRY_DATE	DATE	No
ADRCONF_CONFID_IND	VARCHAR2(1)	Yes
ADRCONF_USER	VARCHAR2(30)	No
ADRCONF_COMMENT	LONG	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRCONF_IDEN_CODE	GURIDEN_IDEN_CODE	GURIDEN
ADRCONF_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_ADRCONF	Unique	ADRCONF_DESG
PK_ADRCONF	Unique	ADRCONF_GRP_SEQ_NO
PK_ADRCONF	Unique	ADRCONF_IDEN_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADRSUBJ	SQL Table	S10B80.ALUMNI	Refer (no action)
F_INLONG_ADRCONF	Oracle Package Function	S10B80.BANINST1.AOKLONG	Use (select)
F_LONGTOCHAR_ADRCONF	Oracle Package Function	S10B80.BANINST1.AOKLONG	Use (select)
ADRCONF	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_ADRCONF	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
GURIDEN	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ADRCONF

Object Dates

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

Source Code Comments

Designation Comment Confidentiality Table

Columns Comments for ADRCONF_DESG (# 1)

Source Code Comments

Designation Comment Confidentiality Designation.

Columns Comments for ADRCONF_IDEN_CODE (# 2)

Source Code Comments

User ID of the Creator/Owner of the Comment Confideniality Record.

Columns Comments for ADRCONF_USER_ID (# 3)

Source Code Comments

User that inserted or last modified the Comment Confidentiality Record.

Columns Comments for ADRCONF_GRP_SEQ_NO (# 4)

Source Code Comments

Designation Comment Confidentiality Group Sequence Number.

Columns Comments for ADRCONF_ACTIVITY_DATE (# 5)

Source Code Comments

Date the Comment Confidentiality Record was inserted or last modified.

Columns Comments for ADRCONF_ENTRY_DATE (# 6)

Source Code Comments

Date the Comment Confidentiality Record was inserted.

Columns Comments for ADRCONF_CONFID_IND (# 7)

Source Code Comments

Confidential Indicator, Y indicates that the comments are confidential.

Columns Comments for ADRCONF_USER (# 8)

Source Code Comments

The User ID of the person who created or last modified the comment record.

Columns Comments for ADRCONF_COMMENT (# 9)

Source Code Comments

Free form text comment.

Table ADRDIDS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ADRDIDS_DESG	VARCHAR2(10)	No	*	*
ADRDIDS_PIDM	NUMBER(8,0)	No	*
ADRDIDS_DITP_CODE	VARCHAR2(4)	No	*	*
ADRDIDS_ACTIVITY_DATE	DATE	No
ADRDIDS_USER	VARCHAR2(30)	No
ADRDIDS_START_DATE	DATE	Yes
ADRDIDS_END_DATE	DATE	Yes
ADRDIDS_DIST_CODE	VARCHAR2(1)	Yes		*
ADRDIDS_ATYP_CODE	VARCHAR2(2)	Yes
ADRDIDS_COMMENT	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRDIDS_DESG	ADBDESG_DESG	ADBDESG
ADRDIDS_DIST_CODE	ATVDIST_CODE	ATVDIST
ADRDIDS_DITP_CODE	ATVDITP_CODE	ATVDITP

Index

Index Name	Index Type	Column Name
PK_ADRDIDS	Unique	ADRDIDS_DESG
PK_ADRDIDS	Unique	ADRDIDS_PIDM
PK_ADRDIDS	Unique	ADRDIDS_DITP_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_ADRDIDS	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDIST	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDITP	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ADRDIDS

Object Dates

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

Source Code Comments

Designation IDs Table

Columns Comments for ADRDIDS_DESG (# 1)

Source Code Comments

Designation ID Designation.

Columns Comments for ADRDIDS_PIDM (# 2)

Source Code Comments

Designation ID PIDM.

Columns Comments for ADRDIDS_DITP_CODE (# 3)

Source Code Comments

Designation ID Type code.

Columns Comments for ADRDIDS_ACTIVITY_DATE (# 4)

Source Code Comments

Date the Designation ID was inserted or last modified.

Columns Comments for ADRDIDS_USER (# 5)

Source Code Comments

User that inserted or last modified the Designation ID.

Columns Comments for ADRDIDS_START_DATE (# 6)

Source Code Comments

Start Date the Designation ID is effective for the designation.

Columns Comments for ADRDIDS_END_DATE (# 7)

Source Code Comments

End Date the Designation ID is effective for the designation.

Columns Comments for ADRDIDS_DIST_CODE (# 8)

Source Code Comments

Designation ID Status code.

Columns Comments for ADRDIDS_ATYP_CODE (# 9)

Source Code Comments

Designation ID Address Type code.

Columns Comments for ADRDIDS_COMMENT (# 10)

Source Code Comments

Comment Text for the Designation ID.

Table ADRFUND

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ADRFUND_DESG	VARCHAR2(10)	No	*	*
ADRFUND_FA_FUND_CODE	VARCHAR2(6)	No	*
ADRFUND_ACTIVITY_DATE	DATE	No
ADRFUND_USER	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRFUND_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_ADRFUND	Unique	ADRFUND_DESG
PK_ADRFUND	Unique	ADRFUND_FA_FUND_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRATRM	SQL Table	S10B80.FAISMGR	Join
RPRAWRD	SQL Table	S10B80.FAISMGR	Join
ADVAWRD	SQL View	S10B80.BANINST1	Use (select)
ADRFUND	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_ADRFUND	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ADRFUND

Object Dates

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

Source Code Comments

Designation Financial Aid Funds Table

Columns Comments for ADRFUND_DESG (# 1)

Source Code Comments

Designation FA Fund Code Designation.

Columns Comments for ADRFUND_FA_FUND_CODE (# 2)

Source Code Comments

Designation Financial Aid Fund Code.

Columns Comments for ADRFUND_ACTIVITY_DATE (# 3)

Source Code Comments

Date the Designation FA Fund Code was inserted or last modified.

Columns Comments for ADRFUND_USER (# 4)

Source Code Comments

User that inserted or last modified the Designation FA Fund Code.

Table ADRSUMM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
ADRSUMM_DESG	VARCHAR2(10)	No	*	*
ADRSUMM_FISC_CODE	NUMBER(4,0)	No	*	*
ADRSUMM_AMT_PLEDGED	NUMBER(13,2)	Yes
ADRSUMM_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
ADRSUMM_AMT_GIFT	NUMBER(13,2)	Yes
ADRSUMM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRSUMM_FISC_CODE	ATVFISC_CODE	ATVFISC
ADRSUMM_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_ADRSUMM	Unique	ADRSUMM_DESG
PK_ADRSUMM	Unique	ADRSUMM_FISC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_GIVINGSUMMARY	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,update,select)
ADRSUMM	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_ADRSUMM	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ADRSUMM

Object Dates

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

Source Code Comments

Designation Summary Repeating Table

Columns Comments for ADRSUMM_DESG (# 1)

Source Code Comments

This field specifies the five character alphanumeric designation code.

Columns Comments for ADRSUMM_FISC_CODE (# 2)

Source Code Comments

This field specifies the fiscal year associated with the summary information for a specific designation.

Columns Comments for ADRSUMM_AMT_PLEDGED (# 3)

Source Code Comments

This field specifies the amount of pledges associated with a designation for a specific fiscal year.

Columns Comments for ADRSUMM_AMT_PLEDGED_PAID (# 4)

Source Code Comments

This field specifies the amount of pledge payments associated with a designation for a specific fiscal year.

Columns Comments for ADRSUMM_AMT_GIFT (# 5)

Source Code Comments

This field specifies the amount of gifts and pledge payments associated with a designation for a specific fiscal year.

Columns Comments for ADRSUMM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table AFRDESG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKPLDG	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCPMT	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKNGFT	Rely On
AFRDESGC	Oracle Package Cursor	S10B80.BANINST1.BWAKGIFT	Use (select)Rely On
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)
ALLAFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
ALLAFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
DEFDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
DEFDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
P_GIVINGSUMMARY	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (update)
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
AFRDESG_REC	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
GET_GIFT_PLEDGE_AMTS_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Rely On
GET_GIFT_PLEDGE_AMTS_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Use (select)
P_CHECK_IF_PAYABLE	Oracle Package Procedure	S10B80.BANINST1.BWAKLIBS	Use (select)
F_AFRDESG_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
AFRDESG	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AFRDESG	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPDES	SQL Table	S10B80.ALUMNI	Join
ATVDSTA	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AFRDESG

Object Dates

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

Source Code Comments

Designation In Campaign Repeating Table

Columns Comments for AFRDESG_CAMPAIGN (# 1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRDESG_DESG (# 2)

Source Code Comments

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

Columns Comments for AFRDESG_GOAL (# 3)

Source Code Comments

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

Columns Comments for AFRDESG_AMT_PLEDGED (# 4)

Source Code Comments

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

Columns Comments for AFRDESG_AMT_PLEDGED_PAID (# 5)

Source Code Comments

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

Columns Comments for AFRDESG_AMT_GIFT (# 6)

Source Code Comments

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

Columns Comments for AFRDESG_ACTIVITY_DATE (# 7)

Source Code Comments

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

Columns Comments for AFRDESG_DSTA_CODE (# 8)

Source Code Comments

Designation Status Code indicates the status of the designation.

Columns Comments for AFRDESG_WEB_GIFT_IND (# 9)

Source Code Comments

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

Columns Comments for AFRDESG_WEB_PLDG_IND (# 10)

Source Code Comments

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

Table 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 AGRGDES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Join
AFBCAMP	SQL Table	S10B80.ALUMNI	Join
AGBGIFT	SQL Table	S10B80.ALUMNI	Join
AGRPDES	SQL Table	S10B80.ALUMNI	Join
AGTGTCR	SQL Table	S10B80.ALUMNI	Join
AGVCSHR	SQL View	S10B80.BANINST1	Use (select)
AGVDONR	SQL View	S10B80.BANINST1	Use (select)
AGVGCRD	SQL View	S10B80.BANINST1	Use (select)
AGVGFD2	SQL View	S10B80.BANINST1	Use (select)
AGVGLST	SQL View	S10B80.BANINST1	Use (select)
AGVGMEM	SQL View	S10B80.BANINST1	Use (select)
AGVGMLT	SQL View	S10B80.BANINST1	Use (select)
AGVGSCR	SQL View	S10B80.BANINST1	Use (select)
AGVGSFT	SQL View	S10B80.BANINST1	Use (select)
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKCPRF	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPPRF	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKLIBS	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AGRGDES_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPPRF	Rely On
AGRGDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
AGRGDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
AGRGDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AGRGDESVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)Rely On
ALLGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
ALLGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
GIFTPLDGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)
PAYMENTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPPRF	Use (select)
PLDGPAYVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
PLDGPAYVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
P_INSERT_AGRGDES	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_AGRGDES	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert)
P_INSERT_AGRGPAY	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_GIFT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_NEWGIFTCAMPDESG	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_PLEDGE_SPLIT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
P_PLPAYCAMPDESG	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_CREATEGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_DISP_OVERALL_TOTALS	Oracle Package Procedure	S10B80.BANINST1.BWDKLIBS	Use (select)Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
P_GIFT_BY_FISCAL_YR	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
F_XMG_DESG_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_DESG_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPL	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
F_XMG_FISC_CALC_EMPR	Oracle Package Function	S10B80.BANINST1.BWAKLIBS	Use (select)
AGRGDES	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGRGDES_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AGRGDES_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
AGRGDES_KEY_INDEX4	SQL Index	S10B80.ALUMNI	Rely On
PK_AGRGDES	SQL Index	S10B80.ALUMNI	Rely On
AGBMGID	SQL Table	S10B80.ALUMNI	Join
AGRGCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGMLT	SQL Table	S10B80.ALUMNI	Join
AGRGMMO	SQL Table	S10B80.ALUMNI	Join
AGRMDES	SQL Table	S10B80.ALUMNI	Join
AGRMGIF	SQL Table	S10B80.ALUMNI	Join
AXBMGID	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGDES

Object Dates

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

Source Code Comments

Gift Designation Repeating Table

Columns Comments for AGRGDES_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRGDES_GIFT_NO (# 2)

Source Code Comments

This field specifies the number of the gift.

Columns Comments for AGRGDES_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the number of the pledge.

Columns Comments for AGRGDES_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRGDES_DESG (# 5)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRGDES_AMT (# 6)

Source Code Comments

This field specifies the amount of the gift designation.

Columns Comments for AGRGDES_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table AGRGHDE

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGHDE_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGRGHDE_DESG	ADBDESG_DESG	ADBDESG
AGRGHDE_ID	AGBGHLD_ID	AGBGHLD
AGRGHDE_GIFT_NO	AGBGHLD_GIFT_NO	AGBGHLD

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
CAMP_DESG_REC	Oracle Package Type	S10B80.BANINST1.AGKGIFT	Rely On
AGRGHDEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNHIS	Use (select)Rely On
P_INSERT_GIFT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Use (Insert)
AGRGHDE_REC	Oracle Package Variable	S10B80.BANINST1.BWAKNHIS	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Use (select)
AGRGHDE	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AGRGHDE	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFBCAMP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBGHLD	SQL Table	S10B80.ALUMNI	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRGHDE

Object Dates

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

Source Code Comments

Web Gift Detail Hold Table.

Columns Comments for AGRGHDE_ID (# 1)

Source Code Comments

Web ID created by a user not found in Banner.

Columns Comments for AGRGHDE_GIFT_NO (# 2)

Source Code Comments

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

Columns Comments for AGRGHDE_PLEDGE_NO (# 3)

Source Code Comments

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

Columns Comments for AGRGHDE_CAMPAIGN (# 4)

Source Code Comments

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

Columns Comments for AGRGHDE_DESG (# 5)

Source Code Comments

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

Columns Comments for AGRGHDE_AMT (# 6)

Source Code Comments

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

Columns Comments for AGRGHDE_ACTIVITY_DATE (# 7)

Source Code Comments

Date the gift was created or changed.

Columns Comments for AGRGHDE_USER (# 8)

Source Code Comments

User who created or changed the gift information.

Columns Comments for AGRGHDE_PIDM (# 9)

Source Code Comments

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

Table AGRPDES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRPDES

Object Dates

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

Source Code Comments

Pledge Designation Repeating Table

Columns Comments for AGRPDES_PIDM (# 1)

Source Code Comments

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

Columns Comments for AGRPDES_PLEDGE_NO (# 2)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AGRPDES_CAMPAIGN (# 3)

Source Code Comments

This field specifies the campaign code associated with the pledge.

Columns Comments for AGRPDES_DESG (# 4)

Source Code Comments

This field specifies the designation code associated with the campaign.

Columns Comments for AGRPDES_AMT (# 5)

Source Code Comments

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

Columns Comments for AGRPDES_AMT_PAID (# 6)

Source Code Comments

This field specifies the amount paid toward the pledge designation.

Columns Comments for AGRPDES_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table AMRDESG

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AMRDESG_PROJ_CODE	VARCHAR2(6)	No	*	*
AMRDESG_DESG	VARCHAR2(10)	No	*	*
AMRDESG_USER	VARCHAR2(30)	No
AMRDESG_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMRDESG_DESG	ADBDESG_DESG	ADBDESG
AMRDESG_PROJ_CODE	ATVPROJ_CODE	ATVPROJ

Index

Index Name	Index Type	Column Name
PK_AMRDESG	Unique	AMRDESG_PROJ_CODE
PK_AMRDESG	Unique	AMRDESG_DESG

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_AMRDESG	SQL Index	S10B80.ALUMNI	Rely On
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVPROJ	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AMRDESG

Object Dates

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

Source Code Comments

Pledge Condition Table

Columns Comments for AMRDESG_PROJ_CODE (# 1)

Source Code Comments

The Project code to which Designations are being associated.

Columns Comments for AMRDESG_DESG (# 2)

Source Code Comments

The Designation that is being associated to a Project Code.

Columns Comments for AMRDESG_USER (# 3)

Source Code Comments

User ID of the person who created/updated the record.

Columns Comments for AMRDESG_ACTIVITY_DATE (# 4)

Source Code Comments

Date the Pledge Condition was inserted or last modified.

Table APRDHIS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APRDHIS_PIDM	NUMBER(8,0)	No	*
APRDHIS_DESG	VARCHAR2(10)	No	*
APRDHIS_FISC_CODE	NUMBER(4,0)	No	*	*
APRDHIS_AMT_PLEDGED	NUMBER(13,2)	Yes
APRDHIS_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
APRDHIS_AMT_GIFT	NUMBER(13,2)	Yes
APRDHIS_AMT_MEMO	NUMBER(13,2)	Yes
APRDHIS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDHIS_FISC_CODE	ATVFISC_CODE	ATVFISC

Index

Index Name	Index Type	Column Name
APRDHIS_KEY_INDEX2		APRDHIS_FISC_CODE
APRDHIS_KEY_INDEX2		APRDHIS_PIDM
APRDHIS_KEY_INDEX3		APRDHIS_DESG
PK_APRDHIS	Unique	APRDHIS_PIDM
PK_APRDHIS	Unique	APRDHIS_DESG
PK_APRDHIS	Unique	APRDHIS_FISC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Join
APBCONS	SQL Table	S10B80.ALUMNI	Join
APRCSPS	SQL Table	S10B80.ALUMNI	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ADVDSG1	SQL View	S10B80.BANINST1	Use (select)
AGVDHIS	SQL View	S10B80.BANINST1	Use (select)
F_DESIGNATION_GIVING	SQL Function	S10B80.BANINST1	Use (select)
F_SPOUSE_DESG_GIVING_INFO	SQL Function	S10B80.BANINST1	Use (select)
DESGDHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCHIS	Rely On
DESGDHIS_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKGHIS	Rely On
DESGDHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)
DESGDHISVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)
P_APRDHIS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_APRDHIS	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (Insert,update,select)
APRDHIS	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
APRDHIS_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
APRDHIS_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_APRDHIS	SQL Index	S10B80.ALUMNI	Rely On
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APRDHIS

Object Dates

Creation Date	Analysis Date
04/02/2008 13:40:55:000	04/02/2008 13:49:15:000

Source Code Comments

Giving History By Desg Repeating Table

Columns Comments for APRDHIS_PIDM (# 1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRDHIS_DESG (# 2)

Source Code Comments

This field specifies the designation(s) associated with the constituents gifts and/or pledge payments.

Columns Comments for APRDHIS_FISC_CODE (# 3)

Source Code Comments

This field specifies the fiscal year of the campaign the associated with the designation.

Columns Comments for APRDHIS_AMT_PLEDGED (# 4)

Source Code Comments

This field specifies the amount the constituent pledged for a specific designation.

Columns Comments for APRDHIS_AMT_PLEDGED_PAID (# 5)

Source Code Comments

This field specifies the amount of pledge payments for a specific designation.

Columns Comments for APRDHIS_AMT_GIFT (# 6)

Source Code Comments

This field specifies the dollar amount of gifts received from a constituent for a specific designation.

Columns Comments for APRDHIS_AMT_MEMO (# 7)

Source Code Comments

This field specifies the amount of memo credit (soft dollars) credited to the constituent for a specific designation.

Columns Comments for APRDHIS_ACTIVITY_DATE (# 8)

Source Code Comments

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

Table ATVCFAE

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVCFAE_CODE	VARCHAR2(5)	No	*
ATVCFAE_TYPE	NUMBER(2,0)	No
ATVCFAE_DESC	VARCHAR2(30)	No
ATVCFAE_ACTIVITY_DATE	DATE	No
ATVCFAE_MG_PURPOSE	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVCFAE	Unique	ATVCFAE_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVCFAEC	Oracle Package Cursor	S10B80.BANINST1.ATKCFAE	Use (select)Rely On
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVCFAE	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_ATVCFAE	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVCFAE

Object Dates

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

Source Code Comments

CFAE Code Validation Table

Columns Comments for ATVCFAE_CODE (# 1)

Source Code Comments

This field specifies the donors purpose for giving as defined for Council for Financial Aid to Education reporting.

Columns Comments for ATVCFAE_TYPE (# 2)

Source Code Comments

This field specifies the value for the Council for Financial Aid to Education reporting category.

Columns Comments for ATVCFAE_DESC (# 3)

Source Code Comments

This field specifies the description of the Council for Financial Aid to Education code.

Columns Comments for ATVCFAE_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for ATVCFAE_MG_PURPOSE (# 5)

Source Code Comments

Purpose of matching gift based on designation.

Table ATVCMTP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVCMTP	Unique	ATVCMTP_CODE

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVCMTP

Object Dates

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

Source Code Comments

Campaign Type Validation Table

Columns Comments for ATVCMTP_CODE (# 1)

Source Code Comments

This field specifies the code for the type of campaign.

Columns Comments for ATVCMTP_DESC (# 2)

Source Code Comments

This field specifies the description of the campaign code.

Columns Comments for ATVCMTP_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for ATVCMTP_CAPITAL_IND (# 4)

Source Code Comments

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

Table ATVDGRP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVDGRP_CODE	VARCHAR2(5)	No	*
ATVDGRP_DESC	VARCHAR2(30)	No
ATVDGRP_ACTIVITY_DATE	DATE	No
ATVDGRP_USER	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVDGRP	Unique	ATVDGRP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVDGRP

Object Dates

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

Source Code Comments

Designation Group Table

Columns Comments for ATVDGRP_CODE (# 1)

Source Code Comments

Designation Group.

Columns Comments for ATVDGRP_DESC (# 2)

Source Code Comments

Designation Group Description.

Columns Comments for ATVDGRP_ACTIVITY_DATE (# 3)

Source Code Comments

Date the Designation Group was inserted or last modified.

Columns Comments for ATVDGRP_USER (# 4)

Source Code Comments

User that inserted or last modified the Designation Group.

Table ATVDSTA

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVDSTA_CODE	VARCHAR2(1)	No	*
ATVDSTA_DESC	VARCHAR2(30)	No
ATVDSTA_ACTIVE_IND	VARCHAR2(1)	No
ATVDSTA_ACTIVITY_DATE	DATE	No
ATVDSTA_USER	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVDSTA	Unique	ATVDSTA_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AFRDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDSTAC	Oracle Package Cursor	S10B80.BANINST1.ATKDSTA	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
F_ATVDSTA_ACTIVE	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
ATVDSTA	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_ATVDSTA	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVDSTA

Object Dates

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

Source Code Comments

Designation Status Code Table

Columns Comments for ATVDSTA_CODE (# 1)

Source Code Comments

Designation Status Code.

Columns Comments for ATVDSTA_DESC (# 2)

Source Code Comments

Designation Status Code Description.

Columns Comments for ATVDSTA_ACTIVE_IND (# 3)

Source Code Comments

Designation Status Active/Inactive indicator.

Columns Comments for ATVDSTA_ACTIVITY_DATE (# 4)

Source Code Comments

Date the Designation Status Code was inserted or last modified.

Columns Comments for ATVDSTA_USER (# 5)

Source Code Comments

User that inserted or last modified the Designation Status Code.

Table ATVDSTP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVDSTP_CODE	VARCHAR2(5)	No	*
ATVDSTP_DESC	VARCHAR2(30)	No
ATVDSTP_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVDSTP	Unique	ATVDSTP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRIDRL	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRSPRL	SQL Table	S10B80.ALUMNI	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVDSTPC	Oracle Package Cursor	S10B80.BANINST1.ATKDSTP	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVDSTP	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_ATVDSTP	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVDSTP

Object Dates

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

Source Code Comments

Designation Type Validation Table

Columns Comments for ATVDSTP_CODE (# 1)

Source Code Comments

This field specifies the code for the type of designation.

Columns Comments for ATVDSTP_DESC (# 2)

Source Code Comments

This field specifies the description of the designation code.

Columns Comments for ATVDSTP_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table AXRMDES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AXRMDES

Object Dates

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

Source Code Comments

Expected Matching Gift Designation repeating table.

Columns Comments for AXRMDES_PIDM (# 1)

Source Code Comments

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

Columns Comments for AXRMDES_EMPR_PIDM (# 2)

Source Code Comments

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

Columns Comments for AXRMDES_PLEDGE_NO (# 3)

Source Code Comments

This field specifies the system assigned number of the pledge.

Columns Comments for AXRMDES_CAMPAIGN (# 4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AXRMDES_DESG (# 5)

Source Code Comments

This field specifies the ten character alphanumeric designation code.

Columns Comments for AXRMDES_AMT (# 6)

Source Code Comments

This field specifies the amount of the designation.

Columns Comments for AXRMDES_ACTIVITY_DATE (# 7)

Source Code Comments

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

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.

Table STVDEPT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
STVDEPT_CODE	VARCHAR2(4)	No	*
STVDEPT_DESC	VARCHAR2(30)	No
STVDEPT_ACTIVITY_DATE	DATE	No
STVDEPT_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVDEPT_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVDEPT	Unique	STVDEPT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ADBDESG	SQL Table	S10B80.ALUMNI	Refer (no action)
APRADEG	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVEMPH	SQL Table	S10B80.GENERAL	Refer (no action)
PERFNIO	SQL Table	S10B80.PAYROLL	Refer (no action)
PERFNIS	SQL Table	S10B80.PAYROLL	Refer (no action)
SARADAP	SQL Table	S10B80.SATURN	Refer (no action)
SARQKER	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)
SCRRDEP	SQL Table	S10B80.SATURN	Refer (no action)
SFRMHRS	SQL Table	S10B80.SATURN	Refer (no action)
SFRRGFE	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)
SHRCOMM	SQL Table	S10B80.SATURN	Refer (no action)
SHRDGMR	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)
SMRIEDP	SQL Table	S10B80.SATURN	Refer (no action)
SMRPCRS	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)
SOBODTE	SQL Table	S10B80.SATURN	Refer (no action)
SORCMJR	SQL Table	S10B80.SATURN	Refer (no action)
SORCOMM	SQL Table	S10B80.SATURN	Refer (no action)
SOREXTN	SQL Table	S10B80.SATURN	Refer (no action)
SORLCDF	SQL Table	S10B80.SATURN	Refer (no action)
SORLFOS	SQL Table	S10B80.SATURN	Refer (no action)
SORMDPT	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)
SSRRDEP	SQL Table	S10B80.SATURN	Refer (no action)
SSRRESV	SQL Table	S10B80.SATURN	Refer (no action)
ST_STVDEPT_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
AG_EVENTS_AND_FUNCTIONS	SQL View	S10B80.BANINST1	Use (select)
GEVEVN1	SQL View	S10B80.BANINST1	Join
SOVDATA	SQL View	S10B80.BANINST1	Use (select)
SRVRECR	SQL View	S10B80.BANINST1	Use (select)
F_GET_DESC_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
DEPARTMENT_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSCKCOM	Rely On
SECTION_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSSKCOM	Rely On
STVDEPT_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.SOKTABS	Rely On
DEPT_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSCKLDI	Rely On
GT_FIELD_OF_STUDY_REC	Oracle Package Type	S10B80.BANINST1.SP_HOUSING_PROFILE	Rely On
DEPARTMENT_C	Oracle Package Cursor	S10B80.BANINST1.ICSSKCOM	Use (select)
SSBOVRR_C	Oracle Package Cursor	S10B80.BANINST1.ICSSKCOM	Use (select)
STVDEPT_C	Oracle Package Cursor	S10B80.BANINST1.BWCKSMDS	Use (select)
P_CREATE_APPL	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
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_LEARNER_LFOS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Rely On
P_LEARNER_LFOS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_GRADEROLL	Rely On
P_LEARNER_LFOS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Rely On
P_LEARNER_LFOS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Rely On
P_LEARNER_LFOS	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_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_ASSMT	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_CURRICULUM	Use (Insert)
TESTCASE_CC	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Rely On
F_CHECK_SECTION_OVERRIDE	Oracle Package Function	S10B80.BANINST1.ICSSKCOM	Rely On
F_GET_ORGUNIT	Oracle Package Function	S10B80.BANINST1.ICSSKCOM	Rely On
GET_DEPT_DESC	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Rely On
GET_DEPT_DESC	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Use (select)
STVDEPTC	Oracle Package Cursor	S10B80.BANINST1.STKDEPT	Use (select)Rely On
STVDEPT_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVDEPT	Rely On
STVDEPT_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVDEPT	Use (select)Rely On
STVDEPT_WDSP_C	Oracle Package Cursor	S10B80.BANINST1.BWCKLIBS	Use (select)Rely On
P_CAT_SEARCH	Oracle Package Procedure	S10B80.BANINST1.BWCKCTLG	Rely On
P_CHECKCURRICULUM	Oracle Package Procedure	S10B80.BANINST1.SOKCURR	Rely On
P_CHECKMAJOR	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_STVDEPT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_DELETE_STVDEPT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (delete)
P_DISPCURRENT_MAJOR1_FORMAT	Oracle Package Procedure	S10B80.BANINST1.BWCKCAPP	Rely On
P_DISPCURRENT_MAJOR2_FORMAT	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_FOUR	Oracle Package Procedure	S10B80.BANINST1.BWCKSMDS	Rely On
P_FACCLAWAITSUM	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FACSCHED	Oracle Package Procedure	S10B80.BANINST1.BWLKIFAC	Rely On
P_GETACCESSIBLECOLLDEPT	Oracle Package Procedure	S10B80.BANINST1.SOKEPRT	Use (select)
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_STVDEPT_ROW	Oracle Package Procedure	S10B80.BANINST1.STKSELS	Rely On
P_INSERT_STVDEPT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_INSERT_STVDEPT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (Insert)
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_SAVE_DEPARTMENT	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SEND_DEPARTMENT	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_UPDATE_STVDEPT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_UPDATE_STVDEPT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (update)
P_VALIDATE_INSERT	Oracle Package Procedure	S10B80.BANINST1.SB_FIELDOFSTUDY_RULES	Rely On
P_VERIFYDATA	Oracle Package Procedure	S10B80.BANINST1.SOKCURR	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FIELDOFSTUDY	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_CRSE_DEPT_RESTRICTION	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_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_PB_FAC_NISTCOMP	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_COURSE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_BLDGDEFINITION	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_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_SB_FACULTY	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_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STVDEPT	Rely On
F_DISPLAY_MAJOR_TABLE	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Rely On
F_FTE_FACTOR	Oracle Package Function	S10B80.BANINST1.SIKLOAD	Rely On
F_GETCODEDESCRIPTION	Oracle Package Function	S10B80.BANINST1.BWLKSECR	Use (select)
F_GET_DEPARTMENT	Oracle Package Function	S10B80.BANINST1.ICSCKLDI	Rely On
F_GET_DEPARTMENT	Oracle Package Function	S10B80.BANINST1.ICSCKCOM	Rely On
F_GET_DEPARTMENT	Oracle Package Function	S10B80.BANINST1.ICSCKCOM	Use (select)
F_GET_DEPT_DESC	Oracle Package Function	S10B80.BANINST1.STVFUNC	Rely On
F_GET_DEPT_DESC	Oracle Package Function	S10B80.BANINST1.STVFUNC	Use (select)
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_STVDEPT	Rely On
F_GET_EVENT_HEADER	Oracle Package Function	S10B80.BANINST1.ICSCKCOM	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
GET_DEPT_DESC	Oracle Package Function	S10B80.BANINST1.BWCKSMDS	Rely On
GET_DEPT_DESC	Oracle Package Function	S10B80.BANINST1.BWCKSMDS	Use (select)
GET_DEPT_DESC	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Rely On
GET_DEPT_DESC	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Use (select)
STVDEPT	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_STVDEPT	SQL Index	S10B80.SATURN	Rely On
ST_STVDEPT_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_STVDEPT_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.STVDEPT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:53:50:000	04/02/2008 21:18:15:000

Source Code Comments

Department Validation Table

Columns Comments for STVDEPT_CODE (# 1)

Source Code Comments

This field identifies the department code referenced in the Catalog, Recruiting, Admissions, and Acad. Hist. Modules. Required value: 0000 - Dept. Not Declared.

Columns Comments for STVDEPT_DESC (# 2)

Source Code Comments

This field specifies the department associated with the department code.

Columns Comments for STVDEPT_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for STVDEPT_SYSTEM_REQ_IND (# 4)

Source Code Comments

System Required Indicator

Columns Comments for STVDEPT_VR_MSG_NO (# 5)

Source Code Comments

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

Link between ADBDESG and AGRGDES

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between ADBDESG and AGRGDES	ALUMNI

List of Real links

Link type	Between	And
Join	ADBDESG	AGRGDES

Link between AGRPDES and ADBDESG

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between AGRPDES and ADBDESG	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPDES	ADBDESG

Link between ADBDESG and APRDHIS

Join Information

Objects list
schema-view : S10B80.BANINST1.ADVDSG1 scope-cursor : S10B80.BANINST1.BWAKCHIS.DESGDHISVIEWC scope-cursor : S10B80.BANINST1.BWDKGHIS.DESGDHISVIEWC

Link List

Link Type	Link	Project
Join	Link Between ADBDESG and APRDHIS	ALUMNI

List of Real links

Link type	Between	And
Join	ADBDESG	APRDHIS

Link between AXRMDES and ADBDESG

Join Information

Objects list
schema-view : S10B80.BANINST1.AXVPINS

Link List

Link Type	Link	Project
Join	Link Between AXRMDES and ADBDESG	ALUMNI

List of Real links

Link type	Between	And
Join	AXRMDES	ADBDESG

Link between AGRPDES and AGRGDES

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between AGRPDES and AGRGDES	ALUMNI

List of Real links

Link type	Between	And
Join	AGRPDES	AGRGDES

Link between AFRDESG and AGRPDES

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between AFRDESG and AGRPDES	ALUMNI

List of Real links

Link type	Between	And
Join	AFRDESG	AGRPDES

Link between AFRDESG and ATVDSTA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRDESG and ATVDSTA (FK1_AFRDESG_INV_ATVDSTA_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRDESG	AFRDESG_DSTA_CODE	ATVDSTA_CODE	ATVDSTA	(0,1)-(0,n)

Link between ADRADAJ and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADRADAJ and ADBDESG (FK1_ADRADAJ_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADRADAJ	ADRADAJ_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Link between ADRATTR and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADRATTR and ADBDESG (FK1_ADRATTR_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADRATTR	ADRATTR_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Link between ADRCONF and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADRCONF and ADBDESG (FK1_ADRCONF_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADRCONF	ADRCONF_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Link between ADRFUND and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADRFUND and ADBDESG (FK1_ADRFUND_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADRFUND	ADRFUND_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Link between ADRSUMM and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADRSUMM and ADBDESG (FK1_ADRSUMM_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADRSUMM	ADRSUMM_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Link between AFRDESG and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AFRDESG and ADBDESG (FK1_AFRDESG_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AFRDESG	AFRDESG_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Link between AGBWPLG and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGBWPLG and ADBDESG (FK1_AGBWPLG_INV_ADBDESG_KEY)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGBWPLG and ADBDESG (FK2_AGBWPLG_INV_ADBDESG_KEY)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AGBWPLG and ADBDESG (FK3_AGBWPLG_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBWPLG	AGBWPLG_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBWPLG	AGBWPLG_DESIGNATION_3	ADBDESG_DESG	ADBDESG	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGBWPLG	AGBWPLG_DESIGNATION_2	ADBDESG_DESG	ADBDESG	(0,1)-(0,n)

Link between AGRGHDE and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AGRGHDE and ADBDESG (FK1_AGRGHDE_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AGRGHDE	AGRGHDE_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Link between AMRDESG and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AMRDESG and ADBDESG (FK1_AMRDESG_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AMRDESG	AMRDESG_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Link between ADBDESG and ATVCFAE

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADBDESG and ATVCFAE (FK1_ADBDESG_INV_ATVCFAE_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADBDESG	ADBDESG_CFAE_CODE	ATVCFAE_CODE	ATVCFAE	(1,1)-(0,n)

Link between ADBDESG and ATVCMTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADBDESG and ATVCMTP (FK1_ADBDESG_INV_ATVCMTP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADBDESG	ADBDESG_CMTP_CODE	ATVCMTP_CODE	ATVCMTP	(0,1)-(0,n)

Link between ADBDESG and ATVDGRP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADBDESG and ATVDGRP (FK1_ADBDESG_INV_ATVDGRP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADBDESG	ADBDESG_DGRP_CODE	ATVDGRP_CODE	ATVDGRP	(0,1)-(0,n)

Link between ADBDESG and ATVDSTA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADBDESG and ATVDSTA (FK1_ADBDESG_INV_ATVDSTA_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADBDESG	ADBDESG_DSTA_CODE	ATVDSTA_CODE	ATVDSTA	(0,1)-(0,n)

Link between ADBDESG and ATVDSTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADBDESG and ATVDSTP (FK1_ADBDESG_INV_ATVDSTP_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADBDESG	ADBDESG_DSTP_CODE	ATVDSTP_CODE	ATVDSTP	(1,1)-(0,n)

Link between ADRDIDS and ADBDESG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADRDIDS and ADBDESG (FK1_ADRDIDS_INV_ADBDESG_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADRDIDS	ADRDIDS_DESG	ADBDESG_DESG	ADBDESG	(1,1)-(0,n)

Link between ADBDESG and STVCOLL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADBDESG and STVCOLL (FK1_ADBDESG_INV_STVCOLL_CODE)	ALUMNI

Foreign Key information

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

Link between ADBDESG and STVDEPT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ADBDESG and STVDEPT (FK1_ADBDESG_INV_STVDEPT_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ADBDESG	ADBDESG_DEPT_CODE	STVDEPT_CODE	STVDEPT	(0,1)-(0,n)