|
|
| Line 16: |
Line 16: |
| * [[LoadCognos.bat]] calls | | * [[LoadCognos.bat]] calls |
| * [[LoadCognos.vbs]] which calls | | * [[LoadCognos.vbs]] which calls |
| * [[Sub CognosImport]] for the actual steps performed during import, and ow the queries and tables work together. | | * [[Sub CognosImport]] for the actual steps performed during import, and ow the queries and tables work together. |
| | |
| {{Discuss | Where should this live? }}
| |
| This next part isn't really part of the import but the explanation needs to live somewhere, so parking here for now.
| |
| * [[Cognos_integrator query]] then tries to match up the data from Cognos to records currently or previously on the laptop; it uses [[Cognos_dispo_translator table]] and [[Cognos_SubServices table]] for the mapping
| |
| * field equivalences (sort of see [[Cognos_import_processor query]] and [[Cognos_integrator query]] for details)
| |
| ** IPAdmitDtm --> [[Accept DtTm]] (but only if pt is from ER)
| |
| ** AsgnUnitStartDtm_current --> [[Arrive DtTm]] or [[Boarding Loc]] date and time
| |
| ** AsgnUnitEndDtm_current --> [[Dispo DtTm]] or [[Boarding Loc]] date and time
| |
| ** AsgnUnit_Prior (but it's more complicated, when pt comes from ER or other site there is info in field "EmergencyDepartment" or "ReferringLocation"; I try to summarize this in [[Cognos_import_processor query]], but not yet good enough for automation) --> [[Previous Location]]
| |
| ** AsgnUnit_current --> [[Service/Location]] or [[Boarding Loc]]
| |
| ** AsgnUnit_Next / IPDischargeDisposition / IPDischargeLocation --> [[Dispo]]
| |
| | |
| * then [[Cognos_integrator query]] draws from [[Cognos_processed table]] and feeds the following:
| |
| ** [[Cognos_Admitter_FormQuery query]] feeds [[Cognos Admitter]]
| |
| ** [[Cognos_Patient_viewer_tab_FormQuery query]] feeds [[Patient viewer tab Cognos ADT]]
| |
| ** [[Cognos_Discharger_FormQuery query]] feeds [[Cognos Discharger]]
| |
|
| |
|
| == Related articles == | | == Related articles == |