HDMS Wiki Home

  • StillMissingGname
    		•  Last edited by Maggie Woo on Jan 14, 2003 10:42 pm

    ET_WITH_NO_NAME

    GNAME, NNAME, SNAME, SCOMNAME in ET are all blank.

    Why does this record exist? Is it important? Chances are, it is not important for the data conversion. Below are the various possibilities.

    ES.EMG.KEYS (Element Stewardship record with Element Management Group Elements that don't occur in your state).

    QC Procedure:

    1. SELECT ET WITHOUT GNAME AND WITH ES.EMG.KEYS
    2. If no records found, go to the next section below.
    3. KEYLIST ET ES.EMG.KEYS ES.EMG.MISSING.ET
    4. GETLIST ES.EMG.MISSING.ET
    5. LIST ES EMG.ELCODE EMG.GNAME
    6. Manually remove the elcode values from EMG.ELCODE that do not have a corresponding EMG.GNAME

    Resolution:

    Manually remove EMG.ELCODE values that reference the "ghost" ET records, then delete the "ghost" ET records. Optionally, delete the specified ES records entirely (you will get them again on the next data exchange, and with them the applicable element records).

    Other Broken Links

    These are ET records that were re-created by the indexing system after the ET was deleted. This happens if the ET was already being referenced by another record when it was deleted. The system attempts to maintain the integrity of the relationships, so if it finds a broken link, it creates a "ghost" record. Note that generally, this happens when the index is rebuilt, and not by the background index processor.

    QC Procedure:

    1. SELECT ET WITH WITHOUT GNAME
    2. LIST ET EM.KEYS EOR.KEYS ES.KEYS REQUESTS.KEYS
    3. Scan the list to find the referring records (listed under the columns for each of the keys)
    4. Manually edit each of the referring records and remove the ELCODE(s) in question until they are no longer being referenced
    5. Delete the ET records.

    Just plain strange data

    These are ET records that just happen to have nothing in the four name fields (but probably have something in GCOMNAME). In addition, they appear to be valid ET records (data fields are filled in). Just for some reason, GNAME, NNAME, SNAME, and SCOMNAME happen to be completely blank. It's your job now to fill them in with something. If you don't fill them in, the HDMS will not have anything for these ET records after the conversion is done.

    Back to HdmsQcBatchProcess
    Back to DataQc