L Communication Notes table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m
 
mNo edit summary
Line 4: Line 4:


== Data Structure ==
== Data Structure ==
L_Problem contains the fields
{| class="wikitable sortable"  
{| class="wikitable sortable"  
|-
|-
Line 9: Line 10:
!| type
!| type
!| description
!| description
 
| D_ID  || long || unique record ID
 
|-
|-
|| '''dispo_ID''' || text || unique ID
| Notes || text || text from the email
|-
|-
| CommDate || date|| date of communication
|}
|}




[[Category: Data structure]]
[[Category: Data structure]]
[[Category: Data Processing]]

Revision as of 08:31, 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

L_Problem contains the fields

field type description D_ID long unique record ID
Notes text text from the email
CommDate date date of communication