_:vb51106046 "214" . _:vb51111982 "212" . _:vb51108828 . _:vb51109725 . _:vb51109725 . _:vb51111983 "214" . _:vb51111757 "218" . _:vb51109275 . _:vb51109278 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount \n JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51109277 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51108606 . _:vb51108603 . . _:vb51108605 . _:vb51104458 . _:vb51110621 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51094467 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51109502 . _:vb51108604 . _:vb51111757 . _:vb51094467 . _:vb51111756 . _:vb51094467 "176" . _:vb51106044 _:vb51106045 . _:vb51109053 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51109054 . _:vb51094468 . _:vb51104457 . _:vb51106046 . _:vb51109500 "amount_type_code" . _:vb51094465 _:vb51094466 . _:vb51094466 "174" . _:vb51108322 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51094468 "179" . _:vb51104456 "212" . _:vb51104457 "214" . _:vb51104458 "218" . _:vb51094465 "174" . _:vb51109501 . _:vb51112208 "212" . _:vb51111983 . _:vb51112211 "218" . _:vb51111983 . _:vb51110621 . _:vb51112209 "212" . _:vb51104458 . _:vb51108606 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount \n JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51094468 "SELECT CAST(policy_amount.policy_amount_identifier as VARCHAR) as policy_amount_identifier, \n CAST(policy_amount.policy_amount as INTEGER) as policy_amount, \n CAST(policy_amount.amount_type_code as VARCHAR) as amount_type_code, \n case when policy_amount.amount_type_code = 'Year' then CAST(policy_amount.policy_amount/12 as VARCHAR) end as monthly_policy_amount, CAST(policy_amount.policy_coverage_detail_identifier as VARCHAR) as policy_coverage_detail_identifier\nFROM demo.acme.policy_amount \nJOIN demo.acme.premium on policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . . _:vb51112209 "amount_type_code" . _:vb51104455 . _:vb51110621 . _:vb51112210 "214" . _:vb51108827 . _:vb51106047 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount_attached \n JOIN demo.acme.premium_attached ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51108320 "212" . _:vb51110619 . _:vb51108323 "218" . _:vb51109726 . _:vb51109723 . _:vb51108321 "212" . _:vb51104455 . _:vb51108320 _:vb51108321 . _:vb51108322 "214" . _:vb51112208 . _:vb51109278 . _:vb51109275 . _:vb51106045 "amount_type_code" . _:vb51111984 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount \n JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51108828 "amount_type_code" . _:vb51104457 . _:vb51111984 "218" . _:vb51111757 . _:vb51109726 . _:vb51109499 . _:vb51109725 . _:vb51109499 . _:vb51106044 . _:vb51109724 . _:vb51111756 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51109278 . _:vb51104455 "212" . _:vb51109051 . _:vb51112211 . . _:vb51108830 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount \n JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51109277 . _:vb51111981 . _:vb51109725 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51109502 . _:vb51111756 . _:vb51111984 . _:vb51110622 . _:vb51109276 . _:vb51094468 . _:vb51109501 . _:vb51111754 . _:vb51108322 . _:vb51109500 . _:vb51110619 . _:vb51110622 . _:vb51111756 . _:vb51112210 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51109054 . _:vb51106046 . _:vb51112211 "SELECT \n policy_amount_attached.policy_amount_identifier, \n policy_amount_attached.policy_amount, \n policy_amount_attached.amount_type_code, \n CASE when policy_amount_attached.amount_type_code = 'Year' then policy_amount_attached.policy_amount/12 end as monthly_policy_amount, policy_amount_attached.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount_attached \n JOIN demo.acme.premium_attached ON policy_amount_attached.policy_amount_identifier = premium_attached.policy_amount_identifier" . _:vb51094465 . _:vb51108603 _:vb51108604 . _:vb51111983 . _:vb51109501 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51109053 . _:vb51108604 "amount_type_code" . _:vb51109052 . _:vb51112210 . _:vb51106047 . _:vb51109723 . _:vb51104457 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51094467 . _:vb51111755 "amount_type_code" . _:vb51094466 "amount_type_code" . _:vb51108323 "SELECT \n policy_amount_attached.policy_amount_identifier, \n policy_amount_attached.policy_amount, \n policy_amount_attached.amount_type_code, \n CASE when policy_amount_attached.amount_type_code = 'Year' then policy_amount_attached.policy_amount/12 end as monthly_policy_amount, policy_amount_attached.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount_attached \n JOIN demo.acme.premium_attached ON policy_amount_attached.policy_amount_identifier = premium_attached.policy_amount_identifier" . _:vb51111984 . _:vb51109277 . _:vb51109502 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount \n JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51110621 . _:vb51108321 "amount_type_code" . _:vb51104458 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount_attached \n JOIN demo.acme.premium_attached ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51109501 . _:vb51104455 _:vb51104456 . _:vb51108827 _:vb51108828 . _:vb51108322 . _:vb51108605 . _:vb51108320 . _:vb51108322 . _:vb51104457 . _:vb51109276 "amount_type_code" . _:vb51109723 . _:vb51104456 "amount_type_code" . _:vb51106046 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51112210 . _:vb51109726 . _:vb51110620 "amount_type_code" . _:vb51109499 . _:vb51109499 _:vb51109500 . _:vb51112211 . _:vb51109502 . _:vb51109051 _:vb51109052 . _:vb51108829 . _:vb51109053 . _:vb51110622 . _:vb51109053 . _:vb51109726 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount \n JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51108829 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51108323 . _:vb51094467 . _:vb51110620 . _:vb51108829 . _:vb51108605 . _:vb51111981 . _:vb51110621 . _:vb51108320 . _:vb51109275 . _:vb51111983 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51110619 . _:vb51109725 . _:vb51109278 . _:vb51106046 . _:vb51108605 "http://demo.openlinksw.com/acme-insurance/Premium-{policy_amount_identifier}#this" . _:vb51109051 . _:vb51108606 . _:vb51109054 . _:vb51109052 "amount_type_code" . _:vb51108827 . _:vb51109053 . _:vb51110622 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount \n JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51108830 . _:vb51108603 . _:vb51112208 _:vb51112209 . _:vb51111981 _:vb51111982 . _:vb51108606 . _:vb51109275 _:vb51109276 . _:vb51106044 . _:vb51109051 . _:vb51109277 . _:vb51109054 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount \n JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51108323 . _:vb51106047 . _:vb51108605 . _:vb51109277 . _:vb51108827 . _:vb51110619 _:vb51110620 . _:vb51111754 . _:vb51112210 . _:vb51109723 _:vb51109724 . _:vb51111982 "amount_type_code" . _:vb51109501 . _:vb51108829 . _:vb51111757 "SELECT \n policy_amount.policy_amount_identifier, \n policy_amount.policy_amount, \n policy_amount.amount_type_code, \n CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier\n FROM demo.acme.policy_amount \n JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier" . _:vb51108830 . _:vb51111754 "212" . _:vb51109724 "amount_type_code" . _:vb51106044 "212" . _:vb51094465 . _:vb51106047 "218" . _:vb51112208 . _:vb51111755 "212" . _:vb51108603 . _:vb51106045 "212" . _:vb51108830 . _:vb51111754 _:vb51111755 . _:vb51111981 "212" . _:vb51108829 . _:vb51111756 "214" .