Search

Example response

{
  "DeaRecords": [
    {
      "DeaId": -5317254453966667000,
      "Name": {
        "PersonId": -6726432927766666000,
        "LastName": "John",
        "MiddleName": "W",
        "FirstName": "Doe",
        "Suffix": "JR",
        "TahoeId": "G-7277067792241666666",
        "Ssn": "266-50-xxxx",
        "FullName": "James W Smith JR"
      },
      "Address": {
        "HouseNumber": "1249",
        "StreetName": "Test",
        "StreetType": "BLVD",
        "StreetPostDirection": "NE",
        "City": "St Petersburg",
        "State": "FL",
        "ZipCode": "33704",
        "Zip4": "3035",
        "Latitude": "27.79670000",
        "Longitude": "-82.61030000",
        "FullAddress": "1249 Test NE BLVD; St Petersburg, FL 33704-3035"
      },
      "Details": {
        "DeaRegistrationNumber": "AS0132xxx",
        "BusinessActivityCode": "C",
        "BusinessActivitySubCode": "0",
        "BusinessDescription": "Practitioner",
        "DrugSchedules": "22N 33N 4 5",
        "MappedDrugSchedules": [
          "Schedule 2 Narcotic Controlled Substances"
        ],
        "ExpDate": "2/29/2020",
        "AdditionalInfo": "Acme Test Corp.",
        "PaymentInd": "P",
        "Activity": "A"
      }
    }
  ],
  "DeaRecordCounts": 1,
  "Pagination": {
    "CurrentPageNumber": 1,
    "ResultsPerPage": 500,
    "TotalPages": 1
  },
  "DatabaseQueryInfo": [
    {
      "DatabaseQueries": [
        {
          "Host": "smf3-posmysql-int-vip.pfnetwork.net",
          "Database": "dea_20180503",
          "DatabaseConnectionTimeInMs": 17,
          "DatabaseQuery": "CALL search_dea_v2_1(@p_business_name := null, @p_first_name := 'James', @p_middle_name := null, @p_last_name := 'Doe', @p_suffix_name := null, @p_house_number := null, @p_street_name := null, @p_unit := null, @p_city := 'st petersburg', @p_state := 'FL', @p_zip_code := null, @p_dea_id_list := null, @p_tahoe_id_list := null, @p_ssn := null, @p_output_bridge := True, @p_match_key_list := null, @p_apply_fn_syn := True, @p_record_limit := 500);",
          "ExecutionTimeInMs": 103
        }
      ]
    }
  ],
  "ExecutionStatistics": [
    {
      "Description": "Dea SP Client Search",
      "StartTime": 92,
      "ExecutionTimeInMs": 120
    }
  ],
  "TotalRequestExecutionTimeMs": 220,
  "RequestId": "d5234896-ae33-47cd-9060-c077198e71dd",
  "RequestType": "Search",
  "RequestTime": "2020-04-10T10:28:39.5408297-07:00"
}