S ee Patient ● Allows this table to be linked to the the Table Key table patient table and all tables that contain the patient table key ● Only a Patient_ID that exists in the P atient table can be referenced here Encounter_ID Encounter 15 or 16-digits Unique integer ID that links a Billing record to a specific Encounter record See ● Allows this table to be linked to the T able Key (i.e., to a sin. [...] table and all other tables that include the Network table key ● Refer to the Network table for the specific regional practice-based research network covered by a given Network_ID P atient_ID Patient Table Key 15 or Unique and randomly assigned integer CPCSSN S ee Patient table ● Allows this table to be linked to the the 1 6-digits p atient ID. [...] patient table and all tables that contain the patient table key ● Only a Patient_ID that exists in the Patient table can be referenced here Encounter_ID Encounter Table 15 or Unique integer ID that links a record in this See Encounter table ● Allows this table to be linked to the Key 16-digits table to a specific Encounter record (i.e., to a Encounter table and all other tables that single interac. [...] i nclude the Encounter_ID ● Only an Encounter_ID that exists in the Encounter table can be referenced here ● Multiple records in this table may be l inked to a single Encounter record ● May be empty if the record cannot be linked to a specific encounter CompletedDate Date yyyy-mm-dd Date of the patient’s visit to the referred to 1980-01-01 to CutOffDate (see the ● Is n ot t he date on which the pa. [...] patient table and all tables that contain the patient table key ● Only a Patient_ID that exists in the Patient table can be referenced here Encounter_ID Encounter Table 1 5 or U nique integer ID that links a record in this See Encounter table ● Allows this table to be linked to the Key 16-digits table to a specific Encounter record (i.e., to a Encounter table and all other tables that s ingle inte.
- Pages
- 30
- Published in
- Canada
