Do one of the following:
Scroll to the first line that begins with “— **** “.
The statements following this line must be customized.
In the first code list stanza, change “module description” in the first line to a brief description of the code type.
For example:
-- **** PHONTYPE **** insert into tCodeList values(’L’, ’PHONTYPE’, ’TELEPHONE TYPE’); |
Create the entries for that module using the following syntax:
insert into tCodeList values(’V’, ’code’, ’code description’); |
where “code” is the processing code of the data element and “code description” is the description of the element as you want it to appear on the Master Index Data Manager windows. For example:
-- **** PHONTYPE **** insert into tCodeList values(’L’, ’PHONTYPE’, ’TELEPHONE TYPE’); insert into tCodeList values(’V’, ’H’, ’HOME’); insert into tCodeList values(’V’, ’C’, ’CELL’); insert into tCodeList values(’V’, ’F’, ’FAX’); insert into tCodeList values(’V’, ’O’, ’OFFICE’); insert into tCodeList values(’V’, ’HB’, ’HOME BUSINESS’); |
Repeat the previous two steps for each code list type defined in the file.
If you specified additional code list fields in object.xml and midm.xml after the database scripts were generated, add a new stanza for each new code type.
Save and close the file.
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.