S tmp table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 1: Line 1:
The '''S_Tmp''' table contains the possible values for the [[L_TmpV2]] table on the PDA and in the [[CCMDB.mdb]].  
The '''S_Tmp''' table contains the possible values for the [[L_TmpV2]] in [[CCMDB.mdb]].  


== to do before de-stubbing ==
== to do before de-stubbing ==

Revision as of 16:07, 2010 December 22

The S_Tmp table contains the possible values for the L_TmpV2 in 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)

Template:Stub