Date of Birth: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m clean-up
mNo edit summary
 
(25 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<onlyinclude>[[Date of Birth]] (DOB/Birth) is the data a patient was born.</onlyinclude>
{{Data_element
| field_name = Birth
| CCMDB_label = DOB
| CCMDB_tab = Top Row
| element_description = Date of Birth (DOB) is the data a patient was born.
| in_table = L_Log table, L_PHI table
| data_type = date
| program_collecting = Med and CC
| created_raw = Raw
| data_element_sort_index = 5
}}


It is used to calculate [[age]].  
It is used to calculate [[age]]. See also [[John or Jane Doe patient]]s.  


== {{CCMDB Data Integrity Checks}} ==
{{PHI_Data}}
The minimum [[age]] allowed is 10, the maximum age allowed is 107.
If the data of birth would lead to a patient age outside of this range, the [[CCMDB.mdb]] will not allow you to send.


{{discussion}}
== Cross checks ==
Was the following done?: Ttenbergen 14:22, 2015 April 27 (CDT)
{{Data Integrity Check
This check is currently only yellowing DOB; need to correct it. We will change it to 120.
| DIC_summary = The minimum [[age]] allowed is 10, the maximum age allowed is 120.
| DIC_related_concepts = Date of Birth
| DIC_firmness = hard check
| DIC_timing = complete
| DIC_app = CCMDB.accdb
| DIC_coding = function ''Validate_DOB''
| DIC_status = implemented
| DIC_implementation_date = 2008-01-01
}}
{{CCMDB.accdb cross checks triggering for correct values}}


[[Category: Data Collection Guide]]
 
[[Category: Registry Data]]
{{Data Integrity Check List}}
[[Category: Data structure]]
 
== Related articles ==
{{Related Articles}}
 
 
[[Category:Data Collection Guide]]
[[Category:Registry Data]]
[[Category:Demographics]]
[[Category:Registry checks]]
[[Category:Cognos Report Integrator]]

Latest revision as of 09:14, 25 May 2022

Data Element (edit)
Field Name: Birth
CCMDB Label: DOB
CCMDB tab: Top Row
Table: L_Log table, L_PHI table
Data type: date
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 5

Date of Birth (DOB) is the data a patient was born.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


It is used to calculate age. See also John or Jane Doe patients.

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: The minimum age allowed is 10, the maximum age allowed is 120.
Related: Date of Birth
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: function Validate_DOB
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2008-01-01
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

CCMDB.accdb cross checks triggering for correct values

If the actual correct data leads to a cross-check error CCMDB.accdb will not allow you to send. In that case, enter a value that is acceptable and then email the Data Processor using the "generate email" button.


Data Integrity Checks (automatic list)

 AppStatus
Check duplicate patientCCMDB.accdbimplemented
Date of BirthCCMDB.accdbimplemented
PL Diff Phin SameLN FN DOBCentralized data front end.accdbimplemented
PL SamePhin Diff DOB SexCentralized data front end.accdbimplemented

Related articles

Related articles: