build_admission_fact3.hpl

<?xml version="1.0" encoding="UTF-8"?>
<pipeline>
  <info>
    <name>build_admission_fact3</name>
    <name_sync_with_filename>Y</name_sync_with_filename>
    <description/>
    <extended_description/>
    <pipeline_version/>
    <pipeline_type>Normal</pipeline_type>
    <pipeline_status>0</pipeline_status>
    <parameters>
    </parameters>
    <capture_transform_performance>Y</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/22 16:42:57.863</created_date>
    <modified_user>-</modified_user>
    <modified_date>2023/08/22 16:42:57.863</modified_date>
  </info>
  <notepads>
  </notepads>
  <order>
    <hop>
      <from>De-serialize from file</from>
      <to>dim_language</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>dim_language</from>
      <to>dim_marital_status</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>dim_patient</from>
      <to>Select values</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>dim_marital_status</from>
      <to>Select values 2</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values 2</from>
      <to>dim_patient</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values</from>
      <to>dim_counselor</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>dim_counselor</from>
      <to>Primary Drug</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Primary Drug</from>
      <to>Secondary Drug</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Referral Source</from>
      <to>Serialize to file</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Secondary Drug</from>
      <to>Tertiary Drug</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Tertiary Drug</from>
      <to>Referral Source</to>
      <enabled>Y</enabled>
    </hop>
  </order>
  <transform>
    <name>De-serialize from file</name>
    <type>CubeInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <addfilenameresult>N</addfilenameresult>
    <file>
      <name>AdmissionsFact2.cube</name>
    </file>
    <limit>0</limit>
    <attributes/>
    <GUI>
      <xloc>96</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Primary Drug</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>
      <key>
        <lookup>drug_name</lookup>
        <name>Primary Drug Of Use </name>
      </key>
      <key>
        <lookup>source_system</lookup>
        <name>source_system</name>
      </key>
      <return>
        <creation_method>tablemax</creation_method>
        <name>drug_key</name>
        <rename>primary_drug_of_use_key</rename>
        <version>version</version>
      </return>
    </fields>
    <max_year>2199</max_year>
    <min_year>1900</min_year>
    <preload_cache>N</preload_cache>
    <schema>"public"</schema>
    <table>dim_drug</table>
    <update>N</update>
    <useBatch>N</useBatch>
    <use_start_date_alternative>N</use_start_date_alternative>
    <attributes/>
    <GUI>
      <xloc>880</xloc>
      <yloc>272</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Referral Source</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>
      <key>
        <lookup>referral_source</lookup>
        <name>Referal Source</name>
      </key>
      <key>
        <lookup>source_system</lookup>
        <name>source_system</name>
      </key>
      <key>
        <lookup>referral_source_id</lookup>
        <name>Referral Source Id</name>
      </key>
      <return>
        <creation_method>tablemax</creation_method>
        <name>referral_source_key</name>
        <rename>referral_source_key</rename>
        <version>version</version>
      </return>
    </fields>
    <max_year>2199</max_year>
    <min_year>1900</min_year>
    <preload_cache>N</preload_cache>
    <schema>"public"</schema>
    <table>dim_referral_source</table>
    <update>N</update>
    <useBatch>N</useBatch>
    <use_start_date_alternative>N</use_start_date_alternative>
    <attributes/>
    <GUI>
      <xloc>480</xloc>
      <yloc>272</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Secondary Drug</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>
      <key>
        <lookup>drug_name</lookup>
        <name>Secondary Drug Of Use </name>
      </key>
      <key>
        <lookup>source_system</lookup>
        <name>source_system</name>
      </key>
      <return>
        <creation_method>tablemax</creation_method>
        <name>drug_key</name>
        <rename>secondary_drug_of_use_key</rename>
        <version>version</version>
      </return>
    </fields>
    <max_year>2199</max_year>
    <min_year>1900</min_year>
    <preload_cache>N</preload_cache>
    <schema>"public"</schema>
    <table>dim_drug</table>
    <update>N</update>
    <useBatch>N</useBatch>
    <use_start_date_alternative>N</use_start_date_alternative>
    <attributes/>
    <GUI>
      <xloc>752</xloc>
      <yloc>272</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Tertiary Drug</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>
        <name/>
        <to>date_to</to>
      </date>
      <key>
        <lookup>drug_name</lookup>
        <name>Tertiary Drug Of Use </name>
      </key>
      <key>
        <lookup>source_system</lookup>
        <name>source_system</name>
      </key>
      <return>
        <creation_method>tablemax</creation_method>
        <name>drug_key</name>
        <rename>tertiary_drug_of_use_key</rename>
        <version>version</version>
      </return>
    </fields>
    <max_year>2199</max_year>
    <min_year>1900</min_year>
    <preload_cache>N</preload_cache>
    <schema>"public"</schema>
    <sequence/>
    <start_date_field_name/>
    <table>dim_drug</table>
    <update>N</update>
    <useBatch>N</useBatch>
    <use_start_date_alternative>N</use_start_date_alternative>
    <attributes/>
    <GUI>
      <xloc>624</xloc>
      <yloc>272</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Select values</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>
      <meta>
        <name>Admission Date</name>
        <rename>Admission Date</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>
      <meta>
        <name>Discharge Date</name>
        <rename>Discharge Date</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>
      <meta>
        <name>Length Of Stay</name>
        <rename>Length Of Stay</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>
      <meta>
        <name>age</name>
        <rename>age</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>752</xloc>
      <yloc>128</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>
      <meta>
        <name>Patient Date Of Birth</name>
        <rename>Patient Date Of Birth</rename>
        <type>Date</type>
        <length>-2</length>
        <precision>-2</precision>
        <conversion_mask>yyy-DD-MM</conversion_mask>
        <date_format_lenient>true</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>normal</storage_type>
      </meta>
    </fields>
    <attributes/>
    <GUI>
      <xloc>496</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Serialize to file</name>
    <type>CubeOutput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <file>
      <add_to_result_filenames>N</add_to_result_filenames>
      <do_not_open_newfile_init>N</do_not_open_newfile_init>
      <name>AdmissionsFact3.cube</name>
    </file>
    <attributes/>
    <GUI>
      <xloc>288</xloc>
      <yloc>272</yloc>
    </GUI>
  </transform>
  <transform>
    <name>dim_counselor</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>
      <key>
        <lookup>primary_counselor</lookup>
        <name>Primary Counselor</name>
      </key>
      <key>
        <lookup>source_system</lookup>
        <name>source_system</name>
      </key>
      <return>
        <creation_method>tablemax</creation_method>
        <name>counselor_key</name>
        <rename>counselor_key</rename>
        <version>version</version>
      </return>
    </fields>
    <max_year>2199</max_year>
    <min_year>1900</min_year>
    <preload_cache>N</preload_cache>
    <schema>"public"</schema>
    <table>dim_counselor</table>
    <update>N</update>
    <useBatch>N</useBatch>
    <use_start_date_alternative>N</use_start_date_alternative>
    <attributes/>
    <GUI>
      <xloc>880</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>dim_language</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>
      <key>
        <lookup>language</lookup>
        <name>Language </name>
      </key>
      <key>
        <lookup>source_system</lookup>
        <name>source_system</name>
      </key>
      <return>
        <creation_method>tablemax</creation_method>
        <name>language_key</name>
        <rename>language_key</rename>
        <version>version</version>
      </return>
    </fields>
    <max_year>2199</max_year>
    <min_year>1900</min_year>
    <preload_cache>N</preload_cache>
    <schema>"public"</schema>
    <table>dim_language</table>
    <update>N</update>
    <useBatch>N</useBatch>
    <use_start_date_alternative>N</use_start_date_alternative>
    <attributes/>
    <GUI>
      <xloc>272</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>dim_marital_status</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>
      <key>
        <lookup>marital_status</lookup>
        <name>Marital Status</name>
      </key>
      <key>
        <lookup>source_system</lookup>
        <name>source_system</name>
      </key>
      <return>
        <creation_method>tablemax</creation_method>
        <name>marital_status_key</name>
        <rename>marital_status_key</rename>
        <version>version</version>
      </return>
    </fields>
    <max_year>2199</max_year>
    <min_year>1900</min_year>
    <preload_cache>N</preload_cache>
    <schema>"public"</schema>
    <table>dim_marital_status</table>
    <update>N</update>
    <useBatch>N</useBatch>
    <use_start_date_alternative>N</use_start_date_alternative>
    <attributes/>
    <GUI>
      <xloc>400</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>dim_patient</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>
      <key>
        <lookup>patient_id</lookup>
        <name>Patient Id</name>
      </key>
      <key>
        <lookup>patient_last_name</lookup>
        <name>Patient Last Name</name>
      </key>
      <key>
        <lookup>patient_first_name</lookup>
        <name>Patient First Name</name>
      </key>
      <return>
        <creation_method>tablemax</creation_method>
        <name>patient_key</name>
        <rename>patient_key</rename>
        <version>version</version>
      </return>
    </fields>
    <max_year>2199</max_year>
    <min_year>1900</min_year>
    <preload_cache>N</preload_cache>
    <schema>"public"</schema>
    <table>dim_patient</table>
    <update>N</update>
    <useBatch>N</useBatch>
    <use_start_date_alternative>N</use_start_date_alternative>
    <attributes/>
    <GUI>
      <xloc>624</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform_error_handling>
  </transform_error_handling>
  <attributes/>
</pipeline>