HDR*PowerBuilder0600fU7RAPIDS import moduleFRE*ZNOD*8. Cx ENT*0600v7Ad_iscc_ams_material.dwoENT*0600Mr1d_iscc_ams_material.srdENT*0600\7d_iscc_ams_default_factors.srdENT*06007Ad_iscc_ams_rel.dwoENT*0600@7Ad_iscc_ams_default_factors.dwoENT*0600 ͐r1d_iscc_ams_rel.srdENT*0600 K=\;d_iscc_ams_code.srdENT*06007Ad_iscc_ams_surrogate_codes.dwoENT*0600g37Ad_iscc_ams_code.dwoENT*0600 !k5d_iscc_ams_surrogate_codes.srdENT*0600)<82d_iregulation.srdENT*0600z,7Ad_ischedules.dwoENT*0600(7Ad_iregulation.dwoENT*06002:v9)d_ischedules.srdENT*0600~ n1d_ireference_type.srdENT*0600F=!7Ad_iseason_adj_factors.dwoENT*0600nq7Ad_ireference_type.dwoENT*0600h@#&.6d_iseason_adj_factors.srdENT*0600d Ңn1d_iref_code.srdENT*0600P7Ad_iseason_code.dwoENT*0600R"7Ad_iref_code.dwoENT*0600&D\5d_iseason_code.srdENT*0600@(;v9d_ireasons_src.srdENT*0600Y7A d_iseasonal_act_percentages.dwoENT*0600*47Ad_ireasons_src.dwoENT*0600$w5 d_iseasonal_act_percentages.srdENT*0600%82d_ireasons_leg.srdENT*0600T7Ad_isic_code.dwoENT*0600m7Ad_ireasons_leg.dwoENT*0600$n1d_isic_code.srdENT*0600a\9d_ireasons_dev.srdENT*0600 T7Ad_isource.dwoENT*0600c7Ad_ireasons_dev.dwoENT*0600zEf{x?d_isource.srdENT*0600a n1d_ireason.srdENT*0600OB7Ad_isource_act.dwoENT*060027Ad_ireason.dwoENT*0600I3v9d_isource_act.srdENT*0600 ɣn1d_iprocess_code.srdENT*0600@7Ad_isource_code.dwoENT*06007Ad_iprocess_code.dwoENT*0600R sn1d_isource_code.srdENT*0600 Sa2v9d_iprocess_act.srdENT*0600`7Ad_isource_leg_entity_rel.dwoENT*0600II7Ad_iprocess_act.dwoENT*0600|9d_isource_leg_entity_rel.srdENT*0600(@*v9d_iprocess.srdENT*06007Ad_ispec_code.dwoENT*0600~<7Ad_iprocess.dwoENT*0600 r1d_ispec_code.srdENT*0600Zj!v6d_ipart5_emission_factors.srdENT*06007Ad_ispec_split_factor.dwoENT*06008!7Ad_ipart5_emission_factors.dwoENT*0600 r1d_ispec_split_factor.srdENT*0600, mn1d_ioper_yearly_schd.srdENT*06007Ad_ispeed_categories.dwoENT*06007Ad_ioper_yearly_schd.dwoENT*0600x1!w5d_ispeed_categories.srdENT*0600 Un1d_ioper_weekly_schd.srdENT*06007Ad_isrc_group_member.dwoENT*0600,9d_isrc_group_member.srdENT*0600:'7Ad_istream.dwoENT*0600b)^9d_istream.srdENT*0600(#7Ad_isic_naics_code.dwoENT*06007I PN?d_isic_naics_code.srdENT*0600R< dAd_iroadway_types.srdENT*06008#7Ad_iroadway_types.dwoNOD*A(*q :8ENT*0600n118A#d_ivehicle_emissions_estimates.dwoENT*0600A6A#d_ivehicle_emissions_estimates.srdENT*0600E8A$d_ivehicle_seasonal_adj_factors.dwoENT*0600 4x5$d_ivehicle_seasonal_adj_factors.srdENT*06008Ad_ivehicle_type.dwoENT*06009@Ad_ivehicle_type.srdENT*0600$$8Ad_ivmt_profiles.dwoENT*0600J&"w5d_ivmt_profiles.srdENT*0600r 8Ad_progress.dwoENT*0600~7K,,d_progress.srdENT*06008A+d_scc_codes_for_mobile_part5_ee_import.dwoENT*0600WIA+d_scc_codes_for_mobile_part5_ee_import.srdENT*0600U/8A+d_vmt_calculations_for_vehicle_act_imp.dwoENT*0600s4vA+d_vmt_calculations_for_vehicle_act_imp.srdENT*0600D~eAf_block_text.funENT*0600 M.b?f_block_text.srfENT*0600eAf_boolean_to_string.funENT*0600M.b?f_boolean_to_string.srfENT*0600;eA f_cknull.funENT*0600 bM.b? f_cknull.srfENT*0600eAf_get_activity_rid.funENT*06008 N.b?$f_get_activity_rid.srfENT*0600eAf_get_cal_protocol_rid.funENT*0600X4 N.b?0f_get_cal_protocol_rid.srfENT*0600eAf_get_device_sequence.funENT*0600ppN.b?f_get_device_sequence.srfENT*0600eAf_get_emis_fact_rid.funENT*0600lO.b?f_get_emis_fact_rid.srfENT*0600NQeAf_get_emission_factor_rid.funENT*0600O.b?+f_get_emission_factor_rid.srfENT*0600R eAf_get_factors.funENT*0600O.b?f_get_factors.srfENT*0600.* eAf_get_leg_ent_rid.funENT*0600P.b?f_get_leg_ent_rid.srfENT*06002eAf_get_metric_map_rid.funENT*0600 P.b?f_get_metric_map_rid.srfENT*0600( eAf_get_metric_maps.funENT*06002Q.b?(f_get_metric_maps.srfENT*0600,h eAf_get_metrics.funENT*0600T Q.b?$f_get_metrics.srfENT*0600L*eA#f_get_population_via_surrogate.funENT*0600&&Q.b?#f_get_population_via_surrogate.srfENT*0600PfAf_get_pro_schedule_rid.funENT*0600o R.b?5f_get_pro_schedule_rid.srfENT*0600TfAf_get_process_sequence.funENT*0600\A(d_vmt_profile_scc_fac_emission_type.srdENT*0600V+]8A(d_vmt_profile_scc_fac_emission_type.dwoENT*0600R.b?f_get_process_sequence.srfENT*0600`=x5A-d_vmt_calculations_for_vehicle_act_imp_6.srdENT*0600n+r09A-d_vmt_calculations_for_vehicle_act_imp_6.dwoENT*0600>4A+d_vmt_calc_for_vehicle_act_imp_no_area.srdENT*0600+/9A+d_vmt_calc_for_vehicle_act_imp_no_area.dwoENT*0600\>Y\A"d_vehicle_cat_by_area_vehicle.srdENT*0600+h9A"d_vehicle_cat_by_area_vehicle.dwoENT*0600x?Ad_vmt_emission_factor_rid.srdENT*0600+:9Ad_vmt_emission_factor_rid.dwoENT*0600,9Ad_lookup_poll_m6.dwoENT*0600BkpAd_lookup_poll_m6.srdNOD*$?868BENT*0600M&8Ad_imobile_emission_factors.dwoENT*0600:?n1d_imetric_map.srdENT*0600X27Ad_imetric_map.dwoENT*0600Fn1d_imetric_lookup.srdENT*060007Ad_imetric_lookup.dwoENT*0600& n1d_imetric_level.srdENT*0600`7Ad_imetric_level.dwoENT*0600.}l6d_imetric.srdENT*0600(7Ad_imetric.dwoENT*0600vwDr1d_imethod_metric.srdENT*0600<;7Ad_imethod_metric.dwoENT*0600. ܡn1d_imethod.srdENT*06007Ad_imethod.dwoENT*0600 n1d_imeasurement.srdENT*0600Y7Ad_imeasurement.dwoENT*0600o,n1d_imaterial_group_member.srdENT*06007Ad_imaterial_group_member.dwoENT*0600 n1d_imaterial_alias.srdENT*0600z7Ad_imaterial_alias.dwoENT*0600$;d_imaterial.srdENT*0600v#7Ad_imaterial.dwoENT*0600NG(;v9d_ilocords_src.srdENT*0600(n%8Ad_ilocords_src.dwoENT*0600 d+"9v9d_ilocords_dev.srdENT*0600(8Ad_ilocords_dev.dwoENT*0600'ZAd_ilocgrp_src.srdENT*0600&8Ad_ilocgrp_src.dwoENT*0600 +lZAd_ilocgrp_dev.srdENT*0600n)(8Ad_ilocgrp_dev.dwoENT*06008>}?"d_iloadlog.srdENT*0600 _8Ad_iloadlog.dwoENT*0600 4n1d_ilegal_rel_code.srdENT*06008Ad_ilegal_rel_code.dwoENT*0600 n1d_ilegal_entity_type.srdENT*0600 8Ad_ilegal_entity_type.dwoENT*0600 N2d_ilegal_entity.srdENT*0600 8Ad_ilegal_entity.dwoENT*0600t HG B2d_ilegal_act.srdENT*06002 A8Ad_ilegal_act.dwoENT*0600 _'<d_iheader.srdENT*0600 8Ad_iheader.dwoENT*0600 Ugn1d_igroup_type.srdENT*0600 ^8Ad_igroup_type.dwoENT*0600D8v9d_igroup_members.srdENT*0600V 8Ad_igroup_members.dwoENT*0600I`1v9d_igeographic_act.srdENT*0600 N8Ad_igeographic_act.dwoENT*0600 n1d_igeo_type.srdENT*0600 x8Ad_igeo_type.dwoENT*0600 &!5d_igeo_surrogates.srdENT*0600 &8Ad_igeo_surrogates.dwoENT*0600 n1d_igeo_member.srdENT*0600b#<=8Ad_iloccords_geo.dwoENT*06006?>d_iloccords_geo.srdENT*0600(E8Ad_ilocgrp_geo.dwoENT*0600BHZAd_ilocgrp_geo.srdENT*06000:$"FAd_imobile6_scenarios.srdENT*0600)Y!8Ad_imobile6_scenarios.dwoENT*0600.:t(lHA!d_imobile6_scenario_counties.srdENT*0600)%8A!d_imobile6_scenario_counties.dwoENT*06009V1RA d_imobile6_emission_factors.srdENT*0600)=G8A d_imobile6_emission_factors.dwoENT*0600<9KA'd_imobile6_emission_factor_for_vmt.srdENT*0600N*58A'd_imobile6_emission_factor_for_vmt.dwoENT*0600f?@VA+d_imobile6_emission_factor_for_vmt_ora.srdENT*0600+@<8A+d_imobile6_emission_factor_for_vmt_ora.dwoNOD*L5 G ENT*0600jfAf_get_typical_day_saf.funENT*0600S.b?f_get_typical_day_saf.srfENT*0600Fd fAf_get_units.funENT*0600 S.b?f_get_units.srfENT*0600x- fAf_getgeorid.funENT*0600 S.b?cf_getgeorid.srfENT*0600|O fAf_getidrid.funENT*06002 T.b?f_getidrid.srfENT*0600JfA f_getrid.funENT*0600P T.b?8 f_getrid.srfENT*0600fA f_getseq.funENT*0600f T.b?? f_getseq.srfENT*0600vfAf_insertactivity.funENT*0600* U.b?f_insertactivity.srfENT*0600fAf_insertactivity_old.funENT*0600 U.b?f_insertactivity_old.srfENT*0600ffAf_insertdevice.funENT*0600 $ =\Af_insertdevice.srfENT*0600 fAf_insertemissionfactor.funENT*0600! V.b?f_insertemissionfactor.srfENT*0600fAf_insertprocess.funENT*0600*!lW.b?f_insertprocess.srfENT*0600fAf_insertsource.funENT*0600P! W.b?f_insertsource.srfENT*06001fAf_insertstream.funENT*0600r! X.b?f_insertstream.srfENT*0600l fAf_metric_ck.funENT*0600!X.b?f_metric_ck.srfENT*0600 fAf_qc_act_data_imp.funENT*0600!$Y.b?>f_qc_act_data_imp.srfENT*0600fAf_qc_act_data_imp2.funENT*0600!+Y.b?hf_qc_act_data_imp2.srfENT*0600@ fAf_speed_2_mph.funENT*0600"Y.b?f_speed_2_mph.srfENT*0600cfA m_imain.menENT*0600"!Z.b?% m_imain.srmENT*0600>E 9A r_import.aplENT*0600"Q0 r_import.praENT*0600"M,b? r_import.sraENT*0600"xZ.b?str_device_id.srsENT*0600fAstr_device_id.strENT*0600"Z.b?str_ierror.srsENT*0600:fAstr_ierror.strENT*0600"IAstr_ifile.srsENT*06004fAstr_ifile.strENT*0600"X[.b?str_map_codes.srsENT*0600fAstr_map_codes.strENT*0600"[.b?str_metric_maps.srsENT*0600fAstr_metric_maps.strENT*0600"[.b?str_metrics.srsENT*0600fAstr_metrics.strENT*0600"[.b?str_scc_ams_code.srsENT*0600ZfAstr_scc_ams_code.strENT*0600"r[.b?str_source_id.srsENT*0600"fAstr_source_id.strENT*0600"v\.b?str_units.srsENT*0600(fAstr_units.strENT*0600#\.b?u_help_bar.sruENT*0600* fAu_help_bar.udoENT*0600B#~|?uo_header.sruENT*0600HfAuo_header.udoENT*0600A+uo_loader.sruENT*06008YVkAuo_loader.udoENT*0600)-b?uo_loadlog.sruENT*0600@#<8Ad_idevice_code.dwoENT*0600FQ1v9d_idevice_act.srdENT*0600F8Ad_idevice_act.dwoENT*060069=px?d_idevice.srdENT*0600@;8Ad_idevice.dwoENT*06006s Πn1d_idata_code.srdENT*0600&I8Ad_idata_code.dwoENT*0600> ZAd_icoord_cal_type.srdENT*0600 8Ad_icoord_cal_type.dwoENT*0600F9d_icontacts_src.srdENT*060098Ad_icontacts_src.dwoENT*0600BEd%82d_icontacts_leg.srdENT*0600:8Ad_icontacts_leg.dwoENT*0600{IV9d_icontacts_dev.srdENT*0600;8Ad_icontacts_dev.dwoENT*0600.O9 d_iconnection.srdENT*0600l 8Ad_iconnection.dwoENT*0600#,u1d_ical_protocol.srdENT*0600(8Ad_ical_protocol.dwoENT*0600 {n1d_ical_method.srdENT*06008Ad_ical_method.dwoENT*06001$w5d_iarea_source_activities.srdENT*0600n,8Ad_iarea_source_activities.dwoENT*0600\odX5d_iarea_fac_type.srdENT*0600Du8Ad_iarea_fac_type.dwoENT*0600d25ܜ9 d_iapplication.srdENT*06008Ad_iapplication.dwoENT*060006d_iaircraft_tim.srdENT*06008Ad_iaircraft_tim.dwoENT*0600&% $w5d_iaircraft_lto.srdENT*0600$8Ad_iaircraft_lto.dwoENT*0600vC\5d_iaircraft_engine.srdENT*0600X8Ad_iaircraft_engine.dwoENT*0600.'06d_iaircraft_ef.srdENT*0600(8Ad_iaircraft_ef.dwoENT*0600J06d_iaircraft_def_tim.srdENT*0600Y8Ad_iaircraft_def_tim.dwoENT*0600.uU;d_iconversion_lookup_codes.srdENT*0600`"8Ad_iconversion_lookup_codes.dwoENT*0600/EqY< d_igeo_emission_factors_old.srdENT*0600|"98A d_igeo_emission_factors_old.dwoENT*0600j9!_ZAd_iemission_types.srdENT*0600*8Ad_iemission_types.dwoENT*0600r<dAd_iarea_fac_road_type.srdENT*0600*8Ad_iarea_fac_road_type.dwoNOD*4N { ENT*0600H9d_contacts_dev.srdENT*0600X;8Ad_contacts_dev.dwoENT*06008Ad_iaccuracy_method.dwoENT*0600 Gn1d_iaccuracy_method.srdENT*0600W8Ad_iact_doc_lookup.dwoENT*0600bL9d_iact_doc_lookup.srdENT*0600F8Ad_iaircraft_categories.dwoENT*0600C\5d_iaircraft_categories.srdENT*0600=A"d_area_fac_roadway_by_roadway.srdENT*0600* 8A"d_area_fac_roadway_by_roadway.dwoENT*0600=0vTSA d_create_emission_factor_m6.srqENT*0600=m?YA d_create_emission_factor_m6.srdENT*0600*78A d_create_emission_factor_m6.dwoNOD*( ]ENT*06001u.b?) w_iretry.srwENT*0600!+kA w_iretry.winENT*0600"kA w_ifiles.winENT*06008xA' w_imain.srwENT*0600+rlA w_imain.winENT*0600x0:rA1 w_ifiles.srwDAT*ZPDW0800ipdw+%#$$````  F$&innaaDAT*\d @!`DAT*^< $0% MS Sans SerifMS Sans Serif$ 2$ -14$700$1$ 553648127$8388DAT*`608$ 9$24$`96$754% Device ContactsDevice Contacts$" 536870912@!@ !%!`5&$'!*,.02DAT*brap_sources_id_t< ( $)-8$+%37$-4$/452$1.558%34Agency Source Id:Agency Source Id:G%6$' 79;,=?AC (FraDAT*dp_sources_id$8 67108864$: 33554432$<n622$>@64$@439$B5&DE [general] [general]`N5H$'!*I.0Krap_devices_id_t$J132%LDAT*fMAgency Device Id:Agency Device Id:SGO$' 79;I=PAC(Rrap_devices_id$Q238`ZNT$'!*U.0Wrap_contacts_fax_no_t$V256%XYFax:Fax:_S[DAT*h$' 79;U=\AC(^rap_contacts_fax_no$]`352`fZ`$'!*a.0crap_contacts_internet_addr_t$b384%deInternet Address:Internet Address:k_g$' 79;a=DAT*jhAC((j(rap_contacts_internet_addr$i786`rfl$'!*m.0o rap_contacts_mail_addr_line_1_t$n508%pqAddress Line 1:Address Line 1:uks$' 79;m=hAC2(DAT*lt(rap_contacts_mail_addr_line_1`|rv$'!*w.0y rap_contacts_mail_addr_line_2_t$x|636%z{Address Line 2:Address Line 2:u}$' 79;w=hAC<(~(rap_contacts_mail_addr_line_2DAT*n`|$'!. rap_geographic_locations_name_t$457$760$137%City:City:$' 79;=ACF(2 city_name$1426DAT*p`$'!.$411$x888$183%State:State:$' 79;=ACP(2 state_name$w1399`$DAT*r'!.$W343$1012$251% Country: Country:$' 79;=AC Z(2 country_name`$'!*.0DAT*trap_contacts_mail_label_code_t$t1140%Mail Label Code:Mail Label Code:$' 79;=PAC d( rap_contacts_mail_label_code`$'!*.0rap_contacts_mail_zip_code_t$DAT*v1264%Zip:Zip:$' 79;=PAC n( rap_contacts_mail_zip_code`$'!*.0rap_contacts_name_t$p1392%Contact Name:Contact Name:$DAT*x' 79;=AC x(2rap_contacts_name$969`$'!*.0rap_contacts_phone_ext_no_t$1516%Ext.:Ext.:$' 79;=AC (DAT*zrap_contacts_phone_ext_no$165`$'!*.0rap_contacts_phone_no_t$l1644%Phone:Phone:$' 79;=\AC(rap_contacts_phone_noDAT*|`$'!*.0rap_contacts_role_t$1768%Title:Title:$' 79;=AC(2rap_contacts_role`$'!*.0rap_conDAT*~tacts_rid_t$h1896%Rid:Rid:$' 79;=A(rap_contacts_rid$274& [general] [general]`$'!*.0rap_contacts_ref_rid_t$DAT*2020%Reference Rid:Reference Rid:$' 79;=A(rap_contacts_ref_rid` $'!*.0rap_contacts_mail_city_rid_t$d2148%   City Rid: City Rid:DAT* $' 79;.A(  city_rid` $'!*.0rap_contacts_mail_state_rid_t$2260% State Rid: State Rid:$' 79;.A(DAT* state_rid$2264`!$'!*.0 rap_contacts_mail_country_rid_t$H 2376%  Country Rid: Country Rid:"$' 79;.A(# country_rid@DAT*!Dc(5&'),N*+DAT*/Z-.2f01)5r34)8|67);9:3><=3A?@ 3DBCDAT* GEF JHI 3MKL PNOSQR3VTU YWX \ Z[DAT* _]^ b!`a rap_sources_idrap_sources.id5nullrap_devices_idrap_devices.idNrap_contacts_fax_norap_contacts.fax_noZrap_contacts_internet_addrrap_contacts.internet_addrfrap_contacts_mail_addr_line_1rap_contacts.mail_addrDAT*_line_1rrap_contacts_mail_addr_line_2rap_contacts.mail_addr_line_2| city_namerap_geographic_locations.name state_namerap_geographic_locations.name country_namerap_geographic_locations.namerap_contacts_mail_label_coderap_contacts.mail_label_coderap_contacts_mail_zip_coderap_contacts.mail_zip_coderap_coDAT*ntacts_namerap_contacts.namerap_contacts_phone_ext_norap_contacts.phone_ext_norap_contacts_phone_norap_contacts.phone_norap_contacts_rolerap_contacts.rolerap_contacts_ridrap_contacts.ridrap_contacts_ref_ridrap_contacts.ref_rid city_ridrap_contacts.mail_city_rid  state_ridrap_contacts.mail_DAT*state_rid country_ridrap_contacts.mail_country_rid!SELECT rap_sources.id, rap_devices.id, rap_contacts.fax_no, rap_contacts.internet_addr, rap_contacts.mail_addr_line_1, rap_contacts.mail_addr_line_2, rap_geographic_locations_a.name, rap_geographic_locations_b.name, rap_geographic_locations_c.name, rap_contacts.mail_label_code, rap_contacts.mail_zip_code, rap_contacts.name, rap_contacts.phone_ext_no, rap_contacts.phone_no, rap_contacts.role, rapDAT*Device Contactsrelease 6; datawindow(units=0 timer_interval=0 color=12632256 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no ) header(height=140 color="536870912" ) summary(height=4 color="536870912" ) footer(height=0 color="536870912" ) detail(height=2492 color="536870912" ) table(columnDAT*=(type=char(15) updatewhereclause=yes name=rap_sources_id dbname="rap_sources.id" initial="null" ) column=(type=char(15) updatewhereclause=yes name=rap_devices_id dbname="rap_devices.id" ) column=(type=char(16) updatewhereclause=yes name=rap_contacts_fax_no dbname="rap_contacts.fax_no" ) column=(type=char(40) updatewhereclause=yes name=rap_contacts_internet_addr dbname="rap_contacts.internet_addr" ) column=(type=char(40) updatewhereclause=yes name=rap_contacts_mail_addr_line_1 dbname="rap_DAT*contacts.mail_addr_line_1" ) column=(type=char(40) updatewhereclause=yes name=rap_contacts_mail_addr_line_2 dbname="rap_contacts.mail_addr_line_2" ) column=(type=char(50) updatewhereclause=yes name=city_name dbname="rap_geographic_locations.name" ) column=(type=char(50) updatewhereclause=yes name=state_name dbname="rap_geographic_locations.name" ) column=(type=char(50) updatewhereclause=yes name=country_name dbname="rap_geographic_locations.name" ) column=(type=char(10) updatewhereclauseDAT*=yes name=rap_contacts_mail_label_code dbname="rap_contacts.mail_label_code" ) column=(type=char(11) updatewhereclause=yes name=rap_contacts_mail_zip_code dbname="rap_contacts.mail_zip_code" ) column=(type=char(50) updatewhereclause=yes name=rap_contacts_name dbname="rap_contacts.name" ) column=(type=char(6) updatewhereclause=yes name=rap_contacts_phone_ext_no dbname="rap_contacts.phone_ext_no" ) column=(type=char(16) updatewhereclause=yes name=rap_contacts_phone_no dbname="rap_contacts.phDAT*one_no" ) column=(type=char(50) updatewhereclause=yes name=rap_contacts_role dbname="rap_contacts.role" ) column=(type=decimal(0) updatewhereclause=yes name=rap_contacts_rid dbname="rap_contacts.rid" ) column=(type=decimal(0) updatewhereclause=yes name=rap_contacts_ref_rid dbname="rap_contacts.ref_rid" ) column=(type=decimal(0) updatewhereclause=yes name=city_rid dbname="rap_contacts.mail_city_rid" ) column=(type=decimal(0) updatewhereclause=yes name=state_rid dbname="rap_contacts.mail_sDAT*tate_rid" ) column=(type=decimal(0) updatewhereclause=yes name=country_rid dbname="rap_contacts.mail_country_rid" ) retrieve="SELECT rap_sources.id, rap_devices.id, rap_contacts.fax_no, rap_contacts.internet_addr, rap_contacts.mail_addr_line_1, rap_contacts.mail_addr_line_2, rap_geographic_locations_a.name, rap_geographic_locations_b.name, rap_geographic_locations_c.name, rap_contacts.mail_label_code, rap_contacts.mail_zip_code, rap_contacts.name, rap_contacts.phone_ext_no, rap_contacts.phone_DAT*no, rap_contacts.role, rap_contacts.rid, rap_contacts.ref_rid, rap_contacts.mail_city_rid, rap_contacts.mail_state_rid, rap_contacts.mail_country_rid FROM rap_contacts, rap_devices, rap_geographic_locations rap_geographic_locations_a, rap_geographic_locations rap_geographic_locations_b, rap_geographic_locations rap_geographic_locations_c, rap_sources WHERE ( rap_devices.rid = rap_contacts.ref_rid ) and ( rap_geographic_locations_a.rid = rap_contacts.mail_city_rid ) and ( rap_geographic_locations_bDAT*.rid = rap_contacts.mail_state_rid ) and ( rap_geographic_locations_c.rid = rap_contacts.mail_country_rid ) and ( rap_sources.rid = rap_devices.source_rid ) " ) text(band=header alignment="1" text="Device Contacts"border="0" color="8388608" x="9" y="24" height="96" width="754" font.face="MS Sans Serif" font.height="-14" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) text(band=detail alignment="1" text="Agency Source Id:"bordDAT*er="0" color="8388608" x="37" y="4" height="52" width="558" name=rap_sources_id_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=1 alignment="0" tabsequence=10 border="5" color="33554432" x="622" y="4" height="64" width="439" format="[general]" name=rap_sources_id edit.limit=15 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes fontDAT*.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Agency Device Id:"border="0" color="8388608" x="37" y="132" height="52" width="558" name=rap_devices_id_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=2 alignment="0" DAT*tabsequence=20 border="5" color="33554432" x="622" y="132" height="64" width="238" format="[general]" name=rap_devices_id edit.limit=15 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Fax:"border="0" color="8388608" x="37" y="256" height="52" width="558" name=rap_contactDAT*s_fax_no_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=3 alignment="0" tabsequence=30 border="5" color="33554432" x="622" y="256" height="64" width="352" format="[general]" name=rap_contacts_fax_no edit.limit=16 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.faDAT*mily="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Internet Address:"border="0" color="8388608" x="37" y="384" height="52" width="558" name=rap_contacts_internet_addr_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=4 alignment="0" tabsequence=40 border="5" color="33554432" x="622" y=DAT*"384" height="64" width="786" format="[general]" name=rap_contacts_internet_addr edit.limit=40 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Address Line 1:"border="0" color="8388608" x="37" y="508" height="52" width="558" name=rap_contacts_mail_addr_line_1_t font.facDAT*e="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=5 alignment="0" tabsequence=50 border="5" color="33554432" x="622" y="508" height="64" width="786" format="[general]" name=rap_contacts_mail_addr_line_1 edit.limit=40 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" fDAT*ont.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Address Line 2:"border="0" color="8388608" x="37" y="636" height="52" width="558" name=rap_contacts_mail_addr_line_2_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=6 alignment="0" tabsequence=60 border="5" color="33554432" x="622" y="636" heiDAT*ght="64" width="786" format="[general]" name=rap_contacts_mail_addr_line_2 edit.limit=40 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="City:"border="0" color="8388608" x="457" y="760" height="52" width="137" name=rap_geographic_locations_name_t font.face="MS Sans SeriDAT*f" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=7 alignment="0" tabsequence=70 border="5" color="33554432" x="622" y="760" height="64" width="1426" format="[general]" name=city_name edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" bacDAT*kground.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="State:"border="0" color="8388608" x="411" y="888" height="52" width="183" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=8 alignment="0" tabsequence=80 border="5" color="33554432" x="622" y="888" height="64" width="1399" format="[general]" name=state_name edit.limit=50 edit.casDAT*e=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Country:"border="0" color="8388608" x="343" y="1012" height="52" width="251" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="5368709DAT*12" ) column(band=detail id=9 alignment="0" tabsequence=90 border="5" color="33554432" x="622" y="1012" height="64" width="1399" format="[general]" name=country_name edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Mail Label Code:"border="0" color="8388608"DAT* x="37" y="1140" height="52" width="558" name=rap_contacts_mail_label_code_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=10 alignment="0" tabsequence=100 border="5" color="33554432" x="622" y="1140" height="64" width="238" format="[general]" name=rap_contacts_mail_label_code edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscDAT*roll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Zip:"border="0" color="8388608" x="37" y="1264" height="52" width="558" name=rap_contacts_mail_zip_code_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=11DAT* alignment="0" tabsequence=110 border="5" color="33554432" x="622" y="1264" height="64" width="238" format="[general]" name=rap_contacts_mail_zip_code edit.limit=11 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Contact Name:"border="0" color="8388608" x="37" y="1392" heDAT*ight="52" width="558" name=rap_contacts_name_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=12 alignment="0" tabsequence=120 border="5" color="33554432" x="622" y="1392" height="64" width="969" format="[general]" name=rap_contacts_name edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.DAT*height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Ext.:"border="0" color="8388608" x="37" y="1516" height="52" width="558" name=rap_contacts_phone_ext_no_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=13 alignment="0" tabsequence=130 border="5"DAT* color="33554432" x="622" y="1516" height="64" width="165" format="[general]" name=rap_contacts_phone_ext_no edit.limit=6 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Phone:"border="0" color="8388608" x="37" y="1644" height="52" width="558" name=rap_contacts_phone_no_DAT*t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=14 alignment="0" tabsequence=140 border="5" color="33554432" x="622" y="1644" height="64" width="352" format="[general]" name=rap_contacts_phone_no edit.limit=16 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.familyDAT*="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Title:"border="0" color="8388608" x="37" y="1768" height="52" width="558" name=rap_contacts_role_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=15 alignment="0" tabsequence=150 border="5" color="33554432" x="622" y="1768" height="64" wiDAT*dth="969" format="[general]" name=rap_contacts_role edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" ) text(band=detail alignment="1" text="Rid:"border="0" color="8388608" x="37" y="1896" height="52" width="558" name=rap_contacts_rid_t font.face="MS Sans Serif" font.height="-8" font.weight="700"DAT* font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=16 alignment="1" tabsequence=32766 border="5" color="33554432" x="622" y="1896" height="64" width="274" format="[general]" name=rap_contacts_rid edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" backgroundDAT*X2.color="67108864" ) text(band=detail alignment="1" text="Reference Rid:"border="0" color="8388608" x="37" y="2020" height="52" width="558" name=rap_contacts_ref_rid_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=17 alignment="1" tabsequence=32766 border="5" color="33554432" x="622" y="2020" height="64" width="274" format="[general]" name=rap_contacts_ref_riDAT*>)_contacts.rid, rap_contacts.ref_rid, rap_contacts.mail_city_rid, rap_contacts.mail_state_rid, rap_contacts.mail_country_rid FROM rap_contacts, rap_devices, rap_geographic_locations rap_geographic_locations_a, rap_geographic_locations rap_geographic_locations_b, rap_geographic_locations rap_geographic_locations_c, rap_sources WHERE ( rap_devices.rid = rap_contacts.ref_rid ) and ( rap_geographic_locations_a.rid = rap_contacts.mail_city_rid ) and ( rap_geographic_locations_b.rid = rap_contacts.mail_sDAT*Activity Document Lookupsrelease 6; datawindow(units=0 timer_interval=0 color=12632256 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no ) header(height=112 color="536870912" ) summary(height=4 color="536870912" ) footer(height=0 color="536870912" ) detail(height=1700 color="536870912" ) taDAT*ble(column=(type=char(20) update=yes updatewhereclause=yes name=rap_document_lookups_image_id dbname="rap_document_lookups.image_id" ) column=(type=decimal(0) update=yes updatewhereclause=yes name=rap_document_lookups_page_no dbname="rap_document_lookups.page_no" ) column=(type=char(20) updatewhereclause=yes name=rap_applications_id dbname="rap_applications.id" ) column=(type=char(20) updatewhereclause=yes name=rap_forms_id dbname="rap_forms.id" ) column=(type=date update=yes updatewhereclDAT*Jause=yes name=rap_document_lookups_start_date dbname="rap_document_lookups.start_date" ) column=(type=char(10) update=yes updatewhereclause=yes name=rap_document_lookups_level_type dbname="rap_document_lookups.level_type" ) column=(type=date update=yes updatewhereclause=yes name=rap_document_lookups_end_date dbname="rap_document_lookups.end_date" ) column=(type=char(15) updatewhereclause=yes name=rap_devices_id dbname="rap_devices.id" ) column=(type=char(15) updatewhereclause=yes name=rap_DAT*PDW0800`pdw+V!"U```` F$`nnaaDAT* @]`DAT* < $0% MS Sans SerifMS Sans Serif$ 2$ -12$700$ 12632256$8388608$DAT*14$8$Q81$746%Accuracy MethodsAccuracy Methods$  536870912@@#P`5$"%((*,.02type_t< &DAT* $'-8$)1$+755$-4$/553$1170%34Type:Type:`@#6"%((79.;=name_t$8%37$:DAT*132$<188%>?Name:Name:P5A"% BD,FHJL O type$C 16777215$E243$GA65$Ia353$K5&MN [general] [gDAT*eneral]@Q"% BD9FRJLT2name$S1756@XW_DAT*@)@[@YZ ^P\]3@rap_accuracy_methodstyperap_accuracy_methods.type@namerap_accuracy_methods.nameP~PBSELECT(TABLE(NAME="rap_accuracy_methods") COLUMN(NAME="rap_accuracy_methods.type")COLUMN(NAME="rap_accuraDAT*release 4; datawindow(units=0 timer_interval=0 color=12632256 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no ) header(height=93 color="536870912" ) summary(height=5 color="536870912" ) footer(height=1 color="536870912" ) detail(height=261 color="536870912" ) table(column=(type=char(10) update=yes key=yes name=type dbname="rap_acDAT*curacy_methods.type" ) column=(type=char(50) update=yes name=name dbname="rap_accuracy_methods.name" ) retrieve="PBSELECT(TABLE(NAME=~"rap_accuracy_methods~") COLUMN(NAME=~"rap_accuracy_methods.type~")COLUMN(NAME=~"rap_accuracy_methods.name~"))" update="rap_accuracy_methods" updatewhere=1 updatekeyinplace=yes ) text(band=header alignment="0" text="Accuracy Methods"border="0" color="8388608" x="14" y="8" height="81" width="746" font.face="MS Sans Serif" font.height="-12" font.weight="700" foDAT*nt.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="12632256" ) text(band=detail alignment="1" text="Type:"border="0" color="8388608" x="55" y="4" height="53" width="170" name=type_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="Name:"border="0" color="8388608" x="37" y="132" height="53" width="188" name=name_t DAT* font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=1 alignment="0" tabsequence=10 border="5" color="0" x="243" y="4" height="65" width="353" format="[general]" name=type edit.limit=10 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset=DAT*"0" background.mode="2" background.color="16777215" ) column(band=detail id=2 alignment="0" tabsequence=20 border="5" color="0" x="243" y="132" height="65" width="1756" format="[general]" name=name edit.limit=50 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) DAT*PDW0800 pdw+#$```` F$( nnaaDAT* @p!`DAT*< $0% MS Sans SerifMS Sans Serif$ 2$ -12$700$1$ 553648127$8388DAT*608$23$24$P80$782% Document LookupsDocument Lookups$" 536870912@!@!%`4$&)+-/1DAT*< ' $(-8$*1970$,736$.452$0439%23Material Code:Material Code:D%5$& 68+:<>@C rap_activities_materiaDAT*l_code$7 16777215$9 2437$;@64$=I841$?5&AB [general] [general]`N4$&EG-IK$Fe1893$HD836$J517DAT*%LMReference Code:Reference Code:QDO$& 68G:<>@P rap_activities_reference_code`[N$&RT-VX$S2043$U936$Wn366%YZ DAT*Value Type: Value Type:`Q\$& 68T:]>@_rap_activities_value_type$^233`j[$&ac-eg$b%2085$d(40$fE325%hi DeDAT*vice Id: Device Id:o`k$& 68c:l>@Pnrap_devices_id$m690`zjp$&!qs-uwrap_document_lookups_ref_rid_t$r2066$t136$vW343%xDAT*y Process Id: Process Id:}o{$& 68s:l>@ Z|rap_processes_id`z$&~-$22098$232$7311% Stream Id: Stream Id:}DAT* $& 68:l>@ drap_streams_id`$&-$2021$L332$389% Metric Code: Metric Code:$& 68DAT* :<>@ n rap_activities_metric_code`$&-$r1906$428$503%Start Date Time:Start Date Time:$& 68:> DAT*x(rap_activities_start_date_time$393&[shortdate] [time][shortdate] [time]`$&q-u$ 524% Data Code: Data Code:$& 68:>@ DAT*rap_activities_data_code$)297`$&-$1938$|636$471%End Date Time:End Date Time:$& 68:>DAT*(rap_activities_end_date_time`$&!c- rap_document_lookups_image_id_t$i361$%293% Image Id: Image Id:`$&!s-rap_document_lookups_page_no_t$DAT*w375$279% Page No: Page No:`$&!-rap_applications_id_t$201$453%Application Id:Application Id:`$&!-DAT*rap_forms_id_t$407$247% Form Id: Form Id:`$&!-"rap_document_lookups_start_date_t$@320$N334% Start Date: Start Date:`$&!-DAT*"rap_document_lookups_level_type_t$w631%Keyword Level Type:Keyword Level Type:`$&!- rap_document_lookups_end_date_t$`352$.302% End Date: End Date:$& 6DAT*c:>@ rap_document_lookups_image_id$681$1029 $& 6s:> ( rap_document_lookups_page_no$274&   [general] [general]DAT*$& 6:>@rap_applications_id $& 6:>@( rap_forms_id$& 6:>2( rap_document_lookups_start_dateDAT*$r370& [general] [general] $& 6:>@< rap_document_lookups_level_type$530%!$& 6:">F($rap_document_lookups_end_dDAT* ate$#e357`. &$&!')-V+#rap_document_lookups_description_t$(R338$* 1056%,- Description: Description:7%/$& 602:4>@(62!rap_document_lookups_desDAT*"cription$1731$31052$51961`@.8$&!9;-=rap_document_lookups_user_id_t$:457$<x1144%>? User Id: User Id:G7A$& 60B:D>@DAT*$(Frap_document_lookups_user_id$Ct1140$E1170`R@H$&!IK-MOrap_legal_entities_name_t$J{123$L1232$NE581%PQLegal Entity Name:Legal Entity Name:DAT*&WGS$& 60T:4>@V2rap_legal_entities_name$U1228``RX$&!Y-[])rap_document_lookups_confidential_flag_t$Z$1316$\384%^_Confidential:ConfidentialDAT*(:kWa$b 60Yfh>@ j'rap_document_lookups_confidential_flag<c ' %deArialArial$g856$iR82`s`$&!el-np$mDAT**t1396$o{379%qr Stream Flag: Stream Flag:xkt$b 60ufh>@ w!rap_document_lookups_stream_flag$vp1392`sy$&!z|-~bookmark_level_type_t${WDAT*,87$}1472$i617%Bookmark Level Type:Bookmark Level Type:x$& 60|->@ bookmark_level_type$w1399`$&!-bookmark_refeDAT*.rence_id_t$250$ 1548$654%Bookmark Reference ID:Bookmark Reference ID:$& 60->@ bookmark_reference_id$443`$&!-DAT*0bookmark_reference_id2_t$5$X1624$699%Bookmark Reference ID 2:Bookmark Reference ID 2:$& 60->@ bookmark_reference_id2@!DAT*2D !!@ @ DAT*4 @ @  @jz  DAT*6    4 N [.3@@DAT*8@R3s@`@3 DAT*: @ @ @ @@  @rap_document_lookupsrap_document_lookups_image_idrap_document_lookups.image_idrap_documDAT*<ent_lookups_page_norap_document_lookups.page_norap_applications_idrap_applications.id  rap_forms_id rap_forms.id rap_document_lookups_start_date rap_document_lookups.start_date rap_document_lookups_level_type rap_document_lookups.level_typerap_document_lookups_end_daterap_document_lookups.end_date rap_devices_idrap_devices.DAT*>idjrap_processes_idrap_processes.idzrap_streams_idrap_streams.idrap_activities_metric_coderap_activities.metric_coderap_activities_start_date_timerap_activities.start_date_timerap_activities_data_coderap_activities.data_coderap_activities_end_date_timerap_activities.end_date_timerap_activities_mateDAT*@rial_coderap_activities.material_code4rap_activities_reference_coderap_activities.reference_codeNrap_activities_value_typerap_activities.value_type[!rap_document_lookups_description!rap_document_lookups.description.rap_document_lookups_user_idrap_document_lookups.user_id@rap_legal_entities_namerap_legal_entities.nameR!rap_documenDAT*Bt_lookups_stream_flag!rap_document_lookups.stream_flags'rap_document_lookups_confidential_flag'rap_document_lookups.confidential_flag`bookmark_level_typerap_sources.namebookmark_reference_idrap_sources.idbookmark_reference_id2rap_sources.operator_idrap_document_lookups_ridrap_document_lookups.rid"rap_document_lookups_document_rid"rap_documentDAT*D_lookups.document_ridrap_document_lookups_form_ridrap_document_lookups.form_ridrap_document_lookups_ref_ridrap_document_lookups.ref_rid%rap_document_lookups_application_rid%rap_document_lookups.application_rid)rap_document_lookups_bookmark_level_type)rap_document_lookups.bookmark_level_type&rap_document_lookups_bookmark_ref_rid&rap_document_lookups.bookmark_ref_ridD PBSELECT( VERSION(400) TABLE(NAME="rap_applications" ) TABLE(NAME="rap_document_lookupDAT*Fs" ) TABLE(NAME="rap_documents" ) TABLE(NAME="rap_forms" ) TABLE(NAME="rap_legal_entities" ) TABLE(NAME="rap_activities" ) TABLE(NAME="rap_devices" ) TABLE(NAME="rap_processes" ) TABLE(NAME="rap_streams" ) TABLE(NAME="rap_sources" ) COLUMN(NAME="rap_document_lookups.image_id") COLUMN(NAME="rap_document_lookups.page_no") COLUMN(NAME="rap_applications.id") COLUMN(NAME="rap_forms.id") COLUMN(NAME="rap_document_lookups.start_date") COLUMN(NAME="rap_document_lookups.level_type") COLUMN(NAME="rap_documeDAT*Hnt_lookups.end_date") COLUMN(NAME="rap_devices.id") COLUMN(NAME="rap_processes.id") COLUMN(NAME="rap_streams.id") COLUMN(NAME="rap_activities.metric_code") COLUMN(NAME="rap_activities.start_date_time") COLUMN(NAME="rap_activities.data_code") COLUMN(NAME="rap_activities.end_date_time") COLUMN(NAME="rap_activities.material_code") COLUMN(NAME="rap_activities.reference_code") COLUMN(NAME="rap_activities.value_type") COLUMN(NAME="rap_document_lookups.description") COLUMN(NAME="rap_document_lookups.userDAT*_id") COLUMN(NAME="rap_legal_entities.name") COLUMN(NAME="rap_document_lookups.stream_flag") COLUMN(NAME="rap_document_lookups.confidential_flag") COLUMN(NAME="rap_sources.name") COLUMN(NAME="rap_sources.id") COLUMN(NAME="rap_sources.operator_id") COLUMN(NAME="rap_document_lookups.rid") COLUMN(NAME="rap_document_lookups.document_rid") COLUMN(NAME="rap_document_lookups.form_rid") COLUMN(NAME="rap_document_lookups.ref_rid") COLUMN(NAME="rap_document_lookups.application_rid") COLUMN(NAME="rap_documenDAT*Lprocesses_id dbname="rap_processes.id" ) column=(type=char(20) updatewhereclause=yes name=rap_streams_id dbname="rap_streams.id" ) column=(type=char(12) updatewhereclause=yes name=rap_activities_metric_code dbname="rap_activities.metric_code" ) column=(type=datetime updatewhereclause=yes name=rap_activities_start_date_time dbname="rap_activities.start_date_time" ) column=(type=char(4) updatewhereclause=yes name=rap_activities_data_code dbname="rap_activities.data_code" ) column=(type=datDAT*Netime updatewhereclause=yes name=rap_activities_end_date_time dbname="rap_activities.end_date_time" ) column=(type=char(12) updatewhereclause=yes name=rap_activities_material_code dbname="rap_activities.material_code" ) column=(type=char(12) updatewhereclause=yes name=rap_activities_reference_code dbname="rap_activities.reference_code" ) column=(type=char(3) updatewhereclause=yes name=rap_activities_value_type dbname="rap_activities.value_type" ) column=(type=char(50) update=yes updatewherDAT*Peclause=yes name=rap_document_lookups_description dbname="rap_document_lookups.description" ) column=(type=char(30) update=yes updatewhereclause=yes name=rap_document_lookups_user_id dbname="rap_document_lookups.user_id" ) column=(type=char(50) updatewhereclause=yes name=rap_legal_entities_name dbname="rap_legal_entities.name" ) column=(type=char(1) update=yes updatewhereclause=yes name=rap_document_lookups_stream_flag dbname="rap_document_lookups.stream_flag" ) column=(type=char(1) updateDAT*R=yes updatewhereclause=yes name=rap_document_lookups_confidential_flag dbname="rap_document_lookups.confidential_flag" ) column=(type=char(50) updatewhereclause=yes name=bookmark_level_type dbname="rap_sources.name" ) column=(type=char(15) updatewhereclause=yes name=bookmark_reference_id dbname="rap_sources.id" ) column=(type=char(15) updatewhereclause=yes name=bookmark_reference_id2 dbname="rap_sources.operator_id" ) column=(type=decimal(0) update=yes updatewhereclause=yes key=yes name=raDAT*Tp_document_lookups_rid dbname="rap_document_lookups.rid" ) column=(type=decimal(0) update=yes updatewhereclause=yes name=rap_document_lookups_document_rid dbname="rap_document_lookups.document_rid" ) column=(type=decimal(0) update=yes updatewhereclause=yes name=rap_document_lookups_form_rid dbname="rap_document_lookups.form_rid" ) column=(type=decimal(0) update=yes updatewhereclause=yes name=rap_document_lookups_ref_rid dbname="rap_document_lookups.ref_rid" ) column=(type=decimal(0) updateDAT*V=yes updatewhereclause=yes name=rap_document_lookups_application_rid dbname="rap_document_lookups.application_rid" ) column=(type=char(3) update=yes updatewhereclause=yes name=rap_document_lookups_bookmark_level_type dbname="rap_document_lookups.bookmark_level_type" ) column=(type=decimal(0) update=yes updatewhereclause=yes name=rap_document_lookups_bookmark_ref_rid dbname="rap_document_lookups.bookmark_ref_rid" ) retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"rap_applications~" ) TABLE(NAME=DAT*X~"rap_document_lookups~" ) TABLE(NAME=~"rap_documents~" ) TABLE(NAME=~"rap_forms~" ) TABLE(NAME=~"rap_legal_entities~" ) TABLE(NAME=~"rap_activities~" ) TABLE(NAME=~"rap_devices~" ) TABLE(NAME=~"rap_processes~" ) TABLE(NAME=~"rap_streams~" ) TABLE(NAME=~"rap_sources~" ) COLUMN(NAME=~"rap_document_lookups.image_id~") COLUMN(NAME=~"rap_document_lookups.page_no~") COLUMN(NAME=~"rap_applications.id~") COLUMN(NAME=~"rap_forms.id~") COLUMN(NAME=~"rap_document_lookups.start_date~") COLUMN(NAME=~"rap_docuDAT*Zment_lookups.level_type~") COLUMN(NAME=~"rap_document_lookups.end_date~") COLUMN(NAME=~"rap_devices.id~") COLUMN(NAME=~"rap_processes.id~") COLUMN(NAME=~"rap_streams.id~") COLUMN(NAME=~"rap_activities.metric_code~") COLUMN(NAME=~"rap_activities.start_date_time~") COLUMN(NAME=~"rap_activities.data_code~") COLUMN(NAME=~"rap_activities.end_date_time~") COLUMN(NAME=~"rap_activities.material_code~") COLUMN(NAME=~"rap_activities.reference_code~") COLUMN(NAME=~"rap_activities.value_type~") COLUMN(NAME=~"DAT*\rap_document_lookups.description~") COLUMN(NAME=~"rap_document_lookups.user_id~") COLUMN(NAME=~"rap_legal_entities.name~") COLUMN(NAME=~"rap_document_lookups.stream_flag~") COLUMN(NAME=~"rap_document_lookups.confidential_flag~") COLUMN(NAME=~"rap_sources.name~") COLUMN(NAME=~"rap_sources.id~") COLUMN(NAME=~"rap_sources.operator_id~") COLUMN(NAME=~"rap_document_lookups.rid~") COLUMN(NAME=~"rap_document_lookups.document_rid~") COLUMN(NAME=~"rap_document_lookups.form_rid~") COLUMN(NAME=~"rap_documentDAT*^_lookups.ref_rid~") COLUMN(NAME=~"rap_document_lookups.application_rid~") COLUMN(NAME=~"rap_document_lookups.bookmark_level_type~") COLUMN(NAME=~"rap_document_lookups.bookmark_ref_rid~") JOIN (LEFT=~"rap_document_lookups.document_rid~" OP =~"=~"RIGHT=~"rap_documents.rid~" ) JOIN (LEFT=~"rap_document_lookups.form_rid~" OP =~"=~"RIGHT=~"rap_forms.rid~" ) JOIN (LEFT=~"rap_applications.legal_entity_rid~" OP =~"=~"RIGHT=~"rap_legal_entities.rid~" ) JOIN (LEFT=~"rap_documents.application_rid~" OP =~"=~"DAT*`RIGHT=~"rap_applications.rid~" ) JOIN (LEFT=~"rap_document_lookups.ref_rid~" OP =~"=~"RIGHT=~"rap_activities.rid~" ) JOIN (LEFT=~"rap_activities.ref_rid~" OP =~"=~"RIGHT=~"rap_streams.rid~" ) JOIN (LEFT=~"rap_streams.from_process_rid~" OP =~"=~"RIGHT=~"rap_processes.rid~" ) JOIN (LEFT=~"rap_processes.device_rid~" OP =~"=~"RIGHT=~"rap_devices.rid~" ) JOIN (LEFT=~"rap_sources.rid~" OP =~"=~"RIGHT=~"rap_applications.source_rid~" )) " update="rap_document_lookups" updatewhere=0 updatekeyinplace=no ) DAT*btext(band=header alignment="0" text="Document Lookups"border="0" color="8388608" x="23" y="24" height="80" width="782" font.face="MS Sans Serif" font.height="-12" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) text(band=detail alignment="1" text="Material Code:"border="0" color="8388608" x="1970" y="736" height="52" width="439" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.DAT*dcharset="0" background.mode="1" background.color="553648127" ) column(band=detail id=15 alignment="0" tabsequence=150 border="5" color="0" x="2437" y="736" height="64" width="841" format="[general]" name=rap_activities_material_code edit.limit=12 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detaiDAT*fl alignment="1" text="Reference Code:"border="0" color="8388608" x="1893" y="836" height="52" width="517" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) column(band=detail id=16 alignment="0" tabsequence=160 border="5" color="0" x="2437" y="836" height="64" width="841" format="[general]" name=rap_activities_reference_code edit.limit=12 edit.case=upper edit.autoselect=yes edit.nilisnDAT*hull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Value Type:"border="0" color="8388608" x="2043" y="936" height="52" width="366" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) column(band=detail id=17 alignmDAT*jent="0" tabsequence=170 border="5" color="0" x="2437" y="936" height="64" width="233" format="[general]" name=rap_activities_value_type edit.limit=3 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Device Id:"border="0" color="8388608" x="2085" y="40" height="52" width="325"DAT*l font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) column(band=detail id=8 alignment="0" tabsequence=80 border="5" color="0" x="2437" y="40" height="64" width="690" format="[general]" name=rap_devices_id edit.limit=15 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" DAT*nfont.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Process Id:"border="0" color="8388608" x="2066" y="136" height="52" width="343" name=rap_document_lookups_ref_rid_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=9 alignment="0" tabsequence=90 border="5" color="0" x="2437" y="136" height="64" width="690" foDAT*prmat="[general]" name=rap_processes_id edit.limit=15 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Stream Id:"border="0" color="8388608" x="2098" y="232" height="52" width="311" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" DAT*rfont.charset="0" background.mode="1" background.color="553648127" ) column(band=detail id=10 alignment="0" tabsequence=100 border="5" color="0" x="2437" y="232" height="64" width="690" format="[general]" name=rap_streams_id edit.limit=20 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignmeDAT*tnt="1" text="Metric Code:"border="0" color="8388608" x="2021" y="332" height="52" width="389" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) column(band=detail id=11 alignment="0" tabsequence=110 border="5" color="0" x="2437" y="332" height="64" width="841" format="[general]" name=rap_activities_metric_code edit.limit=12 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.auDAT*vtohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Start Date Time:"border="0" color="8388608" x="1906" y="428" height="52" width="503" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) column(band=detail id=12 alignment="0" taDAT*xbsequence=120 border="5" color="0" x="2437" y="428" height="64" width="393" format="[shortdate] [time]" name=rap_activities_start_date_time edit.limit=0 edit.case=any edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Data Code:"border="0" color="8388608" x="2066" y="524" height="52" width="3DAT*z43" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) column(band=detail id=13 alignment="0" tabsequence=130 border="5" color="0" x="2437" y="524" height="64" width="297" format="[general]" name=rap_activities_data_code edit.limit=4 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" DAT*|font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="End Date Time:"border="0" color="8388608" x="1938" y="636" height="52" width="471" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) column(band=detail id=14 alignment="0" tabsequence=140 border="5" color="0" x="2437" y="636" height="64" width="393" format="[shortdate]DAT*~ [time]" name=rap_activities_end_date_time edit.limit=0 edit.case=any edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Image Id:"border="0" color="8388608" x="361" y="40" height="52" width="293" name=rap_document_lookups_image_id_t font.face="MS Sans Serif" font.height="-8" font.weight="7DAT*00" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="Page No:"border="0" color="8388608" x="375" y="136" height="52" width="279" name=rap_document_lookups_page_no_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="Application Id:"border="0" color="8388608" x="2DAT*01" y="232" height="52" width="453" name=rap_applications_id_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="Form Id:"border="0" color="8388608" x="407" y="332" height="52" width="247" name=rap_forms_id_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" backgroundDAT*.color="536870912" ) text(band=detail alignment="1" text="Start Date:"border="0" color="8388608" x="320" y="428" height="52" width="334" name=rap_document_lookups_start_date_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="Keyword Level Type:"border="0" color="8388608" x="23" y="524" height="52" width="631" name=rap_document_lookups_level_type_DAT*t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="End Date:"border="0" color="8388608" x="352" y="636" height="52" width="302" name=rap_document_lookups_end_date_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=DAT*1 alignment="0" tabsequence=10 border="5" color="0" x="681" y="40" height="64" width="1029" format="[general]" name=rap_document_lookups_image_id edit.limit=20 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(band=detail id=2 alignment="1" tabsequence=20 border="5" color="0" x="681" y="136" height="64" wDAT*idth="274" format="[general]" name=rap_document_lookups_page_no edit.limit=4 edit.case=any edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(band=detail id=3 alignment="0" tabsequence=30 border="5" color="0" x="681" y="232" height="64" width="1029" format="[general]" name=rap_applications_id edit.limit=20 edit.case=uppeDAT*r edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(band=detail id=4 alignment="0" tabsequence=40 border="5" color="0" x="681" y="332" height="64" width="1029" format="[general]" name=rap_forms_id edit.limit=20 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.heiDAT*ght="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(band=detail id=5 alignment="0" tabsequence=50 border="5" color="0" x="681" y="428" height="64" width="370" format="[general]" name=rap_document_lookups_start_date edit.limit=0 edit.case=any edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" backgrDAT*ound.mode="2" background.color="16777215" ) column(band=detail id=6 alignment="0" tabsequence=60 border="5" color="0" x="681" y="524" height="64" width="530" format="[general]" name=rap_document_lookups_level_type edit.limit=10 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(band=detail id=7 alignment=DAT*"0" tabsequence=70 border="5" color="0" x="681" y="636" height="64" width="357" format="[general]" name=rap_document_lookups_end_date edit.limit=0 edit.case=any edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Description:"border="0" color="8388608" x="338" y="1056" height="52" width="366" DAT* name=rap_document_lookups_description_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=18 alignment="0" tabsequence=180 border="5" color="0" x="731" y="1052" height="64" width="1961" format="[general]" name=rap_document_lookups_description edit.limit=50 edit.case=any edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.heDAT*ight="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="User Id:"border="0" color="8388608" x="457" y="1144" height="52" width="247" name=rap_document_lookups_user_id_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=19 alignment="0" tabsequence=190 bordeDAT*r="5" color="0" x="731" y="1140" height="64" width="1170" format="[general]" name=rap_document_lookups_user_id edit.limit=30 edit.case=any edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Legal Entity Name:"border="0" color="8388608" x="123" y="1232" height="52" width="581" name=rap_legal_DAT*entities_name_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=20 alignment="0" tabsequence=200 border="5" color="0" x="731" y="1228" height="64" width="1961" format="[general]" name=rap_legal_entities_name edit.limit=50 edit.case=upper edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" fonDAT*t.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Confidential:"border="0" color="8388608" x="320" y="1316" height="52" width="384" name=rap_document_lookups_confidential_flag_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=22 alignment="0" tabsequence=32766 border="5" color="0"DAT* x="731" y="1316" height="56" width="82" format="[general]" name=rap_document_lookups_confidential_flag edit.limit=0 edit.case=any edit.autoselect=yes font.face="Arial" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Stream Flag:"border="0" color="8388608" x="325" y="1396" height="52" width="379" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2"DAT* font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=21 alignment="0" tabsequence=32766 border="5" color="0" x="731" y="1392" height="56" width="82" format="[general]" name=rap_document_lookups_stream_flag edit.limit=0 edit.case=any edit.autoselect=yes font.face="Arial" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="BooDAT*kmark Level Type:"border="0" color="8388608" x="87" y="1472" height="52" width="617" name=bookmark_level_type_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=23 alignment="0" tabsequence=32766 border="5" color="0" x="731" y="1472" height="52" width="1399" format="[general]" name=bookmark_level_type edit.limit=0 edit.case=any edit.autoselect=yes font.face="MSDAT* Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Bookmark Reference ID:"border="0" color="8388608" x="50" y="1548" height="52" width="654" name=bookmark_reference_id_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=24 alignmentDAT*="0" tabsequence=32766 border="5" color="0" x="731" y="1548" height="52" width="443" format="[general]" name=bookmark_reference_id edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="1" text="Bookmark Reference ID 2:"border="0" color="8388608" x="5" y="1624" height="52" width="699" name=bookmark_reference_id2_t fDAT*ont.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=25 alignment="0" tabsequence=32766 border="5" color="0" x="731" y="1624" height="52" width="443" format="[general]" name=bookmark_reference_id2 edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode=DAT*x"2" background.color="16777215" ) htmltable(border="1" cellpadding="0" cellspacing="0" generatecss="no" nowrap="yes") DAT*:)t_lookups.bookmark_level_type") COLUMN(NAME="rap_document_lookups.bookmark_ref_rid") JOIN (LEFT="rap_document_lookups.document_rid" OP ="="RIGHT="rap_documents.rid" ) JOIN (LEFT="rap_document_lookups.form_rid" OP ="="RIGHT="rap_forms.rid" ) JOIN (LEFT="rap_applications.legal_entity_rid" OP ="="RIGHT="rap_legal_entities.rid" ) JOIN (LEFT="rap_documents.application_rid" OP ="="RIGHT="rap_applications.rid" ) JOIN (LEFT="rap_document_lookups.ref_rid" OP ="="RIGHT="rap_activities.rid" ) JOIN (LEFT="rapDAT*PDW0800pdw+r!"q````4 F$kkaaDAT* @w`DAT* < $0% MS Sans SerifMS Sans Serif$ 2$ -12$700$ 12632256$8388608$$DAT*36$ 32$Q81$971%AIRCRAFT CATEGORIESAIRCRAFT CATEGORIES$  536870912@@#h`5$"%((*,.02scc_ams_code_t<DAT* & $'-8$)1$+18$-Z346$/452$1420%34Scc Ams Code:Scc Ams Code:`@#6"%((79.;=code_t$8DAT*274$:3$<164%>?Code:Code:`K5A"%((BD.FHdescription_t$Cd100$Ev118$GR338%IJ Description: Description:[@L"% MO9QDAT*SUW (Zcode$N 16777215$P466$RA65$TY601$V5&XY [general] [general]bK\"% MO]_SUW(a device_codDAT*e$^230$`D68e[c"% MO,QSUW((d scc_ams_codehbf"% MODQSUW(g description`ei"%((j].lDAT*ndevice_code_t$k=61$my377%op Device Code: Device Code:@Dts@DAT*wKuvzexy@}[{|@b~ @rap_aircraft_categoriescoderap_aircraft_categories.codeK description$rap_aircraft_categories.descriptioneDAT* device_code$rap_aircraft_categories.device_code[ scc_ams_code%rap_aircraft_categories.scc_ams_codebPBSELECT( VERSION(400) TABLE(NAME="rap_aircraft_categories" ) COLUMN(NAME="rap_aircraft_categories.code") COLUMN(NAME="rap_aircraft_categories.description") COLUMN(NAME="rap_aircraft_categories.device_code") COLUMN(NAME="rap_aircraft_categories.scc_ams_code")) DAT*release 5; datawindow(units=0 timer_interval=0 color=12632256 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 107 print.margin.right = 107 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no ) header(height=119 color="536870912" ) summary(height=1 color="536870912" ) footer(height=1 color="536870912" ) detail(height=426 color="536870912" ) table(column=(type=char(2) update=yes updatewhereclause=yes key=yes naDAT*me=code dbname="rap_aircraft_categories.code" ) column=(type=char(30) update=yes updatewhereclause=yes name=description dbname="rap_aircraft_categories.description" ) column=(type=char(15) update=yes updatewhereclause=yes name=device_code dbname="rap_aircraft_categories.device_code" ) column=(type=char(10) update=yes updatewhereclause=yes name=scc_ams_code dbname="rap_aircraft_categories.scc_ams_code" ) retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"rap_aircraft_categories~" ) COLUMN(NAME=~DAT*"rap_aircraft_categories.code~") COLUMN(NAME=~"rap_aircraft_categories.description~") COLUMN(NAME=~"rap_aircraft_categories.device_code~") COLUMN(NAME=~"rap_aircraft_categories.scc_ams_code~")) " update="rap_aircraft_categories" updatewhere=1 updatekeyinplace=yes ) text(band=header alignment="0" text="AIRCRAFT CATEGORIES"border="0" color="8388608" x="36" y="32" height="81" width="971" font.face="MS Sans Serif" font.height="-12" font.weight="700" font.family="2" font.pitch="2" font.charset="0" bDAT*ackground.mode="2" background.color="12632256" ) text(band=detail alignment="1" text="Scc Ams Code:"border="0" color="8388608" x="18" y="346" height="52" width="420" name=scc_ams_code_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="Code:"border="0" color="8388608" x="274" y="3" height="52" width="164" name=code_t font.face="MS Sans Serif" fonDAT*t.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="Description:"border="0" color="8388608" x="100" y="118" height="52" width="338" name=description_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=1 alignment="0" tabsequence=10 border="5" colorDAT*="0" x="466" y="3" height="65" width="601" format="[general]" name=code edit.limit=2 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(band=detail id=3 alignment="0" tabsequence=30 border="5" color="0" x="466" y="230" height="68" width="601" format="[general]" name=device_code edit.limit=15 edit.case=aDAT*ny edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(band=detail id=4 alignment="0" tabsequence=40 border="5" color="0" x="466" y="346" height="65" width="601" format="[general]" name=scc_ams_code edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" foDAT*nt.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(band=detail id=2 alignment="0" tabsequence=20 border="5" color="0" x="466" y="118" height="65" width="601" format="[general]" name=description edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.modeDAT*Q="2" background.color="16777215" ) text(band=detail alignment="1" text="Device Code:"border="0" color="8388608" x="61" y="230" height="52" width="377" name=device_code_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) DAT*PDW0800pdw+!"```` F$ kkaaDAT* @|`DAT* < $0% MS Sans SerifMS Sans Serif$ 2$ -12$700$ 12632256$8388608$DAT*18$20$P80$1513%AIRCRAFT DEFAULT TIME IN MODEAIRCRAFT DEFAULT TIME IN MODE$  536870912@@(#~`5$"%((*,.02 DAT*time_amt_t< & $'-8$)1$+W343$-\348$/452$1279%34 Time Amt: Time Amt:`@#6"%((79.;=time_unit_code_t$8DAT*169$:464$<453%>?Time Unit Code:Time Unit Code:`K5A"%((BD.FHaircraft_category_code_t$C23$E4$GW599%IJAircraft Category Code:Aircraft Category CDAT*ode:`V@L"%((MO.QS mode_type_t$N%293$Px120$RI329%TU Mode Type: Mode Type:``K"%((WY.[]$Xi361$Z232$\DAT*261%^_ EPA Date: EPA Date:pVa"% bd,fh(jl((o time_amt$c 16777215$e663$gD68$i471$k5&mn [General] [General]xDAT*`q"% bd9rhjt2(wtime_unit_code$s@64&uv [general] [general]{py"% bdDrhjt (zaircraft_category_code~x|"% bdOrDAT*hjt(} mode_type{"% bdrhj epa_date$236& mm/dd/yyyy mm/dd/yyyy@DAT*@x{~ `DAT* @p @rap_aircraft_time_in_modesaircraft_category_code2rap_aircraft_time_in_modes.aircraft_category_codex mode_type%rap_aircraft_time_in_modes.mode_type{ epa_date$rap_aircraft_time_in_modes.epa_date~ time_amt$rap_aircraft_time_in_modes.time_amt`time_unit_code*rap_aircraft_time_in_modes.time_unit_codeDAT*pWPBSELECT( VERSION(400) TABLE(NAME="rap_aircraft_time_in_modes" ) COLUMN(NAME="rap_aircraft_time_in_modes.aircraft_category_code") COLUMN(NAME="rap_aircraft_time_in_modes.mode_type") COLUMN(NAME="rap_aircraft_time_in_modes.epa_date") COLUMN(NAME="rap_aircraft_time_in_modes.time_amt") COLUMN(NAME="rap_aircraft_time_in_modes.time_unit_code")) ("no"yesDAT*release 6; datawindow(units=0 timer_interval=0 color=12632256 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 107 print.margin.right = 107 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no ) header(height=124 color="536870912" ) summary(height=0 color="536870912" ) footer(height=0 color="536870912" ) detail(height=552 color="536870912" ) table(column=(type=char(2) uDAT*pdate=yes updatewhereclause=yes key=yes name=aircraft_category_code dbname="rap_aircraft_time_in_modes.aircraft_category_code" ) column=(type=char(6) update=yes updatewhereclause=yes key=yes name=mode_type dbname="rap_aircraft_time_in_modes.mode_type" ) column=(type=date update=yes updatewhereclause=yes key=yes name=epa_date dbname="rap_aircraft_time_in_modes.epa_date" ) column=(type=decimal(6) update=yes updatewhereclause=yes name=time_amt dbname="rap_aircraft_time_in_modes.time_amt" ) coDAT*lumn=(type=char(8) update=yes updatewhereclause=yes name=time_unit_code dbname="rap_aircraft_time_in_modes.time_unit_code" ) retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"rap_aircraft_time_in_modes~" ) COLUMN(NAME=~"rap_aircraft_time_in_modes.aircraft_category_code~") COLUMN(NAME=~"rap_aircraft_time_in_modes.mode_type~") COLUMN(NAME=~"rap_aircraft_time_in_modes.epa_date~") COLUMN(NAME=~"rap_aircraft_time_in_modes.time_amt~") COLUMN(NAME=~"rap_aircraft_time_in_modes.time_unit_code~")) " update="rDAT*ap_aircraft_time_in_modes" updatewhere=1 updatekeyinplace=yes ) text(band=header alignment="0" text="AIRCRAFT DEFAULT TIME IN MODE"border="0" color="8388608" x="18" y="20" height="80" width="1513" font.face="MS Sans Serif" font.height="-12" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="12632256" ) text(band=detail alignment="1" text="Time Amt:"border="0" color="8388608" x="343" y="348" height="52" width="279" name=time_amt_t font.faceDAT*="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="Time Unit Code:"border="0" color="8388608" x="169" y="464" height="52" width="453" name=time_unit_code_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="AircraDAT*ft Category Code:"border="0" color="8388608" x="23" y="4" height="52" width="599" name=aircraft_category_code_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="Mode Type:"border="0" color="8388608" x="293" y="120" height="52" width="329" name=mode_type_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2"DAT* font.charset="0" background.mode="1" background.color="536870912" ) text(band=detail alignment="1" text="EPA Date:"border="0" color="8388608" x="361" y="232" height="52" width="261" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=4 alignment="1" tabsequence=40 border="5" color="0" x="663" y="348" height="68" width="471" format="[General]" name=time_amt edit.liDAT*mit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(band=detail id=5 alignment="0" tabsequence=50 border="5" color="0" x="663" y="464" height="64" width="471" format="[general]" name=time_unit_code edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face=DAT*"MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) column(b