Linking pairs table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "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=== {| bor..."
 
mNo edit summary
Line 3: Line 3:
===L_Como Table in the [[CCMDB.mdb]]===
===L_Como Table in the [[CCMDB.mdb]]===
{| 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
|-
|-
|Early_D_ID || [[D_ID]] of the '''later''' 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
|}
|}



Revision as of 18:19, 21 May 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.mdb

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.