S tmp table: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) |
||
| Line 4: | Line 4: | ||
* explain data structure | * explain data structure | ||
**Column sent complete - if box is checked in this column then that row of data will sent to the OUTPUT folder on the | **Column sent complete - if '''box is checked''' in this column then that row of data will get sent to the OUTPUT folder on the Regional Server TmpV2_1.mdb '''only when''' the whole patient file is completed and sent in. | ||
*If box is not checked then that row of data will be sent to TmpV2_1.mdb each time any data is sent to the Regional Server. [[User:TOstryzniuk|TOstryzniuk]] 17:17, 18 June 2009 (CDT) | **If box is '''not checked''' then that row of data will be sent to TmpV2_1.mdb each time any data is sent to the Regional Server even if patient file is not complete. Tmpv2 will fill up with repeated data for the same patient but with a different sending date. [[User:TOstryzniuk|TOstryzniuk]] 17:17, 18 June 2009 (CDT) | ||
{{stub}} | {{stub}} | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
Revision as of 00:29, 2009 June 19
The S_Tmp table contains the possible values for the L_TmpV2 table on the PDA and in the CCMDB.mdb.
to do before de-stubbing
- explain data structure
- Column sent complete - if box is checked in this column then that row of data will get sent to the OUTPUT folder on the Regional Server TmpV2_1.mdb only when the whole patient file is completed and sent in.
- If box is not checked then that row of data will be sent to TmpV2_1.mdb each time any data is sent to the Regional Server even if patient file is not complete. Tmpv2 will fill up with repeated data for the same patient but with a different sending date. TOstryzniuk 17:17, 18 June 2009 (CDT)