...
- Talend job creates two XML outputs (cataloging-to-movement, movement-to-cataloging)
Propagation
Field mapping
SQL
Control lists:
- Pot Type: select pot_type from pot_type_code order by pot_type;
- Pot Size: select pot_size from pot_size_code order by pot_size;
- Treatment Type: select treatment_type_name from treatment_type order by treatment_type_name;
Notes
Prop Type:
- lookup table: prop_type_code
- propagation.prop_type = pro_type_code.prop_type
- 21 values in prop_type_code
Reason for Prop: propagation.purpose
- database has a rule that limits the values to: 'class use', 'research', 'garden collection',
'distribution', 'conservation' - 5 distinct values in propagation.purpose
Extra Seeds: propagation.extra_seed_flag
- boolean (0,1)
Activity Type:
- lookup table: activity_type_code
- activity_type_code.activity_type where growth_history.activity_type_id = activity_type_code.activity_type_id
- 24 values in activity_type_code
Medium:
- lookup table: medium
- growth_history.medium_name = medium.medium_name
- 1302 values in medium
Pot Type:
- lookup table: pot_type
- growth_history.pot_type = pot_type_code.pot_type
- 35 values in pot_type_code
Pot Size:
- lookup table: pot_size_code
- pot_size_code.pot_size where growth_history.pot_size_id = pot_size_code.pot_size_id
- 69 values in pot_size_code
Treatment Type:
- lookup table: treatment_type
- treatment_type.treatment_type_name where treatment.treatment_type_id = treatment_type.treatment_type_id
- 91 values in treatment_type
Concentration: treatment.concentration
- varchar(10) field
- no rules or constraints on this field
- 80 distinct values in treatment.concentration