Date of Birth: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 17: | Line 17: | ||
== Cross checks == | == Cross checks == | ||
If the data of birth would lead to a patient age outside of the cross-check range, [[CCMDB.mdb]] will not allow you to send. If the patient has an age outside of this range, please enter an allowed date and send the [[ | If the data of birth would lead to a patient age outside of the cross-check range, [[CCMDB.mdb]] will not allow you to send. If the patient has an age outside of this range, please enter an allowed date and send the [[Data Processor]] an email with the correct date. | ||
{{Data Integrity Check | {{Data Integrity Check | ||
Revision as of 13:04, 25 September 2018
| 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.
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
If the data of birth would lead to a patient age outside of the cross-check range, CCMDB.mdb will not allow you to send. If the patient has an age outside of this range, please enter an allowed date and send the Data Processor an email with the correct date.
| 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.mdb |
| Coding: | function Validate_DOB |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2008-01-01 |
| Backlogged: | true |
Related articles
| Related articles: |