OSS_DECISION_PACKETS
OSS_DECISION_PACKETS is the runtime deterministic review envelope used before LLM-based outcome generation.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OSS_DECISION_PACKETS_PK |
DECISION_PACKET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DECISION_PACKET_ID | NUMBER | 18 | Yes | Primary key for the decision packet | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CUSTOMER_ID | NUMBER | 18 | Yes | Customer identifier; always present | |
| CUSTOMER_NAME | VARCHAR2 | 240 | Customer name for display and traceability | ||
| REVIEW_GRAIN | VARCHAR2 | 30 | Yes | Review grain of the packet | |
| 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 packet | ||
| SOURCE_FAMILY_FACT_COUNT | NUMBER | 9 | Count of source signal-family facts linked into the packet | ||
| BILLING_RELATED_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the packet for ORA_BILLING_RELATED | ||
| BILLING_REL_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the packet for ORA_BILLING_RELATED | |||
| USAGE_UNDERUTIL_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the packet for ORA_USAGE_UNDERUTILIZATION | ||
| USAGE_UNDERUTIL_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the packet for ORA_USAGE_UNDERUTILIZATION | |||
| USAGE_OVERUTIL_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the packet for ORA_USAGE_OVERUTILIZATION | ||
| USAGE_OVERUTIL_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the packet for ORA_USAGE_OVERUTILIZATION | |||
| SERVICE_HEALTH_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the packet for ORA_SERVICE_HEALTH | ||
| SERVICE_HEALTH_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the packet for ORA_SERVICE_HEALTH | |||
| RENEWAL_RELATED_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the packet for ORA_RENEWAL_RELATED | ||
| RENEWAL_REL_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the packet for ORA_RENEWAL_RELATED | |||
| ACTIVATION_GAP_SIGNAL_COUNT | NUMBER | 9 | Count of deduped raw signals in the packet for ORA_ACTIVATION_GAP | ||
| ACTIVATION_GAP_SIG_UPD_DATE | TIMESTAMP | Latest contributing update timestamp in the 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 access is provisioned | |
| LLM_REVIEW_ELIGIBLE_YN | VARCHAR2 | 1 | Yes | Deterministic flag indicating whether LLM review should run | |
| LLM_REV_SUPPRESS_REASON_CODE | VARCHAR2 | 60 | Reason code when the 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 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 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 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 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 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 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 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 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 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 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 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 packet for ORA_ACTIVATION_BLOCKER | |||
| ACTIVATION_BLOCKER_IMPACT_AMT | NUMBER | Value impact amount for ORA_ACTIVATION_BLOCKER | |||
| STATUS | VARCHAR2 | 30 | Yes | Decision-packet lifecycle status | |
| PACKET_BUILT_ON | TIMESTAMP | Yes | Timestamp when the packet was built or refreshed | ||
| 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. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OSS_DECISION_PACKETS_PK | Unique | Default | DECISION_PACKET_ID |
| OSS_DECISION_PACKETS_U1 | Unique | Default | CUSTOMER_ID, REVIEW_GRAIN, REVIEW_GRAIN_ID, EVALUATION_PERIOD, CURRENCY_CODE |
| OSS_DECISION_PACKETS_N1 | Non Unique | Default | LLM_REVIEW_ELIGIBLE_YN, REVIEW_GRAIN, EVALUATION_PERIOD |
| OSS_DECISION_PACKETS_N2 | Non Unique | Default | CUSTOMER_ID, EVALUATION_PERIOD |
| OSS_DECISION_PACKETS_N3 | Non Unique | Default | BILLING_ACCOUNT_ID, EVALUATION_PERIOD |
| OSS_DECISION_PACKETS_N4 | Non Unique | Default | SUBSCRIPTION_ID, EVALUATION_PERIOD |
| OSS_DECISION_PACKETS_N5 | Non Unique | Default | REQUEST_ID |