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.