Editing Childhood Lead Surveillance Data

This handbook is designed to aid state and local childhood lead
poisoning surveillance and program staff in identifying and correcting
errors in their lead poisoning surveillance data.

When data is submitted to the Centers for Disease Control and Prevention
National Childhood Lead Poisoning Database, a series of programs check
the data for valid values and inconsistencies. These programs produce
reports indicating the data errors and a file containing any rejected
records. The files produced are:

-   Report of the Rejected Records \*\*\*\*\*.RPT

-   File of Rejected Records \*\*\*\*\*.BAD

-   Alert Report \*\*\*\*\*.ALT

The report of rejected records and the alert report are sent to the
state to assist them in correcting any errors. The file of rejected
records is not useful to most programs, so it is not returned to the
state unless requested.

**If you make any corrections to your database, you must do a
'Corrections Extract'. However, if you only have a couple of
corrections, we have browse and update capability and can make a
[small]{.underline} number of changes manually (you must still update
your database with corrections).**

**[Report of Rejected Records - \*\*\*\*\*.RPT]{.underline}**

Records listed in the report are NOT loaded into the national database.
The top part of the report contains messages from the record-by-record
(first level) validation. The bottom part has messages that occur during
the load of records to the master file when relational validations are
performed. When a CHI or ADD record is rejected in the first level
processing, any related records (by ID) will be rejected in the second
part of the processing. Here is a sample report:

First Level Edit Report for Edit Date: 5/24/96

Record Identifier Error

‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑

99006LAB 00001839 6/20/95 No matching child record found

99006INV 00000369 1/01/93 Duplicate key

99006CHI 00005770 Child is older than 16 at start of year

99006LNK 00000559 00000487 3/01/96FIRST_OCC is after end of quarter

99006ADD 00002554 Duplicate key

Total Records in file: 2630 Total Rejected: 5

Records without errors will be loaded. Errors occurring

during master database load will be listed below.

Second Level/Relational Report of Master Database Load

99006LAB 00001839 5/21/95 Sample date is before date of birth

99006LNK 00004135 00000068 7/03/95No matching child record found

99006INV 00002554 05/03/95 No matching address record found

This is a breakdown of the report above:

+-----+-----+------+------+------+------+--------+------+---------+
| C   | C   | Col  |      | Col  |      |        | Col  | Columns |
| olu | olu | umns |      | umns |      |        | umns | 35-79   |
| mns | mns | 1    |      | 1    |      |        |      |         |
| 1-5 | 6-8 | 0-17 |      | 9-26 |      |        | 2    |         |
|     |     |      |      |      |      |        | 7-34 |         |
+-----+-----+------+------+------+------+--------+------+---------+
| P   | F   | Add  | C    | Add  | Date | Date   | Date | Error   |
| rog | ile | ress | hild | ress | Refe | Sample | F    | Message |
| ram | ID  | ID   | ID   | ID   | rred | Ob     | irst |         |
| ID  |     |      |      |      |      | tained | Occu |         |
|     |     |      |      |      |      |        | pied |         |
+-----+-----+------+------+------+------+--------+------+---------+
| 99  | ADD | 0000 |      |      |      |        |      | Du      |
| 006 |     | 2554 |      |      |      |        |      | plicate |
|     |     |      |      |      |      |        |      | Key     |
+-----+-----+------+------+------+------+--------+------+---------+
| 99  | CHI |      | 0000 |      |      |        |      | Child   |
| 006 |     |      | 5770 |      |      |        |      | is      |
|     |     |      |      |      |      |        |      | older   |
|     |     |      |      |      |      |        |      | than 16 |
|     |     |      |      |      |      |        |      | at      |
|     |     |      |      |      |      |        |      | start   |
|     |     |      |      |      |      |        |      | of year |
+-----+-----+------+------+------+------+--------+------+---------+
| 99  | INV | 0000 |      |      | 01/0 |        |      | Du      |
| 006 |     | 0369 |      |      | 1/93 |        |      | plicate |
|     |     |      |      |      |      |        |      | Key     |
+-----+-----+------+------+------+------+--------+------+---------+
| 99  | LAB |      | 0000 |      |      | 06     |      | No      |
| 006 |     |      | 1839 |      |      | /20/95 |      | m       |
|     |     |      |      |      |      |        |      | atching |
|     |     |      |      |      |      |        |      | child   |
|     |     |      |      |      |      |        |      | record  |
|     |     |      |      |      |      |        |      | found   |
+-----+-----+------+------+------+------+--------+------+---------+
| 99  | LNK |      | 0000 | 0000 |      |        | 03/0 | FI      |
| 006 |     |      | 0487 | 0559 |      |        | 1/96 | RST_OCC |
|     |     |      |      |      |      |        |      | is      |
|     |     |      |      |      |      |        |      | after   |
|     |     |      |      |      |      |        |      | end of  |
|     |     |      |      |      |      |        |      | quarter |
+-----+-----+------+------+------+------+--------+------+---------+
| To  |     |      |      |      |      |        |      |         |
| tal |     |      |      |      |      |        |      |         |
| R   |     |      |      |      |      |        |      |         |
| eco |     |      |      |      |      |        |      |         |
| rds |     |      |      |      |      |        |      |         |
| in  |     |      |      |      |      |        |      |         |
| fi  |     |      |      |      |      |        |      |         |
| le: |     |      |      |      |      |        |      |         |
| 2   |     |      |      |      |      |        |      |         |
| 630 |     |      |      |      |      |        |      |         |
| To  |     |      |      |      |      |        |      |         |
| tal |     |      |      |      |      |        |      |         |
| Rej |     |      |      |      |      |        |      |         |
| ect |     |      |      |      |      |        |      |         |
| ed: |     |      |      |      |      |        |      |         |
| 5   |     |      |      |      |      |        |      |         |
|     |     |      |      |      |      |        |      |         |
| R   |     |      |      |      |      |        |      |         |
| eco |     |      |      |      |      |        |      |         |
| rds |     |      |      |      |      |        |      |         |
| w   |     |      |      |      |      |        |      |         |
| ith |     |      |      |      |      |        |      |         |
| out |     |      |      |      |      |        |      |         |
| err |     |      |      |      |      |        |      |         |
| ors |     |      |      |      |      |        |      |         |
| w   |     |      |      |      |      |        |      |         |
| ill |     |      |      |      |      |        |      |         |
| be  |     |      |      |      |      |        |      |         |
| l   |     |      |      |      |      |        |      |         |
| oad |     |      |      |      |      |        |      |         |
| ed. |     |      |      |      |      |        |      |         |
| Err |     |      |      |      |      |        |      |         |
| ors |     |      |      |      |      |        |      |         |
| occ |     |      |      |      |      |        |      |         |
| urr |     |      |      |      |      |        |      |         |
| ing |     |      |      |      |      |        |      |         |
|     |     |      |      |      |      |        |      |         |
| dur |     |      |      |      |      |        |      |         |
| ing |     |      |      |      |      |        |      |         |
| mas |     |      |      |      |      |        |      |         |
| ter |     |      |      |      |      |        |      |         |
| da  |     |      |      |      |      |        |      |         |
| tab |     |      |      |      |      |        |      |         |
| ase |     |      |      |      |      |        |      |         |
| l   |     |      |      |      |      |        |      |         |
| oad |     |      |      |      |      |        |      |         |
| w   |     |      |      |      |      |        |      |         |
| ill |     |      |      |      |      |        |      |         |
| be  |     |      |      |      |      |        |      |         |
| lis |     |      |      |      |      |        |      |         |
| ted |     |      |      |      |      |        |      |         |
| bel |     |      |      |      |      |        |      |         |
| ow. |     |      |      |      |      |        |      |         |
|     |     |      |      |      |      |        |      |         |
| Sec |     |      |      |      |      |        |      |         |
| ond |     |      |      |      |      |        |      |         |
| L   |     |      |      |      |      |        |      |         |
| eve |     |      |      |      |      |        |      |         |
| l/R |     |      |      |      |      |        |      |         |
| ela |     |      |      |      |      |        |      |         |
| tio |     |      |      |      |      |        |      |         |
| nal |     |      |      |      |      |        |      |         |
| Rep |     |      |      |      |      |        |      |         |
| ort |     |      |      |      |      |        |      |         |
| of  |     |      |      |      |      |        |      |         |
| Mas |     |      |      |      |      |        |      |         |
| ter |     |      |      |      |      |        |      |         |
| Da  |     |      |      |      |      |        |      |         |
| tab |     |      |      |      |      |        |      |         |
| ase |     |      |      |      |      |        |      |         |
| L   |     |      |      |      |      |        |      |         |
| oad |     |      |      |      |      |        |      |         |
+-----+-----+------+------+------+------+--------+------+---------+
| 99  | LAB |      | 0000 |      |      | 05     |      | Sample  |
| 006 |     |      | 1839 |      |      | /21/95 |      | Date is |
|     |     |      |      |      |      |        |      | before  |
|     |     |      |      |      |      |        |      | date of |
|     |     |      |      |      |      |        |      | birth   |
+-----+-----+------+------+------+------+--------+------+---------+
| 99  | LNK |      | 0000 | 0000 |      |        | 07/0 | No      |
| 006 |     |      | 4135 | 0068 |      |        | 3/95 | m       |
|     |     |      |      |      |      |        |      | atching |
|     |     |      |      |      |      |        |      | child   |
|     |     |      |      |      |      |        |      | record  |
|     |     |      |      |      |      |        |      | found   |
+-----+-----+------+------+------+------+--------+------+---------+
| 99  | INV | 0000 |      |      | 05/0 |        |      | No      |
| 006 |     | 2554 |      |      | 3/95 |        |      | m       |
|     |     |      |      |      |      |        |      | atching |
|     |     |      |      |      |      |        |      | address |
|     |     |      |      |      |      |        |      | record  |
|     |     |      |      |      |      |        |      | found   |
+-----+-----+------+------+------+------+--------+------+---------+

**All Record Types**

+-----------------+-----------------------------+---------------------+
| **Error**       | **Description**             | **What to do/How to |
|                 |                             | Correct**           |
+-----------------+-----------------------------+---------------------+
| Invalid file id | Positions 1-3 of the record | STELLAR Users: Call |
|                 | contain something other     | Stellar User        |
|                 | than ADD, CHI, INV, LAB, or | Support at          |
|                 | LNK.                        | 404-639-5957, email |
|                 |                             | <stel@cdc.gov> or   |
|                 |                             | fax concerns to     |
|                 |                             | Stellar User        |
|                 |                             | Support at          |
|                 |                             | 404-639-2570.       |
|                 |                             |                     |
|                 |                             | Non STELLAR Users:  |
|                 |                             | check for           |
|                 |                             | programming error.  |
|                 |                             |                     |
|                 |                             | NOTE: The first     |
|                 |                             | four messages       |
|                 |                             | appearing together  |
|                 |                             | on the error report |
|                 |                             | may indicate a      |
|                 |                             | blank record.       |
+-----------------+-----------------------------+---------------------+
| Invalid Quarter | Position 5 of the record    |                     |
|                 | contains something other    |                     |
|                 | than 1,2,3, or 4 or does    |                     |
|                 | not match the file name.    |                     |
+-----------------+-----------------------------+---------------------+
| Invalid Program | The value in positions 8-12 |                     |
| ID - not on     | does not match a program ID |                     |
| file            | in our reference file.      |                     |
+-----------------+-----------------------------+---------------------+
| Invalid Report  | Positions 6-7 of the record |                     |
| Year            | contain non-numeric         |                     |
|                 | characters or do not match  |                     |
|                 | the file name.              |                     |
+-----------------+-----------------------------+---------------------+
| Invalid ID -    | ID is not valid. Record was |                     |
| delete record   | not processed.              |                     |
| not processed   |                             |                     |
+-----------------+-----------------------------+---------------------+
| PGMID FIPS does | The first two positions of  | STELLAR Users: Call |
| not match state | the program ID are the      | Stellar User        |
| name            | state fips code. The record | Support at          |
|                 | contains an ID which does   | 404-639-5957, email |
|                 | not match the name of       | <stel@cdc.gov> or   |
|                 |                             | fax concerns to     |
|                 | the state which submitted   | Stellar User        |
|                 | the data set.               | Support at          |
|                 |                             | 404-639-2570.       |
|                 |                             |                     |
|                 |                             | Non STELLAR Users:  |
|                 |                             | Check for           |
|                 |                             | programming error.  |
+-----------------+-----------------------------+---------------------+

+-----------------+----------------------------+----------------------+
| **Error**       | **Description**            | **What to do/How to  |
|                 |                            | Correct**            |
+-----------------+----------------------------+----------------------+
| Duplicate       | Indicates two or more      | STELLAR Users: No    |
| Delete          | identical delete           | action.              |
|                 | transactions. The first    |                      |
|                 | transaction is processed   | Non STELLAR Users:   |
|                 | and subsequent deletions   | Check for            |
|                 | are ignored.               | programming error.   |
|                 |                            | No corrective action |
|                 | The error message includes | to CDC needed.       |
|                 | lead level and sample type |                      |
|                 | for validation purposes.   |                      |
+-----------------+----------------------------+----------------------+
| Duplicate Key   | There is more than one     | STELLAR Users: Call  |
|                 | address record with same   | Stellar User Support |
| For record type | ID.                        | at 404-639-5957,     |
| ADD             |                            | email <stel@cdc.gov> |
|                 | *Programmer's Note: There  | or fax concerns to   |
|                 | are two or more records    | Stellar User Support |
|                 | where values in the fields | at 404-639-2570.     |
|                 | FILEID, ACTION, PGMID,     |                      |
|                 | ADDR_ID (positions 1-4 and | Non STELLAR Users:   |
|                 | 8-20) are identical.*      | Have program         |
|                 |                            | determine which      |
|                 |                            | record is correct.   |
|                 |                            | Remove other         |
|                 |                            | duplicate and        |
|                 |                            | resubmit data.       |
+-----------------+----------------------------+----------------------+
| Duplicate Key   | There is more than one     | STELLAR Users: Call  |
|                 | child record with same ID. | Stellar User Support |
| For record type |                            | at 404-639-5957,     |
| CHI             | *Programmer's Note: There  | email <stel@cdc.gov> |
|                 | are two or more records    | or fax concerns to   |
|                 | where values in the fields | Stellar User Support |
|                 | FILEID, ACTION, PGMID,     | at 404-639-2570.     |
|                 | CHILD_ID (positions 1-4    |                      |
|                 | and 8-20) are identical.*  | Non STELLAR Users:   |
|                 |                            | Have program         |
|                 |                            | determine which      |
|                 |                            | record is correct.   |
|                 |                            | Remove other         |
|                 |                            | duplicate and        |
|                 |                            | resubmit data.       |
+-----------------+----------------------------+----------------------+
| Duplicate Key   | There is more than one     | STELLAR Users:       |
|                 | investigation on the same  | Delete incorrect     |
| For record type | dwelling referred on the   | duplicate. Look up   |
| INV             | same day.                  | address record. Go   |
|                 |                            | to the               |
|                 | *Programmer's Note: There  | Investigations       |
|                 | are two or more records    | table. Delete the    |
|                 | where values in the fields | investigation record |
|                 | FILEID, ACTION, PGMID,     | with the least       |
|                 | ADDR_ID, DATE_REF          | amount of completed  |
|                 | (positions 1-4 and 8-28)*  | information. To flag |
|                 | *are identical.*           | the correct record   |
|                 |                            | for a correction     |
|                 |                            | extract, make a      |
|                 |                            | minor change, noting |
|                 |                            | what it was. Save    |
|                 |                            | the record go back   |
|                 |                            | in and change it     |
|                 |                            | back to the original |
|                 |                            | value. Save again.   |
|                 |                            |                      |
|                 |                            | Non STELLAR Users:   |
|                 |                            | Have program         |
|                 |                            | determine which      |
|                 |                            | record is correct.   |
|                 |                            | Remove other         |
|                 |                            | duplicate and        |
|                 |                            | resubmit data.       |
+-----------------+----------------------------+----------------------+

+-----------------+----------------------------+----------------------+
| **Error**       |                            |                      |
| **Description** |                            |                      |
| **What to       |                            |                      |
| do/How to       |                            |                      |
| Correct**       |                            |                      |
+-----------------+----------------------------+----------------------+
| Duplicate Key   | There is more than one     | STELLAR Users:       |
|                 | test on the same day for   | Stellar software is  |
| \[PbB = xxx     | the same child.            | outdated. Install    |
| Type = x\]      |                            | Stellar 3 or email   |
|                 | *Programmer's Note: There  | or fax Stellar User  |
| For record type | are two or more records    | Support to receive   |
| LAB             | where values in the fields | new version.         |
|                 | FILEID, ACTION, PGMID,     |                      |
|                 | CHILD_ID, SAMP_DATE        | This may be an error |
|                 | (positions 1-4 and 8-28)*  | in your database.    |
|                 | *are identical.*           | During a STELLAR     |
|                 |                            | extract, you will    |
|                 |                            | get a report of      |
|                 |                            | these records before |
|                 |                            | you extract so you   |
|                 |                            | can check them. See  |
|                 |                            | your STELLAR manual  |
|                 |                            | for more             |
|                 |                            | information.         |
|                 |                            |                      |
|                 |                            | Non STELLAR Users:   |
|                 |                            | Check the duplicate  |
|                 |                            | records for keying   |
|                 |                            | errors. If multiple  |
|                 |                            | samples were         |
|                 |                            | obtained on a single |
|                 |                            | day, retain the      |
|                 |                            | highest venous       |
|                 |                            | result. If no tests  |
|                 |                            | were venous, retain  |
|                 |                            | the lowest capillary |
|                 |                            | result. See          |
|                 |                            | surveillance         |
|                 |                            | specifications for   |
|                 |                            | more information.    |
|                 |                            | Correct data and     |
|                 |                            | resubmit.            |
+-----------------+----------------------------+----------------------+
| Duplicate Key   | There is more than one     | STELLAR Users: Look  |
|                 | address history record for | up child. View the   |
| For record type | the same child, address,   | address history      |
| LNK             | and first occupied date.   | records. Delete one  |
|                 |                            | duplicate. To flag   |
|                 | *Programmer's Note: There  | the correct record   |
|                 | are two or more records    | for a correction     |
|                 | where values in the fields | extract, make a      |
|                 | FILEID, ACTION, PGMID,     | minor change, noting |
|                 | CHILD_ID, ADDR_ID,         | what it was. Save    |
|                 | FIRST_OCC (positions 1-4,  | the record, go back  |
|                 | 8-28, 30-37) are           | in and change it     |
|                 | identical.*                | back to the original |
|                 |                            | value. Save again.   |
|                 |                            |                      |
|                 |                            | Non STELLAR Users:   |
|                 |                            | Have program         |
|                 |                            | determine which      |
|                 |                            | record is correct.   |
|                 |                            | Remove other         |
|                 |                            | duplicate and        |
|                 |                            | resubmit data.       |
+-----------------+----------------------------+----------------------+
| Duplicate key   | The first record accepted  | These are resolved   |
| removed from    | from the batch (when there | when the duplicates  |
| transaction     | are subsequent duplicates  | listed earlier in    |
| file            | found in the same batch -  | the report are       |
|                 | see above) has been        | resolved.            |
| Duplicate       | removed from the           |                      |
| transaction     | transaction file and       |                      |
| r               | placed in the rejected     |                      |
| emoved-PbB=xxx, | records file. This occurs  |                      |
| Type = x        | at the end of transaction  |                      |
|                 | processing. LAB record     |                      |
|                 | messages also list PbB     |                      |
|                 | level and sample type      |                      |
|                 | code.                      |                      |
+-----------------+----------------------------+----------------------+

**ADD Record Types**

+-----------------------+--------------------+-------------------------+
| **Error**             | **Description**    | **What to do/How to     |
|                       |                    | Correct**               |
+-----------------------+--------------------+-------------------------+
| ADDR_ID must be       | This is a required | STELLAR Users: Call     |
| numeric, zero-filled, | field and must be  | Stellar User Support at |
| \>0                   | formatted as all   | 404-639-5957, email     |
|                       | numeric, not zero. | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error and resubmit      |
|                       |                    | data.                   |
+-----------------------+--------------------+-------------------------+
| COMP_REN must be      | A completion date  | STELLAR Users: Call     |
| blank-START_REN is    | is not valid       | Stellar User Support at |
| blank                 | without a start    | 404-639-5957, email     |
|                       | date.              | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check and correct the   |
|                       |                    | dates and resubmit      |
|                       |                    | data.                   |
+-----------------------+--------------------+-------------------------+
| COMP_REN is earlier   | The completion     | STELLAR Users: Look up  |
| than START_REN        | date is earlier    | the address. Go to the  |
|                       | than the start     | Investigations table.   |
|                       | date.              | Select the              |
|                       |                    | Investigation. Press    |
|                       |                    | \<F5\> for Events.      |
|                       |                    | Select the RENOV event. |
|                       |                    | Correct the date(s).    |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check and correct the   |
|                       |                    | dates and resubmit      |
|                       |                    | data.                   |
+-----------------------+--------------------+-------------------------+
| Invalid COMP_REN      | The date is not in | STELLAR Users: Call     |
| date - mm/dd/yy       | a valid format,    | Stellar User Support at |
|                       | mm/dd/yy, or is    | 404-639-5957, email     |
|                       | not a valid date.  | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       | *Programmer's      | User Support at         |
|                       | Note: Programming  | 404-639-2570.           |
|                       | logic should       |                         |
|                       | include date       | Non STELLAR Users:      |
|                       | validation         | Correct the date. Check |
|                       | routines.*         | for programming error   |
|                       |                    | and resubmit data.      |
+-----------------------+--------------------+-------------------------+
| Invalid county FIPS   | FIPS code in       | STELLAR Users: Call     |
| code: xxx             | message was not    | Stellar User Support at |
|                       | found in the       | 404-639-5957, email     |
|                       | reference file.    | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 40                      |
|                       |                    | 4-639-2570.User-defined |
|                       |                    | codes may only begin    |
|                       |                    | with 4 through 9.       |
|                       |                    |                         |
|                       |                    | Non STELLAR Users: May  |
|                       |                    | be a programming error; |
|                       |                    | correct if necessary.   |
|                       |                    | Correct the FIPS code   |
|                       |                    | and resubmit data.      |
+-----------------------+--------------------+-------------------------+

+-----------------------+--------------------+-------------------------+
| ### E                 |                    |                         |
| rror Description What |                    |                         |
|  to do/How to Correct |                    |                         |
+-----------------------+--------------------+-------------------------+
| County FIPS may not   | This is a required | STELLAR Users: Look up  |
| be blank              | field and may not  | the address. Go to the  |
|                       | be blank.          | Update Address screen   |
|                       |                    | and enter the county in |
|                       |                    | the County field.       |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Complete the county     |
|                       |                    | field and resubmit      |
|                       |                    | data.                   |
+-----------------------+--------------------+-------------------------+
| Invalid RENOVATED     | Renovated must be  | STELLAR Users: Call     |
| code; must be 1,2,3,  | 1,2,3, or 9        | Stellar User Support at |
| or 9                  |                    | 404-639-5957, email     |
|                       |                    | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct data,    |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| Invalid START_REN     | When renovate is 1 | STELLAR Users: Call     |
| date - mm/dd/yy       | (yes) or 3 (more   | Stellar User Support at |
|                       | than once), there  | 404-639-5957, email     |
|                       | must be a valid    | <stel@cdc.gov> or fax   |
|                       | start renovation   | concerns to Stellar     |
|                       | date in the        | User Support at         |
|                       | mm/dd/yy format.   | 404-639-2570.           |
|                       |                    |                         |
|                       | *Programmer's      | Non STELLAR Users:      |
|                       | Note: Programming  | Check for programming   |
|                       | logic should       | error, correct data,    |
|                       | include date       | and resubmit.           |
|                       | validation         |                         |
|                       | routines.*         |                         |
+-----------------------+--------------------+-------------------------+
| Invalid ZIP           | Must be all blank, | STELLAR Users: Call     |
|                       | all numeric (9     | Stellar User Support at |
|                       | digits), or first  | 404-639-5957, email     |
|                       | 5 numeric and last | <stel@cdc.gov> or fax   |
|                       | 4 blank.           | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct zip code |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| START_REN must be     | When RENOVATE is 2 | STELLAR Users: Call     |
| blank when RENOVATE = | (no) or 9          | Stellar User Support at |
| 2 or 9                | (unknown), the     | 404-639-5957, email     |
|                       | start renovation   | <stel@cdc.gov> or fax   |
|                       | date must be       | concerns to Stellar     |
|                       | blank.             | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, check data and   |
|                       |                    | resubmit.               |
+-----------------------+--------------------+-------------------------+

**CHI Record Types**

+-------------------------+--------------------+----------------------+
| **Error**               | **Description**    | **What to do/How to  |
|                         |                    | Correct**            |
+-------------------------+--------------------+----------------------+
| CHEL_TYPE cannot be     | Chelation Type     | STELLAR Users: Call  |
| blank if CHELATED=1     | cannot be blank if | Stellar User Support |
|                         | Chelated is marked | at 404-639-5957,     |
|                         | as Yes.            | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Child is older than 16  | Persons age 16     | STELLAR Users: Check |
| at start of year        | years or older are | the birth date. Also |
|                         | considered adults  | Stellar Software is  |
|                         | and are not        | outdated. Install    |
|                         | included in the    | Stellar 3 or email   |
|                         | national database. | or fax Stellar User  |
|                         |                    | Support to receive   |
|                         |                    | new version.         |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Have program check   |
|                         |                    | the birthdate. Also, |
|                         |                    | check for            |
|                         |                    | programming error.   |
|                         |                    | Correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| CHILD_ID must be        | This is a required | STELLAR Users: Call  |
| numeric, zero-filled,   | field and must be  | Stellar User Support |
| \> 0.                   | formatted as all   | at 404-639-5957,     |
|                         | numeric, not zero. | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Date of birth is after  | Date of birth is   | STELLAR Users:       |
| end of quarter: (date)  | later than last    | Stellar software is  |
|                         | quarter in         | outdated. Install    |
|                         | extract.           | Stellar 3 or email   |
|                         |                    | or fax Stellar User  |
|                         | *Programmer's      | Support to receive   |
|                         | Note: Change       | new version.         |
|                         | programming logic  |                      |
|                         | so records after   | Non STELLAR Users:   |
|                         | end of reporting   | Check for            |
|                         | period are not     | programming error,   |
|                         | extracted.*        | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| FUND_SOURCE cannot be   | Funding Source     | STELLAR Users: Call  |
| blank if CHELATED=1     | cannot be blank if | Stellar User Support |
|                         | Chelated is marked | at 404-639-5957,     |
|                         | as Yes.            | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+

+-------------------------+--------------------+----------------------+
| **Error**               |                    |                      |
| **Description** **What  |                    |                      |
| to do/How to Correct**  |                    |                      |
+-------------------------+--------------------+----------------------+
| Invalid CHELATED code:  | If CHELATED is     | STELLAR Users: Call  |
| Valid: 1, 2, 9          | coded as 1 (yes),  | Stellar User Support |
|                         | then CHEL_TYPE and | at 404-639-5957,     |
|                         | FUND_SOURCE must   | email <stel@cdc.gov> |
|                         | also be coded.     | or fax concerns to   |
|                         | They may be coded  | Stellar User Support |
|                         | as 9 (unknown) but | at 404-639-2570.     |
|                         | may not be blank.  |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid CHEL_TYPE if    | Chelation Type     | STELLAR Users: Call  |
| CHELATED=2              | must be blank if   | Stellar User Support |
|                         | Chelated is marked | at 404-639-5957,     |
|                         | as 2 (no).         | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid CHEL_TYPE if    | Chelation Type     | STELLAR Users: Call  |
| CHELATED=9              | must be blank if   | Stellar User Support |
|                         | Chelated is marked | at 404-639-5957,     |
|                         | as 9 (unknown).    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid Date of birth - | The date of birth  | STELLAR Users: Call  |
| (date)                  | is not formatted   | Stellar User Support |
|                         | as mm/dd/yy or     | a 404-639-5957,      |
|                         | ccyymmdd or is not | email <stel@cdc.gov> |
|                         | a valid date. This | or fax concerns to   |
|                         | is a required      | Stellar User Support |
|                         | field and may not  | at 404-639-2570.     |
|                         | be blank.          |                      |
|                         |                    | Non STELLAR Users:   |
|                         | *Programmer's      | Check for            |
|                         | Note: Programming  | programming error,   |
|                         | logic should       | correct date and     |
|                         | include date       | resubmit.            |
|                         | validation         |                      |
|                         | routines.*         |                      |
+-------------------------+--------------------+----------------------+
| Invalid ETHNIC code:    | Ethnicity must be  | STELLAR Users:       |
| Valid 1, 2, 9           | 1,2, or 9.         | Stellar software is  |
|                         |                    | outdated. Install    |
|                         |                    | Stellar 3 or email   |
|                         |                    | or fax Stellar User  |
|                         |                    | Support to receive   |
|                         |                    | new version.         |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+

+-------------------------+--------------------+----------------------+
| # Error Description Wh  |                    |                      |
| at to do/How to Correct |                    |                      |
+-------------------------+--------------------+----------------------+
| Invalid FUND_SOURCE if  | Funding Source     | STELLAR Users: Call  |
| CHELATED=2              | must be blank if   | Stellar User Support |
|                         | Chelated is marked | at 404-639-5957,     |
|                         | as 2(no).          | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid FUND_SOURCE if  | Funding Source     | STELLAR Users: Look  |
| CHELATED=9              | must be 9 or blank | up the child; select |
|                         | if Chelated is     | the case; select     |
|                         | marked as          | events. Check the    |
|                         | 9(unknown).        | results/fund source  |
|                         |                    | code for chelation   |
|                         |                    | events. User-defined |
|                         |                    | codes are not        |
|                         |                    | acceptable here.     |
|                         |                    | STELLAR Users: Call  |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-5957,     |
|                         |                    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570 if   |
|                         |                    | further help is      |
|                         |                    | required.            |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid GENDER code:    | Gender must be     | STELLAR Users: Call  |
| Valid 1, 2, 9           | 1,2, or 9.         | Stellar User Support |
|                         |                    | at 404-639-5957,     |
|                         |                    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid NPLSZ code:     | NPLSZ must be 1,2, | STELLAR Users: Call  |
| Valid 1, 2, 9           | or 9.              | Stellar User Support |
|                         |                    | at 404-639-5957,     |
|                         |                    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid NPLSM code:     | NPLSM must be 1,2, | STELLAR Users: Call  |
| Valid 1, 2, 9           | or 9.              | Stellar User Support |
|                         |                    | at 404-639-5957,     |
|                         |                    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+

+-------------------------+--------------------+----------------------+
| # Error Description Wh  |                    |                      |
| at to do/How to Correct |                    |                      |
+-------------------------+--------------------+----------------------+
| Invalid NPLSO code:     | NPLSO must be 1,2, | STELLAR Users: Call  |
| Valid 1, 2, 9           | or 9.              | Stellar User Support |
|                         |                    | at 404-639-5957,     |
|                         |                    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid NPLSH code:     | NPLSH must be 1,2, | STELLAR Users: Call  |
| Valid 1, 2, 9           | or 9.              | Stellar User Support |
|                         |                    | at 404-639-5957,     |
|                         |                    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid NPLSP code:     | NPLSP must be 1,2, | STELLAR Users: Call  |
| Valid 1, 2, 9           | or 9.              | Stellar User Support |
|                         |                    | at 404-639-5957,     |
|                         |                    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid NPLSC code:     | NPLSC must be 1,2, | STELLAR Users: Call  |
| Valid 1, 2, 9           | or 9.              | Stellar User Support |
|                         |                    | at 404-639-5957,     |
|                         |                    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+
| Invalid RACE code:      | RACE must be 1,2,  | STELLAR Users: Call  |
| Valid 1, 2, 3, 4, 8, 9  | 3, 4, 8 or 9.      | Stellar User Support |
|                         |                    | at 404-639-5957,     |
|                         |                    | email <stel@cdc.gov> |
|                         |                    | or fax concerns to   |
|                         |                    | Stellar User Support |
|                         |                    | at 404-639-2570.     |
|                         |                    |                      |
|                         |                    | Non STELLAR Users:   |
|                         |                    | Check for            |
|                         |                    | programming error,   |
|                         |                    | correct data, and    |
|                         |                    | resubmit.            |
+-------------------------+--------------------+----------------------+

**INV Record Types**

+-----------------------+-----------------------+---------------------+
| **Error**             | **Description**       | **What to do/How to |
|                       |                       | Correct**           |
+-----------------------+-----------------------+---------------------+
| ABAT_COMP is earlier  | Abatement Completion  | STELLAR Users: Look |
| than INSP_COMP        | Date is earlier than  | up the address. Go  |
|                       | the Date Survey       | to the              |
|                       | Inspection Completed. | Investigations      |
|                       |                       | table. Correct the  |
|                       | *Programmer's Note:   | date(s).            |
|                       | Programming logic     |                     |
|                       | should include date   | Non STELLAR Users:  |
|                       | validation routines.* | Have the program    |
|                       |                       | correct the         |
|                       |                       | date(s). Resubmit   |
|                       |                       | data.               |
+-----------------------+-----------------------+---------------------+
| ADDR_ID must be       | This is a required    | STELLAR Users: Call |
| numeric, zero-filled, | field and must be     | Stellar User        |
| \>0                   | formatted as all      | Support at          |
|                       | numeric, not zero.    | 404-639-5957, email |
|                       |                       | <stel@cdc.gov> or   |
|                       |                       | fax concerns to     |
|                       |                       | Stellar User        |
|                       |                       | Support at          |
|                       |                       | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| DATE_REF is after end | The date the          | STELLAR Users:      |
| of quarter            | investigation was     | Stellar software is |
|                       | referred is after the | outdated. Install   |
|                       | end of the reporting  | Stellar 3 or email  |
|                       | period.               | or fax Stellar User |
|                       |                       | Support to receive  |
|                       | *Programmer's Note:   | new version.        |
|                       | Change programming    |                     |
|                       | logic so records      | Non STELLAR Users:  |
|                       | after end of          | Check for           |
|                       | reporting period are  | programming error,  |
|                       | not extracted.*       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| \_\_\_\_ must be      | Value must be         | STELLAR Users: Call |
| numeric and           | formatted 000000.0    | Stellar User        |
| zero-filled           | and may not include   | Support at          |
|                       | any blanks or special | 404-639-5957, email |
|                       | characters. This      | <stel@cdc.gov> or   |
|                       | message may appear    | fax concerns to     |
|                       | for DUST_FLOOR,       | Stellar User        |
|                       | DUST_SILL, DUST_WELL, | Support at          |
|                       | PAINT, SOIL, or       | 404-639-2570.       |
|                       | WATER.                |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| \_\_\_\_MSR cannot be | If the sample field   | STELLAR Users: Look |
| blank when \_\_\_\_   | is a non-zero value,  | up the address. Go  |
| \>0                   | the unit of measure   | to the              |
|                       | may not be blank.     | Investigations      |
|                       | This message may      | table. Select the   |
|                       | appear for FLOOR_MSR, | Investigation.      |
|                       | SILL_MSR, WELL_MSR,   | Press \<F8\> for    |
|                       | or PAINT_MSR.         | Samples. Fill in    |
|                       |                       | the appropriate     |
|                       |                       | fields.             |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Have program check  |
|                       |                       | and correct the     |
|                       |                       | unit of measure     |
|                       |                       | field. Also, check  |
|                       |                       | for programming     |
|                       |                       | error. Correct data |
|                       |                       | and resubmit.       |
+-----------------------+-----------------------+---------------------+

+-----------------------+-----------------------+---------------------+
| # E                   |                       |                     |
| rror Description What |                       |                     |
|  to do/How to Correct |                       |                     |
+-----------------------+-----------------------+---------------------+
| INSP_COMP date is     | The Date Survey       | STELLAR Users: In   |
| earlier than DATE_REF | Inspection Completed  | the Investigation   |
|                       | is earlier than the   | and Abatement       |
|                       | Date Referred.        | update screen,      |
|                       |                       | correct the         |
|                       | *Programmer's Note:   | date(s).            |
|                       | Programming logic     |                     |
|                       | should include date   | Non STELLAR Users:  |
|                       | validation routines.* | Have the program    |
|                       |                       | correct the         |
|                       |                       | date(s). Also,      |
|                       |                       | check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| INSP_COMP date        | There is a valid code | STELLAR Users: Call |
| missing but paint     | other than 9          | Stellar User        |
| hazard is coded       | (unknown) in the      | Support at          |
|                       | PAINT_HAZ field, but  | 404-639-5957, email |
|                       | no inspection date.   | <stel@cdc.gov> or   |
|                       |                       | fax concerns to     |
|                       |                       | Stellar User        |
|                       |                       | Support at          |
|                       |                       | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| INSP_COMP must be     | There must be Date    | STELLAR Users: In   |
| present if ABAT_COMP  | Survey Inspection     | the Investigation   |
| is present            | Completed if there is | and Abatement       |
|                       | an Abatement          | Update screen,      |
|                       | Completion date.      | correct the         |
|                       |                       | date(s).            |
|                       | *Programmer's Note:   |                     |
|                       | Programming logic     | Non STELLAR Users:  |
|                       | should include date   | Check for           |
|                       | validation routines.* | programming error.  |
|                       |                       | Correct the date(s) |
|                       |                       | and resubmit.       |
+-----------------------+-----------------------+---------------------+
| Invalid date          | The date is not       | STELLAR Users: Call |
| ABAT_COMP: (date)     | formatted as mm/dd/yy | Stellar User        |
|                       | or ccyymmdd, or is    | Support at          |
|                       | not a valid date.     | 404-639-5957, email |
|                       |                       | <stel@cdc.gov> or   |
|                       | *Programmer's Note:   | fax concerns to     |
|                       | Programming logic     | Stellar User        |
|                       | should include date   | Support at          |
|                       | validation routines.* | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct the data,   |
|                       |                       | and resubmit.       |
+-----------------------+-----------------------+---------------------+
| Invalid date          | The date is not       | STELLAR Users: Call |
| DATE_REF: (date)      | formatted as mm/dd/yy | Stellar User        |
|                       | or ccyymmdd, or is    | Support at          |
|                       | not a valid date.     | 404-639-5957, email |
|                       | This is a required    | <stel@cdc.gov> or   |
|                       | field and may not be  | fax concerns to     |
|                       | blank.                | Stellar User        |
|                       |                       | Support at          |
|                       | *Programmer's Note:   | 404-639-2570.       |
|                       | Programming logic     |                     |
|                       | should include date   | Non STELLAR Users:  |
|                       | validation routines.* | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct the data,   |
|                       |                       | and resubmit.       |
+-----------------------+-----------------------+---------------------+
| Invalid date - delete | The INSP_COMP date is | STELLAR Users: Call |
| record not processed  | not a valid date or   | Stellar User        |
|                       | is blank. The record  | Support at          |
|                       | was not deleted.      | 404-639-5957, email |
|                       |                       | <stel@cdc.gov> or   |
|                       | *Programmer's Note:   | fax concerns to     |
|                       | Programming logic     | Stellar User        |
|                       | should include date   | Support at          |
|                       | validation routines.* | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error.  |
|                       |                       | This date is a      |
|                       |                       | required field and  |
|                       |                       | may not be blank.   |
|                       |                       | Resubmit delete     |
|                       |                       | record.             |
+-----------------------+-----------------------+---------------------+

+-----------------------+-----------------------+---------------------+
| # E                   |                       |                     |
| rror Description What |                       |                     |
|  to do/How to Correct |                       |                     |
+-----------------------+-----------------------+---------------------+
| Invalid DWELL_TYPE    | Dwelling Type must be | STELLAR Users: Call |
| code; must be         | 1,2,3,4,5,8, or 9.    | Stellar User        |
| 1,2,3,4,5,8, or 9     |                       | Support at          |
|                       |                       | 404-639-5957, email |
|                       |                       | <stel@cdc.gov> or   |
|                       |                       | fax concerns to     |
|                       |                       | Stellar User        |
|                       |                       | Support at          |
|                       |                       | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| Invalid XXX_MSR; must | This message may also | STELLAR Users: Call |
| be U or P             | appear for FLOOR_MSR, | Stellar User        |
|                       | SILL_MSR, WELL_MSR,   | Support at          |
|                       | or PAINT_MSR.         | 404-639-5957, email |
|                       | PAINT_MSR may also be | <stel@cdc.gov> or   |
|                       | M.                    | fax concerns to     |
|                       |                       | Stellar User        |
|                       |                       | Support at          |
|                       |                       | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check and correct   |
|                       |                       | unit of measure.    |
|                       |                       | Check for           |
|                       |                       | programming error.  |
|                       |                       | Resubmit data.      |
+-----------------------+-----------------------+---------------------+
| Invalid INDHAZ code;  | Industrial Hazard     | STELLAR Users: Call |
| must be 1, 2, or 9    | code is not valid.    | Stellar User        |
|                       | Code should be 1, 2,  | Support at          |
|                       | or 9.                 | 404-639-5957, email |
|                       |                       | <stel@cdc.gov> or   |
|                       |                       | fax concerns to     |
|                       |                       | Stellar User        |
|                       |                       | Support at          |
|                       |                       | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| Invalid date          | The date is not in a  | STELLAR Users: Call |
| INSP_COMP: (date)     | valid format,         | Stellar User        |
|                       | mm/dd/yy or ccyymmdd, | Support at          |
|                       | or is not a valid     | 404-639-5957, email |
|                       | date.                 | <stel@cdc.gov> or   |
|                       |                       | fax concerns to     |
|                       | *Programmer's Note:   | Stellar User        |
|                       | Programming logic     | Support at          |
|                       | should include date   | 404-639-2570.       |
|                       | validation routines.* |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| Invalid OWNERSHIP     | The code for dwelling | STELLAR Users: Call |
| code; must be         | ownership is not      | Stellar User        |
| 1,2,3,4, or 9         | valid. It must be 1-4 | Support at          |
|                       | or 9.                 | 404-639-5957, email |
|                       |                       | <stel@cdc.gov> or   |
|                       |                       | fax concerns to     |
|                       |                       | Stellar User        |
|                       |                       | Support at          |
|                       |                       | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+

+-----------------------+-----------------------+---------------------+
| # E                   |                       |                     |
| rror Description What |                       |                     |
|  to do/How to Correct |                       |                     |
+-----------------------+-----------------------+---------------------+
| Invalid PAINT_HAZ     | The code for paint    | STELLAR Users: Call |
| code; must be         | hazard is not valid.  | Stellar User        |
| 1,2,3,4, or 9         | The code must be 1-4, | Support at          |
|                       | or 9.                 | 404-639-5957, email |
|                       |                       | <stel@cdc.gov> or   |
|                       |                       | fax concerns to     |
|                       |                       | Stellar User        |
|                       |                       | Support at          |
|                       |                       | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| YEAR built is after   | The year the house    | STELLAR Users: Look |
| reporting year        | was built (Year       | up the address, go  |
|                       | Constructed) is after | to the              |
|                       | the reporting year.   | Investigations      |
|                       |                       | table. Select the   |
|                       | *Programmer's Note:   | Investigation.      |
|                       | Change programming    | Correct the year    |
|                       | logic to check for    | constructed field.  |
|                       | valid year.*          |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check and correct   |
|                       |                       | the year            |
|                       |                       | constructed field.  |
|                       |                       | Resubmit data.      |
+-----------------------+-----------------------+---------------------+
| YEAR must be all      | The Year Construction | STELLAR Users: Call |
| numeric (YYYY) or     | field must be all     | Stellar User        |
| blank                 | numeric or blank.     | Support at          |
|                       |                       | 404-639-5957, email |
|                       | *Programmer's Note:   | <stel@cdc.gov> or   |
|                       | Change programming    | fax concerns to     |
|                       | logic to check for    | Stellar User        |
|                       | valid year.*          | Support at          |
|                       |                       | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check for           |
|                       |                       | programming error,  |
|                       |                       | correct data, and   |
|                       |                       | resubmit.           |
+-----------------------+-----------------------+---------------------+
| XRF must be numeric   | Value must be         | STELLAR Users: Call |
| and zero-filled       | formatted 000.0 and   | Stellar User        |
|                       | may not include any   | Support at          |
|                       | blanks or special     | 404-639-5957, email |
|                       | characters.           | <stel@cdc.gov> or   |
|                       |                       | fax concerns to     |
|                       |                       | Stellar User        |
|                       |                       | Support at          |
|                       |                       | 404-639-2570.       |
|                       |                       |                     |
|                       |                       | Non STELLAR Users:  |
|                       |                       | Check and correct   |
|                       |                       | the value. Check    |
|                       |                       | for programming     |
|                       |                       | error. Resubmit     |
|                       |                       | data.               |
+-----------------------+-----------------------+---------------------+

**LAB Record Types**

+-----------------------+--------------------+-------------------------+
| **Error**             | **Description**    | **What to do/How to     |
|                       |                    | Correct**               |
+-----------------------+--------------------+-------------------------+
| CHILD_ID must be      | This is a required | STELLAR Users: Call     |
| numeric, zero-filled, | field and must be  | Stellar User Support at |
| \>0                   | formatted as all   | 404-639-5957, email     |
|                       | numeric, not zero. | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct data,    |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| Invalid date - delete | The SAMP_DATE is   | STELLAR Users: Call     |
| record not processed  | not a valid date.  | Stellar User Support at |
|                       | The delete         | 404-639-5957, email     |
|                       | transaction is     | <stel@cdc.gov> or fax   |
|                       | dropped.           | concerns to Stellar     |
|                       |                    | User Support at         |
|                       | *Programmer's      | 404-639-2570.           |
|                       | Note: Programming  |                         |
|                       | logic should       | Non STELLAR Users:      |
|                       | include date       | Check for programming   |
|                       | validation         | error. This date is a   |
|                       | routines.*         | required field and may  |
|                       |                    | not be blank. Resubmit  |
|                       |                    | delete record.          |
+-----------------------+--------------------+-------------------------+
| Invalid LAB_FUND_SRC  | Code for           | STELLAR Users: Call     |
| code, must be         | Laboratory Funding | Stellar User Support at |
| 1,2,3,8, or 9         | source is not      | 404-639-5957, email     |
|                       | valid. Code must   | <stel@cdc.gov> or fax   |
|                       | be 1,2,3,8, or 9.  | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct data,    |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| Invalid LAB_TYPE      | Code for           | STELLAR Users: Call     |
| code, must be 1,2, or | Laboratory Type is | Stellar User Support at |
| 9                     | not valid. Must be | 404-639-5957, email     |
|                       | 1,2, or 9.         | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct data,    |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| Invalid MEDICAID      | Code for Medicaid  | STELLAR Users: Call     |
| code, must be 1,2, or | is not valid. Must | Stellar User Support at |
| 9                     | be 1,2, or 9.      | 404-639-5957, email     |
|                       |                    | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct data,    |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+

+-----------------------+--------------------+-------------------------+
| # E                   |                    |                         |
| rror Description What |                    |                         |
|  to do/How to Correct |                    |                         |
+-----------------------+--------------------+-------------------------+
| Invalid date          | The date is not in | STELLAR Users: Call     |
| RSLT_RPT_DT: (date)   | a valid format,    | Stellar User Support at |
|                       | mm/dd/yy or        | 404-639-5957, email     |
|                       | ccyymmdd, or is    | <stel@cdc.gov> or fax   |
|                       | not a valid date.  | concerns to Stellar     |
|                       |                    | User Support at         |
|                       | *Programmer's      | 404-639-2570.           |
|                       | Note: Programming  |                         |
|                       | logic should       | Non STELLAR Users:      |
|                       | include date       | Check for programming   |
|                       | validation         | error, correct data,    |
|                       | routines.*         | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| Invalid date          | The date is not in | STELLAR Users: Call     |
| SAMP_ANAZ_DT: (date)  | a valid format,    | Stellar User Support at |
|                       | mm/dd/yy or        | 404-639-5957, email     |
|                       | ccyymmdd, or is    | <stel@cdc.gov> or fax   |
|                       | not a valid date.  | concerns to Stellar     |
|                       |                    | User Support at         |
|                       | *Programmer's      | 404-639-2570.           |
|                       | Note: Programming  |                         |
|                       | logic should       | Non STELLAR Users:      |
|                       | include date       | Check for programming   |
|                       | validation         | error, correct data,    |
|                       | routines.*         | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| Invalid date          | This is a required | STELLAR Users: Call     |
| SAMP_DATE: (date)     | field and must be  | Stellar User Support at |
|                       | formatted as       | 404-639-5957, email     |
|                       | mm/dd/yy or        | <stel@cdc.gov> or fax   |
|                       | ccyymmdd.          | concerns to Stellar     |
|                       |                    | User Support at         |
|                       | *Programmer's      | 404-639-2570.           |
|                       | Note: Programming  |                         |
|                       | logic should       | Non STELLAR Users:      |
|                       | include date       | Check for programming   |
|                       | validation         | error, correct data,    |
|                       | routines.*         | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| Invalid SCRN_SITE     | Code for screening | STELLAR Users: Call     |
| code, must be         | site is not valid. | Stellar User Support at |
| 1,2,3,4,5, or 9       | Must be 1-5, or 9. | 404-639-5957, email     |
|                       |                    | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct data,    |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| Invalid SAMP_TYPE     | Code for sample    | STELLAR Users: Call     |
| code, must be         | type is not valid. | Stellar User Support at |
| 1,2,3,8, or 9         | Must be 1-3, 8, or | 404-639-5957, email     |
|                       | 9.                 | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct data,    |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| Invalid TEST_RSN      | Code for test      | STELLAR Users: Call     |
| code, must be 1,2,3,  | reason is not      | Stellar User Support at |
| or 9                  | valid. Must be     | 404-639-5957, email     |
|                       | 1-3, or 9.         | <stel@cdc.gov> or fax   |
|                       |                    | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct data,    |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+

+-----------------------+--------------------+-------------------------+
| # E                   |                    |                         |
| rror Description What |                    |                         |
|  to do/How to Correct |                    |                         |
+-----------------------+--------------------+-------------------------+
| LAB_ADDR_ID must be   | This field must be | STELLAR Users: Call     |
| numeric, zero-filled  | formatted as all   | Stellar User Support at |
|                       | numeric. If the    | 404-639-5957, email     |
|                       | address is         | <stel@cdc.gov> or fax   |
|                       | unknown, this ID   | concerns to Stellar     |
|                       | should be all      | User Support at         |
|                       | zeroes.            | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error.                  |
+-----------------------+--------------------+-------------------------+
| RESULT must be        | Value must be      | STELLAR Users: Call     |
| numeric, zero-filled  | formatted 000 with | Stellar User Support at |
|                       | no blanks or       | 404-639-5957, email     |
|                       | special            | <stel@cdc.gov> or fax   |
|                       | characters.        | concerns to Stellar     |
|                       |                    | User Support at         |
|                       |                    | 404-639-2570.           |
|                       |                    |                         |
|                       |                    | Non STELLAR Users:      |
|                       |                    | Check for programming   |
|                       |                    | error, correct data,    |
|                       |                    | and resubmit.           |
+-----------------------+--------------------+-------------------------+
| RSLT_RPT_DT date is   | Result reported    | STELLAR Users: Look up  |
| earlier than          | date is earlier    | child. Select the       |
| SAMP_DATE             | than sample        | child, go to View/Edit  |
|                       | obtained date.     | Lab records. Select the |
|                       |                    | lab record. Correct the |
|                       | *Programmer's      | date(s).                |
|                       | Note: Programming  |                         |
|                       | logic should       | Non STELLAR Users:      |
|                       | include date       | Check and correct       |
|                       | validation         | date(s). Resubmit data. |
|                       | routines.*         |                         |
+-----------------------+--------------------+-------------------------+
| SAMP_ANAZ_DT date is  | The sample         | STELLAR Users: Look up  |
| earlier than          | analyzed date is   | child. Select the       |
| SAMP_DATE             | earlier than the   | child, go to View/Edit  |
|                       | sample obtained    | Lab records. Select the |
|                       | date.              | lab record. Correct the |
|                       |                    | date(s).                |
|                       | *Programmer's      |                         |
|                       | Note: Programming  | Non STELLAR Users:      |
|                       | logic should       | Check and correct       |
|                       | include date       | date(s). Resubmit data. |
|                       | validation         |                         |
|                       | routines.*         |                         |
+-----------------------+--------------------+-------------------------+
| SAMP_DATE is after    | The sample date is | STELLAR Users: Stellar  |
| end of quarter        | after the end of   | software is outdated.   |
|                       | the reporting      | Install Stellar 3 or    |
|                       | period.            | email or fax Stellar    |
|                       |                    | User Support to receive |
|                       | *Programmer's      | new version.            |
|                       | Note: Change       |                         |
|                       | programming logic  |                         |
|                       | so records after   |                         |
|                       | end of reporting   |                         |
|                       | period are not     |                         |
|                       | extracted.*        |                         |
+-----------------------+--------------------+-------------------------+

**LNK Record Type**

+--------------------------+--------------------+----------------------+
| **Error**                | **Description**    | **What to do/How to  |
|                          |                    | Correct**            |
+--------------------------+--------------------+----------------------+
| CHILD_ID must be         | This is a required | STELLAR Users: Call  |
| numeric, zero-filled,    | field and must be  | Stellar User Support |
| \>0                      | formatted as all   | at 404-639-5957,     |
|                          | numeric, not zero. | email <stel@cdc.gov> |
|                          |                    | or fax concerns to   |
|                          |                    | Stellar User Support |
|                          |                    | at 404-639-2570.     |
|                          |                    |                      |
|                          |                    | Non STELLAR Users:   |
|                          |                    | Check for            |
|                          |                    | programming error,   |
|                          |                    | correct data and     |
|                          |                    | resubmit.            |
+--------------------------+--------------------+----------------------+
| FIRST_OCC is after end   | The first occupied | STELLAR Users:       |
| of quarter               | date is after the  | Stellar software is  |
|                          | reporting period.  | outdated. Install    |
|                          |                    | Stellar 3 or email   |
|                          | *Programmer's      | or fax Stellar User  |
|                          | Note: Change       | Support to receive   |
|                          | programming logic  | new version.         |
|                          | so records after   |                      |
|                          | end of reporting   |                      |
|                          | period are not     |                      |
|                          | extracted.*        |                      |
+--------------------------+--------------------+----------------------+
| Invalid date - delete    | The FIRST_OCC date | STELLAR Users: Call  |
| record not processed     | is not valid date. | Stellar User Support |
|                          | The delete         | at 404-639-5957,     |
|                          | transaction was    | email <stel@cdc.gov> |
|                          | not processed.     | or fax concerns to   |
|                          |                    | Stellar User Support |
|                          | *Programmer's      | at 404-639-2570.     |
|                          | Note: Programming  |                      |
|                          | logic should       | Non STELLAR Users:   |
|                          | include date       | Check for            |
|                          | validation         | programming error.   |
|                          | routines.*         | This date is a       |
|                          |                    | required field and   |
|                          |                    | may not be blank.    |
|                          |                    | Resubmit delete      |
|                          |                    | record.              |
+--------------------------+--------------------+----------------------+
| Invalid date FIRST_OCC:  | This is a required | STELLAR Users: Call  |
| (date)                   | field and must be  | Stellar User Support |
|                          | formatted as       | at 404-639-5957,     |
|                          | mm/dd/yy or        | email <stel@cdc.gov> |
|                          | ccyymmdd.          | or fax concerns to   |
|                          |                    | Stellar User Support |
|                          | *Programmer's      | at 404-639-2570.     |
|                          | Note: Programming  |                      |
|                          | logic should       | Non STELLAR Users:   |
|                          | include date       | Check for            |
|                          | validation         | programming error,   |
|                          | routines.*         | correct date, and    |
|                          |                    | resubmit.            |
+--------------------------+--------------------+----------------------+
| Invalid date LAST_OCC:   | The date is not in | STELLAR Users: Call  |
| (date)                   | a valid format,    | Stellar User Support |
|                          | mm/dd/yy or        | at 404-639-5957,     |
|                          | ccyymmdd.          | email <stel@cdc.gov> |
|                          |                    | or fax concerns to   |
|                          | *Programmer's      | Stellar User Support |
|                          | Note: Programming  | at 404-639-2570.     |
|                          | logic should       |                      |
|                          | include date       | Non STELLAR Users:   |
|                          | validation         | Check for            |
|                          | routines.*         | programming error,   |
|                          |                    | correct date, and    |
|                          |                    | resubmit.            |
+--------------------------+--------------------+----------------------+

