GPES_CLND_H_VW (SQL View)	Index Back
Working Hours / Month Working Hours / Month based on the Schedule

GPES_CLND_H_VW

(SQL View)

Working Hours / Month

Working Hours / Month based on the Schedule

SELECT A.SETID , A.SCHEDULE_ID , SUM(A.SCHED_HRS) ,B.THE_DATE ,COUNT(*) FROM PS_SCH_CLND_DTL_VW A , PS_TL_DATES_TBL B WHERE A.DUR <= B.THE_DATE AND SCHED_HRS<>0 GROUP BY B.THE_DATE, A.SETID, A.SCHEDULE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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).

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

4 THE_DATE Date(10) DATE Date

5 SHIFTNUM Number(2,0) SMALLINT NOT NULL Shift Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	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).
3	SCHED_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Scheduled Work Hours
4	THE_DATE	Date(10)	DATE	Date
5	SHIFTNUM	Number(2,0)	SMALLINT NOT NULL	Shift Sequence Number