RS_WO_STDDAY_VW

(SQL View)

SELECT B.EMPLID , %Round(%DecDiv(%DecDiv(%DecDiv(%DecMult(B.STD_HOURS,C.FREQ_ANNUAL_FACTOR),52),A.STD_DAYS),D.STD_HOURS), 4) ,B.SYSTEM_SOURCE FROM %Table(RS_WORKER_TBL) A , %Table(RS_WO_CURJOB_VW) B , %Table(FREQUENCY_TBL) C , %Table(INSTALLATION_RS) D WHERE B.EMPLID = A.EMPLID AND C.EFFDT = ( SELECT MAX(U.EFFDT) FROM %Table(FREQUENCY_TBL) U WHERE U.FREQUENCY_ID = C.FREQUENCY_ID AND U.EFFDT <= %CurrentDateIn) AND C.FREQUENCY_ID = B.STD_HRS_FREQUENCY AND A.STD_DAYS > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 STD_DAY_PERCENT Number(7,4) DECIMAL(6,4) NOT NULL The standard work day represented as a ratio of the worker's standard day to the general standard day.

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	STD_DAY_PERCENT	Number(7,4)	DECIMAL(6,4) NOT NULL	The standard work day represented as a ratio of the worker's standard day to the general standard day.
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.