public static List <string> GetConditionCodes(string encounterId) { DateTime todayDt = DateTime.Today; string[] items; StringBuilder sb = new StringBuilder(); sb.Append("select condition_cd from BAR_Encntr_Condition_Code "); sb.Append("where encntr_Id = " + long.Parse(encounterId) + " and active_ind = '1' "); sb.Append("AND END_EFFECTIVE_DT_TM > '" + todayDt + "'"); sb.Append(" order by sequence "); DataTable dt = new DataTable(); using (var conn = new SqlConnection(GlobalSettings.SqlConnectionString())) using (var cmd = new SqlCommand(sb.ToString(), conn)) using (var da = new SqlDataAdapter(cmd)) { da.Fill(dt); } List <string> condCodes = new List <string>(); foreach (DataRow row in dt.Rows) { string code = row["condition_cd"].ToString(); code = CodeValueDAL.GetCodeValueDisplay(code.Trim()); items = code.Split(' '); condCodes.Add(items[0].Trim()); } return(condCodes); }
private static Diagnosis LoadDiagnosis(DataRow row) { string diagCode = NomenclatureDAL.GetNomenclature_SourceIdentifier(row["nomenclature_id"].ToString()); string poa = CodeValueDAL.GetCodeValueDisplay(row["present_on_admit_cd"].ToString()); string pri = row["diag_priority"].ToString().Trim(); if (poa == "0") { poa = string.Empty; } Diagnosis dx = new Diagnosis(); dx.DxCode = diagCode; dx.GrouperVersion = string.Empty; dx.POA = poa; if (pri == "0" || pri == "") { dx.priority = string.Empty; } else { dx.priority = pri; } dx.DxType = row["diag_type_cd"].ToString().Trim(); return(dx); }
private static Encounter LoadEncounter(DataRow row) { string npi = ""; Encounter encounter = new Encounter(); encounter.Active_Ind = row["Active_Ind"].ToString().Replace(".0000", ""); string dischDisp = CernerCommon.StripDecimalsForMap(row["Disch_Disposition_Cd"].ToString()); encounter.Disch_Disposition_Cd = CernerMapDAL.GetMap("CERNER_DISCHARGE_DISPOSITION", dischDisp, dischDisp); encounter.Cerner_Disch_Disposition_Cd_Display = CodeValueDAL.GetCodeValueDisplay(dischDisp); encounter.Disch_Dt_Tm = row["Disch_Dt_Tm"].ToString(); encounter.Encntr_type_class_cd = row["Encntr_type_class_cd"].ToString().Replace(".0000", ""); encounter.Original_Encounter_Id = row["Encntr_Id"].ToString().Replace(".0000", ""); string encntrId = Encounter_AliasDAL.GetEncounterVisitNumber(row["Encntr_Id"].ToString().Replace(".0000", "")); encounter.Encounter_Id = encntrId; string encounterTypeCd = CernerCommon.StripDecimalsForMap(row["Encntr_Type_Cd"].ToString()); encounter.Cerner_Encoutner_Type_Cd = encounterTypeCd; //used for special logic in mpi conversion record 02 encounter.Cerner_Encounter_Type_Cd_Display = CodeValueDAL.GetCodeValueDisplay(encounterTypeCd); //for data sheet encounter.Encounter_Type_Cd = CernerMapDAL.GetMap("CERNER_REGTYPE", encounterTypeCd, encounterTypeCd); encounter.Inpatient_Admit_Dt_Tm = row["Inpatient_Admit_Dt_Tm"].ToString(); //From Encounter Table use field E_LOC_NURSE_UNIT_CD to retrieve the DISPLAY_KEY (col E) in CodeSet 220. //Use the DISPLAY_KEY to retrieve the Meditech location from the spreadsheet - "Approved locations" string loc = CodeValueDAL.GetCodeValueDisplay_Key(row["Loc_Nurse_Unit_Cd"].ToString().Replace(".0000", "")); encounter.Cerner_Loc_Nurse_Unit_Cd_Display = loc; //for data sheet encounter.Loc_Nurse_Unit_Cd = CernerMapDAL.GetMap("CERNER_LOCATION", loc, loc); //string attendPhys = EncntrPrsnlReltnDAL.GetAttendPhysician(row["Encntr_Id"].ToString()); encounter.AttendPhysicianId = ""; //attendPhys; //MPIOrganization org = MPIOrganizationDAL.GetOrganization(CernerCommon.StripDecimalsForMap(encounter.Organization_Id)); //npi = PrsnlAliasDAL.GetPrsnlAlias(attendPhys); encounter.AttendPhysician = "";//CernerMapDAL.GetMapDR(npi, facility, "Z.CONVPROV"); encounter.Person_Id = row["Person_Id"].ToString().Replace(".0000", ""); encounter.Reason_For_Visit = row["Reason_For_Visit"].ToString(); encounter.Reg_Dt_Tm = row["Reg_Dt_Tm"].ToString(); encounter.ConfidentialVisit = row["confid_level_cd"].ToString(); encounter.VIP_Cd = row["vip_cd"].ToString().Replace(".0000", ""); encounter.Organization_Id = row["organization_id"].ToString().Replace(".0000", ""); encounter.Med_Serv_Cd = row["med_service_cd"].ToString().Replace(".0000", ""); //DateTime? d = GMTtoTZ(encounter.Disch_Dt_Tm, "Mountain Standard Time"); //for BAR encounter.BAR_Encounter_Type_Cd = CernerMapDAL.GetMap("CERNER_REGTYPE", encounterTypeCd, encounterTypeCd); encounter.Admit_Src_Cd = row["admit_src_cd"].ToString().Replace(".0000", ""); encounter.Admit_Type_Cd = row["admit_type_cd"].ToString().Replace(".0000", ""); return(encounter); }
private static Person_Alias LoadPersonAlias(DataRow row) { Person_Alias alias = new Person_Alias(); alias.Aleas_Pool = CodeValueDAL.GetCodeValueDisplay(row["alias_pool_Cd"].ToString()); alias.Alias_Type = CodeValueDAL.GetCodeValueDisplay(row["person_alias_type_cd"].ToString()); alias.Alias = row["alias"].ToString(); return(alias); }
private static Occurrence_Code LoadOccurrenceCodes(DataRow row) { string ocode = ""; string[] items; Occurrence_Code code = new Occurrence_Code(); ocode = CodeValueDAL.GetCodeValueDisplay(row["occurrence_cd"].ToString().Trim()); items = ocode.Split(' '); code.OccurrenceCode = items[0].Trim(); code.OccurrenceDate = CernerCommon.ConvertDateString(row["occurrence_dt_tm"].ToString()); return(code); }
private static Person LoadPersons(DataRow row) { string personId = row["related_person_id"].ToString(); string relationship = CernerCommon.StripDecimalsForMap(row["related_person_reltn_cd"].ToString()); Person person = PersonDAL.GetPerson(personId); if (person != null) { person.Cerner_Relationship = CodeValueDAL.GetCodeValueDisplay(relationship); person.RelationShip = CernerMapDAL.GetMap("CERNER_RELATIONSHIP", relationship, relationship); } return(person); }
private static Diagnosis LoadDiagnosis(DataRow row) { string diagCode = NomenclatureDAL.GetNomenclature_SourceIdentifier(row["nomenclature_id"].ToString()); string poa = CodeValueDAL.GetCodeValueDisplay(row["present_on_admit_cd"].ToString() + ".0000"); if (poa == "0") { poa = string.Empty; } Diagnosis dx = new Diagnosis(); dx.DxCode = diagCode; dx.GrouperVersion = string.Empty; dx.POA = poa; return(dx); }
private static List <Person> LoadPersons(DataTable dt) { List <Person> persons = new List <Person>(); foreach (DataRow row in dt.Rows) { string personId = row["related_person_id"].ToString(); string relationship = CernerCommon.StripDecimalsForMap(row["related_person_reltn_cd"].ToString()); Person person = PersonDAL.GetPerson(personId); if (person != null) { person.Cerner_Relationship = CodeValueDAL.GetCodeValueDisplay(relationship); person.RelationShip = CernerMapDAL.GetMap("CERNER_RELATIONSHIP", relationship, relationship); persons.Add(person); } } return(persons); }
private static Value_Code LoadValueCode(DataRow row) { string vcode = ""; string[] items; Value_Code code = new Value_Code(); vcode = CodeValueDAL.GetCodeValueDisplay(row["value_cd"].ToString().Trim()); items = vcode.Split(' '); code.ValueCode = items[0].Trim(); string amt = row["amount"].ToString(); if (amt.Trim().Length > 0) { if (amt.Trim() != "null") { code.ValueAmount = Convert.ToDecimal(amt); } } return(code); }