Tables - 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.
Tables Object View - Main
Tables Object View - Main
Description of Page
Note:Many fields cannot be changed. You cannot change most attributes on tables that are owned by the base-package (in other words those whose Owner is not Customer Modification).
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. 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 Java, enter the Java class name.
Note:View the source. If the program is shipped with the base package, you can use the adjacent button to display the source code of this program in the source viewer or Java docs viewer. For details, see "Source Code Viewer" and "Java Docs Viewer" sections in the Oracle Utilities Application Framework Administration Guide.
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 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.
Help URL is the link to the user documentation that describes this table.
Special Notes contains any notes or special 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.