LastName field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "| DIC_app" to "| DIC_timing = complete always | DIC_app" |
||
| Line 31: | Line 31: | ||
| DIC_related_concepts = [[LastName field]] | | DIC_related_concepts = [[LastName field]] | ||
| DIC_firmness = hard check | | DIC_firmness = hard check | ||
| DIC_timing = complete always | |||
| DIC_app = CCMDB.mdb | | DIC_app = CCMDB.mdb | ||
| DIC_coding = function ''Validate_Last_name'' | | DIC_coding = function ''Validate_Last_name'' | ||
Revision as of 12:55, 25 September 2018
| 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 |
Last Name of patient
See also LastName field.
Corrections to names
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
See also: Crosschecking data with Manitoba Health
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.
Cross Checks
| Data Integrity Checks | |
| Summary: | * can't be blank
|
| Related: | [[LastName field]] |
| Firmness: | hard check |
| Timing: | complete always |
| App: | CCMDB.mdb |
| Coding: | function Validate_Last_name |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2008-01-01 |
| Backlogged: | true |
This was implemented a long time ago, not clear what date
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 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 preferably only have one first name used
- last names that use two names were hyphenated