ET_WITH_SRANKFAILS

SRANK values are used to populate not just the new S_RANK column in the HDMS, but also to populate the Exotic Status, and the distribution fields (Origin, Regularity, Distribution Confidence, Current Presence/Absence, and Population). However, in order for the conversion to successfully populate all these fields, the SRANK value itself must match a "known" or "recognized" pattern.

If the SRANK value does not match a "known" or "recognized" pattern, the original BCD value will be put into a field called "BCD-Style Rank" and the placeholder value "SNR" will be put into the S_RANK field. The data for the Exotic Status and distribution fields will be left blank, but may be filled in with the correct values after conversion.

QC Procedure:

In ET:

1. SELECT ET WITH HDMS_SRANKFAILS
2. SAVELIST ET_WITH_SRANKFAILS
3. GETLIST ET_WITH_SRANKFAILS
4. LIST ET SRANK HDMS_SRANKFAILS

Resolution:

In the ranks that failed the QC, look for:

• obvious typos (e.g., S12)
• punctuation errors in breeding-nonbreeding-migrant ranks (for example, 'S3B,S4N' is correct, but 'S3BS4N' or 'S3B;S4N' or 'S3B S4N' are all incorrect)

Correct these mistakes in BCD prior to data conversion.

The rest of the ranks that failed QC will likely contain invalid syntax (such as 'S2S3?'--you can't use a ? with a range rank) or ambiguous syntax that includes an 'E' for exotic. Since programs have a variety of ways of writing ranks for exotics, some of these ranks cannot be converted automatically into the values in the new distribution fields in Biotics 4 Tracker.

Correct obvious syntax errors in BCD prior to data conversion. If you do not know why the syntax is wrong or if you believe that it is correct, do nothing prior to conversion. The original BCD SRANK will be migrated to a field called 'BCD-Style RANK,' the Subnational Rank field will contain the placeholder value 'SNR,' and the Exotic Status and distribution fields (Origin, Regularity, Distribution Confidence, Current Presence/Absence, and Population) will be blank. Since there should only be a handful of such records, they can be corrected in Biotics Tracker after conversion.

Back to HdmsQcPlusBatchProcess
Back to DataQc