Date of Birth: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
JMojica (talk | contribs)
mNo edit summary
mNo edit summary
 
(42 intermediate revisions by 4 users not shown)
Line 1: Line 1:
'''Date of Birth''' (DOB)
{{Data_element
* Age is part of the patient demographic information that we collect.  
| 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
}}


* A patient's '''age''' is '''calculated''' as a difference between the '''DOB''' and the '''admission date''' in our database.  The age of the last birthday prior to or same as the admission date is considered (eg. FLOOR function is used).
It is used to calculate [[age]]. See also [[John or Jane Doe patient]]s.  
* The calculated occurs when data sent from the [[Laptop Setup | Laptop]] and is [[PDA Uploader | uploaded]] to the master [[TMSX | Critical Care]] or [[MedTMS | Medicine]] database.


* Age is part of the [[APACHE Scoring table|APACHE II score]] for Critical Care and [[MOST]] score used in Medicine.
{{PHI_Data}}


== Cross checks ==
{{Data Integrity Check
| 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}}


== Data Integrity Rule ==
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.


{{Data Integrity Check List}}


== Related articles ==
{{Related Articles}}




 
[[Category:Data Collection Guide]]
[[Category:Data_Collection_Guide]]
[[Category:Registry Data]]
[[Category: Registry Data]]
[[Category:Demographics]]
[[Category: APACHE II]]
[[Category:Registry checks]]
[[Category: MOST Score Elements]]
[[Category:Cognos Report Integrator]]
[[Category:Data Integrity Rules]]

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: