GORRSQL GORSQPA GORSVSQ GTVSQPA GTVSQPR GTVSQRU GTVSVAP GTVSVBA

Model Business Rule Builder


Model Label : Banner General Business Rule Builder
Path : Default Folder/B70/General/Business_Rule_Builder

List of Objects

Object Name Object Type Layer Name
GORRSQL TABLE Default
GORSQPA TABLE Default
GORSVSQ TABLE Default
GTVSQPA TABLE Default
GTVSQPR TABLE Default
GTVSQRU TABLE Default
GTVSVAP TABLE Default
GTVSVBA TABLE Default

Comments

Model View

''

Table GORRSQL

Schema Name GENERAL
Label GORRSQL
Server name S4B70
Creation Date 10/21/2003 09:31:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORRSQL_SQPR_CODE GORRSQL_SQPR_CODE VARCHAR2(30) No * *
GORRSQL_SQRU_CODE GORRSQL_SQRU_CODE VARCHAR2(30) No * *
GORRSQL_SEQ_NO GORRSQL_SEQ_NO NUMBER(5,0) No *
GORRSQL_ACTIVE_IND GORRSQL_ACTIVE_IND VARCHAR2(1) No
GORRSQL_VALIDATED_IND GORRSQL_VALIDATED_IND VARCHAR2(1) No
GORRSQL_START_DATE GORRSQL_START_DATE DATE No
GORRSQL_SELECT_FROM GORRSQL_SELECT_FROM VARCHAR2(4000) No
GORRSQL_ACTIVITY_DATE GORRSQL_ACTIVITY_DATE DATE No
GORRSQL_USER_ID GORRSQL_USER_ID VARCHAR2(30) No
GORRSQL_SELECT_VALUE GORRSQL_SELECT_VALUE VARCHAR2(4000) Yes
GORRSQL_WHERE_CLAUSE GORRSQL_WHERE_CLAUSE CLOB Yes
GORRSQL_END_DATE GORRSQL_END_DATE DATE Yes
GORRSQL_PARSED_SQL GORRSQL_PARSED_SQL CLOB Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GORRSQL_SQPR_CODE GTVSQPR_CODE GTVSQPR
GORRSQL_SQRU_CODE GTVSQRU_CODE GTVSQRU

Index

Index Name Index Type Column Name
PK_GORRSQL Unique GORRSQL_SQPR_CODE
PK_GORRSQL Unique GORRSQL_SQRU_CODE
PK_GORRSQL Unique GORRSQL_SEQ_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GORRSQL SYNONYM S4B70.PUBLIC Rely on ()
DELETE_GORRSQL Forms Trigger BANNER7_FORMS.GORRSQL Use(delete )
DELETE_GORRSQL Forms Trigger BANNER7_FORMS_10G.GORRSQL Use(delete )
GEN_ONE_UP_NO Forms Trigger BANNER7_FORMS.GORRSQL Use(select )
GEN_ONE_UP_NO Forms Trigger BANNER7_FORMS_10G.GORRSQL Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVSQRU Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVSQPR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVSQPR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVSQRU Use(select )
GENERATE_SEQ_NO Forms Trigger BANNER7_FORMS.GORRSQL.GORRSQL Use(select )
GENERATE_SEQ_NO Forms Trigger BANNER7_FORMS_10G.GORRSQL.GORRSQL Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GORSVSQ.GORSVSQ Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GORSVSQ.GORSVSQ Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.GORRSQL.GORRSQL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.GORRSQL.GORRSQL Use(select )
F_EXECUTE_SQL_RULES Package function S4B70.BANINST1.GOKSVSQ Use(select )
F_INSTITUTIONAL_ROLES Package function S4B70.BANINST1.GB_INSTROLES Rely on ()
F_INSTITUTIONAL_ROLES Package function S4B70.BANINST1.GB_INSTROLES Use(select )
GORRSQL Forms DataBlock BANNER7_FORMS.GORRSQL Rely on () Use(insert,update,delete,select )
GORRSQL Forms DataBlock BANNER7_FORMS_10G.GORRSQL Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GORRSQL INDEX S4B70."GENERAL" Rely on ()
GTVSQPR TABLE S4B70."GENERAL" Refer( No Action )
GTVSQRU TABLE S4B70."GENERAL" Refer( No Action )

