SCHD_VW_ESP (SQL View)	Index Back
Permanent ERE employees Employee population for a permanent ERE

SCHD_VW_ESP

(SQL View)

Permanent ERE employees

Employee population for a permanent ERE

SELECT A.EMPLID , A.EMPL_RCD , B.SETID , B.SCHEDULE_ID , B.DUR , A.EFFDT , A.END_EFFDT , B.OFFDAY_IND , B.SCHED_HRS , A.USE_DFLT_WS FROM PS_SCH_ASSIGN A , PS_SCH_CLND_VW B WHERE A.SETID = B.SETID AND A.SCH_ADHOC_IND = B.SCH_ADHOC_IND AND A.SCHEDULE_ID = B.SCHEDULE_ID AND A.ROTATION_ID = B.ROTATION_ID AND B.DUR <= A.END_EFFDT AND B.DUR >= A.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: EMPLOYMENT

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

4 SCHEDULE_ID Character(16) VARCHAR2(16) NOT NULL The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).

5 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.

6 EFFDT Date(10) DATE Effective Date
Default Value: %date

7 END_EFFDT Date(10) DATE End Effdt

8 OFFDAY_IND Character(1) VARCHAR2(1) NOT NULL Off Day Indicator
N=Work Shift
Y=Off Shift

9 SCHED_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL Scheduled Work Hours

10 USE_DFLT_WS Character(1) VARCHAR2(1) NOT NULL Indicator for Primary Schedule
A=Create Personal Schedule
N=Select Predefined Schedule
Y=Use Default Schedule

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: EMPLOYMENT
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	SCHEDULE_ID	Character(16)	VARCHAR2(16) NOT NULL	The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).
5	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	END_EFFDT	Date(10)	DATE	End Effdt
8	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift
9	SCHED_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Scheduled Work Hours
10	USE_DFLT_WS	Character(1)	VARCHAR2(1) NOT NULL	Indicator for Primary Schedule A=Create Personal Schedule N=Select Predefined Schedule Y=Use Default Schedule