Date of Birth

From CCMDB Wiki
Revision as of 11:45, 2019 September 22 by Ttenbergen (talk | contribs) (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
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.

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.

Related articles

Related articles: