User Defined Tables Menu

In this topic, we continue our discussion of the User Defined tab which is encountered when creating a New Submission.

In order to add an entry successfully, you must have already added a user defined table to your CIS database using Microsoft SQL Server or Microsoft SQL Server Management Studio. If you need assistance adding a user defined table, please contact AIM Product Support.

We recommend that you consult with your AIM system administrator before adding new table entries. In most cases, you should be editing an existing entry to add user defined information to a submission using user defined tables.

In the following table, we discuss the buttons in the User Defined Tables Menu dialog box.

Button	Function
	Add a new user defined table entry
	Edit the selected record
	Save changes to the record and close the dialog box
	Abandon changes without saving and close the dialog box

1. Click Add to add a new user defined table entry.
2. In the Add Detail Record dialog box, enter the following information in the appropriate boxes.
   1. Description – description of the table entry
   2. User Table – name of the user defined table that you created and to which you are adding an entry
   3. Record Type – additional description field in the user-defined table
   4. TableDisplayName – the name of the table to be displayed
   5. ActiveFlag – flag Y/N indicates whether the table is active
   6. Comments – comments relevant to the table entry
   7. CreatedByID – user ID or name of the person creating the entry
   8. Date Added – entry creation date (Click to use the Calendar.)
   9. DateModified – date on which the entry was last modified
   10. ModifiedByID – name or user ID of the person that last modified the entry
   11. TableID_SK – super key value (Associated with a user-defined table.)
   12. PrimaryKeyName – name of the primary key field (Typically, the value 'RecordKey_PK' is entered for user-defined tables.)

To edit an existing table entry for a submission, click Edit.

3. In Add Detail Record, enter the information requested. The contents of the dialog box varies depending on which fields are added to the user defined table.

See Also