TL_MSS_SRCH_FLD

(SQL Table)
 Index Back

MSS Search Field List

These are all the fields that are used for the Manager Search Funcitonality.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GROUP_ID Character(5) VARCHAR2(5) NOT NULL Group ID

Prompt Table: TL_GROUP_SEC_VW

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: TL_EMPL_NAME_VW

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

Prompt Table: TL_EMPL_RCD1_VW

4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

Prompt Table: TL_LAST_NAME_VW

5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

Prompt Table: TL_FIRST_NM_VW

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_HR

7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODE_TBL

8 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description

Prompt Table: TL_JOB_DESC_VW

9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

10 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

Prompt Table: TL_SUPRVSR_VW

11 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

Prompt Table: POSITION_DATA

12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

13 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

14 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

15 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP

16 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup

Prompt Table: TL_WRKGRP_TBL

17 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

Prompt Table: TL_TASKGRP_TBL

18 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Prompt Table: POSN_DATA_VW