Prompt Map

The Prompt Map tab on the Events form allows you to map event prompt input data to a database table and column where the data can be read more easily and can be used for reporting purposes.

On the Prompt Map tab, you define a Semantic Name for one or more of the event’s prompts; these prompts are defined on the Prompt tab of the Events form. Semantic Name identifies a column name in the semantic_map table. The semantic_map table maps prompt input data to a database table and column. For example, if you choose the Semantic Name “Order Num,” the prompt input data will be placed in the order_num field of the trans_action_data table.

See Also:

Prompt Map Field Descriptions

View a Prompt Map

Add a Prompt Map

Modify a Prompt Map

Delete a Prompt Map

 

Prompt Map Field Descriptions

Semantic Name

Identifies a column name in the semantic_map table. The semantic_map table is used to map prompt input data to a database table and column where the data can be read more easily and can be used for reporting purposes. For example, if you choose the Semantic Name “Order Num,” the prompt input data will be placed in the order_num field of the trans_action_data table.

Prompt Name

Identifies the configured Event Prompt. The event prompts is configured on the Prompt tab.

System Required

If this box is checked, the record is system required and cannot be deleted.

Update Date, Updated By

These fields display when the record was created or updated, and the person who created or updated the record.

 

View a Prompt Map

  1. Click Main Menu > Configuration > Event > Events.

  2. Select the record you want to view.

  3. Go to the Prompt Map tab on the lower half of the form to view the details.

 

Add a Prompt Map

  1. Click Main Menu > Configuration > Event > Events.

  2. Select the record you want to which you want to add a Prompt Map record.

  3. Go to the Prompt Map tab on the lower half of the form.

  4. Click Add.

  5. Select a Semantic Name from the drop-down menu.

  6. Select a Prompt Name from the drop-down menu.

  7. Click Save.

 

Modify a Prompt Map

  1. Click Main Menu > Configuration > Event > Events.

  2. Select the record that contains the Event Prompt Map record you want to modify.

  3. Go to the Prompt Map tab on the lower half of the form.

  4. Select the record you want to modify and click Modify.

  5. Modify the record and click Save.

 

Delete a Prompt Map

  1. Click Main Menu > Configuration > Event > Events.

  2. Select the record that contains the Prompt Map record you want to delete.

  3. Go to the Prompt Map tab on the lower half of the form.

  4. Select the record you want to delete and click Delete.

  5. Click OK to confirm the action.