PAY_ALL_CURR_VW (SQL View)	Index Back
Job NA Payroll Data - Current Selects all Persons in JOB and shows their Current information for each EMPLID/EMPL_RCD pair. This view will include Employees, Contingent Workers, and Persons of Interest. Use the PER_ORG field to determine which organzational relationship they have. Use EMPL_STATUS to determine their current status.

PAY_ALL_CURR_VW

(SQL View)

Job NA Payroll Data - Current

Selects all Persons in JOB and shows their Current information for each EMPLID/EMPL_RCD pair. This view will include Employees, Contingent Workers, and Persons of Interest. Use the PER_ORG field to determine which organzational relationship they have. Use EMPL_STATUS to determine their current status.

SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.EMPL_STATUS ,A.HR_STATUS ,A.PER_ORG ,A.COMPANY ,A.TAX_LOCATION_CD ,A.PAY_SYSTEM_FLG ,A.PAYGROUP ,A.REG_TEMP ,A.FULL_PART_TIME FROM PS_JOB A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB JOB2 WHERE A.EMPLID = JOB2.EMPLID AND A.EMPL_RCD = JOB2.EMPL_RCD AND JOB2.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB JOB3 WHERE JOB3.EMPLID = A.EMPLID AND JOB3.EMPL_RCD = A.EMPL_RCD AND JOB3.EFFDT = A.EFFDT)

Parent record: PER_ORG_ASGN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Default Value: 0

3 EFFDT_NOKEY Date(10) DATE Used in Records /Views where the EFFDT won't be a key

4 EFFSEQ_NOKEY Number(3,0) SMALLINT NOT NULL Field used in views where EFFSEQ won't be a key

5 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

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

7 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
Default Value: POI

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

9 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code

10 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface

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

12 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary

13 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Default Value: 0
3	EFFDT_NOKEY	Date(10)	DATE	Used in Records /Views where the EFFDT won't be a key
4	EFFSEQ_NOKEY	Number(3,0)	SMALLINT NOT NULL	Field used in views where EFFSEQ won't be a key
5	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
6	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
7	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 Default Value: POI
8	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
9	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code
10	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface
11	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
12	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
13	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time