VW_PCC_Split

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

FacilityID

int

4

null

PCC_Cache_FacID.FacilityID

Implied ConstraintR

FacilityCode

varchar

3

null

FacilityName

varchar

66

null

AVA_Source

varchar

3

null

CutoverDate

varchar

10

null

Relationships

Close relationships within degrees of separation

View Definition

CREATE VIEW dbo.VW_PCC_Split AS
    /*********************************************************************
    Database:		DataCStore
    View:			dbo.VW_PCC_Split
    Created:		12/9/2021
    Description:	The list of facility id values comes from the CBC agreement
                    with PCC. That agreement specifies literal FacilityID values.

                    ALSO: This view serves as the global configuration value
                          for the cutover date, when CBC data should be
                          obtained exclusively from their new own PCC.

                    Ref: OrgMap repo. excel_helper\PCC_Split.xlsx.

                    ** Refactored 2022-03-02.
                       Reason: So the view can be used in daily refresh of PCC_Cache_Fac.
                       The original version of this view depended on that table,
                       which gets truncated during its daily refresh.

                    IMPORTANT: This view must be updated whenever a new facility comes online.
    *********************************************************************/

    /* SNFs */
    SELECT 45                           AS FacilityID,
           '001'                        AS FacilityCode,
           'Eugene Rehabilitation, LLC' AS FacilityName,
           'SNF'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 61                         AS FacilityID,
           '002'                      AS FacilityCode,
           'Sunnyside Operations LLC' AS FacilityName,
           'SNF'                      AS AVA_Source,
           '2022-01-05'               AS CutoverDate
    UNION
    SELECT 14                                AS FacilityID,
           '003'                             AS FacilityCode,
           'South Salem Rehabilitation, LLC' AS FacilityName,
           'SNF'                             AS AVA_Source,
           '2022-01-05'                      AS CutoverDate
    UNION
    SELECT 32                             AS FacilityID,
           '004'                          AS FacilityCode,
           'Coos Bay Rehabilitation, LLC' AS FacilityName,
           'SNF'                          AS AVA_Source,
           '2022-01-05'                   AS CutoverDate
    UNION
    SELECT 27                              AS FacilityID,
           '005'                           AS FacilityCode,
           'Clackamas Rehabilitation, LLC' AS FacilityName,
           'SNF'                           AS AVA_Source,
           '2022-01-05'                    AS CutoverDate
    UNION
    SELECT 8                                   AS FacilityID,
           '006'                               AS FacilityCode,
           'Junction City Rehabilitation, LLC' AS FacilityName,
           'SNF'                               AS AVA_Source,
           '2022-01-05'                        AS CutoverDate
    UNION
    SELECT 10                         AS FacilityID,
           '008'                      AS FacilityCode,
           'Lebanon Care Center, LLC' AS FacilityName,
           'SNF'                      AS AVA_Source,
           '2022-01-05'               AS CutoverDate
    UNION
    SELECT 13                        AS FacilityID,
           '009'                     AS FacilityCode,
           'Mountain View Rehab LLC' AS FacilityName,
           'SNF'                     AS AVA_Source,
           '2022-01-05'              AS CutoverDate
    UNION
    SELECT 9                      AS FacilityID,
           '010'                  AS FacilityCode,
           'King City Rehab, LLC' AS FacilityName,
           'SNF'                  AS AVA_Source,
           '2022-01-05'           AS CutoverDate
    UNION
    SELECT 12                            AS FacilityID,
           '015'                         AS FacilityCode,
           'Newport Rehabilitation, LLC' AS FacilityName,
           'SNF'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 17                     AS FacilityID,
           '016'                  AS FacilityCode,
           'Twin Oaks Rehab, LLC' AS FacilityName,
           'SNF'                  AS AVA_Source,
           '2022-01-05'           AS CutoverDate
    UNION
    SELECT 11                                      AS FacilityID,
           '017'                                   AS FacilityCode,
           'Beaverton Rehab & Specialty Care, LLC' AS FacilityName,
           'SNF'                                   AS AVA_Source,
           '2022-01-05'                            AS CutoverDate
    UNION
    SELECT 29                                          AS FacilityID,
           '018'                                       AS FacilityCode,
           'Gresham Rehabilitation and Specialty Care' AS FacilityName,
           'SNF'                                       AS AVA_Source,
           '2022-01-05'                                AS CutoverDate
    UNION
    SELECT 33                    AS FacilityID,
           '028'                 AS FacilityCode,
           'Peckham-Miller, Inc' AS FacilityName,
           'SNF'                 AS AVA_Source,
           '2022-01-05'          AS CutoverDate
    UNION
    SELECT 4                           AS FacilityID,
           '061'                       AS FacilityCode,
           'Crestview Operations, LLC' AS FacilityName,
           'SNF'                       AS AVA_Source,
           '2022-01-05'                AS CutoverDate
    UNION
    SELECT 15                          AS FacilityID,
           '062'                       AS FacilityCode,
           'Riverpark Operations, LLC' AS FacilityName,
           'SNF'                       AS AVA_Source,
           '2022-01-05'                AS CutoverDate
    UNION
    SELECT 53                        AS FacilityID,
           '071'                     AS FacilityCode,
           'Medford Operations, LLC' AS FacilityName,
           'SNF'                     AS AVA_Source,
           '2022-01-05'              AS CutoverDate
    UNION
    SELECT 66                          AS FacilityID,
           '112'                       AS FacilityCode,
           'Vancouver Operations, LLC' AS FacilityName,
           'SNF'                       AS AVA_Source,
           '2022-01-05'                AS CutoverDate
    UNION
    SELECT 7                                                       AS FacilityID,
           '119'                                                   AS FacilityCode,
           'Sequim Rehab, LLC DBA Avamere Olympic Rehab of Sequim' AS FacilityName,
           'SNF'                                                   AS AVA_Source,
           '2022-01-05'                                            AS CutoverDate
    UNION
    SELECT 35                         AS FacilityID,
           '120'                      AS FacilityCode,
           'Richmond Beach Rehab LLC' AS FacilityName,
           'SNF'                      AS AVA_Source,
           '2022-01-05'               AS CutoverDate
    UNION
    SELECT 5                     AS FacilityID,
           '152'                 AS FacilityCode,
           'Heritage Rehab, LLC' AS FacilityName,
           'SNF'                 AS AVA_Source,
           '2022-01-05'          AS CutoverDate
    UNION
    SELECT 16                         AS FacilityID,
           '154'                      AS FacilityCode,
           'Avamere at Pacific Ridge' AS FacilityName,
           'SNF'                      AS AVA_Source,
           '2022-01-05'               AS CutoverDate
    UNION
    SELECT 55                           AS FacilityID,
           '155'                        AS FacilityCode,
           'Bellingham Operations, LLC' AS FacilityName,
           'SNF'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 58                        AS FacilityID,
           '156'                     AS FacilityCode,
           'Seattle Operations, LLC' AS FacilityName,
           'SNF'                     AS AVA_Source,
           '2022-01-05'              AS CutoverDate
    UNION
    SELECT 28                                                                   AS FacilityID,
           '157'                                                                AS FacilityCode,
           'Georgian Rehab, LLC.  DBA Avamere Transitional Care of Puget Sound' AS FacilityName,
           'SNF'                                                                AS AVA_Source,
           '2022-01-05'                                                         AS CutoverDate
    UNION
    SELECT 36                           AS FacilityID,
           '164'                        AS FacilityCode,
           'St Francis Operations, LLC' AS FacilityName,
           'SNF'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 56                      AS FacilityID,
           '170'                   AS FacilityCode,
           'Boise Operations, LLC' AS FacilityName,
           'SNF'                   AS AVA_Source,
           '2022-01-05'            AS CutoverDate
    UNION
    SELECT 57                           AS FacilityID,
           '171'                        AS FacilityCode,
           'Northglenn Operations, LLC' AS FacilityName,
           'SNF'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 54                         AS FacilityID,
           '172'                      AS FacilityCode,
           'Brighton Operations, LLC' AS FacilityName,
           'SNF'                      AS AVA_Source,
           '2022-01-05'               AS CutoverDate
    UNION
    SELECT 106                           AS FacilityID,
           '173'                         AS FacilityCode,
           'Albuquerque Operations, LLC' AS FacilityName,
           'SNF'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 1                                     AS FacilityID,
           '226'                                 AS FacilityCode,
           'Keizer Campus Operations LLC  - SNF' AS FacilityName,
           'SNF'                                 AS AVA_Source,
           '2022-01-05'                          AS CutoverDate
    UNION
    SELECT 2                                     AS FacilityID,
           '226'                                 AS FacilityCode,
           'Keizer Campus Operations, LLC - RCF' AS FacilityName,
           'SNF'                                 AS AVA_Source,
           '2022-01-05'                          AS CutoverDate
    UNION
    SELECT 3                                     AS FacilityID,
           '226'                                 AS FacilityCode,
           'Keizer Campus Operations, LLC - ILF' AS FacilityName,
           'SNF'                                 AS AVA_Source,
           '2022-01-05'                          AS CutoverDate
    UNION
    SELECT 38                             AS FacilityID,
           '227'                          AS FacilityCode,
           'The Pearl at Kruse Way - SNF' AS FacilityName,
           'SNF'                          AS AVA_Source,
           '2022-01-05'                   AS CutoverDate
    UNION
    SELECT 39                           AS FacilityID,
           '227'                        AS FacilityCode,
           'The Pearl at Kruse Way-ALZ' AS FacilityName,
           'SNF'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 49                                AS FacilityID,
           '263'                             AS FacilityCode,
           'Waterford Operations, LLC - RCF' AS FacilityName,
           'SNF'                             AS AVA_Source,
           '2022-01-05'                      AS CutoverDate
    UNION
    SELECT 23                                AS FacilityID,
           '263'                             AS FacilityCode,
           'Waterford Operations, LLC - SNF' AS FacilityName,
           'SNF'                             AS AVA_Source,
           '2022-01-05'                      AS CutoverDate
    UNION
    SELECT 24                                 AS FacilityID,
           '263'                              AS FacilityCode,
           'Waterford Operations, LLC  - ALF' AS FacilityName,
           'SNF'                              AS AVA_Source,
           '2022-01-05'                       AS CutoverDate
    UNION
    SELECT 30                             AS FacilityID,
           '275'                          AS FacilityCode,
           'Bend Transitional Care - SNF' AS FacilityName,
           'SNF'                          AS AVA_Source,
           '2022-01-05'                   AS CutoverDate
    UNION
    SELECT 64                                AS FacilityID,
           '371'                             AS FacilityCode,
           'Necanicum Operations, LLC - ALF' AS FacilityName,
           'SNF'                             AS AVA_Source,
           '2022-01-05'                      AS CutoverDate
    UNION
    SELECT 81                                 AS FacilityID,
           '385'                              AS FacilityCode,
           'Table Rock Memory Care Community' AS FacilityName,
           'SNF'                              AS AVA_Source,
           '2022-01-05'                       AS CutoverDate
    UNION
    SELECT 71                                                      AS FacilityID,
           '429'                                                   AS FacilityCode,
           'NP2U, LLC DBA TRANSITIONS PRIMARY and PALLIATIVE CARE' AS FacilityName,
           'SNF'                                                   AS AVA_Source,
           '2022-01-05'                                            AS CutoverDate
    UNION
    SELECT 67           AS FacilityID,
           '470'        AS FacilityCode,
           'NP2U, LLC'  AS FacilityName,
           'SNF'        AS AVA_Source,
           '2022-01-05' AS CutoverDate
    UNION
    SELECT 59                                 AS FacilityID,
           '710'                              AS FacilityCode,
           'Laurelhurst Operations LLC- SNF ' AS FacilityName,
           'SNF'                              AS AVA_Source,
           '2022-01-05'                       AS CutoverDate
    UNION
    SELECT 60                             AS FacilityID,
           '710'                          AS FacilityCode,
           'Laurelhurst Operations - ALF' AS FacilityName,
           'SNF'                          AS AVA_Source,
           '2022-01-05'                   AS CutoverDate

    /* CBCs */
    UNION
    SELECT 40                   AS FacilityID,
           '265'                AS FacilityCode,
           'The Stafford - ALF' AS FacilityName,
           'CBC'                AS AVA_Source,
           '2022-01-05'         AS CutoverDate
    UNION
    SELECT 41                   AS FacilityID,
           '265'                AS FacilityCode,
           'The Stafford - ILF' AS FacilityName,
           'CBC'                AS AVA_Source,
           '2022-01-05'         AS CutoverDate
    UNION
    SELECT 63                            AS FacilityID,
           '326'                         AS FacilityCode,
           'The Arbor at Avamere Court ' AS FacilityName,
           'CBC'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 108                                    AS FacilityID,
           '327'                                  AS FacilityCode,
           'Bend Arbor LLC dba The Arbor at Bend' AS FacilityName,
           'CBC'                                  AS AVA_Source,
           '2022-01-05'                           AS CutoverDate
    UNION
    SELECT 47                                           AS FacilityID,
           '330'                                        AS FacilityCode,
           'Genesis Newberg Operation Co., LLC - Arbor' AS FacilityName,
           'CBC'                                        AS AVA_Source,
           '2022-01-05'                                 AS CutoverDate
    UNION
    SELECT 18                                   AS FacilityID,
           '330'                                AS FacilityCode,
           'Genesis Newberg Operation Co., LCC' AS FacilityName,
           'CBC'                                AS AVA_Source,
           '2022-01-05'                         AS CutoverDate
    UNION
    SELECT 20                                 AS FacilityID,
           '331'                              AS FacilityCode,
           'Avamere-Sherwood Operations. LLC' AS FacilityName,
           'CBC'                              AS AVA_Source,
           '2022-01-05'                       AS CutoverDate
    UNION
    SELECT 50                                         AS FacilityID,
           '331'                                      AS FacilityCode,
           'Avamere-Sherwood Operations, LLC - Arbor' AS FacilityName,
           'CBC'                                      AS AVA_Source,
           '2022-01-05'                               AS CutoverDate
    UNION
    SELECT 19                              AS FacilityID,
           '332'                           AS FacilityCode,
           'Avamere-Sandy Operations, LLC' AS FacilityName,
           'CBC'                           AS AVA_Source,
           '2022-01-05'                    AS CutoverDate
    UNION
    SELECT 48                                      AS FacilityID,
           '332'                                   AS FacilityCode,
           'Avamere-Sandy Operations, LLC - Arbor' AS FacilityName,
           'CBC'                                   AS AVA_Source,
           '2022-01-05'                            AS CutoverDate
    UNION
    SELECT 46                                          AS FacilityID,
           '333'                                       AS FacilityCode,
           'Avamere-Hillsboro Operations, LLC - Arbor' AS FacilityName,
           'CBC'                                       AS AVA_Source,
           '2022-01-05'                                AS CutoverDate
    UNION
    SELECT 34                                       AS FacilityID,
           '333'                                    AS FacilityCode,
           'Avamere-Hillsboro Operations, LLC -ALF' AS FacilityName,
           'CBC'                                    AS AVA_Source,
           '2022-01-05'                             AS CutoverDate
    UNION
    SELECT 21                                         AS FacilityID,
           '334'                                      AS FacilityCode,
           'Avamere-St. Helens Operations, LLC - ALF' AS FacilityName,
           'CBC'                                      AS AVA_Source,
           '2022-01-05'                               AS CutoverDate
    UNION
    SELECT 51                                          AS FacilityID,
           '334'                                       AS FacilityCode,
           'Avamere-St Helens Operations, LLC - Arbor' AS FacilityName,
           'CBC'                                       AS AVA_Source,
           '2022-01-05'                                AS CutoverDate
    UNION
    SELECT 52                                        AS FacilityID,
           '335'                                     AS FacilityCode,
           'Avamere Bethany Operations, LLC - Arbor' AS FacilityName,
           'CBC'                                     AS AVA_Source,
           '2022-01-05'                              AS CutoverDate
    UNION
    SELECT 25                                     AS FacilityID,
           '335'                                  AS FacilityCode,
           'Avamere Bethany Operations, LLC -ALF' AS FacilityName,
           'CBC'                                  AS AVA_Source,
           '2022-01-05'                           AS CutoverDate
    UNION
    SELECT 43                                        AS FacilityID,
           '343'                                     AS FacilityCode,
           'Avamere-Hillsboro Operations, LLC - ILF' AS FacilityName,
           'CBC'                                     AS AVA_Source,
           '2022-01-05'                              AS CutoverDate
    UNION
    SELECT 22                                         AS FacilityID,
           '344'                                      AS FacilityCode,
           'Avamere-St. Helens Operations, LLC - ILF' AS FacilityName,
           'CBC'                                      AS AVA_Source,
           '2022-01-05'                               AS CutoverDate
    UNION
    SELECT 26                                      AS FacilityID,
           '345'                                   AS FacilityCode,
           'Avamere Bethany Operations, LLC - ILF' AS FacilityName,
           'CBC'                                   AS AVA_Source,
           '2022-01-05'                            AS CutoverDate
    UNION
    SELECT 6                              AS FacilityID,
           '348'                          AS FacilityCode,
           'Avamere Living at Berry Park' AS FacilityName,
           'CBC'                          AS AVA_Source,
           '2022-01-05'                   AS CutoverDate
    UNION
    SELECT 44                                    AS FacilityID,
           '349'                                 AS FacilityCode,
           'Avamere Living at Berry Park Villas' AS FacilityName,
           'CBC'                                 AS AVA_Source,
           '2022-01-05'                          AS CutoverDate
    UNION
    SELECT 72                       AS FacilityID,
           '350'                    AS FacilityCode,
           'The Arbor at Bremerton' AS FacilityName,
           'CBC'                    AS AVA_Source,
           '2022-01-05'             AS CutoverDate
    UNION
    SELECT 37                      AS FacilityID,
           '370'                   AS FacilityCode,
           'Suzanne Elise LLC-ALF' AS FacilityName,
           'CBC'                   AS AVA_Source,
           '2022-01-05'            AS CutoverDate
    UNION
    SELECT 65                                  AS FacilityID,
           '371'                               AS FacilityCode,
           'Necanicum Operations, LLC - Arbor' AS FacilityName,
           'CBC'                               AS AVA_Source,
           '2022-01-05'                        AS CutoverDate
    UNION
    SELECT 107                               AS FacilityID,
           '371'                             AS FacilityCode,
           'Necanicum Operations, LCC - ILF' AS FacilityName,
           'CBC'                             AS AVA_Source,
           '2022-01-05'                      AS CutoverDate
    UNION
    SELECT 102                        AS FacilityID,
           '373'                      AS FacilityCode,
           'Avamere at Phoenix - ALF' AS FacilityName,
           'CBC'                      AS AVA_Source,
           '2022-01-05'               AS CutoverDate
    UNION
    SELECT 103                        AS FacilityID,
           '373'                      AS FacilityCode,
           'Avamere at Phoenix - ALZ' AS FacilityName,
           'CBC'                      AS AVA_Source,
           '2022-01-05'               AS CutoverDate
    UNION
    SELECT 104                               AS FacilityID,
           '374'                             AS FacilityCode,
           'Avamere at Mountain Ridge - ALF' AS FacilityName,
           'CBC'                             AS AVA_Source,
           '2022-01-05'                      AS CutoverDate
    UNION
    SELECT 105                               AS FacilityID,
           '374'                             AS FacilityCode,
           'Avamere at Mountain Ridge - ALZ' AS FacilityName,
           'CBC'                             AS AVA_Source,
           '2022-01-05'                      AS CutoverDate
    UNION
    SELECT 82                               AS FacilityID,
           '711'                            AS FacilityCode,
           'Avamere at Chestnut Lane - ALF' AS FacilityName,
           'CBC'                            AS AVA_Source,
           '2022-01-05'                     AS CutoverDate
    UNION
    SELECT 83                            AS FacilityID,
           '712'                         AS FacilityCode,
           'Avamere at Hermiston - ALF ' AS FacilityName,
           'CBC'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 89                            AS FacilityID,
           '713'                         AS FacilityCode,
           'Avamere at Park Place - ALF' AS FacilityName,
           'CBC'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 87                           AS FacilityID,
           '714'                        AS FacilityCode,
           'Avamere at Lexington - ALF' AS FacilityName,
           'CBC'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 88                           AS FacilityID,
           '714'                        AS FacilityCode,
           'Avamere at Lexington - ILF' AS FacilityName,
           'CBC'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 90                            AS FacilityID,
           '715'                         AS FacilityCode,
           'Avamere at Rio Rancho - ALF' AS FacilityName,
           'CBC'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 91                                AS FacilityID,
           '715'                             AS FacilityCode,
           'Avamere at Rio Rancho - Cottage' AS FacilityName,
           'CBC'                             AS AVA_Source,
           '2022-01-05'                      AS CutoverDate
    UNION
    SELECT 92                            AS FacilityID,
           '715'                         AS FacilityCode,
           'Avamere at Rio Rancho - ALZ' AS FacilityName,
           'CBC'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 95                         AS FacilityID,
           '716'                      AS FacilityCode,
           'Avamere at Roswell - ALZ' AS FacilityName,
           'CBC'                      AS AVA_Source,
           '2022-01-05'               AS CutoverDate
    UNION
    SELECT 97                         AS FacilityID,
           '716'                      AS FacilityCode,
           'Avamere at Roswell - ALF' AS FacilityName,
           'CBC'                      AS AVA_Source,
           '2022-01-05'               AS CutoverDate
    UNION
    SELECT 84                           AS FacilityID,
           '717'                        AS FacilityCode,
           'Avamere at Las Vegas - ALF' AS FacilityName,
           'CBC'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 98                            AS FacilityID,
           '718'                         AS FacilityCode,
           'Avamere at Moses Lake - ALF' AS FacilityName,
           'CBC'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 99                            AS FacilityID,
           '718'                         AS FacilityCode,
           'Avamere at Moses Lake - ILF' AS FacilityName,
           'CBC'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 96                            AS FacilityID,
           '719'                         AS FacilityCode,
           'Avamere at South Hill - ALF' AS FacilityName,
           'CBC'                         AS AVA_Source,
           '2022-01-05'                  AS CutoverDate
    UNION
    SELECT 100                                  AS FacilityID,
           '720'                                AS FacilityCode,
           'Avamere at Englewood Heights - ALF' AS FacilityName,
           'CBC'                                AS AVA_Source,
           '2022-01-05'                         AS CutoverDate
    UNION
    SELECT 101                                  AS FacilityID,
           '720'                                AS FacilityCode,
           'Avamere at Englewood Heights - ALZ' AS FacilityName,
           'CBC'                                AS AVA_Source,
           '2022-01-05'                         AS CutoverDate
    UNION
    SELECT 73                  AS FacilityID,
           '840'               AS FacilityCode,
           'Avamere at Albany' AS FacilityName,
           'CBC'               AS AVA_Source,
           '2022-01-05'        AS CutoverDate
    UNION
    SELECT 74                                   AS FacilityID,
           '841'                                AS FacilityCode,
           'Avamere at Cascadia Village -  ALF' AS FacilityName,
           'CBC'                                AS AVA_Source,
           '2022-01-05'                         AS CutoverDate
    UNION
    SELECT 75                                  AS FacilityID,
           '841'                               AS FacilityCode,
           'Avamere at Cascadia Village - ILF' AS FacilityName,
           'CBC'                               AS AVA_Source,
           '2022-01-05'                        AS CutoverDate
    UNION
    SELECT 76                           AS FacilityID,
           '842'                        AS FacilityCode,
           'Avamere at Wenatchee - ALF' AS FacilityName,
           'CBC'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 80                           AS FacilityID,
           '842'                        AS FacilityCode,
           'Avamere at Wenatchee - ILF' AS FacilityName,
           'CBC'                        AS AVA_Source,
           '2022-01-05'                 AS CutoverDate
    UNION
    SELECT 77                    AS FacilityID,
           '843'                 AS FacilityCode,
           'Avamere at Oak Park' AS FacilityName,
           'CBC'                 AS AVA_Source,
           '2022-01-05'          AS CutoverDate
    UNION
    SELECT 78                               AS FacilityID,
           '844'                            AS FacilityCode,
           'Avamere at Port Townsend - ALF' AS FacilityName,
           'CBC'                            AS AVA_Source,
           '2022-01-05'                     AS CutoverDate
    UNION
    SELECT 79                               AS FacilityID,
           '844'                            AS FacilityCode,
           'Avamere at Port Townsend - ILF' AS FacilityName,
           'CBC'                            AS AVA_Source,
           '2022-01-05'                     AS CutoverDate

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views