INSTR_TMPL_SRCH

(SQL View)
 Index Back

Instrument Templates Prompt

Prompt Record for Treasury Instrument Templates

SELECT setid ,instrument_type ,instrmnt_template ,descr60 ,notes_1000 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.