SQL Import Reference

Edit

Table/s

Field/s

Import Notes

Code Conversion Notes

Future notes

SQL Table

tblClients

All Fields

Import Complete
New field added, fldSavedBy
Saved to tblIDCompare under tblClient

Yes

SQL Table

tblCostCentre

All Fields

To combine with tblGroups

SQL Table

tblGroups

All Fields

To swallow tblCostCentre

SQL Field

tblCostCentre

fldNonCRU

Yes

Replace with a table of Unit Types

SQL Field

tblCostCentre

fldUpdated

Redundant - check after code conversion

SQL Field

tblCostCentre

fldEmailHS, fld Email etc etc

Replace with Table or User Role Emails for Houses

The Human Services Professionals