-- Table Type of mwPSW is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwPSW', 'mwPSW.adi', 'USER', 'User;Date Used', '', 2, 512, NULL );

-- Table Type of mwpwd is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwpwd', 'mwpwd.adi', 'PRIMARY', 'User Name', '', 2051, 512, NULL );

-- Table Type of mwSEC is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwSEC', 'mwSEC.adi', 'IDXNAME', 'UPPER(Name)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwSEC', 'mwSEC.adi', 'PRIMARY', 'UPPER(Code)', '', 2, 512, NULL );

-- Table Type of ARRTT is ADT
-- Table Type of ARRUT is ADT
-- Table Type of EDIReports is ADT
-- Table Type of EDIReports_Archive is ADT
-- Table Type of HL7MessageData is ADT
-- Table Type of HL7Messages is ADT
-- Table Type of HL7Trigger is ADT
-- Table Type of MWADD is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWADD', 'MWADD.adi', 'IDXTYPE', 'Type', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWADD', 'MWADD.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWADD', 'MWADD.adi', 'IDXNAME', 'UPPER(Name)', '', 2, 512, NULL );

-- Table Type of MWALL is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWALL', 'MWALL.adi', 'IDXINSURANCE', 'UPPER(Insurance Code)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWALL', 'MWALL.adi', 'PRIMARY', 'UPPER(Insurance Code);Procedure;Modifiers', '', 2051, 512, NULL );

-- Table Type of mwarl is ADT
-- Table Type of MWAUD is ADT
-- Table Type of mwaudd is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwaudd', 'mwaudd.adi', 'ID', 'ID', '', 2051, 512, NULL );

-- Table Type of mwaudm is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwaudm', 'mwaudm.adi', 'ID', 'ID', '', 2051, 512, NULL );

-- Table Type of mwauds is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwauds', 'mwauds.adi', 'PRIMARY', 'Template Name', '', 2, 512, NULL );

-- Table Type of MWBCO is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWBCO', 'MWBCO.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWBCO', 'MWBCO.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );

-- Table Type of MWBOS is ADT
-- Table Type of MWBSP is ADT
-- Table Type of MWCAS is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXINSCARRIER3', 'UPPER(Insurance Carrier #3)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'PRIMARY', 'UPPER(Chart Number);Case Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXINSCARRIER2', 'UPPER(Insurance Carrier #2)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXINSCARRIER1', 'UPPER(Insurance Carrier #1)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXGUARANTOR', 'UPPER(Guarantor)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXCHARTDESCRIPTION', 'UPPER(Chart Number);UPPER(Description)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXFACILITY', 'UPPER(Facility);UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXREFSOURCE', 'UPPER(Referral Source);UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXREFPROVIDER', 'UPPER(Referring Provider);UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXCASENUMBER', 'Case Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXCHARTNUMBER', 'Chart Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCAS', 'MWCAS.adi', 'IDXCASENUMBERDESC', 'UPPER(Chart Number);Case Number', '', 10, 512, NULL );

-- Table Type of mwcasarc is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'PRIMARY', 'UPPER(Chart Number);Case Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXINSCARRIER3', 'UPPER(Insurance Carrier #3)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXINSCARRIER2', 'UPPER(Insurance Carrier #2)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXINSCARRIER1', 'UPPER(Insurance Carrier #1)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXGUARANTOR', 'UPPER(Guarantor)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXCHARTDESCRIPTION', 'UPPER(Chart Number);UPPER(Description)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXFACILITY', 'UPPER(Facility);UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXREFSOURCE', 'UPPER(Referral Source);UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXREFPROVIDER', 'UPPER(Referring Provider);UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXCASENUMBER', 'Case Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwcasarc', 'MWCASARC.adi', 'IDXCHARTNUMBER', 'Chart Number', '', 2, 512, NULL );

-- Table Type of MWCC is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCC', 'MWCC.adi', 'IDXROUTINGDATA', 'Routing Data', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCC', 'MWCC.adi', 'PRIMARY', 'Entry Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCC', 'MWCC.adi', 'ITEM NUMBER', 'Item Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCC', 'MWCC.adi', 'TRANSACTION TYPE', 'Transaction Type', '', 2, 512, NULL );

