value_sources
Summary
This table contains data on the sources that provide information to populate the entity_values table; its primary key is the source_id. Each data point in the entity_values table can be linked to a source from this table.
Fields
| field | type | attributes | notes | example |
|---|---|---|---|---|
| source_id | int(11) | NOT NULL AUTO_INCREMENT | Provided by Pellucid | 1234 |
| title | text | NOT NULL | Provided by source | New Jersey Department of Health |
| update_frequency | enum('triennial','biennial','annual','quarterly','monthly','weekly','daily','hourly','ondemand','unknown') | NOT NULL DEFAULT 'unknown' | Determined by IPRO | annual |
| update_type | enum('rolling','append','snapshot') | NOT NULL DEFAULT 'rolling' | Determined by IPRO | rolling |
| geo_coverage | enum('world','us','state','county','city','zip','facility') | NOT NULL DEFAULT 'world' | Provided by source | world |
| file_format | enum('csv','fixedlength','xls','mdb','sql') | NOT NULL DEFAULT 'world' | Provided by source | world |
| provider_coverage | enum('h','nh','hh','po','cc') | NOT NULL DEFAULT 'h' | Provided by source | h |
| provider_payor | enum('allpayor','medicare','medicaid','private','other') | NOT NULL DEFAULT 'allpayor' | Provided by source | allpayor |
| owner | text | NOT NULL | Provided by source | NJ Department of Health Data |
| owner_public_url | text | NOT NULL | http://datasource.ipro.fakewebsite.com/ | |
| owner_data_url | text | NOT NULL | ||
| short_desc | text | NOT NULL | Produced by IPRO | The department of health for state X |
| long_desc | text | NOT NULL | Produced by IPRO | The department of health for state X. Chartered and operated by soandso, they are responsible for... |
| pellucid_loc | text | NOT NULL | Provided by IPRO | |
| dua_url | text | NOT NULL | http://datasource.ipro.fakewebsite.com/dua | |
| acquisition_contact_name | text | NOT NULL | Determined by IPRO | John Smith |
| acquisition_contact_email | text | NOT NULL | Determined by IPRO | jsmith@doh.statex |
| acquisition_contact_telephone | text | NOT NULL | Determined by IPRO | 1235550001 |
| created | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' | Date the row was created in YYYY-MM-DD HH:MM:SS format | 2009-01-24 13:52:39 |
| modified | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, | Date the row was last edited in YYYY-MM-DD HH:MM:SS format | 2009-03-14 09:08:12 |