Model Job_Submission

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GJBCOLR	SQL Table	Default
GJBJOBS	SQL Table	Default
GJBPDEF	SQL Table	Default
GJBPDFT	SQL Table	Default
GJBPRUN	SQL Table	Default
GJBPVAL	SQL Table	Default
GJBRSLT	SQL Table	Default
GJRJPRM	SQL Table	Default
GJRSWPT	SQL Table	Default
GTVPRNT	SQL Table	Default
GTVSYSI	SQL Table	Default
GUBOUTP	SQL Table	Default
GUROUTP	SQL Table	Default
GURUPRF	SQL Table	Default

Model View

Table GJBCOLR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GJBCOLR_JOB	VARCHAR2(30)	No
GJBCOLR_ONE_UP_NO	NUMBER(0,0)	No
GJBCOLR_NUMBER	VARCHAR2(2)	No
GJBCOLR_VALUE	VARCHAR2(30)	No
GJBCOLR_ACTIVITY_DATE	DATE	No
GJBCOLR_MISC_VALUE	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GJBCOLR_KEY_INDEX		GJBCOLR_JOB
GJBCOLR_KEY_INDEX		GJBCOLR_ONE_UP_NO
GJBCOLR_KEY_INDEX		GJBCOLR_NUMBER

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
GJBCOLR_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GJBCOLR

Object Dates

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

Source Code Comments

Jobs Parameter Collector Table

