Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Desc |  Accessed By FileMan Db Calls |  Pointer To FileMan Files |  Fields |  ICR  | All
Print Page as PDF
Global: ^VBEC(6002.03

Package: VBECS

Global: ^VBEC(6002.03


Information

FileMan FileNo FileMan Filename Package
6002.03 VBECS DSS EXTRACT VBECS

Description

Accessed By FileMan Db Calls, Total: 2

Package Total Routines
DSS Extracts 1 ECXPURG    
VBECS 1 VBECDSS    

Pointer To FileMan Files, Total: 2

Package Total FileMan Files
Kernel 1 NEW PERSON(#200)[5]    
Registration 1 PATIENT(#2)[1]    

Fields, Total: 15

Field # Name Loc Type Details
.01 TRANSACTION ID 0;1 FREE TEXT
************************REQUIRED FIELD************************

  • 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)
1 DFN 0;2 POINTER TO PATIENT FILE (#2) PATIENT(#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
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,
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)
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.
5 ORDERING PROVIDER 0;6 POINTER TO NEW PERSON FILE (#200) NEW PERSON(#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.
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)
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)
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
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.
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.
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
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)
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)
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.

ICR, Total: 1

ICR LINK Subscribing Package(s) Fields Referenced Description
ICR #4953
  • DSS - DECISION SUPPORT SYSTEM EXTRACTS
    		•
    Info |  Desc |  Accessed By FileMan Db Calls |  Pointer To FileMan Files |  Fields |  ICR  | All