RS_SCP_STDDAY (SQL Table)	Index Back
Std Day Percent of Employees This Record will have the From and To Date and Std Day Percent of a Employee.

RS_SCP_STDDAY

(SQL Table)

Std Day Percent of Employees

This Record will have the From and To Date and Std Day Percent of a Employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT_FROM Date(10) DATE Effective Date From

3 EFFDT_TO Date(10) DATE Effective Date To

4 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT_FROM	Date(10)	DATE	Effective Date From
3	EFFDT_TO	Date(10)	DATE	Effective Date To
4	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
5	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.