Columns Comments for GJBCOLR_JOB (# 1)

Source Code Comments

JOB: Job name used along with One Up Number and Number to uniquely identify records.

Columns Comments for GJBCOLR_ONE_UP_NO (# 2)

Source Code Comments

ONE UP NO: Sequence number used along with Job and Number to uniquely identify records.

Columns Comments for GJBCOLR_NUMBER (# 3)

Source Code Comments

NUMBER: Parameter number used along with Job and One Up Number to uniquely identify records.

Columns Comments for GJBCOLR_VALUE (# 4)

Source Code Comments

VALUE: Actual value being stored for this parameter.

Columns Comments for GJBCOLR_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Actual date this record was created.

Columns Comments for GJBCOLR_MISC_VALUE (# 6)

Source Code Comments

MISCELLANEOUS VALUE: Miscellaneous field for optional use.

Table GJBJOBS

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GJBJOBS_NAME	VARCHAR2(30)	No
GJBJOBS_TITLE	VARCHAR2(30)	No
GJBJOBS_ACTIVITY_DATE	DATE	No
GJBJOBS_SYSI_CODE	VARCHAR2(2)	Yes	*
GJBJOBS_JOB_TYPE_IND	VARCHAR2(1)	Yes
GJBJOBS_DESC	VARCHAR2(240)	Yes
GJBJOBS_COMMAND_NAME	VARCHAR2(30)	Yes
GJBJOBS_PRNT_FORM	VARCHAR2(30)	Yes
GJBJOBS_PRNT_CODE	VARCHAR2(30)	Yes	*
GJBJOBS_LINE_COUNT	NUMBER(3,0)	Yes
GJBJOBS_VALIDATION	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GJBJOBS_PRNT_CODE	GTVPRNT_CODE	GTVPRNT
GJBJOBS_SYSI_CODE	GTVSYSI_CODE	GTVSYSI

Index

Index Name	Index Type	Column Name
GJBJOBS_KEY_INDEX	Unique	GJBJOBS_NAME
GJBJOBS_KEY_INDEX	Unique	GJBJOBS_SYSI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GJBJOBS_ADD	SQL View	S10B80.BANINST1	Use (select)
GJBJOBS_ADS	SQL View	S10B80.BANINST1	Use (select)
GJBJOBS	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
GJBJOBS_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GTVPRNT	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSYSI	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GJBJOBS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:13:000	04/02/2008 21:17:52:000

Source Code Comments

Report/Process Definition Table

Columns Comments for GJBJOBS_NAME (# 1)

Source Code Comments

NAME: Name of the executable, procedure or report.

Columns Comments for GJBJOBS_TITLE (# 2)

Source Code Comments

TITLE: Title or description of the executable, procedure or report.

Columns Comments for GJBJOBS_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date record was created or last modified.

Columns Comments for GJBJOBS_SYSI_CODE (# 4)

Source Code Comments

SYSTEM INDICATOR: Indicator which identifies the Banner System to which this executable, procedure or report belongs.

Columns Comments for GJBJOBS_JOB_TYPE_IND (# 5)

Source Code Comments

JOB TYPE INDICATOR: Indicator to identify whether this is an (E)xecutable, (P)rocedure or (R)eport.

Columns Comments for GJBJOBS_DESC (# 6)

Source Code Comments

DESCRIPTION: Long description of executable, procedure or report.

Columns Comments for GJBJOBS_COMMAND_NAME (# 7)

Source Code Comments

COMMAND NAME: Alternate procedure name to be run.

Columns Comments for GJBJOBS_PRNT_FORM (# 8)

Source Code Comments

STOCK PAPER: Default paper stock to be used.

Columns Comments for GJBJOBS_PRNT_CODE (# 9)

Source Code Comments

PRINTER CODE: Default printer code assigned to this executable, procedure or report.

Columns Comments for GJBJOBS_LINE_COUNT (# 10)

Source Code Comments

LINE COUNT: Default number of print lines per page for this executable, procedure, or report.

Columns Comments for GJBJOBS_VALIDATION (# 11)

Source Code Comments

VALIDATION: Process level validation label to executed when submitting job through the Job Submission system.

Table GJBPDEF

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GJBPDEF_JOB	VARCHAR2(30)	No	*
GJBPDEF_NUMBER	VARCHAR2(2)	No	*
GJBPDEF_DESC	VARCHAR2(30)	No
GJBPDEF_LENGTH	NUMBER(2,0)	No
GJBPDEF_TYPE_IND	VARCHAR2(1)	No
GJBPDEF_OPTIONAL_IND	VARCHAR2(1)	No
GJBPDEF_SINGLE_IND	VARCHAR2(1)	No
GJBPDEF_ACTIVITY_DATE	DATE	No
GJBPDEF_LOW_RANGE	VARCHAR2(30)	Yes
GJBPDEF_HIGH_RANGE	VARCHAR2(30)	Yes
GJBPDEF_HELP_TEXT	VARCHAR2(78)	Yes
GJBPDEF_VALIDATION	VARCHAR2(30)	Yes
GJBPDEF_LIST_VALUES	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GJBPDEF	Unique	GJBPDEF_JOB
PK_GJBPDEF	Unique	GJBPDEF_NUMBER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GJBPDEF_ADD	SQL View	S10B80.BANINST1	Use (select)
GJBPDEF_ADS	SQL View	S10B80.BANINST1	Use (select)
P_INSERT_GUBPRUN	Oracle Package Procedure	S10B80.BANINST1.RPKPCKG	Use (select)
GJBPDEF	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_GJBPDEF	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GJBPDEF

Object Dates

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

Source Code Comments

Jobs Parameter Definition Table

Columns Comments for GJBPDEF_JOB (# 1)

Source Code Comments

JOB: Name of executable, procedure or report.

Columns Comments for GJBPDEF_NUMBER (# 2)

Source Code Comments

NUMBER: Parameter number for this job.

Columns Comments for GJBPDEF_DESC (# 3)

Source Code Comments

DESCRIPTION: Description of parameter.

Columns Comments for GJBPDEF_LENGTH (# 4)

Source Code Comments

LENGTH: Length of the defined parameter.

Columns Comments for GJBPDEF_TYPE_IND (# 5)

Source Code Comments

TYPE INDICATOR: Indicator to identify parameter type of (C)haracter, (D)ate, (I)nteger or (N)umber.

Columns Comments for GJBPDEF_OPTIONAL_IND (# 6)

Source Code Comments

OPTIONAL INDICATOR: Indicator to identify whether or not this parameter is (O)ptional or (R)equired.

Columns Comments for GJBPDEF_SINGLE_IND (# 7)

Source Code Comments

SINGLE INDICATOR: Indicator to identify whether or not this parameter occurs (S)ingle or (M)ultiple times.

Columns Comments for GJBPDEF_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: Date this parameter was created or last modified.

Columns Comments for GJBPDEF_LOW_RANGE (# 9)

Source Code Comments

LOW RANGE: Specifies the low range boundry for this parameter.

Columns Comments for GJBPDEF_HIGH_RANGE (# 10)

Source Code Comments

LOW RANGE: Specifies the high range boundry for this parameter.

Columns Comments for GJBPDEF_HELP_TEXT (# 11)

Source Code Comments

HELP TEXT: Long description of parameter.

Columns Comments for GJBPDEF_VALIDATION (# 12)

Source Code Comments

VALIDATION: Parameter level validation label to be performed when job is submitted through the Job Submission system.

Columns Comments for GJBPDEF_LIST_VALUES (# 13)

Source Code Comments

LIST VALUES: Name of form to call for List of Values for this parameter.

Table GJBPDFT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GJBPDFT_JOB	VARCHAR2(30)	No
GJBPDFT_NUMBER	VARCHAR2(2)	No
GJBPDFT_ACTIVITY_DATE	DATE	No
GJBPDFT_USER_ID	VARCHAR2(30)	Yes
GJBPDFT_VALUE	VARCHAR2(30)	Yes
GJBPDFT_JPRM_CODE	VARCHAR2(15)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GJBPDFT_KEY_INDEX		GJBPDFT_JOB
GJBPDFT_KEY_INDEX		GJBPDFT_NUMBER
GJBPDFT_USER_INDEX		GJBPDFT_JOB
GJBPDFT_USER_INDEX		GJBPDFT_USER_ID
GJBPDFT_USER_INDEX		GJBPDFT_NUMBER

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
GJBPDFT_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GJBPDFT_USER_INDEX	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GJBPDFT

Object Dates

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

Source Code Comments

Default Parameter Table

Columns Comments for GJBPDFT_JOB (# 1)

Source Code Comments

JOB: Name of executable, procedure or report associated with this parameter default.

Columns Comments for GJBPDFT_NUMBER (# 2)

Source Code Comments

NUMBER: Parameter number associated with this default.

Columns Comments for GJBPDFT_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date default value was created or last modified.

Columns Comments for GJBPDFT_USER_ID (# 4)

Source Code Comments

USER ID: User ID associated with this default. NULL values represent system level defaults.

Columns Comments for GJBPDFT_VALUE (# 5)

Source Code Comments

VALUE: Default value for this parameter.

Columns Comments for GJBPDFT_JPRM_CODE (# 6)

Source Code Comments

Job Parameter Set Code.

Table GJBPRUN

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GJBPRUN_JOB	VARCHAR2(30)	No
GJBPRUN_ONE_UP_NO	NUMBER(0,0)	No	*
GJBPRUN_NUMBER	VARCHAR2(2)	No
GJBPRUN_ACTIVITY_DATE	DATE	No
GJBPRUN_VALUE	VARCHAR2(30)	Yes
GJBPRUN_LABEL	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GJBPRUN_ONE_UP_NO	GJBVPDI_ONE_UP_NO	GJBVPDI

Index

Index Name	Index Type	Column Name
GJBPRUN_KEY_INDEX		GJBPRUN_JOB
GJBPRUN_KEY_INDEX		GJBPRUN_ONE_UP_NO
GJBPRUN_KEY_INDEX		GJBPRUN_NUMBER
GJBPRUN_NO_INDEX		GJBPRUN_ONE_UP_NO
GJBPRUN_NO_INDEX		GJBPRUN_NUMBER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
G_ADDR_DATE_PARM_NBR	Oracle Package Variable	S10B80.BANINST1.SHKPXEX	Rely On
G_ADDR_TYPE_PARM_NBR	Oracle Package Variable	S10B80.BANINST1.SHKPXEX	Rely On
G_DOM_ADDR_NATN_CODE_PARM_NBR	Oracle Package Variable	S10B80.BANINST1.SHKPXEX	Rely On
G_EMAIL_TYPE_PARM_NBR	Oracle Package Variable	S10B80.BANINST1.SHKPXEX	Rely On
G_ID_SEQ_PARM_NBR	Oracle Package Variable	S10B80.BANINST1.SHKPXEX	Rely On
G_SELFRPT_TESC_CODE_PARM_NBR	Oracle Package Variable	S10B80.BANINST1.SHKPXEX	Rely On
G_TRNS_TYPE_PARM_NBR	Oracle Package Variable	S10B80.BANINST1.SHKPXEX	Rely On
PDEF_AIDY_PARM_NO	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_FROM_AIDY_PARM_NO	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_FUND_PARM_NO	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_FUND_SOURCE_PARM_NO	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_NO1	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_NO2	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_NO3	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_NO4	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_NO5	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_NO6	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_NO7	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_OPEID_PARM_NO	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_SCH_CDE_PARM_NO	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PDEF_TO_AIDY_PARM_NO	Oracle Package Variable	S10B80.BANINST1.ROKPVAL	Rely On
PARM_PRUN_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
F_CHK_RERGRNT_PELL_OPTION	Oracle Package Function	S10B80.BANINST1.ROKPVAL	Use (select)
F_GJBPRUN	Oracle Package Function	S10B80.BANINST1.GOKPVAL	Use (select)
SELECT_GJBPRUN_1	Oracle Package Function	S10B80.BANINST1.POKPVAL	Use (select)
GJBPRUN_C	Oracle Package Cursor	S10B80.BANINST1.FB_COMMON	Rely On
GJBPRUN_C	Oracle Package Cursor	S10B80.BANINST1.FB_COMMON	Use (select)Rely On
PARM_PRUN_C	Oracle Package Cursor	S10B80.BANINST1.TOKPVAL	Use (select)Rely On
CHECK_FGRFITD	Oracle Package Procedure	S10B80.BANINST1.FOKPVAL	Use (select)
GET_GJBPRUN_VALUE	Oracle Package Procedure	S10B80.BANINST1.FOKPVAL	Use (select)
P_CHK_ACTIVE_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_CHK_ACTIVE_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_CHK_DL_SCHOOL_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_CHK_FDRL_FUND_SOURCE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_CHK_FDRL_FUND_SOURCE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_CHK_INVALID_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_CHK_INVALID_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_CHK_OPEID_AND_BRANCH	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_INSERT_COLLECTOR_TABLE_PARMS	Oracle Package Procedure	S10B80.BANINST1.SHKPXEX	Rely On
P_INSERT_COLLECTOR_TABLE_PARMS	Oracle Package Procedure	S10B80.BANINST1.SHKPXEX	Use (select)
P_INSERT_GUBPRUN	Oracle Package Procedure	S10B80.BANINST1.RPKPCKG	Use (Insert)
P_JOBSUB_INIT	Oracle Package Procedure	S10B80.BANINST1.BWCKCMPL	Use (Insert)
P_PR_REBCDXX_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_PR_RERCDXX_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_PR_REREXXX_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PR_RERIMEX_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_PR_RORHSDP_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_PR_RORREGS_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PR_RPRCNCL_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PR_RPRSMRT_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	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_VALIDATE_GLBDATA	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE_GLBLSEL	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALID_AIDY_OPT_TERM	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VALID_AIDY_TERM	Oracle Package Procedure	S10B80.BANINST1.SOKPVAL	Rely On
P_VALID_AIDY_TERM	Oracle Package Procedure	S10B80.BANINST1.SOKPVAL	Use (select)
P_VALID_AIDY_TERM	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VALID_STAT_DATE	Oracle Package Procedure	S10B80.BANINST1.SOKPVAL	Rely On
F_GET_GJBPRUN_VALUE	Oracle Package Function	S10B80.BANINST1.FB_COMMON	Rely On
F_GJBPRUN	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
F_GJBPRUN	Oracle Package Function	S10B80.BANINST1.TOKPVAL	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
F_SELECT_GJBPRUN_1	Oracle Package Function	S10B80.BANINST1.GOKPVAL	Use (select)
F_SELECT_GJBPRUN_1	Oracle Package Function	S10B80.BANINST1.SOKPVAL	Use (select)
F_SELECT_GJBPRUN_1	Oracle Package Function	S10B80.BANINST1.ICOKPVAL	Use (select)
F_SELECT_GJBPRUN_1	Oracle Package Function	S10B80.BANINST1.ROKPVAL	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_VALID_POPULATION_SELECTION	Oracle Package Function	S10B80.BANINST1.SOKPVAL	Rely On
F_VALID_POPULATION_SELECTION4	Oracle Package Function	S10B80.BANINST1.GOKPVAL	Rely On
F_VALID_POPULATION_SELECTION4	Oracle Package Function	S10B80.BANINST1.SOKPVAL	Rely On
F_VALID_POPULATION_SELECTION4	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Rely On
F_VALID_POPULATION_SELECTION4	Oracle Package Function	S10B80.BANINST1.ICOKPVAL	Rely On
GJBPRUN	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
GJBPRUN_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GJBPRUN_NO_INDEX	SQL Index	S10B80.GENERAL	Rely On
GJBVPDI	SQL Table	S10B80.GENERAL	Join
GT_GJBPRUN_VPDI_AIR	SQL Trigger	S10B80.GENERAL	Fire (Insert,after,each row)
GT_GJBPRUN_VPDI_AUR	SQL Trigger	S10B80.GENERAL	Fire (delete,after,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GJBPRUN

Object Dates

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

Source Code Comments

Process Run Parameter Table

Columns Comments for GJBPRUN_JOB (# 1)

Source Code Comments

JOB: Job name used along with One Up Number and Number to identify the parameters.

Columns Comments for GJBPRUN_ONE_UP_NO (# 2)

Source Code Comments

ONE UP NO: Sequence number used along with Job and Number to identify the parameters.

Columns Comments for GJBPRUN_NUMBER (# 3)

Source Code Comments

NUMBER: Parameter Number used along with Job and One Up Number to identify the parameters.

Columns Comments for GJBPRUN_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date of record creation.

Columns Comments for GJBPRUN_VALUE (# 5)

Source Code Comments

VALUE: Value of parameter.

Columns Comments for GJBPRUN_LABEL (# 6)

Source Code Comments

GJBPRUN_LABEL: The gjbprun_label column contains the name of a variable that will be prompted for when glblsel or glbdata is run. This value is only filled in from the gjapctl form

Table GJBPVAL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GJBPVAL_JOB	VARCHAR2(30)	No	*
GJBPVAL_NUMBER	VARCHAR2(2)	No	*
GJBPVAL_VALUE	VARCHAR2(30)	No	*
GJBPVAL_DESC	VARCHAR2(30)	No
GJBPVAL_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GJBPVAL	Unique	GJBPVAL_JOB
PK_GJBPVAL	Unique	GJBPVAL_NUMBER
PK_GJBPVAL	Unique	GJBPVAL_VALUE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GJBPVAL	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GJBPVAL

Object Dates

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

Source Code Comments

General Jobs Parameter Value Table

Columns Comments for GJBPVAL_JOB (# 1)

Source Code Comments

JOB: Job name of executable, procedure or report.

Columns Comments for GJBPVAL_NUMBER (# 2)

Source Code Comments

NUMBER: Parameter number associated with this job.

Columns Comments for GJBPVAL_VALUE (# 3)

Source Code Comments

VALUE: Validation value associated with this parameter.

Columns Comments for GJBPVAL_DESC (# 4)

Source Code Comments

DESCRIPTION: Description of this validation value.

Columns Comments for GJBPVAL_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date record was created or last modified.

Table GJBRSLT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GJBRSLT_JOB	VARCHAR2(30)	No	*
GJBRSLT_ONE_UP_NO	NUMBER(0,0)	No	*
GJBRSLT_USER_ID	VARCHAR2(30)	No
GJBRSLT_STATUS_IND	VARCHAR2(1)	Yes
GJBRSLT_MESSAGE	VARCHAR2(60)	Yes
GJBRSLT_ACTIVITY_DATE	DATE	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GJBRSLT	Unique	GJBRSLT_JOB
PK_GJBRSLT	Unique	GJBRSLT_ONE_UP_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_ADD_RESULT	Oracle Package Procedure	S10B80.BANINST1.ROKSAPR	Use (Insert)
GJBRSLT	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_GJBRSLT	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GJBRSLT

Object Dates

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

Source Code Comments

External Process Results Table

Columns Comments for GJBRSLT_JOB (# 1)

Source Code Comments

JOB ID: Name of executable, procedure or report that was executed

Columns Comments for GJBRSLT_ONE_UP_NO (# 2)

Source Code Comments

ONE UP NO: System generated sequence number for each execution of any process

Columns Comments for GJBRSLT_USER_ID (# 3)

Source Code Comments

USER ID: User id of the user executing the process

Columns Comments for GJBRSLT_STATUS_IND (# 4)

Source Code Comments

STATUS INDICATOR: Final status of procedure, either (F)ailed or (S)uccess

Columns Comments for GJBRSLT_MESSAGE (# 5)

Source Code Comments

MESSAGE: Any message text to be passed or returned to calling process

Columns Comments for GJBRSLT_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date the process was executed

Table GJRJPRM

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GJRJPRM_JOB	VARCHAR2(30)	No	*
GJRJPRM_CODE	VARCHAR2(15)	No	*
GJRJPRM_DESC	VARCHAR2(30)	No
GJRJPRM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GJRJPRM	Unique	GJRJPRM_JOB
PK_GJRJPRM	Unique	GJRJPRM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GJRJPRM_ADS	SQL View	S10B80.BANINST1	Use (select)
GJRJPRM_SUB	SQL View	S10B80.BANINST1	Use (select)
GJRJPRM	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_GJRJPRM	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GJRJPRM

Object Dates

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

Source Code Comments

Job Parameter Set Rule Table

Columns Comments for GJRJPRM_JOB (# 1)

Source Code Comments

JOB: Name of Process being run.

Columns Comments for GJRJPRM_CODE (# 2)

Source Code Comments

Job Parameter Set Code.

Columns Comments for GJRJPRM_DESC (# 3)

Source Code Comments

Job Parameter Set Description

Columns Comments for GJRJPRM_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table GJRSWPT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GJRSWPT_SESSION_ID	NUMBER(0,0)	No
GJRSWPT_PROCESS	VARCHAR2(30)	No
GJRSWPT_PRINTER	VARCHAR2(30)	No
GJRSWPT_CURRENT_INTERVAL	NUMBER(6,0)	No
GJRSWPT_NEXT_INTERVAL	NUMBER(6,0)	No
GJRSWPT_LAST_EXECUTION	DATE	Yes
GJRSWPT_NEXT_EXECUTION	DATE	Yes
GJRSWPT_ERROR_IND	VARCHAR2(1)	Yes
GJRSWPT_INTERVAL_COUNT	NUMBER(9,0)	Yes
GJRSWPT_CUMULATIVE_COUNT	NUMBER(9,0)	Yes
GJRSWPT_CONTINUE_IND	VARCHAR2(1)	Yes
GJRSWPT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

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)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GJRSWPT

Object Dates

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

Source Code Comments

GJRSWPT: This table contains information about jobs running in sleep/wake mode.

Columns Comments for GJRSWPT_PROCESS (# 2)

Source Code Comments

Process running is sleep/wake mode.

Columns Comments for GJRSWPT_PRINTER (# 3)

Source Code Comments

Printer associated with this process.

Columns Comments for GJRSWPT_CURRENT_INTERVAL (# 4)

Source Code Comments

Amount of time (seconds) for this sleep/wake cycle.

Columns Comments for GJRSWPT_NEXT_INTERVAL (# 5)

Source Code Comments

Amount of time (seconds) for the next sleep/wake cycle.

Columns Comments for GJRSWPT_LAST_EXECUTION (# 6)

Source Code Comments

Last time this process executed.

Columns Comments for GJRSWPT_NEXT_EXECUTION (# 7)

Source Code Comments

Next time this process will execute.

Columns Comments for GJRSWPT_ERROR_IND (# 8)

Source Code Comments

Indicates whether or not the process has terminated because of an error.

Columns Comments for GJRSWPT_INTERVAL_COUNT (# 9)

Source Code Comments

Number of items processed last cycle.

Columns Comments for GJRSWPT_CUMULATIVE_COUNT (# 10)

Source Code Comments

Number of items processed for all cycles from the last time started.

Columns Comments for GJRSWPT_CONTINUE_IND (# 11)

Source Code Comments

Y indicates the process should continue to cycle, N indicates the process should stop executing when it next wakes.

Columns Comments for GJRSWPT_ACTIVITY_DATE (# 12)

Source Code Comments

Last time this row was inserted or updated.

Table GTVPRNT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVPRNT_CODE	VARCHAR2(30)	No	*
GTVPRNT_DESC	VARCHAR2(30)	No
GTVPRNT_ACTIVITY_DATE	DATE	No
GTVPRNT_PRINTER_COMMAND	VARCHAR2(255)	Yes
GTVPRNT_PRINTER_PORT	VARCHAR2(60)	Yes
GTVPRNT_LANDSCAPE_CDE	VARCHAR2(200)	Yes
GTVPRNT_LANDSCAPE_STRING	VARCHAR2(2000)	Yes
GTVPRNT_PORTRAIT_STRING	VARCHAR2(2000)	Yes
GTVPRNT_PORTRAIT_CDE	VARCHAR2(200)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVPRNT	Unique	GTVPRNT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GJBJOBS	SQL Table	S10B80.GENERAL	Refer (no action)
STVWSSO	SQL Table	S10B80.SATURN	Refer (no action)
GTVPRNTC	Oracle Package Cursor	S10B80.BANINST1.GTKPRNT	Use (select)Rely On
GTVPRNT_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVPRNT	Rely On
GTVPRNT_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVPRNT	Use (select)Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ENROLL_VER_SERVICE	Use (Insert)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVPRNT	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVPRNT	Rely On
GTVPRNT	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_GTVPRNT	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVPRNT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:05:000	04/02/2008 21:17:52:000

Source Code Comments

Printer Validation Table

Columns Comments for GTVPRNT_CODE (# 1)

Source Code Comments

PRINTER CODE: Printer code.

Columns Comments for GTVPRNT_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of print code.

Columns Comments for GTVPRNT_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date of record creation or last modification.

Columns Comments for GTVPRNT_PRINTER_COMMAND (# 4)

Source Code Comments

Host specific command to direct printout to this printer and options.

Columns Comments for GTVPRNT_PRINTER_PORT (# 5)

Source Code Comments

GTVPRNT_PRINTER_PORT: This column is now obsolete.

Columns Comments for GTVPRNT_LANDSCAPE_CDE (# 6)

Source Code Comments

GTVPRNT_LANDSCAPE_CODE: This column is now obsolete.

Columns Comments for GTVPRNT_LANDSCAPE_STRING (# 7)

Source Code Comments

GTVPRNT_LANDSCAPE_STRING: This column is now obsolete.

Columns Comments for GTVPRNT_PORTRAIT_STRING (# 8)

Source Code Comments

GTVPRNT_PORTRAIT_STRING: This column is now obsolete.

Columns Comments for GTVPRNT_PORTRAIT_CDE (# 9)

Source Code Comments

GTVPRNT_PORTRAIT_CODE: This column is now obsolete.

Table GTVSYSI

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVSYSI_CODE	VARCHAR2(2)	No	*
GTVSYSI_DESC	VARCHAR2(30)	No
GTVSYSI_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSYSI	Unique	GTVSYSI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ETVAXAP	SQL Table	S10B80.BANIMGR	Refer (no action)
GJBJOBS	SQL Table	S10B80.GENERAL	Refer (no action)
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)
GORMERC	SQL Table	S10B80.GENERAL	Refer (no action)
GORSDAV	SQL Table	S10B80.GENERAL	Join
GUBOBJS	SQL Table	S10B80.GENERAL	Refer (no action)
GURAOBJ	SQL Table	S10B80.BANSECR	Refer (no action)
GTVSYSI_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVSYSI_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVSYSIC	Oracle Package Cursor	S10B80.BANINST1.GTKSYSI	Use (select)Rely On
GTVSYSI_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSYSI	Rely On
GTVSYSI_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSYSI	Use (select)Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVSYSI	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVSYSI	Rely On
GTVSYSI	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_GTVSYSI	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVSYSI

Object Dates

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

Source Code Comments

System Indicator Validation Table

Columns Comments for GTVSYSI_CODE (# 1)

Source Code Comments

CODE: System indicator which uniquely identifies this record.

Columns Comments for GTVSYSI_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of this code.

Columns Comments for GTVSYSI_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date that record was created or last updated.

Table GUBOUTP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GUBOUTP_USERNAME	VARCHAR2(30)	No
GUBOUTP_USER_ID	NUMBER(0,0)	No	*
GUBOUTP_ONE_UP_NO	NUMBER(0,0)	No	*
GUBOUTP_JOB	VARCHAR2(30)	No
GUBOUTP_FILE_NAME	VARCHAR2(60)	No
GUBOUTP_FILE_NUMBER	NUMBER(0,0)	No	*
GUBOUTP_NUMBER_OF_LINES	NUMBER(0,0)	No
GUBOUTP_DATE_SAVED	DATE	Yes
GUBOUTP_DATE_PRINTED	DATE	Yes
GUBOUTP_OPERATING_SYSTEM	VARCHAR2(10)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GUBOUTP	Unique	GUBOUTP_USER_ID
PK_GUBOUTP	Unique	GUBOUTP_ONE_UP_NO
PK_GUBOUTP	Unique	GUBOUTP_FILE_NUMBER
UK1_GUBOUTP_JOB	Unique	GUBOUTP_USERNAME
UK1_GUBOUTP_JOB	Unique	GUBOUTP_USER_ID
UK1_GUBOUTP_JOB	Unique	GUBOUTP_ONE_UP_NO
UK1_GUBOUTP_JOB	Unique	GUBOUTP_FILE_NUMBER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUROUTP	SQL Table	S10B80.GENERAL	Refer (no action)
GUBOUTP_JOB_REC	Oracle Package Type	S10B80.BANINST1.BWGCBREF	Rely On
P_TRACE_CLEAR	Oracle Package Procedure	S10B80.WTAILOR.TWBKCOOK	Use (Insert,delete)
F_GET_JOBS	Oracle Package Function	S10B80.BANINST1.BWGCBREF	Rely On
F_GET_JOBS	Oracle Package Function	S10B80.BANINST1.BWGCBREF	Use (select)
F_GET_JOBS_COUNT	Oracle Package Function	S10B80.BANINST1.BWGCBREF	Rely On
F_GET_JOBS_COUNT	Oracle Package Function	S10B80.BANINST1.BWGCBREF	Use (select)
F_GET_REPORTS_XML	Oracle Package Function	S10B80.BANINST1.BWGCXCHN	Rely On
GUBOUTP	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_GUBOUTP	SQL Index	S10B80.GENERAL	Rely On
UK1_GUBOUTP_JOB	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUBOUTP

Object Dates

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

Source Code Comments

The job submission base output table used to store header information from batch jobs executed in a client server environment.

Columns Comments for GUBOUTP_USERNAME (# 1)

Source Code Comments

The guboutp_username is the Oracle username used to run the job.

Columns Comments for GUBOUTP_USER_ID (# 2)

Source Code Comments

The guboutp_username is the Oracle user_id assigned to the Oracle username used to run the job.

Columns Comments for GUBOUTP_ONE_UP_NO (# 3)

Source Code Comments

The guboutp_one_up_no is the one up number generated when the job was submitted from a BANNER form.

Columns Comments for GUBOUTP_JOB (# 4)

Source Code Comments

The guboutp_job is the name of the job or process which generated the output file.

Columns Comments for GUBOUTP_DATE_SAVED (# 8)

Source Code Comments

The guboutp_date_saved is the date the report was saved into the database.

Columns Comments for GUBOUTP_DATE_PRINTED (# 9)

Source Code Comments

The guboutp_date_printed is the date the report was printed via the on-line form.

Columns Comments for GUBOUTP_OPERATING_SYSTEM (# 10)

Source Code Comments

The guboutp_operating_system reflects the operating system on which the gurinso job was running when the report was saved.

Table GUROUTP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GUROUTP_USER_ID	NUMBER(0,0)	No	*	*
GUROUTP_ONE_UP_NO	NUMBER(0,0)	No	*	*
GUROUTP_FILE_NUMBER	NUMBER(0,0)	No	*	*
GUROUTP_SEQ_NO	NUMBER(0,0)	No	*
GUROUTP_LINE	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUROUTP_USER_ID	GUBOUTP_USER_ID	GUBOUTP
GUROUTP_ONE_UP_NO	GUBOUTP_ONE_UP_NO	GUBOUTP
GUROUTP_FILE_NUMBER	GUBOUTP_FILE_NUMBER	GUBOUTP

Index

Index Name	Index Type	Column Name
PK_GUROUTP	Unique	GUROUTP_USER_ID
PK_GUROUTP	Unique	GUROUTP_ONE_UP_NO
PK_GUROUTP	Unique	GUROUTP_FILE_NUMBER
PK_GUROUTP	Unique	GUROUTP_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUROUTP_REC	Oracle Package Variable	S10B80.BANINST1.GOKOUTP	Rely On
GUROUTPC	Oracle Package Cursor	S10B80.BANINST1.GOKOUTP	Use (select)Rely On
P_TRACE	Oracle Package Procedure	S10B80.WTAILOR.TWBKCOOK	Use (Insert,select)
P_TRACE_CLEAR	Oracle Package Procedure	S10B80.WTAILOR.TWBKCOOK	Use (delete)
P_TRACE_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.TWBKCOOK	Use (select)
GUROUTP	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_GUROUTP	SQL Index	S10B80.GENERAL	Rely On
GUBOUTP	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUROUTP

Object Dates

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

Source Code Comments

The job submission repeating output table used to store the output from batch jobs executed in a client server environment.

Columns Comments for GUROUTP_USER_ID (# 1)

Source Code Comments

The guroutp_username is the Oracle user_id assigned to the Oracle username used to run the job.

Columns Comments for GUROUTP_ONE_UP_NO (# 2)

Source Code Comments

The guroutp_one_up_no is the one up number generated when the job was submitted from a BANNER form.

Columns Comments for GUROUTP_SEQ_NO (# 4)

Source Code Comments

The guroutp_seq_no is a one up sequence number indicating the order of the lines in the file.

Columns Comments for GUROUTP_LINE (# 5)

Source Code Comments

The guroutp_line is a line of output from the listing file.

Table GURUPRF

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURUPRF_USER_ID	VARCHAR2(30)	No	*
GURUPRF_GROUP	VARCHAR2(30)	No	*
GURUPRF_KEY	VARCHAR2(30)	No	*
GURUPRF_STRING	VARCHAR2(30)	No	*
GURUPRF_VALUE	VARCHAR2(200)	Yes
GURUPRF_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
GURUPRF_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURUPRF	Unique	GURUPRF_USER_ID
PK_GURUPRF	Unique	GURUPRF_GROUP
PK_GURUPRF	Unique	GURUPRF_KEY
PK_GURUPRF	Unique	GURUPRF_STRING

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_GET_UPREF	Oracle Package Function	S10B80.BANINST1.GOKSSSO	Use (select)
ADD_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.GENUTIL	Use (Insert,select)
P_DISPLAY_PO	Oracle Package Procedure	S10B80.BANINST1.BWFKEAPI	Use (select)
P_DISPLAY_REQ	Oracle Package Procedure	S10B80.BANINST1.BWFKEAPI	Use (select)
F_GET_REPORTS_XML	Oracle Package Function	S10B80.BANINST1.BWGCXCHN	Rely On
GURUPRF	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_GURUPRF	SQL Index	S10B80.GENERAL	Rely On
GT_GURUPRF_PRE_UPDATE_ROW	SQL Trigger	S10B80.GENERAL	Fire (update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GURUPRF

Object Dates

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

Source Code Comments

Personal Preference Table

Columns Comments for GURUPRF_USER_ID (# 1)

Source Code Comments

UserID

Columns Comments for GURUPRF_GROUP (# 2)

Source Code Comments

Group

Columns Comments for GURUPRF_KEY (# 3)

Source Code Comments

Key

Columns Comments for GURUPRF_STRING (# 4)

Source Code Comments

String

Columns Comments for GURUPRF_VALUE (# 5)

Source Code Comments

Value

Columns Comments for GURUPRF_SYSTEM_REQ_IND (# 6)

Source Code Comments

System Required Indicator

Columns Comments for GURUPRF_ACTIVITY_DATE (# 7)

Source Code Comments

Activity Date of the last change

Link between GJBJOBS and GTVPRNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GJBJOBS and GTVPRNT (FK1_GJBJOBS_INV_GTVPRNT_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GJBJOBS	GJBJOBS_PRNT_CODE	GTVPRNT_CODE	GTVPRNT	(0,1)-(0,n)

Link between GJBJOBS and GTVSYSI

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GJBJOBS and GTVSYSI (FK1_GJBJOBS_INV_GTVSYSI_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GJBJOBS	GJBJOBS_SYSI_CODE	GTVSYSI_CODE	GTVSYSI	(0,1)-(0,n)

Link between GUROUTP and GUBOUTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GUROUTP and GUBOUTP (FK1_GUROUTP_INV_GUBOUTP_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GUROUTP	GUROUTP_USER_ID	GUBOUTP_USER_ID	GUBOUTP	(1,1)-(0,n)
GUROUTP	GUROUTP_ONE_UP_NO	GUBOUTP_ONE_UP_NO	GUBOUTP	(1,1)-(0,n)
GUROUTP	GUROUTP_FILE_NUMBER	GUBOUTP_FILE_NUMBER	GUBOUTP	(1,1)-(0,n)