Comments

Source Code Comments

SQL Process Rules Table

Columns Comments for GORRSQL_SQPR_CODE (1)

Source Code Comments

SQL PROCESS CODE: Process code for dynamic SQL processing.

Columns Comments for GORRSQL_SQRU_CODE (2)

Source Code Comments

SQL RULE CODE: Rule code for dynamic SQL processing.

Columns Comments for GORRSQL_SEQ_NO (3)

Source Code Comments

SQL RULE SEQUENCE NUMBER: Sequence for SEVIS SQL rule for uniqueness and process order.

Columns Comments for GORRSQL_ACTIVE_IND (4)

Source Code Comments

ACTIVE INDICATOR: Indicator to show if the rule is currently active.

Columns Comments for GORRSQL_VALIDATED_IND (5)

Source Code Comments

VALIDATED INDICATOR: Indicator to show if the SQL has been validated.

Columns Comments for GORRSQL_START_DATE (6)

Source Code Comments

START DATE: Date that the rule becomes effective.

Columns Comments for GORRSQL_SELECT_FROM (7)

Source Code Comments

SELECT FROM VALUE: Tables and views that are in the FROM portion of the SQL statement.

Columns Comments for GORRSQL_ACTIVITY_DATE (8)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Columns Comments for GORRSQL_USER_ID (9)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GORRSQL_SELECT_VALUE (10)

Source Code Comments

SELECT VALUE: Value that is in the SELECT portion of the SQL statement.

Columns Comments for GORRSQL_WHERE_CLAUSE (11)

Source Code Comments

WHERE CLAUSE: WHERE clause of the SQL statement.

Columns Comments for GORRSQL_END_DATE (12)

Source Code Comments

END DATE: Date that the rule becomes obsolete.

Columns Comments for GORRSQL_PARSED_SQL (13)

Source Code Comments

PARSED SQL: Parsed SQL statement.

Table GORSQPA

Schema Name GENERAL
Label GORSQPA
Server name S4B70
Creation Date 10/21/2003 09:31:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORSQPA_SQPR_CODE GORSQPA_SQPR_CODE VARCHAR2(30) No * *
GORSQPA_SQPA_CODE GORSQPA_SQPA_CODE VARCHAR2(30) No * *
GORSQPA_SYS_REQ_IND GORSQPA_SYS_REQ_IND VARCHAR2(1) No
GORSQPA_ACTIVITY_DATE GORSQPA_ACTIVITY_DATE DATE No
GORSQPA_USER_ID GORSQPA_USER_ID VARCHAR2(30) No

Foreign Key information

Column name is Foreign Key For Column on Table
GORSQPA_SQPA_CODE GTVSQPA_CODE GTVSQPA
GORSQPA_SQPR_CODE GTVSQPR_CODE GTVSQPR

Index

Index Name Index Type Column Name
PK_GORSQPA Unique GORSQPA_SQPR_CODE
PK_GORSQPA Unique GORSQPA_SQPA_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GORSQPA SYNONYM S4B70.PUBLIC Rely on ()
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVSQRU Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVSQPR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVSQPR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVSQPA Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVSQRU Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVSQPA Use(select )
GORSQPA_RG Forms Record Group BANNER7_FORMS.GORRSQL Use(select )
GORSQPA_RG Forms Record Group BANNER7_FORMS_10G.GORRSQL Use(select )
CHK_SYS_REQ_IND Forms Function BANNER7_FORMS.GORSQPA Use(select )
CHK_SYS_REQ_IND Forms Function BANNER7_FORMS_10G.GORSQPA Use(select )
F_VALIDATE_SQL_RULE Package function S4B70.BANINST1.GOKRSQL Rely on ()
F_VALIDATE_SQL_RULE Package function S4B70.BANINST1.GOKRSQL Rely on () Use(select )
GORSQPA Forms DataBlock BANNER7_FORMS.GORSQPA Rely on () Use(insert,update,delete,select )
GORSQPA Forms DataBlock BANNER7_FORMS_10G.GORSQPA Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GORSQPA INDEX S4B70."GENERAL" Rely on ()
GTVSQPA TABLE S4B70."GENERAL" Refer( No Action )
GTVSQPR TABLE S4B70."GENERAL" Refer( No Action )

