INSTR_XFR_VW

(SQL View)
 Index Back

Instrument Prompt for Funds Xf


SELECT DISTINCT h.setid , h.instrument_type , h.instrmnt_template , MAX(h.descr60 ) FROM PS_INSTR_HEADER_TR h , ps_instr_detail_tr d WHERE h.setid = d.setid AND h.instrument_type = d.instrument_type AND d.instrmnt_template = h.instrmnt_template AND h.instrmnt_template = ' ' GROUP BY h.setid, h.instrument_type, h.instrmnt_template HAVING COUNT(*) = 1 AND (MAX(instrmnt_base_type) = '01' OR MAX(instrmnt_base_type) = '03')

  • Related Language Record: INSTR_FX_VW_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
    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
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description