VW_OrgMap_AD - DataCStore Database

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

AD_Department

varchar

null

datateam_site_id

int

√

null

ParentCompany

varchar

null

View Definition

CREATE VIEW dbo.VW_OrgMap_AD AS

/*********************************************************************
Database:		DataCStore
View:			dbo.VW_OrgMap_AD
Created:		3/1/2021
Description:	Authoritative registry of Active Directory "Department"
                values mapped to data team universal site id.
                This view is an experiment in attempting to bring some
                order to the "facility mapping" chaos.
                The SQL was auto-generated with assistance from Excel
                formulas. See O365_Mapper.xlsx file in SVN repo.
*********************************************************************/

    SELECT '0011-EugeneRehab' AS AD_Department,
           '0011'             AS datateam_site_id,
           'AVL'              AS ParentCompany
    UNION
    SELECT '0021-CorporateOffice' AS AD_Department,
           NULL                   AS datateam_site_id,
           'INF'                  AS ParentCompany
    UNION
    SELECT '0021-Sunnyside' AS AD_Department,
           '0021'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '0031-SalemTransCare' AS AD_Department,
           '0031'                AS datateam_site_id,
           'AVL'                 AS ParentCompany
    UNION
    SELECT '0041-CoosBayRehab' AS AD_Department,
           '0041'              AS datateam_site_id,
           'AVL'               AS ParentCompany
    UNION
    SELECT '0051-ClackamasRehab' AS AD_Department,
           '0051'                AS datateam_site_id,
           'AVL'                 AS ParentCompany
    UNION
    SELECT '0061-JunctionCityRehab' AS AD_Department,
           '0061'                   AS datateam_site_id,
           'AVL'                    AS ParentCompany
    UNION
    SELECT '0081-LebanonRehab' AS AD_Department,
           '0081'              AS datateam_site_id,
           'AVL'               AS ParentCompany
    UNION
    SELECT '0091-OregonCityRehab' AS AD_Department,
           '0091'                 AS datateam_site_id,
           'AVL'                  AS ParentCompany
    UNION
    SELECT '0101-KingCityRehab' AS AD_Department,
           '0101'               AS datateam_site_id,
           'AVL'                AS ParentCompany
    UNION
    SELECT '0151-NewportRehab' AS AD_Department,
           '0151'              AS datateam_site_id,
           'AVL'               AS ParentCompany
    UNION
    SELECT '0171-BeavertonRehab' AS AD_Department,
           '0171'                AS datateam_site_id,
           'AVL'                 AS ParentCompany
    UNION
    SELECT '0281-HillsboroRehab' AS AD_Department,
           '0281'                AS datateam_site_id,
           'AVL'                 AS ParentCompany
    UNION
    SELECT '0611-Crestview' AS AD_Department,
           '0611'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '0621-Riverpark' AS AD_Department,
           '0621'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '0661-Landmark' AS AD_Department,
           '066'           AS datateam_site_id,
           'INF'           AS ParentCompany
    UNION
    SELECT '0711-RogueValley' AS AD_Department,
           '0711'             AS datateam_site_id,
           'AVL'              AS ParentCompany
    UNION
    SELECT '1001-Avamere-Beaverton' AS AD_Department,
           '100'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '1021-ForestGrove' AS AD_Department,
           '002'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '1031-CascadeTerrace' AS AD_Department,
           '003'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '1041-Chehalem' AS AD_Department,
           '004'           AS datateam_site_id,
           'INF'           AS ParentCompany
    UNION
    SELECT '1051-Avamere-Clackamas' AS AD_Department,
           '005'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '1061-CoastFork' AS AD_Department,
           '006'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '1071-Avamere-Eugene' AS AD_Department,
           '007'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '1091-Glisan' AS AD_Department,
           '009'         AS datateam_site_id,
           'INF'         AS ParentCompany
    UNION
    SELECT '1101-Avamere-JunctionCity' AS AD_Department,
           '010'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '1111-Avamere-CoosBay' AS AD_Department,
           '011'                  AS datateam_site_id,
           'INF'                  AS ParentCompany
    UNION
    SELECT '1121-Avamere-Heritage' AS AD_Department,
           '012'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '1121-CascadeParkRehab' AS AD_Department,
           '1121'                  AS datateam_site_id,
           'AVL'                   AS ParentCompany
    UNION
    SELECT '1131-Avamere-Hillsboro' AS AD_Department,
           '013'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '1141-HoodRiver' AS AD_Department,
           '014'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '1161-Avamere-Keizer' AS AD_Department,
           '016'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '1171-Avamere-KingCity' AS AD_Department,
           '017'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '1181-LindaVista' AS AD_Department,
           '018'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '1191-OlympicRehabSequim' AS AD_Department,
           '1191'                    AS datateam_site_id,
           'AVL'                     AS ParentCompany
    UNION
    SELECT '1201-MolallaManor' AS AD_Department,
           '020'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '1201-RichmondBeach' AS AD_Department,
           '1201'               AS datateam_site_id,
           'AVL'                AS ParentCompany
    UNION
    SELECT '1211-Avamere-OregonCity' AS AD_Department,
           '021'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '124-Newport' AS AD_Department,
           '024'         AS datateam_site_id,
           'INF'         AS ParentCompany
    UNION
    SELECT '1241-Avamere-Newport' AS AD_Department,
           '024'                  AS datateam_site_id,
           'INF'                  AS ParentCompany
    UNION
    SELECT '1261-OregonCity' AS AD_Department,
           '026'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '1281-ParkForest' AS AD_Department,
           '028'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '1291-Porthaven' AS AD_Department,
           '029'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '1341-Avamere-Salem' AS AD_Department,
           '034'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '1351-SullivanPark' AS AD_Department,
           '035'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '1361-Avamere-PacificRidge' AS AD_Department,
           '036'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '1381-Timberview' AS AD_Department,
           '038'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '1401-Avamere-Lebanon' AS AD_Department,
           '040'                  AS datateam_site_id,
           'INF'                  AS ParentCompany
    UNION
    SELECT '1421-Willowbrook' AS AD_Department,
           '042'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '1471-Creswell' AS AD_Department,
           '047'           AS datateam_site_id,
           'INF'           AS ParentCompany
    UNION
    SELECT '1511-Avamere-Richmond' AS AD_Department,
           '051'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '1521-TacomaRehab' AS AD_Department,
           '1521'             AS datateam_site_id,
           'AVL'              AS ParentCompany
    UNION
    SELECT '1541-TacomaSkilledNursing' AS AD_Department,
           '1541'                       AS datateam_site_id,
           'AVL'                       AS ParentCompany
    UNION
    SELECT '1541-Toppenish' AS AD_Department,
           '054'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '1551-BellinghamRehab' AS AD_Department,
           '1551'                 AS datateam_site_id,
           'AVL'                  AS ParentCompany
    UNION
    SELECT '1551-Discovery' AS AD_Department,
           '055'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '1561-QueenAnne' AS AD_Department,
           '1561'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '1561-Village' AS AD_Department,
           '056'          AS datateam_site_id,
           'INF'          AS ParentCompany
    UNION
    SELECT '1571-PugetSound' AS AD_Department,
           '1571'            AS datateam_site_id,
           'AVL'             AS ParentCompany
    UNION
    SELECT '1641-StFrancisBellingham' AS AD_Department,
           '1641'                     AS datateam_site_id,
           'AVL'                      AS ParentCompany
    UNION
    SELECT '1701-BoiseTransCare' AS AD_Department,
           '1701'                AS datateam_site_id,
           'AVL'                 AS ParentCompany
    UNION
    SELECT '1711-Malley' AS AD_Department,
           '1711'        AS datateam_site_id,
           'AVL'         AS ParentCompany
    UNION
    SELECT '1721-Brighton' AS AD_Department,
           '1721'          AS datateam_site_id,
           'AVL'           AS ParentCompany
    UNION
    SELECT '1731-FiestaPark' AS AD_Department,
           '1731'             AS datateam_site_id,
           'AVL'             AS ParentCompany
    UNION
    SELECT '1741-Avamere-Olympic' AS AD_Department,
           '074'                  AS datateam_site_id,
           'INF'                  AS ParentCompany
    UNION
    SELECT '1751-BethanySilverLake' AS AD_Department,
           '075'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '1911-TriStateHospital' AS AD_Department,
           '091'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '2001-EvenglowLodge' AS AD_Department,
           '200'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '2031-Avamere-Pearl' AS AD_Department,
           '203'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '2171-Avamere-Crestview' AS AD_Department,
           '217'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '2181-Avamere-Riverpark' AS AD_Department,
           '218'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '2191-Avamere Three Fountains' AS AD_Department,
           '219'                          AS datateam_site_id,
           'INF'                          AS ParentCompany
    UNION
    SELECT '2191-Avamere-ThreeFountains' AS AD_Department,
           '219'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '2201-Avamere-StFrancis' AS AD_Department,
           '220'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '2261-CourtAtKeizer' AS AD_Department,
           '2261'               AS datateam_site_id,
           'AVL'                AS ParentCompany
    UNION
    SELECT '2271-ThePearlKruse' AS AD_Department,
           '2271'               AS datateam_site_id,
           'AVL'                AS ParentCompany
    UNION
    SELECT '2301-GS-Gresham' AS AD_Department,
           '230'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '2331-PinecrestCommunity' AS AD_Department,
           '233'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '2481-PacificHealth' AS AD_Department,
           '248'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '2501-SummitView' AS AD_Department,
           '250'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '2551-VillageManor' AS AD_Department,
           '255'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '2581-GS-SpokaneValley' AS AD_Department,
           '258'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '2631-HollyCreek' AS AD_Department,
           '263'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '2631-Holly Creek' AS AD_Department, --Space between words
           '263'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '2631-Three Fountains-Waterford' AS AD_Department,
           '2631'                           AS datateam_site_id,
           'AVL'                            AS ParentCompany
    UNION
    SELECT '2641-ClermontPark' AS AD_Department,
           '264'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '2651-SomerenGlen' AS AD_Department,
           '265'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '2651-TheStafford' AS AD_Department,
           '2651'             AS datateam_site_id,
           'AVL'              AS ParentCompany
    UNION
    SELECT '2711-Avamere-Bend' AS AD_Department,
           '271'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '2751-BendTransCare' AS AD_Department,
           '2751'               AS datateam_site_id,
           'AVL'                AS ParentCompany
    UNION
    SELECT '2801-Prestige-Anchorage' AS AD_Department,
           '280'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '2801-PrestigeAnchorage' AS AD_Department, --No hyphen
           '280'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '2871-Fernhill' AS AD_Department,
           '287'           AS datateam_site_id,
           'INF'           AS ParentCompany
    UNION
    SELECT '2881-StephensonNursingCenter' AS AD_Department,
           '288'                          AS datateam_site_id,
           'INF'                          AS ParentCompany
    UNION
    SELECT '2911-GS-Moscow' AS AD_Department,
           '291'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '3061-ChristianHealth' AS AD_Department,
           '306'                  AS datateam_site_id,
           'INF'                  AS ParentCompany
    UNION
    SELECT '3091-WestHills' AS AD_Department,
           '309'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '3251-EbenEzer' AS AD_Department,
           '325'           AS datateam_site_id,
           'INF'           AS ParentCompany
    UNION
    SELECT '3261-Rockwood-SouthHill' AS AD_Department,
           '326'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '3261-TheArbor' AS AD_Department,
           '3261'          AS datateam_site_id,
           'AVL'           AS ParentCompany
    UNION
    SELECT '3271-BendArbor' AS AD_Department,
           '3271'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '3271-Rockwood-Hawthorne' AS AD_Department,
           '327'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '3301-Columbia Lutheran Home' AS AD_Department,
           '330'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '3301-ColumbiaLutheranHome' AS AD_Department,
           '330'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '3301-Newberg' AS AD_Department,
           '3301'         AS datateam_site_id,
           'AVL'          AS ParentCompany
    UNION
    SELECT '3311-Sherwood' AS AD_Department,
           '3311'          AS datateam_site_id,
           'AVL'           AS ParentCompany
    UNION
    SELECT '3321-Bayview' AS AD_Department,
           '332'          AS datateam_site_id,
           'INF'          AS ParentCompany
    UNION
    SELECT '3321-Sandy' AS AD_Department,
           '3321'       AS datateam_site_id,
           'AVL'        AS ParentCompany
    UNION
    SELECT '3331-Hillsboro' AS AD_Department,
           '3331'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '3341-StHelens' AS AD_Department,
           '3341'          AS datateam_site_id,
           'AVL'           AS ParentCompany
    UNION
    SELECT '3351-Bethany' AS AD_Department,
           '3351'         AS datateam_site_id,
           'AVL'          AS ParentCompany
    UNION
    SELECT '3481-BerryPark' AS AD_Department,
           '3481'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '3491-VibraHospital' AS AD_Department,
           '349'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '3501-Bremerton' AS AD_Department,
           '3501'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '3531-CareageWhidbey' AS AD_Department,
           '353'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '3541-Prestige-Reedwood' AS AD_Department,
           '354'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '3601-MyrtlePoint' AS AD_Department,
           '360'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '3631-Mission' AS AD_Department,
           '363'          AS datateam_site_id,
           'INF'          AS ParentCompany
    UNION
    SELECT '3651-PrestigeBurlington' AS AD_Department,
           '365'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '3661-Prestige-Clarkston' AS AD_Department,
           '366'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '3681-Prestige-Camas' AS AD_Department,
           '368'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '3691-Prestige-Sunnyside' AS AD_Department,
           '369'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '3701-Prestige-MenloPark' AS AD_Department,
           '370'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '3701-Prestige-MenloParkr' AS AD_Department, --Typo in AD appeared 11/1/2021.
           '370'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '3701-SuzanneElise' AS AD_Department,
           '3701'              AS datateam_site_id,
           'AVL'               AS ParentCompany
    UNION
    SELECT '3711-Prestige-TheOrchards' AS AD_Department,
           '371'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '3711-Seaside' AS AD_Department,
           '3711'         AS datateam_site_id,
           'AVL'          AS ParentCompany
    UNION
    SELECT '3721-Prestige-Richland' AS AD_Department,
           '372'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '3731-Stratford' AS AD_Department,
           '3731'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '3741-SouthOgden' AS AD_Department,
           '3741'            AS datateam_site_id,
           'AVL'             AS ParentCompany
    UNION
    SELECT '3811-Prestige-Pinewood' AS AD_Department,
           '381'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '3821-Prestige-Parkside' AS AD_Department,
           '382'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '3841-Prestige-Puyallup' AS AD_Department,
           '384'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '3841-PuyallupRehab' AS AD_Department,
           '384'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '3851-FernGardens' AS AD_Department,
           '3851'             AS datateam_site_id,
           'AVL'              AS ParentCompany
    UNION
    SELECT '3881-Avamere-RogueValley' AS AD_Department,
           '388'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '3891-Avamere-QueenAnne' AS AD_Department,
           '389'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '3901-Avamere-Bellingham' AS AD_Department,
           '390'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '3911-Avamere-Boise' AS AD_Department,
           '391'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '3921-Avamere-Brighton' AS AD_Department,
           '392'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '3931-Avamere-Malley' AS AD_Department,
           '393'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '4011-Prestige-McMinnville' AS AD_Department,
           '401'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '4031-Prestige-Centralia' AS AD_Department,
           '403'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '4101-GS-Stafholt' AS AD_Department,
           '410'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '4111-Payette-HH' AS AD_Department,
           '4111'            AS datateam_site_id,
           'SIG'             AS ParentCompany
    UNION
    SELECT '4111-WillametteView' AS AD_Department,
           '411'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '4121-Avamere-Sunnyside' AS AD_Department,
           '412'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '4121-SignatureCorporate' AS AD_Department,
           NULL                        AS datateam_site_id,
           'SIG'                     AS ParentCompany
    UNION
    SELECT '4131-Portland-HH' AS AD_Department,
           '4131'             AS datateam_site_id,
           'SIG'              AS ParentCompany
    UNION
    SELECT '4141-Bellingham-HH' AS AD_Department,
           '4141'               AS datateam_site_id,
           'SIG'                AS ParentCompany
    UNION
    SELECT '4151-FederalWay-HH' AS AD_Department,
           '4151'               AS datateam_site_id,
           'SIG'                AS ParentCompany
    UNION
    SELECT '4161-Eugene-HC' AS AD_Department,
           '4161'           AS datateam_site_id,
           'SIG'            AS ParentCompany
    UNION
    SELECT '4161-Eugene-HH' AS AD_Department,
           '4161'           AS datateam_site_id,
           'SIG'            AS ParentCompany
    UNION
    SELECT '4171-Bellevue-HH' AS AD_Department,
           '4171'             AS datateam_site_id,
           'SIG'              AS ParentCompany
    UNION
    SELECT '4181-Medford-HC' AS AD_Department,
           '4181'            AS datateam_site_id,
           'SIG'             AS ParentCompany
    UNION
    SELECT '4181-Medford-HH' AS AD_Department,
           '4181'            AS datateam_site_id,
           'SIG'             AS ParentCompany
    UNION
    SELECT '4191-Josephine' AS AD_Department,
           '419'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '4191-SaltLakeNorth-HH' AS AD_Department,
           '4191'                  AS datateam_site_id,
           'SIG'                   AS ParentCompany
    UNION
    SELECT '4201-Prestige-KittitasValley' AS AD_Department,
           '420'                          AS datateam_site_id,
           'INF'                          AS ParentCompany
    UNION
    SELECT '4211-CaseysPond' AS AD_Department,
           '421'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '4211-Payette-HOS' AS AD_Department,
           '4211'             AS datateam_site_id,
           'SIG'              AS ParentCompany
    UNION
    SELECT '4221-Nampa-HOS' AS AD_Department,
           '4221'           AS datateam_site_id,
           'SIG'            AS ParentCompany
    UNION
    SELECT '4251-Portland-HOS' AS AD_Department,
           '4251'              AS datateam_site_id,
           'SIG'               AS ParentCompany
    UNION
    SELECT '4271-Eugene-HOS' AS AD_Department,
           '4271'            AS datateam_site_id,
           'SIG'             AS ParentCompany
    UNION
    SELECT '4281-Medford-HOS' AS AD_Department,
           '4281'             AS datateam_site_id,
           'SIG'              AS ParentCompany
    UNION
    SELECT '4291-SaltLakeNorth-HOS' AS AD_Department,
           '4291'                   AS datateam_site_id,
           'SIG'                    AS ParentCompany
    UNION
    SELECT '4411-AvamarqDiagnostics' AS AD_Department,
           NULL                        AS datateam_site_id,
           'EXI'                     AS ParentCompany
    UNION
    SELECT '4441-ExigesImaging' AS AD_Department,
           NULL                   AS datateam_site_id,
           'EXI'                AS ParentCompany
    UNION
    SELECT '4481-ExigesLab' AS AD_Department,
           NULL               AS datateam_site_id,
           'EXI'            AS ParentCompany
    UNION
    SELECT '4501-Corporate Office' AS AD_Department,
           '4501'                  AS datateam_site_id,
           'AHS'                   AS ParentCompany
    UNION
    SELECT 'MCPc' AS AD_Department,
           NULL AS datateam_site_id,
           'AHS' AS ParentCompany
	UNION
    SELECT '4501-CorporateFacility' AS AD_Department,
           '4501'                   AS datateam_site_id,
           'AHS'                    AS ParentCompany
    UNION
    SELECT '4501-CorporateFacility Growth and Development' AS AD_Department,
           NULL                                              AS datateam_site_id,
           'AHS'                                           AS ParentCompany
    UNION
    SELECT '4501-Administration' AS AD_Department,
           4501                  AS datateam_site_id,
           'AHS'                 AS ParentCompany
    UNION
    SELECT '4501-CareConnect' AS AD_Department,
           4501               AS datateam_site_id,
           'AHS'              AS ParentCompany
    UNION
    SELECT '4501-Compliance' AS AD_Department,
           4501              AS datateam_site_id,
           'AHS'             AS ParentCompany
    UNION
    SELECT '4501-HumanResources' AS AD_Department,
           4501                  AS datateam_site_id,
           'AHS'                 AS ParentCompany
    UNION
    SELECT '4501-InformationTechnology' AS AD_Department,
           4501                         AS datateam_site_id,
           'AHS'                        AS ParentCompany
    UNION
    SELECT '4501-Legal' AS AD_Department,
           4501         AS datateam_site_id,
           'AHS'        AS ParentCompany
    UNION
    SELECT '4501-Recruitment' AS AD_Department,
           4501               AS datateam_site_id,
           'AHS'              AS ParentCompany
    UNION
    SELECT '4501-Sales&Marketing' AS AD_Department,
           4501                   AS datateam_site_id,
           'AHS'                  AS ParentCompany
    UNION
    SELECT 'Matrix' AS AD_Department, --Same as 4501-InformationTechnology
           4501     AS datateam_site_id,
           'AHS'    AS ParentCompany
    UNION
    SELECT '4541-StAnthonyHealthCenter' AS AD_Department,
           '454'                        AS datateam_site_id,
           'INF'                        AS ParentCompany
    UNION
    SELECT '4551-Corporate Office' AS AD_Department,
           NULL                      AS datateam_site_id,
           'AHS'                   AS ParentCompany
    UNION
    SELECT '4581-Consulenti' AS AD_Department,
           NULL                AS datateam_site_id,
           'CON'             AS ParentCompany
    UNION
    SELECT '4581-CopperHealth' AS AD_Department,
           '458'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '4691-ShalomPark' AS AD_Department,
           '469'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '4731-GS-SilverWood' AS AD_Department,
           '473'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '4751-Avamere-CascadePark' AS AD_Department,
           '475'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '4771-MiraVista' AS AD_Department,
           '477'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '4801-PointDevelopment' AS AD_Department,
           NULL                      AS datateam_site_id,
           'POI'                   AS ParentCompany
    UNION
    SELECT '4801-Shoreline' AS AD_Department,
           '480'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '4821-GS-EugeneVillage' AS AD_Department,
           '482'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '4861-IdahoStateVeteransHome' AS AD_Department,
           '486'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '4881-FairviewManor' AS AD_Department,
           '488'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '4921-GS-Bismarck' AS AD_Department, --Old name is in AD. Now called Prospera August Place.
           '492'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '4971-Prestige-Milwaukie' AS AD_Department,
           '497'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '4981-Prestige-Edmonds' AS AD_Department,
           '498'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '5051-LongviewHome' AS AD_Department,
           '505'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '5061-RoseVistaHome' AS AD_Department,
           '506'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '5141-GS-MountainViewManor' AS AD_Department,
           '514'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '5191-BlueValleyLutheranHome' AS AD_Department,
           '519'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '5201-ShastaView' AS AD_Department,
           '520'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '5201-SiennaHills' AS AD_Department,
           '5201'             AS datateam_site_id,
           'OVA'              AS ParentCompany
    UNION
    SELECT '5211-Heartwood' AS AD_Department,
           '5211'           AS datateam_site_id,
           'OVA'            AS ParentCompany
    UNION
    SELECT '5231-Avamere-PugetSound' AS AD_Department,
           '523'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '5241-Prestige-KarcherEstates' AS AD_Department,
           '524'                          AS datateam_site_id,
           'INF'                          AS ParentCompany
    UNION
    SELECT '5251-Prestige-ColonialVista' AS AD_Department,
           '525'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '5391-GS-GrandIsland' AS AD_Department,
           '539'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '5551-ChateauGirardeau' AS AD_Department,
           '555'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '5591-SecoraRehab' AS AD_Department,
           '559'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '5641-MtBakerCare' AS AD_Department,
           '564'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '5651-SharonCareCenter' AS AD_Department,
           '565'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '5661-ArlingtonHealthRehab' AS AD_Department,
           '566'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '5671-ViewRidge' AS AD_Department,
           '567'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '5681-TheOaksatTimberline' AS AD_Department,
           '568'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '5691-TheOaksatLakewood' AS AD_Department,
           '569'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '5701-TheOaksatForestBay' AS AD_Department,
           '570'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '5731-MissouriSlope' AS AD_Department,
           '573'                AS datateam_site_id,
           'INF'                AS ParentCompany
    UNION
    SELECT '5741-LaurelhurstVillage' AS AD_Department,
           '574'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '5761-SunriseCountryManor' AS AD_Department,
           '576'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '5771-MissionHealthcareatRenton' AS AD_Department,
           '577'                            AS datateam_site_id,
           'INF'                            AS ParentCompany
    UNION
    SELECT '5800' AS AD_Department,
           '580'  AS datateam_site_id,
           'INF'  AS ParentCompany
    UNION
    SELECT '5841-WestchesterPlace' AS AD_Department,
           '584'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '5851-AblePalms' AS AD_Department,
           '585'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '5861-SabalPalms' AS AD_Department,
           '586'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '5881-Terracina' AS AD_Department,
           '588'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '5891-CarsonTahoe' AS AD_Department,
           '589'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '5921-FiestaPark' AS AD_Department,
           '592'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '5931-ValleyView' AS AD_Department,
           '593'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '5941-RiversideHealthandRehab' AS AD_Department,
           '594'                          AS datateam_site_id,
           'INF'                          AS ParentCompany
    UNION
    SELECT '5951-HillsideHealthandRehab' AS AD_Department,
           '595'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '5961-VillageHealthandRehab' AS AD_Department,
           '596'                        AS datateam_site_id,
           'INF'                        AS ParentCompany
    UNION
    SELECT '5971-SherwoodPark' AS AD_Department,
           '597'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '6001-TherapySolutions' AS AD_Department,
           '600'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '6151-Ogden-HH' AS AD_Department,
           '6151'          AS datateam_site_id,
           'SIG'           AS ParentCompany
    UNION
    SELECT '6161-Logan-HH' AS AD_Department,
           '6161'          AS datateam_site_id,
           'SIG'           AS ParentCompany
    UNION
    SELECT '6181-Salem-HH' AS AD_Department,
           '6181'          AS datateam_site_id,
           'SIG'           AS ParentCompany
    UNION
    SELECT '6191-Nampa-HH' AS AD_Department,
           '4221'          AS datateam_site_id,
           'SIG'           AS ParentCompany
    UNION
    SELECT '6251-Ogden-HOS' AS AD_Department,
           '6251'           AS datateam_site_id,
           'SIG'            AS ParentCompany
    UNION
    SELECT '6281-Salem-HOS' AS AD_Department,
           '6281'           AS datateam_site_id,
           'SIG'            AS ParentCompany
    UNION
    SELECT '6301-Albany-HH' AS AD_Department,
           '6301'           AS datateam_site_id,
           'SIG'            AS ParentCompany
    UNION
    SELECT '6311-OregonCoast-HH' AS AD_Department,
           '6311'                AS datateam_site_id,
           'SIG'                 AS ParentCompany
    UNION
    SELECT '6321-Bend-HC' AS AD_Department,
           '6321'         AS datateam_site_id,
           'SIG'          AS ParentCompany
    UNION
    SELECT '6321-Bend-HH' AS AD_Department,
           '6321'         AS datateam_site_id,
           'SIG'          AS ParentCompany
    UNION
    SELECT '6501-MonteVistaEstates' AS AD_Department,
           '650'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '6511-LamarEstates' AS AD_Department,
           '651'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '6521-BethanyAtPacific' AS AD_Department,
           '652'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '6531-BothellHealthCare' AS AD_Department,
           '653'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '6541-StOttos' AS AD_Department,
           '654'          AS datateam_site_id,
           'INF'          AS ParentCompany
    UNION
    SELECT '6571-GoshenHealthCare' AS AD_Department,
           '657'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '6581-FriendshipHealthCenter' AS AD_Department,
           '658'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '6631-KinOnHC' AS AD_Department,
           '663'          AS datateam_site_id,
           'INF'          AS ParentCompany
    UNION
    SELECT '6651-WashingtonCare' AS AD_Department,
           '665'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '6661-LasVentanasSummerlin' AS AD_Department,
           '666'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '667-RegencyCoupeville' AS AD_Department,
           '667'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '6711-AngelsCareHH-Nebraska' AS AD_Department,
           '671'                       AS datateam_site_id,
           'INF'                        AS ParentCompany
    UNION
    SELECT '6741-TheTerracesOfBoise' AS AD_Department,
           '674'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '6761-AngelsCareHH-Iowa-CouncilBluffs' AS AD_Department,
           '676'                       AS datateam_site_id,
           'INF'                        AS ParentCompany
    UNION
    SELECT '6841-AlliantHomeHealth' AS AD_Department,
           '684'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '6871-BethanyNWHH'       AS AD_Department,
           '687'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '6931-TerracesatLosAltos' AS AD_Department,
           '693'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '6971-AlamitosWestHealth&Rehab' AS AD_Department,
           '697'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '7101-LaurelhurstVillage' AS AD_Department,
           '7101'                    AS datateam_site_id,
           'AVL'                     AS ParentCompany
    UNION
    SELECT '7111-ChestnutLane' AS AD_Department,
           '7111'              AS datateam_site_id,
           'AVL'               AS ParentCompany
    UNION
    SELECT '7121-HermistonHighland' AS AD_Department,
           '7121'                   AS datateam_site_id,
           'AVL'                    AS ParentCompany
    UNION
    SELECT '7131-Tigard' AS AD_Department,
           '7131'        AS datateam_site_id,
           'AVL'         AS ParentCompany
    UNION
    SELECT '7141-Lexington' AS AD_Department,
           '7141'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '7151-RioRancho' AS AD_Department,
           '7151'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '7161-Roswell' AS AD_Department,
           '7161'         AS datateam_site_id,
           'AVL'          AS ParentCompany
    UNION
    SELECT '7171-LasVegas' AS AD_Department,
           '7171'          AS datateam_site_id,
           'AVL'           AS ParentCompany
    UNION
    SELECT '7181-MosesLake' AS AD_Department,
           '7181'           AS datateam_site_id,
           'AVL'            AS ParentCompany
    UNION
    SELECT '7191-Spokane' AS AD_Department,
           '7191'         AS datateam_site_id,
           'AVL'          AS ParentCompany
    UNION
    SELECT '7201-Yakima' AS AD_Department,
           '7201'        AS datateam_site_id,
           'AVL'         AS ParentCompany
    UNION
    SELECT '7311-BendTransCare' AS AD_Department,
           '7311'               AS datateam_site_id,
           'AVL'                AS ParentCompany
    UNION
    SELECT '8001-InfinityAtHomePortlandWest' AS AD_Department,
           NULL                                AS datateam_site_id,
           'INF'                             AS ParentCompany
    UNION
    SELECT '8021-InfinityAtHomeEugene' AS AD_Department,
           NULL                          AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '8171-InfinityAtHome-McMinnville' AS AD_Department,
           '817'                             AS datateam_site_id,
           'INF'                             AS ParentCompany
    UNION
    SELECT '8401-CambridgeTerrace' AS AD_Department,
           '8401'                  AS datateam_site_id,
           'AVL'                   AS ParentCompany
    UNION
    SELECT '8411-CascadiaVillage' AS AD_Department,
           '8411'                 AS datateam_site_id,
           'AVL'                  AS ParentCompany
    UNION
    SELECT '8421-ColumbiaHeights' AS AD_Department,
           '8421'                 AS datateam_site_id,
           'AVL'                  AS ParentCompany
    UNION
    SELECT '8431-OakPark' AS AD_Department,
           '8431'         AS datateam_site_id,
           'AVL'          AS ParentCompany
    UNION
    SELECT '8441-SeaportLanding' AS AD_Department,
           '8441'                AS datateam_site_id,
           'AVL'                 AS ParentCompany
    UNION
    SELECT '9011-OvationSiennaHills' AS AD_Department,
           '9011'                    AS datateam_site_id,
           'OVA'                     AS ParentCompany
    UNION
    SELECT '9031-MarysWoods' AS AD_Department,
           '903'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '9061-MelodyLiving' AS AD_Department,
           '906'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '9081-PineGroveCrossing' AS AD_Department,
           '908'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '9131-TheSprings' AS AD_Department,
           '913'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '9141-KiplingMeadows' AS AD_Department,
           '914'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '9151-VillageAtBelmar' AS AD_Department,
           '915'                  AS datateam_site_id,
           'INF'                  AS ParentCompany
    UNION
    SELECT '9201-TheAckerly' AS AD_Department,
           '920'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '9211-RussellvillePark' AS AD_Department,
           '921'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '9311-FrankeTobeyJones' AS AD_Department,
           '931'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '9321-ClackamasWoods' AS AD_Department,
           '932'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '9341-CrescentPark' AS AD_Department,
           '934'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT '9401-EliteCare' AS AD_Department,
           '940'            AS datateam_site_id,
           'INF'            AS ParentCompany
    UNION
    SELECT '9441-CollegeView' AS AD_Department,
           '944'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '9481-Springcreek' AS AD_Department,
           '948'              AS datateam_site_id,
           'INF'              AS ParentCompany
    UNION
    SELECT '9571-CountryMeadows' AS AD_Department,
           '957'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '9651-Elkrun' AS AD_Department,
           '965'         AS datateam_site_id,
           'INF'         AS ParentCompany
    UNION
    SELECT '9671-Hilltop-TheFountains' AS AD_Department,
           '967'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '9681-Hilltop-TheCommons' AS AD_Department,
           '968'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '9721-SunshineGardens' AS AD_Department,
           '972'                  AS datateam_site_id,
           'INF'                  AS ParentCompany
    UNION
    SELECT '9771-LaurelParc' AS AD_Department,
           '977'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '9791-GoldenPond' AS AD_Department,
           '979'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '9831-Avamere-Stafford' AS AD_Department,
           '983'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '9841-TerwilligerPlaza' AS AD_Department,
           '984'                   AS datateam_site_id,
           'INF'                   AS ParentCompany
    UNION
    SELECT '9871-TheSprings-Tanasbourne' AS AD_Department,
           '987'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '9891-Summitview' AS AD_Department,
           '989'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '9951-HorizonHouse' AS AD_Department,
           '995'               AS datateam_site_id,
           'INF'               AS ParentCompany
    UNION
    SELECT 'IT'  AS AD_Department,
           NULL    AS datateam_site_id,
           'AHS' AS ParentCompany
    UNION
    SELECT 'NP2U' AS AD_Department,
           NULL     AS datateam_site_id,
           'NP2U' AS ParentCompany
    UNION
    SELECT '3421-VillaMaria' AS AD_Department,
           '342'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '3651-Prestige-Burlington' AS AD_Department,
           '365'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '4501- CorporateFacility' AS AD_Department,
           '4501'                    AS datateam_site_id,
           'AHS'                     AS ParentCompany
    UNION
    SELECT '6671-RegencyCoupeville' AS AD_Department,
           '667'                    AS datateam_site_id,
           'INF'                    AS ParentCompany
    UNION
    SELECT '6681-ColumbiaCareCenter' AS AD_Department,
           '668'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '6721-AngelsCareHH-Omaha' AS AD_Department,
           '672'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '6801-DevonshireAcres' AS AD_Department,
           '680'                  AS datateam_site_id,
           'INF'                  AS ParentCompany
    UNION
    SELECT '6811-VillaMaria' AS AD_Department,
           '342'             AS datateam_site_id,
           'INF'             AS ParentCompany
    UNION
    SELECT '6821-RosewoodOnBroadway' AS AD_Department,
           '682'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '6861-SunnyVistaLiving'   AS AD_Department,
           '686'                     AS datateam_site_id,
           'INF'                     AS ParentCompany
    UNION
    SELECT '6911-DiscoveryCareCenter' AS AD_Department,
           '691'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '8011-InfinityAtHomePortlandEast' AS AD_Department,
           '801'                             AS datateam_site_id,
           'INF'                             AS ParentCompany
    UNION
    SELECT '803-InfinityAtHome-Salem' AS AD_Department,
           '803'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '8031-InfinityAtHomeSalem' AS AD_Department,
           '803'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '8051-InfinityAtHome-Bend' AS AD_Department,
           '805'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '8061-InfinityAtHome-Spokane' AS AD_Department,
           '806'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '8071-InfinityAtHomeOmaha' AS AD_Department,
           '807'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '8091-InfinityAtHomeDenve' AS AD_Department,
           '809'                      AS datateam_site_id,
           'INF'                      AS ParentCompany
    UNION
    SELECT '8091-InfinityAtHomeDenver' AS AD_Department,
           '809'                       AS datateam_site_id,
           'INF'                       AS ParentCompany
    UNION
    SELECT '8121-InfinityAtHome-DowntownSeattle' AS AD_Department,
           '812'                                 AS datateam_site_id,
           'INF'                                 AS ParentCompany
    UNION
    SELECT '8151-InfinityAtHome-Corporate' AS AD_Department,
           '815'                           AS datateam_site_id,
           'INF'                           AS ParentCompany
    UNION
    SELECT '9011-Ovation-SiennaHills' AS AD_Department,
           '901'                      AS datateam_site_id,
           'OVA'                      AS ParentCompany
    UNION
    SELECT '9131-TheSprings-GreerGardens' AS AD_Department,
           '913'                          AS datateam_site_id,
           'INF'                          AS ParentCompany
    UNION
    SELECT '9201-TheAckerlyAtTimberland' AS AD_Department,
           '920'                         AS datateam_site_id,
           'INF'                         AS ParentCompany
    UNION
    SELECT '9321-TheSprings-ClackamasWoods' AS AD_Department,
           '932'                            AS datateam_site_id,
           'INF'                            AS ParentCompany
    UNION
    SELECT '9541-MiramontPointe' AS AD_Department,
           '954'                 AS datateam_site_id,
           'INF'                 AS ParentCompany
    UNION
    SELECT '916-Hilltop-CommunityResource' AS AD_Department,
           '916'                           AS datateam_site_id,
           'INF'                           AS ParentCompany
    UNION
    SELECT '9161-Hilltop-CommunityResource' AS AD_Department,
           '916'                           AS datateam_site_id,
           'INF'                           AS ParentCompany
    UNION
    SELECT '6421-Bend-HOS' AS AD_Department,
           '6421'          AS datateam_site_id,
           'SIG'           AS ParentCompany
    UNION
    SELECT '6831-JosephineHH' AS AD_Department,
           '6831'             AS datateam_site_id,
           'SIG'              AS ParentCompany
    UNION
    SELECT '9021-TheSpringsAtLakeOswego' AS AD_Department,
           '902'                         AS datateam_site_id,
           'INF'                         AS ParentCompany

Possibly Referenced Tables/Views

VW_OrgMap_AD