Template:MP-appointments-cargo

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. 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 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. 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:

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: This template defines the table "mp_appointments". View table.

Usage — concurrent second minister: This template defines the table "mp_appointments". View table.

Usage — parliamentary role: This template defines the table "mp_appointments". View table.

Usage — acting minister: This template defines the table "mp_appointments". View table.