Results for “phase_indicator”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XNP_SV_STATUS_TYPES_B is the base (language-independent) definition table for subscription version status types within the Oracle E-Business Suite Number Portability module (XNP). It stores the master list of status codes that describe the lifecycle state of a subscription version — the database record tracking an individual porting request as it moves between carriers. Administrators and the porting engine consult this table to resolve a STATUS_TYPE_CODE into its behavioral attributes, such as which phase of the porting process the status belongs to, whether it is currently active, and whether it represents an initial status.

In a Data Vault modeling sense, the table is heuristically classified as hub-leaning: its primary key STATUS_TYPE_CODE acts as a stable business key that is referenced by multiple dependent tables, which is characteristic of a hub entity. The presence of descriptive attributes (PHASE_INDICATOR, ACTIVE_FLAG, INITIAL_FLAG) alongside the key suggests a hybrid role, but for modeling purposes it is best treated as a reference hub surrounded by transactional satellites such as XNP_SV_SOA. This interpretation is a suggestion; actual warehouse design should follow site standards.

Key Information Stored

The object was documented with 13 physical columns in the ETRM 12.2.2 schema. The most important columns are:

• STATUS_TYPE_CODE — the primary key (enforced by XNP_SV_STATUS_TYPES_B_PK) and the primary business-key candidate; also appears in the unique index XNP_SV_STATUS_TYPES_B_U1 in combination with ZD_EDITION_NAME.
• PHASE_INDICATOR — classifies the status by the phase of the subscription version lifecycle it belongs to.
• ACTIVE_FLAG — indicates whether the status type is currently enabled for use.
• INITIAL_FLAG — marks statuses that can be assigned when a subscription version is first created.
• INITIAL_FLAG_ENFORCE_SEQ — controls sequencing behavior when validating the initial flag assignment.
• DISPLAY_SEQUENCE — governs the ordering of statuses in user interface lists and lookups.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org/security-group data segregation.
• ZD_EDITION_NAME — editioning column used by EBS Online Patching in 12.2.x; it participates in the unique index XNP_SV_STATUS_TYPES_B_U1.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking who created and last modified each row and when.

The table has no separate surrogate key beyond STATUS_TYPE_CODE; that column serves as the natural business identifier rather than an artificial sequence.

Common Use Cases and Queries

Typical scenarios include populating status list-of-values, validating inbound porting status transitions, and reporting porting throughput by phase. A common lookup resolves active statuses in display order:

SELECT status_type_code, phase_indicator, active_flag, display_sequence
FROM xnp.xnp_sv_status_types_b
WHERE active_flag = 'Y'
ORDER BY display_sequence;

To find valid starting statuses for a new subscription version:

SELECT status_type_code
FROM xnp.xnp_sv_status_types_b
WHERE initial_flag = 'Y' AND active_flag = 'Y';

Because descriptive text is held in the translation table, reporting queries should join XNP_SV_STATUS_TYPES_TL to retrieve the user-facing status name, filtered by the appropriate language. The status definition also drives workflow logic: the PHASE_INDICATOR and INITIAL_FLAG_ENFORCE_SEQ columns influence how the porting engine sequences transitions recorded against XNP_SV_SOA.

Related Objects

• XNP_SV_STATUS_TYPES_TL — the translation table; joined on STATUS_TYPE_CODE to obtain the language-specific status description.
• XNP_SV_SOA — references this table twice, via XNP_SV_SOA.STATUS_TYPE_CODE and XNP_SV_SOA.PREV_STATUS_TYPE_CODE, capturing the current and previous status of each subscription version.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID, providing the security group governing row visibility.
• XNP_SV_STATUS_TYPES_B_PK — the primary key constraint on STATUS_TYPE_CODE.
• XNP_SV_STATUS_TYPES_B_U1 — the unique index on STATUS_TYPE_CODE and ZD_EDITION_NAME, supporting the 12.2 editioning model.