-- Table Type of MWCCD is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCCD', 'MWCCD.adi', 'PRIMARY', 'Case Number', '', 2051, 512, NULL );

-- Table Type of MWCDP is ADT
-- Table Type of MWCLA is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXINSCO1', 'UPPER(Insurance Carrier 1);UPPER(Claim Status 1)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXDATECREATED', 'Date Created', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXINSCO3', 'UPPER(Insurance Carrier 3);UPPER(Claim Status 3)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXBATCH3', 'Batch Number 3', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'PRIMARY', 'Claim Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXRECEIVER2PROVIDER', 'UPPER(EMC Receiver 2);UPPER(Provider);UPPER(Insurance Carrier 2)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXBATCH2', 'Batch Number 2', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXRECEIVER3PROVIDER', 'UPPER(EMC Receiver 3);UPPER(Provider);UPPER(Insurance Carrier 3)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXINSCO2', 'UPPER(Insurance Carrier 2);UPPER(Claim Status 2)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXRECEIVER1INS1', 'UPPER(EMC Receiver 1);UPPER(Insurance Carrier 1);UPPER(Provider)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXRECEIVER1PROVIDER', 'UPPER(EMC Receiver 1);UPPER(Provider);UPPER(Insurance Carrier 1)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXBATCH1', 'Batch Number 1', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLA', 'MWCLA.adi', 'IDXCHARTCASE', 'UPPER(Chart Number);Case Number', '', 2, 512, NULL );

-- Table Type of mwclaarc is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXINSCO3', 'UPPER(Insurance Carrier 3);UPPER(Claim Status 3)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXINSCO1', 'UPPER(Insurance Carrier 1);UPPER(Claim Status 1)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'PRIMARY', 'Claim Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXRECEIVER2PROVIDER', 'UPPER(EMC Receiver 2);UPPER(Provider);UPPER(Insurance Carrier 2)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXBATCH3', 'Batch Number 3', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXRECEIVER3PROVIDER', 'UPPER(EMC Receiver 3);UPPER(Provider);UPPER(Insurance Carrier 3)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXBATCH2', 'Batch Number 2', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXINSCO2', 'UPPER(Insurance Carrier 2);UPPER(Claim Status 2)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXRECEIVER1INS1', 'UPPER(EMC Receiver 1);UPPER(Insurance Carrier 1);UPPER(Provider)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXRECEIVER1PROVIDER', 'UPPER(EMC Receiver 1);UPPER(Provider);UPPER(Insurance Carrier 1)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXBATCH1', 'Batch Number 1', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXCHARTCASE', 'UPPER(Chart Number);Case Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwclaarc', 'MWCLAARC.adi', 'IDXDATECREATED', 'Date Created', '', 2, 512, NULL );

-- Table Type of MWCLB is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLB', 'mwclb.adi', 'PRIMARY', 'Run ID', '', 2051, 512, NULL );

-- Table Type of MWCLC is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLC', 'MWCLC.adi', 'PRIMARY', 'Change ID', '', 2051, 512, NULL );

-- Table Type of MWCLD is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCLD', 'MWCLD.adi', 'PRIMARY', 'Unique ID', '', 2051, 512, NULL );

-- Table Type of MWCLM is ADT
-- Table Type of MWCLU is ADT
-- Table Type of MWCND is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCND', 'MWCND.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCND', 'MWCND.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );

-- Table Type of MWCON is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCON', 'MWCON.adi', 'IDXCONTACT', 'Upper(Contact);Upper(Business);Upper(Category)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCON', 'MWCON.adi', 'PRIMARY', 'UPPER(Business);UPPER(Contact);UPPER(Category)', '', 2, 512, NULL );

-- Table Type of MWCPD is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWCPD', 'MWCPD.adi', 'PRIMARY', 'Chart Number', '', 2051, 512, NULL );

-- Table Type of MwDef is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MwDef', 'MwDef.adi', 'PRIMARY', 'UPPER(Table);UPPER(Field)', '', 2, 512, NULL );

