L Communication Notes table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The '''L_Communication_Notes''' table in [[Centralized_data. | The '''L_Communication_Notes''' table in [[Centralized_data.accdb]] contains data related to the [[data processor]]'s communications with [[data collector]]s during [[vetting]]. | ||
Specifically, the [[email | Specifically, the [["email collector about patient data" button]] will populate this table with the content of the email and the date. The data is used by the main office to keep track which problem data has been processed. | ||
== Data Structure == | == Data Structure == | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
|- | |- | ||
| Line 10: | Line 9: | ||
!| type | !| type | ||
!| description | !| description | ||
|- | |- | ||
| Notes || text || text from the email | | D_ID || text(18)|| unique record ID | ||
|- | |||
| Notes || text(255) || text from the email | |||
|- | |- | ||
| CommDate || date|| date of communication | | CommDate || date|| date of communication | ||
|} | |} | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category: Data Processing]] | [[Category:Data Processing]] | ||
[[Category:Centralized_data.accdb]] | |||
Latest revision as of 10:35, 30 July 2025
The L_Communication_Notes table in Centralized_data.accdb contains data related to the data processor's communications with data collectors during vetting.
Specifically, the "email collector about patient data" button will populate this table with the content of the email and the date. The data is used by the main office to keep track which problem data has been processed.
Data Structure
| field | type | description |
|---|---|---|
| D_ID | text(18) | unique record ID |
| Notes | text(255) | text from the email |
| CommDate | date | date of communication |
Related articles
| Related articles: |