The Ministry of Agriculture Licensing System (MALS) was created with intent of being a single licensing application, replacing various disparate Animal Industry Branch licensing applications.
MALS-1248 - Dairy Test Result - IH Correspondence
Move the functionality from the view and into the stored procedure.
This approach should improve performance and make it easier to support.
The view pr_update_dairy_farm_test_results can be dropped
VIEW: MAL_DAIRY_FARM_TEST_INFRACTION_VW
DATA: MAL_DAIRY_FARM_TEST_INFRACTION_LU
PROCEDURE: PR_UPDATE_DAIRY_FARM_TEST_RESULTS
R5.3.1
MALS-1248 - Apiary licenses printing client's name as client and as company on certificates
APIARY and BULK TANK MILK GRADER will use Company Name only, and three others will use a new column named derived_company_name, which has the existing logic.
VIEW: MAL_PRINT_CERTIFICATE_VW
MALS-1246 Renewal Notice for Purchase Live Poultry Incorrect
Added DispLicenceExpiryDate key/value pair to the JSON output.
MALS-1248 - Apiary licenses printing client's name as client and as company on certificates
APIARY and BULK TANK MILK GRADER will use Company Name only, and four others will use a new column named derived_company_name, which has the existing logic.
VIEW: MAL_PRINT_RENEWAL_VW
MALS-1253 Add a column for postal codes to the Apiary_Site_Report
Add a column for Site postal codes to the view and procedure
MALS-1189 Producer Analysis Report by Region not calculating correctly
Add Licence Region, District and City to support updates to the Apiary Producer report updates.
The columns did not get used by the proc as direction ws given to switch to use the Licence hive counts.
VIEW: MAL_APIARY_PRODUCER_VW
PROCEDURE: PR_GENERATE_PRINT_JSON_APIARY_SITE
MALS-1249 Dairy Test Inventory showing FFA Warning & Penalties being issued - this is incorrect
Deleted existing Wartning and Penalties data. Removed functionality to populate those columns, from the stored procedure.
UPDATE: DAIRY_FARM_TEST_RESULT
PROCEDURE: PR_UPDATE_DAIRY_FARM_TEST_RESULTS
MALS-1189 Producer Analysis Report by Region not calculating correctly
Add Licence Region, District and City to support updates to the templates.
PROCEDURE: PR_GENERATE_PRINT_JSON_APIARY_PRODUCER_REGION
PROCEDURE: PR_GENERATE_PRINT_JSON_APIARY_PRODUCER_DISTRICT
R5.3.1
MALS-1248 - Dairy Test Result - IH Correspondence Move the functionality from the view and into the stored procedure. This approach should improve performance and make it easier to support. The view pr_update_dairy_farm_test_results can be dropped VIEW: MAL_DAIRY_FARM_TEST_INFRACTION_VW DATA: MAL_DAIRY_FARM_TEST_INFRACTION_LU PROCEDURE: PR_UPDATE_DAIRY_FARM_TEST_RESULTS
R5.3.1
MALS-1248 - Apiary licenses printing client's name as client and as company on certificates APIARY and BULK TANK MILK GRADER will use Company Name only, and three others will use a new column named derived_company_name, which has the existing logic. VIEW: MAL_PRINT_CERTIFICATE_VW
MALS-1246 Renewal Notice for Purchase Live Poultry Incorrect Added DispLicenceExpiryDate key/value pair to the JSON output. MALS-1248 - Apiary licenses printing client's name as client and as company on certificates APIARY and BULK TANK MILK GRADER will use Company Name only, and four others will use a new column named derived_company_name, which has the existing logic. VIEW: MAL_PRINT_RENEWAL_VW
MALS-1253 Add a column for postal codes to the Apiary_Site_Report Add a column for Site postal codes to the view and procedure MALS-1189 Producer Analysis Report by Region not calculating correctly Add Licence Region, District and City to support updates to the Apiary Producer report updates. The columns did not get used by the proc as direction ws given to switch to use the Licence hive counts. VIEW: MAL_APIARY_PRODUCER_VW PROCEDURE: PR_GENERATE_PRINT_JSON_APIARY_SITE
MALS-1249 Dairy Test Inventory showing FFA Warning & Penalties being issued - this is incorrect Deleted existing Wartning and Penalties data. Removed functionality to populate those columns, from the stored procedure. UPDATE: DAIRY_FARM_TEST_RESULT PROCEDURE: PR_UPDATE_DAIRY_FARM_TEST_RESULTS
MALS-1189 Producer Analysis Report by Region not calculating correctly Add Licence Region, District and City to support updates to the templates. PROCEDURE: PR_GENERATE_PRINT_JSON_APIARY_PRODUCER_REGION PROCEDURE: PR_GENERATE_PRINT_JSON_APIARY_PRODUCER_DISTRICT