Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

DescriptionThis 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

SettingNursing Home
TypeEntity
FrequencyMonthly
FormatXLS

...

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

See Nursing Home Measures

...