Production Lot Upload Data Preparation: Feedlot Health Management Services (FHMS)
Site Information Details
Feedlot Health Management Services (4) (FHMS)Vet: CSBV00001 (1)
Project Year: 2020
The site has eight (8) herds. The herds used for this project year are:
CSBH000001
CSBH000004
CSBH000005
CSBH000006
CSBH000007
CSBH000008
CSBH000041
CSBH000042
Access to previous years documentation click on the appropriate link below:
FHMS 2019
FHMS 2021
FHMS 2022
FHMS 2023
Up to now we upload 1 year's data for 1 herd.
FHMS has a different 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 FHMS data we need to make sure we have added all survey records for a year for all herds.
FHMS herds have changed from 2019 to 2020. Please take note as year to year there may be herd changes.
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: Feedlot Health Management Services (FHMS)
Data Source Information
FHMS has 8 herds.Each spreadsheet within a workbook from FHMS represents all herds for a specific sampling year.
The core production lot fields resides in 1 worksheet within the workbook.
The drug information for bolus fields resides in a 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.
Because of this we need to upload all 4 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 4 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 or n/a.
In actual fact there is no drug data in the core worksheet. It will upload in this format with no problem.
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 FHMS 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 there is 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.
The product name in the target database is called a trade name. The combination of both trade name and active ingredient
are used in combination to acquire the correct trade name id and active ingredient id. What is new for 2020 is
each row in the source spreadsheet with a product name and active ingredient needs to be checked.
What is done is to make certain the trade name has 1 and only 1 active ingredient associated with it. If not,
the the upload takes into account and uploads the multiple active ingredients associated with the specific trade name.
All drug routes and associated drugs for a production lot are available.
All drug routes and associated drugs for a production lot are available within the three remaining drug worksheets.
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
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. You can do this but I do no recommend it.
For 2019 data, and as well for 2020 data, it is best practise to create a template for each drug route.
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.
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: Feedlot Health Management Services (FHMS)
Template Setup Suggestions
A four template setup is used for one or more years batch of data.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!
Four 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.
The source field available for herd code in FHMS data is called "feedlot_code".
*** Remember to setup the source field "feedlot_code" to the target field "csb_survey_main_id" field and set to not used!
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.
For the FHMS 2020 data I setup the field map in the following way:
Bolus: csb_survey_production_lot_drugs_bolus_id -> pen_id
Feed: csb_survey_production_lot_drugs_feed_id -> lot_id
Bolus: csb_survey_production_lot_drugs_injectable_id -> lot_id
The FHMS source data setup for drugs needs a connection between worksheets and the only field I have is the production lot code.
Each of the source field name so the upload can proceed.
Here are the typical template settings used for FHMS.
Name: FHMS 2020 - Core
Level: Top Level (1)
Type: Core (1)
Route: n/a (0)
Version: Version 1 (1)
By Row or Column: By Column (2)
Method: Populate template fields from Target (1)
|
||||||
|---|---|---|---|---|---|---|
| # | Field Setup | 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 | 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 | production_lot_code | 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 | calf_yearling_calc | Used (0) |
| 14 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_percent_calves | calf_pct | Used (0) |
| 15 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_percent_yearlings | yearling_pct | Used (0) |
| 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_calc | Used (0) |
| 18 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_origin_percent_auction | auction_pct | Used (0) |
| 19 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_origin_percent_backgrounded | backgrounded_pct | Used (0) |
| 20 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_origin_percent_ranch_direct | ranch_direct_pct | Used (0) |
| 21 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_brd_risk_id | brd_calc | Used (0) |
| 22 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_brd_risk_percent_low | low_brd_risk_pct | Used (0) |
| 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 | high_brd_risk_pct | Used (0) |
| 25 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_quarter_of_year_closeout_id | quarter_of_close_out | Used (0) |
| 26 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_n_animals_in | animals_in | Used (0) |
| 27 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_n_animals_railed | csb_pl_n_animals_railed | Not Used (1) |
| 28 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_n_animals_dead | animals_dead | Used (0) |
| 29 | Setup Standard Field (1) | Core Field (0) | integer | csb_pl_n_animals_slaughtered | animals_slaughtered | Used (0) |
| 30 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_source_weight_in_units_id | average_weight_in_kg | 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 | average_weight_in_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 | average_weight_out_kg | Used (0) |
| 36 | Setup Standard Field (1) | Core Field (0) | date | csb_pl_avg_date_in | average_date_in | Used (0) |
| 37 | Setup Standard Field (1) | Core Field (0) | date | csb_pl_avg_date_out | average_date_out | Used (0) |
| 38 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_total_days_on_feed | average_days_on_feed | 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: FHMS 2020 - Drugs
Level: Second Level (2)
Type: Drug (2)
Route: Bolus (1)
Version: Version 1 (1)
By Row or Column: By Row (1)
Method: Populate template fields from Target (1)
| # | Field Setup | 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 | csb_survey_production_lot_drug_id | 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_of_admin | Used (0) |
| 10 | Setup Standard Field (1) | Core Field (0) | varchar(192) | csb_pl_source_drug_name | active_ingredient | Used (0) |
| 11 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_source_drug_value | total_quantity_of_antimicrobial_used_in_boluses_used | Used (0) |
| 12 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_source_drug_value_units_id | source_units | Used (0) |
| 13 | Setup Standard Field (1) | Trade Name (2) | integer | csb_pl_drug_trade_name_id (TnId=) | product_name | Used (0) |
| 14 | Setup Standard Field (1) | Active Ingredient (1) | integer | csb_pl_drug_active_ingredient_id (AiId=) | active_ingredient | 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 | csb_pl_drug_total_ml | Not Used (1) |
| 17 | Setup Standard Field (1) | Core Field (0) | bigint | csb_pl_drug_regimen_id | regimen_identification | 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_for_use | Used (0) |
| 20 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_primary_reason_for_use_pct_ | 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_ | 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_ | 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 | condition_antimicrobial_used_for | 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_absc | 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_de | 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_des | 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 | condition_antimicrobial_used_for | Used (0) |
| 35 | Setup Standard Field (1) | Core Field (0) | varchar | csb_pl_drug_notes | csb_pl_drug_notes | Not Used (1) |
Name: FHMS 2020 - Drugs
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 (1)
| # | Field Setup | 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 | csb_survey_production_lot_drug_id | 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_of_admin | Used (0) |
| 10 | Setup Standard Field (1) | Core Field (0) | varchar(192) | csb_pl_source_drug_name | active_ingredient | Used (0) |
| 11 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_source_drug_value | total_quantity_of_antimicrobial_ingredient_used_in_g | Used (0) |
| 12 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_source_drug_value_units_id | source_units | Used (0) |
| 13 | Setup Standard Field (1) | Trade Name (2) | integer | csb_pl_drug_trade_name_id (TnId=) | csb_pl_drug_trade_name_id | Used (0) |
| 14 | Setup Standard Field (1) | Active Ingredient (1) | integer | csb_pl_drug_active_ingredient_id (AiId=) | active_ingredient | Used (0) |
| 15 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_total_mg | total_quantity_of_antimicrobial_ingredient_used_in_g | Used (0) |
| 16 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_drug_total_ml | csb_pl_drug_total_ml | 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_for_use | 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 | condition_antmicrobial_used_for | 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 | condition_antmicrobial_used_for | Used (0) |
| 35 | Setup Standard Field (1) | Core Field (0) | varchar | csb_pl_drug_notes | csb_pl_drug_notes | Not Used (1) |
Name: FHMS 2020 - Drugs
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 (1)
| # | Field Setup | 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 | csb_survey_production_lot_drug_id | 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_of_admin | Used (0) |
| 10 | Setup Standard Field (1) | Core Field (0) | varchar(192) | csb_pl_source_drug_name | active_ingredient | Used (0) |
| 11 | Setup Standard Field (1) | Core Field (0) | numeric | csb_pl_source_drug_value | total_quantity_of_antimicrobial_used_in_ml | Used (0) |
| 12 | Setup Lookup Field (2) | Core Field (0) | integer | csb_pl_source_drug_value_units_id | source_units | Used (0) |
| 13 | Setup Standard Field (1) | Trade Name (2) | integer | csb_pl_drug_trade_name_id (TnId=) | product_names | Used (0) |
| 14 | Setup Standard Field (1) | Active Ingredient (1) | integer | csb_pl_drug_active_ingredient_id (AiId=) | active_ingredient | 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 | 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_for_use | 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 | condition_antimicrobial_used_for | 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 | condition_antimicrobial_used_for | Used (0) |
| 35 | Setup Standard Field (1) | Core Field (0) | varchar | csb_pl_drug_notes | csb_pl_drug_notes | Not Used (1) |