MATR_SRCH_ITA (SQL View)	Index Back
Matr Employee Search - ITA MATR_SRCH_ITA is an Employment Search record containing all of the localized alternate search keys. None of the localized search keys are maked as alternate searches. However, it's easy for a customer to mark any/all of them as alternate search keys if they choose to. Use it to select employee records for you to use when you access a panel. This view shows you records only for employees in departments that your operator class is allowed to access.

MATR_SRCH_ITA

(SQL View)

Matr Employee Search - ITA

MATR_SRCH_ITA is an Employment Search record containing all of the localized alternate search keys. None of the localized search keys are maked as alternate searches. However, it's easy for a customer to mark any/all of them as alternate search keys if they choose to. Use it to select employee records for you to use when you access a panel. This view shows you records only for employees in departments that your operator class is allowed to access.

SELECT %Sql(SCRTY_SEL_PKEY,SEC,SEC) , MTR.MATRICULA_NBR_ITA , MTR.HIRE_DT , SEC.COMPANY , SEC.REG_REGION , MTR.EMPL_CLASS , %Sql(SCRTY_SEL_PERSBR,SEC,SEC) , %Sql(SCRTY_SEL_FLDSBR,SEC) FROM PS_EMPL_MATR_ITA MTR , PS_PERS_SRCH_GBL SEC WHERE SEC.EMPLID = MTR.EMPLID AND SEC.EMPL_RCD = MTR.EMPL_RCD

# 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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

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

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 MATRICULA_NBR_ITA Number(6,0) INTEGER NOT NULL Matricula Number ITA

6 HIRE_DT Date(10) DATE First Start Date

7 COMPANY_SEC Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

8 REG_REGION_SEC Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Prompt Table: REG_STANDARD_VW

9 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
Prompt Table: EMPL_CLASS_TBL

10 NAME Character(50) VARCHAR2(50) NOT NULL Name

11 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.

12 NAME_PSFORMAT Character(50) VARCHAR2(50) NOT NULL A Person's name in the Peoplesoft Format (basically LN,FN MI

13 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

14 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name

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

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

17 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name

18 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

19 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME

20 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

21 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest

22 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.

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

24 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
Prompt Table: SETID_TBL

25 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: PERS_DEPT_VW

26 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

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

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

29 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

30 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

31 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

32 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive

33 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service
Prompt Table: MIL_SERVICE_TBL

34 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank
Prompt Table: MIL_RANK_TBL

35 MIL_WORN_RANK Character(5) VARCHAR2(5) NOT NULL Worn Rank
Prompt Table: MIL_RANK_TBL

36 APPT_TYPE Character(1) VARCHAR2(1) NOT NULL This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
0=Core Appointment
1=Japan Kenmu Appointment
2=French Public Sector Appt
3=Staffing

37 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

38 OTHER_ID_JPN Character(11) VARCHAR2(11) NOT NULL Other Identifier

39 FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current

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

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

42 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

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

#	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	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	MATRICULA_NBR_ITA	Number(6,0)	INTEGER NOT NULL	Matricula Number ITA
6	HIRE_DT	Date(10)	DATE	First Start Date
7	COMPANY_SEC	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
8	REG_REGION_SEC	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_STANDARD_VW
9	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification Prompt Table: EMPL_CLASS_TBL
10	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
11	NAME_DISPLAY_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Uppercase version of Name to improve performance on searches.
12	NAME_PSFORMAT	Character(50)	VARCHAR2(50) NOT NULL	A Person's name in the Peoplesoft Format (basically LN,FN MI
13	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
14	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
15	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
16	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
17	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
18	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
19	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
20	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
21	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
22	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS.
23	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
24	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID Prompt Table: SETID_TBL
25	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: PERS_DEPT_VW
26	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
27	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
28	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
29	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
30	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
31	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
32	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
33	MILITARY_SERVICE	Character(8)	VARCHAR2(8) NOT NULL	Military Service Prompt Table: MIL_SERVICE_TBL
34	MIL_RANK	Character(5)	VARCHAR2(5) NOT NULL	Military Rank Prompt Table: MIL_RANK_TBL
35	MIL_WORN_RANK	Character(5)	VARCHAR2(5) NOT NULL	Worn Rank Prompt Table: MIL_RANK_TBL
36	APPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers. 0=Core Appointment 1=Japan Kenmu Appointment 2=French Public Sector Appt 3=Staffing
37	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
38	OTHER_ID_JPN	Character(11)	VARCHAR2(11) NOT NULL	Other Identifier
39	FUTURE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current
40	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
41	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
42	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
43	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code