EOR_MISSING_NATION

For any records that are missing data in the NATION field, the default value will be "US"--please update all the EOR records where the NATION value is missing. Put in the appropriate two-letter abbreviation.

QC Procedure:

In EOR:

1. SELECT EOR WITHOUT NATION
2. SAVELIST EOR_MISSING_NATION
3. GETLIST EOR_MISSING_NATION
4. LIST EOR NATION
5. Fix the data manually.
6. Re-run the QC until no records are found

Resolution:

Fix the data. Technically, you can leave it alone if you are happy with the default action. However, if you feel compelled to contact someone for their advice, then instead, execute the following at TCL (it's faster to do this command than hunting for advice about the pros and cons of taking the default action):

• UPDATE EOR WITHOUT NATION SET NATION="US"

Back to HdmsQcBatchProcess
Back to DataQc