# phpMyAdmin MySQL-Dump # version 2.3.0-rc4 # http://phpwizard.net/phpMyAdmin/ # http://www.phpmyadmin.net/ (download page) # # Host: localhost # Generation Time: Sep 13, 2003 at 10:03 AM # Server version: 4.00.12 # PHP Version: 4.2.2 # Database : `freedental` # -------------------------------------------------------- # # Table structure for table `adjustment` # DROP TABLE IF EXISTS adjustment; CREATE TABLE adjustment ( AdjNum mediumint(8) unsigned NOT NULL auto_increment, AdjDate date NOT NULL default '0000-00-00', AdjAmt double NOT NULL default '0', PatNum mediumint(8) unsigned NOT NULL default '0', AdjType tinyint(3) unsigned NOT NULL default '0', ProvNum mediumint(8) unsigned NOT NULL default '0', AdjNote varchar(255) NOT NULL default '', PRIMARY KEY (AdjNum) ) TYPE=MyISAM; # # Dumping data for table `adjustment` # # -------------------------------------------------------- # # Table structure for table `appointment` # DROP TABLE IF EXISTS 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(32) NOT NULL default '/X/', Confirmed tinyint(3) unsigned NOT NULL default '0', AddTime tinyint(3) NOT NULL default '0', Op smallint(5) unsigned NOT NULL default '0', Note varchar(255) NOT NULL default '', ProvNum smallint(5) unsigned NOT NULL default '0', ProvHyg smallint(5) unsigned NOT NULL default '0', AptDateTime datetime NOT NULL default '0000-00-00 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', PRIMARY KEY (AptNum) ) TYPE=MyISAM; # # Dumping data for table `appointment` # # -------------------------------------------------------- # # Table structure for table `claim` # DROP TABLE IF EXISTS 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 '0000-00-00', DateSent date NOT NULL default '0000-00-00', ClaimStatus char(1) NOT NULL default '', DateReceived date NOT NULL default '0000-00-00', 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', ClaimPaymentNum mediumint(8) unsigned NOT NULL default '0', DedApplied double NOT NULL default '0', OverMax double NOT NULL default '0', PreAuthString varchar(40) NOT NULL default '', IsProsthesis char(1) NOT NULL default '', PriorDate date NOT NULL default '0000-00-00', ReasonUnderPaid varchar(255) NOT NULL default '', ClaimNote varchar(255) NOT NULL default '', PriClaimNum mediumint(8) unsigned NOT NULL default '0', SecClaimNum mediumint(8) unsigned NOT NULL default '0', IsPreAuth tinyint(1) unsigned NOT NULL default '0', 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 '0000-00-00', AccidentST char(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 '0000-00-00', PRIMARY KEY (ClaimNum) ) TYPE=MyISAM; # # Dumping data for table `claim` # # -------------------------------------------------------- # # Table structure for table `claimpayment` # DROP TABLE IF EXISTS claimpayment; CREATE TABLE claimpayment ( ClaimPaymentNum mediumint(8) unsigned NOT NULL auto_increment, CheckDate date NOT NULL default '0000-00-00', CheckAmt double NOT NULL default '0', CheckNum varchar(25) NOT NULL default '', BankBranch varchar(25) NOT NULL default '', Note varchar(255) NOT NULL default '', PRIMARY KEY (ClaimPaymentNum) ) TYPE=MyISAM; # # Dumping data for table `claimpayment` # # -------------------------------------------------------- # # Table structure for table `computer` # DROP TABLE IF EXISTS 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) ) TYPE=MyISAM; # # Dumping data for table `computer` # # -------------------------------------------------------- # # Table structure for table `covcat` # DROP TABLE IF EXISTS 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) ) TYPE=MyISAM; # # Dumping data for table `covcat` # INSERT INTO covcat VALUES (1, 'Diag/Prev', 100, 1, 0, 0); INSERT INTO covcat VALUES (2, 'Basic', 80, 0, 1, 0); INSERT INTO covcat VALUES (3, 'Major', 50, 0, 2, 0); INSERT INTO covcat VALUES (4, 'Ortho', -1, 0, 5, 0); INSERT INTO covcat VALUES (6, 'Endo', 80, 0, 3, 0); INSERT INTO covcat VALUES (7, 'none', 0, 0, 6, 1); INSERT INTO covcat VALUES (8, 'Perio', 80, 0, 4, 0); # -------------------------------------------------------- # # Table structure for table `covpat` # DROP TABLE IF EXISTS 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) ) TYPE=MyISAM; # # Dumping data for table `covpat` # # -------------------------------------------------------- # # Table structure for table `covspan` # DROP TABLE IF EXISTS covspan; CREATE TABLE covspan ( CovSpanNum mediumint(8) unsigned NOT NULL auto_increment, CovCatNum mediumint(8) unsigned NOT NULL default '0', FromCode varchar(6) NOT NULL default '', ToCode varchar(6) NOT NULL default '', PRIMARY KEY (CovSpanNum) ) TYPE=MyISAM; # # Dumping data for table `covspan` # INSERT INTO covspan VALUES (1, 1, 'D0000', 'D1999'); INSERT INTO covspan VALUES (2, 2, 'D2000', 'D2699'); INSERT INTO covspan VALUES (3, 3, 'D2700', 'D2999'); INSERT INTO covspan VALUES (4, 2, 'D3000', 'D3999'); INSERT INTO covspan VALUES (5, 2, 'D4000', 'D4999'); INSERT INTO covspan VALUES (6, 3, 'D5000', 'D5899'); INSERT INTO covspan VALUES (7, 7, 'D5900', 'D6199'); INSERT INTO covspan VALUES (8, 3, 'D6200', 'D6999'); INSERT INTO covspan VALUES (9, 2, 'D7000', 'D7999'); INSERT INTO covspan VALUES (10, 4, 'D8000', 'D8998'); INSERT INTO covspan VALUES (12, 7, 'D9000', 'D9999'); INSERT INTO covspan VALUES (13, 7, 'D8999', 'D8999'); # -------------------------------------------------------- # # Table structure for table `definition` # DROP TABLE IF EXISTS 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) ) TYPE=MyISAM; # # Dumping data for table `definition` # INSERT INTO definition VALUES (1, 1, 2, 'Misc Neg Adjustment', '-', 0, 0); INSERT INTO definition VALUES (2, 1, 3, 'Misc Pos Adjustment', '+', 0, 0); INSERT INTO definition VALUES (4, 0, 1, 'Adjustment', '', -16777031, 0); INSERT INTO definition VALUES (5, 0, 3, 'Payment', '', -16744448, 0); INSERT INTO definition VALUES (6, 0, 4, 'Insurance', '', -2555904, 0); INSERT INTO definition VALUES (7, 0, 0, 'Default', '', -16777216, 0); INSERT INTO definition VALUES (8, 1, 0, 'Professional Discount', '-', 0, 0); INSERT INTO definition VALUES (9, 1, 1, 'Cash Discount', '-', 0, 0); INSERT INTO definition VALUES (10, 1, 5, 'Write Off', '-', 0, 0); INSERT INTO definition VALUES (112, 0, 2, 'Discount', '', -16744448, 0); INSERT INTO definition VALUES (12, 1, 6, 'Insurance Writeoff', '-', 0, 0); INSERT INTO definition VALUES (13, 1, 7, '$10 Referral Discount', '-', 0, 0); INSERT INTO definition VALUES (14, 1, 8, 'BROKEN Appt - No Show', '+', 0, 0); INSERT INTO definition VALUES (15, 1, 9, 'BROKEN Appt w/o 24 hrs Notice', '+', 0, 0); INSERT INTO definition VALUES (16, 1, 10, 'Returned Check', '+', 0, 0); INSERT INTO definition VALUES (17, 1, 11, 'NSF fee', '+', 0, 0); INSERT INTO definition VALUES (18, 1, 4, 'Patient Refund Check', '+', 0, 0); INSERT INTO definition VALUES (19, 2, 0, 'Unconfirmed', 'Unconfrm', -1, 0); INSERT INTO definition VALUES (20, 2, 1, 'Left Msg on Ans Mach', 'LeftMsg', -256, 0); INSERT INTO definition VALUES (21, 2, 2, 'Appointment Confirmed', 'Confirmed', -6099851, 0); INSERT INTO definition VALUES (22, 2, 3, 'Left Msg w Fam Mem', 'MsgFam', -256, 0); INSERT INTO definition VALUES (23, 2, 4, 'Not Home', 'NotHome', -65536, 0); INSERT INTO definition VALUES (24, 2, 5, 'Disconnected Number', 'DiscNum', -65536, 0); INSERT INTO definition VALUES (25, 2, 6, 'Line Busy', 'LinBusy', -65536, 0); INSERT INTO definition VALUES (26, 3, 0, 'Comp Exam', 'D0150', 0, 0); INSERT INTO definition VALUES (27, 3, 1, 'Per Exam', 'D0120', 0, 0); INSERT INTO definition VALUES (28, 3, 2, 'Lim Exam', 'D0140', 0, 0); INSERT INTO definition VALUES (29, 3, 3, '1 PA', 'D0220', 0, 0); INSERT INTO definition VALUES (30, 3, 4, '2BW', 'D0272', 0, 0); INSERT INTO definition VALUES (31, 3, 5, '4BW', 'D0274', 0, 0); INSERT INTO definition VALUES (32, 3, 7, 'Pro Adult', 'D1110', 0, 0); INSERT INTO definition VALUES (33, 3, 8, 'Fluor Adult', 'D1204', 0, 0); INSERT INTO definition VALUES (34, 3, 9, 'Pro Child', 'D1120', 0, 0); INSERT INTO definition VALUES (35, 3, 10, 'Fluor Child', 'D1203', 0, 0); INSERT INTO definition VALUES (36, 3, 13, 'empty', 'D0120', 0, 1); INSERT INTO definition VALUES (37, 3, 6, 'Pano', 'D0330', 0, 0); INSERT INTO definition VALUES (38, 3, 11, 'PostOp', 'N4101', 0, 0); INSERT INTO definition VALUES (39, 3, 12, 'DentAdj', 'N4102', 0, 0); INSERT INTO definition VALUES (40, 4, 0, 'Standard Account', '', 0, 0); INSERT INTO definition VALUES (41, 4, 1, 'Bad Debt - Precollections', '', 0, 0); INSERT INTO definition VALUES (42, 4, 2, 'Bad Debt - Sent to Collections', '', 0, 0); INSERT INTO definition VALUES (43, 5, 0, 'paper', 'ADA2002', 0, 0); INSERT INTO definition VALUES (44, 5, 1, 'eClaim', 'eclaim', 0, 0); INSERT INTO definition VALUES (45, 6, 0, 'Standard 0-30', '', 0, 0); INSERT INTO definition VALUES (46, 6, 1, 'Standard 31-60', 'Charges over 30 days.', 0, 0); INSERT INTO definition VALUES (47, 6, 2, 'Standard 61-90', 'Charges over 60 days.', 0, 0); INSERT INTO definition VALUES (48, 6, 3, 'Standard Over 90', 'Charges over 90 days. Finance charges apply.', 0, 0); INSERT INTO definition VALUES (49, 6, 4, 'Insurance 0-30', '', 0, 0); INSERT INTO definition VALUES (50, 6, 5, 'Insurance 31-60', 'Charges over 30 days.', 0, 0); INSERT INTO definition VALUES (51, 6, 6, 'Insurance 61-90', 'Charges over 60 days.', 0, 0); INSERT INTO definition VALUES (52, 6, 7, 'Insurance Over 90', 'Charges over 90 days. You are responsible for unpaid insurance. Finance charges apply.', 0, 0); INSERT INTO definition VALUES (53, 7, 0, 'Standard', '', 0, 0); INSERT INTO definition VALUES (54, 7, 2, 'BCBS', '', 0, 0); INSERT INTO definition VALUES (55, 7, 1, 'ODS', '', 0, 0); INSERT INTO definition VALUES (56, 8, 1, 'BP', '', 0, 0); INSERT INTO definition VALUES (57, 8, 6, 'Allergy:', '', 0, 0); INSERT INTO definition VALUES (58, 8, 2, 'Heart', '', 0, 0); INSERT INTO definition VALUES (59, 8, 3, 'Low Epi', '', 0, 0); INSERT INTO definition VALUES (60, 8, 4, 'PAC', '', 0, 0); INSERT INTO definition VALUES (61, 8, 7, 'Medication:', '', 0, 0); INSERT INTO definition VALUES (62, 8, 0, 'none', '', 0, 0); INSERT INTO definition VALUES (63, 8, 5, 'Diabetes', '', 0, 0); INSERT INTO definition VALUES (64, 9, 0, 'Operatory 1', 'OP-1', 0, 0); INSERT INTO definition VALUES (65, 9, 1, 'Operatory 2', 'OP-2', 0, 0); INSERT INTO definition VALUES (66, 9, 2, 'Operatory 3', 'OP-3', 0, 0); INSERT INTO definition VALUES (67, 9, 3, 'Operatory 4', 'OP-4', 0, 0); INSERT INTO definition VALUES (68, 9, 4, 'Hygiene Op 1', 'Hyg1', 0, 0); INSERT INTO definition VALUES (69, 10, 0, 'Check', '', 0, 0); INSERT INTO definition VALUES (70, 10, 1, 'Cash', '', 0, 0); INSERT INTO definition VALUES (71, 10, 2, 'Credit Card', '', 0, 0); INSERT INTO definition VALUES (113, 12, 2, 'Status Existing Current Prov', '', -16777206, 0); INSERT INTO definition VALUES (72, 10, 3, 'Not used', '', 0, 1); INSERT INTO definition VALUES (73, 11, 0, 'Exams & Xrays', '', 0, 0); INSERT INTO definition VALUES (74, 11, 1, 'Cleanings', '', 0, 0); INSERT INTO definition VALUES (75, 11, 2, 'Fillings', '', 0, 0); INSERT INTO definition VALUES (76, 11, 3, 'Endo', '', 0, 0); INSERT INTO definition VALUES (77, 11, 4, 'Perio', '', 0, 0); INSERT INTO definition VALUES (78, 11, 5, 'Dentures', '', 0, 0); INSERT INTO definition VALUES (79, 11, 6, 'Cosmetic', '', 0, 0); INSERT INTO definition VALUES (80, 11, 7, 'Implants', '', 0, 0); INSERT INTO definition VALUES (81, 11, 8, 'Crown & Bridge', '', 0, 0); INSERT INTO definition VALUES (82, 11, 9, 'Oral Surgery', '', 0, 0); INSERT INTO definition VALUES (83, 11, 10, 'Ortho', '', 0, 0); INSERT INTO definition VALUES (84, 11, 11, 'Misc', '', 0, 0); INSERT INTO definition VALUES (85, 11, 12, 'No Fee', '', 0, 0); INSERT INTO definition VALUES (86, 11, 13, 'Rarely Used', '', 0, 0); INSERT INTO definition VALUES (87, 11, 14, 'Never Used', '', 0, 0); INSERT INTO definition VALUES (88, 12, 1, 'Status Complete', '', -16185069, 0); INSERT INTO definition VALUES (89, 12, 5, 'Rx', '', -65536, 0); INSERT INTO definition VALUES (90, 12, 0, 'Status Treatment Planned', '', -8978432, 0); INSERT INTO definition VALUES (91, 12, 3, 'Status Existing Other Prov', '', -16751616, 0); INSERT INTO definition VALUES (92, 13, 0, 'Appointment Scheduled', 'AptSchd', 0, 0); INSERT INTO definition VALUES (93, 13, 8, 'Not Home, Call Again', 'NotHome', 0, 0); INSERT INTO definition VALUES (94, 13, 1, 'Call Back, Not Ready', 'CallBak', 0, 0); INSERT INTO definition VALUES (95, 13, 2, 'Patient Will Call Us', 'CallUs', 0, 0); INSERT INTO definition VALUES (96, 13, 3, 'Bad Debt. Don\'t Call', 'BadDebt', 0, 0); INSERT INTO definition VALUES (97, 13, 5, 'Left Msg on Ans. Mach', 'LeftMsg', 0, 0); INSERT INTO definition VALUES (98, 13, 6, 'Left Message with Fam', 'MsgFam', 0, 0); INSERT INTO definition VALUES (99, 13, 7, 'Discon Ph Num', 'DiscNum', 0, 0); INSERT INTO definition VALUES (100, 13, 4, 'Wait. See notes.', 'Wait', 0, 0); INSERT INTO definition VALUES (101, 14, 3, 'Pillow', '', 0, 0); INSERT INTO definition VALUES (102, 14, 4, 'No Fluoride', '', 0, 0); INSERT INTO definition VALUES (103, 14, 7, 'Hard to Numb', '', 0, 1); INSERT INTO definition VALUES (104, 14, 0, 'Value', '', 0, 0); INSERT INTO definition VALUES (105, 14, 2, 'Quality', '', 0, 0); INSERT INTO definition VALUES (106, 14, 5, 'Don\'t Lean Back', '', 0, 0); INSERT INTO definition VALUES (107, 14, 1, 'Painless', '', 0, 0); INSERT INTO definition VALUES (108, 15, 1, '10% Senior Discount', '10', 0, 0); INSERT INTO definition VALUES (109, 15, 0, '5% Cash Discount', '5', 0, 0); INSERT INTO definition VALUES (110, 15, 2, 'New Patient Discount', '20', 0, 0); INSERT INTO definition VALUES (111, 15, 3, 'Discount', '', 0, 0); INSERT INTO definition VALUES (114, 11, 15, 'Obsolete', '', 0, 0); INSERT INTO definition VALUES (115, 16, 1, 'Caries', 'C', 0, 0); INSERT INTO definition VALUES (116, 16, 2, 'Recurrent (Car)', 'R', 0, 0); INSERT INTO definition VALUES (117, 16, 3, 'Incipient (Car)', 'I', 0, 0); INSERT INTO definition VALUES (118, 16, 4, 'Defect (or miss fill)', 'D', 0, 0); INSERT INTO definition VALUES (119, 16, 5, 'Missing (tooth struct)', 'M', 0, 0); INSERT INTO definition VALUES (120, 16, 6, 'Irrevers. Pulp.', 'IP', 0, 0); INSERT INTO definition VALUES (121, 16, 7, 'Revers. Pulp.', 'RP', 0, 0); INSERT INTO definition VALUES (122, 16, 8, 'Necrotic', 'Nc', 0, 0); INSERT INTO definition VALUES (123, 16, 9, 'Apical Perio', 'AP', 0, 0); INSERT INTO definition VALUES (124, 16, 10, 'Abcess', 'Ab', 0, 0); INSERT INTO definition VALUES (125, 16, 11, 'Carious Pulp Exp', 'CE', 0, 0); INSERT INTO definition VALUES (126, 16, 12, 'Cracked Tooth', 'Cr', 0, 0); INSERT INTO definition VALUES (127, 17, 0, 'Practice Open', '', -1, 0); INSERT INTO definition VALUES (128, 17, 1, 'Practice Closed', '', -2368549, 0); INSERT INTO definition VALUES (129, 9, 5, 'Hygiene Op 2', 'Hyg2', 0, 0); INSERT INTO definition VALUES (130, 18, 3, 'Medical History', '', 0, 0); INSERT INTO definition VALUES (131, 18, 2, 'Insurance', '', 0, 0); INSERT INTO definition VALUES (132, 18, 6, 'Treatment Plans', '', 0, 0); INSERT INTO definition VALUES (133, 18, 8, 'Patient Treatment', '', 0, 0); INSERT INTO definition VALUES (134, 18, 1, 'Financial', '', 0, 0); INSERT INTO definition VALUES (135, 18, 7, 'Letters', '', 0, 0); INSERT INTO definition VALUES (136, 18, 0, 'Credit Approval', '', 0, 0); INSERT INTO definition VALUES (137, 18, 4, 'Miscellaneous', '', 0, 0); INSERT INTO definition VALUES (138, 18, 5, 'Patient Information', '', 0, 0); INSERT INTO definition VALUES (139, 16, 0, 'None', '', 0, 0); INSERT INTO definition VALUES (140, 17, 2, 'Appointment Complete-Time bar', '', -8355712, 0); INSERT INTO definition VALUES (141, 17, 3, 'Appointment Complete-Background', '', -2039837, 0); INSERT INTO definition VALUES (142, 13, 9, 'Mailed Postcard', 'Mailed', 0, 0); INSERT INTO definition VALUES (143, 19, 0, 'Called. Left message.', '', 0, 0); INSERT INTO definition VALUES (144, 19, 1, 'Called. No answer.', '', 0, 0); INSERT INTO definition VALUES (145, 19, 2, 'Called. Bad number. Made note in chart', '', 0, 0); INSERT INTO definition VALUES (146, 20, 0, '1', '', -16777216, 0); INSERT INTO definition VALUES (147, 20, 1, '2', '', -16777216, 0); INSERT INTO definition VALUES (148, 20, 11, 'Wait', '', -7237231, 0); INSERT INTO definition VALUES (149, 20, 9, 'Low', '', -16777216, 0); INSERT INTO definition VALUES (150, 20, 8, 'Next', '', -6356992, 0); INSERT INTO definition VALUES (151, 20, 4, '5', '', -16777216, 0); INSERT INTO definition VALUES (152, 20, 13, '10', '', -16777216, 1); INSERT INTO definition VALUES (153, 20, 2, '3', '', -16777216, 0); INSERT INTO definition VALUES (154, 20, 3, '4', '', -16777216, 0); INSERT INTO definition VALUES (155, 20, 12, '9', '', -16777216, 1); INSERT INTO definition VALUES (156, 20, 5, '6', '', -16777216, 0); INSERT INTO definition VALUES (157, 20, 6, '7', '', -16777216, 0); INSERT INTO definition VALUES (158, 20, 7, '8', '', -16777216, 0); INSERT INTO definition VALUES (159, 20, 10, 'Recmend', '', -7237231, 0); INSERT INTO definition VALUES (160, 12, 4, 'Status Referred', '', -8978432, 0); INSERT INTO definition VALUES (161, 14, 6, 'Anxiety', '', 0, 0); # -------------------------------------------------------- # # Table structure for table `docattach` # DROP TABLE IF EXISTS 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) ) TYPE=MyISAM; # # Dumping data for table `docattach` # # -------------------------------------------------------- # # Table structure for table `document` # DROP TABLE IF EXISTS 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 '', PRIMARY KEY (DocNum) ) TYPE=MyISAM; # # Dumping data for table `document` # # -------------------------------------------------------- # # Table structure for table `fee` # DROP TABLE IF EXISTS fee; CREATE TABLE fee ( FeeNum mediumint(8) unsigned NOT NULL auto_increment, Amount double NOT NULL default '0', ADACode varchar(6) 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) ) TYPE=MyISAM; # # Dumping data for table `fee` # # -------------------------------------------------------- # # Table structure for table `insplan` # DROP TABLE IF EXISTS insplan; CREATE TABLE insplan ( PlanNum mediumint(8) unsigned NOT NULL auto_increment, Subscriber mediumint(8) unsigned NOT NULL default '0', Carrier varchar(50) NOT NULL default '', DateEffective date NOT NULL default '0000-00-00', DateTerm date NOT NULL default '0000-00-00', Phone varchar(30) NOT NULL default '', GroupName varchar(50) NOT NULL default '', GroupNum varchar(20) NOT NULL default '', Address varchar(60) NOT NULL default '', Address2 varchar(60) NOT NULL default '', City varchar(40) NOT NULL default '', State char(2) NOT NULL default '', Zip varchar(10) NOT NULL default '', ClaimFormat tinyint(3) unsigned NOT NULL default '0', ElectID varchar(5) NOT NULL default '', Employer varchar(40) NOT NULL default '', AnnualMax smallint(6) NOT NULL default '0', RenewMonth tinyint(4) NOT NULL default '0', Deductible smallint(6) NOT NULL default '0', DeductWaivPrev tinyint(3) unsigned NOT NULL default '0', OrthoMax smallint(6) NOT NULL default '0', FloToAge tinyint(4) NOT NULL default '0', PlanNote text NOT NULL, MissToothExcl tinyint(3) unsigned NOT NULL default '0', MajorWait tinyint(3) unsigned NOT NULL default '0', FeeSched smallint(5) unsigned NOT NULL default '0', ReleaseInfo tinyint(1) unsigned NOT NULL default '1', AssignBen tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (PlanNum) ) TYPE=MyISAM; # # Dumping data for table `insplan` # # -------------------------------------------------------- # # Table structure for table `instemplate` # DROP TABLE IF EXISTS instemplate; CREATE TABLE instemplate ( TemplateNum smallint(5) unsigned NOT NULL auto_increment, Carrier varchar(50) NOT NULL default '', Address varchar(60) NOT NULL default '', Address2 varchar(60) NOT NULL default '', City varchar(15) NOT NULL default '', State char(2) NOT NULL default '', Zip varchar(10) NOT NULL default '', Phone varchar(18) NOT NULL default '', ClaimFormat smallint(5) unsigned NOT NULL default '0', ElectID varchar(5) NOT NULL default '', Note text NOT NULL, PRIMARY KEY (TemplateNum) ) TYPE=MyISAM; # # Dumping data for table `instemplate` # INSERT INTO instemplate VALUES (1, 'ACS Consulting Services, Inc.', '', '', '', '', '', '', 44, '72468', ''); INSERT INTO instemplate VALUES (2, 'AFLAC of Georgia', '', '', '', '', '', '', 44, '58066', ''); INSERT INTO instemplate VALUES (3, 'AH & L', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (4, 'ALTA Health & Life Insurance Company', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (5, 'APA Partners of New York', '', '', '', '', '', '', 44, '16140', ''); INSERT INTO instemplate VALUES (6, 'Activa Benefit Services, LLC', '', '', '', '', '', '', 44, '38255', ''); INSERT INTO instemplate VALUES (7, 'Advantage Dental Plan, Inc.', '', '', '', '', '', '', 44, '93524', ''); INSERT INTO instemplate VALUES (8, 'Aetna', '', '', '', '', '', '', 44, '60054', ''); INSERT INTO instemplate VALUES (9, 'Aetna US Healthcare Encounters', '', '', '', '', '', '', 44, '68246', ''); INSERT INTO instemplate VALUES (10, 'Alaska Children\'s Services, Inc', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (11, 'Alaska Laborers Construction Industry Trust', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (12, 'Alaska Pipe Trades Local 375', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (13, 'Alaska United Food & Comm. Workers Health & Welfar', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (14, 'Allen Medical Claims Administrators', '', '', '', '', '', '', 44, 'CX016', ''); INSERT INTO instemplate VALUES (15, 'Altus Dental', '', '', '', '', '', '', 44, '50503', ''); INSERT INTO instemplate VALUES (16, 'AmeriChoice - New Jersey Medicaid', '', '', '', '', '', '', 44, '86047', ''); INSERT INTO instemplate VALUES (17, 'AmeriChoice - New York Medicaid', '', '', '', '', '', '', 44, '86048', ''); INSERT INTO instemplate VALUES (18, 'AmeriChoice - Pennsylvania Medicaid', '', '', '', '', '', '', 44, '86049', ''); INSERT INTO instemplate VALUES (19, 'American Medical Security', '', '', '', '', '', '', 44, 'CX001', ''); INSERT INTO instemplate VALUES (20, 'American Postal Workers Union (APWU)', '', '', '', '', '', '', 44, '44444', ''); INSERT INTO instemplate VALUES (21, 'Ameritas Life Insurance Corp.', '', '', '', '', '', '', 44, '47009', ''); INSERT INTO instemplate VALUES (22, 'Amway Corporation', '', '', '', '', '', '', 44, '38255', ''); INSERT INTO instemplate VALUES (23, 'Anthem Blue Cross/Blue Shield (IN, OH & KY)', '', '', '', '', '', '', 44, '84105', ''); INSERT INTO instemplate VALUES (24, 'Anthem Blue Cross/Blue Shield of Connecticut', '', '', '', '', '', '', 44, '65358', ''); INSERT INTO instemplate VALUES (25, 'Anthem Health & Life Insurance Company of New Jers', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (26, 'Automotive Machinists Local 289 Health & Welfare T', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (27, 'Bankers United Life', '', '', '', '', '', '', 44, '74227', ''); INSERT INTO instemplate VALUES (28, 'Bell Atlantic', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (29, 'BeneCare Dental Plan', '', '', '', '', '', '', 44, '23210', ''); INSERT INTO instemplate VALUES (30, 'Benefit Planners', '', '', '', '', '', '', 44, '74223', ''); INSERT INTO instemplate VALUES (31, 'Benefit Systems & Services, Inc. (BSSI)', '', '', '', '', '', '', 44, '36342', ''); INSERT INTO instemplate VALUES (32, 'Blue Care Family Plan (BCBS of CT)', '', '', '', '', '', '', 44, '00700', ''); INSERT INTO instemplate VALUES (33, 'Blue Cross Blue Shield of Michigan', '', '', '', '', '', '', 44, 'CBMI1', ''); INSERT INTO instemplate VALUES (34, 'Blue Cross of Alabama (AL)', '', '', '', '', '', '', 44, 'CBAL1', ''); INSERT INTO instemplate VALUES (35, 'Blue Cross of Alaska & Washington', '', '', '', '', '', '', 44, '47570', ''); INSERT INTO instemplate VALUES (36, 'Blue Cross of Arkansas (AR)', '', '', '', '', '', '', 44, 'CBAR1', ''); INSERT INTO instemplate VALUES (37, 'Blue Cross of California (CA)', '', '', '', '', '', '', 44, '47198', ''); INSERT INTO instemplate VALUES (38, 'Blue Cross of Colorado (CO)', '', '', '', '', '', '', 44, '84099', ''); INSERT INTO instemplate VALUES (39, 'Blue Cross of Connecticut (CT)', '', '', '', '', '', '', 44, '65368', ''); INSERT INTO instemplate VALUES (40, 'Blue Cross of Connecticut Blue Care Family Plan', '', '', '', '', '', '', 44, '00700', ''); INSERT INTO instemplate VALUES (41, 'Blue Cross of Delaware (DE)', '', '', '', '', '', '', 44, '53287', ''); INSERT INTO instemplate VALUES (42, 'Blue Cross of Idaho (ID)', '', '', '', '', '', '', 44, 'CBID1', ''); INSERT INTO instemplate VALUES (43, 'Blue Cross of Illinois (IL)', '', '', '', '', '', '', 44, 'CB621', ''); INSERT INTO instemplate VALUES (44, 'Blue Cross of Indiana (IN) - Anthem', '', '', '', '', '', '', 44, '84105', ''); INSERT INTO instemplate VALUES (45, 'Blue Cross of Iowa (FEP claims only)', '', '', '', '', '', '', 44, 'CBIA1', ''); INSERT INTO instemplate VALUES (46, 'Blue Cross of Iowa (IA)', '', '', '', '', '', '', 44, 'CBIA2', ''); INSERT INTO instemplate VALUES (47, 'Blue Cross of Kansas (KS)', '', '', '', '', '', '', 44, 'CBKS1', ''); INSERT INTO instemplate VALUES (48, 'Blue Cross of Kentucky (KY) - Anthem', '', '', '', '', '', '', 44, '84105', ''); INSERT INTO instemplate VALUES (49, 'Blue Cross of Louisiana (LA)', '', '', '', '', '', '', 44, '23739', ''); INSERT INTO instemplate VALUES (50, 'Blue Cross of Massachusetts (MA)', '', '', '', '', '', '', 44, 'CBMA1', ''); INSERT INTO instemplate VALUES (51, 'Blue Cross of Nevada (NV)', '', '', '', '', '', '', 44, '84101', ''); INSERT INTO instemplate VALUES (52, 'Blue Cross of New Jersey (NJ) - Horizon', '', '', '', '', '', '', 44, '22099', ''); INSERT INTO instemplate VALUES (53, 'Blue Cross of New Mexico (NM)', '', '', '', '', '', '', 44, '84100', ''); INSERT INTO instemplate VALUES (54, 'Blue Cross of New York (NY) - Empire', '', '', '', '', '', '', 44, 'CBNY1', ''); INSERT INTO instemplate VALUES (55, 'Blue Cross of North Dakota (ND)/North Dakota Denta', '', '', '', '', '', '', 44, 'CX004', ''); INSERT INTO instemplate VALUES (56, 'Blue Cross of Ohio (OH) - Anthem', '', '', '', '', '', '', 44, '84105', ''); INSERT INTO instemplate VALUES (57, 'Blue Cross of Oregon (OR) - Regence', '', '', '', '', '', '', 44, 'CB850', ''); INSERT INTO instemplate VALUES (58, 'Blue Cross of Rhode Island (RI)', '', '', '', '', '', '', 44, 'CB870', ''); INSERT INTO instemplate VALUES (59, 'Blue Cross of Tennessee (TN)', '', '', '', '', '', '', 44, 'CBTN1', ''); INSERT INTO instemplate VALUES (60, 'Blue Cross of Texas (TX)', '', '', '', '', '', '', 44, 'CB900', ''); INSERT INTO instemplate VALUES (61, 'Blue Cross of Virginia (VA) - Trigon', '', '', '', '', '', '', 44, 'CB923', ''); INSERT INTO instemplate VALUES (62, 'Blue Cross of Washington & Alaska', '', '', '', '', '', '', 44, '47570', ''); INSERT INTO instemplate VALUES (63, 'Blue Cross of Wisconsin (WI)', '', '', '', '', '', '', 44, 'CB950', ''); INSERT INTO instemplate VALUES (64, 'Blue Shield of Idaho (ID) - Regence', '', '', '', '', '', '', 44, 'CBID2', ''); INSERT INTO instemplate VALUES (65, 'Blue Shield of Pennsylvania (PA)', '', '', '', '', '', '', 44, '99996', ''); INSERT INTO instemplate VALUES (66, 'Blue Shield of Washington (WA) - Regence', '', '', '', '', '', '', 44, '93200', ''); INSERT INTO instemplate VALUES (67, 'Boilermakers National Health & Welfare Fund', '', '', '', '', '', '', 44, '36609', ''); INSERT INTO instemplate VALUES (68, 'Bridgeport Dental Services', '', '', '', '', '', '', 44, 'CX028', ''); INSERT INTO instemplate VALUES (69, 'Businessmen\'s Assurance (BMA)', '', '', '', '', '', '', 44, '47009', ''); INSERT INTO instemplate VALUES (70, 'CCEA Welfare Benefit Trust', '', '', '', '', '', '', 44, '88020', ''); INSERT INTO instemplate VALUES (71, 'CIGNA (Connecticut General)', '', '', '', '', '', '', 44, '62308', ''); INSERT INTO instemplate VALUES (72, 'CIGNA Flex Care (New Mexico only)', '', '', '', '', '', '', 44, '62310', ''); INSERT INTO instemplate VALUES (73, 'CNA Health Partners of Arkansas ', '', '', '', '', '', '', 44, '71063', ''); INSERT INTO instemplate VALUES (74, 'Canada Life Assurance Company, The', '', '', '', '', '', '', 44, '80659', ''); INSERT INTO instemplate VALUES (75, 'Caterpillar, Inc.', '', '', '', '', '', '', 44, '37060', ''); INSERT INTO instemplate VALUES (76, 'Cement Masons & Plasterers Health & Welfare Trust', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (77, 'Central & Southwest Services', '', '', '', '', '', '', 44, '75177', ''); INSERT INTO instemplate VALUES (78, 'Choice Plus (TRW)', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (79, 'Christian Brothers Services', '', '', '', '', '', '', 44, '61271', ''); INSERT INTO instemplate VALUES (80, 'Community Health Electronic Claims /CHEC/webTPA', '', '', '', '', '', '', 44, '75261', ''); INSERT INTO instemplate VALUES (81, 'CompDent', '', '', '', '', '', '', 44, 'CX021', ''); INSERT INTO instemplate VALUES (82, 'Comprehensive Benefits Administrators, Inc.', '', '', '', '', '', '', 44, '03036', ''); INSERT INTO instemplate VALUES (83, 'Connecticut General (CIGNA)', '', '', '', '', '', '', 44, '62308', ''); INSERT INTO instemplate VALUES (84, 'Consolidated Group Dental', '', '', '', '', '', '', 44, '61305', ''); INSERT INTO instemplate VALUES (85, 'Cooperative Benefit Administrators - (CBA)', '', '', '', '', '', '', 44, '52132', ''); INSERT INTO instemplate VALUES (86, 'CoreStar', '', '', '', '', '', '', 44, '41045', ''); INSERT INTO instemplate VALUES (87, 'Corporate Benefit Services', '', '', '', '', '', '', 44, '56117', ''); INSERT INTO instemplate VALUES (88, 'Corporate Benefit Services of America - (CBSA)', '', '', '', '', '', '', 44, '41124', ''); INSERT INTO instemplate VALUES (89, 'CustomCare (Southwestern Bell-Exec)', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (90, 'Delta Dental of Arizona (AZ)', '', '', '', '', '', '', 44, '86027', ''); INSERT INTO instemplate VALUES (91, 'Delta Dental of Arkansas (AR)', '', '', '', '', '', '', 44, 'CDAR1', ''); INSERT INTO instemplate VALUES (92, 'Delta Dental of California (CA)', '', '', '', '', '', '', 44, '77777', ''); INSERT INTO instemplate VALUES (93, 'Delta Dental of California/Tricare Retiree Dental', '', '', '', '', '', '', 44, 'CDCA1', ''); INSERT INTO instemplate VALUES (94, 'Delta Dental of Colorado (CO)', '', '', '', '', '', '', 44, '84056', ''); INSERT INTO instemplate VALUES (95, 'Delta Dental of Delaware (DE)', '', '', '', '', '', '', 44, '51022', ''); INSERT INTO instemplate VALUES (96, 'Delta Dental of Idaho (ID)', '', '', '', '', '', '', 44, '82029', ''); INSERT INTO instemplate VALUES (97, 'Delta Dental of Illinois (IL)', '', '', '', '', '', '', 44, '05030', ''); INSERT INTO instemplate VALUES (98, 'Delta Dental of Indiana (IN)', '', '', '', '', '', '', 44, 'CDIN1', ''); INSERT INTO instemplate VALUES (99, 'Delta Dental of Iowa (IA)', '', '', '', '', '', '', 44, 'CDIA1', ''); INSERT INTO instemplate VALUES (100, 'Delta Dental of Kansas (KS)', '', '', '', '', '', '', 44, 'CDKS1', ''); INSERT INTO instemplate VALUES (101, 'Delta Dental of Kentucky (KY)', '', '', '', '', '', '', 44, 'CDKY1', ''); INSERT INTO instemplate VALUES (102, 'Delta Dental of Maryland (MD)', '', '', '', '', '', '', 44, '23166', ''); INSERT INTO instemplate VALUES (103, 'Delta Dental of Massachusetts (MA)', '', '', '', '', '', '', 44, '04614', ''); INSERT INTO instemplate VALUES (104, 'Delta Dental of Michigan (MI)', '', '', '', '', '', '', 44, 'CDMI0', ''); INSERT INTO instemplate VALUES (105, 'Delta Dental of Minnesota (MN)', '', '', '', '', '', '', 44, 'CDMN1', ''); INSERT INTO instemplate VALUES (106, 'Delta Dental of Missouri (MO)', '', '', '', '', '', '', 44, '43090', ''); INSERT INTO instemplate VALUES (107, 'Delta Dental of Nebraska (NE)', '', '', '', '', '', '', 44, 'CDNE1', ''); INSERT INTO instemplate VALUES (108, 'Delta Dental of New Jersey (NJ)', '', '', '', '', '', '', 44, '22189', ''); INSERT INTO instemplate VALUES (109, 'Delta Dental of New Mexico (NM)', '', '', '', '', '', '', 44, '85022', ''); INSERT INTO instemplate VALUES (110, 'Delta Dental of New York (NY)', '', '', '', '', '', '', 44, '11198', ''); INSERT INTO instemplate VALUES (111, 'Delta Dental of North Carolina (NC)', '', '', '', '', '', '', 44, '56101', ''); INSERT INTO instemplate VALUES (112, 'Delta Dental of North Dakota (ND)', '', '', '', '', '', '', 44, 'CDND1', ''); INSERT INTO instemplate VALUES (113, 'Delta Dental of Northeast (ME, NH, VT)', '', '', '', '', '', '', 44, '02027', ''); INSERT INTO instemplate VALUES (114, 'Delta Dental of Ohio (OH)', '', '', '', '', '', '', 44, 'CDOH1', ''); INSERT INTO instemplate VALUES (115, 'Delta Dental of Oklahoma (OK)', '', '', '', '', '', '', 44, 'CDOK1', ''); INSERT INTO instemplate VALUES (116, 'Delta Dental of Oregon (OR)', '', '', '', '', '', '', 44, 'CDOR1', ''); INSERT INTO instemplate VALUES (117, 'Delta Dental of Pennsylvania (PA)', '', '', '', '', '', '', 44, '23166', ''); INSERT INTO instemplate VALUES (118, 'Delta Dental of Rhode Island (RI)', '', '', '', '', '', '', 44, '05029', ''); INSERT INTO instemplate VALUES (119, 'Delta Dental of South Carolina (SC) in Missouri', '', '', '', '', '', '', 44, '43091', ''); INSERT INTO instemplate VALUES (120, 'Delta Dental of South Dakota (SD)', '', '', '', '', '', '', 44, '54097', ''); INSERT INTO instemplate VALUES (121, 'Delta Dental of Tennessee (TN)', '', '', '', '', '', '', 44, 'CDTN1', ''); INSERT INTO instemplate VALUES (122, 'Delta Dental of Virginia (VA)', '', '', '', '', '', '', 44, '54084', ''); INSERT INTO instemplate VALUES (123, 'Delta Dental of Washington D.C. (DC)', '', '', '', '', '', '', 44, '52147', ''); INSERT INTO instemplate VALUES (124, 'Delta Dental of West Virginia (WV)', '', '', '', '', '', '', 44, '31096', ''); INSERT INTO instemplate VALUES (125, 'Delta Dental of Wisconsin (WI)', '', '', '', '', '', '', 44, '39069', ''); INSERT INTO instemplate VALUES (126, 'Delta Dental of Wyoming (WY)', '', '', '', '', '', '', 44, 'CDWY1', ''); INSERT INTO instemplate VALUES (127, 'DentaQuest', '', '', '', '', '', '', 44, '04356', ''); INSERT INTO instemplate VALUES (128, 'Dental Benefit Providers', '', '', '', '', '', '', 44, '52133', ''); INSERT INTO instemplate VALUES (129, 'Dental Care Plus', '', '', '', '', '', '', 44, 'CX035', ''); INSERT INTO instemplate VALUES (130, 'Dental Comp', '', '', '', '', '', '', 44, 'CX017', ''); INSERT INTO instemplate VALUES (131, 'Dental Network', '', '', '', '', '', '', 44, 'CX034', ''); INSERT INTO instemplate VALUES (132, 'Denti-Cal', '', '', '', '', '', '', 44, '94146', ''); INSERT INTO instemplate VALUES (133, 'Doral Dental of Wisconsin', '', '', '', '', '', '', 44, 'CX014', ''); INSERT INTO instemplate VALUES (134, 'E3 Health, Inc.', '', '', '', '', '', '', 44, '75232', ''); INSERT INTO instemplate VALUES (135, 'EHI', '', '', '', '', '', '', 44, '73288', ''); INSERT INTO instemplate VALUES (136, 'EMPHESYS', '', '', '', '', '', '', 44, '73288', ''); INSERT INTO instemplate VALUES (137, 'EQUICOR', '', '', '', '', '', '', 44, '62308', ''); INSERT INTO instemplate VALUES (138, 'Employee Benefit Admin. (Pembroke, Mass.)', '', '', '', '', '', '', 44, 'CX012', ''); INSERT INTO instemplate VALUES (139, 'Employee Benefit Management Corp. (EBMC)', '', '', '', '', '', '', 44, 'CX025', ''); INSERT INTO instemplate VALUES (140, 'Employee Benefit Mang. Services, Inc. (EBMS)', '', '', '', '', '', '', 44, '81039', ''); INSERT INTO instemplate VALUES (141, 'Employee Group Services (EGS)', '', '', '', '', '', '', 44, 'CX022', ''); INSERT INTO instemplate VALUES (142, 'Employee Plans, LLC', '', '', '', '', '', '', 44, '35112', ''); INSERT INTO instemplate VALUES (143, 'Employee Security Inc.', '', '', '', '', '', '', 44, '54098', ''); INSERT INTO instemplate VALUES (144, 'Employers Health Of Wisconsin (EMPHESYS) (EHIC)', '', '', '', '', '', '', 44, '73288', ''); INSERT INTO instemplate VALUES (145, 'Enstar Natural Gas', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (146, 'Equitable', '', '', '', '', '', '', 44, '62308', ''); INSERT INTO instemplate VALUES (147, 'ExclusiCare', '', '', '', '', '', '', 44, '71412', ''); INSERT INTO instemplate VALUES (148, 'Federated Mutual Health Insurance', '', '', '', '', '', '', 44, '41041', ''); INSERT INTO instemplate VALUES (149, 'First Allmerica Financial Life Ins. Co.', '', '', '', '', '', '', 44, '69140', ''); INSERT INTO instemplate VALUES (150, 'First Ameritas Life Insurance Corp. of NY', '', '', '', '', '', '', 44, '72630', ''); INSERT INTO instemplate VALUES (151, 'First Health', '', '', '', '', '', '', 44, '87043', ''); INSERT INTO instemplate VALUES (152, 'First Integrated Health', '', '', '', '', '', '', 44, '75232', ''); INSERT INTO instemplate VALUES (153, 'First Reliance Standard (N.Y. Business)', '', '', '', '', '', '', 44, '13317', ''); INSERT INTO instemplate VALUES (154, 'FlexCare', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (155, 'Florida Power & Light', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (156, 'Fortis Benefits Insurance Company', '', '', '', '', '', '', 44, '70408', ''); INSERT INTO instemplate VALUES (157, 'Fortis Insurance Company', '', '', '', '', '', '', 44, '39065', ''); INSERT INTO instemplate VALUES (158, 'Fortis Self Funded Administrative Services', '', '', '', '', '', '', 44, '41124', ''); INSERT INTO instemplate VALUES (159, 'G.E. Group Life Assurance Company', '', '', '', '', '', '', 44, '67814', ''); INSERT INTO instemplate VALUES (160, 'GHI - New York - (Group Health Inc.)', '', '', '', '', '', '', 44, '13551', ''); INSERT INTO instemplate VALUES (161, 'General American Life Insurance Co.', '', '', '', '', '', '', 44, '63665', ''); INSERT INTO instemplate VALUES (162, 'Glassworkers Health & Welfare Fund, Grp. #F29', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (163, 'Great West Life & Annuity Insurance Co.', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (164, 'Group Administrators Ltd.', '', '', '', '', '', '', 44, '36338', ''); INSERT INTO instemplate VALUES (165, 'Group Benefit Services (East Lansing, Mich.)', '', '', '', '', '', '', 44, 'CX011', ''); INSERT INTO instemplate VALUES (166, 'Group Link of Indiana', '', '', '', '', '', '', 44, 'CX015', ''); INSERT INTO instemplate VALUES (167, 'Guardian Life Insurance Co. of America, The', '', '', '', '', '', '', 44, '64246', ''); INSERT INTO instemplate VALUES (168, 'HRM Claim Management', '', '', '', '', '', '', 44, '41170', ''); INSERT INTO instemplate VALUES (169, 'HRM Claim Management', '', '', '', '', '', '', 44, '41170', ''); INSERT INTO instemplate VALUES (170, 'Harrington Benefit Services, Inc.', '', '', '', '', '', '', 44, '95266', ''); INSERT INTO instemplate VALUES (171, 'Harrington Benefit Services, Inc. (Oklahoma)', '', '', '', '', '', '', 44, '59142', ''); INSERT INTO instemplate VALUES (172, 'Health Management Systems', '', '', '', '', '', '', 44, '84097', ''); INSERT INTO instemplate VALUES (173, 'Health Partners of Minnesota', '', '', '', '', '', '', 44, 'CX009', ''); INSERT INTO instemplate VALUES (174, 'Health Partners of Tennessee', '', '', '', '', '', '', 44, '62157', ''); INSERT INTO instemplate VALUES (175, 'Health Plan Services (Oklahoma)', '', '', '', '', '', '', 44, '59142', ''); INSERT INTO instemplate VALUES (176, 'Health Resources Incorporated (HRI)', '', '', '', '', '', '', 44, 'CX019', ''); INSERT INTO instemplate VALUES (177, 'Health Risk Management (HRM)', '', '', '', '', '', '', 44, '41170', ''); INSERT INTO instemplate VALUES (178, 'HealthRight Inc. of Connecticut (To First Health)', '', '', '', '', '', '', 44, '87043', ''); INSERT INTO instemplate VALUES (179, 'HealthSCOPE Benefits, Inc.', '', '', '', '', '', '', 44, '71063', ''); INSERT INTO instemplate VALUES (180, 'Healthplex, Inc.', '', '', '', '', '', '', 44, '11271', ''); INSERT INTO instemplate VALUES (181, 'Healthsource Provident (CIGNA)', '', '', '', '', '', '', 44, '68195', ''); INSERT INTO instemplate VALUES (182, 'Horizon Blue Cross/Blue Shield of New Jersey', '', '', '', '', '', '', 44, '22099', ''); INSERT INTO instemplate VALUES (183, 'Hotel Employees & Restaurant Employees Health Trus', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (184, 'Humana', '', '', '', '', '', '', 44, '73288', ''); INSERT INTO instemplate VALUES (185, 'IBI (Iowa Benefits Inc.)', '', '', '', '', '', '', 44, '41124', ''); INSERT INTO instemplate VALUES (186, 'Insurance Design Administrators of New Jersey', '', '', '', '', '', '', 44, '13315', ''); INSERT INTO instemplate VALUES (187, 'J. F. Molloy and Associates', '', '', '', '', '', '', 44, '61271', ''); INSERT INTO instemplate VALUES (188, 'JLT Services Corporation', '', '', '', '', '', '', 44, '14168', ''); INSERT INTO instemplate VALUES (189, 'John Deere Health Care/Heritage National Health Pl', '', '', '', '', '', '', 44, '95378', ''); INSERT INTO instemplate VALUES (190, 'John Hancock Health Security Plan', '', '', '', '', '', '', 44, '65099', ''); INSERT INTO instemplate VALUES (191, 'Kanawha Insurance Company', '', '', '', '', '', '', 44, '57038', ''); INSERT INTO instemplate VALUES (192, 'Kempton Company', '', '', '', '', '', '', 44, '73100', ''); INSERT INTO instemplate VALUES (193, 'Kempton Group Administrators', '', '', '', '', '', '', 44, '73100', ''); INSERT INTO instemplate VALUES (194, 'Life Insurance Co. of Boston & New York', '', '', '', '', '', '', 44, '78140', ''); INSERT INTO instemplate VALUES (195, 'Lincoln National (WI)', '', '', '', '', '', '', 44, '73288', ''); INSERT INTO instemplate VALUES (196, 'Lovelace Health Plan', '', '', '', '', '', '', 44, '62310', ''); INSERT INTO instemplate VALUES (197, 'Lovelace Senior Options (LSO)', '', '', '', '', '', '', 44, '62310', ''); INSERT INTO instemplate VALUES (198, 'Lovelace Senior Plan (LSP)', '', '', '', '', '', '', 44, '62310', ''); INSERT INTO instemplate VALUES (199, 'MAMSI', '', '', '', '', '', '', 44, 'CX033', ''); INSERT INTO instemplate VALUES (200, 'MBS (MedCost Benefit Services)', '', '', '', '', '', '', 44, '56205', ''); INSERT INTO instemplate VALUES (201, 'MEDICA of Minnesota', '', '', '', '', '', '', 44, 'CX026', ''); INSERT INTO instemplate VALUES (202, 'MEGA Life & Health Co. (Student Division)', '', '', '', '', '', '', 44, '74227', ''); INSERT INTO instemplate VALUES (203, 'Mailhandlers Benefit Plan', '', '', '', '', '', '', 44, '62413', ''); INSERT INTO instemplate VALUES (204, 'Manulife, W.J. Sutton Co.', '', '', '', '', '', '', 44, '98010', ''); INSERT INTO instemplate VALUES (205, 'Marriott', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (206, 'Mass Mutual', '', '', '', '', '', '', 44, '65935', ''); INSERT INTO instemplate VALUES (207, 'MedBen (Newark, OH)', '', '', '', '', '', '', 44, '74323', ''); INSERT INTO instemplate VALUES (208, 'Medcost of North Carolina', '', '', '', '', '', '', 44, '56205', ''); INSERT INTO instemplate VALUES (209, 'Medicaid of Alabama', '', '', '', '', '', '', 44, 'CXAL1', ''); INSERT INTO instemplate VALUES (210, 'Medicaid of Arkansas', '', '', '', '', '', '', 44, 'CKAR1', ''); INSERT INTO instemplate VALUES (211, 'Medicaid of California (Denti-Cal)', '', '', '', '', '', '', 44, '94146', ''); INSERT INTO instemplate VALUES (212, 'Medicaid of Colorado', '', '', '', '', '', '', 44, 'CKCO1', ''); INSERT INTO instemplate VALUES (213, 'Medicaid of Connecticut', '', '', '', '', '', '', 44, 'CKCT1', ''); INSERT INTO instemplate VALUES (214, 'Medicaid of Delaware', '', '', '', '', '', '', 44, 'CKDE1', ''); INSERT INTO instemplate VALUES (215, 'Medicaid of Florida', '', '', '', '', '', '', 44, 'CKFL1', ''); INSERT INTO instemplate VALUES (216, 'Medicaid of Georgia', '', '', '', '', '', '', 44, 'CKGA1', ''); INSERT INTO instemplate VALUES (217, 'Medicaid of Idaho', '', '', '', '', '', '', 44, 'CKID1', ''); INSERT INTO instemplate VALUES (218, 'Medicaid of Illinois', '', '', '', '', '', '', 44, 'CKIL1', ''); INSERT INTO instemplate VALUES (219, 'Medicaid of Indiana', '', '', '', '', '', '', 44, 'CKIN1', ''); INSERT INTO instemplate VALUES (220, 'Medicaid of Iowa', '', '', '', '', '', '', 44, 'CKIA1', ''); INSERT INTO instemplate VALUES (221, 'Medicaid of Kansas', '', '', '', '', '', '', 44, 'CKKS1', ''); INSERT INTO instemplate VALUES (222, 'Medicaid of Kentucky', '', '', '', '', '', '', 44, 'CKKY1', ''); INSERT INTO instemplate VALUES (223, 'Medicaid of Louisiana (ADULT)', '', '', '', '', '', '', 44, 'CKLA2', ''); INSERT INTO instemplate VALUES (224, 'Medicaid of Louisiana (EPSDT)', '', '', '', '', '', '', 44, 'CKLA1', ''); INSERT INTO instemplate VALUES (225, 'Medicaid of Maine', '', '', '', '', '', '', 44, 'CKME1', ''); INSERT INTO instemplate VALUES (226, 'Medicaid of Maryland', '', '', '', '', '', '', 44, 'CKMD1', ''); INSERT INTO instemplate VALUES (227, 'Medicaid of Massachusetts', '', '', '', '', '', '', 44, 'CKMA1', ''); INSERT INTO instemplate VALUES (228, 'Medicaid of Michigan', '', '', '', '', '', '', 44, 'CKMI1', ''); INSERT INTO instemplate VALUES (229, 'Medicaid of Minnesota', '', '', '', '', '', '', 44, 'CKMN1', ''); INSERT INTO instemplate VALUES (230, 'Medicaid of Minnesota (by Health Partners)', '', '', '', '', '', '', 44, 'CX010', ''); INSERT INTO instemplate VALUES (231, 'Medicaid of Mississippi', '', '', '', '', '', '', 44, 'CKMS1', ''); INSERT INTO instemplate VALUES (232, 'Medicaid of Missouri', '', '', '', '', '', '', 44, 'CKMO1', ''); INSERT INTO instemplate VALUES (233, 'Medicaid of Montana', '', '', '', '', '', '', 44, 'CKMT1', ''); INSERT INTO instemplate VALUES (234, 'Medicaid of Nebraska', '', '', '', '', '', '', 44, 'CX014', ''); INSERT INTO instemplate VALUES (235, 'Medicaid of New Hampshire', '', '', '', '', '', '', 44, 'CKNH1', ''); INSERT INTO instemplate VALUES (236, 'Medicaid of New Jersey', '', '', '', '', '', '', 44, 'CKNJ1', ''); INSERT INTO instemplate VALUES (237, 'Medicaid of New Jersey (Adminstrated by Americhoic', '', '', '', '', '', '', 44, '86047', ''); INSERT INTO instemplate VALUES (238, 'Medicaid of New Mexico', '', '', '', '', '', '', 44, 'CX014', ''); INSERT INTO instemplate VALUES (239, 'Medicaid of New York', '', '', '', '', '', '', 44, 'CKNY1', ''); INSERT INTO instemplate VALUES (240, 'Medicaid of New York (Adminstrated by Americhoice)', '', '', '', '', '', '', 44, '86048', ''); INSERT INTO instemplate VALUES (241, 'Medicaid of New York (Dental Clinics Only)', '', '', '', '', '', '', 44, 'CKNY2', ''); INSERT INTO instemplate VALUES (242, 'Medicaid of North Carolina', '', '', '', '', '', '', 44, 'CKNC1', ''); INSERT INTO instemplate VALUES (243, 'Medicaid of Ohio (Administered by CareSource)', '', '', '', '', '', '', 44, 'CKOH2', ''); INSERT INTO instemplate VALUES (244, 'Medicaid of Ohio (Administered by Doral Dental)', '', '', '', '', '', '', 44, 'CX014', ''); INSERT INTO instemplate VALUES (245, 'Medicaid of Ohio (Administered by Quadax)', '', '', '', '', '', '', 44, 'CKOH1', ''); INSERT INTO instemplate VALUES (246, 'Medicaid of Oklahoma (Administered by Doral Dental', '', '', '', '', '', '', 44, 'CX014', ''); INSERT INTO instemplate VALUES (247, 'Medicaid of Oklahoma (Administered by UNISYS)', '', '', '', '', '', '', 44, 'CKOK1', ''); INSERT INTO instemplate VALUES (248, 'Medicaid of Oregon', '', '', '', '', '', '', 44, 'CKOR1', ''); INSERT INTO instemplate VALUES (249, 'Medicaid of Pennsylvania (Administered by Americho', '', '', '', '', '', '', 44, '86049', ''); INSERT INTO instemplate VALUES (250, 'Medicaid of Pennsylvania (Administered by EDS)', '', '', '', '', '', '', 44, 'CKPA1', ''); INSERT INTO instemplate VALUES (251, 'Medicaid of Pennsylvania  (Administered by Doral D', '', '', '', '', '', '', 44, 'CX014', ''); INSERT INTO instemplate VALUES (252, 'Medicaid of Rhode Island', '', '', '', '', '', '', 44, 'CKRI1', ''); INSERT INTO instemplate VALUES (253, 'Medicaid of South Carolina', '', '', '', '', '', '', 44, 'CKSC1', ''); INSERT INTO instemplate VALUES (254, 'Medicaid of Tennessee, Access Med Plus', '', '', '', '', '', '', 44, 'CKTN1', ''); INSERT INTO instemplate VALUES (255, 'Medicaid of Texas', '', '', '', '', '', '', 44, 'CKTX1', ''); INSERT INTO instemplate VALUES (256, 'Medicaid of Utah', '', '', '', '', '', '', 44, 'CKUT1', ''); INSERT INTO instemplate VALUES (257, 'Medicaid of Vermont', '', '', '', '', '', '', 44, 'CKVT1', ''); INSERT INTO instemplate VALUES (258, 'Medicaid of Virginia', '', '', '', '', '', '', 44, 'CKVA1', ''); INSERT INTO instemplate VALUES (259, 'Medicaid of Virginia (Administered by Doral Dental', '', '', '', '', '', '', 44, 'CX014', ''); INSERT INTO instemplate VALUES (260, 'Medicaid of Washington', '', '', '', '', '', '', 44, 'CKWA1', ''); INSERT INTO instemplate VALUES (261, 'Medicaid of West Virginia', '', '', '', '', '', '', 44, 'CKWV1', ''); INSERT INTO instemplate VALUES (262, 'Medicaid of Wisconsin', '', '', '', '', '', '', 44, 'CKWI1', ''); INSERT INTO instemplate VALUES (263, 'Medicaid of Wisconsin (Administered by Doral Denta', '', '', '', '', '', '', 44, 'CX014', ''); INSERT INTO instemplate VALUES (264, 'Medicaid of Wyoming', '', '', '', '', '', '', 44, 'CKWY1', ''); INSERT INTO instemplate VALUES (265, 'Medical Benefit Administrators', '', '', '', '', '', '', 44, 'CX024', ''); INSERT INTO instemplate VALUES (266, 'Medical Benefits Mutual', '', '', '', '', '', '', 44, '74323', ''); INSERT INTO instemplate VALUES (267, 'Medical Mutual of Ohio', '', '', '', '', '', '', 44, 'CB833', ''); INSERT INTO instemplate VALUES (268, 'MetLife', '', '', '', '', '', '', 44, '65978', ''); INSERT INTO instemplate VALUES (269, 'MetLife (formerly Travelers)', '', '', '', '', '', '', 44, '87726', ''); INSERT INTO instemplate VALUES (270, 'Mid-West United Life (Student Division)', '', '', '', '', '', '', 44, '74227', ''); INSERT INTO instemplate VALUES (271, 'Mutual Alliance Plan (MAP)', '', '', '', '', '', '', 44, '69140', ''); INSERT INTO instemplate VALUES (272, 'Mutual of Omaha Insurance Co.', '', '', '', '', '', '', 44, '71412', ''); INSERT INTO instemplate VALUES (273, 'Mutually Preferred', '', '', '', '', '', '', 44, '71412', ''); INSERT INTO instemplate VALUES (274, 'N. W. International Assc.of Machinists & Aerospace', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (275, 'N.W. Ironworkers Health & Security Trust Fund', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (276, 'N.W. Roofers & Employers Health & Security Trust F', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (277, 'N.W. Textile Processors', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (278, 'NCAS - Fairfax, VA', '', '', '', '', '', '', 44, '75190', ''); INSERT INTO instemplate VALUES (279, 'NEA Alaska Health Plan', '', '', '', '', '', '', 44, '54098', ''); INSERT INTO instemplate VALUES (280, 'NOVA HEALTHCARE ADMIN., INC.', '', '', '', '', '', '', 44, '16644', ''); INSERT INTO instemplate VALUES (281, 'National Assoc. of Letter Carriers/NALC', '', '', '', '', '', '', 44, '53011', ''); INSERT INTO instemplate VALUES (282, 'National Rural Letter Carrier Assoc.', '', '', '', '', '', '', 44, '71412', ''); INSERT INTO instemplate VALUES (283, 'New England Dental Administrators', '', '', '', '', '', '', 44, '43351', ''); INSERT INTO instemplate VALUES (284, 'New England Financial', '', '', '', '', '', '', 44, '66893', ''); INSERT INTO instemplate VALUES (285, 'New York Life (now NYLCare) **(N)', '', '', '', '', '', '', 44, '66915', ''); INSERT INTO instemplate VALUES (286, 'Nippon Life Insurance Co.', '', '', '', '', '', '', 44, '81264', ''); INSERT INTO instemplate VALUES (287, 'Northeast Delta Dental (ME, NH, VT)', '', '', '', '', '', '', 44, '02027', ''); INSERT INTO instemplate VALUES (288, 'Northern Nevada Trust Fund', '', '', '', '', '', '', 44, '88027', ''); INSERT INTO instemplate VALUES (289, 'Northwest Administrators', '', '', '', '', '', '', 44, '91060', ''); INSERT INTO instemplate VALUES (290, 'Northwest Dental Services', '', '', '', '', '', '', 44, '93525', ''); INSERT INTO instemplate VALUES (291, 'Northwestern National Life (Now ReliaStar)', '', '', '', '', '', '', 44, '41045', ''); INSERT INTO instemplate VALUES (292, 'ONE Health Plan Inc. of Alaska, Arizona, Florida,', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (293, 'ONE Health Plan Inc. of California', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (294, 'ONE Health Plan Inc. of Colorado', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (295, 'ONE Health Plan Inc. of Georgia', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (296, 'ONE Health Plan Inc. of Illinois', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (297, 'ONE Health Plan Inc. of Texas', '', '', '', '', '', '', 44, '80705', ''); INSERT INTO instemplate VALUES (298, 'Operating Engineers Locals 302 & 612 Health & Secu', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (299, 'Oregon Dental Service', '', '', '', '', '', '', 44, 'CDOR1', ''); INSERT INTO instemplate VALUES (300, 'Oxford Health Plans', '', '', '', '', '', '', 44, '84104', ''); INSERT INTO instemplate VALUES (301, 'PM Group', '', '', '', '', '', '', 44, '67466', ''); INSERT INTO instemplate VALUES (302, 'Pacific Life & Annuity', '', '', '', '', '', '', 44, '67466', ''); INSERT INTO instemplate VALUES (303, 'PacificSource Health Plans', '', '', '', '', '', '', 44, '93029', ''); INSERT INTO instemplate VALUES (304, 'Paul Revere/Provident', '', '', '', '', '', '', 44, '47009', ''); INSERT INTO instemplate VALUES (305, 'Phoenix American', '', '', '', '', '', '', 44, '67814', ''); INSERT INTO instemplate VALUES (306, 'Phoenix Home Life', '', '', '', '', '', '', 44, '67814', ''); INSERT INTO instemplate VALUES (307, 'Physicians Plus Insurance, -WI State Employees', '', '', '', '', '', '', 44, 'CX014', ''); INSERT INTO instemplate VALUES (308, 'Pinnacle Claims Management, Inc.', '', '', '', '', '', '', 44, '24735', ''); INSERT INTO instemplate VALUES (309, 'Preferred Dental Organization (PDO)', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (310, 'Primary PhysicianCare, Inc.', '', '', '', '', '', '', 44, '56144', ''); INSERT INTO instemplate VALUES (311, 'Principal Financial Group', '', '', '', '', '', '', 44, '61271', ''); INSERT INTO instemplate VALUES (312, 'Principal Mutual Life Insurance Co.', '', '', '', '', '', '', 44, '61271', ''); INSERT INTO instemplate VALUES (313, 'Protective Life', '', '', '', '', '', '', 44, '70408', ''); INSERT INTO instemplate VALUES (314, 'Provident Life & Acc. Ins. Co. of America', '', '', '', '', '', '', 44, '68195', ''); INSERT INTO instemplate VALUES (315, 'Provident Life & Casualty Ins. Co.', '', '', '', '', '', '', 44, '68195', ''); INSERT INTO instemplate VALUES (316, 'Provident Life and Accident Ins. Co.', '', '', '', '', '', '', 44, '68195', ''); INSERT INTO instemplate VALUES (317, 'Provident Preferred Network', '', '', '', '', '', '', 44, '68195', ''); INSERT INTO instemplate VALUES (318, 'Prudential', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (319, 'Pugent Sound Benefits Trust', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (320, 'Pugent Sound Electrical Workers Trust', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (321, 'Regence Blue Cross/Blue Shield of Oregon', '', '', '', '', '', '', 44, 'CB850', ''); INSERT INTO instemplate VALUES (322, 'Regence Blue Shield Idaho', '', '', '', '', '', '', 44, 'CBID2', ''); INSERT INTO instemplate VALUES (323, 'Regence Blue Shield Washington', '', '', '', '', '', '', 44, '93200', ''); INSERT INTO instemplate VALUES (324, 'Regence Washington Health - AKA - Aberdeen, Raymon', '', '', '', '', '', '', 44, '93200', ''); INSERT INTO instemplate VALUES (325, 'ReliaStar (Prev.Northwestern National Life)', '', '', '', '', '', '', 44, '80314', ''); INSERT INTO instemplate VALUES (326, 'Reliance Standard Life', '', '', '', '', '', '', 44, '36088', ''); INSERT INTO instemplate VALUES (327, 'Rocky Mountain Life Dental', '', '', '', '', '', '', 44, '84102', ''); INSERT INTO instemplate VALUES (328, 'Safeguard', '', '', '', '', '', '', 44, 'CX030', ''); INSERT INTO instemplate VALUES (329, 'Seabury & Smith', '', '', '', '', '', '', 44, 'CX023', ''); INSERT INTO instemplate VALUES (330, 'Select Benefit Administrators', '', '', '', '', '', '', 44, 'CX018', ''); INSERT INTO instemplate VALUES (331, 'SelectCare (Coca Cola)', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (332, 'Self Funded Plans Inc. of Cleveland Ohio', '', '', '', '', '', '', 44, '34131', ''); INSERT INTO instemplate VALUES (333, 'Self Insured Services Company', '', '', '', '', '', '', 44, 'CX020', ''); INSERT INTO instemplate VALUES (334, 'Southwestern Bell', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (335, 'Southwestern Bell Exec.- Custom Care', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (336, 'Southwestern Bell Exec.- Southwest Bell', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (337, 'Standard Insurance (OR)', '', '', '', '', '', '', 44, '93024', ''); INSERT INTO instemplate VALUES (338, 'Student Insurance', '', '', '', '', '', '', 44, '74227', ''); INSERT INTO instemplate VALUES (339, 'Sun Life of Canada', '', '', '', '', '', '', 44, '47009', ''); INSERT INTO instemplate VALUES (340, 'Superior Dental Care', '', '', '', '', '', '', 44, '31117', ''); INSERT INTO instemplate VALUES (341, 'TDC - The Dental Companies (Green Bay, WI)', '', '', '', '', '', '', 44, '73288', ''); INSERT INTO instemplate VALUES (342, 'The Canada Life Assurance Company', '', '', '', '', '', '', 44, '80659', ''); INSERT INTO instemplate VALUES (343, 'Third Party Claims Management', '', '', '', '', '', '', 44, '06131', ''); INSERT INTO instemplate VALUES (344, 'Time Insurance (a Fortis company)', '', '', '', '', '', '', 44, '39065', ''); INSERT INTO instemplate VALUES (345, 'Travelers (now MetLife)', '', '', '', '', '', '', 44, '87726', ''); INSERT INTO instemplate VALUES (346, 'Tricare Active Reservists Only (Green Bay, WI)', '', '', '', '', '', '', 44, '73288', ''); INSERT INTO instemplate VALUES (347, 'Tricare Retiree Dental Program - Delta USA', '', '', '', '', '', '', 44, 'CDCA1', ''); INSERT INTO instemplate VALUES (348, 'Trigon Blue Cross/Blue Shield of Virginia', '', '', '', '', '', '', 44, 'CB923', ''); INSERT INTO instemplate VALUES (349, 'Trigon Insurance Company (Colorado)', '', '', '', '', '', '', 44, '84103', ''); INSERT INTO instemplate VALUES (350, 'UICI - Administrators - State of Nevada', '', '', '', '', '', '', 44, '75245', ''); INSERT INTO instemplate VALUES (351, 'UNICARE Major Accounts', '', '', '', '', '', '', 44, '80314', ''); INSERT INTO instemplate VALUES (352, 'UNICARE Special Accounts', '', '', '', '', '', '', 44, '65099', ''); INSERT INTO instemplate VALUES (353, 'UniCare of Texas - HMO', '', '', '', '', '', '', 44, '80314', ''); INSERT INTO instemplate VALUES (354, 'United Concordia-UCCI ( CHAMPUS ) - Fee for Servic', '', '', '', '', '', '', 44, '99995', ''); INSERT INTO instemplate VALUES (355, 'United Concordia-UCCI (TRICARE, FMDP)', '', '', '', '', '', '', 44, '99994', ''); INSERT INTO instemplate VALUES (356, 'United Concordia-UCCI - ConcordiaPLUS DHMO', '', '', '', '', '', '', 44, '99998', ''); INSERT INTO instemplate VALUES (357, 'United Concordia-UCCI - DentalPLUS DHMO', '', '', '', '', '', '', 44, '99997', ''); INSERT INTO instemplate VALUES (358, 'United Healthcare (Dental Benefit Providers)', '', '', '', '', '', '', 44, '52133', ''); INSERT INTO instemplate VALUES (359, 'United States Life Insurance Company of NJ', '', '', '', '', '', '', 44, '13545', ''); INSERT INTO instemplate VALUES (360, 'United of Omaha', '', '', '', '', '', '', 44, '71412', ''); INSERT INTO instemplate VALUES (361, 'Univera of New York', '', '', '', '', '', '', 44, '16105', ''); INSERT INTO instemplate VALUES (362, 'University of Washington Students & Graduate Appts', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (363, 'Varian Health Care Plan', '', '', '', '', '', '', 44, '68241', ''); INSERT INTO instemplate VALUES (364, 'WEA Insurance Group', '', '', '', '', '', '', 44, '39151', ''); INSERT INTO instemplate VALUES (365, 'Washington Dental Service', '', '', '', '', '', '', 44, '91062', ''); INSERT INTO instemplate VALUES (366, 'Washington State County & City Employees Dental Tr', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (367, 'Wausau Benefits-aka Employers Ins. of Wausau', '', '', '', '', '', '', 44, '39026', ''); INSERT INTO instemplate VALUES (368, 'WebTPA/Community Health Electronic Claims', '', '', '', '', '', '', 44, '75261', ''); INSERT INTO instemplate VALUES (369, 'Wellpoint Dental-AKA- Blue Cross of CA', '', '', '', '', '', '', 44, '47198', ''); INSERT INTO instemplate VALUES (370, 'West Coast Stationary Engineers Health Trust Fund', '', '', '', '', '', '', 44, '91136', ''); INSERT INTO instemplate VALUES (371, 'Western Grower\'s Assurance Trust & Insurance', '', '', '', '', '', '', 44, '24735', ''); INSERT INTO instemplate VALUES (372, 'Whatcom Medical Bureau', '', '', '', '', '', '', 44, '84098', ''); INSERT INTO instemplate VALUES (373, 'Xantus Health Plan - Tennesse', '', '', '', '', '', '', 44, 'CX104', ''); # -------------------------------------------------------- # # Table structure for table `language` # DROP TABLE IF EXISTS language; CREATE TABLE language ( LanguageNum smallint(5) unsigned NOT NULL auto_increment, EnglishComments text NOT NULL, ClassType varchar(255) NOT NULL default '', English text NOT NULL, Spanish text NOT NULL, SpanishComments text NOT NULL, Italian text NOT NULL, ItalianComments text NOT NULL, Chinese text NOT NULL, ChineseComments text NOT NULL, PRIMARY KEY (LanguageNum) ) TYPE=MyISAM; # # Dumping data for table `language` # INSERT INTO language VALUES (1, '', 'FormMedical', 'Quick paste Service', '', '', 'Aggiungi servizio', '', '', ''); INSERT INTO language VALUES (2, '', 'FormMedical', 'Quick paste Medical', '', '', 'Aggiungi medico', '', '', ''); INSERT INTO language VALUES (3, '', 'FormMedical', 'Urgent Medical Notes', 'Notas Urgentes del Medico', '', 'Note mediche urgenti', '', '', ''); INSERT INTO language VALUES (4, '', 'FormMedical', 'Medical Summary', 'Resumen Médico', '', 'Riassunto medico', '', '', ''); INSERT INTO language VALUES (5, '', 'FormMedical', 'Service Notes', 'Notas de Servicio', '', 'Note di servizio', '', '', ''); INSERT INTO language VALUES (79, '', 'ContrFamily', ' Set Guarantor', ' Establecer Fiador', '', ' E\' un Garante', '', '', ''); INSERT INTO language VALUES (9, '', 'FormFreeDental', 'Docs', 'Docs', '', 'Dottori', '', '', ''); INSERT INTO language VALUES (10, '', 'FormFreeDental', 'Acct', 'Cta', '', 'Acc', '', '', ''); INSERT INTO language VALUES (11, '', 'FormFreeDental', 'Fam', 'Fam', '', 'Fam', '', '', ''); INSERT INTO language VALUES (12, '', 'FormFreeDental', 'Appts', 'Citas', '', 'App', '', '', ''); INSERT INTO language VALUES (13, '', 'FormFreeDental', 'Treat\' Plan', 'Plan Trat\'', '', 'Trattamenti', '', '', ''); INSERT INTO language VALUES (14, '', 'FormFreeDental', 'Chart', 'Gráfico', '', 'Cartella', '', '', ''); INSERT INTO language VALUES (15, '', 'FormFreeDental', 'Tools', 'Herramientas', '', 'Strumenti', '', '', ''); INSERT INTO language VALUES (16, '', 'TablePatient', 'Patient Information', 'Información del Paciente', '', 'Dettagli del Paziente', '', '', ''); INSERT INTO language VALUES (17, '', 'TablePatient', 'Chart Num', 'Número del Gráfico', '', 'Cartella N.', '', '', ''); INSERT INTO language VALUES (18, '', 'TablePatient', 'Last', 'Anterior', '', 'Cognome', '', '', ''); INSERT INTO language VALUES (19, '', 'TablePatient', 'First', 'Primero', '', 'Nome', '', '', ''); INSERT INTO language VALUES (20, '', 'TablePatient', 'Middle', 'Mitad', '', 'Iniziali', '', '', ''); INSERT INTO language VALUES (21, '', 'TablePatient', 'Preferred', 'Preferido', '', 'Preferito', '', '', ''); INSERT INTO language VALUES (22, '', 'TablePatient', 'Salutation', 'Saludo', '', 'Saluti', '', '', ''); INSERT INTO language VALUES (23, '', 'TablePatient', 'Status', 'Estatus', '', 'Stato civ.', '', '', ''); INSERT INTO language VALUES (24, '', 'TablePatient', 'Gender', 'Género', '', 'Sesso', '', '', ''); INSERT INTO language VALUES (25, '', 'TablePatient', 'Position', 'Posición', '', 'Posizione', '', '', ''); INSERT INTO language VALUES (26, '', 'TablePatient', 'Birthdate', 'Dia de Nacimiento', '', 'Data Nascita', '', '', ''); INSERT INTO language VALUES (27, '', 'TablePatient', 'Age', 'Edad', '', 'Età', '', '', ''); INSERT INTO language VALUES (28, 'blank in Spanish and Italian', 'TablePatient', 'SS#', ' ', '', ' ', '', '', ''); INSERT INTO language VALUES (29, '', 'TablePatient', 'Address', 'Dirección', '', 'Indirizzo', '', '', ''); INSERT INTO language VALUES (30, '', 'TablePatient', 'Address2', 'Dirección2', '', 'Indirizzo2', '', '', ''); INSERT INTO language VALUES (31, '', 'TablePatient', 'City', 'Ciudad', '', 'Città', '', '', ''); INSERT INTO language VALUES (32, '', 'TablePatient', 'State', 'Estado', '', 'Regione', '', '', ''); INSERT INTO language VALUES (33, '', 'TablePatient', 'Zip', 'Código Postal', '', 'c.a.p.', '', '', ''); INSERT INTO language VALUES (34, '', 'TablePatient', 'Hm Phone', 'Teléfono Hab.', '', 'Tel casa', '', '', ''); INSERT INTO language VALUES (35, '', 'TablePatient', 'Wk Phone', 'Teléfono Ofc.', '', 'Tel ufficio', '', '', ''); INSERT INTO language VALUES (36, '', 'TablePatient', 'Wireless Ph', 'Celular', '', 'Cellulare', '', '', ''); INSERT INTO language VALUES (37, '', 'TablePatient', 'E-mail', 'E-mail', '', 'E-mail', '', '', ''); INSERT INTO language VALUES (38, '"Family" means shared between patients', 'TablePatient', 'Family Address and Phone Notes', 'Notas por Habitación y Teléfonos', '', 'Ind. famiglia e note tel.', '', '', ''); INSERT INTO language VALUES (39, '', 'TableCoverage', 'Primary Insurance Coverage', 'Cobertura Primaria Seguro', '', 'Copertura Assicurativa Primaria', '', '', ''); INSERT INTO language VALUES (40, '', 'TableCoverage', 'Secondary Insurance Coverage', 'Cobertura Secundaria Seguro', '', 'Copertura Assicurativa Secondaria', '', '', ''); INSERT INTO language VALUES (41, '', 'TableCoverage', 'Ins Plan', 'Ingresar Plan', '', 'Polizza', '', '', ''); INSERT INTO language VALUES (42, '', 'TableCoverage', 'Rel\'ship to Sub', '', '', 'Relaz.con contraente', '', '', ''); INSERT INTO language VALUES (43, '', 'TableCoverage', 'Annual Max $', '', '', 'Massimale annuo', '', '', ''); INSERT INTO language VALUES (44, '', 'TableCoverage', 'Ortho Max $', '', '', 'Massimale ortho.', '', '', ''); INSERT INTO language VALUES (45, '', 'TableCoverage', 'Renewal Month', 'Mes de la Renovación', '', 'Mese di scadenza', '', '', ''); INSERT INTO language VALUES (46, '', 'TableCoverage', 'Deductible $', 'Deducible Bs.', '', 'Deducibile €', '', '', ''); INSERT INTO language VALUES (47, '', 'TableCoverage', 'Waived on Prev?', '', '', 'Deduz. aggiuntiva', '', '', ''); INSERT INTO language VALUES (48, 'Fluoride to age:', 'TableCoverage', 'Flo to Age:', '', '', 'Fluoro da', '', '', ''); INSERT INTO language VALUES (49, '', 'TableCoverage', 'Miss Tooth Excl?', '', '', 'Condiz.assic.preesistenti ?', '', '', ''); INSERT INTO language VALUES (50, '', 'TableCoverage', 'Wait on Major?', '', '', 'Ass. non paga i primi 6 mesi', '', '', ''); INSERT INTO language VALUES (51, '', 'TableCoverage', 'Ins Plan Note', 'Ingresar Nota al Plan', '', 'Note su copertura ass.', '', '', ''); INSERT INTO language VALUES (52, '', 'TableInsPlans', 'Insurance Plans for Family', 'Plan Familiar de Seguro', '', 'Polizza della famiglia', '', '', ''); INSERT INTO language VALUES (53, '', 'TableInsPlans', '#', '', '', 'n°', '', '', ''); INSERT INTO language VALUES (54, '', 'TableInsPlans', 'Subscriber', 'Suscriptor', '', 'Contraente', '', '', ''); INSERT INTO language VALUES (55, '', 'TableInsPlans', 'Ins Carrier', '', '', 'Assicurazione', '', '', ''); INSERT INTO language VALUES (56, '', 'TableInsPlans', 'Date Effect.', 'Fecha Inicio', '', 'Data inizio', '', '', ''); INSERT INTO language VALUES (57, '', 'TableInsPlans', 'Date Term.', 'Fecha Finaliz.', '', 'Data di termine', '', '', ''); INSERT INTO language VALUES (78, '', 'ContrFamily', ' Delete Patient', ' Eliminar', '', ' Elimina Paziente', '', '', ''); INSERT INTO language VALUES (77, '', 'ContrFamily', ' Add Family Member', ' Agregar', '', ' Aggiungi', '', '', ''); INSERT INTO language VALUES (76, '', 'ContrFamily', ' Delete Plan', ' Eliminar Plan', '', ' Elimina Polizza', '', '', ''); INSERT INTO language VALUES (75, '', 'ContrFamily', ' Add Plan', ' Agregar Plan', '', ' Agg. Polizza', '', '', ''); INSERT INTO language VALUES (74, 'or Ital: Vedi maschere standard?', 'ContrFamily', 'View Templates', 'Ver Plantillas', '', 'Vedi Elenco', '', '', ''); INSERT INTO language VALUES (73, 'or Italian: Seleziona paziente', 'ContrFamily', ' Select Patient', ' Seleccionar Paciente', '', ' Scegli Paziente', '', '', ''); INSERT INTO language VALUES (70, '', 'FormMedical', 'Medical', 'Médico', '', 'Medico', '', '', ''); INSERT INTO language VALUES (71, '', 'All', 'OK', 'Ok', '', 'OK', '', '', ''); INSERT INTO language VALUES (72, '', 'All', 'Cancel', 'Cancelar', '', 'Annulla', '', '', ''); INSERT INTO language VALUES (80, '', 'ContrFamily', ' Move to Other Fam', ' Mover a Familia', '', ' Sposta ad altra fam.', '', '', ''); INSERT INTO language VALUES (81, '', 'All', 'Free Dental', 'Dental Free', '', 'Free Dental', '', '', ''); INSERT INTO language VALUES (82, '', 'ContrAppt', 'Today', 'Hoy', '', 'Oggi', '', '', ''); INSERT INTO language VALUES (83, '', 'ContrAppt', 'Week', 'Semana', '', 'Settimana', '', '', ''); INSERT INTO language VALUES (84, '', 'ContrAppt', ' Clear', ' Blanquear', '', ' Pulisci', '', '', ''); INSERT INTO language VALUES (85, '', 'ContrAppt', 'Appointment Note:', 'Notas de Citas', '', 'Nota appuntamento:', '', '', ''); INSERT INTO language VALUES (86, '', 'ContrAppt', 'Phone/Addr notes:', 'Notas Dir./Tlf.', '', 'Nota tel/indirizzo:', '', '', ''); INSERT INTO language VALUES (87, '', 'ContrAppt', 'Urgent medical notes:', 'Notas médicas urgentes', '', 'Note mediche urgenti:', '', '', ''); INSERT INTO language VALUES (88, '', 'ContrAppt', 'Appointment module notes:', 'Módulo de Citas', '', 'Note modulo appuntamenti:', '', '', ''); INSERT INTO language VALUES (89, '', 'All', 'Edit', '', '', 'Edita', '', '', ''); INSERT INTO language VALUES (90, '', 'ContrAppt', 'Select Patient', 'Seleccionar un paciente', '', 'Seleziona Paziente', '', '', ''); INSERT INTO language VALUES (91, '', 'ContrAppt', 'Unscheduled List', 'Lista no Programados', '', 'Elenco da rivedere', '', '', ''); INSERT INTO language VALUES (92, '', 'ContrAppt', 'Recall List', '', '', 'Elenco da richiamare', '', '', ''); INSERT INTO language VALUES (93, '', 'ContrAppt', 'Print Schedule', 'Programación de impresiones', '', 'Stampa Scheda', '', '', ''); INSERT INTO language VALUES (95, '', 'ContrFamily', 'Patient', '', '', 'Paziente', '', '', ''); INSERT INTO language VALUES (96, '', 'TableFamily', 'Family Members', '', '', 'Membri famiglia', '', '', ''); INSERT INTO language VALUES (97, '', 'TableFamily', 'Guar', 'Fiador', '', '', '', '', ''); INSERT INTO language VALUES (98, '', 'TableFamily', 'Name', 'Nombre', '', 'Nome', '', '', ''); INSERT INTO language VALUES (99, '', 'TableFamily', 'Position', 'Posición', '', 'Posizione', '', '', ''); INSERT INTO language VALUES (100, '', 'TableFamily', 'Gender', 'Género', '', 'Sesso', '', '', ''); INSERT INTO language VALUES (101, '', 'TableFamily', 'Status', 'Estatus', '', 'Stato civ.', '', '', ''); INSERT INTO language VALUES (102, '', 'TableFamily', 'Age', 'Edad', '', 'Età', '', '', ''); INSERT INTO language VALUES (103, '', 'ContrAppt', 'Delete Appointment?', '', '', 'Cancella appuntamento?', '', '', ''); INSERT INTO language VALUES (104, '', 'FormFreeDental', 'Warning! This version is not meant to be used for real data. It will stop working in a few months.', '', '', '', '', '', ''); INSERT INTO language VALUES (105, '', 'FormFreeDental', 'Trial period has ended. Closing Free Dental.', '', '', '', '', '', ''); INSERT INTO language VALUES (106, '', 'enum PatientStatus', 'Patient', '', '', '', '', '', ''); INSERT INTO language VALUES (107, '', 'enum PatientGender', 'Male', '', '', '', '', '', ''); INSERT INTO language VALUES (108, '', 'enum PatientPosition', 'Married', '', '', '', '', '', ''); INSERT INTO language VALUES (109, '', 'ContrFamily', 'Guar', '', '', '', '', '', ''); INSERT INTO language VALUES (110, '', 'enum PatientGender', 'Female', '', '', '', '', '', ''); INSERT INTO language VALUES (111, '', 'enum PatientPosition', 'Single', '', '', '', '', '', ''); INSERT INTO language VALUES (112, '', 'ContrFamily', 'Please select a plan first.', '', '', '', '', '', ''); INSERT INTO language VALUES (113, '', 'TableCoverage', 'Primary Insurance Plan', '', '', '', '', '', ''); INSERT INTO language VALUES (114, '', 'TableCoverage', 'Secondary Insurance Plan', '', '', '', '', '', ''); INSERT INTO language VALUES (115, '', 'FormPath', 'Export Path: for exporting tables. If you use a network path (like \\\\server\\FreeDentalExport\\ ), the data will be exported to one central computer. But it is usually easier to use a local path (like C:\\FreeDentalExport\\ ), and the data will be stored on the local hard drive of the computer you export on. The folder will be created later if it does not exist.', '', '', '', '', '', ''); INSERT INTO language VALUES (116, '', 'FormPath', 'Document Path: for storing images of documents. This path is the same for every computer, and there can be only be one folder. If you have only one computer, then the folder can be local (like C:\\FreeDentalData\\ ), otherwise it should be a folder shared on the network (like \\\\server\\FreeDentalData\\ ). It must contain the A - Z folders. ', '', '', '', '', '', ''); INSERT INTO language VALUES (117, '', 'FormPath', 'Document Path is not valid.', '', '', '', '', '', ''); INSERT INTO language VALUES (118, '', 'FormQuery', 'Select Folder to Save File To', '', '', '', '', '', ''); INSERT INTO language VALUES (120, '', 'enum PatientStatus', 'Non-patient', '', '', '', '', '', ''); INSERT INTO language VALUES (121, '', 'enum PatientPosition', 'Child', '', '', '', '', '', ''); INSERT INTO language VALUES (122, '', 'TablePatient', 'Credit Type', '', '', '', '', '', ''); INSERT INTO language VALUES (123, '', 'TablePatient', 'Recall Months', '', '', '', '', '', ''); INSERT INTO language VALUES (124, '', 'TablePatient', 'Billing Type', '', '', '', '', '', ''); INSERT INTO language VALUES (125, '', 'FormApptsOther', 'Appointments for', '', '', '', '', '', ''); INSERT INTO language VALUES (126, '', 'FormFreeDental', 'Msg', '', '', '', '', '', ''); INSERT INTO language VALUES (127, '', 'ContrFamily', 'Delete Patient?', '', '', '', '', '', ''); INSERT INTO language VALUES (128, '', 'ContrFamily', 'Make the selected patient the guarantor?', '', '', '', '', '', ''); INSERT INTO language VALUES (129, '', 'ContrFamily', 'Patient is already the guarantor. Please select a different family member.', '', '', '', '', '', ''); INSERT INTO language VALUES (130, '', 'ProcCodes', 'code not found: ', '', '', '', '', '', ''); INSERT INTO language VALUES (131, '', 'FormPrntScrn', 'Select Folder to Save Image To', '', '', '', '', '', ''); INSERT INTO language VALUES (132, '', 'ContrFamily', 'Delete Plan?', '', '', '', '', '', ''); INSERT INTO language VALUES (133, '', 'FormFreeDental', 'Staff', '', '', '', '', '', ''); INSERT INTO language VALUES (134, '', 'ContrFamily', 'Moving the guarantor will cause two families to be combined. The financial notes for both families will be combined and may need to be edited. The address notes will also be combined and may need to be edited. Do you wish to continue?', '', '', '', '', '', ''); INSERT INTO language VALUES (135, '', 'ContrFamily', 'Select the family to move this patient to from the list that will come up next.', '', '', '', '', '', ''); INSERT INTO language VALUES (136, '', 'ContrFamily', 'You can not delete the guarantor if there are other family members. You would have to make a different family member the guarantor first.', '', '', '', '', '', ''); INSERT INTO language VALUES (137, '', 'ContrFamily', 'You can not move the guarantor. If you wish to move the guarantor, you must make another family member the guarantor first.', '', '', '', '', '', ''); INSERT INTO language VALUES (138, '', 'ContrFamily', 'You can not delete a patient with a balance.', '', '', '', '', '', ''); INSERT INTO language VALUES (139, '', 'ContrFamily', 'Not allowed to delete a plan that is in use by patients.', '', '', '', '', '', ''); INSERT INTO language VALUES (140, '', 'ContrFamily', 'Not allowed to delete a plan with existing claims.', '', '', '', '', '', ''); INSERT INTO language VALUES (141, '', 'ContrFamily', 'No insurance dependencies detected. Preparing to move family member. Financial notes and address notes will not be transferred. Proceed to next step?', '', '', '', '', '', ''); INSERT INTO language VALUES (142, '', 'ContrFamily', 'Create new family instead of moving to an existing family?', '', '', '', '', '', ''); INSERT INTO language VALUES (143, '', 'ContrFamily', 'Patient has insurance that has existing claims for other family members. Please see the manual for instructions.', '', '', '', '', '', ''); INSERT INTO language VALUES (144, '', 'ContrFamily', 'Patient has insurance that is in use by other family memebers. Please see the manual for instructions.', '', '', '', '', '', ''); INSERT INTO language VALUES (145, '', 'FormFreeDental', 'Warning! This version is not meant to be used for real data. It will stop working on August 25,2003.', '', '', '', '', '', ''); INSERT INTO language VALUES (146, '', 'FormPath', 'Invalid Document path. Closing Free Dental.', '', '', '', '', '', ''); INSERT INTO language VALUES (147, '', 'FormApptsOther', 'Please select appointment first.', '', '', '', '', '', ''); INSERT INTO language VALUES (148, '', 'FormApptsOther', 'Unable to go to unscheduled appointment.', '', '', '', '', '', ''); INSERT INTO language VALUES (149, '', 'FormApptsOther', 'Do you really want to move a previously scheduled appointment?', '', '', '', '', '', ''); INSERT INTO language VALUES (150, '', 'TimeCard', 'TimeCard', '', '', '', '', '', ''); INSERT INTO language VALUES (151, '', 'TableTimeCard', 'LogIn', '', '', '', '', '', ''); INSERT INTO language VALUES (152, '', 'TableTimeCard', 'LogOut', '', '', '', '', '', ''); INSERT INTO language VALUES (153, '', 'TableTimeCard', 'Estimated Hours', '', '', '', '', '', ''); INSERT INTO language VALUES (154, '', 'TableTimeCard', 'Notes', '', '', '', '', '', ''); INSERT INTO language VALUES (155, '', 'TablePatient', 'ABC0', '', '', '', '', '', ''); # -------------------------------------------------------- # # Table structure for table `ledger` # DROP TABLE IF EXISTS ledger; CREATE TABLE ledger ( PatNum mediumint(8) unsigned NOT NULL default '0', PatName varchar(100) NOT NULL default '', c90 double NOT NULL default '0', p90 double NOT NULL default '0', c6090 double NOT NULL default '0', p6090 double NOT NULL default '0', c3060 double NOT NULL default '0', p3060 double NOT NULL default '0', c030 double NOT NULL default '0', p030 double NOT NULL default '0', InsEst double NOT NULL default '0' ) TYPE=MyISAM; # # Dumping data for table `ledger` # # -------------------------------------------------------- # # Table structure for table `patient` # DROP TABLE IF EXISTS patient; CREATE TABLE patient ( PatNum mediumint(8) unsigned NOT NULL auto_increment, LName varchar(100) NOT NULL default '', FName varchar(100) NOT NULL default '', MiddleI varchar(100) NOT NULL default '', Preferred varchar(100) NOT NULL default '', PatStatus tinyint(3) unsigned NOT NULL default '0', Gender tinyint(3) unsigned NOT NULL default '0', Position tinyint(3) unsigned NOT NULL default '0', Birthdate date NOT NULL default '0000-00-00', SSN varchar(9) NOT NULL default '', Address varchar(100) NOT NULL default '', Address2 varchar(100) NOT NULL default '', City varchar(50) NOT NULL default '', State char(2) NOT NULL default '', Zip varchar(10) NOT NULL default '', HmPhone varchar(30) NOT NULL default '', WkPhone varchar(30) NOT NULL default '', WirelessPhone varchar(30) NOT NULL default '', Guarantor mediumint(8) unsigned NOT NULL default '0', CreditType char(1) NOT NULL default '', Email varchar(100) NOT NULL default '', Salutation varchar(100) NOT NULL default '', PriPlanNum mediumint(8) unsigned NOT NULL default '0', PriRelationship tinyint(3) unsigned NOT NULL default '0', SecPlanNum mediumint(8) unsigned NOT NULL default '0', SecRelationship tinyint(3) unsigned NOT NULL default '0', EstBalance double NOT NULL default '0', NextAptNum mediumint(8) NOT NULL default '0', PriProv smallint(5) unsigned NOT NULL default '0', SecProv smallint(5) unsigned NOT NULL default '0', FeeSched smallint(5) unsigned NOT NULL default '0', BillingType smallint(5) unsigned NOT NULL default '0', RecallInterval tinyint(4) NOT NULL default '0', RecallStatus smallint(5) unsigned NOT NULL default '0', ImageFolder varchar(100) NOT NULL default '', FamAddrNote text NOT NULL, FamFinUrgNote varchar(255) NOT NULL default '', MedUrgNote varchar(255) NOT NULL default '', ApptModNote varchar(255) NOT NULL default '', StudentStatus char(1) NOT NULL default '', SchoolName varchar(30) NOT NULL default '', ChartNumber varchar(20) NOT NULL default '', PRIMARY KEY (PatNum) ) TYPE=MyISAM; # # Dumping data for table `patient` # # -------------------------------------------------------- # # Table structure for table `patientnote` # DROP TABLE IF EXISTS patientnote; CREATE TABLE patientnote ( PatNum mediumint(8) unsigned NOT NULL default '0', FamFinancial text NOT NULL, ApptPhone text NOT NULL, Medical text NOT NULL, Service text NOT NULL, PRIMARY KEY (PatNum) ) TYPE=MyISAM; # # Dumping data for table `patientnote` # # -------------------------------------------------------- # # Table structure for table `payment` # DROP TABLE IF EXISTS payment; CREATE TABLE payment ( PayNum mediumint(8) unsigned NOT NULL auto_increment, PayType tinyint(3) unsigned NOT NULL default '0', PayDate date NOT NULL default '0000-00-00', PayAmt double NOT NULL default '0', CheckNum varchar(25) NOT NULL default '', BankBranch varchar(25) NOT NULL default '', PayNote varchar(255) NOT NULL default '', IsSplit tinyint(1) unsigned NOT NULL default '0', PatNum mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (PayNum) ) TYPE=MyISAM; # # Dumping data for table `payment` # # -------------------------------------------------------- # # Table structure for table `paysplit` # DROP TABLE IF EXISTS paysplit; CREATE TABLE paysplit ( SplitNum mediumint(8) unsigned NOT NULL auto_increment, SplitAmt double NOT NULL default '0', PatNum mediumint(8) unsigned NOT NULL default '0', ProcDate date NOT NULL default '0000-00-00', PayNum mediumint(8) unsigned NOT NULL default '0', IsDiscount tinyint(1) unsigned NOT NULL default '0', DiscountType tinyint(3) unsigned NOT NULL default '0', ProvNum smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (SplitNum) ) TYPE=MyISAM; # # Dumping data for table `paysplit` # # -------------------------------------------------------- # # Table structure for table `preference` # DROP TABLE IF EXISTS preference; CREATE TABLE preference ( PrefName varchar(255) NOT NULL default '', ValueString varchar(255) NOT NULL default '', PRIMARY KEY (PrefName) ) TYPE=MyISAM; # # Dumping data for table `preference` # INSERT INTO preference VALUES ('DataBaseVersion', '1.0.1.2'); INSERT INTO preference VALUES ('ScannerCompression', '40'); INSERT INTO preference VALUES ('DocPath', '\\\\SERVER\\FreeDentalData\\'); INSERT INTO preference VALUES ('ExportPath', 'C:\\FreeDentalExports\\'); INSERT INTO preference VALUES ('PracticeTitle', ''); INSERT INTO preference VALUES ('PracticeAddress', ''); INSERT INTO preference VALUES ('PracticeAddress2', ''); INSERT INTO preference VALUES ('PracticeCity', ''); INSERT INTO preference VALUES ('PracticeST', ''); INSERT INTO preference VALUES ('PracticeZip', ''); INSERT INTO preference VALUES ('PracticePhone', ''); INSERT INTO preference VALUES ('PracticeBankNumber', ''); INSERT INTO preference VALUES ('PracticeDefaultProv', '1'); INSERT INTO preference VALUES ('PracticeDefaultBillType', '40'); INSERT INTO preference VALUES ('RecallDaysPast', ''); INSERT INTO preference VALUES ('RecallDaysFuture', ''); INSERT INTO preference VALUES ('RecallPattern', '//XX/'); INSERT INTO preference VALUES ('RecallProcedures', 'D0120,D1110,D1204'); INSERT INTO preference VALUES ('RecallBW', 'D0274'); INSERT INTO preference VALUES ('StatementShowCreditCard', '1'); INSERT INTO preference VALUES ('CropDelta', '.035'); INSERT INTO preference VALUES ('TreatmentPlanNote', 'If you have dental insurance, please be aware that THIS IS AN ESTIMATE ONLY. Coverage may be different if your deductible has not been met, annual maximum has been met, or if your coverage table is lower than average.'); # -------------------------------------------------------- # # Table structure for table `procedurecode` # DROP TABLE IF EXISTS procedurecode; CREATE TABLE procedurecode ( ADACode varchar(6) NOT NULL default '', Descript varchar(255) NOT NULL default '', AbbrDesc varchar(50) NOT NULL default '', ProcTime varchar(24) NOT NULL default '/X/', ProcCat tinyint(3) unsigned NOT NULL default '0', TreatArea tinyint(3) unsigned NOT NULL default '0', RemoveTooth tinyint(1) unsigned NOT NULL default '0', SetRecall tinyint(1) unsigned NOT NULL default '0', NoBillIns tinyint(1) unsigned NOT NULL default '0', IsProsth tinyint(1) unsigned NOT NULL default '0', DefaultNote text NOT NULL, IsHygiene tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (ADACode) ) TYPE=MyISAM; # # Dumping data for table `procedurecode` # INSERT INTO procedurecode VALUES ('D0120', 'Periodic Oral Evaluation', 'PerEx', '/X/', 73, 3, 0, 1, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0140', 'Limited Oral Evaluation-Problem Focused', 'LimEx', '/X/', 73, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0150', 'Comprehensive Oral Evaluation', 'CmpEx', '/XX/', 73, 3, 0, 1, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0160', 'Detailed and Extensive oral Evaluation-Problem Focused, By Report', 'DetailedEval', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0170', 'Re-evaluation - Limited, Problem Focused', 'ReEval', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0180', 'Comprehensive Periodontal Examination (New or Established Client)', 'CompPerioEval', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0210', 'Intraoral - Full Mouth X-rays (Including Bitewings)', 'FMX', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0220', 'Intraoral - 1 Periapical X-ray, First Film', 'PA', '/', 73, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0230', 'Intraoral - Additional Periapical X-ray', 'PA+', '/', 73, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0240', 'Intraoral - Occlusal X-ray', 'OcclusalX', '/', 86, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0250', 'Extraoral - First Film', 'ExtraOr1', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0260', 'Extraoral - Each Additional Film', 'ExtraOrX+', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0270', '1 Bitewing X-ray', '1BW', '/', 73, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0272', '2 Bitewing X-rays', '2BW', '/', 73, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0274', '4 Bitewing X-rays', '4BW', '//', 73, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0277', 'Vertical Bitewings - 7 To 8 Films', 'VertBW7-8', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0290', 'A-P or Lateral Skull & Facial X-ray', 'SurvXray', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0310', 'Sialography', 'Sialo', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0320', 'TMJ Joint Arthrogram, including injection', 'TMJArthrIninj', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0321', 'Other TMJ Films, By Report', 'OtherTMJX', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0330', 'Panoramic X-ray', 'Pano', '//', 73, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0340', 'Cephalometric Film', 'Cephalo', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0350', 'Oral/Facial Images (Included Intra and Extraoral Images)', 'OralFacimage', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0415', 'Microscopic Examination', 'MicroEx', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0425', 'Caries susceptibility tests', 'CariesTest', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0460', 'Pulp Vitality Test', 'PulpVital', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0470', 'Diagnostic Casts', 'DiagnCast', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0472', 'Accession of Tissue, Gross Examination, Preparation and Transmission of Written Report', 'AccessTissGrEx', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0473', 'Accession of Tissue, Gross and Microscopic Examination, Preparation and Transmission of Written Report', 'AccessTissGrMicrEx', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0474', 'Accession of Tissue, Gross Examination, Including Assessment of Surgical Margins for Presence of Disease, Preparation and Transmission of Written Report', 'AccessTissGrExInSurg', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0480', 'Processing and Interpretation of Cytologic Smears, Including Preparation and Transmission of Written Report', 'ProInterOytoSm', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0502', 'Other Oral Pathology Procedures, By Report', 'OtherPath', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D0999', 'Unspecified Diagnostic Procedure, By Report', 'UnspecDiagn', '/X/', 73, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1110', 'Cleaning-Adult (Transitional or Permanent Teeth)', 'Pro', '/XX/', 74, 3, 0, 1, 0, 0, '', 1); INSERT INTO procedurecode VALUES ('D1120', 'Cleaning-Child (Primary or Transitional Teeth)', 'ProChild', '/X/', 74, 3, 0, 1, 0, 0, '', 1); INSERT INTO procedurecode VALUES ('D1201', 'Topical Fluoride Including Prophy-Child', 'ProFloChild', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1203', 'Fluoride Topical Excluding Prophy-Child', 'FloChild', '/', 74, 3, 0, 0, 0, 0, '', 1); INSERT INTO procedurecode VALUES ('D1204', 'Fluoride Topical Excluding Prophy-Adult', 'Flo', '/', 74, 3, 0, 0, 0, 0, '', 1); INSERT INTO procedurecode VALUES ('D1205', 'Topical Fluoride Including Prophy-Adult', 'ProFlo', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1310', 'Nutritional Counseling for Control of Dental Disease', 'NutriCnsl', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1320', 'Tobacco Counseling', 'TobacoCnsl', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1330', 'Oral Hygiene Instruction', 'OralHygIn', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1351', 'Sealant (per tooth)', 'Seal', '/X/', 75, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1510', 'Space Maintainer-Fixed-Unilateral', 'BandLoop', '/XX/', 83, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1515', 'Space Maintainer-Fixed-Bilateral', 'SpMFxBi', '/XX/', 83, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1520', 'Space Maintainer-Removable-Unilateral', 'SpMRemUni', '/X/', 86, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1525', 'Space Maintainer-Removable-Bilateral', 'SpMRemBil', '/X/', 86, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D1550', 'Recementation of Space Maintainer', 'Recement', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2140', 'Amalgam-One Surface, Primary or Permanent', 'A1', '/X/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2150', 'Amalgam-Two Surfaces, Primary or Permanent', 'A2', '/XX/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2160', 'Amalgam-Three Surfaces, Primary or Permanent', 'A3', '/XXX/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2161', 'Amalgam-Four or More Surfaces, Primary or Permanent', 'A4', '/XXXX/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2330', 'Composite 1 Surface-Anterior', 'C1', '/X/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2331', 'Composite 2 Surfaces-Anterior', 'C2', '/XX/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2332', 'Composite 3 Surfaces-Anterior', 'C3', '/XXX/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2335', 'Composite 4 Or More Surfaces-Anterior', 'C4', '/XXXX/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2390', 'Composite Resin Crown-Anterior', 'CresCn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2391', 'Composite 1 Surface-Posterior', 'C1(P)', '/X/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2392', 'Composite 2 Surfaces-Posterior', 'C2(P)', '/XX/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2393', 'Composite 3 Surfaces-Posterior', 'C3(P)', '/XXX/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2394', 'Composite 4 Or More Surfaces-Posterior', 'C4(P)', '/XXXX/', 75, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2410', 'Gold Foil 1 Surface', 'GoldFoil1', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2420', 'Gold Foil 2 Surfaces', 'GoldFoil2', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2430', 'Gold Foil 3 Surfaces', 'GoldFoil3', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2510', 'Inlay-Metallic-1 Surface', 'InlayMet1', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2520', 'Inlay-Metallic-2 Surfaces', 'InlayMet2', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2530', 'Inlay-Metallic-3 Surfaces', 'InlayMet3', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2542', 'Onlay-Metallic-2 Surfaces', 'OnlayMet2', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2543', 'Onlay-Metallic-3 Surfaces', 'OnlayMet3', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2544', 'Onlay-Metallic-4 or More Surfaces', 'OnlayMet4', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2610', 'Inlay-Porcelain/Ceramic-1 Surface', 'Cerinlay1', '//XXX/', 79, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2620', 'InLay-Porcelain/Ceramic-2 Surfaces', 'Cerinlay2', '///XXXX/', 79, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2630', 'Inlay-Porcelain/Ceramic-3 Surfaces', 'Cerinlay3', '///XXXX/', 79, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2642', 'Onlay-Porcelain/Ceramic-2 Surfaces', 'CerOnlay2', '///XXXX/', 86, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2643', 'Onlay-Porcelain/Ceramic-3 Surfaces', 'CerOnlay3', '///XXXX/', 86, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2644', 'Onlay-Porcelain/Ceramic-4 or More Surfaces', 'CerOnlay4', '///XXXXX/', 86, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2650', 'Inlay-Composite/Resin-1 Surface', 'InCRs1Lb', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2651', 'Inlay-Composite/Resin-2 Surfaces', 'InCRs2Lb', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2652', 'Inlay-Composite/Resin-3 Surfaces', 'InCRs3Lb', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2662', 'Onlay-Composite/Resin-2 Surfaces', 'OnCRs2S', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2663', 'Onlay-Composite/Resin-3 Surfaces', 'OnCRs3S', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2664', 'Onlay-Composite/Resin-4 or More Surfaces', 'OnCRs4+S', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2710', 'Crown-Resin-Indirect (Fiber, Porcelain, or Ceramic Reinforced Polymer)', 'CrnRsLb', '/X/', 87, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2720', 'Crown-Resin with High Noble Metal', 'CrnRsHN', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2721', 'Crown-Resin with Predominantly Base Metal', 'CrnRsBm', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2722', 'Crown-Resin with Noble Metal', 'CrnRsNm', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2740', 'Crown-All Porcelain/Ceramic', 'AllCerCrn', '/XXXXXXX/', 81, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2750', 'Crown-Porcelain Fused to High Noble Metal', 'PFM', '/XXXX/////', 81, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2751', 'Crown-Porcelain Fused to Predominantly Base Metal', 'CrnPrFBm', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2752', 'Crown-Porcelain Fused to Noble Metal', 'CrnPrFNm', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2780', 'Crown-3/4 Cast High Noble Metal', '3/4HiNobl', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2781', 'Crown-3/4 Cast Predominantly Base Metal', '3/4BaseM', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2782', 'Crown-3/4 Cast Noble Metal', '3/4Noble', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2783', 'Crown-3/4 Porcelain/Ceramic', '3/4Porc', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2790', 'Crown-Full Cast High Noble Metal', 'FGCrn', '/XXXX/////', 81, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2791', 'Crown-Full Cast Predominantly Base Metal', 'CrnFlcBm', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2792', 'Crown-Full Cast Noble Metal', 'CrnFlcNm', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2799', 'Provisional Crown (Interim Restoration Of At Least 6 Months)', 'ProvisCn', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2910', 'Recement Inlay', 'RecemInly', '/XXX/', 86, 1, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2920', 'Recement Crown', 'RecemCn', '/XX/', 81, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2930', 'Prefabricated Stainless Steel Crown-Primary Tooth', 'SSCPri', '/XXX/', 81, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2931', 'Prefabricated Stainless Steel Crown-Permanent Tooth', 'SSCPer', '/XXX/', 81, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2932', 'Prefabricated Resin Crown', 'PrFbRsCrn', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2933', 'Prefabricated Stainless Steel Crown with Resin Window', 'PrFbScRsW', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2940', 'Sedative Filling', 'SedFill', '/X/', 75, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2950', 'Core Build Up, Including Any Pins', 'BU', '/XX/', 75, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2951', 'Pin Retention-Per Tooth, In Addition to Restoration', 'Pin', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2952', 'Cast Post and Core in Addition to Crown', 'CastP&C', '/XX/', 75, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2953', 'Each Additional Cast Post - Same Tooth', 'AdditCastPost', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2954', 'Prefabricated Post and Core in Addition to Crown', 'P&C', '/XX/', 75, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2955', 'Post Removal (not in conjunction with endodontic therapy)', 'PostRemov', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2957', 'Each Additional Prefabricated Post - Same Tooth', 'AdditPost', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2960', 'Labial Veneer (resin laminate)-Chairside', 'CmpVnr', '/XXXXX/', 79, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2961', 'Labial Veneer (resin laminate)-Laboratory', 'CmpVnrLb', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2962', 'Labial Veneer (porcelain laminate)-Laboratory', 'PorcVnr', '/XXXX/', 79, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2970', 'Temporary Crown (fractured tooth)', 'TempCrn', '/X////', 81, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2980', 'Crown Repair, by Report', 'CrnRepair', '/X/', 81, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D2999', 'Unspecified Restorative Procedure, by Report', 'UnspecRestor', '/X/', 75, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3110', 'Pulp Cap - Direct (excluding final restoration)', 'PulpCap', '/X/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3120', 'Pulp Cap - Indirect (excluding final restoration)', 'PulpCapIn', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3220', 'Therapeutic Pulpotomy (excluding final restoration)', 'Pulpotomy', '/XX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3221', 'Pulpal Debridement-Primary and Permanent Teeth', 'PulpDebr', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3230', 'Root Canal, (resorbable filling) - Anterior, Primary Tooth (excluding final restoration)', 'PulpThA/Pr', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3240', 'Root Canal, (resorbable filling) - Posterior, Primary Tooth (excluding final restoration)', 'PulpThP/Pr', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3310', 'Root Canal, Anterior', 'RCTAnt', '/XXXX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3320', 'Root Canal, Bicuspid', 'RCTPre', '/XXXXX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3330', 'Root Canal, Molar', 'RCTMol', '/XXXXXXX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3331', 'Treatment of Root Canal Obstruction; Non-Surgical Access', 'RCObstr', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3332', 'Incomplete Endodontic Therapy; Inoperable or Fractured Tooth', 'IncmpRCT', '/XX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3233', 'Internal Root Repair of Perforation Defects (Not Iatrogenic by Provider Filing Claim)', 'InternRRepair', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3346', 'Retreatment-Anterior', 'RCT-RAnt', '/XXXXX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3347', 'Retreatment-Bicuspid', 'RCT-RBi', '/XXXXXXX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3348', 'Retreatment-Molar', 'RCT-RMol', '/XXXXXXXX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3351', 'Apexification/Recalcification-Initial Visit', 'Apexif', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3352', 'Apexification/Recalcification-Interim Visit', 'ApxRclIn', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3353', 'Apexification/Recalcification-Final Visit', 'ApxRcFin', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3410', 'Apicoectomy/Periradicular Surgery-Anterior', 'ApctPrSrA', '/XXXXXX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3421', 'Apicoectomy/Periradicular Surgery-Bicuspid (first root)', 'ApctPr+th', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3425', 'Apicoectomy/Periradicular Surgery-Molar (first root)', 'ApctPrMol', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3426', 'Apicoectomy/Periradicular Surgery (each additional root)', 'ApctPr+th', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3430', 'Retrograde Filling-Per Root', 'RetroFill', '/XX/', 86, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3450', 'Root Amputation-Per Root', 'RtAmp', '/XX/', 86, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3460', 'Endodontic Endosseous Implant', 'EndoEdsIm', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3470', 'Intentional Replantation (Including Necessary Splinting)', 'IntRplISp', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3910', 'Surgical Procedure for Isolation of Tooth with Rubber Dam', 'SurgIs/RD', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3920', 'Hemisection (including any root removal, not root canal)', 'Hemi', '/XX/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3950', 'Canal Preparation For Post', 'CanPrepPt', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D3999', 'Unspecified Endodontic Procedure, by Report', 'UnspecEndo', '/X/', 76, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4210', 'Gingivectomy/plasty-Four or More Contiguous Teeth or Bounded Teeth Spaces', 'GingivQdr', '/X/', 87, 4, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4211', 'Gingivectomy/plasty-One to Three Teeth, per Quadrant', 'Gingiv', '/X/', 77, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4240', 'Gingival Flap Procedure, Including Root Planing-Four or More Contiguous Teeth or Bounded Teeth Spaces', 'GnFlInRtp4+', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4241', 'Gingival Flap Procedure, Including Root Planing-One to Three Teeth, per Quadrant', 'GnFlInRtp1-3', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4245', 'Apically Positioned Flap', 'ApicFlap', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4249', 'Crown Lengthening-Hard Tissue', 'CrnLength', '/XXXXXX/', 77, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4250', 'Mucogingival Surgery-per Quadrant', 'MucGinSrQ', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4260', 'Osseous Surgery-Four or More Contiguous Teeth or Bounded Teeth Spaces', 'OssSurgQ', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4261', 'Osseous Surgery-One to Three Teeth, per Quadrant', 'OssSurg1-2', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4263', 'Bone Replacement Graft-First Site in Quadrant', 'BnRpGr1st', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4264', 'Bone Replacement Graft-Each Additional Site in Quadrant', 'BnRpGrEa1+', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4265', 'Biologic Materials to Aid in Soft and Osseous Tissue Regeneration', 'BioMatSftOTissReg', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4266', 'Guided Tissue Regeneration-Resorbable Barrier, Per Site', 'TissRgPer', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4267', 'Guided Tissue Regeneration-Non-resorbable Barrier, Per Site, Per Tooth', 'TissRgNr', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4268', 'Surgical Revision Procedure, Per Tooth', 'SurgRevis', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4270', 'Pedicle Soft Tissue Graft Procedure', 'PedSfTsGr', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4271', 'Free Soft Tissue Graft Procedure', 'FrSfTsGr', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4273', 'Subepithelial Connective Tissue Graft', 'SubTsGr', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4274', 'Distal or Proximal Wedge Procedure', 'DistPxWg', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4275', 'Soft Tissue Allograft', 'SfTsAll', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4276', 'Combined Connective Tissue and Double Pedicle Graft', 'ComConTissDPGr', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4320', 'Provisional Splint-Intracoronal', 'ProSplIn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4321', 'Provisional Splint-Extracoronal', 'ProSplEx', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4341', 'Periodontal Scaling and Root Planing-Four or More Contiguous Teeth or Bounded Teeth Spaces', 'SRP', '/XXXXXX/', 77, 4, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4342', 'Periodontal Scaling and Root Planing-One to Three Teeth, per Quadrant', 'SRP1-3', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4355', 'Full Mouth Debridement to Enable Comprehensive Periodontal Evaluation and Diagnosis', 'FullDebrd', '/XXX/', 77, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4381', 'Localized Delivery of Chemotherapeutic Agents Via A Controlled Release Vehicle', 'Arestin', '/X/', 77, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4910', 'Periodontal Maintenance, Following Active Therapy (Surgical or Non-Surgical)', 'PerioMaint', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4920', 'Unscheduled Dressing Change (Other Than Treating Dentist)', 'UnscDrChg', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D4999', 'Unspecified Periodontal Procedure, by Report', 'UnspecPerio', '/X/', 77, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5110', 'Complete Upper Denture', 'MaxDent', '/XXX/', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5120', 'Complete Lower Denture', 'MandDent', '/XXX/', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5130', 'Immediate-Complete Upper Denture', 'MaxImmDent', '/XXX/', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5140', 'Immediate-Complete Lower Denture', 'MandImmDent', '/XXX/', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5211', 'Upper Partial Denture - Resin', 'PermMaxFlip', '/XX/', 78, 7, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5212', 'Lower Partial Denture - Resin', 'PermMandFlip', '/XX/', 78, 7, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5213', 'Upper Partial Denture - Cast Metal With Resin Denture Base', 'MaxRPD', '/XXXX/', 78, 7, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5214', 'Lower Partial Denture - Cast Metal With Resin Denture Base', 'MandRPD', '/XXXX/', 78, 7, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5281', 'Removable Unilateral Partial Denture - One Piece Cast Metal', 'RmvUniPDn', '/X/', 87, 7, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5410', 'Adjust Complete Upper Denture', 'AdjCmDnMax', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5411', 'Adjust Complete Lower Denture', 'AdjCmDnMand', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5421', 'Adjust Partial Denture Upper', 'AdjPrDnMax', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5422', 'Adjust Partial Denture Lower', 'AdjPrDnMand', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5510', 'Repair Broken Complete Denture Base', 'RepairDent', '/XX/', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5520', 'Replace Missing or Broken Teeth-Complete Denture (each tooth)', 'RplThCmDn', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5610', 'Partial Denture Repair, Resin Base', 'ReprFlip', '/XX/', 78, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5620', 'Partial Denture Repair, Cast Framework', 'RprRPDFm', '/XX/', 78, 7, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5630', 'Partial Denture Repair or Replace Broken Clasp', 'RepClsp', '/X/', 78, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5640', 'Partial Denture Replace Broken Teeth, Per Tooth', 'RepBrkTh', '/X/', 78, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5650', 'Add Tooth To Existing Partial Denture', 'AddTooth', '/X/', 78, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5660', 'Add Clasp To Existing Partial Denture', 'AddClasp', '/X/', 78, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5670', 'Replace All Teeth and Acrylic on Cast Metal Framework (Maxillary)', 'ReTh&AcryMaxRPD', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5671', 'Replace All Teeth and Acrylic on Cast Metal Framework (Mandibular)', 'ReTh&AcryMandRPD', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5710', 'Rebase Complete Upper Denture', 'RebsComMaxDn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5711', 'Rebase Complete Lower Denture', 'RebsComMandDn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5720', 'Rebase Upper Partial Denture', 'RebsRPDMaxDn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5721', 'Rebase Lower Partial Denture', 'RebsRPDMandDn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5730', 'Reline Complete Upper Denture (chairside)', 'RelMaxDntChair', '/XXX/////', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5731', 'Reline Complete Lower Denture (chairside)', 'RelMandDntChair', '/XXX/////', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5740', 'Reline Upper Partial Denture (chairside)', 'RelMaxRPDChair', '/XXX////', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5741', 'Reline Lower Partial Denture (chairside)', 'RelMandRPDChair', '/XXX///', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5750', 'Reline Complete Upper Denture (lab)', 'RelMaxDnLab', '/XX/', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5751', 'Reline Complete Lower Denture (lab)', 'RelMandDnLab', '/XX/', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5760', 'Reline Upper Partial Denture (lab)', 'RelMaxRPDLab', '/XX/', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5761', 'Reline Lower Partial Denture (lab)', 'RelMandRPDLab', '/XX/', 78, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5810', 'Interim Complete Denture Upper', 'TempCompMaxDn', '/X/', 87, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5811', 'Interim Complete Denture Lower', 'TempCompMandDn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5820', 'Interim Partial Denture Upper', 'TempMaxFlip', '/X/', 78, 7, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5821', 'Interim Partial Denture Lower', 'TempMandFlip', '/X/', 78, 7, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5850', 'Tissue Conditioning, Upper', 'TisConMax', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5851', 'Tissue Conditioning, Lower', 'TisConMand', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5860', 'Overdenture-Complete, by Report', 'OverDent', '/XXX/', 86, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5861', 'Overdenture-Partial, by Report', 'OverDentRPD', '/XXX/', 86, 6, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5862', 'Precision Attachment, by Report', 'DentAttach', '/XXX/', 78, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5867', 'Replacement of Replaceable Part of Semi-Precision Attachment (Male or Female Component)', 'ReplaceAttach', '/XX/', 78, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5875', 'Modification of Removable Prosthesis Following Implant Surgery', 'ModRmvProAftImpSurg', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5899', 'Unspecified Removable Prosthodontic Procedure, by Report', 'UnspecDent', '/X/', 78, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5911', 'Facial Moulage (sectional)', 'SecFacMoul', '/X/', 87, 3, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5912', 'Facial Moulage (complete)', 'CompFacMoul', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5913', 'Nasal Prosthesis', 'NasPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5914', 'Auricular Prosthesis', 'AurPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5915', 'Orbital Prosthesis', 'OrbPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5916', 'Ocular Prosthesis', 'OcuPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5919', 'Facial Prosthesis', 'FacPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5922', 'Nasal Septal Prosthesis', 'NasSepPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5923', 'Ocular Prosthesis, Interim', 'TempOcuPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5924', 'Cranial Prosthesis', 'CranPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5925', 'Facial Augmentation Implant Prosthesis', 'FacAugImp', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5926', 'Nasal Prosthesis, Replacement', 'NasProsRep', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5927', 'Auricular Prosthesis, Replacement', 'AurProsRep', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5928', 'Orbital Prosthesis, Replacement', 'OrbProsRep', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5929', 'Facial Prosthesis, Replacement', 'FacProsRep', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5931', 'Obturator Prosthesis, Surgical', 'ObtProsSur', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5932', 'Obturator Prosthesis, Definitive', 'ObtProsDef', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5933', 'Obturator Prosthesis, Modification', 'ObtProsMod', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5934', 'Mandibular Resection Prosthesis with Guide Flange', 'MandResFla', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5935', 'Mandibular Resection Prosthesis without Guide Flange', 'MandRec', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5936', 'Obturator Prosthesis, Interim', 'ObtProsInt', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5937', 'Trismus Appliance (not for TMD treatment)', 'TrisAppli', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5951', 'Feeding Aid', 'FeedAid', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5952', 'Speech Aid Prosthesis, Pediatric', 'SpchAidPd', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5953', 'Speech Aid Prosthesis, Adult', 'SpchAidAd', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5954', 'Palatal Augmentation Prosthesis', 'PalAugPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5955', 'Palatal Lift Prosthesis, Definitive', 'PiLftProsDf', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5958', 'Palatal Lift Prosthesis, Interim', 'PiLftProsIn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5959', 'Palatal Lift Prosthesis, Modification', 'PiLftProsMod', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5960', 'Speech Aid Prosthesis, Modification', 'SpchAdProsMod', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5982', 'Surgical Stent', 'SurgStent', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5983', 'Radiation Carrier', 'RadtnCarr', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5984', 'Radiation Shield', 'RadtnShld', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5985', 'Radiation Cone Locator', 'RadtnCnLc', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5986', 'Fluoride Gel Carrier', 'FlrGelCarr', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5987', 'Commissure Splint', 'CommSplnt', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5988', 'Surgical Splint', 'SurgSplnt', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D5999', 'Unspecified Maxillofacial Prosthesis, by Report', 'UnspecMaxPros', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6010', 'Surgical Placement of Implant Body:   Endosteal Implant', 'SurgImpEnd', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6020', 'Abutment Placement or Substitution:   Endosteal Implant', 'PlaceAbut', '/XXX/', 80, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6040', 'Surgical Placement Eposteal Implant', 'SurgEpoImp', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6050', 'Surgical Placement Transosteal Implant', 'SurgTranImp', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6053', 'Implant/Abutment Supported Removable Denture for Completely Edentulous Arch', 'ImpAvRmvDnCpEdA', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6054', 'Implant/Abutment Supported Removable Denture for Partially Edentulous Arch', 'ImpAbRmvDnPartEdA', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6055', 'Dental Implant Supported Connecting Bar', 'ImpConBr', '/X/', 80, 4, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6056', 'Prefabricated Abutment', 'PrefabAbut', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6057', 'Custom Abutment (e.g. UCLA abutment)', 'CustAbut', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6058', 'Abutment Supported Porcelain/Ceramic Crown', 'AbPorCerCn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6059', 'Abutment Supported Porcelain Fused to Metal Crown, High Noble Metal', 'AbPFMCnHNM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6060', 'Abutment Supported Porcelain Fused to Metal Crown, Predominantly Base Metal', 'AbPFMCnBasM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6061', 'Abutment Supported Porcelain Fused to Metal Crown, Noble Metal', 'AbPFMCnNM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6062', 'Abutment Supported Cast Metal Crown, High Noble Metal', 'AbCasMCnHNM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6063', 'Abutment Supported Cast Metal Crown, Predominantly Base Metal', 'AbCasMCnBasM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6064', 'Abutment Supported Cast Metal Crown, Noble Metal', 'AbCasMCnNM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6065', 'Implant Supported Porcelain/Ceramic Crown', 'ImpPorCerCn', '/X/', 87, 2, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6066', 'Implant Supported Porcelain Fused to Metal Crown (Titanium, Titanium Alloy, High Noble Metal)', 'ImpPFMCrn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6067', 'Implant Supported Metal Crown (Titanium, Titanium Alloy, High Noble Metal)', 'ImpMCn', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6068', 'Abutment Supported Retainer for Porcelain/Ceramic Fixed Partial Denture', 'AbCasMCnBasM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6069', 'Abutment Supported Retainer for Porcelain Fused to Metal Fixed Partial Denture, High Noble Metal', 'AbRPFMFxRPDHNM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6070', 'Abutment Supported Retainer for Porcelain Fused to Metal Fixed Partial Denture, Predominantly Base Metal', 'AbRPFMFxRPDBasM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6071', 'Abutment Supported Retainer for Porcelain Fused to Metal Fixed Partial Denture, Noble Metal', 'AbRPFMFxRPDNM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6072', 'Abutment Supported Retainer for Cast Metal Fixed Partial Denture, High Noble Metal', 'AbRtCasMFxRPDHNM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6073', 'Abutment Supported Retainer for Cast Metal Fixed Partial Denture, Predominantly Base Metal', 'AbRCasMFxRPDBasM', '/X/', 87, 0, 0, 0, 0, 0, '', 0); INSERT INTO procedurecode VALUES ('D6074', 'Abutment Supported Retaine