build_payment_fact.hpl

<?xml version="1.0" encoding="UTF-8"?>
<pipeline>
  <info>
    <name>build_payment_fact</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>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/22 16:42:57.863</created_date>
    <modified_user>-</modified_user>
    <modified_date>2023/08/22 16:42:57.863</modified_date>
  </info>
  <notepads>
    <notepad>
      <backgroundcolorblue>251</backgroundcolorblue>
      <backgroundcolorgreen>232</backgroundcolorgreen>
      <backgroundcolorred>201</backgroundcolorred>
      <bordercolorblue>90</bordercolorblue>
      <bordercolorgreen>58</bordercolorgreen>
      <bordercolorred>14</bordercolorred>
      <fontbold>N</fontbold>
      <fontcolorblue>90</fontcolorblue>
      <fontcolorgreen>58</fontcolorgreen>
      <fontcolorred>14</fontcolorred>
      <fontitalic>N</fontitalic>
      <fontname>.AppleSystemUIFont</fontname>
      <fontsize>13</fontsize>
      <height>26</height>
      <xloc>51</xloc>
      <yloc>73</yloc>
      <note>Dimensions for payments Fact</note>
      <width>193</width>
    </notepad>
  </notepads>
  <order>
    <hop>
      <from>Adjustment Type</from>
      <to>Stream lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Table input</from>
      <to>Stream lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup</from>
      <to>Stream lookup 2</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Claim Status</from>
      <to>Stream lookup 2</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 2</from>
      <to>Stream lookup 3</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Payment Description</from>
      <to>Stream lookup 3</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 3</from>
      <to>Stream lookup 4</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Adjustment Reason</from>
      <to>Stream lookup 4</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 4</from>
      <to>Stream lookup 5</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Comments</from>
      <to>Stream lookup 5</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 5</from>
      <to>Stream lookup 6</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Payment From</from>
      <to>Stream lookup 6</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 6</from>
      <to>Stream lookup 7</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Payment Type</from>
      <to>Stream lookup 7</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>dim_date</from>
      <to>Select values</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 7</from>
      <to>Deposit Date Lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values</from>
      <to>Deposit Date Lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values</from>
      <to>DOB Lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Deposit Date Lookup</from>
      <to>DOB Lookup</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values</from>
      <to>Payment Date</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>DOB Lookup</from>
      <to>Payment Date</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Payment Date</from>
      <to>Stream lookup 8</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Facility</from>
      <to>Stream lookup 8</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values 2</from>
      <to>Table output</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 8</from>
      <to>Stream lookup 9</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Level Of Care</from>
      <to>Stream lookup 9</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Procedure Code</from>
      <to>Stream lookup 10</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 9</from>
      <to>Stream lookup 10</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 10</from>
      <to>Stream lookup 11</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Referral Source</from>
      <to>Stream lookup 11</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Patient</from>
      <to>Select values 3</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 11</from>
      <to>Stream lookup 12</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values 3</from>
      <to>Stream lookup 12</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Insurance</from>
      <to>Stream lookup 13</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 12</from>
      <to>Stream lookup 13</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Stream lookup 13</from>
      <to>Select values 2</to>
      <enabled>Y</enabled>
    </hop>
  </order>
  <transform>
    <name>Adjustment Reason</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  adjusted_reason_key
, adjusted_reason
, source_system

FROM "public".dim_adjusted_reason
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>960</xloc>
      <yloc>224</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Adjustment Type</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  adjustment_type_key
, adjustment_type
, source_system
FROM "public".dim_adjustment_type
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>304</xloc>
      <yloc>208</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Claim Status</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  claim_status_key
, claim_status
, source_system
FROM "public".dim_claim_status
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>512</xloc>
      <yloc>208</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Comments</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  comments_key
, comments
, source_system
FROM "public".dim_comments
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>1168</xloc>
      <yloc>224</yloc>
    </GUI>
  </transform>
  <transform>
    <name>DOB 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>line_patient_date_of_birth</name>
        <field>date_key</field>
      </key>
      <value>
        <name>date_key</name>
        <rename>patient_dob_key</rename>
        <default>0</default>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>1808</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Deposit Date 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>deposit_date</name>
        <field>date_dt</field>
      </key>
      <value>
        <name>date_key</name>
        <rename>deposit_date_key</rename>
        <default>0</default>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>1664</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Facility</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  service_facility_key
, service_facility
, source_system
FROM "public".dim_service_facility
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>2080</xloc>
      <yloc>224</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Insurance</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  insurance_name_key