-- Table Type of MWDEP is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDEP', 'MWDEP.adi', 'IDXPAYOR', 'UPPER(Payor Name)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDEP', 'MWDEP.adi', 'IDXENTRYNUMBER', 'Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDEP', 'MWDEP.adi', 'IDXPAYMENTAMOUNT', 'Payment Amount', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDEP', 'MWDEP.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDEP', 'MWDEP.adi', 'IDXCHARTNUMBER', 'UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDEP', 'MWDEP.adi', 'IDXINSURANCE', 'UPPER(Insurance Code)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDEP', 'MWDEP.adi', 'PAYOR', 'Deposit Date;UPPER(Payor Name)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDEP', 'MWDEP.adi', 'PRIMARY', 'Deposit Date;UPPER(Description);Entry Number', '', 2051, 512, NULL );

-- Table Type of mwdeparc is ADT
-- Table Type of MWDIA is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDIA', 'MWDIA.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWDIA', 'MWDIA.adi', 'PRIMARY', 'UPPER(Code 1)', '', 2051, 512, NULL );

-- Table Type of MWECR is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWECR', 'MWECR.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWECR', 'MWECR.adi', 'IDXNAME', 'UPPER(Name)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWECR', 'MWECR.adi', 'IDXSTMRECEIVER', 'eStatement_Receiver;Code', '', 2, 512, NULL );

-- Table Type of mwEDI_ID is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwEDI_ID', 'mwEDI_ID.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwEDI_ID', 'mwEDI_ID.adi', 'IDX_IDS', 'ID Type;Code;ID', '', 2051, 512, NULL );

-- Table Type of MWEDITransactions is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWEDITransactions', 'MWEDITransactions.adi', 'ID', 'ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWEDITransactions', 'MWEDITransactions.adi', 'TRANSACTIONDATE', 'TransactionDate', '', 2, 512, NULL );

-- Table Type of MWEDITransactionTypes is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWEDITransactionTypes', 'MWEDITransactionTypes.adi', 'TRANSACTIONTYPE', 'TransactionTypeCode', '', 2051, 512, NULL );

-- Table Type of MWEEI is ADT
-- Table Type of MWELG is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWELG', 'MWELG.adi', 'INSURANCE CODE', 'UPPER(Insurance Code);UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWELG', 'MWELG.adi', 'CHART NUMBER', 'UPPER(Chart Number);Date Verified', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWELG', 'MWELG.adi', 'POLICY NUMBER', 'Policy Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWELG', 'MWELG.adi', 'DATE VERIFIED', 'Date Verified;UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWELG', 'MWELG.adi', 'PATIENT NAME', 'UPPER(Patient Name);Date Verified', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWELG', 'MWELG.adi', 'PROVIDER CODE', 'UPPER(Provider Code);UPPER(Chart Number)', '', 2, 512, NULL );

-- Table Type of MWERA is ADT
-- Table Type of mwERC is ADT
-- Table Type of mwERT is ADT
-- Table Type of MWEVS is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWEVS', 'MWEVS.adi', 'PRIMARY', 'evTransactionID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWEVS', 'MWEVS.adi', 'VERIFICATIONDATE', 'Verification Date', '', 10, 512, NULL );

-- Table Type of MWEVS14 is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWEVS14', 'MWEVS14.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );

-- Table Type of mwfil is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwfil', 'MWFIL.adi', 'PRIMARY', 'User_Code', '', 2051, 512, NULL );

-- Table Type of MWGID is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWGID', 'MWGID.adi', 'PRIMARY', 'User_Code;Group_ID', '', 2, 512, NULL );

-- Table Type of MWGRP is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWGRP', 'MWGRP.adi', 'PRIMARY', 'Name', '', 2, 512, NULL );

-- Table Type of MWINC is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWINC', 'MWINC.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWINC', 'MWINC.adi', 'NAME', 'Class Name', '', 2, 512, NULL );

-- Table Type of MWINS is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWINS', 'MWINS.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWINS', 'MWINS.adi', 'IDXIOD', 'UPPER(IOD)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWINS', 'MWINS.adi', 'IDXNAME', 'UPPER(Name)', '', 2, 512, NULL );

-- Table Type of mwLIO is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwLIO', 'mwLIO.adi', 'USER', 'User;Date;Time', '', 2, 512, NULL );

-- Table Type of mwLPM is ADT
-- Table Type of MWMDP is ADT
-- Table Type of MWMUL is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWMUL', 'MWMUL.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWMUL', 'MWMUL.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );

