INSTR_FX_VW_LNG

(SQL View)
 Index Back

Instruments & Templates

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

SELECT setid , instrument_type , instrmnt_template , language_cd , descr60 FROM PS_INSTR_HD_TR_LNG

  • Related Language Record for INSTR_FX_VW INSTR_XFR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL 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

    Prompt Table: INSTR_TMPL_H_VW

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description