TL_MSS_INST_DFT

(SQL Table)
Index Back

T & L MSS Installation Default

MSS Installation Defaults

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: TL_MSS_FLD_VW

2 INCL_CRITERIA Character(1) VARCHAR2(1) NOT NULL Include in Criteria

Y/N Table Edit

Default Value: Y

3 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

Default Value: Y

4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number