| Column | Verbose Name | Type | Business Data Type | Groupable | Filterable | Is temporal | Extra | |
|---|---|---|---|---|---|---|---|---|
| code | None | VARCHAR(3) | None | None | ||||
| total_number | None | INTEGER | None | None | ||||
| meet_standard | None | INTEGER | None | None | ||||
| meet_standard_percentage | None | NUMERIC(7, 4) | None | None | ||||
| have_at_least_one_mou | None | INTEGER | None | None | ||||
| have_at_least_one_mou_percentage | None | NUMERIC(7, 4) | None | None | ||||
| have_authorization | None | INTEGER | None | None | ||||
| have_authorization_percentage | None | NUMERIC(7, 4) | None | None | ||||
| year | INTEGER | None | None |
| Metric | Verbose Name | Type | Extra | |
|---|---|---|---|---|
| sum__year | None | sum | None | |
| avg__year | None | avg | None | |
| sum__total_number | None | sum | None | |
| avg__total_number | None | avg | None | |
| sum__meet_standard | None | sum | None | |
| avg__meet_standard | None | avg | None | |
| sum__meet_standard_percentage | None | sum | None | |
| avg__meet_standard_percentage | None | avg | None | |
| sum__have_at_least_one_mou | None | sum | None | |
| avg__have_at_least_one_mou | None | avg | None | |
| sum__have_at_least_one_mou_percentage | None | sum | None | |
| avg__have_at_least_one_mou_percentage | None | avg | None | |
| sum__have_authorization | None | sum | None | |
| avg__have_authorization | None | avg | None | |
| sum__have_authorization_percentage | None | sum | None | |
| avg__have_authorization_percentage | None | avg | None | |
| count | COUNT(*) | count | None |
| Table Name | overall_care_facilities_data |
|---|---|
| Sql | None |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | UNICEF Cambodia |
| Schema | public |
| Description | None |
| Owners | [Ona ] |
| Main Datetime Column | None |
| Default Endpoint | None |
| Offset | 0 |
| Cache Timeout | None |
| SQL Lab View | False |
| Template parameters | None |
| Extra | None |
| Normalize Columns | True |
| Always Filter Main Dttm | False |
| Perm | [UNICEF Cambodia].[overall_care_facilities_data](id:49) |
| Associated Charts | [Total Number of RCIs Inspected, Number of RCIs with authorization, Percentage of RCIs that have Authorization, Percentage of RCIs with at least one mou, Percentage of RCIs with at least one mou, Overall has at least one mou, Inspection 2018, Total Number of RCIs Inspected, ភាគរយនៃមណ្ឌលថែទាំកុមារដែលអនុវត្តស្របតាមបទដ្ឋាន, ចំនួនសរុបនៃមណ្ឌលថែទាំកុមារដែលត្រូវបានធ្វើអធិការកិច្ច, Percentage of RCIs Meeting Standards, ចំនួនមណ្ឌលថែទាំកុមារដែលអនុវត្តស្របតាមបទដ្ឋាន, ចំនួនមណ្ឌលថែទាំកុមារ ដែល MoU យ៉ាងហោចណាស់មួយ, Number of RCIs with at least one mou, Number of RCIs Meeting standards, ភាគរយនៃមណ្ឌលថែទាំកុមារ ដែល MoU យ៉ាងហោចណាស់មួយ, Number of RCIs with at least one mou, Overall Meeting Standards, Percentage of RCIs that have Authorization, Overall has at least one mou, Overall Meeting Standards, Overall has authorization, Inspection 2018, Overall has authorization, ភាគរយនៃមណ្ឌលថែទាំកុមារដែលមានលិខិតអនុញ្ញាត, Percentage of RCIs Meeting Standards, Number of RCIs Meeting standards, ចំនួនមណ្ឌលថែទាំកុមារដែលមានលិខិតអនុញ្ញាត, Number of RCIs with authorization] |