GPBR_SHF_DUR_VW (SQL View)	Index Back
Sum Schedule Shift Duration Summarize the duration per shift.

GPBR_SHF_DUR_VW

(SQL View)

Sum Schedule Shift Duration

Summarize the duration per shift.

SELECT SETID , SHIFT_ID , EFFDT , %Round(%DecMult(SUM(STRT_STOP_DIFF), 60), 0) FROM PS_SCH_SHIFT_DTL WHERE PUNCH_TYPE IN ('0','1','2') GROUP BY SETID, SHIFT_ID, EFFDT

Parent record: SCH_SHIFT_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_VLD_TL_01

2 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 STRT_STOP_DIFF Number(5,2) DECIMAL(4,2) NOT NULL Start Stop Time Duration

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_TL_01
2	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	STRT_STOP_DIFF	Number(5,2)	DECIMAL(4,2) NOT NULL	Start Stop Time Duration