RS_ED_WO_STDDY (SQL View)	Index Back
Std Day percent for WO This view will have the Std Day percent for employee based on the Servide Order.

RS_ED_WO_STDDY

(SQL View)

Std Day percent for WO

This view will have the Std Day percent for employee based on the Servide Order.

SELECT A.EMPLID , A.EFFDT , A.EMPL_STATUS , A.STD_DAY_PERCENT , A.SYSTEM_SOURCE FROM %Table(RS_WO_STDDY_VW) A WHERE A.SYSTEM_SOURCE = 'RS' AND A.EFFDT=( SELECT MAX(X.EFFDT) FROM PS_RS_WO_STDDY_VW X WHERE X.SYSTEM_SOURCE = A.SYSTEM_SOURCE AND X.EMPLID = A.EMPLID AND X.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE Effective Date

3 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

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

5 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	EFFDT	Date(10)	DATE	Effective Date
3	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
4	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.
5	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.