wrongdoing.yaml

dataset_type: wrongdoing
target_dataset: wrongdoing
title: Proactive Publication - Acts of Founded Wrongdoing
shortname: Acts of Founded Wrongdoing
notes: Access, upload and modify the Acts of Founded Wrongdoing reports for your organization

template_version: 3
template_updated: 2020-02-17

portal_type: info
collection: pd

resources:
- title: Proactive Publication - Founded Wrongdoing
  resource_name: wrongdoing

  published_resource_id: 84a77a58-6bce-4bfb-ad67-bbe452523b14

  create_form: true
  edit_form: true
  fields:

  - datastore_id: ref_number
    label:
      en: Reference Number
      fr: Numéro de référence
    description:
      en: This field is populated by the user. It is a unique reference number given to each line item in the spreadsheet. Having a unique identifier for each item will allow users locate a specific item in the registry should they need to modify or delete.
      fr: Cette zone est remplie par chaque organisation. Un identificateur unique est attribué à chaque poste dans le tableur. Un identificateur unique pour chaque poste permettra aux utilisateurs de repérer un article en particulier s’ils doivent le modifier ou le supprimer.
    obligation: Mandatory
    excel_required: true
    form_required: true
    format_type:
      en: "FW-2015-Q1-00001 – this sequence will continue for each line item (i.e.: FW-2015-Q1-00001, FW-2015-Q1-00002, FW-2015-Q1-00001….)"
      fr: FW-2016-Q1-00001 – cette séquence se poursuivra pour chaque poste (c.-à-d. FW-2016-Q1-00001, FW-2016-Q1-00002, FW-2016-Q1-00003….)
    datastore_type: text

  - datastore_id: file_id_number
    label:
      en: File Identification Number
      fr: Numéro d’identification du fichier
    description:
      en: This field will contain the file identification number of the founded wrongdoing file.
      fr: Cette zone renferme le numéro d’identification du dossier de l’acte répréhensible constaté.
    obligation: Mandatory
    excel_required: true
    form_required: true
    format_type: Free text
    datastore_type: text

  - datastore_id: file_id_date
    label:
      en: File Identification date
      fr: Date d’identification du ficher
    description:
      en: This field will provide the date that the file was created/received.
      fr: Cette zone renferme la date à laquelle le dossier a été créé ou reçu.
    obligation: Mandatory
    excel_required: true
    form_required: true
    format_type: Date (Please format the data as YYYY-MM-DD)
    datastore_type: date
    extract_date_year: true
    extract_date_month: true
    extract_date_clean: true
    form_snippet: scheming/form_snippets/date.html

  - datastore_id: case_description_en
    label:
      en: English Case Description
      fr: Description anglaise
    description:
      en: The field will contain the case description, in English.
      fr: Cette zone renferme la description du cas en anglais.
    obligation: Mandatory
    excel_required: true
    form_required: true
    format_type: Free text
    datastore_type: text
    form_attrs:
      size: 60

  - datastore_id: case_description_fr
    label:
      en: French Case Description
      fr: Description française
    description:
      en: This field will contain the case description, in French.
      fr: Cette zone renferme la description du cas en français.
    obligation: Mandatory
    excel_required: true
    form_required: true
    format_type: Free text
    datastore_type: text
    form_attrs:
      size: 60

  - datastore_id: findings_conclusions
    label:
      en: Findings and Conclusions
      fr: Constatations et Conclusions
    description:
      en: The field will contain value(s) a – f, separated by commas if more than one value.
      fr: Le champ contiendra une (des) valeur(s) a – f, séparées par une virgule s´il y en a plus d´une.
    obligation: Mandatory
    excel_required: true
    form_required: true
    format_type: Controlled List
    occurrence: Repeatable
    datastore_type: _text
    excel_full_text_choices: false
    form_snippet: scheming/form_snippets/multiple_checkbox.html
    choices:
      a:
        en: a contravention of any Act of Parliament or of the legislature
            of a province, or of any regulations made under any such Act,
            other than a contravention of section 19 of this Act
        fr: la contravention d’une loi fédérale ou provinciale ou d’un
            règlement pris sous leur régime, à l’exception de la
            contravention de l’article 19 de la présente loi
      b:
        en: a misuse of public funds or a public asset
        fr: l’usage abusif des fonds ou des biens publics
      c:
        en: a gross mismanagement in the public sector
        fr: les cas graves de mauvaise gestion dans le secteur public
      d:
        en: an act or omission that creates a substantial and specific
            danger to the life, health or safety of persons, or to the
            environment, other than a danger that is inherent in the
            performance of the duties or functions of a public servant
        fr: le fait de causer — par action ou omission — un risque grave
            et précis pour la vie, la santé ou la sécurité humaines ou
            pour l’environnement, à l’exception du risque inhérent à
            l’exercice des attributions d’un fonctionnaire
      e:
        en: a serious breach of a code of conduct established under
            section 5 or 6
        fr: la contravention grave d’un code de conduite établi en vertu
            des articles 5 ou 6
      f:
        en: knowingly directing or counselling a person to commit a
            wrongdoing set out in any of paragraphs (a) to (e)
        fr: le fait de sciemment ordonner ou conseiller à une personne
            de commettre l’un des actes répréhensibles visés aux alinéas
            a) à e)

  - datastore_id: recommendations_corrective_measures_en
    label:
      en: English Recommendations and Corrective Measures
      fr: Recommendations et mesures Correctives anglaises
    excel_heading:
      en: |
        English Recommendations and
        Corrective Measures
      fr: |
        Recommendations et mesures
        Correctives anglaises
    description:
      en: The Field will contain the Recommendations and Corrective Measures as per the article 11 of the Public Servants Disclosure Protection Act, in English.
      fr: Cette zone renferme les recommandations et mesures correctives en anglais, en conformité à l’article 11 de la Loi sur la protection des fonctionnaires divulgateurs d’actes répréhensibles.
    obligation: Mandatory
    excel_required: true
    form_required: true
    format_type: Free text
    datastore_type: text
    form_snippet: scheming/form_snippets/textarea.html
    form_attrs:
      style: "width: 100%; display: block"

  - datastore_id: recommendations_corrective_measures_fr
    label:
      en: French Recommendations and Corrective Measures
      fr: Recommendations et mesures Correctives françaises
    excel_heading:
      en: |
        French Recommendations and
        Corrective Measures
      fr: |
        Recommendations et mesures
        Correctives françaises
    description:
      en: The Field will contain the Recommendations and Corrective Measures as per the article 11 of the Public Servants Disclosure Protection Act, in French.
      fr: Cette zone renferme les recommandations et mesures correctives en français, en conformité à l’article 11 de la Loi sur la protection des fonctionnaires divulgateurs d’actes répréhensibles.
    obligation: Mandatory
    excel_required: true
    form_required: true
    format_type: Free text
    datastore_type: text
    form_snippet: scheming/form_snippets/textarea.html
    form_attrs:
      style: "width: 100%; display: block"

  - datastore_id: record_created
    label: Record Creation Time
    import_template_include: false
    visible_to_public: false
    datastore_type: timestamp
    preview_class: bg-info

  - datastore_id: record_modified
    label: Last Record Modification Time
    import_template_include: false
    visible_to_public: false
    datastore_type: timestamp
    preview_class: bg-info

  - datastore_id: user_modified
    label: User Last Modified Record
    import_template_include: false
    visible_to_public: false
    datastore_type: text
    preview_class: bg-info

  datastore_primary_key: [ref_number]
  datastore_indexes: ""

  triggers:
  - wrongdoing_trigger: |
      DECLARE
        errors text[][] := '{{}}';
        crval RECORD;
      BEGIN
        errors := errors || required_error(NEW.ref_number, 'ref_number');
        IF NEW.ref_number LIKE '%,%' THEN
          errors := errors || ARRAY[['ref_number', {ref_number_error}]];
        END IF;
        errors := errors || required_error(NEW.file_id_number, 'file_id_number');
        errors := errors || required_error(NEW.case_description_en, 'case_description_en');
        errors := errors || required_error(NEW.case_description_fr, 'case_description_fr');
        crval := choices_clean_error(NEW.findings_conclusions, {findings_conclusions}, 'findings_conclusions');
        errors := errors || crval.error;
        NEW.findings_conclusions := crval.clean;
        errors := errors || required_error(NEW.recommendations_corrective_measures_en, 'recommendations_corrective_measures_en');
        errors := errors || required_error(NEW.recommendations_corrective_measures_fr, 'recommendations_corrective_measures_fr');

        IF errors = '{{}}' THEN
          RETURN NEW;
        END IF;
        RAISE EXCEPTION E'TAB-DELIMITED\t%', array_to_string(errors, E'\t');
      END;


  - update_record_modified_created_trigger

  trigger_strings:  # yaml | not supported
    ref_number_error: Comma is not allowed in Reference Number field

  examples:
    record:
      ref_number: "1980198"
      file_id_number: "15677"
      file_id_date: "2016-01-01"
      case_description_en: 'Description'
      case_description_fr: 'Description'
      findings_conclusions: [b]
      recommendations_corrective_measures_en: 'Recommendations and Corrective Measures'
      recommendations_corrective_measures_fr: 'Recommandations et mesures correctives'
    filters:
      findings_conclusions: b
    filter_one:
      ref_number: "1980198"
    sort: file_id_date desc

excel_edge_style:
  PatternFill:
    patternType: solid
    fgColor: FF4E4741
excel_header_style:
  PatternFill:
    patternType: solid
    fgColor: FFC1D699
excel_column_heading_style:
  PatternFill:
    patternType: solid
    fgColor: FFC1D699