Model Web Management

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GOBANSR	SQL Table	Default
GOBDIRO	SQL Table	Default
GOBFNXR	SQL Table	Default
GOBQSTN	SQL Table	Default
GOBSRVR	SQL Table	Default
GOBTPAC	SQL Table	Default
GORADRL	SQL Table	Default
GORDADD	SQL Table	Default
GORDPRF	SQL Table	Default
GOREMAL	SQL Table	Default
GORPAUD	SQL Table	Default
GORPPRM	SQL Table	Default
GORSRVR	SQL Table	Default
GORTCTL	SQL Table	Default
GOVSRVR	SQL View	Default
GTVDIRO	SQL Table	Default
GTVEMAL	SQL Table	Default
GTVSDAX	SQL Table	Default
GUBPPRF	SQL Table	Default
GUBSRVY	SQL Table	Default
GURSRVQ	SQL Table	Default
GURSVRL	SQL Table	Default
SPRADDR	SQL Table	Default

Model View

Table GOBANSR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBANSR_PIDM	NUMBER(0,0)	No	*
GOBANSR_NUM	NUMBER(0,0)	No	*
GOBANSR_GOBQSTN_ID	VARCHAR2(6)	Yes		*
GOBANSR_QSTN_DESC	VARCHAR2(255)	Yes
GOBANSR_ANSR_DESC	VARCHAR2(255)	No
GOBANSR_ANSR_SALT	VARCHAR2(128)	No
GOBANSR_USER_ID	VARCHAR2(30)	No
GOBANSR_DATA_ORIGIN	VARCHAR2(30)	No
GOBANSR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBANSR_GOBQSTN_ID	GOBQSTN_ID	GOBQSTN

Index

Index Name	Index Type	Column Name
PK_GOBANSR	Unique	GOBANSR_PIDM
PK_GOBANSR	Unique	GOBANSR_NUM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PIN_ANSWER_REC	Oracle Package Type	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
P_DISPQUESTIONLIST	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
F_BUILD_GOBANSR_REC	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
F_GET_QSTNANSRD	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)
GOBANSRC	Oracle Package Cursor	S10B80.WTAILOR.TWBKGLIB	Use (select)Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_QUESTION	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBANSR	Use (delete)
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_FIRSTMENU	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GOBANSR	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_ANSWER	Use (select)
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_PROCSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_ANSWER_RULES	Rely On
P_SECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_SECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBANSR	Use (update)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_ANSWER_RULES	Rely On
P_VALIDATEQUESTIONANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_VALIDATEQUESTIONANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Use (select)
F_VALIDATE_ANSWER	Oracle Package Function	S10B80.BANINST1.GB_PIN_ANSWER	Rely On
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)
GOBANSR	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_GOBANSR	SQL Index	S10B80.GENERAL	Rely On
GOBQSTN	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBANSR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:27:55:000	04/02/2008 21:17:51:000

Source Code Comments

General table for storing responses and PIN questions

