Activities Database Tables
To create and maintain activities list, you use the following database tables:
- The RDC_ACTIVITIES database table, which contains the setup information for all the activities defined for the RDC application
- The RDC_ACTIVITIES_TAGS database table, which contains the tags that call the functions that provide values for a text string, a display expression, or a URL
The following sections provide more information about each table:
RDC_ACTIVITIES Database Table
The Oracle Clinical RDC_ACTIVITIES database table contains the setup information for all the activities defined for the RDC application. You can add new activities, modify existing activities, and delete activities.
Note:
The database table includes the default activities listed in Table 10-1.Each field (that is, column) defines the values for an activity. Table 10-1 describes each column in the RDC_ACTIVITIES database table.
Table 10-1 RDC_ACTIVITIES Database Table
Column Name | Description | Type (Max Length) |
---|---|---|
|
Specifies for which user roles RDC displays the activity. Each user logging in to RDC is associated with only one role. You can use the user role to control which activities RDC displays when the user logs in to the application. You can specify:
For example, assume you define the following activities and user roles:
For this example, RDC displays:
The user role is not the only value that controls when RDC displays an activity. The value defined in the DISPLAY_EXPR column defines the condition that must be meet for RDC to display the activity. See the DISPLAY_EXPR description later in this table for more information. |
VARCHAR2 (50) |
|
Specifies the title of the activity. This is the title the user sees in the RDC application. Examples of title text:
You must specify the TEXT value in English. RDC currently only supports English. The TEXT value can contain one or more tags. A tag provides variable
information, such as the site name, a count of records, or a refer
function. You use % signs to enclose a tag. For example,
When you specify a tag in the TEXT column, RDC processes the tag as follows:
For example, assume the TEXT column has the following line:
For this example, the resulting title in the RDC application might be:
You can also customize the return value of the function to take into account the applicable site. |
VARCHAR2 (200) |
|
Provides a unique key for the activity. |
Number (10) |
|
Defines the type of activity.
|
VARCHAR2 (15) |
|
Defines the scope in which the activity is eligible for display. The possible values for For RDC (4.5.3 and later),
|
VARCHAR2 (15) |
|
Defines what task RDC executes when the user clicks the activity link. The value you specify depends on the type of activity you are creating. If the
If the U = https://company.com/v_rsdir/study%CURR_STUDY%.htm U = https://opa.apps.company.com/v_rsdir/rdcservlet?study=%CURR_STUDY%&site=%CURR_SITE% For these URL examples, you must create the study specific Web pages or a servlet that accepts study and site as parameters. See Creating and Maintaining Customized Activities for more information. |
VARCHAR2 (200) |
|
Defines the condition that determines whether RDC displays the activity link. You can enter no value (null) or you can specify a conditional display expression associated with the activity. The expression can include tags. The expression must return a true or false value. Based on the value in the column, RDC determines whether to display the activity.
You use the %BLANK_COUNT%>0 %OPEN_DISCREPS%>0 %ZF_OTHER_DISC%>0 %ZF_OPEN_DISC%>0 |
VARCHAR2 (200) |
Parent topic: Activities Database Tables
RDC_ACTIVITY_TAGS Database Table
The RDC_ACTIVITY_TAGS database table contains the tags that are defined in the system and the execution module (function name) that evaluates the tag.
The following list describes the columns in the RDC_ACTIVITY_TAGS table.
Column Name | Description | Type (Max Length) |
---|---|---|
|
Defines the tag that you can then specify in the following columns in the RDC_ACTIVITIES database table:
When RDC finds a tag in a column, RDC then searches through the values in the ACTIVITY_TAG column looking for a match for the tag.
When each of these columns is parsed, if a TAG is found, the process searches this column to find the TAG match so that it can identify the code or substitution variable to display in place of the TAG. If a match is found, it processes the expression found in the |
VARCHAR2 (15) |
|
Defines the type of function specified in the FUNCTION_NAME column.
|
VARCHAR2 (15) |
|
Defines either the name of the substitution variable or the name of the function in the system. Depending on the FUNCTION_TYPE value, the value in this column can be one of several types.
|
VARCHAR2 (61) |
Parent topic: Activities Database Tables