{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DataSheet","Hidden Data","Help"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"DataSheet","index":0,"n_rows":17,"n_cols":48,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Id","TrustId","SubmissionId","MetaSubmissionId","Research Ethics Committee Reference Number","Integrated Research Application System Number","Submission Type","Name of Trial","Date of Receipt of Valid Research Application","Date of NHS Permission","First Patient Recruited?","Date of First Patient Recruited","Duration between VRA and NHS Permission","Duration between NHS Permission and First Patient","Duration between VRA and First Patient","Benchmark Met","Date Study Initiated","Date Site Invited","Date Site Selected","HRA Approval Date","Date Site Confirmed By Sponsor","Date Site Confirmed","Non-Confirmation Status","Date Site Ready To Start","AddedByUserId","AmendedByUserId","DateAdded","DateAmended","A - Permissions delayed/denied","B - Suspended by sponsor","C - Closed by sponsor","D - Sponsor Delays","E - Staff availability issues","F - No patients seen","G - No patients consented","H - Contracting delays","I - Rare diseases","J - Other","K - Not Used","L - Not Used","M - Not Used","N - Not Used","O - Not Used","Comments","Reasons for delay correspond to:",null,"Errors","Warnings"]
[78122,1078,3697,37,"14/YH/1199",153953,"NHS Permission","\"GALACTIC: GA-101 (obinutuzumab) monocLonal Antibody as Consolidation Therapy In CLL \n\n\n \n\n \n\"","2015-04-07","2015-04-08","Yes","2015-06-04",1,57,58,"Yes",null,null,null,null,null,null,null,null,"Unknown","Unknown","2016-04-28","2016-04-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please Select..."]
[78123,1078,3697,37,"13/LO0108",112000,"NHS Permission","LEGEND: RCT in second-line treatment of Diffuse Large B-cell lymphoma (DLBCL)","2015-04-02","2015-04-02","No",null,0,null,null,null,null,null,null,null,null,null,null,null,"Unknown","Unknown","2016-04-28","2016-04-28",null,null,null,null,null,null,null,null,null,"Y",null,null,null,null,null,"No patients passed screening yet","Neither"]
[78124,1078,3697,37,"14/NW/1373",163963,"NHS Permission","DS-5565 in pain associated with fibromyalgia (FM)","2015-04-29","2015-04-29","No",null,0,null,null,null,null,null,null,null,null,null,null,null,"Unknown","Unknown","2016-04-28","2016-04-28",null,null,"Y",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sponsor"]
[78125,1078,3697,37,"14/NW/1258",161891,"NHS Permission","(ARAMIS) A Multinational, Randomised, Double-Blind, Placebo-Controlled,Phase III Efficacy And Safety Study Of ODM-201 In Men With High-Risk Non-Metastatic Castration-Resistant Prostate Cancer (ARAMIS STUDY)","2015-05-14","2015-05-14","Yes","2016-01-25",0,256,256,"No",null,null,null,null,null,null,null,null,"Unknown","Unknown","2016-04-28","2016-04-28",null,null,null,null,"Y",null,null,null,null,null,null,null,null,null,null,null,"NHS Provider"]
[78126,1078,3697,37,"14/NW/0006",140059,"NHS Permission","LPEffect of calcipotriol plus betamethasone dipropionate gel on the hpa axis and calcium metabolism in adolescent subjects (aged 12 to 16 years, 11 months) with scalp and body psoriasis","2015-07-13","2015-07-13","Yes","2015-07-27",0,14,14,"Yes",null,null,null,null,null,null,null,null,"Unknown","Unknown","2016-04-28","2016-04-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please Select..."]
[78127,1078,3697,37,"15/SC/0443",173722,"NHS Permission","CAIN457A3302 - OPTIMISE STUDY","2015-10-20","2015-10-22","Yes","2015-12-03",2,42,44,"Yes",null,null,null,null,null,null,null,null,"Unknown","Unknown","2016-04-28","2016-04-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please Select..."]
[78128,1078,3697,37,"14/YH/1259",163195,"NHS Permission","ALPHA: Comparison of Alitretinoin with PUVA as the first line treatment in patient with severe chronic hand eczema","2015-11-05","2015-11-06","No",null,1,null,null,null,null,null,null,null,null,null,null,null,"Unknown","Unknown","2016-04-28","2016-04-28","Y",null,null,null,"Y",null,null,null,null,"Y",null,null,null,null,null,"Staff availability for PUVA.  R&D have arranged for specialist training of Research Nurses at cost","NHS Provider"]
[78129,1078,3697,37,"15/YO/0428",188418,"NHS Permission","4228: DUAL? VIII ? Durability, IDegLira vs IGlar in Type 2 diabetes","2015-11-30","2015-12-04","Yes","2016-02-24",4,82,86,"No","2015-11-27",null,null,null,null,"2015-09-08",null,null,"Unknown","Unknown","2016-04-28","2016-04-28",null,null,null,null,null,null,"Y",null,null,null,null,null,null,null,null,null,"NHS Provider"]

{"sheet":"Hidden Data","index":1,"n_rows":20,"n_cols":90,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[null,"SpreadsheetOne - Hidden Data"]
[]
[null,"******** PLEASE DO NOT CHANGE ANY OF THESE VALUES ********"]
[]
[null,"Hidden Data Key","Hidden Data Value",null,"XML",null,"Class"]
[null,"Is First Open","FALSE",null,"<?xml version=\"1.0\" encoding=\"utf-16\"?>\r\n<DataTableDataExportContainerOfPerformanceInitiationDetail xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\r\n\t<DataTypeName>Exbos.Applications.NHSRBVP.Components.BusinessObjects.PerformanceInitiationDetail, Exbos.Applications.NHSRBVP.Components.BusinessObjects, Version=1.0.10.0, Culture=neutral, PublicKeyToken=null</DataTypeName>\r\n\t<Site Id=\"1\" AddressId=\"-1\" StatusId=\"51\" TypeId=\"401\" CultureId=\"1\" AddedByUserId=\"1\" AmendedByUserId=\"1\" DateAdded=\"2013-06-15T22:56:16\" DateAmended=\"2013-06-15T22:56:16\">\r\n\t\t<Name>CTP Submission Platform</Name>\r\n\t\t<Description/>\r\n\t</Site>\r\n</DataTableDataExportContainerOfPerformanceInitiationDetail>\r\n",null,"PerformanceInitiationDetail"]
[null,"Development Mode","FALSE"]
[null,"Data Id",3697]
[null,"User Id",-1]
[null,"Data Id",40]
["<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>1</Order>\r\n\t<Name>Id</Name>\r\n\t<FriendlyName>Id</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>true</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>2</Order>\r\n\t<Name>TrustId</Name>\r\n\t<FriendlyName>TrustId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">1078</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>3</Order>\r\n\t<Name>SubmissionId</Name>\r\n\t<FriendlyName>SubmissionId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">3697</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>4</Order>\r\n\t<Name>MetaSubmissionId</Name>\r\n\t<FriendlyName>MetaSubmissionId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">37</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>NotEmpty</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>5</Order>\r\n\t<Name>ReferenceNumber</Name>\r\n\t<FriendlyName>Research Ethics Committee Reference Number</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>6</Order>\r\n\t<Name>IntegratedResearchNumber</Name>\r\n\t<FriendlyName>Integrated Research Application System Number</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>7</Order>\r\n\t<Name>InitiationSubmissionTypeId</Name>\r\n\t<FriendlyName>Submission Type</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2800</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2801</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>NHS Permission</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2802</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>HRA Approval</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>NotEmpty</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>8</Order>\r\n\t<Name>TrialName</Name>\r\n\t<FriendlyName>Name of Trial</FriendlyName>\r\n\t<UseTextArea>true</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>2000</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>9</Order>\r\n\t<Name>ReceiptDate</Name>\r\n\t<FriendlyName>Date of Receipt of Valid Research Application</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>true</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>10</Order>\r\n\t<Name>PermissionDate</Name>\r\n\t<FriendlyName>Date of NHS Permission</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>11</Order>\r\n\t<Name>FirstPatientRecruitedTypeId</Name>\r\n\t<FriendlyName>First Patient Recruited?</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>1400</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>1401</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Yes</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>1402</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Yes - Date Unavailable</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>1403</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>No</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>12</Order>\r\n\t<Name>FirstPatientRecruitedDate</Name>\r\n\t<FriendlyName>Date of First Patient Recruited</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>13</Order>\r\n\t<Name>ApplicationToPermissionDuration</Name>\r\n\t<FriendlyName>Duration between VRA and NHS Permission</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>true</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>true</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>14</Order>\r\n\t<Name>PermissionToFirstPatientDuration</Name>\r\n\t<FriendlyName>Duration between NHS Permission and First Patient</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>true</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>true</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>15</Order>\r\n\t<Name>ApplicationToFirstPatientDuration</Name>\r\n\t<FriendlyName>Duration between VRA and First Patient</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>true</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>true</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>16</Order>\r\n\t<Name>BenchmarkMetTypeId</Name>\r\n\t<FriendlyName>Benchmark Met</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>1500</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>1501</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Yes</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>1502</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>No</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>1503</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Within 70 Days</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>-1</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Please Select...</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>true</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>true</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>17</Order>\r\n\t<Name>StudyInitiatedDate</Name>\r\n\t<FriendlyName>Date Study Initiated</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>true</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>18</Order>\r\n\t<Name>SiteInvitedDate</Name>\r\n\t<FriendlyName>Date Site Invited</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>true</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>19</Order>\r\n\t<Name>SiteSelectedDate</Name>\r\n\t<FriendlyName>Date Site Selected</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>true</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>20</Order>\r\n\t<Name>HRAApprovalDate</Name>\r\n\t<FriendlyName>HRA Approval Date</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>true</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>21</Order>\r\n\t<Name>SponsorConfirmedDate</Name>\r\n\t<FriendlyName>Date Site Confirmed By Sponsor</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>true</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>22</Order>\r\n\t<Name>SiteConfirmedDate</Name>\r\n\t<FriendlyName>Date Site Confirmed</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>true</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>23</Order>\r\n\t<Name>NonConfirmationTypeId</Name>\r\n\t<FriendlyName>Non-Confirmation Status</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2900</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2901</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Sponsor declined site confirmation</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2902</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Site declined to participate</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>-1</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Please Select...</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>24</Order>\r\n\t<Name>SiteReadyToStartDate</Name>\r\n\t<FriendlyName>Date Site Ready To Start</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>true</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>25</Order>\r\n\t<Name>AddedByUserId</Name>\r\n\t<FriendlyName>AddedByUserId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>Site</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>181</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Unknown</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>26</Order>\r\n\t<Name>AmendedByUserId</Name>\r\n\t<FriendlyName>AmendedByUserId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>Site</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>329</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Unknown</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>27</Order>\r\n\t<Name>DateAdded</Name>\r\n\t<FriendlyName>DateAdded</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">2016-04-28T10:03:44.474+01:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>28</Order>\r\n\t<Name>DateAmended</Name>\r\n\t<FriendlyName>DateAmended</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">2016-04-28T10:03:44.474+01:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>29</Order>\r\n\t<Name>NotMetATypeId</Name>\r\n\t<FriendlyName>A - Permissions delayed/denied</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>30</Order>\r\n\t<Name>NotMetBTypeId</Name>\r\n\t<FriendlyName>B - Suspended by sponsor</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>31</Order>\r\n\t<Name>NotMetCTypeId</Name>\r\n\t<FriendlyName>C - Closed by sponsor</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>32</Order>\r\n\t<Name>NotMetDTypeId</Name>\r\n\t<FriendlyName>D - Sponsor Delays</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>33</Order>\r\n\t<Name>NotMetETypeId</Name>\r\n\t<FriendlyName>E - Staff availability issues</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>34</Order>\r\n\t<Name>NotMetFTypeId</Name>\r\n\t<FriendlyName>F - No patients seen</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>35</Order>\r\n\t<Name>NotMetGTypeId</Name>\r\n\t<FriendlyName>G - No patients consented</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>36</Order>\r\n\t<Name>NotMetHTypeId</Name>\r\n\t<FriendlyName>H - Contracting delays</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>37</Order>\r\n\t<Name>NotMetITypeId</Name>\r\n\t<FriendlyName>I - Rare diseases</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>38</Order>\r\n\t<Name>NotMetJTypeId</Name>\r\n\t<FriendlyName>J - Other</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>39</Order>\r\n\t<Name>NotMetKTypeId</Name>\r\n\t<FriendlyName>K - Not Used</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>40</Order>\r\n\t<Name>NotMetLTypeId</Name>\r\n\t<FriendlyName>L - Not Used</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>41</Order>\r\n\t<Name>NotMetMTypeId</Name>\r\n\t<FriendlyName>M - Not Used</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>42</Order>\r\n\t<Name>NotMetNTypeId</Name>\r\n\t<FriendlyName>N - Not Used</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>43</Order>\r\n\t<Name>NotMetOTypeId</Name>\r\n\t<FriendlyName>O - Not Used</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2200</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2201</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Y</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2202</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>\r\n\t\t\t\t</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>false</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">2202</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>44</Order>\r\n\t<Name>Comments</Name>\r\n\t<FriendlyName>Comments</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>500</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>45</Order>\r\n\t<Name>ReasonForDelayTypeId</Name>\r\n\t<FriendlyName>Reasons for delay correspond to:</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2300</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2301</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>NHS Provider</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2302</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Sponsor</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2303</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Both</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2304</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Neither</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>-1</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Please Select...</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>false</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>"]
["Id",null,"TrustId",null,"SubmissionId",null,"MetaSubmissionId",null,"Research Ethics Committee Reference Number",null,"Integrated Research Application System Number",null,"Submission Type",null,"Name of Trial",null,"Date of Receipt of Valid Research Application",null,"Date of NHS Permission",null,"First Patient Recruited?",null,"Date of First Patient Recruited",null,"Duration between VRA and NHS Permission",null,"Duration between NHS Permission and First Patient",null,"Duration between VRA and First Patient",null,"Benchmark Met",null,"Date Study Initiated",null,"Date Site Invited",null,"Date Site Selected",null,"HRA Approval Date",null,"Date Site Confirmed By Sponsor",null,"Date Site Confirmed",null,"Non-Confirmation Status",null,"Date Site Ready To Start",null,"AddedByUserId",null,"AmendedByUserId",null,"DateAdded",null,"DateAmended",null,"A - Permissions delayed/denied",null,"B - Suspended by sponsor",null,"C - Closed by sponsor",null,"D - Sponsor Delays",null,"E - Staff availability issues",null,"F - No patients seen",null,"G - No patients consented",null,"H - Contracting delays",null,"I - Rare diseases",null,"J - Other",null,"K - Not Used",null,"L - Not Used",null,"M - Not Used",null,"N - Not Used",null,"O - Not Used",null,"Comments",null,"Reasons for delay correspond to:"]
["Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value"]
["blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",2801,"NHS Permission","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",1401,"Yes","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",1501,"Yes","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",2901,"Sponsor declined site confirmation","blank£%X_@#","blank£%X_@#",181,"Unknown",329,"Unknown","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y",2201,"Y","blank£%X_@#","blank£%X_@#",2301,"NHS Provider"]
[null,null,null,null,null,null,null,null,null,null,null,null,2802,"HRA Approval",null,null,null,null,null,null,1402,"Yes - Date Unavailable",null,null,null,null,null,null,null,null,1502,"No",null,null,null,null,null,null,null,null,null,null,null,null,2902,"Site declined to participate",null,null,"blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",null,null,null,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,2202,null,null,null,2302,"Sponsor"]
[null,null,null,null,null,null,null,null,null,null,null,null,"blank£%X_@#","blank£%X_@#",null,null,null,null,null,null,1403,"No",null,null,null,null,null,null,null,null,1503,"Within 70 Days",null,null,null,null,null,null,null,null,null,null,null,null,-1,"Please Select...",null,null,null,null,null,null,null,null,null,null,"blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",null,null,2303,"Both"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"blank£%X_@#","blank£%X_@#",null,null,null,null,null,null,null,null,-1,"Please Select...",null,null,null,null,null,null,null,null,null,null,null,null,"blank£%X_@#","blank£%X_@#",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2304,"Neither"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"blank£%X_@#","blank£%X_@#",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1,"Please Select..."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"blank£%X_@#","blank£%X_@#"]

{"sheet":"Help","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null," Spreadsheet Help"]