Columns Comments for GOBANSR_PIDM (# 1)

Source Code Comments

PIDM: PIDM of the self service user who created PIN responses.

Columns Comments for GOBANSR_NUM (# 2)

Source Code Comments

NUM: Number of the question/answer stored

Columns Comments for GOBANSR_GOBQSTN_ID (# 3)

Source Code Comments

GOBQSTN_ID: Question ID from gobqstn table

Columns Comments for GOBANSR_QSTN_DESC (# 4)

Source Code Comments

QSTN_DESC: Descriptive questions

Columns Comments for GOBANSR_ANSR_DESC (# 5)

Source Code Comments

ANSR_DESC: Descriptive answer for the question

Columns Comments for GOBANSR_ANSR_SALT (# 6)

Source Code Comments

ANSR_SALT: Random value used in hashing answer

Columns Comments for GOBANSR_USER_ID (# 7)

Source Code Comments

USER_ID: ID of the user who created or last updated the record.

Columns Comments for GOBANSR_DATA_ORIGIN (# 8)

Source Code Comments

DATA_ORIGIN: Source system that created or updated the row

Columns Comments for GOBANSR_ACTIVITY_DATE (# 9)

Source Code Comments

ACTIVITY_DATE: Date on which the record was created or last updated.

Table GOBDIRO

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBDIRO_DIRO_CODE	VARCHAR2(8)	No	*	*
GOBDIRO_DIRECTORY_TYPE	VARCHAR2(1)	No
GOBDIRO_ITEM_TYPE	VARCHAR2(1)	No
GOBDIRO_DISP_PROFILE_IND	VARCHAR2(1)	No
GOBDIRO_UPD_PROFILE_IND	VARCHAR2(1)	No
GOBDIRO_NON_PROFILE_DEF_IND	VARCHAR2(1)	No
GOBDIRO_SYSTEM_REQ_IND	VARCHAR2(1)	No
GOBDIRO_ACTIVITY_DATE	DATE	No
GOBDIRO_SEQ_NO	NUMBER(2,0)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBDIRO_DIRO_CODE	GTVDIRO_CODE	GTVDIRO

Index

Index Name	Index Type	Column Name
PK_GOBDIRO	Unique	GOBDIRO_DIRO_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORDADD	SQL Table	S10B80.GENERAL	Refer (no action)
GORDPRF	SQL Table	S10B80.GENERAL	Refer (no action)
GOBDIRO_REC	Oracle Package Variable	S10B80.BANINST1.BWAKSRCH	Rely On
GOBDIROC	Oracle Package Cursor	S10B80.BANINST1.BWAKSRCH	Use (select)
GOBDIROC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)
GOBDIRO_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
GOBDIROLISTC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)Rely On
GOBDIROREADC	Oracle Package Cursor	S10B80.BANINST1.BWAKSRCH	Use (select)Rely On
GOBDIRO	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_GOBDIRO	SQL Index	S10B80.GENERAL	Rely On
GTVDIRO	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBDIRO

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:40:000	04/02/2008 21:17:54:000

Source Code Comments

Directory Options Rule Table

Columns Comments for GOBDIRO_DIRO_CODE (# 1)

Source Code Comments

DIRECTORY CODE: Code for Directory Item.

Columns Comments for GOBDIRO_DIRECTORY_TYPE (# 2)

Source Code Comments

DIRECTORY TYPE INDICATOR: Indicator to print in (S)tudent, (E)mployee, or (A)ll Directories.

Columns Comments for GOBDIRO_ITEM_TYPE (# 3)

Source Code Comments

DIRECTORY ITEM TYPE INDICATOR: Indicator for Item Type; (A)ddress, (T)elephone, or (N)ot Applicable.

Columns Comments for GOBDIRO_DISP_PROFILE_IND (# 4)

Source Code Comments

INCLUDE IN DIRECTORY INDICATOR: Indicator to display in Directory; (Y)es or (N)o.

Columns Comments for GOBDIRO_UPD_PROFILE_IND (# 5)

Source Code Comments

DISPLAY IN DIRECTORY INDICATOR: Indicator to allow User to choose to display in directory; (Y)es or (N)o.

Columns Comments for GOBDIRO_NON_PROFILE_DEF_IND (# 6)

Source Code Comments

DEFAULT INDICATOR: Indicator to default to directory for users without a directory profile; (Y)es or (N)o.

Columns Comments for GOBDIRO_SYSTEM_REQ_IND (# 7)

Source Code Comments

SYSTEM REQUIRED INDICATOR: System Required Indicator.

Columns Comments for GOBDIRO_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for GOBDIRO_SEQ_NO (# 9)

Source Code Comments

SEQUENCE NUMBER: Directory profile indicator.

Table GOBFNXR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOBFNXR_FUNCTION	VARCHAR2(30)	No	*
GOBFNXR_PACKAGE	VARCHAR2(80)	No	*
GOBFNXR_SYS_REQ_IND	VARCHAR2(1)	No
GOBFNXR_ACTIVITY_DATE	DATE	No
GOBFNXR_USER_ID	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBFNXR	Unique	GOBFNXR_PACKAGE
PK_GOBFNXR	Unique	GOBFNXR_FUNCTION

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBFNXRC	Oracle Package Cursor	S10B80.BANINST1.VRGKOINT	Use (select)Rely On
GOBFNXR_REC	Oracle Package Variable	S10B80.BANINST1.VRGKOINT	Rely On
GOBFNXR_ROW_BY_FUNC_C	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Rely On
GOBFNXR_ROW_BY_FUNC_C	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Use (select)Rely On
GOBFNXR_ROW_BY_PKG_FUNC_C	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Rely On
GOBFNXR_ROW_BY_PKG_FUNC_C	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Use (select)Rely On
P_VR_ACCT_REVIEW_BALANCE	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_ADD_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_ADM_APPT_OPER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_MATERIALS_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_ORIENTATION_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_REQUEST_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ALL_REQ_SPEAK_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_APPLY_CC_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_ASSESS_FEES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_AUTODROP_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_AW_MULTI_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_AW_SINGLE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_BIL_INFO_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BIL_OPTIONS_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BUILD_BAD_CC_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_CC_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BUILD_EXPIR_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_PAYMENT_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_ST_ACCOUNT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BYPASS_TERM_CHECKS	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CHANGE_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHANGE_PIN_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHECK_CLAS_AVAIL	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CHECK_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_CHECK_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHECK_OPEN_SECTIONS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CHECK_OPEN_SECTIONS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CONFIRM_NEEDED_CHECK	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_NEEDED_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_REG	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_REG_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONTINUE_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CREDIT_HOURS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CRN_EXCEPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CRN_LIST	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CRN_LIST_MULTI_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CRN_LIST_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_DAY_TIME_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_DROP_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_DROP_CLASS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_END_CALL	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_END_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_END_INFC_TABLE	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_EXCEPTION	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_FIN_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_MATERIALS_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_PROGRAM_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_REQUEST_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_GEN_GRDE_INFO	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GET_AIDY_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_APPL_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_BILLING_DEADLN_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_DAY_TIME	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_GET_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_GET_FIN_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_GET_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRLAP	Rely On
P_VR_GET_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_OFFER_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_PROGRESS_DATA	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GET_TERM_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GIVE_DECISION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_GIVE_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_GRADE_MODE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_GRDE_INFO_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GRDE_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GRDE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_HOLD_OPER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_HOLD_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_INIT_INFC_TABLE	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_LIKE_TO_REG_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_LIST_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_LIST_CLASSES	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_LIST_CURRENT_CLASSES	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_LIST_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_LIST_MORE_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_MAIN_MENU_RETURN	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MAX_TRIES_EXCEEDED	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MENU_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MIF_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MORE_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_MORE_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_MULTI_TERMS	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_NOAPP_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_NO_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_NO_HOLD_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_PMPT_ST_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_ADM_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_BAD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_EXPDATE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_EXPDATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_CC_NUMBER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_CC_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_CC_TYPE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_DETAIL_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_DIFF_AMOUNT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXPIR_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXP_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_MISSING_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MORE_REQ	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MULTI_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_MULT_TERMS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_PROCESS_NEW_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_OFFER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_PROCESS_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_PROCESS_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_PROCESS_REVIEW_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_SINGLE_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_TOTAL_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCES_NONSTU_DET_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROC_ST_ADM_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROMPT_CC_NUMBER	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_DIFF_AMT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_EXP_DATE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_MISSING_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_MORE_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_REBUILD_CURRENT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_REG_APPL_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_APPL_MENU_OPT_CONT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_REG_CLASS_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_DATA_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_REG_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_TERM_ELIGIBLE	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_RESULT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_REVIEW_CHRGS_AND_PYMNTS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_INSTL_PMNT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_MORE_CHPY	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_MORE_INSTL	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_BALANCE	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REV_AND_SPK_ACCT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REV_NONSTU_CHRG_AND_PMNT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_SCHED_DAY_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_SELECT_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_SELECT_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_SINGLE_TERM	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_SINGLE_TERM	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_SPEAK_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_START_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_SYSTEM_PROBLEM	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_TERM_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_VALIDATE_ALT_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_BIRTH_DATE	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_ID	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VERIFY_CREDIT_CARD	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_VERIFY_DROP	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_VERIFY_START_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_WAITLIST_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_WITHDRAW_FROM_TERM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
F_GET_COMMAND	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_GET_GOBFNXR_REC	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_GET_PROC	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_GET_PROCESS	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_VR_GET_NEXT_TRANS	Oracle Package Function	S10B80.BANINST1.VRGKOCTL	Rely On
GOBFNXR	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_GOBFNXR	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBFNXR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:33:43:000	04/02/2008 21:17:58:000

Source Code Comments

Third-Party Function Calls Table.

Columns Comments for GOBFNXR_FUNCTION (# 1)

Source Code Comments

Function or transaction label associated with the package and procedure e.g. MAIN_MENU, REG_MENU, FIN_MENU.

Columns Comments for GOBFNXR_PACKAGE (# 2)

Source Code Comments

Name of package and procedure associated with function.

Columns Comments for GOBFNXR_SYS_REQ_IND (# 3)

Source Code Comments

System Required Indicator. Indicates whether the record is required by the SCT system.

Columns Comments for GOBFNXR_ACTIVITY_DATE (# 4)

Source Code Comments

Date on which the record was last updated or created.

Columns Comments for GOBFNXR_USER_ID (# 5)

Source Code Comments

The user id of the person who updates this record.

Table GOBQSTN

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOBQSTN_ID	VARCHAR2(6)	No	*
GOBQSTN_DESC	VARCHAR2(255)	No
GOBQSTN_DISPLAY_IND	VARCHAR2(1)	No
GOBQSTN_USER_ID	VARCHAR2(30)	No
GOBQSTN_ACTIVITY_DATE	DATE	No
GOBQSTN_DATA_ORIGIN	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBQSTN	Unique	GOBQSTN_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBANSR	SQL Table	S10B80.GENERAL	Refer (no action)
PIN_QUESTION_REC	Oracle Package Type	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
P_DISPQUESTIONLIST	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_DISPQUESTIONLIST	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
F_BUILD_GOBQSTN_REC	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBQSTN	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GOBQSTN	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_QUESTION	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_QUESTION_RULES	Rely On
P_SECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_SECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBQSTN	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_PIN_QUESTION_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_PIN_QUESTION	Use (select)
GOBQSTN	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_GOBQSTN	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBQSTN

Object Dates

Creation Date	Analysis Date
04/02/2008 20:32:59:000	04/02/2008 21:17:57:000

Source Code Comments

General table for storing list of PIN questions

Columns Comments for GOBQSTN_ID (# 1)

Source Code Comments

ID: Unique identifier for the question.

Columns Comments for GOBQSTN_DESC (# 2)

Source Code Comments

DESC: Descriptive questions

Columns Comments for GOBQSTN_DISPLAY_IND (# 3)

Source Code Comments

DISPLAY_IND: Descriptive questions

Columns Comments for GOBQSTN_USER_ID (# 4)

Source Code Comments

USER_ID: ID of the user who created or last updated the record.

Columns Comments for GOBQSTN_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY_DATE: Date on which the record was created or last updated.

Columns Comments for GOBQSTN_DATA_ORIGIN (# 6)

Source Code Comments

DATA_ORIGIN: Source system that created or updated the row

Table GOBSRVR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOBSRVR_PIDM	NUMBER(8,0)	No	*
GOBSRVR_NAME	VARCHAR2(15)	No	*
GOBSRVR_ACTIVITY_DATE	DATE	No
GOBSRVR_USER	VARCHAR2(30)	No
GOBSRVR_DECLINED_IND	VARCHAR2(1)	No
GOBSRVR_COMPLETE_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBSRVR	Unique	GOBSRVR_PIDM
PK_GOBSRVR	Unique	GOBSRVR_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORSRVR	SQL Table	S10B80.GENERAL	Refer (no action)
SPRIDEN	SQL Table	S10B80.SATURN	Join
GOVSRVR	SQL View	S10B80.BANINST1	Use (select)
GOBSRVR_REC	Oracle Package Variable	S10B80.BANINST1.BWGKSRVY	Rely On
P_MODIFYRESPONSEHEAD	Oracle Package Procedure	S10B80.BANINST1.BWGKSRVY	Use (Insert,update)
GOBSRVRREADC	Oracle Package Cursor	S10B80.BANINST1.BWGKSRVY	Use (select)Rely On
GOBSRVR	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_GOBSRVR	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBSRVR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:54:000	04/02/2008 21:17:54:000

Source Code Comments

Survey Response Header Table. This table contains one row for each person who responds to the survey.

Columns Comments for GOBSRVR_PIDM (# 1)

Source Code Comments

Internal Identification Number of the person who responded to the survey.

Columns Comments for GOBSRVR_NAME (# 2)

Source Code Comments

Survey Name.

Columns Comments for GOBSRVR_ACTIVITY_DATE (# 3)

Source Code Comments

The date that the person last responded to the survey.

Columns Comments for GOBSRVR_USER (# 4)

Source Code Comments

The User ID(Oracle) of the person who responded to the survey.

Columns Comments for GOBSRVR_DECLINED_IND (# 5)

Source Code Comments

Declined Indicator. Y = user declined to answer the survey.

Columns Comments for GOBSRVR_COMPLETE_IND (# 6)

Source Code Comments

Complete Indicator. Y indicates complete, N indicates incomplete.

Table GOBTPAC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOBTPAC_PIDM	NUMBER(8,0)	No	*
GOBTPAC_PIN_DISABLED_IND	VARCHAR2(1)	No
GOBTPAC_USAGE_ACCEPT_IND	VARCHAR2(1)	No
GOBTPAC_ACTIVITY_DATE	DATE	No
GOBTPAC_USER	VARCHAR2(30)	No
GOBTPAC_PIN	VARCHAR2(256)	Yes
GOBTPAC_PIN_EXP_DATE	DATE	Yes
GOBTPAC_EXTERNAL_USER	VARCHAR2(30)	Yes
GOBTPAC_QUESTION	VARCHAR2(90)	Yes
GOBTPAC_RESPONSE	VARCHAR2(30)	Yes
GOBTPAC_INSERT_SOURCE	VARCHAR2(8)	Yes
GOBTPAC_LDAP_USER	VARCHAR2(255)	Yes
GOBTPAC_DATA_ORIGIN	VARCHAR2(30)	Yes
GOBTPAC_SALT	VARCHAR2(128)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GOBTPAC_KEY_INDEX	Unique	GOBTPAC_EXTERNAL_USER
PK_GOBTPAC	Unique	GOBTPAC_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SPRIDEN	SQL Table	S10B80.SATURN	Join
GT_GOBTPAC_AR_LDI	SQL Trigger	S10B80.GENERAL	Rely On
NET_USER	Oracle Package Type	S10B80.BANINST1.IMF_SERVICE	Rely On
PERSON_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSPKCOM	Rely On
THIRD_PARTY_ACCESS_REC	Oracle Package Type	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
GETGOBTPACBYPIDMC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
GETGOBTPACC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
GETGOBTPACC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)
PERSON_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
P_AUTHENTICATE_BANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKLOGN	Rely On
P_AUTHENTICATE_LDAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKLOGN	Rely On
P_INSERT_GOBSRID_REC	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_INSERT_GORPAUD_REC	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_RECORD_LOGIN_ATTEMPT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
UT_GB_THIRD_PARTY_ACCESSC_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_THIRD_PARTY_ACCESS	Use (select)
UT_SP_LDIPERSONPROCESSAPI	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (delete)
PIDM_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.GOKTPTY	Rely On
GOBTPAC_REC	Oracle Package Variable	S10B80.BANINST1.BWCKREGS	Rely On
GOBTPAC_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
GV_EXTERNAL_USER	Oracle Package Variable	S10B80.BANINST1.UT_GB_INSTITUTION_ROLE	Rely On
GV_EXTERNAL_USER	Oracle Package Variable	S10B80.BANINST1.UT_SP_LDIPERSON	Rely On
GV_EXTERNAL_USER	Oracle Package Variable	S10B80.BANINST1.UT_GP_CARDHOLDER	Rely On
GV_LOGON_ID	Oracle Package Variable	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Rely On
GV_LOGON_ID2	Oracle Package Variable	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Rely On
GV_LOGON_ID999	Oracle Package Variable	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Rely On
GV_PIN	Oracle Package Variable	S10B80.BANINST1.UT_SP_LDIPERSON	Rely On
PIN	Oracle Package Variable	S10B80.BANINST1.BWCKREGS	Rely On
F_BUILD_GOBTPAC_REC	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_CHECK_PIN_REUSE	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
F_CPPASSWDEXPIRED	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
GOBTPACC	Oracle Package Cursor	S10B80.WTAILOR.TWBKGLIB	Use (select)Rely On
GOBTPACC	Oracle Package Cursor	S10B80.BANINST1.GOKLIBS	Use (select)Rely On
P_CERTIFICATIONDRIVER	Oracle Package Procedure	S10B80.BANINST1.BWPKTESB	Rely On
P_CHANGE_PIN	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_CREATE_GOBTPAC	Oracle Package Procedure	S10B80.WTAILOR.TWBKSLIB	Rely On
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_FIRSTMENU	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_FORWARDFROMBANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Rely On
P_FORWARDFROMBANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GOBTPAC	Use (Insert)Rely On
P_INSERT_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Rely On
P_INSERT_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Use (select)
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GOKMAIL	Rely On
P_POPULATE_PIDM_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.GOKPAPI	Use (select)
P_PROCCHANGEPIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_PROCLOGINNON	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_PROCSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_REGISTERNOW	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
P_RETURNFROMOTHER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Rely On
P_RETURNFROMOTHER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (select)
P_SAVE_GLOBAL_PIDM	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Rely On
P_SECURELOGIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
P_SECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBTPAC	Use (update)Rely On
P_UPDATE_GOBTPAC	Oracle Package Procedure	S10B80.WTAILOR.TWBKSLIB	Rely On
P_UPDATE_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKMODS	Rely On
P_UPDATE_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKMODS	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
P_VALIDATECHANGEPIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_VALIDATECHANGEPIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
P_VALIDATE_PIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKLOGN	Rely On
P_VALIDATE_PINRULES	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
P_VALLOGIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_VR_MENU_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_VALIDATE_ID	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_NEWPIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_VERPIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_WEB_LOGIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKAUSR	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TP_STUDENT_DEPOSIT	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_ELIGIBILITY	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TP_STUDENT_RECEIVABLE	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_ENTITY_ADDRESS	Use (select)
F_CALC_LOGON_ID	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_CHECK_EXTERNAL_USER	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Rely On
F_CHECK_MGMT_CONTROL	Oracle Package Function	S10B80.BANINST1.SFKRCTL	Rely On
F_CPAUTHENTICATE	Oracle Package Function	S10B80.WTAILOR.TWBKAUTH	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
F_EXTERNAL_PIN	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_GENERATE_EXTERNAL_USER	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Rely On
F_GET_CURRENT_PIN	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_GET_CURRENT_PIN	Oracle Package Function	S10B80.BANINST1.GOKFUNC	Rely On
F_GET_ENCRYPTION_TYPE	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_NET_ID	Oracle Package Function	S10B80.BANINST1.IMF_SERVICE	Rely On
F_GET_NET_ID	Oracle Package Function	S10B80.BANINST1.IMF_SERVICE2	Rely On
F_GET_PERSON_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GET_PIDM	Oracle Package Function	S10B80.BANINST1.GOKPAPI	Use (select)
F_GET_PIN	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_PINHASH	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_LDAP_BANNERSEARCH	Oracle Package Function	S10B80.WTAILOR.TWBKLOGN	Use (select)
F_PINREUSED	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Rely On
F_PINREUSED	Oracle Package Function	S10B80.BANINST1.GOKLIBS	Rely On
F_PROC_PIN	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
F_VALIDATESTUDENTPIN	Oracle Package Function	S10B80.BANINST1.BWCKCOMS	Rely On
F_VALIDATE_PIN	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
GOBTPAC	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
GOBTPAC_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
PK_GOBTPAC	SQL Index	S10B80.GENERAL	Rely On
GT_GOBTPAC_AR_LDI	SQL Trigger	S10B80.GENERAL	Fire (Insert,update,delete,after,each row)
GT_GOBTPAC_AS_LDI	SQL Trigger	S10B80.GENERAL	Fire (Insert,update,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBTPAC

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:15:000	04/02/2008 21:17:51:000

Source Code Comments

Third Party Access Table

Columns Comments for GOBTPAC_PIDM (# 1)

Source Code Comments

Banner PIDM

Columns Comments for GOBTPAC_PIN_DISABLED_IND (# 2)

Source Code Comments

PIN disabled Indicator. When Y, access to SCT Third Party Access products (Web Fors, VR, Kiosk) will be denied.

Columns Comments for GOBTPAC_USAGE_ACCEPT_IND (# 3)

Source Code Comments

Terms of Usage accepted indicator. When N, Terms of Usage page displays upon login to Web For products. When Y then it does not display. This page can be customized using the WebTailor Customize a set of Information Text feature.

Columns Comments for GOBTPAC_ACTIVITY_DATE (# 4)

Source Code Comments

Date on which the record was last added or updated.

Columns Comments for GOBTPAC_USER (# 5)

Source Code Comments

Oracle User ID of the last user to modify the record

Columns Comments for GOBTPAC_PIN (# 6)

Source Code Comments

Personal Identification Number. It is used together with the Login ID to access SCT Third Party products and other partner systems. Must be a six digit number.

Columns Comments for GOBTPAC_PIN_EXP_DATE (# 7)

Source Code Comments

PIN expiration date. When valued and the date is in the past, a user attempting to access a Third Party product will be required to change their pin.

Columns Comments for GOBTPAC_EXTERNAL_USER (# 8)

Source Code Comments

Value which may be passed to the partner systems as a login ID and/or email ID..

Columns Comments for GOBTPAC_QUESTION (# 9)

Source Code Comments

Free form question entered by a Web User to be used as a hint when trying to get their PIN reset.

Columns Comments for GOBTPAC_RESPONSE (# 10)

Source Code Comments

Free form response entered by a Web User to be used as answer to the hint question when trying to get their PIN reset.

Columns Comments for GOBTPAC_INSERT_SOURCE (# 11)

Source Code Comments

ACTIVITY SOURCE: Describes the source of the GOBTPAC insert or update. SELF = User change the pin record, ADMIN = Administrator change the pin record, SYSTEM = Record was changed by the logic in a process.

Columns Comments for GOBTPAC_LDAP_USER (# 12)

Source Code Comments

LDAP User Mapping: This will optionally store non LUMINIS LDAP user mapping for Banner.

Columns Comments for GOBTPAC_DATA_ORIGIN (# 13)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Columns Comments for GOBTPAC_SALT (# 14)

Source Code Comments

SALT: Random value used in generation of PIN Hash.

Table GORADRL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORADRL_ATYP_CODE	VARCHAR2(2)	No	*	*
GORADRL_ROLE	VARCHAR2(30)	No	*
GORADRL_PRIV_IND	VARCHAR2(1)	No
GORADRL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORADRL_ATYP_CODE	STVATYP_CODE	STVATYP

Index

Index Name	Index Type	Column Name
PK_GORADRL	Unique	GORADRL_ATYP_CODE
PK_GORADRL	Unique	GORADRL_ROLE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SPRADDR	SQL Table	S10B80.SATURN	Join
GETSTVATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)
GORADRLPRIVC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GORADRLVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWLKOSAD	Use (select)
SPRADDRLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
STVATYPUPDATEC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWLKOSAD	Use (select)
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
UROLE	Oracle Package Variable	S10B80.BANINST1.BWLKOSAD	Rely On
F_ROLEPRIV	Oracle Package Function	S10B80.BANINST1.BWGKOADR	Use (select)
P_PREF_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWAKPREF	Use (select)
F_ROLEPRIV	Oracle Package Function	S10B80.BANINST1.BWLKOSAD	Use (select)
GORADRL	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_GORADRL	SQL Index	S10B80.GENERAL	Rely On
STVATYP	SQL Table	S10B80.SATURN	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORADRL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:55:000	04/02/2008 21:17:52:000

Source Code Comments

Address/User Roles Rules Table

Columns Comments for GORADRL_ATYP_CODE (# 1)

Source Code Comments

Address Type Code

Columns Comments for GORADRL_ROLE (# 2)

Source Code Comments

User Role. Values are STUDENT, EMPLOYEE, or FACULTY

Columns Comments for GORADRL_PRIV_IND (# 3)

Source Code Comments

Privilege Indicator. Values are (U)pdate, (D)isplay, or (N)one

Columns Comments for GORADRL_ACTIVITY_DATE (# 4)

Source Code Comments

Last Activity Date

Table GORDADD

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORDADD_DIRO_CODE	VARCHAR2(8)	No	*	*
GORDADD_PRIORITY_NO	NUMBER(1,0)	No	*
GORDADD_ATYP_CODE	VARCHAR2(2)	Yes
GORDADD_TELE_CODE	VARCHAR2(4)	Yes
GORDADD_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORDADD_DIRO_CODE	GOBDIRO_DIRO_CODE	GOBDIRO

Index

Index Name	Index Type	Column Name
PK_GORDADD	Unique	GORDADD_DIRO_CODE
PK_GORDADD	Unique	GORDADD_PRIORITY_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORDADD_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
GORDADDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)Rely On
P_GETPHONES	Oracle Package Procedure	S10B80.BANINST1.BWPKEDIR	Use (select)
GORDADD	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_GORDADD	SQL Index	S10B80.GENERAL	Rely On
GOBDIRO	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORDADD

Object Dates

Creation Date	Analysis Date
04/02/2008 20:33:19:000	04/02/2008 21:17:57:000

Source Code Comments

Directory Address Table

Columns Comments for GORDADD_DIRO_CODE (# 1)

Source Code Comments

DIRECTORY CODE: Code for Directory Item.

Columns Comments for GORDADD_PRIORITY_NO (# 2)

Source Code Comments

PRIORITY NUMBER: Priority Number.

Columns Comments for GORDADD_ATYP_CODE (# 3)

Source Code Comments

ADDRESS TYPE CODE: Address Type Code.

Columns Comments for GORDADD_TELE_CODE (# 4)

Source Code Comments

TELEPHONE TYPE CODE: Telephone Type Code.

Columns Comments for GORDADD_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Table GORDPRF

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORDPRF_PIDM	NUMBER(8,0)	No	*
GORDPRF_DIRO_CODE	VARCHAR2(8)	No	*	*
GORDPRF_DISP_DIRECTORY_IND	VARCHAR2(1)	No
GORDPRF_USER_ID	VARCHAR2(30)	No
GORDPRF_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORDPRF_DIRO_CODE	GOBDIRO_DIRO_CODE	GOBDIRO

Index

Index Name	Index Type	Column Name
PK_GORDPRF	Unique	GORDPRF_PIDM
PK_GORDPRF	Unique	GORDPRF_DIRO_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORDPRFC	Oracle Package Cursor	S10B80.BANINST1.BWAKSRCH	Use (select)
GORDPRFC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)
GORDPRF_REC	Oracle Package Variable	S10B80.BANINST1.BWAKSRCH	Rely On
GORDPRF_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
P_MODIFYDIROITEM	Oracle Package Procedure	S10B80.BANINST1.BWGKOPRF	Use (Insert,update)
GORDPRF	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_GORDPRF	SQL Index	S10B80.GENERAL	Rely On
GOBDIRO	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORDPRF

Object Dates

Creation Date	Analysis Date
04/02/2008 20:33:45:000	04/02/2008 21:17:58:000

Source Code Comments

Directory Profile Table

Columns Comments for GORDPRF_PIDM (# 1)

Source Code Comments

PIDM NUMBER: Personal Identification Number.

Columns Comments for GORDPRF_DIRO_CODE (# 2)

Source Code Comments

DIRECTORY CODE: Code for Directory Item.

Columns Comments for GORDPRF_DISP_DIRECTORY_IND (# 3)

Source Code Comments

DISPLAY INDICATOR: Display Indicator; Y or N.

Columns Comments for GORDPRF_USER_ID (# 4)

Source Code Comments

USER ID: The ORACLE user id of the person last updating this record.

Columns Comments for GORDPRF_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Table GOREMAL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOREMAL_PIDM	NUMBER(8,0)	No	*	*
GOREMAL_EMAL_CODE	VARCHAR2(4)	No	*	*
GOREMAL_EMAIL_ADDRESS	VARCHAR2(128)	No	*
GOREMAL_STATUS_IND	VARCHAR2(1)	No
GOREMAL_PREFERRED_IND	VARCHAR2(1)	No
GOREMAL_ACTIVITY_DATE	DATE	No
GOREMAL_USER_ID	VARCHAR2(30)	No
GOREMAL_COMMENT	VARCHAR2(60)	Yes
GOREMAL_DISP_WEB_IND	VARCHAR2(1)	No
GOREMAL_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOREMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL
GOREMAL_PIDM	SARADAP_PIDM	SARADAP
GOREMAL_EMAL_CODE	GORICCR_VALUE	GORICCR

Index

Index Name	Index Type	Column Name
PK_GOREMAL	Unique	GOREMAL_PIDM
PK_GOREMAL	Unique	GOREMAL_EMAL_CODE
PK_GOREMAL	Unique	GOREMAL_EMAIL_ADDRESS

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRADVR	SQL Table	S10B80.SATURN	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
GT_GOREMAL_AR_LDI	SQL Trigger	S10B80.GENERAL	Rely On
SAVAMCD	SQL View	S10B80.BANINST1	Use (select)
F_GET_EMAIL_ROWID	SQL Function	S10B80.BANINST1	Use (select)
EMAIL_REC	Oracle Package Type	S10B80.BANINST1.GB_EMAIL	Rely On
EMAIL_RECORD	Oracle Package Type	S10B80.BANINST1.GOKSEVN	Rely On
EMAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
EMAL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKADVS	Rely On
GOREMAL_LINK_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
GOREMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
PREV_EMAL	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
GET_GOREMAL_EMAIL_C	Oracle Package Cursor	S10B80.BANINST1.BWLKFCWL	Use (select)
GOREMALC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)
GOREMALEMALEADDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALERIDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALPREFC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALPREFERIDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
GOREMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKADVS	Use (select)
GOREMAL_BY_PREFERRED_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Rely On
GOREMAL_BY_PREFERRED_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
GOREMAL_BY_TYPE_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Rely On
GOREMAL_BY_TYPE_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
GOREMAL_ETYP_C	Oracle Package Cursor	S10B80.BANINST1.APKLDRD	Rely On
GOREMAL_ETYP_C	Oracle Package Cursor	S10B80.BANINST1.APKLDRD	Use (select)Rely On
LATEST_SPBPERSC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
P_MATCH_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_GOREMAL_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
EMAIL	Oracle Package Variable	S10B80.BANINST1.BWLKFCWL	Rely On
GOREMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
GV_EMAIL_ADDRESS1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_ADDRESS2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_ADDRESS3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_FRN_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_GOREMAL_REC	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_BUILD_MAIL_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_STUDENT	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_STUDENT_COLLECTION	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_US_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_EMAILSDAXEXISTS	Oracle Package Function	S10B80.BANINST1.GOKSEVN	Use (select)
F_GET_PERSON_DETAILS	Oracle Package Function	S10B80.BANINST1.ICSPKLDI	Rely On
F_GOREMAL_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Use (select)
GOREMALC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
GOREMALC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GTVEMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GOREMAL	Use (delete)
P_DISPADVISEES	Oracle Package Procedure	S10B80.BANINST1.BWLKADVR	Rely On
P_DISPADVISEES	Oracle Package Procedure	S10B80.BANINST1.BWLKADVR	Use (select)
P_DISPCURRENT	Oracle Package Procedure	S10B80.BANINST1.BWCKCAPP	Rely On
P_DISPEVALADDITIONAL	Oracle Package Procedure	S10B80.BANINST1.BWCKSNCR	Rely On
P_DISPEVALDETAILREQ	Oracle Package Procedure	S10B80.BANINST1.BWCKSMLT	Rely On
P_DISPEVALGENERALREQ	Oracle Package Procedure	S10B80.BANINST1.BWCKSMLT	Rely On
P_EMAILEVENTCHECK	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_EMAIL_INSERT	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_EMAIL_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_GETEMAILS	Oracle Package Procedure	S10B80.BANINST1.BWPKEDIR	Use (select)
P_GET_GIFT_INFO	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Rely On
P_GET_GIFT_INFO	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Use (select)
P_GET_STUDENT_ADVISORS	Oracle Package Procedure	S10B80.BANINST1.BWSCBREF	Use (select)
P_GET_STUDENT_ADVISORS	Oracle Package Procedure	S10B80.BANINST1.BWSCJREF	Use (select)
P_GET_STUDENT_ADVISORS	Oracle Package Procedure	S10B80.BANINST1.BWXCBREF	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GOREMAL	Use (Insert)Rely On
P_INSERT_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_LOAD_EMAIL	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Rely On
P_LOAD_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SAKL045	Rely On
P_LOAD_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SAKL045	Use (select)
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Use (select)
P_MODIFY_USER	Oracle Package Procedure	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
P_MODIFY_USER	Oracle Package Procedure	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Use (select)
P_PERSON_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_PERSON_EXP	Rely On
P_PERSON_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_PERSON_EXP	Use (select)
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL_RULES	Rely On
P_SEND_EMAIL	Oracle Package Procedure	S10B80.BANINST1.SFKWLAT	Rely On
P_SEND_EMAIL	Oracle Package Procedure	S10B80.BANINST1.SFKWLAT	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GOREMAL	Use (update)Rely On
P_VALEMAILUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL_RULES	Use (select)
P_VERIFYDISPEVALVIEWOPTION	Oracle Package Procedure	S10B80.BANINST1.BWCKCAPP	Rely On
F_CLASS_EMAIL_STR	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Rely On
F_CLASS_EMAIL_STR	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Use (select)
F_DISP_INSTR_EMAIL_ICON	Oracle Package Function	S10B80.BANINST1.BWCKFRMT	Rely On
F_DISP_INSTR_EMAIL_ICON	Oracle Package Function	S10B80.BANINST1.BWCKFRMT	Use (select)
F_EMAIL_VALUE	Oracle Package Function	S10B80.BANINST1.SFKWLAT	Rely On
F_EMAIL_VALUE	Oracle Package Function	S10B80.BANINST1.SFKWLAT	Use (select)
F_EQUAL_E_ADDRESS	Oracle Package Function	S10B80.BANINST1.SRKPREL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
F_GETEMAILADDRESS	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Rely On
F_GETEMAILADDRESS	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Use (select)
F_GETEMAILADDRESS	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Rely On
F_GETEMAILADDRESS	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Use (select)
F_GET_ADV_DASH_COMMON_XML	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Rely On
F_GET_ADV_DASH_RESULT	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Rely On
F_GET_EMAIL	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_PERSON_DETAILS	Oracle Package Function	S10B80.BANINST1.VIJAYSPKLDI	Rely On
F_GET_PERSON_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GET_STUDENT_DATA	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_LOOKUP_USER	Oracle Package Function	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
F_LOOKUP_USER	Oracle Package Function	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Use (select)
F_PREFERRED_IND_RULE	Oracle Package Function	S10B80.BANINST1.GB_EMAIL_RULES	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
GOREMAL	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_GOREMAL	SQL Index	S10B80.GENERAL	Rely On
GORICCR	SQL Table	S10B80.GENERAL	Join
GTVEMAL	SQL Table	S10B80.GENERAL	Refer (no action)
SARADAP	SQL Table	S10B80.SATURN	Join
GT_GOREMAL_AR_LDI	SQL Trigger	S10B80.GENERAL	Fire (Insert,update,delete,after,each row)
GT_GOREMAL_AS_LDI	SQL Trigger	S10B80.GENERAL	Fire (Insert,update,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOREMAL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:33:03:000	04/02/2008 21:17:57:000

Source Code Comments

Person E-mail repeating table.

Columns Comments for GOREMAL_PIDM (# 1)

Source Code Comments

The pidm of the entity who owns this e-mail information.

Columns Comments for GOREMAL_EMAL_CODE (# 2)

Source Code Comments

The type of e-mail address.

Columns Comments for GOREMAL_EMAIL_ADDRESS (# 3)

Source Code Comments

The e-mail address.

Columns Comments for GOREMAL_STATUS_IND (# 4)

Source Code Comments

The status of the e-mail address: (A)ctive, (I)nactive

Columns Comments for GOREMAL_PREFERRED_IND (# 5)

Source Code Comments

This column indicates if the e-mail address is the preferred contact address.

Columns Comments for GOREMAL_ACTIVITY_DATE (# 6)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GOREMAL_USER_ID (# 7)

Source Code Comments

The user id when the row was added or modified.

Columns Comments for GOREMAL_COMMENT (# 8)

Source Code Comments

This is a free format comment regarding the e-mail information.

Columns Comments for GOREMAL_DISP_WEB_IND (# 9)

Source Code Comments

Indicate whether a e-mail address should appear on Web.

Columns Comments for GOREMAL_DATA_ORIGIN (# 10)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GORPAUD

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GORPAUD_PIDM	NUMBER(8,0)	No
GORPAUD_ACTIVITY_DATE	DATE	No
GORPAUD_USER	VARCHAR2(30)	No
GORPAUD_PIN	VARCHAR2(256)	Yes
GORPAUD_EXTERNAL_USER	VARCHAR2(30)	Yes
GORPAUD_CHG_IND	VARCHAR2(1)	No
GORPAUD_SALT	VARCHAR2(128)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GORPAUD_KEY_INDEX		GORPAUD_PIDM
GORPAUD_KEY_INDEX2		GORPAUD_EXTERNAL_USER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_INSERT_GORPAUD_REC	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
UT_SP_LDIPERSONPROCESSAPI	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (delete)
F_CHECK_PIN_REUSE	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORPAUD	Use (delete)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORPAUD	Use (Insert)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORPAUD	Rely On
F_CHECK_EXTERNAL_USER	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
F_EXTERNAL_PIN	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_EXTERNAL_PIN	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
F_PINREUSED	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Use (select)
F_PINREUSED	Oracle Package Function	S10B80.BANINST1.GOKLIBS	Use (select)
GORPAUD	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
GORPAUD_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GORPAUD_KEY_INDEX2	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORPAUD

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:29:000	04/02/2008 21:17:55:000

Source Code Comments

Third Party Access Audit Table

Columns Comments for GORPAUD_PIDM (# 1)

Source Code Comments

Banner PIDM

Columns Comments for GORPAUD_ACTIVITY_DATE (# 2)

Source Code Comments

Date on which the audit trail record was modified.

Columns Comments for GORPAUD_USER (# 3)

Source Code Comments

Oracle User ID of the user who created or last updated the PIN

Columns Comments for GORPAUD_PIN (# 4)

Source Code Comments

Previous PIN

Columns Comments for GORPAUD_EXTERNAL_USER (# 5)

Source Code Comments

Previous External User.

Columns Comments for GORPAUD_CHG_IND (# 6)

Source Code Comments

Change Indicator. Flag used to indicate why this audit record was written. P = PIN change, I = User ID change.

Columns Comments for GORPAUD_SALT (# 7)

Source Code Comments

SALT: Random value used in generation of PIN Hash.

Table GORPPRM

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GORPPRM_PACKAGE	VARCHAR2(80)	No
GORPPRM_SEQ	NUMBER(0,0)	No
GORPPRM_NAME	VARCHAR2(30)	No
GORPPRM_KEY_POS	NUMBER(0,0)	No
GORPPRM_OUTPUT_IND	VARCHAR2(1)	No
GORPPRM_TYPE_IND	VARCHAR2(1)	No
GORPPRM_MIN_LEN	NUMBER(0,0)	No
GORPPRM_MAX_LEN	NUMBER(0,0)	No
GORPPRM_SYS_REQ_IND	VARCHAR2(1)	No
GORPPRM_ACTIVITY_DATE	DATE	No
GORPPRM_USER_ID	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GORPPRM_KEY_INDEX	Unique	GORPPRM_PACKAGE
GORPPRM_KEY_INDEX	Unique	GORPPRM_SEQ

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORPPRMC	Oracle Package Cursor	S10B80.BANINST1.VRGKOINT	Use (select)Rely On
GORPPRM_TYP	Oracle Package Type	S10B80.BANINST1.VRGKOINT	Rely On
GORPPRM_REC	Oracle Package Variable	S10B80.BANINST1.VRGKOINT	Rely On
GORPPRM_ROW_BY_PKG_C	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Rely On
GORPPRM_ROW_BY_PKG_C	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Use (select)Rely On
P_VR_END_INFC_TABLE	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_INIT_INFC_TABLE	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
GORPPRM	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
GORPPRM_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORPPRM

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:25:000	04/02/2008 21:17:55:000

Source Code Comments

Third-Party Function Parameters Table.

Columns Comments for GORPPRM_PACKAGE (# 1)

Source Code Comments

Name of package and procedure.

Columns Comments for GORPPRM_SEQ (# 2)

Source Code Comments

Sequence number of parameter.

Columns Comments for GORPPRM_NAME (# 3)

Source Code Comments

Parameter value used by procedure.

Columns Comments for GORPPRM_KEY_POS (# 4)

Source Code Comments

Position in data string in which the parameter resides.

Columns Comments for GORPPRM_OUTPUT_IND (# 5)

Source Code Comments

Flag indicating whether data contained in parameter is to be included in the output string.

Columns Comments for GORPPRM_TYPE_IND (# 6)

Source Code Comments

Type of data contained in the parameter, e.g. character or number.

Columns Comments for GORPPRM_MIN_LEN (# 7)

Source Code Comments

Minimum length of data contained in parameter.

Columns Comments for GORPPRM_MAX_LEN (# 8)

Source Code Comments

Maximum length of data contained in parameter.

Columns Comments for GORPPRM_SYS_REQ_IND (# 9)

Source Code Comments

System Required Indicator. Indicates whether the record is required by the SCT system.

Columns Comments for GORPPRM_ACTIVITY_DATE (# 10)

Source Code Comments

Date on which the record was last updated or created.

Columns Comments for GORPPRM_USER_ID (# 11)

Source Code Comments

User ID of the person who updates this record.

Table GORSRVR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORSRVR_PIDM	NUMBER(8,0)	No	*	*
GORSRVR_NAME	VARCHAR2(15)	No	*	*
GORSRVR_QUESTION_NO	NUMBER(3,0)	No	*
GORSRVR_ACTIVITY_DATE	DATE	No
GORSRVR_USER	VARCHAR2(30)	No
GORSRVR_RESPONSE_1	VARCHAR2(1)	Yes
GORSRVR_RESPONSE_2	VARCHAR2(1)	Yes
GORSRVR_RESPONSE_3	VARCHAR2(1)	Yes
GORSRVR_RESPONSE_4	VARCHAR2(1)	Yes
GORSRVR_RESPONSE_5	VARCHAR2(1)	Yes
GORSRVR_COMMENTS	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORSRVR_PIDM	GOBSRVR_PIDM	GOBSRVR
GORSRVR_NAME	GOBSRVR_NAME	GOBSRVR

Index

Index Name	Index Type	Column Name
PK_GORSRVR	Unique	GORSRVR_PIDM
PK_GORSRVR	Unique	GORSRVR_NAME
PK_GORSRVR	Unique	GORSRVR_QUESTION_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORSRVR_ADS	SQL View	S10B80.BANINST1	Use (select)
GORSRVR_SUB	SQL View	S10B80.BANINST1	Use (select)
GORSRVR_REC	Oracle Package Variable	S10B80.BANINST1.BWGKSRVY	Rely On
P_MODIFYRESPONSES	Oracle Package Procedure	S10B80.BANINST1.BWGKSRVY	Use (Insert,update)
GORSRVRREADC	Oracle Package Cursor	S10B80.BANINST1.BWGKSRVY	Use (select)Rely On
GORSRVR	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_GORSRVR	SQL Index	S10B80.GENERAL	Rely On
GOBSRVR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORSRVR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:11:000	04/02/2008 21:17:51:000

Source Code Comments

Survey Repsonses Repeating Table. This tables store the individual responses.

Columns Comments for GORSRVR_PIDM (# 1)

Source Code Comments

Internal Identification Number of the person who responded to the survey.

Columns Comments for GORSRVR_NAME (# 2)

Source Code Comments

Survey Name.

Columns Comments for GORSRVR_QUESTION_NO (# 3)

Source Code Comments

Survey Response Question Number.

Columns Comments for GORSRVR_ACTIVITY_DATE (# 4)

Source Code Comments

The date that the response was created or last updated.

Columns Comments for GORSRVR_USER (# 5)

Source Code Comments

The User ID which created or last updated the response.

Columns Comments for GORSRVR_RESPONSE_1 (# 6)

Source Code Comments

First possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_2 (# 7)

Source Code Comments

Second possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_3 (# 8)

Source Code Comments

Third possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_4 (# 9)

Source Code Comments

Fourth possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_5 (# 10)

Source Code Comments

Fifth possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_COMMENTS (# 11)

Source Code Comments

Free form text entered as comments by the respondent.

Table GORTCTL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GORTCTL_GROUP	VARCHAR2(15)	No
GORTCTL_FUNCTION	VARCHAR2(20)	No
GORTCTL_DESC	VARCHAR2(60)	No
GORTCTL_TERM_YEAR	VARCHAR2(6)	No
GORTCTL_TCTL_NUM	NUMBER(2,0)	No
GORTCTL_VALUE	VARCHAR2(2)	No
GORTCTL_ACTIVE_IND	VARCHAR2(1)	No
GORTCTL_SYS_REQ_IND	VARCHAR2(1)	No
GORTCTL_ACTIVITY_DATE	DATE	No
GORTCTL_USER_ID	VARCHAR2(30)	No
GORTCTL_TCTL_SEQNO	NUMBER(2,0)	Yes
GORTCTL_BEGIN_DATE	DATE	Yes
GORTCTL_END_DATE	DATE	Yes
GORTCTL_BEGIN_TIME	VARCHAR2(4)	Yes
GORTCTL_END_TIME	VARCHAR2(4)	Yes
GORTCTL_DAYS_AVAIL	VARCHAR2(9)	Yes
GORTCTL_YEAR	VARCHAR2(4)	Yes
GORTCTL_YEAR_2	VARCHAR2(4)	Yes
GORTCTL_VALUE_2	VARCHAR2(30)	Yes
GORTCTL_VALUE_3	VARCHAR2(30)	Yes
GORTCTL_VALUE_4	VARCHAR2(30)	Yes
GORTCTL_TERM_YEAR_2	VARCHAR2(6)	Yes
GORTCTL_DATE	DATE	Yes
GORTCTL_SYSI_CODE	VARCHAR2(2)	Yes
GORTCTL_SYSI_CODE_2	VARCHAR2(2)	Yes
GORTCTL_RECORD_TYPE	VARCHAR2(10)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GORTCTL_KEY_INDEX		GORTCTL_FUNCTION
GORTCTL_KEY_INDEX		GORTCTL_GROUP

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORTCTL_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.GOKTABS	Rely On
GORTCTL_ROW_BY_MULTI_C	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Rely On
GORTCTL_ROW_BY_MULTI_C	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Use (select)Rely On
P_FIN_AIDY_MESSAGES	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_GET_CONTROLS	Oracle Package Procedure	S10B80.BANINST1.GOKFUNC	Rely On
P_VR_ADD_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_ADM_APPT_OPER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Use (select)Rely On
P_VR_ADM_MATERIALS_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_ORIENTATION_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_REQUEST_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ALL_REQ_SPEAK_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_ASSESS_FEES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_AUTODROP_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_AW_MULTI_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_AW_SINGLE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_BIL_INFO_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BIL_OPTIONS_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BUILD_ACCT_REVIEW_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BUILD_CC_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BUILD_MISSING_REQ	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_BUILD_PAYMENT_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BYPASS_TERM_CHECKS	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CHANGE_PIN_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHECK_CLAS_AVAIL	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CHECK_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_CHECK_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHECK_OPEN_SECTIONS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CHECK_OPEN_SECTIONS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CONFIRM_NEEDED_CHECK	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_NEEDED_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_REG	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_REG_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONTINUE_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CREDIT_HOURS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CRN_EXCEPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CRN_LIST	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CRN_LIST_MULTI_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CRN_LIST_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_DAY_TIME_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_DROP_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_DROP_CLASS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_END_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_END_INFC_TABLE	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_FIN_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_MATERIALS_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_PROGRAM_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_REQUEST_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_GEN_GRDE_INFO	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GET_AIDY_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_APPL_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_BILLING_DEADLN_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_GET_DROP_CODE	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_GET_FIN_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_GET_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRLAP	Rely On
P_VR_GET_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_OFFER_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_PROGRESS_DATA	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GET_TERM_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GIVE_DECISION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_GRADE_MODE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_GRDE_INFO_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GRDE_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GRDE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_HOLD_OPER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_HOLD_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_INIT_INFC_TABLE	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_LIKE_TO_REG_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_LIST_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_LIST_CLASSES	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_LIST_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_LIST_MORE_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_MENU_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MIF_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MORE_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_MORE_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_MULTI_TERMS	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_NOAPP_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_NO_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_NO_HOLD_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_PMPT_ST_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_ADM_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_BAD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_EXPDATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_CC_NUMBER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_DETAIL_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_DIFF_AMOUNT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXPIR_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXP_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_MISSING_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MORE_REQ	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MULTI_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_MULT_TERMS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_PROCESS_NEW_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_OFFER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_PROCESS_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_PROCESS_REVIEW_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_SINGLE_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_TOTAL_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCES_NONSTU_DET_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROC_ST_ADM_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROMPT_CC_NUMBER	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_DIFF_AMT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_EXP_DATE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_REBUILD_CURRENT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_REG_APPL_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_APPL_MENU_OPT_CONT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_REG_CLASS_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_DATA_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_REG_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_TERM_DATES	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_REG_TERM_ELIGIBLE	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_RESULT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_REVIEW_CHRGS_AND_PYMNTS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_INSTL_PMNT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_MORE_CHPY	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_MORE_INSTL	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_BALANCE	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REV_NONSTU_CHRG_AND_PMNT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_SCHED_DAY_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_SINGLE_TERM	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_SPEAK_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_START_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_TERM_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_VALIDATE_ALT_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_BIRTH_DATE	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_ID	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VERIFY_DROP	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_VERIFY_START_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_WAITLIST_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_WITHDRAW_FROM_TERM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
F_CHECK_MGMT_CONTROL	Oracle Package Function	S10B80.BANINST1.SFKRCTL	Rely On
F_GET_CTRL_VALUE	Oracle Package Function	S10B80.BANINST1.GOKFUNC	Rely On
F_GET_CTRL_VALUE_2	Oracle Package Function	S10B80.BANINST1.GOKFUNC	Rely On
F_GET_CTRL_VALUE_3	Oracle Package Function	S10B80.BANINST1.GOKFUNC	Rely On
F_TRIES_EXCEED_MAX	Oracle Package Function	S10B80.BANINST1.GOKFUNC	Rely On
F_VR_GET_SSRRSTS_REC	Oracle Package Function	S10B80.BANINST1.SFKOLRL	Rely On
GORTCTL	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
GORTCTL_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORTCTL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:17:000	04/02/2008 21:17:53:000

Source Code Comments

Third-Party Electronic Controls Table.

Columns Comments for GORTCTL_GROUP (# 1)

Source Code Comments

Group to which record belongs, e.g. if the record contains the start and stop times for Registration, the Group would be REGISTRATION.

Columns Comments for GORTCTL_FUNCTION (# 2)

Source Code Comments

Label associated with the function, e.g. MAIN_MENU, REG_MENU, FIN_MENU.

Columns Comments for GORTCTL_DESC (# 3)

Source Code Comments

Description of the function named in GORTCTL_FUNCTION e.g. Main Menu, Registration Available, Financial Aid Available.

Columns Comments for GORTCTL_TERM_YEAR (# 4)

Source Code Comments

Term Code or Year for which the record is effective. Term codes are validated against STVTERM.

Columns Comments for GORTCTL_TCTL_NUM (# 5)

Source Code Comments

Control number. Uses vary depending on the process and vendor. For Voice Response, it equates to the menu option.

Columns Comments for GORTCTL_VALUE (# 6)

Source Code Comments

Value associated with the corresponding function. Values currently used by Voice Response are Y, N, B, G where Y equals yes and N equals no.

Columns Comments for GORTCTL_ACTIVE_IND (# 7)

Source Code Comments

Flag indicating whether the function is currently available. Valid values are Y and N

Columns Comments for GORTCTL_SYS_REQ_IND (# 8)

Source Code Comments

System Required Indicator. Indicates whether the record is required by the SCT system.

Columns Comments for GORTCTL_ACTIVITY_DATE (# 9)

Source Code Comments

Date on which the record was last updated or created.

Columns Comments for GORTCTL_USER_ID (# 10)

Source Code Comments

User ID of the person that last updates this record.

Columns Comments for GORTCTL_TCTL_SEQNO (# 11)

Source Code Comments

Record Sequence Number. Contains a series of sequential numbers if more than one record exists for a function.

Columns Comments for GORTCTL_BEGIN_DATE (# 12)

Source Code Comments

Initial Date which the record becomes effective.

Columns Comments for GORTCTL_END_DATE (# 13)

Source Code Comments

Last date for which the record is effective.

Columns Comments for GORTCTL_BEGIN_TIME (# 14)

Source Code Comments

Time at which the record becomes effective. Format is HHMM.

Columns Comments for GORTCTL_END_TIME (# 15)

Source Code Comments

Time after which the record ceases to be effective. Format is HHMM.

Columns Comments for GORTCTL_DAYS_AVAIL (# 16)

Source Code Comments

Frequency or days on which the record can be used, e.g. Everyday, Mondays, Weekends, Weekdays.

Columns Comments for GORTCTL_YEAR (# 17)

Source Code Comments

Year. For Voice Response, it contains the year to be spoken, e.g. Financial Aid inquiry is available from Fall GORTCTL_YEAR through Spring GORTCTL_YEAR_2.

Columns Comments for GORTCTL_YEAR_2 (# 18)

Source Code Comments

Second Year.

Columns Comments for GORTCTL_VALUE_2 (# 19)

Source Code Comments

Miscellaneous values for third-party applications, e.g for Voice Resonse it contains message numbers.

Columns Comments for GORTCTL_VALUE_3 (# 20)

Source Code Comments

Miscellaneous values for third-party applications, e.g for Voice Resonse it contains message numbers.

Columns Comments for GORTCTL_VALUE_4 (# 21)

Source Code Comments

Miscellaneous values for third-party applications, e.g for Voice Resonse it contains message numbers.

Columns Comments for GORTCTL_TERM_YEAR_2 (# 22)

Source Code Comments

Aidy Year or Year for which the record is effective. Aidy Year codes are validated against RCRAIDY.

Columns Comments for GORTCTL_DATE (# 23)

Source Code Comments

Additional date relevant to the record.

Columns Comments for GORTCTL_SYSI_CODE (# 24)

Source Code Comments

System Indicator Code. Identifies the system to which the value contained in GORTCTL_TERM_YEAR is associated for validation purposes.

Columns Comments for GORTCTL_SYSI_CODE_2 (# 25)

Source Code Comments

System Indicator Code. Identifies the system to which the value contained in GORTCTL_TERM_YEAR_2 is associated for validation purposes.

Columns Comments for GORTCTL_RECORD_TYPE (# 26)

Source Code Comments

Record Type. Indicates the functional purpose of the record.

Table GTVDIRO

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVDIRO_CODE	VARCHAR2(8)	No	*
GTVDIRO_DESC	VARCHAR2(30)	No
GTVDIRO_SYSTEM_REQ_IND	VARCHAR2(1)	No
GTVDIRO_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVDIRO	Unique	GTVDIRO_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBDIRO	SQL Table	S10B80.GENERAL	Refer (no action)
GTVDIROC	Oracle Package Cursor	S10B80.BANINST1.BWAKSRCH	Use (select)
GTVDIROC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)
GTVDIRO_REC	Oracle Package Variable	S10B80.BANINST1.BWAKSRCH	Rely On
GTVDIRO_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
GTVDIROC	Oracle Package Cursor	S10B80.BANINST1.GTKDIRO	Use (select)Rely On
GTVDIRO_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVDIRO	Rely On
GTVDIRO_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVDIRO	Use (select)Rely On
P_DISPLAYEMPINFO	Oracle Package Procedure	S10B80.BANINST1.BWPKEDIR	Rely On
P_GETDATALABELS	Oracle Package Procedure	S10B80.BANINST1.BWPKEDIR	Use (select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVDIRO	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVDIRO	Rely On
GTVDIRO	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_GTVDIRO	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVDIRO

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:08:000	04/02/2008 21:17:53:000

Source Code Comments

Directory Options Validation Table

Columns Comments for GTVDIRO_CODE (# 1)

Source Code Comments

DIRECTORY CODE: Code for Directory Item.

Columns Comments for GTVDIRO_DESC (# 2)

Source Code Comments

DIRECTORY DESCRIPTION: Description for Directory Item.

Columns Comments for GTVDIRO_SYSTEM_REQ_IND (# 3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: System Required Indicator.

Columns Comments for GTVDIRO_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Table GTVEMAL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVEMAL_CODE	VARCHAR2(4)	No	*
GTVEMAL_DESC	VARCHAR2(60)	Yes
GTVEMAL_ACTIVITY_DATE	DATE	No
GTVEMAL_DISP_WEB_IND	VARCHAR2(1)	No
GTVEMAL_URL_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVEMAL	Unique	GTVEMAL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVEMAL	Oracle Synonym	S10B80.FAISMGR	Rely On
APBWIDN	SQL Table	S10B80.ALUMNI	Refer (no action)
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)
GOREMAL	SQL Table	S10B80.GENERAL	Refer (no action)
ROTEMAL	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWAPP	SQL Table	S10B80.SATURN	Refer (no action)
SMBWCRL	SQL Table	S10B80.SATURN	Refer (no action)
SRBWPRO	SQL Table	S10B80.SATURN	Refer (no action)
SRTEMAL	SQL Table	S10B80.SATURN	Refer (no action)
EMAIL_RECORD	Oracle Package Type	S10B80.BANINST1.GOKSEVN	Rely On
EMAL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKADVS	Rely On
GOREMAL_LINK_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
GETGTVEMALC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
GOREMALEMALEADDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALERIDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKADVS	Use (select)
GTVEMALC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)
GTVEMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.BWGKOGAD	Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.BWGKOGAD	Use (select)Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWLKOSAD	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
GV_EMAIL_CODE1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_CODE2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_CODE3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
F_CHECK_EMAL_CODE	Oracle Package Function	S10B80.BANINST1.SAKL045	Use (select)
GTVEMALC	Oracle Package Cursor	S10B80.BANINST1.GTKEMAL	Use (select)Rely On
GTVEMALLISTC	Oracle Package Cursor	S10B80.BANINST1.GOKLIBS	Use (select)Rely On
GTVEMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
GTVEMALWEBC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
GTVEMALWEBLISTC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEMAL	Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEMAL	Use (select)Rely On
P_DISPEMAILUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOGAD	Rely On
P_PA_GTVEMAL_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISPLAY_OPTIONS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EMAIL	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISP_HIER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_RULES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EFDTEST	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT	Use (Insert)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVEMAL	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVEMAL	Rely On
F_GTVEMAL_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
F_SORXREF_CHK	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
F_SORXREF_VAL	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
GTVEMAL	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_GTVEMAL	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVEMAL

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:10:000	04/02/2008 21:17:51:000

Source Code Comments

The GTVEMAL table contains the valid e-mail type codes.

Columns Comments for GTVEMAL_CODE (# 1)

Source Code Comments

A code identifying the type of e-mail address.

Columns Comments for GTVEMAL_DESC (# 2)

Source Code Comments

The description of the e-mail address.

Columns Comments for GTVEMAL_ACTIVITY_DATE (# 3)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GTVEMAL_DISP_WEB_IND (# 4)

Source Code Comments

Display on Web Indicator, Y indicates this type of email should display

Columns Comments for GTVEMAL_URL_IND (# 5)

Source Code Comments

URL Indicator, Y indicates that this email record is actually a URL.

Table GTVSDAX

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_INTERNAL_CODE	VARCHAR2(10)	No	*
GTVSDAX_REPORTING_DATE	DATE	Yes
GTVSDAX_TRANSLATION_CODE	VARCHAR2(15)	Yes
GTVSDAX_INTERNAL_CODE_SEQNO	NUMBER(2,0)	Yes
GTVSDAX_INTERNAL_CODE_GROUP	VARCHAR2(20)	No
GTVSDAX_DESC	VARCHAR2(30)	No
GTVSDAX_SYSREQ_IND	VARCHAR2(1)	Yes
GTVSDAX_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVSDAX_EXTERNAL_CODE	SARAPPD_APDC_CODE	SARAPPD
GTVSDAX_EXTERNAL_CODE	SORBCHR_BCHR_CODE	SORBCHR
GTVSDAX_EXTERNAL_CODE	SORTEST_TESC_CODE	SORTEST
GTVSDAX_EXTERNAL_CODE	SSBSECT_SSTS_CODE	SSBSECT
GTVSDAX_INTERNAL_CODE	SORPCOL_SBGI_CODE	SORPCOL
GTVSDAX_INTERNAL_CODE	SPRMEDI_MEDI_CODE	SPRMEDI
GTVSDAX_EXTERNAL_CODE	PERJTOT_EARN_CODE	PERJTOT
GTVSDAX_EXTERNAL_CODE	TBBDEPC_DTYP_CODE	TBBDEPC
GTVSDAX_EXTERNAL_CODE	TBRACCD_DETAIL_CODE	TBRACCD
GTVSDAX_EXTERNAL_CODE	SRBRECR_LEVL_CODE	SRBRECR
GTVSDAX_EXTERNAL_CODE	SARADAP_LEVL_CODE	SARADAP
GTVSDAX_EXTERNAL_CODE	SPRTELE_TELE_CODE	SPRTELE
GTVSDAX_EXTERNAL_CODE	STVATYP_CODE	STVATYP
GTVSDAX_EXTERNAL_CODE	SFRRSTS_RSTS_CODE	SFRRSTS

Index

Index Name	Index Type	Column Name
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_GROUP
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_EXTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PARAPST	SQL Table	S10B80.PAYROLL	Join
SPRADDR	SQL Table	S10B80.SATURN	Join
ST_SPRADDR_INSERT_ROW	SQL Trigger	S10B80.SATURN	Use (select)
ST_SPRADDR_UPDATE_ROW	SQL Trigger	S10B80.SATURN	Use (select)
GTVSDAX_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVSDAX_ADS	SQL View	S10B80.BANINST1	Use (select)
PEVPRF1	SQL View	S10B80.BANINST1	Use (select)
SSVENR1	SQL View	S10B80.BANINST1	Use (select)
FN_SORFOLK_VALUE	SQL Function	S10B80.BANINST1	Use (select)
F_ACTIVE_COURSE_IND	SQL Function	S10B80.BANINST1	Use (select)
F_ACTIVE_SECTION_IND	SQL Function	S10B80.BANINST1	Use (select)
F_ACTIVITY_CODE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_ADMS_APPLICATION_STATUS	SQL Function	S10B80.BANINST1	Use (select)
F_ALUMNUS_IND	SQL Function	S10B80.BANINST1	Use (select)
F_AMOUNT_DUE	SQL Function	S10B80.BANINST1	Use (select)
F_APPLICANT_SOURCE	SQL Function	S10B80.BANINST1	Use (select)
F_APPL_RESPONSE_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_AR_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
F_BALANCE_OTHER_TERMS	SQL Function	S10B80.BANINST1	Use (select)
F_BARGAINING_UNIT_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_CALC_AGED_DAYS	SQL Function	S10B80.BANINST1	Use (select)
F_CALC_AGING_SLOT	SQL Function	S10B80.BANINST1	Use (select)
F_CAMP_EXCLUSION_CODE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_CHECKSDAXRULE	SQL Function	S10B80.BANINST1	Use (select)
F_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
F_CHECK_FOR_MORE_PAY	SQL Function	S10B80.BANINST1	Use (select)
F_CHECK_FOR_MORE_SUBJ_INDEXES	SQL Function	S10B80.BANINST1	Use (select)
F_CHECK_FOR_MORE_TASKS	SQL Function	S10B80.BANINST1	Use (select)
F_CHECK_FOR_PARTICIPANTS	SQL Function	S10B80.BANINST1	Use (select)
F_CHECK_FOR_SUBJ_CMNTS	SQL Function	S10B80.BANINST1	Use (select)
F_CLASS_TRANSLATION_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_COMPLETED_TASK_FLAG	SQL Function	S10B80.BANINST1	Use (select)
F_CONCAT_FISC_GROSS	SQL Function	S10B80.BANINST1	Use (select)
F_CONCAT_SGRCHRT	SQL Function	S10B80.BANINST1	Use (select)
F_CONCAT_SGRSPRT	SQL Function	S10B80.BANINST1	Use (select)
F_CONCAT_SIRNIST	SQL Function	S10B80.BANINST1	Use (select)
F_CONCAT_SPRMEDI	SQL Function	S10B80.BANINST1	Use (select)
F_COUNT_TASKS	SQL Function	S10B80.BANINST1	Use (select)
F_CROSS_REFERENCE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_DESG_EXCLUSION_CODE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_DISABILITY_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_DISABLED_IND	SQL Function	S10B80.BANINST1	Use (select)
F_EARNING_FLAG	SQL Function	S10B80.BANINST1	Use (select)
F_EXCLUSION_CODE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_EXTERNAL_SOURCE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_FUND_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_GEOGRAPHIC_REGION	SQL Function	S10B80.BANINST1	Use (select)
F_GET_ADDRESS_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_GET_ADDRESS_ROWID	SQL Function	S10B80.BANINST1	Rely On
F_GET_ADDRESS_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_ADDRESS_TELEPHONE_ROWID	SQL Function	S10B80.BANINST1	Rely On
F_GET_ADDRESS_TELEPHONE_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_EMAIL_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_GERFEXP_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_GERFFEE_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_GERFREV_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_GERPART_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_RBRACMP_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_RRRAREQ_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SARCHKL_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SCRATTR_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SCRSCHD_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SDAX	SQL Function	S10B80.BANINST1	Rely On
F_GET_SDAX	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SHRATTR_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SIRATTR_DATA	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SORCONT_CONTACT_DATE	SQL Function	S10B80.BANINST1	Rely On
F_GET_SORCONT_CONTACT_DATE	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SORFOLK_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SORTEST_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SPRHOLD_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SPRTELE_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SUBJECT_INDEX	SQL Function	S10B80.BANINST1	Use (select)
F_GET_TASK_TYPE	SQL Function	S10B80.BANINST1	Use (select)
F_GIFT_SOCIETY_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_GURMAIL_LETR_CODE	SQL Function	S10B80.BANINST1	Use (select)
F_GURMAIL_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_HSCH_TYPE_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_INCLUDE_ECLS	SQL Function	S10B80.BANINST1	Use (select)
F_JOB_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_LEAVE_CODE	SQL Function	S10B80.BANINST1	Rely On
F_LEAVE_CODE	SQL Function	S10B80.BANINST1	Use (select)
F_LEAVE_ROWID	SQL Function	S10B80.BANINST1	Rely On
F_LEAVE_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_MAIL_CODE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_MORE_ATTRIBUTES	SQL Function	S10B80.BANINST1	Use (select)
F_OUTSIDE_INTEREST	SQL Function	S10B80.BANINST1	Use (select)
F_PAID_ADMISSIONS_DEPOSIT	SQL Function	S10B80.BANINST1	Use (select)
F_PAYROLL_EMPLOYEE_IC	SQL Function	S10B80.BANINST1	Use (select)
F_PROFILE_DATE	SQL Function	S10B80.BANINST1	Use (select)
F_PROJECT_CODE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_RATING_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_RECRUIT_SOURCE	SQL Function	S10B80.BANINST1	Use (select)
F_SDAX_APPL_STAT	SQL Function	S10B80.BANINST1	Use (select)
F_SECONDARY_CONTACT_TYPE	SQL Function	S10B80.BANINST1	Use (select)
F_SKIL_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_SORCONT_CTYP_CODE	SQL Function	S10B80.BANINST1	Use (select)
F_SORCONT_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_SPECIAL_PURPOSE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_STAFF_ASSIGNMENT_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
F_STU_GETPROGRAM	SQL Function	S10B80.BANINST1	Use (select)
F_STU_GETWEBREGSRSTS	SQL Function	S10B80.BANINST1	Use (select)
F_TERM_CHARGES	SQL Function	S10B80.BANINST1	Use (select)
F_TERM_PAYMENTS	SQL Function	S10B80.BANINST1	Use (select)
F_TEST_SCORE_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_HOUR_EARNING_CODE	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_HOUR_EARNING_OTHER	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_HOUR_EARNING_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_VARIABLE_PURPOSE_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_WFE_TEST_CODE	SQL Function	S10B80.BANINST1	Use (select)
F_YEAR	SQL Function	S10B80.BANINST1	Use (select)
GTVSDAX_REC1	Oracle Package Type	S10B80.BANINST1.SFKCURS	Rely On
MERCH_ID_REC_TYPE	Oracle Package Type	S10B80.BANINST1.GOKTABS	Rely On
SECTION_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSSKCOM	Rely On
C_GETGTVSDAX	Oracle Package Cursor	S10B80.BANINST1.TOKWEXT	Use (select)
GTVSDAX_CONTACTS_TAB	Oracle Package Type	S10B80.BANINST1.SOKLIBS	Rely On
GTVSDAX_CONTACTS_TAB	Oracle Package Type	S10B80.BANINST1.SOKLIBS_OJ	Rely On
GTVSDAX_TAB	Oracle Package Type	S10B80.BANINST1.SHKSELS	Rely On
GT_GTVSDAX	Oracle Package Type	S10B80.BANINST1.SCKSELS	Rely On
GV_GTVSDAX	Oracle Package Type	S10B80.BANINST1.SOKSELS	Rely On
GV_GTVSDAX_ADDRESS_TYPE	Oracle Package Type	S10B80.BANINST1.GOKSELS	Rely On
GV_GTVSDAX_ADDRESS_TYPE	Oracle Package Type	S10B80.BANINST1.P_ADDR_TELE	Rely On
GV_ADDRESS_INTERNAL_CODE	Oracle Package Variable	S10B80.BANINST1.P_ADDR_TELE	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKCPMT	Rely On
AFRDESG_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKNGFT	Rely On
AFRDESGVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
AFRDESGVIEWC	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)
GETGTVSDAXEXTCODEC	Oracle Package Cursor	S10B80.BANINST1.BWDKSRCH	Use (select)
GET_CODES	Oracle Package Cursor	S10B80.BANINST1.SIKLIBS	Rely On
GET_CODES	Oracle Package Cursor	S10B80.BANINST1.SIKLIBS	Use (select)
GET_GTVSDAX	Oracle Package Cursor	S10B80.BANINST1.BWCKREGS	Use (select)
GET_GTVSDAX_EXTCODE_C	Oracle Package Cursor	S10B80.BANINST1.ICGOKCOM	Rely On
GET_GTVSDAX_EXTCODE_C	Oracle Package Cursor	S10B80.BANINST1.ICGOKCOM	Use (select)
GET_GTVSDAX_TRANSCODE_C	Oracle Package Cursor	S10B80.BANINST1.ICGOKCOM	Rely On
GET_GTVSDAX_TRANSCODE_C	Oracle Package Cursor	S10B80.BANINST1.ICGOKCOM	Use (select)
GTVSDAX_EXTC	Oracle Package Cursor	S10B80.BANINST1.BWSKOACC	Rely On
GTVSDAX_EXTC	Oracle Package Cursor	S10B80.BANINST1.BWSKOACC	Use (select)
SMRRQCM_ALL_PROCESSED_REQNO_C	Oracle Package Cursor	S10B80.BANINST1.BWCKSMMT	Use (select)
P_BUILDSOTWADA	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Use (select)
P_CAPPPREQCHK	Oracle Package Procedure	S10B80.BANINST1.SFKPREQ	Use (select)
P_GETGROSSINCOME	Oracle Package Procedure	S10B80.BANINST1.PEKWEMP	Use (select)
P_GETMOREINFO	Oracle Package Procedure	S10B80.BANINST1.PAKRECR	Use (select)
P_GETSOMEINDICATORS	Oracle Package Procedure	S10B80.BANINST1.PAKRECR	Use (select)
P_GETTESTSCORE	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Use (select)
P_GET_SUB_CODE	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_GET_SUB_CODE	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_INITIALIZE	Oracle Package Procedure	S10B80.BANINST1.ICGOKROL	Use (select)
P_INSERT_AGTOGIV_DATA	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
UT_GP_CARDHOLDERPROCESSAPI	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,update)
UT_GP_INTERNATIONAL_STUDENT_P	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert,update,delete,select)
UT_GP_PERSON_IDENTITYP_API	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (delete,select)
UT_SP_HOUSING_ELIGIBILITYP_API	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_ELIGIBILITY	Use (Insert,update)
UT_SP_HOUSING_PROFILEP_API	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert)
UT_TP_STUDENT_DEPOSITP_API	Oracle Package Procedure	S10B80.BANINST1.UT_TP_STUDENT_DEPOSIT	Use (update)
UT_TP_STUDENT_RECEIVABLEP_API	Oracle Package Procedure	S10B80.BANINST1.UT_TP_STUDENT_RECEIVABLE	Use (update)
AR_NULL_ERROR	Oracle Package Variable	S10B80.BANINST1.TOKWEXT	Rely On
AUTH_SETL_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
AUTH_SETL_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
AUTH_SETL_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
COMMIT_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMIT_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMIT_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
GL_NULL_VALUE	Oracle Package Variable	S10B80.BANINST1.TOKWEXT	Rely On
GROUP_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
GROUP_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
GROUP_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKWCCP	Rely On
GROUP_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
GTVSDAX_GROUP	Oracle Package Variable	S10B80.BANINST1.BWCKGENS	Rely On
GTVSDAX_GROUP	Oracle Package Variable	S10B80.BANINST1.BWCKSAMS	Rely On
GTVSDAX_REC	Oracle Package Variable	S10B80.BANINST1.SB_PESCXML_TRANDATA_EXP	Rely On
GV_ADDRESS_INTERNAL_CODE	Oracle Package Variable	S10B80.BANINST1.GOKSELS	Rely On
GV_GTVSDAX_CAMP_ADDR	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_GTVSDAX_CAMP_PHONE	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_GTVSDAX_CM	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_GTVSDAX_EMAIL	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_GTVSDAX_FAX_PHONE	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_GTVSDAX_MOBILE_PHONE	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_GTVSDAX_PRIM_ADDR	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_GTVSDAX_ROW	Oracle Package Variable	S10B80.BANINST1.SIKLIBS	Rely On
GV_INTADDR_CODE	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_RESADDR_DATASOURCE	Oracle Package Variable	S10B80.BANINST1.GP_CARDHOLDER	Rely On
GV_RESPHON_DATASOURCE	Oracle Package Variable	S10B80.BANINST1.GP_CARDHOLDER	Rely On
GV_SORCONT_INTERNAL_CODE	Oracle Package Variable	S10B80.BANINST1.SOKLIBS	Rely On
GV_SORCONT_INTERNAL_CODE	Oracle Package Variable	S10B80.BANINST1.SOKLIBS_OJ	Rely On
GV_SORTEST_INTERNAL_CODE	Oracle Package Variable	S10B80.BANINST1.SOKLIBS	Rely On
GV_SORTEST_INTERNAL_CODE	Oracle Package Variable	S10B80.BANINST1.SOKLIBS_OJ	Rely On
GV_SVSFRNADDR_CODE	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_SVSUSADDR_CODE	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
INTERNAL_CODE	Oracle Package Variable	S10B80.BANINST1.BWCKGENS	Rely On
INTERNAL_CODE	Oracle Package Variable	S10B80.BANINST1.BWCKSAMS	Rely On
INTERNAL_CODE_FRN	Oracle Package Variable	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
INTERNAL_CODE_GROUP	Oracle Package Variable	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
INTERNAL_CODE_US	Oracle Package Variable	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
PMTSERVER_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
PMTSERVER_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
PMTSERVER_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
PMTSRCE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKWCCP	Rely On
PMTSRCE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
PMT_SRCE	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
SDAX_CODE	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
USERSOURCE	Oracle Package Variable	S10B80.BANINST1.GP_PERSON_IDENTITY	Rely On
F_CHECKDAXRULE	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Use (select)
F_GETGTVSDAXEXTCODE	Oracle Package Function	S10B80.BANINST1.GOKSEVN	Rely On
F_GETGTVSDAXEXTCODE	Oracle Package Function	S10B80.BANINST1.GOKSEVN	Use (select)
F_GET_ADDR_TYPE	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_GET_ADDR_TYPE	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Use (select)
F_GET_HASHFLAG	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
F_GET_HASHFLAG	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
F_GET_HASHFLAG	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
F_GET_HASHFLAG	Oracle Package Function	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Use (select)
F_GET_MEAL_PLANS	Oracle Package Function	S10B80.BANINST1.GP_CARDHOLDER	Rely On
F_GET_PHONE_ASSIGNMENT	Oracle Package Function	S10B80.BANINST1.GP_CARDHOLDER	Rely On
F_GET_ROOM_ASSIGNMENT	Oracle Package Function	S10B80.BANINST1.GP_CARDHOLDER	Rely On
F_GET_SOURCE	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_GET_SOURCE	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Use (select)
F_LOAD_EXTRACURR_TAB	Oracle Package Function	S10B80.BANINST1.SP_HOUSING_PROFILE	Use (select)
F_LOAD_SPORT_TAB	Oracle Package Function	S10B80.BANINST1.SP_HOUSING_PROFILE	Use (select)
C_RETRIEVE_GTVSDAX_ROW	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Rely On
C_RETRIEVE_GTVSDAX_ROW	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Use (select)Rely On
GET_GTVSDAXC	Oracle Package Cursor	S10B80.BANINST1.SFKCURS	Rely On
GET_GTVSDAXC	Oracle Package Cursor	S10B80.BANINST1.SFKCURS	Use (select)
GTVSDAX_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSDAX	Rely On
GTVSDAX_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSDAX	Use (select)Rely On
P_ACKNOWLEDGEMENT_PAGE	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Rely On
P_ALTPIN	Oracle Package Procedure	S10B80.BANINST1.BWSKFREG	Rely On
P_ALTPIN1	Oracle Package Procedure	S10B80.BANINST1.BWSKFREG	Rely On
P_BUILDPATRECR	Oracle Package Procedure	S10B80.BANINST1.PAKRECR	Use (select)
P_BUILDPETDEGR	Oracle Package Procedure	S10B80.BANINST1.PEKDEGR	Use (select)
P_BUILDPETWEMP	Oracle Package Procedure	S10B80.BANINST1.PEKWEMP	Use (select)
P_BUILD_ACTION_PULLDOWN	Oracle Package Procedure	S10B80.BANINST1.BWCKCOMS	Rely On
P_BUILD_WAIT_ACTION_PULLDOWN	Oracle Package Procedure	S10B80.BANINST1.BWCKCOMS	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CC_PAYMENT_STATUS	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CREDIT_CARD_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_DISPADVISEES	Oracle Package Procedure	S10B80.BANINST1.BWLKADVR	Rely On
P_DISP_COURSE_UNSEC	Oracle Package Procedure	S10B80.BANINST1.BWCKSCHD	Use (select)
P_FACACTASSIGN	Oracle Package Procedure	S10B80.BANINST1.BWLKASGN	Rely On
P_FACASSIGNHIST	Oracle Package Procedure	S10B80.BANINST1.BWLKASGN	Rely On
P_FACCLALIST	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FACCLALISTSUM	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FACCLAWAITDTL	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FACDISPSHRMRKS	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Rely On
P_FACDISPSHRMRKS	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Use (select)
P_FACDISPSHRSMRK	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Rely On
P_FACDISPSHRSMRK	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Use (select)
P_FACFINGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKGRDE	Rely On
P_FACFINGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKGRDE	Use (select)
P_FACFINGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKFFGD	Rely On
P_FACFINGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKFFGD	Use (select)
P_FACMIDGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKFMGD	Rely On
P_FACMIDGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKFMGD	Use (select)
P_FACSCHED	Oracle Package Procedure	S10B80.BANINST1.BWLKIFAC	Rely On
P_FACSCHED	Oracle Package Procedure	S10B80.BANINST1.BWLKIFAC	Use (select)
P_FACSCOREPOST	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Rely On
P_FACSCOREPOST	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Use (select)
P_FACSCOREPOST2	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Rely On
P_FACSCOREPOST2	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Use (select)
P_FACWAITLIST	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FACWAITLISTSUM	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FEEASSES	Oracle Package Procedure	S10B80.BANINST1.BWSKFFEE	Rely On
P_GET_GTVSDAX	Oracle Package Procedure	S10B80.BANINST1.SFKCURS	Rely On
P_GET_GTVSDAX	Oracle Package Procedure	S10B80.BANINST1.SFKCURS	Use (select)Rely On
P_GET_MERCHANT_IDS	Oracle Package Procedure	S10B80.BANINST1.GOKSELS	Rely On
P_GET_SUB_CODE	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_GET_SUB_CODE	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_GET_SUB_CODE_1	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_GIFT_BY_FISCAL_YR	Oracle Package Procedure	S10B80.BANINST1.AGKGRPT	Use (select)
P_INSERT_GORCCAU	Oracle Package Procedure	S10B80.BANINST1.GOKFUNC	Rely On
P_INSERT_TBRACCD	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_INSERT_TBRACCD_CC	Oracle Package Procedure	S10B80.BANINST1.SFKMODS	Rely On
P_MAKE_A_DONATION	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_OPEN_STUDENT_LIST_C	Oracle Package Procedure	S10B80.BANINST1.BWLKOIDS	Rely On
P_POPULATE_PIDM_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.GOKPAPI	Rely On
P_PROC_TERM_TYPE	Oracle Package Procedure	S10B80.BANINST1.BWSKRQST	Rely On
P_REGSSTATUSDISP	Oracle Package Procedure	S10B80.BANINST1.BWSKRSTA	Rely On
P_REQUIRE_PII_PROMPT	Oracle Package Procedure	S10B80.BANINST1.GOKFGAC	Rely On
P_SEARCHCHK	Oracle Package Procedure	S10B80.BANINST1.BWCKGENS	Rely On
P_STOREADDRUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_STUDENTTERMDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKXMIS	Rely On
P_VERIFY_CREDIT_CARD_INFO	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Rely On
P_VERIFY_CREDIT_CARD_INFO	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Use (select)
P_VIEWACCT	Oracle Package Procedure	S10B80.BANINST1.BWSKOACC	Rely On
P_VIEWACCTTERM	Oracle Package Procedure	S10B80.BANINST1.BWSKOACC	Rely On
P_VIEWACCTTOTAL	Oracle Package Procedure	S10B80.BANINST1.BWSKOACC	Rely On
P_VIEWINSTALLMENTS	Oracle Package Procedure	S10B80.BANINST1.BWSKOACC	Rely On
P_VR_ADD_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_DROP_CLASS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_REG_APPL_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_APPL_MENU_OPT_CONT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_INSTITUTION_ROLE	Use (delete)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert,update)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TP_STUDENT_DEPOSIT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,delete)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_ELIGIBILITY	Use (Insert,update,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TP_STUDENT_RECEIVABLE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_ENTITY_ADDRESS	Use (Insert,update,select)
F_ADDRESS_TELEPHONE_VALUE	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_ADDRESS_TELEPHONE_VALUE	Oracle Package Function	S10B80.BANINST1.GOKSELS	Use (select)
F_ADDRESS_VALUE	Oracle Package Function	S10B80.BANINST1.P_ADDR_TELE	Rely On
F_ADDRESS_VALUE	Oracle Package Function	S10B80.BANINST1.P_ADDR_TELE	Use (select)
F_ADD_ENTITY_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_AMOUNT_DUE_PER_ROW	Oracle Package Function	S10B80.BANINST1.TOKGWIZ	Use (select)
F_AR_CLEARED	Oracle Package Function	S10B80.BANINST1.SOKSELS	Rely On
F_AR_CLEARED	Oracle Package Function	S10B80.BANINST1.SOKSELS	Use (select)
F_AUTODROP_SETTING	Oracle Package Function	S10B80.BANINST1.SFKFUNC	Rely On
F_CHECK_HOLDS	Oracle Package Function	S10B80.BANINST1.BWCKCPMT	Rely On
F_CHECK_MGMT_CONTROL	Oracle Package Function	S10B80.BANINST1.SFKRCTL	Rely On
F_CLASS_EMAIL_STR	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVSDAX	Rely On
F_CREATE_PIN_OK	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Rely On
F_CREATE_PIN_OK	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
F_DO_ADMINDROP	Oracle Package Function	S10B80.BANINST1.SFKFUNC	Rely On
F_DROP_LAST	Oracle Package Function	S10B80.BANINST1.SFKDROP	Rely On
F_EXISTING_REQ	Oracle Package Function	S10B80.BANINST1.BWCKSMMT	Use (select)
F_FACCLALISTPAGESIZE	Oracle Package Function	S10B80.BANINST1.BWLKFCWL	Rely On
F_FACCLALISTPAGESIZE	Oracle Package Function	S10B80.BANINST1.BWLKFCWL	Use (select)
F_GETGTVSDAXEXTCODE	Oracle Package Function	S10B80.BANINST1.GOKEACC	Rely On
F_GETGTVSDAXEXTCODE	Oracle Package Function	S10B80.BANINST1.GOKEACC	Use (select)
F_GETGTVSDAXRULE	Oracle Package Function	S10B80.BANINST1.BWCKLIBS	Rely On
F_GETGTVSDAXRULE	Oracle Package Function	S10B80.BANINST1.BWCKLIBS	Use (select)Rely On
F_GET_ADDRESS_OOT	Oracle Package Function	S10B80.BANINST1.GOKPAPI	Rely On
F_GET_DASHBOARD_SUBJ	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Rely On
F_GET_DASHBOARD_TERM	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Rely On
F_GET_DASHBOARD_XML	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Rely On
F_GET_DEFAULT_SUBCODE	Oracle Package Function	S10B80.BANINST1.GOKFUNC	Rely On
F_GET_DEPOSIT_TAB	Oracle Package Function	S10B80.BANINST1.TOKPAPI	Rely On
F_GET_DEPOSIT_TAB	Oracle Package Function	S10B80.BANINST1.TOKPAPI	Use (select)
F_GET_DESC	Oracle Package Function	S10B80.BANINST1.BWRKVEPR	Use (select)
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVSDAX	Rely On
F_GET_ELIGIBLE_CARDHOLDER	Oracle Package Function	S10B80.BANINST1.GP_CARDHOLDER	Rely On
F_GET_ELIGIBLE_CARDHOLDERS	Oracle Package Function	S10B80.BANINST1.GP_CARDHOLDER	Rely On
F_GET_ELIGIBLE_CARDHOLDERS	Oracle Package Function	S10B80.BANINST1.GP_ASYNC_CARDHOLDER	Rely On
F_GET_FEE_TAB	Oracle Package Function	S10B80.BANINST1.TOKPAPI	Rely On
F_GET_FEE_TAB	Oracle Package Function	S10B80.BANINST1.TOKPAPI	Use (select)
F_GET_GTVSDAX_EXTCODE	Oracle Package Function	S10B80.BANINST1.ICGOKCOM	Rely On
F_GET_GTVSDAX_ROW	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_GET_GTVSDAX_TRANSCODE	Oracle Package Function	S10B80.BANINST1.ICGOKCOM	Rely On
F_GET_LOCATION_OOT	Oracle Package Function	S10B80.BANINST1.GOKPAPI	Rely On
F_GET_MTCH_CURRIC_HEIR	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Use (select)
F_GET_PIDM	Oracle Package Function	S10B80.BANINST1.GOKPAPI	Rely On
F_GET_TELEPHONE_OOT	Oracle Package Function	S10B80.BANINST1.GOKPAPI	Rely On
F_GET_TELEPHONE_OOT	Oracle Package Function	S10B80.BANINST1.GOKPAPI	Use (select)
F_GTVSDAX_WEBCURR_EXIST	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Use (select)
F_GURMAIL_VALUE	Oracle Package Function	S10B80.BANINST1.SOKSELS	Use (select)
F_REGSSTU	Oracle Package Function	S10B80.BANINST1.BWCKSAMS	Rely On
F_REG_ACCESS_STILL_GOOD	Oracle Package Function	S10B80.BANINST1.BWCKCOMS	Rely On
F_SARCHKL_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Use (select)
F_SARCHKL_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
F_SCRATTR_VALUE	Oracle Package Function	S10B80.BANINST1.SCKSELS	Use (select)
F_SCRSCHD_VALUE	Oracle Package Function	S10B80.BANINST1.SCKSELS	Use (select)
F_SDAX_APPL_STAT	Oracle Package Function	S10B80.BANINST1.PAKRECR	Use (select)
F_SHRATTR_VALUE	Oracle Package Function	S10B80.BANINST1.SHKSELS	Use (select)
F_SORCONT_ORDER	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Use (select)
F_SORCONT_ORDER	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
F_SORFOLK_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Use (select)
F_SORFOLK_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
F_SORTEST_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Use (select)
F_SORTEST_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
F_SORTEST_VALUE	Oracle Package Function	S10B80.BANINST1.PACKAGE_REPLACE_SORCONT	Use (select)
F_SPRHOLD_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Use (select)
F_SPRHOLD_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
F_STUDENT_ID_TYPE	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Rely On
GTVSDAX	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
GTVSDAX_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
PERJTOT	SQL Table	S10B80.PAYROLL	Join
SARADAP	SQL Table	S10B80.SATURN	Join
SARAPPD	SQL Table	S10B80.SATURN	Join
SFRRSTS	SQL Table	S10B80.SATURN	Join
SORBCHR	SQL Table	S10B80.SATURN	Join
SORPCOL	SQL Table	S10B80.SATURN	Join
SORTEST	SQL Table	S10B80.SATURN	Join
SPRMEDI	SQL Table	S10B80.SATURN	Join
SPRTELE	SQL Table	S10B80.SATURN	Join
SRBRECR	SQL Table	S10B80.SATURN	Join
SSBSECT	SQL Table	S10B80.SATURN	Join
STVATYP	SQL Table	S10B80.SATURN	Join
TBBDEPC	SQL Table	S10B80.TAISMGR	Join
TBRACCD	SQL Table	S10B80.TAISMGR	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVSDAX

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:14:000	04/02/2008 21:17:51:000

Source Code Comments

SDA crosswalk/conversion table

Columns Comments for GTVSDAX_EXTERNAL_CODE (# 1)

Source Code Comments

Banner/concept code for to be retrieved

Columns Comments for GTVSDAX_INTERNAL_CODE (# 2)

Source Code Comments

The pre-determined SDA retrieval code

Columns Comments for GTVSDAX_REPORTING_DATE (# 3)

Source Code Comments

The date column used for various reporting needs

Columns Comments for GTVSDAX_TRANSLATION_CODE (# 4)

Source Code Comments

The hard-coded translation of the user defined external code, eg. Freshman, PUB for Public School, etc

Columns Comments for GTVSDAX_INTERNAL_CODE_SEQNO (# 5)

Source Code Comments

The sequence number for internal codes requiring multiple values

Columns Comments for GTVSDAX_INTERNAL_CODE_GROUP (# 6)

Source Code Comments

The group typing for translated or crosswalked values to specifically identify which grouping each series of codes belongs too

Columns Comments for GTVSDAX_DESC (# 7)

Source Code Comments

The description of the SDA code/concept

Columns Comments for GTVSDAX_SYSREQ_IND (# 8)

Source Code Comments

A Y in this field indicates that this row is required for production processing

Columns Comments for GTVSDAX_ACTIVITY_DATE (# 9)

Source Code Comments

The last activity date for this row of data

Table GUBPPRF

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GUBPPRF_FORMAT	VARCHAR2(1)	No	*
GUBPPRF_VALUE	VARCHAR2(1)	No
GUBPPRF_SELF_NOTIFY_TYPE_IND	VARCHAR2(1)	No
GUBPPRF_ADMIN_NOTIFY_TYPE_IND	VARCHAR2(1)	No
GUBPPRF_PRE_EXPIRE_IND	VARCHAR2(1)	No
GUBPPRF_USER_ID	VARCHAR2(30)	No
GUBPPRF_ACTIVITY_DATE	DATE	No
GUBPPRF_APPLICATION	VARCHAR2(30)	Yes	*
GUBPPRF_LETR_CODE_LETTER	VARCHAR2(15)	Yes	*
GUBPPRF_LETR_CODE_EMAIL	VARCHAR2(15)	Yes	*
GUBPPRF_LENGTH_LAST_NAME	NUMBER(2,0)	Yes
GUBPPRF_MIN_LENGTH	NUMBER(2,0)	No
GUBPPRF_MAX_LENGTH	NUMBER(2,0)	No
GUBPPRF_NO_OF_QSTNS	NUMBER(2,0)	No
GUBPPRF_NUM_IND	VARCHAR2(1)	No
GUBPPRF_CHAR_IND	VARCHAR2(1)	No
GUBPPRF_REUSE_DAYS	NUMBER(3,0)	No
GUBPPRF_QSTN_MIN_LENGTH	NUMBER(2,0)	Yes
GUBPPRF_ANSR_MIN_LENGTH	NUMBER(2,0)	Yes
GUBPPRF_EDITQSTN_IND	VARCHAR2(1)	No
GUBPPRF_SELF_LETR_CODE_LETTER	VARCHAR2(15)	Yes
GUBPPRF_SELF_LETR_CODE_EMAIL	VARCHAR2(15)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUBPPRF_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL
GUBPPRF_LETR_CODE_LETTER	GTVLETR_CODE	GTVLETR
GUBPPRF_LETR_CODE_EMAIL	GTVLETR_CODE	GTVLETR
GUBPPRF_FORMAT	GORSDAV_PK_PARENTTAB	GORSDAV

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUBPPRF_ADD	SQL View	S10B80.BANINST1	Use (select)
GUBPPRF_ADS	SQL View	S10B80.BANINST1	Use (select)
GUBPPRF_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
C_GUBPPRF	Oracle Package Cursor	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_STRINGS	Use (select)
GETGUBPPRFC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Use (select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
UT_GB_THIRD_PARTY_ACCESSC_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_THIRD_PARTY_ACCESS	Use (update)
UT_GB_THIRD_PARTY_ACCESSU_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_THIRD_PARTY_ACCESS	Use (update)
GUBPPRF_REC	Oracle Package Variable	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_STRINGS	Rely On
GUBPPRF_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
GUBPPRFC	Oracle Package Cursor	S10B80.BANINST1.GUKLIBS	Use (select)Rely On
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_INSERT_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Rely On
P_INSERT_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Use (select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GOKMAIL	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
P_VALIDATEQUESTIONANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_VALIDATEQUESTIONANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_VALIDATE_PINRULES	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
F_GENERATE_EXTERNAL_USER	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
F_PINLENGTH	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Use (select)
F_PINLENGTH	Oracle Package Function	S10B80.BANINST1.GOKLIBS	Use (select)
F_PINLENGTH_VALIDATE	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Rely On
F_PINLENGTH_VALIDATE	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Use (select)
F_PINREUSED	Oracle Package Function	S10B80.BANINST1.GOKLIBS	Use (select)
F_RESET_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Rely On
F_RESET_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
F_VALIDATE_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Rely On
F_VALIDATE_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
TWBKLIBS	Oracle Package	S10B80.WTAILOR	Use (select)
GUBPPRF	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
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)
GORSDAV	SQL Table	S10B80.GENERAL	Join
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUBPPRF

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:50:000	04/02/2008 21:17:52:000

Source Code Comments

Enterprise Pin Preference table.

Columns Comments for GUBPPRF_FORMAT (# 1)

Source Code Comments

PIN RESET FORMAT: N = Numeric, A = Alphanumeric.

Columns Comments for GUBPPRF_VALUE (# 2)

Source Code Comments

PIN RESET VALUE: B = Birth date, R = Random value.

Columns Comments for GUBPPRF_SELF_NOTIFY_TYPE_IND (# 3)

Source Code Comments

PIN USER INSERT/UPDATE NOTIFICATION CONTROL: E = Create Email, L = Create Letter, B = Create Both Email and Letter, N = No Notification.

Columns Comments for GUBPPRF_ADMIN_NOTIFY_TYPE_IND (# 4)

Source Code Comments

PIN ADMINISTRATOR INSERT/UPDATE NOTIFICATION CONTROL: E = Create Email, L = Create Letter, B = Create Both Email and Letter, N = No Notification.

Columns Comments for GUBPPRF_PRE_EXPIRE_IND (# 5)

Source Code Comments

PRE-EXPIRE PIN INDICATOR: Y = Pre-expire PINs when created automatically or in batch, N = Do not pre-expire PINs.

Columns Comments for GUBPPRF_USER_ID (# 6)

Source Code Comments

USER ID: The USER ID which changed this record.

Columns Comments for GUBPPRF_ACTIVITY_DATE (# 7)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GUBPPRF_APPLICATION (# 8)

Source Code Comments

APPLICATION CODE: Letter Generation Application code. (From GLBAPPL)

Columns Comments for GUBPPRF_LETR_CODE_LETTER (# 9)

Source Code Comments

LETTER CODE: The pin reset letter generation code for the letter notification. (From GTVLETR)

Columns Comments for GUBPPRF_LETR_CODE_EMAIL (# 10)

Source Code Comments

LETTER CODE: The pin reset letter generation code for the email notification. (From GTVLETR)

Columns Comments for GUBPPRF_LENGTH_LAST_NAME (# 11)

Source Code Comments

LENGTH OF LAST NAME: Length used when generating the GOBTPAC_EXTERNAL_USER value. The value of 7 is the preexisting (before 7.4) behavior.

Columns Comments for GUBPPRF_MIN_LENGTH (# 12)

Source Code Comments

MIN_LENGTH: Minimum length required for PIN.

Columns Comments for GUBPPRF_MAX_LENGTH (# 13)

Source Code Comments

MAX_LENGTH: Maximum length required for PIN.

Columns Comments for GUBPPRF_NO_OF_QSTNS (# 14)

Source Code Comments

NO_OF_QSTNS: Number of questions required to be answered before PIN reset is allowed.

Columns Comments for GUBPPRF_NUM_IND (# 15)

Source Code Comments

NUM_IND: Indicator requires numeric value to be present.

Columns Comments for GUBPPRF_CHAR_IND (# 16)

Source Code Comments

CHAR_IND: Indicator requires character value to be present.

Columns Comments for GUBPPRF_REUSE_DAYS (# 17)

Source Code Comments

REUSE_DAYS: Number of days required to be checked for password reuse.

Columns Comments for GUBPPRF_QSTN_MIN_LENGTH (# 18)

Source Code Comments

QSTN_MIN_LENGTH: Minimum length required for question.

Columns Comments for GUBPPRF_ANSR_MIN_LENGTH (# 19)

Source Code Comments

ANSR_MIN_LENGTH: Minimum length required for answer.

Columns Comments for GUBPPRF_EDITQSTN_IND (# 20)

Source Code Comments

EDITQSTN_IND: This indicates whether question can be edited or not.

Columns Comments for GUBPPRF_SELF_LETR_CODE_LETTER (# 21)

Source Code Comments

SELF_LETR_CODE_LETTER: Self Letter code to be used for letter generation.

Columns Comments for GUBPPRF_SELF_LETR_CODE_EMAIL (# 22)

Source Code Comments

SELF_LETR_CODE_EMAIL: Self EMail code to be used for letter generation.

Table GUBSRVY

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GUBSRVY_NAME	VARCHAR2(15)	No	*
GUBSRVY_TITLE	VARCHAR2(60)	No
GUBSRVY_DISP_WEB_IND	VARCHAR2(1)	No
GUBSRVY_ACTIVITY_DATE	DATE	No
GUBSRVY_USER	VARCHAR2(30)	No
GUBSRVY_FROM_DATE	DATE	Yes
GUBSRVY_TO_DATE	DATE	Yes
GUBSRVY_EXTR_APPLICATION	VARCHAR2(30)	Yes
GUBSRVY_EXTR_SELECTION	VARCHAR2(30)	Yes
GUBSRVY_EXTR_CREATOR_ID	VARCHAR2(30)	Yes
GUBSRVY_EXTR_USER_ID	VARCHAR2(30)	Yes
GUBSRVY_INFO	VARCHAR2(2000)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GUBSRVY	Unique	GUBSRVY_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURSRVQ	SQL Table	S10B80.GENERAL	Refer (no action)
GURSVRL	SQL Table	S10B80.GENERAL	Refer (no action)
GUBSRVY_REC	Oracle Package Variable	S10B80.BANINST1.BWGKSRVY	Rely On
GUBSRVYDISPC	Oracle Package Cursor	S10B80.BANINST1.BWGKSRVY	Use (select)Rely On
GUBSRVYREADC	Oracle Package Cursor	S10B80.BANINST1.BWGKSRVY	Use (select)Rely On
GUBSRVY	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_GUBSRVY	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUBSRVY

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:33:000	04/02/2008 21:17:55:000

Source Code Comments

Survey Header Table. This tables defines the header information for surveys.

Columns Comments for GUBSRVY_NAME (# 1)

Source Code Comments

Survey Name.

Columns Comments for GUBSRVY_TITLE (# 2)

Source Code Comments

Title of the survey.

Columns Comments for GUBSRVY_DISP_WEB_IND (# 3)

Source Code Comments

Display on the Web Indicator, Y = display, N = do not display.

Columns Comments for GUBSRVY_ACTIVITY_DATE (# 4)

Source Code Comments

The date that the Survey was created or last changed.

Columns Comments for GUBSRVY_USER (# 5)

Source Code Comments

The User who created or last modified the Survey.

Columns Comments for GUBSRVY_FROM_DATE (# 6)

Source Code Comments

The date from which the Survey should be available for responses.

Columns Comments for GUBSRVY_TO_DATE (# 7)

Source Code Comments

The date until which the Survey should be available for responses.

Columns Comments for GUBSRVY_EXTR_APPLICATION (# 8)

Source Code Comments

The Population Selection Application that can respond to the Survey.

Columns Comments for GUBSRVY_EXTR_SELECTION (# 9)

Source Code Comments

The Population Selection Selection that can respond to the Survey.

Columns Comments for GUBSRVY_EXTR_CREATOR_ID (# 10)

Source Code Comments

The Population Selection Creator ID.

Columns Comments for GUBSRVY_EXTR_USER_ID (# 11)

Source Code Comments

The Population Selection User ID.

Columns Comments for GUBSRVY_INFO (# 12)

Source Code Comments

Free form text which describes the Survey and is displayed on the web.

Table GURSRVQ

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURSRVQ_NAME	VARCHAR2(15)	No	*	*
GURSRVQ_QUESTION_NO	NUMBER(3,0)	No	*
GURSRVQ_ACTIVITY_DATE	DATE	No
GURSRVQ_USER	VARCHAR2(30)	No
GURSRVQ_MULT_RESP_IND	VARCHAR2(1)	No
GURSRVQ_TEXT	VARCHAR2(1000)	No
GURSRVQ_ALLOW_COMMENTS_IND	VARCHAR2(1)	No
GURSRVQ_RESPONSE_1_TEXT	VARCHAR2(60)	Yes
GURSRVQ_RESPONSE_2_TEXT	VARCHAR2(60)	Yes
GURSRVQ_RESPONSE_3_TEXT	VARCHAR2(60)	Yes
GURSRVQ_RESPONSE_4_TEXT	VARCHAR2(60)	Yes
GURSRVQ_RESPONSE_5_TEXT	VARCHAR2(60)	Yes
GURSRVQ_COMMENTS_TEXT	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURSRVQ_NAME	GUBSRVY_NAME	GUBSRVY

Index

Index Name	Index Type	Column Name
PK_GURSRVQ	Unique	GURSRVQ_NAME
PK_GURSRVQ	Unique	GURSRVQ_QUESTION_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURSRVQ_ADD	SQL View	S10B80.BANINST1	Use (select)
GURSRVQ_ADS	SQL View	S10B80.BANINST1	Use (select)
GURSRVQ_SUB	SQL View	S10B80.BANINST1	Use (select)
GURSRVQ_REC	Oracle Package Variable	S10B80.BANINST1.BWGKSRVY	Rely On
GURSRVQREADC_MSC	Oracle Package Cursor	S10B80.BANINST1.BWGKSRVY	Use (select)Rely On
GURSRVQREADC	Oracle Package Cursor	S10B80.BANINST1.BWGKSRVY	Use (select)Rely On
GURSRVQ	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_GURSRVQ	SQL Index	S10B80.GENERAL	Rely On
GUBSRVY	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GURSRVQ

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:42:000	04/02/2008 21:17:52:000

Source Code Comments

Survey Questions Repeating Table. This tables defines the survey questions.

Columns Comments for GURSRVQ_NAME (# 1)

Source Code Comments

Survey Name.

Columns Comments for GURSRVQ_QUESTION_NO (# 2)

Source Code Comments

Survey Question Number.

Columns Comments for GURSRVQ_ACTIVITY_DATE (# 3)

Source Code Comments

The date that the question was created or last updated.

Columns Comments for GURSRVQ_USER (# 4)

Source Code Comments

The User ID which created or last updated the question.

Columns Comments for GURSRVQ_MULT_RESP_IND (# 5)

Source Code Comments

Allow multiple responses per question indicator.

Columns Comments for GURSRVQ_TEXT (# 6)

Source Code Comments

Free form text which defines the question.

Columns Comments for GURSRVQ_ALLOW_COMMENTS_IND (# 7)

Source Code Comments

Allow Comments Indicator. Y = allow comments, N = do not allow comments.

Columns Comments for GURSRVQ_RESPONSE_1_TEXT (# 8)

Source Code Comments

Free form text which describes the first possible response.

Columns Comments for GURSRVQ_RESPONSE_2_TEXT (# 9)

Source Code Comments

Free form text which describes the second possible response.

Columns Comments for GURSRVQ_RESPONSE_3_TEXT (# 10)

Source Code Comments

Free form text which describes the third possible response.

Columns Comments for GURSRVQ_RESPONSE_4_TEXT (# 11)

Source Code Comments

Free form text which describes the fourth possible response.

Columns Comments for GURSRVQ_RESPONSE_5_TEXT (# 12)

Source Code Comments

Free form text which describes the fifth possible response.

Columns Comments for GURSRVQ_COMMENTS_TEXT (# 13)

Source Code Comments

Free form text which define text display before the comment box on the web.

Table GURSVRL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURSVRL_NAME	VARCHAR2(15)	No	*	*
GURSVRL_ROLE	VARCHAR2(30)	No	*
GURSVRL_ACTIVITY_DATE	DATE	No
GURSVRL_USER	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURSVRL_NAME	GUBSRVY_NAME	GUBSRVY

Index

Index Name	Index Type	Column Name
PK_GURSVRL	Unique	GURSVRL_NAME
PK_GURSVRL	Unique	GURSVRL_ROLE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURSVRL_REC	Oracle Package Variable	S10B80.BANINST1.BWGKSRVY	Rely On
GURSVRLREADC	Oracle Package Cursor	S10B80.BANINST1.BWGKSRVY	Use (select)Rely On
GURSVRL	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_GURSVRL	SQL Index	S10B80.GENERAL	Rely On
GUBSRVY	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GURSVRL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:50:000	04/02/2008 21:17:55:000

Source Code Comments

Survey Roles Repeating Table. This tables defines which roles may respond.

Columns Comments for GURSVRL_NAME (# 1)

Source Code Comments

Survey Name.

Columns Comments for GURSVRL_ROLE (# 2)

Source Code Comments

Survey Role.

Columns Comments for GURSVRL_ACTIVITY_DATE (# 3)

Source Code Comments

The date that the role restriction was created or last updated.

Columns Comments for GURSVRL_USER (# 4)

Source Code Comments

The User ID which created or last updated the role restriction.

Table SPRADDR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SPRADDR_PIDM	NUMBER(8,0)	No	*
SPRADDR_ATYP_CODE	VARCHAR2(2)	No	*
SPRADDR_SEQNO	NUMBER(2,0)	No	*
SPRADDR_FROM_DATE	DATE	Yes
SPRADDR_TO_DATE	DATE	Yes
SPRADDR_STREET_LINE1	VARCHAR2(75)	Yes
SPRADDR_STREET_LINE2	VARCHAR2(75)	Yes
SPRADDR_STREET_LINE3	VARCHAR2(75)	Yes
SPRADDR_CITY	VARCHAR2(50)	No	*
SPRADDR_STAT_CODE	VARCHAR2(3)	Yes	*
SPRADDR_ZIP	VARCHAR2(30)	Yes
SPRADDR_CNTY_CODE	VARCHAR2(5)	Yes	*
SPRADDR_NATN_CODE	VARCHAR2(5)	Yes	*
SPRADDR_PHONE_AREA	VARCHAR2(6)	Yes
SPRADDR_PHONE_NUMBER	VARCHAR2(12)	Yes
SPRADDR_PHONE_EXT	VARCHAR2(10)	Yes
SPRADDR_STATUS_IND	VARCHAR2(1)	Yes
SPRADDR_ACTIVITY_DATE	DATE	No
SPRADDR_USER	VARCHAR2(30)	Yes
SPRADDR_ASRC_CODE	VARCHAR2(4)	Yes	*
SPRADDR_DELIVERY_POINT	NUMBER(2,0)	Yes
SPRADDR_CORRECTION_DIGIT	NUMBER(1,0)	Yes
SPRADDR_CARRIER_ROUTE	VARCHAR2(4)	Yes
SPRADDR_GST_TAX_ID	VARCHAR2(15)	Yes
SPRADDR_REVIEWED_IND	VARCHAR2(1)	Yes
SPRADDR_REVIEWED_USER	VARCHAR2(30)	Yes
SPRADDR_DATA_ORIGIN	VARCHAR2(30)	Yes
SPRADDR_CTRY_CODE_PHONE	VARCHAR2(4)	Yes
SPRADDR_HOUSE_NUMBER	VARCHAR2(10)	Yes
SPRADDR_STREET_LINE4	VARCHAR2(75)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPRADDR_ASRC_CODE	STVASRC_CODE	STVASRC
SPRADDR_ATYP_CODE	STVATYP_CODE	STVATYP
SPRADDR_CNTY_CODE	STVCNTY_CODE	STVCNTY
SPRADDR_NATN_CODE	STVNATN_CODE	STVNATN
SPRADDR_STAT_CODE	STVSTAT_CODE	STVSTAT
SPRADDR_PIDM	GORCGEO_PIDM	GORCGEO
SPRADDR_ATYP_CODE	GORCGEO_ATYP_CODE	GORCGEO
SPRADDR_SEQNO	GORCGEO_ADDR_SEQNO	GORCGEO
SPRADDR_ATYP_CODE	GTVSDAX_EXTERNAL_CODE	GTVSDAX
SPRADDR_PIDM	NBRBJOB_PIDM	NBRBJOB
SPRADDR_PIDM	SARADAP_PIDM	SARADAP
SPRADDR_PIDM	AMRINFO_PIDM	AMRINFO
SPRADDR_CITY	SORGEOR_START_RANGE	SORGEOR
SPRADDR_STAT_CODE	SORGEOR_END_RANGE	SORGEOR
SPRADDR_STAT_CODE	SORGEOR_START_RANGE	SORGEOR
SPRADDR_CNTY_CODE	SORGEOR_START_RANGE	SORGEOR
SPRADDR_NATN_CODE	SORGEOR_START_RANGE	SORGEOR
SPRADDR_PIDM	SFBETRM_PIDM	SFBETRM
SPRADDR_PIDM	PEBEMPL_PIDM	PEBEMPL
SPRADDR_PIDM	PABAPPL_PIDM	PABAPPL
SPRADDR_ATYP_CODE	APBCONS_ATYP_CODE_PREF	APBCONS
SPRADDR_PIDM	SRBRECR_PIDM	SRBRECR
SPRADDR_PIDM	GORSVAS_ACT_SITE_PIDM	GORSVAS
SPRADDR_ATYP_CODE	GORSVAS_ATYP_CODE	GORSVAS
SPRADDR_PIDM	GORSVEI_EMPLOYER_PIDM	GORSVEI
SPRADDR_ATYP_CODE	GORSVEI_ATYP_CODE	GORSVEI
SPRADDR_ATYP_CODE	AOBORGN_ATYP_CODE	AOBORGN
SPRADDR_SEQNO	SPRTELE_ADDR_SEQNO	SPRTELE
SPRADDR_ATYP_CODE	SPRTELE_ATYP_CODE	SPRTELE
SPRADDR_PIDM	SPRTELE_PIDM	SPRTELE
SPRADDR_ATYP_CODE	SARERUL_VALUE	SARERUL
SPRADDR_ATYP_CODE	GORICCR_VALUE	GORICCR
SPRADDR_STAT_CODE	SPRCOLR_VALUE_ATYP	SPRCOLR
SPRADDR_ATYP_CODE	GORADRL_ATYP_CODE	GORADRL
SPRADDR_ATYP_CODE	SORMSTA_ATYP_CODE	SORMSTA
SPRADDR_STAT_CODE	SORMSTA_STAT_CODE	SORMSTA

Index

Index Name	Index Type	Column Name
SPRADDR_KEY_INDEX	Unique	SPRADDR_PIDM
SPRADDR_KEY_INDEX	Unique	SPRADDR_ATYP_CODE
SPRADDR_KEY_INDEX	Unique	SPRADDR_SEQNO
SPRADDR_KEY_INDEX	Unique	SPRADDR_STATUS_IND
SPRADDR_KEY_INDEX2		SPRADDR_PIDM
SPRADDR_KEY_INDEX2		SPRADDR_ATYP_CODE
SPRADDR_KEY_INDEX2		SPRADDR_SEQNO
SPRADDR_KEY_INDEX2		SPRADDR_STATUS_IND
SPRADDR_KEY_INDEX2		SPRADDR_FROM_DATE
SPRADDR_KEY_INDEX2		SPRADDR_TO_DATE
SPRADDR_KEY_INDEX3		SPRADDR_USER
SPRADDR_KEY_INDEX3		SPRADDR_ASRC_CODE
SPRADDR_KEY_INDEX3		SPRADDR_ACTIVITY_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SORFOLK	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ST_SPRADDR_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
AF_VENDOR_PERFORMANCE	SQL View	S10B80.BANINST1	Use (select)
AF_VENDOR_VOLUME	SQL View	S10B80.BANINST1	Use (select)
ALVADDS	SQL View	S10B80.BANINST1	Use (select)
AMVGEOR	SQL View	S10B80.BANINST1	Use (select)
AOVCOMP	SQL View	S10B80.BANINST1	Use (select)
AOVIDEN	SQL View	S10B80.BANINST1	Use (select)
AOVORG1	SQL View	S10B80.BANINST1	Use (select)
APVADRS	SQL View	S10B80.BANINST1	Use (select)
APVCNI1	SQL View	S10B80.BANINST1	Use (select)
GEVEVN1	SQL View	S10B80.BANINST1	Use (select)
GEVEVN2	SQL View	S10B80.BANINST1	Use (select)
GOVSVAS	SQL View	S10B80.BANINST1	Use (select)
GOVSVEI	SQL View	S10B80.BANINST1	Use (select)
GOVSVEV	SQL View	S10B80.BANINST1	Use (select)
GOVSVSD	SQL View	S10B80.BANINST1	Use (select)
GPVENT1	SQL View	S10B80.BANINST1	Use (select)
PAVREQ1	SQL View	S10B80.BANINST1	Use (select)
PDVDED1	SQL View	S10B80.BANINST1	Use (select)
PEVJOB1	SQL View	S10B80.BANINST1	Use (select)
PEVPRF1	SQL View	S10B80.BANINST1	Use (select)
PEVREC0	SQL View	S10B80.BANINST1	Use (select)
PEVVER2	SQL View	S10B80.BANINST1	Use (select)
PPVADRS	SQL View	S10B80.BANINST1	Use (select)
RCVAPL2	SQL View	S10B80.BANINST1	Use (select)
ROVSTU3	SQL View	S10B80.BANINST1	Use (select)
RPVADDR	SQL View	S10B80.BANINST1	Use (select)
RPVADRS	SQL View	S10B80.BANINST1	Use (select)
RPVAWT2	SQL View	S10B80.BANINST1	Use (select)
RPVAWY2	SQL View	S10B80.BANINST1	Use (select)
RPVFDRS	SQL View	S10B80.BANINST1	Use (select)
SAVADM2_N	SQL View	S10B80.BANINST1	Use (select)
SAVADRS	SQL View	S10B80.BANINST1	Use (select)
SAVAMCD	SQL View	S10B80.BANINST1	Use (select)
SAVLIF1	SQL View	S10B80.BANINST1	Use (select)
SGVADRS	SQL View	S10B80.BANINST1	Use (select)
SHVDTL2_OLD	SQL View	S10B80.BANINST1	Use (select)
SOVGEOR	SQL View	S10B80.BANINST1	Use (select)
SPRADDR_ADD	SQL View	S10B80.BANINST1	Use (select)
SPRADDR_ADS	SQL View	S10B80.BANINST1	Use (select)
SPVADDF	SQL View	S10B80.BANINST1	Use (select)
SPVADDF_OJ	SQL View	S10B80.BANINST1	Use (select)
SPVADDG	SQL View	S10B80.BANINST1	Use (select)
SPVADDI	SQL View	S10B80.BANINST1	Use (select)
SPVADDI_OJ	SQL View	S10B80.BANINST1	Use (select)
SPVADDR	SQL View	S10B80.BANINST1	Use (select)
SPVADDS	SQL View	S10B80.BANINST1	Use (select)
SPVADDS_OJ	SQL View	S10B80.BANINST1	Use (select)
SPVADRS	SQL View	S10B80.BANINST1	Use (select)
SPVPERS	SQL View	S10B80.BANINST1	Use (select)
SRVADRS	SQL View	S10B80.BANINST1	Use (select)
SRVLIF1	SQL View	S10B80.BANINST1	Use (select)
F_GET_ADDRESS_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_GET_ADDRESS_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_ADDRESS_TELEPHONE_ROWID	SQL Function	S10B80.BANINST1	Rely On
F_GET_ADDRESS_TELEPHONE_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SPRADDR_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_LOST_AL_IND	SQL Function	S10B80.BANINST1	Use (select)
F_SECONDARY_CONTACT_ADDRESS	SQL Function	S10B80.BANINST1	Use (select)
F_SPOUSE_INFO	SQL Function	S10B80.BANINST1	Use (select)
ADDRESS_LINK_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
ADDRESS_REC	Oracle Package Type	S10B80.BANINST1.GB_ADDRESS	Rely On
ADDRESS_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSPKCOM	Rely On
ADDRESS_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKPREF	Rely On
ADDRESS_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
ADDR_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKMAIL	Rely On
SPRADDR_APP_C	Oracle Package Cursor	S10B80.BANINST1.SPKLIBS	Rely On
SPRADDR_APP_C	Oracle Package Cursor	S10B80.BANINST1.SPKLIBS	Use (select)
GV_SPRADDR_ADDRESS	Oracle Package Type	S10B80.BANINST1.GOKSELS	Rely On
GV_SPRADDR_ADDRESS	Oracle Package Type	S10B80.BANINST1.P_ADDR_TELE	Rely On
HOLD_ZIP_CODE_FROM	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
HOLD_ZIP_CODE_TO	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
PREV_ATYP	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
SPRADDR_REC	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
SPRADDR_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPSRC	Rely On
SPRADDR_REC	Oracle Package Variable	S10B80.BANINST1.BWAKPREF	Rely On
SPRADDR_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
SPRADDR_REC	Oracle Package Variable	S10B80.BANINST1.BWAKADVS	Rely On
ADDRESS_TYPE	Oracle Package Type	S10B80.BANINST1.BWLKOSAD	Rely On
ADDRESS_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Rely On
ADDRESS_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
ALLADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
CONSPREFADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
ORGPREFADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
SORFOLKC	Oracle Package Cursor	S10B80.BANINST1.BWSKAPAR	Use (select)
SORFOLKC2	Oracle Package Cursor	S10B80.BANINST1.BWSKAPAR	Use (select)
SPRADDRC	Oracle Package Cursor	S10B80.BANINST1.BWSKAPAR	Use (select)Rely On
SPRADDRC	Oracle Package Cursor	S10B80.BANINST1.BWSKAADR	Use (select)
SPRADDRCHECKFUTUREDATEC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDREQUALSCHGC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDREXISTSADDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDREXISTSCHGC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDRLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDRONEEQUALC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDRSEQNOVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
SPRADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
SPRADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKADVS	Use (select)Rely On
SPRADDR_ACTIVE_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Rely On
SPRADDR_ACTIVE_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Use (select)
SPRADDR_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKRQST	Rely On
SPRADDR_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKRQST	Use (select)
SPRADDR_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Rely On
SPRADDR_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
SPRADDR_ALL_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Rely On
SPRADDR_ALL_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Use (select)
SPRADDR_BY_HIERARCHY_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Rely On
SPRADDR_BY_HIERARCHY_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)Rely On
SPRADDR_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKRQST	Use (select)
SPRADDR_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
SPRTELE_ACCESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Rely On
SPRTELE_PHONEC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Rely On
STATSPRADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWLKOSAD	Use (select)
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
ZIPCSPRADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
EXTRACT_DEFAULT_DATA	Oracle Package Procedure	S10B80.BANINST1.BWSKAPAR	Rely On
P_APPLY_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.NOKEDIT	Rely On
P_CHECK_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
P_CHECK_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Use (select)
P_CREATE_PERSON	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
P_CREATE_PRIVATE	Oracle Package Procedure	S10B80.BANINST1.FB_SHIP	Rely On
P_CUR_NORTRAN_VALUE	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_DEFAULT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_DEFAULT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
P_GETMOREINFO	Oracle Package Procedure	S10B80.BANINST1.PAKRECR	Use (select)
P_INSERT_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.SAKL040	Rely On
P_MASS_EDIT_ARRAY	Oracle Package Procedure	S10B80.BANINST1.NOKEDIT	Rely On
P_MATERIAL_MATCHING	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (select)
P_NEW_NORTRAN_VALUE	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_OPEN_SPRADDR_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_ADDRESS	Rely On
P_PRINT_ADDRTELE_ROW	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_PRINT_ADDR_ROW	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_PRINT_NORTRAN_FIELDS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_PROC_SET_INFO	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_WHICH_ADDRTELE	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
UT_TB_MEMOQUERYAPI	Oracle Package Procedure	S10B80.BANINST1.UT_TB_MEMO	Use (update)
UT_TB_RECEIVABLEQUERYAPI	Oracle Package Procedure	S10B80.BANINST1.UT_TB_RECEIVABLE	Use (update)
ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.BWDKMOVE	Rely On
CUR_OF_CITY	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_OF_STATE	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_OF_STREET1	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_OF_STREET2	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_OF_STREET3	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_OF_STREET4	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_OF_ZIP	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_PR_CITY	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_PR_STATE	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_PR_STREET1	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_PR_STREET2	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_PR_STREET3	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_PR_STREET4	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_PR_ZIP	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
GV_ADDR1	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_ADDR2	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_ADDR3	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_ADDR_SEQ	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_ADDR_SEQNO1	Oracle Package Variable	S10B80.BANINST1.UT_SP_LDIPERSON	Rely On
GV_ADDR_SEQNO2	Oracle Package Variable	S10B80.BANINST1.UT_SP_LDIPERSON	Rely On
GV_ADDR_SEQNO3	Oracle Package Variable	S10B80.BANINST1.UT_SP_LDIPERSON	Rely On
GV_ADDR_SEQNO4	Oracle Package Variable	S10B80.BANINST1.UT_SP_LDIPERSON	Rely On
GV_CAMP_ADDR1	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_CAMP_ADDR2	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_CAMP_ADDR3	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_CITY	Oracle Package Variable	S10B80.BANINST1.BWSKRQST	Rely On
GV_DIPL_ADDR_ATYP	Oracle Package Variable	S10B80.BANINST1.BWSKGRAD	Rely On
GV_NATN_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKRQST	Rely On
GV_SEQNO	Oracle Package Variable	S10B80.BANINST1.UT_GP_CARDHOLDER	Rely On
GV_STAT_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKRQST	Rely On
GV_STREET1	Oracle Package Variable	S10B80.BANINST1.BWSKRQST	Rely On
GV_STREET2	Oracle Package Variable	S10B80.BANINST1.BWSKRQST	Rely On
GV_STREET3	Oracle Package Variable	S10B80.BANINST1.BWSKRQST	Rely On
GV_ZIP	Oracle Package Variable	S10B80.BANINST1.BWSKRQST	Rely On
PK_VAR_NEW_CITY	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_NEW_CNTY	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_NEW_NATN	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_NEW_STAT	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_NEW_ZIP	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_OLD_ADDR_STATUS	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_OLD_CITY	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_OLD_CNTY	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_OLD_NATN	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_OLD_STAT	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
PK_VAR_OLD_ZIP	Oracle Package Variable	S10B80.BANINST1.NOKEDIT	Rely On
SPRADDR_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
WORK_ADDRESS1	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
WORK_ADDRESS2	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
WORK_CITY	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
WORK_NATN	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
WORK_STATE	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
WORK_ZIP	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
F_BUILD_FRN_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_MAIL_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_SPRADDR_REC	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Rely On
F_BUILD_US_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_CHECK_STATE	Oracle Package Function	S10B80.BANINST1.BWDKSRCH	Use (select)
F_CHK_SPRADDR	Oracle Package Function	S10B80.BANINST1.SAKL050	Use (select)
F_FORMAT_ADDRESS	Oracle Package Function	S10B80.BANINST1.BWPKEPCR	Rely On
F_GET_ADDR_SEQNO	Oracle Package Function	S10B80.BANINST1.SAKL040	Use (select)
F_GET_ADDR_TYPE	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_GET_MAX_ADDRESS_SEQNO	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_GET_MAX_ADDRESS_SEQNO	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Use (select)
F_GET_MAX_TELEPHONE_SEQNO	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_SPRADDR_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Use (select)
GETADDRESSRECC	Oracle Package Cursor	S10B80.BANINST1.BWFKRPCU	Rely On
GETADDRESSRECC	Oracle Package Cursor	S10B80.BANINST1.BWFKRPCU	Use (select)Rely On
GETSPRADDRRECC	Oracle Package Cursor	S10B80.BANINST1.FPKSELS	Rely On
GETSPRADDRRECC	Oracle Package Cursor	S10B80.BANINST1.FPKSELS	Use (select)Rely On
SPRADDRC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)Rely On
SPRADDRTELEC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)
SPRADDRVIEWATYPSEQNOC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
SPRADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
P_ADDRESS_RULE	Oracle Package Procedure	S10B80.BANINST1.GB_EMERGENCY_CONTACT_RULES	Rely On
P_ADDRESS_RULE	Oracle Package Procedure	S10B80.BANINST1.GB_EMERGENCY_CONTACT_RULES	Use (select)
P_COLLECT_CREDIT_CARD_INFO	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Rely On
P_COLLECT_CREDIT_CARD_INFO	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_ADDRESS	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_ADDRESS	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SPRADDR	Use (delete)
P_DISPADDRUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_DISP_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKRQST	Rely On
P_DISP_ADDRESSES	Oracle Package Procedure	S10B80.BANINST1.BWDKCPRF	Rely On
P_DISP_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_DISP_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Use (select)
P_DISP_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	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_EVALUATE_SPRTELE	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_GET_ADDR_PRIORITY	Oracle Package Procedure	S10B80.BANINST1.NOKEPAF	Rely On
P_INACTIVATE_HOUSEHOLD_ADDR	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Rely On
P_INACTIVATE_HOUSEHOLD_ADDR	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SPRADDR	Use (Insert)Rely On
P_INSERT_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_LOAD_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Rely On
P_LOAD_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Use (select)Rely On
P_LOAD_EMPLOYER	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Rely On
P_LOAD_GOTCMME	Oracle Package Procedure	S10B80.BANINST1.NOKEPAF	Rely On
P_LOAD_SPOUSE	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Rely On
P_LOAD_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.SAKL040	Use (select)
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_ADDRESS	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_ADDRESS	Use (select)
P_PREF_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWAKPREF	Use (select)
P_PRINT_ADDRTELE_SELECTION	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_PRINT_ADDR_SELECTION	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_PRINT_W2C_2005	Oracle Package Procedure	S10B80.BANINST1.BWPKXW2S	Rely On
P_PRINT_W2C_2006	Oracle Package Procedure	S10B80.BANINST1.BWPKX06S	Rely On
P_PRINT_W2C_2007	Oracle Package Procedure	S10B80.BANINST1.BWPKX07S	Rely On
P_PRINT_W2C_PREVIEW_2005	Oracle Package Procedure	S10B80.BANINST1.PXK05TS	Rely On
P_PRINT_W2C_PREVIEW_2005	Oracle Package Procedure	S10B80.BANINST1.BWPKXW2S	Rely On
P_PRINT_W2C_PREVIEW_2006	Oracle Package Procedure	S10B80.BANINST1.PXK06TS	Rely On
P_PRINT_W2C_PREVIEW_2006	Oracle Package Procedure	S10B80.BANINST1.BWPKX06S	Rely On
P_PRINT_W2C_PREVIEW_2007	Oracle Package Procedure	S10B80.BANINST1.PXK07TS	Rely On
P_PRINT_W2_2007	Oracle Package Procedure	S10B80.BANINST1.BWPKX07S	Rely On
P_PRINT_W2_PREVIEW_2005	Oracle Package Procedure	S10B80.BANINST1.PXK05TS	Rely On
P_PRINT_W2_PREVIEW_2005	Oracle Package Procedure	S10B80.BANINST1.BWPKXW2S	Rely On
P_PRINT_W2_PREVIEW_2006	Oracle Package Procedure	S10B80.BANINST1.PXK06TS	Rely On
P_PRINT_W2_PREVIEW_2006	Oracle Package Procedure	S10B80.BANINST1.BWPKX06S	Rely On
P_PRINT_W2_PREVIEW_2007	Oracle Package Procedure	S10B80.BANINST1.PXK07TS	Rely On
P_PROCADDRUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOGAD	Rely On
P_PROCESS_HOUSEHOLD_ADDR_RECS	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Rely On
P_PROCESS_HOUSEHOLD_ADDR_RECS	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Use (select)
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (select)Rely On
P_PROCESS_SPRADDR_REC	Oracle Package Procedure	S10B80.BANINST1.NOKMUPD	Rely On
P_PROCESS_SPRADDR_REC	Oracle Package Procedure	S10B80.BANINST1.NOKMUPD	Use (select)
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_PROC_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKRQST	Rely On
P_PROC_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_PROC_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_PROC_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Use (select)
P_PROC_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_PURCHASEORDER	Oracle Package Procedure	S10B80.BANINST1.BWFKPURR	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_ADDRESS_RULES	Rely On
P_REQUISITION	Oracle Package Procedure	S10B80.BANINST1.BWFKREQN	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_STOREADDRUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_ADDRESS	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SPRADDR	Use (update)Rely On
P_UPDATE_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_UPDATE_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_ADDRESS_RULES	Rely On
P_VALIDATE_HEADER	Oracle Package Procedure	S10B80.BANINST1.FPKREQN	Rely On
P_VALIDATE_HEADER	Oracle Package Procedure	S10B80.BANINST1.FPKPURR	Rely On
P_VIEWDCSR	Oracle Package Procedure	S10B80.BANINST1.BWFKVDCR	Rely On
P_VIEWDCSR	Oracle Package Procedure	S10B80.BANINST1.BWFKVDCR	Use (select)
P_VIEWINV	Oracle Package Procedure	S10B80.BANINST1.BWFKVINV	Rely On
P_VIEWINV	Oracle Package Procedure	S10B80.BANINST1.BWFKVINV	Use (select)
P_VIEWPUR	Oracle Package Procedure	S10B80.BANINST1.BWFKVPUR	Rely On
P_VIEWPUR	Oracle Package Procedure	S10B80.BANINST1.BWFKVPUR	Use (select)
P_VIEWREQ	Oracle Package Procedure	S10B80.BANINST1.BWFKVREQ	Rely On
P_VIEWREQ	Oracle Package Procedure	S10B80.BANINST1.BWFKVREQ	Use (select)
P_VIEWW2_2005	Oracle Package Procedure	S10B80.BANINST1.BWPKXW2S	Rely On
P_VIEWW2_2006	Oracle Package Procedure	S10B80.BANINST1.BWPKX06S	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_TELEPHONE	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_CUSTOMER_PROFILE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_ENTITY_ADDRESS	Use (Insert)
F_ACTIVE_ADDRESSES	Oracle Package Function	S10B80.BANINST1.AOKHHLD	Use (select)
F_ADDRESS_TELEPHONE_VALUE	Oracle Package Function	S10B80.BANINST1.GOKSELS	Use (select)
F_ADDRESS_VALUE	Oracle Package Function	S10B80.BANINST1.P_ADDR_TELE	Use (select)
F_ADD_ENTITY_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_CALC_STREET	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_CURRENT_ADDRESS_INACTIVE	Oracle Package Function	S10B80.BANINST1.AOKHHLD	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
F_EXISTS_ACTIVE	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Rely On
F_EXISTS_ACTIVE	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
F_EXPIRE_ENTITY_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_GET_ADDRESS	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_ADDRESS_CHANGES_IND	Oracle Package Function	S10B80.BANINST1.APKWIND	Use (select)
F_GET_EMPL_DATA	Oracle Package Function	S10B80.BANINST1.PXKLIBS	Use (select)
F_GET_EMPL_DATA	Oracle Package Function	S10B80.BANINST1.BWPKXW2S	Use (select)
F_GET_MAJORS	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_NEXT_ADDR_SEQNO	Oracle Package Function	S10B80.BANINST1.GB_COMMON	Rely On
F_GET_NEXT_ADDR_SEQNO	Oracle Package Function	S10B80.BANINST1.GB_COMMON	Use (select)
F_GET_PERSON_XML	Oracle Package Function	S10B80.BANINST1.XMLGPERS	Use (select)
F_GET_PERSON_XML	Oracle Package Function	S10B80.BANINST1.LUKEAPI	Use (select)
F_GET_PERSON_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GET_PHONE	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_SPRADDR	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_SPRADDR_FIELD	Oracle Package Function	S10B80.BANINST1.NOKEPCR	Rely On
F_GET_SPRTELE_FIELD	Oracle Package Function	S10B80.BANINST1.NOKEPCR	Rely On
F_GET_SPRTELE_REC	Oracle Package Function	S10B80.BANINST1.NOKEPAF	Rely On
F_GET_STATUS	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
F_GET_VALID_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
F_IDNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.GB_IDENTIFICATION	Rely On
F_IDNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.GB_IDENTIFICATION	Use (select)
F_IDNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.TEST_LVH	Rely On
F_IDNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.TEST_LVH	Use (select)
F_IDNAME_SEARCH_MOD	Oracle Package Function	S10B80.BANINST1.TEST_LVH	Rely On
F_IDNAME_SEARCH_NEW	Oracle Package Function	S10B80.BANINST1.TEST_LVH	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
F_QUERY_LOCK	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Rely On
F_QUERY_LOCK	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
F_SSNNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.GB_IDENTIFICATION	Rely On
F_SSNNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.GB_IDENTIFICATION	Use (select)
F_VALIDATETELEADDR	Oracle Package Function	S10B80.BANINST1.BWPKEDIR	Use (select)
SPRADDR	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
SPRADDR_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SPRADDR_KEY_INDEX2	SQL Index	S10B80.SATURN	Rely On
SPRADDR_KEY_INDEX3	SQL Index	S10B80.SATURN	Rely On
AMRINFO	SQL Table	S10B80.ALUMNI	Join
AOBORGN	SQL Table	S10B80.ALUMNI	Join
APBCONS	SQL Table	S10B80.ALUMNI	Join
GORADRL	SQL Table	S10B80.GENERAL	Join
GORCGEO	SQL Table	S10B80.GENERAL	Join
GORICCR	SQL Table	S10B80.GENERAL	Join
GORSVAS	SQL Table	S10B80.GENERAL	Join
GORSVEI	SQL Table	S10B80.GENERAL	Join
GTVSDAX	SQL Table	S10B80.GENERAL	Join
NBRBJOB	SQL Table	S10B80.POSNCTL	Join
PABAPPL	SQL Table	S10B80.PAYROLL	Join
PEBEMPL	SQL Table	S10B80.PAYROLL	Join
SARADAP	SQL Table	S10B80.SATURN	Join
SARERUL	SQL Table	S10B80.SATURN	Join
SFBETRM	SQL Table	S10B80.SATURN	Join
SORGEOR	SQL Table	S10B80.SATURN	Join
SORMSTA	SQL Table	S10B80.SATURN	Join
SPRCOLR	SQL Table	S10B80.SATURN	Join
SPRTELE	SQL Table	S10B80.SATURN	Join
SRBRECR	SQL Table	S10B80.SATURN	Join
STVASRC	SQL Table	S10B80.SATURN	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
STVCNTY	SQL Table	S10B80.SATURN	Refer (no action)
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVSTAT	SQL Table	S10B80.SATURN	Refer (no action)
ST_SPRADDR_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_SPRADDR_AS_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,all rows)
ST_SPRADDR_DELETE_ROW	SQL Trigger	S10B80.SATURN	Fire (delete,before,each row)
ST_SPRADDR_INSERT_ROW	SQL Trigger	S10B80.SATURN	Fire (Insert,before,each row)
ST_SPRADDR_UPDATE_ROW	SQL Trigger	S10B80.SATURN	Fire (update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SPRADDR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:57:07:000	04/02/2008 21:18:18:000

Source Code Comments

Address Repeating Table

Columns Comments for SPRADDR_PIDM (# 1)

Source Code Comments

Internal identification number of person.

Columns Comments for SPRADDR_ATYP_CODE (# 2)

Source Code Comments

This field identifies the type of address associated with person.

Columns Comments for SPRADDR_SEQNO (# 3)

Source Code Comments

This field assigns an internal sequence number to each address type associated with person. This field does not display on screen.

Columns Comments for SPRADDR_FROM_DATE (# 4)

Source Code Comments

This field maintains the effective start date of address associated with person.

Columns Comments for SPRADDR_TO_DATE (# 5)

Source Code Comments

This field maintains the effective end date of address associated with person.

Columns Comments for SPRADDR_STREET_LINE1 (# 6)

Source Code Comments

This field maintains the first line of the address associated with person.

Columns Comments for SPRADDR_STREET_LINE2 (# 7)

Source Code Comments

This field maintains the second line of the address associated with person.

Columns Comments for SPRADDR_STREET_LINE3 (# 8)

Source Code Comments

This field maintains the third line of the address associated with person.

Columns Comments for SPRADDR_CITY (# 9)

Source Code Comments

This field maintains the city associated with the address of person.

Columns Comments for SPRADDR_STAT_CODE (# 10)

Source Code Comments

This field maintains the state associated with the address of person.

Columns Comments for SPRADDR_ZIP (# 11)

Source Code Comments

This field maintains the zip code associated with the address of person.

Columns Comments for SPRADDR_CNTY_CODE (# 12)

Source Code Comments

This field maintains the county associated with the address of person.

Columns Comments for SPRADDR_NATN_CODE (# 13)

Source Code Comments

This field maintains the nation/country associated with the address of person.

Columns Comments for SPRADDR_PHONE_AREA (# 14)

Source Code Comments

This field maintains the area code of the phone number associated with address of person.

Columns Comments for SPRADDR_PHONE_NUMBER (# 15)

Source Code Comments

This field maintains the phone number associated with address of person.

Columns Comments for SPRADDR_PHONE_EXT (# 16)

Source Code Comments

This field maintains the extension of the phone number associated with address of person.

Columns Comments for SPRADDR_STATUS_IND (# 17)

Source Code Comments

This field identifies if address information is inactive. Valid value is I - Inactive.

Columns Comments for SPRADDR_ACTIVITY_DATE (# 18)

Source Code Comments

This field defines the most current date a record is added or changed.

Columns Comments for SPRADDR_USER (# 19)

Source Code Comments

The Id for the User who create or update the record.

Columns Comments for SPRADDR_ASRC_CODE (# 20)

Source Code Comments

Address source code.

Columns Comments for SPRADDR_DELIVERY_POINT (# 21)

Source Code Comments

DELIVERY POINT: This field is used to designate the delivery point for mail as established by the Postal Service.

Columns Comments for SPRADDR_CORRECTION_DIGIT (# 22)

Source Code Comments

CORRECTION DIGIT: The Correction Digit field is defined by the Postal Service and is used to determine the digits used for delivery related to the ZIP code.

Columns Comments for SPRADDR_CARRIER_ROUTE (# 23)

Source Code Comments

CARRIER ROUTE: The addresses to which a carrier delivers mail. In common usage, carrier route includes city routes, rural routes, highway contract routes, post office box sections, and general delivery units.

Columns Comments for SPRADDR_GST_TAX_ID (# 24)

Source Code Comments

GST TAX IDENTIFICATION NUMBER: Goods and Services Tax Identification of vendor at this address

Columns Comments for SPRADDR_REVIEWED_IND (# 25)

Source Code Comments

Reviewed Indicator, Y indicates the address has been reviewed

Columns Comments for SPRADDR_REVIEWED_USER (# 26)

Source Code Comments

Reviewed User, indicates the user who reviewed the address.

Columns Comments for SPRADDR_DATA_ORIGIN (# 27)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SPRADDR_CTRY_CODE_PHONE (# 28)

Source Code Comments

COUNTRY CODE: Telephone code that designates the region and country.

Columns Comments for SPRADDR_HOUSE_NUMBER (# 29)

Source Code Comments

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

Columns Comments for SPRADDR_STREET_LINE4 (# 30)

Source Code Comments

STREET LINE 4: This field maintains the fourth line of the address associated with person.

View GOVSRVR

Server Name S10B80
Database Name BANINST1
View Label

View Columns information

Column Name	Column Type	Allow NULL
GOVSRVR_PIDM	NUMBER(8,0)	No
GOVSRVR_NAME	VARCHAR2(15)	No
GOVSRVR_DECLINED_IND	VARCHAR2(1)	No
GOVSRVR_COMPLETE_IND	VARCHAR2(1)	No
GOVSRVR_ID	VARCHAR2(9)	No
GOVSRVR_FULL_NAME	VARCHAR2(125)	Yes
GOVSRVR_LAST_NAME	VARCHAR2(60)	No
GOVSRVR_FIRST_NAME	VARCHAR2(60)	Yes
GOVSRVR_MI	VARCHAR2(60)	Yes
GOVSRVR_NAME_PREFIX	VARCHAR2(20)	Yes
GOVSRVR_NAME_SUFFIX	VARCHAR2(20)	Yes
GOVSRVR_USER	VARCHAR2(30)	No
GOVSRVR_ACTIVITY_DATE	DATE	No

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBSRVR	SQL Table	S10B80.GENERAL	Use (select)
SPBPERS	SQL Table	S10B80.SATURN	Use (select)
SPRIDEN	SQL Table	S10B80.SATURN	Use (select)
DATE	Oracle Package Type	S10B80.SYS.STANDARD	Rely On
NUMBER	Oracle Package Type	S10B80.SYS.STANDARD	Rely On
VARCHAR2	Oracle Package Type	S10B80.SYS.STANDARD	Rely On
GOBSRVR	Oracle Synonym	S10B80.PUBLIC	Use (select)
SPBPERS	Oracle Synonym	S10B80.PUBLIC	Use (select)
SPRIDEN	Oracle Synonym	S10B80.PUBLIC	Use (select)
DECODE	Oracle Package Function	S10B80.SYS.STANDARD	Call

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANINST1.GOVSRVR

Object Dates

Creation Date	Analysis Date
04/04/2008 21:07:47:000	04/04/2008 21:57:37:000

Number of code lines

Number of heading comment lines

Number of inner comment lines

Columns Comments for GOVSRVR_PIDM (# 1)

Source Code Comments

Internal identification number for the respondent.

Columns Comments for GOVSRVR_NAME (# 2)

Source Code Comments

Full name of the respondent.

Columns Comments for GOVSRVR_DECLINED_IND (# 3)

Source Code Comments

Declined Indicator, Y indicates declined to respond.

Columns Comments for GOVSRVR_COMPLETE_IND (# 4)

Source Code Comments

Complete indicator, Y indicates complete, N indicates incomplete.

Columns Comments for GOVSRVR_ID (# 5)

Source Code Comments

External identification number of the respondent.

Columns Comments for GOVSRVR_LAST_NAME (# 7)

Source Code Comments

Last name of the respondent.

Columns Comments for GOVSRVR_FIRST_NAME (# 8)

Source Code Comments

First name of the respondent.

Columns Comments for GOVSRVR_MI (# 9)

Source Code Comments

Middle name of the respondent.

Columns Comments for GOVSRVR_NAME_PREFIX (# 10)

Source Code Comments

Name prefix of the respondent.

Columns Comments for GOVSRVR_NAME_SUFFIX (# 11)

Source Code Comments

Name suffix of the respondent.

Columns Comments for GOVSRVR_USER (# 12)

Source Code Comments

User ID of the person who created or last changed the record.

Columns Comments for GOVSRVR_ACTIVITY_DATE (# 13)

Source Code Comments

Date the record was created or last changed.

Link between SPRADDR and GTVSDAX

Join Information

Objects list
schema-function : S10B80.BANINST1.F_GET_ADDRESS_TELEPHONE_ROWID

Link List

Link Type	Link	Project
Join	Link Between SPRADDR and GTVSDAX	SATURN

List of Real links

Link type	Between	And
Join	SPRADDR	GTVSDAX

Link between GOVSRVR and GOBSRVR

Link List

Link Type	Link	Project
Use (select)	Link Between GOVSRVR and GOBSRVR	BANINST1

List of Real links

Link type	Between	And
Use (select)	GOVSRVR	GOBSRVR

Link between SPRADDR and GORADRL

Join Information

Objects list
scope-cursor : S10B80.BANINST1.BWLKOSAD.STVATYPVIEWC scope-cursor : S10B80.BANINST1.BWGKOADR.STVATYPVIEWC

Link List

Link Type	Link	Project
Join	Link Between SPRADDR and GORADRL	SATURN

List of Real links

Link type	Between	And
Join	SPRADDR	GORADRL

Link between GOBDIRO and GTVDIRO

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBDIRO and GTVDIRO (FK1_GOBDIRO_INV_GTVDIRO_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBDIRO	GOBDIRO_DIRO_CODE	GTVDIRO_CODE	GTVDIRO	(1,1)-(0,1)

Link between GORSRVR and GOBSRVR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORSRVR and GOBSRVR (FK1_GORSRVR_INV_GOBSRVR_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORSRVR	GORSRVR_PIDM	GOBSRVR_PIDM	GOBSRVR	(1,1)-(0,n)
GORSRVR	GORSRVR_NAME	GOBSRVR_NAME	GOBSRVR	(1,1)-(0,n)

Link between GURSRVQ and GUBSRVY

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURSRVQ and GUBSRVY (FK1_GURSRVQ_INV_GUBSRVY_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURSRVQ	GURSRVQ_NAME	GUBSRVY_NAME	GUBSRVY	(1,1)-(0,n)

Link between GURSVRL and GUBSRVY

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURSVRL and GUBSRVY (FK1_GURSVRL_INV_GUBSRVY_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURSVRL	GURSVRL_NAME	GUBSRVY_NAME	GUBSRVY	(1,1)-(0,n)

Link between GOBANSR and GOBQSTN

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBANSR and GOBQSTN (FK1_GOBANSR_INV_GOBQSTN_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBANSR	GOBANSR_GOBQSTN_ID	GOBQSTN_ID	GOBQSTN	(0,1)-(0,n)

Link between GOREMAL and GTVEMAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOREMAL and GTVEMAL (FK1_GOREMAL_INV_GTVEMAL_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOREMAL	GOREMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL	(1,1)-(0,n)

Link between GORDADD and GOBDIRO

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDADD and GOBDIRO (FK1_GORDADD_INV_GOBDIRO_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDADD	GORDADD_DIRO_CODE	GOBDIRO_DIRO_CODE	GOBDIRO	(1,1)-(0,n)

Link between GORDPRF and GOBDIRO

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDPRF and GOBDIRO (FK1_GORDPRF_INV_GOBDIRO_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDPRF	GORDPRF_DIRO_CODE	GOBDIRO_DIRO_CODE	GOBDIRO	(1,1)-(0,n)