INSTR_HEADER_TR

(SQL Table)
Index Back

Instruments & Templates

Both Instruments (instrmnt_template = ' ') and Instrument Templates (instrmnt_template != ' ')

  • Related Language Record: INSTR_HD_TR_LNG
  • Parent Record Of INSTR_DETAIL_TR INSTR_DETAIL_VW INSTR_DETL_VW1 TRD_INST_DTL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type

    Prompt Table: INSTR_INST_H_VW

    3 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

    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.

    Prompt Table: BANK_TR_CPTY_VW

    6 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

    7 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

    8 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

    9 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

    Default Value: Y

    10 MINIMUM_BIDS Number(3,0) SMALLINT NOT NULL The minimum number of bids for a deal
    11 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
    12 MTM_EXCL_VAL_TYPE Character(4) VARCHAR2(4) NOT NULL A code that selects what processing and label the user wants to appear against field MTM_EXCL_VALUE on the Deal Analytics page. 1st char is either "C" display Cumulative adjustment amounts (like Amortized Cost), or "P" display Period by period adjustment amounts (FAS133 derivatives) Next 3 chars are the LABEL_ID of one of MTM_EXCL_VALUE's labels.
    CAC=Cumulative Amortized Cost
    CFVA=Cumulative Fair Value
    PFVA=Per Period Fair Value

    Default Value: PFVA

    13 CONFO_VALID_ID Character(10) VARCHAR2(10) NOT NULL A unique key identifier that represents a group of deal transaction fields designated as ma

    Prompt Table: DAD_CNF_VALCOL

    14 AUTO_PREVIEW_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that the deal preview workflow feature has been enabled in the Treasur

    Y/N Table Edit

    Default Value: N

    15 CONFO_REVIEW_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that the deal confirmation review workflow feature has been enabled

    Y/N Table Edit

    Default Value: N

    16 OB_CONFO_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that the automated outbound confirmation feature has been enabled in

    Y/N Table Edit

    Default Value: N

    17 ALLOW_ROLLING Character(1) VARCHAR2(1) NOT NULL This flag indicates if a deal can be rolled forward or swapped forward or backward.

    Y/N Table Edit

    Default Value: N

    18 ALLOW_FIXED_RT_CHG Character(1) VARCHAR2(1) NOT NULL This flag indicates if a deal fixed rate can be changed.

    Y/N Table Edit

    Default Value: N

    19 TR_REPO_SW Character(1) VARCHAR2(1) NOT NULL Switch to indicate whether the Deal is a Repo or not.

    Y/N Table Edit

    Default Value: N

    20 FAS133_INSTRUMENT Character(1) VARCHAR2(1) NOT NULL listbox to choose the FAS 133 Hedging Instrument Type: "D" Derivative "E" Embedded Derivative "X" Nonderivative Foreign Currency "H" Hedgable Item If this field has a value, then this instrument can be used for FAS 133 hedging: D, E, X as Hedging Instruments, X, H as Hedged Items
    D=Is a Derivative
    E=Contains Embedded Derivative
    H=Can be a Hedged Item
    X=Nonderivative Foreign Currency
    21 NOTES_1000 Long Character(1000) VARCHAR2(1000) Represents a field that allows free form text on the instrument definition panels.
    22 RSK_VAR_EXP_SQL Character(30) VARCHAR2(30) NOT NULL SQLID used to obtain data for VaR export.

    Prompt Table: SQLID_VW

    23 TR_LOC_DEBT_FLG Character(1) VARCHAR2(1) NOT NULL Flag to mark instrument as being drawn on Line of Credit facility

    Y/N Table Edit

    Default Value: N

    24 TR_CP_ISSUE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate that the Instrument is a Commercial Paper instrument

    Y/N Table Edit

    Default Value: N