Date of Birth: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) m (→Cross checks) |
||
| Line 27: | Line 27: | ||
}} | }} | ||
{{CCMDB.accdb cross checks triggering for correct values}} | {{CCMDB.accdb cross checks triggering for correct values}} | ||
{{Data Integrity Check List}} | |||
== Related articles == | == Related articles == | ||
Revision as of 14:34, 2020 December 17
| 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
| 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
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)
| App | Status | |
|---|---|---|
| Check duplicate patient | CCMDB.accdb | implemented |
| Date of Birth | CCMDB.accdb | implemented |
| PL Diff Phin SameLN FN DOB | Centralized data front end.accdb | implemented |
| PL SamePhin Diff DOB Sex | Centralized data front end.accdb | implemented |