Document toolboxDocument toolbox

9.2.1.x

Change History

Document Version

Date

Author(s)

Summary of Changes

9.2.1.02015-10-26Wendy Swann

Added definition of TZ for dates/times in sp620_special_periods and sp621_special_periods_history.

9.2.1.02015-10-26Wendy Swann

Updated & corrected definitions for sp116_break_specifications and sp641_break_overrides.

9.2.1.02015-10-26Wendy Swann

Clarified timezone used for timestamp in sp500_gantt_audit.

9.2.1.02015-10-26Wendy Swann

Removed mention of sysdate and replaced with alternative wording.

9.2.1.02015-10-26Wendy Swann

Update sp057 definition of lat1, lon1 etc for top left, bottom right rather than bottom left, top right.

9.2.1.02015-10-26Wendy Swann

Added requirement for VARCHAR2 sizes to be specified as CHAR in support of Unicode/UTF8.

9.2.1.02015-10-26Wendy Swann

Increased size of field_id in sp900 and all related tables to 100.

9.2.1.02015-10-26Wendy Swann

Noted that resp_unit_ref and region_ref are restricted to non-wide characters as a temporary restriction.