Linking pairs table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
Line 1: Line 1:
The '''linking_pairs''' table in [[Centralized data.mdb]] is where the data generated by [[Populate linking pairs]] is stored.  
The '''linking_pairs''' table in [[Centralized data.mdb]] is where the data generated by [[Populate linking pairs]] is stored.  


===L_Como Table in the [[CCMDB.mdb]]===
===L_Como Table in the [[CCMDB.accdb]]===
{| border="1"
{| border="1"
|early_D_ID  || [[D_ID]] of the '''earlier''' record in a pair of consecutive records for same patient
|early_D_ID  || [[D_ID]] of the '''earlier''' record in a pair of consecutive records for same patient

Revision as of 10:43, 22 September 2019

The linking_pairs table in Centralized data.mdb is where the data generated by Populate linking pairs is stored.

L_Como Table in the CCMDB.accdb

early_D_ID D_ID of the earlier record in a pair of consecutive records for same patient
late_D_ID D_ID of the later record in a pair of consecutive records for same patient

Data Structure

To see the data structure of this table, see most up-to-date Centralized data.mdb in Regional Server\Output Centralized_data.mdb.