$VAR1 = {
          'defaults' => {
                          'LOSS_DESCRIPTION' => '',
                          'ENDORSEMENT_2' => '',
                          'COVERAGE_F' => '0',
                          'ENDORSEMENT_10' => '',
                          'CLIENT_PHONE_3' => '',
                          'XACTID' => '',
                          'PROPERTY_POSTAL_CODE' => '',
                          'ENDORSEMENT_19' => '',
                          'FIRST_NAMED_INSURED' => '',
                          'MAILING_POSTAL_CODE' => '',
                          'COVERAGE_B' => '0',
                          'MAILING_STREET' => '',
                          'HURRICANE_DEDUCTIBLE' => '',
                          'SEVERITY_CODE' => '',
                          'MAILING_CITY' => '',
                          'ENDORSEMENT_9' => '',
                          'ENDORSEMENT_14' => '',
                          'ENDORSEMENT_11' => '',
                          'TYPE_CODE' => '',
                          'ENDORSEMENT_7' => '',
                          'ENDORSEMENT_16' => '',
                          'ENDORSEMENT_20' => '',
                          'ENDORSEMENT_4' => '',
                          'CLAIM_NUMBER' => '',
                          'ENDORSEMENT_23' => '',
                          'POLICY_SYMBOL' => '',
                          'CLIENT_PHONE' => '',
                          'CAT_FIRM' => '',
                          'POLICY_EFFECTIVE_DATE' => '0001-01-01',
                          'COVERAGE_E' => '0',
                          'ENDORSEMENT_18' => '',
                          'CLIENT_PHONE_2' => '',
                          'ENDORSEMENT_8' => '',
                          'ENDORSEMENT_1' => '',
                          'ENDORSEMENT_3' => '',
                          'ENDORSEMENT_12' => '',
                          'ENDORSEMENT_17' => '',
                          'ENDORSEMENT_15' => '',
                          'CLIENT_PHONE_1' => '',
                          'SAFETY_DESK_ADJUSTER' => '',
                          'COVERAGE_C' => '0',
                          'ENDORSEMENT_5' => '',
                          'CAT_CODE' => '',
                          'CLAIMANT_NAME' => '',
                          'MAILING_STATE' => '',
                          'ENDORSEMENT_22' => '',
                          'LOSS_DATE' => '0001-01-01',
                          'REPORTED_DATE' => '0001-01-01',
                          'COVERAGE_D' => '0',
                          'ENDORSEMENT_6' => '',
                          'ALL_PERIL_DEDUCTIBLE' => '0',
                          'COVERAGE_A' => '0',
                          'ENDORSEMENT_13' => '',
                          'POLICY_NUMBER' => '',
                          'ENDORSEMENT_21' => ''
                        },
          'tab_xl_num' => {
                            'LOSS_DESCRIPTION' => '19',
                            'POLICY_SYMBOL' => '1',
                            'CLIENT_PHONE' => '12',
                            'CAT_FIRM' => '9',
                            'POLICY_EFFECTIVE_DATE' => '3',
                            'FIRST_NAMED_INSURED' => '14',
                            'MAILING_POSTAL_CODE' => '16',
                            'SAFETY_DESK_ADJUSTER' => '8',
                            'MAILING_STREET' => '13',
                            'SEVERITY_CODE' => '4',
                            'CLAIMANT_NAME' => '11',
                            'MAILING_CITY' => '14',
                            'MAILING_STATE' => '15',
                            'LOSS_DATE' => '18',
                            'REPORTED_DATE' => '17',
                            'TYPE_CODE' => '5',
                            'POLICY_NUMBER' => '2',
                            'CLAIM_NUMBER' => '0'
                          },
          'pif_sql' => {
                         '37' => 'SELECT
	entry_01 as ENDORSEMENT_1,
	entry_02 as ENDORSEMENT_2,
	entry_03 as ENDORSEMENT_3,
	entry_04 as ENDORSEMENT_4,
	entry_05 as ENDORSEMENT_5,
	entry_06 as ENDORSEMENT_6,
	entry_07 as ENDORSEMENT_7,
	entry_08 as ENDORSEMENT_8,
	entry_09 as ENDORSEMENT_9,
	entry_10 as ENDORSEMENT_10,
	entry_11 as ENDORSEMENT_11,
	entry_12 as ENDORSEMENT_12,
	entry_13 as ENDORSEMENT_13,
	entry_14 as ENDORSEMENT_14,
	entry_15 as ENDORSEMENT_15,
	entry_16 as ENDORSEMENT_16,
	entry_17 as ENDORSEMENT_17,
	entry_18 as ENDORSEMENT_18,
	entry_19 as ENDORSEMENT_19,
	entry_20 as ENDORSEMENT_20,
	entry_21 as ENDORSEMENT_21,
	entry_22 as ENDORSEMENT_22
FROM "dbo"."pif_37"
WHERE master_id = ?	
',
                         '17' => 'SELECT
	zip_code as PROPERTY_POSTAL_CODE,
	deductible_amount as ALL_PERIL_DEDUCTIBLE,
	wind_hail_exclusion as HURRICANE_DEDUCTIBLE,
	coverage_a_limit as COVERAGE_A,
	coverage_b_limit as COVERAGE_B,
	coverage_c_limit as COVERAGE_C,
	coverage_d_limit as COVERAGE_D,
	coverage_e_limit as COVERAGE_E,
	coverage_f_limit as COVERAGE_F
FROM "dbo"."pif_17"
WHERE master_id = ?	
'
                       },
          'tab_names' => [
                           'CAT_CODE',
                           'CLAIM_NUMBER',
                           'POLICY_SYMBOL',
                           'POLICY_NUMBER',
                           'POLICY_EFFECTIVE_DATE',
                           'SEVERITY_CODE',
                           'TYPE_CODE',
                           'SAFETY_DESK_ADJUSTER',
                           'XACTID',
                           'CAT_FIRM',
                           'CLAIMANT_NAME',
                           'CLIENT_PHONE',
                           'CLIENT_PHONE_1',
                           'CLIENT_PHONE_2',
                           'CLIENT_PHONE_3',
                           'MAILING_STREET',
                           'MAILING_CITY',
                           'MAILING_STATE',
                           'MAILING_POSTAL_CODE',
                           'REPORTED_DATE',
                           'LOSS_DATE',
                           'LOSS_DESCRIPTION',
                           'FIRST_NAMED_INSURED',
                           'PROPERTY_POSTAL_CODE',
                           'ALL_PERIL_DEDUCTIBLE',
                           'HURRICANE_DEDUCTIBLE',
                           'COVERAGE_A',
                           'COVERAGE_B',
                           'COVERAGE_C',
                           'COVERAGE_D',
                           'COVERAGE_E',
                           'COVERAGE_F',
                           'ENDORSEMENT_1',
                           'ENDORSEMENT_2',
                           'ENDORSEMENT_3',
                           'ENDORSEMENT_4',
                           'ENDORSEMENT_5',
                           'ENDORSEMENT_6',
                           'ENDORSEMENT_7',
                           'ENDORSEMENT_8',
                           'ENDORSEMENT_9',
                           'ENDORSEMENT_10',
                           'ENDORSEMENT_11',
                           'ENDORSEMENT_12',
                           'ENDORSEMENT_13',
                           'ENDORSEMENT_14',
                           'ENDORSEMENT_15',
                           'ENDORSEMENT_16',
                           'ENDORSEMENT_17',
                           'ENDORSEMENT_18',
                           'ENDORSEMENT_19',
                           'ENDORSEMENT_20',
                           'ENDORSEMENT_21',
                           'ENDORSEMENT_22',
                           'ENDORSEMENT_23'
                         ]
        };