LastName field: Difference between revisions
Jump to navigation
Jump to search
m →Corrections to names: changed |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (22 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
| CCMDB_tab = Top Row | | CCMDB_tab = Top Row | ||
| element_description = Last Name of patient | | element_description = Last Name of patient | ||
| in_table = L_Log | | in_table = L_Log table, L_PHI table | ||
| data_type = string | | data_type = string | ||
| datafield_length = 40 | | datafield_length = 40 | ||
| Line 12: | Line 12: | ||
}} | }} | ||
See also [[ | See also [[FirstName field]]. | ||
== | '''Enter the patient name as in EPR.''' | ||
== Data Processing at main office == | |||
===Name changes over time === | |||
Also see [[Biographic changes over time]] | |||
If an inconsistency is found between old and current records, | If an inconsistency is found between old and current records, | ||
* edit only if there is something incorrect, e.g. a typo | * edit only if there is something incorrect, e.g. a typo | ||
* use the value in the EPR for the correction | * use the value in the EPR for the correction | ||
* we change the old entries to be consistent with the most current entry <!-- confirmed w Pagasa 2017-11-15 --> | |||
Information about other names for the patient may be available in [[Alias ID collection]]. | |||
See also: [[Crosschecking data with Manitoba Health]] | See also: [[Crosschecking data with Manitoba Health]] | ||
{{Guideline Minimal Data Set}} | |||
{{PHI_Data}} | {{PHI_Data}} | ||
{{Data Integrity Check List}} | |||
== Legacy info == | == Legacy info == | ||
We used to standardize names to make it easier to keep them consistent over time. We decided to stop using our own standards to | {{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 facilitate comparison with Manitoba Health and similar data. 13:34, 2015 April 27 (CDT) | |||
It used to be: | It used to be: | ||
* if a name changed we retained the original one and changed new encounters of the patient to the old one. | * 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 preferably only have one first name used | * for first names we decided not to use hyphens if there was more than one, and to preferably 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}} | |||
[[Category: | [[Category:Standards and Conventions]] | ||
[[Category:Data Collection Guide]] | |||
[[Category:Registry Data]] | |||
[[Category:Patient Viewer]] | |||
[[Category:Data Processing]] | |||
[[Category:Demographics]] | |||
Latest revision as of 10:34, 30 July 2025
| Data Element (edit) | |
| Field Name: | LastName |
| CCMDB Label: | Last 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: | 2 |
| Data Dependencies(Reports/Indicators/Data Elements): | No results |
Last Name of patient
See also FirstName field.
Enter the patient name as in EPR.
Data Processing at main office
Name changes over time
Also see Biographic changes over time 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.
See also: Crosschecking data with Manitoba Health
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)
| App | Status | |
|---|---|---|
| Check duplicate patient | CCMDB.accdb | implemented |
| Query check minimal data set incomplete | CCMDB.accdb | implemented |
| Check function Validate Last name | CCMDB.accdb | implemented |
| PL DiffPhin SameLN FN DOB | Centralized data front end.accdb | implemented |
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 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 preferably only have one first name used
- last names that use two names were hyphenated