SIM_STATUS_HISTORY

SIM status change history and associated SIM attributes.

SIM_STATUS_HISTORY contains SIM lifecycle status changes and related SIM attributes. Use it to review status transitions over time.

Public Contract

• Rows are limited to the current SORACOM Query request context.

Data Freshness

Updated daily.

Columns

Column	Type	Description
IMSI	TEXT	IMSI associated with the SIM.
OPERATOR_ID	TEXT	Operator identifier associated with the row.
APPLY_DATETIME	TIMESTAMP_NTZ	When the status change was applied.
STATUS	TEXT	SIM lifecycle status after the change.
SIM_ID	TEXT	SIM identifier.
SIM_ID_SRN	TEXT	SORACOM Resource Name for the SIM identifier.
SPEED_CLASS	TEXT	Speed class of the subscription.
SUBSCRIPTION	TEXT	Subscription plan code.
PRIMARY_IMSI	TEXT	Primary IMSI for multi-IMSI SIMs.
IS_PRIMARY	NUMBER	Whether the row represents the primary IMSI.
BUNDLES	ARRAY	Bundle codes associated with the SIM.
GROUP_ID	TEXT	Group identifier associated with the SIM.
SRN	TEXT	SORACOM Resource Name for the SIM.

JSON / VARIANT Fields

BUNDLES is an array of bundle codes associated with the SIM.

Example:

SELECT
  SIM_ID,
  bundle.value::STRING AS bundle_code
FROM SIM_STATUS_HISTORY,
  LATERAL FLATTEN(INPUT => BUNDLES) bundle;

Common Queries

Recent status changes:

SELECT
  SIM_ID,
  IMSI,
  APPLY_DATETIME,
  STATUS
FROM SIM_STATUS_HISTORY
ORDER BY APPLY_DATETIME DESC
LIMIT 100;

Status history for a SIM:

SELECT
  APPLY_DATETIME,
  STATUS,
  SPEED_CLASS,
  SUBSCRIPTION
FROM SIM_STATUS_HISTORY
WHERE SIM_ID = '8981100000000000000'
ORDER BY APPLY_DATETIME;