Step 5: Define Master Index Code Lists

You only need to perform this step if you defined any fields in the object structure to have a code module. The SQL script for entering processing codes and descriptions into the database is written in PL/SQL. The Code List file contains a stanza for each type of common table data element for which you use processing codes. You can create additional common table data types and additional common table data elements. This script inserts data into two tables: sbyn_common_header, which lists the types of common table data, and sbyn_common_detail, which lists each common table data element. Before you begin this step, complete Step 4: Define Master Index External Systems.

Note - The codes you specify in this file can be no longer than eight characters (the codes are the second value in the value list for each common table data type and data element).

To Customize Common Table Data for Oracle

1. Under the master index project in the Projects window, expand Database Scripts and then open the Code Lists file in the NetBeans editor.
2. Scroll to the following line.

   codes tCodeList := tCodeList(

   The statements following this line can be customized.

3. Add or modify the elements of each stanza as needed. A sample stanza is shown below.

   -- **** PHONTYPE **** tCode(’L’, ’PHONTYPE’, ’TELEPHONE TYPE’), tCode(’V’, ’H’, ’HOME’), tCode(’V’, ’M’, ’MOBILE’), tCode(’V’, ’F’, ’FAX’), tCode(’V’, ’O’, ’OFFICE’),

   Note - Do not modify the “L” or “V” in each row. These characters define whether the information is inserted into the sbyn_common_header (L) or sbyn_common_detail (V) table. Following the table indicator is the processing code, and the final item in each row is a description. The descriptions appear on the Patient EDM and should be kept short.

4. In the last code module stanza, make sure each line except the last contains a comma at the end.

   For example:

   -- **** ADDRTYPE **** tCode(’L’, ’ADDRTYPE’, ’ADDRESS TYPE’), tCode(’V’, ’H’, ’HOME’), tCode(’V’, ’B’, ’BUSINESS’), tCode(’V’, ’M’, ’MAILING’)

5. Save and close the file.
6. Do one of the following:
   • If you need to define user code lists, continue to Step 6: Define Master Index User Code Lists.
   • If you need to create a custom database script, skip to Step 7: Create Custom Master Index Database Scripts.
   • If you are ready to create the master index database structure, skip to Step 8: Create the Master Index Database Structure.

To Customize Common Table Data for SQL Server

1. Under the master index project in the Projects window, expand Database Scripts and then open the Code Lists file in the NetBeans editor.
2. Scroll to the following line.

   begin

   The statements following this line can be customized.

3. Add or modify the elements of each stanza as needed. A sample stanza is shown below.

   -- **** PHONTYPE **** insert into @codelist values(’L’, ’PHONTYPE’, ’TELEPHONE TYPE’), insert into @codelist values(’V’, ’H’, ’HOME’), insert into @codelist values(’V’, ’M’, ’MOBILE’), insert into @codelist values(’V’, ’F’, ’FAX’), insert into @codelist values(’V’, ’O’, ’OFFICE’),

   Note - Do not modify the “L” or “V” in each row. These characters define whether the information is inserted into the sbyn_common_header or sbyn_common_detail table. Following the table indicator is the processing code, and the final item in each row is the description that appears on the Patient EDM. The descriptions should be kept short.

4. Save and close the file.
5. Do one of the following:
   • To define user code lists, continue to Step 6: Define Master Index User Code Lists.
   • To create a custom database script, skip to Step 7: Create Custom Master Index Database Scripts.
   • To create the master index database structure, skip to Step 8: Create the Master Index Database Structure.