FirstName field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 14: Line 14:
See also [[LastName field]].
See also [[LastName field]].


== Name changes over time ==
'''Enter the patient name as in EPR.'''
 
== Data Processing at main office ==
===Name changes over time ===
When people change names, eg marriage, the [[Data Processor]] changes all old records to be consistent with the current one.
 
<!-- if this changes, update [[Biographic changes over time]] -->
<!-- if this changes, update [[Biographic changes over time]] -->
If an inconsistency is found between old and current records,  
If an inconsistency is found between old and current records,  
Line 21: Line 26:
* we change the old entries to be consistent with the most current entry  
* we change the old entries to be consistent with the most current entry  
<!-- confirmed w Pagasa 2017-11-15 -->  
<!-- confirmed w Pagasa 2017-11-15 -->  
{{Discuss | who=Pagasa | question = under [[#Legacy info]] it said we stopped messing with names so cross checks with old data would work. If we no longer do that we should fix the reasoning there. }}
EPR uses the name used at admission time. Our old records therefore become inconsistent with EPR.
When people change names, eg marriage, the [[Data Processor]] changes all old records to be consistent with the current one.


{{Discuss | who=Pagasa | question = please confirm what we actually do now:
Information about other names for the patient may be available in [[Alias ID collection]].
* in case of a typo
* in case of a change
* do you use the [[Alias ID collection]] for this? }}


{{Guideline Minimal Data Set}}
{{Guideline Minimal Data Set}}
Line 39: Line 36:


== Legacy info ==
== Legacy info ==
{{LegacyContent
|explanation=we used to change names around for consistency but stopped doing this.
|successor=use rules above
|content=
We used to standardize names to make it easier to keep them consistent over time. We decided to stop using our own standards to make it facilitate comparison with Manitoba Health and similar data. 13:34, 2015 April 27 (CDT)
We used to standardize names to make it easier to keep them consistent over time. We decided to stop using our own standards to make it facilitate comparison with Manitoba Health and similar data. 13:34, 2015 April 27 (CDT)
It used to be:
It used to be:
Line 44: Line 45:
* for first names we decided not to use hyphens if there was more than one, and to preferrably only have one first name used
* for first names we decided not to use hyphens if there was more than one, and to preferrably only have one first name used
* last names that use two names were hyphenated
* last names that use two names were hyphenated
}}


== Related Articles ==
== Related Articles ==

Latest revision as of 11:25, 2019 October 23

Data Element (edit)
Field Name: FirstName
CCMDB Label: First Name
CCMDB tab: Top Row
Table: L_Log table, L_PHI table
Data type: string
Length: 40
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 3

Last Name of patient

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


See also LastName field.

Enter the patient name as in EPR.

Data Processing at main office

Name changes over time

When people change names, eg marriage, the Data Processor changes all old records to be consistent with the current one.

If an inconsistency is found between old and current records,

  • edit only if there is something incorrect, e.g. a typo
  • use the value in the EPR for the correction
  • we change the old entries to be consistent with the most current entry

Information about other names for the patient may be available in Alias ID collection.

Minimal Data Set

This entry is part of the Minimal Data Set. Special collection instructions apply, see that page for more info.

L_PHI vs L_Log

This field is stored in the L_PHI table in CFE but in the L_Log table in CCMDB.accdb. See L_PHI table for details why.

Data Integrity Checks (automatic list)

 AppStatus
Check duplicate patientCCMDB.accdbimplemented
Query check minimal data set incompleteCCMDB.accdbimplemented
Check function Validate First nameCCMDB.accdbimplemented
PL Diff Phin SameLN FN DOBCentralized data front end.accdbimplemented

Legacy info

Legacy Content

This page contains Legacy Content.
  • Explanation: we used to change names around for consistency but stopped doing this.
  • Successor: use rules above

Click Expand to show legacy content.

We used to standardize names to make it easier to keep them consistent over time. We decided to stop using our own standards to make it facilitate comparison with Manitoba Health and similar data. 13:34, 2015 April 27 (CDT) It used to be:

  • if a name changed we retained the original one and changed new encounters of the patient to the old one.
  • for first names we decided not to use hyphens if there was more than one, and to preferrably only have one first name used
  • last names that use two names were hyphenated


Related Articles

Related articles: