HearAid Version 5.0

Identifiers

Identifiers

Previous topic Next topic  

Identifiers

Previous topic Next topic  

HearAid uses a number of identifiers to uniquely identify and connect database records. The two most important identifiers are:

 

1.A Primary Key which is typically an integer, or whole number. The primary key is allocated sequentially, every time a new record is added to a table. Users of HearAid Version 4.0 may recognise that this is similar to the CAKE key in that version. The primary key must be unique and if, for any reason, an attempt is made to add new record with a duplicate primary key Firebird will generate an error message

 

2.A Record ID which is a 36-character sequence which is guaranteed to be unique (GUID). The Record ID is used when importing data or synchronising databases

 

Primary keys perform a vital function in a relational database: they uniquely connect data in different tables. For example, the primary key for the Clients table is called CLIENT_PK, while the primary key for the Claims table is CLAIM_PK. However, each record in the Claims table also has a field called CLIENT_PK which tells the database which client owns each particular claim record. Using integers to form these connections allows the database to very quickly form linkages which are used to retrieve data in queries. While the Record ID could also be used for this purpose, making connections between strings of letters and numbers 36-characters long is much less efficient and slower. The Record ID intentionally adds a layer of redundancy which is used to cross-check data integrity when combining databases.

It is strongly recommended that you do not manually modify either Primary Keys or Record IDs without first consulting HearSoft Pty Ltd!

The Identifiers section of the data entry work areas displays the primary key, the record ID, a Tag and the date the record was last updated.

The Client Details Identifiers section also stores other useful information such as DVA, Medicare and CentreLink number, employer and insurance references, an external ID code (such as a hospital medical record number) and an account number for your financial system.