INSERT INTO `definition` (`DefNum`, `Category`, `ItemOrder`, `ItemName`, `ItemValue`, `ItemColor`, `IsHidden`) VALUES (1, 1, 3, 'Ajustement nég divers', '-', 0, 0), (2, 1, 4, 'Ajustement pos divers', '+', 0, 0), (4, 0, 1, 'Adjustment', '', -16777031, 0), (5, 0, 3, 'Payment', '', -16744448, 0), (6, 0, 4, 'Insurance', '', -2555904, 0), (7, 0, 0, 'Default', '', -16777216, 0), (8, 1, 0, 'Rabais professionnel', '-', 0, 0), (9, 1, 2, 'Rabais comptant', '-', 0, 0), (10, 1, 6, 'Radiation', '-', 0, 0), (112, 0, 2, 'Discount', '', -16744448, 0), (12, 1, 7, 'Radiation assurance', '-', 0, 0), (13, 1, 8, '$10 rabais référencement', '-', 0, 0), (14, 1, 9, 'RDV manqué - no show', '+', 0, 0), (15, 1, 10, 'RDV manqué - sans 24h préavis', '+', 0, 0), (16, 1, 11, 'Chèque retourné', '+', 0, 0), (17, 1, 12, 'Frais NSF', '+', 0, 0), (18, 1, 5, 'Rembousement patient (chèque)', '+', 0, 0), (19, 2, 0, 'Non confirmé', 'NonConfirmé', -1, 0), (20, 2, 1, 'Laissé message sur répondeur', 'Répondeur', -256, 0), (21, 2, 2, 'Rendez-vous confirmé', 'Confirmé', -6099851, 0), (22, 2, 3, 'Laissé message à un membre de la famille', 'MsgFamille', -256, 0), (23, 2, 4, 'Sans réponse', 'PasRéponse', -65536, 0), (24, 2, 5, 'Téléphone déconnecté', 'TélInvalide', -65536, 0), (25, 2, 6, 'Ligne occupée', 'LigneOcc', -65536, 0), (40, 4, 0, 'Compte standard', '', 0, 0), (41, 4, 1, 'Mauvaise créance', '', 0, 0), (42, 4, 2, 'Mauvaise créance - en recouvrement', '', 0, 0), (45, 6, 0, 'Standard 0-30', '', 0, 0), (46, 6, 1, 'Standard 31-60', 'Charges over 30 days.', 0, 0), (47, 6, 2, 'Standard 61-90', 'Charges over 60 days.', 0, 0), (48, 6, 3, 'Standard Over 90', 'Charges over 90 days. Finance charges apply.', 0, 0), (49, 6, 4, 'Insurance 0-30', '', 0, 0), (50, 6, 5, 'Insurance 31-60', 'Charges over 30 days.', 0, 0), (51, 6, 6, 'Insurance 61-90', 'Charges over 60 days.', 0, 0), (52, 6, 7, 'Insurance Over 90', 'Charges over 90 days. You are responsible for unpaid insurance. Finance charges apply.', 0, 0), (256, 11, 9, 'Services Généraux', '', 0, 0), (56, 8, 1, 'BP', '', 0, 0), (57, 8, 6, 'Allergy:', '', 0, 0), (58, 8, 2, 'Heart', '', 0, 0), (59, 8, 3, 'Low Epi', '', 0, 0), (60, 8, 4, 'PAC', '', 0, 0), (61, 8, 7, 'Medication:', '', 0, 0), (62, 8, 0, 'none', '', 0, 0), (63, 8, 5, 'Diabetes', '', 0, 0), (207, 22, 7, 'Existing Current Prov (light)', '', -8421409, 0), (206, 22, 6, 'Complete (light)', '', -8421408, 0), (205, 22, 5, 'Treatment Planned (light)', '', -1933441, 0), (69, 10, 0, 'Chèque', '', 0, 0), (70, 10, 1, 'Comptant', '', 0, 0), (71, 10, 2, 'Carte de crédit', '', 0, 0), (113, 12, 2, 'Status Existing Current Prov', '', -16777206, 0), (72, 10, 5, 'Not used', '', 0, 1), (255, 11, 8, 'Orthodontie', '', 0, 0), (254, 11, 7, 'Chirurgie buccale et maxillo-faciale', '', 0, 0), (253, 11, 5, 'Prosthodontie - Amovible', '', 0, 0), (252, 11, 4, 'Parodontie', '', 0, 0), (251, 11, 3, 'Endodontie', '', 0, 0), (88, 12, 1, 'Status Complete', '', -16185069, 0), (89, 12, 5, 'Rx', '', -65536, 0), (90, 12, 0, 'Status Treatment Planned', '', -8978432, 0), (91, 12, 3, 'Status Existing Other Prov', '', -16751616, 0), (92, 13, 0, 'Rendez-vous céduler', 'Céduler', 0, 0), (93, 13, 8, 'Sans réponse', 'PasRép', 0, 0), (94, 13, 1, 'Rappeler le patient, il n''est pas prêt', 'Rappelé', 0, 0), (95, 13, 2, 'Le patient nous rappellera', 'VaRaplé', 0, 0), (96, 13, 3, 'Mauvaise Créance - Ne pas rappeler', 'Dette', 0, 0), (97, 13, 5, 'Laissé msg sur répondeur\r\n', 'MsgRép', 0, 0), (98, 13, 6, 'Laissé msg famille', 'MsgFam', 0, 0), (99, 13, 7, 'Téléphone Invalide', 'TélInva', 0, 0), (100, 13, 4, 'Attendre, voir note', 'Attend', 0, 0), (101, 14, 3, 'Pillow', '', 0, 0), (102, 14, 4, 'No Fluoride', '', 0, 0), (103, 14, 7, 'Hard to Numb', '', 0, 1), (104, 14, 0, 'Value', '', 0, 0), (105, 14, 2, 'Quality', '', 0, 0), (106, 14, 5, 'Don''t Lean Back', '', 0, 0), (107, 14, 1, 'Painless', '', 0, 0), (108, 15, 1, '10% rabais âge d''or', '10', 0, 0), (109, 15, 0, '5% rabais comptant', '5', 0, 0), (110, 15, 2, 'Rabais nouveau patient', '20', 0, 0), (111, 15, 3, 'Rabais', '', 0, 0), (115, 16, 1, 'Caries', 'C', 0, 0), (116, 16, 2, 'Caries Récurrentes', 'R', 0, 0), (117, 16, 3, 'Caries Naissantes', 'N', 0, 0), (118, 16, 4, 'Défaut (ou obturation défectueusel)', 'D', 0, 0), (119, 16, 5, 'Absente (structure dentaire)', 'M', 0, 0), (120, 16, 6, 'Pulpite Irréversible', 'IP', 0, 0), (121, 16, 7, 'Pulpite Réversible', 'RP', 0, 0), (122, 16, 8, 'Necrotique', 'Nc', 0, 0), (123, 16, 9, 'Parodontite apicale', 'PA', 0, 0), (124, 16, 10, 'Abcès', 'Ab', 0, 0), (125, 16, 11, 'Carious Pulp Exp', 'CE', 0, 0), (126, 16, 12, 'Dent Fracturé', 'DF', 0, 0), (127, 17, 0, 'Practice Open', '', -1, 0), (128, 17, 1, 'Practice Closed', '', -2368549, 0), (204, 26, 0, 'All', '', 0, 0), (130, 18, 3, 'Antécédents médicaux', 'E', 0, 0), (131, 18, 2, 'Assurance', 'E', 0, 0), (132, 18, 6, 'Plan de Traitement', 'E', 0, 0), (133, 18, 8, 'Patient Treatment', 'E', 0, 0), (134, 18, 1, 'Finance', 'E', 0, 0), (135, 18, 7, 'dvdv', 'E', 0, 0), (136, 18, 0, 'Approbation de crédit', 'E', 0, 0), (137, 18, 4, 'Divers', 'E', 0, 0), (138, 18, 5, 'Information Patient', 'E', 0, 0), (139, 16, 0, 'Aucun', '', 0, 0), (268, 10, 4, 'Rembousement patient (chèque)', '', 0, 0), (141, 17, 2, 'Appointment Complete-Background', '', -2039837, 0), (142, 13, 9, 'Envoyé carte postale', 'Postale', 0, 0), (143, 19, 0, 'Called. Left message.', '', 0, 0), (144, 19, 1, 'Called. No answer.', '', 0, 0), (145, 19, 2, 'Called. Bad number. Made note in chart', '', 0, 0), (146, 20, 0, '1', '', -16777216, 0), (147, 20, 1, '2', '', -16777216, 0), (148, 20, 11, 'Attente', '', -7237231, 0), (149, 20, 9, 'Bas', '', -16777216, 0), (150, 20, 8, 'Prochain', '', -6356992, 0), (151, 20, 4, '5', '', -16777216, 0), (152, 20, 13, '10', '', -16777216, 1), (153, 20, 2, '3', '', -16777216, 0), (154, 20, 3, '4', '', -16777216, 0), (155, 20, 12, '9', '', -16777216, 1), (156, 20, 5, '6', '', -16777216, 0), (157, 20, 6, '7', '', -16777216, 0), (158, 20, 7, '8', '', -16777216, 0), (159, 20, 10, 'Recommandé', '', -7237231, 0), (160, 12, 4, 'Status Referred', '', -8978432, 0), (161, 14, 6, 'Anxiety', '', 0, 0), (162, 17, 3, 'Holiday', '', -2509157, 0), (163, 0, 5, 'Comm', '', -8388608, 0), (164, 21, 0, 'Family Module Coverage', '', -2823993, 0), (165, 22, 0, 'Treatment Planned', '', -3801088, 0), (166, 22, 1, 'Complete', '', -16777023, 0), (167, 22, 2, 'Existing Current Prov', '', -16777025, 0), (168, 22, 3, 'Existing Other Prov', '', -16751616, 0), (169, 22, 4, 'Referred Out', '', -3276800, 0), (170, 1, 13, 'Intérêt sur prêt', '+', 0, 0), (171, 23, 0, 'Pharmacies', '', 0, 0), (172, 23, 1, 'Dentistes locaux', '', 0, 0), (173, 0, 6, 'PayPlan', '', -8388608, 0), (250, 11, 2, 'Dentisterie Opératoire', '', 0, 0), (249, 11, 1, 'Préventif', '', 0, 0), (248, 11, 0, 'Diagnostique', '', 0, 0), (187, 21, 1, 'Perio Bleeding', '', -1043436, 0), (188, 21, 2, 'Perio Suppuration', '', -24576, 0), (189, 21, 3, 'Chart Module Medical', '', -16192, 0), (190, 21, 4, 'Perio Plaque', '', -10066177, 0), (191, 21, 5, 'Perio Calculus', '', -16737024, 0), (192, 18, 9, 'BWs', 'E', 0, 0), (193, 18, 10, 'FMXs', 'E', 0, 0), (194, 18, 11, 'Panos', 'E', 0, 0), (195, 18, 12, 'Photos', 'XE', 0, 0), (196, 21, 6, 'Chart Today''s Procs', '', -886, 0), (197, 21, 7, 'Commlog Appt Related', '', -886, 0), (198, 1, 14, '5% rabais comptant', '-', 0, 0), (199, 1, 15, '10% rabais âge d''or', '-', 0, 0), (200, 1, 16, 'Rabais nouveau patient', '-', 0, 0), (201, 1, 17, 'Rabais', '-', 0, 0), (202, 17, 4, 'Blockout Text', '', -9539986, 0), (203, 18, 13, 'Patient Pictures', 'PE', 0, 0), (208, 22, 8, 'Existing Other Prov (light)', '', -8408705, 0), (209, 22, 9, 'Referred Out (light)', '', -1671297, 0), (210, 12, 6, 'CommLog', '', -65536, 0), (211, 22, 10, 'Main Background', '', -6909543, 0), (212, 22, 11, 'Text', '', -1, 0), (213, 22, 12, 'Highlighted Text', '', -65536, 0), (214, 22, 13, 'Highlighted Background', '', -1, 0), (215, 22, 14, 'Background on TPs', '', -1, 0), (216, 22, 15, 'Text on TPs', '', -16777216, 0), (217, 12, 7, 'LabCase', '', -65536, 0), (218, 12, 8, 'Appointment Text - Today', '', -8388480, 0), (219, 12, 9, 'Appointment Background - Today', '', -886, 0), (220, 12, 10, 'Past Appointment Text', '', -8388480, 0), (221, 12, 11, 'Past Appointment Background', '', -1, 0), (222, 12, 12, 'Future Appointment Text', '', -8388480, 0), (223, 12, 13, 'Future Appointment Background', '', -7278960, 0), (224, 12, 14, 'Broken/Unschd Appt Text', '', -8388480, 0), (225, 12, 15, 'Broken/Unschd Appt Background', '', -1, 0), (226, 12, 16, 'Planned Appointment Text', '', -8388480, 0), (227, 12, 17, 'Planned Appointment Background', '', -1, 0), (228, 12, 18, 'Patient Note Text', '', -8388480, 0), (229, 12, 19, 'Patient Note Background', '', -1, 0), (267, 11, 11, 'Obsolète', '', 0, 0), (231, 17, 5, 'Patient Note Background', '', -1051718, 0), (265, 2, 8, 'Envoie d''un texto', 'Texto', 0, 0), (266, 11, 12, 'Hygiène', '', 0, 0), (234, 17, 6, 'Completed Pt. Note Background', '', -8355712, 0), (235, 12, 20, 'Completed Pt Note Text', '', -8388480, 0), (236, 12, 21, 'Completed Pt Note Background', '', -1, 0), (237, 27, 0, 'Rendez-vous', 'APPT', 0, 0), (238, 27, 1, 'Assurance', '', 0, 0), (239, 27, 2, 'Finance', 'FIN', 0, 0), (240, 27, 3, 'Rappel', 'RECALL', 0, 0), (241, 27, 4, 'Autre', 'MISC', 0, 0), (242, 18, 14, 'Statements', 'S', 0, 0), (243, 0, 7, 'Insurance Payment', '', -16744448, 0), (244, 0, 8, 'Received Ins Claim', '', -5220352, 0), (245, 0, 9, 'Received Pre-Auth', '', -8388480, 0), (246, 21, 8, 'Family Module Referral', '', -2823993, 0), (247, 1, 18, 'Frais de facturation', '+', 0, 0), (257, 11, 10, 'Sans Frais', '', 0, 0), (258, 11, 6, 'Prosthodontie - Fixe', '', 0, 0), (259, 1, 19, 'Réaffectation', '+', 0, 0), (260, 12, 22, 'Status Condition', '', -8978432, 0), (261, 22, 16, 'Condition', '', -5169880, 0), (262, 22, 17, 'Condition (light)', '', -1678747, 0), (263, 18, 15, 'Tooth Charts', 'TE', 0, 0), (264, 2, 7, 'Envoie d''un courriel', 'Courriel', 0, 0), (269, 32, 0, 'Chèque', '', 0, 0), (270, 32, 1, 'Transfert électronique', 'N', 0, 0), (271, 33, 0, 'Normal', 'D', -1, 0), (272, 34, 0, 'Default', '', -16777216, 0), (273, 34, 1, 'Provider', '', -15161839, 0), (274, 34, 2, 'Clinic', '', -3176419, 0), (275, 34, 3, 'Provider and Clinic', '', -16776961, 0), (276, 35, 0, 'Généraliste', '', 0, 0), (277, 35, 1, 'Hygiéniste', '', 0, 0), (278, 35, 2, 'Endo', '', 0, 0), (279, 35, 3, 'Pédo', '', 0, 0), (280, 35, 4, 'Paro', '', 0, 0), (281, 35, 5, 'Prostho', '', 0, 0), (282, 35, 6, 'Ortho', '', 0, 0), (283, 35, 7, 'Denturo', '', 0, 0), (284, 35, 8, 'Maxillo', '', 0, 0), (285, 35, 9, 'Assistant', '', 0, 0), (286, 35, 10, 'TechLabo', '', 0, 0), (287, 35, 11, 'Patho', '', 0, 0), (288, 35, 12, 'PublicHealth', '', 0, 0), (289, 35, 13, 'Radio', '', 0, 0), (290, 0, 10, 'Broken Appointment Procedure', '', -16777031, 0), (291, 36, 0, 'Défaut', '', 0, 0), (295, 38, 1, 'Voir notes', '', 0, 0), (294, 38, 0, 'Tentative', '', 0, 0), (296, 29, 0, 'Prepaiement', '', 0, 0), (297, 0, 11, 'Canceled Appointment Procedure', '', -16777031, 0), (298, 33, 1, 'Rappel', 'R', -9031, 0), (299, 40, 0, 'Défaut', '', 0, 0), (300, 21, 9, 'Family Module ICE', '', -70679, 0), (301, 21, 10, 'Family Module Pat Restrictions', '', -70679, 0), (302, 2, 9, 'eConfirmationEnvoyé', 'eConfirmEnvoyé', 0, 0), (303, 2, 10, 'eConfirmationRappelé', 'eConfirmRappelé', 0, 0), (304, 2, 11, 'eConfirmationÉchec', 'eConfirmÉchec', 0, 0), (305, 1, 1, 'Taxe de vente', '+', 0, 0), (306, 10, 3, 'Débit', '', 0, 0); INSERT INTO `displayfield` (`DisplayFieldNum`, `InternalName`, `ItemOrder`, `Description`, `ColumnWidth`, `Category`, `ChartViewNum`, `PickList`, `DescriptionOverride`) VALUES (1, 'Date', 0, '', 67, 0, 1, '', ''), (2, 'Th', 1, '', 27, 0, 1, '', ''), (3, 'Surf', 2, '', 40, 0, 1, '', ''), (4, 'Dx', 3, '', 28, 0, 1, '', ''), (5, 'Description', 4, '', 218, 0, 1, '', ''), (6, 'Stat', 5, '', 25, 0, 1, '', ''), (7, 'Prov', 6, '', 42, 0, 1, '', ''), (8, 'Amount', 7, '', 48, 0, 1, '', ''), (9, 'ADA Code', 8, '', 62, 0, 1, '', ''), (10, 'User', 9, '', 62, 0, 1, '', ''), (11, 'Signed', 10, '', 55, 0, 1, '', ''), (46, 'Discount', 10, 'Rabais', 55, 7, 0, '', ''), (45, 'Sec Ins', 9, 'Ass 2', 50, 7, 0, '', ''), (44, 'Pri Ins', 8, 'Ass 1', 50, 7, 0, '', ''), (43, 'Fee', 7, 'Frais', 50, 7, 0, '', ''), (42, 'Description', 6, 'Description', 202, 7, 0, '', ''), (41, 'Sub', 5, 'Sub', 28, 7, 0, '', ''), (39, 'Surf', 3, 'Surf', 45, 7, 0, '', ''), (40, 'Code', 4, 'Code', 50, 7, 0, '', ''), (38, 'Tth', 2, 'Dent', 40, 7, 0, '', ''), (37, 'Priority', 1, 'Priorité', 50, 7, 0, '', ''), (36, 'Done', 0, 'Fait', 50, 7, 0, '', ''), (47, 'Pat', 11, 'Pat', 50, 7, 0, '', ''), (61, 'charges', 5, 'Honoraires', 60, 11, 0, '', ''), (60, 'description', 4, 'Description', 275, 11, 0, '', ''), (59, 'tth', 3, 'Dent', 45, 11, 0, '', ''), (58, 'ProcCode', 2, 'Code', 45, 11, 0, '', ''), (57, 'patient', 1, 'Patient', 100, 11, 0, '', ''), (56, 'date', 0, 'Date', 75, 11, 0, '', ''), (62, 'credits', 6, 'Crédits', 60, 11, 0, '', ''), (63, 'balance', 7, 'Balance', 60, 11, 0, '', ''), (80, 'LastRemind', 6, 'DernierRappel', 82, 4, 0, '', ''), (79, '#Remind', 5, '#Rappel', 55, 4, 0, '', ''), (78, 'Interval', 4, 'Interval.', 50, 4, 0, '', ''), (77, 'Type', 3, 'Type', 60, 4, 0, '', ''), (76, 'Age', 2, 'Âge', 30, 4, 0, '', ''), (75, 'Patient', 1, 'Patient', 120, 4, 0, '', ''), (74, 'Due Date', 0, 'Date Dûe', 75, 4, 0, '', ''), (81, 'Contact', 7, 'Contact', 120, 4, 0, '', ''), (82, 'Status', 8, 'Statut', 130, 4, 0, '', ''), (83, 'Note', 9, 'Note', 215, 4, 0, '', ''), (84, 'Date', 0, 'Date', 67, 6, 0, '', ''), (85, 'Th', 1, 'Dent', 29, 6, 0, '', ''), (86, 'Surf', 2, 'Surf', 40, 6, 0, '', ''), (87, 'Description', 3, 'Description', 203, 6, 0, '', ''), (88, 'Stat', 4, 'Stat', 25, 6, 0, '', ''), (89, 'Prov', 5, 'Four', 42, 6, 0, '', ''), (90, 'Amount', 6, 'Montant', 48, 6, 0, '', ''), (91, 'ADA Code', 7, 'Code ACDQ', 70, 6, 0, '', ''), (223, 'Charges', 6, 'Frais', 60, 3, 0, '', ''), (222, 'Description', 5, 'Description', 270, 3, 0, '', ''), (221, 'Tth', 4, 'Dent', 29, 3, 0, '', ''), (220, 'Code', 3, 'Code', 46, 3, 0, '', ''), (219, 'Prov', 2, 'Four', 40, 3, 0, '', ''), (218, 'Patient', 1, 'Patient', 100, 3, 0, '', ''), (101, 'Patient Name', 0, 'Nom Patient', 0, 9, 0, '', ''), (102, 'Patient Picture', 1, 'Photo Patient', 0, 9, 0, '', ''), (103, 'Appt Day', 2, 'Jour RDV', 0, 9, 0, '', ''), (104, 'Appt Date', 3, 'Date RDV', 0, 9, 0, '', ''), (105, 'Appt Time', 4, 'Heure RDV', 0, 9, 0, '', ''), (106, 'Appt Length', 5, 'Durée RDV', 0, 9, 0, '', ''), (107, 'Provider', 6, 'Fournisseur', 0, 9, 0, '', ''), (108, 'Production', 7, 'Production', 0, 9, 0, '', ''), (109, 'Confirmed', 8, 'Confirmé', 0, 9, 0, '', ''), (110, 'Appt Status', 9, 'Statut RDV', 0, 9, 0, '', ''), (111, 'Med Flag', 10, 'Alerte Médicale', 0, 9, 0, '', ''), (112, 'Med Note', 11, 'Note Médicale', 0, 9, 0, '', ''), (113, 'Lab', 12, 'Lab', 0, 9, 0, '', ''), (114, 'Procedures', 13, 'Actes', 0, 9, 0, '', ''), (115, 'Note', 14, 'Note', 0, 9, 0, '', ''), (116, 'Horizontal Line', 15, 'Ligne Horizontale', 0, 9, 0, '', ''), (117, 'PatNum', 16, 'PatNum', 0, 9, 0, '', ''), (118, 'ChartNum', 17, 'CharteNum', 0, 9, 0, '', ''), (119, 'Billing Type', 18, 'Type de facturation', 0, 9, 0, '', ''), (120, 'Age', 19, 'Âge', 0, 9, 0, '', ''), (121, 'Home Phone', 20, 'Tél Maison', 0, 9, 0, '', ''), (122, 'Work Phone', 21, 'Tél Travail', 0, 9, 0, '', ''), (123, 'Wireless Phone', 22, 'Tél Cell', 0, 9, 0, '', ''), (124, 'Contact Methods', 23, 'Méthodes de contact', 0, 9, 0, '', ''), (125, 'Insurance', 24, 'Assurance', 0, 9, 0, '', ''), (126, 'Address Note', 25, 'Note d''Adresse', 0, 9, 0, '', ''), (127, 'Fam Note', 26, 'Note Famille', 0, 9, 0, '', ''), (128, 'Appt Mod Note', 27, 'Note Modification RDV', 0, 9, 0, '', ''), (129, 'Stat', 0, 'Stat', 35, 13, 0, '', ''), (130, 'Priority', 1, 'Priorité', 45, 13, 0, '', ''), (131, 'Tth', 2, 'Dent', 29, 13, 0, '', ''), (132, 'Surf', 3, 'Surf', 50, 13, 0, '', ''), (133, 'Code', 4, 'Code', 50, 13, 0, '', ''), (134, 'Description', 5, 'Description', 275, 13, 0, '', ''), (135, 'Fee', 6, 'Frais', 60, 13, 0, '', ''), (136, 'Age', 0, 'Âge', 0, 5, 0, '', ''), (137, 'ABC0', 1, 'ABC0', 0, 5, 0, '', ''), (138, 'Billing Type', 2, 'Type de Facturation', 0, 5, 0, '', ''), (139, 'Referred From', 3, 'Référé De', 0, 5, 0, '', ''), (140, 'Date First Visit', 4, 'Date Première Visite', 0, 5, 0, '', ''), (141, 'Prov. (Pri, Sec)', 5, 'Four. (Pri, Sec)', 0, 5, 0, '', ''), (142, 'Pri Ins', 6, 'Ass 1', 0, 5, 0, '', ''), (143, 'Sec Ins', 7, 'Ass 2', 0, 5, 0, '', ''), (144, 'Payor Types', 8, 'Types de Payeur', 0, 5, 0, '', ''), (145, 'Premedicate', 9, 'Prémédication', 0, 5, 0, '', ''), (146, 'Problems', 10, 'Problèmes', 0, 5, 0, '', ''), (147, 'Med Urgent', 11, 'Urgence Méd.', 0, 5, 0, '', ''), (148, 'Medical Summary', 12, 'Résumé Médical', 0, 5, 0, '', ''), (149, 'Service Notes', 13, 'Notes', 0, 5, 0, '', ''), (150, 'Medications', 14, 'Médications', 0, 5, 0, '', ''), (151, 'Allergies', 15, 'Allergies', 0, 5, 0, '', ''), (152, 'Pat Restrictions', 16, 'Restrictions', 0, 5, 0, '', ''), (153, 'Type', 0, 'Type', 90, 12, 0, '', ''), (154, 'Due Date', 1, 'Date Dûe', 80, 12, 0, '', ''), (155, 'Sched Date', 2, 'Date Cédulée', 80, 12, 0, '', ''), (156, 'Notes', 3, 'Notes', 255, 12, 0, '', ''), (157, 'Last', 0, 'Nom', 0, 2, 0, '', ''), (158, 'First', 1, 'Prénom', 0, 2, 0, '', ''), (159, 'Middle', 2, 'Initiale', 0, 2, 0, '', ''), (160, 'Preferred', 3, 'Préféré', 0, 2, 0, '', ''), (161, 'Title', 4, 'Titre', 0, 2, 0, '', ''), (162, 'Salutation', 5, 'Salutation', 0, 2, 0, '', ''), (163, 'Status', 6, 'Statut', 0, 2, 0, '', ''), (164, 'Gender', 7, 'Sexe', 0, 2, 0, '', ''), (165, 'Position', 8, 'Position', 0, 2, 0, '', ''), (166, 'Birthdate', 9, 'Date de Naissance', 0, 2, 0, '', ''), (167, 'Age', 10, 'Âge', 0, 2, 0, '', ''), (168, 'SS#', 11, 'SSN', 0, 2, 0, '', ''), (169, 'Address', 12, 'Adresse', 0, 2, 0, '', ''), (170, 'Address2', 13, 'Adresse2', 0, 2, 0, '', ''), (171, 'City', 14, 'Ville', 0, 2, 0, '', ''), (172, 'State', 15, 'Province', 0, 2, 0, '', ''), (173, 'Zip', 16, 'Code Postal', 0, 2, 0, '', ''), (174, 'Hm Phone', 17, 'Tél Maison', 0, 2, 0, '', ''), (175, 'Wk Phone', 18, 'Tél Travail', 0, 2, 0, '', ''), (176, 'Wireless Ph', 19, 'Tél Cell', 0, 2, 0, '', ''), (177, 'E-mail', 20, 'E-mail', 0, 2, 0, '', ''), (178, 'Contact Method', 21, 'Méthode de Contact', 0, 2, 0, '', ''), (179, 'ABC0', 22, 'ABC0', 0, 2, 0, '', ''), (180, 'Billing Type', 23, 'Type de Facturation', 0, 2, 0, '', ''), (181, 'Primary Provider', 24, 'Fournisseur Principal', 0, 2, 0, '', ''), (182, 'Sec. Provider', 25, 'Fournisseur Secondaire', 0, 2, 0, '', ''), (183, 'Payor Types', 26, 'Types de Payeur', 0, 2, 0, '', ''), (184, 'Language', 27, 'Langue', 0, 2, 0, '', ''), (185, 'Referrals', 28, 'Référencements', 0, 2, 0, '', ''), (186, 'Addr/Ph Note', 29, 'Addr/Tel Note', 0, 2, 0, '', ''), (187, 'PatFields', 30, 'PatFields', 0, 2, 0, '', ''), (188, 'Pat Restrictions', 31, 'Pat Restrictions', 0, 2, 0, '', ''), (189, 'ICE Name', 32, 'Urg Nom', 0, 2, 0, '', ''), (190, 'ICE Phone', 33, 'Urg Tél', 0, 2, 0, '', ''), (191, 'Stat', 0, 'Stat', 35, 14, 0, '', ''), (192, 'Priority', 1, 'Priorité', 45, 14, 0, '', ''), (193, 'Tth', 2, 'Dent', 29, 14, 0, '', ''), (194, 'Surf', 3, 'Surf', 50, 14, 0, '', ''), (195, 'Code', 4, 'Code', 50, 14, 0, '', ''), (196, 'Description', 5, 'Description', 275, 14, 0, '', ''), (197, 'Fee', 6, 'Frais', 60, 14, 0, '', ''), (198, 'LastName', 0, 'Nom', 75, 1, 0, '', ''), (199, 'First Name', 1, 'Prénom', 75, 1, 0, '', ''), (200, 'Pref Name', 2, 'Nom Pref', 60, 1, 0, '', ''), (201, 'Age', 3, 'Âge', 30, 1, 0, '', ''), (202, 'SSN', 4, 'NAS', 65, 1, 0, '', ''), (203, 'Hm Phone', 5, 'Tél maison', 90, 1, 0, '', ''), (204, 'Wk Phone', 6, 'Tél travail', 90, 1, 0, '', ''), (205, 'PatNum', 7, 'NumPat', 80, 1, 0, '', ''), (206, 'Address', 8, 'Adresse', 100, 1, 0, '', ''), (207, 'Status', 9, 'Statut', 65, 1, 0, '', ''), (224, 'Credits', 7, 'Crédits', 60, 3, 0, '', ''), (217, 'Date', 0, 'Date', 65, 3, 0, '', ''), (225, 'Balance', 8, 'Balance', 60, 3, 0, '', '');