TRX_OPT_BARRIER(SQL Table) |
Index Back |
|---|---|
Treasury Deals Option BarriersTreasury 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 |