Because the Stage is the root staging table for all data mapping, it is the first element to build when configuring an integration.
  • Navigate to System Definition > Tables > New.

  • At the top of the new table record, the following fields are the first to be configured:

# Field Description Value
1 Label The display name for this table that can be localized. < Your Unique Label >
2 Name The internal name of the table that cannot later be changed. < u_your_unique_name >
3 Extends table Table this table inherits fields from. ‘Stage’ [x_snd_eb_stage]
4 Create module Creates a module in the Application Navigator. < checked >
5 Add module to menu The name of the Application menu to add the module to. ‘[ws] Unifi’

Your form should look something like this:

Stage Table Fields

  • Do not click ‘Submit’ (there are more fields to configure on the form first):

‘Controls’ Tab Fields

  • Click on the ‘Controls’ tab & configure the following fields:
# Field Description Value
1 Create access controls Select to automatically create basic access controls rules for this table. < checked >
2 User role Role required for end users to access this table. ‘itil’

Your tab should look like the one pictured below:

Stage Table Controls

‘Application Access’ Tab Fields

  • Click on the ‘Application Access’ tab & configure the following fields:
# Field Description Value
1 Accessible from Choose whether just this, or all application scopes have access to this table. ‘All application scopes’
2 Can read Allow other application scopes to run scripts that read data from this table. < checked >
3 Can create Allow other application scopes to run scripts that create data in this table. < checked >
4 Can update Allow other application scopes to run scripts that update data in this table. < checked >
5 Can delete Allow other application scopes to run scripts that delete data from this table. < checked >
6 Allow access to this table via web services Flag to determine if web service calls can be made to this table. < checked >
7 Allow configuration Allow design time configuration of this table from other application scopes. < checked >

The ‘Application Access’ tab should look like this:

Stage Table Application Access

‘Columns’ Tab Fields

  • Lastly, (before we click ‘Submit’), we are now ready to add the fields that will map to the table/fields we are integrating with.

Note: Ordinarily, you will add as many columns as is appropriate to suit the requirements of your integration. In this guide, however, we are configuring a basic Incident integration as an example, so we will create the following columns on our table:

# Column Label Column Name Type Max Length
1 Caller ID u_caller_id String 40
2 Short description u_short_description String 160
3 Description u_description String 4000
4 Category u_category String 40
5 State u_state String 40
6 Impact u_impact String 40
7 Urgency u_urgency String 40
8 Priority u_priority String 40
9 Worknotes u_worknotes String 4000
10 Comments u_comments String 4000
  • Now click ‘Submit’.

You should see the newly created columns on the record (see image below):

Stage Table Columns

Note: This list has been sorted to display by Column label order.

Next, we shall go on to configure the Process.