QuerySunwaveBedboard.hpl

<?xml version="1.0" encoding="UTF-8"?>
<pipeline>
  <info>
    <name>QuerySunwaveBedboard</name>
    <name_sync_with_filename>Y</name_sync_with_filename>
    <description/>
    <extended_description/>
    <pipeline_version/>
    <pipeline_type>Normal</pipeline_type>
    <parameters>
    </parameters>
    <capture_transform_performance>N</capture_transform_performance>
    <transform_performance_capturing_delay>1000</transform_performance_capturing_delay>
    <transform_performance_capturing_size_limit>100</transform_performance_capturing_size_limit>
    <created_user>-</created_user>
    <created_date>2023/08/01 18:43:34.654</created_date>
    <modified_user>-</modified_user>
    <modified_date>2023/08/01 18:43:34.654</modified_date>
  </info>
  <notepads>
  </notepads>
  <order>
    <hop>
      <from>Generate rows</from>
      <to>REST client</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>REST client</from>
      <to>Buildings Parse JSON</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Buildings Parse JSON</from>
      <to>Select values</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>REST client</from>
      <to>Rooms JSON input</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>REST client</from>
      <to>Beds JSON input 2</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Rooms JSON input</from>
      <to>Select values 2</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Beds JSON input 2</from>
      <to>Select values 3</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values</from>
      <to>Buildings Stream lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values 2</from>
      <to>Rooms Stream lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values 3</from>
      <to>Rooms Stream lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Rooms Stream lookup</from>
      <to>Buildings Stream lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Buildings Stream lookup</from>
      <to>Remove Nulls</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Remove Nulls</from>
      <to>fct_building_occupency</to>
      <enabled>N</enabled>
    </hop>
    <hop>
      <from>Remove Nulls</from>
      <to>String operations</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>String operations</from>
      <to>Table output</to>
      <enabled>Y</enabled>
    </hop>
  </order>
  <transform>
    <name>Beds JSON input 2</name>
    <type>JsonInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <include>N</include>
    <include_field/>
    <rownum>N</rownum>
    <addresultfile>N</addresultfile>
    <readurl>N</readurl>
    <removeSourceField>N</removeSourceField>
    <IsIgnoreEmptyFile>N</IsIgnoreEmptyFile>
    <doNotFailIfNoFile>Y</doNotFailIfNoFile>
    <ignoreMissingPath>Y</ignoreMissingPath>
    <defaultPathLeafToNull>Y</defaultPathLeafToNull>
    <rownum_field/>
    <file>
      <name/>
      <filemask/>
      <exclude_filemask/>
      <file_required>N</file_required>
      <include_subfolders>N</include_subfolders>
    </file>
    <fields>
      <field>
        <name>admissionDate</name>
        <path>$.*.rooms.*.beds.*.admissionDate</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>allergies</name>
        <path>$.*.rooms.*.beds.*.allergies</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>bedId</name>
        <path>$.*.rooms.*.beds.*.bedId</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>bed_name</name>
        <path>$.*.rooms.*.beds.*.bed_name</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>bed_statuses</name>
        <path>$.*.rooms.*.beds.*.bed_statuses</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>building_id</name>
        <path>$.*.rooms.*.beds.*.building_id</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>checkin</name>
        <path>$.*.rooms.*.beds.*.checkin</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>checkin_id</name>
        <path>$.*.rooms.*.beds.*.checkin_id</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>checkout</name>
        <path>$.*.rooms.*.beds.*.checkout</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>fullName</name>
        <path>$.*.rooms.*.beds.*.fullName</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>insurance</name>
        <path>$.*.rooms.*.beds.*.insurance</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>labels</name>
        <path>$.*.rooms.*.beds.*.labels</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>level_of_care</name>
        <path>$.*.rooms.*.beds.*.level_of_care</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>mri</name>
        <path>$.*.rooms.*.beds.*.mri</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>patientGender</name>
        <path>$.*.rooms.*.beds.*.patientGender</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>patient_id</name>
        <path>$.*.rooms.*.beds.*.patient_id</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>plannedDischarge</name>
        <path>$.*.rooms.*.beds.*.plannedDischarge</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>precautions</name>
        <path>$.*.rooms.*.beds.*.precautions</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>q</name>
        <path>$.*.rooms.*.beds.*.q</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>referalDestination</name>
        <path>$.*.rooms.*.beds.*.referalDestination</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>referalSource</name>
        <path>$.*.rooms.*.beds.*.referalSource</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>reserved_by</name>
        <path>$.*.rooms.*.beds.*.reserved_by</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>reserved_for_account_id</name>
        <path>$.*.rooms.*.beds.*.reserved_for_account_id</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>reserved_for_name</name>
        <path>$.*.rooms.*.beds.*.reserved_for_name</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>reserved_until</name>
        <path>$.*.rooms.*.beds.*.reserved_until</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>room_id</name>
        <path>$.*.rooms.*.beds.*.room_id</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
    </fields>
    <limit>0</limit>
    <IsInFields>Y</IsInFields>
    <IsAFile>N</IsAFile>
    <valueField>result</valueField>
    <shortFileFieldName/>
    <pathFieldName/>
    <hiddenFieldName/>
    <lastModificationTimeFieldName/>
    <uriNameFieldName/>
    <rootUriNameFieldName/>
    <extensionFieldName/>
    <sizeFieldName/>
    <attributes/>
    <GUI>
      <xloc>448</xloc>
      <yloc>400</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Buildings Parse JSON</name>
    <type>JsonInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <include>N</include>
    <include_field/>
    <rownum>N</rownum>
    <addresultfile>N</addresultfile>
    <readurl>N</readurl>
    <removeSourceField>N</removeSourceField>
    <IsIgnoreEmptyFile>N</IsIgnoreEmptyFile>
    <doNotFailIfNoFile>Y</doNotFailIfNoFile>
    <ignoreMissingPath>Y</ignoreMissingPath>
    <defaultPathLeafToNull>Y</defaultPathLeafToNull>
    <rownum_field/>
    <file>
      <name/>
      <filemask/>
      <exclude_filemask/>
      <file_required>N</file_required>
      <include_subfolders>N</include_subfolders>
    </file>
    <fields>
      <field>
        <name>building_name</name>
        <path>$.*.building_name</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>id</name>
        <path>$.*.id</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>max_number_of_beds</name>
        <path>$.*.max_number_of_beds</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>requires_check_in</name>
        <path>$.*.requires_check_in</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
    </fields>
    <limit>0</limit>
    <IsInFields>Y</IsInFields>
    <IsAFile>N</IsAFile>
    <valueField>result</valueField>
    <shortFileFieldName/>
    <pathFieldName/>
    <hiddenFieldName/>
    <lastModificationTimeFieldName/>
    <uriNameFieldName/>
    <rootUriNameFieldName/>
    <extensionFieldName/>
    <sizeFieldName/>
    <attributes/>
    <GUI>
      <xloc>464</xloc>
      <yloc>176</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Buildings Stream lookup</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Select values</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>building_id</name>
        <field>id</field>
      </key>
      <value>
        <name>building_name</name>
        <rename>building_name</rename>
        <default/>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>960</xloc>
      <yloc>176</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Generate rows</name>
    <type>RowGenerator</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <length>-1</length>
        <name>Prime</name>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
        <type>Integer</type>
      </field>
    </fields>
    <interval_in_ms>5000</interval_in_ms>
    <last_time_field>FiveSecondsAgo</last_time_field>
    <limit>1</limit>
    <never_ending>N</never_ending>
    <row_time_field>now</row_time_field>
    <attributes/>
    <GUI>
      <xloc>96</xloc>
      <yloc>176</yloc>
    </GUI>
  </transform>
  <transform>
    <name>REST client</name>
    <type>Rest</type>
    <description/>
    <distribute>N</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <applicationType>TEXT PLAIN</applicationType>
    <method>GET</method>
    <url>https://emr.sunwavehealth.com/SunwaveEMR/api/bedboard/buildings</url>
    <urlInField>N</urlInField>
    <dynamicMethod>N</dynamicMethod>
    <methodFieldName/>
    <urlField/>
    <bodyField/>
    <httpLogin>oliver.nielsen@kpi-forge.com:358:61</httpLogin>
    <httpPassword>Encrypted 2be98afc86aa7f2a6aa10a275c7c3fc9b</httpPassword>
    <proxyHost/>
    <proxyPort/>
    <preemptive>Y</preemptive>
    <trustStoreFile/>
    <trustStorePassword>Encrypted </trustStorePassword>
    <ignoreSsl>N</ignoreSsl>
    <headers>
      </headers>
    <parameters>
      </parameters>
    <matrixParameters>
      </matrixParameters>
    <result>
      <name>result</name>
      <code/>
      <response_time/>
      <response_header/>
    </result>
    <attributes/>
    <GUI>
      <xloc>272</xloc>
      <yloc>176</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Remove Nulls</name>
    <type>FilterRows</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <compare>
      <condition>
        <conditions>
