GOBEQRC GOREQER GOREQNM GOREQPG GOREQRC GTVEQNM GTVEQPG GTVEQPM GTVEQTS

Model Event Queue Maintenance


Model Label : Banner General Event Queue Maintenance
Path : BANNER DEV/General/ERD/Event Queue Maintenance

List of Objects

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

Comments

Model View

''

Table GOBEQRC

Schema Name GENERAL
Label GOBEQRC
Server name MALDEV8_B60
Creation Date 03/24/2003 15:13:57:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBEQRC_SEQNO GOBEQRC_SEQNO NUMBER(0,0) No *
GOBEQRC_EQTS_CODE GOBEQRC_EQTS_CODE VARCHAR2(10) No * *
GOBEQRC_EQNM_CODE GOBEQRC_EQNM_CODE VARCHAR2(20) No * *
GOBEQRC_STATUS_IND GOBEQRC_STATUS_IND VARCHAR2(1) No
GOBEQRC_USER_ID GOBEQRC_USER_ID VARCHAR2(30) No
GOBEQRC_ACTIVITY_DATE 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

Comments

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

Schema Name GENERAL
Label GOREQER
Server name MALDEV8_B60
Creation Date 03/24/2003 15:13:57:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREQER_EQTS_CODE GOREQER_EQTS_CODE VARCHAR2(10) No * *
GOREQER_EQNM_CODE GOREQER_EQNM_CODE VARCHAR2(20) No * *
GOREQER_SEQNO GOREQER_SEQNO NUMBER(0,0) No *
GOREQER_ERROR_MESSAGE GOREQER_ERROR_MESSAGE VARCHAR2(2000) No
GOREQER_USER_ID GOREQER_USER_ID VARCHAR2(30) No
GOREQER_ACTIVITY_DATE GOREQER_ACTIVITY_DATE DATE No
GOREQER_ERROR_NUMBER GOREQER_ERROR_NUMBER NUMBER(0,0) Yes
GOREQER_ERROR_SEND_TO GOREQER_ERROR_SEND_TO VARCHAR2(30) Yes
GOREQER_SEVERITY_LEVEL GOREQER_SEVERITY_LEVEL VARCHAR2(1) Yes
GOREQER_ERROR_TYPE GOREQER_ERROR_TYPE VARCHAR2(6) Yes
GOREQER_ERROR_STACK GOREQER_ERROR_STACK VARCHAR2(2000) Yes
GOREQER_CALL_STACK 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

Comments

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

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREQNM_EQNM_CODE GOREQNM_EQNM_CODE VARCHAR2(20) No * *
GOREQNM_EQPG_CODE GOREQNM_EQPG_CODE VARCHAR2(10) No *
GOREQNM_EQTS_CODE GOREQNM_EQTS_CODE VARCHAR2(10) No * *
GOREQNM_STATUS_IND GOREQNM_STATUS_IND VARCHAR2(1) No
GOREQNM_USER_ID GOREQNM_USER_ID VARCHAR2(30) No
GOREQNM_ACTIVITY_DATE 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

Comments

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

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREQPG_EQPG_CODE GOREQPG_EQPG_CODE VARCHAR2(10) No * *
GOREQPG_EQPM_CODE GOREQPG_EQPM_CODE VARCHAR2(100) No * *
GOREQPG_SEQNO GOREQPG_SEQNO NUMBER(2,0) No *
GOREQPG_DEFAULT_VALUE GOREQPG_DEFAULT_VALUE VARCHAR2(2000) Yes
GOREQPG_TARGET_NAME GOREQPG_TARGET_NAME VARCHAR2(100) Yes
GOREQPG_USER_ID GOREQPG_USER_ID VARCHAR2(30) No
GOREQPG_ACTIVITY_DATE 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

Comments

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

Schema Name GENERAL
Label GOREQRC
Server name MALDEV8_B60
Creation Date 03/24/2003 15:13:57:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREQRC_SEQNO GOREQRC_SEQNO NUMBER(0,0) No *
GOREQRC_PARM_SEQNO GOREQRC_PARM_SEQNO NUMBER(0,0) No *
GOREQRC_PARM_NAME GOREQRC_PARM_NAME VARCHAR2(100) No
GOREQRC_PARM_VALUE GOREQRC_PARM_VALUE VARCHAR2(2000) No
GOREQRC_USER_ID GOREQRC_USER_ID VARCHAR2(30) No
GOREQRC_ACTIVITY_DATE 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

