TRX_OPT_BARRIER

(SQL Table)
Index Back

Treasury Deals Option Barriers

Treasury Deals Option Barriers. If the underlying rate goes through one of the barriers, then the option will: ~ and IN: Become active ~ and Out: Be deactivated

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
3 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.
4 START_DT Date(10) DATE Start Date
5 OPT_BARRIER_NBR Number(1,0) SMALLINT NOT NULL A sequential number that describes the number of barrier terms currently in place for a given option
6 END_DT Date(10) DATE End Date
7 OPT_BARRIER_TYPE Character(2) VARCHAR2(2) NOT NULL The option barrier type.
DI=Down and In
DO=Down and Out
UI=Up and In
UO=Up and Out
8 OPT_BARRIER_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL The rate or level at which the option is invoked.
9 OPT_BR_BREACHED Character(1) VARCHAR2(1) NOT NULL Allows a user to indicate whether an option barrier term has been breached.

Y/N Table Edit

Default Value: N

10 OPT_BR_BREACH_DT Date(10) DATE The option barrier term breach date.
11 OPT_BR_REBATE_WHEN Character(1) VARCHAR2(1) NOT NULL Represents a series of options related to when a barrier rebate should be paid when the barrier
B=At Barrier Breach
E=At Option Expiry
N=No Rebate Paid

Default Value: N

12 OPT_BR_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The option barrier rebate amount.
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL