VW_ActiveDir_TypeLookup

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

group_cn

varchar

null

type

varchar

null

View Definition

CREATE VIEW dbo.VW_ActiveDir_TypeLookup AS

/*********************************************************************
Database:		DataCStore
View:			dbo.VW_ActiveDir_TypeLookup
Created:		10/3/2020
Description:	Lookup "table" created to enable Karan to do
                analysis and determine whether job title can be
                be used to derived group type.
*********************************************************************/

    SELECT 'SC_AHS_CC_CL' AS group_cn,
           'Department'   AS type
    UNION
    SELECT 'SC_AHS_CC_EXEC' AS group_cn,
           'Exec'           AS type
    UNION
    SELECT 'SC_AHS_CC_SALES' AS group_cn,
           'Department'      AS type
    UNION
    SELECT 'SC_AHS_CC_Team' AS group_cn,
           'Department'     AS type
    UNION
    SELECT 'SC_AHS_CEO' AS group_cn,
           'Exec'       AS type
    UNION
    SELECT 'SC_AHS_CFO' AS group_cn,
           'Exec'       AS type
    UNION
    SELECT 'SC_AHS_CISO' AS group_cn,
           'Exec'        AS type
    UNION
    SELECT 'SC_AHS_CMO' AS group_cn,
           'Exec'       AS type
    UNION
    SELECT 'SC_AHS_COMPL' AS group_cn,
           'Department'   AS type
    UNION
    SELECT 'SC_AHS_COO' AS group_cn,
           'Exec'       AS type
    UNION
    SELECT 'SC_AHS_CSO' AS group_cn,
           'Exec'       AS type
    UNION
    SELECT 'SC_AHS_Data_Team' AS group_cn,
           'Department'       AS type
    UNION
    SELECT 'SC_AHS_DIR_PayRel' AS group_cn,
           'Exec'              AS type
    UNION
    SELECT 'SC_AHS_EXEC' AS group_cn,
           'Exec'        AS type
    UNION
    SELECT 'SC_AHS_HR'  AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_AHS_HR_EXEC' AS group_cn,
           'Exec'           AS type
    UNION
    SELECT 'SC_AHS_IT_EXEC' AS group_cn,
           'Exec'           AS type
    UNION
    SELECT 'SC_AHS_Legal_Exec' AS group_cn,
           'Exec'              AS type
    UNION
    SELECT 'SC_AHS_MARCOM_EXEC' AS group_cn,
           'Exec'               AS type
    UNION
    SELECT 'SC_AHS_PM'  AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_AHS_Recruiting_Head' AS group_cn,
           'Exec'                   AS type
    UNION
    SELECT 'SC_AHS_VP_ANC' AS group_cn,
           'Exec'          AS type
    UNION
    SELECT 'SC_AVA_0011_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0011_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0021_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0021_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0031_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0031_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0041_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0041_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0051_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0051_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0061_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0061_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0081_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0081_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0091_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0091_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0101_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0101_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0151_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0151_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0171_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0171_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0281_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0281_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0611_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0611_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0621_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0621_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0711_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_0711_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1121_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1121_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1191_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1191_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1201_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1201_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1521_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1521_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1541_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1541_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1551_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1551_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1561_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1561_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1571_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1571_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1641_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1641_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1701_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1701_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1711_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1711_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1721_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1721_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1731_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_1731_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_2261_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_2261_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_2271_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_2271_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_2631_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_2631_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_2651_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_2651_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3261_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3261_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3301_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3301_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3311_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3311_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3321_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3321_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3331_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3331_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3341_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3341_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3351_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3351_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3481_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3481_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3501_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3501_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3701_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3701_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3711_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3711_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3731_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3731_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3741_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3741_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3851_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_3851_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7101_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7101_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7111_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7111_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7121_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7121_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7131_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7131_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7141_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7141_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7151_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7151_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7161_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7161_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7171_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7171_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7181_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7181_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7191_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7191_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7201_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7201_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7311_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_7311_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8401_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8401_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8411_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8411_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8421_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8421_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8431_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8431_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8441_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_8441_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_AVA_AFM' AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_AVA_AZ_CBC' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_BusDev' AS group_cn,
           'Exec'          AS type
    UNION
    SELECT 'SC_AVA_CBC_AFM' AS group_cn,
           'Department'     AS type
    UNION
    SELECT 'SC_AVA_CBC_EXEC' AS group_cn,
           'Exec'            AS type
    UNION
    SELECT 'SC_AVA_CBC_OPS' AS group_cn,
           'Department'     AS type
    UNION
    SELECT 'SC_AVA_CBC_RDO' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_AVA_CBC_RDO_OneOff' AS group_cn,
           'n/a'                   AS type
    UNION
    SELECT 'SC_AVA_CBC_RDO_OR' AS group_cn,
           'Regional'          AS type
    UNION
    SELECT 'SC_AVA_CBC_RDO_SW' AS group_cn,
           'Regional'          AS type
    UNION
    SELECT 'SC_AVA_CBC_RDO_WA_OR' AS group_cn,
           'Regional'             AS type
    UNION
    SELECT 'SC_AVA_CBC_RNC' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_AVA_CBC_SALES' AS group_cn,
           'Department'       AS type
    UNION
    SELECT 'SC_AVA_CO_SNF' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_COMPL' AS group_cn,
           'Department'   AS type
    UNION
    SELECT 'SC_AVA_DIR_BusDev' AS group_cn,
           'Exec'              AS type
    UNION
    SELECT 'SC_AVA_EXEC' AS group_cn,
           'Exec'        AS type
    UNION
    SELECT 'SC_AVA_FIN' AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_AVA_FIN_EXEC' AS group_cn,
           'Exec'            AS type
    UNION
    SELECT 'SC_AVA_HR'  AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_AVA_ID_SNF' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_NE_CBC' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_NM_CBC' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_NM_SNF' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_OPS' AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_AVA_OR_CBC' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_OR_SNF' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_Quality_EXEC' AS group_cn,
           'Exec'                AS type
    UNION
    SELECT 'SC_AVA_SNF_AFM' AS group_cn,
           'Department'     AS type
    UNION
    SELECT 'SC_AVA_SNF_EXEC' AS group_cn,
           'Exec'            AS type
    UNION
    SELECT 'SC_AVA_SNF_OPS' AS group_cn,
           'Department'     AS type
    UNION
    SELECT 'SC_AVA_SNF_RDO' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_AVA_SNF_RNC' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_AVA_UT_CBC' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_VP_BusDev' AS group_cn,
           'Exec'             AS type
    UNION
    SELECT 'SC_AVA_WA_CBC' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_AVA_WA_SNF' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_INF_ARD_MID1' AS group_cn,
           'Regional'        AS type
    UNION
    SELECT 'SC_INF_ARD_MID2' AS group_cn,
           'Regional'        AS type
    UNION
    SELECT 'SC_INF_ARD_MTN2' AS group_cn,
           'Regional'        AS type
    UNION
    SELECT 'SC_INF_ARD_NDM' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_OP1' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_OP2' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_OP3' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_OR4' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_OR5' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_OR6' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_OR7' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_SE1' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_WA1' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_WA2' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_WA3' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_ARD_WA5' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_Clinical' AS group_cn,
           'Department'      AS type
    UNION
    SELECT 'SC_INF_COMPL' AS group_cn,
           'Department'   AS type
    UNION
    SELECT 'SC_INF_COMPL_Exec' AS group_cn,
           'Exec'              AS type
    UNION
    SELECT 'SC_INF_DIR_ProfDev' AS group_cn,
           'Exec'               AS type
    UNION
    SELECT 'SC_INF_DIR_Recruiting' AS group_cn,
           'Exec'                  AS type
    UNION
    SELECT 'SC_INF_DIR_ThStaff' AS group_cn,
           'Exec'               AS type
    UNION
    SELECT 'SC_INF_DORs' AS group_cn,
           'Department'  AS type
    UNION
    SELECT 'SC_INF_EXEC' AS group_cn,
           'Exec'        AS type
    UNION
    SELECT 'SC_INF_FIN' AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_INF_FIN_Exec' AS group_cn,
           'Exec'            AS type
    UNION
    SELECT 'SC_INF_HR'  AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_INF_HR_EXEC' AS group_cn,
           'Exec'           AS type
    UNION
    SELECT 'SC_INF_OPS' AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_INF_OPS_Exec' AS group_cn,
           'Exec'            AS type
    UNION
    SELECT 'SC_INF_OUTP_ARD' AS group_cn,
           'Regional'        AS type
    UNION
    SELECT 'SC_INF_OUTP_Exec' AS group_cn,
           'Exec'             AS type
    UNION
    SELECT 'SC_INF_Quality_Exec' AS group_cn,
           'Exec'                AS type
    UNION
    SELECT 'SC_INF_RDO_OPS' AS group_cn,
           'Department'       AS type
    UNION
    SELECT 'SC_INF_Recruiting' AS group_cn,
           'Department'        AS type
    UNION
    SELECT 'SC_INF_SALES' AS group_cn,
           'Department'   AS type
    UNION
    SELECT 'SC_INF_SALES_Exec' AS group_cn,
           'Exec'              AS type
    UNION
    SELECT 'SC_INF_SNF_ARD' AS group_cn,
           'Regional'       AS type
    UNION
    SELECT 'SC_INF_Staffing' AS group_cn,
           'Department'      AS type
    UNION
    SELECT 'SC_OVA_EXEC' AS group_cn,
           'Exec'        AS type
    UNION
    SELECT 'SC_PDCO_FIN' AS group_cn,
           'Department'  AS type
    UNION
    SELECT 'SC_SIG_4111_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4111_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4131_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4131_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4141_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4141_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4151_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4151_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4161_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4161_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4171_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4171_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4181_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4181_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4211_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4211_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4221_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4221_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4251_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4251_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4271_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4271_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4281_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_4281_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6111_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6111_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6121_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6121_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6131_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6131_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6141_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6141_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6151_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6151_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6161_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6161_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6181_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6181_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6191_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6191_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6211_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6211_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6221_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6221_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6231_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6231_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6241_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6241_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6251_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6251_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6261_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6261_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6281_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6281_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6301_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6301_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6311_C' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_6311_E' AS group_cn,
           'Building'      AS type
    UNION
    SELECT 'SC_SIG_EXEC' AS group_cn,
           'Exec'        AS type
    UNION
    SELECT 'SC_SIG_FIN' AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_SIG_HH_ADMIN' AS group_cn,
           'Department'      AS type
    UNION
    SELECT 'SC_SIG_HH_CM' AS group_cn,
           'Department'   AS type
    UNION
    SELECT 'SC_SIG_HH_DPS' AS group_cn,
           'Department'    AS type
    UNION
    SELECT 'SC_SIG_HH_RDO' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_SIG_HO_ADMIN' AS group_cn,
           'Department'      AS type
    UNION
    SELECT 'SC_SIG_HO_DPS' AS group_cn,
           'Department'    AS type
    UNION
    SELECT 'SC_SIG_HO_RDO' AS group_cn,
           'Regional'      AS type
    UNION
    SELECT 'SC_SIG_HR'  AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_SIG_OPS' AS group_cn,
           'Department' AS type
    UNION
    SELECT 'SC_SIG_SALES' AS group_cn,
           'Department'   AS type

Columns

View Definition

Possibly Referenced Tables/Views