GPES_EMPLOC_VW (SQL View)	Index Back
Personal Data Personal Data

GPES_EMPLOC_VW

(SQL View)

Personal Data

SELECT DISTINCT SEC.OPRID , SEC.ROWSECCLASS , A.PER_ORG ,P.GPES_TAX_LOCATION , A.EMPLID , SEC.NAME FROM PS_PER_ORG_ASGN A , PS_PERS_SRCH_GBL SEC ,PS_GPES_PAYEE_DATA P WHERE A.EMPLID = SEC.EMPLID AND A.EMPL_RCD = SEC.EMPL_RCD AND P.EMPLID = A.EMPLID AND P.EFFDT <= %CurrentDateIn AND P.GPES_TRANS_MOB = 'N'

# 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 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.

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

6 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	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.
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name