Legislative reform order: Lords procedure determination Business step

There are 24 steps.

Step	Actualisation count
Debate on motion to disagree with the procedure recommendation made by the Delegated Powers and Regulatory Reform Committee (DPRRC) (House of Lords)	0
Delegated Powers and Regulatory Reform Committee (DPRRC) agreed the instrument should follow the affirmative procedure (House of Lords)	0
Delegated Powers and Regulatory Reform Committee (DPRRC) agreed the instrument should follow the negative procedure (House of Lords)	0
Delegated Powers and Regulatory Reform Committee (DPRRC) agreed the instrument should follow the super-affirmative procedure (House of Lords)	0
Delegated Powers and Regulatory Reform Committee (DPRRC) recommended the instrument should be upgraded to the affirmative procedure (House of Lords)	0
Delegated Powers and Regulatory Reform Committee (DPRRC) recommended the instrument should be upgraded to the super-affirmative procedure (House of Lords)	0
Further information published by the Delegated Powers and Regulatory Reform Committee (DPRRC) (House of Lords)	0
Government response to the procedure recommendation by the Delegated Powers and Regulatory Reform Committee (DPRRC) (House of Lords)	0
House of Lords agreed to the affirmative procedure (House of Lords)	0
House of Lords agreed to the negative procedure (House of Lords)	0
House of Lords agreed to the super-affirmative procedure (House of Lords)	0
House resolved against committee procedure recommendation (House of Lords)	0
House resolved in favour of committee procedure recommendation (House of Lords)	0
Instrument withdrawn from the House of Lords (House of Lords)	0
Minister recommended the instrument follow the affirmative procedure	0
Minister recommended the instrument follow the negative procedure (House of Commons and House of Lords)	0
Minister recommended the instrument follow the super-affirmative procedure (House of Commons and House of Lords)	0
Motion to disagree with the procedure recommendation by the Delegated Powers and Regulatory Reform Committee (DPRRC) lapsed at end of session (House of Lords)	0
Motion to disagree with the procedure recommendation by the Delegated Powers and Regulatory Reform Committee (DPRRC) not moved (House of Lords)	0
Motion to disagree with the procedure recommendation by the Delegated Powers and Regulatory Reform Committee (DPRRC) withdrawn (House of Lords)	0
Motion to disagree with the procedure recommendation made by the Delegated Powers and Regulatory Reform Committee (DPRRC) tabled (House of Lords)	0
Procedure considered by the Delegated Powers and Regulatory Reform Committee (DPRRC) (House of Lords)	0
Procedure determination period ends	0
Question put on motion to disagree with the procedure recommendation made by the Delegated Powers and Regulatory Reform Committee (DPRRC) (House of Lords)	0

Procedure identifier

https://id.parliament.uk/meSrUdup

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:meSrUdup }

# 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:meSrUdup.}

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

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