Create a New Custom Table

Activity Steps

  1. On the Home screen, select the Custom Tables module.

    The Table Type window displays.

  2. Set the Table Type to Custom.

  3. On the toolbar, click New.

    The User Defined Table window displays.

  4. Enter the Table Name.

    Note: The table name is automatically prefixed with UDEF_.

  5. Add Comments to describe the new table if required.
  6. Enter a Tab Title for the table. This is the title that is displayed on the tab for the table.
  7. Select the required core Template for the table.

    Note: There are two Oriented Core (OC) templates. Both have the same default columns that are required for OC calculations. Additionally, there are two templates that match the table structure used in Core Profiler (CP).

    • OC-All—Uses survey records of all types in the OC calculations.
    • OC-Ranked—Uses only the survey records that have the highest ranking test type.
    • CP Core—Columns match those in Core Profiler's core units table.
    • CP Defects—Columns match those in Core Profiler's defects table.
  8. Select the table Style from:
    • Form
    • Grid—The default, recommended style setting. Displays table as a grid format.
    • Drill Hole
  9. Select the Relationship of the table from:
    • Drill Hole—Capture drill hole related data.
    • Interval—Link to major or minor intervals and have depth constraints.
    • Sample Station—Capture sample related data.
    • Standalone—Available only on in a Central database.
  10. Select whether to Allow Overlaps, Allow Duplicates and Allow Gaps.

    Note: If a table allows overlaps, duplicates and gaps, the table has no default columns. If the table does not allow overlaps, duplicates and gaps, the default columns Depth_From and Depth_To are created.

  11. Select whether Data must start at zero.
  12. Select whether to Create Default Row. This is an interval-related table setting. When major or minor intervals are added, a new row is added to the table with the same depths.

    Note: In Sample Station UDEF tables only, Business Unit preferences may override these settings because DHLogger now shows List and Form, and Standalone Tables are GRID only.

  13. Click OK.

    Note: At this point, the table is defined, but not yet created. Column definitions must be added to finish creating the table.