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

File                                                                                                      Description
----                                                                                                      -----------
43244.229.NATIONAL - ELOG - Logbook  Shrimp - JBE - Journal de bord  Crevette.csv :                     CSV file containing the basic structure of the XML file associated to the National Shrimp (excluding offshores) form (form_version_id 229)

43244.229.NATIONAL - ELOG - Logbook  Shrimp - JBE - Journal de bord  Crevette.xlsx :                    Excel file containing the basic structure of the XML file associated to the National Shrimp (excluding offshores) form. Some columns are hidden. 
                                                                                                          Look at Worksheet "Readme-Lisez-moi" for more details about columns.

43244.229.NATIONAL - ELOG - Logbook  Shrimp - JBE - Journal de bord  Crevette_20220713 000000.xsd :     XSD file of the National Shrimp (excluding offshores) form (form_version_id 229)

FS-NAT-229-5-EN.pdf :                                                                                     English version of the National Shrimp (excluding offshores) form fact sheet (form_version_id 229)
FS-NAT-229-5-FR.pdf :                                                                                     French version of the National Shrimp (excluding offshores) form fact sheet (form_version_id 229)

Subforms_requirements_229.xlsx:                                                                           File that contains the requirements for each subforms of the main form (form_version_id 229) - English version. This document is referred by document FS-NAT-229-1-EN.pdf
Sous-formulaires_exigences_229.xlsx:                                                                      File that contains the requirements for each subforms of the main form (form_version_id 229) - French version. This document is referred by document FS-NAT-229-1-FR.pdf

DFO instructions_NAT_229-1.2_fre.pdf :                                                                    French version of the document "DFO Instructions" 
DFO instructions_NAT_229-1.2_eng.pdf :                                                                    English version of the document "DFO Instructions"

NAT - Structure XML Crevette (excluant pche hauturire) - Shrimp (excluding offshores) XML Structure.pdf:Diagram representing the structure of the National Shrimp (excluding offshores) form (form_version_id 229)





         
         
MODIFICATIONS:
==============================================================================================================
2021-07-13:
Creation of the technical package related to the National "Shrimp (excluding offshores)" form - Initial Version
==============================================================================================================

2021-08-30
Replaced "HLIN..." by "HLOUT...." in bloc HLOUT of the powerpoint document (NAT - Structure XML Crevette (excluant pche hauturire) - Shrimp (excluding offshores) XML Structure.pdf)
Replaced statement "Meaning of requirements" by "Significations des exigences" in document Sous-formulaires_exigences.xlsx
==============================================================================================================

2021-10-21
Documents DFO instructions_NAT_229-1.0_fre.pdf and DFO instructions_NAT_229-1.0_eng.pdf are replaced by their final versions.
==============================================================================================================

2021-11-03

FS-NAT-229-2-FR.pdf and FS-NAT-229-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-02-02

FS-NAT-229-2-FR.pdf and FS-NAT-229-2-EN.pdf:
     - Addition of rule #931 (label of FIN)

Sous-formulaires_exigences_229.xlsx and Subforms_requirements_229.xlsx:
     - Node PCONS becomes blocked form Pacific sub-forms (subform_id 4,5 and 6)
     - Element Effort.Nb_days_fsh changed from Optional to Mandatory
     - Element Effort_by_gear.Sel_dev_id becomes mandatory in subform_id 6 (PAC - Shrimp - Trawl)
==============================================================================================================
2022-04-07

XSD:
    - Transfer.To_vrn goes from optionnel to obligatoire
    - Trip.port_id is no more mandatory
    - Gear_info.Gear_hght becomes mandatory
    - Gear_info.Nb_tnls becomes mandatory
    - Element Catch.Specie_sz_id removed
    - Node Catch_dtl added
    - Element Transfer.Trnsf_dt goes from mandatory to optional
    - Nodes TRANSFER_DTL and TRANSFER_DTL_CTNR removed
    - Elements Transfer.Trnsf_dt, From_vrn and From_vname removed

Form: 43244.229.NATIONAL - ELOG - Logbook  Shrimp - JBE - Journal de bord  Crevette.xlsx  and 43244.229.NATIONAL - ELOG - Logbook  Shrimp - JBE - Journal de bord  Crevette.csv
    - Nodes TRANSFER_DTL and TRANSFER_DTL_CTNR removed
    - Node Catch_dtl added
    - Column "Required?" updated based on modifications requested
         - Elements added:
              Catch_Dtl.Spcmn_Sz_Id
              Catch_Dtl.Wt
              Catch_Dtl.Spcmn_Frm_Id
              Catch_Dtl.Rem

         - Elements changed from Optional to Mandatory:
              Transfer.To_Vrn
              Gear_Info.Nb_Tnls
              Gear_Info.Gear_Hght

         - Elements changed from Mandatory to Optional:
              Trip.Port_Id

         - Elements removed:
              Catch.Specie_Sz_Id
              Transfer.Trnsf_Dt
              Transfer.From_Vrn
              Transfer.From_Vname
              Transfer_Dtl.Specie_Id
              Transfer_Dtl.Specie_Frm_Id
              Transfer_Dtl.Wt
              Transfer_Dtl.Rem
              Transfer_Dtl_Ctnr.Ctnr_Typ_Id
              Transfer_Dtl_Ctnr.Nb_Ctnr
              Transfer_Dtl_Ctnr.Othr_Ctnr_Dsc
              Transfer_Dtl_Ctnr.Specie_Treatmt_Id
              Transfer_Dtl_Ctnr.Rem


Sous-formulaires_exigences_229.xlsx and Subforms_requirements_229.xlsx:

    - elements changed from Optional to Mandatory:
	Catch.Kept_wt (subform_id#8)
        Catch.Disc_wt (subform_id #8)
        Effort.Nb_days_fshd (subform_id #4)
        Effort_detail.avg_gr_dpth (subform_id #8)
        Gear_info.Gear_hght (subform_id#5)
        Gear_info.Nb_tnls (subform_id #5)
        

    - Elements changed from Blocked to Optional
        Effort_by_gear.Gear_sbtyp_id (subform_id #3)

    - Elements changed from Blocked to Mandatory
        Effort_detail.Start_lat (subform_id #1)
        Effort_detail.Start_long (subform_id #1)
        Effort_detail.End_lat (subform_id #1)
        Effort_detail.End_long (subform_id #1)
        Effort_detail.Nb_gear_hld (subform_id #8)
        Effort_detail.Tow_num (subform_id #2)
        General_info.Vname (subform_id #4,5,6)

    - Elements changed from Mandatory to Blocked
        Effort_detail.Lat (subform_id #1)
        Effort_detail.Long (subform_id #1)
        Effort_detail.Nb_tows (subform_id #2)
        Trip.Port_id (subform_id #4,5,6)
    
    - Node Landing blocked in subform_id #4,5,6
    - Node Pcons blocked in subform_id #2,4,5,6
    - Node Catch_dtl added
    - Nodes Transfer_dtl and Transfer_dtl_ctnr removed
    - Elements Transfer.Trnsf_dt, From_vrn and From_vname removed

Fact sheet:
Modifications after regional revisions
    - Added element Effort_by_gear.Gear_sbtyp_id to sub-form#3
    - Replaced rule #612 by rules #612a and 612b (Effort_by_gear.Gear_sbtyp_id)
    - In rule #35, the following gear codes have been removed from the list: 877,878,880,881,882,10581,25247 and 39500
    - Element START_LONG changed to END_LAT in rule #613
    - Addition of rule #962 (size of gear in node GEAR_INFO)
    - Rule #34 (same list of targeted species) replaced by rule #826 (list of targeted species per sub-form)
    - Addition of rule #727 (gear name Pot -> Pot/Trap)
    - Addition of rule #963 (Mandatory elements when gear is a Trawl)
    - Addition of rule #964 and #965 (node Catch_dtl)
    - Withdrawal of rules #248, #619, #621,#622 et #623 (removal of transfer details)
    - Addition of appendix B and rules #825 (Pcons species) and #836 (Catch species)
    - Removal of rule #618 (Catch species list of sub-form #4)
    - Rule #2500: new version of the DFO instructions documents


NAT - Structure XML Crevette (excluant pche hauturire) - Shrimp (excluding offshores) XML Structure.pdf:
    - Document updated to reflect the modifications

DFO instructions_NAT_229-1.1_fre.pdf and DFO instructions_NAT_229-1.1_eng.pdf:
    - Document updated to reflect the modifications

==============================================================================================================
2022-07-15

Form (43244.229.NATIONAL - ELOG - Logbook  Shrimp - JBE - Journal de bord  Crevette.csv and .xlsx):
    - Withdrawal of element Effort_detail.Grid_id

Subforms (Subforms_requirements_229.xlsx and Sous-formulaires_exigences_229.xlsx)
    - Withdrawal of element Effort_detail.Grid_id

Fact sheet:
    - Withdrawal of element Effort_detail.Grid_id so:
           - Withdrawal of this element from rule #420
           - New version of the DFO instructions to reflect this change, so, update of rule #2500.
    - Modification of the text of the Data transmission section.

Diagram (NAT - Structure XML Crevette (excluant pche hauturire) - Shrimp (excluding offshores) XML Structure.pdf):
    - Withdrawal of element Effort_detail.Grid_id

DFO instructions (DFO instructions_NAT_229-1.1_fre.pdf and DFO instructions_NAT_229-1.1_eng.pdf)::
     - Withdrawal of instruction concerning the grid (Effort_detail.Grid_id).

XSD:
     - Withdrawal of element Effort_detail.Grid_id
==============================================================================================================
2024-02-28

Fact sheet:
     - Withdrawal of Rule #615
     - Rule #825: correction from Appendix C to Appendix B

Subforms (Subforms_requirements_229.xlsx and Sous-formulaires_exigences_229.xlsx)
    - Modify Effort_detail.NB_tows to Blocked