For questions about this archive, please contact webmaster@hl7.org.
Welcome Bot (Jan 04 2018 at 09:52):Welcome to #v2.
Description: V2 specification questions / discussion
Grahame Grieve (Jan 04 2018 at 09:52):Welcome everyone. I added all the users here that have a known interest in v2
Shyamanand Rath (May 30 2018 at 18:29):I need help to map few fields to HL7 version 2.x Messages/Segments (any version of HL7 2.x would be fine). The HL7 messages will be received through a HL7 listener. I'm unable to upload the fields as an attachment. Can anyone please to whom I can email my file?
Shyamanand Rath (May 30 2018 at 18:29):*tell me
Shyamanand Rath (May 30 2018 at 21:54):My email id is shyam.rath3@gmail.com
Shyamanand Rath (May 30 2018 at 22:39): Shyamanand Rath (May 31 2018 at 17:28):@Grahame Grieve
Hello Grahame,
I am having difficulty in mapping most of the fields listed below this message to HL7 version 2.x Message Structure (I could not upload it as a file). I would be extremely grateful if you can help me to identify the mapping the fields up to Message and Segment level (any version of HL7 2.x is fine).
Thanking you in advance
--Shyam
Encounter Table
{
"_id" : ObjectId("5af14b0980044239d4220d77"),
"personId" : ObjectId("5af13e684c38512750066890"),
"startDtTm" : ISODate("2018-05-08T07:00:25.414Z"),
"status" : "c",
"activeInd" : true,
"updtBy" : ObjectId("5af1365ffa79102660282f19"),
"updtTm" : ISODate("2018-05-08T07:00:25.414Z")
}
Login Users
{
"_id" : ObjectId("5af197b4373a8113bc62ce9b"),
"username" : "rohith",
"email" : "abc@gmail.com",
"password" : "rohith",
"timestamp" : 1525782452,
"online" : "N",
"socketId" : "HJ2hDfkCf",
"type" : 2,
"status" : "Active"
}
Allergy Table
{
"_id" : ObjectId("5af1dde07ea5613c90c893f1"),
"type" : "Food",
"subType" : "Oysters",
"reactionType" : "Nausea",
"dateKnown" : ISODate("2018-05-07T18:30:00.000Z"),
"personId" : ObjectId("5af1a085373a8113bc62ce9e"),
"documentedBy" : "5af194f8373a8113bc62ce95",
"encntrId" : ObjectId("5af1a402373a8113bc62cea0"),
"activeInd" : 1,
"comments" : "Vomiting Sensation after dinner",
"timestamp" : ISODate("2018-05-08T17:26:56.095Z")
}
Diagnosis Table
{
"_id" : ObjectId("5b0bb7678f1e6c441cdfbbc3"),
"category" : "CIRCULATORY",
"code" : "I89.1",
"name" : "Lymphangitis",
"isPrimaryDiagnosis" : true,
"startDate" : ISODate("2018-05-27T18:30:00.000Z"),
"documentedBy" : "5af1365ffa79102660282f19",
"activeInd" : 1,
"encntrId" : ObjectId("5b0bb3078f1e6c441cdfbbbb"),
"personId" : ObjectId("5af1c8fa7ea5613c90c893ce"),
"timestamp" : ISODate("2018-05-28T08:01:43.831Z")
}
Vitals Table
{
"_id" : ObjectId("5af1a7d7373a8113bc62ceaf"),
"patientId" : ObjectId("5af1a085373a8113bc62ce9e"),
"encntrId" : "5af1a402373a8113bc62cea0",
"recordedDate" : ISODate("2018-04-13T06:27:15.000Z"),
"height" : "165",
"weight" : "56",
"temperature" : "92",
"heart_rate" : "81",
"bpsystolic" : "130",
"bpdiastolic" : "90",
"blood_glucose" : "3.4",
"spo2" : "95",
"bmi" : "20.57"
}
Procedure Table
{
"_id" : ObjectId("5b0d0967cead6738e4da16eb"),
"startDate" : ISODate("2018-05-28T18:30:00.000Z"),
"procedureType" : "Surgical",
"anaesthesiaType" : "Spinal",
"assocDiagnosis" : "Disorders of arteries, arterioles and capillaries in diseases classified elsewhere",
"documentedBy" : "5af1365ffa79102660282f19",
"activeInd" : 1,
"procedureNotes" : {},
"personId" : ObjectId("5af19857373a8113bc62ce9c"),
"encntrId" : ObjectId("5b0d07b8cead6738e4da16e6"),
"name" : "INSERTION OF PACEMAKER LEAD INTO RIGHT ATRIUM, PERC APPROACH",
"description" : "",
"code" : "02H63JZ",
"timestamp" : ISODate("2018-05-29T08:03:51.184Z")
}
Chief Complaint Historical Patient Illness Table
{
"_id" : ObjectId("5af824e81be54a1d3c6f9b6a"),
"recordedDtTm" : ISODate("2018-05-01T11:43:07.000Z"),
"complaints" : "Watering Eye",
"location" : "(R) Eye",
"aggravatingFactor" : "Watching Tv",
"intensity" : "Moderate",
"period" : "Past 1 week",
"associatedFactor" : "Exposed to Sunlight",
"relievingFactor" : "Eye Drops",
"documentedBy" : ObjectId("5af13741fa79102660282f1c"),
"activeInd" : 0,
"encntrId" : ObjectId("5af8238d1be54a1d3c6f9b66"),
"patientId" : ObjectId("5af197b4373a8113bc62ce9b"),
"timestamp" : ISODate("2018-05-28T10:43:18.585Z"),
"checkValue" : true
}
WalkIn Table
{
"_id" : ObjectId("5b0bad4b43fc390070a1e0f1"),
"physcianId" : ObjectId("5af194f8373a8113bc62ce95"),
"patients" : [
{
"patientId" : ObjectId("5af1ca297ea5613c90c893cf"),
"Name" : "Usha",
"speciality" : "Cardiology",
"location" : "Columbia Asia Hospital",
"Age" : 22,
"Sex" : "Female",
"date" : ISODate("2018-05-28T00:00:00.000Z"),
"status" : "COMPLETED",
"id" : 1
}
]
}
Gynec Table
{
"_id" : ObjectId("5afe56656cc6ed2ff427d99a"),
"encntrId" : ObjectId("5afe55526cc6ed2ff427d999"),
"patientId" : ObjectId("5af1cdda7ea5613c90c893d3"),
"documentedBy" : ISODate("1970-01-01T00:00:00.000Z"),
"recordedDate" : ISODate("2018-05-18T04:27:36.462Z"),
"ageOfMenarche" : "14",
"ageOfMenoPause" : "",
"gravida" : "1",
"para" : "0",
"lastMenstrualDate" : "2018-05-06T18:30:00.000Z",
"menstrualPeriod" : "regular",
"cycleLength" : "31",
"isPregnant" : true,
"expectedDeliveryDate" : "2019-02-10T18:30:00.000Z",
"activeInd" : 1,
"comments" : "",
"timeStamp" : ISODate("2018-05-18T04:28:21.108Z")
}
Social History Table
{
"_id" : ObjectId("5afbc836344c552c5826e630"),
"encntrId" : ObjectId("5afbc759344c552c5826e624"),
"patientId" : ObjectId("5af1cd457ea5613c90c893d2"),
"documentedBy" : ObjectId("5af1365ffa79102660282f19"),
"recordedDate" : ISODate("2018-05-16T05:56:42.557Z"),
"comments" : "",
"activeInd" : 1,
"exercise" : {
"value" : "Never",
"comment" : ""
},
"caffieneIntake" : {
"value" : "5 plus cups/day",
"comment" : ""
},
{
.
.
},
"timeStamp" : ISODate("2018-05-16T05:57:10.123Z")
}
Medical History
{
"_id" : ObjectId("5af824fa1be54a1d3c6f9b6f"),
"highBp" : true,
"lowBp" : false,
"diabetesMellitus" : false,
"cholesterol" : true,
"lungsDisease" : false,
"cancer" : false,
"liverDisease" : false,
"std" : false,
"asthma" : true,
"tb" : true,
"kidneyDisease" : false,
"neurological" : false,
"heartAilment" : false,
"thyroid" : false,
"stroke" : false,
"recordedDate" : ISODate("2018-05-01T18:30:00.000Z"),
"documentedBy" : ObjectId("5af13741fa79102660282f1c"),
"activeInd" : 1,
"encntrId" : ObjectId("5af8238d1be54a1d3c6f9b66"),
"patientId" : ObjectId("5af197b4373a8113bc62ce9b"),
"timeStamp" : ISODate("2018-05-13T11:44:40.351Z"),
"comments" : "Breathing Trouble"
}
Obstetrics Table
{
"_id" : ObjectId("5afbda22344c552c5826e711"),
"yearOfDelivery" : "2018-02-05T18:30:00.000Z",
"lengthOfPregnancy" : "36",
"noOfBabies" : "1",
"documentedBy" : ObjectId("5af1365ffa79102660282f19"),
"activeInd" : 1,
"encntrId" : ObjectId("5afbd4b8344c552c5826e6d0"),
"patientId" : ObjectId("5af1ceba7ea5613c90c893d5"),
"babies" : [
{
"babyCode" : "Baby (1)",
"babyOutcome" : "Alive",
"gender" : "Female",
"weight" : "6",
"activeBabyInd" : 1,
"tempActiveBabyInd" : 1,
"minDate" : "2018-02-05T18:30:00.000Z",
"birthDateTime" : "2018-02-05T19:13:16.000Z",
"labourType" : "Induced",
"modeOfDelivery" : "Vaginal Delivery"
}
],
"timeStamp" : ISODate("2018-05-16T07:13:38.804Z")
}
Radiology Table
{
"_id" : ObjectId("5b0d11f7cead6738e4da16f9"),
"orderDateTime" : "2018-05-29T08:39:30.138Z",
"orderType" : "xray",
"associateDiagnosis" : "Lymphangitis",
"linkOrder" : [
"5b0d114ecead6738e4da16f8"
],
"shortDesc" : "Surgery - Hand Fracture",
"longDesc" : "Surgery completed - Hand Fracture",
"status" : "COMPLETED",
"patientId" : ObjectId("5af1c8fa7ea5613c90c893ce"),
"encntrId" : ObjectId("5b0d0edfcead6738e4da16f1"),
"location" : "Columbia Asia Hospital",
"speciality" : "Cardiothoracic surgery",
"orderedBy" : ObjectId("5af1365ffa79102660282f19"),
"radOrderId" : "lzMjCA9gBK",
"timeStamp" : ISODate("2018-05-29T08:40:23.563Z"),
"activeInd" : 1,
"results" : [
"Surgery completed with insertion of screws and bolts",
"Surgery completed."
],
"linkedImages" : [
"After Surgery arm 2.jpg",
"After Surgery arm1.jpg"
]
}
Message Contd..
Shyamanand Rath (May 31 2018 at 17:33):@Grahame Grieve
Message Contd...
Patient Registration Table
{
"_id" : ObjectId("5af1600980044239d4220d7d"),
"Salutation" : "MR",
"FirstName" : "JOHNHP",
"LastName" : "PETER",
"DOB" : ISODate("2015-02-01T18:30:00.000Z"),
"Gender" : "Male",
"address_line1" : "206",
"address_line2" : "1 ST CROSS",
"address_line3" : "BEMLBANGALORE",
"State" : "KARNATAKA",
"Country" : "INDIA",
"Pincode" : "56078",
"marital_status" : "Single",
"PhoneNo" : "9870098700",
"employment_status" : "Employed",
"employer_name" : "ABC",
"employer_address" : "MG ROAD",
"employer_phone" : "6578789876",
"emergency_contact_name" : "PETER",
"emergency_contact_phone" : "9860098600",
"guarantor_name" : "PETER",
"guarantor_Contact_no" : "9870098098",
"Guarantor_relationship" : "FATHER",
"templateId" : "710",
"patientId" : "2018-00002",
"imageUrl" : "2018-00002_DP.jpg",
"created_on" : ISODate("2018-05-08T08:30:01.687Z")
}
Review Of System
{
"_id" : ObjectId("5afad7835ba1421a7c8a722d"),
"encntrId" : ObjectId("5afad5915ba1421a7c8a7220"),
"patientId" : ObjectId("5af1c8fa7ea5613c90c893ce"),
"documentedBy" : ObjectId("5af13741fa79102660282f1c"),
"recordedDate" : ISODate("2018-05-15T12:49:42.386Z"),
"rosComment" : "",
"activeInd" : 1,
"gastrointestinal" : {
"values" : [
"Nausea",
"Loss of appetite",
"Heart burn"
],
"comment" : ""
},
"respiratory" : {
"values" : [
"Cough",
"Shortness of breath on rest"
],
"comment" : ""
},
{
.
.
},
"timeStamp" : ISODate("2018-05-15T12:50:11.553Z")
}
Family History Table
{
"_id" : ObjectId("5afc054f344c552c5826e858"),
"documentedBy" : ObjectId("5af1365ffa79102660282f19"),
"activeInd" : 1,
"encntrId" : ObjectId("5afc0460344c552c5826e856"),
"patientId" : ObjectId("5af1d58c7ea5613c90c893db"),
"recordedDate" : ISODate("2018-05-16T10:17:33.759Z"),
"comments" : "",
"history" : [
{
"medicalList" : "Alive",
"brother" : false,
"daughter" : false,
"father" : true,
"grandFather" : false,
"grandMother" : false,
"mother" : false,
"sister" : false,
"son" : false
},
{
"medicalList" : "High BP",
"brother" : false,
"daughter" : false,
"father" : false,
"grandFather" : false,
"grandMother" : false,
"mother" : false,
"sister" : false,
"son" : false
},
],
"timeStamp" : ISODate("2018-05-16T10:17:51.518Z")
}
Prescription Table
{
"_id" : ObjectId("5afbe28d344c552c5826e792"),
"documentedBy" : ObjectId("5af1365ffa79102660282f19"),
"encntrId" : ObjectId("5afbde71344c552c5826e754"),
"patientId" : ObjectId("5af1d3dc7ea5613c90c893d7"),
"activeInd" : 1,
"prescribedDate" : ISODate("2018-05-16T07:49:33.353Z"),
"assocDiagnosis" : "Alopecia areata",
"presciptionId" : "184b0693-a566-73bb-ef42-415a962347eb",
"prescribeDrugs" : [
{
"drugName" : "Encript5 mg Cap",
"tradeName" : "Encript",
"genericName" : "Bromocriptine",
"drugCode" : "00078-0102-15",
"manufacturer" : "Micro Synapse",
"strength" : "5",
"strengthUnits" : "mg",
"form" : "Cap",
"route" : "ORAL",
"drugType" : "Normal",
"frequency" : {
"name" : "Twice daily",
"value" : "2"
},
"duration" : "0",
"durationUnits" : "",
"dose" : "5",
"doseUnits" : "mg",
"updateBy" : "",
"timeStamp" : "",
"activeInd" : 1,
"durationType" : "days",
"startDate" : ISODate("2018-05-16T00:00:00.000Z"),
"endDate" : ISODate("2018-05-16T00:00:00.000Z"),
"assocDiagnosis" : "Alopecia areata",
"medId" : "5af937efab21868c0ff24b1c",
"dosageType" : "F",
"doseFrequency" : [],
"color" : "black",
"drugToolTip" : "Encript5 mg Cap 5 undefined Cap 2 ORAL Normal 5 mg 0 days May 16, 2018 May 16, 2018 Alopecia areata"
}
],
"timeStamp" : ISODate("2018-05-16T07:49:33.398Z")
}
Provider Table
{
"_id" : ObjectId("5af196db373a8113bc62ce99"),
"firstName" : "Anju",
"lastName" : "George",
"gender" : "Female",
"qualification" : "MS",
"providerType" : "Surgeon",
"contact" : "9821098210",
"emailId" : "anjug@ge.com",
"status" : "Active",
"slotInfo" : [
{
"idx" : 1,
"location" : "Apollo Hospital",
"speciality" : "Pediatric Surgery",
"startDate" : "2018-05-09T00:00:00.000Z",
"endDate" : "2018-07-31T00:00:00.000Z",
"startTime" : "08:00 am",
"endTime" : "01:00 pm",
"ActiveInd" : true,
"slotType" : "v",
"slotPerDay" : 5,
"overBookingAllowed" : false,
"forceBookingAllowed" : false
},
{
"idx" : 2,
"location" : "Apollo Hospital",
"speciality" : "Pediatric Surgery",
"startDate" : "2018-05-09T00:00:00.000Z",
"endDate" : "2018-07-31T00:00:00.000Z",
"startTime" : "01:00 pm",
"endTime" : "06:00 pm",
"ActiveInd" : true,
"slotType" : "v",
"slotPerDay" : 5,
"overBookingAllowed" : false,
"forceBookingAllowed" : false
},
]
}
Rene Spronk (Jun 01 2018 at 08:06):Well, whilst we're certainly willing to put you on the right track, I'm afraid we won't be able to do the things that you should be doing, as all of us are volunteers. Please read the definitions of the PID PV1 OBX AL1 PR1 segments as a starting point and create mappings for those. If you have a specific/detailed question how to map a certain data item, or to solve a particular use case, then please don't hesitate to ask again.
Shyamanand Rath (Jun 01 2018 at 08:14):Sure, Thank you very much for replying. I'll remove the fields for which I have already found the mapping from my list.
Lloyd McKenzie (Jun 01 2018 at 15:45):@Shyamanand Rath There isn't yet a specific document aimed at the HL7 chat, so I'm going to point you to FHIR's rules for asking questions which I think hold here as well. This sort of question falls under the category of "Please do my homework for me". If you had done the work and found mappings for most of your elements but had one or two you were struggling with, this forum is a perfectly appropriate place to ask for guidance. However, if you'd like someone to map 100+ data elements, the only appropriate use of this forum would be to solicit for individuals interested in a short-term contract to do the work for you.
Shyamanand Rath (Jun 01 2018 at 15:56):Sure Lloyd, I will follow the guidelines and request for the specific fields for which I had trouble in mapping the same. Thank you for the input.
Shyamanand Rath (Jun 03 2018 at 03:56):Which segment should I refer for Chief Complaint, Gynecology, Social History, Medical History, Obstetrics, Radiology, Family History, Prescriptions?
Rene Spronk (Jun 04 2018 at 09:36):Most of those are Observations, please study chapter 7 and the OBX segment, as well as the Pharmacy messages detailed in chapter 4.
Shyamanand Rath (Jun 04 2018 at 13:20):Thank You Rene
Shyamanand Rath (Jun 16 2018 at 17:32):Hello Rene
Thanks a lot for your inputs, I have mapped some of the fields as shown in the attached sheet. However, I'm unable to find the mappings for few other fields. Can you please check my attached sheet once?
Thanks in advance for your time.
Shyam
HL7-Map.xlsx
Last updated: Mar 23 2020 at 00:02 UTC