, insurance_name
, source_system
FROM "public".dim_insurance_name
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>2752</xloc>
      <yloc>240</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Level Of Care</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  loc_key
, level_of_care
, source_system
FROM "public".dim_level_of_care
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>2192</xloc>
      <yloc>224</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Patient</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  patient_key
, patient_id
, patient_dob
, "Patient Name"
FROM "public".dim_patient
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>2592</xloc>
      <yloc>224</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Payment Date</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>payment_date</name>
        <field>date_dt</field>
      </key>
      <value>
        <name>date_key</name>
        <rename>payment_date_key</rename>
        <default>0</default>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>1936</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Payment Description</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  payment_description_key
, description
, source_system
FROM "public".dim_payment_description
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>736</xloc>
      <yloc>208</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Payment From</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  payment_from_key
, payment_from
, source_system
FROM "public".dim_payment_from
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>1344</xloc>
      <yloc>224</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Payment Type</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  payment_type_key
, payment_type
, source_system
FROM "public".dim_payment_type
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>1504</xloc>
      <yloc>224</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Procedure Code</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  procedure_code_key
, procedure_code
, source_system
FROM "public".dim_procedure_code
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>2304</xloc>
      <yloc>224</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Referral Source</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  referral_source_key
, referral_source_id
, referral_source
, source_system
FROM "public".dim_referral_source
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>2432</xloc>
      <yloc>224</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>
      <meta>
        <name>date_dt</name>
        <rename>date_dt</rename>
        <type>String</type>
        <length>-2</length>
        <precision>-2</precision>
        <conversion_mask>yyyy-MM-dd</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/>
      </meta>
    </fields>
    <attributes/>
    <GUI>
      <xloc>1792</xloc>
      <yloc>240</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>
      <field>
        <name>source_system</name>
      </field>
      <field>
        <name>check_number</name>
      </field>
      <field>
        <name>claim_id</name>
      </field>
      <field>
        <name>adjustment_type_key</name>
      </field>
      <field>
        <name>claim_status_key</name>
      </field>
      <field>
        <name>payment_description_key</name>
      </field>
      <field>
        <name>adjusted_reason_key</name>
      </field>
      <field>
        <name>comments_key</name>
      </field>
      <field>
        <name>payment_from_key</name>
      </field>
      <field>
        <name>payment_type_key</name>
      </field>
      <field>
        <name>deposit_date_key</name>
      </field>
      <field>
        <name>patient_dob_key</name>
      </field>
      <field>
        <name>payment_date_key</name>
      </field>
      <field>
        <name>service_facility_key</name>
      </field>
      <field>
        <name>procedure_code_key</name>
      </field>
      <field>
        <name>patient_key</name>
      </field>
      <field>
        <name>loc_key</name>
      </field>
      <field>
        <name>payer_key</name>
      </field>
      <field>
        <name>referral_source_key</name>
      </field>
      <field>
        <name>debit_type</name>
      </field>
      <field>
        <name>editable</name>
      </field>
      <field>
        <name>expected_payment</name>
      </field>
      <field>
        <name>insurance_provider_id</name>
      </field>
      <field>
        <name>interest</name>
      </field>
      <field>
        <name>line_adjusted</name>
      </field>
      <field>
        <name>line_adjusted_reason</name>
      </field>
      <field>
        <name>line_allocated_amount</name>
      </field>
      <field>
        <name>line_allowed</name>
      </field>
      <field>
        <name>line_charge_amount</name>
      </field>
      <field>
        <name>line_claim_id</name>
      </field>
      <field>
        <name>line_coinsurance</name>
      </field>
      <field>
        <name>line_copay</name>
      </field>
      <field>
        <name>line_deductible</name>
      </field>
      <field>
        <name>line_denied_comments</name>
      </field>
      <field>
        <name>line_denied_reason</name>
      </field>
      <field>
        <name>line_eob_type</name>
      </field>
      <field>
        <name>line_paid_amount</name>
      </field>
      <field>
        <name>line_patient_date_of_birth</name>
      </field>
      <field>
        <name>line_patient_name</name>
      </field>
      <field>
        <name>other_reference_number</name>
      </field>
      <field>
        <name>paid_to_patient_amount</name>
      </field>
      <field>
        <name>patient_payment_mri</name>
      </field>
      <field>
        <name>payment_id</name>
      </field>
      <field>
        <name>payment_line_created_on</name>
      </field>
      <field>
        <name>payment_line_id</name>
      </field>
      <field>
        <name>payment_plan_id</name>
      </field>
      <field>
        <name>payment_plan_opportunity_id</name>
      </field>
      <field>
        <name>payment_plan_patient_date_of_birth</name>
      </field>
      <field>
        <name>payment_plan_patient_name</name>
      </field>
      <field>
        <name>payment_plan_type</name>
      </field>
      <field>
        <name>payment_received_by</name>
      </field>
      <field>
        <name>processed_by</name>
      </field>
      <field>
        <name>processed_on</name>
      </field>
      <field>
        <name>remit_total_allocated_amount</name>
      </field>
      <field>
        <name>remit_total_paid_amount</name>
      </field>
      <field>
        <name>service_date</name>
      </field>
      <field>
        <name>variance</name>
      </field>
      <select_unspecified>N</select_unspecified>
      <meta>
        <name>service_date</name>
        <rename>service_date_key</rename>
        <type>String</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>payment_line_created_on</name>
        <rename>payment_line_created_on</rename>
        <type>Timestamp</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>variance</name>
        <rename>variance</rename>
        <type>Number</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>expected_payment</name>
        <rename>expected_payment</rename>
        <type>Number</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>interest</name>
        <rename>interest</rename>
        <type>Number</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>line_adjusted</name>
        <rename>line_adjusted</rename>
        <type>Number</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>line_allocated_amount</name>
        <rename>line_allocated_amount</rename>
        <type>Number</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>line_allowed</name>
        <rename>line_allowed</rename>
        <type>Number</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>line_charge_amount</name>
        <rename>line_charge_amount</rename>
        <type>Number</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>line_coinsurance</name>
        <rename>line_coinsurance</rename>
        <type>Number</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>line_copay</name>
        <rename>line_copay</rename>
        <type>Number</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>line_deductible</name>
        <rename>line_deductible</rename>
        <type>Number</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>line_paid_amount</name>
        <rename>line_paid_amount</rename>
        <type>Number</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>remit_total_allocated_amount</name>
        <rename>remit_total_allocated_amount</rename>
        <type>Number</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>remit_total_paid_amount</name>
        <rename>remit_total_paid_amount</rename>
        <type>Number</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>paid_to_patient_amount</name>
        <rename>paid_to_patient_amount</rename>
        <type>Number</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>2512</xloc>
      <yloc>576</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>
      <meta>
        <name>patient_dob</name>
        <rename>patient_dob</rename>
        <type>String</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>2592</xloc>
      <yloc>304</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Adjustment Type</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>adjustment_type</name>
        <field>adjustment_type</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>adjustment_type_key</name>
        <rename>adjustment_type_key</rename>
        <default>0</default>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>304</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 10</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>N</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Procedure Code</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>procedure_code</name>
        <field>procedure_code</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>procedure_code_key</name>
        <rename>procedure_code_key</rename>
        <default/>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>2304</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 11</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>N</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Referral Source</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>referral_source</name>
        <field>referral_source</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>referral_source_key</name>
        <rename>referral_source_key</rename>
        <default/>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>2432</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 12</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Select values 3</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>line_patient_name</name>
        <field>Patient Name</field>
      </key>
      <value>
        <name>patient_key</name>
        <rename>patient_key</rename>
        <default/>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>2592</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 13</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Insurance</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>payer_name</name>
        <field>insurance_name</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>insurance_name_key</name>
        <rename>payer_key</rename>
        <default>0</default>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>2752</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 2</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Claim Status</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>claim_status</name>
        <field>claim_status</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>claim_status_key</name>
        <rename>claim_status_key</rename>
        <default>0</default>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>512</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 3</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Payment Description</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>description</name>
        <field>description</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>payment_description_key</name>
        <rename>payment_description_key</rename>
        <default>0</default>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>736</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 4</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Adjustment Reason</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>line_adjusted_reason</name>
        <field>adjusted_reason</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>adjusted_reason_key</name>
        <rename>adjusted_reason_key</rename>
        <default>0</default>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>960</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 5</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Comments</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>line_denied_comments</name>
        <field>comments</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>comments_key</name>
        <rename>comments_key</rename>
        <default>0</default>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>1168</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 6</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Payment From</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>payment_from</name>
        <field>payment_from</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>payment_from_key</name>
        <rename>payment_from_key</rename>
        <default>0</default>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>1344</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 7</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Payment Type</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>payment_type</name>
        <field>payment_type</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>payment_type_key</name>
        <rename>payment_type_key</rename>
        <default>0</default>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>1504</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 8</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Facility</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>service_facility</name>
        <field>service_facility</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>service_facility_key</name>
        <rename>service_facility_key</rename>
        <default>0</default>
        <type>Integer</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>2080</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Stream lookup 9</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>N</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Level Of Care</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>level_of_care</name>
        <field>level_of_care</field>
      </key>
      <key>
        <name>source_system</name>
        <field>source_system</field>
      </key>
      <value>
        <name>loc_key</name>
        <rename>loc_key</rename>
        <default/>
        <type>Integer</type>
      </value>
      <value>
        <name>level_of_care</name>
        <rename>level_of_care</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>source_system</name>
        <rename>source_system</rename>
        <default/>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <GUI>
      <xloc>2192</xloc>
      <yloc>368</yloc>
    </GUI>
  </transform>
  <transform>
    <name>Table input</name>
    <type>TableInput</type>
    <description/>
    <distribute>N</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
'Sunwave' as source_system,
  adjustment_type
, billing_facility
, check_number
, claim_id
, claim_status
, clearing_house_file_id
, debit_type
, deposit_date
, description
, editable
, expected_payment
, insurance_provider_id
, interest
, level_of_care
, line_adjusted
, line_adjusted_reason
, line_allocated_amount
, line_allowed
, line_charge_amount
, line_claim_id
, line_coinsurance
, line_copay
, line_deductible
, line_denied_comments
, line_denied_reason
, line_eob_type
, line_paid_amount
, line_patient_date_of_birth
, line_patient_name
, other_reference_number
, paid_to_patient_amount
, patient_payment_mri
, payer_name
, payment_category
, payment_date
, payment_from
, payment_id
, payment_line_created_on
, payment_line_id
, payment_plan_id
, payment_plan_opportunity_id
, payment_plan_patient_date_of_birth
, payment_plan_patient_name
, payment_plan_type
, payment_received_by
, payment_type
, procedure_code
, processed_by
, processed_on
, referral_source
, referral_source_account_owner
, remit_total_allocated_amount
, remit_total_paid_amount
, service_date
, service_facility
, variance
FROM "public".stage_sunwave_payments
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>112</xloc>
      <yloc>368</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>variance</column_name>
        <stream_name>variance</stream_name>
      </field>
      <field>
        <column_name>source_system</column_name>
        <stream_name>source_system</stream_name>
      </field>
      <field>
        <column_name>service_facility_key</column_name>
        <stream_name>service_facility_key</stream_name>
      </field>
      <field>
        <column_name>service_date_key</column_name>
        <stream_name>service_date_key</stream_name>
      </field>
      <field>
        <column_name>remit_total_paid_amount</column_name>
        <stream_name>remit_total_paid_amount</stream_name>
      </field>
      <field>
        <column_name>remit_total_allocated_amount</column_name>
        <stream_name>remit_total_allocated_amount</stream_name>
      </field>
      <field>
        <column_name>referral_source_key</column_name>
        <stream_name>referral_source_key</stream_name>
      </field>
      <field>
        <column_name>processed_on</column_name>
        <stream_name>processed_on</stream_name>
      </field>
      <field>
        <column_name>processed_by</column_name>
        <stream_name>processed_by</stream_name>
      </field>
      <field>
        <column_name>procedure_code_key</column_name>
        <stream_name>procedure_code_key</stream_name>
      </field>
      <field>
        <column_name>payment_type_key</column_name>
        <stream_name>payment_type_key</stream_name>
      </field>
      <field>
        <column_name>payment_received_by</column_name>
        <stream_name>payment_received_by</stream_name>
      </field>
      <field>
        <column_name>payment_plan_type</column_name>
        <stream_name>payment_plan_type</stream_name>
      </field>
      <field>
        <column_name>payment_plan_patient_name</column_name>
        <stream_name>payment_plan_patient_name</stream_name>
      </field>
      <field>
        <column_name>payment_plan_opportunity_id</column_name>
        <stream_name>payment_plan_opportunity_id</stream_name>
      </field>
      <field>
        <column_name>payment_plan_id</column_name>
        <stream_name>payment_plan_id</stream_name>
      </field>
      <field>
        <column_name>payment_line_id</column_name>
        <stream_name>payment_line_id</stream_name>
      </field>
      <field>
        <column_name>payment_line_created_on</column_name>
        <stream_name>payment_line_created_on</stream_name>
      </field>
      <field>
        <column_name>payment_id</column_name>
        <stream_name>payment_id</stream_name>
      </field>
      <field>
        <column_name>payment_from_key</column_name>
        <stream_name>payment_from_key</stream_name>
      </field>
      <field>
        <column_name>payment_description_key</column_name>
        <stream_name>payment_description_key</stream_name>
      </field>
      <field>
        <column_name>payment_date_key</column_name>
        <stream_name>payment_date_key</stream_name>
      </field>
      <field>
        <column_name>payer_key</column_name>
        <stream_name>payer_key</stream_name>
      </field>
      <field>
        <column_name>patient_payment_mri</column_name>
        <stream_name>patient_payment_mri</stream_name>
      </field>
      <field>
        <column_name>patient_key</column_name>
        <stream_name>patient_key</stream_name>
      </field>
      <field>
        <column_name>patient_dob_key</column_name>
        <stream_name>patient_dob_key</stream_name>
      </field>
      <field>
        <column_name>paid_to_patient_amount</column_name>
        <stream_name>paid_to_patient_amount</stream_name>
      </field>
      <field>
        <column_name>other_reference_number</column_name>
        <stream_name>other_reference_number</stream_name>
      </field>
      <field>
        <column_name>loc_key</column_name>
        <stream_name>loc_key</stream_name>
      </field>
      <field>
        <column_name>line_paid_amount</column_name>
        <stream_name>line_paid_amount</stream_name>
      </field>
      <field>
        <column_name>line_eob_type</column_name>
        <stream_name>line_eob_type</stream_name>
      </field>
      <field>
        <column_name>line_denied_reason</column_name>
        <stream_name>line_denied_reason</stream_name>
      </field>
      <field>
        <column_name>line_deductible</column_name>
        <stream_name>line_deductible</stream_name>
      </field>
      <field>
        <column_name>line_copay</column_name>
        <stream_name>line_copay</stream_name>
      </field>
      <field>
        <column_name>line_coinsurance</column_name>
        <stream_name>line_coinsurance</stream_name>
      </field>
      <field>
        <column_name>line_claim_id</column_name>
        <stream_name>line_claim_id</stream_name>
      </field>
      <field>
        <column_name>line_charge_amount</column_name>
        <stream_name>line_charge_amount</stream_name>
      </field>
      <field>
        <column_name>line_allowed</column_name>
        <stream_name>line_allowed</stream_name>
      </field>
      <field>
        <column_name>line_allocated_amount</column_name>
        <stream_name>line_allocated_amount</stream_name>
      </field>
      <field>
        <column_name>line_adjusted_reason</column_name>
        <stream_name>line_adjusted_reason</stream_name>
      </field>
      <field>
        <column_name>line_adjusted</column_name>
        <stream_name>line_adjusted</stream_name>
      </field>
      <field>
        <column_name>interest</column_name>
        <stream_name>interest</stream_name>
      </field>
      <field>
        <column_name>insurance_provider_id</column_name>
        <stream_name>insurance_provider_id</stream_name>
      </field>
      <field>
        <column_name>expected_payment</column_name>
        <stream_name>expected_payment</stream_name>
      </field>
      <field>
        <column_name>editable</column_name>
        <stream_name>editable</stream_name>
      </field>
      <field>
        <column_name>deposit_date_key</column_name>
        <stream_name>deposit_date_key</stream_name>
      </field>
      <field>
        <column_name>debit_type</column_name>
        <stream_name>debit_type</stream_name>
      </field>
      <field>
        <column_name>comments_key</column_name>
        <stream_name>comments_key</stream_name>
      </field>
      <field>
        <column_name>claim_status_key</column_name>
        <stream_name>claim_status_key</stream_name>
      </field>
      <field>
        <column_name>claim_id</column_name>
        <stream_name>claim_id</stream_name>
      </field>
      <field>
        <column_name>check_number</column_name>
        <stream_name>check_number</stream_name>
      </field>
      <field>
        <column_name>adjustment_type_key</column_name>
        <stream_name>adjustment_type_key</stream_name>
      </field>
      <field>
        <column_name>adjusted_reason_key</column_name>
        <stream_name>adjusted_reason_key</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_field/>
    <partitioning_monthly>Y</partitioning_monthly>
    <return_field/>
    <return_keys>N</return_keys>
    <schema>public</schema>
    <specify_fields>Y</specify_fields>
    <table>fct_payments</table>
    <tablename_field/>
    <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>2224</xloc>
      <yloc>656</yloc>
    </GUI>
  </transform>
  <transform>
    <name>dim_date</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>NorthsightBI</connection>
    <execute_each_row>N</execute_each_row>
    <limit>0</limit>
    <sql>SELECT
  date_key
, date_dt
FROM "public".dim_date
</sql>
    <variables_active>N</variables_active>
    <attributes/>
    <GUI>
      <xloc>1776</xloc>
      <yloc>144</yloc>
    </GUI>
  </transform>
  <transform_error_handling>
  </transform_error_handling>
  <attributes/>
</pipeline>