GPES_EMPEXPL_VW (SQL View)	Index Back
Expatriate Employees Expatriate Employees

GPES_EMPEXPL_VW

(SQL View)

Expatriate Employees

SELECT DISTINCT B.OPRID , B.ROWSECCLASS ,B.PER_ORG ,B.COMPANY ,P.GPES_TAX_LOCATION , P.EMPLID , B.NAME FROM PS_EMPLMT_SRCH_GBL B ,PS_GPES_PAYEE_DATA P WHERE P.EMPLID = B.EMPLID AND P.EFFDT <= %CurrentDateIn AND P.GPES_TRANS_MOB = '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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

3 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

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

5 GPES_TAX_LOCATION Character(5) VARCHAR2(5) NOT NULL Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

6 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL EmplID To

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

#	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	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
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	GPES_TAX_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
6	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	EmplID To
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name