TRX_OPT_BR_TEO3(SQL Table) |
Index Back |
---|---|
CCU TEO temp tableCCU temporary table for TRX_OPT_BARRIER |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | TREAS_HEADER_ID | Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
4 | TRANSACTION_LINE | Number(3,0) | SMALLINT NOT NULL | The separate and distinct base instrument type components of a given deal transaction. |
5 | START_DT | Date(10) | DATE | Start Date |
6 | 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 |
7 | END_DT | Date(10) | DATE | End Date |
8 | 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 |
9 | OPT_BARRIER_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | The rate or level at which the option is invoked. |
10 | 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 |
11 | OPT_BR_BREACH_DT | Date(10) | DATE | The option barrier term breach date. |
12 | 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 |
13 | OPT_BR_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The option barrier rebate amount. |
14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
15 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |