Difference between revisions of "Effects Spreadsheet"
| Line 37: | Line 37: | ||
===C - Affected Provision(s)=== | ===C - Affected Provision(s)=== | ||
| − | The affected provision(s) is the provision of the legislation to which | + | The affected provision(s) is the provision of the legislation to which an amendment will be applied. |
The affected provision column can be populated with a range of the type of legislation, | The affected provision column can be populated with a range of the type of legislation, | ||
Revision as of 09:57, 25 June 2019
To update
Column Groupings
Extent
Columns E-J
Amending
Commencement
Additional PiTs
Columns Z onward:
Explain the first set - talk through and then put they are all the same after that.
Notes for Editor
Column
Column overview
A - Effect ID
The Effect ID is automatically generated and is a protected column in the spreadsheet. If you try to enter data in this column, a pop-up will state "Do not change effect IDs. When you create a new effect, leave the ID blank. A new ID will be automatically created for it." Select cancel in this pop-up.
The effect ID is the unique group of numbers and letters that you normally see in XMetaL after the opening "ukl:Commentary" tag of an amendment's annotation.
You do not need to do anything with this column.
B - Affected Legislation
The affected legislation is the primary or secondary piece of legislation to which an amendment will be applied.
The affected legislation column will be populated with the year, number and type of legislation. The preparation task Record Effects' guidance on Affected and Affecting Legislation lists the different types of legislation and their corresponding formatting that you should expect to see in this column.
When completing the Record Effects task, there may be several different pieces of legislation in this column as the spreadsheet records every piece of legislation affected by the legislation whose effects have been identified in the prior preparation task, Identify Effects task.
In contrast, when completing the Research Effects and Update tasks, there will only be one piece of legislation in this column as the spreadsheet only contains the effects information which affect the piece of legislation you are researching/updating.
C - Affected Provision(s)
The affected provision(s) is the provision of the legislation to which an amendment will be applied.
The affected provision column can be populated with a range of the type of legislation,
the year, number and type of legislation. The preparation task Record Effects' guidance on Affected and Affecting Legislation lists the different types of legislation and their corresponding formatting that you should expect to see in this column.
When completing the Record Effects task, there may be several different pieces of legislation in this column as the spreadsheet records every piece of legislation affected by the legislation whose effects have been identified in the prior preparation task, Identify Effects task.
In contrast, when completing the Research Effects and Update tasks, there will only be one piece of legislation in this column as the spreadsheet only contains the effects information which affect the piece of legislation you are researching/updating.
To begin with, therefore, we should always cite provisions right down to the lowest, numbered (or lettered as the case may be) affected or affecting provision or sub-provision mentioned by the drafter. (The only exceptions to this rule occur when dealing with Tables and Forms). For text affected within a provision or sub-provision, we cannot specify below this level in the affected provision column so instead we qualify the Type of Effect: for example, “word inserted”, “words substituted” or “words repealed”. For example, where some words contained in an unnumbered entry in a repeal schedule (e.g. Sch. 10 Pt. 2) have been substituted, the affected provision should be “Sch. 10 Pt. 02” (the lowest, numbered provision available) and the type of effect would be “words substituted”.
When entering affected provisions you should do so from the point of view of the result of the effect. For example, where a provision is being renumbered (e.g. where s. 12 is being renumbered as s. 12(1)) then the result of the renumbering (s. 0012(01)) should be entered as the affected provision. Another example would be where an unequal substitution of provisions was taking place (e.g. where s. 10 was being substituted for the existing ss. 10-10C). In this case:
the affected provision = the result of the substitution (s. 0010) the type of effect = what had happened to the old provisions (“substituted for s. 10-10C”).
Only where a range of provisions is indicated as affected in the legislation (e.g. s. 0010-0015) or when consecutive provisions are being inserted or substituted (e.g. s. 0001A 0001B) should more than one provision be entered on a single line. This rule also applies to sub-provisions (e.g. amendments to s. 0001(02)-(05) or s. 0001(01)(02)(03) are allowed on one line, but amendments to s. 0001(02), s. 0001(04) and s. 0001(06) should be split across three lines).
When provisions have to be cited as Affecting Provisions, they too should be entered in the singular: e.g. art. 001 002 (not arts. 001 002) and reg. 001-003 (not regs. 001-003). However, it will frequently occur that non-consecutive affecting provisions will have to be entered on the same line and this is perfectly acceptable.
Where the affected provision has been drafted in the legislation as an Act or a Part or even a range of provisions, but excluding certain provisions (for example, an “Act (except sections 1, 13, 25 and Schedule 1)” is repealed), we should enter the affected provision as drafted e.g. “Act” and stipulate those provisions excluded from the amendment in Comments for Editor (e.g. “except sections 1, 13, 25 and Schedule 1”). The type of effect should also be qualified with “in part”. So in this example the Act would be “repealed in part”.