-- Table Type of MWOBJ is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWOBJ', 'MWOBJ.adi', 'IMAGE NUMBER', 'Image Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWOBJ', 'MWOBJ.adi', 'IDXCHARTCASE', 'UPPER(Chart Number);Case Number', '', 2, 512, NULL );

-- Table Type of mwobjarc is ADT
-- Table Type of MWOCR is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWOCR', 'MWOCR.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWOCR', 'MWOCR.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );

-- Table Type of MWOPT is ADT
-- Table Type of MWOSP is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWOSP', 'MWOSP.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWOSP', 'MWOSP.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );

-- Table Type of MWPAT is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAT', 'MWPAT.adi', 'PRIMARY', 'UPPER(Chart Number)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAT', 'MWPAT.adi', 'SSN', 'UPPER(Social Security Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAT', 'MWPAT.adi', 'IDXNAME', 'UPPER(Last Name);UPPER(First Name)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAT', 'MWPAT.adi', 'FULL NAME', 'Upper(Last Name + '', '' +First Name + '' '' + Middle Initial);UPPER(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAT', 'MWPAT.adi', 'ASSIGNED PROVIDER', 'UPPER(Assigned Provider)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAT', 'MWPAT.adi', 'BY PAYMENT PLAN', 'Payment Plan', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAT', 'MWPAT.adi', 'IDXPATID', 'UPPER(Patient ID #2)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAT', 'MWPAT.adi', 'IDXFLAG', 'Flag', '', 2, 512, NULL );

-- Table Type of MWPAX is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAX', 'MWPAX.adi', 'PRIMARY', 'Payment Reference;Charge Reference', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAX', 'MWPAX.adi', 'IDXCHARGEREFERENCE', 'Charge Reference', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAX', 'MWPAX.adi', 'IDXDEPOSITID', 'Deposit ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPAX', 'MWPAX.adi', 'IDXPAYMENTREFERENCE', 'Payment Reference', '', 2, 512, NULL );

-- Table Type of mwpaxarc is ADT
-- Table Type of mwpcl is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwpcl', 'MWPCL.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwpcl', 'MWPCL.adi', 'NAME', 'Class_Name', '', 2, 512, NULL );

-- Table Type of MWPDS is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPDS', 'MWPDS.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPDS', 'MWPDS.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );

-- Table Type of MWPER is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPER', 'MWPER.adi', 'PRIMARY', 'UPPER(Window);UPPER(Process)', '', 2, 512, NULL );

-- Table Type of MWPHY is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPHY', 'MWPHY.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPHY', 'MWPHY.adi', 'IDXNAME', 'UPPER(Last Name);UPPER(First Name)', '', 2, 512, NULL );

-- Table Type of mwpid is ADT
-- Table Type of MWPLG is ADT
-- Table Type of MWPLN is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPLN', 'MWPLN.adi', 'IDXDESCRIPTION', 'Upper(Description)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPLN', 'MWPLN.adi', 'IDXCHARTPLAN', 'Upper(Chart Number);Plan Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPLN', 'MWPLN.adi', 'IDXPLANNUMBER', 'Plan Number', '', 2, 512, NULL );

-- Table Type of mwppl is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwppl', 'mwppl.adi', 'BY CODE', 'Code', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwppl', 'mwppl.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwppl', 'mwppl.adi', 'BY DESCRIPTION', 'Upper(Description)', '', 2, 512, NULL );

-- Table Type of MWPPR is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPPR', 'MWPPR.adi', 'IDXPLANNUMBER', 'Plan Number', '', 2, 512, NULL );

-- Table Type of MWPRA is ADT
-- Table Type of MWPRN is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPRN', 'MWPRN.adi', 'PRIMARY', 'Run ID', '', 2051, 512, NULL );

-- Table Type of MWPRO is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPRO', 'MWPRO.adi', 'IDXTYPE', 'Type', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPRO', 'MWPRO.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPRO', 'MWPRO.adi', 'PRIMARY', 'UPPER(Code 1)', '', 2051, 512, NULL );

