TL_MSS_INS_LANG

(SQL View)
Index Back

T&L MSS Installation Default

Related Language for T&L MSS Installation

SELECT A.FIELDNAME ,A.LANGUAGE_CD , A.LONGNAME ,A.EDITTABLE ,B.INCL_LIST ,B.INCL_CRITERIA FROM PS_TL_MSS_FLD_LANG A , PS_TL_MSS_INST_DFT B WHERE A.FIELDNAME = B.FIELDNAME

  • Related Language Record for TL_MSS_INSFD_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    4 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table
    5 INCL_LIST Character(1) VARCHAR2(1) NOT NULL Field used as indicator for whether and how employee search criteria should be included in the resulting list displayed on MSS components within time and labor. The how options include: Show Code, Show Description or Show "Both" for fields that carry a description, such as Department or Location.
    B=Include Code and Description
    C=Include Code Only
    D=Include Description Only
    N=Do Not Include
    Y=Include
    6 INCL_CRITERIA Character(1) VARCHAR2(1) NOT NULL Include in Criteria