Row in a Database Table. It Is Essay

Total Length: 629 words ( 2 double-spaced pages)

Total Sources: 4

Page 1 of 2

row in a database table. It is coded (or 'keyed') so that access to that information can be faster. An example particularly relevant to the field of Health Information Management System, where multiple data is coded and organized in Health-related organizations, would be the names of employees in the hospital. These names would be entered in the database with personal information about each. The key -- or identifier - accorded to each employee would be termed the Primary Key (PK). Initials could be used but that might be confusing were two or more employees to share the same initials. Many organizations use Social Security Numbers as identifiers, but since their use is controversial due to privacy concerns, most organizations have created their own unique identifiers such as (in a health system) employee ID or patient ID, and so forth which they then enter into the database and which the data base system enforces by reminding management, in the event that a duplicate key is inserted, that this code already exists (Chapple, Web).

The Master Patient Index (MPI)

The Master Patient Index (MPI) (otherwise known as the Patient Master Index (MPI) or the EMPI (Enterprise Master Patient Index) (HealthInformatics, Web) is a database that allocates a Primary Key for patient medical record entries on a national and sub-national level.
Each patient is registered under a Primary key. This Primary key - called an integration control number and based on a patient's national ID or residency number (VHA, 2008) - ensures that the patient is repeated only once through the entire system and that this particular set of clinical and demographic information is not accidentally replicated.

The American Health Information Management Association (AHIMA) recommends some of the following date elements to be included under each Primary Key (or patient) stub: Patient name; Date of birth; Gender; Race; Ethnicity; Address; Alias or previous name; Social….....

Show More ⇣


     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Row In A Database Table It Is" (2010, December 06) Retrieved June 17, 2026, from
https://www.aceyourpaper.com/essays/row-database-table-49220

Latest MLA Format (8th edition)

Copy Reference
"Row In A Database Table It Is" 06 December 2010. Web.17 June. 2026. <
https://www.aceyourpaper.com/essays/row-database-table-49220>

Latest Chicago Format (16th edition)

Copy Reference
"Row In A Database Table It Is", 06 December 2010, Accessed.17 June. 2026,
https://www.aceyourpaper.com/essays/row-database-table-49220