Problem writing Pseudocode

[osimini1]

How can I write a structured English Pseudocode for matching two – to extract matching data record from the table called “tblState” to update called tblCity. Below are the fields. I wan to extract NPI number from the tblState and update into tblCity. I am looking for Pseudocode for (a) matching, (b) validation, (c) update the record to tblCity table. Please really need somebody’s help.

tblState
NPI
Org_Name
Practice Address
Zip
State code
Identifer ID
Primary Taxanomy


tblCity
Org_Name
Practice Address
Zip
State code
Identifier_ID
Primary Taxanomy

 

[randy700]

Why would you want two identical tables?
Where in tblCity would you put the NPI?
Is the Identifier ID a unique value?


Randy

 

[osimini1]

Randy,

Firstly, thank you very much for helping. Here is the issue. tblCity has a field called NPI also but may not be populated or may be deactivated. tblState has customers in other cities but I am only interested in city called Culver and its zip codes. Also, tblState have other fields that are not in tblCity and I don't care about those fields. For exampe here is what I put together and is wrong
MATCH Provider_Information with Provider_Record using provider’s Name, Practice_Address, Practice_Zip, Primary_taxanomy_Code and Provider_Identifier _Code

Updating Provider File

For each item accepted record do
Search provider file using provider identifier code
If successful Then
Update retrieved provider record;
Write update record to provider master file using accepted record
Else
Create new record in provider master file;
Enter accepted record in provider master file
End if
End for