STANDARD DATA DICTIONARY #6002.03 -- VBECS DSS EXTRACT FILE 3/24/25 PAGE 1
STORED IN ^VBEC(6002.03, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 1.0)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
DD ACCESS:
RD ACCESS:
WR ACCESS:
DEL ACCESS:
LAYGO ACCESS:
AUDIT ACCESS:
CROSS
REFERENCED BY: TRANSACTION ID(B), DATE/TIME OF TRANSFUSION(C), DATE/TIME OF RECORD(D)
6002.03,.01 TRANSACTION ID 0;1 FREE TEXT (Required)
INPUT TRANSFORM: K:$L(X)>45!($L(X)<3) X
LAST EDITED: DEC 08, 2006
HELP-PROMPT: Answer must be 3-45 characters in length
DESCRIPTION:
This is an identifier unique to this record.
CROSS-REFERENCE: 6002.03^B
1)= S ^VBEC(6002.03,"B",$E(X,1,30),DA)=""
2)= K ^VBEC(6002.03,"B",$E(X,1,30),DA)
6002.03,1 DFN 0;2 POINTER TO PATIENT FILE (#2)
LAST EDITED: NOV 14, 2006
DESCRIPTION:
This is a pointer to the PATIENT (#2) file.
TECHNICAL DESCR:
VBECS Source: Table: Patient Column: VistaPatientId - numeric
6002.03,2 ORDERING LOCATION 0;3 FREE TEXT
INPUT TRANSFORM: K:$L(X)>5!($L(X)<3) X
LAST EDITED: NOV 06, 2007
HELP-PROMPT: Answer must be 3-5 characters in length
DESCRIPTION:
This is the location associated with the patient hospital location at the time of order.
TECHNICAL DESCR: VBECS Source: CASE WHEN PO.InstitutionDivisionCode IS NULL THEN PO.DivisionCode ELSE
PO.InstitutionDivisionCode END AS OrderingLocation,
6002.03,3 TRANSFUSION LOCATION 0;4 FREE TEXT
INPUT TRANSFORM: K:$L(X)>5!($L(X)<3) X
LAST EDITED: MAR 12, 2008
HELP-PROMPT: Answer must be 3-5 characters in length
DESCRIPTION: Identifies the VBECS Facility ID (3-5 character station number) of the Blood Bank where the
specimen work (pre-transfusion testing) is done. This field will consist of the station number +
the division of where the Blood Bank is located.
TECHNICAL DESCR: An indicator of the division where this event occurred. FACILITY is derived from the STATION NUMBER
field(#99) for that pointer number in the INSTITUTION file(#4).
VBECS Source: Table: Patient Transfusion Column: DivisionCode - char(5) FK
Table: VamcDivision Column: DivisionCode - char(5)
6002.03,4 PHYSICIAN 0;5 FREE TEXT
INPUT TRANSFORM: K:$L(X)>35!($L(X)<3) X
LAST EDITED: DEC 14, 2006
HELP-PROMPT: Answer must be 3-35 characters in length
DESCRIPTION: This field contains the name of the provider that ordered the blood product for transfusion, when
avialable in VBECS. This physician may or may not be the same as the ORDERING PROVIDER.
6002.03,5 ORDERING PROVIDER 0;6 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: DEC 14, 2006
HELP-PROMPT: Answer must be 1-11 characters in length
DESCRIPTION: This is the IEN from file 200 of the provider that ordered the Type and Crossmatch in preparation
for a transfusion.
6002.03,6 PRODUCT NAME 0;7 FREE TEXT
INPUT TRANSFORM: K:$L(X)>50!($L(X)<3) X
LAST EDITED: DEC 14, 2006
HELP-PROMPT: Answer must be 3-50 characters in length
DESCRIPTION:
This is the PRODUCT NAME and is also referred to as the COMPONENT.
TECHNICAL DESCR: VBECS Source:
Table: BloodUnit Column: BloodProductGuid - uniqueidentifier FK
Table: BloodProduct Column: ProductShortName - varchar(50)
6002.03,7 COMPONENT ABBREVIATION 0;8 FREE TEXT
INPUT TRANSFORM: K:$L(X)>5!($L(X)<1) X
LAST EDITED: DEC 14, 2006
HELP-PROMPT: Answer must be 1-5 characters in length
DESCRIPTION: This field contains the Component Class Short Name for the transfused component. The abbreviations
for component classes are: RBC = RED BLOOD CELLS FFP = FRESH FROZEN PLASMA CRYO = CRYOPRECIPITATE
PLT = PLATELETS OTHER = OTHER WB = WHOLE BLOOD
TECHNICAL DESCR: VBECS Source:
Table: BloodUnit - Column:BloodProductGuid Uniqueidentifier FK
Table: BloodProduct - Column: ProductTypeCode char(4) FK
Table: ProductType - Column: ComponentClassID int FK
Table: ComponentClass - Column: ComponentClassShortName varchar(25)
6002.03,8 NUMBER OF UNITS 0;9 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99)!(X<1)!(X?.E1"."1.N) X
LAST EDITED: NOV 14, 2006
HELP-PROMPT: Type a number between 1 and 99, 0 Decimal Digits
DESCRIPTION: This is the total number of units pooled for transfusion. The data from VBECS should consist of
the total number of units transfused.
TECHNICAL DESCR:
VBECS Source: Table: PatientTransfusion Column: TransfusionPooledUnitsCount - smallint
6002.03,9 DATE/TIME OF TRANSFUSION 0;10 DATE
INPUT TRANSFORM: S %DT="EST" D ^%DT S X=+Y K:X<1 X
LAST EDITED: MAY 05, 2008
HELP-PROMPT: (No range limit on date)
DESCRIPTION:
This field contains the date and time of the blood component transfusion.
TECHNICAL DESCR:
VBECS Source: Table: PatientTransfusion Column: TransfusionEndDateTime - datetime
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 6002.03^C
1)= S ^VBEC(6002.03,"C",$E(X,1,30),DA)=""
2)= K ^VBEC(6002.03,"C",$E(X,1,30),DA)
This cross reference can be used to scan the records by transfusion date.
6002.03,10 DATE/TIME OF RECORD 0;11 DATE
INPUT TRANSFORM: S %DT="EST" D ^%DT S X=Y K:X<1 X
LAST EDITED: OCT 18, 2006
HELP-PROMPT: (No range limit on date)
DESCRIPTION:
This is the date and time that this record was created.
TECHNICAL DESCR:
If time cannot be determined, use 000001 as a default.
CROSS-REFERENCE: 6002.03^D
1)= S ^VBEC(6002.03,"D",$E(X,1,30),DA)=""
2)= K ^VBEC(6002.03,"D",$E(X,1,30),DA)
This cross reference can be used to scan the records by the record creation date.
6002.03,11 VOLUME 0;12 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<1)!(X?.E1"."1.N) X
LAST EDITED: NOV 14, 2006
HELP-PROMPT: Type a number between 1 and 9999, 0 Decimal Digits
DESCRIPTION:
This is the total transfused volume.
TECHNICAL DESCR:
VBECS Source: Table: PatientTransfusion Column: TransfusedVolume - int
6002.03,12 REACTION TYPE 0;13 FREE TEXT
INPUT TRANSFORM: K:$L(X)>10!($L(X)<2) X
LAST EDITED: APR 30, 2007
HELP-PROMPT: Answer must be 2-10 characters in length
DESCRIPTION: This is the type of transfusion reaction. It should consist of the first 10 characters from the
VBECS source file. The values stored in this field and the full tex associated wiht them are as
follows: Anaphylaxi = Anaphylaxis Circulator = Circulatory Delayed He = Delayed Hemolytic Febrile
No = Febrile Nonhemolytic Graft vs. = Graft vs. Host disease Acute Hemo = Acute Hemolytic
Transfusio = Transfusion Related Acute Lung Injury Other = Other Post Trans = Post Transfusion
- Associated Disease Urticaria = Urticaria
TECHNICAL DESCR: VBECS Source: Table: PatientTransfusionReaction Column: TransfusionReactionTypeCode - char(1) FK
Table: TransfusionReactionType Column: TransfustionReactionTypeText - varchar(50)
6002.03,13 UNIT MODIFICATION 0;14 FREE TEXT
INPUT TRANSFORM: K:$L(X)>6!($L(X)<1) X
LAST EDITED: DEC 14, 2006
HELP-PROMPT: Answer must be 1-6 characters in length
DESCRIPTION: This field notes the type of modification made to the unit before transfusion. The modification
types are indicated by a single character code. Multiple modifications are indicated as a string of
single character codes. The codes are as follows: D = Deglycerolize, F = Freeze, I = Irradiate, L
= Leukoreduce, P = Pool, R = Rejuvenate, S = Split/Divide, T = Thaw, U = Thaw/Pool Cryo, V = Volume
Reduce, W = Wash
TECHNICAL DESCR: VBECS Source: Table: PatientTransfusion Column: BloodUnitGuid - uniqueidentifier FK
Table: BloodUnitModification Column: FromBloodUnitGuid - uniqueidentifier FK
Table: BloodUnitModification Column: ProductModificationCode - char(1) FK
Table: ProductModification Column: ProductModificationText - varchar(30)
6002.03,14 TRANSFUSION REACTION 0;15 SET
'1' FOR YES;
'0' FOR NO;
LAST EDITED: DEC 14, 2006
DESCRIPTION:
This field is used to indicate if a transfusion reaction has been indicated or not.
FILES POINTED TO FIELDS
NEW PERSON (#200) ORDERING PROVIDER (#5)
PATIENT (#2) DFN (#1)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):