
Content of the technical package:
=================================

File                                                                                                                                                                    Description
----                                                                                                                                                                    -----------
39797.227.NATIONAL - ELOG-Logbook-Herring,Mackerel,Smelt,Alewife,Capelin - JBE-Journal de bord-Hareng,Maquereau,Éperlan,Gaspareau,Capelan.csv :                         CSV file containing the basic structure of the XML file associated to the National Herring,Mackerel,Smelt,Alewife and Capelin form (form_version_id 227)

39797.227.NATIONAL - ELOG-Logbook-Herring,Mackerel,Smelt,Alewife,Capelin - JBE-Journal de bord-Hareng,Maquereau,Éperlan,Gaspareau,Capelan.xlsx :                        Excel file containing the basic structure of the XML file associated to the National Herring,Mackerel,Smelt,Alewife and Capelin form. Some columns are hidden. 
                                                                                                                                                                        Look at Worksheet "Readme-Lisezmoi" for more details about columns.

39797.227.NATIONAL - ELOG-Logbook-Herring,Mackerel,Smelt,Alewife,Capelin - JBE-Journal de bord-Hareng,Maquereau,Éperlan,Gaspareau,Capelan_20221019 000000.xsd :         XSD file of the National Herring,Mackerel,Smelt,Alewife and Capelin form (form_version_id 227)

FS-NAT-227-4-EN.pdf :                                                                                                                                                   English version of the National Herring,Mackerel,Smelt,Alewife and Capelin form fact sheet (form_version_id 227)
FS-NAT-227-4-FR.pdf :                                                                                                                                                   French version of the National Herring,Mackerel,Smelt,Alewife and Capelin form fact sheet (form_version_id 227)

DFO instructions_NAT_227-2.0_fre.pdf :                                                                                                                                  French version of the document "DFO Instructions" 
DFO instructions_NAT_227-2.0_eng.pdf :                                                                                                                                  English version of the document "DFO Instructions"

NAT - Structure XML Hareng, Maquereau, Éperlan, Gaspareau et Capelan - Herring, Mackerel, Smelt, Alewife and Capelin XML Structure.pdf :                                Diagram representing the structure of the National Herring,Mackerel,Smelt,Alewife and Capelin form (form_version_id 227)

Subforms_requirements.xlsx:                                                                                                                                             Subforms requirements (English version)
Sous-formulaires_exigences.xlsx:                                                                                                                                        Subforms requirements (French version)



         
         
MODIFICATIONS:
==============================================================================================================
2021-10-21:
Creation of the technical package related to the National "Herring,Mackerel,Smelt,Alewife and Capelin" form - Initial Version
==============================================================================================================

2021-11-04

FS-NAT-227-2-FR.pdf and FS-NAT-227-2-EN.pdf:
     - Section "Client group" of the fact sheet removed.
     - Modification of sub-forms naming (standardization)

Sous-formulaires_exigences.xlsx and Subforms_requirements.xlsx:
     - Modification of sub-forms naming (standardization)
==============================================================================================================
2022-01-14

Replaced dummy version of the DFO instructions documents by the official version.
==============================================================================================================
2022-01-31

FS-NAT-227-3-FR.pdf and FS-NAT-227-3-EN.pdf:
     - Addition of rule #931 (label of FIN)
==============================================================================================================
2022-10-19

Fact sheets: FS-NAT-227-4-FR.pdf and FS-NAT-227-4-EN.pdf:
     - Addition of rule #302 (Effort_detail.Wtr_srf_temp added)
     - Addition of rule #968 (Effort_detail.Fish_sz_id)
     - Addition of rule #969 (Catch.Sblgl_disc_wt)
     - Withdrawal of species 1299-Flatfishes not specified and 808-Groundfish from Appendix F which are considered too general.
     - Addition of species White hake, Yellowtail flounder and Witch flounder in Appendix F
     - Added species “Birds” in Appendix F for sub-forms 34 and 36 (PAC)
     - Withdrawal of species “Other” from Appendix F for sub-form 35
     - Addition of rule #970 (Catch.Spcmn_cght_wt)
     - Addition of rule #971 (Catch.Kept_wt,Catch.Nb_spcmn_kept,Nb_spcmn_disc)
     - Withdrawal of rule #850 (Landing_dtl.From_pnd_num,Landing_dtl.Est_wt_land_from_pnd)
     - Addition of rule #972 (Landing_dtl.From_pnd_num,Landing_dtl.Est_wt_land_from_pnd)
     - Withdrawal of element Transfer.From_tow_num from rule #841
     - Withdrawal of rule #845 (Transfer.Released_at_sea_ind) – was unnecessary
     - Text of section 5.1 modified.
     - Rule 830 splitted in rules #830a, 830b and 830c (830b new rule)
     - New version of DFO instructions (rel. 2)


XSD (39797.227.NATIONAL - ELOG-Logbook-Herring,Mackerel,Smelt,Alewife,Capelin - JBE-Journal de bord-Hareng,Maquereau,Éperlan,Gaspareau,Capelan_20221019 000000.xsd):
     - Withdrawal of Trip.Hrvstr_phone
     - Addition of Trip.Contact_phone
     - Addition of Trip.Oper_phone
     - Withdrawal of node Rsn_not_fish
     - Effort.Start_dt becomes Mandatory
     - Effort.End_dt becomes Mandatory
     - Addition of Effort_by_gear.Gear_len
     - Addition of Effort_detail.Wtr_srf_temp
     - Addition of Effort_detail.Wthr_cond_id
     - Addition of Effort_detail.Fish_dens_id
     - Addition of Effort_detail.Fish_sz_id
     - Addition of Effort_detail.Spawn_ind
     - Addition of Effort_detail.Nb_gear_hld_catch
     - Addition of Catch.Sblgl_disc_wt
     - Addition of Catch.Encounter_typ_id
     - Withdrawal of Catch.Spcmn_cond_id
     - Withdrawal of Effort_detail.Dist_to_pnd
     - Landing_dtl.Est_wt_land_from_pnd becomes Mandatory
     - Landing_dtl.Est_wt_land_from_sets becomes Mandatory
     - Addition of Transfer.Tow_time_from_set_to_pnd
     - Addition of Transfer.Tow_dist_from_set_to_pnd

XML Structure (NAT - Structure XML Hareng, Maquereau, Éperlan, Gaspareau et Capelan - Herring, Mackerel, Smelt, Alewife and Capelin XML Structure.pdf ): 
     - Update of the contents of many boxes
     - Withdrawal of data groups not used by this form

Form: 39797.227.NATIONAL - ELOG-Logbook-Herring,Mackerel,Smelt,Alewife,Capelin - JBE-Journal de bord-Hareng,Maquereau,Éperlan,Gaspareau,Capelan.csv (and xlsx)
     - Withdrawal of Trip.Hrvstr_phone
     - Addition of Trip.Contact_phone
     - Addition of Trip.Oper_phone
     - Withdrawal of node Rsn_not_fish
     - Effort.Start_dt becomes Mandatory
     - Effort.End_dt becomes Mandatory
     - Addition of Effort_by_gear.Gear_len
     - Addition of Effort_detail.Wtr_srf_temp
     - Addition of Effort_detail.Wthr_cond_id
     - Addition of Effort_detail.Fish_dens_id
     - Addition of Effort_detail.Fish_sz_id
     - Addition of Effort_detail.Spawn_ind
     - Addition of Effort_detail.Nb_gear_hld_catch
     - Addition of Catch.Sblgl_disc_wt
     - Addition of Catch.Encounter_typ_id
     - Withdrawal of Catch.Spcmn_cond_id
     - Withdrawal of Effort_detail.Dist_to_pnd
     - Landing_dtl.Est_wt_land_from_pnd becomes Mandatory
     - Landing_dtl.Est_wt_land_from_sets becomes Mandatory
     - Addition of Transfer.Tow_time_from_set_to_pnd
     - Addition of Transfer.Tow_dist_from_set_to_pnd
     - Some "display order" have been modified.
     - Some of the descriptions have been updated.

Subforms requirements: Subforms_requirements.xlsx and Sous-formulaires_exigences.xlsx: 
     - New version of these files
==============================================================================================================
2024-02-01

XSD:
     - change value of string_100 to 100
     - remove definition of air_temp
     - remove regex pattern from wtr_srf_temp elements
     - remove whitespace after element name SNR_ON_DT

Subform Requirements renamed to include 227:
     Subforms_requirements_227.xlsx                                                                                                                                             Subforms requirements (English version)
     Sous-formulaires_exigences_227.xlsx     

Fact sheets: FS-NAT-227-5-FR.pdf and FS-NAT-227-5-EN.pdf:
     - Removal of rule #1502 – RSN_NOT_FISH not part of form
     - Removal of rule #1017 – RSN_NOT_FISH not part of form
     - Removal of node RSN_NOT_FISH from rules #601, #823 and #824
     - Rule 2500: New version of the “DFO instructions” documents (v. 2.1)

DFO Instructions: DFO instructions_NAT_227-2.1_eng.pdf & DFO instructions_NAT_227-2.1_fre.pdf
- New version 2.1 (to correct Table of Contents)

==============================================================================================================
2024-03-12

Sous-formulaires-exigences_227.xlsx and Subforms_requirements_227.xlsx
    - the elements of the HLIN and HLOUT nodes are now available and no longer blocked for subform 32

Fact sheets: FS-NAT-227-6-FR.pdf and FS-NAT-227-6-EN.pdf:
   - Rule 2500: New version of the “DFO instructions” documents (v. 2.2)

DFO Instructions: DFO instructions_NAT_227-2.1_eng.pdf & DFO instructions_NAT_227-2.1_fre.pdf
   - New version 2.2 (to provide clarification of Transfer Detail - logbook)


==============================================================================================================
2026-01-14

XSD:
- remove maxInclusive from dates