Login    Sites MenuBlueStep

BlueStep Platform Support
                    
RelateScript
Outline full outline 
Overview 
Data Types 
Operators 
Statements 
Functions 
Data Conversion 
String Functions 
HTML/CSS/JavaScript 
Array Functions 
Date/Time Functions 
Mathematical Functions 
Advanced Functions 
Restricted Functions 
clearCache()
B.clearCache
 
clearLock(...)
B.clearLock
 
End Point request/response
B.request,B.response
 
executeQuery(...)
B.executeQuery
 
logKeyword(...) 
Mckesson Functions 
getActivePatients(...) 
getDispensesByRX(...) 
getDispensesByDate(...) 
getFieldByID(...) 
getDispense(...) 
getDispenseMap(...) 
getPatientMap(...) 
prepareLookup(...) 
setBioImage() 
storeString(...) 
storeURL(...) 
Web Services 
Working with Relate Data 
How Formulas Work 
Related Topics 
PrintPrint PDF
getDispenseMap(...)

The getDispenseMap(...) function retrieves a Dispense Field Map from the Mckesson Database by passing it a rxID and dispenseNumber.  By passing the String fieldID to the Map you can retrieve various fields from the dispense.

Syntax:
getDispenseMap( rxID, dispenseNumber )
rxID.getDispenseMap( dispenseNumber );

Parameter Description
rxID A String value containing the id assigned to the RX.
dispenseNumber A String value containing the dispense number assigned to the dispense.

