INSTR_PHY_V_LNG

(SQL View)
 Index Back

Physical Rolling Instruments

List the physical instruments available during the rolling process

SELECT h.setid ,h.instrument_type ,h.instrmnt_template ,l.language_cd ,MAX(l.descr60) FROM PS_INSTR_HEADER_TR h ,ps_instr_detail_tr d ,ps_instr_hd_tr_lng l WHERE d.setid = h.setid AND d.instrument_type=h.instrument_type AND d.instrmnt_template=h.instrmnt_template AND h.instrmnt_template = ' ' AND l.setid = h.setid AND l.instrument_type=h.instrument_type AND l.instrmnt_template=h.instrmnt_template AND h.instrmnt_template = ' ' GROUP BY h.setid ,h.instrument_type ,h.instrmnt_template, l.language_cd HAVING COUNT(*) =1 AND MAX(repeat_int_periods) = 'N' AND MAX(instrmnt_base_type) = '01'

  • Related Language Record for INSTR_PHYS_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
    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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description