INSTR_TMPL_H_VW

(SQL View)
Index Back

Instrument Templates Prompt

Prompt Record for Treasury Instrument Templates

SELECT setid ,instrument_type ,instrmnt_template ,descr60 ,notes_1000 ,counterparty ,transaction_issuer ,transact_guarantor ,treasury_portfolio ,net_cashflows ,tra_actg_treatment ,confo_valid_id ,auto_preview_sw ,confo_review_sw FROM PS_INSTR_HEADER_TR WHERE instrmnt_template <> ' '

  • Related Language Record: INSTR_HD_TR_LNG
  • # 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 NOTES_1000 Long Character(1000) VARCHAR2(1000) Represents a field that allows free form text on the instrument definition panels.
    6 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.

    Prompt Table: BANK_TR_CPTY_VW

    7 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_TR_CPTY_VW

    8 TRANSACT_GUARANTOR Character(5) VARCHAR2(5) NOT NULL Entity that guarantees the credit worthiness of a financial instrument and its counterparty

    Prompt Table: BANK_TR_CPTY_VW

    9 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

    10 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

    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 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

    13 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

    14 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