You can use the Inventory of Table and Fields workspace to add, view, edit, duplicate and delete the tables and fields in the Eagle data model.

Create New Tables and Fields

You can create new tables and fields in the Inventory of Table and Fields workspace.

To create a new table in the Inventory of Tables and Fields:

1. In the Setup workspace, in the left navigation, click Inventory of Tables and Fields.
   You see the Inventory of Fields workspace with the list of available database tables.
2. Click Create New and then select Table.
   You see the Create New Table dialog box.
3. Select the Database Name by typing in the field or selecting it from the drop-down list.
4. In the Table Name box, enter a name for the table.
5. Select an Indicator from the drop-down list.
6. Click Save.

To create a new field in the Inventory of Tables and Fields:

1. In the Setup workspace, in the left navigation, click Inventory of Tables and Fields.
   You see the Inventory of Fields workspace with the list of available fields.
2. Click Create New and then select Field.
   You see the Create New Field dialog box.
3. Select the Database Name by typing in the field or selecting it from the drop-down list.

4. In the Table Name box, enter a name for the table.

   Note

   If the Table Indicator field is V (virtual) the Database and Table Name fields are disabled for editing.

5. In the Column/Field Name box, enter a name for the Column/Field.
6. Enter a Description for the field in the description box.
7. Optionally, select to use this as the Update User field or Updated Date Field by clicking the appropriate checkbox.
8. Select the Storage Type from the drop-down list. If you select storage type String or Wide you must then enter the Size.
9. Indicate if you would like the field to be Shown in editing screens, Make required or Show as read only by clicking on the  corresponding check box.
10. Enter the XML tag for the field.
11. Select a Reference Field from the drop-down list.
12. Enter the Eagle Star tag.
13. Select a Lookup Type from the drop-down list. Options include:
    –  None
    –  Underlying Security
    –  Issuer
    –  Entity
    –  Business Calendar
    –  Source
14. Click Add.
15. Click Save All.

View/Edit Tables and Fields

You can view and edit the current list of tables and fields in the Inventory of Table and Fields workspace.

To view/edit tables in the Inventory of Tables and Fields:

1. In the Setup workspace, in the left navigation, click Inventory of Tables and Fields.
   You see the Inventory of Fields workspace with the list of available database tables.
2. To view tables only, under View, click Tables.
   You see a list of available database tables.
3. To edit a table, select the table you want to edit, and then click Edit.
   You see the Edit table dialog box.
4. Select the Database Name from the drop-down list.
5. You can edit the Table Name by entering a new name in the Table Name box.
6. Select an Indicator from the drop-down list.
7. Click Save.
   You see the revised table listed in the Inventory of Tables and Fields workspace.

To view/edit fields in the Inventory of Tables and Fields:

1. In the Setup workspace, in the left navigation, click Inventory of Tables and Fields.
   You see the Inventory of Fields workspace with the list of available database tables.
2. To view fields only, under View, click Fields.
   You see a list of available fields.
3. To edit a field, select the field you want to edit, and then click Edit.
   You see the Edit field dialog box.

4. Edit the Column/Name field.

5. You can click on the Description box and update the field description.

6. Select a Storage Type from the drop-down list.

7. You can click on the XML Tag box and update the XML tag.

8. Select a Reference field from the drop-down list or by clicking on to use Advanced Search.

9. You can click on the Eagle Star Tag box and enter an Eagle Star tag.

10. Select a Lookup Type from the drop-down list. Options include:
    –  None
    –  Underlying Security
    –  Issuer
    –  Entity
    –  Business Calendar
    –  Source

11. Click Save All.
    You see the revised field listed in the Inventory of Tables and Fields workspace.

Duplicate Tables and Fields

You can duplicate tables and fields in the Inventory of Table and Fields workspace.

To duplicate tables/fields in the Inventory of Tables and Fields:

1. In the Setup workspace, in the left navigation, click Inventory of Tables and Fields.
   You see the Inventory of Fields workspace with the list of available database tables.
2. Select the table or field that you want to duplicate.
3. Click Duplicate.
   You see the Create New Table /Create New Field dialog box
4. Update the fields following the steps outlined in Create New Tables and Fields.
5. Click Save.
   You see the revised table/or field listed in the Inventory of Tables and Fields workspace.

Delete Tables and Fields

You can delete tables and fields in the Inventory of Table and Fields workspace.

To delete tables/fields in the Inventory of Tables and Fields:

1. In the Setup workspace, in the left navigation, click Inventory of Tables and Fields.
   You see the Inventory of Fields workspace with the list of available database tables.
2. Select the table or field that you want to delete.
3. Click Delete.
   You see the Create New Table /Create New Field dialog box
4. Update the fields following the steps outlined in Create New Tables and Fields.
5. Click Save.
   The table/field is deleted from the system.