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.