Model Job Submission

Model Label : Banner General Job Submission
Path : BANNER DEV/General/ERD/Job Submission

List of Objects

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

Comments

Model View

Table GJBCOLR

Schema Name GENERAL
Label GJBCOLR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:24:000

Table Columns information

Column Name	Label	Column Type	Allow NULL
GJBCOLR_JOB	GJBCOLR_JOB	VARCHAR2(30)	No
GJBCOLR_ONE_UP_NO	GJBCOLR_ONE_UP_NO	NUMBER(0,0)	No
GJBCOLR_NUMBER	GJBCOLR_NUMBER	VARCHAR2(2)	No
GJBCOLR_VALUE	GJBCOLR_VALUE	VARCHAR2(30)	No
GJBCOLR_ACTIVITY_DATE	GJBCOLR_ACTIVITY_DATE	DATE	No
GJBCOLR_MISC_VALUE	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

Comments

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

Schema Name GENERAL
Label GJBJOBS
Server name MALDEV8_B60
Creation Date 06/11/2002 09:46:50:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
GJBJOBS_NAME	GJBJOBS_NAME	VARCHAR2(30)	No
GJBJOBS_TITLE	GJBJOBS_TITLE	VARCHAR2(30)	No
GJBJOBS_ACTIVITY_DATE	GJBJOBS_ACTIVITY_DATE	DATE	No
GJBJOBS_SYSI_CODE	GJBJOBS_SYSI_CODE	VARCHAR2(2)	Yes	*
GJBJOBS_JOB_TYPE_IND	GJBJOBS_JOB_TYPE_IND	VARCHAR2(1)	Yes
GJBJOBS_DESC	GJBJOBS_DESC	VARCHAR2(240)	Yes
GJBJOBS_COMMAND_NAME	GJBJOBS_COMMAND_NAME	VARCHAR2(30)	Yes
GJBJOBS_PRNT_FORM	GJBJOBS_PRNT_FORM	VARCHAR2(30)	Yes
GJBJOBS_PRNT_CODE	GJBJOBS_PRNT_CODE	VARCHAR2(30)	Yes	*
GJBJOBS_LINE_COUNT	GJBJOBS_LINE_COUNT	NUMBER(3,0)	Yes
GJBJOBS_VALIDATION	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

Comments

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

Schema Name GENERAL
Label GJBPDEF
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:24:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GJBPDEF_JOB	GJBPDEF_JOB	VARCHAR2(30)	No	*
GJBPDEF_NUMBER	GJBPDEF_NUMBER	VARCHAR2(2)	No	*
GJBPDEF_DESC	GJBPDEF_DESC	VARCHAR2(30)	No
GJBPDEF_LENGTH	GJBPDEF_LENGTH	NUMBER(2,0)	No
GJBPDEF_TYPE_IND	GJBPDEF_TYPE_IND	VARCHAR2(1)	No
GJBPDEF_OPTIONAL_IND	GJBPDEF_OPTIONAL_IND	VARCHAR2(1)	No
GJBPDEF_SINGLE_IND	GJBPDEF_SINGLE_IND	VARCHAR2(1)	No
GJBPDEF_ACTIVITY_DATE	GJBPDEF_ACTIVITY_DATE	DATE	No
GJBPDEF_LOW_RANGE	GJBPDEF_LOW_RANGE	VARCHAR2(30)	Yes
GJBPDEF_HIGH_RANGE	GJBPDEF_HIGH_RANGE	VARCHAR2(30)	Yes
GJBPDEF_HELP_TEXT	GJBPDEF_HELP_TEXT	VARCHAR2(78)	Yes
GJBPDEF_VALIDATION	GJBPDEF_VALIDATION	VARCHAR2(30)	Yes
GJBPDEF_LIST_VALUES	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

Comments

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

Schema Name GENERAL
Label GJBPDFT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:24:000

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
GJBPDFT_JOB	GJBPDEF_JOB	GJBPDEF
GJBPDFT_NUMBER	GJBPDEF_NUMBER	GJBPDEF

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

Comments

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

