Print Page as PDF
Use of STD_ETHNICITY table in PATS Data Migration ICR (4892)

Use of STD_ETHNICITY table in PATS Data Migration    ICR (4892)

Name Value
NUMBER 4892
IA # 4892
DATE CREATED 2006/08/22
CUSTODIAL PACKAGE 807
USAGE Private
TYPE SQL Table
DBIC APPROVAL STATUS APPROVED
NAME Use of STD_ETHNICITY table in PATS Data Migration
GENERAL DESCRIPTION 
This integration agreement describes the use of the
Patient Services std_ethnicity table and fields within the PATS data migration
application.  This agreement is in force only until the PATS application has
been rolled out nationally to all sites. (distributed by Standard Data
Services)

When the first test site goes to production with PATS, the EMC will be using
version 11 of the SDS database.
STATUS Active
KEYWORDS
  • PATS
  • SDS
  • ETHNICITY
  • STD_ETHNICITY
DURATION Till Otherwise Agreed
DATE ACTIVATED 2006/09/25
SQL TABLE STD_ETHNICITY
SQL COLUMN
SQL COLUMN COLUMN DETAILS
ID 
PATS has a foreign key reference to the ID field on the
std_ethnicity table.  This field must be populated when the data is migrated
from VistA Patient Representative into the PATS tables
ABBREVIATION 
When data is migrated from the VistA Patient Representative
system into PATS, the ABBREVIATION field from the VistA ETHNICITY file (10.2)
is used to look up entries on the std_ethnicity table, in order to populate
the foreign key value in the PATS_patient.