TRX_OPT_BR_TEO2

(SQL Table)
Index Back

CCU TEO temp table

CCU 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