TRX_HDR_TR_TEO1(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for TRX_HEADER_TR |
| # | 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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW |
| 3 | TREAS_HEADER_ID | Character(12) | VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Default Value: NEXT Prompt Table: TRX_HEADER_TR |
| 4 | INSTRUMENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Instrument type
Prompt Table: %EDITTABLE |
| 5 | INSTRMNT_TEMPLATE | Character(10) | VARCHAR2(10) NOT NULL |
A unique key identifier associated with an instrument that describes a separate template version of a pre
Prompt Table: INSTR_TMPL_H_VW |
| 6 | TRANSACTION_DT | Date(10) | DATE | Transaction date (often used as trade date) |
| 7 | COUNTERPARTY_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given dealing counterparty. |
| 8 | COUNTERPARTY | Character(5) | VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW |
| 9 | DEAL_FAMILY_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
When deals are linked together, a code is set to identify the nature of the linkage. (EG btb = back to back)
BTB=Back to Back COPY=Other Purpose Deal Copy MIR=Standard Mirror MIRR=Other Purpose Deal Mirror PART=Partial Sell/Buyback RLFX=FX Swap Forward / Backward RLPH=One Period Physical Rollover SUB=Internal or Subsidiary |
| 10 | INTER_UNIT_DEAL | Character(1) | VARCHAR2(1) NOT NULL |
Indication showing the deal is with the Treasury on an interunit or subsidiary basis.
Y/N Table Edit |
| 11 | TREAS_MAST_SUB_BU | Character(5) | VARCHAR2(5) NOT NULL | The business unit of the Treasury unit who controls a group of internal deals, soem of which may have different business units. |
| 12 | TREAS_MAST_SUB_ID | Character(12) | VARCHAR2(12) NOT NULL | This field contains the first deal id in a series of deals that are related for interunit dealing, on behalf dealing, or deals between subsidiaries. |
| 13 | TREAS_MAST_ROLL_ID | Character(12) | VARCHAR2(12) NOT NULL | This fields contains the first deal id in a series of deals that are related for deal rolling forward. |
| 14 | TREAS_BACK_ROLL_ID | Character(12) | VARCHAR2(12) NOT NULL | This fields contains the first deal id in a series of deals that are related for deal rolling forward. |
| 15 | TREAS_MIRROR_BU | Character(5) | VARCHAR2(5) NOT NULL | The business unit of the deal that is the opposite clearing deal of the current deal. |
| 16 | TREAS_MIRROR_ID | Character(12) | VARCHAR2(12) NOT NULL | The deal ID of the deal the is the offset for this deal. |
| 17 | TREAS_MIRROR_CPTY | Character(5) | VARCHAR2(5) NOT NULL | The counterparty in a mirror clearing deal. |
| 18 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 19 | TRANSACTION_ISSUER | Character(5) | VARCHAR2(5) NOT NULL |
The entity or organization that sponsors the issuance of a given financial instrument on behalf of the tre
Prompt Table: BANK_ISSUER_VW |
| 20 | TRANSACT_GUARANTOR | Character(5) | VARCHAR2(5) NOT NULL |
Entity that guarantees the credit worthiness of a financial instrument and its counterparty
Prompt Table: BANK_GURANTR_VW |
| 21 | TRANSACTION_BROKER | Character(5) | VARCHAR2(5) NOT NULL |
"The deal transaction intermediary
Prompt Table: BANK_BROKER_VW |
| 22 | DEALER_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that originally created and saved a given deal tran
Prompt Table: OPRID_VW |
| 23 | TRANSACTION_DTTM | DateTime(26) | TIMESTAMP | Transaction Date-Time |
| 24 | ORIG_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
User ID
Prompt Table: OPRID_VW |
| 25 | ORIG_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the original creation and saving of a given transaction. |
| 26 | TREASURY_PORTFOLIO | Character(15) | VARCHAR2(15) NOT NULL |
A unique key identifier for a position portfolio that may be associated with a given deal transaction.
Prompt Table: TRX_PORTFLIO_TR |
| 27 | CPTY_DEALER | Character(10) | VARCHAR2(10) NOT NULL | The assigned external dealer or trader associated with a given dealing counterparty. |
| 28 | CPTY_REFERENCE | Character(15) | VARCHAR2(15) NOT NULL | A reference identifier associated with a dealing counterparty transaction. |
| 29 | TRANSACTION_LOCKED | Character(1) | VARCHAR2(1) NOT NULL |
"An internal work field that
Y/N Table Edit Default Value: N |
| 30 | NET_CASHFLOWS | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to designate that the inbound and outbound cashflows for a given financi
Y/N Table Edit |
| 31 | TRA_ACTG_TREATMENT | Character(2) | VARCHAR2(2) NOT NULL |
Treasury Deal Accounting Treatment.
Edit Translates on this field to alter the Accounting Treatments available.
(Not quite a control table, but as good as it gets!)
01=Held to Maturity 02=Available for Sale 03=Trading 04=Other 05=Loans and Receivables |
| 32 | TR_COLL_LVL_MIN | Number(27,3) | DECIMAL(26,3) NOT NULL | Amount of Collateral that agreed upon to be pledged for a repo. |
| 33 | TR_SUB_REPO | Character(1) | VARCHAR2(1) NOT NULL |
Switch to allow substitution of collateral.
L=Substitution with Limits N=No Substitution W=Unlimited Substitution Default Value: N |
| 34 | TR_COLL_LVL_MAX | Number(27,3) | DECIMAL(26,3) NOT NULL | Amount of Collateral that agreed upon to be pledged for a repo. |
| 35 | TR_SUB_LIMIT | Number(6,2) | DECIMAL(5,2) NOT NULL | Limit of substitution amount. |
| 36 | TR_REPO_PRICE | Number(27,3) | DECIMAL(26,3) NOT NULL | The repurchase price of the instrument. |
| 37 | MTM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
The stated currency for a deal transaction's fair value (mark-to-market)
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 38 | MTM_VALUE_OVRD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate that the returned output value from an analytics function may be
Y/N Table Edit Default Value: N |
| 39 | MTM_ACCTG_VALUE_0 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The Initial (starting) Mark to Market Value for a Treasury Deal or other transaction |
| 40 | MTM_ACCTG_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The Fair Value (Mark to Market) of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item |
| 41 | MTM_EXCL_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | (Cumulative) Adjustment amount excluded from the calculation of the change in fair value of a deal or hedged item. Corresponds to Amortized Cost for investments and to Para 19 adjustments for a hedged item. NOTE: ONLY Label IDs 3 characters or less can be used as user-chosen labels on the Define Intruments / Analytics page (if added as XLATs to field MTM_EXCL_VAL_TYPE + C/P prefix) |
| 42 | MTM_DEAL_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | "A deal transaction's mark-to-market |
| 43 | SALE_CPTY_SETID | Character(5) | VARCHAR2(5) NOT NULL | The subject settlement bank tableset ID for a buy/sellback transaction. |
| 44 | SALE_COUNTERPARTY | Character(5) | VARCHAR2(5) NOT NULL |
The subject counterparty for a buy/sellback transaction.
Prompt Table: BANK_TR_CPTY_VW |
| 45 | SALE_CPTY_REF | Character(15) | VARCHAR2(15) NOT NULL | The subject transaction reference identifier for a buy/sellback transaction. |
| 46 | SALE_CPTY_DEALER | Character(10) | VARCHAR2(10) NOT NULL | The subject dealer for a buy/sellback transaction. |
| 47 | SALE_TRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unwind Par Amount |
| 48 | SALE_PRICE_PERCENT | Number(14,8) | DECIMAL(13,8) NOT NULL | The percentage of Unwind par value of which a financial instrument is priced when booked into the system. |
| 49 | SALE_PROCEEDS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The received sales proceeds for a buy/sellback transaction. |
| 50 | SALE_PRICE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The sales price for a buy/sellback transaction. |
| 51 | SALE_PURCH_INT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The amount of accrued interest associated with an instrument when the same is acquired. |
| 52 | PURCH_INT_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Whether purchased interest was input by user or calculated by system.
S=System Supplied U=User Supplied |
| 53 | SALE_CURRENT_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The subject accounting value for a buy/sellback transaction. |
| 54 | SALE_UBV_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Whether UBV was input by user or calculated by system.
S=System Supplied U=User Supplied |
| 55 | SALE_UPB | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unwind Principal Balance (Original Par Amount if no amortization OR Unamortized Principal Balance) |
| 56 | SALE_ORDER_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Type of the Sale Order - market or limit order
01=Market Order 02=Limit Order |
| 57 | AMORT_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the discount amount deducted from the par price of a given deal transaction such as a bond. |
| 58 | UNAMORT_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the Unamortized discount amount deducted from the par price of a given deal transaction such as a bond. |
| 59 | SALE_PRO_PERCENT | Number(14,8) | DECIMAL(13,8) NOT NULL | The percentage of Unwind par value of which a financial instrument is priced when booked into the system. |
| 60 | WRITEOFF_UNAM | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the discount amount deducted from the par price of a given deal transaction such as a bond. |
| 61 | SALE_FEE_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents Fee Balance on Deal Fees |
| 62 | AMORT_FEE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents Amortized Fee Balance on Deal Fees |
| 63 | UNAMORT_FEE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents Unamortized Fee Balance on Deal Fees |
| 64 | WRITEOFF_FEE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents Unamortized Fee Balance on Deal Fees |
| 65 | SALE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
The subject transaction currency for a buy/sellback transaction.
Prompt Table: CURRENCY_CD_TBL |
| 66 | SALE_DT | Date(10) | DATE | The transaction sales date for a buy/sellback transaction. |
| 67 | SALE_SETTLEMENT_DT | Date(10) | DATE | The agreed upon settlement date for a buy/sellback transaction. |
| 68 | SALE_BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The subject tableset ID associated with the treasury bank code for a buy/sellback transaction. |
| 69 | SALE_BANK_CD_CUST | Character(5) | VARCHAR2(5) NOT NULL | The subject treasury bank code for a buy/sellback transaction. |
| 70 | SALE_BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
The subject settlement bank code for a buy/sellback transaction.
Prompt Table: BANK_TR_BANK_VW |
| 71 | SALE_BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL |
The subject bank account for a buy/sellback transaction.
Prompt Table: BANK_TR_ACTS_VW |
| 72 | SALE_SETTLEMENT_ID | Character(5) | VARCHAR2(5) NOT NULL |
The subject settlement instructions for a buy/sellback transaction.
Prompt Table: BANK_SETL_CS_VW |
| 73 | SALE_PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check DD=Direct Debit DFT=Draft - Supplier Initiated EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 74 | SALE_FORMAT_ID | Character(10) | VARCHAR2(10) NOT NULL | Format ID |
| 75 | PREAPPV_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate that a deal transaction has been submitted for review via workflow process
Y/N Table Edit Default Value: N |
| 76 | DEAL_PVW_SUBMITTED | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a deal transaction subject to the deal previ
Y/N Table Edit Default Value: N |
| 77 | TR_APPV_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
An internal work field that indicates whether a given deal transaction has been approved by a reviewe
01=Authorized 02=Submitted 03=Pending Review 04=Deal Previewed 05=Deal Suspended 06=Deal Approved Default Value: 01 |
| 78 | PREAPPV_MAIL_SENT | Character(2) | VARCHAR2(2) NOT NULL |
An internal work field that indicates that a deal preview request has been rejected and an e-mai
01=Undelivered 02=Delivered Default Value: 01 |
| 79 | DEAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation 02=Sample 03=Open 04=Matured 05=Deactivated 06=Rejected 07=Sold / Bought back 08=Forecasted 09=Partially Sold/Bought Back Default Value: 03 |
| 80 | DEAL_RVW_SUBMITTED | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a deal transaction subject to the deal review proc
Y/N Table Edit Default Value: N |
| 81 | CONF_RVW_SUBMITTED | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates that a deal transaction subject to confirmation review suc
Y/N Table Edit Default Value: N |
| 82 | APPROVAL_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a given transaction is approved by an oper |
| 83 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
Prompt Table: OPRID_VW |
| 84 | DEAL_CONF_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Reflects the confirmation status of a given deal transaction at any particular point in time.
01=Pending 02=Confirmed 03=Invalid Default Value: 01 |
| 85 | DEAL_CONF_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a given deal transaction is confirmed |
| 86 | DEAL_CONF_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that confirmed a given deal transaction.
Prompt Table: OPRID_VW |
| 87 | AUTO_CONF_SENT | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a given deal transaction subject to outbound con
Y/N Table Edit Default Value: N |
| 88 | CONF_MAIL_SENT | Character(2) | VARCHAR2(2) NOT NULL |
An internal work field that indicates that a deal transaction has been rejected in the confirmation
01=Undelivered 02=Delivered Default Value: 01 |
| 89 | CONFO_OUT_SENT | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates that a given deal transaction subject to outbound confirmat
Y/N Table Edit Default Value: N |
| 90 | LAST_MAINT_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a transaction was last modified |
| 91 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
Prompt Table: OPRID_VW |
| 92 | EXCL_FROM_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to designate that a given deal transaction is not to be included in a subse
N=Include in Position Y=Exclude From Position Y/N Table Edit Default Value: N |
| 93 | LIMIT_RESERVED | Character(1) | VARCHAR2(1) NOT NULL |
An internal workfield that indicates whether a portion of a given treasury position's available exposu
N=UnReserved Y=Limit Reserved Y/N Table Edit Default Value: N |
| 94 | FCLTY_ID | Character(12) | VARCHAR2(12) NOT NULL |
A unique key identifier that represents a given counterparty facility.
Prompt Table: FCLTY_DFN |
| 95 | TREAS_MASTER_ID | Character(12) | VARCHAR2(12) NOT NULL |
Master ID for a given deal header.
Prompt Table: TRX_HEADER_VW2 |
| 96 | TREAS_NEXT_ID | Character(12) | VARCHAR2(12) NOT NULL | The new deal id created by Partial Sell/Buy back activity. |
| 97 | TREAS_PREVIOUS_ID | Character(12) | VARCHAR2(12) NOT NULL | Previous ID for a given deal header for Partial Sell/Buy back. |
| 98 | TRD_TRADE_ID | Character(12) | VARCHAR2(12) NOT NULL |
Trade ID
Prompt Table: TRD_HEADER_VW |
| 99 | TRADE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Trade Type
C=Close O=Open |
| 100 | TRD_SELLBUY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Trade Sell/Buy Flag
Y/N Table Edit Default Value: N |
| 101 | START_DT | Date(10) | DATE | Start Date |
| 102 | START_DISCOUNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Internal field utilized to determine the appropriate accrual accounting amount for a giv |
| 103 | SECURITY_ID | Character(10) | VARCHAR2(10) NOT NULL |
A reference identifier for a given deal transaction.
Prompt Table: TRX_SEC_HDR |
| 104 | RUN_POSN | Character(1) | VARCHAR2(1) NOT NULL |
A flag to check if position update to be run.
Y/N Table Edit Default Value: Y |
| 105 | TRP_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Pool Business Unit |
| 106 | POOL_ID | Character(10) | VARCHAR2(10) NOT NULL | Pool ID field. |
| 107 | EVENT_TRACKING_ID | Number(10,0) | DECIMAL(10) NOT NULL | The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID. |
| 108 | CR_RATING_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
The market credit agency associated wth a given group of credit ratings.
I=IBCA M=Moody's S=Standard && Poors Prompt Table: CREDIT_RTG_DEFN |
| 109 | CR_RATING_VALUE | Number(3,0) | SMALLINT NOT NULL |
User defined rating values utilized to assign priorities to a given set of credit ratings.
Prompt Table: CREDIT_RTG_TBL |
| 110 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |