HDMS Wiki Home

  • MissingSitename
  • Last edited by Maggie Woo on Jan 14, 2003 10:48 pm

    SBR_MISSING_SITENAME

    CONSERVATION_SITE.SITE_NAME is a required attribute in Biotics 4. Any SBR record where SITENAME is blank will be rejected during conversion.

    QC Procedure:

    In SBR:

    1. SELECT SBR WITHOUT SITENAME OR WITHOUT NATION OR WITHOUT STATE
    2. SAVELIST SBR_MISSING_SITENAME
    3. GETLIST SBR_MISSING_SITENAME
    4. LIST SBR SITENAME NATION STATE
    5. Fix the data manually.
    6. Re-run the QC until no records are found

    Resolution:

    You may need to enter a name, or delete the SBR record entirely. Before deleting an SBR record, press CTRL-F6 to see if there are MABR or EOR records that rely upon this record--sometimes they give you a clue as to what the name may be, or you may have to go and delete those records as well, or re-link them to the correct SBR.

    The NATION and STATE QC are combined here because the CONSERVATION_SITE.NATION_ID and CONSERVATION_SITE.D_STATE_ID columns in Biotics 4 are not required columns on the back end--they may still be required columns on the Biotics Tracker front end.

    Back to HdmsQcBatchProcess
    Back to DataQc