/*version 15 medisoft /* Table Type of MWCAS is ADT*/ Create Index IDXINSCARRIER3 on MWCAS( [INSURANCE CARRIER #3] ); Create Unique Index [PRIMARY] on MWCAS( [CHART NUMBER], [CASE NUMBER] ); Create Index IDXINSCARRIER2 on MWCAS( [INSURANCE CARRIER #2] ); Create Index IDXINSCARRIER1 on MWCAS( [INSURANCE CARRIER #1] ); Create Index IDXGUARANTOR on MWCAS( [GUARANTOR] ); Create Index IDXCHARTDESCRIPTION on MWCAS( [CHART NUMBER], [DESCRIPTION] ); Create Index IDXFACILITY on MWCAS( [FACILITY], [CHART NUMBER] ); Create Index IDXREFSOURCE on MWCAS( [REFERRAL SOURCE], [CHART NUMBER] ); Create Index IDXREFPROVIDER on MWCAS( [REFERRING PROVIDER], [CHART NUMBER] ); Create Index IDXCASENUMBER on MWCAS( [CASE NUMBER] ); Create Index IDXCHARTNUMBER on MWCAS( [CHART NUMBER] ); Create Index IDXCASENUMBERDESC on MWCAS( [CHART NUMBER], [CASE NUMBER] ); /* Table Type of MWPAT is ADT*/ Create Unique Index [PRIMARY] on MWPAT( [CHART NUMBER] ); Create Index SSN on MWPAT( [SOCIAL SECURITY NUMBER] ); Create Index IDXNAME on MWPAT( [LAST NAME], [FIRST NAME] ); Create Index [FULL NAME] on MWPAT( [CHART NUMBER] ); Create Index [ASSIGNED PROVIDER] on MWPAT( [ASSIGNED PROVIDER] ); Create Index [BY PAYMENT PLAN] on MWPAT( [PAYMENT PLAN] ); Create Index IDXPATID on MWPAT( [PATIENT ID #2] ); Create Index IDXFLAG on MWPAT( [FLAG] ); /* Table Type of mwPSW is ADT*/ Create Index [USER] on mwPSW( [USER],[DATE USED] ); /* Table Type of mwpwd is ADT*/ Create Unique Index [PRIMARY] on mwpwd( [USER NAME] ); /* Table Type of mwSEC is ADT*/ Create Index IDXNAME on mwSEC( [NAME] ); Create Index [PRIMARY] on mwSEC( [CODE] ); /* Table Type of MWTRN is ADT*/ Create Index [IDXENTRY NUMBER] on MWTRN( [CC ENTRY NUMBER] ); Create Index IDXPROVIDER on MWTRN( [ATTENDING PROVIDER] ); Create Index IDXCASENUMBER on MWTRN( [CASE NUMBER] ); Create Index IDXDATECREATED on MWTRN( [DATE CREATED] ); Create Index IDXSTATEMENT on MWTRN( [STATEMENT NUMBER],[DATE FROM],[ENTRY NUMBER] ); Create Index IDXDEPOSITID on MWTRN( [DEPOSIT ID] ); Create Index IDXCHARTCASEDOC on MWTRN( [CHART NUMBER],[CASE NUMBER],[DOCUMENT NUMBER],[ENTRY NUMBER],[TOOTH NUMBER] ); Create Index IDXENTRYNUMBER on MWTRN( [ENTRY NUMBER] ); Create Unique Index [PRIMARY] on MWTRN( [CHART NUMBER],[CASE NUMBER],[ENTRY NUMBER],[TOOTH NUMBER] ); Create Index IDXDOCUMENT on MWTRN( [CHART NUMBER],[DOCUMENT NUMBER],[TRANSACTION TYPE] ); Create Index IDXDATECHARTTYPE on MWTRN( [DATE FROM],[CHART NUMBER], [TRANSACTION TYPE] ); Create Index IDXCHARTNUMBER on MWTRN( [CHART NUMBER] ); Create Index IDXCHECKNUMBER on MWTRN( [CHECK NUMBER] ); Create Index IDXTYPE on MWTRN( [TRANSACTION TYPE] ); Create Index IDXPROMODIFIERS on MWTRN( [PROCEDURE CODE],[MODIFIER 1],[MODIFIER 2],[MODIFIER 3],[MODIFIER 4] ); Create Index IDXCHARTDATE on MWTRN( [CHART NUMBER], [DATE FROM] ); Create Index IDXCLAIMREJECTION on MWTRN( [CLAIM REJECTION CODE] ); Create Index IDXCLAIM on MWTRN( [CLAIM NUMBER],[DATE FROM],[ENTRY NUMBER] ); Create Index IDXSTATEMENTID on MWTRN( [STATEMENT NUMBER] ); Create Index IDXDATEMODIFIED on MWTRN( [DATE MODIFIED] ); Create Index IDXPROCEDURE on MWTRN( [PROCEDURE CODE], [INSURANCE CATEGORY] ); Create Index IDXCLAIMREVENUECODE on MWTRN( [CLAIM NUMBER], [REVENUE_CODE] ); Create Unique Index IDXCHARTCASESERVDT on MWTRN( [CHART NUMBER],[CASE NUMBER],[DATE FROM],[ENTRY NUMBER] ); Create Index IDXUBGROUP on MWTRN( [CLAIM NUMBER],[REVENUE_CODE],[PROCEDURE CODE],[MODIFIER 1],[MODIFIER 2],[MODIFIER 3],[MODIFIER 4],[DATE FROM] ); /* Table Type of MWPHY is ADT*/ Create Unique Index [PRIMARY] on MWPHY( CODE ); Create Index IDXNAME on MWPHY( [LAST NAME], [FIRST NAME] ); /* Table Type of MWADD is ADT*/ Create Index IDXTYPE on MWADD( TYPE ); Create Unique Index [PRIMARY] on MWADD( CODE ); Create Index IDXNAME on MWADD( NAME ); /* Table Type of MWRPH is ADT*/ Create Index IDXNAME on MWRPH( [LAST NAME], [FIRST NAME] ); Create Unique Index [PRIMARY] on MWRPH( CODE ); /* Table Type of MWDIA is ADT*/ Create Index IDXDESCRIPTION on MWDIA( DESCRIPTION ); Create Unique Index [PRIMARY] on MWDIA( [CODE 1] ); /* Table Type of MWPRO is ADT*/ Create Index IDXTYPE on MWPRO( [TYPE] ); Create Index IDXDESCRIPTION on MWPRO( DESCRIPTION ); Create Unique Index [PRIMARY] on MWPRO( [CODE 1] ); /* Table Type of MWBCO is ADT*/ Create Unique Index [PRIMARY] on MWBCO( CODE ); Create Index IDXDESCRIPTION on MWBCO( DESCRIPTION ); /* Table Type of MWINS is ADT*/ Create Unique Index [PRIMARY] on MWINS( CODE ); Create Index IDXIOD on MWINS( IOD ); Create Index IDXNAME on MWINS( NAME ); 1LlNiR6SiO5H