Model Event_Queue_Maintenance

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GOBEQRC	SQL Table	Default
GOREQER	SQL Table	Default
GOREQNM	SQL Table	Default
GOREQPG	SQL Table	Default
GOREQRC	SQL Table	Default
GTVEQNM	SQL Table	Default
GTVEQPG	SQL Table	Default
GTVEQPM	SQL Table	Default
GTVEQTS	SQL Table	Default

Model View

Table GOBEQRC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBEQRC_SEQNO	NUMBER(0,0)	No	*
GOBEQRC_EQTS_CODE	VARCHAR2(10)	No	*	*
GOBEQRC_EQNM_CODE	VARCHAR2(20)	No	*	*
GOBEQRC_STATUS_IND	VARCHAR2(1)	No
GOBEQRC_USER_ID	VARCHAR2(30)	No
GOBEQRC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBEQRC_EQNM_CODE	GTVEQNM_CODE	GTVEQNM
GOBEQRC_EQTS_CODE	GTVEQTS_CODE	GTVEQTS

Index

Index Name	Index Type	Column Name
GOBEQRC_EQTS_INDEX	Unique	GOBEQRC_EQTS_CODE
GOBEQRC_EQTS_INDEX	Unique	GOBEQRC_STATUS_IND
GOBEQRC_EQTS_INDEX	Unique	GOBEQRC_SEQNO
GOBEQRC_EQTS_INDEX	Unique	GOBEQRC_EQNM_CODE
PK_GOBEQRC	Unique	GOBEQRC_SEQNO
PK_GOBEQRC	Unique	GOBEQRC_EQTS_CODE
PK_GOBEQRC	Unique	GOBEQRC_EQNM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_GET_ALL_TODAYS_EVENTS	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Rely On
F_GET_ALL_TODAYS_EVENTS	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Use (select)
F_GET_TODAYS_PRIOR_EVENTS	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Rely On
F_GET_TODAYS_PRIOR_EVENTS	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Use (select)
HANDLE_ERROR	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Use (delete)
SEND_PARAM_LIST	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Use (Insert)
SEND_PARAM_LIST	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Use (Insert)
SEND_PARAM_LIST	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Use (Insert)
F_GET_EVENT_DATA	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Rely On
F_GET_QUEUE	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Rely On
F_GET_QUEUE_CREATEALL	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Rely On
F_GET_QUEUE_CREATEALL	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Use (select)
GOBEQRC	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
GOBEQRC_EQTS_INDEX	SQL Index	S10B80.GENERAL	Rely On
PK_GOBEQRC	SQL Index	S10B80.GENERAL	Rely On
GTVEQNM	SQL Table	S10B80.GENERAL	Refer (no action)
GTVEQTS	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBEQRC

Object Dates

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

Source Code Comments

Event Queue Record Maintenance Table.

