SF_WRK_WK_SH_VW (SQL View)	Index Back
SF Work Week Shift View 07/23/98 TKI CN#MG800-5.0 Replaced a.shift with a.mg_shift and b.shift with b.mg_shift in query for database reconciliation project 06/01/00 DDP: replaced a.mfg_shift with b.mg_shift in select and where clause changed from a.mfg_shift to a.mg_shift 07/06/00 DDP: Modified view to include valid shift not shift code

SF_WRK_WK_SH_VW

(SQL View)

SF Work Week Shift View

07/23/98 TKI CN#MG800-5.0 Replaced a.shift with a.mg_shift and b.shift with b.mg_shift in query for database reconciliation project 06/01/00 DDP: replaced a.mfg_shift with b.mg_shift in select and where clause changed from a.mfg_shift to a.mg_shift 07/06/00 DDP: Modified view to include valid shift not shift code

SELECT a.business_unit , 1 , b.start_time , b.end_time FROM PS_MG_WORK_WK_DEFN a , ps_mg_shifts b WHERE b.business_unit = a.business_unit AND b.mg_shift = a.mg_shift

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 MG_SHIFT Number(2,0) SMALLINT NOT NULL MG_SHIFT represents the shift code (i.e., 1, 2, 3, etc) for a manufacturing shift. 07/23/98 TKI CN#MG800-5.0 Created to replace SHIFT for the database reconcilation project (8.0)
1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating

3 START_TIME Time(15) TIMESTAMP Start of Shift

4 END_TIME Time(15) TIMESTAMP End of Shift

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	MG_SHIFT	Number(2,0)	SMALLINT NOT NULL	MG_SHIFT represents the shift code (i.e., 1, 2, 3, etc) for a manufacturing shift. 07/23/98 TKI CN#MG800-5.0 Created to replace SHIFT for the database reconcilation project (8.0) 1=1 2=2 3=3 C=Compressed N=Not Applicable R=Rotating
3	START_TIME	Time(15)	TIMESTAMP	Start of Shift
4	END_TIME	Time(15)	TIMESTAMP	End of Shift