Miscellaneous Changes

GMT Changed to UTC

References to GMT have been changed to UTC throughout the document (not including the appendices).

Tables with expiry_date Columns

The following tables were updated to replace the expiry_date column with expiry_date_utc and expiry_date_local columns:

• item_inv

• item_transfer

• transfer_list

In addition, the following tables were updated to replace the from_expiry_date column with from_expiry_date_utc and from_expiry_date_local columns:

• item_transfer

• transfer_list

In summary, the *_utc columns contain the expiry date and time in UTC, while the *_local columns contain the expiry date and time in the local time of the entity associated with the item inventory.

Additional Data Types Being Used

In Chapter 2: Definition of Data Types, the following data types were added to the mapping table:

• tdatetime2:datetime2

• time0:time(0)

• tsmalldatetime:smalldatetime

Also in this chapter, the italicized text shown below was added to following item to note:

• Whole numbers which are assigned sequentially by the system are shown as an ID data type. These are called identity columns in SQL Server. The number following "ID" is the starting value. All IDs are assumed to increment by one and never wrap around. They are handled as 32‑bit integer except in heavily inserted tables, for which they are defined as bigints.

Also in this chapter, the following items to note were added:

• Milliseconds are stripped from all datetime columns except labor usage.

• The smalldatetime data type is used to remove seconds from those columns using it (e.g., the effectivity dates for shift patterns).

• The datetime2(0) data type is used to store datetimes with no decimal values (i.e., YYYY-MM-DD hh:mm:ss).

• For definitions of the SQL Server data types listed here, see the Microsoft SQL Server online documentation.

Columns Changed to Data Type tdatetime2

The following columns have been changed to the data type tdatetime2:

• corr_action_log.event_time_utc

• data_log.sample_time_local

• data_log.sample_time_utc

• db_status.service_last_ran

• util_history.event_time_local

• util_history.event_time_utc

• util_shift_link.act_event_time_utc

• util_shift_link.event_time_local

• util_shift_link.event_time_utc

Columns Changed to Data Type tdatetime20

The following columns have been changed to the data type tdatetime20:

• lot.expiry_date

• sublot.expiry_date

Columns Changed to Data Type tdatetimems

The following columns have been changed to the data type tdatetimems:

• labor_usage.labor_start_local

• labor_usage.labor_start_utc

Columns Changed to Data Type tsmalldatetime

The following columns have been changed to the data type tsmalldatetime:

• bom_ver.start_eff

• bom_ver.end_eff

• cert_user_link.expiry

• qm_spec.start_eff_local

• qm_spec.start_eff_utc

• qm_spec.end_eff_local

• qm_spec.end_eff_utc

last_edit_comment Columns Changed to Data Type notes

The last_edit_comment columns in the following tables have been changed to the data type notes:

• bottleneck_history

• cert_audit_log

• corr_action_log

• data_entry_log

• data_log

• db_maint_history

• item_cons

• item_inv

• item_prod

• job_exec

• job_event

• job_history

• job_hour_history

• job_step_data

• labor_usage

• prod_rate_history

• qm_context

• rejected_message

• result

• result_attr

• sample

• sample_attr

• sample_char_link

• sample_char_link_to_go

• sample_to_go

• shift_history

• util_exec

• util_history

• util_shift_link