Date of Birth

From CCMDB Wiki
Jump to navigationJump 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: 1900-01-01
End Date: 2300-01-01
Sort Index: 5

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

It is used to calculate age.

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: 

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.

Related articles

Related articles: