ET_WITH_MISSING_NNAME

NNAME in ET

If NNAME is blank, no ELEMENT_NATIONAL record can be successfully created in HDMS. This will in turn cascade down to the ELEMENT_SUBNATIONAL, to any EO records for those ELEMENT_SUBNATIONAL records.

QC Procedure:

In ET:

1. SELECT ET WITHOUT NNAME AND ( WITH GNAME OR WITH SNAME )
2. SAVELIST ET_WITH_MISSING_NNAME
3. GETLIST ET_WITH_MISSING_NNAME
4. LIST ET NNAME SNAME
5. Fix the data manually, or execute the following UPDATE command to put GNAME into the NNAME field.
6. UPDATE ET GETLIST ET_WITH_MISSING_NNAME SET NNAME = {GNAME}

Resolution:

In all cases, data must be modified. There is no configuration work-around.

[2003-01-15 last minute update: After preliminary Data Exchange testing, we realize that the blank NNAME values should really be populated using GNAME not SNAME! Need to fix other documentation.]

Back to HdmsQcBatchProcess
Back to DataQc