+--------------------------+--------------------+----------------------+
| # Error Description W    |                    |                      |
| hat to do/How to Correct |                    |                      |
+--------------------------+--------------------+----------------------+
| Invalid TYPE_ADDR code,  | The code for       | STELLAR Users: Call  |
| must be 1,2,3,4, or 9    | address type is    | Stellar User Support |
|                          | not valid. Code    | at 404-639-5957,     |
|                          | must be 1-4, or 9. | email <stel@cdc.gov> |
|                          |                    | or fax concerns to   |
|                          |                    | Stellar User Support |
|                          |                    | at 404-639-2570.     |
|                          |                    |                      |
|                          |                    | Non STELLAR Users:   |
|                          |                    | Check for            |
|                          |                    | programming error,   |
|                          |                    | correct data and     |
|                          |                    | resubmit.            |
+--------------------------+--------------------+----------------------+
| LAST_OCC date is earlier | The date last      | STELLAR Users: Look  |
| than FIRST_OCC           | occupied is        | up Child by ID. Go   |
|                          | earlier than the   | to the Child's       |
|                          | date first         | address history.     |
|                          | occupied.          | Select the address.  |
|                          |                    | Correct the date(s). |
|                          | *Programmer's      |                      |
|                          | Note: Programming  | Non STELLAR Users:   |
|                          | logic should       | Correct date(s) and  |
|                          | include date       | resubmit.            |
|                          | validation         |                      |
|                          | routines.*         |                      |
+--------------------------+--------------------+----------------------+
| LINK_ADDR_ID must be     | This is a required | STELLAR Users: Call  |
| numeric, zero-filled,    | field and must be  | Stellar User Support |
| \>0                      | formatted as all   | at 404-639-5957,     |
|                          | numeric, not zero. | email <stel@cdc.gov> |
|                          |                    | or fax concerns to   |
|                          |                    | Stellar User Support |
|                          |                    | at 404-639-2570.     |
|                          |                    |                      |
|                          |                    | Non STELLAR Users:   |
|                          |                    | Check for            |
|                          |                    | programming error,   |
|                          |                    | correct data and     |
|                          |                    | resubmit.            |
+--------------------------+--------------------+----------------------+

**Load to Master File Errors**

Child (CHI) and address (ADD) transactions are loaded first.
Transactions with a delete action code cause the master record matching
the transaction (by unique key) to be deleted. Any other action code
causes an add or replace to the master file. When errors occur, the
transaction record is written to the same BAD file used in the earlier
processing and an error message is added to the report (RPT) file.

+-------------------+-------------------------+------------------------+
| **Error**         | **Description**         | **What to do/How to    |
|                   |                         | Correct**              |
+-------------------+-------------------------+------------------------+
| Address ID        | When loading LAB        | 1\) This message can   |
| xxxxxxxx not      | records, a check is     | mean the ADD was       |
| found             | made to validate the    | rejected in the line   |
|                   | address master record.  | by line checks (top    |
|                   | If the address records  | part of the report).   |
|                   | does not exist, the LAB |                        |
|                   | transaction is rejected | 2\) If Address ID not  |
|                   | and this message is     | previously rejected,   |
|                   | written to the report   | check and correct      |
|                   | file.                   | Address ID.            |
|                   |                         |                        |
|                   |                         | STELLAR Users:         |
|                   |                         |                        |
|                   |                         | 3\) Look up the LAB    |
|                   |                         | record and select the  |
|                   |                         | correct address. If    |
|                   |                         | unknown, delete the    |
|                   |                         | invalid address ID     |
|                   |                         | from the record.       |
|                   |                         |                        |
|                   |                         | 4\) If the address was |
|                   |                         | previously rejected,   |
|                   |                         | correct the address.   |
|                   |                         | To 'flag' the LAB      |
|                   |                         | record to be extracted |
|                   |                         | again, make a minor    |
|                   |                         | change, noting what it |
|                   |                         | was. Save the record,  |
|                   |                         | go back in and change  |
|                   |                         | it back to the         |
|                   |                         | original value. Save   |
|                   |                         | again.                 |
|                   |                         |                        |
|                   |                         | Non STELLAR Users:     |
|                   |                         |                        |
|                   |                         | 3\) If there are many, |
|                   |                         | check for programming  |
|                   |                         | error.                 |
+-------------------+-------------------------+------------------------+

+-------------------+-------------------------+------------------------+
| # Error Des       |                         |                        |
| cription What to  |                         |                        |
| do/How to Correct |                         |                        |
+-------------------+-------------------------+------------------------+
| Duplicate key     | A transaction matches   | STELLAR Users: Stellar |
| with Action = A   | an existing master file | software is outdated.  |
|                   | record (by key) but the | Install Stellar 3.4a   |
|                   | transaction is marked   | or call Stellar User   |
|                   | as a new record         | Support at             |
|                   | (action=A, for Add).    | 404-639-5957, email    |
|                   | The transaction is      | <stel@cdc.gov> or fax  |
|                   | rejected and this       | concerns to Stellar    |
|                   | message is written to   | User Support at        |
|                   | the report file.        | 404-639-2570.          |
|                   |                         |                        |
|                   |                         | Non STELLAR Users: If  |
|                   |                         | the record is an       |
|                   |                         | update or a            |
|                   |                         | replacement for an     |
|                   |                         | existing record,       |
|                   |                         | change the Action code |
|                   |                         | to \"C\" and resubmit. |
|                   |                         |                        |
|                   |                         | If CHI or ADD record   |
|                   |                         | type is rejected and   |
|                   |                         | this is a *new* child  |
|                   |                         | or address, the child  |
|                   |                         | or address ID is       |
|                   |                         | incorrect. It has      |
|                   |                         | already been used.     |
|                   |                         | Correct your           |
|                   |                         | programming logic      |
|                   |                         | and/or database system |
|                   |                         | to assign new, unique  |
|                   |                         | ID numbers. Correct    |
|                   |                         | the CHI and/or ADD     |
|                   |                         | records and resubmit.  |
|                   |                         |                        |
|                   |                         | If a CHI or ADD record |
|                   |                         | is resubmitted, you    |
|                   |                         | must also resubmit any |
|                   |                         | LAB, LNK, and INV      |
|                   |                         | records which are      |
|                   |                         | rejected in the same   |
|                   |                         | file. If the ID is     |
|                   |                         | changed in the CHI or  |
|                   |                         | ADD record(s), correct |
|                   |                         | it in the LAB, LNK,    |
|                   |                         | and INV records also.  |
|                   |                         |                        |
|                   |                         | ***Warning*** If you   |
|                   |                         | change a CHI record to |
|                   |                         | "C" and it has a       |
|                   |                         | different DOB (date of |
|                   |                         | birth) than the        |
|                   |                         | matching CHI in the    |
|                   |                         | master file, it will   |
|                   |                         | cause a DELETE in the  |
|                   |                         | CDC database of the    |
|                   |                         | existing child and     |
|                   |                         | related information.   |
|                   |                         | You must resubmit ALL  |
|                   |                         | related information or |
|                   |                         | previously submitted   |
|                   |                         | records will be lost.  |
+-------------------+-------------------------+------------------------+