Comments

Source Code Comments

SQL Process Parameter Table

Columns Comments for GORSQPA_SQPR_CODE (1)

Source Code Comments

PROCESS CODE: SQL Process code

Columns Comments for GORSQPA_SQPA_CODE (2)

Source Code Comments

PARAMETER CODE: Parameter code associated with the SQL process code.

Columns Comments for GORSQPA_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: Indicates whether or not this parameter is system required.

Columns Comments for GORSQPA_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Columns Comments for GORSQPA_USER_ID (5)

Source Code Comments

USER ID: The most recent user to create or update a record.

Table GORSVSQ

Schema Name GENERAL
Label GORSVSQ
Server name S4B70
Creation Date 10/21/2003 09:31:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORSVSQ_SQPR_CODE GORSVSQ_SQPR_CODE VARCHAR2(30) No * *
GORSVSQ_SQRU_CODE GORSVSQ_SQRU_CODE VARCHAR2(30) No * *
GORSVSQ_SEQ_NO GORSVSQ_SEQ_NO NUMBER(5,0) No *
GORSVSQ_PROCESS_TYPE_IND GORSVSQ_PROCESS_TYPE_IND VARCHAR2(1) No
GORSVSQ_ACTIVE_IND GORSVSQ_ACTIVE_IND VARCHAR2(1) No
GORSVSQ_START_DATE GORSVSQ_START_DATE DATE No
GORSVSQ_ACTIVITY_DATE GORSVSQ_ACTIVITY_DATE DATE No
GORSVSQ_USER_ID GORSVSQ_USER_ID VARCHAR2(30) No
GORSVSQ_SVAP_CODE GORSVSQ_SVAP_CODE VARCHAR2(30) Yes *
GORSVSQ_SVBA_CODE GORSVSQ_SVBA_CODE VARCHAR2(30) Yes *
GORSVSQ_END_DATE GORSVSQ_END_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GORSVSQ_SQPR_CODE GTVSQPR_CODE GTVSQPR
GORSVSQ_SQRU_CODE GTVSQRU_CODE GTVSQRU
GORSVSQ_SVAP_CODE GTVSVAP_CODE GTVSVAP
GORSVSQ_SVBA_CODE GTVSVBA_CODE GTVSVBA

Index

