Print Page as PDF
Use of STD_RACE table in PATS Application ICR (4889)

Use of STD_RACE table in PATS Application    ICR (4889)

Name Value
NUMBER 4889
IA # 4889
DATE CREATED 2006/08/22
CUSTODIAL PACKAGE 807
USAGE Private
TYPE SQL Table
DBIC APPROVAL STATUS APPROVED
NAME Use of STD_RACE table in PATS Application
GENERAL DESCRIPTION 
This integration agreement describes the use of the
Patient Services std_race table and fields within the PATS application's
Oracle database (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
  • RACE
  • STD_RACE
DURATION Till Otherwise Agreed
DATE ACTIVATED 2006/09/23
SQL TABLE STD_RACE
SQL COLUMN
SQL COLUMN COLUMN DETAILS
ID 
A join is made between the PATS patient_race table and the
SDS std_race table using the institution foreign key on the PATS table and the
ID field on the std_race table. This join is made while building the data for
rollup to Austin.
NAME 
PATS selects this field for inclusion in the rollup data for
Austin VSSC reports.