Date of Birth

From CCMDB Wiki
(Redirected from DOB field)
Jump to navigation Jump to search
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: