L Communication Notes table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) m m |
||
| Line 10: | Line 10: | ||
!| description | !| description | ||
|- | |- | ||
| D_ID || | | D_ID || text(18)|| unique record ID | ||
|- | |- | ||
| Notes || text || text from the email | | Notes || text(255) || text from the email | ||
|- | |- | ||
| CommDate || date|| date of communication | | CommDate || date|| date of communication | ||
Revision as of 09:23, 17 August 2015
The L_Communication_Notes table in Centralized_data.mdb contains data related to the data processor's communications with data collectors during vetting.
Specifically, the email question 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 |