Copyright © 2025, Oracle and/or its affiliates.
Field Index SQL Mapping

Class /event/notification/threshold_below

This notification event will be generated when thresholds are breached downwards for the following scenarios: (1) if breached while updating the credit profile, the reason type will be set to PIN_MONITOR_BAL_ALERT_REASON_RESET_DOWN, (2) if breached while applying balance impacts, the reason type will be set to PIN_MONITOR_BAL_ALERT_REASON_BREACH_DOWN.

Notes

  • This object can be read by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be modified by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be created by anyone.

Links



Field Index

Type Field Name
substruct PIN_FLD_INHERITED_INFO
substruct
array
int
enum
enum


Field Details

substruct PIN_FLD_INHERITED_INFO

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_BALANCES

Balances sub-structure.

Notes

Links

array PIN_FLD_THRESHOLDS

List of thresholds breached by this event. It will include all limit, floor, and percentage/fixed threshold breaches.

Notes

Links

int PIN_FLD_CREDIT_THRESHOLDS

The threshold that was breached by this event. This amount could be for a percent or fixed amount, as well as for the floor or limit.

Notes

  • Required on object creation
  • Can be modified

Links

enum PIN_FLD_ALERT_TYPE

Alert type for this threshold. It can be (1) Limit, (2) Percent Threshold, (3) Floor, or (4) Fixed Threshold.

Notes

  • Required on object creation
  • Can be modified

Links

enum PIN_FLD_REASON

Reason for this breach. It can be (0x01) Upward Breach, (0x02) Downward Breach, (0x04) Upward Reset, (0x08) Downward Reset, or (0x10) Indeterminate.

Notes

  • Required on object creation
  • Can be modified

Links


SQL Mapping

Links


Type Field Name Table Column Name
derived-class /event/notification/threshold_below
substruct PIN_FLD_INHERITED_INFO
substruct
PIN_FLD_BALANCES
int
PIN_FLD_RESOURCE_ID
decimal
PIN_FLD_AMOUNT
decimal
PIN_FLD_CURRENT_BAL
poid
PIN_FLD_BAL_GRP_OBJ
decimal
PIN_FLD_PERCENT
poid
PIN_FLD_SOURCE_OBJ
enum
PIN_FLD_ALERT_TYPE
string
PIN_FLD_MONITOR_TYPE
enum
PIN_FLD_REASON
decimal
PIN_FLD_CREDIT_FLOOR
decimal
PIN_FLD_CREDIT_LIMIT
int
PIN_FLD_CREDIT_THRESHOLDS
string
PIN_FLD_CREDIT_THRESHOLDS_FIXED
string
PIN_FLD_EVENT_TYPE
string
PIN_FLD_CALLING_NUMBER
string
PIN_FLD_CALLED_NUMBER
array
PIN_FLD_THRESHOLDS
int
PIN_FLD_CREDIT_THRESHOLDS
enum
PIN_FLD_ALERT_TYPE
enum
PIN_FLD_REASON
Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size.

Field Index This Class