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

Class /event/notification/balance/expiry

This event is generated whenever the sub balance is nearing expiry and is sent via PCM_OP_BAL_NOTIFY_BALANCE_EXPIRY opcode . The event notification framework will trigger necessary functions based on the type of the notification event.

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
string PIN_FLD_NAME
poid PIN_FLD_USERID
poid PIN_FLD_SESSION_OBJ
poid PIN_FLD_ACCOUNT_OBJ
string PIN_FLD_PROGRAM_NAME
timestamp PIN_FLD_END_T
timestamp PIN_FLD_START_T
string PIN_FLD_SYS_DESCR
array PIN_FLD_BALANCES
poid
poid
string
string
int
timestamp
decimal
int


Field Details

string PIN_FLD_NAME

User-defined name of the event.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 0 bytes

Links

poid PIN_FLD_USERID

The unique ID of the user who is running the program that started the event.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_SESSION_OBJ

Link to the event object (/event/session) that represents the session within which this event occurred.

Notes

  • Can be specified on object creation
  • Cannot be modified

Links

poid PIN_FLD_ACCOUNT_OBJ

Link to the /account object which owns this balance group

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_PROGRAM_NAME

The name of the program that generated the event

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 0 bytes

Links

timestamp PIN_FLD_END_T

The time when event ended

Notes

  • Required on object creation
  • Can be modified

Links

timestamp PIN_FLD_START_T

The time when the event started

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_SYS_DESCR

System generated description. This describes the event programmatically

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 0 bytes

Links

array PIN_FLD_BALANCES

Array that contains information about the expiring balances

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_BAL_GRP_OBJ

Link to the /balance_group object, to which the expiry notification is being sent

Notes

Links

poid PIN_FLD_SERVICE_OBJ

Link to the /service object, to which the expiry notification is being sent

Notes

Links

string PIN_FLD_RESOURCE_NAME

BEID name which is expiring

Notes

Links

string PIN_FLD_RESOURCE_SYMBOL

BEID symbol which is expiring

Notes

Links

int PIN_FLD_RESOURCE_ID

Resource name which is expiring

Notes

Links

timestamp PIN_FLD_VALID_TO

The end date of this validity based balance, 0 indicate infinity

Notes

Links

decimal PIN_FLD_CURRENT_BALANCE_QUANTITY

Current sub balance

Notes

Links

int PIN_FLD_REC_ID

RecId for sub-balance which is expiring

Notes

Links



SQL Mapping

Links


Type Field Name Table Column Name
derived-class /event/notification/balance/expiry
string PIN_FLD_NAME
poid PIN_FLD_USERID
poid PIN_FLD_SESSION_OBJ
poid PIN_FLD_ACCOUNT_OBJ
string PIN_FLD_PROGRAM_NAME
timestamp PIN_FLD_END_T
timestamp PIN_FLD_START_T
string PIN_FLD_SYS_DESCR
array PIN_FLD_BALANCES
poid
PIN_FLD_BAL_GRP_OBJ
poid
PIN_FLD_SERVICE_OBJ
string
PIN_FLD_RESOURCE_NAME
string
PIN_FLD_RESOURCE_SYMBOL
int
PIN_FLD_RESOURCE_ID
timestamp
PIN_FLD_VALID_TO
decimal
PIN_FLD_CURRENT_BALANCE_QUANTITY
int
PIN_FLD_REC_ID
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