-- Table Type of MWProviderPayerEnrollmentFlags is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWProviderPayerEnrollmentFlags', 'MWProviderPayerEnrollmentFlags.adi', 'MWPROVIDERPAYERENROLLMENTFLAGS_IDX', 'ProviderCode;PayerID;ReceiverID;ServiceType;PayerType;PayerDescription', '', 2051, 1024, NULL );

-- Table Type of MWPRS is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPRS', 'MWPRS.adi', 'PRIMARY', 'Setting ID;Context', '', 2051, 512, NULL );

-- Table Type of MWPTD is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPTD', 'MWPTD.adi', 'PRIMARY', 'Template_Def_ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPTD', 'MWPTD.adi', 'IDXCODE', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPTD', 'MWPTD.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );

-- Table Type of MWPTF is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPTF', 'MWPTF.adi', 'PRIMARY', 'Template_Fields_ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPTF', 'MWPTF.adi', 'IDXSOURCEID', 'Template_Def_ID;Source;ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPTF', 'MWPTF.adi', 'IDXDEFINITIONID', 'Template_Def_ID;Field_Order', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWPTF', 'MWPTF.adi', 'IDXCAPTION', 'UPPER(Caption)', '', 2, 512, NULL );

-- Table Type of MWREC is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWREC', 'MWREC.adi', 'IDXPROVIDERDATE', 'UPPER(Provider);Date of Recall', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWREC', 'MWREC.adi', 'IDXCHARTDATE', 'UPPER(Chart Number);Date of Recall', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWREC', 'MWREC.adi', 'PRIMARY', 'Date of Recall;UPPER(Provider);UPPER(Chart Number)', '', 2051, 512, NULL );

-- Table Type of mwrej is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwrej', 'mwrej.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwrej', 'mwrej.adi', 'BY REJECTION CODE', 'Rejection Code', '', 2051, 512, NULL );

-- Table Type of MWREV is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWREV', 'MWREV.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWREV', 'MWREV.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );

-- Table Type of MWRPH is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWRPH', 'MWRPH.adi', 'IDXNAME', 'UPPER(Last Name);UPPER(First Name)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWRPH', 'MWRPH.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );

-- Table Type of MWRTK is ADT
-- Table Type of mwrul is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwrul', 'MWRUL.adi', 'PRIMARY', 'Task_Code', '', 2051, 512, NULL );

-- Table Type of MWSCD is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSCD', 'MWSCD.adi', 'IDXCONTROLID', 'Control_ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSCD', 'MWSCD.adi', 'IDXSCREENID', 'Screen ID', '', 2, 512, NULL );

-- Table Type of MWSCR is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSCR', 'MWSCR.adi', 'IDXSCREENID', 'Screen ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSCR', 'MWSCR.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );


-- Table Type of MWSTA is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTA', 'MWSTA.adi', 'IDXSUBMISSIONCOUNT', 'Submission Count', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTA', 'MWSTA.adi', 'IDXBILLINGDATE', 'Last Billing Date', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTA', 'MWSTA.adi', 'PRIMARY', 'Statement Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTA', 'MWSTA.adi', 'IDXBATCH', 'Batch Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTA', 'MWSTA.adi', 'IDXDATECREATED', 'Date Created', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTA', 'MWSTA.adi', 'IDXINITIALBILLDATE', 'Initial Billing Date', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTA', 'MWSTA.adi', 'IDXCHARTSTMT', 'UPPER(Chart Number);Statement Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTA', 'MWSTA.adi', 'IDXCHART', 'Chart Number', '', 2, 512, NULL );

-- Table Type of mwstaarc is ADT
-- Table Type of mwStmtPayTo is ADT
-- Table Type of MWSTR is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTR', 'MWSTR.adi', 'PRIMARY', 'Chart Number;Document Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTR', 'MWSTR.adi', 'IDXSTATUS', 'Status', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTR', 'MWSTR.adi', 'IDXDOCUMENTNUMBER', 'Document Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWSTR', 'MWSTR.adi', 'IDXCHARTNUMBER', 'UPPER(Chart Number)', '', 2, 512, NULL );

-- Table Type of MWTNT is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTNT', 'MWTNT.adi', 'PRIMARY', 'ID;Entry Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTNT', 'MWTNT.adi', 'IDX_IDS', 'ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTNT', 'MWTNT.adi', 'IDX_ENTRYNUMBER', 'Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTNT', 'MWTNT.adi', 'IDX_NOTETYPE', 'Note Type', '', 2, 512, NULL );

