Date of Birth: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Ttenbergen (talk | contribs) m Been 120 since CCMDB.mdb_Change_Log_2015#2015-Jan-5 |
||
| Line 16: | Line 16: | ||
== {{CCMDB Data Integrity Checks|implemented}} == | == {{CCMDB Data Integrity Checks|implemented}} == | ||
The minimum [[age]] allowed is 10, the maximum age allowed is | The minimum [[age]] allowed is 10, the maximum age allowed is 120. | ||
If the data of birth would lead to a patient age outside of this range, the [[CCMDB.mdb]] will not allow you to send. | If the data of birth would lead to a patient age outside of this range, the [[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 Pagasa an email with the correct date. | If the patient has an age outside of this range, please enter an allowed date and send Pagasa an email with the correct date. | ||
Revision as of 12:00, 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 |
| Data Dependencies(Reports/Indicators/Data Elements): | |
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.
Template:CCMDB Data Integrity Checks
The minimum age allowed is 10, the maximum age allowed is 120. If the data of birth would lead to a patient age outside of this range, the 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 Pagasa an email with the correct date.