Navigate using
.Description of Page
Table Name is the identifier of this table.
Description contains a brief description of the table.
System Table defines if the table includes rows that are owned by the base product.
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 is not in use at this time.
Table Type defines if the table is an External Table, 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 Local Standard Time Local Legal Time is the time as adjusted for daylight savings / summer time.
Table Classification Type specifies the category of data the table will hold. This is for information purposes only and is not used by any system processing. Valid values are Admin System Table, Admin Non System Table, Master Table, Transaction Table, and Unclassified.
Table Volume Type specifies the expected amount of data the table will hold. This is for information purposes only and is not used by any system processing. Valid values are High Volume, Low Volume, Medium Volume, and Unclassified. The volume of data in a particular table in the system may differ greatly from one implementation to another based on unique business requirements. The values populated for base product tables are set to volumes that are typical but may not be true for a given implementation. The value may be updated to reflect the situation for a given implementation.
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 Java (Converted), meaning it was converted into Java.
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.
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 product
Refresh means that the rows on this table are deleted and refreshed with rows owned by the base product.
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. This is commonly used for administrative tables.
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.
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.
Java Table Name. This field is used to identify the entity/Java class name of the class that represents the table in the Java code. It should contain a short "camelCased" name to be used as the name of the entity within the system. It must also be a valid Java name, and must be unique across the system. This name is used as follows:
As the short class name on all classes in the Java hierarchy for the class: the Impl class, the Gen, and the interface.
In HQL queries, it is used to identify the hibernate entity being selected.
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.
Extract for Translation is only visible in a development environment. It indicates whether or not the table includes strings that are eligible for product translation.
Translation Context is only visible in a development environment. It is used to provide information to a translator about the nature and purpose of rows in 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.
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]