{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["First Page","Instructions","Report","Column Descriptions","Look Up Tables","Validation Rules"],"not_rendered":{"charts":0,"images":12,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"First Page","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":7}
["Blood Lead Reporting Spreadsheet"]
["You will use the following website to upload results"]
["https://leadreporting.health.ok.gov"]
["The secure website requires a username and password to access, please see the \"Lead Upload Customer User Guide\"  that you should have received as a pdf document separately"]
[]
[]
["Before you can use the secure website, OCLPPP must create a user account for you.  Please contact the Oklahoma Childhood Lead Poisoning Prevention Program (OKLPPP) at 405-271-6617 or by email at oklppp@health.ok.gov to create your account or for additional questions"]
[]
["revised 08/28/17"]

{"sheet":"Instructions","index":1,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,10],[5,0,5,10],[7,0,7,10]]}
["INSTRUCTIONS / HELP "]
[]
[]
[]
[]
["This spreadsheet is designed to limit what and/or how information can be entered under certain columns. "]
[]
["DO NOT DELETE OR MOVE ANY COLUMNS IN THIS SPREADSHEET!"]

{"sheet":"Report","index":2,"n_rows":1001,"n_cols":36,"rows_kept":1001,"cut":false,"hidden":false,"merged":[]}
["VALIDATION","PT_LASTNAME","PT_FIRSTNAME","PT_MIDDLEINITIAL","PT_DOB","PT_PHONE","PT_ADDRESS","PT_CITY","PT_STATE","PT_ZIP","PT_COUNTY","PT_SEX","PT_RACE","PT_ETHNICITY","MEDICAID","SSN","G_LASTNAME","G_FIRSTNAME","DATE_DRAWN","DATE_ANALYZED","SAMPLE_TYPE","RESULT","INSTITUTION_NAME","INSTITUTION_ADDRESS","INSTITUTION_CITY","INSTITUTION_STATE","INSTITUTION_ZIP","PROV_LASTNAME","PROV_FIRSTNAME","PROV_ADDRESS","PROV_CITY","PROV_STATE","PROV_ZIP","COMMENT","ANALYZING_LAB","CLIA_Number"]
[{"$f":"IF(COUNTA(B2,C2,E2,G2,H2,I2,J2,L2,S2,T2,U2,V2,AI2,AJ2)=14,\"PASS\",\"ERROR\")","v":"ERROR"},{"$nulls":33},"LEAD CARE II","NON-CLIA EXEMPT"]
["ERROR",{"$nulls":33},"LEAD CARE II","NON-CLIA EXEMPT"]
["ERROR",{"$nulls":33},"LEAD CARE II","NON-CLIA EXEMPT"]
["ERROR",{"$nulls":33},"LEAD CARE II","NON-CLIA EXEMPT"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B66,C66,E66,G66,H66,I66,J66,L66,S66,T66,U66,V66,AI66,AJ66)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B130,C130,E130,G130,H130,I130,J130,L130,S130,T130,U130,V130,AI130,AJ130)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B194,C194,E194,G194,H194,I194,J194,L194,S194,T194,U194,V194,AI194,AJ194)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B258,C258,E258,G258,H258,I258,J258,L258,S258,T258,U258,V258,AI258,AJ258)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B322,C322,E322,G322,H322,I322,J322,L322,S322,T322,U322,V322,AI322,AJ322)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B386,C386,E386,G386,H386,I386,J386,L386,S386,T386,U386,V386,AI386,AJ386)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B450,C450,E450,G450,H450,I450,J450,L450,S450,T450,U450,V450,AI450,AJ450)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B514,C514,E514,G514,H514,I514,J514,L514,S514,T514,U514,V514,AI514,AJ514)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B578,C578,E578,G578,H578,I578,J578,L578,S578,T578,U578,V578,AI578,AJ578)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B642,C642,E642,G642,H642,I642,J642,L642,S642,T642,U642,V642,AI642,AJ642)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B706,C706,E706,G706,H706,I706,J706,L706,S706,T706,U706,V706,AI706,AJ706)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B770,C770,E770,G770,H770,I770,J770,L770,S770,T770,U770,V770,AI770,AJ770)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B834,C834,E834,G834,H834,I834,J834,L834,S834,T834,U834,V834,AI834,AJ834)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B898,C898,E898,G898,H898,I898,J898,L898,S898,T898,U898,V898,AI898,AJ898)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
[{"$f":"IF(COUNTA(B962,C962,E962,G962,H962,I962,J962,L962,S962,T962,U962,V962,AI962,AJ962)=14,\"PASS\",\"ERROR\")","v":"ERROR"}]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]
["ERROR"]

