TL_MSS_SRCH1_VW (SQL View)	Index Back
T&L MSS Search by Oprid View used in MSS pages

TL_MSS_SRCH1_VW

(SQL View)

T&L MSS Search by Oprid

View used in MSS pages

SELECT A.OPRID , A.FIELDNAME , A.FIELD_VALUE3 , A.INCL_CRITERIA ,A.INCL_LIST , A.FIELDNUM FROM PS_TL_MSS_SEARCH A WHERE A.INCL_CRITERIA = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

3 FIELD_VALUE3 Character(30) VARCHAR2(30) NOT NULL This field is used to place values into from another field. For example: Translate fields or other derived values as it relates to text. ST_LBL_WRK.FIELD_VALUE1.Value = ST_ISSUANCE.STOCK_PLAN_TYPE.LongTranslateValue;
Prompt Table: %EDITTABLE

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

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
Y/N Table Edit

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
3	FIELD_VALUE3	Character(30)	VARCHAR2(30) NOT NULL	This field is used to place values into from another field. For example: Translate fields or other derived values as it relates to text. ST_LBL_WRK.FIELD_VALUE1.Value = ST_ISSUANCE.STOCK_PLAN_TYPE.LongTranslateValue; Prompt Table: %EDITTABLE
4	INCL_CRITERIA	Character(1)	VARCHAR2(1) NOT NULL	Include in Criteria
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 Y/N Table Edit
6	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number