VW_OrgMap_FSDept - DataCStore Database

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

department

varchar

null

type_site_id

varchar

√

null

View Definition

CREATE VIEW dbo.VW_OrgMap_FSDept AS

/*********************************************************************
Database:		DataCStore
View:			dbo.VW_OrgMap_FSDept
Created:		2/22/2022
Description:	Mapper that resolves Fresh Service department to
                Data team type site id.
                In OrgMap repo, see: excel_helper\type_site_id_mappings.xlsx
*********************************************************************/

    SELECT '0011-EugeneRehab' AS department,
           '0011'             AS type_site_id
    UNION
    SELECT '0021-CorporateOffice' AS department,
           '000'                  AS type_site_id
    UNION
    SELECT '0021-InfinityCorporate' AS department,
           '000'                    AS type_site_id
    UNION
    SELECT '0021-Sunnyside' AS department,
           '0021'           AS type_site_id
    UNION
    SELECT '0031-SalemTransCare' AS department,
           '0031'                AS type_site_id
    UNION
    SELECT '0041-CoosBayRehab' AS department,
           '0041'              AS type_site_id
    UNION
    SELECT '0051-ClackamasRehab' AS department,
           '0051'                AS type_site_id
    UNION
    SELECT '0061-JunctionCityRehab' AS department,
           '0061'                   AS type_site_id
    UNION
    SELECT '0081-LebanonRehab' AS department,
           '0081'              AS type_site_id
    UNION
    SELECT '0091-OregonCityRehab' AS department,
           '0091'                 AS type_site_id
    UNION
    SELECT '0101-KingCityRehab' AS department,
           '0101'               AS type_site_id
    UNION
    SELECT '0151-NewportRehab' AS department,
           '0151'              AS type_site_id
    UNION
    SELECT '0171-BeavertonRehab' AS department,
           '0171'                AS type_site_id
    UNION
    SELECT '0281-HillsboroRehab' AS department,
           '0281'                AS type_site_id
    UNION
    SELECT '0611-Crestview' AS department,
           '0611'           AS type_site_id
    UNION
    SELECT '0621-Riverpark' AS department,
           '0621'           AS type_site_id
    UNION
    SELECT '0711-RogueValley' AS department,
           '0711'             AS type_site_id
    UNION
    SELECT '1001-Avamere-Beaverton' AS department,
           '100'                    AS type_site_id
    UNION
    SELECT '1021-ForestGrove' AS department,
           '002'              AS type_site_id
    UNION
    SELECT '1031-CascadeTerrace' AS department,
           '003'                 AS type_site_id
    UNION
    SELECT '1041-Chehalem' AS department,
           '004'           AS type_site_id
    UNION
    SELECT '1051-Avamere-Clackamas' AS department,
           '005'                    AS type_site_id
    UNION
    SELECT '1061-CoastFork' AS department,
           '006'            AS type_site_id
    UNION
    SELECT '1071-Avamere-Eugene' AS department,
           '007'                 AS type_site_id
    UNION
    SELECT '1091-Glisan' AS department,
           '009'         AS type_site_id
    UNION
    SELECT '1101-Avamere-JunctionCity' AS department,
           '010'                       AS type_site_id
    UNION
    SELECT '1111-Avamere-CoosBay' AS department,
           '011'                  AS type_site_id
    UNION
    SELECT '1121-Avamere-Heritage' AS department,
           '012'                   AS type_site_id
    UNION
    SELECT '1121-CascadeParkRehab' AS department,
           '1121'                  AS type_site_id
    UNION
    SELECT '1131-Avamere-Crestview' AS department,
           '217'                    AS type_site_id
    UNION
    SELECT '1131-Avamere-Hillsboro' AS department,
           '013'                    AS type_site_id
    UNION
    SELECT '1141-HoodRiver' AS department,
           '014'            AS type_site_id
    UNION
    SELECT '1161-Avamere-Keizer' AS department,
           '016'                 AS type_site_id
    UNION
    SELECT '1171-Avamere-KingCity' AS department,
           '017'                   AS type_site_id
    UNION
    SELECT '1181-LindaVista' AS department,
           '018'             AS type_site_id
    UNION
    SELECT '1191-OlympicRehabSequim' AS department,
           '1191'                    AS type_site_id
    UNION
    SELECT '1201-MolallaManor' AS department,
           '020'               AS type_site_id
    UNION
    SELECT '1201-RichmondBeach' AS department,
           '1201'               AS type_site_id
    UNION
    SELECT '1211-Avamere-OregonCity' AS department,
           '021'                     AS type_site_id
    UNION
    SELECT '1241-Avamere-Newport' AS department,
           '024'                  AS type_site_id
    UNION
    SELECT '1261-OregonCity' AS department,
           '026'             AS type_site_id
    UNION
    SELECT '1281-ParkForest' AS department,
           '028'             AS type_site_id
    UNION
    SELECT '1291-Porthaven' AS department,
           '029'            AS type_site_id
    UNION
    SELECT '1341-Avamere-Salem' AS department,
           '034'                AS type_site_id
    UNION
    SELECT '1351-SullivanPark' AS department,
           '035'               AS type_site_id
    UNION
    SELECT '1361-Avamere-PacificRidge' AS department,
           '036'                       AS type_site_id
    UNION
    SELECT '1381-Timberview' AS department,
           '038'             AS type_site_id
    UNION
    SELECT '1401-Avamere-Lebanon' AS department,
           '040'                  AS type_site_id
    UNION
    SELECT '1421-Willowbrook' AS department,
           '042'              AS type_site_id
    UNION
    SELECT '1441-MarysWoods' AS department,
           '044'             AS type_site_id
    UNION
    SELECT '1471-Creswell' AS department,
           '047'           AS type_site_id
    UNION
    SELECT '1511-Avamere-Richmond' AS department,
           '051'                   AS type_site_id
    UNION
    SELECT '1521-TacomaRehab' AS department,
           '1521'             AS type_site_id
    UNION
    SELECT '1541-TacomaSkilledNursing' AS department,
           '1541'                      AS type_site_id
    UNION
    SELECT '1541-Toppenish' AS department,
           '054'            AS type_site_id
    UNION
    SELECT '1551-BellinghamRehab' AS department,
           '1551'                 AS type_site_id
    UNION
    SELECT '1551-Discovery' AS department,
           '055'            AS type_site_id
    UNION
    SELECT '1561-QueenAnne' AS department,
           '1561'           AS type_site_id
    UNION
    SELECT '1561-Village' AS department,
           '056'          AS type_site_id
    UNION
    SELECT '1571-PugetSound' AS department,
           '1571'            AS type_site_id
    UNION
    SELECT '1641-StFrancisBellingham' AS department,
           '1641'                     AS type_site_id
    UNION
    SELECT '1661-Landmark' AS department,
           '066'           AS type_site_id
    UNION
    SELECT '1711-Malley' AS department,
           '1711'        AS type_site_id
    UNION
    SELECT '1721-Brighton' AS department,
           '1721'          AS type_site_id
    UNION
    SELECT '1731-FiestaPark' AS department,
           '1731'            AS type_site_id
    UNION
    SELECT '1741-Avamere-Olympic' AS department,
           '074'                  AS type_site_id
    UNION
    SELECT '1751-BethanySilverLake' AS department,
           '075'                    AS type_site_id
    UNION
    SELECT '1911-TriStateHospital' AS department,
           '091'                   AS type_site_id
    UNION
    SELECT '2031-Avamere-Pearl' AS department,
           '203'                AS type_site_id
    UNION
    SELECT '2171-Avamere-Crestview' AS department,
           '217'                    AS type_site_id
    UNION
    SELECT '2181-Avamere-Riverpark' AS department,
           '218'                    AS type_site_id
    UNION
    SELECT '2191-Avamere-ThreeFountains' AS department,
           '219'                         AS type_site_id
    UNION
    SELECT '2201-Avamere-StFrancis' AS department,
           '220'                    AS type_site_id
    UNION
    SELECT '2231-Skyline' AS department,
           '223'          AS type_site_id
    UNION
    SELECT '2261-CourtAtKeizer' AS department,
           '2261'               AS type_site_id
    UNION
    SELECT '2271-ThePearlKruse' AS department,
           '2271'               AS type_site_id
    UNION
    SELECT '2331-PinecrestCommunity' AS department,
           '233'                     AS type_site_id
    UNION
    SELECT '2481-PacificHealth' AS department,
           '248'                AS type_site_id
    UNION
    SELECT '2501-SummitView' AS department,
           '250'             AS type_site_id
    UNION
    SELECT '2551-VillageManor' AS department,
           '255'               AS type_site_id
    UNION
    SELECT '2631-HollyCreek' AS department,
           '263'             AS type_site_id
    UNION
    SELECT '2631-Three Fountains-Waterford' AS department,
           '2631'                           AS type_site_id
    UNION
    SELECT '2641-ClermontPark' AS department,
           '264'               AS type_site_id
    UNION
    SELECT '2651-SomerenGlen' AS department,
           '265'              AS type_site_id
    UNION
    SELECT '2651-TheStafford' AS department,
           '2651'             AS type_site_id
    UNION
    SELECT '2711-Avamere-Bend' AS department,
           '271'               AS type_site_id
    UNION
    SELECT '2751-BendTransCare' AS department,
           '2751'               AS type_site_id
    UNION
    SELECT '2801-Prestige-Anchorage' AS department,
           '280'                     AS type_site_id
    UNION
    SELECT '2871-Fernhill' AS department,
           '287'           AS type_site_id
    UNION
    SELECT '2881-StephensonNursingCenter' AS department,
           '288'                          AS type_site_id
    UNION
    SELECT '3061-ChristianHealth' AS department,
           '306'                  AS type_site_id
    UNION
    SELECT '3091-WestHills' AS department,
           '309'            AS type_site_id
    UNION
    SELECT '3111-LegacyHouse' AS department,
           '311' AS type_site_id
    UNION
    SELECT '3251-EbenEzer' AS department,
           '325'           AS type_site_id
    UNION
    SELECT '3261-Rockwood-SouthHill' AS department,
           '326'                     AS type_site_id
    UNION
    SELECT '3261-TheArbor' AS department,
           '3261'          AS type_site_id
    UNION
    SELECT '3271-BendArbor' AS department,
           '3271'           AS type_site_id
    UNION
    SELECT '3301-ColumbiaLutheranHome' AS department,
           '330'                       AS type_site_id
    UNION
    SELECT '3301-Newberg' AS department,
           '3301'         AS type_site_id
    UNION
    SELECT '3311-Sherwood' AS department,
           '3311'          AS type_site_id
    UNION
    SELECT '3321-Bayview' AS department,
           '332'          AS type_site_id
    UNION
    SELECT '3321-Sandy' AS department,
           '3321'       AS type_site_id
    UNION
    SELECT '3331-Hillsboro' AS department,
           '3331'           AS type_site_id
    UNION
    SELECT '3341-StHelens' AS department,
           '3341'          AS type_site_id
    UNION
    SELECT '3351-Bethany' AS department,
           '3351'         AS type_site_id
    UNION
    SELECT '3421-VillaMaria' AS department,
           '342'             AS type_site_id
    UNION
    SELECT '3481-BerryPark' AS department,
           '3481'           AS type_site_id
    UNION
    SELECT '3491-VibraHospital' AS department,
           '349'                AS type_site_id
    UNION
    SELECT '3501-Bremerton' AS department,
           '3501'           AS type_site_id
    UNION
    SELECT '3531-CareageWhidbey' AS department,
           '353'                 AS type_site_id
    UNION
    SELECT '3541-Prestige-Reedwood' AS department,
           '354'                    AS type_site_id
    UNION
    SELECT '3601-MyrtlePoint' AS department,
           '360'              AS type_site_id
    UNION
    SELECT '6361-MissionatBellevue' AS department, -- Per Remya this is actually 363 Mission Bellevue
           '363' AS type_site_id
    UNION
    SELECT '3621-SunnyVistaLiving' AS department,
           '362'                   AS type_site_id
    UNION
    SELECT '3631-Mission' AS department,
           '363'          AS type_site_id
    UNION
    SELECT '3651-Prestige-Burlington' AS department,
           '365'                      AS type_site_id
    UNION
    SELECT '3661-Prestige-Clarkston' AS department,
           '366'                     AS type_site_id
    UNION
    SELECT '3681-Prestige-Camas' AS department,
           '368'                 AS type_site_id
    UNION
    SELECT '3691-Prestige-Sunnyside' AS department,
           '369'                     AS type_site_id
    UNION
    SELECT '3701-Prestige-MenloPark' AS department,
           '370'                     AS type_site_id
    UNION
    SELECT '3701-SuzanneElise' AS department,
           '3701'              AS type_site_id
    UNION
    SELECT '3711-Prestige-TheOrchards' AS department,
           '371'                       AS type_site_id
    UNION
    SELECT '3711-Seaside' AS department,
           '3711'         AS type_site_id
    UNION
    SELECT '3721-Prestige-Richland' AS department,
           '373'                    AS type_site_id
    UNION
    SELECT '3731-RichlandRehabCenter' AS department,
           '372'                      AS type_site_id
    UNION
    SELECT '3731-Stratford' AS department,
           '3731'           AS type_site_id
    UNION
    SELECT '3741-Sheridan' AS department,
           '3741'          AS type_site_id
    UNION
    SELECT '3741-SouthOgden' AS department,
           '3741'            AS type_site_id
    UNION
    SELECT '3841-Prestige-Puyallup' AS department,
           '384'                    AS type_site_id
    UNION
    SELECT '3841-PuyallupRehab' AS department,
           '384'                AS type_site_id
    UNION
    SELECT '3851-Prestige-Tacoma' AS department,
           '385'                  AS type_site_id
    UNION
    SELECT '3881-Avamere-RogueValley' AS department,
           '388'                      AS type_site_id
    UNION
    SELECT '3891-Avamere-QueenAnne' AS department,
           '389'                    AS type_site_id
    UNION
    SELECT '3901-Avamere-Bellingham' AS department,
           '390'                     AS type_site_id
    UNION
    SELECT '3921-Avamere-Brighton' AS department,
           '392'                   AS type_site_id
    UNION
    SELECT '3931-Avamere-Malley' AS department,
           '393'                 AS type_site_id
    UNION
    SELECT '4011-Prestige-McMinnville' AS department,
           '401'                       AS type_site_id
    UNION
    SELECT '4031-Prestige-Centralia' AS department,
           '403'                     AS type_site_id
    UNION
    SELECT '4111-WillametteView' AS department,
           '411'                 AS type_site_id
    UNION
    SELECT '4121-Avamere-Sunnyside' AS department,
           '412'                    AS type_site_id
    UNION
    SELECT '4121-SignatureCorporate' AS department,
           '4121'                    AS type_site_id
    UNION
    SELECT '4141-Bellingham-HH' AS department,
           '4141'               AS type_site_id
    UNION
    SELECT '4161-Eugene-HH' AS department,
           '4161'           AS type_site_id
    UNION
    SELECT '4171-Bellevue-HH' AS department,
           '4171'             AS type_site_id
    UNION
    SELECT '4191-Josephine' AS department,
           '419'            AS type_site_id
    UNION
    SELECT '4191-SaltLakeNorth-HH' AS department,
           '4191'                  AS type_site_id
    UNION
    SELECT '4201-Prestige-KittitasValley' AS department,
           '420'                          AS type_site_id
    UNION
    SELECT '4211-CaseysPond' AS department,
           '421'             AS type_site_id
    UNION
    SELECT '4221-Nampa-HOS' AS department,
           '4221'           AS type_site_id
    UNION
    SELECT '4251-Portland-HOS' AS department,
           '4251'              AS type_site_id
    UNION
    SELECT '4271-Eugene-HOS' AS department,
           '4271'            AS type_site_id
    UNION
    SELECT '4281-Medford-HOS' AS department,
           '4281'             AS type_site_id
    UNION
    SELECT '4411-AvamarqDiagnostics' AS department,
           '4411'                    AS type_site_id
    UNION
    SELECT '4441-ExigesImaging' AS department,
           '4441'               AS type_site_id
    UNION
    SELECT '4501-Administration' AS department,
           '4501'                AS type_site_id
    UNION
    SELECT '4501-CareConnect' AS department,
           '450' AS type_site_id
    UNION
    SELECT '4501-Compliance' AS department,
           '4501'            AS type_site_id
    UNION
    SELECT '4501-CorporateFacility' AS department,
           '4501'                   AS type_site_id
    UNION
    SELECT '4501-HumanResources' AS department,
           '4501'                AS type_site_id
    UNION
    SELECT '4501-InformationTechnology' AS department,
           '4501'                       AS type_site_id
    UNION
    SELECT '4501-Legal' AS department,
           '4501'       AS type_site_id
    UNION
    SELECT '4501-Recruitment' AS department,
           '4501'             AS type_site_id
    UNION
    SELECT '4501-Sales&Marketing' AS department,
           '4501'                 AS type_site_id
    UNION
    SELECT '4541-StAnthonyHealthCenter' AS department,
           '454'                        AS type_site_id
    UNION
    SELECT '4551-AvamereLiving' AS department,
           '4551'               AS type_site_id
    UNION
    SELECT '4551-Corporate Office' AS department,
           '4551'                  AS type_site_id
    UNION
    SELECT '4581-Consulenti' AS department,
           '4581'            AS type_site_id
    UNION
    SELECT '4691-ShalomPark' AS department,
           '469'             AS type_site_id
    UNION
    SELECT '4751-Avamere-CascadePark' AS department,
           '475'                      AS type_site_id
    UNION
    SELECT '4801-PointDevelopment' AS department,
           '4801'                  AS type_site_id
    UNION
    SELECT '4861-IdahoStateVeteransHome' AS department,
           '486'                         AS type_site_id
    UNION
    SELECT '4881-FairviewManor' AS department,
           '488'                AS type_site_id
    UNION
    SELECT '4971-Prestige-Milwaukie' AS department,
           '497'                     AS type_site_id
    UNION
    SELECT '4981-Prestige-Edmonds' AS department,
           '498'                   AS type_site_id
    UNION
    SELECT '5061-RoseVistaHome' AS department,
           '506'                AS type_site_id
    UNION
    SELECT '5191-BlueValleyLutheranHome' AS department,
           '519'                         AS type_site_id
    UNION
    SELECT '5201-ShastaView' AS department,
           '520'             AS type_site_id
    UNION
    SELECT '5201-SiennaHills' AS department,
           '5201'             AS type_site_id
    UNION
    SELECT '5211-Heartwood' AS department,
           '5211'           AS type_site_id
    UNION
    SELECT '5231-Avamere-PugetSound' AS department,
           '523'                     AS type_site_id
    UNION
    SELECT '5241-Prestige-KarcherEstates' AS department,
           '524'                          AS type_site_id
    UNION
    SELECT '5251-Prestige-ColonialVista' AS department,
           '525'                         AS type_site_id
    UNION
    SELECT '5551-ChateauGirardeau' AS department,
           '555'                   AS type_site_id
    UNION
    SELECT '5641-MtBakerCare' AS department,
           '564'              AS type_site_id
    UNION
    SELECT '5661-ArlingtonHealthRehab' AS department,
           '566'                       AS type_site_id
    UNION
    SELECT '5671-ViewRidge' AS department,
           '567'            AS type_site_id
    UNION
    SELECT '5731-MissouriSlope' AS department,
           '573'                AS type_site_id
    UNION
    SELECT '5741-LaurelhurstVillage' AS department,
           '574'                     AS type_site_id
    UNION
    SELECT '5761-SunriseCountryManor' AS department,
           '576'                      AS type_site_id
    UNION
    SELECT '5771-MissionHealthcareatRenton' AS department,
           '577'                            AS type_site_id
    UNION
    SELECT '5841-WestchesterPlace' AS department,
           '584'                   AS type_site_id
    UNION
    SELECT '5861-SabalPalms' AS department,
           '586'             AS type_site_id
    UNION
    SELECT '5881-Terracina' AS department,
           '588'            AS type_site_id
    UNION
    SELECT '5891-CarsonTahoe' AS department,
           '589'              AS type_site_id
    UNION
    SELECT '5921-FiestaPark' AS department,
           '592'             AS type_site_id
    UNION
    SELECT '5931-ValleyView' AS department,
           '593'             AS type_site_id
    UNION
    SELECT '5941-RiversideHealthandRehab' AS department,
           '594'                          AS type_site_id
    UNION
    SELECT '5961-VillageHealthandRehab' AS department,
           '596'                        AS type_site_id
    UNION
    SELECT '5971-SherwoodPark' AS department,
           '597'               AS type_site_id
    UNION
    SELECT '6181-Salem-HH' AS department,
           '6181'          AS type_site_id
    UNION
    SELECT '6281-Salem-HOS' AS department,
           '6281'           AS type_site_id
    UNION
    SELECT '6301-Albany-HH' AS department,
           '6301'           AS type_site_id
    UNION
    SELECT '6311-OregonCoast-HH' AS department,
           '6311'                AS type_site_id
    UNION
    SELECT '6421-Bend-HOS' AS department,
           '6421'          AS type_site_id
    UNION
    SELECT '6501-MonteVistaEstates' AS department,
           '650'                    AS type_site_id
    UNION
    SELECT '6521-BethanyAtPacific' AS department,
           '652'                   AS type_site_id
    UNION
    SELECT '6531-BothellHealthcare' AS department,
           '653'                    AS type_site_id
    UNION
    SELECT '6541-StOttos' AS department,
           '654'          AS type_site_id
    UNION
    SELECT '6571-GoshenHealthCare' AS department,
           '657'                   AS type_site_id
    UNION
    SELECT '6581-FriendshipHealthCenter' AS department,
           '658'                         AS type_site_id
    UNION
    SELECT '6631-KinOnHC' AS department,
           '663'          AS type_site_id
    UNION
    SELECT '6651-WashingtonCare' AS department,
           '665'                 AS type_site_id
    UNION
    SELECT '6661-LasVentanasSummerlin' AS department,
           '666'                       AS type_site_id
    UNION
    SELECT '6671-RegencyCoupeville' AS department,
           '667'                    AS type_site_id
    UNION
    SELECT '6681-ColumbiaCareCenter' AS department,
           '668'                     AS type_site_id
    UNION
    SELECT '6741-TheTerracesOfBoise' AS department,
           '674'                     AS type_site_id
    UNION
    SELECT '6801-DevonshireAcres' AS department,
           '680'                  AS type_site_id
    UNION
    SELECT '6811-VillaMaria' AS department,
           '681'             AS type_site_id
    UNION
    SELECT '6821-RosewoodOnBroadway' AS department,
           '682'                     AS type_site_id
    UNION
    SELECT '6831-JosephineHH' AS department,
           '683'              AS type_site_id
    UNION
    SELECT '6841-AlliantHomeHealth' AS department,
           '684'                    AS type_site_id
    UNION
    SELECT '6861-SunnyVistaLiving' AS department,
           '686'                   AS type_site_id
    UNION
    SELECT '6871-BethanyNWHH' AS department,
           '687'              AS type_site_id
    UNION
    SELECT '6911-DiscoveryCareCenter' AS department,
           '691'                      AS type_site_id
    UNION
    SELECT '6931-TerracesatLosAltos' AS department,
           '693'                     AS type_site_id
    UNION
    SELECT '6961-AbleCareHH' AS department,
           '696'             AS type_site_id
    UNION
    SELECT '6971-AlamitosWestHealth&Rehab' AS department,
           '697'                           AS type_site_id
    UNION
    SELECT '7101-LaurelhurstVillage' AS department,
           '7101'                    AS type_site_id
    UNION
    SELECT '7111-ChestnutLane' AS department,
           '7111'              AS type_site_id
    UNION
    SELECT '7121-HermistonHighland' AS department,
           '7121'                   AS type_site_id
    UNION
    SELECT '7131-Tigard' AS department,
           '7131'        AS type_site_id
    UNION
    SELECT '7141-Lexington' AS department,
           '7141'           AS type_site_id
    UNION
    SELECT '7151-RioRancho' AS department,
           '7151'           AS type_site_id
    UNION
    SELECT '7161-Roswell' AS department,
           '7161'         AS type_site_id
    UNION
    SELECT '7171-LasVegas' AS department,
           '7171'          AS type_site_id
    UNION
    SELECT '7181-MosesLake' AS department,
           '7181'           AS type_site_id
    UNION
    SELECT '7191-Spokane' AS department,
           '7191'         AS type_site_id
    UNION
    SELECT '7201-Yakima' AS department,
           '7201'        AS type_site_id
    UNION
    SELECT '7311-BendTransCare' AS department,
           '2751'               AS type_site_id
    UNION
    SELECT '8001-InfinityAtHomePortlandWest' AS department,
           '800'                             AS type_site_id
    UNION
    SELECT '8011-InfinityAtHomePortlandEast' AS department,
           '801'                             AS type_site_id
    UNION
    SELECT '8021-InfinityAtHomeEugene' AS department,
           '802'                       AS type_site_id
    UNION
    SELECT '803-InfinityAtHome-Salem' AS department,
           '803'                      AS type_site_id
    UNION
    SELECT '8031-InfinityAtHomeSalem' AS department,
           '803'                      AS type_site_id
    UNION
    SELECT '8061-InfinityAtHome-Spokane' AS department,
           '806'                         AS type_site_id
    UNION
    SELECT '8071-InfinityAtHomeOmaha' AS department,
           '807'                      AS type_site_id
    UNION
    SELECT '8091-InfinityAtHomeDenver' AS department,
           '809'                       AS type_site_id
    UNION
    SELECT '8121-InfinityAtHome-DowntownSeattle' AS department,
           '812'                                 AS type_site_id
    UNION
    SELECT '8151-InfinityAtHome-Corporate' AS department,
           '815'                           AS type_site_id
    UNION
    SELECT '8171-InfinityAtHome-McMinnville' AS department,
           '817' AS type_site_id
    UNION
    SELECT '8401-CambridgeTerrace' AS department,
           '8401'                  AS type_site_id
    UNION
    SELECT '8411-CascadiaVillage' AS department,
           '8411'                 AS type_site_id
    UNION
    SELECT '8421-ColumbiaHeights' AS department,
           '8421'                 AS type_site_id
    UNION
    SELECT '8431-OakPark' AS department,
           '8431'         AS type_site_id
    UNION
    SELECT '8441-SeaportLanding' AS department,
           '8441'                AS type_site_id
    UNION
    SELECT '9001-Ovation-Heartwood' AS department,
           '900' AS type_site_id
    UNION
    SELECT '9011-Ovation-SiennaHills' AS department,
           '901'                      AS type_site_id
    UNION
    SELECT '9011-OvationSiennaHills' AS department,
           '901'                     AS type_site_id
    UNION
    SELECT '9021-TheSpring-LakeOswego' AS department,
           '902'                       AS type_site_id
    UNION
    SELECT '9021-TheSpringsAtLakeOswego' AS department,
           '902'                         AS type_site_id
    UNION
    SELECT '9031-MarysWoods' AS department,
           '903'             AS type_site_id
    UNION
    SELECT '9061-MelodyLiving' AS department,
           '906'               AS type_site_id
    UNION
    SELECT '9081-PineGroveCrossing' AS department,
           '908'                    AS type_site_id
    UNION
    SELECT '9131-TheSprings-GreerGardens' AS department,
           '913'                          AS type_site_id
    UNION
    SELECT '9201-TheAckerlyAtTimberland' AS department,
           '920'                         AS type_site_id
    UNION
    SELECT '9211-RussellvillePark' AS department,
           '921'                   AS type_site_id
    UNION
    SELECT '9311-FrankeTobeyJones' AS department,
           '931'                   AS type_site_id
    UNION
    SELECT '9321-ClackamasWoods' AS department,
           '932'                 AS type_site_id
    UNION
    SELECT '9321-TheSprings-ClackamasWoods' AS department,
           '932'                            AS type_site_id
    UNION
    SELECT '9331-TheSprings-CarmanOaks' AS department,
           '933'                        AS type_site_id
    UNION
    SELECT '9401-EliteCare' AS department,
           '582'            AS type_site_id
    UNION
    SELECT '9441-CollegeView' AS department,
           '944'              AS type_site_id
    UNION
    SELECT '9671-Hilltop-TheFountains' AS department,
           '967'                       AS type_site_id
    UNION
    SELECT '9681-Hilltop-TheCommons' AS department,
           '968'                     AS type_site_id
    UNION
    SELECT '9721-SunshineGardens' AS department,
           '972'                  AS type_site_id
    UNION
    SELECT '9771-LaurelParc' AS department,
           '977'             AS type_site_id
    UNION
    SELECT '9831-Avamere-Stafford' AS department,
           '983'                   AS type_site_id
    UNION
    SELECT '9841-TerwilligerPlaza' AS department,
           '984'                   AS type_site_id
    UNION
    SELECT '9871-TheSprings-Tanasbourne' AS department,
           '987'                         AS type_site_id
    UNION
    SELECT '9891-Summitview' AS department,
           '989'             AS type_site_id
    UNION
    SELECT '9951-HorizonHouse' AS department,
           '995'               AS type_site_id
    UNION
    SELECT 'Unassigned' AS department,
           NULL         AS type_site_id

Possibly Referenced Tables/Views

VW_OrgMap_FSDept