Schema Name GENERAL
Label GJBPRUN
Server name MALDEV8_B60
Creation Date 02/07/2003 15:34:43:000

Table Columns information

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

Foreign Key information

No Foreign Key

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

Comments

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

Schema Name GENERAL
Label GJBPVAL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:24:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GJBPVAL_JOB	GJBPVAL_JOB	VARCHAR2(30)	No	*
GJBPVAL_NUMBER	GJBPVAL_NUMBER	VARCHAR2(2)	No	*
GJBPVAL_VALUE	GJBPVAL_VALUE	VARCHAR2(30)	No	*
GJBPVAL_DESC	GJBPVAL_DESC	VARCHAR2(30)	No
GJBPVAL_ACTIVITY_DATE	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

Comments

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

Schema Name GENERAL
Label GJBRSLT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:24:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GJBRSLT_JOB	GJBRSLT_JOB	VARCHAR2(30)	No	*
GJBRSLT_ONE_UP_NO	GJBRSLT_ONE_UP_NO	NUMBER(0,0)	No	*
GJBRSLT_USER_ID	GJBRSLT_USER_ID	VARCHAR2(30)	No
GJBRSLT_STATUS_IND	GJBRSLT_STATUS_IND	VARCHAR2(1)	Yes
GJBRSLT_MESSAGE	GJBRSLT_MESSAGE	VARCHAR2(60)	Yes
GJBRSLT_ACTIVITY_DATE	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

Comments

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

Schema Name GENERAL
Label GJRJPRM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GJRJPRM_JOB	GJRJPRM_JOB	VARCHAR2(30)	No	*
GJRJPRM_CODE	GJRJPRM_CODE	VARCHAR2(15)	No	*
GJRJPRM_DESC	GJRJPRM_DESC	VARCHAR2(30)	No
GJRJPRM_ACTIVITY_DATE	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

Comments

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

Schema Name GENERAL
Label GJRSWPT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

No Result

Comments

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

Schema Name GENERAL
Label GTVPRNT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:34:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVPRNT	Unique	GTVPRNT_CODE

Comments

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 contains the path to a network printer. It is used by the GJIREVO form when printing from a PC based system. The name of a local LPT device could also be used.

Columns Comments for GTVPRNT_LANDSCAPE_CDE (6)

Source Code Comments

GTVPRNT_LANDSCAPE_CODE: This is the hex escape sequence needed by the device named in GTVPRNT_PRINTER_PORT that tells the printer how to switch to landscape print mode.

Columns Comments for GTVPRNT_LANDSCAPE_STRING (7)

Source Code Comments

GTVPRNT_LANDSCAPE_STRING: This is a sequence of concatenated chr values that are parsed using DBMS_SQL to generate the GTVPRNT_LANDSCAPE_CODE.

Columns Comments for GTVPRNT_PORTRAIT_STRING (8)

Source Code Comments

GTVPRNT_PORTRAIT_STRING: This is a sequence of concatenated chr values that are parsed using DBMS_SQL to generate the GTVPRNT_PORTRAIT_CODE.

Columns Comments for GTVPRNT_PORTRAIT_CDE (9)

Source Code Comments

GTVPRNT_PORTRAIT_CODE: This is the hex escape sequence needed by the device named in GTVPRNT_PRINTER_PORT that tells the printer how to switch to portrait print mode.

Table GTVSYSI

Schema Name GENERAL
Label GTVSYSI
Server name MALDEV8_B60
Creation Date 08/13/2002 15:20:19:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSYSI	Unique	GTVSYSI_CODE

Comments

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

Schema Name GENERAL
Label GUBOUTP
Server name MALDEV8_B60
Creation Date 01/24/2003 17:02:12:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GUBOUTP_USERNAME	GUBOUTP_USERNAME	VARCHAR2(30)	No
GUBOUTP_USER_ID	GUBOUTP_USER_ID	NUMBER(0,0)	No	*
GUBOUTP_ONE_UP_NO	GUBOUTP_ONE_UP_NO	NUMBER(0,0)	No	*
GUBOUTP_JOB	GUBOUTP_JOB	VARCHAR2(30)	No
GUBOUTP_FILE_NAME	GUBOUTP_FILE_NAME	VARCHAR2(60)	No
GUBOUTP_FILE_NUMBER	GUBOUTP_FILE_NUMBER	NUMBER(0,0)	No	*
GUBOUTP_NUMBER_OF_LINES	GUBOUTP_NUMBER_OF_LINES	NUMBER(0,0)	No
GUBOUTP_DATE_SAVED	GUBOUTP_DATE_SAVED	DATE	Yes
GUBOUTP_DATE_PRINTED	GUBOUTP_DATE_PRINTED	DATE	Yes
GUBOUTP_OPERATING_SYSTEM	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

Comments

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

Schema Name GENERAL
Label GUROUTP
Server name MALDEV8_B60
Creation Date 03/17/2003 09:53:14:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GUROUTP_USER_ID	GUROUTP_USER_ID	NUMBER(0,0)	No	*	*
GUROUTP_ONE_UP_NO	GUROUTP_ONE_UP_NO	NUMBER(0,0)	No	*	*
GUROUTP_FILE_NUMBER	GUROUTP_FILE_NUMBER	NUMBER(0,0)	No	*	*
GUROUTP_SEQ_NO	GUROUTP_SEQ_NO	NUMBER(0,0)	No	*
GUROUTP_LINE	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

Comments

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

Schema Name GENERAL
Label GURUPRF
Server name MALDEV8_B60
Creation Date 02/03/2003 16:43:21:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GURUPRF_USER_ID	GURUPRF_USER_ID	VARCHAR2(30)	No	*
GURUPRF_GROUP	GURUPRF_GROUP	VARCHAR2(30)	No	*
GURUPRF_KEY	GURUPRF_KEY	VARCHAR2(30)	No	*
GURUPRF_STRING	GURUPRF_STRING	VARCHAR2(30)	No	*
GURUPRF_VALUE	GURUPRF_VALUE	VARCHAR2(200)	Yes
GURUPRF_SYSTEM_REQ_IND	GURUPRF_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
GURUPRF_ACTIVITY_DATE	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

Comments

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

Caller : GJBJOBS
Called : GTVPRNT

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between GJBJOBS and GTVPRNT	GENERAL

Link Foreign Key Between GJBJOBS and GTVPRNT

Caller : GJBJOBS
Called : GTVPRNT
Link Type : Refer(No Action )
Link : Link Foreign Key Between GJBJOBS and GTVPRNT

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)

Comments

Link between GJBJOBS and GTVSYSI

Caller : GJBJOBS
Called : GTVSYSI

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between GJBJOBS and GTVSYSI	GENERAL

Link Foreign Key Between GJBJOBS and GTVSYSI

Caller : GJBJOBS
Called : GTVSYSI
Link Type : Refer(No Action )
Link : Link Foreign Key Between GJBJOBS and GTVSYSI

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)

Comments

Link between GUROUTP and GUBOUTP

Caller : GUROUTP
Called : GUBOUTP

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between GUROUTP and GUBOUTP	GENERAL

Link Foreign Key Between GUROUTP and GUBOUTP

Caller : GUROUTP
Called : GUBOUTP
Link Type : Refer(No Action )
Link : Link Foreign Key Between GUROUTP and GUBOUTP

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)

Comments

Link between GJBPDFT and GJBPDEF

Caller : GJBPDFT
Called : GJBPDEF

Join Information

Objects list
forms-pl/sql-library-procedure : FORMS_BANNER.TOQRPLS.T$_RUN_TGRAPPL

Link List

Link Type	Link	Project
Join	Link Between GJBPDFT and GJBPDEF	GENERAL

Link Between GJBPDFT and GJBPDEF

Caller : GJBPDFT
Called : GJBPDEF
Link Type : Join
Link : Link Between GJBPDFT and GJBPDEF

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GJBPDFT	GJBPDFT_JOB	GJBPDEF_JOB	GJBPDEF	(0,1)-(0,1)
GJBPDFT	GJBPDFT_NUMBER	GJBPDEF_NUMBER	GJBPDEF	(0,1)-(0,1)