SHS_EE_SRCH_FRA (SQL View)	Index Back
France Employment Search EMPLMT_SRCH_FRA is an Employment Search record containing the French SSN as an alternate search key. 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. Use this view to access records with primary keys of EMPLID and EMPL_RCD#. To access records keyed by EMPLID without EMPL_RCD#, use one of ther Personal Searches.

SHS_EE_SRCH_FRA

(SQL View)

France Employment Search

EMPLMT_SRCH_FRA is an Employment Search record containing the French SSN as an alternate search key. 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. Use this view to access records with primary keys of EMPLID and EMPL_RCD#. To access records keyed by EMPLID without EMPL_RCD#, use one of ther Personal Searches.

SELECT %Sql(SCRTY_SEL_PKEY,SEC,SEC) ,SEC.NAME ,SEC.LAST_NAME_SRCH ,SEC.BUSINESS_UNIT ,SEC.SETID_DEPT ,SEC.DEPTID ,SEC.PER_ORG ,SEC.JOBCODE ,B.DESCR FROM PS_EMPLMT_SRCH_GBL SEC , PS_JOBCODE_TBL B WHERE SEC.SETID_JOBCODE = B.SETID AND SEC.JOBCODE = B.JOBCODE AND B.EFF_STATUS = 'A' AND %EffdtCheck(JOBCODE_TBL, B, %Currentdatein)

# 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 Rcd Nbr

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

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

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

8 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

10 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

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

12 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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 Rcd Nbr
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
10	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
11	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
12	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description