Date of Birth
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 |
| Data Dependencies(Reports/Indicators/Data Elements): | |
Date of Birth (DOB) is the data a patient was born.
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 |
{{CCMDB.accdb cross checks triggering for correct values}}
Data Integrity Checks (automatic list)
| App | Status | |
|---|---|---|
| Date of Birth | CCMDB.accdb | implemented |
| Check duplicate patient | CCMDB.accdb | implemented |
| Function Validate DOB | CCMDB.accdb | implemented |
| PL SamePhin Diff DOB Sex | Centralized data front end.accdb | implemented |
| PL_DiffPhin_SameLN_FN_DOB | Centralized data front end.accdb | implemented |