RS_WO_STDDY_VW (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_WO_STDDY_VW

(SQL View)

Std Day percent for WO

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

SELECT B.EMPLID , B.EFFDT , B.EMPL_STATUS , %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_ALLJOB_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 EFFDT Date(10) DATE Effective Date
Default Value: %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 Default Value: %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.