TL_MSS_INSFD_VW

(SQL View)
Index Back

Manager Search Field View

View of Installation Options for MSS

SELECT A.FIELDNAME , A.LONGNAME , A.FIELDNUM ,A.EDITTABLE ,B.INCL_LIST ,B.INCL_CRITERIA FROM PS_TL_MSS_FLD_VW A , PS_TL_MSS_INST_DFT B WHERE A.FIELDNAME = B.FIELDNAME

  • Related Language Record: TL_MSS_INS_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    3 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    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