Columns Comments for GOBEQRC_SEQNO (# 1)

Source Code Comments

SEQUENCE NUMBER: Sequence Number of an Event within the Target System. Generated by GOBESEQ.

Columns Comments for GOBEQRC_EQTS_CODE (# 2)

Source Code Comments

TARGET SYSTEM CODE: Target System Code.

Columns Comments for GOBEQRC_EQNM_CODE (# 3)

Source Code Comments

EVENT CODE: Event Code to be processed.

Columns Comments for GOBEQRC_STATUS_IND (# 4)

Source Code Comments

STATUS INDICATOR: 0=Ready for Processing, 1=Being Processed, 2=Complete.

Columns Comments for GOBEQRC_USER_ID (# 5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOBEQRC_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GOREQER

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOREQER_EQTS_CODE	VARCHAR2(10)	No	*	*
GOREQER_EQNM_CODE	VARCHAR2(20)	No	*	*
GOREQER_SEQNO	NUMBER(0,0)	No	*
GOREQER_ERROR_MESSAGE	VARCHAR2(2000)	No
GOREQER_USER_ID	VARCHAR2(30)	No
GOREQER_ACTIVITY_DATE	DATE	No
GOREQER_ERROR_NUMBER	NUMBER(0,0)	Yes
GOREQER_ERROR_SEND_TO	VARCHAR2(30)	Yes
GOREQER_SEVERITY_LEVEL	VARCHAR2(1)	Yes
GOREQER_ERROR_TYPE	VARCHAR2(6)	Yes
GOREQER_ERROR_STACK	VARCHAR2(2000)	Yes
GOREQER_CALL_STACK	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOREQER_EQNM_CODE	GTVEQNM_CODE	GTVEQNM
GOREQER_EQTS_CODE	GTVEQTS_CODE	GTVEQTS

Index

Index Name	Index Type	Column Name
PK_GOREQER	Unique	GOREQER_EQTS_CODE
PK_GOREQER	Unique	GOREQER_EQNM_CODE
PK_GOREQER	Unique	GOREQER_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
HANDLE_ERROR	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Use (Insert)
GOREQER	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_GOREQER	SQL Index	S10B80.GENERAL	Rely On
GTVEQNM	SQL Table	S10B80.GENERAL	Refer (no action)
GTVEQTS	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOREQER

Object Dates

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

Source Code Comments

Error Log Event Queue Table.

Columns Comments for GOREQER_EQTS_CODE (# 1)

Source Code Comments

TARGET SYSTEM CODE: Target System Code in the Error Log.

Columns Comments for GOREQER_EQNM_CODE (# 2)

Source Code Comments

EVENT CODE: Event Code ine the Error Log.

Columns Comments for GOREQER_SEQNO (# 3)

Source Code Comments

SEQUENCE NUMBER: Error sequence Number generated by GOBRSEQ sequence.

Columns Comments for GOREQER_ERROR_MESSAGE (# 4)

Source Code Comments

ERROR MESSAGE: Oracle error Message

Columns Comments for GOREQER_USER_ID (# 5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOREQER_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Columns Comments for GOREQER_ERROR_NUMBER (# 7)

Source Code Comments

ERROR NUMBER: Oracle Error Number

Columns Comments for GOREQER_ERROR_SEND_TO (# 8)

Source Code Comments

SEND TO: User Name to be notified of the Error.

Columns Comments for GOREQER_SEVERITY_LEVEL (# 9)

Source Code Comments

SEVERITY LEVEL: Error Severity level (reserved for future release).

Columns Comments for GOREQER_ERROR_TYPE (# 10)

Source Code Comments

ERROR TYPE: Error Type ( reserved for future release)

Columns Comments for GOREQER_ERROR_STACK (# 11)

Source Code Comments

ERROR STACK: Error Stack Messages.

Columns Comments for GOREQER_CALL_STACK (# 12)

Source Code Comments

CALL STACK: The call stack of pl/sql units( triggers, procedures).

Table GOREQNM

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOREQNM_EQNM_CODE	VARCHAR2(20)	No	*	*
GOREQNM_EQPG_CODE	VARCHAR2(10)	No		*
GOREQNM_EQTS_CODE	VARCHAR2(10)	No	*	*
GOREQNM_STATUS_IND	VARCHAR2(1)	No
GOREQNM_USER_ID	VARCHAR2(30)	No
GOREQNM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOREQNM_EQNM_CODE	GTVEQNM_CODE	GTVEQNM
GOREQNM_EQPG_CODE	GTVEQPG_CODE	GTVEQPG
GOREQNM_EQTS_CODE	GTVEQTS_CODE	GTVEQTS

Index

Index Name	Index Type	Column Name
PK_GOREQNM	Unique	GOREQNM_EQNM_CODE
PK_GOREQNM	Unique	GOREQNM_EQTS_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
C_GOREQNM	Oracle Package Cursor	S10B80.BANINST1.GOKPARM	Use (select)
GOREQNM_C	Oracle Package Cursor	S10B80.BANINST1.ICGOKCOM	Use (select)
CREATE_WORKFLOW_EVENT	Oracle Package Function	S10B80.BANINST1.EWFEVNT	Use (select)
P_SAVE_ASSIGNMENT	Oracle Package Procedure	S10B80.BANINST1.ICSIKLDI	Rely On
P_SAVE_COLLEGE	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SAVE_COURSE	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SAVE_CROSSLIST_GROUP	Oracle Package Procedure	S10B80.BANINST1.ICSSKLDI	Rely On
P_SAVE_CROSSLIST_MEMBERSHIP	Oracle Package Procedure	S10B80.BANINST1.ICSSKLDI	Rely On
P_SAVE_DEPARTMENT	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SAVE_ENROLLMENT	Oracle Package Procedure	S10B80.BANINST1.ICSFKLDI	Rely On
P_SAVE_PERSON	Oracle Package Procedure	S10B80.BANINST1.VIJAYSPKLDI	Rely On
P_SAVE_PERSON	Oracle Package Procedure	S10B80.BANINST1.ICSPKLDI	Rely On
P_SAVE_SECTION	Oracle Package Procedure	S10B80.BANINST1.ICSSKLDI	Rely On
P_SAVE_TERM	Oracle Package Procedure	S10B80.BANINST1.ICSOKLDI	Rely On
P_SEND_ADD_HOLD	Oracle Package Procedure	S10B80.BANINST1.ICSPKBEV	Rely On
P_SEND_ADD_REGISTRATION	Oracle Package Procedure	S10B80.BANINST1.ICSFKSEV	Rely On
P_SEND_ADD_REGISTRATION	Oracle Package Procedure	S10B80.BANINST1.SFKSEVN	Rely On
P_SEND_DROP_REGISTRATION	Oracle Package Procedure	S10B80.BANINST1.ICSFKSEV	Rely On
P_SEND_DROP_REGISTRATION	Oracle Package Procedure	S10B80.BANINST1.SFKSEVN	Rely On
P_SEND_PERSON	Oracle Package Procedure	S10B80.BANINST1.VIJAYSPKLDI	Rely On
P_SEND_PERSON	Oracle Package Procedure	S10B80.BANINST1.ICSPKLDI	Rely On
F_CHECKEVENT	Oracle Package Function	S10B80.BANINST1.ICGOKCOM	Rely On
F_CHECKEVENT	Oracle Package Function	S10B80.BANINST1.GOKEVNT	Use (select)
GOREQNM	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_GOREQNM	SQL Index	S10B80.GENERAL	Rely On
GTVEQNM	SQL Table	S10B80.GENERAL	Refer (no action)
GTVEQPG	SQL Table	S10B80.GENERAL	Refer (no action)
GTVEQTS	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOREQNM

Object Dates

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

Source Code Comments

Event Queue Name Definition Table

Columns Comments for GOREQNM_EQNM_CODE (# 1)

Source Code Comments

EVENT CODE: Event Code.

Columns Comments for GOREQNM_EQPG_CODE (# 2)

Source Code Comments

GROUP CODE: Group Code.

Columns Comments for GOREQNM_EQTS_CODE (# 3)

Source Code Comments

TARGET SYSTEM CODE: Target System Code.

Columns Comments for GOREQNM_STATUS_IND (# 4)

Source Code Comments

STATUS INDICATOR: Status Indicator for Events. Valid Values are (A)ctive and (I)nactive.

Columns Comments for GOREQNM_USER_ID (# 5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOREQNM_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GOREQPG

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOREQPG_EQPG_CODE	VARCHAR2(10)	No	*	*
GOREQPG_EQPM_CODE	VARCHAR2(100)	No	*	*
GOREQPG_SEQNO	NUMBER(2,0)	No	*
GOREQPG_DEFAULT_VALUE	VARCHAR2(2000)	Yes
GOREQPG_TARGET_NAME	VARCHAR2(100)	Yes
GOREQPG_USER_ID	VARCHAR2(30)	No
GOREQPG_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOREQPG_EQPG_CODE	GTVEQPG_CODE	GTVEQPG
GOREQPG_EQPM_CODE	GTVEQPM_CODE	GTVEQPM

Index

Index Name	Index Type	Column Name
PK_GOREQPG	Unique	GOREQPG_EQPG_CODE
PK_GOREQPG	Unique	GOREQPG_EQPM_CODE
PK_GOREQPG	Unique	GOREQPG_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
C_GOREQPG	Oracle Package Cursor	S10B80.BANINST1.GOKPARM	Use (select)
GET_EQPM_CODE_C	Oracle Package Cursor	S10B80.BANINST1.GOKPARM	Use (select)Rely On
SEND_PARAM_LIST	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Rely On
GOREQPG	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_GOREQPG	SQL Index	S10B80.GENERAL	Rely On
GTVEQPG	SQL Table	S10B80.GENERAL	Refer (no action)
GTVEQPM	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOREQPG

Object Dates

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

Source Code Comments

Parameter Group Code Rule Table

Columns Comments for GOREQPG_EQPG_CODE (# 1)

Source Code Comments

GROUP CODE: Group Code for the Parameter Set

Columns Comments for GOREQPG_EQPM_CODE (# 2)

Source Code Comments

PARAMETER CODE: Parameter Code.

Columns Comments for GOREQPG_SEQNO (# 3)

Source Code Comments

SEQUENCE NUMBER: Sequence Number for Parameters attached to the Group Code

Columns Comments for GOREQPG_DEFAULT_VALUE (# 4)

Source Code Comments

DEFAULT VALUE: Default Value for Parameters

Columns Comments for GOREQPG_TARGET_NAME (# 5)

Source Code Comments

TARGET NAME: Name for the Target Object to receive the value

Columns Comments for GOREQPG_USER_ID (# 6)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOREQPG_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GOREQRC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOREQRC_SEQNO	NUMBER(0,0)	No	*
GOREQRC_PARM_SEQNO	NUMBER(0,0)	No	*
GOREQRC_PARM_NAME	VARCHAR2(100)	No
GOREQRC_PARM_VALUE	VARCHAR2(2000)	No
GOREQRC_USER_ID	VARCHAR2(30)	No
GOREQRC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOREQRC	Unique	GOREQRC_SEQNO
PK_GOREQRC	Unique	GOREQRC_PARM_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PARAM_REC_TYPE	Oracle Package Type	S10B80.BANINST1.GOKPARM	Rely On
F_GET_PERSON_DETAILS	Oracle Package Function	S10B80.BANINST1.ICSPKLDI	Rely On
HANDLE_ERROR	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Use (delete)
P_SEND_PERSON	Oracle Package Procedure	S10B80.BANINST1.VIJAYSPKLDI	Rely On
P_SEND_PERSON	Oracle Package Procedure	S10B80.BANINST1.ICSPKLDI	Rely On
SEND_PARAM_LIST	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Use (Insert)
SEND_PARAM_LIST	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Use (Insert)
SEND_PARAM_LIST	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Use (Insert)
F_GET_EVENT_DATA	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Rely On
F_GET_EVENT_DATA	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Use (select)
F_GET_PERSON_DETAILS	Oracle Package Function	S10B80.BANINST1.VIJAYSPKLDI	Rely On
F_GET_QUEUE	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Rely On
F_GET_QUEUE	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Use (select)
F_GET_QUEUE_CREATEALL	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Rely On
F_GET_QUEUE_CREATEALL	Oracle Package Function	S10B80.BANINST1.SP_EVENT	Use (select)
GOREQRC	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_GOREQRC	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOREQRC

Object Dates

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

Source Code Comments

Event Queue Record Maintenance Detail Table.

Columns Comments for GOREQRC_SEQNO (# 1)

Source Code Comments

SEQUENCE NUMBER:Event Sequence Number.

Columns Comments for GOREQRC_PARM_SEQNO (# 2)

Source Code Comments

SEQUENCE NUMBER: Parameter Sequence Number.

Columns Comments for GOREQRC_PARM_NAME (# 3)

Source Code Comments

PARAMETER NAME: Parameter Name.

Columns Comments for GOREQRC_PARM_VALUE (# 4)

Source Code Comments

PARAMETER VALUE: Value for the Parameter

Columns Comments for GOREQRC_USER_ID (# 5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOREQRC_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GTVEQNM

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVEQNM_CODE	VARCHAR2(20)	No	*
GTVEQNM_DESC	VARCHAR2(30)	No
GTVEQNM_USER_ID	VARCHAR2(30)	No
GTVEQNM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVEQNM	Unique	GTVEQNM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBEQRC	SQL Table	S10B80.GENERAL	Refer (no action)
GOREQER	SQL Table	S10B80.GENERAL	Refer (no action)
GOREQNM	SQL Table	S10B80.GENERAL	Refer (no action)
GOREQNM_C	Oracle Package Cursor	S10B80.BANINST1.ICGOKCOM	Rely On
V_EQNM_CODE	Oracle Package Variable	S10B80.BANINST1.GOKPARM	Rely On
CREATE_WORKFLOW_EVENT	Oracle Package Function	S10B80.BANINST1.EWFEVNT	Rely On
F_GET_EVENT_NAME	Oracle Package Function	S10B80.BANINST1.EWFEVNT	Rely On
GTVEQNMC	Oracle Package Cursor	S10B80.BANINST1.GTKEQNM	Use (select)Rely On
GTVEQNM_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEQNM	Rely On
GTVEQNM_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEQNM	Use (select)Rely On
HANDLE_ERROR	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Rely On
P_AGBGIFTNEWGIFT	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Rely On
P_CHANGE_PIN	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_EMAILEVENTCHECK	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_FAWITHDRAW	Oracle Package Procedure	S10B80.BANINST1.SHKWEVN	Rely On
P_GRADE_CHANGE	Oracle Package Procedure	S10B80.BANINST1.ICSHKBEV	Rely On
P_GRADE_ROLL	Oracle Package Procedure	S10B80.BANINST1.ICSHKBEV	Rely On
P_PASSWORDEVNT	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_SAVE_ASSIGNMENT	Oracle Package Procedure	S10B80.BANINST1.ICSIKLDI	Rely On
P_SAVE_COLLEGE	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SAVE_COURSE	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SAVE_CROSSLIST_GROUP	Oracle Package Procedure	S10B80.BANINST1.ICSSKLDI	Rely On
P_SAVE_CROSSLIST_MEMBERSHIP	Oracle Package Procedure	S10B80.BANINST1.ICSSKLDI	Rely On
P_SAVE_DEPARTMENT	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SAVE_ENROLLMENT	Oracle Package Procedure	S10B80.BANINST1.ICSFKLDI	Rely On
P_SAVE_PERSON	Oracle Package Procedure	S10B80.BANINST1.VIJAYSPKLDI	Rely On
P_SAVE_PERSON	Oracle Package Procedure	S10B80.BANINST1.ICSPKLDI	Rely On
P_SAVE_SECTION	Oracle Package Procedure	S10B80.BANINST1.ICSSKLDI	Rely On
P_SAVE_TERM	Oracle Package Procedure	S10B80.BANINST1.ICSOKLDI	Rely On
P_SECTION_CANCELLED	Oracle Package Procedure	S10B80.BANINST1.ICSSKBEV	Rely On
P_SEND_ADD_HOLD	Oracle Package Procedure	S10B80.BANINST1.ICSPKBEV	Rely On
P_SEND_ADD_REGISTRATION	Oracle Package Procedure	S10B80.BANINST1.ICSFKSEV	Rely On
P_SEND_ADD_REGISTRATION	Oracle Package Procedure	S10B80.BANINST1.SFKSEVN	Rely On
P_SEND_ASSIGNMENT	Oracle Package Procedure	S10B80.BANINST1.ICSIKLDI	Rely On
P_SEND_COLLEGE	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SEND_COURSE	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SEND_CROSSLIST_GROUP	Oracle Package Procedure	S10B80.BANINST1.ICSSKLDI	Rely On
P_SEND_CROSSLIST_MEMBERSHIP	Oracle Package Procedure	S10B80.BANINST1.ICSSKLDI	Rely On
P_SEND_DEPARTMENT	Oracle Package Procedure	S10B80.BANINST1.ICSCKLDI	Rely On
P_SEND_DROP_REGISTRATION	Oracle Package Procedure	S10B80.BANINST1.ICSFKSEV	Rely On
P_SEND_DROP_REGISTRATION	Oracle Package Procedure	S10B80.BANINST1.SFKSEVN	Rely On
P_SEND_ENROLLMENT	Oracle Package Procedure	S10B80.BANINST1.ICSFKLDI	Rely On
P_SEND_PERSON	Oracle Package Procedure	S10B80.BANINST1.VIJAYSPKLDI	Rely On
P_SEND_PERSON	Oracle Package Procedure	S10B80.BANINST1.ICSPKLDI	Rely On
P_SEND_SECTION	Oracle Package Procedure	S10B80.BANINST1.ICSSKLDI	Rely On
P_SEND_TERM	Oracle Package Procedure	S10B80.BANINST1.ICSOKLDI	Rely On
P_WFEDEVNT	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_WITHDRAW_STUDENT	Oracle Package Procedure	S10B80.BANINST1.SHKWEVN	Rely On
F_CHECKEVENT	Oracle Package Function	S10B80.BANINST1.ICGOKCOM	Rely On
F_CHECKEVENT	Oracle Package Function	S10B80.BANINST1.GOKEVNT	Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVEQNM	Rely On
F_GET_ASSIGNMENT	Oracle Package Function	S10B80.BANINST1.ICSIKLDI	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVEQNM	Rely On
F_GET_ENROLLMENT	Oracle Package Function	S10B80.BANINST1.ICSFKLDI	Rely On
GTVEQNM	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_GTVEQNM	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVEQNM

Object Dates

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

Source Code Comments

Event Code Validation Table

Columns Comments for GTVEQNM_CODE (# 1)

Source Code Comments

EVENT CODE: Event Code for the Target System.

Columns Comments for GTVEQNM_DESC (# 2)

Source Code Comments

DESCRIPTION: Description for the Event Code

Columns Comments for GTVEQNM_USER_ID (# 3)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GTVEQNM_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GTVEQPG

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVEQPG_CODE	VARCHAR2(10)	No	*
GTVEQPG_DESC	VARCHAR2(30)	No
GTVEQPG_USER_ID	VARCHAR2(30)	No
GTVEQPG_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVEQPG	Unique	GTVEQPG_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOREQNM	SQL Table	S10B80.GENERAL	Refer (no action)
GOREQPG	SQL Table	S10B80.GENERAL	Refer (no action)
GTVEQPGC	Oracle Package Cursor	S10B80.BANINST1.GTKEQPG	Use (select)Rely On
GTVEQPG_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEQPG	Rely On
GTVEQPG_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEQPG	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVEQPG	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVEQPG	Rely On
GTVEQPG	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_GTVEQPG	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVEQPG

Object Dates

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

Source Code Comments

GROUP CODE Validation Table

Columns Comments for GTVEQPG_CODE (# 1)

Source Code Comments

GROUP CODE: Group Code for Events

Columns Comments for GTVEQPG_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of the Group Code.

Columns Comments for GTVEQPG_USER_ID (# 3)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GTVEQPG_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GTVEQPM

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVEQPM_CODE	VARCHAR2(100)	No	*
GTVEQPM_DESC	VARCHAR2(30)	No
GTVEQPM_USER_ID	VARCHAR2(30)	No
GTVEQPM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVEQPM	Unique	GTVEQPM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOREQPG	SQL Table	S10B80.GENERAL	Refer (no action)
GTVEQPMC	Oracle Package Cursor	S10B80.BANINST1.GTKEQPM	Use (select)Rely On
GTVEQPM_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEQPM	Rely On
GTVEQPM_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEQPM	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVEQPM	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVEQPM	Rely On
GTVEQPM	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_GTVEQPM	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVEQPM

Object Dates

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

Source Code Comments

Parameter Code Validation Table.

Columns Comments for GTVEQPM_CODE (# 1)

Source Code Comments

PARAMETER CODE: Parameter Code for Events

Columns Comments for GTVEQPM_DESC (# 2)

Source Code Comments

DESCRIPTION: Description for the Parameter Code.

Columns Comments for GTVEQPM_USER_ID (# 3)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GTVEQPM_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GTVEQTS

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVEQTS_CODE	VARCHAR2(10)	No	*
GTVEQTS_DESC	VARCHAR2(30)	No
GTVEQTS_USER_ID	VARCHAR2(30)	No
GTVEQTS_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVEQTS	Unique	GTVEQTS_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBEQRC	SQL Table	S10B80.GENERAL	Refer (no action)
GOREQER	SQL Table	S10B80.GENERAL	Refer (no action)
GOREQNM	SQL Table	S10B80.GENERAL	Refer (no action)
GOREQNM_C	Oracle Package Cursor	S10B80.BANINST1.ICGOKCOM	Rely On
V_EQTS_CODE	Oracle Package Variable	S10B80.BANINST1.GOKPARM	Rely On
GTVEQTSC	Oracle Package Cursor	S10B80.BANINST1.GTKEQTS	Use (select)Rely On
GTVEQTS_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEQTS	Rely On
GTVEQTS_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEQTS	Use (select)Rely On
HANDLE_ERROR	Oracle Package Procedure	S10B80.BANINST1.GOKPARM	Rely On
F_CHECKEVENT	Oracle Package Function	S10B80.BANINST1.ICGOKCOM	Rely On
F_CHECKEVENT	Oracle Package Function	S10B80.BANINST1.GOKEVNT	Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVEQTS	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVEQTS	Rely On
GTVEQTS	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_GTVEQTS	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVEQTS

Object Dates

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

Source Code Comments

Target System Code Validation Table

Columns Comments for GTVEQTS_CODE (# 1)

Source Code Comments

TARGET SYSTEM CODE: Target System Code for Workflow and Campus Pipeline Process

Columns Comments for GTVEQTS_DESC (# 2)

Source Code Comments

DESCRIPTION: Target Sytem Code Description.

Columns Comments for GTVEQTS_USER_ID (# 3)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GTVEQTS_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Link between GOREQER and GTVEQNM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOREQER and GTVEQNM (FK1_GOREQER_INV_GTVEQNM_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOREQER	GOREQER_EQNM_CODE	GTVEQNM_CODE	GTVEQNM	(1,1)-(0,n)

Link between GOREQNM and GTVEQNM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOREQNM and GTVEQNM (FK1_GOREQNM_INV_GTVEQNM_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOREQNM	GOREQNM_EQNM_CODE	GTVEQNM_CODE	GTVEQNM	(1,1)-(0,n)

Link between GOREQNM and GTVEQPG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOREQNM and GTVEQPG (FK1_GOREQNM_INV_GTVEQPG_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOREQNM	GOREQNM_EQPG_CODE	GTVEQPG_CODE	GTVEQPG	(1,1)-(0,n)

Link between GOREQPG and GTVEQPG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOREQPG and GTVEQPG (FK1_GOREQPG_INV_GTVEQPG_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOREQPG	GOREQPG_EQPG_CODE	GTVEQPG_CODE	GTVEQPG	(1,1)-(0,n)

Link between GOREQPG and GTVEQPM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOREQPG and GTVEQPM (FK1_GOREQPG_INV_GTVEQPM_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOREQPG	GOREQPG_EQPM_CODE	GTVEQPM_CODE	GTVEQPM	(1,1)-(0,n)

Link between GOREQER and GTVEQTS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOREQER and GTVEQTS (FK1_GOREQER_INV_GTVEQTS_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOREQER	GOREQER_EQTS_CODE	GTVEQTS_CODE	GTVEQTS	(1,1)-(0,n)

Link between GOREQNM and GTVEQTS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOREQNM and GTVEQTS (FK1_GOREQNM_INV_GTVEQTS_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOREQNM	GOREQNM_EQTS_CODE	GTVEQTS_CODE	GTVEQTS	(1,1)-(0,n)

Link between GOBEQRC and GTVEQNM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBEQRC and GTVEQNM (FK1_GOBEQRC_INV_GTVEQNM_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBEQRC	GOBEQRC_EQNM_CODE	GTVEQNM_CODE	GTVEQNM	(1,1)-(0,n)

Link between GOBEQRC and GTVEQTS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBEQRC and GTVEQTS (FK1_GOBEQRC_INV_GTVEQTS_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBEQRC	GOBEQRC_EQTS_CODE	GTVEQTS_CODE	GTVEQTS	(1,1)-(0,n)