JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Java CAPS Master Index Processing Reference     Java CAPS Documentation
search filter icon
search icon

Document Information

Oracle Java CAPS Master Index Processing Reference

Understanding Operational Processes

The Database Structure

About the Database

Database Table Details

SBYN_OBJECT_NAME

SBYN_OBJECT_NAMESBR

SBYN_CHILD_OBJECT

SBYN_CHILD_OBJECTSBR

SBYN_APPL

SBYN_ASSUMEDMATCH

SBYN_AUDIT

SBYN_COMMON_DETAIL

SBYN_COMMON_HEADER

SBYN_ENTERPRISE

SBYN_MERGE

SBYN_OVERWRITE

SBYN_POTENTIALDUPLICATES

SBYN_SEQ_TABLE

SBYN_SYSTEMOBJECT

SBYN_SYSTEMS

SBYN_SYSTEMSBR

SBYN_TRANSACTION

SBYN_USER_CODE

Sample Database Model

Working with the Java API

Inbound Message Processing with Custom Logic

A.  Match Types and Field Names

Sample Database Model

The diagrams on the following pages illustrate the table structure and relationships for a sample master index Oracle database designed for storing information about companies. The diagrams display attributes for each database column, such as the field name, data type, whether the field can be null, and primary keys. They also show directional relationships between tables and the keys by which the tables are related. This diagram is very similar to SQL Server, with the exception of a few column name changes and some different data types as noted in the tables above.

image:Diagram shows a sample database structure for a master index application (along with the following two diagrams).image:Diagram shows a sample database structure for a master index application (along with the previous and following diagrams).image:Diagram shows a sample database structure for a master index application (along with the previous two diagrams).