An Example of A NYSDOH File
- Jaz-Michael King (Unlicensed)
Owned by Jaz-Michael King (Unlicensed)
| Description | This file contains information about the number of windows each nursing home in NYS has. |
|---|---|
IPRO Custodian | Jaz-Michael King (Unlicensed) |
| Source Custodian | Bob McGuffrey, bmcguffrey@nys.gov 518 324 4567 |
| Setting | Nursing Home |
| Type | Entity |
| Frequency | Monthly |
| Format | XLS |
Business Rules
PFI must match with pellucid.local_id. Merge with bippety boppety, and place all in table X. Convert column F to decimal with 5 decimal places.
Merge id with id using the following SQL
UPDATE SET value FROM entity_values WHERE measure_id = 10677 AND date_end = ‘2009-12-31’
Calculate rank and populate field_name with value.
Lots
And lots
Of Detail
Here
Associated Measures
Sample Row
001234,Bob's Nursing Home,5,1,2016-01-01