Template:MP-appointments-cargo: Difference between revisions

From PoliticalSG
VisualWikitext
No edit summary
No edit summary
 
Line 1: Line 1:
{{#cargo_declare:_table=mp_appointments
<noinclude>{{#cargo_declare:_table=mp_appointments
|appointment_id=String
|appointment_id=String
|mp_id=String
|mp_id=String
Line 9: Line 9:
|verified=String
|verified=String
|last_updated=Date
|last_updated=Date
}}<noinclude>
}}</noinclude><includeonly>{{#cargo_store:_table=mp_appointments
|appointment_id={{{appointment_id|}}}
|mp_id={{{mp_id|}}}
|role_title={{{role_title|}}}
|ministry_id={{{ministry_id|}}}
|start_date={{{start_date|}}}
|end_date={{{end_date|}}}
|parliament_no={{{parliament_no|}}}
|verified={{{verified|}}}
|last_updated={{{last_updated|}}}
}}</includeonly>
<noinclude>
Stores one appointment per instance.
Stores one appointment per instance.
An MP with multiple roles gets multiple instances
An MP with multiple roles gets multiple instances
of this template, one per appointment.
of this template, one per appointment.
Each appointment is independent with its own
start and end date regardless of other concurrent appointments.


appointment_id format: mp_id + role + ministry_id + start_year
appointment_id format: mp_id + role + ministry_id + start_year
Line 22: Line 31:


Leave ministry_id blank for parliamentary roles.
Leave ministry_id blank for parliamentary roles.
ministry_id must reference a valid entry in ministries table.
mp_id must reference a valid entry in mp_profiles table.
Leave end_date blank if appointment is current.


Valid role_title values:
Valid role_title values:
Line 61: Line 67:
|last_updated=2026-05-16
|last_updated=2026-05-16
}}
}}
 
</noinclude>
Usage — concurrent second minister:
{{MP-appointments-cargo
|appointment_id=lawrence-wong-second-minister-mindef-2021
|mp_id=lawrence-wong
|role_title=Second Minister
|ministry_id=mindef
|start_date=2021-05-15
|end_date=2022-05-15
|parliament_no=14
|verified=yes
|last_updated=2026-05-16
}}
 
Usage — parliamentary role:
{{MP-appointments-cargo
|appointment_id=pritam-singh-leader-of-opposition-2020
|mp_id=pritam-singh
|role_title=Leader of Opposition
|ministry_id=
|start_date=2020-08-24
|end_date=
|parliament_no=14
|verified=yes
|last_updated=2026-05-16
}}
 
Usage — acting minister:
{{MP-appointments-cargo
|appointment_id=chan-chun-sing-acting-minister-mti-2018
|mp_id=chan-chun-sing
|role_title=Acting Minister
|ministry_id=mti
|start_date=2018-01-04
|end_date=2018-04-30
|parliament_no=13
|verified=yes
|last_updated=2026-05-16
}}
</noinclude>{{#cargo_store:_table=mp_appointments
|appointment_id={{{appointment_id|}}}
|mp_id={{{mp_id|}}}
|role_title={{{role_title|}}}
|ministry_id={{{ministry_id|}}}
|start_date={{{start_date|}}}
|end_date={{{end_date|}}}
|parliament_no={{{parliament_no|}}}
|verified={{{verified|}}}
|last_updated={{{last_updated|}}}
}}

Latest revision as of 08:58, 16 May 2026

This template defines the table "mp_appointments". View table.

Stores one appointment per instance. An MP with multiple roles gets multiple instances of this template, one per appointment.

appointment_id format: mp_id + role + ministry_id + start_year e.g. lawrence-wong-minister-mof-2021 e.g. pritam-singh-leader-of-opposition-2020 e.g. baey-yam-keng-sps-mot-2018

Leave ministry_id blank for parliamentary roles.

Valid role_title values:

Cabinet and Executive: Prime Minister Deputy Prime Minister Senior Minister Coordinating Minister Minister Acting Minister Second Minister Senior Minister of State Minister of State Senior Parliamentary Secretary Parliamentary Secretary

Parliamentary: Speaker Deputy Speaker Leader of the House Deputy Leader of the House Leader of Opposition Government Whip

Usage — cabinet appointment:


Retrieved from "https://politicalsg.com/index.php?title=Template:MP-appointments-cargo&oldid=4840"