VW_Kashi_Ulti_PCC_Remap

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

FacilityCode

varchar

null

FacilityName

varchar

null

UltiOrgLevel3Code

varchar

null

View Definition

CREATE VIEW dbo.VW_Kashi_Ulti_PCC_Remap AS

/*********************************************************************
Database:		DataCStore
View:			dbo.VW_Kashi_Ulti_PCC_Remap
Created:		8/20/2020
Description:    Convenience Avamere Living view that contains only
                "non-standard" code remappings. If not in this view,
                the same code is used in both systems. Intended only
                for Kashi export. It's a simplification, in that it
                doesn't need to deal with "variant" facility codes
                (e.g. 343, 344) because those codes are not used in
                in UltiPro.
*********************************************************************/

    WITH nonstandard AS (
        SELECT '840'               AS FacilityCode,
               'Avamere at Albany' AS FacilityName,
               '390'               AS UltiOrgLevel3Code
        UNION ALL
        SELECT '841'                         AS FacilityCode,
               'Avamere at Cascadia Village' AS FacilityName,
               '391'                         AS UltiOrgLevel3Code
        UNION ALL
        SELECT '842'                  AS FacilityCode,
               'Avamere at Wenatchee' AS FacilityName,
               '392'                  AS UltiOrgLevel3Code
        UNION ALL
        SELECT '843'                 AS FacilityCode,
               'Avamere at Oak Park' AS FacilityName,
               '393'                 AS UltiOrgLevel3Code
        UNION ALL
        SELECT '844'                      AS FacilityCode,
               'Avamere at Port Townsend' AS FacilityName,
               '394'                      AS UltiOrgLevel3Code
        UNION ALL
        SELECT '157'                                      AS FacilityCode,
               'Avamere Transitional Care of Puget Sound' AS FacilityName,
               '151'                                      AS UltiOrgLevel3Code
    )

    SELECT FacilityCode,
           FacilityName,
           UltiOrgLevel3Code
    FROM nonstandard

Columns

View Definition

Possibly Referenced Tables/Views