5 queries found for "Meter Configuration"

Get Meter Installed at SP

SELECT MC.MTR_ID MTR
FROM CI_SP_MTR_HIST SPMH, CI_MTR_CONFIG MC
WHERE
  SPMH.SP_ID = 'INSERT_SERVICE_POINT_ID'
  AND SPMH.REMOVAL_MR_ID = ' '
  AND SPMH.MTR_CONFIG_ID = MC.MTR_CONFIG_ID
  AND MC.EFF_DTTM <= 'INSERT_METER_CONFIG_EFFECTIVE_DATE'

uploaded by Nuno Rodrigues

Get latest SP where Meter is installed

SELECT CV.SP_ID SPID
FROM
  CI_MTR_CONFIG MC,
  CI_CFG_SPMR_VW CV
WHERE
  MC.MTR_ID = 'INSERT_METER_ID'
  AND CV.MTR_CONFIG_ID = MC.MTR_CONFIG_ID
ORDER BY CV.INSTALL_DTTM DESC, CV.SP_MTR_HIST_ID ASC

uploaded by Nuno Rodrigues

Get SP from Meter or Mtr Cfg or SP/Mtr Hist installed on SP

SELECT 
HIST.*
FROM 
CI_MTR_CONFIG CFG,
CI_SP_MTR_HIST HIST
-- choose one and remove the [ ]
[ WHERE CFG.MTR_ID = 'INSERT_METER_ID']
[ WHERE CFG.MTR_CONFIG_ID = 'INSERT_METER_CONFIG_ID']
[ WHERE HIST.SP_MTR_HIST_ID = 'INSERT_METER_HISTORY_ID']
AND CFG.MTR_CONFIG_ID = HIST.MTR_CONFIG_ID
AND HIST.REMOVAL_MR_ID = ' '
AND HIST.REMOVAL_DTTM IS NULL

uploaded by Nuno Rodrigues

Determine if SA is Linked to Any Metered SP

SELECT
  COUNT(*)  AS MSP_COUNT
FROM 
  CI_SA_SP SASP,
  CI_SP SP,
  CI_SP_TYPE SPTY,
  CI_SP_MTR_HIST SPM,
  CI_MTR_CONFIG CFG
WHERE
    SASP.SA_ID = 'INSERT_SA_ID'
AND SP.SP_ID = SASP.SP_ID
AND SPTY.SP_TYPE_CD = SP.SP_TYPE_CD
AND SPTY.SP_SUBTYPE_FLG = 'M'
AND SPM.SP_ID = SP.SP_ID
AND (SPM.REMOVAL_DTTM IS NULL OR SPM.REMOVAL_DTTM > 'INSERT_MINIMUM_REMOVAL_DATE')
AND CFG.MTR_CONFIG_ID = SPM.MTR_CONFIG_ID
AND NOT EXISTS (SELECT 'X'
                  FROM CI_REG REG
                 WHERE REG.MTR_ID = CFG.MTR_ID
                   AND REG.EFF_DTTM = CFG.EFF_DTTM
                   AND REG.INTV_REG_TYPE_CD != ' ')
                   

uploaded by Nuno Rodrigues

Get Meter Information at SP

SELECT
  CFG.MTR_ID MTR, 
  MTR.BADGE_NBR BADGE, 
  CFG.MTR_CONFIG_TY_CD  CONFIGTYPE
FROM
  CI_SP_MTR_HIST HIST, 
  CI_MTR_CONFIG CFG, 
  CI_MTR MTR
WHERE
  HIST.SP_ID = 'INSERT_SERVICE_POINT_ID'
AND(HIST.REMOVAL_DTTM IS NULL
  OR HIST.REMOVAL_DTTM >= 'INSERT_MINIMUM_REMOVAL_DATE')
  AND CFG.MTR_CONFIG_ID = HIST.MTR_CONFIG_ID
  AND MTR.MTR_ID = CFG.MTR_ID
  

uploaded by Nuno Rodrigues