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

Pointer To FileMan Files, Total: 2

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

Info | Desc | Accessed By FileMan Db Calls | Pointer To FileMan Files | Fields | ICR | All