Step 2: Check the database to avoid duplications


Position the cursor on the Person Number field, then press the ‘F8=Lookup*’ key.
The program will display the “Lookup Person Number” parameter screen.

Key the search parameters.
Do you know the person's Social Security Number?
If yes, key the number into the ‘SSN’ field, then press Enter.
– or – 
Else, key all -- or part -- of the person's Last Name and First Name, then press Enter.
Use the beginning letters of either name 
rather than using the Sounds Like function.

You can also search by Street Name.
We do not recommend searching by Age Range, Sounds Like, or Sex.

Examine the list of possibilities.
Did the search parameters produce any possibilities?
If so, try to identify the person by full name, age, and/or sex.

If the person you seek is on the list, you do not need to a record to the file.
Press the ‘F12=Previous’ key.
Press the ‘F3=Exit’ key to leave the lookup program.
If the person is not on the list, you might try changing the search parameters.
Press the ‘F12=Previous’ to change the parameters.

ONECase cannot assure agency workers will not duplicate a person in the database -- that is, define a single individual in more than one data record. Before adding a new Person, the worker should search the database thoroughly using "Lookup Person Number" to determine whether the person has already been set up in the database. The program gives the worker a red warning message when the worker attempts to add a new Person with a Social Security Number that is already defined for another Person record in the database. 

Parameter screen

.
CS4000-1 H Lookup Person Number 9/03/98 
8:04:36 


SSN........ 
AND
Last First 
Name....... 
or 
Sounds Like 
or 
Street Name Str Nbr City State 
Address.... 

or 
School ID.* 
and 

Age Range.. thru and/or Sex........ 

Enter F3=Exit F8=Lookup* F24=Zip 




. CS4000-2 H Lookup Person Number 9/03/98
9:24:30
Name........ Sex.........
Phonetic.... Age Range... thru
Address..... SSN......... 273728138

_S___Title_First_Name_________Middle_Name________Last_Name__________Sfx___Age_S
_ Mr. Thomas Ned Smith 49
_ Thomas Smithe 49

...

Key any character to select 1 record, press Enter when finished.
* = Person Not Active F12=Previous F17=Fold/Unfold
.

.
CS4000-2 H Lookup Person Number 9/03/98 
8:08:09 
Name..... Cox SSN..... Sex. 
Phonetic. Age Range. - School 
Address.. 
S Title First Name Middle Name Last Name Sfx Age S 
Billy Cox 
Miss Elizabeth Gwin Cox 23 
Jill Cox 3 
John Cox 
Mildred Cox 50 
Mildred Cox 
Millicent Cox 
Nancy Faris Cox 78 
Mr Robert Dalton Cox 17 
Thomas Cox 
Mr. Thomas Edward Cox Jr 52 
Thomas Miles Cox 20 
Timothy Cox 20 
Mr Tom Cox 

Key any character to select 1 record, press Enter when finished. 
* = Person Not Active F12=Previous F17=Fold/Unfold F24=Zip