Configuring the Oracle Argus Affiliate System Numbering

The system provides the ability to use multiple case numbering schemes for globally. For example, if site is used in the numbering, the system provides the option to keep separate sequences for each site. However, Oracle Argus Affiliate System Numbering configuration can only be done from Oracle Argus Safety application. Therefore, to configure the Oracle Argus Affiliate System Numbering, the Administrator must be logged on to Oracle Argus Safety application, and the System Numbering menu and the Local Affiliate sub-menu must be enabled in the User Group.

Select Argus Console > System Configuration > System Numbering > Local Affiliate to view the Oracle Argus Affiliate System Numbering screen. The following is an illustration of the LAM System Numbering page.

LAM System Numbering screen

The following table lists and describes the fields on the LAM System Numbering page.

Field Description

Manually Number Cases

The option enables the user to manually number the cases on booking or while copying the case, using the "save as" option on the case form.

Automatically Number Cases

On selection, the system automatically numbers the cases as defined by the user in the numbering format.

Start at

Enables the user to initialize the counter of the sequence number.

Separate sequence for each site

Enables the user to separate the sequence numbering for cases on site by site basis. If there are cases being entered from two different sites then each site will have different sequencing of case numbers.

Separate sequence for each report type

Enables the user to separate the sequence numbering for cases by the report type of the case.

Separate sequence for each year

Enables the user to reset the sequence numbering for cases after each year, based on the initial receipt date of the case.

Separate sequence for each month

Enables the user to reset the sequence numbering for cases after each month, based on the initial receipt date of the case.

Separate sequence for each product abbreviation

Enables the user to reset the sequence numbering for cases for each different product abbreviation.

Numbering Format

Enables the user to select the numbering format by selecting the different placeholders.

Define the numbering format by typing in custom keywords to print on every case number & selecting different placeholders.

[YY][MM]-[###] is the default format.

Placeholder

Enables the user to enter a placeholder.

Placeholders are used to pickup values from the database to be used in the Case numbering format.

The possible values populated in this list are:

  • . # -- Number: defines the digits to be used as the sequence number in the format. The field is used to display the sequence number on the case numbers.
  • CC-- Country code: When selected, this uses the A2 code for the country of incidence for the case number.
  • DD -- Day: When selected, this uses the date of the "Initial receipt date" field of the case.
  • MM -- month: When selected, this uses the month of the "Initial receipt date" field of the case.
  • P -- When selected, this uses either of the two values:
    1. If report type is "Spontaneous" or " other" during booking: the system uses the value of the "Product Abbreviation" field specified in the Product configuration for the selected Primary suspect product.
    2. If report type is of the type "report from study" during booking: the system uses the "Product Abbreviation" field specified in the study configuration.
  • SSS -- User Site: When selected this uses the Site abbreviation of the site belonging to the user who booked in the case
  • TTT -- Report Type: When selected this uses the report type abbreviation of the report type selected during bookin of the case
  • YY -- Year: When selected, this uses the year of the "Initial receipt date" field of the case.

To Configure Oracle Argus Affiliate system numbering:

  1. Select the Numbering feature as required. This can be manual numbering or automatic numbering of cases.
  2. Select the Sequencing Options as required.
  3. Select the Numbering Format. Use Placeholders to enter the required format.

    To customize the Numbering Format, use the placeholder values.

    Example: To select Country Code, Month and Year (as values to be incorporated from the database) as the Case numbering format, execute the following steps.

    1. Click on Country Code. This appears in the Numbering Format field.
    2. Click on Month. This appears in the Numbering Format field next to the Country Code.
    3. Click on Year. This appears in the Numbering Format field next to the Country Code and Month.
    4. The final data listed in the Numbering Format field is the Case Numbering Format.
  4. Click Save to save the changes made.