Table Field Description
RX External_RX_ID A String value containing the id assigned to the RX that appears on the Mckesson RX screen.
Dispense Dispense_ID A String value containing the unique dispense id for the database assigned to the dispense.
Dispense Dispense_Number A String value containing the dispense number related to the dispense.
Patient Patient_ID A String value containing the unique patient id for the database assigned to the patient.
Item Item_Name A String value containing the name of the med related to the dispense.
Prescriber Prescriber_Last_Name A String value containing the lastname of the prescriber who prescribed the RX or dispense.
Dispense Quantity_Dispensed A String value containing the dispense number assigned to the dispense.
Dispense Dosage_Signa_Code A String value containing the type of RX to be given to append to the instructions assigned to the dispense.
Dispense Signa_String A String value containing the signa codes to append to the instructions assigned to the dispense.
Dispense DailyQty A String value containing the quantity to be consumed daily for the dispense.
Dispense Instruction_Signa_Text A String value containing the instructions assigned to the dispense.
Dispense Days_Supply A String value containing the days supplied for the dispense.
Dispense Dispense_Date A String value containing the date of the dispense.
RX RX_ID A String value containing the unique rx id for the database assigned to the rx.
RX Written_For_Item_ID A String value containing unknown.
RX Written_For_Item_Version A String value containing unknown.
RX Date_Written A String value containing the date the RX was written.
RX Script_Status A String value containing unknown.
RX Prescription_Expiration_Date A String value containing the date the RX expires.
RX Original_Refills_Authorized A String value containing unknown.
RX Total_Refills_Authorized A String value containing the number of refills authorized.
RX Total_Refills_Used A String value containing the number of refills used.
RX Discontinue_Date A String value containing the date the RX was discontinued.
RX Last_Dispense_Number A String value containing unknown.
RX Last_Dispense_Stop_Date A String value containing unknown.
RX Quantity_Written A String value containing unknown.
RX Total_QTY_Used A String value containing unknown.
RX Total_QTY_Authorized A String value containing unknown.
RX Days_Supply_Written A String value containing unknown.
RX Days_Supply_Remaining A String value containing unknown.
RX Script_Origin_Indicator A String value containing unknown.
RX Phoned_In_By_Type A String value containing unknown.
RX Phoned_In_By_Name A String value containing unknown.
RX Narcotic_Form_Number A String value containing unknown.
RX TimeStamp A String value containing unknown.
RX ReassignedRx A String value containing unknown.
RX ChronicMed A String value containing unknown.
RX Link_RX_ID A String value containing unknown.
RX Copy_From_External_RX_ID A String value containing unknown.
Patient Patient_ID A String value containing the unique patient id for the database assigned to the patient.
Patient Patient_First_Name A String value containing the first name of the patient.
Patient Patient_Last_Name A String value containing the last name of the patient.
Patient Patient_Middle_Initial A String value containing the middle initial of the patient.
Patient Pharmacy_Patient_Number A String value containing unknown.
Patient Patient_Location_Code A String value containing unknown.
Patient Student_Code A String value containing unknown.
Patient Marital_Status_Type A String value containing unknown.
Patient Add_On_Amount A String value containing unknown.
Patient Mark_Up_Down_PCT A String value containing unknown.
Patient Language_Override_Code A String value containing unknown.
Patient Tax_Exempt_Flag A String value containing unknown.
Patient Safety_Cap_Code A String value containing unknown.
Patient Safety_Cap A String value containing unknown.
Patient Signature_On_File_Flag A String value containing unknown.
Patient PIL_Flag A String value containing unknown.
Patient PIL_Authorization_Date A String value containing unknown.
Patient Sex A String value containing unknown.
Patient Birthdate A String value containing unknown.
Patient Deceased_Date A String value containing unknown.
Patient SSN A String value containing unknown.
Patient Suffix A String value containing unknown.
Patient Eligibility_Override_Code A String value containing unknown.
Patient EPSDT_Code A String value containing unknown.
Patient Carrier_Clinic_Number A String value containing unknown.
Patient Assign_Benefits_Date A String value containing unknown.
Patient Driver_License A String value containing unknown.
Patient Inactive_Flag A String value containing unknown.
Patient Smoker_Nonsmoker_Code A String value containing unknown.
Patient Pregnancy_Indicator A String value containing unknown.
Patient DNR A String value containing unknown.
Patient Create_Date A String value containing unknown.
Patient DNI A String value containing unknown.
Patient NPPack_Code A String value containing unknown.
Patient Patient_Timestamp A String value containing unknown.
Patient MedicareDEnrollDate A String value containing unknown.
Patient MedicareDEnrolledFlag A String value containing unknown.
Patient MultiStoreFlag A String value containing unknown.
Patient PatientInfoReviewedFlag A String value containing unknown.
Patient CorporatePatientId A String value containing unknown.
Patient Primary_Prescriber_ID A String value containing unknown.
Patient Primary_Pharmacy_ID A String value containing unknown.
Patient Head_Of_Household_ID A String value containing unknown.
Patient Price_Schedule_ID A String value containing unknown.
Patient Discount_Schedule_ID A String value containing unknown.
Patient Label_Format_ID A String value containing unknown.
Patient Parameter LTCPatientParameterID A String value containing the primary key of the patient parameter entry.
Patient Parameter AdmissionDate A String value containing the date of admission to the facility.
Patient Parameter DischargeDate A String value containing the date of discharge from the facility.
Patient Parameter FacilityPatientIdentifier A String value containing unknown.
Patient Parameter Comments A String value containing unknown.
Patient Parameter PrescriberTypeCode A String value containing unknown.
Patient Parameter PrescriberTypeCodeGrp A String value containing unknown.
Dispense Dispensing_Status_Indicator A String value containing the status of the dispense in the dispensing process.
Dispense Dispensed_Item_ID A String value containing the item(medication) id that was dispensed.
Dispense Item_Version A String value containing unknown.
Dispense DAW_Indicator A String value containing unknown.
Dispense True_Cost A String value containing unknown.
Dispense Cost_Calculation_Basis A String value containing unknown.
Dispense Discard_Date A String value containing unknown.
Dispense Basis_Of_Cost_Indicator A String value containing unknown.
Dispense Dispense_PIL_Flag A String value containing unknown.
Dispense Package_Insert_Flag A String value containing unknown.
Dispense MFG_EDU_Auth_Indicator A String value containing unknown.
Dispense Lot_Number A String value containing unknown.
Dispense Pharmacist_User_ID A String value containing unknown.
Dispense Technician_User_ID A String value containing unknown.
Dispense Drug_Interaction_Status A String value containing unknown.
Dispense Prior_adverse_Reaction_Status A String value containing unknown.
Dispense Drug_disease_Status A String value containing unknown.
Dispense Therapeutic_Duplication_Status A String value containing unknown.
Dispense Dosage_Duration_Status A String value containing unknown.
Dispense Early_Late_Refill_Status A String value containing unknown.
Dispense Dispense_Create_Date A String value containing unknown.
Dispense DUR_Warning_ID A String value containing unknown.
Dispense Date_Cancelled A String value containing unknown.
Dispense Partial_Fill_Status A String value containing unknown.
Dispense HOA_Code A String value containing unknown.
Dispense Number_Of_Labels A String value containing unknown.
Dispense Distribution_Method_Code A String value containing unknown.
Dispense Distribution_Method_Code_Group A String value containing unknown.
Dispense Quantity_Entry_Flag A String value containing unknown.
Dispense Batch_Label_Flag A String value containing unknown.
Dispense Override_Dispense_Time A String value containing unknown.
Dispense DispStatusId A String value containing unknown.
Dispense DispUpdateSource A String value containing unknown.
Dispense DispStatusLastUpdate A String value containing unknown.
Dispense UnicodeLanguageSig A String value containing unknown.
Dispense CycleFillFlag A String value containing unknown.
Dispense QEEndOfDistCycleDate A String value containing unknown.
Dispense Quantity_Dispensed_Ovrd A String value containing unknown.
Dispense PickupID A String value containing unknown.
Dispense BagTypeCode A String value containing unknown.
Dispense BagTypeCodeGrp A String value containing unknown.
Dispense DispenseDuration A String value containing unknown.
Dispense DispenseStopDate A String value containing unknown.
Dispense Receivable_ID A String value containing unknown.
Item Item_ID A String value containing the primary key for an item.
Item Current_Item_Version A String value containing the version for an item. (Might be part of the primary key)
Item NDC_Code A String value containing unknown.
Item Package_Code A String value containing unknown.
Item Package_Size A String value containing unknown.
Item Item_Type A String value containing unknown.
Item Item_Category_Code A String value containing unknown.
Item DUR_Screen_Indicator A String value containing unknown.
Item KDC_Number A String value containing unknown.
Item GPI_Group_Code A String value containing unknown.
Item GPI_Class_Code A String value containing unknown.
Item GPI_Subclass_Code A String value containing unknown.
Item GPI_Name_Code A String value containing unknown.
Item GPI_Name_Extension_Code A String value containing unknown.
Item GPI_Dosage_Form_Code A String value containing unknown.
Item GPI_Strength_Code A String value containing unknown.
Item HRI_Number A String value containing unknown.
Item Item_Dosage_Signa_Code A String value containing unknown.
Item Instruction_Signa_String A String value containing unknown.
Item Form_Type A String value containing unknown.
Item Route_Of_Administration A String value containing unknown.
Item Alternate_Manufacturer_ID A String value containing unknown.
Item UPC A String value containing unknown.
Item Current_Lot_Expiration_Date A String value containing unknown.
Item Current_Lot_Number A String value containing unknown.
Item Default_Dispense_Quantity A String value containing unknown.
Item Strength A String value containing unknown.
Item Package_UOM A String value containing unknown.
Item Pre_Pack_Size A String value containing unknown.
Item MFG_EDU_Materials_Flag A String value containing unknown.
Item Item_Package_Insert_Flag A String value containing unknown.
Item Item_Price_Schedule A String value containing unknown.
Item Cost_Basis A String value containing unknown.
Item Special_Pricing_ID A String value containing unknown.
Item Item_Mark_Up_Down_PCT A String value containing unknown.
Item Dosage_Add_On_Flag A String value containing unknown.
Item Preferred_Flag A String value containing unknown.
Item Wholesale_Acquisition_Cost A String value containing unknown.
Item Wholesale_Acquisition_Update_D A String value containing unknown.
Item Active_Flag AS ItemActiveFlag A String value containing unknown.
Item AVG_Wholesale_Price A String value containing unknown.
Item AVG_Wholsale_Update_Date A String value containing unknown.
Item Direct_Acquisition_Cost A String value containing unknown.
Item Direct_Acquisition_Update_Date A String value containing unknown.
Item EST_Acquisition_Cost A String value containing unknown.
Item EST_Acquisition_Update_Date A String value containing unknown.
Item Color_Code A String value containing unknown.
Item Flavor_Code A String value containing unknown.
Item Shape_Code A String value containing unknown.
Item Product_Marking A String value containing unknown.
Item Cross_Reference_Item_ID A String value containing unknown.
Item Multi_Source_Flag A String value containing unknown.
Item Innovator_Flag A String value containing unknown.
Item Substitutes_Flag A String value containing unknown.
Item Narcotic_Code A String value containing unknown.
Item Source_Indicator A String value containing unknown.
Item Imprint1_Code A String value containing unknown.
Item Imprint2_Code A String value containing unknown.
Item Unit_Size A String value containing unknown.
Item Unit_Of_Measure A String value containing unknown.
Item LTC_Dosage_Add_On_Flag A String value containing unknown.
Item OvrColorCode A String value containing unknown.
Item OvrFlavorCode A String value containing unknown.
Item OvrShapeCode A String value containing unknown.
Item OvrImprint1Code A String value containing unknown.
Item OvrImprint2Code A String value containing unknown.
Item OvrCautionCode A String value containing unknown.