ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
ECPRIEVTCDECACTIONCDTREAS_HEADER_IDMTM_FUNC_SEQJPM_AGGREGATE_IDJPM_COMPOSITE_IDB=Buy
S=Sell
C=Call
P=Put
Default Value: 32767
TR_FOUR15_OB_EC(SQL Table) |
Index Back |
|---|---|
JPM 4-15 Filexp OB Staging TblJPM Filexport Staging table for FourFifteen |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ECTRANSID |
Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
| 2 | ECQUEUEINSTANCE |
Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 3 | ECTRANSINOUTSW |
Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound |
| 4 | ECPRIEVTCD |
Character(6) | VARCHAR2(6) NOT NULL | Electronic Commerce Primary Event Codes (or Purpose codes) - specify the status of the transaction. New, Cancellation, duplicate, etc. Every transaction has a primary code assigned to it. Used in EDI Manager. |
| 5 | ECACTIONCD |
Character(3) | VARCHAR2(3) NOT NULL | EC Action Code |
| 6 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
| 7 | MTM_FUNC_SEQ |
Number(2,0) | SMALLINT NOT NULL | A sequential value utilized in order to determine the calling or submission sequence of a series of a |
| 8 | JPM_AGGREGATE_ID |
Number(5,0) | INTEGER NOT NULL | The manner in which aggregate instruments are identified for purposes of analytics processing in t |
| 9 | JPM_COMPOSITE_ID |
Number(5,0) | INTEGER NOT NULL | The manner in which composite instruments are identified for purposes of analytics processing in t |
| 10 | JPM_TYPE | Character(15) | VARCHAR2(15) NOT NULL | "A given deal transaction's associated instrument type |
| 11 | JPM_CCY | Character(3) | VARCHAR2(3) NOT NULL | "A given deal transaction's currency |
| 12 | JPM_RATING | Character(6) | VARCHAR2(6) NOT NULL | "A given deal transaction's counterparty or issuer rating |
| 13 | JPM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | "A given deal transaction's counterparty or issuer group |
| 14 | JPM_CURVE | Character(10) | VARCHAR2(10) NOT NULL | "A given deal transaction's specified and relevant rate yield curve |
| 15 | JPM_FX_HEDGED | Character(8) | VARCHAR2(8) NOT NULL | A value indicating whether a given FX deal transaction has been intrinsically hedged by the treasur |
| 16 | JPM_NAME | Character(150) | VARCHAR2(150) NOT NULL | "A given deal transaction's associated instrument description |
| 17 | JPM_HOLDING | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | "A given deal transaction's nominal holding amount in a transaction currency |
| 18 | JPM_COUPON | Number(16,8) | DECIMAL(15,8) NOT NULL | "A given deal transaction's coupon rate |
| 19 | JPM_FREQUENCY | Number(3,0) | SMALLINT NOT NULL | "A given deal transaction's coupon frequency |
| 20 | JPM_MATURITY | Character(20) | VARCHAR2(20) NOT NULL | "A given deal transaction's maturity date |
| 21 | JPM_ISSUE_DT | Date(10) | DATE | "A given deal transaction's issuance date |
| 22 | JPM_1ST_COUPON | Date(10) | DATE | "The first in a series of deal transaction coupon dates |
| 23 | JPM_PRICE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | "A given deal transaction's nominal |
| 24 | JPM_ACCRUED | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | "A given deal transaction's accrued interest |
| 25 | JPM_YIELD | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A given deal transaction's yield |
| 26 | JPM_DURATION | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A given deal transaction's duration |
| 27 | JPM_CONVEXITY | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A given deal transaction's convexity |
| 28 | JPM_FULL_STUB | Number(2,0) | SMALLINT NOT NULL | "A value indicating how 'stub' |
| 29 | JPM_BUY_OR_SELL | Character(1) | VARCHAR2(1) NOT NULL |
The manner in which a given option instrument is distinguished in terms of its exercise rights for p
B=Buy S=Sell |
| 30 | JPM_CALL_OR_PUT | Character(1) | VARCHAR2(1) NOT NULL |
The manner in which a given option instrument is distinguished as either a put or a call option for
C=Call P=Put |
| 31 | JPM_CCY2 | Character(3) | VARCHAR2(3) NOT NULL | "A given deal transaction's currency |
| 32 | JPM_STRIKE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A given deal transaction's option strike rate |
| 33 | JPM_EXPIRY | Date(10) | DATE | "A given deal transaction's option expiration date |
| 34 | JPM_PREMIUM | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | "A given deal transaction's option premium price |
| 35 | JPM_DELTA | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A given deal transaction's option curve delta |
| 36 | JPM_GAMMA | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A given deal transaction's gamma factor |
| 37 | JPM_VOLATILITY | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A given deal transaction's price volatility factor |
| 38 | JPM_1DAY_VOL | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A one day yield volatility factor |
| 39 | JPM_6M_VOL | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A six month yield volatility factor |
| 40 | JPM_12M_VOL | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A twelve month yield volatility factor |
| 41 | JPM_18M_VOL | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "An eighteen month yield volatility factor |
| 42 | JPM_2YR_VOL | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A two year yield volatility factor |
| 43 | JPM_5YR_VOL | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A five year yield volatility factor |
| 44 | JPM_10YR_VOL | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A ten year yield volatility factor |
| 45 | JPM_20YR_VOL | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A twenty year yield volatility factor |
| 46 | JPM_30YR_VOL | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "A thirty year yield volatility factor |
| 47 | JPM_FIX_OR_FLOAT | Character(8) | VARCHAR2(8) NOT NULL | A value indicating whether a given leg of a deal transaction is subject to a fixed or variable i |
| 48 | JPM_COUPON_CCY | Character(3) | VARCHAR2(3) NOT NULL | "A given deal transaction's coupon currency |
| 49 | JPM_COUPN_MATURITY | Number(3,0) | SMALLINT NOT NULL | "A given deal transaction's coupon maturity |
| 50 | JPM_SPREAD | Signed Number(13,6) | DECIMAL(11,6) NOT NULL | Represents the reset rate spread over the LIBOR index for a given deal transaction; the value is passed by the |
| 51 | JPM_MAXCOMPOSIT_ID | Number(5,0) | INTEGER NOT NULL |
Represents the largest possible number to be utilized as a composite ID for a given deal transac
Default Value: 32767 |
| 52 | JPM_NOM_IN_LOCAL | Character(8) | VARCHAR2(8) NOT NULL | A value indicating whether a given deal transaction is stated in a transaction or base currency; t |