Comments

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

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

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVEQNM Unique GTVEQNM_CODE

Comments

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

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

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVEQPG Unique GTVEQPG_CODE

Comments

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

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

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVEQPM Unique GTVEQPM_CODE

Comments

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

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

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVEQTS Unique GTVEQTS_CODE

Comments

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

Caller : GOREQER
Called : GTVEQNM

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GOREQER and GTVEQNM GENERAL

Link Foreign Key Between GOREQER and GTVEQNM

Caller : GOREQER
Called : GTVEQNM
Link Type : Refer(No Action )
Link : Link Foreign Key Between GOREQER and GTVEQNM

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)

Comments

Link between GOREQNM and GTVEQNM

Caller : GOREQNM
Called : GTVEQNM

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GOREQNM and GTVEQNM GENERAL

Link Foreign Key Between GOREQNM and GTVEQNM

Caller : GOREQNM
Called : GTVEQNM
Link Type : Refer(No Action )
Link : Link Foreign Key Between GOREQNM and GTVEQNM

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)

Comments

Link between GOREQNM and GTVEQPG

Caller : GOREQNM
Called : GTVEQPG

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GOREQNM and GTVEQPG GENERAL

Link Foreign Key Between GOREQNM and GTVEQPG

Caller : GOREQNM
Called : GTVEQPG
Link Type : Refer(No Action )
Link : Link Foreign Key Between GOREQNM and GTVEQPG

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)

Comments

Link between GOREQPG and GTVEQPG

Caller : GOREQPG
Called : GTVEQPG

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GOREQPG and GTVEQPG GENERAL

Link Foreign Key Between GOREQPG and GTVEQPG

Caller : GOREQPG
Called : GTVEQPG
Link Type : Refer(No Action )
Link : Link Foreign Key Between GOREQPG and GTVEQPG

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)

Comments

Link between GOREQPG and GTVEQPM

Caller : GOREQPG
Called : GTVEQPM

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GOREQPG and GTVEQPM GENERAL

Link Foreign Key Between GOREQPG and GTVEQPM

Caller : GOREQPG
Called : GTVEQPM
Link Type : Refer(No Action )
Link : Link Foreign Key Between GOREQPG and GTVEQPM

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)

Comments

Link between GOREQER and GTVEQTS

Caller : GOREQER
Called : GTVEQTS

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GOREQER and GTVEQTS GENERAL

Link Foreign Key Between GOREQER and GTVEQTS

Caller : GOREQER
Called : GTVEQTS
Link Type : Refer(No Action )
Link : Link Foreign Key Between GOREQER and GTVEQTS

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)

Comments

Link between GOREQNM and GTVEQTS

Caller : GOREQNM
Called : GTVEQTS

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GOREQNM and GTVEQTS GENERAL

Link Foreign Key Between GOREQNM and GTVEQTS

Caller : GOREQNM
Called : GTVEQTS
Link Type : Refer(No Action )
Link : Link Foreign Key Between GOREQNM and GTVEQTS

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)

Comments

Link between GOBEQRC and GTVEQNM

Caller : GOBEQRC
Called : GTVEQNM

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GOBEQRC and GTVEQNM GENERAL

Link Foreign Key Between GOBEQRC and GTVEQNM

Caller : GOBEQRC
Called : GTVEQNM
Link Type : Refer(No Action )
Link : Link Foreign Key Between GOBEQRC and GTVEQNM

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)

Comments

Link between GOBEQRC and GTVEQTS

Caller : GOBEQRC
Called : GTVEQTS

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GOBEQRC and GTVEQTS GENERAL

Link Foreign Key Between GOBEQRC and GTVEQTS

Caller : GOBEQRC
Called : GTVEQTS
Link Type : Refer(No Action )
Link : Link Foreign Key Between GOBEQRC and GTVEQTS

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)

Comments