RS_WRKR_ELGBL

(SQL View)

SELECT A.EMPLID ,A.EMPL_RCD , A.SYSTEM_SOURCE , B.PER_STATUS , C.SUPERVISOR_ID , A.EFFDT FROM %Table(RS_WRKR_EFFDT) A , %Table(PERSONAL_DATA) B ,%Table(EMPLOYMENT) C WHERE A.EMPLID = B.EMPLID AND A.EMPLID =+ C.EMPLID AND A.EMPL_RCD =+ C.EMPL_RCD AND %EffdtCheck(RS_WRKR_EFFDT Z, A, %CURRENTDATEIN) AND A.WRKR_INELIGIBLE = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee

5 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

6 EFFDT Date(10) DATE Effective Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	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.
4	PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Personnel Status E=Employee N=Non-Employee
5	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
6	EFFDT	Date(10)	DATE	Effective Date