-- Table Type of MWTRB is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRB', 'MWTRB.adi', 'PRIMARY', 'Transmission Batch ID', '', 2051, 512, NULL );

-- Table Type of MWTRC is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRC', 'MWTRC.adi', 'PRIMARY', 'Transmission Component ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRC', 'MWTRC.adi', 'IDXTRANSMISSIONBATCHID', 'Transmission Batch ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRC', 'MWTRC.adi', 'IDXCLAIMBATCHID', 'Claim Batch ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRC', 'MWTRC.adi', 'IDXPAYMENTLOGID', 'Payment Log ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRC', 'MWTRC.adi', 'IDXCHANGEID', 'Change ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRC', 'MWTRC.adi', 'IDXERAID', 'Electronic Remittance ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRC', 'MWTRC.adi', 'IDXRESPONSEID', 'Response ID', '', 2, 512, NULL );

-- Table Type of mwtrg is ADT
-- Table Type of MWTRN is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXENTRY NUMBER', 'CC Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXPROVIDER', 'UPPER(Attending Provider)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCASENUMBER', 'Case Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDATECREATED', 'Date Created', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXSTATEMENT', 'Statement Number;Date From;Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDEPOSITID', 'Deposit ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHARTCASEDOC', 'Chart Number;Case Number;Document Number;Entry Number;Tooth Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXENTRYNUMBER', 'Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'PRIMARY', 'Chart Number;Case Number;Entry Number;Tooth Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDOCUMENT', 'UPPER(Chart Number);Document Number;UPPER(Transaction Type)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDATECHARTTYPE', 'Date From;UPPER(Chart Number);UPPER(Transaction Type)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHARTNUMBER', 'Chart Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHECKNUMBER', 'Check Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXTYPE', 'Transaction Type', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXPROMODIFIERS', 'Procedure Code;Modifier 1;Modifier 2;Modifier 3;Modifier 4', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHARTDATE', 'UPPER(Chart Number);Date From', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCLAIMREJECTION', 'Claim Rejection Code', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCLAIM', 'Claim Number;Date From;Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXSTATEMENTID', 'Statement Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDATEMODIFIED', 'Date Modified', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXPROCEDURE', 'UPPER(Procedure Code);UPPER(Insurance Category)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCLAIMREVENUECODE', 'Claim Number;UPPER(Revenue_Code)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCLAIMDATEREVENUECODE', 'Claim Number;Date From;UPPER(Revenue_Code)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHARTCASESERVDT', 'Chart Number;Case Number;Date From;Entry Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXUBGROUP', 'Claim Number;Revenue_Code;Procedure Code;Modifier 1;Modifier 2;Modifier 3;Modifier 4;Date From', '', 2, 512, NULL );

-- Table Type of mwtrnarc is ADT
-- Table Type of MWTRR is ADT
-- Table Type of MWTSK is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTSK', 'MWTSK.adi', 'PRIMARY', 'Group;User', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTSK', 'MWTSK.adi', 'AREA', 'Associated_Area', '', 2, 512, NULL );

-- Table Type of MWUBF is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUBF', 'MWUBF.adi', 'IDXCHARTCASE', 'UPPER(Chart Number);Case Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUBF', 'MWUBF.adi', 'PRIMARY', 'UB_ID', '', 2051, 512, NULL );

-- Table Type of MWUIR is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUIR', 'mwuir.adi', 'INDEX2', 'Claim_Status;Chart_Number;Case_Number;HL7MessageID;Procedure_Order', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUIR', 'mwuir.adi', 'PRIMARY', 'HL7MessageID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUIR', 'mwuir.adi', 'GROUP_ORDER', 'HL7MessageID;Chart_Number;Case_Number', '', 2, 512, NULL );

-- Table Type of MWUTC is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'AMOUNT_ORDER', 'Amount', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'AMOUNT_ORDER_DESC', 'Amount', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DOB_ORDER', 'Birth_Date', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DOB_ORDER_DESC', 'Birth_Date', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'CASE_ORDER', 'Case_Number;Chart_Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'CASE_ORDER_DESC', 'Case_Number;Chart_Number', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'CHART_ORDER', 'Chart_Number;Case_Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'CHART_ORDER_DESC', 'Chart_Number;Case_Number', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'INDEX2', 'Claim_Status;Chart_Number;Case_Number;HL7MessageID;Procedure_Order', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'INDEX2_DESC', 'Claim_Status;Chart_Number;Case_Number;HL7MessageID;Procedure_Order', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'TIME_ORDER', 'Date_Created;Date_Modified', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'TIME_ORDER_DESC', 'Date_Created;Date_Modified', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DATE_FROM_ORDER', 'Date_From;Chart_Number;Case_Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DATE_FROM_ORDER_DESC', 'Date_From;Chart_Number;Case_Number', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DATE_MODIFIED_ORDER', 'Date_Modified', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DATE_MODIFIED_ORDER_DESC', 'Date_Modified', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DIAG_CODE1_ORDER', 'Diagnosis_Code_1', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DIAG_CODE1_ORDER_DESC', 'Diagnosis_Code_1', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DIAG_CODE2_ORDER', 'Diagnosis_Code_2', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DIAG_CODE2_ORDER_DESC', 'Diagnosis_Code_2', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DIAG_CODE3_ORDER', 'Diagnosis_Code_3', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DIAG_CODE3_ORDER_DESC', 'Diagnosis_Code_3', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DIAG_CODE4_ORDER', 'Diagnosis_Code_4', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'DIAG_CODE4_ORDER_DESC', 'Diagnosis_Code_4', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'FACILITY_ORDER', 'Facility', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'FACILITY_ORDER_DESC', 'Facility', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'PRIMARY', 'HL7MessageID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'PRIMARY_DESC', 'HL7MessageID', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'GROUP_ORDER', 'HL7MessageID;Chart_Number;Case_Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'GROUP_ORDER_DESC', 'HL7MessageID;Chart_Number;Case_Number', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'MODIFIER1_ORDER', 'Modifier_1', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'MODIFIER1_ORDER_DESC', 'Modifier_1', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'MODIFIER2_ORDER', 'Modifier_2', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'MODIFIER2_ORDER_DESC', 'Modifier_2', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'MODIFIER3_ORDER', 'Modifier_3', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'MODIFIER3_ORDER_DESC', 'Modifier_3', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'MODIFIER4_ORDER', 'Modifier_4', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'MODIFIER4_ORDER_DESC', 'Modifier_4', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'LNAME_ORDER', 'Patient_Last_Name;Patient_First_Name', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'LNAME_ORDER_DESC', 'Patient_Last_Name;Patient_First_Name', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'PROCEDURE_CODE_ORDER', 'Procedure_Code', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'PROCEDURE_CODE_ORDER_DESC', 'Procedure_Code', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'PROCEDURE_ORDER_ORDER', 'Procedure_Order', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'PROCEDURE_ORDER_ORDER_DESC', 'Procedure_Order', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'PROVIDER_ORDER', 'Provider;Chart_Number;Case_Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'PROVIDER_ORDER_DESC', 'Provider;Chart_Number;Case_Number', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'SSN_ORDER', 'SSN', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'SSN_ORDER_DESC', 'SSN', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'TRANSSTATUS_ORDER', 'Transaction_Status;Date_Created', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'TRANSSTATUS_ORDER_DESC', 'Transaction_Status;Date_Created', '', 10, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'UNITS_ORDER', 'Units', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWUTC', 'mwutc.adi', 'UNITS_ORDER_DESC', 'Units', '', 10, 512, NULL );

-- Table Type of MWVAL is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWVAL', 'MWVAL.adi', 'PRIMARY', 'UPPER(Code)', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWVAL', 'MWVAL.adi', 'IDXDESCRIPTION', 'UPPER(Description)', '', 2, 512, NULL );

-- Table Type of MWWHS is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWWHS', 'MWWHS.adi', 'SETTING ID', 'Setting ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWWHS', 'MWWHS.adi', 'PRIMARY', 'Setting ID', '', 2051, 512, NULL );

