RS_WRKR_LIST_VW (SQL View)	Index Back
Worker Search This defines the list of ALL workers that have ever been listed in Resource Management. It is joined against the JOB, DEPT_TBL, and LOCATION_TBL tables to get the most current information about the worker and his/her job. SUJ--SYSTEM_SOURCE field added to store product under which user is a resource

RS_WRKR_LIST_VW

(SQL View)

Worker Search

This defines the list of ALL workers that have ever been listed in Resource Management. It is joined against the JOB, DEPT_TBL, and LOCATION_TBL tables to get the most current information about the worker and his/her job. SUJ--SYSTEM_SOURCE field added to store product under which user is a resource

SELECT A.EMPLID ,C.SYSTEM_SOURCE , C.EMPL_RCD , J.DEPTID , J.LOCATION , J.EMPL_STATUS , C.WRKR_INELIGIBLE , J.JOBCODE FROM %Table(JOB) J , %Table(RS_WRKR_EFFDT) C ,%Table(RS_WORKER_TBL) A WHERE A.EMPLID = C.EMPLID AND C.EFFDT = ( SELECT MAX(M.EFFDT) FROM %Table(RS_WRKR_EFFDT) M WHERE M.EMPLID = A.EMPLID AND M.EFFDT <= %CurrentDateIn) AND C.EMPLID = J.EMPLID AND C.EMPL_RCD = J.EMPL_RCD AND J.EFFDT = ( SELECT MAX(H.EFFDT) FROM %Table(JOB) H WHERE J.EMPLID = H.EMPLID AND J.EMPL_RCD = H.EMPL_RCD AND H.EFFDT <= %CurrentDateIn) AND J.EFFSEQ = ( SELECT MAX(I.EFFSEQ) FROM %Table(JOB) I WHERE J.EMPLID = I.EMPLID AND J.EMPL_RCD = I.EMPL_RCD AND J.EFFDT = I.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

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

6 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Employee Status
A=Active
D=Deceased
I=Inactive
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

7 WRKR_INELIGIBLE Character(1) VARCHAR2(1) NOT NULL Worker Ineligible Flag

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
5	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
6	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Employee Status A=Active D=Deceased I=Inactive 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
7	WRKR_INELIGIBLE	Character(1)	VARCHAR2(1) NOT NULL	Worker Ineligible Flag
8	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code