Define a Data Model Table Query

You need to define several parameters in the table query you are adding to a form's data model.

*Table Query Parameters*
Parameter	Description
Workflow Type	Current Workflow: select a table from the current workflow. External Table: select any table from a different workflow or from outside Cora SeQuence. Cora SeQuence cannot modify the structure of external tables. New: define a new table.
Selected Table	The selected table's UACT name in the Cora SeQuence database.
Name	Define the query name of the table in the data model.
Key Name	Enter the table's primary key.
Secondary Key	Enter the table's secondary key. This is only relevant for Task Activities that have action items for recipients. If the activity is a task, you can use the secondary key to better control the data.
Connection String	Enter the connection string to the table. This is only relevant for external tables.

The table below indicates the database operations that Sequence can perform on UACT and external tables.

*Supported Database Operations*
Action/Table and Key	UACT - System Key	UACT - Any Key	UACT - No Key	External Table - Any Key	External Table - No Key
Select	V	Must supply key value	V	V	V
Insert	V	Key from UI	V	Key from UI	V
Update Single	V	Key from UI	V	Key from UI	V
Update Multiple	Has incremental key defined	UI should provide the Key Has incremental key defined	Has incremental key defined	Has incremental key defined	Has incremental key defined
Delete	V	X	X	X	X