ApplicationsEdit Columns in a Cross Reference Table

After you Create a Cross Reference Table, you can add, delete, and reorder columns in the table, as well as edit column names and types, using the Edit Columns page of the XrefAdminApplication. To edit data in a cross reference table, see Edit Data in a Cross Reference Table.

Tip: For assistance with cross reference table applications or to have Loftware create a custom cross reference table application for you, contact Loftware's Professional Services Group.

To access the Edit Columns page of the XrefAdminApplication, perform the following steps:

  1. In Applications , open the Cross Reference Table App folder and select the XrefAdminApplication.
  2. Under Table Actions, click Edit Columns.
  3. Under Edit Columns, select a table from the drop-down list. The DisplayOrder, ColumnName, and DataType for each column in the table are displayed and you can now Reorder a Column, Add a Column, Edit a Column Name, Change a Column Type, and Delete a Column.

Reorder a Column

To reorder a column in a cross reference table, perform the following steps:

  1. On the Edit Columns page of the XrefAdminApplication, select a table from the drop-down list. The columns in the table are displayed.
  2. Under Reorder Columns, select the row of the column you want to reorder, and then click Up or Down as needed. The display order of the column is modified.

Add a Column

To add a column to a cross reference table, perform the following steps:

  1. On the Edit Columns page of the XrefAdminApplication, select a table from the drop-down list. The columns in the table are displayed.
  2. Under Add a Column, enter a name for the column.

    Important! Avoid using any Oracle Database Reserved Words for table or column names. Cross reference table and column names can include uppercase and lowercase alphanumeric characters only.

  3. Select a data type for the column from the Type drop-down list:
    TypeDescription

    String

    A column of this type contains text strings. Any number included is treated as text.

    Number

    A column of this type contains signed decimal values.

    Date/Time

    A column of this type contains date and time values in the format:

    yyyy/MM/dd hh24:mi:ss (year, month number, two-digit date, hour, minutes, seconds in 24-hour format) .

    Example

    2017/01/04 13:43:28

  4. Click Add. A message is displayed confirming the column has been added.

You can now add data to the table. For more information, see Edit Data in a Cross Reference Table.

Edit a Column Name

To edit a name of a column in a cross reference table, perform the following steps:

  1. On the Edit Columns page of the XrefAdminApplication, select a table from the drop-down list. The columns in the table are displayed.
  2. Under Edit Column, select a column from the drop-down list.
  3. Enter the new column name in the New Name field, and then click Rename. The new column name is displayed.

    Important! Avoid using any Oracle Database Reserved Words for table or column names. Cross reference table and column names can include uppercase and lowercase alphanumeric characters only.

Change a Column Type

To change a type of column in a cross reference table, perform the following steps:

Note: You can only change a column type if the column does not contain data.

  1. On the Edit Columns page of the XrefAdminApplication, select a table from the drop-down list. The columns in the table are displayed.
  2. Under Edit Column, select a column from the drop-down list.
  3. Select the new data type from the Type drop-down list, and then click Change Type. The new column data type is displayed.

Encrypt a Column

The Encrypt and Decrypt buttons are only available if Loftware Enterprise SP has been configured for GDPR compliance.

  1. On the Edit Columns page of the XrefAdminApplication, select a table from the drop-down list. The columns in the table are displayed.
  2. Under Edit Column, select a column from the drop-down list.
  3. Click Encrypt. The new column data type is displayed.

Delete a Column

To delete a column in a cross reference table, perform the following steps:

Important! If you delete a column, all data in the column is also deleted.

  1. On the Edit Columns page of the XrefAdminApplication, select a table from the drop-down list. The columns in the table are displayed.
  2. Under Delete Column, select a column to delete from the drop-down list.
  3. Click Delete. The deleted column is no longer displayed.