+------------------+-------------------------+------------------------+
| # Error Descr    |                         |                        |
| iption What to d |                         |                        |
| o/How to Correct |                         |                        |
+------------------+-------------------------+------------------------+
| Matching ADD was | An address record in    | STELLAR Users: Call    |
| rejected         | the same file was       | Stellar User Support   |
|                  | rejected as a Duplicate | at 404-639-5957, email |
|                  | Key. All LAB, LNK, or   | <stel@cdc.gov> or fax  |
|                  | INV records which       | concerns to Stellar    |
|                  | relate to that ADD      | User Support at        |
|                  | record are also         | 404-639-2570.          |
|                  | rejected.               |                        |
|                  |                         | Non STELLAR Users:     |
|                  |                         | Resubmit with the      |
|                  |                         | corrected ADD record.  |
|                  |                         | If address ID was      |
|                  |                         | changed in ADD record, |
|                  |                         | change ID to match.    |
+------------------+-------------------------+------------------------+
| Matching CHI was | A child record in the   | STELLAR Users: Call    |
| rejected         | same file was rejected  | Stellar User Support   |
|                  | as a Duplicate Key. All | at 404-639-5957, email |
|                  | LAB and LNK records     | <stel@cdc.gov> or fax  |
|                  | which relate to that    | concerns to Stellar    |
|                  | CHI record are also     | User Support at        |
|                  | rejected.               | 404-639-2570.          |
|                  |                         |                        |
|                  |                         | Non STELLAR Users:     |
|                  |                         | Resubmit with the      |
|                  |                         | corrected CHI record.  |
|                  |                         | If child ID was        |
|                  |                         | changed in CHI record, |
|                  |                         | change ID to match.    |
+------------------+-------------------------+------------------------+
| No matching      | When loading LNK        | 1\) This message can   |
| child record     | records, a check is     | mean the CHI or ADD    |
| found            | made to validate the    | record was rejected    |
|                  | existence of the master | during the line by     |
| No matching      | records for the child   | line check.            |
| address record   | (ID) and address (ID).  |                        |
| found            | If either of the master | STELLAR Users:         |
|                  | records is missing, the |                        |
|                  | LNK transaction is      | 2\) When rejected CHI  |
|                  | rejected and one of     | (child) or ADD         |
|                  | these messages is       | (address) records are  |
|                  | written to the report   | corrected or changed,  |
|                  | file.                   | (all of) the           |
|                  |                         | associated LNK, LAB,   |
|                  |                         | INV records(s) will be |
|                  |                         | extracted in the next  |
|                  |                         | extract.               |
|                  |                         |                        |
|                  |                         | Non STELLAR Users:     |
|                  |                         |                        |
|                  |                         | 1\) If child/address   |
|                  |                         | records are corrected  |
|                  |                         | and resubmitted, all   |
|                  |                         | of the associated      |
|                  |                         | records should also be |
|                  |                         | resubmitted.           |
|                  |                         |                        |
|                  |                         | 2\) If there are many, |
|                  |                         | check for programming  |
|                  |                         | error.                 |
+------------------+-------------------------+------------------------+

+------------------+-------------------------+------------------------+
| #                |                         |                        |
| #### Error Descr |                         |                        |
| iption What to d |                         |                        |
| o/How to Correct |                         |                        |
+------------------+-------------------------+------------------------+
| No matching      | When loading INV        | 1\) This message can   |
| address found    | records, a check is     | mean the ADD was       |
|                  | made to validate the    | rejected in the line   |
|                  | existence of the master | by line checks.        |
|                  | address (ID). If the    |                        |
|                  | ADD record is missing,  | STELLAR Users:         |
|                  | the INV transaction is  |                        |
|                  | rejected and this       | 2\) When rejected CHI  |
|                  | message is written to   | (child) or ADD         |
|                  | the report file.        | (address) records are  |
|                  |                         | corrected or changed,  |
|                  |                         | (all of) the           |
|                  |                         | associated LNK, LAB,   |
|                  |                         | INV records(s) will be |
|                  |                         | extracted in the next  |
|                  |                         | extract.               |
|                  |                         |                        |
|                  |                         | Non STELLAR Users:     |
|                  |                         |                        |
|                  |                         | 1\) If child/address   |
|                  |                         | records are corrected  |
|                  |                         | and resubmitted, all   |
|                  |                         | of the associated      |
|                  |                         | records should also be |
|                  |                         | resubmitted.           |
|                  |                         |                        |
|                  |                         | 2\) If Address ID not  |
|                  |                         | previously rejected,   |
|                  |                         | check and correct      |
|                  |                         | Address ID.            |
|                  |                         |                        |
|                  |                         | 3\) If there are many, |
|                  |                         | check for programming  |
|                  |                         | error.                 |
+------------------+-------------------------+------------------------+

+-------------------+-------------------------+------------------------+
| # Error Des       |                         |                        |
| cription What to  |                         |                        |
| do/How to Correct |                         |                        |
+-------------------+-------------------------+------------------------+
| No matching child | When loading LAB        | 1\) This message can   |
| record found      | records, a check is     | mean the CHI record    |
|                   | made to validate the    | was rejected during    |
|                   | child master record. If | the line by line       |
|                   | the child record does   | check.                 |
|                   | not exist, the LAB      |                        |
|                   | transaction is rejected | STELLAR Users:         |
|                   | and this message is     |                        |
|                   | written to the report   | 2\) When rejected CHI  |
|                   | file.                   | (child) or ADD         |
|                   |                         | (address) records are  |
|                   |                         | corrected or changed,  |
|                   |                         | (all of) the           |
|                   |                         | associated LNK, LAB,   |
|                   |                         | INV records(s) will be |
|                   |                         | extracted in the next  |
|                   |                         | extract.               |
|                   |                         |                        |
|                   |                         | Non STELLAR Users:     |
|                   |                         |                        |
|                   |                         | 1\) If child/address   |
|                   |                         | records are corrected  |
|                   |                         | and resubmitted, all   |
|                   |                         | of the associated      |
|                   |                         | records should also be |
|                   |                         | resubmitted.           |
|                   |                         |                        |
|                   |                         | 2\) If Child ID not    |
|                   |                         | previously rejected,   |
|                   |                         | check and correct      |
|                   |                         | Child ID.              |
|                   |                         |                        |
|                   |                         | 3\) If there are many, |
|                   |                         | check for programming  |
|                   |                         | error.                 |
+-------------------+-------------------------+------------------------+
| Sample date is    | The lab sample date is  | STELLAR Users: Check   |
| before date of    | compared to the date of | and correct the        |
| birth             | birth in the master     | date(s).               |
|                   | child record. It is     |                        |
|                   | earlier than date of    | Non STELLAR Users:     |
|                   | birth.                  | Check and correct the  |
|                   |                         | date(s). Resubmit the  |
|                   |                         | child record, if       |
|                   |                         | changed. Resubmit the  |
|                   |                         | lab record.            |
+-------------------+-------------------------+------------------------+

**[Alert Report - \*\*\*\*\*.ALT]{.underline}**

The second report is the Alert report. Pictured below is a sample Alert
Report showing at least one of each possible type of message that may
occur during surveillance data processing. The records referenced in
this report **are** loaded to the master files, but represent a
situation which is unusual or out of the ordinary. If you cannot
validate one or more of the items, let us know and they will be excluded
from any reports/tables that are produced.

The top portion of the sample report (The following ADD records\....)
will only appear when one or more address records in the data contain
county FIPS codes which are not included in our FIPS reference file.
It\'s possible for STELLAR users to assign user-defined FIPS codes to
represent counties/geographic areas which are not in their state or are
defined with geographic boundaries other than county/borough/parish with
standard FIPS codes.

In the next part of the report, the first line and all the "header"
lines will always appear whether or not any records are listed. The most
common "alert" items are PbB results greater than 69 and PbB test draw
date or sample date is the same as the child\'s date of birth. Results
greater than 69 are generally correct and same sample and date of birth
are usually errors.

The Child ID or Address ID will be listed for each message. To look up a
child by Child ID in STELLAR, go to Data Entry, Child/Case. Check the
information in the database against the original record. If there is a
keying error, correct errors and resubmit data. If you cannot validate
one or more of the items, let us know and they will be excluded from any
reports/tables that are produced.

+-----------------------------------+-----------------------------------+
| # Common Alert Items              | **What to do/How to               |
|                                   | Correct\.....**                   |
+-----------------------------------+-----------------------------------+
| Dwelling type is 2 - Day Care or  | On the report, for every line     |
| 5 - School                        | annotate with one of these three  |
|                                   | answers:                          |
|                                   |                                   |
|                                   | Ok - If the value is correct      |
|                                   |                                   |
|                                   | Corrected - If the value has been |
|                                   | corrected in the database and is  |
|                                   | included in a corrections         |
|                                   | extract. If you only have a few,  |
|                                   | and wish for us to make the       |
|                                   | corrections, put the correct      |
|                                   | values next to the annotation on  |
|                                   | the report.                       |
|                                   |                                   |
|                                   | Cannot Validate - If you cannot   |
|                                   | confirm whether or not the value  |
|                                   | is correct.                       |
+-----------------------------------+-----------------------------------+
| Invalid Year of Construction (if  |                                   |
| the year is \>0000 and \<1700).   |                                   |
+-----------------------------------+-----------------------------------+
| PbB result is \> 69               |                                   |
+-----------------------------------+-----------------------------------+
| Sample date same as date of birth |                                   |
+-----------------------------------+-----------------------------------+
| Invalid county FIPS code          | STELLAR Users: Call Stellar User  |
|                                   | Support at 404-639-5957, email to |
|                                   | <stel@cdc.gov> or fax concerns to |
|                                   | Stellar User Support at           |
|                                   | 404-639-2570. If user-defined     |
|                                   | code send CDC an E-mail with      |
|                                   | explanation of user-defined code. |
|                                   |                                   |
|                                   | Non STELLAR Users: Correct the    |
|                                   | FIPS code or send CDC an E-mail   |
|                                   | with explanation of user-defined  |
|                                   | code.                             |
|                                   |                                   |
|                                   | NOTE: User-defined FIPS codes may |
|                                   | be assigned when coordinated with |
|                                   | CDC Surveillance Technical        |
|                                   | support. User-defined fips codes  |
|                                   | must begin with 4 through 9.      |
+-----------------------------------+-----------------------------------+

If you make any corrections to your database, you must do a 'Corrections
Extract'. However, if you only have a couple of corrections, we have
browse and update capability and can make a [small]{.underline} number
of changes manually (you must still update your database with
corrections).

Please return a copy of the alert report file annotated as instructed
above. You may use any text editor to edit and save the file, and return
to CDC or your state lead surveillance office (if instructed) as an
email attachment.