Skip to main content

Sort order changes for some Claim ID & Filing ID columns

As part of ongoing work to unblock critical platform upgrades, we've changed the data type of several Claim ID and Filing ID columns. The only visible effect is that some dashboard lists may now sort slightly differently.

Affected Columns:

  • Claim ID (e.g. SCE2016_Q1_0004770)

  • Filing ID (e.g. PGE-2025Q1-PGE_Pub_009-0256)

  • Program ID (e.g. SCE-13-SW-002G)

  • Site ID (e.g. SDGE3226-11202730)

  • CE Input ID (e.g. BAY-2024-EE-CZ2)

What to expect:

  • When IDs contain hyphens or underscores, some lists may sort differently. The new sort order places hyphens and underscores before alphanumerics. Previously, the sort order ignored hyphens and underscores.

  • The sort order remains case-insensitive (unchanged).
    E.g.: both of these sort orders on Program ID are valid:
    SW_ETP_Gas
    SW_ETP_Gas
    SW_ETP_GAS

    SW_ETP_Gas
    SW_ETP_GAS
    SW_ETP_Gas

New