SAspecimenState

[luciazarauz]

Hi,

In a ETP dedicated sampling it may happen that for the same trip and haul sampled, the observer reports two specimens of the same species, one alive and another dead.

However, in table SA SpecimenState is not a Unique Key variable. Is this rigth?

Thanks

[nmprista]

would it work if you stratify the species into live and dead?

[luciazarauz]

I guess so. Thanks

I understand that this solution can work as a shortcut. But for the longer term, don't you think that it makes sense to include SpecimenState as Unique Key? (probably I am missing some other implications, but just to confirm)