Editing the TMA Data Table

The TMA Data Table page allows system administrators to customize the fields and inputs for entering and displaying TMA core, block and spot image records. The table below lists commonly used TMA fields, input criteria, and formatting instructions. The columns listed are examples only.  You can modify any default or existing data type, display order, and value by deleting, renaming or hiding the display, and you can add new data columns with user-defined fields. For a typical TMA installation, you will probably want to use at least some of the default data fields and types.

 

Column Name (no spaces)

Examples of typical column names: ID, BlockId, CreatedBy, CreatedDate, Comment, Status, DataGroupId

Data Types

Text (alphanumeric, appears in lists and search results), Memo (does not appear in lists and is not searchable, less restricted on length than text) Date (must follow a user-defined date format, such as mm-dd-yyyy or dd-JUN-yy), Foreign (external identifier), Identification (system generated unique identifier), Special (user defined)

Order

The order in which a field is displayed. Select from drop-down list (values are 1-29 or Not Visible). Note: If numbers 1-15 are assigned to data columns and you select 28 from the list as the display order for a new data column, eSlide Manager will put it at the end of the list, but will automatically increment the numbers in use by one.  Thus, it will be assigned a value of 16 rather than 28.  If you want to display a new data column in the middle in the columns and assign it an order of 7, the existing order values of 7 through 15 will be incremented by one.

Display Name

This is the name that users will see for the columns unless you have specified that they are Not Visible. The column name cannot contain spaces, but the display name can.

Access Audit

If the Compliance module is licensed, you can choose which fields in the data table to audit for user access. (Access Auditing must be enabled in the Compliance section of the System Settings page.)

Vocabulary

This field can be used to limit valid input values to those you specify. Invalid inputs will be rejected.  Inputs entered must be separated by a pipe (|) character. To begin with a blank selection box, use a pipe symbol before the first entry in the vocabulary list.