Index Name Index Type Column Name
PK_GORSVSQ Unique GORSVSQ_SQPR_CODE
PK_GORSVSQ Unique GORSVSQ_SQRU_CODE
PK_GORSVSQ Unique GORSVSQ_SEQ_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GORSVSQ SYNONYM S4B70.PUBLIC Rely on ()
WHEN-BUTTON-PRESSED Forms Trigger BANNER7_FORMS.GORSVSQ.BUTTON_CONTROL_BLOCK.SEQUENCE_MAINT_BTN Use(update,select )
WHEN-BUTTON-PRESSED Forms Trigger BANNER7_FORMS_10G.GORSVSQ.BUTTON_CONTROL_BLOCK.SEQUENCE_MAINT_BTN Use(update,select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVSVBA Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVSVAP Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVSVBA Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVSVAP Use(select )
POST-DELETE Forms Trigger BANNER7_FORMS.GORSVSQ.GORSVSQ Use(update,select )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.GORSVSQ.GORSVSQ Use(update,select )
POST-QUERY Forms Trigger BANNER7_FORMS.GORSVSQ.GORSVSQ Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.GORSVSQ.GORSVSQ Use(select )
ASSIGN_SEQ_NUMS Forms Procedure BANNER7_FORMS.GORSVSQ Use(select )
ASSIGN_SEQ_NUMS Forms Procedure BANNER7_FORMS_10G.GORSVSQ Use(select )
ASSIGN_SEQ_NUMS2 Forms Procedure BANNER7_FORMS.GORSVSQ Use(select )
ASSIGN_SEQ_NUMS2 Forms Procedure BANNER7_FORMS_10G.GORSVSQ Use(select )
P_PROCESS_AGAIN Package procedure S4B70.BANINST1.GOKSVSQ Rely on ()
P_PROCESS_AGAIN Package procedure S4B70.BANINST1.GOKSVSQ Rely on () Use(select )
P_PROCESS_SQL_RULES Package procedure S4B70.BANINST1.GOKSVSQ Rely on ()
P_PROCESS_SQL_RULES Package procedure S4B70.BANINST1.GOKSVSQ Rely on () Use(select )
GORSVSQ Forms DataBlock BANNER7_FORMS.GORSVSQ Rely on () Use(insert,update,delete,select )
GORSVSQ Forms DataBlock BANNER7_FORMS_10G.GORSVSQ Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GORSVSQ INDEX S4B70."GENERAL" Rely on ()
GTVSQPR TABLE S4B70."GENERAL" Refer( No Action )
GTVSQRU TABLE S4B70."GENERAL" Refer( No Action )
GTVSVAP TABLE S4B70."GENERAL" Refer( No Action )
GTVSVBA TABLE S4B70."GENERAL" Refer( No Action )

Comments

Source Code Comments

SEVIS SQL Rules Table

Columns Comments for GORSVSQ_SQPR_CODE (1)

Source Code Comments

SQL PROCESS CODE: Process code for SEVIS SQL processing.

Columns Comments for GORSVSQ_SQRU_CODE (2)

Source Code Comments

SQL RULE CODE: Rule code for SEVIS SQL processing.

Columns Comments for GORSVSQ_SEQ_NO (3)

Source Code Comments

SEVIS SQL RULE SEQUENCE NUMBER: Sequence for SEVIS SQL rule for uniqueness.

Columns Comments for GORSVSQ_PROCESS_TYPE_IND (4)

Source Code Comments

SEVIS SQL PROCESS TYPE: Process type - autopopulate update or business action.

Columns Comments for GORSVSQ_ACTIVE_IND (5)

Source Code Comments

ACTIVE INDICATOR: Indicator to show if the rule is currently active.

Columns Comments for GORSVSQ_START_DATE (6)

Source Code Comments

START DATE: Date that the rule comes into effective.

Columns Comments for GORSVSQ_ACTIVITY_DATE (7)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Columns Comments for GORSVSQ_USER_ID (8)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GORSVSQ_SVAP_CODE (9)

Source Code Comments

SEVIS AUTO-POPULATE COLUMN CODE: Name of table column to be auto-populated.

Columns Comments for GORSVSQ_SVBA_CODE (10)

Source Code Comments

SEVIS BUSINESS ACTION CODE: Code of the business action to be executed.

Columns Comments for GORSVSQ_END_DATE (11)

Source Code Comments

END DATE: Date that the rule is no longer in effect.

Table GTVSQPA

Schema Name GENERAL
Label GTVSQPA
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSQPA_CODE GTVSQPA_CODE VARCHAR2(30) No *
GTVSQPA_DESC GTVSQPA_DESC VARCHAR2(60) No
GTVSQPA_DATA_TYPE_CDE GTVSQPA_DATA_TYPE_CDE VARCHAR2(1) No
GTVSQPA_START_DATE GTVSQPA_START_DATE DATE No
GTVSQPA_ACTIVITY_DATE GTVSQPA_ACTIVITY_DATE DATE No
GTVSQPA_USER_ID GTVSQPA_USER_ID VARCHAR2(30) No
GTVSQPA_END_DATE GTVSQPA_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSQPA Unique GTVSQPA_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GTVSQPA SYNONYM S4B70.PUBLIC Rely on ()
GORSQPA TABLE S4B70."GENERAL" Refer( No Action )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GTVSQPA.GTVSQPA.GTVSQPA_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GTVSQPA.GTVSQPA.GTVSQPA_CODE Use(select )
GORSQPA_RG Forms Record Group BANNER7_FORMS.GORRSQL Use(select )
GORSQPA_RG Forms Record Group BANNER7_FORMS_10G.GORRSQL Use(select )
GTVSQPA_RG Forms Record Group BANNER7_FORMS.GORSQPA Use(select )
GTVSQPA_RG Forms Record Group BANNER7_FORMS_10G.GORSQPA Use(select )
CHK_PARM_CODE Forms Function BANNER7_FORMS.GORSQPA Use(select )
CHK_PARM_CODE Forms Function BANNER7_FORMS_10G.GORSQPA Use(select )
GET_PARM_DESC Forms Function BANNER7_FORMS.GORSQPA Rely on () Use(select )
GET_PARM_DESC Forms Function BANNER7_FORMS_10G.GORSQPA Rely on () Use(select )
GTVSQPA_C Package cursor S4B70.BANINST1.GB_GTVSQPA Rely on ()
GTVSQPA_C Package cursor S4B70.BANINST1.GB_GTVSQPA Rely on () Use(select )
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSQPA Rely on ()
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSQPA Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSQPA Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSQPA Rely on ()
F_VALIDATE_SQL_RULE Package function S4B70.BANINST1.GOKRSQL Rely on ()
F_VALIDATE_SQL_RULE Package function S4B70.BANINST1.GOKRSQL Use(select )
GTVSQPA Forms DataBlock BANNER7_FORMS.GTVSQPA Rely on () Use(insert,update,delete,select )
GTVSQPA Forms DataBlock BANNER7_FORMS_10G.GTVSQPA Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GTVSQPA INDEX S4B70."GENERAL" Rely on ()

Comments

Source Code Comments

SQL Process Parameter Validation Table

Columns Comments for GTVSQPA_CODE (1)

Source Code Comments

PARAMETER CODE: Parameter code.

Columns Comments for GTVSQPA_DESC (2)

Source Code Comments

PARAMETER DESCRIPTION: Description of the parameter code.

Columns Comments for GTVSQPA_DATA_TYPE_CDE (3)

Source Code Comments

DATA TYPE INDICATOR: Indicates whether this parameter is (C)haracter, (N)umber or (D)ate.

Columns Comments for GTVSQPA_START_DATE (4)

Source Code Comments

START DATE: Date code became effective.

Columns Comments for GTVSQPA_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Columns Comments for GTVSQPA_USER_ID (6)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GTVSQPA_END_DATE (7)

Source Code Comments

END DATE: Date code became obsolete.

Table GTVSQPR

Schema Name GENERAL
Label GTVSQPR
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSQPR_CODE GTVSQPR_CODE VARCHAR2(30) No *
GTVSQPR_DESC GTVSQPR_DESC VARCHAR2(60) No
GTVSQPR_SYS_REQ_IND GTVSQPR_SYS_REQ_IND VARCHAR2(1) No
GTVSQPR_START_DATE GTVSQPR_START_DATE DATE No
GTVSQPR_ACTIVITY_DATE GTVSQPR_ACTIVITY_DATE DATE No
GTVSQPR_USER_ID GTVSQPR_USER_ID VARCHAR2(30) No
GTVSQPR_END_DATE GTVSQPR_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSQPR Unique GTVSQPR_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GTVSQPR SYNONYM S4B70.PUBLIC Rely on ()
GORRSQL TABLE S4B70."GENERAL" Refer( No Action )
GORSQPA TABLE S4B70."GENERAL" Refer( No Action )
GORSVSQ TABLE S4B70."GENERAL" Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.GORSVSQ.GORSVSQ.GORSVSQ_SQPR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GORSVSQ.GORSVSQ.GORSVSQ_SQPR_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GTVSQPR.GTVSQPR.GTVSQPR_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GTVSQPR.GTVSQPR.GTVSQPR_CODE Use(select )
GTVSQPR_RG Forms Record Group BANNER7_FORMS.GORSVSQ Use(select )
GTVSQPR_RG Forms Record Group BANNER7_FORMS.GORSQPA Use(select )
GTVSQPR_RG Forms Record Group BANNER7_FORMS_10G.GORSVSQ Use(select )
GTVSQPR_RG Forms Record Group BANNER7_FORMS_10G.GORSQPA Use(select )
GTVSQPR_RG Forms Record Group BANNER7_FORMS_10G.GORRSQL Use(select )
GTVSQPR_RG Forms Record Group BANNER7_FORMS.GORRSQL Use(select )
CHK_PROCESS_CODE Forms Function BANNER7_FORMS.GORSQPA Use(select )
CHK_PROCESS_CODE Forms Function BANNER7_FORMS.GORRSQL Use(select )
CHK_PROCESS_CODE Forms Function BANNER7_FORMS_10G.GORSQPA Use(select )
CHK_PROCESS_CODE Forms Function BANNER7_FORMS_10G.GORRSQL Use(select )
CHK_SYS_REQ_IND Forms Function BANNER7_FORMS.GTVSQPR Use(select )
CHK_SYS_REQ_IND Forms Function BANNER7_FORMS_10G.GTVSQPR Use(select )
GET_PROCESS_DESC Forms Function BANNER7_FORMS.GORSQPA Rely on () Use(select )
GET_PROCESS_DESC Forms Function BANNER7_FORMS_10G.GORRSQL Rely on () Use(select )
GET_PROCESS_DESC Forms Function BANNER7_FORMS.GORRSQL Rely on () Use(select )
GET_PROCESS_DESC Forms Function BANNER7_FORMS_10G.GORSQPA Rely on () Use(select )
GTVSQPR_C Package cursor S4B70.BANINST1.GB_GTVSQPR Rely on ()
GTVSQPR_C Package cursor S4B70.BANINST1.GB_GTVSQPR Rely on () Use(select )
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSQPR Rely on ()
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSQPR Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSQPR Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSQPR Rely on ()
GTVSQPR Forms DataBlock BANNER7_FORMS.GTVSQPR Rely on () Use(insert,update,delete,select )
GTVSQPR Forms DataBlock BANNER7_FORMS_10G.GTVSQPR Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GTVSQPR INDEX S4B70."GENERAL" Rely on ()

Comments

Source Code Comments

Validation entries for SQL Process Codes.

Columns Comments for GTVSQPR_CODE (1)

Source Code Comments

PROCESS CODE: Process code for dynamic SQL processing.

Columns Comments for GTVSQPR_DESC (2)

Source Code Comments

PROCESS CODE DESCRIPTION: Description of SQL process code.

Columns Comments for GTVSQPR_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: This field identifies whether or not this code is required by the system.

Columns Comments for GTVSQPR_START_DATE (4)

Source Code Comments

START DATE: Date code became effective.

Columns Comments for GTVSQPR_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: This field identifies the most recent date a record was created or updated.

Columns Comments for GTVSQPR_USER_ID (6)

Source Code Comments

USER ID: This field identifies the most recent user to create or update a record.

Columns Comments for GTVSQPR_END_DATE (7)

Source Code Comments

END DATE: Date code became obsolete.

Table GTVSQRU

Schema Name GENERAL
Label GTVSQRU
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSQRU_CODE GTVSQRU_CODE VARCHAR2(30) No *
GTVSQRU_DESC GTVSQRU_DESC VARCHAR2(60) No
GTVSQRU_SYS_REQ_IND GTVSQRU_SYS_REQ_IND VARCHAR2(1) No
GTVSQRU_START_DATE GTVSQRU_START_DATE DATE No
GTVSQRU_ACTIVITY_DATE GTVSQRU_ACTIVITY_DATE DATE No
GTVSQRU_USER_ID GTVSQRU_USER_ID VARCHAR2(30) No
GTVSQRU_END_DATE GTVSQRU_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSQRU Unique GTVSQRU_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GTVSQRU SYNONYM S4B70.PUBLIC Rely on ()
GORRSQL TABLE S4B70."GENERAL" Refer( No Action )
GORSVSQ TABLE S4B70."GENERAL" Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.GORSVSQ.GORSVSQ.GORSVSQ_SQRU_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GORSVSQ.GORSVSQ.GORSVSQ_SQRU_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GTVSQRU.GTVSQRU.GTVSQRU_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GTVSQRU.GTVSQRU.GTVSQRU_CODE Use(select )
GTVSQRU_RG Forms Record Group BANNER7_FORMS.GORSVSQ Use(select )
GTVSQRU_RG Forms Record Group BANNER7_FORMS.GORRSQL Use(select )
GTVSQRU_RG Forms Record Group BANNER7_FORMS_10G.GORSVSQ Use(select )
GTVSQRU_RG Forms Record Group BANNER7_FORMS_10G.GORRSQL Use(select )
CHK_RULE_CODE Forms Function BANNER7_FORMS.GORRSQL Use(select )
CHK_RULE_CODE Forms Function BANNER7_FORMS_10G.GORRSQL Use(select )
CHK_SYS_REQ_IND Forms Function BANNER7_FORMS.GTVSQRU Use(select )
CHK_SYS_REQ_IND Forms Function BANNER7_FORMS_10G.GTVSQRU Use(select )
GET_RULE_DESC Forms Function BANNER7_FORMS.GORRSQL Rely on () Use(select )
GET_RULE_DESC Forms Function BANNER7_FORMS_10G.GORRSQL Rely on () Use(select )
GTVSQRU_C Package cursor S4B70.BANINST1.GB_GTVSQRU Rely on ()
GTVSQRU_C Package cursor S4B70.BANINST1.GB_GTVSQRU Rely on () Use(select )
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSQRU Rely on ()
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSQRU Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSQRU Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSQRU Rely on ()
GTVSQRU Forms DataBlock BANNER7_FORMS.GTVSQRU Rely on () Use(insert,update,delete,select )
GTVSQRU Forms DataBlock BANNER7_FORMS_10G.GTVSQRU Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GTVSQRU INDEX S4B70."GENERAL" Rely on ()

Comments

Source Code Comments

Validation entries for SQL Rule Codes.

Columns Comments for GTVSQRU_CODE (1)

Source Code Comments

RULE CODE: Rule code for dynamic SQL rules.

Columns Comments for GTVSQRU_DESC (2)

Source Code Comments

RULE CODE DESCRIPTION: Description of dynamic SQL rule code.

Columns Comments for GTVSQRU_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: This field identifies whether or not this code is required by the system.

Columns Comments for GTVSQRU_START_DATE (4)

Source Code Comments

START DATE: Date code became effective.

Columns Comments for GTVSQRU_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: This field identifies the most recent date a record was created or updated.

Columns Comments for GTVSQRU_USER_ID (6)

Source Code Comments

USER ID: This field identifies the most recent user to create or update a record.

Columns Comments for GTVSQRU_END_DATE (7)

Source Code Comments

END DATE: Date code became obsolete.

Table GTVSVAP

Schema Name GENERAL
Label GTVSVAP
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSVAP_CODE GTVSVAP_CODE VARCHAR2(30) No *
GTVSVAP_DESC GTVSVAP_DESC VARCHAR2(60) No
GTVSVAP_SYS_REQ_IND GTVSVAP_SYS_REQ_IND VARCHAR2(1) No
GTVSVAP_START_DATE GTVSVAP_START_DATE DATE No
GTVSVAP_ACTIVITY_DATE GTVSVAP_ACTIVITY_DATE DATE No
GTVSVAP_USER_ID GTVSVAP_USER_ID VARCHAR2(30) No
GTVSVAP_END_DATE GTVSVAP_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSVAP Unique GTVSVAP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GTVSVAP SYNONYM S4B70.PUBLIC Rely on ()
GORSVSQ TABLE S4B70."GENERAL" Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.GORSVSQ.GORSVSQ.GORSVSQ_SVAP_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GORSVSQ.GORSVSQ.GORSVSQ_SVAP_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GTVSVAP.GTVSVAP.GTVSVAP_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GTVSVAP.GTVSVAP.GTVSVAP_CODE Use(select )
GTVSVAP_RG Forms Record Group BANNER7_FORMS.GORSVSQ Use(select )
GTVSVAP_RG Forms Record Group BANNER7_FORMS_10G.GORSVSQ Use(select )
CHK_SYS_REQ_IND Forms Function BANNER7_FORMS.GTVSVAP Use(select )
CHK_SYS_REQ_IND Forms Function BANNER7_FORMS_10G.GTVSVAP Use(select )
GTVSVAP_C Package cursor S4B70.BANINST1.GB_GTVSVAP Rely on ()
GTVSVAP_C Package cursor S4B70.BANINST1.GB_GTVSVAP Rely on () Use(select )
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSVAP Rely on ()
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSVAP Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSVAP Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSVAP Rely on ()
GTVSVAP Forms DataBlock BANNER7_FORMS.GTVSVAP Rely on () Use(insert,update,delete,select )
GTVSVAP Forms DataBlock BANNER7_FORMS_10G.GTVSVAP Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GTVSVAP INDEX S4B70."GENERAL" Rely on ()

Comments

Source Code Comments

Validation entries for SEVIS Auto-populate codes.

Columns Comments for GTVSVAP_CODE (1)

Source Code Comments

AUTO-POPULATE ELEMENT CODE: Name of element to be auto-populated.

Columns Comments for GTVSVAP_DESC (2)

Source Code Comments

AUTO-POPULATE ELEMENT CODE DESCRIPTION: Description of SEVIS auto-populate element code.

Columns Comments for GTVSVAP_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: This field identifies whether or not this code is required by the system.

Columns Comments for GTVSVAP_START_DATE (4)

Source Code Comments

START DATE: Date SEVIS auto-populate code starts.

Columns Comments for GTVSVAP_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: This field identifies the most recent date a record was created or updated.

Columns Comments for GTVSVAP_USER_ID (6)

Source Code Comments

USER ID: This field identifies the most recent user to create or update a record.

Columns Comments for GTVSVAP_END_DATE (7)

Source Code Comments

END DATE: Date SEVIS auto-populate code became obsolete.

Table GTVSVBA

Schema Name GENERAL
Label GTVSVBA
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSVBA_CODE GTVSVBA_CODE VARCHAR2(30) No *
GTVSVBA_DESC GTVSVBA_DESC VARCHAR2(60) No
GTVSVBA_SYS_REQ_IND GTVSVBA_SYS_REQ_IND VARCHAR2(1) No
GTVSVBA_DBPROC_NAME GTVSVBA_DBPROC_NAME VARCHAR2(100) No
GTVSVBA_START_DATE GTVSVBA_START_DATE DATE No
GTVSVBA_ACTIVITY_DATE GTVSVBA_ACTIVITY_DATE DATE No
GTVSVBA_USER_ID GTVSVBA_USER_ID VARCHAR2(30) No
GTVSVBA_END_DATE GTVSVBA_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSVBA Unique GTVSVBA_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GTVSVBA SYNONYM S4B70.PUBLIC Rely on ()
GORSVSQ TABLE S4B70."GENERAL" Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.GORSVSQ.GORSVSQ.GORSVSQ_SVBA_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GORSVSQ.GORSVSQ.GORSVSQ_SVBA_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GTVSVBA.GTVSVBA.GTVSVBA_CODE Use(select )
WHEN-VALIDATE-ITEM