Legislative reform order: Draft negative Business step

There are 38 steps.

Step	Actualisation count
Chamber debate (House of Lords)	0
Debate on motion to refer the instrument to a Delegated Legislation Committee (DLC) (House of Commons)	0
Decision on motion (prayer) to stop the instrument becoming law deferred (House of Commons)	0
Decision on motion to refer the instrument to a Delegated Legislation Committee (DLC) deferred (House of Commons)	0
Decision on non-fatal motion (prayer) to object to the instrument deferred (House of Commons)	0
Instrument has been determined to follow the negative procedure (House of Commons and House of Lords)	0
Instrument withdrawn from the House of Commons (House of Commons)	0
Motion (prayer) to stop the instrument becoming law approved (House of Commons)	0
Motion (prayer) to stop the instrument becoming law approved (House of Lords)	0
Motion (prayer) to stop the instrument becoming law lapsed at end of session (House of Commons)	0
Motion (prayer) to stop the instrument becoming law not called (House of Commons)	0
Motion (prayer) to stop the instrument becoming law not moved (House of Commons)	0
Motion (prayer) to stop the instrument becoming law rejected (House of Commons)	0
Motion (prayer) to stop the instrument becoming law rejected (House of Lords)	0
Motion (prayer) to stop the instrument becoming law tabled (House of Commons)	0
Motion (prayer) to stop the instrument becoming law withdrawn (House of Commons)	0
Motion to refer the instrument to a Delegated Legislation Committee (DLC) approved (House of Commons)	0
Motion to refer the instrument to a Delegated Legislation Committee (DLC) lapsed at end of session (House of Commons)	0
Motion to refer the instrument to a Delegated Legislation Committee (DLC) not called (House of Commons)	0
Motion to refer the instrument to a Delegated Legislation Committee (DLC) not moved (House of Commons)	0
Motion to refer the instrument to a Delegated Legislation Committee (DLC) rejected (House of Commons)	0
Motion to refer the instrument to a Delegated Legislation Committee (DLC) tabled by the Government (House of Commons)	0
Motion to refer the instrument to a Delegated Legislation Committee (DLC) withdrawn (House of Commons)	0
Non-fatal motion (prayer) to object to the instrument approved (House of Commons)	0
Non-fatal motion (prayer) to object to the instrument approved (House of Lords)	0
Non-fatal motion (prayer) to object to the instrument lapsed at end of session (House of Commons)	0
Non-fatal motion (prayer) to object to the instrument not called (House of Commons)	0
Non-fatal motion (prayer) to object to the instrument not moved (House of Commons)	0
Non-fatal motion (prayer) to object to the instrument rejected (House of Commons)	0
Non-fatal motion (prayer) to object to the instrument rejected (House of Lords)	0
Non-fatal motion (prayer) to object to the instrument tabled (House of Commons)	0
Non-fatal motion (prayer) to object to the instrument withdrawn (House of Commons)	0
Objection period ends	0
Question on motion (prayer) to stop the instrument becoming law put (House of Commons)	0
Question on motion (prayer) to stop the instrument becoming law put (House of Lords)	0
Question on motion to refer the instrument to a Delegated Legislation Committee (DLC) put (House of Commons)	0
Question on non-fatal motion (prayer) to object to the instrument put (House of Commons)	0
Question on non-fatal motion (prayer) to object to the instrument put (House of Lords)	0

Procedure identifier

https://id.parliament.uk/0g8JqRKX

SPARQL queries used by this page

A list of steps of a type within a procedure

# We declare the Parliament and ID namespaces.
PREFIX : <https://id.parliament.uk/schema/>
PREFIX id: <https://id.parliament.uk/>

# We select the properties we want to appear in results. If all properties are required, an asterisk can be used between SELECT and WHERE instead of listing properties.
SELECT DISTINCT ?procedure ?procedureName ?stepType ?stepTypeLabel ?step ?stepName ?legislature ?legislatureName ?commonsId ?lordsId (COALESCE(?rawBiCount, 0) AS ?biCount) WHERE {

# We set the value of the procedure property.   
VALUES ?procedure { id:0g8JqRKX }

# We specify that the procedure property is a procedure and look for its name.   
?procedure a :Procedure;
:name ?procedureName.

# We look for all procedure routes and the steps in those routes, including whether they are a From step or a To step. The pipe in line 17 is a SPARQL OR.  
?procedure :procedureHasProcedureRoute ?route.
?route :procedureRouteIsFromProcedureStep|:procedureRouteIsToProcedureStep ?step.

# We specify the procedure step must have a name, a step type and that the step type also has a name.   
?step :name ?stepName.
?step :procedureStepHasProcedureStepType ?stepType.
?stepType :name ?stepTypeLabel.

# We limit steps to being only of the type 'Business step'.
FILTER (?stepType in (id:Jwc6nqJi))

# We check to see if the step belongs to a legislature. A legislature will be Scottish Parliament, Senedd Cymru or the Northern Ireland Assembly.   
OPTIONAL {?step :procedureStepInLegislature ?legislature .
?legislature :name ?legislatureName .}

# We check to see if the step belongs to the House of Commons.     
OPTIONAL {?step :procedureStepHasHouse ?commonsId .
FILTER (?commonsId = id:1AFu55Hs)}

# We check to see if the step belongs to the House of Lords.   
OPTIONAL {?step :procedureStepHasHouse ?lordsId .
FILTER (?lordsId = id:WkUWUBMx)}

# We specify an optional subquery which calculates the number of distinct business items that actualise a steps from the procedure. We make it optional because not every step will be actualised in a business item.   
OPTIONAL {
SELECT ?step (COUNT(DISTINCT ?bi) AS ?rawBiCount)
WHERE {
# We find business items actualising the step. 
?step :procedureStepHasBusinessItem ?bi .

# We find the work package each business item belongs to.
?bi :businessItemHasWorkPackage ?wp.

# We specify that the work packages must have the procedure. 
?wp :workPackageHasProcedure id:0g8JqRKX.}

# We group the results by step.    
GROUP BY ?step}
}

# We order the results by step name. 
ORDER BY ?stepName