Table - Main

Select Admin Menu > Table to view information about a table, define the fields whose changes should be audited, and to override a field's label on a specific table.

Description of Page

Description contains a brief description of the table.

System Table defines if the table holds rows that are owned by the base-package.

Enable Referential Integrity defines if the system performs referential integrity validation when rows in this table are deleted.

Data Group ID is used for internal purposes.

Table Usage defines how the table is used in the application. In the current release, only tables that are part of Oracle Utilities Business Intelligence make use of this field.

Table Type defines if the table is a View or a physical Table.

Date / Time Data Type defines if the system shows times on this table in Local Legal Time or in Standard Time (Local Legal Time is the time as adjusted for daylight savings).

Audit Table is the name of the table on which this table's audit logs are stored. Refer to The Audit Trail File for more information.

Use Audit Program Type to define if the audit program is written in Java or COBOL.

Audit Program is the name of the program that is executed to store an audit log. Refer to Turn On Auditing For a Table for more information.

• If the Program Type is COBOL, enter the name of the COBOL program.
• If the Program Type is Java, enter the Java class name.

Upgrade controls what happens to the rows in this table when the system is upgraded to a new release:

• Keep means that the rows on this table are not touched during an upgrade
• Merge means that the rows on this table are merged with rows owned by the base package
• Refresh means that the rows on this table are deleted and refreshed with rows owned by the base package.

Data Conversion Role controls if / how the table is used by the conversion tool:

• Convert (Retain PK) means that the table's rows are populated from the conversion schema and the prime key in the conversion schema is used when the rows are converted. A new key is not assigned by the system.
• Convert (New PK) means that the table's rows are populated from the conversion schema and the prime key is reassigned by the system during conversion.
• Not Converted means that the table's rows are not managed by the conversion tool.
• View of Production means that the conversion tool uses a view of the table in production when accessing the rows in the table. For example, the customer class table would be set up using this value so that the conversion tool will use the customer classes in production when it needs to access customer class codes.

A Language Table is specified when fields containing descriptions are kept in a child table. The child table keeps a separate record for each language for which a description is translated.

Enable Data Dictionary defines if the table is to be included in the Data Dictionary application viewer.

A Key Table is specified when the prime-key is assigned by the system. This table holds the identity of the prime keys allocated to both live and archived rows.

Type of Key specifies how prime key values are generated when records are added to the table:

• Other means a foreign-system allocates the table's prime-key (e.g., the fact and dimension tables within Oracle Utilities Business Intelligence have their keys assigned by Oracle Warehouse Builder).
• Sequential means a sequence number is incremented whenever a record is added to the table. The next number in the sequence determines the key value.
• System-generated means a program generates a random key for the record when it is added. If the record's table is the child of another table, it may inherit a portion of the random number from its parent's key.
• User-defined means the user specifies the key when a record is added.

Inherited Key Prefix Length defines the number of most significant digits used from a parent record's primary key value to be used as the prefix for a child record's key value. This is only specified when the Type of Key is System-generated and the high-order values of the table's key is inherited from the parent table.

Caching Regime determines if the table’s values should be cached when they are accessed by a batch process. The default value is Not Cached. You should select Cached for Batch if you know the values in the table will not change during the course of a batch job. For example, currency codes will not change during a batch process. Caching a table's values will reduce unnecessary SQL calls and improve performance.

Key Validation determines if and when keys are checked for uniqueness. The default value is Always Check Uniqueness. Select Check Uniqueness Online Only when the database constructs the keys in the table, such as in log tables. Select Never Perform Uniqueness Checking when you know that the database constructs the keys in the table and that users cannot add rows directly to the table, such as in log parameter tables. This will reduce unnecessary SQL calls and improve performance.

Help URL is the link to the user documentation that describes this table.

Help Text contains additional information about the table.

The grid contains an entry for every field on the table. Drilling down on the field takes you to the Table Field tab where you may modify certain attributes. The following fields may also be modified from the grid: Description, Override Label, Audit Delete, Audit Insert and Audit Update. Refer to the Table Field tab for descriptions of these fields.