Print Page as PDF
Use of STD_INSTITUTION table in PATS Data Migration ICR (4888)

Use of STD_INSTITUTION table in PATS Data Migration    ICR (4888)

Name Value
NUMBER 4888
IA # 4888
DATE CREATED 2006/08/22
CUSTODIAL PACKAGE 807
USAGE Private
TYPE SQL Table
DBIC APPROVAL STATUS APPROVED
NAME Use of STD_INSTITUTION table in PATS Data Migration
GENERAL DESCRIPTION 
This integration agreement describes the use of the
Standard Data Services std_institution 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.

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
  • INSTITUTION
  • STD_INSTITUTION
  • DATA MIGRATION
  • MIGRATION
DURATION Till Otherwise Agreed
DATE ACTIVATED 2006/09/23
SQL TABLE STD_INSTITUTION
SQL COLUMN
SQL COLUMN COLUMN DETAILS
STATIONNUMBER 
The contingency option to delete all PATS data for an
institution and the divisions within that insitution, takes the ID value for
the computing institution as an input parameter. It does a SELECT statement on
the STD_INSTITUTION table to get the STATIONNUMBER field for the computing
institution. It then selects all ID values from the STD_INSTITUTION table,
whose STATIONNUMBER field begins with the same 3 digit station number. The
procedure then deletes all records from the report_of_contact table, and all
PATS reference tables that reference either the computing institution, or
divisions within the computing institution.

When data is migrated from the VistA Patient Representative system into PATS,
both parent and child station numbers from VistA data are used to look up
entries on the std_institution table, in order to populate foreign key values
in the PATS tables.
VISTANAME 
When data is migrated from the VistA Patient Representative
system into PATS, the VISN name is passed from VistA, and is used to look up
an entry on the std_institution table matching to the vistaname. The resulting
ID field is used as a foreign key value on entries in the PATS
facility_service_or_section table.
ID 
PATS has several foreign key references to the ID field on
the std_institution table. This field must be populated when the data is
migrated from VistA Patient Representative into the PATS tables. This field is
also used by the contingency data deletion option, to identify which entries
must be deleted from the PATS tables.