Date of Birth: Difference between revisions
Jump to navigation
Jump to search
m Text replacement - "in_table = L_Log" to "in_table = L_Log table" |
Ttenbergen (talk | contribs) m Text replacement - "cross checks" to "cross checks" |
||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
| CCMDB_tab = Top Row | | CCMDB_tab = Top Row | ||
| element_description = Date of Birth (DOB) is the data a patient was born. | | element_description = Date of Birth (DOB) is the data a patient was born. | ||
| in_table = L_Log table | | in_table = L_Log table, L_PHI table | ||
| data_type = date | | data_type = date | ||
| program_collecting = Med and CC | | program_collecting = Med and CC | ||
| Line 11: | Line 11: | ||
}} | }} | ||
It is used to calculate [[age]]. | It is used to calculate [[age]]. See also [[John or Jane Doe patient]]s. | ||
{{PHI_Data}} | {{PHI_Data}} | ||
== {{ | == Cross checks == | ||
The minimum [[age]] allowed is 10, the maximum age allowed is | {{Data Integrity Check | ||
| DIC_summary = The minimum [[age]] allowed is 10, the maximum age allowed is 120. | |||
| DIC_related_concepts = Date of Birth | |||
| DIC_firmness = hard check | |||
| DIC_timing = complete | |||
| DIC_app = CCMDB.accdb | |||
| DIC_coding = function ''Validate_DOB'' | |||
| DIC_status = implemented | |||
| DIC_implementation_date = 2008-01-01 | |||
}} | |||
{{CCMDB.accdb [[cross check]]s triggering for correct values}} | |||
{{Data Integrity Check List}} | |||
== Related articles == | |||
{{Related Articles}} | |||
| Line 25: | Line 38: | ||
[[Category:Registry Data]] | [[Category:Registry Data]] | ||
[[Category:Demographics]] | [[Category:Demographics]] | ||
[[Category:Registry checks]] | |||
[[Category:Cognos Report Integrator]] | |||
Latest revision as of 13:25, 20 June 2025
| 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 | |
|---|---|---|
| Check duplicate patient | CCMDB.accdb | implemented |
| Date of Birth | 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 |