/*
MySQL Backup
Source Host:           localhost
Source Server Version: 4.1.10-nt
Source Database:       opendental
Date:                  2005/03/29 07:56:53
*/

SET FOREIGN_KEY_CHECKS=0;
use opendental;
#----------------------------
# Table structure for adjustment
#----------------------------
CREATE TABLE `adjustment` (
  `AdjNum` mediumint(8) unsigned NOT NULL auto_increment,
  `AdjDate` date NOT NULL default '0001-01-01',
  `AdjAmt` double NOT NULL default '0',
  `PatNum` mediumint(8) unsigned NOT NULL default '0',
  `AdjType` smallint(5) unsigned NOT NULL default '0',
  `ProvNum` mediumint(8) unsigned NOT NULL default '0',
  `AdjNote` text NOT NULL,
  `ProcDate` date NOT NULL default '0001-01-01',
  `ProcNum` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`AdjNum`),
  KEY `indexPatNum` (`PatNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table adjustment
#----------------------------

#----------------------------
# Table structure for appointment
#----------------------------
CREATE TABLE `appointment` (
  `AptNum` mediumint(8) unsigned NOT NULL auto_increment,
  `PatNum` mediumint(8) unsigned NOT NULL default '0',
  `AptStatus` tinyint(3) unsigned NOT NULL default '0',
  `Pattern` varchar(255) NOT NULL default '',
  `Confirmed` smallint(5) unsigned NOT NULL default '0',
  `AddTime` tinyint(3) NOT NULL default '0',
  `Op` smallint(5) unsigned NOT NULL default '0',
  `Note` text NOT NULL,
  `ProvNum` smallint(5) unsigned NOT NULL default '0',
  `ProvHyg` smallint(5) unsigned NOT NULL default '0',
  `AptDateTime` datetime NOT NULL default '0001-01-01 00:00:00',
  `NextAptNum` mediumint(8) unsigned NOT NULL default '0',
  `UnschedStatus` smallint(5) unsigned NOT NULL default '0',
  `Lab` tinyint(3) unsigned NOT NULL default '0',
  `IsNewPatient` tinyint(1) unsigned NOT NULL default '0',
  `ProcDescript` varchar(255) NOT NULL default '',
  `Assistant` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`AptNum`),
  KEY `indexPatNum` (`PatNum`),
  KEY `indexNextAptNum` (`NextAptNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table appointment
#----------------------------

#----------------------------
# Table structure for apptview
#----------------------------
CREATE TABLE `apptview` (
  `ApptViewNum` smallint(5) unsigned NOT NULL auto_increment,
  `Description` varchar(255) NOT NULL default '',
  `ItemOrder` smallint(5) unsigned NOT NULL default '0',
  `RowsPerIncr` tinyint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (`ApptViewNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table apptview
#----------------------------

#----------------------------
# Table structure for apptviewitem
#----------------------------
CREATE TABLE `apptviewitem` (
  `ApptViewItemNum` mediumint(8) unsigned NOT NULL auto_increment,
  `ApptViewNum` smallint(5) unsigned NOT NULL default '0',
  `OpNum` smallint(5) unsigned NOT NULL default '0',
  `ProvNum` smallint(5) unsigned NOT NULL default '0',
  `ElementDesc` varchar(255) NOT NULL default '',
  `ElementOrder` tinyint(3) unsigned NOT NULL default '0',
  `ElementColor` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ApptViewItemNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table apptviewitem
#----------------------------

#----------------------------
# Table structure for autocode
#----------------------------
CREATE TABLE `autocode` (
  `AutoCodeNum` smallint(5) unsigned NOT NULL auto_increment,
  `Description` varchar(255) NOT NULL default '',
  `IsHidden` tinyint(1) unsigned NOT NULL default '0',
  `LessIntrusive` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`AutoCodeNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table autocode
#----------------------------


insert  into autocode values 
(1, 'Amalgam', 0, 0), 
(5, 'Composite', 0, 0), 
(6, 'Root Canal', 0, 0), 
(7, 'Crown', 0, 0), 
(8, 'Bridge', 0, 0), 
(9, 'Extraction', 1, 0), 
(10, 'Denture', 0, 0), 
(11, 'PA', 0, 0), 
(12, 'BU/P&C', 0, 0), 
(13, 'RCT Retreat', 0, 0);
#----------------------------
# Table structure for autocodecond
#----------------------------
CREATE TABLE `autocodecond` (
  `AutoCodeCondNum` smallint(5) unsigned NOT NULL auto_increment,
  `AutoCodeItemNum` smallint(5) unsigned NOT NULL default '0',
  `Cond` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`AutoCodeCondNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table autocodecond
#----------------------------


insert  into autocodecond values 
(65, 32, 0), 
(61, 30, 6), 
(14, 3, 5), 
(13, 1, 4), 
(20, 7, 0), 
(19, 6, 4), 
(18, 6, 0), 
(63, 5, 7), 
(21, 7, 5), 
(22, 8, 0), 
(23, 8, 6), 
(69, 33, 1), 
(68, 9, 7), 
(67, 9, 0), 
(29, 10, 1), 
(30, 10, 4), 
(31, 11, 1), 
(32, 11, 5), 
(33, 12, 1), 
(34, 12, 6), 
(72, 13, 7), 
(71, 13, 1), 
(38, 14, 0), 
(39, 15, 2), 
(40, 16, 3), 
(41, 17, 0), 
(44, 18, 1), 
(73, 19, 16), 
(74, 20, 15), 
(47, 21, 11), 
(48, 22, 12), 
(49, 23, 9), 
(50, 24, 10), 
(56, 25, 1), 
(57, 26, 0), 
(58, 27, 0), 
(59, 28, 2), 
(60, 29, 3), 
(64, 31, 8), 
(66, 32, 8), 
(70, 33, 8);
#----------------------------
# Table structure for autocodeitem
#----------------------------
CREATE TABLE `autocodeitem` (
  `AutoCodeItemNum` smallint(5) unsigned NOT NULL auto_increment,
  `AutoCodeNum` smallint(5) unsigned NOT NULL default '0',
  `ADACode` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`AutoCodeItemNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table autocodeitem
#----------------------------


insert  into autocodeitem values 
(1, 1, 'D2140'), 
(3, 1, 'D2150'), 
(30, 1, 'D2160'), 
(5, 1, 'D2161'), 
(6, 5, 'D2330'), 
(7, 5, 'D2331'), 
(8, 5, 'D2332'), 
(9, 5, 'D2335'), 
(10, 5, 'D2391'), 
(11, 5, 'D2392'), 
(12, 5, 'D2393'), 
(13, 5, 'D2394'), 
(14, 6, 'D3310'), 
(15, 6, 'D3320'), 
(16, 6, 'D3330'), 
(17, 7, 'D2740'), 
(18, 7, 'D2750'), 
(19, 8, 'D6750'), 
(20, 8, 'D6240'), 
(21, 10, 'D5110'), 
(22, 10, 'D5120'), 
(23, 11, 'D0220'), 
(24, 11, 'D0230'), 
(25, 12, 'D2950'), 
(26, 12, 'D2954'), 
(27, 13, 'D3346'), 
(28, 13, 'D3347'), 
(29, 13, 'D3348'), 
(31, 1, 'D2161'), 
(32, 5, 'D2335'), 
(33, 5, 'D2394');
#----------------------------
# Table structure for carrier
#----------------------------
CREATE TABLE `carrier` (
  `CarrierNum` mediumint(8) unsigned NOT NULL auto_increment,
  `CarrierName` varchar(255) NOT NULL default '',
  `Address` varchar(255) NOT NULL default '',
  `Address2` varchar(255) NOT NULL default '',
  `City` varchar(255) NOT NULL default '',
  `State` varchar(255) NOT NULL default '',
  `Zip` varchar(255) NOT NULL default '',
  `Phone` varchar(255) NOT NULL default '',
  `ElectID` varchar(255) NOT NULL default '',
  `NoSendElect` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`CarrierNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table carrier
#----------------------------

#----------------------------
# Table structure for claim
#----------------------------
CREATE TABLE `claim` (
  `ClaimNum` mediumint(8) unsigned NOT NULL auto_increment,
  `PatNum` mediumint(8) unsigned NOT NULL default '0',
  `DateService` date NOT NULL default '0001-01-01',
  `DateSent` date NOT NULL default '0001-01-01',
  `ClaimStatus` char(1) NOT NULL default '',
  `DateReceived` date NOT NULL default '0001-01-01',
  `PlanNum` mediumint(8) unsigned NOT NULL default '0',
  `ProvTreat` smallint(5) unsigned NOT NULL default '0',
  `ClaimFee` double NOT NULL default '0',
  `InsPayEst` double NOT NULL default '0',
  `InsPayAmt` double NOT NULL default '0',
  `DedApplied` double NOT NULL default '0',
  `PreAuthString` varchar(40) NOT NULL default '',
  `IsProsthesis` char(1) NOT NULL default '',
  `PriorDate` date NOT NULL default '0001-01-01',
  `ReasonUnderPaid` varchar(255) NOT NULL default '',
  `ClaimNote` varchar(255) NOT NULL default '',
  `ClaimType` varchar(255) NOT NULL default '',
  `ProvBill` smallint(5) unsigned NOT NULL default '0',
  `ReferringProv` smallint(5) unsigned NOT NULL default '0',
  `RefNumString` varchar(40) NOT NULL default '',
  `PlaceService` tinyint(3) unsigned NOT NULL default '0',
  `AccidentRelated` char(1) NOT NULL default '',
  `AccidentDate` date NOT NULL default '0001-01-01',
  `AccidentST` varchar(2) NOT NULL default '',
  `EmployRelated` tinyint(3) unsigned NOT NULL default '0',
  `IsOrtho` tinyint(1) unsigned NOT NULL default '0',
  `OrthoRemainM` tinyint(3) unsigned NOT NULL default '0',
  `OrthoDate` date NOT NULL default '0001-01-01',
  `PatRelat` tinyint(3) unsigned NOT NULL default '0',
  `PlanNum2` mediumint(8) unsigned NOT NULL default '0',
  `PatRelat2` tinyint(3) unsigned NOT NULL default '0',
  `WriteOff` double NOT NULL default '0',
  `Radiographs` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ClaimNum`),
  KEY `indexPatNum` (`PatNum`),
  KEY `indexPlanNum` (`PlanNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table claim
#----------------------------

#----------------------------
# Table structure for claimform
#----------------------------
CREATE TABLE `claimform` (
  `ClaimFormNum` mediumint(8) unsigned NOT NULL auto_increment,
  `Description` varchar(50) NOT NULL default '',
  `IsHidden` tinyint(1) unsigned NOT NULL default '0',
  `FontName` varchar(255) NOT NULL default '',
  `FontSize` float unsigned NOT NULL default '0',
  `UniqueID` varchar(255) NOT NULL default '',
  `PrintImages` tinyint(1) unsigned NOT NULL default '0',
  `OffsetX` smallint(5) NOT NULL default '0',
  `OffsetY` smallint(5) NOT NULL default '0',
  PRIMARY KEY  (`ClaimFormNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table claimform
#----------------------------


insert  into claimform values 
(1, 'ADA 2002', 0, 'Arial', '9', 'OD1', 1, 0, 0), 
(2, 'Denti-Cal', 0, 'Arial', '9', 'OD2', 0, 0, 0), 
(3, 'ADA 2000', 0, 'Arial', '9', 'OD3', 1, 0, 0), 
(4, 'HCFA-1500', 0, 'Arial', '9', 'OD4', 1, 0, 0), 
(5, 'HCFA-1500 preprinted', 0, 'Arial', '9', 'OD5', 0, 0, 0);
#----------------------------
# Table structure for claimformitem
#----------------------------
CREATE TABLE `claimformitem` (
  `ClaimFormItemNum` mediumint(8) unsigned NOT NULL auto_increment,
  `ClaimFormNum` mediumint(8) unsigned NOT NULL default '0',
  `ImageFileName` varchar(255) NOT NULL default '',
  `FieldName` varchar(255) NOT NULL default '',
  `FormatString` varchar(255) NOT NULL default '',
  `XPos` float NOT NULL default '0',
  `YPos` float NOT NULL default '0',
  `Width` float NOT NULL default '0',
  `Height` float NOT NULL default '0',
  PRIMARY KEY  (`ClaimFormItemNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table claimformitem
#----------------------------


insert  into claimformitem values 
(1095, 3, '', 'RadiographsNumAttached', '', '460', '545', '35', '14'), 
(1094, 3, '', 'RadiographsNotAttached', '', '495', '547', '0', '0'), 
(1093, 3, '', 'IsRadiographsAttached', '', '388', '548', '0', '0'), 
(1092, 3, '', 'EmployerName', '', '482', '391', '140', '14'), 
(1091, 1, '', 'BillingDentistMedicaidID', '', '39', '990', '120', '14'), 
(1090, 1, '', 'TreatingDentistMedicaidID', '', '492', '946', '117', '14'), 
(1089, 2, '', 'IsRadiographsAttached', '', '186', '187', '0', '0'), 
(1088, 2, '', 'RadiographsNumAttached', '', '111', '217', '30', '14'), 
(1087, 1, '', 'RadiographsNumAttached', '', '684', '738', '27', '14'), 
(370, 5, '', 'PriInsCarrierName', '', '533', '413', '250', '14'), 
(371, 5, '', 'OtherInsExists', '', '544', '450', '0', '0'), 
(372, 5, '', 'PriInsST', '', '674', '89', '30', '14'), 
(373, 5, '', 'P2Date', 'MM    dd      yy', '44', '784', '80', '14'), 
(374, 5, '', 'P3Code', '', '278', '817', '65', '14'), 
(375, 5, '', 'PatientLastFirst', '', '47', '180', '250', '13'), 
(376, 5, '', 'PatientPhone', '', '177', '281', '120', '14'), 
(377, 5, '', 'PatientDOB', 'MM     dd     yy', '336', '183', '90', '14'), 
(378, 5, '', 'PatientIsMale', '', '444', '182', '0', '0'), 
(379, 5, '', 'PatientIsFemale', '', '494', '183', '0', '0'), 
(380, 5, '', 'SubscrLastFirst', '', '528', '180', '250', '14'), 
(381, 5, '', 'PatientAddress', '', '47', '213', '250', '14'), 
(382, 5, '', 'PatientCity', '', '47', '245', '200', '14'), 
(383, 5, '', 'PatientST', '', '287', '245', '30', '14'), 
(384, 5, '', 'PatientZip', '', '47', '281', '100', '14'), 
(385, 5, '', 'RelatIsSelf', '', '353', '215', '0', '0'), 
(386, 5, '', 'RelatIsSpouse', '', '405', '214', '0', '0'), 
(387, 5, '', 'RelatIsChild', '', '445', '214', '0', '0'), 
(388, 5, '', 'RelatIsOther', '', '495', '214', '0', '0'), 
(389, 5, '', 'SubscrAddress', '', '528', '213', '250', '14'), 
(390, 5, '', 'SubscrCity', '', '528', '245', '200', '14'), 
(391, 5, '', 'SubscrST', '', '759', '245', '50', '14'), 
(392, 5, '', 'SubscrZip', '', '528', '280', '100', '14'), 
(393, 5, '', 'GroupNum', '', '528', '313', '250', '14'), 
(394, 5, '', 'SubscrDOB', 'MM     dd     yy', '564', '350', '100', '14'), 
(395, 5, '', 'SubscrIsMale', '', '703', '348', '0', '0'), 
(396, 5, '', 'SubscrIsFemale', '', '775', '348', '0', '0'), 
(397, 5, '', 'EmployerName', '', '533', '381', '250', '14'), 
(398, 5, '', 'IsFTStudent', '', '435', '283', '0', '0'), 
(399, 5, '', 'OtherInsSubscrLastFirst', '', '47', '313', '250', '14'), 
(400, 5, '', 'OtherInsGroupNum', '', '47', '346', '250', '14'), 
(401, 5, '', 'OtherInsSubscrDOB', 'MM     dd     yy', '45', '385', '100', '14'), 
(402, 5, '', 'OtherInsSubscrIsMale', '', '205', '384', '0', '0'), 
(403, 5, '', 'OtherInsSubscrIsFemale', '', '266', '384', '0', '0'), 
(404, 5, '', 'OtherInsCarrierName', '', '49', '446', '250', '14'), 
(405, 5, '', 'IsOccupational', '', '376', '351', '0', '0'), 
(406, 5, '', 'IsAutoAccident', '', '376', '383', '0', '0'), 
(407, 5, '', 'IsOtherAccident', '', '376', '415', '0', '0'), 
(408, 5, '', 'AccidentST', '', '477', '381', '25', '14'), 
(409, 5, '', 'PatientRelease', '', '88', '510', '250', '14'), 
(410, 5, '', 'PatientReleaseDate', 'MM/dd/yyyy', '394', '510', '113', '14'), 
(411, 5, '', 'PatientAssignment', '', '587', '510', '225', '14'), 
(412, 5, '', 'SubscrPhone', '', '673', '280', '120', '14'), 
(413, 5, '', 'PriInsCarrierName', '', '533', '47', '250', '14'), 
(414, 5, '', 'PriInsAddress', '', '533', '61', '250', '14'), 
(415, 5, '', 'PriInsCity', '', '533', '89', '140', '14'), 
(416, 5, '', 'PriInsZip', '', '704', '89', '79', '14'), 
(417, 5, '', 'P1Date', 'MM    dd      yy', '44', '751', '80', '14'), 
(418, 5, '', 'P1Code', '', '278', '751', '65', '14'), 
(419, 5, '', 'P1Fee', '', '598', '749', '75', '14'), 
(420, 5, '', 'P2Code', '', '278', '785', '65', '14'), 
(421, 5, '', 'P2Fee', '', '598', '782', '75', '14'), 
(422, 5, '', 'P3Date', 'MM    dd      yy', '44', '817', '80', '14'), 
(423, 5, '', 'P3Fee', '', '598', '816', '75', '14'), 
(424, 5, '', 'P4Date', 'MM    dd      yy', '44', '850', '80', '14'), 
(425, 5, '', 'P4Code', '', '278', '851', '65', '14'), 
(426, 5, '', 'P4Fee', '', '598', '849', '75', '14'), 
(427, 5, '', 'P5Date', 'MM    dd      yy', '44', '884', '80', '14'), 
(428, 5, '', 'P5Code', '', '278', '883', '65', '14'), 
(429, 5, '', 'P5Fee', '', '598', '882', '75', '14'), 
(430, 5, '', 'P6Date', 'MM    dd      yy', '45', '917', '80', '14'), 
(431, 5, '', 'P6Code', '', '278', '917', '65', '14'), 
(432, 5, '', 'P6Fee', '', '598', '915', '75', '14'), 
(433, 5, '', 'BillingDentistSSNorTIN', '', '47', '949', '131', '14'), 
(434, 5, '', 'TotalFee', '', '621', '948', '75', '14'), 
(435, 5, '', 'BillingDentist', '', '526', '980', '250', '14'), 
(436, 5, '', 'BillingDentistAddress', '', '526', '993', '250', '14'), 
(437, 5, '', 'BillingDentistCity', '', '526', '1006', '139', '14'), 
(438, 5, '', 'BillingDentistST', '', '666', '1006', '30', '14'), 
(439, 5, '', 'BillingDentistZip', '', '696', '1006', '80', '14'), 
(440, 5, '', 'P3Date', 'MM    dd      yy', '132', '817', '80', '14'), 
(441, 5, '', 'P1Date', 'MM    dd      yy', '132', '751', '80', '14'), 
(442, 5, '', 'P2Date', 'MM    dd      yy', '132', '784', '80', '14'), 
(443, 5, '', 'P4Date', 'MM    dd      yy', '132', '850', '80', '14'), 
(444, 5, '', 'P5Date', 'MM    dd      yy', '132', '884', '80', '14'), 
(445, 5, '', 'P6Date', 'MM    dd      yy', '131', '917', '80', '14'), 
(446, 5, '', 'IsMedicaidClaim', '', '105', '152', '0', '0'), 
(447, 5, '', 'IsStandardClaim', '', '335', '152', '0', '0'), 
(448, 5, '', 'PriInsAddress2', '', '533', '75', '250', '14'), 
(449, 5, '', 'IsPTStudent', '', '495', '283', '0', '0'), 
(450, 5, '', 'PatientIsMarried', '', '435', '251', '0', '0'), 
(451, 5, '', 'PatientIsSingle', '', '373', '251', '0', '0'), 
(452, 5, '', 'IsNotOccupational', '', '435', '350', '0', '0'), 
(453, 5, '', 'IsNotAutoAccident', '', '435', '383', '0', '0'), 
(454, 5, '', 'IsNotOtherAccident', '', '435', '415', '0', '0'), 
(455, 5, '', 'OtherInsNotExists', '', '594', '449', '0', '0'), 
(456, 5, '', 'P1PlaceNumericCode', '', '216', '751', '28', '14'), 
(457, 5, '', 'P2PlaceNumericCode', '', '216', '784', '28', '14'), 
(458, 5, '', 'P3PlaceNumericCode', '', '217', '817', '28', '14'), 
(459, 5, '', 'P4PlaceNumericCode', '', '217', '850', '28', '14'), 
(460, 5, '', 'P5PlaceNumericCode', '', '217', '884', '28', '14'), 
(461, 5, '', 'P6PlaceNumericCode', '', '217', '917', '28', '14'), 
(462, 5, '', 'BillingDentistPh123', '', '526', '1019', '40', '14'), 
(463, 5, '', 'BillingDentistPh456', '', '567', '1019', '40', '14'), 
(464, 5, '', 'BillingDentistPh78910', '', '607', '1019', '50', '14'), 
(465, 5, '', 'BillingDentistNumIsSSN', '', '199', '951', '0', '0'), 
(466, 5, '', 'BillingDentistNumIsTIN', '', '219', '951', '0', '0'), 
(467, 4, '', 'BillingDentistNumIsTIN', '', '219', '951', '0', '0'), 
(468, 4, '', 'BillingDentistNumIsSSN', '', '199', '951', '0', '0'), 
(469, 4, '', 'BillingDentistPh78910', '', '607', '1019', '50', '14'), 
(470, 4, '', 'BillingDentistPh456', '', '567', '1019', '40', '14'), 
(471, 4, '', 'BillingDentistPh123', '', '526', '1019', '40', '14'), 
(472, 4, '', 'P6PlaceNumericCode', '', '217', '917', '28', '14'), 
(473, 4, '', 'P5PlaceNumericCode', '', '217', '884', '28', '14'), 
(474, 4, '', 'P4PlaceNumericCode', '', '217', '850', '28', '14'), 
(475, 4, '', 'P3PlaceNumericCode', '', '217', '817', '28', '14'), 
(476, 4, '', 'P2PlaceNumericCode', '', '216', '784', '28', '14'), 
(477, 4, '', 'P1PlaceNumericCode', '', '216', '751', '28', '14'), 
(478, 4, '', 'OtherInsNotExists', '', '594', '449', '0', '0'), 
(479, 4, '', 'IsNotOtherAccident', '', '435', '415', '0', '0'), 
(480, 4, '', 'IsNotAutoAccident', '', '435', '383', '0', '0'), 
(481, 4, '', 'IsNotOccupational', '', '435', '350', '0', '0'), 
(482, 4, '', 'PatientIsSingle', '', '373', '251', '0', '0'), 
(483, 4, '', 'PatientIsMarried', '', '435', '251', '0', '0'), 
(484, 4, '', 'IsPTStudent', '', '495', '283', '0', '0'), 
(485, 4, '', 'PriInsAddress2', '', '533', '75', '250', '14'), 
(486, 4, '', 'IsStandardClaim', '', '335', '152', '0', '0'), 
(487, 4, '', 'IsMedicaidClaim', '', '105', '152', '0', '0'), 
(488, 4, '', 'P6Date', 'MM    dd      yy', '131', '917', '80', '14'), 
(489, 4, '', 'P5Date', 'MM    dd      yy', '132', '884', '80', '14'), 
(490, 4, '', 'P4Date', 'MM    dd      yy', '132', '850', '80', '14'), 
(491, 4, '', 'P2Date', 'MM    dd      yy', '132', '784', '80', '14'), 
(492, 4, '', 'P1Date', 'MM    dd      yy', '132', '751', '80', '14'), 
(493, 4, '', 'P3Date', 'MM    dd      yy', '132', '817', '80', '14'), 
(494, 4, '', 'BillingDentistZip', '', '696', '1006', '80', '14'), 
(495, 4, '', 'BillingDentistST', '', '666', '1006', '30', '14'), 
(496, 4, '', 'BillingDentistCity', '', '526', '1006', '139', '14'), 
(497, 4, '', 'BillingDentistAddress', '', '526', '993', '250', '14'), 
(498, 4, '', 'BillingDentist', '', '526', '980', '250', '14'), 
(499, 4, '', 'TotalFee', '', '621', '948', '75', '14'), 
(500, 4, '', 'BillingDentistSSNorTIN', '', '47', '949', '131', '14'), 
(501, 4, '', 'P6Fee', '', '598', '915', '75', '14'), 
(502, 4, '', 'P6Code', '', '278', '917', '65', '14'), 
(503, 4, '', 'P6Date', 'MM    dd      yy', '45', '917', '80', '14'), 
(504, 4, '', 'P5Fee', '', '598', '882', '75', '14'), 
(505, 4, '', 'P5Code', '', '278', '883', '65', '14'), 
(506, 4, '', 'P5Date', 'MM    dd      yy', '44', '884', '80', '14'), 
(507, 4, '', 'P4Fee', '', '598', '849', '75', '14'), 
(508, 4, '', 'P4Code', '', '278', '851', '65', '14'), 
(509, 4, '', 'P4Date', 'MM    dd      yy', '44', '850', '80', '14'), 
(510, 4, '', 'P3Fee', '', '598', '816', '75', '14'), 
(511, 4, '', 'P3Date', 'MM    dd      yy', '44', '817', '80', '14'), 
(512, 4, '', 'P2Fee', '', '598', '782', '75', '14'), 
(513, 4, '', 'P2Code', '', '278', '785', '65', '14'), 
(514, 4, '', 'P1Fee', '', '598', '749', '75', '14'), 
(515, 4, '', 'P1Code', '', '278', '751', '65', '14'), 
(516, 4, '', 'P1Date', 'MM    dd      yy', '44', '751', '80', '14'), 
(517, 4, '', 'PriInsZip', '', '704', '89', '79', '14'), 
(518, 4, '', 'PriInsCity', '', '533', '89', '140', '14'), 
(519, 4, '', 'PriInsAddress', '', '533', '61', '250', '14'), 
(520, 4, '', 'PriInsCarrierName', '', '533', '47', '250', '14'), 
(521, 4, '', 'SubscrPhone', '', '673', '280', '120', '14'), 
(522, 4, '', 'PatientAssignment', '', '587', '510', '225', '14'), 
(523, 4, '', 'PatientReleaseDate', 'MM/dd/yyyy', '394', '510', '113', '14'), 
(524, 4, '', 'PatientRelease', '', '88', '510', '250', '14'), 
(525, 4, '', 'AccidentST', '', '477', '381', '25', '14'), 
(526, 4, '', 'IsOtherAccident', '', '376', '415', '0', '0'), 
(527, 4, '', 'IsAutoAccident', '', '376', '383', '0', '0'), 
(528, 4, '', 'IsOccupational', '', '376', '351', '0', '0'), 
(529, 4, '', 'OtherInsCarrierName', '', '49', '446', '250', '14'), 
(530, 4, '', 'OtherInsSubscrIsFemale', '', '266', '384', '0', '0'), 
(531, 4, '', 'OtherInsSubscrIsMale', '', '205', '384', '0', '0'), 
(532, 4, '', 'OtherInsSubscrDOB', 'MM     dd     yy', '45', '385', '100', '14'), 
(533, 4, '', 'OtherInsGroupNum', '', '47', '346', '250', '14'), 
(534, 4, '', 'OtherInsSubscrLastFirst', '', '47', '313', '250', '14'), 
(535, 4, '', 'IsFTStudent', '', '435', '283', '0', '0'), 
(536, 4, '', 'EmployerName', '', '533', '381', '250', '14'), 
(537, 4, '', 'SubscrIsFemale', '', '775', '348', '0', '0'), 
(538, 4, '', 'SubscrIsMale', '', '703', '348', '0', '0'), 
(539, 4, '', 'SubscrDOB', 'MM     dd     yy', '564', '350', '100', '14'), 
(540, 4, '', 'GroupNum', '', '528', '313', '250', '14'), 
(541, 4, '', 'SubscrZip', '', '528', '280', '100', '14'), 
(542, 4, '', 'SubscrST', '', '759', '245', '50', '14'), 
(543, 4, '', 'SubscrCity', '', '528', '245', '200', '14'), 
(544, 4, '', 'SubscrAddress', '', '528', '213', '250', '14'), 
(545, 4, '', 'RelatIsOther', '', '495', '214', '0', '0'), 
(546, 4, '', 'RelatIsChild', '', '445', '214', '0', '0'), 
(547, 4, '', 'RelatIsSpouse', '', '405', '214', '0', '0'), 
(548, 4, '', 'RelatIsSelf', '', '353', '215', '0', '0'), 
(549, 4, '', 'PatientZip', '', '47', '281', '100', '14'), 
(550, 4, '', 'PatientST', '', '287', '245', '30', '14'), 
(551, 4, '', 'PatientCity', '', '47', '245', '200', '14'), 
(552, 4, '', 'PatientAddress', '', '47', '213', '250', '14'), 
(553, 4, '', 'SubscrLastFirst', '', '528', '180', '250', '14'), 
(554, 4, '', 'PatientIsFemale', '', '494', '183', '0', '0'), 
(555, 4, '', 'PatientIsMale', '', '444', '182', '0', '0'), 
(556, 4, '', 'PatientDOB', 'MM     dd     yy', '336', '183', '90', '14'), 
(557, 4, '', 'PatientPhone', '', '177', '281', '120', '14'), 
(558, 4, '', 'PatientLastFirst', '', '47', '180', '250', '13'), 
(559, 4, 'HCFA1500.gif', '', '', '5', '2', '843', '1170'), 
(560, 5, 'HCFA1500.gif', '', '', '5', '2', '843', '1170'), 
(561, 4, '', 'P3Code', '', '278', '817', '65', '14'), 
(562, 4, '', 'P2Date', 'MM    dd      yy', '44', '784', '80', '14'), 
(563, 4, '', 'PriInsST', '', '674', '89', '30', '14'), 
(564, 4, '', 'OtherInsExists', '', '544', '450', '0', '0'), 
(565, 4, '', 'PriInsCarrierName', '', '533', '413', '250', '14'), 
(566, 1, 'ADA2002.gif', '', '', '9', '0', '834', '1058'), 
(567, 1, '', 'IsPreAuth', '', '205', '67', '0', '0'), 
(568, 1, '', 'IsStandardClaim', '', '51', '67', '0', '0'), 
(569, 1, '', 'PreAuthString', '', '48', '112', '200', '14'), 
(570, 1, '', 'PriInsCarrierName', '', '95', '161', '320', '14'), 
(571, 1, '', 'PriInsAddress', '', '95', '177', '320', '14'), 
(572, 1, '', 'PriInsAddress2', '', '95', '193', '320', '14'), 
(573, 1, '', 'PriInsCity', '', '95', '209', '150', '14'), 
(574, 1, '', 'PriInsST', '', '251', '209', '40', '14'), 
(575, 1, '', 'OtherInsSubscrLastFirst', '', '48', '272', '340', '14'), 
(576, 1, '', 'OtherInsExists', '', '291', '243', '0', '14'), 
(577, 1, '', 'OtherInsNotExists', '', '196', '243', '0', '14'), 
(578, 1, '', 'OtherInsSubscrDOB', 'MM/dd/yyyy', '48', '304', '100', '14'), 
(579, 1, '', 'PriInsZip', '', '309', '209', '100', '14'), 
(580, 1, '', 'OtherInsSubscrIsMale', '', '186', '307', '0', '14'), 
(581, 1, '', 'OtherInsSubscrIsFemale', '', '215', '307', '0', '14'), 
(582, 1, '', 'OtherInsSubscrID', '', '261', '304', '130', '14'), 
(583, 1, '', 'OtherInsGroupNum', '', '48', '334', '111', '14'), 
(584, 1, '', 'OtherInsRelatIsSelf', '', '186', '339', '0', '14'), 
(585, 1, '', 'OtherInsRelatIsSpouse', '', '234', '339', '0', '14'), 
(586, 1, '', 'OtherInsRelatIsChild', '', '292', '339', '0', '14'), 
(587, 1, '', 'OtherInsRelatIsOther', '', '359', '339', '0', '14'), 
(588, 1, '', 'OtherInsCarrierName', '', '48', '369', '360', '14'), 
(589, 1, '', 'OtherInsAddress', '', '48', '385', '360', '14'), 
(590, 1, '', 'OtherInsCity', '', '48', '401', '170', '14'), 
(591, 1, '', 'SubscrLastFirst', '', '444', '128', '350', '14'), 
(592, 1, '', 'OtherInsST', '', '236', '401', '40', '14'), 
(593, 1, '', 'OtherInsZip', '', '297', '401', '90', '14'), 
(594, 1, '', 'SubscrAddress', '', '444', '143', '350', '14'), 
(595, 1, '', 'SubscrAddress2', '', '444', '159', '350', '14'), 
(596, 1, '', 'SubscrCity', '', '444', '175', '140', '14'), 
(597, 1, '', 'SubscrST', '', '600', '175', '58', '14'), 
(598, 1, '', 'SubscrZip', '', '671', '175', '110', '14'), 
(599, 1, '', 'SubscrDOB', 'MM/dd/yyyy', '444', '208', '100', '14'), 
(600, 1, '', 'SubscrIsMale', '', '579', '211', '0', '0'), 
(601, 1, '', 'SubscrIsFemale', '', '608', '211', '0', '0'), 
(602, 1, '', 'SubscrID', '', '656', '208', '120', '14'), 
(603, 1, '', 'GroupNum', '', '444', '240', '95', '14'), 
(604, 1, '', 'EmployerName', '', '574', '240', '230', '14'), 
(605, 1, '', 'RelatIsSelf', '', '445', '292', '0', '0'), 
(606, 1, '', 'RelatIsSpouse', '', '493', '292', '0', '0'), 
(607, 1, '', 'RelatIsChild', '', '551', '291', '0', '0'), 
(608, 1, '', 'RelatIsOther', '', '637', '292', '0', '0'), 
(609, 1, '', 'IsFTStudent', '', '714', '291', '0', '0'), 
(610, 1, '', 'IsPTStudent', '', '762', '291', '0', '0'), 
(611, 1, '', 'PatientLastFirst', '', '444', '321', '350', '14'), 
(612, 1, '', 'PatientAddress', '', '444', '337', '350', '14'), 
(613, 1, '', 'PatientAddress2', '', '444', '353', '350', '14'), 
(614, 1, '', 'PatientCity', '', '444', '369', '140', '14'), 
(615, 1, '', 'PatientST', '', '598', '369', '58', '14'), 
(616, 1, '', 'PatientZip', '', '669', '369', '110', '14'), 
(617, 1, '', 'PatientDOB', 'MM/dd/yyyy', '444', '401', '90', '14'), 
(618, 1, '', 'PatientIsMale', '', '580', '403', '0', '0'), 
(619, 1, '', 'PatientIsFemale', '', '608', '403', '0', '0'), 
(620, 1, '', 'PatientSSN', '', '646', '401', '100', '14'), 
(621, 1, '', 'P1Date', 'MM/dd/yyyy', '51', '466', '96', '14'), 
(622, 1, '', 'P1Area', '', '154', '466', '28', '14'), 
(623, 1, '', 'P1System', '', '182', '466', '28', '14'), 
(624, 1, '', 'P1ToothNumber', '', '210', '466', '116', '14'), 
(625, 1, '', 'P1Surface', '', '326', '466', '57', '14'), 
(626, 1, '', 'P1Code', '', '384', '466', '56', '14'), 
(627, 1, '', 'P1Description', '', '441', '466', '307', '14'), 
(628, 1, '', 'P1Fee', '', '810', '466', '60', '14'), 
(629, 1, '', 'P2Date', 'MM/dd/yyyy', '51', '482', '96', '14'), 
(630, 1, '', 'P2Area', '', '154', '482', '28', '14'), 
(631, 1, '', 'P2System', '', '182', '482', '28', '14'), 
(632, 1, '', 'P2ToothNumber', '', '210', '482', '116', '14'), 
(633, 1, '', 'P2Surface', '', '326', '482', '57', '14'), 
(634, 1, '', 'P2Code', '', '384', '483', '56', '14'), 
(635, 1, '', 'P2Description', '', '441', '482', '307', '14'), 
(636, 1, '', 'P2Fee', '', '810', '482', '60', '14'), 
(637, 1, '', 'P3Date', 'MM/dd/yyyy', '51', '498', '96', '14'), 
(638, 1, '', 'P3Area', '', '154', '498', '28', '14'), 
(639, 1, '', 'P3System', '', '183', '498', '28', '14'), 
(640, 1, '', 'P3ToothNumber', '', '211', '498', '116', '14'), 
(641, 1, '', 'P3Surface', '', '327', '498', '57', '14'), 
(642, 1, '', 'P3Code', '', '385', '499', '56', '14'), 
(643, 1, '', 'P3Description', '', '441', '498', '307', '14'), 
(644, 1, '', 'P3Fee', '', '810', '498', '60', '14'), 
(645, 1, '', 'P4Date', 'MM/dd/yyyy', '51', '514', '96', '14'), 
(646, 1, '', 'P4Area', '', '154', '514', '28', '14'), 
(647, 1, '', 'P4System', '', '183', '514', '28', '14'), 
(648, 1, '', 'P4ToothNumber', '', '211', '514', '116', '14'), 
(649, 1, '', 'P4Surface', '', '327', '514', '57', '14'), 
(650, 1, '', 'P4Code', '', '385', '515', '56', '14'), 
(651, 1, '', 'P4Description', '', '441', '514', '307', '14'), 
(652, 1, '', 'P4Fee', '', '810', '514', '60', '14'), 
(653, 1, '', 'P5Date', 'MM/dd/yyyy', '51', '531', '96', '14'), 
(654, 1, '', 'P5Area', '', '154', '531', '28', '14'), 
(655, 1, '', 'P5System', '', '182', '531', '28', '14'), 
(656, 1, '', 'P5ToothNumber', '', '210', '531', '116', '14'), 
(657, 1, '', 'P5Surface', '', '326', '531', '57', '14'), 
(658, 1, '', 'P5Code', '', '384', '531', '56', '14'), 
(659, 1, '', 'P5Description', '', '441', '531', '307', '14'), 
(660, 1, '', 'P5Fee', '', '810', '531', '60', '14'), 
(661, 1, '', 'P6Date', 'MM/dd/yyyy', '51', '547', '96', '14'), 
(662, 1, '', 'P6Area', '', '154', '547', '28', '14'), 
(663, 1, '', 'P6System', '', '182', '547', '28', '14'), 
(664, 1, '', 'P6ToothNumber', '', '210', '546', '116', '14'), 
(665, 1, '', 'P6Surface', '', '326', '547', '57', '14'), 
(666, 1, '', 'P6Code', '', '384', '546', '56', '14'), 
(667, 1, '', 'P6Description', '', '441', '546', '307', '14'), 
(668, 1, '', 'P6Fee', '', '810', '546', '60', '14'), 
(669, 1, '', 'P7Date', 'MM/dd/yyyy', '51', '562', '96', '14'), 
(670, 1, '', 'P7Area', '', '154', '562', '28', '14'), 
(671, 1, '', 'P7System', '', '182', '562', '28', '14'), 
(672, 1, '', 'P7ToothNumber', '', '210', '562', '116', '14'), 
(673, 1, '', 'P7Surface', '', '326', '562', '57', '14'), 
(674, 1, '', 'P7Code', '', '384', '562', '56', '14'), 
(675, 1, '', 'P7Description', '', '441', '562', '307', '14'), 
(676, 1, '', 'P7Fee', '', '810', '562', '60', '14'), 
(677, 1, '', 'P8Date', 'MM/dd/yyyy', '51', '578', '96', '14'), 
(678, 1, '', 'P8Area', '', '154', '578', '28', '14'), 
(679, 1, '', 'P8System', '', '182', '578', '28', '14'), 
(680, 1, '', 'P8ToothNumber', '', '210', '578', '116', '14'), 
(681, 1, '', 'P8Surface', '', '326', '578', '57', '14'), 
(682, 1, '', 'P8Code', '', '384', '578', '56', '14'), 
(683, 1, '', 'P8Description', '', '441', '578', '307', '14'), 
(684, 1, '', 'P8Fee', '', '810', '578', '60', '14'), 
(685, 1, '', 'P9Date', 'MM/dd/yyyy', '51', '594', '96', '14'), 
(686, 1, '', 'P9Area', '', '154', '594', '28', '14'), 
(687, 1, '', 'P9System', '', '182', '594', '28', '14'), 
(688, 1, '', 'P9ToothNumber', '', '210', '594', '116', '14'), 
(689, 1, '', 'P9Surface', '', '326', '594', '57', '14'), 
(690, 1, '', 'P9Code', '', '384', '594', '56', '14'), 
(691, 1, '', 'P9Description', '', '441', '594', '307', '14'), 
(692, 1, '', 'P9Fee', '', '810', '594', '60', '14'), 
(693, 1, '', 'P10Date', 'MM/dd/yyyy', '51', '609', '96', '14'), 
(694, 1, '', 'P10Area', '', '154', '609', '28', '14'), 
(695, 1, '', 'P10System', '', '182', '609', '28', '14'), 
(696, 1, '', 'P10ToothNumber', '', '210', '609', '116', '14'), 
(697, 1, '', 'P10Surface', '', '326', '610', '57', '14'), 
(698, 1, '', 'P10Code', '', '384', '610', '56', '14'), 
(699, 1, '', 'P10Description', '', '441', '610', '307', '14'), 
(700, 1, '', 'P10Fee', '', '810', '610', '60', '14'), 
(701, 1, '', 'TotalFee', '', '810', '658', '60', '14'), 
(702, 1, '', 'Miss1', '', '194', '641', '0', '0'), 
(703, 1, '', 'Miss2', '', '215', '641', '0', '0'), 
(704, 1, '', 'Miss3', '', '234', '641', '0', '0'), 
(705, 1, '', 'Miss4', '', '253', '641', '0', '0'), 
(706, 1, '', 'Miss5', '', '272', '641', '0', '0'), 
(707, 1, '', 'Miss6', '', '291', '641', '0', '0'), 
(708, 1, '', 'Miss7', '', '311', '641', '0', '0'), 
(709, 1, '', 'Miss8', '', '329', '641', '0', '0'), 
(710, 1, '', 'Miss9', '', '349', '641', '0', '0'), 
(711, 1, '', 'Miss10', '', '368', '641', '0', '0'), 
(712, 1, '', 'Miss11', '', '387', '641', '0', '0'), 
(713, 1, '', 'Miss12', '', '407', '641', '0', '0'), 
(714, 1, '', 'Miss13', '', '426', '641', '0', '0'), 
(715, 1, '', 'Miss14', '', '445', '641', '0', '0'), 
(716, 1, '', 'Miss15', '', '464', '641', '0', '0'), 
(717, 1, '', 'Miss16', '', '484', '641', '0', '0'), 
(718, 1, '', 'Miss17', '', '483', '656', '0', '0'), 
(719, 1, '', 'Miss18', '', '464', '656', '0', '0'), 
(720, 1, '', 'Miss19', '', '445', '656', '0', '0'), 
(721, 1, '', 'Miss20', '', '426', '656', '0', '0'), 
(722, 1, '', 'Miss21', '', '407', '656', '0', '0'), 
(723, 1, '', 'Miss22', '', '387', '656', '0', '0'), 
(724, 1, '', 'Miss23', '', '369', '656', '0', '0'), 
(725, 1, '', 'Miss24', '', '349', '656', '0', '0'), 
(726, 1, '', 'Miss25', '', '329', '656', '0', '0'), 
(727, 1, '', 'Miss26', '', '310', '656', '0', '0'), 
(728, 1, '', 'Miss27', '', '291', '656', '0', '0'), 
(729, 1, '', 'Miss28', '', '272', '656', '0', '0'), 
(730, 1, '', 'Miss29', '', '252', '656', '0', '0'), 
(731, 1, '', 'Miss30', '', '234', '656', '0', '0'), 
(732, 1, '', 'Miss31', '', '215', '656', '0', '0'), 
(733, 1, '', 'Miss32', '', '195', '657', '0', '0'), 
(734, 1, '', 'Remarks', '', '86', '674', '720', '30'), 
(735, 1, '', 'PatientRelease', '', '52', '772', '240', '14'), 
(736, 1, '', 'PatientReleaseDate', 'MM/dd/yyyy', '312', '772', '110', '14'), 
(737, 1, '', 'PatientAssignment', '', '52', '836', '240', '14'), 
(738, 1, '', 'PatientAssignmentDate', 'MM/dd/yyyy', '312', '836', '110', '14'), 
(739, 1, '', 'PlaceIsOffice', '', '445', '738', '0', '0'), 
(740, 1, '', 'PlaceIsHospADA2002', '', '522', '738', '0', '0'), 
(741, 1, '', 'PlaceIsExtCareFacilityADA2002', '', '570', '738', '0', '0'), 
(742, 1, '', 'PlaceIsOtherADA2002', '', '608', '738', '0', '0'), 
(743, 1, '', 'IsNotOrtho', '', '445', '770', '0', '0'), 
(744, 1, '', 'IsOrtho', '', '532', '770', '0', '0'), 
(745, 1, '', 'DateOrthoPlaced', 'MM/dd/yyyy', '664', '769', '110', '14'), 
(746, 1, '', 'MonthsOrthoRemaining', '', '489', '801', '30', '14'), 
(747, 1, '', 'IsNotReplacementProsth', '', '532', '802', '0', '0'), 
(748, 1, '', 'IsReplacementProsth', '', '560', '802', '0', '0'), 
(749, 1, '', 'DatePriorProsthPlaced', 'MM/dd/yyyy', '664', '800', '110', '14'), 
(750, 1, '', 'IsOccupational', '', '444', '834', '0', '0'), 
(751, 1, '', 'IsAutoAccident', '', '589', '834', '0', '0'), 
(752, 1, '', 'IsOtherAccident', '', '685', '834', '0', '0'), 
(753, 1, '', 'AccidentDate', 'MM/dd/yyyy', '569', '850', '110', '14'), 
(754, 1, '', 'AccidentST', '', '775', '850', '35', '14'), 
(755, 1, '', 'BillingDentist', '', '51', '910', '350', '14'), 
(756, 1, '', 'BillingDentistAddress', '', '51', '926', '350', '14'), 
(757, 1, '', 'BillingDentistAddress2', '', '51', '942', '350', '14'), 
(758, 1, '', 'BillingDentistCity', '', '51', '958', '165', '14'), 
(759, 1, '', 'BillingDentistST', '', '227', '958', '40', '14'), 
(760, 1, '', 'BillingDentistZip', '', '277', '958', '110', '14'), 
(761, 1, '', 'BillingDentistLicenseNum', '', '170', '991', '100', '14'), 
(762, 1, '', 'BillingDentistSSNorTIN', '', '297', '991', '115', '14'), 
(763, 1, '', 'BillingDentistPh123', '', '118', '1009', '30', '14'), 
(764, 1, '', 'BillingDentistPh456', '', '156', '1009', '30', '14'), 
(765, 1, '', 'BillingDentistPh78910', '', '197', '1009', '50', '14'), 
(766, 1, '', 'TreatingDentistSignature', '', '444', '913', '245', '14'), 
(767, 1, '', 'TreatingDentistSigDate', 'MM/dd/yyyy', '704', '913', '100', '14'), 
(768, 1, '', 'TreatingDentistLicense', '', '686', '945', '115', '14'), 
(769, 1, '', 'TreatingDentistAddress', '', '443', '974', '350', '14'), 
(770, 1, '', 'TreatingDentistCity', '', '443', '991', '165', '14'), 
(771, 1, '', 'TreatingDentistST', '', '617', '991', '40', '14'), 
(772, 1, '', 'TreatingDentistZip', '', '670', '991', '110', '14'), 
(773, 1, '', 'TreatingDentistPh123', '', '502', '1009', '30', '14'), 
(774, 1, '', 'TreatingDentistPh456', '', '540', '1009', '30', '14'), 
(775, 1, '', 'TreatingDentistPh78910', '', '579', '1009', '40', '14'), 
(776, 1, '', 'TreatingProviderSpecialty', '', '694', '1009', '120', '14'), 
(777, 2, 'DentiCal.jpg', '', '', '0', '11', '0', '0'), 
(778, 2, '', 'PatientIsMale', '', '409', '90', '0', '0'), 
(779, 2, '', 'PatientLastFirst', '', '38', '89', '225', '14'), 
(780, 2, '', 'PatientSSN', '', '278', '89', '125', '14'), 
(781, 2, '', 'PatientIsFemale', '', '437', '90', '0', '0'), 
(782, 2, '', 'PatientAddress', '', '38', '121', '500', '14'), 
(783, 2, '', 'PatientCity', '', '38', '155', '300', '14'), 
(784, 2, '', 'PatientST', '', '348', '155', '100', '14'), 
(785, 2, '', 'PatientZip', '', '486', '155', '100', '14'), 
(786, 2, '', 'OtherInsExists', '', '599', '186', '0', '0'), 
(787, 2, '', 'IsOtherAccident', '', '396', '187', '0', '0'), 
(788, 2, '', 'IsOccupational', '', '395', '220', '0', '0'), 
(789, 2, '', 'IsAutoAccident', '', '395', '187', '0', '0'), 
(790, 2, '', 'BillingDentist', '', '38', '288', '245', '14'), 
(791, 2, '', 'BillingDentistAddress', '', '38', '321', '245', '14'), 
(792, 2, '', 'BillingDentistCity', '', '38', '355', '200', '14'), 
(793, 2, '', 'BillingDentistST', '', '244', '355', '75', '14'), 
(794, 2, '', 'BillingDentistZip', '', '345', '355', '100', '14'), 
(795, 2, '', 'PlaceIsOffice', '', '31', '398', '0', '0'), 
(796, 2, '', 'PlaceIsSkilledNursFac', '', '155', '399', '131', '0'), 
(797, 2, '', 'PlaceIsPatientsHome', '', '71', '399', '131', '0'), 
(798, 2, '', 'Miss1', '', '38', '517', '0', '0'), 
(799, 2, '', 'Miss2', '', '38', '501', '0', '0'), 
(800, 2, '', 'Miss3', '', '41', '486', '0', '0'), 
(801, 2, '', 'Miss4', '', '48', '472', '0', '0'), 
(802, 2, '', 'Miss5', '', '57', '461', '0', '0'), 
(803, 2, '', 'Miss6', '', '69', '451', '0', '0'), 
(804, 2, '', 'Miss7', '', '82', '444', '0', '0'), 
(805, 2, '', 'Miss8', '', '97', '441', '0', '0'), 
(806, 2, '', 'Miss9', '', '113', '441', '0', '0'), 
(807, 2, '', 'Miss10', '', '129', '444', '0', '0'), 
(808, 2, '', 'Miss11', '', '143', '451', '0', '0'), 
(809, 2, '', 'Miss12', '', '155', '461', '0', '0'), 
(810, 2, '', 'Miss13', '', '164', '473', '0', '0'), 
(811, 2, '', 'Miss14', '', '170', '486', '0', '0'), 
(812, 2, '', 'Miss15', '', '172', '502', '0', '0'), 
(813, 2, '', 'Miss16', '', '173', '518', '0', '0'), 
(814, 2, '', 'Miss17', '', '172', '601', '0', '0'), 
(815, 2, '', 'Miss18', '', '172', '617', '0', '0'), 
(816, 2, '', 'Miss19', '', '169', '631', '0', '0'), 
(817, 2, '', 'Miss20', '', '163', '645', '0', '0'), 
(818, 2, '', 'Miss21', '', '154', '656', '0', '0'), 
(819, 2, '', 'Miss22', '', '142', '666', '0', '0'), 
(820, 2, '', 'Miss23', '', '128', '673', '0', '0'), 
(821, 2, '', 'Miss24', '', '113', '676', '0', '0'), 
(822, 2, '', 'Miss25', '', '97', '676', '0', '0'), 
(823, 2, '', 'Miss26', '', '82', '673', '0', '0'), 
(824, 2, '', 'Miss27', '', '68', '667', '0', '0'), 
(825, 2, '', 'Miss28', '', '57', '656', '0', '0'), 
(826, 2, '', 'Miss29', '', '47', '645', '0', '0'), 
(827, 2, '', 'Miss30', '', '42', '631', '0', '0'), 
(828, 2, '', 'Miss31', '', '38', '617', '0', '0'), 
(829, 2, '', 'Miss32', '', '38', '601', '0', '0'), 
(830, 2, '', 'Remarks', '', '33', '730', '565', '57'), 
(831, 2, '', 'P1ToothNumber', '', '203', '467', '20', '14'), 
(832, 2, '', 'P1Surface', '', '223', '467', '38', '14'), 
(833, 2, '', 'P1Description', '', '281', '467', '231', '14'), 
(834, 2, '', 'P1Date', 'MM/dd/yy', '514', '467', '58', '14'), 
(835, 2, '', 'P1Code', '', '596', '467', '47', '14'), 
(836, 2, '', 'P1Fee', '', '711', '467', '63', '14'), 
(837, 2, '', 'P2ToothNumber', '', '203', '484', '20', '14'), 
(838, 2, '', 'P2Surface', '', '223', '484', '38', '14'), 
(839, 2, '', 'P2Description', '', '281', '484', '231', '14'), 
(840, 2, '', 'P2Date', 'MM/dd/yy', '514', '484', '58', '14'), 
(841, 2, '', 'P2Code', '', '596', '484', '47', '14'), 
(842, 2, '', 'P2Fee', '', '711', '484', '63', '14'), 
(843, 2, '', 'P3ToothNumber', '', '203', '500', '20', '14'), 
(844, 2, '', 'P3Surface', '', '223', '500', '38', '14'), 
(845, 2, '', 'P3Description', '', '281', '500', '231', '14'), 
(846, 2, '', 'P3Date', 'MM/dd/yy', '514', '500', '58', '14'), 
(847, 2, '', 'P3Code', '', '596', '500', '47', '14'), 
(848, 2, '', 'P3Fee', '', '711', '500', '63', '14'), 
(849, 2, '', 'P4ToothNumber', '', '203', '517', '20', '14'), 
(850, 2, '', 'P4Surface', '', '223', '517', '38', '14'), 
(851, 2, '', 'P4Description', '', '281', '517', '231', '14'), 
(852, 2, '', 'P4Date', 'MM/dd/yy', '514', '517', '58', '14'), 
(853, 2, '', 'P4Code', '', '596', '517', '47', '14'), 
(854, 2, '', 'P4Fee', '', '711', '517', '63', '14'), 
(855, 2, '', 'P5ToothNumber', '', '203', '533', '20', '14'), 
(856, 2, '', 'P5Surface', '', '223', '533', '38', '14'), 
(857, 2, '', 'P5Description', '', '281', '533', '231', '14'), 
(858, 2, '', 'P5Date', 'MM/dd/yy', '514', '533', '58', '14'), 
(859, 2, '', 'P5Code', '', '596', '533', '47', '14'), 
(860, 2, '', 'P5Fee', '', '711', '533', '63', '14'), 
(861, 2, '', 'P6ToothNumber', '', '203', '550', '20', '14'), 
(862, 2, '', 'P6Surface', '', '223', '550', '38', '14'), 
(863, 2, '', 'P6Description', '', '281', '550', '231', '14'), 
(864, 2, '', 'P6Date', 'MM/dd/yy', '514', '550', '58', '14'), 
(865, 2, '', 'P6Code', '', '596', '550', '47', '14'), 
(866, 2, '', 'P6Fee', '', '711', '550', '63', '14'), 
(867, 2, '', 'P7ToothNumber', '', '203', '567', '20', '14'), 
(868, 2, '', 'P7Surface', '', '223', '567', '38', '14'), 
(869, 2, '', 'P7Description', '', '281', '567', '231', '14'), 
(870, 2, '', 'P7Date', 'MM/dd/yy', '514', '567', '58', '14'), 
(871, 2, '', 'P7Code', '', '596', '567', '47', '14'), 
(872, 2, '', 'P7Fee', '', '711', '567', '63', '14'), 
(873, 2, '', 'P8ToothNumber', '', '203', '584', '20', '14'), 
(874, 2, '', 'P8Surface', '', '223', '584', '38', '14'), 
(875, 2, '', 'P8Description', '', '281', '584', '231', '14'), 
(876, 2, '', 'P8Date', 'MM/dd/yy', '514', '584', '58', '14'), 
(877, 2, '', 'P8Code', '', '596', '584', '47', '14'), 
(878, 2, '', 'P8Fee', '', '711', '584', '63', '14'), 
(879, 2, '', 'P9ToothNumber', '', '203', '601', '20', '14'), 
(880, 2, '', 'P9Surface', '', '223', '601', '38', '14'), 
(881, 2, '', 'P9Description', '', '281', '601', '231', '14'), 
(882, 2, '', 'P9Date', 'MM/dd/yy', '514', '601', '58', '14'), 
(883, 2, '', 'P9Code', '', '596', '601', '47', '14'), 
(884, 2, '', 'P9Fee', '', '711', '601', '63', '14'), 
(885, 2, '', 'P10ToothNumber', '', '203', '617', '20', '14'), 
(886, 2, '', 'P10Surface', '', '223', '617', '38', '14'), 
(887, 2, '', 'P10Description', '', '281', '617', '231', '14'), 
(888, 2, '', 'P10Date', 'MM/dd/yy', '514', '617', '58', '14'), 
(889, 2, '', 'P10Code', '', '596', '617', '47', '14'), 
(890, 2, '', 'P10Fee', '', '711', '617', '63', '14'), 
(891, 2, '', 'TotalFee', '', '817', '723', '90', '14'), 
(892, 2, '', 'TreatingDentistSignature', '', '41', '877', '260', '14'), 
(893, 2, '', 'TreatingDentistSigDate', 'MM/dd/yyyy', '324', '876', '100', '14'), 
(894, 2, '', 'BillingDentistPh123', '', '300', '322', '40', '14'), 
(895, 2, '', 'BillingDentistPh456', '', '348', '322', '40', '14'), 
(896, 2, '', 'BillingDentistPh78910', '', '392', '322', '63', '14'), 
(897, 2, '', 'TreatingDentistSigDate', 'MM/dd/yyyy', '716', '836', '100', '14'), 
(898, 2, '', 'PlaceIsInpatHosp', '', '233', '399', '0', '0'), 
(899, 2, '', 'PlaceIsOutpatHosp', '', '273', '399', '0', '0'), 
(900, 2, '', 'PlaceIsOtherLocation', '', '311', '399', '0', '0'), 
(901, 2, '', 'IsOrtho', '', '810', '252', '0', '0'), 
(902, 2, '', 'PatientDOB', 'MM          dd         yy', '473', '90', '115', '14'), 
(903, 2, '', 'PatientMedicaidID', '', '596', '88', '130', '14'), 
(904, 2, '', 'PlaceIsAdultLivCareFac', '', '193', '399', '0', '0'), 
(905, 2, '', 'BillingDentistMedicaidID', '', '299', '289', '137', '14'), 
(906, 2, '', 'P2TreatDentMedicaidID', '', '718', '484', '100', '14'), 
(907, 2, '', 'P1TreatDentMedicaidID', '', '718', '467', '100', '14'), 
(908, 2, '', 'P3TreatDentMedicaidID', '', '718', '500', '100', '14'), 
(909, 2, '', 'P4TreatDentMedicaidID', '', '718', '517', '100', '14'), 
(910, 2, '', 'P5TreatDentMedicaidID', '', '718', '533', '100', '14'), 
(911, 2, '', 'P6TreatDentMedicaidID', '', '718', '550', '100', '14'), 
(912, 2, '', 'P7TreatDentMedicaidID', '', '718', '567', '100', '14'), 
(913, 2, '', 'P8TreatDentMedicaidID', '', '718', '584', '100', '14'), 
(914, 2, '', 'P9TreatDentMedicaidID', '', '718', '601', '100', '14'), 
(915, 2, '', 'P10TreatDentMedicaidID', '', '718', '617', '100', '14'), 
(916, 3, 'ADA2000.jpg', '', '', '25', '13', '0', '0'), 
(917, 3, '', 'IsPreAuth', '', '49', '52', '0', '0'), 
(918, 3, '', 'IsStandardClaim', '', '49', '65', '0', '0'), 
(919, 3, '', 'PreAuthString', '', '183', '98', '120', '14'), 
(920, 3, '', 'PriInsCarrierName', '', '393', '59', '400', '14'), 
(921, 3, '', 'PriInsAddress', '', '376', '86', '260', '14'), 
(922, 3, '', 'PriInsCity', '', '361', '106', '275', '14'), 
(923, 3, '', 'PriInsST', '', '676', '109', '25', '14'), 
(924, 3, '', 'PriInsZip', '', '720', '108', '80', '14'), 
(925, 3, '', 'PatientLastFirst', '', '69', '143', '250', '14'), 
(926, 3, '', 'PatientAddress', '', '339', '143', '200', '14'), 
(927, 3, '', 'PatientCity', '', '581', '143', '175', '14'), 
(928, 3, '', 'PatientDOB', 'MM        dd        yyyy', '83', '175', '115', '14'), 
(929, 3, '', 'OtherInsSubscrDOB', 'MM        dd       yyyy', '465', '303', '120', '14'), 
(930, 3, '', 'PatientID-MedicaidOrSSN', '', '214', '175', '150', '14'), 
(931, 3, '', 'PatientIsMale', '', '393', '173', '0', '0'), 
(932, 3, '', 'PatientIsFemale', '', '422', '173', '0', '0'), 
(933, 3, '', 'PatientST', '', '762', '143', '45', '14'), 
(934, 3, '', 'PatientZip', '', '681', '174', '100', '14'), 
(935, 3, '', 'RelatIsSelf', '', '64', '205', '0', '0'), 
(936, 3, '', 'RelatIsSpouse', '', '90', '205', '0', '0'), 
(937, 3, '', 'RelatIsChild', '', '130', '205', '0', '0'), 
(938, 3, '', 'RelatIsOther', '', '161', '205', '0', '0'), 
(939, 3, '', 'SubscrID', '', '78', '245', '100', '14'), 
(940, 3, '', 'EmployerName', '', '201', '245', '89', '14'), 
(941, 3, '', 'GroupNum', '', '354', '245', '64', '14'), 
(942, 3, '', 'SubscrLastFirst', '', '78', '274', '300', '14'), 
(943, 3, '', 'SubscrAddress', '', '78', '303', '235', '14'), 
(944, 3, '', 'SubscrCity', '', '78', '335', '175', '14'), 
(945, 3, '', 'SubscrST', '', '269', '335', '45', '14'), 
(946, 3, '', 'SubscrZip', '', '335', '335', '75', '14'), 
(947, 3, '', 'SubscrIsMale', '', '388', '367', '0', '0'), 
(948, 3, '', 'SubscrIsFemale', '', '410', '367', '0', '0'), 
(949, 3, '', 'OtherInsExists', '', '548', '245', '0', '0'), 
(950, 3, '', 'OtherInsNotExists', '', '458', '245', '0', '0'), 
(951, 3, '', 'OtherInsExists', '', '577', '245', '0', '0'), 
(952, 3, '', 'OtherInsGroupNum', '', '715', '243', '90', '14'), 
(953, 3, '', 'OtherInsSubscrLastFirst', '', '470', '273', '300', '14'), 
(954, 3, '', 'OtherInsSubscrIsMale', '', '623', '304', '0', '0'), 
(955, 3, '', 'OtherInsSubscrIsFemale', '', '642', '304', '0', '0'), 
(956, 3, '', 'PatientRelease', '', '78', '435', '210', '14'), 
(957, 3, '', 'PatientReleaseDate', 'MM/dd/yyyy', '295', '435', '113', '14'), 
(958, 3, '', 'PatientAssignment', '', '468', '436', '180', '14'), 
(959, 3, '', 'PatientAssignmentDate', 'MM/dd/yyyy', '653', '436', '100', '14'), 
(960, 3, '', 'TreatingProviderSpecialty', '', '212', '62', '100', '14'), 
(961, 3, '', 'BillingDentistPh123', '', '391', '485', '28', '14'), 
(962, 3, '', 'BillingDentistPh456', '', '424', '485', '30', '14'), 
(963, 3, '', 'BillingDentistPh78910', '', '457', '485', '75', '14'), 
(964, 3, '', 'BillingDentist', '', '78', '488', '275', '14'), 
(965, 3, '', 'BillingDentistAddress', '', '78', '517', '275', '14'), 
(966, 3, '', 'BillingDentistCity', '', '78', '549', '150', '14'), 
(967, 3, '', 'BillingDentistST', '', '260', '549', '40', '14'), 
(968, 3, '', 'BillingDentistZip', '', '313', '549', '65', '14'), 
(969, 3, '', 'BillingDentistMedicaidID', '', '545', '488', '100', '14'), 
(970, 3, '', 'BillingDentistSSNorTIN', '', '671', '488', '131', '14'), 
(971, 3, '', 'BillingDentistLicenseNum', '', '385', '517', '125', '14'), 
(972, 3, '', 'PlaceIsOffice', '', '655', '516', '0', '0'), 
(973, 3, '', 'PlaceIsHospADA2002', '', '689', '516', '0', '0'), 
(974, 3, '', 'PlaceIsExtCareFacilityADA2002', '', '722', '517', '0', '0'), 
(975, 3, '', 'PlaceIsOtherADA2002', '', '750', '516', '0', '0'), 
(976, 3, '', 'IsOrtho', '', '731', '532', '0', '0'), 
(977, 3, '', 'IsNotOrtho', '', '757', '532', '0', '0'), 
(978, 3, '', 'DateOrthoPlaced', 'MM/dd/yyyy', '609', '575', '98', '14'), 
(979, 3, '', 'MonthsOrthoRemaining', '', '753', '575', '50', '14'), 
(980, 3, '', 'IsReplacementProsth', '', '159', '578', '0', '0'), 
(981, 3, '', 'IsInitialProsth', '', '133', '578', '0', '0'), 
(982, 3, '', 'DatePriorProsthPlaced', 'MM/dd/yyyy', '432', '576', '129', '14'), 
(983, 3, '', 'IsOccupational', '', '292', '594', '0', '0'), 
(984, 3, '', 'IsAutoAccident', '', '482', '594', '0', '0'), 
(985, 3, '', 'IsOtherAccident', '', '549', '594', '0', '0'), 
(986, 3, '', 'AccidentDate', 'MM/dd/yyyy', '639', '604', '100', '14'), 
(987, 3, '', 'P1Date', '', '38', '696', '80', '14'), 
(988, 3, '', 'P1ToothNumber', '', '123', '696', '45', '14'), 
(989, 3, '', 'P1Surface', '', '174', '696', '55', '14'), 
(990, 3, '', 'P1Code', '', '323', '696', '75', '14'), 
(991, 3, '', 'P1Description', '', '429', '696', '210', '14'), 
(992, 3, '', 'P1Fee', '', '707', '696', '60', '14'), 
(993, 3, '', 'P2Date', '', '38', '715', '80', '14'), 
(994, 3, '', 'P2ToothNumber', '', '123', '715', '45', '14'), 
(995, 3, '', 'P2Surface', '', '174', '715', '55', '14'), 
(996, 3, '', 'P2Code', '', '323', '715', '75', '14'), 
(997, 3, '', 'P2Description', '', '429', '715', '210', '14'), 
(998, 3, '', 'P2Fee', '', '707', '715', '60', '14'), 
(999, 3, '', 'P3Date', '', '38', '734', '80', '14'), 
(1000, 3, '', 'P3ToothNumber', '', '123', '734', '45', '14'), 
(1001, 3, '', 'P3Code', '', '323', '734', '75', '14'), 
(1002, 3, '', 'P3Surface', '', '174', '734', '55', '14'), 
(1003, 3, '', 'P3Description', '', '429', '734', '210', '14'), 
(1004, 3, '', 'P3Fee', '', '707', '734', '60', '14'), 
(1005, 3, '', 'P4Date', '', '38', '753', '80', '14'), 
(1006, 3, '', 'P4ToothNumber', '', '123', '753', '45', '14'), 
(1007, 3, '', 'P4Surface', '', '174', '753', '55', '14'), 
(1008, 3, '', 'P4Code', '', '323', '753', '75', '14'), 
(1009, 3, '', 'P4Description', '', '429', '753', '210', '14'), 
(1010, 3, '', 'P4Fee', '', '707', '753', '60', '14'), 
(1011, 3, '', 'P5Date', '', '38', '771', '80', '14'), 
(1012, 3, '', 'P5ToothNumber', '', '123', '771', '45', '14'), 
(1013, 3, '', 'P5Surface', '', '174', '771', '55', '14'), 
(1014, 3, '', 'P5Code', '', '323', '771', '75', '14'), 
(1015, 3, '', 'P5Description', '', '429', '771', '210', '14'), 
(1016, 3, '', 'P5Fee', '', '707', '771', '60', '14'), 
(1017, 3, '', 'P6Date', '', '38', '790', '80', '14'), 
(1018, 3, '', 'P6ToothNumber', '', '123', '790', '45', '14'), 
(1019, 3, '', 'P6Surface', '', '174', '790', '55', '14'), 
(1020, 3, '', 'P6Code', '', '323', '790', '75', '14'), 
(1021, 3, '', 'P6Description', '', '429', '790', '210', '14'), 
(1022, 3, '', 'P6Fee', '', '707', '790', '60', '14'), 
(1023, 3, '', 'P7Date', '', '38', '810', '80', '14'), 
(1024, 3, '', 'P7ToothNumber', '', '123', '810', '45', '14'), 
(1025, 3, '', 'P7Surface', '', '174', '810', '55', '14'), 
(1026, 3, '', 'P7Code', '', '323', '810', '75', '14'), 
(1027, 3, '', 'P7Description', '', '429', '810', '210', '14'), 
(1028, 3, '', 'P7Fee', '', '707', '810', '60', '14'), 
(1029, 3, '', 'P8Date', '', '38', '829', '80', '14'), 
(1030, 3, '', 'P8ToothNumber', '', '123', '829', '45', '14'), 
(1031, 3, '', 'P8Surface', '', '174', '829', '55', '14'), 
(1032, 3, '', 'P8Code', '', '323', '829', '75', '14'), 
(1033, 3, '', 'P8Description', '', '429', '828', '210', '14'), 
(1034, 3, '', 'P8Fee', '', '707', '828', '60', '14'), 
(1035, 3, '', 'Miss1', '', '51', '869', '0', '0'), 
(1036, 3, '', 'Miss2', '', '69', '869', '0', '0'), 
(1037, 3, '', 'Miss3', '', '87', '869', '0', '0'), 
(1038, 3, '', 'Miss4', '', '106', '869', '0', '0'), 
(1039, 3, '', 'Miss5', '', '124', '869', '0', '0'), 
(1040, 3, '', 'Miss6', '', '143', '869', '0', '0'), 
(1041, 3, '', 'Miss7', '', '160', '869', '0', '0'), 
(1042, 3, '', 'Miss8', '', '177', '869', '0', '0'), 
(1043, 3, '', 'Miss9', '', '219', '869', '0', '0'), 
(1044, 3, '', 'Miss10', '', '236', '869', '0', '0'), 
(1045, 3, '', 'Miss11', '', '254', '869', '0', '0'), 
(1046, 3, '', 'Miss12', '', '270', '869', '0', '0'), 
(1047, 3, '', 'Miss13', '', '289', '869', '0', '0'), 
(1048, 3, '', 'Miss14', '', '305', '869', '0', '0'), 
(1049, 3, '', 'Miss15', '', '322', '869', '0', '0'), 
(1050, 3, '', 'Miss16', '', '338', '869', '0', '0'), 
(1051, 3, '', 'Miss17', '', '335', '886', '0', '0'), 
(1052, 3, '', 'Miss18', '', '320', '886', '0', '0'), 
(1053, 3, '', 'Miss19', '', '304', '886', '0', '0'), 
(1054, 3, '', 'Miss20', '', '287', '886', '0', '0'), 
(1055, 3, '', 'Miss21', '', '271', '886', '0', '0'), 
(1056, 3, '', 'Miss22', '', '252', '886', '0', '0'), 
(1057, 3, '', 'Miss23', '', '234', '886', '0', '0'), 
(1058, 3, '', 'Miss24', '', '220', '886', '0', '0'), 
(1059, 3, '', 'Miss25', '', '174', '886', '0', '0'), 
(1060, 3, '', 'Miss26', '', '158', '886', '0', '0'), 
(1061, 3, '', 'Miss27', '', '142', '886', '0', '0'), 
(1062, 3, '', 'Miss28', '', '126', '886', '0', '0'), 
(1063, 3, '', 'Miss29', '', '110', '886', '0', '0'), 
(1064, 3, '', 'Miss30', '', '91', '886', '0', '0'), 
(1065, 3, '', 'Miss31', '', '72', '886', '0', '0'), 
(1066, 3, '', 'Miss32', '', '54', '886', '0', '0'), 
(1067, 3, '', 'TotalFee', '', '707', '849', '60', '14'), 
(1068, 3, '', 'Remarks', '', '44', '913', '475', '55'), 
(1069, 3, '', 'TreatingDentistSignature', '', '55', '1012', '160', '14'), 
(1070, 3, '', 'TreatingDentistLicense', '', '219', '1012', '100', '14'), 
(1071, 3, '', 'TreatingDentistSigDate', 'MM/dd/yyyy', '326', '1012', '131', '14'), 
(1072, 3, '', 'TreatingDentistAddress', '', '523', '989', '275', '14'), 
(1073, 3, '', 'TreatingDentistCity', '', '524', '1018', '160', '14'), 
(1074, 3, '', 'TreatingDentistST', '', '693', '1018', '45', '14'), 
(1075, 3, '', 'TreatingDentistZip', '', '747', '1018', '65', '14'), 
(1076, 3, '', 'IsMedicaidClaim', '', '49', '78', '0', '0'), 
(1077, 3, '', 'PriInsAddress2', '', '636', '85', '160', '14'), 
(1078, 3, '', 'PatientPhone', '', '463', '174', '200', '14'), 
(1079, 3, '', 'SubscrPhone', '', '330', '302', '95', '14'), 
(1080, 3, '', 'SubscrDOB', 'MM      dd         yyyy', '71', '366', '120', '14'), 
(1081, 3, '', 'SubscrIsMarried', '', '238', '367', '0', '0'), 
(1082, 3, '', 'SubscrIsSingle', '', '278', '367', '0', '0'), 
(1083, 3, '', 'SubscrIsFTStudent', '', '578', '366', '0', '0'), 
(1084, 3, '', 'SubscrIsPTStudent', '', '655', '366', '0', '0'), 
(1085, 3, '', 'IsNotOccupational', '', '269', '594', '0', '0'), 
(1086, 3, '', 'IsNotAccident', '', '616', '593', '0', '0');
#----------------------------
# Table structure for claimpayment
#----------------------------
CREATE TABLE `claimpayment` (
  `ClaimPaymentNum` mediumint(8) unsigned NOT NULL auto_increment,
  `CheckDate` date NOT NULL default '0001-01-01',
  `CheckAmt` double NOT NULL default '0',
  `CheckNum` varchar(25) NOT NULL default '',
  `BankBranch` varchar(25) NOT NULL default '',
  `Note` varchar(255) NOT NULL default '',
  `ClinicNum` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ClaimPaymentNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table claimpayment
#----------------------------

#----------------------------
# Table structure for claimproc
#----------------------------
CREATE TABLE `claimproc` (
  `ClaimProcNum` mediumint(8) unsigned NOT NULL auto_increment,
  `ProcNum` mediumint(8) unsigned NOT NULL default '0',
  `ClaimNum` mediumint(8) unsigned NOT NULL default '0',
  `PatNum` mediumint(8) unsigned NOT NULL default '0',
  `ProvNum` smallint(5) unsigned NOT NULL default '0',
  `FeeBilled` double NOT NULL default '0',
  `InsPayEst` double NOT NULL default '0',
  `DedApplied` double NOT NULL default '0',
  `Status` tinyint(3) unsigned NOT NULL default '0',
  `InsPayAmt` double NOT NULL default '0',
  `Remarks` varchar(255) NOT NULL default '',
  `ClaimPaymentNum` mediumint(8) unsigned NOT NULL default '0',
  `PlanNum` mediumint(8) unsigned NOT NULL default '0',
  `DateCP` date NOT NULL default '0001-01-01',
  `WriteOff` double NOT NULL default '0',
  `CodeSent` varchar(15) NOT NULL default '',
  `AllowedAmt` double NOT NULL default '-1',
  `Percentage` tinyint(4) NOT NULL default '-1',
  `PercentOverride` tinyint(4) NOT NULL default '-1',
  `CopayAmt` double NOT NULL default '-1',
  `OverrideInsEst` double NOT NULL default '-1',
  `NoBillIns` tinyint(1) unsigned NOT NULL default '0',
  `DedBeforePerc` tinyint(1) unsigned NOT NULL default '0',
  `OverAnnualMax` double NOT NULL default '-1',
  `PaidOtherIns` double NOT NULL default '-1',
  `BaseEst` double NOT NULL default '0',
  `CopayOverride` double NOT NULL default '-1',
  `ProcDate` date NOT NULL default '0001-01-01',
  PRIMARY KEY  (`ClaimProcNum`),
  KEY `indexPatNum` (`PatNum`),
  KEY `indexPlanNum` (`PlanNum`),
  KEY `indexClaimNum` (`ClaimNum`),
  KEY `indexProvNum` (`ProvNum`),
  KEY `indexProcNum` (`ProcNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table claimproc
#----------------------------

#----------------------------
# Table structure for clearinghouse
#----------------------------
CREATE TABLE `clearinghouse` (
  `ClearinghouseNum` mediumint(8) unsigned NOT NULL auto_increment,
  `Description` varchar(255) NOT NULL default '',
  `ExportPath` text NOT NULL,
  `IsDefault` tinyint(1) unsigned NOT NULL default '0',
  `Payors` text NOT NULL,
  `Eformat` tinyint(3) unsigned NOT NULL default '0',
  `ReceiverID` varchar(255) NOT NULL default '',
  `SenderID` varchar(255) NOT NULL default '',
  `Password` varchar(255) NOT NULL default '',
  `ResponsePath` varchar(255) NOT NULL default '',
  `CommBridge` tinyint(3) unsigned NOT NULL default '0',
  `ClientProgram` varchar(255) NOT NULL default '',
  `LastBatchNumber` smallint(5) unsigned NOT NULL default '0',
  `ModemPort` tinyint(3) unsigned NOT NULL default '0',
  `LoginID` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ClearinghouseNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table clearinghouse
#----------------------------


insert  into clearinghouse values 
(1, 'Renaissance', 'C:\\Program Files\\Renaissance\\dotr\\upload\\', 1, '', 2, '', '', '', '', 3, 'C:\\Program Files\\Renaissance\\lite\\RemoteLite.exe', 0, 0, ''), 
(2, 'WebMD', 'C:\\WebMD\\Claims\\', 0, '', 1, '0135WCH00', '', '', 'C:\\WebMD\\Mail\\', 1, 'C:\\Program Files\\WebMD\\WebMd_FileTransfer_ConClient.exe', 0, 0, ''), 
(3, 'BCBS GA', 'C:\\BCBS\\Upload\\', 0, '00601', 1, 'BCBSGA', '', '', 'C:\\BCBS\\Response\\', 2, '', 0, 0, ''), 
(4, 'RECS', 'C:\\Recscom\\', 0, '', 1, 'RECS', '', '', '', 5, 'C:\\Recscom\\Recscom.exe', 0, 0, ''), 
(5, 'ClaimConnect', 'C:\\ClaimConnect\\Upload\\', 0, '', 1, '330989922', '', '', '', 4, '', 0, 0, '');
#----------------------------
# Table structure for clockevent
#----------------------------
CREATE TABLE `clockevent` (
  `ClockEventNum` mediumint(8) unsigned NOT NULL auto_increment,
  `EmployeeNum` smallint(5) unsigned NOT NULL default '0',
  `TimeEntered` datetime NOT NULL default '0000-00-00 00:00:00',
  `TimeDisplayed` datetime NOT NULL default '0000-00-00 00:00:00',
  `ClockIn` tinyint(1) unsigned NOT NULL default '0',
  `ClockStatus` tinyint(3) unsigned NOT NULL default '0',
  `Note` text NOT NULL,
  PRIMARY KEY  (`ClockEventNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table clockevent
#----------------------------

#----------------------------
# Table structure for commlog
#----------------------------
CREATE TABLE `commlog` (
  `CommlogNum` mediumint(8) unsigned NOT NULL auto_increment,
  `PatNum` mediumint(8) unsigned NOT NULL default '0',
  `CommDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `CommType` tinyint(3) unsigned NOT NULL default '0',
  `Note` text NOT NULL,
  `Mode` tinyint(3) unsigned NOT NULL default '0',
  `SentOrReceived` tinyint(3) unsigned NOT NULL default '0',
  `EmailMessageNum` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`CommlogNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table commlog
#----------------------------

#----------------------------
# Table structure for computer
#----------------------------
CREATE TABLE `computer` (
  `ComputerNum` mediumint(8) unsigned NOT NULL auto_increment,
  `CompName` varchar(100) NOT NULL default '',
  `PrinterName` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ComputerNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table computer
#----------------------------


insert  into computer values 
(5, 'JORDANS', '');
#----------------------------
# Table structure for contact
#----------------------------
CREATE TABLE `contact` (
  `ContactNum` mediumint(8) unsigned NOT NULL auto_increment,
  `LName` varchar(255) NOT NULL default '',
  `FName` varchar(255) NOT NULL default '',
  `WkPhone` varchar(255) NOT NULL default '',
  `Fax` varchar(255) NOT NULL default '',
  `Category` smallint(5) unsigned NOT NULL default '0',
  `Notes` text NOT NULL,
  PRIMARY KEY  (`ContactNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table contact
#----------------------------

#----------------------------
# Table structure for county
#----------------------------
CREATE TABLE `county` (
  `CountyName` varchar(255) NOT NULL default '',
  `CountyCode` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`CountyName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table county
#----------------------------

#----------------------------
# Table structure for covcat
#----------------------------
CREATE TABLE `covcat` (
  `CovCatNum` mediumint(8) unsigned NOT NULL auto_increment,
  `Description` varchar(50) NOT NULL default '',
  `DefaultPercent` tinyint(3) NOT NULL default '0',
  `IsPreventive` tinyint(1) unsigned NOT NULL default '0',
  `CovOrder` tinyint(3) unsigned NOT NULL default '0',
  `IsHidden` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`CovCatNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table covcat
#----------------------------



insert  into covcat values 
(1, 'Diag/Prev', 100, 1, 0, 0), 
(2, 'Basic', 80, 0, 1, 0), 
(3, 'Major', 50, 0, 2, 0), 
(4, 'Ortho', -1, 0, 5, 0), 
(6, 'Endo', 80, 0, 3, 0), 
(7, 'none', 0, 0, 6, 1), 
(8, 'Perio', 80, 0, 4, 0);
#----------------------------
# Table structure for covpat
#----------------------------
CREATE TABLE `covpat` (
  `CovPatNum` mediumint(8) unsigned NOT NULL auto_increment,
  `CovCatNum` mediumint(8) unsigned NOT NULL default '0',
  `PlanNum` mediumint(8) unsigned NOT NULL default '0',
  `PriPatNum` mediumint(8) unsigned NOT NULL default '0',
  `SecPatNum` mediumint(8) unsigned NOT NULL default '0',
  `Percent` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`CovPatNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table covpat
#----------------------------

#----------------------------
# Table structure for covspan
#----------------------------
CREATE TABLE `covspan` (
  `CovSpanNum` mediumint(8) unsigned NOT NULL auto_increment,
  `CovCatNum` mediumint(8) unsigned NOT NULL default '0',
  `FromCode` varchar(15) NOT NULL default '',
  `ToCode` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`CovSpanNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table covspan
#----------------------------


insert  into covspan values 
(1, 1, 'D0000', 'D1999'), 
(2, 2, 'D2000', 'D2699'), 
(3, 3, 'D2700', 'D2999'), 
(4, 2, 'D3000', 'D3999'), 
(5, 2, 'D4000', 'D4999'), 
(6, 3, 'D5000', 'D5899'), 
(7, 7, 'D5900', 'D6199'), 
(8, 3, 'D6200', 'D6999'), 
(9, 2, 'D7000', 'D7999'), 
(10, 4, 'D8000', 'D8998'), 
(12, 7, 'D9000', 'D9999'), 
(13, 7, 'D8999', 'D8999');
#----------------------------
# Table structure for definition
#----------------------------
CREATE TABLE `definition` (
  `DefNum` smallint(5) unsigned NOT NULL auto_increment,
  `Category` tinyint(3) unsigned NOT NULL default '0',
  `ItemOrder` smallint(5) unsigned NOT NULL default '0',
  `ItemName` varchar(255) NOT NULL default '',
  `ItemValue` varchar(255) NOT NULL default '',
  `ItemColor` int(11) NOT NULL default '0',
  `IsHidden` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`DefNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table definition
#----------------------------


insert  into definition values 
(1, 1, 2, 'Misc Neg Adjustment', '-', 0, 0), 
(2, 1, 3, 'Misc Pos Adjustment', '+', 0, 0), 
(4, 0, 1, 'Adjustment', '', -16777031, 0), 
(5, 0, 3, 'Payment', '', -16744448, 0), 
(6, 0, 4, 'Insurance', '', -2555904, 0), 
(7, 0, 0, 'Default', '', -16777216, 0), 
(8, 1, 0, 'Professional Discount', '-', 0, 0), 
(9, 1, 1, 'Cash Discount', '-', 0, 0), 
(10, 1, 5, 'Write Off', '-', 0, 0), 
(112, 0, 2, 'Discount', '', -16744448, 0), 
(12, 1, 6, 'Insurance Writeoff', '-', 0, 0), 
(13, 1, 7, '$10 Referral Discount', '-', 0, 0), 
(14, 1, 8, 'BROKEN Appt - No Show', '+', 0, 0), 
(15, 1, 9, 'BROKEN Appt w/o 24 hrs Notice', '+', 0, 0), 
(16, 1, 10, 'Returned Check', '+', 0, 0), 
(17, 1, 11, 'NSF fee', '+', 0, 0), 
(18, 1, 4, 'Patient Refund Check', '+', 0, 0), 
(19, 2, 0, 'Unconfirmed', 'Unconfrm', -1, 0), 
(20, 2, 1, 'Left Msg on Ans Mach', 'LeftMsg', -256, 0), 
(21, 2, 2, 'Appointment Confirmed', 'Confirmed', -6099851, 0), 
(22, 2, 3, 'Left Msg w Fam Mem', 'MsgFam', -256, 0), 
(23, 2, 4, 'Not Home', 'NotHome', -65536, 0), 
(24, 2, 5, 'Disconnected Number', 'DiscNum', -65536, 0), 
(25, 2, 6, 'Line Busy', 'LinBusy', -65536, 0), 
(26, 3, 0, 'Comp Exam', 'D0150', 0, 0), 
(27, 3, 1, 'Per Exam', 'D0120', 0, 0), 
(28, 3, 2, 'Lim Exam', 'D0140', 0, 0), 
(29, 3, 3, '1 PA', 'D0220', 0, 0), 
(30, 3, 4, '2BW', 'D0272', 0, 0), 
(31, 3, 5, '4BW', 'D0274', 0, 0), 
(32, 3, 7, 'Pro Adult', 'D1110', 0, 0), 
(33, 3, 8, 'Fluor Adult', 'D1204', 0, 0), 
(34, 3, 9, 'Pro Child', 'D1120', 0, 0), 
(35, 3, 10, 'Fluor Child', 'D1203', 0, 0), 
(36, 3, 13, 'empty', 'D0120', 0, 1), 
(37, 3, 6, 'Pano', 'D0330', 0, 0), 
(38, 3, 11, 'PostOp', 'N4101', 0, 0), 
(39, 3, 12, 'DentAdj', 'N4102', 0, 0), 
(40, 4, 0, 'Standard Account', '', 0, 0), 
(41, 4, 1, 'Bad Debt - Precollections', '', 0, 0), 
(42, 4, 2, 'Bad Debt - Sent to Collections', '', 0, 0), 
(43, 5, 0, 'paper', 'ADA2002', 0, 0), 
(44, 5, 1, 'eClaim', 'eclaim', 0, 0), 
(45, 6, 0, 'Standard 0-30', '', 0, 0), 
(46, 6, 1, 'Standard 31-60', 'Charges over 30 days.', 0, 0), 
(47, 6, 2, 'Standard 61-90', 'Charges over 60 days.', 0, 0), 
(48, 6, 3, 'Standard Over 90', 'Charges over 90 days.  Finance charges apply.', 0, 0), 
(49, 6, 4, 'Insurance 0-30', '', 0, 0), 
(50, 6, 5, 'Insurance 31-60', 'Charges over 30 days.', 0, 0), 
(51, 6, 6, 'Insurance 61-90', 'Charges over 60 days.', 0, 0), 
(52, 6, 7, 'Insurance Over 90', 'Charges over 90 days.  You are responsible for unpaid insurance. Finance charges apply.', 0, 0), 
(53, 7, 0, 'Standard', '', 0, 0), 
(54, 7, 2, 'BCBS', '', 0, 0), 
(55, 7, 1, 'ODS', '', 0, 0), 
(56, 8, 1, 'BP', '', 0, 0), 
(57, 8, 6, 'Allergy:', '', 0, 0), 
(58, 8, 2, 'Heart', '', 0, 0), 
(59, 8, 3, 'Low Epi', '', 0, 0), 
(60, 8, 4, 'PAC', '', 0, 0), 
(61, 8, 7, 'Medication:', '', 0, 0), 
(62, 8, 0, 'none', '', 0, 0), 
(63, 8, 5, 'Diabetes', '', 0, 0), 
(64, 9, 0, 'Operatory 1', 'OP-1', 0, 0), 
(65, 9, 1, 'Operatory 2', 'OP-2', 0, 0), 
(66, 9, 2, 'Operatory 3', 'OP-3', 0, 0), 
(67, 9, 3, 'Operatory 4', 'OP-4', 0, 0), 
(68, 9, 4, 'Hygiene Op 1', 'Hyg1', 0, 0), 
(69, 10, 0, 'Check', '', 0, 0), 
(70, 10, 1, 'Cash', '', 0, 0), 
(71, 10, 2, 'Credit Card', '', 0, 0), 
(113, 12, 2, 'Status Existing Current Prov', '', -16777206, 0), 
(72, 10, 3, 'Not used', '', 0, 1), 
(73, 11, 0, 'Exams & Xrays', '', 0, 0), 
(74, 11, 1, 'Cleanings', '', 0, 0), 
(75, 11, 2, 'Fillings', '', 0, 0), 
(76, 11, 3, 'Endo', '', 0, 0), 
(77, 11, 4, 'Perio', '', 0, 0), 
(78, 11, 5, 'Dentures', '', 0, 0), 
(79, 11, 6, 'Cosmetic', '', 0, 0), 
(80, 11, 7, 'Implants', '', 0, 0), 
(81, 11, 8, 'Crown & Bridge', '', 0, 0), 
(82, 11, 9, 'Oral Surgery', '', 0, 0), 
(83, 11, 10, 'Ortho', '', 0, 0), 
(84, 11, 11, 'Misc', '', 0, 0), 
(85, 11, 12, 'No Fee', '', 0, 0), 
(86, 11, 13, 'Rarely Used', '', 0, 0), 
(87, 11, 14, 'Never Used', '', 0, 0), 
(88, 12, 1, 'Status Complete', '', -16185069, 0), 
(89, 12, 5, 'Rx', '', -65536, 0), 
(90, 12, 0, 'Status Treatment Planned', '', -8978432, 0), 
(91, 12, 3, 'Status Existing Other Prov', '', -16751616, 0), 
(92, 13, 0, 'Appointment Scheduled', 'AptSchd', 0, 0), 
(93, 13, 8, 'Not Home, Call Again', 'NotHome', 0, 0), 
(94, 13, 1, 'Call Back, Not Ready', 'CallBak', 0, 0), 
(95, 13, 2, 'Patient Will Call Us', 'CallUs', 0, 0), 
(96, 13, 3, 'Bad Debt. Don\'t Call', 'BadDebt', 0, 0), 
(97, 13, 5, 'Left Msg on Ans. Mach', 'LeftMsg', 0, 0), 
(98, 13, 6, 'Left Message with Fam', 'MsgFam', 0, 0), 
(99, 13, 7, 'Discon Ph Num', 'DiscNum', 0, 0), 
(100, 13, 4, 'Wait. See notes.', 'Wait', 0, 0), 
(101, 14, 3, 'Pillow', '', 0, 0), 
(102, 14, 4, 'No Fluoride', '', 0, 0), 
(103, 14, 7, 'Hard to Numb', '', 0, 1), 
(104, 14, 0, 'Value', '', 0, 0), 
(105, 14, 2, 'Quality', '', 0, 0), 
(106, 14, 5, 'Don\'t Lean Back', '', 0, 0), 
(107, 14, 1, 'Painless', '', 0, 0), 
(108, 15, 1, '10% Senior Discount', '10', 0, 0), 
(109, 15, 0, '5% Cash Discount', '5', 0, 0), 
(110, 15, 2, 'New Patient Discount', '20', 0, 0), 
(111, 15, 3, 'Discount', '', 0, 0), 
(114, 11, 15, 'Obsolete', '', 0, 0), 
(115, 16, 1, 'Caries', 'C', 0, 0), 
(116, 16, 2, 'Recurrent (Car)', 'R', 0, 0), 
(117, 16, 3, 'Incipient (Car)', 'I', 0, 0), 
(118, 16, 4, 'Defect (or miss fill)', 'D', 0, 0), 
(119, 16, 5, 'Missing (tooth struct)', 'M', 0, 0), 
(120, 16, 6, 'Irrevers. Pulp.', 'IP', 0, 0), 
(121, 16, 7, 'Revers. Pulp.', 'RP', 0, 0), 
(122, 16, 8, 'Necrotic', 'Nc', 0, 0), 
(123, 16, 9, 'Apical Perio', 'AP', 0, 0), 
(124, 16, 10, 'Abcess', 'Ab', 0, 0), 
(125, 16, 11, 'Carious Pulp Exp', 'CE', 0, 0), 
(126, 16, 12, 'Cracked Tooth', 'Cr', 0, 0), 
(127, 17, 0, 'Practice Open', '', -1, 0), 
(128, 17, 1, 'Practice Closed', '', -2368549, 0), 
(129, 9, 5, 'Hygiene Op 2', 'Hyg2', 0, 0), 
(130, 18, 3, 'Medical History', '', 0, 0), 
(131, 18, 2, 'Insurance', '', 0, 0), 
(132, 18, 6, 'Treatment Plans', '', 0, 0), 
(133, 18, 8, 'Patient Treatment', '', 0, 0), 
(134, 18, 1, 'Financial', '', 0, 0), 
(135, 18, 7, 'Letters', '', 0, 0), 
(136, 18, 0, 'Credit Approval', '', 0, 0), 
(137, 18, 4, 'Miscellaneous', '', 0, 0), 
(138, 18, 5, 'Patient Information', '', 0, 0), 
(139, 16, 0, 'None', '', 0, 0), 
(140, 17, 2, 'Appointment Complete-Time bar', '', -8355712, 0), 
(141, 17, 3, 'Appointment Complete-Background', '', -2039837, 0), 
(142, 13, 9, 'Mailed Postcard', 'Mailed', 0, 0), 
(143, 19, 0, 'Called. Left message.', '', 0, 0), 
(144, 19, 1, 'Called.  No answer.', '', 0, 0), 
(145, 19, 2, 'Called.  Bad number.  Made note in chart', '', 0, 0), 
(146, 20, 0, '1', '', -16777216, 0), 
(147, 20, 1, '2', '', -16777216, 0), 
(148, 20, 11, 'Wait', '', -7237231, 0), 
(149, 20, 9, 'Low', '', -16777216, 0), 
(150, 20, 8, 'Next', '', -6356992, 0), 
(151, 20, 4, '5', '', -16777216, 0), 
(152, 20, 13, '10', '', -16777216, 1), 
(153, 20, 2, '3', '', -16777216, 0), 
(154, 20, 3, '4', '', -16777216, 0), 
(155, 20, 12, '9', '', -16777216, 1), 
(156, 20, 5, '6', '', -16777216, 0), 
(157, 20, 6, '7', '', -16777216, 0), 
(158, 20, 7, '8', '', -16777216, 0), 
(159, 20, 10, 'Recmend', '', -7237231, 0), 
(160, 12, 4, 'Status Referred', '', -8978432, 0), 
(161, 14, 6, 'Anxiety', '', 0, 0), 
(162, 17, 4, 'Holiday', '', -2509157, 0), 
(163, 0, 5, 'Comm', '', -8388608, 0), 
(164, 21, 0, 'Family Module Coverage', '', -2823993, 0), 
(165, 22, 0, 'Treatment Planned', '', -3801088, 0), 
(166, 22, 1, 'Complete', '', -16777023, 0), 
(167, 22, 2, 'Existing Current Prov', '', -16777025, 0), 
(168, 22, 3, 'Existing Other Prov', '', -16751616, 0), 
(169, 22, 4, 'Referred Out', '', -3276800, 0), 
(170, 1, 12, 'Finance Charge', '+', 0, 0), 
(171, 23, 0, 'Pharmacies', '', 0, 0), 
(172, 23, 1, 'Local Dentists', '', 0, 0), 
(173, 0, 6, 'PayPlan', '', -8388608, 0), 
(174, 21, 1, 'Perio Bleeding', '', -1043436, 0), 
(175, 21, 2, 'Perio Suppuration', '', -24576, 0), 
(176, 21, 3, 'Chart Module Medical', '', -16192, 0), 
(177, 21, 4, 'Perio Plaque', '', -10066177, 0), 
(178, 21, 5, 'Perio Calculus', '', -16737024, 0), 
(179, 18, 9, 'BWs', 'X', 0, 0), 
(180, 18, 10, 'FMXs', 'X', 0, 0), 
(181, 18, 11, 'Panos', 'X', 0, 0), 
(182, 18, 12, 'Photos', 'X', 0, 0), 
(183, 21, 6, 'Chart Today\'s Procs', '', -886, 0), 
(184, 21, 7, 'Commlog Appt Related', '', -886, 0), 
(185, 1, 13, '5% Cash Discount', '-', 0, 0), 
(186, 1, 14, '10% Senior Discount', '-', 0, 0), 
(187, 1, 15, 'New Patient Discount', '-', 0, 0), 
(188, 1, 16, 'Discount', '-', 0, 0);
#----------------------------
# Table structure for docattach
#----------------------------
CREATE TABLE `docattach` (
  `DocAttachNum` mediumint(8) unsigned NOT NULL auto_increment,
  `PatNum` mediumint(8) unsigned NOT NULL default '0',
  `DocNum` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`DocAttachNum`),
  KEY `ChartNum` (`PatNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table docattach
#----------------------------

#----------------------------
# Table structure for document
#----------------------------
CREATE TABLE `document` (
  `DocNum` mediumint(8) unsigned NOT NULL auto_increment,
  `Description` varchar(255) NOT NULL default '',
  `DateCreated` date NOT NULL default '0000-00-00',
  `DocCategory` smallint(5) unsigned NOT NULL default '0',
  `WithPat` mediumint(8) unsigned NOT NULL default '0',
  `FileName` varchar(255) NOT NULL default '',
  `ImgType` tinyint(3) unsigned NOT NULL default '0',
  `IsFlipped` tinyint(1) unsigned NOT NULL default '0',
  `DegreesRotated` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`DocNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table document
#----------------------------

#----------------------------
# Table structure for electid
#----------------------------
CREATE TABLE `electid` (
  `ElectIDNum` mediumint(8) unsigned NOT NULL auto_increment,
  `PayorID` varchar(255) NOT NULL default '',
  `CarrierName` varchar(255) NOT NULL default '',
  `IsMedicaid` tinyint(3) unsigned NOT NULL default '0',
  `ProviderTypes` varchar(255) NOT NULL default '',
  `Comments` text NOT NULL,
  PRIMARY KEY  (`ElectIDNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table electid
#----------------------------


insert  into electid values 
(1, 'CX044', 'A&I Benefit Plan Admin. Of Oregon', 0, '', ''), 
(2, '64071', 'Acclaim', 0, '', ''), 
(3, '59140', 'Acec', 0, '', ''), 
(4, '72468', 'ACS Consulting Services, Inc.', 0, '', ''), 
(5, '38255', 'Activa Benefit Services, LLC', 0, '', ''), 
(6, '93524', 'Advantage Dental Plan, Inc.', 0, '', ''), 
(7, '60054', 'Aetna', 0, '', ''), 
(8, '68246', 'Aetna US Healthcare Encounters', 0, '', ''), 
(9, '58066', 'AFLAC of Georgia', 0, '', ''), 
(10, '80705', 'AH & L', 0, '', ''), 
(11, '91136', 'Alaska Children\'s Services, Inc', 0, '', ''), 
(12, '91136', 'Alaska Laborers Construction Industry Trust', 0, '', ''), 
(13, '91136', 'Alaska Pipe Trades Local 375', 0, '', ''), 
(14, '91136', 'Alaska United Food & Comm. Workers Health & Welfare Trust', 0, '', ''), 
(15, 'CX016', 'Allen Medical Claims Administrators', 0, '', ''), 
(16, '80705', 'ALTA Health & Life Insurance Company', 0, '', ''), 
(17, '50503', 'Altus Dental', 0, '', ''), 
(18, '59067', 'American Bankers Life Assurance Co.', 0, '', ''), 
(19, '34187', 'American Benefits Mangement of OH', 0, '', ''), 
(20, 'AHG01', 'American Health Group', 0, '', ''), 
(21, 'CX001', 'American Medical Security', 0, '', ''), 
(22, '44444', 'American Postal Workers Union (APWU)', 0, '', ''), 
(23, '86001', 'AmeriChoice - New Jersey Medicare', 1, '', ''), 
(24, '86002', 'AmeriChoice - New York Medicare', 1, '', ''), 
(25, '86047', 'AmeriChoice  New Jersey Medicaid', 1, '', ''), 
(26, '86047', 'AmeriChoice  New Jersey Medicaid', 1, '', ''), 
(27, '86048', 'AmeriChoice  New York Medicaid', 1, '', ''), 
(28, 'CKNY1', 'AmeriChoice  New York Medicaid', 1, '', ''), 
(29, '86003', 'AmeriChoice  Pennsylvania  Medicare', 1, '', ''), 
(30, '86049', 'AmeriChoice  Pennsylvania Medicaid', 1, '', ''), 
(31, '47009', 'Ameritas Life Insurance Company', 0, '', ''), 
(32, '61301', 'Ameritas Life Insurance Corp.', 0, '', ''), 
(33, '38255', 'Amway Corporation', 0, '', ''), 
(34, '84105', 'Anthem Blue Cross/Blue Shield (IN, OH & KY)', 0, '', ''), 
(35, '65358', 'Anthem Blue Cross/Blue Shield of Connecticut', 0, '', ''), 
(36, '80705', 'Anthem Health & Life Ins. Co. of New Jersey', 0, '', ''), 
(37, '16140', 'APA Partners of New York', 0, '', ''), 
(38, 'ATPA1', 'Associated Third Party Administrators', 0, '', ''), 
(39, 'ADN01', 'Atlantic Dental (ADI)', 0, '', ''), 
(40, '91136', 'Automotive Machinists Local 289 Health & Welfare Trust', 0, '', ''), 
(41, '74227', 'Bankers United Life', 0, '', ''), 
(42, 'BCCA2', 'BCCA ENCOUNTER', 0, '', ''), 
(43, '68241', 'Bell Atlantic', 0, '', ''), 
(44, '23210', 'BeneCare Dental Plan', 0, '', ''), 
(45, '25145', 'Benefit Coordinators Corporation', 0, '', ''), 
(46, '39081', 'Benefit Plan Administrators', 0, '', ''), 
(47, '74223', 'Benefit Planners', 0, '', ''), 
(48, '36342', 'Benefit Systems & Services, Inc. (BSSI)', 0, '', ''), 
(49, 'BMX01', 'Benemax', 0, '', ''), 
(50, '95604', 'Best Life & Health Insurance Company', 0, '', ''), 
(51, '00700', 'Blue Care Family Plan (BCBS of CT)', 0, '', ''), 
(52, 'CBAL1', 'Blue Cross of Alabama', 0, '', ''), 
(53, '47570', 'Blue Cross of Alaska & Washington', 0, '', ''), 
(54, 'CBAR1', 'Blue Cross of Arkansas', 0, '', ''), 
(55, 'BCCA1', 'Blue Cross of California', 0, '', ''), 
(56, '47198', 'Blue Cross of California', 0, '', ''), 
(57, '84099', 'Blue Cross of Colorado', 0, '', ''), 
(58, '65358', 'Blue Cross of Connecticut', 0, '', ''), 
(59, '00700', 'Blue Cross of Connecticut Blue Care Family', 0, '', ''), 
(60, '53287', 'Blue Cross of Delaware', 0, '', ''), 
(61, 'CBID1', 'Blue Cross of Idaho', 0, '', ''), 
(62, 'CB621', 'Blue Cross of Illinois', 0, '', ''), 
(63, '84105', 'Blue Cross of Indiana - Anthem', 0, '', ''), 
(64, 'CBIA2', 'Blue Cross of Iowa', 0, '', ''), 
(65, 'CBIA1', 'Blue Cross of Iowa (FEP claims only)', 0, '', ''), 
(66, 'CBKS1', 'Blue Cross of Kansas', 0, '', ''), 
(67, '84105', 'Blue Cross of Kentucky - Anthem', 0, '', ''), 
(68, '23739', 'Blue Cross of Louisiana', 0, '', ''), 
(69, 'CBMA1', 'Blue Cross of Massachusetts', 0, '', ''), 
(70, '84101', 'Blue Cross of Nevada', 0, '', ''), 
(71, '22099', 'Blue Cross of New Jersey - Horizon', 0, '', ''), 
(72, '84100', 'Blue Cross of New Mexico', 0, '', ''), 
(73, 'CBNY1', 'Blue Cross of New York- Empire', 0, '', ''), 
(74, 'CX004', 'Blue Cross of North Dakota/North Dakota Dental Svc.', 0, '', ''), 
(75, '84105', 'Blue Cross of Ohio - Anthem', 0, '', ''), 
(76, 'CB850', 'Blue Cross of Oregon - Regence', 0, '', ''), 
(77, 'CB870', 'Blue Cross of Rhode Island', 0, '', ''), 
(78, 'CBTN1', 'Blue Cross of Tennessee', 0, '', ''), 
(79, 'CB900', 'Blue Cross of Texas', 0, '', ''), 
(80, 'CB923', 'Blue Cross of Virginia- Trigon', 0, '', ''), 
(81, 'BWI01', 'Blue Cross of Wisconsin', 0, '', ''), 
(82, 'CB950', 'Blue Cross of Wisconsin', 0, '', ''), 
(83, '83470', 'Blue Cross/Blue Shield of Arkansas', 0, '', ''), 
(84, '00003', 'Blue Cross/Blue Shield of Central New York', 0, '', ''), 
(85, '84099', 'Blue Cross/Blue Shield of Colorado', 0, '', ''), 
(86, 'BCGA1', 'Blue Cross/Blue Shield of Georgia', 0, '', ''), 
(87, 'SB601', 'Blue Cross/Blue Shield of Georgia', 0, '', ''), 
(88, '00621', 'Blue Cross/Blue Shield of Illinois', 0, '', ''), 
(89, 'SB621', 'Blue Cross/Blue Shield of Illinois', 0, '', ''), 
(90, '84105', 'Blue Cross/Blue Shield of Indiana', 0, '', ''), 
(91, '84105', 'Blue Cross/Blue Shield of Kentucky', 0, '', ''), 
(92, 'BME01', 'Blue Cross/Blue Shield of Maine', 0, '', ''), 
(93, 'CBMI1', 'Blue Cross/Blue Shield of Michigan', 0, '', ''), 
(94, 'CBNE1', 'Blue Cross/Blue Shield of Nebraska', 0, '', ''), 
(95, '84101', 'Blue Cross/Blue Shield of Nevada', 0, '', ''), 
(96, 'BNH01', 'Blue Cross/Blue Shield of New Hampshire', 0, '', ''), 
(97, 'CBNY1', 'Blue Cross/Blue Shield of New York Empire', 0, '', ''), 
(98, '84105', 'Blue Cross/Blue Shield of Ohio', 0, '', ''), 
(99, 'CB865', 'Blue Cross/Blue Shield of Pennsylvania', 0, '', ''), 
(100, '00003', 'Blue Cross/Blue shield of the Rochester Area (Finger Lakes BC/BS)', 0, '', ''), 
(101, '93221', 'Blue Sheild  King County (Walla Walla Valley)', 0, '', ''), 
(102, '93213', 'Blue Shield  King County (Callam)', 0, '', ''), 
(103, '93220', 'Blue Shield  King County (Cowlitz)', 0, '', ''), 
(104, '93207', 'Blue Shield  King County (Grays harbor)', 0, '', ''), 
(105, '93210', 'Blue Shield  King County (Lewis)', 0, '', ''), 
(106, '93219', 'Blue Shield  King County (Snohomish)', 0, '', ''), 
(107, '93211', 'Blue Shield  King County (Thurston)', 0, '', ''), 
(108, '93214', 'Blue Shield  King County (Yakima)', 0, '', ''), 
(109, 'CBID2', 'Blue Shield of Idaho - Regence', 0, '', ''), 
(110, '0000D', 'Blue Shield of PA', 0, '', ''), 
(111, '99996', 'Blue Shield of Pennsylvania', 0, '', ''), 
(112, 'CB865', 'Blue Shield of Pennsylvania', 0, '', ''), 
(113, '99997', 'Blue Shield of Pennsylvania (DHMO)', 0, '', ''), 
(114, '93200', 'Blue Shield of Washington- Regence', 0, '', ''), 
(115, '36609', 'Boilermakers National Health & Welfare Fund', 0, '', ''), 
(116, '', 'BoonChapman Benefit Administrators, Inc.', 0, '', ''), 
(117, 'CX028', 'Bridgeport Dental Services', 0, '', ''), 
(118, 'CX032', 'Brokers National', 0, '', ''), 
(119, '47009', 'Businessmen\'s Assurance (BMA)', 0, '', ''), 
(120, '61301', 'Businessmen\'s Assurance (BMA)', 0, '', ''), 
(121, '61492', 'Businessmen\'s Assurance (BMA)', 0, '', ''), 
(122, 'CBDP1', 'California Benefits Dental Plan', 0, '', ''), 
(123, '80659', 'Canada Life Assurance Company, The', 0, '', ''), 
(124, '37105', 'Cannon Cochran Management Services', 0, '', ''), 
(125, '68011', 'Capital Administrators', 0, '', ''), 
(126, 'CX037', 'Capital Dental of Houston, TX', 0, '', ''), 
(127, 'CKOH2', 'CareSource Medicaid of Ohio', 1, '', ''), 
(128, '37060', 'Caterpillar, Inc.', 0, '', ''), 
(129, '41124', 'CBSA', 0, '', ''), 
(130, '88020', 'CCEA Welfare Benefit Trust', 0, '', ''), 
(131, '91136', 'Cement Masons & Plasterers Health & Welfare Trust', 0, '', ''), 
(132, '75177', 'Central & Southwest Services', 0, '', ''), 
(133, '84147', 'CHAMPVAHAC', 0, '', ''), 
(134, '84147', 'Children of Women Vietnam Beterans VA HAC', 0, '', ''), 
(135, '68241', 'Choice Plus (TRW)', 0, '', ''), 
(136, '61271', 'Christian Brothers Services', 0, '', ''), 
(137, '62308', 'CIGNA (Connecticut General)', 0, '', ''), 
(138, '62310', 'CIGNA Flex Care (New Mexico only)', 0, '', ''), 
(139, 'CMS01', 'Claim Management services (WI)', 0, '', ''), 
(140, 'CCS01', 'Clayton county Self Funded Dental Plan', 0, '', ''), 
(141, '71063', 'CNA Health Partners of Arkansas', 0, '', ''), 
(142, '75261', 'Community Health Electronic Claims /CHEC/WebTPA', 0, '', ''), 
(143, 'CX021', 'CompDent', 0, '', ''), 
(144, '03036', 'Comprehensive Benefits Administrators, Inc.', 0, '', ''), 
(145, '62308', 'Connecticut General (CIGNA)', 0, '', ''), 
(146, '61305', 'Consolidated Group Dental', 0, '', ''), 
(147, '52132', 'Cooperative Benefit Administrators - (CBA)', 0, '', ''), 
(148, '35182', 'Coresource of (PA, MD, IL)', 0, '', ''), 
(149, '41045', 'CoreStar', 0, '', ''), 
(150, '56117', 'Corporate Benefit Services', 0, '', ''), 
(151, '41124', 'Corporate Benefit Services of America - (CBSA)', 0, '', ''), 
(152, '58102', 'Covenant Administrators, Inc', 0, '', ''), 
(153, '25148', 'Coventry Health Care of Georgia, Inc', 0, '', ''), 
(154, '68241', 'CustomCare (Southwestern Bell-Exec)', 0, '', ''), 
(155, 'DEW01', 'D. Edward Wright TPA', 0, '', ''), 
(156, '94276', 'DDIC (AK, AL, FL, GA, LA, MS, MT, NV, TX)', 0, '', ''), 
(157, '97276', 'Delta Dental Insurance Co. (DDIC)', 0, '', ''), 
(158, 'DDAL1', 'Delta Dental of Alabama', 0, '', ''), 
(159, 'DDAK1', 'Delta Dental of Alaska', 0, '', ''), 
(160, '86027', 'Delta Dental of Arizona', 0, '', ''), 
(161, 'DDAR1', 'Delta Dental of Arizona', 0, '', ''), 
(162, 'DDPAR', 'Delta Dental of Arkansas', 0, '', ''), 
(163, 'CDAR1', 'Delta Dental of Arkansas', 0, '', ''), 
(164, '77777', 'Delta Dental of California', 0, '', ''), 
(165, 'DDCA1', 'Delta Dental of California', 0, '', ''), 
(166, 'CDCA1', 'Delta Dental of California/Tricare Retiree Dental', 0, '', ''), 
(167, '84056', 'Delta Dental of Colorado', 0, '', ''), 
(168, 'DDDE1', 'Delta Dental of Delaware', 0, '', ''), 
(169, '51022', 'Delta Dental of Delaware', 0, '', ''), 
(170, 'DDFL1', 'Delta Dental of Florida', 0, '', ''), 
(171, 'DDGA1', 'Delta Dental of Georgia', 0, '', ''), 
(172, '82029', 'Delta Dental of Idaho', 0, '', ''), 
(173, '47598', 'Delta Dental of Illinois', 0, '', ''), 
(174, '05030', 'Delta Dental of Illinois', 0, '', ''), 
(175, 'DELTI', 'Delta Dental of Indiana', 0, '', ''), 
(176, 'CDIN1', 'Delta Dental of Indiana', 0, '', ''), 
(177, 'DDPI', 'Delta Dental of Indiana', 0, '', ''), 
(178, 'CDIA1', 'Delta Dental of Iowa', 0, '', ''), 
(179, 'CDKS1', 'Delta Dental of Kansas', 0, '', ''), 
(180, 'CDKY1', 'Delta Dental of Kentucky', 0, '', ''), 
(181, 'DDLA1', 'Delta Dental of Lousiana', 0, '', ''), 
(182, '23166', 'Delta Dental of Maryland', 0, '', ''), 
(183, '04614', 'Delta Dental of Massachusetts', 0, '', ''), 
(184, 'CDMI0', 'Delta Dental of Michigan', 0, '', ''), 
(185, 'DELTA', 'Delta Dental of Michigan', 0, '', ''), 
(186, 'DDPM', 'Delta Dental of Michigan', 0, '', ''), 
(187, '07000', 'Delta Dental of Minnesota', 0, '', ''), 
(188, 'CDMN1', 'Delta Dental of Minnesota', 0, '', ''), 
(189, 'DDMS1', 'Delta Dental of Mississippi', 0, '', ''), 
(190, '43090', 'Delta Dental of Missouri', 0, '', ''), 
(191, 'DDMT1', 'Delta Dental of Montana', 0, '', ''), 
(192, 'DDNE1', 'Delta Dental of Nebraska', 0, '', ''), 
(193, '07025', 'Delta Dental of Nebraska', 0, '', ''), 
(194, 'DDNV1', 'Delta Dental of Nevada', 0, '', ''), 
(195, '22189', 'Delta Dental of New Jersey', 0, '', ''), 
(196, 'DDNJ1', 'Delta Dental of New Jersey', 0, '', ''), 
(197, '85022', 'Delta Dental of New Mexico', 0, '', ''), 
(198, 'DDNM1', 'Delta Dental of New Mexico', 0, '', ''), 
(199, 'DDPNM1', 'Delta Dental of New Mexico', 0, '', ''), 
(200, 'DELTM', 'Delta Dental of New Mexico', 0, '', ''), 
(201, '11198', 'Delta Dental of New York', 0, '', ''), 
(202, 'DDNY1', 'Delta Dental of New York', 0, '', ''), 
(203, 'DDNC1', 'Delta Dental of North Carolina', 0, '', ''), 
(204, '56101', 'Delta Dental of North Carolina', 0, '', ''), 
(205, 'CDND1', 'Delta Dental of North Dakota', 0, '', ''), 
(206, '07029', 'Delta Dental of North Dakota', 0, '', ''), 
(207, '02027', 'Delta Dental of Northeast (ME, NH, VT)', 0, '', ''), 
(208, 'DELTO', 'Delta Dental of Ohio', 0, '', ''), 
(209, 'CDOH1', 'Delta Dental of Ohio', 0, '', ''), 
(210, 'DDPO', 'Delta Dental of Ohio', 0, '', ''), 
(211, 'DELOK', 'Delta Dental of Oklahoma', 0, '', ''), 
(212, 'CDOK1', 'Delta Dental of Oklahoma', 0, '', ''), 
(213, 'DDPOK', 'Delta Dental of Oklahoma', 0, '', ''), 
(214, 'CDOR1', 'Delta Dental of Oregon', 0, '', ''), 
(215, 'DDPA1', 'Delta Dental of Pennsylvania', 0, '', ''), 
(216, '23166', 'Delta Dental of Pennsylvania', 0, '', ''), 
(217, '05029', 'Delta Dental of Rhode Island', 0, '', ''), 
(218, '43091', 'Delta Dental of South Carolina in Missouri', 0, '', ''), 
(219, '54097', 'Delta Dental of South Dakota', 0, '', ''), 
(220, 'DELTN', 'Delta Dental of Tennessee', 0, '', ''), 
(221, 'DDPTN', 'Delta Dental of Tennessee', 0, '', ''), 
(222, 'CDTN1', 'Delta Dental of Tennessee', 0, '', ''), 
(223, 'DDTX1', 'Delta Dental of Texas', 0, '', ''), 
(224, 'DDUT1', 'Delta Dental of Utah', 0, '', ''), 
(225, '54084', 'Delta Dental of Virginia', 0, '', ''), 
(226, '52147', 'Delta Dental of Washington D.C.', 0, '', ''), 
(227, 'DDDC1', 'Delta Dental of Washington D.C.', 0, '', ''), 
(228, '31096', 'Delta Dental of West Virginia', 0, '', ''), 
(229, 'DDWV1', 'Delta Dental of West Virginia', 0, '', ''), 
(230, '39069', 'Delta Dental of Wisconsin', 0, '', ''), 
(231, 'CDWY1', 'Delta Dental of Wyoming', 0, '', ''), 
(232, '07027', 'Delta Dental of Wyoming', 0, '', ''), 
(233, '07029', 'Delta Dental Plan of North Dakota', 0, '', ''), 
(234, 'DDND1', 'Delta Dental Plan of North Dakota', 0, '', ''), 
(235, '07027', 'Delta Dental Plan of Wyoming', 0, '', ''), 
(236, 'DDWY1', 'Delta Dental Plan of Wyoming', 0, '', ''), 
(237, 'CX049', 'DeneX/SG', 0, '', ''), 
(238, '52133', 'Dental Benefit Providers', 0, '', ''), 
(239, 'CX035', 'Dental Care Plus', 0, '', ''), 
(240, 'DCP01', 'Dental Care Plus (DCP)', 0, '', ''), 
(241, 'CX017', 'Dental Comp', 0, '', ''), 
(242, 'CX034', 'Dental Network', 0, '', ''), 
(243, '43091', 'Dental Plan of the South Carolina in Missouri', 0, '', ''), 
(244, '54084', 'Dental Plan of Virginia', 0, '', ''), 
(245, '52133', 'Dental Profit Providers', 0, '', ''), 
(246, '04356', 'DentaQuest', 0, '', ''), 
(247, '94146', 'Denti-Cal', 1, '', ''), 
(248, '94146', 'Denti-Cal Medicaid of California', 1, '', ''), 
(249, 'A1004', 'Detroit Laborers (Metropolitan)', 0, '', ''), 
(250, 'HSP01', 'District Council 37 Health & Welfare Fund', 0, '', ''), 
(251, 'DOM01', 'Dominion Dental', 0, '', ''), 
(252, 'CX104', 'Doral Dental Medicaid of Ohio', 1, '', ''), 
(253, 'CKOK1', 'Doral Dental Medicaid of Oklahoma', 1, '', ''), 
(254, 'CKPA1', 'Doral Dental Medicaid of Pennsylvania', 1, '', ''), 
(255, 'CKWI1', 'Doral Dental Medicaid of Wisconsin', 1, '', ''), 
(256, 'CX014', 'Doral Dental of Arizona  CIGNA', 0, '', ''), 
(257, 'CX014', 'Doral Dental of Arizona  Non Global Budget', 0, '', ''), 
(258, 'CX014', 'Doral Dental of Connecticu', 0, '', ''), 
(259, 'CX014', 'Doral Dental of Illinois', 0, '', ''), 
(260, 'CX014', 'Doral Dental of Kansas', 0, '', ''), 
(261, 'CX014', 'Doral Dental of Kentucky', 0, '', ''), 
(262, 'CKKY3', 'Doral Dental of Kentucky/Region #3', 1, '', ''), 
(263, 'CX014', 'Doral Dental of Maryland  Helix', 0, '', ''), 
(264, 'CX014', 'Doral Dental of Maryland  Physicians Care', 0, '', ''), 
(265, 'CX014', 'Doral Dental of Maryland  Priority Partners', 0, '', ''), 
(266, 'CX014', 'Doral Dental of Minnesota (M)', 1, '', ''), 
(267, 'CX014', 'Doral Dental of Minnesota Medicare', 1, '', ''), 
(268, 'CX014', 'Doral Dental of Missouri  Kansas City', 0, '', ''), 
(269, 'CX014', 'Doral Dental of Missouri  St. Louis', 0, '', ''), 
(270, 'CX014', 'Doral Dental of Nebraska', 0, '', ''), 
(271, 'CX014', 'Doral Dental of New Jersey  Amerigroup', 0, '', ''), 
(272, 'CX014', 'Doral Dental of New Mexico', 0, '', ''), 
(273, 'CX014', 'Doral Dental of New York', 0, '', ''), 
(274, 'CX014', 'Doral Dental of New York  Non Global Budget', 0, '', ''), 
(275, 'CX014', 'Doral Dental of Ohio (M)', 1, '', ''), 
(276, 'CX014', 'Doral Dental of Oklahoma  Community Care', 0, '', ''), 
(277, 'CX014', 'Doral Dental of Oklahoma  Heartland', 0, '', ''), 
(278, 'CX014', 'Doral Dental of Oklahoma  Non Global Budget', 0, '', ''), 
(279, 'CX014', 'Doral Dental of Oklahoma  Unicare', 0, '', ''), 
(280, 'CX014', 'Doral Dental of Oklahoma  Unicare Non Global', 0, '', ''), 
(281, 'CX014', 'Doral Dental of Pennsylvania  AmeriHealth', 0, '', ''), 
(282, 'CX014', 'Doral Dental of Pennsylvania  Healthmate', 0, '', ''), 
(283, 'CX014', 'Doral Dental of Pennsylvania  Keystone', 0, '', ''), 
(284, 'CX014', 'Doral Dental of Pennsylvania  Philadelphia', 0, '', ''), 
(285, 'CX014', 'Doral Dental of Pennsylvania  Pittsburgh', 0, '', ''), 
(286, 'CX014', 'Doral Dental of Tennessee  TennCare', 0, '', ''), 
(287, 'CX014', 'Doral Dental of USA', 0, '', ''), 
(288, 'CX014', 'Doral Dental of Virginia  Commercial', 0, '', ''), 
(289, 'CX014', 'Doral Dental of Virginia  Premier', 0, '', ''), 
(290, 'CX014', 'Doral Dental of Virginia  Sentara', 0, '', ''), 
(291, 'CX014', 'Doral Dental of Virginia  Unicare', 0, '', ''), 
(292, 'CX014', 'Doral Dental of Virginia (M)', 1, '', ''), 
(293, 'CX014', 'Doral Dental of Wisconsin', 0, '', ''), 
(294, 'CX014', 'Doral Dental Plan of Wisconsin', 0, '', ''), 
(295, 'DTCH1', 'Dutcher Insurance', 0, '', ''), 
(296, '75232', 'E3 Health, Inc.', 0, '', ''), 
(297, '81039', 'EBMS (Employee Beneft management Services, Inc.', 0, '', ''), 
(298, 'CX043', 'EBS Benefit Solutions', 0, '', ''), 
(299, 'CKPA1', 'EDS Medicaid of Pennsylvania', 1, '', ''), 
(300, '73288', 'EHI', 0, '', ''), 
(301, '73288', 'EHI, EHIC', 0, '', ''), 
(302, 'EWF01', 'Electrical Workers Benefit Fund (IBEW local 369)', 0, '', ''), 
(303, '73288', 'EMPHESYS', 0, '', ''), 
(304, '55093', 'Empire Blue Cross/Blue Shield', 0, '', ''), 
(305, 'CX012', 'Employee Benefit Admin. (Pembroke, Mass.)', 0, '', ''), 
(306, '38241', 'Employee Benefit Concepts', 0, '', ''), 
(307, 'CX025', 'Employee Benefit Management Corp. (EBMC)', 0, '', ''), 
(308, '81039', 'Employee Benefit Mang. Services, Inc. (EBMS)', 0, '', ''), 
(309, '03036', 'Employee Beneftis Plan Administration, Inc. (EBPA)', 0, '', ''), 
(310, 'CX022', 'Employee Group Services (EGS)', 0, '', ''), 
(311, '73288', 'Employee Health Insurance', 0, '', ''), 
(312, '73288', 'Employee Health Insurance of Wisconsin', 0, '', ''), 
(313, '73288', 'Employee Health of Wisconsin (EMPHESYS)(EHIC)', 0, '', ''), 
(314, '35112', 'Employee Plans, LLC', 0, '', ''), 
(315, '54098', 'Employee Security Inc.', 0, '', ''), 
(316, '73288', 'Employers Health Insurance', 0, '', ''), 
(317, '73288', 'Employers Health Of Wisconsin (EMPHESYS) (EHIC)', 0, '', ''), 
(318, '91136', 'Enstar Natural Gas', 0, '', ''), 
(319, '62308', 'Equicore', 0, '', ''), 
(320, '62308', 'Equitable', 0, '', ''), 
(321, '73126', 'Equitable Plan Services', 0, '', ''), 
(322, 'CX046', 'Erin Group Administrators in PA', 0, '', ''), 
(323, '43168', 'Essex Dental Benefits', 0, '', ''), 
(324, '00003', 'Excellus', 0, '', ''), 
(325, '71412', 'ExclusiCare', 0, '', ''), 
(326, 'CX002', 'Family members Dental Plan (FMDP)', 0, '', ''), 
(327, '41041', 'Federated Mutual Health Insurance', 0, '', ''), 
(328, '71056', 'FedEx Freight East, Inc.', 0, '', ''), 
(329, '69140', 'First Allmerica Financial Life Ins. Co.', 0, '', ''), 
(330, '72630', 'First Ameritas Life Insurance Corp. of New York', 0, '', ''), 
(331, '60033', 'First Ameritas Life Insurance Corp. of NY', 0, '', ''), 
(332, '87043', 'First Health', 0, '', ''), 
(333, '75232', 'First Integrated Health', 0, '', ''), 
(334, '71005', 'First Reliance Standard', 0, '', ''), 
(335, '13317', 'First Reliance Standard (N.Y. Business) (Ameritas)', 0, '', ''), 
(336, '68241', 'FlexCare', 0, '', ''), 
(337, '48116', 'Florida Hospital Waterman', 0, '', ''), 
(338, '68241', 'Florida Power & Light', 0, '', ''), 
(339, '68241', 'Florida Power & Light/ FlexCare', 0, '', ''), 
(340, '48117', 'FMH Benefit Services Inc. of KS', 0, '', ''), 
(341, '70408', 'Fortis Benefits Insurance Company', 0, '', ''), 
(342, '39065', 'Fortis Insurance Company', 0, '', ''), 
(343, '41124', 'Fortis Self Funded Administrative Services', 0, '', ''), 
(344, 'CX041', 'Fraternal Order of Police', 0, '', ''), 
(345, '67814', 'G.E. Group Life Assurance Company', 0, '', ''), 
(346, 'GCU01', 'GCU Local 8-M & 96B health & Welsfare Fund', 0, '', ''), 
(347, '44054', 'GEHA', 0, '', ''), 
(348, '63665', 'General American Life Insurance Co.', 0, '', ''), 
(349, '13551', 'GHI - New York - (Group Health Inc.)', 0, '', ''), 
(350, '80314', 'GIC', 0, '', ''), 
(351, '07205', 'Gilsbar, Inc', 0, '', ''), 
(352, '91136', 'Glassworkers Health & Welfare Fund, Grp. #F29', 0, '', ''), 
(353, 'GWD01', 'Golden West Dental', 0, '', ''), 
(354, '44054', 'Government Employee Hospital Association, Inc', 0, '', ''), 
(355, '80705', 'Great West Life & Annuity Insurance Co.', 0, '', ''), 
(356, '36338', 'Group Administrators Ltd.', 0, '', ''), 
(357, 'CX011', 'Group Benefit Services (East Lansing, Mich.)', 0, '', ''), 
(358, '38194', 'Group Health Managers of MI', 0, '', ''), 
(359, 'CX015', 'Group Link of Indiana', 0, '', ''), 
(360, 'CX036', 'Group Services of Houston, TX', 0, '', ''), 
(361, '64246', 'Guardian Life Insurance Co. of America', 0, '', ''), 
(362, '95266', 'Harrington Benefit Services, Inc.', 0, '', ''), 
(363, '06131', 'Harrington Benefit Services, Inc. (Formerly TPCM)', 0, '', ''), 
(364, '59142', 'Harrington Benefit Services, Inc. (Oklahoma)', 0, '', ''), 
(365, '0000F', 'Health Economics Group', 0, '', ''), 
(366, 'CX039', 'Health Economics Group Inc.', 0, '', ''), 
(367, '30946', 'Health Furture, LLC', 0, '', ''), 
(368, '84097', 'Health Management Systems', 0, '', ''), 
(369, 'CX009', 'Health Partners of Minnesota', 0, '', ''), 
(370, 'CX010', 'Health Partners of Minnesota Medicaid', 1, '', ''), 
(371, '62157', 'Health Partners of Tennessee', 0, '', ''), 
(372, '59142', 'Health Plan Services (Oklahoma)', 0, '', ''), 
(373, 'CX019', 'Health Resources Incorporated (HRI)', 0, '', ''), 
(374, '41170', 'Health Risk Management (HRM)', 0, '', ''), 
(375, 'HMA01', 'Healthcare Management Administrators', 0, '', ''), 
(376, 'HNET1', 'HealthNet Dental Claims', 0, '', ''), 
(377, 'HNET2', 'HealthNet Dental Encounters', 0, '', ''), 
(378, '11271', 'Healthplex, Inc.', 0, '', ''), 
(379, '87043', 'HealthRight Inc. of Connecticut (To First Health)', 0, '', ''), 
(380, '71063', 'HealthSCOPE Benefits, Inc.', 0, '', ''), 
(381, '68195', 'Healthsource Provident (CIGNA)', 0, '', ''), 
(382, 'HGL01', 'Heavy & General Laborers', 0, '', ''), 
(383, 'CX015', 'Hooser Dental Benefit Trust (GroupLink)', 0, '', ''), 
(384, 'CX015', 'Hooser Dental Plans (GroupLink)', 0, '', ''), 
(385, '22099', 'Horizon Blue Cross/Blue Shield', 0, '', ''), 
(386, 'BCNJ1', 'Horizon Blue Cross/Blue Shield of New Jersey', 0, '', ''), 
(387, '22099', 'Horizon Blue Cross/Blue Shield of New Jersey', 0, '', ''), 
(388, '91136', 'Hotel Employees & Restaurant Employees Health Trust', 0, '', ''), 
(389, '41170', 'HRM Claim Management', 0, '', ''), 
(390, '73288', 'Humana', 0, '', ''), 
(391, '22175', 'I.E. Shaffer', 0, '', ''), 
(392, 'IAT01', 'IATSE Atlanta Health & Welfare Fund', 0, '', ''), 
(393, 'A1117', 'IBEW Local 117', 0, '', ''), 
(394, 'A1317', 'IBEW Local 38', 0, '', ''), 
(395, 'A1461', 'IBEW Local 461', 0, '', ''), 
(396, 'A4681', 'IBEW Local 481', 0, '', ''), 
(397, '41124', 'IBI (Iowa Benefits Inc.)', 0, '', ''), 
(398, '36600', 'Illinois Central Hospital Association', 0, '', ''), 
(399, 'ICW01', 'Indiana Carpenters Welfare Fund', 0, '', ''), 
(400, '13315', 'Insurance Design Administrators of New Jersey', 0, '', ''), 
(401, '88006', 'Insurance Management Services', 0, '', ''), 
(402, '51020', 'Integra Administrative Group', 0, '', ''), 
(403, 'IAT01', 'Intern. Assoc. of Theatrical Stage Employees (IATSE) Atlanta health & Welfare Fund', 0, '', ''), 
(404, '36609', 'International Brotherhood of Boilermakers', 0, '', ''), 
(405, '41124', 'Iowa Benefits Inc.', 0, '', ''), 
(406, '61271', 'J. F. Molloy and Associates', 0, '', ''), 
(407, 'JPF01', 'Jefferson Pilot/Guarantee Life Insurance', 0, '', ''), 
(408, 'JEN01', 'Jenkins & Associates', 0, '', ''), 
(409, '14168', 'JLT Services Corporation', 0, '', ''), 
(410, '95378', 'John Deere Health Care/Heritage National Health Plan', 0, '', ''), 
(411, '65099', 'John Hancock Health Security Plan', 0, '', ''), 
(412, '57038', 'Kanawha Insurance Company', 0, '', ''), 
(413, 'KBT01', 'Kansas Bulding Trades', 0, '', ''), 
(414, '73100', 'Kempton Group Administrators', 0, '', ''), 
(415, '73100', 'Kempton Group Company', 0, '', ''), 
(416, 'LSH01', 'Laborers Southeast Health & Welfare Plan', 0, '', ''), 
(417, '78140', 'Life Insurance Co. of Boston & New York', 0, '', ''), 
(418, 'CX047', 'LifeRe', 0, '', ''), 
(419, '73288', 'Lincoln National (WI)', 0, '', ''), 
(420, 'NYT01', 'Local 1149 Baldwinsville, NY', 0, '', ''), 
(421, 'NYT01', 'Local 118 Rochester, NY', 0, '', ''), 
(422, '35107', 'Local 135 Health Benefits', 0, '', ''), 
(423, 'NYT01', 'Local 182 Utica, NY', 0, '', ''), 
(424, 'NYT01', 'Local 264 Cheektowaga, NY', 0, '', ''), 
(425, 'NYT01', 'Local 294 Albany, NY', 0, '', ''), 
(426, 'NYT01', 'Local 317 Syracuse, NY', 0, '', ''), 
(427, 'NYT01', 'Local 375 Buffalo, NY', 0, '', ''), 
(428, 'NYT01', 'Local 529 Elmira, NY', 0, '', ''), 
(429, 'NYT01', 'Local 669 Albany, NY', 0, '', ''), 
(430, 'NYT01', 'Local 687 Potsdam, NY', 0, '', ''), 
(431, 'NYT01', 'Local 693 Binghamton, NY', 0, '', ''), 
(432, 'NYT01', 'Local 791 Rocheter, NY', 0, '', ''), 
(433, 'GCU01', 'Local 8-M & 96B Health & Welfare', 0, '', ''), 
(434, '62310', 'Lovelace Health Plan', 0, '', ''), 
(435, '62310', 'Lovelace Senior Options (LSO)', 0, '', ''), 
(436, '62310', 'Lovelace Senior Plan (LSP)', 0, '', ''), 
(437, '10317', 'Machigonne Benefit Administrators', 0, '', ''), 
(438, 'CX042', 'Mahoney Benefit Admin. Of TX', 0, '', ''), 
(439, '62413', 'Mailhandlers Benefit Plan', 0, '', ''), 
(440, 'CX033', 'MAMSI', 0, '', ''), 
(441, '84097', 'Managed Dental Care Network (MDCN) (Encounters Only)', 0, '', ''), 
(442, 'CX014', 'Managed health Services-WI State Employee', 0, '', ''), 
(443, '98010', 'Manulife, W.J. Sutton Co.', 0, '', ''), 
(444, '68241', 'Marriott', 0, '', ''), 
(445, '65935', 'Mass Mutual', 0, '', ''), 
(446, '56205', 'MBS (MedCost Benefit Services)', 0, '', ''), 
(447, '74323', 'MedBen (Newark, OH)', 0, '', ''), 
(448, '56205', 'MedCost of North Carolina', 0, '', ''), 
(449, '07031', 'Medica Dental', 0, '', ''), 
(450, 'CX026', 'MEDICA of Minnesota', 0, '', ''), 
(451, 'CXAL1', 'Medicaid of Alabama', 1, '', ''), 
(452, 'CKAK1', 'Medicaid of Alaska', 1, '', ''), 
(453, 'CKAR1', 'Medicaid of Arkansas', 1, '', ''), 
(454, '94146', 'Medicaid of California (Denti-Cal)', 1, '', ''), 
(455, 'CKCO1', 'Medicaid of Colorado', 1, '', ''), 
(456, 'CKCT1', 'Medicaid of Connecticut', 1, '', ''), 
(457, 'CKDE1', 'Medicaid of Delaware', 1, '', ''), 
(458, '77027', 'Medicaid of Florida', 1, '', ''), 
(459, 'CKFL1', 'Medicaid of Florida', 1, '', ''), 
(460, 'CKGA1', 'Medicaid of Georgia', 1, '', ''), 
(461, 'CKID1', 'Medicaid of Idaho', 1, '', ''), 
(462, 'CKIL1', 'Medicaid of Illinois', 1, '', ''), 
(463, 'CKIN1', 'Medicaid of Indiana', 1, '', ''), 
(464, 'CKIA1', 'Medicaid of Iowa', 1, '', ''), 
(465, 'CKKS1', 'Medicaid of Kansas', 1, '', ''), 
(466, 'CKKY1', 'Medicaid of Kentucky', 1, '', ''), 
(467, 'CKKY3', 'Medicaid of Kentucky Region #3', 1, '', ''), 
(468, 'CKLA2', 'Medicaid of Louisiana (ADULT)', 1, '', ''), 
(469, 'CKLA1', 'Medicaid of Louisiana (EPSDT)', 1, '', ''), 
(470, 'CKME1', 'Medicaid of Maine', 1, '', ''), 
(471, 'CKMD1', 'Medicaid of Maryland', 1, '', ''), 
(472, 'CKMA1', 'Medicaid of Massachusetts', 1, '', ''), 
(473, 'CKMI1', 'Medicaid of Michigan', 1, '', ''), 
(474, 'CKMN1', 'Medicaid of Minnesota', 1, '', ''), 
(475, 'CX010', 'Medicaid of Minnesota (by Health Partners)', 1, '', ''), 
(476, 'CKMS1', 'Medicaid of Mississippi', 1, '', ''), 
(477, 'CKMO1', 'Medicaid of Missouri', 1, '', ''), 
(478, 'CKMT1', 'Medicaid of Montana', 1, '', ''), 
(479, 'CX014', 'Medicaid of Nebraska', 1, '', ''), 
(480, 'CKNV1', 'Medicaid of Nevada', 1, '', ''), 
(481, 'CKNH1', 'Medicaid of New Hampshire', 1, '', ''), 
(482, 'CKNJ1', 'Medicaid of New Jersey', 1, '', ''), 
(483, '86047', 'Medicaid of New Jersey (Adminstrated by Americhoice)', 1, '', ''), 
(484, 'CX014', 'Medicaid of New Mexico', 1, '', ''), 
(485, 'CKNM1', 'Medicaid of New Mexico', 1, '', ''), 
(486, 'CKNY1', 'Medicaid of New York', 1, '', ''), 
(487, '86048', 'Medicaid of New York (Adminstrated by Americhoice)', 1, '', ''), 
(488, 'CKNY2', 'Medicaid of New York (Dental Clinics Only)', 1, '', ''), 
(489, 'CKNC1', 'Medicaid of North Carolina', 1, '', ''), 
(490, 'CX104', 'Medicaid of Ohio  (Administered by Doral Dental)', 1, '', ''), 
(491, 'CKOH2', 'Medicaid of Ohio (Administered by CareSource)', 1, '', ''), 
(492, 'CKOH1', 'Medicaid of Ohio (Administered by Quadax)', 1, '', ''), 
(493, 'CX014', 'Medicaid of Oklahoma  (Administered by Doral Dental)', 1, '', ''), 
(494, 'CKOK1', 'Medicaid of Oklahoma (Administered by UNISYS)', 1, '', ''), 
(495, 'CKOR1', 'Medicaid of Oregon', 1, '', ''), 
(496, 'CX014', 'Medicaid of Pennsylvania  (Administered by Doral Dental)', 1, '', ''), 
(497, '86049', 'Medicaid of Pennsylvania (Administered by Americhoice)', 1, '', ''), 
(498, 'CKPA1', 'Medicaid of Pennsylvania (Administered by EDS)', 1, '', ''), 
(499, 'CKRI1', 'Medicaid of Rhode Island', 1, '', ''), 
(500, 'CKSC1', 'Medicaid of South Carolina', 1, '', ''), 
(501, 'CKTN1', 'Medicaid of Tennessee, Access Med Plus', 1, '', ''), 
(502, 'CKTX1', 'Medicaid of Texas', 1, '', ''), 
(503, 'CKUT1', 'Medicaid of Utah', 1, '', ''), 
(504, 'CKVT1', 'Medicaid of Vermont', 1, '', ''), 
(505, 'CKVA1', 'Medicaid of Virginia', 1, '', ''), 
(506, 'CX014', 'Medicaid of Virginia (Administered by Doral Dental)', 1, '', ''), 
(507, 'CKWA1', 'Medicaid of Washington', 1, '', ''), 
(508, 'CKWV1', 'Medicaid of West Virginia', 1, '', ''), 
(509, 'CKWI1', 'Medicaid of Wisconsin', 1, '', ''), 
(510, 'CX014', 'Medicaid of Wisconsin (Administered by Doral Dental)', 1, '', ''), 
(511, 'CKWY1', 'Medicaid of Wyoming', 1, '', ''), 
(512, 'CX024', 'Medical Benefit Administrators', 0, '', ''), 
(513, '74323', 'Medical Benefits Companies (Newark, OH)', 0, '', ''), 
(514, '74323', 'Medical Benefits Mutual', 0, '', ''), 
(515, 'CB833', 'Medical Mutual of Ohio (MMO)', 0, '', ''), 
(516, '59226', 'MEGA Life & Health Co. (Family Division)', 0, '', ''), 
(517, '74227', 'MEGA Life & Health Co. (Student Division)', 0, '', ''), 
(518, 'MNM01', 'Mennonite Mutual Aid', 0, '', ''), 
(519, '65978', 'MetLife', 0, '', ''), 
(520, '87726', 'MetLife (formerly Travelers)', 0, '', ''), 
(521, 'A1004', 'Metropolitan Detroit Laborers', 0, '', ''), 
(522, 'A1432', 'Michigan Laborers', 0, '', ''), 
(523, 'A1404', 'Michigan State Painters', 0, '', ''), 
(524, 'MAMS1', 'Mid-Atlantic Medical Services, Inc. (MAMSI)', 0, '', ''), 
(525, '74227', 'Mid-West United Life (Student Division)', 0, '', ''), 
(526, 'A1402', 'Millwrights Local 1102 Health & Welfare Fund', 0, '', ''), 
(527, '36111', 'Motorola', 0, '', ''), 
(528, '86040', 'Mountain States Administrative Services', 0, '', ''), 
(529, '69140', 'Mutual Alliance Plan (MAP)', 0, '', ''), 
(530, '71412', 'Mutual of Omaha Insurance Co.', 0, '', ''), 
(531, '71412', 'Mutually Preferred', 0, '', ''), 
(532, '91136', 'N.W. International Assc. Of Machinists & Aerospace Engineers Benefits Trust', 0, '', ''), 
(533, '91136', 'N.W. Ironworkers Health & Security Trust Fund', 0, '', ''), 
(534, '91136', 'N.W. Roffers & Employers Health & Securtiy Trust Fund', 0, '', ''), 
(535, '91136', 'N.W. Textile Processors', 0, '', ''), 
(536, '53011', 'National Assoc. of Letter Carriers/NALC', 0, '', ''), 
(537, 'CX045', 'National Elevator Industy Benefit Plans (NEIB) of PA', 0, '', ''), 
(538, '71412', 'National Rural Letter Carrier Assoc.', 0, '', ''), 
(539, '75190', 'NCAS - Fairfax, VA', 0, '', ''), 
(540, '54098', 'NEA Alaska Health Plan', 0, '', ''), 
(541, '43351', 'New England Dental Administrators', 0, '', ''), 
(542, '66893', 'New England Financial', 0, '', ''), 
(543, '38332', 'New World Claims Services', 0, '', ''), 
(544, '66915', 'New York Life (now NYLCare) **(N)', 0, '', ''), 
(545, 'NYT01', 'New York State Teamsters Union', 0, '', ''), 
(546, '81264', 'Nippon Life Insurance Co.', 0, '', ''), 
(547, '65085', 'North America Administrators, L.P.', 0, '', ''), 
(548, 'DDPNE', 'Northeast Delta Dental (ME, NH, VT)', 0, '', ''), 
(549, '02027', 'Northeast Delta Dental (ME, NH, VT)', 0, '', ''), 
(550, '88027', 'Northern Nevada Trust Fund', 0, '', ''), 
(551, '91060', 'Northwest Administrators', 0, '', ''), 
(552, '93525', 'Northwest Dental Services', 0, '', ''), 
(553, '41045', 'Northwestern National Life (Now ReliaStar)', 0, '', ''), 
(554, '16644', 'NOVA HEALTHCARE ADMIN., INC.', 0, '', ''), 
(555, '91166', 'Nylcae health Plan Northwest', 0, '', ''), 
(556, 'OAC01', 'Ohio AFSCME Care Plan', 0, '', ''), 
(557, '80705', 'ONE Health Plan Inc.', 0, '', ''), 
(558, '91136', 'Operating Engineers Locals 302 & 612 Health & Security Fund, Grp. #F12', 0, '', ''), 
(559, 'CDOR1', 'Oregon Dental Service', 0, '', ''), 
(560, '84104', 'Oxford Health Plans', 0, '', ''), 
(561, '67466', 'Pacific Life & Annuity', 0, '', ''), 
(562, '93029', 'PacificSource Health Plans', 0, '', ''), 
(563, '61301', 'Paul Revere/Provident', 0, '', ''), 
(564, '47009', 'Paul Revere/Provident', 0, '', ''), 
(565, 'PRW01', 'Pavers and Road Builders Welfare Fund', 0, '', ''), 
(566, '54771', 'Pennsylvania Blue Shield', 0, '', ''), 
(567, '67814', 'Phoenix American', 0, '', ''), 
(568, '67814', 'Phoenix Home Life', 0, '', ''), 
(569, 'CX014', 'Physicians Plus Insurance, -WI State Employees', 0, '', ''), 
(570, '24735', 'Pinnacle Claims Management, Inc.', 0, '', ''), 
(571, 'PIP01', 'Pipe Trades Industry Health & Welfare Fund', 0, '', ''), 
(572, 'PIP02', 'Pipefitters 597', 0, '', ''), 
(573, 'PCM01', 'Plasterers & Cement Masons Local 148 Health & Welfare Fund', 0, '', ''), 
(574, '67466', 'PM Group', 0, '', ''), 
(575, 'DDCA2', 'PMI DeltaCare Claims', 0, '', ''), 
(576, 'DDCA3', 'PMI DeltaCare Encounters', 0, '', ''), 
(577, '67466', 'PMI Group', 0, '', ''), 
(578, '16111', 'POMCO', 0, '', ''), 
(579, '68241', 'Preferred Dental Organization (PDO)', 0, '', ''), 
(580, '47570', 'Premara Blue Cross', 0, '', ''), 
(581, 'CX029', 'Premier Dental', 0, '', ''), 
(582, '56144', 'Primary PhysicianCare, Inc.', 0, '', ''), 
(583, '61271', 'Principal Financial Group', 0, '', ''), 
(584, '61271', 'Principal Mutual Life Insurance Co.', 0, '', ''), 
(585, '06126', 'Print Claims', 0, '', ''), 
(586, '36331', 'Professional Benefit Administrators, Inc', 0, '', ''), 
(587, '70408', 'Protective Life', 0, '', ''), 
(588, '70408', 'Protective Life Insurance Company', 0, '', ''), 
(589, '68195', 'Provident Life & Acc. Ins. Co. of America', 0, '', ''), 
(590, '68195', 'Provident Life & Casualty Ins, Co.', 0, '', ''), 
(591, '68195', 'Provident Life and Accident Ins. Co.', 0, '', ''), 
(592, '68195', 'Provident Preferred Network', 0, '', ''), 
(593, '60054', 'Prudential', 0, '', ''), 
(594, '68241', 'Prudential', 0, '', ''), 
(595, '91136', 'Pugent Sound Benefits Trust', 0, '', ''), 
(596, '91136', 'Pugent Sound Electrical Workers Trust', 0, '', ''), 
(597, 'QM001', 'Quad Med', 0, '', ''), 
(598, 'CKOH1', 'Quadax Medicaid of Ohio', 1, '', ''), 
(599, 'CB850', 'Regence Blue Cross / Blue Sheild Oregon', 0, '', ''), 
(600, 'CB850', 'Regence Blue Cross/Blue Shield of Oregon', 0, '', ''), 
(601, 'CBID2', 'Regence Blue Shield Idaho', 0, '', ''), 
(602, '93200', 'Regence Northwest Health', 0, '', ''), 
(603, '93200', 'Regence Washington Health  AKA', 0, '', ''), 
(604, '38221', 'Regency Employee Benefits of MI', 0, '', ''), 
(605, '36088', 'Reliance Standard Life', 0, '', ''), 
(606, '68381', 'Reliance Standard Life', 0, '', ''), 
(607, '80314', 'ReliaStar (Prev.Northwestern National Life)', 0, '', ''), 
(608, '84102', 'Rocky Mountain Life Dental', 0, '', ''), 
(609, 'CX030', 'Safeguard', 0, '', ''), 
(610, 'CX023', 'Seabury & Smith', 0, '', ''), 
(611, 'CX018', 'Select Benefit Administrators', 0, '', ''), 
(612, '60054', 'SelectCare (Coca Cola)', 0, '', ''), 
(613, '68241', 'SelectCare (Coca Cola)', 0, '', ''), 
(614, '34131', 'Self Funded Plans Inc. of Cleveland Ohio', 0, '', ''), 
(615, '59111', 'Self Insured Benefit Administrators', 0, '', ''), 
(616, 'CX020', 'Self Insured Services Company', 0, '', ''), 
(617, 'CX038', 'Serentas Dental Care Solutions', 0, '', ''), 
(618, 'SMW01', 'Sheet Metal Workers Local 91', 0, '', ''), 
(619, 'SLI01', 'Shenandoah Life Insurance Company', 0, '', ''), 
(620, 'SEI01', 'Southeastern Service Employees International Union (SEIU) Health & Welfare Fund', 0, '', ''), 
(621, '56131', 'Southern Group Administrators of NC', 0, '', ''), 
(622, 'SWAD1', 'Southwest Administrators', 0, '', ''), 
(623, '68241', 'Southwester Bell', 0, '', ''), 
(624, '60054', 'Southwestern Bell Exec. - Custom Care', 0, '', ''), 
(625, '60054', 'Southwestern Bell Exec.- Southwest  Bell', 0, '', ''), 
(626, '84147', 'Spina Bifida  VA HAC', 0, '', ''), 
(627, '69019', 'Standard Insurance', 0, '', ''), 
(628, '93024', 'Standard Insurance (OR)', 0, '', ''), 
(629, '13411', 'Standard Insurance Co. (NY)', 0, '', ''), 
(630, '89009', 'Standard Insurance of NY', 0, '', ''), 
(631, 'STR01', 'Starmount Life Insurance Company', 0, '', ''), 
(632, '57254', 'State of Texas Dental Plan', 0, '', ''), 
(633, '31121', 'Stoner and Associates', 0, '', ''), 
(634, '58128', 'Stowe Associates of GA', 0, '', ''), 
(635, '74227', 'Student Insurance  Boston Mutual Life Ins. Co.', 0, '', ''), 
(636, '74227', 'Student Insurance  Life Insurance', 0, '', ''), 
(637, '74227', 'Student Insurance  MEGA Life & Health Ins. Co.', 0, '', ''), 
(638, '74227', 'Student Insurance  Mid-West National Life Ins. Co. of TN', 0, '', ''), 
(639, '74227', 'Student Insurance  Reliance Insurance Co.', 0, '', ''), 
(640, '74227', 'Student Insurance  Reliance National Ins. Co.', 0, '', ''), 
(641, '47009', 'Sun Life of Canada', 0, '', ''), 
(642, '31117', 'Superior Dental Care', 0, '', ''), 
(643, '00003', 'Syracuse Blue Cross / Blue Shield', 0, '', ''), 
(644, '73288', 'TDC - The Dental Companies (Green Bay, WI)', 0, '', ''), 
(645, '88020', 'Teachers Health Trust', 0, '', ''), 
(646, '91060', 'Teamster Construction Industy Welfare Trust', 0, '', ''), 
(647, '80659', 'The Canada Life Assurance Company', 0, '', ''), 
(648, '73288', 'The Dental Companies', 0, '', ''), 
(649, '73288', 'The Dental Concern', 0, '', ''), 
(650, 'TDN01', 'The Dental Network', 0, '', ''), 
(651, '64246', 'The Guardian Life Insurance Co. of America', 0, '', ''), 
(652, '06131', 'Third Party Claims Management', 0, '', ''), 
(653, '25175', 'Three Rivers Health Plans, Inc.', 0, '', ''), 
(654, 'TIC01', 'TIC International, Inc.', 0, '', ''), 
(655, '39065', 'Time Insurance (a Fortis company)', 0, '', ''), 
(656, 'TTTF1', 'Title Insurance Trust Fund', 0, '', ''), 
(657, 'CMS01', 'Total Claims Solution', 0, '', ''), 
(658, '65978', 'Travelers (now MetLife)', 0, '', ''), 
(659, '87726', 'Travelers (now MetLife)', 0, '', ''), 
(660, '73288', 'Tricare Active Reservists Only (Green Bay, WI)', 0, '', ''), 
(661, 'CX002', 'Tricare Dental Plan (United Concordia', 0, '', ''), 
(662, 'CDCA1', 'Tricare Retiree Dental Program - Delta USA', 0, '', ''), 
(663, '84103', 'Trigon Blue Cross / Blue Shield Colorado Dental Office of Virginia', 0, '', ''), 
(664, 'CB923', 'Trigon Blue Cross/Blue Shield of Virginia', 0, '', ''), 
(665, 'CB923', 'Trigon Blue Cross/Blue Shield of Virginia', 0, '', ''), 
(666, '84103', 'Trigon Insurance Company (Colorado)', 0, '', ''), 
(667, '61425', 'Trustmark Insurance', 0, '', ''), 
(668, '73288', 'TSRDP Dental Claims', 0, '', ''), 
(669, '0000N', 'UFCW Local 1', 0, '', ''), 
(670, 'A5205', 'UFCW Local 400-5205', 0, '', ''), 
(671, '75245', 'UICI - Administrators - State of Nevada', 0, '', ''), 
(672, '74223', 'UICI - Administrators - State of Nevada', 0, '', ''), 
(673, '80314', 'UNICARE Individual  Small Group', 0, '', ''), 
(674, '80314', 'UNICARE Major Accounts', 0, '', ''), 
(675, '80314', 'UniCare of Texas', 0, '', ''), 
(676, '65099', 'UNICARE Special Accounts', 0, '', ''), 
(677, '13142', 'Union Labour Life Insurance Company', 0, '', ''), 
(678, 'CKOK1', 'UNISYS Medicaid of Oklahoma', 1, '', ''), 
(679, '89070', 'United Concordia', 0, '', ''), 
(680, 'CBPA2', 'United Concordia  Pennsylvanis', 0, '', ''), 
(681, 'CX002', 'United Concordia (Tricare Dental Plan)', 0, '', ''), 
(682, '0000D', 'United Concordia (Tricare FMDP)', 0, '', ''), 
(683, 'CX013', 'United Concordia-UCC- ConcordiaPLUS DHMO', 0, '', ''), 
(684, '99998', 'United Concordia-UCCI - ConcordiaPLUS DHMO', 0, '', ''), 
(685, '99997', 'United Concordia-UCCI - DentalPLUS DHMO', 0, '', ''), 
(686, '99995', 'United Concordia-UCCI ( CHAMPUS ) - Fee for Service', 0, '', ''), 
(687, 'CX007', 'United Concordia-UCCI ( CHAMPUS ) - Fee for Service', 0, '', ''), 
(688, 'CX002', 'United Concordia-UCCI (TRICARE, FMDP)', 0, '', ''), 
(689, '99994', 'United Concordia-UCCI (TRICARE, FMDP)', 0, '', ''), 
(690, '70408', 'United Dental  Texas', 0, '', ''), 
(691, 'UFCW1', 'United Food & Commercial Workers (UFCW-Midwest', 0, '', ''), 
(692, 'UFC01', 'United Food & Commercial Workers Union of Central Ohio (UFCW of Central Ohio)', 0, '', ''), 
(693, 'UFC02', 'United Food & Commercial Workers Union of Cleveland (UFCW of Cleveland)', 0, '', ''), 
(694, '52133', 'United Healthcare (Dental Benefit Providers)', 0, '', ''), 
(695, '33108', 'United Medical Resources', 0, '', ''), 
(696, '71412', 'United of Omaha', 0, '', ''), 
(697, '13545', 'United States Life Insurance Company of NJ', 0, '', ''), 
(698, '00003', 'Univera Benefit Systems', 0, '', ''), 
(699, '16105', 'Univera of New York', 0, '', ''), 
(700, '91136', 'University of Washington Students & Graduate Appts.', 0, '', ''), 
(701, '', 'Upper Peninsula Health Plan', 0, '', ''), 
(702, '00003', 'Utica Blue Cross / Blue Shield', 0, '', ''), 
(703, '12116', 'VA Fee Basis Programs', 0, '', ''), 
(704, 'VHP01', 'Valley Health Plan', 0, '', ''), 
(705, '68241', 'Varian Health Care Plan', 0, '', ''), 
(706, '91062', 'Washington Dental Service', 0, '', ''), 
(707, '37294', 'Washington Employers Trust', 0, '', ''), 
(708, '91136', 'Washington State County & City Employees Dental Trust', 0, '', ''), 
(709, '39026', 'Wausau Benefits-aka Employers Ins. of Wausau', 0, '', ''), 
(710, '39151', 'WEA Insurance Group', 0, '', ''), 
(711, '75261', 'WebTPA/Community Health Electronic Claims', 0, '', ''), 
(712, '47198', 'Wellpoint Dental-AKA- Blue Cross of CA', 0, '', ''), 
(713, '91136', 'West Coast Stationary Engineers Health Trust Fund', 0, '', ''), 
(714, '24735', 'Western Grower\'s Assurance Trust & Insurance', 0, '', ''), 
(715, '91060', 'Western Teamster Welfare Trust', 0, '', ''), 
(716, '84098', 'Whatcom Medical Bureau', 0, '', ''), 
(717, 'CX104', 'Xantus Health Plan - Tennesse', 0, '', ''), 
(718, '62154', 'Xantus Health Plan - Tennesse', 0, '', '');
#----------------------------
# Table structure for emailmessage
#----------------------------
CREATE TABLE `emailmessage` (
  `EmailMessageNum` mediumint(8) unsigned NOT NULL auto_increment,
  `PatNum` mediumint(9) NOT NULL default '0',
  `ToAddress` text NOT NULL,
  `FromAddress` text NOT NULL,
  `Subject` text NOT NULL,
  `BodyText` text NOT NULL,
  `MsgDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`EmailMessageNum`),
  KEY `PatNum` (`PatNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table emailmessage
#----------------------------

#----------------------------
# Table structure for emailtemplate
#----------------------------
CREATE TABLE `emailtemplate` (
  `EmailTemplateNum` mediumint(8) unsigned NOT NULL auto_increment,
  `Subject` text NOT NULL,
  `BodyText` text NOT NULL,
  PRIMARY KEY  (`EmailTemplateNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table emailtemplate
#----------------------------

#----------------------------
# Table structure for employee
#----------------------------
CREATE TABLE `employee` (
  `EmployeeNum` smallint(5) unsigned NOT NULL auto_increment,
  `LName` varchar(255) NOT NULL default '',
  `FName` varchar(255) NOT NULL default '',
  `MiddleI` varchar(255) NOT NULL default '',
  `Password` varchar(255) NOT NULL default '',
  `IsHidden` tinyint(1) unsigned NOT NULL default '0',
  `UserName` varchar(255) NOT NULL default '',
  `ClockStatus` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`EmployeeNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table employee
#----------------------------


#----------------------------
# Table structure for employer
#----------------------------
CREATE TABLE `employer` (
  `EmployerNum` mediumint(8) unsigned NOT NULL auto_increment,
  `EmpName` varchar(255) NOT NULL default '',
  `Address` varchar(255) NOT NULL default '',
  `Address2` varchar(255) NOT NULL default '',
  `City` varchar(255) NOT NULL default '',
  `State` varchar(255) NOT NULL default '',
  `Zip` varchar(255) NOT NULL default '',
  `Phone` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`EmployerNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table employer
#----------------------------

#----------------------------
# Table structure for fee
#----------------------------
CREATE TABLE `fee` (
  `FeeNum` mediumint(8) unsigned NOT NULL auto_increment,
  `Amount` double NOT NULL default '0',
  `ADACode` varchar(15) NOT NULL default '',
  `FeeSched` smallint(5) unsigned NOT NULL default '0',
  `UseDefaultFee` tinyint(1) unsigned NOT NULL default '0',
  `UseDefaultCov` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`FeeNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# No records for table fee
#----------------------------

#----------------------------
# Table structure for graphicassembly
#----------------------------
CREATE TABLE `graphicassembly` (
  `GAssemblyNum` smallint(5) unsigned NOT NULL auto_increment,
  `GTypeNum` smallint(5) unsigned NOT NULL default '0',
  `GElementNum` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`GAssemblyNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table graphicassembly
#----------------------------


insert  into graphicassembly values 
(1, 8, 1), 
(2, 8, 2), 
(3, 8, 3), 
(4, 8, 4), 
(5, 8, 5), 
(6, 8, 6), 
(7, 8, 7), 
(8, 8, 8), 
(9, 8, 9), 
(10, 8, 10), 
(11, 8, 11), 
(12, 8, 12), 
(13, 8, 13), 
(14, 8, 14), 
(15, 8, 15), 
(16, 8, 16), 
(17, 8, 17), 
(18, 8, 18), 
(19, 8, 19), 
(20, 8, 20), 
(21, 8, 21), 
(22, 8, 22), 
(23, 8, 23), 
(24, 8, 24), 
(25, 8, 25), 
(26, 8, 26), 
(27, 8, 27), 
(28, 8, 28), 
(29, 8, 29), 
(30, 8, 30), 
(31, 8, 31), 
(32, 8, 32), 
(33, 1, 33), 
(34, 2, 34), 
(35, 2, 35), 
(36, 2, 36), 
(37, 2, 37), 
(38, 2, 38), 
(39, 2, 39), 
(40, 2, 40), 
(41, 2, 41), 
(42, 2, 42), 
(43, 2, 43), 
(44, 2, 44), 
(45, 2, 45), 
(46, 2, 46), 
(47, 2, 47), 
(48, 2, 48), 
(49, 2, 49), 
(50, 2, 50), 
(51, 2, 51), 
(52, 2, 52), 
(53, 2, 53), 
(54, 2, 54), 
(55, 2, 55), 
(56, 2, 56), 
(57, 2, 57), 
(58, 2, 58), 
(59, 2, 59), 
(60, 2, 60), 
(61, 2, 61), 
(62, 2, 62), 
(63, 2, 63), 
(260, 4, 226), 
(261, 4, 227), 
(262, 4, 228), 
(263, 4, 229), 
(264, 4, 230), 
(265, 4, 231), 
(266, 4, 232), 
(267, 4, 233), 
(268, 4, 234), 
(269, 4, 235), 
(270, 4, 236), 
(271, 4, 237), 
(272, 4, 238), 
(273, 22, 239), 
(275, 5, 241), 
(276, 5, 242), 
(277, 5, 243), 
(278, 5, 244), 
(279, 5, 245), 
(280, 5, 246), 
(281, 5, 247), 
(282, 5, 248), 
(283, 5, 249), 
(284, 5, 250), 
(285, 5, 251), 
(286, 5, 252), 
(257, 4, 223), 
(258, 4, 224), 
(259, 4, 225), 
(256, 10, 222), 
(287, 5, 253), 
(288, 5, 254), 
(289, 5, 255), 
(290, 5, 256), 
(291, 1, 257), 
(292, 10, 258), 
(325, 23, 264), 
(324, 23, 263), 
(102, 2, 102), 
(103, 2, 103), 
(104, 2, 104), 
(105, 2, 105), 
(106, 2, 106), 
(107, 2, 107), 
(108, 2, 108), 
(109, 2, 109), 
(110, 2, 110), 
(111, 2, 111), 
(112, 2, 112), 
(113, 2, 113), 
(114, 2, 114), 
(115, 2, 115), 
(118, 6, 29), 
(119, 6, 5), 
(120, 6, 3), 
(121, 6, 1), 
(122, 6, 7), 
(123, 6, 9), 
(124, 6, 11), 
(125, 6, 25), 
(126, 6, 27), 
(127, 6, 23), 
(128, 6, 22), 
(129, 6, 19), 
(130, 6, 18), 
(131, 6, 13), 
(132, 6, 16), 
(133, 6, 31), 
(134, 12, 29), 
(135, 12, 5), 
(136, 12, 3), 
(137, 12, 1), 
(138, 12, 7), 
(139, 12, 9), 
(140, 12, 11), 
(141, 12, 25), 
(142, 12, 27), 
(143, 12, 23), 
(144, 12, 22), 
(145, 12, 19), 
(146, 12, 18), 
(147, 12, 13), 
(148, 12, 16), 
(149, 12, 31), 
(150, 8, 116), 
(151, 2, 117), 
(152, 2, 118), 
(153, 2, 119), 
(154, 2, 120), 
(155, 2, 121), 
(156, 2, 122), 
(157, 2, 123), 
(158, 2, 124), 
(159, 2, 125), 
(160, 2, 126), 
(161, 2, 127), 
(162, 2, 128), 
(163, 2, 129), 
(164, 2, 130), 
(165, 2, 131), 
(166, 2, 132), 
(167, 2, 133), 
(168, 2, 134), 
(169, 2, 135), 
(170, 2, 136), 
(171, 2, 137), 
(172, 2, 138), 
(173, 2, 139), 
(174, 2, 140), 
(175, 2, 141), 
(176, 2, 142), 
(177, 2, 143), 
(178, 2, 144), 
(179, 2, 145), 
(180, 2, 146), 
(181, 2, 147), 
(182, 2, 148), 
(183, 2, 149), 
(184, 2, 150), 
(185, 2, 151), 
(186, 2, 152), 
(187, 8, 153), 
(188, 8, 154), 
(189, 8, 155), 
(190, 8, 156), 
(191, 8, 157), 
(192, 8, 158), 
(193, 8, 159), 
(194, 8, 160), 
(195, 8, 161), 
(196, 8, 162), 
(197, 8, 163), 
(198, 8, 164), 
(199, 8, 165), 
(200, 8, 166), 
(201, 8, 167), 
(202, 8, 168), 
(203, 8, 169), 
(204, 8, 170), 
(205, 8, 171), 
(206, 2, 172), 
(207, 2, 173), 
(208, 2, 174), 
(209, 2, 175), 
(210, 2, 176), 
(211, 2, 177), 
(212, 2, 178), 
(213, 2, 179), 
(214, 2, 180), 
(215, 2, 181), 
(216, 2, 182), 
(217, 2, 183), 
(218, 2, 184), 
(219, 2, 185), 
(220, 2, 186), 
(221, 2, 187), 
(222, 2, 188), 
(223, 2, 189), 
(224, 2, 190), 
(225, 2, 191), 
(226, 2, 192), 
(227, 2, 193), 
(228, 2, 194), 
(229, 2, 195), 
(230, 2, 196), 
(231, 2, 197), 
(232, 2, 198), 
(233, 2, 199), 
(234, 2, 200), 
(235, 2, 201), 
(236, 2, 202), 
(237, 2, 203), 
(238, 2, 204), 
(239, 2, 205), 
(240, 2, 206), 
(241, 2, 207), 
(242, 2, 208), 
(243, 2, 209), 
(244, 2, 210), 
(245, 2, 211), 
(246, 2, 212), 
(247, 2, 213), 
(248, 2, 214), 
(249, 2, 215), 
(250, 2, 216), 
(251, 2, 217), 
(252, 2, 218), 
(253, 2, 219), 
(254, 2, 220), 
(255, 2, 221), 
(323, 23, 262), 
(322, 23, 261), 
(321, 11, 260), 
(320, 11, 259), 
(319, 6, 162), 
(318, 6, 164), 
(317, 6, 166), 
(316, 6, 168), 
(315, 6, 170), 
(314, 6, 156), 
(313, 6, 154), 
(312, 6, 116), 
(311, 6, 158), 
(310, 6, 160), 
(326, 23, 265), 
(327, 23, 266), 
(328, 23, 267), 
(329, 23, 268), 
(330, 24, 29), 
(331, 24, 5), 
(332, 24, 3), 
(333, 24, 1), 
(334, 24, 7), 
(335, 24, 9), 
(336, 24, 11), 
(337, 24, 25), 
(338, 24, 27), 
(339, 24, 23), 
(340, 24, 22), 
(341, 24, 19), 
(342, 24, 18), 
(343, 24, 13), 
(344, 24, 16), 
(345, 24, 31);
#----------------------------
# Table structure for graphicelement
#----------------------------
CREATE TABLE `graphicelement` (
  `GElementNum` smallint(5) unsigned NOT NULL auto_increment,
  `ToothNum` varchar(2) NOT NULL default '',
  `Description` varchar(100) NOT NULL default '',
  `Surface` varchar(5) NOT NULL default '',
  `ZOrder` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`GElementNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#----------------------------
# Records for table graphicelement
#----------------------------


insert  into graphicelement values 
(1, '4', 'Crown', '', 2), 
(2, '4', 'Root', '', 1), 
(3, '3', 'Crown', '', 2), 
(4, '3', 'Root', '', 1), 
(5, '2', 'Crown', '', 2), 
(6, '2', 'Root', '', 1), 
(7, '5', 'Crown', '', 2), 
(8, '5', 'Root', '', 1), 
(9, '6', 'Crown', '', 2), 
(10, '6', 'Root', '', 1), 
(11, '7', 'Crown', '', 2), 
(12, '7', 'Root', '', 1), 
(13, '30', 'Crown', '', 2), 
(14, '30', 'Root', '', 1), 
(15, '31', 'Root', '', 1), 
(16, '31', 'Crown', '', 2), 
(17, '29', 'Root', '', 0), 
(18, '