Sample add production test data and expected results

Sample test data that could be entered in the form for various DateTime formats, and the expected results in the MES database, are listed in the following tables.

DateTime format 1

• Date format MM/dd/yyyy

• Time format HH:mm:ss

  Column Name	Database Data Type	Data Input	Data Expected in MES Database
  Session Id	Int32	114	114
  Event Time	datetime	11/08/2012 5:00:00	11/08/2012 5:00:00
  User Id	String 80	ww	ww
  Ent Id	Int32	4	4
  Qty Prod	Double	4	4
  Reason Code	Int32	1	1
  Lot No	String80	1	1
  Sublot No	String80	Null	Null
  Storage Ent Id	Int32	4	4
  Produced Item	String80	Item-A	Item-A
  Bom Position	Int32	Null	Null
  Segment Requirement ID	Null	Null
  Segment Response ID	Null	Null
  Job Position	Int32	0	0

DateTime format 2

• Date format yyyy-MM-dd

• Time format hh:mm:ss tt

  Column Name	Database Data Type	Data Input	Data Expected in MES Database
  Session Id	Int32	114	114
  Event Time	datetime	2012-11-08 5:00:00 AM	11/08/2012 5:00:00
  User Id	String 80	ww	ww
  Ent Id	Int32	4	4
  Qty Prod	Double	4	4
  Reason Code	Int32	1	1
  Lot No	String80	1	1
  Sublot No	String80	Null	Null
  Storage Ent Id	Int32	4	4
  Produced Item	String80	Item-A	Item-A
  Bom Position	Int32	Null	Null
  Segment Requirement ID	Null	Null
  Segment Response ID	Null	Null
  Job Position	Int32	0	0

DateTime format 3

• Date format dd-mm-yyyy

• Time format hh:mm:ss tt

  Column Name	Database Data Type	Data Input	Data Expected in MES Database
  Session Id	Int32	114	114
  Event Time	datetime	08-11-2012 5:00:00 PM	11/08/2012 17:00:00
  User Id	String 80	ww	ww
  Ent Id	Int32	4	4
  Qty Prod	Double	4	4
  Reason Code	Int32	1	1
  Lot No	String80	1	1
  Sublot No	String80	Null	Null
  Storage Ent Id	Int32	4	4
  Produced Item	String80	Item-A	Item-A
  Bom Position	Int32	Null	Null
  Segment Requirement ID	Null	Null
  Segment Response ID	Null	Null
  Job Position	Int32	0	0

DateTime format 4

• Date format dd.MMM.yyyy

• Time format hh:mm:ss tt

  Column Name	Database Data Type	Data Input	Data Expected in MES Database
  Session Id	Int32	114	114
  Event Time	datetime	08.Nov.2012 5:00:00 PM	11/08/2012 17:00:00
  User Id	String 80	ww	ww
  Ent Id	Int32	4	4
  Qty Prod	Double	4	4
  Reason Code	Int32	1	1
  Lot No	String80	1	1
  Sublot No	String80	Null	Null
  Storage Ent Id	Int32	4	4
  Produced Item	String80	Item-A	Item-A
  Bom Position	Int32	Null	Null
  Segment Requirement ID	Null	Null
  Segment Response ID	Null	Null
  Job Position	Int32	0	0