Baselight

HHSC CCL Non-Compliance Data

City of Austin

@usgov.city_of_austin_hhsc_ccl_non_compliance_data

Loading...
Loading...

About this Dataset

HHSC CCL Non-Compliance Data

This Data set contains all the non-compliance detail information for the specific section evaluated. The Operation ID, Activity ID and Section ID can be used to link back to the Activity records, Activity Section record, and Operation record files.
Organization: City of Austin
Last updated: 2023-08-25T23:33:07.552991
Tags: ccl, child-care, complicance, hhsc, non-compliance, noncompliance

Tables

Table 1

@usgov.city_of_austin_hhsc_ccl_non_compliance_data.table_1
  • 13.59 MB
  • 147756 rows
  • 11 columns
Loading...

CREATE TABLE table_1 (
  "operation_id" BIGINT,
  "activity_id" BIGINT,
  "section_id" BIGINT,
  "non_compliance_id" BIGINT,
  "standard_number_description" VARCHAR,
  "standard_risk_level" VARCHAR,
  "corrected_at_inspection" VARCHAR,
  "corrected_date" VARCHAR,
  "date_correction_verified" VARCHAR,
  "narrative" VARCHAR,
  "technical_assistance_given" VARCHAR
);

Share link

Anyone who has the link will be able to view this.