SELECT orders_id FROM fnma_bpo_rpt WHERE orders_id = #form.orders_id# ; INSERT INTO fnma_bpo_rpt( orders_id, bpo_id, bpo_type_cd, bpo_dt, curr_mkt_cond_cd, emp_cond_cd, mkt_price_chng_dir_cd, mkt_price_chng_pct_dec, mkt_price_chng_pct_inc, mkt_price_chng_mon_dec, mkt_price_chng_mon_inc, est_pct_own, est_pct_tenant, supply_cd, comp_forsale_no, comp_list_no, boarded_home_no, gen_mkt_comments, neighbor_low_val, neighbor_high_val, subject_imprv_cd, norm_mkt_days, subj_prop_mrk_cd, subj_unit_type_cd, subj_unit_type_no, mon_condo_fee_val, mon_condo_fee_cur, mon_condo_fee_unp, mon_condo_fee_pool, mon_condo_fee_tennis, mon_condo_fee_ins, mon_condo_fee_land, mon_condo_fee_oth, assoc_cont_nm, assoc_cont_phone, assoc_cont_addr, most_likely_buy_cd, planned_marketing, rec_repair_item_1, rec_repair_cost_1, rec_repair_desc_1, rec_repair_item_2, rec_repair_cost_2, rec_repair_desc_2, rec_repair_item_3, rec_repair_cost_3, rec_repair_desc_3, rec_repair_item_4, rec_repair_cost_4, rec_repair_desc_4, rec_repair_item_5, rec_repair_cost_5, rec_repair_desc_5, sale_asis_price, sale_asrepaired_price, list_asis_price, list_asrepaired_price, inspected_cd, asis_avail_fin_conv, asis_avail_fin_fhava, asis_avail_fin_other, asrep_avail_fin_conv, asrep_avail_fin_fhava, asrep_avail_fin_other, final_val_comments, brok_rec_mkt_cd, comp_by_agent, comp_by_phone, upd_id, upd_dtm) VALUES( #form.orders_id#, #variables.rtn_id#, '#form.bpo_type_cd#', '#DateFormat(variables.createdate,"mm/dd/yyyy")#', '#variables.curr_mkt_cond_cd#', '#variables.emp_cond_cd#', '#variables.mkt_price_chng_dir_cd#', '#form.mkt_price_chng_pct_dec#', '#form.mkt_price_chng_pct_inc#', '#form.mkt_price_chng_mon_dec#', '#form.mkt_price_chng_mon_inc#', '#form.est_pct_own#', '#form.est_pct_tenant#', '#variables.supply_cd#', '#form.comp_forsale_no#', '#form.comp_list_no#', '#form.boarded_home_no#', '#form.gen_mkt_comments#', '#form.neighbor_low_val#', '#form.neighbor_high_val#', '#variables.subject_imprv_cd#', '#form.norm_mkt_days#', '#variables.subj_prop_mrk_cd#', '#variables.subj_unit_type_cd#', '#form.subj_unit_type_no#', '#form.mon_condo_fee_val#', #variables.mon_condo_fee_cur#, '#form.mon_condo_fee_unp#', #variables.mon_condo_fee_pool#, #variables.mon_condo_fee_tennis#, #variables.mon_condo_fee_ins#, #variables.mon_condo_fee_land#, #variables.mon_condo_fee_oth#, '#form.assoc_cont_nm#', '#form.assoc_cont_phone#', '#form.assoc_cont_addr#', '#variables.most_likely_buy_cd#', '#form.planned_marketing#', '#form.rec_repair_item_1#', '#form.rec_repair_cost_1#', '#form.rec_repair_desc_1#', '#form.rec_repair_item_2#', '#form.rec_repair_cost_2#', '#form.rec_repair_desc_2#', '#form.rec_repair_item_3#', '#form.rec_repair_cost_3#', '#form.rec_repair_desc_3#', '#form.rec_repair_item_4#', '#form.rec_repair_cost_4#', '#form.rec_repair_desc_4#', '#form.rec_repair_item_5#', '#form.rec_repair_cost_5#', '#form.rec_repair_desc_5#', '#form.sale_asis_price#', '#form.sale_asrepaired_price#', '#form.list_asis_price#', '#form.list_asrepaired_price#', '#variables.inspected_cd#', #variables.asis_avail_fin_conv#, #variables.asis_avail_fin_fhava#, #variables.asis_avail_fin_other#, #variables.asrep_avail_fin_conv#, #variables.asrep_avail_fin_fhava#, #variables.asrep_avail_fin_other#, '#form.final_val_comments#', '#variables.brok_rec_mkt_cd#', '#form.comp_by_agent#', '#form.comp_by_phone#', '#client.user_id#', #variables.createdate#) ; UPDATE orders SET ord_comp_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' SET fr_report_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' WHERE orders_id = #form.orders_id# ; INSERT INTO fnma_comp_sales_list( csl_id, orders_id, csl_type_cd, csl_type_col_no, csl_addr, csl_proximity, csl_cur_list_price, csl_org_list_price, csl_data_source, csl_days_on_mkt, csl_days_on_mkt_adj, csl_location, csl_location_adj, csl_site_view, csl_site_view_adj, csl_design, csl_design_adj, csl_qual_const, csl_qual_const_adj, csl_age, csl_age_adj, csl_cond, csl_cond_adj, csl_system, csl_system_adj, csl_basement, csl_basement_adj, csl_functional, csl_functional_adj, csl_heating, csl_heating_adj, csl_garage, csl_garage_adj, csl_porches, csl_porches_adj, csl_spec_energy_eff, csl_spec_energy_eff_adj, csl_fireplaces, csl_fireplaces_adj, csl_other, csl_other_adj, csl_total_rooms, csl_bedrooms, csl_bath_rooms, csl_sqft, csl_sqft_adj, csl_reocorp_prpty, upd_id, upd_dtm) VALUES (#variables.rtn_id#, #form.orders_id#, '1', 1, '#form.sub_address#', 'SUBJECT', '#form.sub_cur_list_price#', '#form.sub_org_list_price#', '#form.sub_data_source#', '#form.sub_days_on_mkt#', '', '#form.sub_location#', '', '#form.sub_site_view#', '', '#form.sub_design#', '', '#form.sub_qual_const#', '', '#form.sub_age#', '', '#form.sub_cond#', '', '#form.sub_system#', '', '#form.sub_basement#', '', '#form.sub_functional#', '', '#form.sub_heating#', '', '#form.sub_garage#', '', '#form.sub_porches#', '', '#form.sub_spec_energy_eff#', '', '#form.sub_fireplaces#', '', '#form.sub_other#', '', '#form.sub_total_rooms#', '#form.sub_bedrooms#', '#form.sub_bath_rooms#', '#form.sub_sqft#', '', 0, '#client.user_id#', #variables.createdate#) ; INSERT INTO fnma_comp_sales_list( csl_id, orders_id, csl_type_cd, csl_type_col_no, csl_addr, csl_proximity, csl_cur_list_price, csl_org_list_price, csl_sale_dt, csl_sale_date_adj, csl_days_on_mkt, csl_days_on_mkt_adj, csl_data_source, csl_location, csl_location_adj, csl_site_view, csl_site_view_adj, csl_design, csl_design_adj, csl_qual_const, csl_qual_const_adj, csl_age, csl_age_adj, csl_cond, csl_cond_adj, csl_system, csl_system_adj, csl_basement, csl_basement_adj, csl_functional, csl_functional_adj, csl_heating, csl_heating_adj, csl_garage, csl_garage_adj, csl_porches, csl_porches_adj, csl_spec_energy_eff, csl_spec_energy_eff_adj, csl_fireplaces, csl_fireplaces_adj, csl_other, csl_other_adj, csl_concessions, csl_concessions_adj, csl_net_adjust, csl_subject_val, csl_total_rooms, csl_bedrooms, csl_bath_rooms, csl_sqft, csl_sqft_adj, csl_reocorp_prpty, upd_id, upd_dtm) VALUES (#variables.rtn_id#, #form.orders_id#, '#cd_idx#', #col_idx#, '#evaluate("form.#coltype##col_idx#_#coldesc#address")#', '#evaluate("form.#coltype##col_idx#_#coldesc#proximity_to")#', '#evaluate("form.#coltype##col_idx#_#coldesc#cur_list_price")#', '#evaluate("form.#coltype##col_idx#_#coldesc#org_list_price")#', '#trim(evaluate("form.#coltype##col_idx#_#coldesc#sale_date"))#', '#evaluate("form.#coltype##col_idx#_#coldesc#sale_date_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#days_on_mkt")#', '#evaluate("form.#coltype##col_idx#_#coldesc#days_on_mkt_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#data_source")#', '#evaluate("form.#coltype##col_idx#_#coldesc#location")#', '#evaluate("form.#coltype##col_idx#_#coldesc#location_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#site_view")#', '#evaluate("form.#coltype##col_idx#_#coldesc#site_view_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#design")#', '#evaluate("form.#coltype##col_idx#_#coldesc#design_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#qual_const")#', '#evaluate("form.#coltype##col_idx#_#coldesc#qual_const_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#age")#', '#evaluate("form.#coltype##col_idx#_#coldesc#age_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#cond")#', '#evaluate("form.#coltype##col_idx#_#coldesc#cond_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#system")#', '#evaluate("form.#coltype##col_idx#_#coldesc#system_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#basement")#', '#evaluate("form.#coltype##col_idx#_#coldesc#basement_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#functional")#', '#evaluate("form.#coltype##col_idx#_#coldesc#functional_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#heating")#', '#evaluate("form.#coltype##col_idx#_#coldesc#heating_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#garage")#', '#evaluate("form.#coltype##col_idx#_#coldesc#garage_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#porches")#', '#evaluate("form.#coltype##col_idx#_#coldesc#porches_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#spec_energy_eff")#', '#evaluate("form.#coltype##col_idx#_#coldesc#spec_energy_eff_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#fireplaces")#', '#evaluate("form.#coltype##col_idx#_#coldesc#fireplaces_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#other")#', '#evaluate("form.#coltype##col_idx#_#coldesc#other_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#concessions")#', '#evaluate("form.#coltype##col_idx#_#coldesc#concessions_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#net_adjust_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#subject_val_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#total_rooms")#', '#evaluate("form.#coltype##col_idx#_#coldesc#bedrooms")#', '#evaluate("form.#coltype##col_idx#_#coldesc#bath_rooms")#', '#evaluate("form.#coltype##col_idx#_#coldesc#sqft")#', '#evaluate("form.#coltype##col_idx#_#coldesc#sqft_adj")#', #variables.reocorp_prpty#, '#client.user_id#', #variables.createdate#) ; UPDATE fnma_bpo_rpt SET curr_mkt_cond_cd = '#variables.curr_mkt_cond_cd#', emp_cond_cd = '#variables.emp_cond_cd#', mkt_price_chng_dir_cd = '#variables.mkt_price_chng_dir_cd#', mkt_price_chng_pct_dec = '#form.mkt_price_chng_pct_dec#', mkt_price_chng_pct_inc = '#form.mkt_price_chng_pct_inc#', mkt_price_chng_mon_dec = '#form.mkt_price_chng_mon_dec#', mkt_price_chng_mon_inc = '#form.mkt_price_chng_mon_inc#', est_pct_own = '#form.est_pct_own#', est_pct_tenant = '#form.est_pct_tenant#', supply_cd = '#variables.supply_cd#', comp_forsale_no = '#form.comp_forsale_no#', comp_list_no = '#form.comp_list_no#', boarded_home_no = '#form.boarded_home_no#', gen_mkt_comments = '#form.gen_mkt_comments#', neighbor_low_val = '#form.neighbor_low_val#', neighbor_high_val = '#form.neighbor_high_val#', subject_imprv_cd = '#variables.subject_imprv_cd#', norm_mkt_days = '#form.norm_mkt_days#', subj_prop_mrk_cd = '#variables.subj_prop_mrk_cd#', subj_unit_type_cd = '#variables.subj_unit_type_cd#', subj_unit_type_no = '#form.subj_unit_type_no#', mon_condo_fee_val = '#form.mon_condo_fee_val#', mon_condo_fee_cur = #variables.mon_condo_fee_cur#, mon_condo_fee_unp = '#form.mon_condo_fee_unp#', mon_condo_fee_pool = #variables.mon_condo_fee_pool#, mon_condo_fee_tennis = #variables.mon_condo_fee_tennis#, mon_condo_fee_ins = #variables.mon_condo_fee_ins#, mon_condo_fee_land = #variables.mon_condo_fee_land#, mon_condo_fee_oth = #variables.mon_condo_fee_oth#, assoc_cont_nm = '#form.assoc_cont_nm#', assoc_cont_phone ='#form.assoc_cont_phone#', assoc_cont_addr = '#form.assoc_cont_addr#', most_likely_buy_cd = '#variables.most_likely_buy_cd#', planned_marketing = '#form.planned_marketing#', rec_repair_item_1 = '#form.rec_repair_item_1#', rec_repair_cost_1 = '#form.rec_repair_cost_1#', rec_repair_desc_1 = '#form.rec_repair_desc_1#', rec_repair_item_2 = '#form.rec_repair_item_2#', rec_repair_cost_2 = '#form.rec_repair_cost_2#', rec_repair_desc_2 = '#form.rec_repair_desc_2#', rec_repair_item_3 = '#form.rec_repair_item_3#', rec_repair_cost_3 = '#form.rec_repair_cost_3#', rec_repair_desc_3 = '#form.rec_repair_desc_3#', rec_repair_item_4 = '#form.rec_repair_item_4#', rec_repair_cost_4 = '#form.rec_repair_cost_4#', rec_repair_desc_4 = '#form.rec_repair_desc_4#', rec_repair_item_5 = '#form.rec_repair_item_5#', rec_repair_cost_5 = '#form.rec_repair_cost_5#', rec_repair_desc_5 = '#form.rec_repair_desc_5#', sale_asis_price = '#form.sale_asis_price#', sale_asrepaired_price = '#form.sale_asrepaired_price#', list_asis_price = '#form.list_asis_price#', list_asrepaired_price = '#form.list_asrepaired_price#', inspected_cd = '#variables.inspected_cd#', asis_avail_fin_conv = #variables.asis_avail_fin_conv#, asis_avail_fin_fhava = #variables.asis_avail_fin_fhava#, asis_avail_fin_other = #variables.asis_avail_fin_other#, asrep_avail_fin_conv = #variables.asrep_avail_fin_conv#, asrep_avail_fin_fhava = #variables.asrep_avail_fin_fhava#, asrep_avail_fin_other = #variables.asrep_avail_fin_other#, final_val_comments = '#form.final_val_comments#', brok_rec_mkt_cd = '#variables.brok_rec_mkt_cd#', comp_by_agent = '#form.comp_by_agent#', comp_by_phone = '#form.comp_by_phone#', upd_id = '#client.user_id#', upd_dtm = #variables.createdate# WHERE orders_id = #form.orders_id# ; UPDATE orders SET ord_comp_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' SET fr_report_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' WHERE orders_id = #form.orders_id# ; UPDATE fnma_comp_sales_list SET csl_addr = '#form.sub_address#', csl_cur_list_price = '#form.sub_cur_list_price#', csl_org_list_price = '#form.sub_org_list_price#', csl_data_source = '#form.sub_data_source#', csl_days_on_mkt = '#form.sub_days_on_mkt#', csl_location = '#form.sub_location#', csl_site_view = '#form.sub_site_view#', csl_design = '#form.sub_design#', csl_qual_const = '#form.sub_qual_const#', csl_age = '#form.sub_age#', csl_cond = '#form.sub_cond#', csl_system = '#form.sub_system#', csl_basement = '#form.sub_basement#', csl_functional = '#form.sub_functional#', csl_heating = '#form.sub_heating#', csl_garage = '#form.sub_garage#', csl_porches = '#form.sub_porches#', csl_spec_energy_eff = '#form.sub_spec_energy_eff#', csl_fireplaces = '#form.sub_fireplaces#', csl_other = '#form.sub_other#', csl_total_rooms = '#form.sub_total_rooms#', csl_bedrooms = '#form.sub_bedrooms#', csl_bath_rooms = '#form.sub_bath_rooms#', csl_sqft = '#form.sub_sqft#', upd_id = '#client.user_id#', upd_dtm = #variables.createdate# WHERE csl_id = #form.sub_csl_id# ; UPDATE fnma_comp_sales_list SET csl_addr = '#evaluate("form.#coltype##col_idx#_#coldesc#address")#', csl_proximity = '#evaluate("form.#coltype##col_idx#_#coldesc#proximity_to")#', csl_cur_list_price = '#evaluate("form.#coltype##col_idx#_#coldesc#cur_list_price")#', csl_org_list_price = '#evaluate("form.#coltype##col_idx#_#coldesc#org_list_price")#', csl_sale_dt = '#trim(evaluate("form.#coltype##col_idx#_#coldesc#sale_date"))#', csl_sale_date_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#sale_date_adj")#', csl_days_on_mkt = '#evaluate("form.#coltype##col_idx#_#coldesc#days_on_mkt")#', csl_days_on_mkt_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#days_on_mkt_adj")#', csl_data_source = '#evaluate("form.#coltype##col_idx#_#coldesc#data_source")#', csl_location = '#evaluate("form.#coltype##col_idx#_#coldesc#location")#', csl_location_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#location_adj")#', csl_site_view = '#evaluate("form.#coltype##col_idx#_#coldesc#site_view")#', csl_site_view_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#site_view_adj")#', csl_design = '#evaluate("form.#coltype##col_idx#_#coldesc#design")#', csl_design_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#design_adj")#', csl_qual_const = '#evaluate("form.#coltype##col_idx#_#coldesc#qual_const")#', csl_qual_const_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#qual_const_adj")#', csl_age = '#evaluate("form.#coltype##col_idx#_#coldesc#age")#', csl_age_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#age_adj")#', csl_cond = '#evaluate("form.#coltype##col_idx#_#coldesc#cond")#', csl_cond_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#cond_adj")#', csl_heating = '#evaluate("form.#coltype##col_idx#_#coldesc#heating")#', csl_heating_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#heating_adj")#', csl_basement = '#evaluate("form.#coltype##col_idx#_#coldesc#basement")#', csl_basement_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#basement_adj")#', csl_functional = '#evaluate("form.#coltype##col_idx#_#coldesc#functional")#', csl_functional_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#functional_adj")#', csl_garage = '#evaluate("form.#coltype##col_idx#_#coldesc#garage")#', csl_garage_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#garage_adj")#', csl_porches = '#evaluate("form.#coltype##col_idx#_#coldesc#porches")#', csl_porches_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#porches_adj")#', csl_spec_energy_eff = '#evaluate("form.#coltype##col_idx#_#coldesc#spec_energy_eff")#', csl_spec_energy_eff_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#spec_energy_eff_adj")#', csl_fireplaces = '#evaluate("form.#coltype##col_idx#_#coldesc#fireplaces")#', csl_fireplaces_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#fireplaces_adj")#', csl_other = '#evaluate("form.#coltype##col_idx#_#coldesc#other")#', csl_other_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#other_adj")#', csl_concessions = '#evaluate("form.#coltype##col_idx#_#coldesc#concessions")#', csl_concessions_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#concessions_adj")#', csl_net_adjust = '#evaluate("form.#coltype##col_idx#_#coldesc#net_adjust_adj")#', csl_subject_val = '#evaluate("form.#coltype##col_idx#_#coldesc#subject_val_adj")#', csl_total_rooms = '#evaluate("form.#coltype##col_idx#_#coldesc#total_rooms")#', csl_bedrooms = '#evaluate("form.#coltype##col_idx#_#coldesc#bedrooms")#', csl_bath_rooms = '#evaluate("form.#coltype##col_idx#_#coldesc#bath_rooms")#', csl_sqft = '#evaluate("form.#coltype##col_idx#_#coldesc#sqft")#', csl_sqft_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#sqft_adj")#', csl_reocorp_prpty = #variables.reocorp_prpty#, upd_id = '#client.user_id#', upd_dtm = #variables.createdate# WHERE csl_id = #evaluate("form.#coltype##col_idx#_csl_id")# ;