</conditions>
        <function>IS NOT NULL</function>
        <leftvalue>admissionDate</leftvalue>
        <negated>N</negated>
        <operator>-</operator>
      </condition>
    </compare>
    <send_true_to>String operations</send_true_to>
    <attributes/>
    <GUI>
      <xloc>1152</xloc>
      <yloc>176</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Rooms JSON input</name>
    <type>JsonInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <include>N</include>
    <include_field/>
    <rownum>N</rownum>
    <addresultfile>N</addresultfile>
    <readurl>N</readurl>
    <removeSourceField>N</removeSourceField>
    <IsIgnoreEmptyFile>N</IsIgnoreEmptyFile>
    <doNotFailIfNoFile>Y</doNotFailIfNoFile>
    <ignoreMissingPath>Y</ignoreMissingPath>
    <defaultPathLeafToNull>Y</defaultPathLeafToNull>
    <rownum_field/>
    <file>
      <name/>
      <filemask/>
      <exclude_filemask/>
      <file_required>N</file_required>
      <include_subfolders>N</include_subfolders>
    </file>
    <fields>
      <field>
        <name>id</name>
        <path>$.*.rooms.*.id</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>name</name>
        <path>$.*.rooms.*.name</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
      <field>
        <name>room_gender</name>
        <path>$.*.rooms.*.room_gender</path>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
        <repeat>N</repeat>
      </field>
    </fields>
    <limit>0</limit>
    <IsInFields>Y</IsInFields>
    <IsAFile>N</IsAFile>
    <valueField>result</valueField>
    <shortFileFieldName/>
    <pathFieldName/>
    <hiddenFieldName/>
    <lastModificationTimeFieldName/>
    <uriNameFieldName/>
    <rootUriNameFieldName/>
    <extensionFieldName/>
    <sizeFieldName/>
    <attributes/>
    <GUI>
      <xloc>448</xloc>
      <yloc>288</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Rooms Stream lookup</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Select values 2</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>room_id</name>
        <field>id</field>
      </key>
      <value>
        <name>name</name>
        <rename>room_name</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>room_gender</name>
        <rename>room_gender</rename>
        <default/>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>784</xloc>
      <yloc>288</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Select values</name>
    <type>SelectValues</type>
    <description/>
    <distribute>N</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <select_unspecified>N</select_unspecified>
      <remove>
        <name>result</name>
      </remove>
      <remove>
        <name>Prime</name>
      </remove>
      <meta>
        <name>max_number_of_beds</name>
        <rename>max_number_of_beds</rename>
        <type>Integer</type>
        <length>-2</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
    </fields>
    <attributes/>
    <GUI>
      <xloc>640</xloc>
      <yloc>176</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Select values 2</name>
    <type>SelectValues</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <select_unspecified>N</select_unspecified>
      <remove>
        <name>result</name>
      </remove>
      <remove>
        <name>Prime</name>
      </remove>
    </fields>
    <attributes/>
    <GUI>
      <xloc>640</xloc>
      <yloc>288</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Select values 3</name>
    <type>SelectValues</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <select_unspecified>N</select_unspecified>
      <remove>
        <name>Prime</name>
      </remove>
      <remove>
        <name>result</name>
      </remove>
      <meta>
        <name>plannedDischarge</name>
        <rename>plannedDischarge</rename>
        <type>Date</type>
        <length>-2</length>
        <precision>-2</precision>
        <conversion_mask>yyyy-MM-dd</conversion_mask>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
    </fields>
    <attributes/>
    <GUI>
      <xloc>640</xloc>
      <yloc>400</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Table output</name>
    <type>TableOutput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <commit>1000</commit>
    <connection>NorthsightBI</connection>
    <fields>
      <field>
        <column_name>admissiondate</column_name>
        <stream_name>admissionDate</stream_name>
      </field>
      <field>
        <column_name>patient_id</column_name>
        <stream_name>patient_id</stream_name>
      </field>
      <field>
        <column_name>allergies</column_name>
        <stream_name>allergies</stream_name>
      </field>
      <field>
        <column_name>bedid</column_name>
        <stream_name>bedId</stream_name>
      </field>
      <field>
        <column_name>bed_name</column_name>
        <stream_name>bed_name</stream_name>
      </field>
      <field>
        <column_name>bed_statuses</column_name>
        <stream_name>bed_statuses</stream_name>
      </field>
      <field>
        <column_name>building_id</column_name>
        <stream_name>building_id</stream_name>
      </field>
      <field>
        <column_name>checkin</column_name>
        <stream_name>checkin</stream_name>
      </field>
      <field>
        <column_name>checkin_id</column_name>
        <stream_name>checkin_id</stream_name>
      </field>
      <field>
        <column_name>checkout</column_name>
        <stream_name>checkout</stream_name>
      </field>
      <field>
        <column_name>fullname</column_name>
        <stream_name>fullName</stream_name>
      </field>
      <field>
        <column_name>insurance</column_name>
        <stream_name>insurance</stream_name>
      </field>
      <field>
        <column_name>labels</column_name>
        <stream_name>labels</stream_name>
      </field>
      <field>
        <column_name>level_of_care</column_name>
        <stream_name>level_of_care</stream_name>
      </field>
      <field>
        <column_name>mri</column_name>
        <stream_name>mri</stream_name>
      </field>
      <field>
        <column_name>patientgender</column_name>
        <stream_name>patientGender</stream_name>
      </field>
      <field>
        <column_name>planneddischarge</column_name>
        <stream_name>plannedDischarge</stream_name>
      </field>
      <field>
        <column_name>precautions</column_name>
        <stream_name>precautions</stream_name>
      </field>
      <field>
        <column_name>referaldestination</column_name>
        <stream_name>referalDestination</stream_name>
      </field>
      <field>
        <column_name>referalsource</column_name>
        <stream_name>referalSource</stream_name>
      </field>
      <field>
        <column_name>reserved_by</column_name>
        <stream_name>reserved_by</stream_name>
      </field>
      <field>
        <column_name>reserved_for_account_id</column_name>
        <stream_name>reserved_for_account_id</stream_name>
      </field>
      <field>
        <column_name>reserved_for_name</column_name>
        <stream_name>reserved_for_name</stream_name>
      </field>
      <field>
        <column_name>reserved_until</column_name>
        <stream_name>reserved_until</stream_name>
      </field>
      <field>
        <column_name>room_id</column_name>
        <stream_name>room_id</stream_name>
      </field>
      <field>
        <column_name>room_name</column_name>
        <stream_name>room_name</stream_name>
      </field>
      <field>
        <column_name>room_gender</column_name>
        <stream_name>room_gender</stream_name>
      </field>
      <field>
        <column_name>building_name</column_name>
        <stream_name>building_name</stream_name>
      </field>
    </fields>
    <ignore_errors>N</ignore_errors>
    <only_when_have_rows>N</only_when_have_rows>
    <partitioning_daily>N</partitioning_daily>
    <partitioning_enabled>N</partitioning_enabled>
    <partitioning_monthly>Y</partitioning_monthly>
    <return_keys>N</return_keys>
    <schema>"public"</schema>
    <specify_fields>Y</specify_fields>
    <table>fct_building_occupency</table>
    <tablename_in_field>N</tablename_in_field>
    <tablename_in_table>Y</tablename_in_table>
    <truncate>Y</truncate>
    <use_batch>Y</use_batch>
    <attributes/>
    <GUI>
      <xloc>1264</xloc>
      <yloc>336</yloc>
    </GUI>
  </transform>
  <transform>
    <name>fct_building_occupency</name>
    <type>DimensionLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <cache_size>-1</cache_size>
    <commit>100</commit>
    <connection>NorthsightBI</connection>
    <fields>
      <date>
        <from>date_from</from>
        <to>date_to</to>
      </date>
      <field>
        <lookup>allergies</lookup>
        <name>allergies</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>bedId</lookup>
        <name>bedId</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>bed_name</lookup>
        <name>bed_name</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>bed_statuses</lookup>
        <name>bed_statuses</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>building_id</lookup>
        <name>building_id</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>checkin</lookup>
        <name>checkin</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>checkin_id</lookup>
        <name>checkin_id</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>checkout</lookup>
        <name>checkout</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>fullName</lookup>
        <name>fullName</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>insurance</lookup>
        <name>insurance</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>labels</lookup>
        <name>labels</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>level_of_care</lookup>
        <name>level_of_care</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>mri</lookup>
        <name>mri</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>patientGender</lookup>
        <name>patientGender</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>plannedDischarge</lookup>
        <name>plannedDischarge</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>precautions</lookup>
        <name>precautions</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>referalDestination</lookup>
        <name>referalDestination</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>referalSource</lookup>
        <name>referalSource</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>reserved_by</lookup>
        <name>reserved_by</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>reserved_for_account_id</lookup>
        <name>reserved_for_account_id</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>reserved_for_name</lookup>
        <name>reserved_for_name</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>reserved_until</lookup>
        <name>reserved_until</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>room_id</lookup>
        <name>room_id</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>room_name</lookup>
        <name>room_name</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>room_gender</lookup>
        <name>room_gender</name>
        <update>Punch through</update>
      </field>
      <field>
        <lookup>building_name</lookup>
        <name>building_name</name>
        <update>Punch through</update>
      </field>
      <key>
        <lookup>admissionDate</lookup>
        <name>admissionDate</name>
      </key>
      <key>
        <lookup>patient_id</lookup>
        <name>patient_id</name>
      </key>
      <return>
        <creation_method>tablemax</creation_method>
        <name>occupency_key</name>
        <version>version</version>
      </return>
    </fields>
    <max_year>2199</max_year>
    <min_year>1900</min_year>
    <preload_cache>N</preload_cache>
    <schema>public</schema>
    <table>fct_building_occupency</table>
    <update>Y</update>
    <useBatch>N</useBatch>
    <use_start_date_alternative>N</use_start_date_alternative>
    <attributes/>
    <GUI>
      <xloc>1312</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>String operations</name>
    <type>StringOperations</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <in_stream_name>building_name</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>no</init_cap>
        <mask_xml>none</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
    </fields>
    <attributes/>
    <GUI>
      <xloc>1200</xloc>
      <yloc>256</yloc>
    </GUI>
  </transform>
  <transform_error_handling>
  </transform_error_handling>
  <attributes/>
</pipeline>