VW_Kashi_Fac

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

OrgName

varchar

null

Code

varchar

null

AvaFacCode

varchar

null

View Definition

CREATE VIEW dbo.VW_Kashi_Fac AS

/*********************************************************************
Database:		DataCStore
View:			dbo.VW_Kashi_Fac
Created:		8/28/2020
Description:	View derived from spreadsheet provided by Daniel T.
                AvaFacCodes added based on visual inspection and cross
                reference to PCC.
*********************************************************************/

SELECT 'Avamere at Albany' AS OrgName,
           'AL6483'            AS Code,
           '840'               AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Bethany' AS OrgName,
           'YR3376'             AS Code,
           '335'                AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Cascadia Village' AS OrgName,
           'VX9112'                      AS Code,
           '841'                         AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Chestnut Lane' AS OrgName,
           'CL9145'                   AS Code,
           '711'                      AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Cheyenne' AS OrgName,
           'CW6433'              AS Code,
           '717'                 AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Englewood Heights' AS OrgName,
           'EH7294'                       AS Code,
           '720'                          AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Hermiston' AS OrgName,
           'KF8259'               AS Code,
           '712'                  AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Hillsboro' AS OrgName,
           'LL9006'               AS Code,
           '333'                  AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Lexington' AS OrgName,
           'LC4567'               AS Code,
           '714'                  AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Moses Lake' AS OrgName,
           'ML6621'                AS Code,
           '718'                   AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Mountain Ridge' AS OrgName,
           'MR4467'                    AS Code,
           '374'                       AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Newberg' AS OrgName,
           'NW8162'             AS Code,
           '330'                AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Oak Park' AS OrgName,
           'OP7321'              AS Code,
           '843'                 AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Park Place' AS OrgName,
           'PP5567'                AS Code,
           '713'                   AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Port Townsend' AS OrgName,
           'OG2237'                   AS Code,
           '844'                      AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Rio Rancho' AS OrgName,
           'RR4426'                AS Code,
           '715'                   AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Roswell' AS OrgName,
           'AR5710'             AS Code,
           '716'                AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Sandy' AS OrgName,
           'SY9409'           AS Code,
           '332'              AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Seaside' AS OrgName,
           'IX6497'             AS Code,
           '371'                AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Sherwood' AS OrgName,
           'SL3375'              AS Code,
           '331'                 AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at South Hill' AS OrgName,
           'SH3106'                AS Code,
           '719'                   AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at St. Helens' AS OrgName,
           'ST6238'                AS Code,
           '334'                   AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at The Stratford' AS OrgName,
           'OH6528'                   AS Code,
           '373'                      AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Three Fountains/Waterford' AS OrgName,
           'WE9276'                               AS Code,
           '263'                                  AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Waterford' AS OrgName,
           'WF7718'               AS Code,
           '263'                  AS AvaFacCode
    UNION ALL
    SELECT 'Avamere at Wenatchee' AS OrgName,
           'WQ1117'               AS Code,
           '842'                  AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Bellingham HC & Rehab Services' AS OrgName,
           'BC3766'                                 AS Code,
           '155'                                    AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Court at Keizer' AS OrgName,
           'BY0456'                  AS Code,
           '226'                     AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Crestview of Portland' AS OrgName,
           'PL2988'                        AS Code,
           '061'                           AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Heritage Rehab of Tacoma' AS OrgName,
           'TR5211'                           AS Code,
           '152'                              AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Living at Berry Park' AS OrgName,
           'BP5612'                       AS Code,
           '348'                          AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Olympic Rehabilitation of Sequim' AS OrgName,
           'SA7333'                                   AS Code,
           '119'                                      AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation at Fiesta Park' AS OrgName,
           'FJ8444'                                AS Code,
           '173'                                   AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Beaverton' AS OrgName,
           'BH9577'                              AS Code,
           '017'                                 AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Cascade Park' AS OrgName,
           'CP7433'                                 AS Code,
           '112'                                    AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Clackamas' AS OrgName,
           'LC4271'                              AS Code,
           '005'                                 AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Coos Bay' AS OrgName,
           'CF6377'                             AS Code,
           '004'                                AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Eugene' AS OrgName,
           'RE7222'                           AS Code,
           '001'                              AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Hillsboro' AS OrgName,
           'HL9216'                              AS Code,
           '028'                                 AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Junction City' AS OrgName,
           'JV0015'                                  AS Code,
           '006'                                     AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of King City' AS OrgName,
           'KE6807'                              AS Code,
           '010'                                 AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Lebanon' AS OrgName,
           'LG4663'                            AS Code,
           '008'                               AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Newport' AS OrgName,
           'NJ7933'                            AS Code,
           '015'                               AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Oregon City' AS OrgName,
           'OV8642'                                AS Code,
           '009'                                   AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Rehabilitation of Rogue Valley' AS OrgName,
           'VB7025'                                 AS Code,
           '071'                                    AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Riverpark of Eugene' AS OrgName,
           'EG1263'                      AS Code,
           '062'                         AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Skilled Nursing of Tacoma (Pacific Ridge)' AS OrgName,
           'NH6676'                                            AS Code,
           '154'                                               AS AvaFacCode
    UNION ALL
    SELECT 'Avamere TC & Rehab at Boise' AS OrgName,
           'AB4188'                      AS Code,
           '170'                         AS AvaFacCode
    UNION ALL
    SELECT 'Avamere TC & Rehabilitation-Brighton' AS OrgName,
           'BF1743'                               AS Code,
           '172'                                  AS AvaFacCode
    UNION ALL
    SELECT 'Avamere TC & Rehabilitation-Malley' AS OrgName,
           'MJ9123'                             AS Code,
           '171'                                AS AvaFacCode
    UNION ALL
    SELECT 'Avamere TC & Rehabilitation-Queen Anne' AS OrgName,
           'QW9126'                                 AS Code,
           '156'                                    AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Transitional Care at Sunnyside' AS OrgName,
           'SD6429'                                 AS Code,
           '002'                                    AS AvaFacCode
    UNION ALL
    SELECT 'Avamere Transitional Care of Puget Sound' AS OrgName,
           'PS1220'                                   AS Code,
           '157'                                      AS AvaFacCode
    UNION ALL
    SELECT 'Harmony House/Bend Transitional Care' AS OrgName,
           'GD1884'                               AS Code,
           '275'                                  AS AvaFacCode
    UNION ALL
    SELECT 'Laurelhurst Village' AS OrgName,
           'DS1873'              AS Code,
           '710'                 AS AvaFacCode
    UNION ALL
    SELECT 'Richmond Beach Rehab' AS OrgName,
           'RS7652'               AS Code,
           '120'                  AS AvaFacCode
    UNION ALL
    SELECT 'Salem Transitional Care' AS OrgName,
           'UK0075'                  AS Code,
           '003'                     AS AvaFacCode
    UNION ALL
    SELECT 'St. Francis of Bellingham' AS OrgName,
           'SF0445'                    AS Code,
           '164'                       AS AvaFacCode
    UNION ALL
    SELECT 'The Arbor at Avamere Court' AS OrgName,
           'AA7409'                     AS Code,
           '326'                        AS AvaFacCode
    UNION ALL
    SELECT 'The Arbor at Bremerton' AS OrgName,
           'BU7890'                 AS Code,
           '350'                    AS AvaFacCode
    UNION ALL
    SELECT 'The Pearl at Kruse Way' AS OrgName,
           'PW1948'                 AS Code,
           '227'                    AS AvaFacCode
    UNION ALL
    SELECT 'The Stafford' AS OrgName,
           'DG2394'       AS Code,
           '265'          AS AvaFacCode
    UNION ALL
    SELECT 'Table Rock Memory Care' AS OrgName,
           'TK1114'                 AS Code,
           '385'                    AS AvaFacCode
    UNION ALL
    SELECT 'Suzanne Elise'          AS OrgName,
           'SE9034'                 AS Code,
           '370'                    AS AvaFacCode
    UNION ALL
    SELECT 'Avamere The Arbor at Bend Memory' AS OrgName,
           'BM7702'                           AS Code,
           '327'                              AS AvaFacCode
    UNION ALL
    SELECT 'Ovation Sienna Hills' AS OrgName,
           'SH6885' AS Code,
           '520' AS AvaFacCode

Columns

View Definition

Possibly Referenced Tables/Views