CTSC Clinical Data Warehouse
Constructing Your Data Specifications
You may download a Data Specification Worksheet corresponding to this page. Alternatively, you are cordially invited to meet with Laurie McPherson for assistance in determining your exact data needs and how they can best be filled and approved from available sources.
DATA SPECIFICATION WORKSHEET (Revised 6/24/2009
Instructions: Please circle the data fields you want. Where possible please specify the following:
a) Mark specific fields versus *(all)
b) Provide date ranges
c) For diagnoses or procedures, provide specific codes (ICD-9, CPT-4, SNOMED CT) if known
d) For test codes, batteries, and testing details, see TriCore's online Test Directory
e) Provide standard terminology or other search terms in text fields
f) Specify Aggregation processes (sum, count, average, etc.) where desired
EXAMPLE:
Gout is less common in females. For preparing a grant proposal, you wish to estimate how many UNM patients, who are middle-aged Hispanic females in the greater Albuquerque area, have this diagnosis in conjunction with elevated uric acid levels. In addition, you hope to limit your activities to Albuquerque proper, unless you need to include neighboring communities to get an adequate sample size.
Your data request could be specified as follows.
In this instance, both TriCore and IDX data would used, since discharge diagnosis and ethnicity are not available in the lab-only data.
TRICORE REFERENCE LABORATORIES
|
Patients |
Criteria for Patient Fields |
Episodes |
Criteria for Episode Fields |
|
* (All) |
|
* (All) |
|
|
MRN |
COUNT (group by city) |
AdmissionDate |
|
|
Name |
|
DischargeDate |
|
|
DOB |
|
ClinicID |
|
|
SSN |
|
Ward |
|
|
Sex |
Female |
Room |
|
|
Address |
|
||
|
City, |
* (all) |
|
|
|
State |
|
|
|
|
Zip |
(Albuquerque metro area) |
|
|
|
Accessions |
Criteria for Accession Fields |
Tests |
Criteria for Test Fields |
|
* (All) |
|
* (All) |
|
|
TestBatteries |
|
Test Name |
URIC (see Test Directory) |
|
OrderingPhysicianID |
|
TestMethod |
|
|
CopyToPhysicianID |
|
Containers |
|
|
PtLocationAtOrder |
|
Aliquots |
|
|
PtAgeAtOrder |
Between 40 - 60 yrs |
CallbackCodes |
|
|
|
|
CPTcodes |
|
|
Results |
Criteria for Results Fields |
|
TimeStampOrdered |
|
|
TimeStampCompleted |
|
|
Priority (e.g. stat) |
|
|
Sensitivity (e.g. HIV) |
|
|
Finality |
|
|
ResultCode |
(HIGH ) OR |
|
ResultDescription |
(> 7.0 mg/dL ) |
IDX BILLING (INFORMATION SOLUTIONS)
|
Professional Billing from UNMMG |
Criteria for Billing Fields |
|
MRN |
|
|
EncounterID |
|
|
ClinicianID |
|
|
DateOfService |
|
|
ProcedureCode |
|
|
Diagnoses (up to 5 ICD-9 codes) |
274.* (Gout) |
|
ChargeAmount |
|
|
InsuranceProvider |
|
|
DOB |
|
|
Sex |
|
|
Language |
|
|
Ethnicity |
Hispanic |
|
TribalAffiliation |
|
|
Address |
|
|
City |
|
|
State |
|
|
Zip |
|
|
Phone |
|
VETERANS ADMINISTRATION DATA
Special procedures apply for VA data. Investigators must be appointed by the VA as a WOC (without compensation) employees.
The final section on the data warehouse provides all available forms and documentation in downloadable format. Please see the next section on Downloadable Forms.