{"sheet":"Column Descriptions","index":3,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Section","Reporting","Column Name","Description","Spreadsheet automated format"]
[null,null,"VALIDATION",null,"Max 15","This is based on a formula, if you did not enter the required information you will not receive a 'pass' on this line."]
[null,"Required","PT_LASTNAME","Patient Last Name","Max 50 chars"]
[null,"Required","PT_FIRSTNAME","Patient First Name","Max 50 chars"]
[null,"Preferred","PT_MIDDLEINITIAL","Patient Middle Initial (if applicable)","Max 1 char"]
[null,"Required","PT_DOB","Patient Date of Birth in MM/DD/YYYY Format","*Error will appear if child is less than 60 days of age  Must enter date using / as separators"]
[null,"Preferred","PT_PHONE","10 Digit Phone Number of Patient (no formatting)","Max 10 ","*parentheses and dashes will be added automatically"]
["Patient Information","Required","PT_ADDRESS","Patient Street Address","Max 100? chars"]
[null,"Required","PT_CITY","Do not abbreviate, ensure correct spelling","Max "]
[null,"Required","PT_STATE","Default to State of OK","Max 2 chars"]
[null,"Required","PT_ZIP","5 digit, no plus 4","Max 5 chars","*Report children who live in other states to the appropriate State's Lead Program"]
[null,"Preferred","PT_COUNTY",null,"Max 50 chars","*non-Oklahoma zip code will prompt you to re-enter"]
[null,"Required","PT_SEX","Please Indicate Sex of Patient (Coded Value from Pull Down)","Max 1 char"]
[null,"Preferred","PT_RACE","Indicate race of patient (Coded Value from Pull-Down Table)","Max 1 char"]
[null,"Preferred","PT_ETHNICITY","Indicate ethnicity (Coded Value from Pull DownTable)","Max 1 char"]
[null,"Preferred","MEDICAID","Child's Medicaid number if available","Max 15 char"]
[null,"Preferred","SSN","Child's SSN if available","Max 9 char","*no spaces, no dashes"]
[null,"Preferred","G_LASTNAME","Guardian Last Name","Max 50 chars"]
[null,"Preferred","G_FIRSTNAME","Guardian First Name","Max 50 chars"]
[null,"Required","DATE_DRAWN","Collection Date in MM/DD/YYYY","MM/DD/YYYY ","*Error prompt if date drawn is less than 60 days after child's dob"]
[null,"Required","DATE_ANALYZED","Date the blood sample was analyzed in MM/DD/YYYY","MM/DD/YYYY","*Cannot be before date drawn"]
["Blood Test Information","Required","SAMPLE_TYPE","Specimen Type (Coded Value from Pull Down)","Max 1 char","*Normally C for Capillary, less frequently venous "]
[null,"Required","RESULT","Blood lead value reported in µg/dL","MAX 3","*Remember OCLPPP rounds up or down.  "]
[null,"Required","INSTITUTION_NAME",null,"Max 50 chars","Required IF there is no  PROV-LASTNAME & PROV_FIRSTNAME"]
["Analyzing Institution Information",null,"INSTITUTION_ADDRESS",null,"Max 100 chars"]
[null,null,"INSTITUTION_CITY","Full Name of City where Clinic is Located","Max 50 chars"]
["for LeadCare II users, this would be the Clinic information",null,"INSTITUTION_STATE","State where Clinic is located","Max 2 chars"]
[null,null,"INSTITUTION_ZIP","Clinic 5 Digit ZIP Code","Max 5"]
[null,"Required","PROV_LASTNAME",null,"Max 50 chars","Required IF there is NO Institution_Name"]
[null,"Required","PROV_FIRSTNAME",null,"Max 50 chars"]
["Ordering Physician",null,"PROV_ADDRESS",null,"Max 100 chars"]
[null,null,"PROV_CITY","Full Name of City where Clinic is Located","Max 50 chars"]
["for LeadCare II users, this could be the Clinic information or individual doctor",null,"PROV_STATE","State where Clinic is located","Max 2 chars"]
[null,null,"PROV_ZIP","Clinic 5 Digit ZIP Code","Max 5"]
[null,null,"COMMENT","Additional comments about test, retesting",null,"This will default to Lead CARE II"]
[null,"Required","ANALYZING_LAB","LEAD CARE II ","Max 15","This will default to NON-CLIA EXEMPT"]
[null,"Required","CLIA_NUMBER","NON-CLIA EXEMPT","Max 15"]

{"sheet":"Look Up Tables","index":4,"n_rows":780,"n_cols":5,"rows_kept":780,"cut":false,"hidden":true,"merged":[]}
["ZIP",null,"COUNTIES",null,"CITIES"]
[73001,null,"ADAIR",null,"Achille"]
[73002,null,"ALFALFA",null,"Ada"]
[73003,null,"ATOKA",null,"Adair"]
[73004,null,"BEAVER",null,"Addington"]
[73005,null,"BECKHAM",null,"Afton"]
[73006,null,"BLAINE",null,"Agra"]
[73007,null,"BRYAN",null,"Akins"]
[73008,null,"CADDO",null,"Albany"]
[73009,null,"CANADIAN",null,"Albion"]
[73010,null,"CARTER",null,"Alderson"]
[73011,null,"CHEROKEE",null,"Alex"]
[73012,null,"CHOCTAW",null,"Aline"]
[73013,null,"CIMMARON",null,"Allen"]
[73014,null,"CLEVELAND",null,"Altus"]
[73015,null,"COAL ",null,"Alva"]
[73016,null,"COMANCHE",null,"Amber"]
[73017,null,"COTTON",null,"Ames"]
[73018,null,"CRAIG",null,"Amorita"]
[73019,null,"CREEK",null,"Anadarko"]
[73020,null,"CUSTER",null,"Antlers"]
[73021,null,"DELAWARE",null,"Apache"]
[73022,null,"DEWEY",null,"Arapaho"]
[73023,null,"ELLIS",null,"Arcadia"]
[73024,null,"GARFIELD",null,"Ardmore"]
[73026,null,"GARVIN",null,"Arkoma"]
[73027,null,"GRADY",null,"Armstrong"]
[73028,null,"GRANT",null,"Arnett"]
[73029,null,"GREER",null,"Arpelar"]
[73030,null,"HARMON",null,"Asher"]
[73031,null,"HARPER",null,"Ashland"]
[73032,null,"HASKELL",null,"Atoka"]
[73033,null,"HUGHES",null,"Atwood"]
[73034,null,"JACKSON",null,"Avant"]
[73036,null,"JEFFERSON",null,"Badger Lee"]
[73038,null,"JOHNSTON",null,"Ballou"]
[73040,null,"KAY",null,"Barnsdall"]
[73041,null,"KINGFISHER",null,"Bartlesville"]
[73042,null,"KIOWA",null,"Bearden"]
[73043,null,"LATIMER",null,"Beaver"]
[73044,null,"LE FLORE",null,"Bee"]
[73045,null,"LINCOLN",null,"Beggs"]
[73047,null,"LOGAN",null,"Belfonte"]
[73048,null,"LOVE",null,"Bell"]
[73049,null,"MAJOR",null,"Bennington"]
[73050,null,"MARSHALL",null,"Bernice"]
[73051,null,"MAYES",null,"Bessie"]
[73052,null,"MCCLAIN",null,"Bethany"]
[73053,null,"MCCURTAIN",null,"Bethel Acres"]
[73054,null,"MCINTOSH",null,"Big Cabin"]
[73055,null,"MURRAY",null,"Billings"]
[73056,null,"MUSKOGEE",null,"Binger"]
[73057,null,"NOBLE",null,"Bison"]
[73058,null,"NOWATA",null,"Bixby"]
[73059,null,"OKFUSKEE",null,"Blackburn"]
[73061,null,"OKLAHOMA",null,"Blackgum"]
[73062,null,"OKMULGEE",null,"Blackwell"]
[73063,null,"OSAGE",null,"Blair"]
[73064,null,"OTTAWA",null,"Blanchard"]
[73065,null,"PAWNEE",null,"Blue"]
[73066,null,"PAYNE",null,"Bluejacket"]
[73067,null,"PITTSBURG",null,"Boise City"]
[73068,null,"PONTOTOC",null,"Bokchito"]
[73069,null,"POTTAWATOMIE",null,"Bokoshe"]
[73070,null,"PUSHMATAHA",null,"Boley"]
[73071,null,"ROGER MILLS",null,"Boswell"]
[73072,null,"ROGERS",null,"Bowlegs"]
[73073,null,"SEMINOLE",null,"Box"]
[73074,null,"SEQUOYAH",null,"Boynton"]
[73075,null,"STEPHENS",null,"Bradley"]
[73077,null,"TEXAS",null,"Braggs"]
[73078,null,"TILLMAN",null,"Braman"]
[73079,null,"TULSA",null,"Bray"]
[73080,null,"WAGONER",null,"Breckenridge"]
[73082,null,"WASHINGTON",null,"Brent"]
[73083,null,"WASHITA",null,"Bridge Creek"]
[73084,null,"WOODS",null,"Bridgeport"]
[73085,null,"WOODWARD",null,"Briggs"]
[73086,null,null,null,"Bristow"]
[73089,null,null,null,"Broken Arrow"]
[73090,null,null,null,"Broken Bow"]
[73092,null,null,null,"Bromide"]
[73093,null,null,null,"Brooksville"]
[73094,null,null,null,"Brush Creek"]
[73095,null,null,null,"Brushy"]
[73096,null,null,null,"Buffalo"]
[73097,null,null,null,"Bull Hollow"]
[73098,null,null,null,"Burbank"]
[73099,null,null,null,"Burlington"]
[73101,null,null,null,"Burns Flat"]
[73102,null,null,null,"Bushyhead"]
[73103,null,null,null,"Butler"]
[73104,null,null,null,"Butler CDP"]
[73105,null,null,null,"Byars"]
[73106,null,null,null,"Byng"]
[73107,null,null,null,"Byron"]
[73108,null,null,null,"Cache"]
[73109,null,null,null,"Caddo"]
[73110,null,null,null,"Calera"]
[73111,null,null,null,"Calumet"]
[73112,null,null,null,"Calvin"]
[73113,null,null,null,"Camargo"]
[73114,null,null,null,"Cameron"]
[73115,null,null,null,"Canadian"]
[73116,null,null,null,"Caney"]
[73117,null,null,null,"Canton"]
[73118,null,null,null,"Canute"]
[73119,null,null,null,"Capron"]
[73120,null,null,null,"Carlisle"]
[73121,null,null,null,"Carmen"]
[73122,null,null,null,"Carnegie"]
[73123,null,null,null,"Carney"]
[73124,null,null,null,"Carrier"]
[73125,null,null,null,"Carter"]
[73126,null,null,null,"Cartwright"]
[73127,null,null,null,"Cashion"]
[73128,null,null,null,"Castle"]
[73129,null,null,null,"Catoosa"]
[73130,null,null,null,"Cayuga"]
[73131,null,null,null,"Cedar Crest"]
[73132,null,null,null,"Cedar Valley"]
[73134,null,null,null,"Cement"]
[73135,null,null,null,"Centrahoma"]
[73136,null,null,null,"Central High"]
[73137,null,null,null,"Chandler"]
[73139,null,null,null,"Chattanooga"]
[73140,null,null,null,"Checotah"]
[73141,null,null,null,"Chelsea"]
[73142,null,null,null,"Cherokee"]
[73143,null,null,null,"Cherry Tree"]
[73144,null,null,null,"Chester"]
[73145,null,null,null,"Chewey"]
[73146,null,null,null,"Cheyenne"]
[73147,null,null,null,"Chickasha"]
[73148,null,null,null,"Choctaw"]
[73149,null,null,null,"Chouteau"]
[73150,null,null,null,"Christie"]
[73151,null,null,null,"Cimarron City"]
[73152,null,null,null,"Claremore"]
[73153,null,null,null,"Clayton"]
[73154,null,null,null,"Clearview"]
[73155,null,null,null,"Cleo Springs"]
[73156,null,null,null,"Cleora"]
[73157,null,null,null,"Cleveland"]
[73159,null,null,null,"Clinton"]
[73160,null,null,null,"Cloud Creek"]
[73162,null,null,null,"Coalgate"]
[73163,null,null,null,"Colbert"]
[73164,null,null,null,"Colcord"]
[73165,null,null,null,"Cole"]
[73167,null,null,null,"Collinsville"]
[73169,null,null,null,"Colony"]
[73170,null,null,null,"Comanche"]
[73172,null,null,null,"Commerce"]
[73173,null,null,null,"Cooperton"]
[73177,null,null,null,"Copan"]
[73178,null,null,null,"Copeland"]
[73179,null,null,null,"Corn"]
[73180,null,null,null,"Cornish"]
[73184,null,null,null,"Council Hill"]
[73185,null,null,null,"Covington"]
[73189,null,null,null,"Coweta"]
[73190,null,null,null,"Cowlington"]
[73193,null,null,null,"Coyle"]
[73194,null,null,null,"Crescent"]
[73195,null,null,null,"Cromwell"]
[73196,null,null,null,"Crowder"]
[73197,null,null,null,"Cushing"]
[73198,null,null,null,"Custer City"]
[73199,null,null,null,"Cyril"]
[73401,null,null,null,"Dacoma"]
[73402,null,null,null,"Dale"]
[73403,null,null,null,"Davenport"]
[73425,null,null,null,"Davidson"]
[73430,null,null,null,"Davis"]
[73432,null,null,null,"Deer Creek"]
[73433,null,null,null,"Deer Lick"]
[73434,null,null,null,"Del City"]
[73435,null,null,null,"Delaware"]
[73436,null,null,null,"Dennis"]
[73437,null,null,null,"Depew"]
[73438,null,null,null,"Devol"]
[73439,null,null,null,"Dewar"]
[73440,null,null,null,"Dewey"]
[73441,null,null,null,"Dibble"]
[73442,null,null,null,"Dickson"]
[73443,null,null,null,"Dill City"]
[73444,null,null,null,"Disney"]
[73446,null,null,null,"Dodge"]
[73447,null,null,null,"Dotyville"]
[73448,null,null,null,"Dougherty"]
[73449,null,null,null,"Douglas"]
[73450,null,null,null,"Dover"]
[73453,null,null,null,"Dripping Springs"]
[73455,null,null,null,"Drowning Creek"]
[73456,null,null,null,"Drummond"]
[73458,null,null,null,"Drumright"]
[73459,null,null,null,"Dry Creek"]
[73460,null,null,null,"Duchess Landing"]
[73461,null,null,null,"Duncan"]
[73463,null,null,null,"Durant"]
[73476,null,null,null,"Dustin"]
[73481,null,null,null,"Dwight Mission"]
[73487,null,null,null,"Eagletown"]
[73488,null,null,null,"Eakly"]
[73491,null,null,null,"Earlsboro"]
[73501,null,null,null,"East Duke"]
[73502,null,null,null,"Edmond"]
[73503,null,null,null,"El Reno"]
[73505,null,null,null,"Eldon"]
[73506,null,null,null,"Eldorado"]
[73507,null,null,null,"Elgin"]
[73520,null,null,null,"Elk City"]
[73521,null,null,null,"Elm Grove"]
[73522,null,null,null,"Elmer"]
[73523,null,null,null,"Elmore City"]
[73526,null,null,null,"Empire City"]
[73527,null,null,null,"Enid"]
[73528,null,null,null,"Erick"]
[73529,null,null,null,"Erin Springs"]
[73530,null,null,null,"Etowah"]
[73531,null,null,null,"Eufaula"]
[73532,null,null,null,"Evening Shade"]
[73533,null,null,null,"Fair Oaks"]
[73534,null,null,null,"Fairfax"]
[73536,null,null,null,"Fairfield"]
[73537,null,null,null,"Fairland"]
[73538,null,null,null,"Fairmont"]
[73539,null,null,null,"Fairview"]
[73540,null,null,null,"Fallis"]
[73541,null,null,null,"Fanshawe"]
[73542,null,null,null,"Fargo"]
[73543,null,null,null,"Faxon"]
[73544,null,null,null,"Felt"]
[73546,null,null,null,"Fitzhugh"]
[73547,null,null,null,"Fletcher"]
[73548,null,null,null,"Flint Creek"]
[73549,null,null,null,"Flute Springs"]
[73550,null,null,null,"Foraker"]
[73551,null,null,null,"Forest Park"]
[73552,null,null,null,"Forgan"]
[73553,null,null,null,"Fort Cobb"]
[73554,null,null,null,"Fort Coffee"]
[73555,null,null,null,"Fort Gibson"]
[73556,null,null,null,"Fort Supply"]
[73557,null,null,null,"Fort Towson"]
[73558,null,null,null,"Foss"]
[73559,null,null,null,"Foster"]
[73560,null,null,null,"Foyil"]
[73561,null,null,null,"Francis"]
[73562,null,null,null,"Frederick"]
[73564,null,null,null,"Freedom"]
[73565,null,null,null,"Friendship"]
[73566,null,null,null,"Gage"]
[73567,null,null,null,"Gans"]
[73568,null,null,null,"Garber"]
[73569,null,null,null,"Garvin"]
[73570,null,null,null,"Gate"]
[73571,null,null,null,"Geary"]
[73572,null,null,null,"Gene Autry"]
[73573,null,null,null,"Geronimo"]
[73575,null,null,null,"Gerty"]
[73601,null,null,null,"Gideon"]
[73620,null,null,null,"Glencoe"]
[73622,null,null,null,"Glenpool"]
[73624,null,null,null,"Goldsby"]
[73625,null,null,null,"Goltry"]
[73626,null,null,null,"Goodwell"]
[73627,null,null,null,"Gore"]
[73628,null,null,null,"Gotebo"]
[73632,null,null,null,"Gould"]
[73638,null,null,null,"Gracemont"]
[73639,null,null,null,"Grainola"]
[73641,null,null,null,"Grand Lake Towne"]
[73642,null,null,null,"Grandfield"]
[73644,null,null,null,"Grandview"]
[73645,null,null,null,"Granite"]
[73646,null,null,null,"Grant"]
[73647,null,null,null,"Grayson"]
[73648,null,null,null,"Greasy"]
[73650,null,null,null,"Greenfield"]
[73651,null,null,null,"Gregory"]
[73654,null,null,null,"Grove"]
[73655,null,null,null,"Guthrie"]
[73658,null,null,null,"Guymon"]
[73659,null,null,null,"Haileyville"]
[73660,null,null,null,"Hallett"]
[73661,null,null,null,"Hammon"]
[73662,null,null,null,"Hanna"]
[73663,null,null,null,"Hardesty"]
[73664,null,null,null,"Harrah"]
[73666,null,null,null,"Hartshorne"]
[73667,null,null,null,"Haskell"]
[73668,null,null,null,"Hastings"]
[73669,null,null,null,"Haworth"]
[73673,null,null,null,"Headrick"]
[73701,null,null,null,"Healdton"]
[73702,null,null,null,"Heavener"]
[73703,null,null,null,"Helena"]
[73705,null,null,null,"Hendrix"]
[73706,null,null,null,"Hennessey"]
[73716,null,null,null,"Henryetta"]
[73717,null,null,null,"Hickory"]
[73718,null,null,null,"Hillsdale"]
[73719,null,null,null,"Hinton"]
[73720,null,null,null,"Hitchcock"]
[73722,null,null,null,"Hitchita"]
[73724,null,null,null,"Hobart"]
[73726,null,null,null,"Hoffman"]
[73727,null,null,null,"Holdenville"]
[73728,null,null,null,"Hollis"]
[73729,null,null,null,"Hollister"]
[73730,null,null,null,"Hominy"]
[73731,null,null,null,"Hooker"]
[73733,null,null,null,"Hoot Owl"]
[73734,null,null,null,"Horntown"]
[73735,null,null,null,"Howe"]
[73736,null,null,null,"Hugo"]
[73737,null,null,null,"Hulbert"]
[73738,null,null,null,"Hunter"]
[73739,null,null,null,"Hydro"]
[73741,null,null,null,"Idabel"]
[73742,null,null,null,"Indiahoma"]
[73743,null,null,null,"Indianola"]
[73744,null,null,null,"Indianola town"]
[73746,null,null,null,"Inola"]
[73747,null,null,null,"Iron Post"]
[73749,null,null,null,"Isabella"]
[73750,null,null,null,"IXL"]
[73753,null,null,null,"Jay"]
[73754,null,null,null,"Jefferson"]
[73755,null,null,null,"Jenks"]
[73756,null,null,null,"Jennings"]
[73757,null,null,null,"Jet"]
[73758,null,null,null,"Johnson"]
[73759,null,null,null,"Jones"]
[73760,null,null,null,"Justice"]
[73761,null,null,null,"Kansas"]
[73762,null,null,null,"Katie"]
[73763,null,null,null,"Kaw City"]
[73764,null,null,null,"Kellyville"]
[73766,null,null,null,"Kemp"]
[73768,null,null,null,"Kendrick"]
[73770,null,null,null,"Kenefic"]
[73771,null,null,null,"Kenton"]
[73772,null,null,null,"Kenwood"]
[73773,null,null,null,"Keota"]
[73801,null,null,null,"Ketchum"]
[73802,null,null,null,"Keyes"]
[73832,null,null,null,"Keys"]
[73834,null,null,null,"Kiefer"]
[73835,null,null,null,"Kildare"]
[73838,null,null,null,"Kingfisher"]
[73840,null,null,null,"Kingston"]
[73841,null,null,null,"Kinta"]
[73842,null,null,null,"Kiowa"]
[73843,null,null,null,"Knowles"]
[73844,null,null,null,"Konawa"]
[73847,null,null,null,"Krebs"]
[73848,null,null,null,"Kremlin"]
[73851,null,null,null,"Lahoma"]
[73852,null,null,null,"Lake Aluma"]
[73853,null,null,null,"Lamar"]
[73855,null,null,null,"Lambert"]
[73857,null,null,null,"Lamont"]
[73858,null,null,null,"Lane"]
[73859,null,null,null,"Langley"]
[73860,null,null,null,"Langston"]
[73901,null,null,null,"Laverne"]
[73931,null,null,null,"Lawrence Creek"]
[73932,null,null,null,"Lawton"]
[73933,null,null,null,"Le Flore"]
[73937,null,null,null,"Leach"]
[73938,null,null,null,"Lebanon"]
[73939,null,null,null,"Leedey"]
[73942,null,null,null,"Lehigh"]
[73944,null,null,null,"Lenapah"]
[73945,null,null,null,"Leon"]
[73946,null,null,null,"Lexington"]
[73947,null,null,null,"Liberty"]
[73949,null,null,null,"Liberty town"]
[73950,null,null,null,"Lima"]
[73951,null,null,null,"Limestone"]
[74001,null,null,null,"Lindsay"]
[74002,null,null,null,"Loco"]
[74003,null,null,null,"Locust Grove"]
[74004,null,null,null,"Lone Grove"]
[74005,null,null,null,"Lone Wolf"]
[74006,null,null,null,"Long"]
[74008,null,null,null,"Longdale"]
[74009,null,null,null,"Longtown"]
[74010,null,null,null,"Lookeba"]
[74011,null,null,null,"Lost City"]
[74012,null,null,null,"Lotsee"]
[74013,null,null,null,"Loveland"]
[74014,null,null,null,"Loyal"]
[74015,null,null,null,"Lucien"]
[74016,null,null,null,"Luther"]
[74017,null,null,null,"Lyons Switch"]
[74018,null,null,null,"Macomb"]
[74019,null,null,null,"Madill"]
[74020,null,null,null,"Manchester"]
[74021,null,null,null,"Mangum"]
[74022,null,null,null,"Manitou"]
[74023,null,null,null,"Mannford"]
[74026,null,null,null,"Mannsville"]
[74027,null,null,null,"Maramec"]
[74028,null,null,null,"Marble City"]
[74029,null,null,null,"Marietta"]
[74030,null,null,null,"Marietta city"]
[74031,null,null,null,"Marland"]
[74032,null,null,null,"Marlow"]
[74033,null,null,null,"Marshall"]
[74034,null,null,null,"Martha"]
[74035,null,null,null,"Maud"]
[74036,null,null,null,"May"]
[74037,null,null,null,"Maysville"]
[74038,null,null,null,"Mazie"]
[74039,null,null,null,"McAlester"]
[74041,null,null,null,"McCord"]
[74042,null,null,null,"McCurtain"]
[74043,null,null,null,"McLoud"]
[74044,null,null,null,"Mead"]
[74045,null,null,null,"Medford"]
[74046,null,null,null,"Medicine Park"]
[74047,null,null,null,"Meeker"]
[74048,null,null,null,"Meno"]
[74050,null,null,null,"Meridian"]
[74051,null,null,null,"Meridian CDP"]
[74052,null,null,null,"Miami"]
[74053,null,null,null,"Midwest City"]
[74054,null,null,null,"Milburn"]
[74055,null,null,null,"Mill Creek"]
[74056,null,null,null,"Millerton"]
[74058,null,null,null,"Minco"]
[74059,null,null,null,"Moffett"]
[74060,null,null,null,"Moore"]
[74061,null,null,null,"Mooreland"]
[74062,null,null,null,"Morris"]
[74063,null,null,null,"Morrison"]
[74066,null,null,null,"Mounds"]
[74067,null,null,null,"Mountain Park"]
[74068,null,null,null,"Mountain View"]
[74070,null,null,null,"Mulberry"]
[74071,null,null,null,"Muldrow"]
[74072,null,null,null,"Mulhall"]
[74073,null,null,null,"Murphy"]
[74074,null,null,null,"Muskogee"]
[74075,null,null,null,"Mustang"]
[74076,null,null,null,"Mutual"]
[74077,null,null,null,"Narcissa"]
[74078,null,null,null,"Nardin"]
[74079,null,null,null,"Nash"]
[74080,null,null,null,"Nescatunga"]
[74081,null,null,null,"New Alluwe"]
[74082,null,null,null,"New Cordell"]
[74083,null,null,null,"New Eucha"]
[74084,null,null,null,"New Woodville"]
[74085,null,null,null,"Newcastle"]
[74101,null,null,null,"Newkirk"]
[74102,null,null,null,"Nichols Hills"]
[74103,null,null,null,"Nicoma Park"]
[74104,null,null,null,"Nicut"]
[74105,null,null,null,"Ninnekah"]
[74106,null,null,null,"Newalla"]
[74107,null,null,null,"Noble"]
[74108,null,null,null,"Norge"]
[74110,null,null,null,"Norman"]
[74112,null,null,null,"North Enid"]
[74114,null,null,null,"North Miami"]
[74115,null,null,null,"Notchietown"]
[74116,null,null,null,"Nowata"]
[74117,null,null,null,"Oak Grove"]
[74119,null,null,null,"Oakhurst"]
[74120,null,null,null,"Oakland"]
[74121,null,null,null,"Oaks"]
[74126,null,null,null,"Oakwood"]
[74127,null,null,null,"Ochelata"]
[74128,null,null,null,"Oilton"]
[74129,null,null,null,"Okarche"]
[74130,null,null,null,"Okay"]
[74131,null,null,null,"Okeene"]
[74132,null,null,null,"Okemah"]
[74133,null,null,null,"Oklahoma City"]
[74134,null,null,null,"Okmulgee"]
[74135,null,null,null,"Oktaha"]
[74136,null,null,null,"Old Eucha"]
[74137,null,null,null,"Old Green"]
[74141,null,null,null,"Olustee"]
[74145,null,null,null,"Oologah"]
[74146,null,null,null,"Optima"]
[74147,null,null,null,"Orlando"]
[74148,null,null,null,"Osage"]
[74149,null,null,null,"Owasso"]
[74150,null,null,null,"Paden"]
[74152,null,null,null,"Panama"]
[74153,null,null,null,"Paoli"]
[74155,null,null,null,"Paradise Hill"]
[74156,null,null,null,"Park Hill"]
[74157,null,null,null,"Pauls Valley"]
[74158,null,null,null,"Pawhuska"]
[74159,null,null,null,"Pawnee"]
[74169,null,null,null,"Peavine"]
[74170,null,null,null,"Peggs"]
[74171,null,null,null,"Pensacola"]
[74172,null,null,null,"Peoria"]
[74182,null,null,null,"Perkins"]
[74183,null,null,null,"Perry"]
[74184,null,null,null,"Pettit"]
[74186,null,null,null,"Phillips"]
[74187,null,null,null,"Piedmont"]
[74189,null,null,null,"Pin Oak Acres"]
[74192,null,null,null,"Piney"]
[74193,null,null,null,"Pinhook Corner"]
[74194,null,null,null,"Pink"]
[74301,null,null,null,"Pittsburg"]
[74330,null,null,null,"Pocasset"]
[74331,null,null,null,"Pocola"]
[74332,null,null,null,"Ponca City"]
[74333,null,null,null,"Pond Creek"]
[74335,null,null,null,"Porter"]
[74337,null,null,null,"Porum"]
[74338,null,null,null,"Poteau"]
[74339,null,null,null,"Prague"]
[74340,null,null,null,"Proctor"]
[74342,null,null,null,"Prue"]
[74343,null,null,null,"Pryor Creek"]
[74344,null,null,null,"Pump Back"]
[74345,null,null,null,"Purcell"]
[74346,null,null,null,"Putnam"]
[74347,null,null,null,"Quapaw"]
[74349,null,null,null,"Quinton"]
[74350,null,null,null,"Ralston"]
[74352,null,null,null,"Ramona"]
[74354,null,null,null,"Randlett"]
[74355,null,null,null,"Ratliff City"]
[74358,null,null,null,"Rattan"]
[74359,null,null,null,"Ravia"]
[74360,null,null,null,"Red Oak"]
[74361,null,null,null,"Red Rock"]
[74362,null,null,null,"Redbird"]
[74363,null,null,null,"Redbird Smith"]
[74364,null,null,null,"Remy"]
[74365,null,null,null,"Renfrow"]
[74366,null,null,null,"Rentiesville"]
[74367,null,null,null,"Reydon"]
[74368,null,null,null,"Ringling"]
[74369,null,null,null,"Ringwood"]
[74370,null,null,null,"Ripley"]
[74401,null,null,null,"River Bottom"]
[74402,null,null,null,"Rock Island"]
[74403,null,null,null,"Rocky"]
[74421,null,null,null,"Rocky Ford"]
[74422,null,null,null,"Rocky Mountain"]
[74423,null,null,null,"Roff"]
[74425,null,null,null,"Roland"]
[74426,null,null,null,"Roosevelt"]
[74427,null,null,null,"Rose"]
[74428,null,null,null,"Rosedale"]
[74429,null,null,null,"Rosston"]
[74430,null,null,null,"Rush Springs"]
[74431,null,null,null,"Ryan"]
[74432,null,null,null,"Salem"]
[74434,null,null,null,"Salina"]
[74435,null,null,null,"Sallisaw"]
[74436,null,null,null,"Sams Corner"]
[74437,null,null,null,"Sand Hill"]
[74438,null,null,null,"Sand Springs"]
[74440,null,null,null,"Sapulpa"]
[74441,null,null,null,"Sasakwa"]
[74442,null,null,null,"Savanna"]
[74444,null,null,null,"Sawyer"]
[74445,null,null,null,"Sayre"]
[74446,null,null,null,"Schulter"]
[74447,null,null,null,"Scraper"]
[74450,null,null,null,"Seiling"]
[74451,null,null,null,"Seminole"]
[74452,null,null,null,"Sentinel"]
[74454,null,null,null,"Sequoyah"]
[74455,null,null,null,"Shady Grove"]
[74456,null,null,null,"Shady Grove CDP (McIntosh County)"]
[74457,null,null,null,"Shady Point"]
[74458,null,null,null,"Shamrock"]
[74459,null,null,null,"Sharon"]
[74460,null,null,null,"Shattuck"]
[74461,null,null,null,"Shawnee"]
[74462,null,null,null,"Shidler"]
[74463,null,null,null,"Short"]
[74464,null,null,null,"Silo"]
[74465,null,null,null,"Simms"]
[74466,null,null,null,"Skedee"]
[74467,null,null,null,"Skiatook"]
[74468,null,null,null,"Slaughterville"]
[74469,null,null,null,"Slick"]
[74470,null,null,null,"Smith Village"]
[74471,null,null,null,"Smithville"]
[74472,null,null,null,"Snake Creek"]
[74477,null,null,null,"Snyder"]
[74501,null,null,null,"Soper"]
[74502,null,null,null,"Sour John"]
[74521,null,null,null,"South Coffeyville"]
[74522,null,null,null,"Sparks"]
[74523,null,null,null,"Spaulding"]
[74525,null,null,null,"Spavinaw"]
[74528,null,null,null,"Spencer"]
[74529,null,null,null,"Sperry"]
[74530,null,null,null,"Spiro"]
[74531,null,null,null,"Sportsmen Acres"]
[74533,null,null,null,"Springer"]
[74534,null,null,null,"St. Louis"]
[74535,null,null,null,"Steely Hollow"]
[74536,null,null,null,"Sterling"]
[74538,null,null,null,"Stidham"]
[74540,null,null,null,"Stigler"]
[74542,null,null,null,"Stillwater"]
[74543,null,null,null,"Stilwell"]
[74545,null,null,null,"Stonewall"]
[74546,null,null,null,"Stoney Point"]
[74547,null,null,null,"Strang"]
[74549,null,null,null,"Stratford"]
[74552,null,null,null,"Stringtown"]
[74553,null,null,null,"Strong City"]
[74554,null,null,null,"Stroud"]
[74555,null,null,null,"Stuart"]
[74556,null,null,null,"Sugden"]
[74557,null,null,null,"Sulphur"]
[74558,null,null,null,"Summit"]
[74559,null,null,null,"Sweetwater"]
[74560,null,null,null,"Swink"]
[74561,null,null,null,"Sycamore"]
[74562,null,null,null,"Taft"]
[74563,null,null,null,"Tagg Flats"]
[74565,null,null,null,"Tahlequah"]
[74567,null,null,null,"Talala"]
[74569,null,null,null,"Talihina"]
[74570,null,null,null,"Taloga"]
[74571,null,null,null,"Tamaha"]
[74572,null,null,null,"Tatums"]
[74574,null,null,null,"Tecumseh"]
[74576,null,null,null,"Temple"]
[74577,null,null,null,"Tenkiller"]
[74578,null,null,null,"Teresita"]
[74601,null,null,null,"Terlton"]
[74602,null,null,null,"Terral"]
[74603,null,null,null,"Texanna"]
[74604,null,null,null,"Texhoma"]
[74630,null,null,null,"Texola"]
[74631,null,null,null,"Thackerville"]
[74632,null,null,null,"The Village"]
[74633,null,null,null,"Thomas"]
[74636,null,null,null,"Tiawah"]
[74637,null,null,null,"Tipton"]
[74640,null,null,null,"Tishomingo"]
[74641,null,null,null,"Titanic"]
[74643,null,null,null,"Tonkawa"]
[74644,null,null,null,"Tribbey"]
[74646,null,null,null,"Tryon"]
[74647,null,null,null,"Tullahassee"]
[74650,null,null,null,"Tulsa"]
[74651,null,null,null,"Tupelo"]
[74652,null,null,null,"Turley"]
[74653,null,null,null,"Turpin"]
[74701,null,null,null,"Tushka"]
[74702,null,null,null,"Tuskahoma"]
[74720,null,null,null,"Tuttle"]
[74721,null,null,null,"Twin Oaks"]
[74722,null,null,null,"Tyrone"]
[74723,null,null,null,"Union City"]
[74724,null,null,null,"Valley Brook"]
[74726,null,null,null,"Valley Park"]
[74727,null,null,null,"Valliant"]
[74728,null,null,null,"Velma"]
[74729,null,null,null,"Vera"]
[74730,null,null,null,"Verden"]
[74731,null,null,null,"Verdigris"]
[74733,null,null,null,"Vian"]
[74734,null,null,null,"Vici"]
[74735,null,null,null,"Vinita"]
[74736,null,null,null,"Wagoner"]
[74737,null,null,null,"Wainwright"]
[74738,null,null,null,"Wakita"]
[74740,null,null,null,"Walters"]
[74741,null,null,null,"Wanette"]
[74743,null,null,null,"Wann"]
[74745,null,null,null,"Wapanucka"]
[74747,null,null,null,"Warner"]
[74748,null,null,null,"Warr Acres"]
[74750,null,null,null,"Warwick"]
[74752,null,null,null,"Washington"]
[74753,null,null,null,"Watonga"]
[74754,null,null,null,"Watts"]
[74755,null,null,null,"Wauhillau"]
[74756,null,null,null,"Waukomis"]
[74759,null,null,null,"Waurika"]
[74760,null,null,null,"Wayne"]
[74761,null,null,null,"Waynoka"]
[74764,null,null,null,"Weatherford"]
[74766,null,null,null,"Webb City"]
[74801,null,null,null,"Webbers Falls"]
[74802,null,null,null,"Welch"]
[74804,null,null,null,"Weleetka"]
[74818,null,null,null,"Welling"]
[74820,null,null,null,"Wellston"]
[74821,null,null,null,"West Peavine"]
[74824,null,null,null,"West Siloam Springs"]
[74825,null,null,null,"Westport"]
[74826,null,null,null,"Westville"]
[74827,null,null,null,"Wetumka"]
[74829,null,null,null,"Wewoka"]
[74830,null,null,null,"White Oak"]
[74831,null,null,null,"White Water"]
[74832,null,null,null,"Whitefield"]
[74833,null,null,null,"Whitesboro"]
[74834,null,null,null,"Wickliffe"]
[74836,null,null,null,"Wilburton"]
[74837,null,null,null,"Willow"]
[74839,null,null,null,"Wilson"]
[74840,null,null,null,"Winchester"]
[74842,null,null,null,"Wister"]
[74843,null,null,null,"Woodall"]
[74844,null,null,null,"Woodlawn Park"]
[74845,null,null,null,"Woodward"]
[74848,null,null,null,"Wright City"]
[74849,null,null,null,"Wyandotte"]
[74850,null,null,null,"Wynnewood"]
[74851,null,null,null,"Wynona"]
[74852,null,null,null,"Yale"]
[74854,null,null,null,"Yeager"]
[74855,null,null,null,"Yukon"]
[74856,null,null,null,"Zeb"]
[74857,null,null,null,"Zena"]
[74859,null,null,null,"Zion"]
[74860]
[74864]
[74865]
[74866]
[74867]
[74868]
[74869]
[74871]
[74872]
[74873]
[74875]
[74878]
[74880]
[74881]
[74883]
[74884]
[74901]
[74902]
[74930]
[74931]
[74932]
[74935]
[74936]
[74937]
[74939]
[74940]
[74941]
[74942]
[74943]
[74944]
[74945]
[74946]
[74947]
[74948]
[74949]
[74951]
[74953]
[74954]
[74955]
[74956]
[74957]
[74959]
[74960]
[74962]
[74963]
[74964]
[74965]
[74966]

{"sheet":"Validation Rules","index":5,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":true,"merged":[[32,10,33,10],[7,10,8,10],[18,10,19,10],[32,4,33,4],[32,5,33,5],[32,6,33,6],[32,8,33,8],[32,9,33,9]]}
["Section","Column Name","Spreadsheet input format","Spreadsheet automated format","Current database column name","DB Data Type","DB Length in segment tables","Processing ","Validation Rules","Possible Error Message","Comments/Clarifications"]
[null,"VALIDATION","formula","Max 10 chars","IGNORE-For end-user only","varchar",10,null,"IGNORE-do not parse"]
[null,"PT_LASTNAME","string","Max 50 chars","PID_5_PatientName_FamilyLastName","varchar",50,null,"Validate present\nValidate length","Patient Last Name is missing\nPatient Last Name exceeds 50 characters\n\n","Convert to uppercase"]
[null,"PT_FIRSTNAME","string","Max 50 chars","PID_5_PatientName_GivenName","varchar",50,null,"Validate present\nValidate length","Patient First Name is missing\nPatient First Name exceeds 50 characters\n","Convert to uppercase"]
[null,"PT_MIDDLEINITIAL","string","Max 1 chars","PID_5_PatientName_MiddleInitialOrName","varchar",1,null,"Validate length","Patient Initial exceeds 1 character\n","Take only first letter. Convert to uppercase"]
[null,"PT_DOB","MM/DD/YYYY ",null,"PID_7_DateOfBirth","date",null,null,"Validate present     Validate the format to be MM/DD/YYYY \nValidated date must be prior to spec_dt  \nVaildated date can't be future date\nVaildated date can't be prior to 1/1/1900","Date of Birth is missing\nDate of Birth  is an invalid format\nDate of Birth  cannot be a future date\nDate of Birth must be before specimen collection date\nDate of Birth cannot be before 1/1/1900"]
[null,"PT_PHONE","10 digit number",null,"PID_13_PhoneNumberHome_AreaCityCode\nPID_13_PhoneNumberHome_PhoneNumber","varchar",10,null,"Validate Length","Patient Phone number has to be 10 digits\n"]
["Patient Information","PT_ADDRESS","string","Max 50 chars","PID_11_PatientAddress_StreetAddress","varchar",50,null,"Validate present\nValidate length","Patient Address exceeds 50 characters \nPatient Address and Address2 exceeds 75 characters."]
[null,"PT_ADDRESS2","string","Max 25 chars","PID_11_PatientAddress_StreetAddress","varchar",25,null,"Validate Length","Patient Address & Address 2 exceeds 75"]
[null,"PT_CITY","string","Max 50 chars","PID_11_PatientAddress_City","varchar",50,null,"Validate present\nValidate length","Patient City is missing\nPatient City cannot exceed 50 characters\n"]
[null,"PT_STATE","Drop down (String)","Max 2 chars","PID_11_PatientAddress_StateOrProvince","varchar",2,null,"Validate value\n","Patient State is  invalid. It has to be a valid U.S  state.","Default is OK  should not be reporting patients who reside in another state\n"]
[null,"PT_ZIP","5 digit number","XXXXX","PID_11_PatientAddress_ZipOrPostalCode","varchar",5,null,"Validate present\nValidate length","Patient Zipcode is missing\nPatient Zip cannot exceed 5 characters\n"]
[null,"PT_COUNTY","string","Max 50 chars-Spreadsheet contains all 77 counties with correct spellings and will alert to incorrect entry"," Patient County (PID_11_9)","varchar",50,null,"Validate length","Patient County may be missing"]
[null,"PT_SEX","Drop down (String)","Max 1 char","PID_8_Sex","varchar",1,null,"Validate present     Validate length as 1 digit\nValidate value","Gender is missing\nGender is invalid","Must translate into HL7 standard vocabulary or acceptable HHLPSS. Convert to uppercase"]
[null,"PT_RACE","Drop down (String)","Max 10 chars","PID_10_Race/CE_0005_0_Identifier\nPID_10_Race/CE_0005_1_Text\nPID_10_Race/CE_0005_2_NameOfCodingSystem","varchar",10,null,"Validate value","Race is invalid","Must translate into HL7 standard vocabulary or acceptable HHLPSS standards\nConvert to uppercase"]
[null,"PT_ETHNICITY","Drop down (String)","Max 10 chars","PID_22_EthnicGroup/CE_0189_0_Identifier\nPID_22_EthnicGroup/CE_0189_1_Text\nPID_22_EthnicGroup/CE_0189_2_NameOfCodingSystem","varchar",10,null,"Validate value","Ethnicity is invalid","Must translate into HL7 standard vocabulary or acceptable HHLPSS standards\nConvert to uppercase"]
[null,"MEDICAID","string","Max 15 chars","???","varchar",15,null,"Validate Length","Must not exceed 15 characters"]
[null,"SSN","string","Max 11 chars","PID_???","varchar",11,null,"Validate Length","Must not exceed 9 characters, no dashes","Remove dashes"]
[null,"G_LASTNAME","string","Max 50 chars","NK1_2_Name_FamilyLastName","varchar",50,null,"Validate Length","Guardian Last Name exceeds 50 characters"]
["Guardian Info","G_FIRSTNAME","string","Max 50 chars","NK1_2_Name_GivenName","varchar",50,null,"Validate Length","Guardian First Name exceeds 50 characters"]
[null,"DATE_DRAWN","MM/DD/YYYY ","MM/DD/YYYY","OBR_7_ObservationDateTime","datetime",null,null,"Validate Present  Validate the format to be MM/DD/YYYY\n Vaildate date which can't be future date\nVaildate date which can't be prior to date of birth\nVaildate date after 1/1/1900  \n ","Specimen Collection date is missing\nSpecimen Collection date is an invalid format\nSpecimen Collection date cannot be a future date\nSpecimen Collection date cannot be before date of birth\nSpecimen Collection date cannot be prior to 1/1/1900","This is the date specimen was collected"]
[null,"DATE_ANALYZED","MM/DD/YYYY ","MM/DD/YYYY","OBX_14_DateTimeOfTheObservation/TS_0_TimeOfAnEvent","datetime",null,null,"Validate Present  Validate the format to be MM/DD/YYYY\nValidate date which can't be prior to spec_dt  Vaildate date which can't be future date\nVaildate date which can't be prior to date of birth\nVaildate date after 1/1/1900  \n ","Analysis Date is missing\nAnalysis Date is an invalid format\nAnalysis Date cannot  be a future date\nAnalysis Date cannot be prior to specimen collection date\nAnalysis Date cannot be prior to date of birth\nAnalysis Date cannot be before 1/1/1900"]
["Blood Test Information","SAMPLE_TYPE","Drop down (String)",null,"if (SAMPLE_TYPE == \"V\") then  OBR_15_SpecimenSource/SPS_0_SpecimenSourceNameOrCode/SPS_0_0_Identifier = BLDV\nif (SAMPLE_TYPE == \"C\") then OBR_15_SpecimenSource/SPS_0_SpecimenSourceNameOrCode/SPS_0_0_Identifier = BLDC\n","varchar",100,null,"Valiate present\nValidate value","Sample Type is missing\nSample Type is invalid","Must translate into acceptable HHLPSS Convert to UPPERCASE"]
[null,"RESULT","string","Max 50 chars","OBX_5_ObservationValue/XVAR_0\n\n","varchar\n",50,null,"Validate present\nValidate length\n","Result is missing\nResult exceeds 50 characters\n","If \"Low\" convert to <3.3"]
[null,"INSTITUTION_NAME","string","Max 50 chars","ORC_21_OrderingFacilityName","varchar",50,null,"Validate present IF PROVIDER_LASTNAME AND PROVIDER_FIRSTNAME is NOT present\nValidate length ","Institution Name OR Provider Last Name AND First Name is missing\nINSTITUTION_ID length exceeds 50 characters"]
[null,"INSTITUTION_ADDRESS ","string","Max 120 chars",null,"varchar",120,null,"\nValidate length","Performing INSTITUTION address is missing  (IS NOT REQUIRED)\nPerforming Lab address cannot exceed 120 characters"]
["Analyzing Laboratory Information","INSTITUTION_ADDRESS2","string","Max 50 chars",null,"varchar",50,null,"Validate length\nValidate length of INSTITUTION_ADDRESS and INSTITUTION_ADDRESSS2","(DOES NOT HAVE TO BE PRESENT) Performing INSTITUTION_ADDRESS 2 cannot exceed 50 characters\nPerforming INSTITUTION_ADDRESS and ADDRESS 2 exceeds 120 character"]
[null,"INSTITUTION_CITY","String","Max 50 chars",null,"varchar",50,null,"\nValidate length","Performing INSTITUTION_City MAY BE MISSING\nPerforming INSTITUTION_City cannot exceed 50 characters"]
["for LeadCare II users, this would be the facility information","INSTITUTION_STATE","String","Max 2 chars",null,"varchar",2,null,"\nValidate value","Performing INSTITUTION_State CAN BE MISSING\nPerforming INSTITUTION State is  invalid. It has to be a valid US State or territory. \n"]
[null,"INSTITUTION_ZIP","5 digit number","xxxxx",null,"varchar",5,null,"Validate length","Performing INSTITUTE_Zip CAN BE MISSING\n\n"]
["Ordering Physician Information","PROV_LASTNAME","string","Max 50 chars","OBR_16_OrderingProvider_GivenName","varchar",50,null,"Validate present\nValidate Length","Provider Last Name CAN BE MISSING IF INSTITUTION_NAME is PRESENT\nProvider Last Name exceeds 50 characters.\n"]
[null,"PROV_FIRSTNAME","string","Max 50 chars","OBR_16_OrderingProvider_FamilyLastName","varchar",50,null,"Validate present\nValidate Length","Provider First Name MUST BE PRESENT IF PROVIDER_LASTNAME is LISTED AND INSTITUTION_NAME is BLANK\nProvider First Name exceeds 50 characters.\n"]
[null,"PROV_ADDRESS","string","Max 50 chars","ORC_22_OrderingFacilityAddress_StreetAddress\nORC_24_OrderingProviderAddress_StreetAddress","varchar",75,null,"Validate Length","Provider_Address may be MISSING  Provider Address exceeds 50 characters \nProvider Address2 exceeds 25 characters \nProvider Address and Address 2 exceeds 75 characters."]
[null,"PROV_ADDRESS2","string","Max 25 chars",{"$nulls":5},"Apt_nbr "]
[null,"PROV_CITY","string","Max 50 chars","ORC_22_OrderingFacilityAddress_City\nORC_24_OrderingProviderAddress_City","varchar",50,null,"Validate Length","IF PRESENT (MAY BE MISSING) Provider City exceeds 50 character"]
[null,"PROV_STATE","string","Max 2 chars","ORC_22_OrderingFacilityAddress_StateOrProvince\nORC_24_OrderingProviderAddress_StateOrProvince","varchar",2,null,"Validate value","IF PRESENT (MAY BE MISSING) Provider State is  invalid. It has to be a valid US State or territory. \n","MUST BE VALID US STATE or TERRITORY"]
[null,"PROV_ZIP","string","XXXXX","ORC_22_OrderingFacilityAddress_ZipOrPostalCode\nORC_24_OrderingProviderAddress_ZipOrPostalCode","varchar",5,null,"Truncate to first ten characters","MAY BE MISSING, Validate length, if present"]
["COMMENT","COMMENT","string","Max 300 chars",null,"varchar",300,null,"No Validation"]
["DEFAULT VALUES","ANALYZING_LAB","string","Max 15 chars",null,"varchar",15,null,"Validate to default \"LEAD CARE II\"","IF BLANK-INSERT \"LEAD CARE II\""]
[null,"CLIA_NUMBER","string","Max 15 chars",null,"varchar",15,null,"Validate to default \"NON-CLIA EXEMPT\"","IF BLANK-INSERT\"NON-CLIA EXEMPT\""]
{"$rows_empty":7}
["NOTE:","Items in column B which are \"RED\" are required fields and must be present and validated, those in YELLOW can be present, some may be autofilled through RHAPSODY if blank."]