-- Table Type of mwwrk is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'BY FOLLOW UP DATE', 'Follow Up Date', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'IDXGUARANTORPATIENT', 'Responsible Party;Guarantor;Patient;Claim;Statement_Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'IDXRESPONSIBLEPATIENT', 'Responsible Party;Patient', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'BY BALANCE', 'Balance', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'DATE DELETED', 'Date Deleted', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'PRIMARY', 'Item Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'DATE RESOLVED', 'Date Resolved', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'RESPONSIBLE TYPE', 'Responsible Type', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'BY PATIENT', 'Patient', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'BY USER ID', 'User ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'DATE CREATED', 'Date Created', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'IDXCLAIMTOTAL', 'Claim_Total', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwrk', 'mwwrk.adi', 'IDXINSURANCEESTIMATE', 'Insurance_Estimate', '', 2, 512, NULL );

-- Table Type of mwwtr is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwtr', 'mwwtr.adi', 'PRIMARY', 'Item Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwtr', 'mwwtr.adi', 'BY PATIENT', 'Patient Chart', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'mwwtr', 'mwwtr.adi', 'BY DATE LETTER SENT', 'Date Letter Sent', '', 2, 512, NULL );

-- Table Type of MWZIP is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'MWZIP', 'MWZIP.adi', 'PRIMARY', 'UPPER(Zip Code)', '', 2051, 512, NULL );

-- Table Type of OHAPP is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHAPP', 'OHAPP.adi', 'IDXREASONPROVIDER', 'Reason Code;Provider', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHAPP', 'OHAPP.adi', 'IDXPROVIDERREASON', 'Provider;Reason Code', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHAPP', 'OHAPP.adi', 'IDXCHART', 'Upper(Chart Number)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHAPP', 'OHAPP.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHAPP', 'OHAPP.adi', 'IDXDATETIME', 'Date;Start Time', '', 2, 512, NULL );

-- Table Type of OHCHK is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHCHK', 'OHCHK.adi', 'PRIMARY', 'ID;Date', '', 2051, 512, NULL );

-- Table Type of OHEXC is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHEXC', 'OHEXC.adi', 'PRIMARY', 'Recurring Number;Date', '', 2051, 512, NULL );

-- Table Type of OHOPT is ADT
-- Table Type of OHRM is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHRM', 'OHRM.adi', 'IDXDESCRIPTION', 'Upper(Description)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHRM', 'OHRM.adi', 'PRIMARY', 'Upper(Resource)', '', 2051, 512, NULL );

-- Table Type of OHRPTOLD is ADT
-- Table Type of OHRSN is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHRSN', 'OHRSN.adi', 'IDXDESCRIPTION', 'Upper(Description)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHRSN', 'OHRSN.adi', 'PRIMARY', 'Upper(Code)', '', 2051, 512, NULL );

-- Table Type of OHRTP is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHRTP', 'OHRTP.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );

-- Table Type of OHTEXC is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHTEXC', 'OHTEXC.adi', 'PRIMARY', 'Recurring Number; Date', '', 2051, 512, NULL );

-- Table Type of OHTPL is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHTPL', 'OHTPL.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );

-- Table Type of OHVIE is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHVIE', 'OHVIE.adi', 'PRIMARY', 'Upper(Name);Column', '', 2051, 512, NULL );

-- Table Type of OHWAI is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'OHWAI', 'OHWAI.adi', 'PRIMARY', 'ID', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHWAI', 'OHWAI.adi', 'BY DATE CREATED', 'Date Created', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHWAI', 'OHWAI.adi', 'BY REASON', 'Upper(Reason)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHWAI', 'OHWAI.adi', 'BY PROVIDER', 'Upper(Provider)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHWAI', 'OHWAI.adi', 'BY NAME', 'Upper(Name)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'OHWAI', 'OHWAI.adi', 'BY CHART NUMBER', 'Upper(Chart Number)', '', 2, 512, NULL );

-- Table Type of ReportTree is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'ReportTree', 'ReportTree.adi', 'PRIMARY', 'UserCode', '', 2051, 512, NULL );

-- Table Type of ReportUser is ADT
EXECUTE PROCEDURE sp_CreateIndex90( 'ReportUser', 'ReportUser.adi', 'PRIMARY', 'UserCode;ReportID', '', 2051, 512, NULL );