Production Lot Upload Data Preparation: Metzger Veterinary Services (MVS)
Data Source Information
Metzger Veterinary Services (MVS)Vet: CSBV00005 (5)
Project Year: 2021
The site has six (6) herds reporting for 2021 data. They are:
CSBH0000034
CSBH0000035
CSBH0000037
CSBH0000038
CSBH0000039
CSBH0000040
Access to previous years documentation click on the appropriate link below:
MVS 2019
MVS 2020
There is 1 spreadsheet of source data provided by the site.
Within the spreadsheet/workbook of source data are 3 worksheets (actually more but original data is available).
Each worksheet contains the data to upload.
Each worksheet represents 1 year of data for all herds.
MVS source data structure is similar to FHMS data source structure.
All core production lot data, for all herds are in a single worksheet and no drug data is included.
In the appllication, for previous uploads, I would add a survey record to include the year and its herd.
At that point we could add the herd's core and associated drug data.
For MVS data we need to make sure we have added all survey records for a specified year for all herds.
The upload process will upload data for all herds at once, not just one herd at a time.
You can check within the source worksheet of core field production lot data for available herds in the data.
To do this copy all the data in the column referring to the survey herd codes.
Next, in a new worksheet, paste the column of herd codes. There are many repeated herd codes.
To see just the unique herd codes, highlight the column of herd codes within the worksheet,
click on the menu-item Data, then click on button to "Remove Duplicates".
You will see the unique herd codes provided the site.
Production Lot Upload Data Preparation: Metzger Veterinary Services (MVS)
Data Source Information
MVS has 4 herds. More herds have been assigned but only 4 herds of data collected so far.Each spreadsheet within a workbook from MVS represents all herds for a specific sampling year.
The core production lot fields resides in 1 worksheet within the workbook.
The drug information for feed fields resides in a worksheet within the workbook.
The drug information for injectable fields resides in a worksheet within the workbook.
The is no drug information for bolus provided for 2019. There may be in the future.
We need to upload all 3 worksheets before we attempt to integrate the data into production.
Each worksheet will be checked separately against its corresponding template.
Once checking is completed and all seems well, then we integrate the data.
All 3 uploaded datasets are necessary before the integrations step can take place within the application.
The core data when uploaded will be set to be uploaded as columns and drugs set to be mixed.
In actual fact there is no drug data in the core worksheet. It will in this way cause no problems at upload.
The drugs are listed as rows, not columns, within the sheet.
The drugs are set to its specific drug route when being uploaded i.e. Bolus, Feed or Injectable. No need to chose mixed!
Core field data has no drug data in the worksheet.
However, as mentioned above, all herds for MVS for a specific year are available.
Because of this, make sure you have created a survey record for each herd for the year you are uploading and integrating.
If it is not done, then we have no way to associate the production lot data with a survey!
During the upload of the spreadsheet into the database, missing or implied core field data is filled in.
The rows of drug data represent 1 drug, usually a product name and active ingredient for 1 drug route.
All drug routes and associated drugs for a production lot are available within the two remaining drug worksheets.
The drug route column is not provided by the source so add a column called "drug route" into a drug worksheet..
When you do this it makes it simpler at upload and integrate time to add information into the final target drug tables.
There are several extra things you should do in the spreadsheet before uploading the data:
The season or "Quarter Closeout" field is available.
The seasons are defined in the following way:
Winter -> January 1 thru March 31
Spring -> April 1 thru June 30
Summer -> July 1 thru September 30
Fall -> October 1 thru December 31
The origin or "Origin" field is available.
The seasons are defined in the following way:
Auction -> Auction Market (1)
Ranch -> Ranch Direct (2)
Background -> Backgrounded (3)
Mix -> Mixed (4)
The core data includes a column called "# Dead" as well as a column called "# Railed".
The target database does have a field to store the data in column "# Railed".
Three target fields exist to integrate data into: # of animals in, # of animals that died, # of animals out.
After several discussions, it was decided the "# Railed" should be included in the "# Out".
Because of this a new column is added to the core data called "out_final". The out final field is calculated as:
"# Railed" + "# Out" = "out_final"
When setting up the template use the "out_final" column and skip columns "# In" and "# Out".
Before creating and setting up a template, go thru all spreadsheets provided from the site.
Collect field names from each site and put them together. Review the field names to make sure they all
match. My experience is the field names do not match. To reduce the number of templates to create,
get the field names to match. The fields do not need to be in the same order.
The drug worksheets are missing a column to indicate what drug route the data pertains to.
The worksheet data is confounded with drug route, but when integrating the data it will help to have a column to indicate the route.
I inserted a new empty column after "Lot Code" near the beginning of the worksheet and labelled it "Route".
In the feed worksheet all cell values are set to "Feed".
In the injectable worksheet all cell values are set to "Injectable".
The drug data to be uploaded requires a column to be added by the data preparation people.
The column added is "Total quantity of antimicrobial units" for the bolus, feed and injectable worksheets.
Each new column has a parent column we use as a guide for the values to insert into the appropriate worksheet.
As an example, for Bolus, the parent column is "Total quantity of antimicrobial used in mg".
In the new empty column inserted right beside this column add the value "mg" for all bolus records.
A similar process is used for the feed and injectable worksheets.
Production Lot Upload Data Preparation: Metzger Veterinary Services (MVS)
Template Setup Suggestions
A three template setup is used for one or more years batch of data. If Bolus data was available then create 4 templates.For the current document, we assume place all known drug fields for each drug route resides in a separate specific drug data worksheet.
No data switches from core field columns to drug fields as rows for the setup of data for this site!
Three templates are created. The primary, top level template created represents the Core fields.
The secondary, second level child template created represents the Drug fields associated with a Core row of data.
One drug template is required for each drug route, you need to create separate templates for each drug route.
The Core Template is populated from the Target Table from the production lot table (core fields).
The Child Drug Template is populated from the Target Table from the drug table.
When setting up the core template, make sure a field is specified in the worksheet of core data
to match the csb_survey_main_id target field. In this way I can find the correct main id based on herd code.
When setting up the core template, make sure a field is specified in the worksheet of core data
to match the csb_survey_main_id target field. In this way I can find the correct main id based on herd code.
The source field available for herd code in MVS data is called "yard_code".
*** Remember to setup the template so the source field "yard_code" to the target field "csb_survey_main_id" field and set to not used!
*** Remember to setup the template so the source fields pertaining to weights as multi-field and make sure to add the fields for the target fields
*** csb_pl_avg_weight_in_kgs and csb_pl_avg_weight_out_kgs. Set associated target fields for source units and source value
*** for the weight in and weight out to be skipped.
When setting up each drug template, make sure a field is specified in the worksheet of drug data
to match the production lot code source field name. I use the unused field csb_survey_production_lot_drug_id target field.
In this way the production lot code field name is identified.
Similarly for the drug templates, make sure a field is specified in the worksheet of drug data
to match the csb_survey_production_lot_drug_id target field. In this way we can find the correct production lot.
The source drug field available for production lot code in MVS data is called "lot_code".
*** Remember to setup the template so the source drug field "lot_code" to the target field "csb_survey_production_lot_drug_id" field and set to not used!
*** Remember to do this for each drug route of data provided.
Here are the typical template settings used for MVS.
Name: MVS 2021 - Core (79)
Level: Top Level (1)
Type: Core (1)
Route: Multiple Drugs (4)
Version: Version 1 (1)
By Row or Column: By Column (2)
Method: Populate template fields from Target
|
||||||
|---|---|---|---|---|---|---|
| column_number | target_column_classify_field_setup | target_field_category | target_column_type | target_column_name | source_column_name | column_not_used |
| 1 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_production_lot_id | csb_survey_production_lot_id | Not Used (1) |
| 2 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_main_id | cipars_feedlot_code | Not Used (1) |
| 3 | Setup Standard Field (1) | Core Field (0) | bigint | csb_record_group_id | csb_record_group_id | Not Used (1) |
| 4 | Setup Standard Field (1) | Core Field (0) | bigint | csb_account_id | csb_account_id | Not Used (1) |
| 5 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_production_lot_upload_id | csb_survey_production_lot_upload_id | Not Used (1) |
| 6 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_template_id | csb_pl_template_id | Not Used (1) |
| 7 | Setup Standard Field (1) | Core Field (0) | varchar(128) | csb_pl_production_lot_code | feedlot_lot_name | Used (0) |
| 8 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_sex_id | sex | Used (0) |
| 9 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_sex_percent_steers | csb_pl_sex_percent_steers | Not Used (1) |
| 10 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_sex_percent_cows | csb_pl_sex_percent_cows | Not Used (1) |
| 11 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_sex_percent_heifers | csb_pl_sex_percent_heifers | Not Used (1) |
| 12 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_sex_percent_bulls | csb_pl_sex_percent_bulls | Not Used (1) |
| 13 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_animal_age_category_id | type_uk | Used (0) |
| 14 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_percent_calves | csb_pl_percent_calves | Not Used (1) |
| 15 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_percent_yearlings | csb_pl_percent_yearlings | Not Used (1) |
| 16 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_percent_adults | csb_pl_percent_adults | Not Used (1) |
| 17 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_origin_id | origin | Used (0) |
| 18 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_origin_percent_auction | csb_pl_origin_percent_auction | Not Used (1) |
| 19 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_origin_percent_backgrounded | csb_pl_origin_percent_backgrounded | Not Used (1) |
| 20 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_origin_percent_ranch_direct | csb_pl_origin_percent_ranch_direct | Not Used (1) |
| 21 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_brd_risk_id | brd_risk_category | Used (0) |
| 22 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_brd_risk_percent_low | csb_pl_brd_risk_percent_low | Not Used (1) |
| 23 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_brd_risk_percent_medium | csb_pl_brd_risk_percent_medium | Not Used (1) |
| 24 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_brd_risk_percent_high | csb_pl_brd_risk_percent_high | Not Used (1) |
| 25 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_quarter_of_year_closeout_id | closeout | Used (0) |
| 26 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_n_animals_in | hd_in | Used (0) |
| 27 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_n_animals_railed | railed | Used (0) |
| 28 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_n_animals_dead | deaths | Used (0) |
| 29 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_n_animals_slaughtered | hd_out | Used (0) |
| 30 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_source_weight_in_units_id | csb_pl_source_weight_in_units_id | Not Used (1) |
| 31 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_source_weight_in_value | csb_pl_source_weight_in_value | Not Used (1) |
| 32 | Setup Multiple Target Fields (3) | Core Field (0) | numeric | csb_pl_avg_weight_in_kgs | avg_in_weight_kg | Used (0) |
| 33 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_source_weight_out_units_id | csb_pl_source_weight_out_units_id | Not Used (1) |
| 34 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_source_weight_out_value | csb_pl_source_weight_out_value | Not Used (1) |
| 35 | Setup Multiple Target Fields (3) | Core Field (0) | numeric | csb_pl_avg_weight_out_kgs | avg_out_weight_kg | Used (0) |
| 36 | Setup Standard Field (1) | Core Field (0) | date | csb_pl_avg_date_in | avg_in_date | Used (0) |
| 37 | Setup Standard Field (1) | Core Field (0) | date | csb_pl_avg_date_out | avg_out_date | Used (0) |
| 38 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_total_days_on_feed | dof | Used (0) |
| 39 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_total_head_days | head_days | Used (0) |
| 40 | Setup Standard Field (1) | Core Field (0) | varchar | csb_pl_notes | csb_pl_notes | Not Used (1) |
Name: MVS 2021 - Feed Drugs (80)
Level: Second Level (2)
Type: Drug (2)
Route: Feed (2)
Version: Version 1 (1)
By Row or Column: By Row (1)
Method: Populate template fields from Target
|
||||||
|---|---|---|---|---|---|---|
| column_number | target_column_classify_field_setup | target_field_category | target_column_type | target_column_name | source_column_name | column_not_used |
| 1 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_production_lot_drug_id | lot_code | Not Used (1) |
| 2 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_production_lot_id | csb_survey_production_lot_id | Not Used (1) |
| 3 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_main_id | csb_survey_main_id | Not Used (1) |
| 4 | Setup Standard Field (1) | Core Field (0) | bigint | csb_record_group_id | csb_record_group_id | Not Used (1) |
| 5 | Setup Standard Field (1) | Core Field (0) | bigint | csb_account_id | csb_account_id | Not Used (1) |
| 6 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_production_lot_upload_id | csb_survey_production_lot_upload_id | Not Used (1) |
| 7 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_template_id | csb_pl_template_id | Not Used (1) |
| 8 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_ordinal | csb_pl_drug_ordinal | Not Used (1) |
| 9 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_drug_route_id | route | Used (0) |
| 10 | Setup Standard Field (1) | Core Field (0) | varchar(192) | csb_pl_source_drug_name | antibiotic | Used (0) |
| 11 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_source_drug_value | kg_used | Used (0) |
| 12 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_source_drug_value_units_id | unit | Used (0) |
| 13 | Setup Standard Field (1) | Trade Name (2) | integer | csb_pl_drug_trade_name_id (TnId=) | csb_pl_drug_trade_name_id | Not Used (1) |
| 14 | Setup Standard Field (1) | Active Ingredient (1) | integer | csb_pl_drug_active_ingredient_id (AiId=) | antibiotic | Used (0) |
| 15 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_total_mg | kg_used | Used (0) |
| 16 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_total_ml | csb_pl_drug_total_ml | Not Used (1) |
| 17 | Setup Standard Field (1) | Core Field (0) | bigint | csb_pl_drug_regimen_id | csb_pl_drug_regimen_id | Not Used (1) |
| 18 | Setup Standard Field (1) | Core Field (0) | bigint | csb_pl_drug_regimen_detail_id | csb_pl_drug_regimen_detail_id | Not Used (1) |
| 19 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_drug_primary_reason_for_use | reason | Used (0) |
| 20 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_primary_reason_for_use_pct_gp | csb_pl_drug_primary_reason_for_use_pct_gp | Not Used (1) |
| 21 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_primary_reason_for_use_pct_dp | csb_pl_drug_primary_reason_for_use_pct_dp | Not Used (1) |
| 22 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_primary_reason_for_use_pct_dt | csb_pl_drug_primary_reason_for_use_pct_dt | Not Used (1) |
| 23 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_respiratory | indication | Used (0) |
| 24 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_digestive | csb_pl_drug_secondary_reason_digestive | Not Used (1) |
| 25 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_lameness | csb_pl_drug_secondary_reason_lameness | Not Used (1) |
| 26 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_neurologic | csb_pl_drug_secondary_reason_neurologic | Not Used (1) |
| 27 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_liver_abscess | csb_pl_drug_secondary_reason_liver_abscess | Not Used (1) |
| 28 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_coccidiosis | csb_pl_drug_secondary_reason_coccidiosis | Not Used (1) |
| 29 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_enteritis | csb_pl_drug_secondary_reason_enteritis | Not Used (1) |
| 30 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_mixed | csb_pl_drug_secondary_reason_mixed | Not Used (1) |
| 31 | Setup Standard Field (1) | Core Field (0) | varchar(128) | csb_pl_drug_secondary_reason_mixed_description | csb_pl_drug_secondary_reason_mixed_description | Not Used (1) |
| 32 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_other | csb_pl_drug_secondary_reason_other | Not Used (1) |
| 33 | Setup Standard Field (1) | Core Field (0) | varchar(128) | csb_pl_drug_secondary_reason_other_description | csb_pl_drug_secondary_reason_other_description | Not Used (1) |
| 34 | Setup Standard Field (1) | Core Field (0) | varchar | csb_pl_drug_secondary_reason_source | indication | Not Used (1) |
| 35 | Setup Standard Field (1) | Core Field (0) | varchar | csb_pl_drug_notes | csb_pl_drug_notes | Not Used (1) |
Name: MVS 2021 - Injectable Drugs (81)
Level: Second Level (2)
Type: Drug (2)
Route: Injectable (3)
Version: Version 1 (1)
By Row or Column: By Row (1)
Method: Populate template fields from Target
|
||||||
|---|---|---|---|---|---|---|
| column_number | target_column_classify_field_setup | target_field_category | target_column_type | target_column_name | source_column_name | column_not_used |
| 1 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_production_lot_drug_id | lot_code | Not Used (1) |
| 2 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_production_lot_id | csb_survey_production_lot_id | Not Used (1) |
| 3 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_main_id | csb_survey_main_id | Not Used (1) |
| 4 | Setup Standard Field (1) | Core Field (0) | bigint | csb_record_group_id | csb_record_group_id | Not Used (1) |
| 5 | Setup Standard Field (1) | Core Field (0) | bigint | csb_account_id | csb_account_id | Not Used (1) |
| 6 | Setup Standard Field (1) | Core Field (0) | bigint | csb_survey_production_lot_upload_id | csb_survey_production_lot_upload_id | Not Used (1) |
| 7 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_template_id | csb_pl_template_id | Not Used (1) |
| 8 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_ordinal | csb_pl_drug_ordinal | Not Used (1) |
| 9 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_drug_route_id | route | Used (0) |
| 10 | Setup Standard Field (1) | Core Field (0) | varchar(192) | csb_pl_source_drug_name | antibiotic | Used (0) |
| 11 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_source_drug_value | ml_used | Used (0) |
| 12 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_source_drug_value_units_id | unit | Used (0) |
| 13 | Setup Standard Field (1) | Trade Name (2) | integer | csb_pl_drug_trade_name_id (TnId=) | csb_pl_drug_trade_name_id | Not Used (1) |
| 14 | Setup Standard Field (1) | Active Ingredient (1) | integer | csb_pl_drug_active_ingredient_id (AiId=) | antibiotic | Used (0) |
| 15 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_total_mg | csb_pl_drug_total_mg | Not Used (1) |
| 16 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_total_ml | ml_used | Used (0) |
| 17 | Setup Standard Field (1) | Core Field (0) | bigint | csb_pl_drug_regimen_id | csb_pl_drug_regimen_id | Not Used (1) |
| 18 | Setup Standard Field (1) | Core Field (0) | bigint | csb_pl_drug_regimen_detail_id | csb_pl_drug_regimen_detail_id | Not Used (1) |
| 19 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_drug_primary_reason_for_use | reason | Used (0) |
| 20 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_primary_reason_for_use_pct_gp | csb_pl_drug_primary_reason_for_use_pct_gp | Not Used (1) |
| 21 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_primary_reason_for_use_pct_dp | csb_pl_drug_primary_reason_for_use_pct_dp | Not Used (1) |
| 22 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_primary_reason_for_use_pct_dt | csb_pl_drug_primary_reason_for_use_pct_dt | Not Used (1) |
| 23 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_respiratory | indication | Used (0) |
| 24 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_digestive | csb_pl_drug_secondary_reason_digestive | Not Used (1) |
| 25 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_lameness | csb_pl_drug_secondary_reason_lameness | Not Used (1) |
| 26 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_neurologic | csb_pl_drug_secondary_reason_neurologic | Not Used (1) |
| 27 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_liver_abscess | csb_pl_drug_secondary_reason_liver_abscess | Not Used (1) |
| 28 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_coccidiosis | csb_pl_drug_secondary_reason_coccidiosis | Not Used (1) |
| 29 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_enteritis | csb_pl_drug_secondary_reason_enteritis | Not Used (1) |
| 30 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_mixed | csb_pl_drug_secondary_reason_mixed | Not Used (1) |
| 31 | Setup Standard Field (1) | Core Field (0) | varchar(128) | csb_pl_drug_secondary_reason_mixed_description | csb_pl_drug_secondary_reason_mixed_description | Not Used (1) |
| 32 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_drug_secondary_reason_other | csb_pl_drug_secondary_reason_other | Not Used (1) |
| 33 | Setup Standard Field (1) | Core Field (0) | varchar(128) | csb_pl_drug_secondary_reason_other_description | csb_pl_drug_secondary_reason_other_description | Not Used (1) |
| 34 | Setup Standard Field (1) | Core Field (0) | varchar | csb_pl_drug_secondary_reason_source | indication | Not Used (1) |
| 35 | Setup Standard Field (1) | Core Field (0) | varchar | csb_pl_drug_notes | csb_pl_drug_notes | Not Used (1) |