OSS_DP_CANDIDATES_GT
Global temporary table to stage Selfservice Outcomes decision packet candidates within a session.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| STAGE_ROW_ID | NUMBER | 18 | Yes | Session-scoped surrogate row id for the staged packet candidate | |
| EXISTING_DECISION_PACKET_ID | NUMBER | 18 | Existing packet id resolved by the packet key, when present | ||
| RESOLVED_DECISION_PACKET_ID | NUMBER | 18 | Packet id chosen after insert or update by the Java stage | ||
| CUSTOMER_ID | NUMBER | 18 | Yes | Customer identifier represented by the staged packet candidate | |
| CUSTOMER_NAME | VARCHAR2 | 240 | Customer name for display and traceability | ||
| REVIEW_GRAIN | VARCHAR2 | 30 | Yes | Review grain of the staged packet candidate | |
| REVIEW_GRAIN_ID | NUMBER | 18 | Yes | Identifier for the selected review grain | |
| EVALUATION_PERIOD | VARCHAR2 | 7 | Yes | Evaluation window in YYYY-MM format | |
| BILLING_ACCOUNT_ID | NUMBER | 18 | Billing account identifier when relevant to the review scope | ||
| BILLING_ACCOUNT_NAME | VARCHAR2 | 240 | Billing account name when relevant to the review scope | ||
| SUBSCRIPTION_ID | NUMBER | 18 | Subscription contract identifier when the review grain is contract level | ||
| SUBSCRIPTIONS_COUNT | NUMBER | 9 | Count of subscriptions represented in the packet review scope | ||
| COVERAGE_COUNT | NUMBER | 9 | Count of coverage lines represented in the packet review scope | ||
| SUBSCRIPTION_PRODUCT_COUNT | NUMBER | 9 | Count of subscription products represented in the packet review scope | ||
| COVERED_ASSET_COUNT | NUMBER | 9 | Count of covered assets represented in the packet review scope | ||
| PARTY_SITE_COUNT | NUMBER | 9 | Count of party sites represented in the packet review scope | ||
| TOTAL_CONTRACT_VALUE | NUMBER | 18 | Sum of contract value at the packet review grain | ||
| TOTAL_USAGE_CHARGE | NUMBER | 18 | Sum of usage charge value at the packet review grain | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency for commercial amount fields | ||
| SOURCE_RAW_SIGNAL_COUNT | NUMBER | 9 | Count of source raw-signal rows represented in the candidate packet | ||
| SOURCE_FAMILY_FACT_COUNT | NUMBER | 9 | Count of source signal-family facts represented in the candidate packet | ||
| BILLING_RELATED_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the candidate packet for ORA_BILLING_RELATED | ||
| BILLING_REL_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_BILLING_RELATED | |||
| USAGE_UNDERUTIL_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the candidate packet for ORA_USAGE_UNDERUTILIZATION | ||
| USAGE_UNDERUTIL_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_USAGE_UNDERUTILIZATION | |||
| USAGE_OVERUTIL_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the candidate packet for ORA_USAGE_OVERUTILIZATION | ||
| USAGE_OVERUTIL_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_USAGE_OVERUTILIZATION | |||
| SERVICE_HEALTH_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the candidate packet for ORA_SERVICE_HEALTH | ||
| SERVICE_HEALTH_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_SERVICE_HEALTH | |||
| RENEWAL_RELATED_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the candidate packet for ORA_RENEWAL_RELATED | ||
| RENEWAL_REL_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_RENEWAL_RELATED | |||
| ACTIVATION_GAP_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the candidate packet for ORA_ACTIVATION_GAP | ||
| ACTIVATION_GAP_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_ACTIVATION_GAP | |||
| ACCOUNT_TERRITORY_ASSIGNED_YN | VARCHAR2 | 1 | Yes | Whether seller-facing assigned territory exists | |
| SELF_SERVICE_PROVISIONED_YN | VARCHAR2 | 1 | Yes | Whether self-service capability is provisioned for the review scope | |
| LLM_REVIEW_ELIGIBLE_YN | VARCHAR2 | 1 | Yes | Whether the packet is eligible for downstream LLM review | |
| LLM_REV_SUPPRESS_REASON_CODE | VARCHAR2 | 60 | Reason code when the candidate packet is suppressed from LLM review | ||
| BILLING_BLOCKER_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_BILLING_BLOCKER | ||
| BILLING_BLOCKER_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_BILLING_BLOCKER | |||
| BILLING_BLOCKER_IMPACT_AMT | NUMBER | Value impact amount for ORA_BILLING_BLOCKER | |||
| BILLING_VARIANCE_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_BILLING_VARIANCE | ||
| BILLING_VARIANCE_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_BILLING_VARIANCE | |||
| BILLING_VARIANCE_IMPACT_AMT | NUMBER | Value impact amount for ORA_BILLING_VARIANCE | |||
| COLLECTION_RISK_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_COLLECTION_RISK | ||
| COLLECTION_RISK_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_COLLECTION_RISK | |||
| COLLECTION_RISK_IMPACT_AMT | NUMBER | Value impact amount for ORA_COLLECTION_RISK | |||
| USAGE_UNDERUSE_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_USAGE_UNDERUSE | ||
| USAGE_UNDERUSE_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_USAGE_UNDERUSE | |||
| USAGE_UNDERUSE_IMPACT_AMT | NUMBER | Value impact amount for ORA_USAGE_UNDERUSE | |||
| COMM_UNDERREALIZATION_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_COMM_UNDERREALIZATION | ||
| COMM_UNDERREAL_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_COMM_UNDERREALIZATION | |||
| COMM_UNDERREAL_IMPACT_AMT | NUMBER | Value impact amount for ORA_COMM_UNDERREALIZATION | |||
| USAGE_OVERUSE_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_USAGE_OVERUSE | ||
| USAGE_OVERUSE_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_USAGE_OVERUSE | |||
| USAGE_OVERUSE_IMPACT_AMT | NUMBER | Value impact amount for ORA_USAGE_OVERUSE | |||
| COMM_OVERRUN_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_COMM_OVERRUN | ||
| COMM_OVERRUN_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_COMM_OVERRUN | |||
| COMM_OVERRUN_IMPACT_AMT | NUMBER | Value impact amount for ORA_COMM_OVERRUN | |||
| SERVICE_EXECUTION_GAP_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_SERVICE_EXECUTION_GAP | ||
| SERVICE_EXEC_GAP_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_SERVICE_EXECUTION_GAP | |||
| SERVICE_EXEC_GAP_IMPACT_AMT | NUMBER | Value impact amount for ORA_SERVICE_EXECUTION_GAP | |||
| SERVICE_FAILURE_RISK_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_SERVICE_FAILURE_RISK | ||
| SERVICE_FAIL_RISK_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_SERVICE_FAILURE_RISK | |||
| SERVICE_FAIL_RISK_IMPACT_AMT | NUMBER | Value impact amount for ORA_SERVICE_FAILURE_RISK | |||
| RENEWAL_RISK_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_RENEWAL_RISK | ||
| RENEWAL_RISK_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_RENEWAL_RISK | |||
| RENEWAL_RISK_IMPACT_AMT | NUMBER | Value impact amount for ORA_RENEWAL_RISK | |||
| RENEWAL_OPPORTUNITY_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_RENEWAL_OPPORTUNITY | ||
| RENEWAL_OPPTY_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_RENEWAL_OPPORTUNITY | |||
| RENEWAL_OPPTY_IMPACT_AMT | NUMBER | Value impact amount for ORA_RENEWAL_OPPORTUNITY | |||
| ACTIVATION_BLOCKER_COUNT | NUMBER | 9 | Distinct subscription-product count for ORA_ACTIVATION_BLOCKER | ||
| ACTIVATION_BLOCKER_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the candidate packet for ORA_ACTIVATION_BLOCKER | |||
| ACTIVATION_BLOCKER_IMPACT_AMT | NUMBER | Value impact amount for ORA_ACTIVATION_BLOCKER | |||
| STATUS | VARCHAR2 | 30 | Yes | Staging lifecycle status for the packet candidate | |
| ERROR_MESSAGE | VARCHAR2 | 4000 | Error message captured for staging or packet-resolution diagnostics | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| OSS_DP_CANDIDATES_GT_N1 | Non Unique | REQUEST_ID, STAGE_ROW_ID |
| OSS_DP_CANDIDATES_GT_N2 | Non Unique | CUSTOMER_ID, REVIEW_GRAIN, REVIEW_GRAIN_ID, EVALUATION_PERIOD, CURRENCY_CODE |