* class_id class_name class_code stat ordering

* annual_inspection_no annual_inspection_code series_no annual_inspection_date bus_app_id bus_owner_id char_of_occupancy_id classification_id recommendations remarks issued_date inspection_date application_status savedate with_bp bp_id bp_no bp_date char_of_occupancy classification no_of_storeys no_of_unit total_area date_of_completion owner_type owner_id owner_name owner_address storage_combustible projectid projectname projectaddress ctc_no ctc_date ctc_place permit_name cert_type chief_and_proc_eval chief_enforecement_eval isLastYear loadPrevBill

* application_no td_no application_status applicant_type applicant_id application_code area_code application_save_date applicant_address lot_no blk_no tct_no property_st property_brgy property_city with_td indigens_status with_bp bldg_id insp_id savedate status user_id permit_type permit_code bldg_code bldg_permit_id

* pkid application_no notary_citymun notary_location notary_date notary_id notary_name notary_year doc_no page_no book_no series_no savedate status permit_type

* id application_no permit_type mat_wood mat_concrete mat_steel mat_mixed mat_others mat_specify cost1 cost2 cost3 cost4 cost5 cost6 cost_total savedate status

* dtl_id application_no zoning_no subd_no date_of_entry area_no_prov_code area_no_bgry_code establishment_name scope_of_work char_of_occupancy occupancy_classified no_of_storey no_of_units total_estmtd_cst proposed_date_of_const expected_date_of_comp bldg_classification total_flr_area savedate status permit_type

* dtl_id application_no owner_id owner_tin owner_type owner_bid owner_businesstype occupancy brgy_id address tel_no status permit_type owner_prefix owner_firstname owner_middlename owner_lastname owner_suffix owner_ppid owner_businessname addr_no addr_st addr_brgy addr_citymun addr_prov addr_zipcode

* id application_no permit_type measure_length measure_height measure_area measure_others total_connected_load total_transformer total_generator savedate

* id application_no permit_type process_id process_name datetime_in datetime_out process_by process_emp savedate

* id new_application_no old_application_no ts status type_

* id application_no application_stat date_ user_id remarks ts stat

* id evaluation_id app_date refno referenceno appno projectID projectName projectLoc total_area total_lots applicantID applicantName app_address app_tellno nature_alteration evaluation_ decision_ cond1 cond2 cond3 cond4 cond5 cond6 cond7 devID devName alt_type authorityby authorityname issue_by stat timestamp permit_name alter_type

* id palc_type palc_id evaluation_id app_date refno clearanceno applicationno referenceno projectID projectName projectLoc projectTel applicantID applicantName app_address app_tellno app_type affected_area lot_no block_no total_area total_lots projectclass rightoverland issue_by purpose evaluation_facts decision_ conditions1 conditions2 conditions3 conditions4 conditions5 conditions6 conditions7 authorityby authorityname toID toName toPosition devID devName devAddress devTelNo devType devPermit stat timestamp

* id evaluation_id app_date refno appno projectID projectName projectLoc total_area total_lots applicantID applicantName app_address app_tellno businesss_number business_name bus_address purpose_ purpose_remarks notaryby notaryname docno pageno bookno seriesno res_no issued_date issue_by approve_date approve_by rightoverland clearances zone_class proj_class vicinity evaluation decision conditions1 conditions2 conditions3 conditions4 subd_approved remarks stat timestamp

* id mainid req_id req_name cnt ts

* id evaluation_id app_date refno appno projectID projectName projectLoc total_area total_lots toID toName toPosition applicantID applicantName app_address app_tellno res_no issue_by issued_date approve_date approve_by rightoverland clearances zone_class proj_class vicinity evaluation decision conditions1 conditions2 conditions3 conditions4 subd_approved remarks stat timestamp

* id mainid req_id req_name cnt ts

* id palc_type palc_id evaluation_id app_date refno clearanceno applicationno referenceno projectID projectName projectLoc projectTel applicantID applicantName app_address app_tellno app_type total_area total_lots projectclass rightoverland issue_by purpose evaluation_facts decision_ conditions1 conditions2 conditions3 conditions4 conditions5 conditions6 authorityby authorityname toID toName toPosition devID devName devAddress devTelNo devType devPermit stat timestamp

* id evaluation_id app_date refno appno projectID projectName projectLoc total_area total_lots applicantID applicantName app_address app_tellno businesss_number business_name bus_address purpose_ purpose_remarks notaryby notaryname docno pageno bookno seriesno res_no issued_date issue_by approve_date approve_by rightoverland clearances zone_class proj_class vicinity evaluation decision conditions1 conditions2 conditions3 conditions4 subd_approved remarks stat timestamp

* id mainid req_id req_name cnt ts

* id evaluation_id app_date refno appno projID projname projloc to_id to_name to_position total_area total_lots applicantID applicantName app_address app_tellno res_no approveby approve_by issue_by issued_date approve_date docno pageno bookno seriesof remarks rightoverland clearances zone_class proj_class vicinity evaluation decision conditions1 conditions2 conditions3 conditions4 subd_approved stat timestamp

* id mainid req_id req_name cnt ts

* id evaluation_id app_date projectID projectName to_id to_name to_position to_municipality total_area total_lots applicantID applicantName app_address app_tellno approveby issue_by stat timestamp

* id palc_pkid evaluation_id app_date refno projectID projectName projectLoc projectDesc tctno rightoverland businessNumber businessID businessName ownerid ownername capitalization autorized subscribe paidup contractorId contractorName brokerID brokerName total_area applicantID applicantName app_position app_address app_status app_tellno docno pageno bookno seriesof notaryId notaryName PALCno Dominant evaluation_facts decision_ b_clearance condition1 condition2 condition3 condition4 authorityby authorityname dpTYPE approveby issue_by stat timestamp permit_name

* id evaluation_id app_date refno projectID projectName projectLoc total_area total_lots businesss_number business_name bus_address applicantID applicantName app_address app_tellno purpose_ purpose_remarks notaryby notaryname docno pageno bookno seriesno res_no issued_date issue_by approve_date approve_by rightoverland clearances zone_class proj_class vicinity evaluation decision conditions1 conditions2 conditions3 conditions4 subd_approved appno remarks stat timestamp

* id mainid req_id req_name cnt ts

* id evaluation_id app_date refno appno projectID projectName projectLoc total_area total_lots businesss_number business_name bus_address applicantID applicantName app_address app_tellno purpose_ purpose_remarks notaryby notaryname docno pageno bookno seriesno res_no issued_date issue_by approve_date approve_by rightoverland clearances zone_class proj_class vicinity evaluation decision conditions1 conditions2 conditions3 conditions4 subd_approved remarks stat timestamp

* id mainid req_id req_name cnt ts

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position building_id bns_id date_save project_id project_name form_type char_occupancy

* bill_id permit_id permit_type payable application_type status savedate

* pkid main_id transaction_type ref_id bill_id div_no sub_div_no ts

* pkid main_id permit_no div_no sub_div_no Section Description Remarks UoM Qty Total range_from range_to fee function permit_type add_on income_code income_account trans_type fee_type unit_qty submain_id Datagrouping InspectionName application_no function1 keyFieldId parentDescription isLock excess additional islocal_rev ts withpercent

* pkid main_id permit_no div_no sub_div_no Section Description Remarks UoM Qty Total range_from range_to fee function permit_type add_on income_code income_account trans_type fee_type unit_qty submain_id Datagrouping InspectionName application_no function1 keyFieldId parentDescription isLock excess additional islocal_rev ts withpercent

* id main_id transaction_type ref_id bill_id div_no sub_div_no sub_sub_div_no ts

* main_id project_id project_name project_owner project_location project_date app_id app_type app_type_id app_by permit_type status ts transaction_type

* main_id project_id project_name project_owner project_location project_date app_id app_type app_type_id app_by permit_type status ts transaction_type

* pkid application_no permit_type type_id type_name type_remarks type_additional status savedate

* pkid application_no permit_type type_id type_name type_remarks type_additional status savedate

* pkid application_no nature_id nature_name nature_remarks status savedate

* pkid application_no scope_id scope_name scope_remarks permit_type status savedate

* pkid application_no permit_type sig_id sig_name sig_date sig_count sig_remarks status savedate

* administration_no administration

* Construction_id Type_ stat timestamp

* bridge_no refno date_ inventorydate bridge_name bridge_station administration_no type_of_construcation length_ width_ load_capacity physical_condition remarks condition_ bridge_type bridge_other stat timestamp

* id main_id From_RoadId From_RoadName From_brgyID From_brgyname To_RoadId To_RoadName To_brgyID To_brgyname

* physical_condition_no physical_condition_legend physical_condition_detail timestamp stat

* pkid btype status ts

* pkid user_id user_name application_no permit_type ts

* bp_no project_id project_name app_no bp_status bp_id generated_bpid date_issued bp_type or_no or_date issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position td_id savedate indigenous indigenous_id isBluePrint

* id section_id section_count section_name with_sub sub_remarks main_violation main_remarks sub_violation remarks freq_type freq_desc with_fines amt_fines accnt_code accnt_desc orderBy stat ts

* id main_id violation_id section_id section_count section_name with_sub sub_remarks main_violation main_remarks sub_violation sub_others remarks freq_type with_fines amt_fines stat ts

* id ref_no app_date owner_type owner_id owner_name proj_brgy proj_id proj_name proj_address remarks frequency total_amount inspectedBy inspectedDate receiver receivedBy receivedDate building_official chief_enforcement stat transType ts isWaiveWObill

* pkid application_no building_id project_id project_name fsec_no fsec_date ts app_type

* annual_inspection_no annual_status annual_inspection_code series_no annual_inspection_date owner_type bus_number business_address owner_id owner_name owner_address applicantID applicantName inspection_date with_bp bp_no bp_id bp_date char_group char_of_occupancy total_connected total_transformer total_generator voltage phase grounding_wire sv_type sv_name sv_nameid sv_prc sv_prt sv_issuedat sv_dateissued sv_valid date_of_completion project_id project_name project_address permit_name mode_payment application_status savedate

* annual_inspection_no annual_inspection_code annual_inspection_date annual_appstatus occupancy_permit_no issued_status issued_date bp_no bp_date series_no bus_app_id bus_owner_id char_of_occupancy_id classification_id recommendations remarks inspection_date with_bp bp_id plan_type char_of_occupancy classification group_name no_of_storeys no_of_unit total_area date_of_completion owner_type applicantID owner_address owner_id owner_name project_id project_name project_address ctc_no ctc_date ctc_place permit_name cert_type mode_payment data_type bpnumber_type application_status savedate isDuplicate user_id

* id main_id application_no bpnumber bpissued ts

* id chk main_id req_id req_desc req_others savedate status

* annual_inspection_no annual_inspection_code series_no annual_inspection_date bus_app_id bus_owner_id char_of_occupancy_id classification_id recommendations remarks issued_date inspection_date application_status savedate with_bp bp_id bp_no bp_date char_of_occupancy classification no_of_storeys no_of_unit total_area date_of_completion owner_type owner_id owner_name owner_address project_id project_name project_address ctc_no ctc_date ctc_place permit_name cert_type

* id refno appdate barangayid application_type applicantid applicant_name applicant_add business_id business_name business_add permit_type remarks status ts

* id mainid type_ bp_number bp_issued pages ts

* annual_inspection_no annual_inspection_code series_no annual_inspection_date owner_type bus_number business_address char_of_occupancy applicantID applicantName owner_name owner_address owner_id bp_id bp_no bp_date bp_orno bp_paid occupancy_id occupancy_no occupancy_date occupancy_orno occupancy_paid date_of_completion project_id project_name project_address ctc_no ctc_date ctc_place permit_name cert_type with_bp mode_payment application_status savedate

* id main_id occupancy_exist occupancy_propos occupant_exist occupant_propos storey_exist storey_additional flr_exist flr_additional flr_affected construction_exist construction_propos

* id chk main_id req_id req_desc req_others savedate status

* char_of_occ_no group char_of_occ classification char_code

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save project_id project_name form_type

* id ref_no app_date owner_id business_id business_name owner_name to_position project_id project_name project_location thru_id thru_name thru_position thru_company_id thru_company_name from_id from_name from_position incharge_id incharge_name subject_name issue status uid noted_by

* id form_name project_id form_id ntp_date revised_contractdate revised_contractduration ts status

* id refno app_date projectID projectName projectLoc projContracid projContrac particular estVolume PouringSys reqStrength pouring_date pouring_start pouring_end reqby reqdate save_userID update_userID issued_by insp_by insp_date recomend Approved Approvedby Approve_date Approve_note Disapprove_due_to stat timestamp

* det_id main_id type_id remarks contractor LGU ts

* id main_id start_dt end_dt ts

* id _type

* permit_no permit_code application_no demolish_status date_issued bldg_official_id bldg_official_name bldg_official_date bldg_permit_no or_no or_date or_amount applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id action_taken demolition_period demolition_days date_save project_name project_id

* id evaluation_id app_date refno clearanceno projectID projectName projectLoc total_area total_lots applicantID applicantName app_address app_tellno purpose_ purpose_remarks notaryby notaryname docno pageno bookno seriesno issued_date issue_by PALCno evaluation_facts decision_ dpType condition1 condition2 condition3 condition4 condition5 condition6 authorityby authorityname devID devName stat timestamp

* id evaluation_id app_date refno clearanceno projectID projectName projectLoc total_area total_lots toID toName toPosition applicantID applicantName app_address app_tellno issue_by PALCno evaluation_facts decision_ dpType condition1 condition2 condition3 condition4 condition5 condition6 authorityby authorityname stat timestamp

* id palc_commercial_pk evaluation_id app_date refno clearanceno projectID projectName projectLoc total_area total_lots toID toName toPosition applicantID applicantName app_address app_tellno issue_by PALCNo evaluation_facts decision_ dpType condition1 condition2 condition3 condition4 condition5 condition6 authorityby authorityname devID devName stat timestamp

* div_no div_name div_detls permit_no fee range_from range_to function remarks permit_no2 function1 parentDescription excess additional islocal_rev exempt

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save bns_id project_id project_name indigenous_id form_type char_occupancy

* drainage_id refno date_ inventorydate RoadID BrgyID typeOfPavement concrete avsurface1 asphalt avsurface2 gravel earth avsurface3 length_ width_ type_ conditionlegend remarks drainage_con stat timestamp

* pkid refno drainage_type status ts

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save bns_id project_id project_name indigenous_id form_type char_occupancy

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save project_id project_name form_type char_occupancy

* permit_no permit_code application_no app_date date_issued bldg_official_id bldg_official_name bldg_permit_no applicant_id bp_id bns_id issued_to bldg_name category lights snap_switch con_outlets breakers controllers wattage conductor current_protection note voltage frequency phase nature_wiring remarks issued_id issued_by approveby dt_approve notedby BuildingType occupancy_id form_type OccNumberType project_name project_id status permit_name date_save

* id refno app_date projectID projectName projectLoc claimantID claimantname claimant_add engrID engrname regno ptrno lotno grossarea sale1 nonsale1 roadlot1 other1 surveyno sublots sale2 nonsale2 roadlot2 other2 doctype remarks evauluatedID evauluatedName eval_date notedby noted_date stat doc1 doc2 doc3 doc4 doc5 doc6

* permit_no permit_code application_no issued_status date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id date_save project_id project_name

* pkid application_no permit_type type_id type_name type_remarks type_additional status savedate

* permit_no permit_code application_no issued_status date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id project_id project_name date_save issued_by2 issued_id2 issued_position

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save project_id project_name form_type char_occupancy

* id ref_no app_date owner_id business_id business_name business_pos owner_name project_id project_name project_location thru_name thru_position thru_company_name from_name from_position incharge_id incharge_name subject_name issue status uid noted_by ts

* id main_id issues

* id refno app_date ownerID businessID businessName ownerName projectID projectName projectStart projectEnd days_delayed remaining_days location remarks update_userID save_userID notedID approvedID requested_by issued_by contractid contractname con_ownerid con_ownername accomp target_accomp tot_accomp proprietor prop_pos stat timestamp

* id refno app_date date_finished owner_id owner_name business_id business_name projectID projectName projectLoc save_userID update_userID issued_by insp_by noted_by stat timestamp submitted_date issues days_completed

* det_id main_id desc timestamp

* id refno app_date projectID projectName projectLoc contractor contractor_id to_id to_name thru_id thru_name prepby save_userID update_userID stat timestamp

* det_id main_id desc timestamp

* sig_type sig_id

* id type_id req_count req_desc order_by app_date timestamp stat

* id type_ order_by

* id main_id code_id code_tag code_regulation compliance ts

* id app_date eval_date permit_name application_no building_id application_tag eval_id eval_by remarks ts

* pkid code_id code_regulation permit_type st

* permit_no permit_type section_id section_description order_by input_type unit_measure Annual Building Indigenous Occupancy endorsement excavation notice dole

* permit_no permit_type

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save project_id project_name indigenous_id form_type char_occupancy

* id desc

* id project_id proj_incharge proj_incharge_id ts

* pkid application_no project_id project_name project_status project_date ts

* road_class_no refno Road_ RoadName date stat

* pkid refno road_type status ts

* road_direct_no refno Direction date stat

* LocalRoadID appdate inventorydate refno RoadID project_name project_id project_loc brgyID brgyName roadName roadClassID roadClassName RoadclassDesc lenght_ width_ cWay_width surfDR Gravel Conc Asphalt Earth Macad AvSurfCondID AvSurfCondName ADT PercentHeavy RoadImportance TerrainID TerrainName NoOfCulverts NoOfBridges Remarks no_carriageway c_kmpost_start c_kmpost_end c_length c_width c_no_lanes c_lane_leftwidth c_lane_rightwidth c_pavement_type c_pavement_thk c_pavement_strength c_const_date c_const_value c_year_construct c_useful_life c_shoulder_widthleft c_shoulder_widthright c_drainage_left c_drainage_right c_drainage_depth c_drainage_type c_drainage_type_sta c_drainage_remarks environment direction_flow rrow_acq_date rrow_acq_cost rrow_ul Stat _DT

* id roadID trans_date ref_no brgy_id brgy_name streetname no_of_carriageway km1_latitude km1_longitude km1_station km2_latitude km2_longitude km2_station km3_latitude km3_longitude km3_station km4_latitude km4_longitude km4_station status date_save

* road_pavement_no refno pavement_type date stat

* road_terrain_no refno road_terrain road_terrain_description date stat timestamp

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save project_id project_name form_type char_occupancy

* permit_no permit_code application_no issued_status date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id date_save project_id project_name

* id refno app_date ownerID ownerName businessID businessName projectID projectName projectDesc projectLoc projectEnd accomplishment target_accomplishment remarks PInChargeID PInChargeName NotedBy Approvedby save_userID update_userID issued_by stat timestamp

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id date_save project_id project_name repair_ sqm_meter premises pursuant ts

* sig_no application_no person_id person_name title_no st_no sig_date sig_prc_no sig_prc_date sig_ptr_no sig_ptr_date sig_ptr_place sig_tin_no sig_ctc_no sig_ctc_date sig_ctc_place validity sig_tel_no permit_type sig_add_no sig_add_place sig_add_date title_position sig_type status savedate

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save project_id project_name form_type

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save bns_id project_id project_name indigenous_id form_type char_occupancy

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save project_id project_name form_type char_occupancy

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id date_save project_id project_name

* application_no granted address construct word_ premises

* pkid appdate inspectdate palc_id palc_formname app_id app_name location findings recommend inspectby noted_by status ts

* id mainid lotno faas_id remarks ts

* pole_id date_of_entry refno pole_no pole_owner pole_type diameter height classification RoadId purok sitio subdivision bgryID brgyName remarks stat _DT

* det_id date_installed pole_id fixturesID fixtures qty wattages rate operation busted_ remarks timestamp stat

* det_id date_installed pole_id fixturesID fixtures qty wattages rate operation busted_ remarks timestamp stat change_type

* id fixtures_name

* div_no div_name div_detls permit_no fee range_from range_to function remarks permit_no2 function1 parentDescription excess additional islocal_rev

* sub_div_no div_no sub_div_name sub_div_dtls fee unit range_from range_to type_of_computation unit2 function add_on unit_qty compute_fifty_percent function1 parentDescription excess additional islocal_rev

* sub_sub_div_no div_no sub_div_no sub_div_name sub_div_dtls fee unit range_from range_to type_of_computation unit2 function add_on unit_qty compute_fifty_percent function1 parentDescription excess additional islocal_rev

* sub_sub_sub_div_no div_no sub_sub_div_no sub_div_no sub_div_name sub_div_dtls fee unit range_from range_to type_of_computation unit2 function add_on unit_qty compute_fifty_percent function1 parentDescription excess additional islocal_rev

* id palc_pkid Subd_id Subd_type app_date refno projectID projectName projectLoc tctno total_area total_lots applicantID applicantName app_address app_tellno purpose others decision remarks conditions rightoverland clearances site_zoning proj_class authorityby authorityname issue_by vicinity facts_eval decision_eval conditions1 conditions2 conditions3 conditions4 stat timestamp permit_name

* pkid main_id permit_no div_no sub_div_no Section Description Remarks UoM Qty Total range_from range_to fee function permit_type add_on income_code income_account trans_type fee_type unit_qty submain_id Datagrouping InspectionName application_no function1 keyFieldId parentDescription isLock excess additional islocal_rev ts status

* main_id project_id project_name project_owner project_location project_date app_id app_type app_type_id app_by permit_type status ts transaction_type

* permit_no permit_type section_id section_description order_by input_type unit_measure Annual Building Indigenous Occupancy endorsement

* sub_div_no div_no sub_div_name sub_div_dtls fee unit range_from range_to type_of_computation unit2 function add_on unit_qty compute_fifty_percent function1 parentDescription excess additional islocal_rev exempt

* sub_sub_div_no div_no sub_div_no sub_div_name sub_div_dtls fee unit range_from range_to type_of_computation unit2 function add_on unit_qty compute_fifty_percent function1 parentDescription excess additional islocal_rev exempt

* sub_sub_sub_div_no div_no sub_sub_div_no sub_div_no sub_div_name sub_div_dtls fee unit range_from range_to type_of_computation unit2 function add_on unit_qty compute_fifty_percent function1 parentDescription excess additional islocal_rev exempt

* id sub_sub type_

* id ref_no suspension_no app_date effective_date project_id project_name project_location contractor_id contractor_name issue ntp_date contract_date contract_duration day_use_to_date days_remaining requisted_by requisted_name approved_by noted_by stat timestamp

* permit_no permit_code application_no issued_status date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id issued_to bldg_name issued_by issued_id date_save bns_id project_id project_name period_of days_ date_

* permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id issued_to bldg_name issued_by issued_id date_save bns_id project_id project_name

* permit_no permit_code application_no issued_status date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id date_save project_id project_name

* id category_id class_id category_type category_group category_label category_use savedate

* application_no permit_no scope_of_work scope_of_work_spcfy nature_of_work nature_of_work_spcfy div_no sub_div_no pisces qty system_type total_fee pk_no cbfronting assessed_id assessed_name or_id or_no or_date nso status savedate

* Id trans_id itemId permit_no description Datagrouping application_no applicant_id

* id transType Date Reference application_no buildingPermitId permit_type remarks Status TS

* id registration_no applicant_name applicant_id applicant_address nationality civil_status birthdate age contact_no broker_name broker_name_id broker_address broker_contact_no app_type

* bof_id registration_no bof_name bof_postion bof_contact

* id registration_no bns_name bns_id bns_address organizational_type kind_of_business capitalization contact_no br_bns_name br_bns_pos br_bns_contact_no bod_Name bod_position bod_contact status

* id c_name

* id registration_date series registration_no project_name location project_type property_id applicant_id broker_id right_overland project_classification project_category duration_start duration_end project_duration Total_area Total_sublot status app_type brgy_id acct_budget_id year sofid sof deptid expenseid expense_class activityid Project_status PercentCompletion isEarmark projectCost Appropriation bankid deptid_owner deptname_owner classification modeImplementation modeProcurment proj_type palc_type palc_id subd_approved noticeViolationID ts user_id user_id_update userdeptid IsSavingsCertified ShowToProjMonitoring guid IsBreakEditable IsABCEditable prvID

* property_id registration_no tct_id tct_no lot_owner address brgy_id lot_no block survey_no area a_saleable a_non_saleable a_roadlot_row a_others sub_lot s_saleable s_non_saleable s_roadlot_row s_others stat

* id trans_date project_id phase_stage proj_status status_percent remarks

* id type_ frm status timestamp

* id mainID variation_id det_type det_length det_width det_height det_number_units det_area det_volume det_diameter det_weight det_total_weight det_uom form_type ts user_id stat project_id

* id mainID variation_id det_type det_length det_width det_height det_number_units det_area det_volume det_diameter det_weight det_total_weight det_uom det_remarks form_type ts user_id stat project_id

* id name stat

* id main_id isMinor percent equipment_desc no_of_equipment hours rate cost

* id main_id isMinor percent equipment_desc no_of_equipment hours rate cost

* id main_id isMinor percent equipment_desc no_of_equipment hours rate cost

* id order_by variation_id new_DUPAID item_desc uom qty rate hours production cost ocm profit vat status ts user_id project_id remarks total_ocm_amount total_profit_amount total_vat_amount total_cost total_directcost total_indirectcost total_unitcost total_adjusted_unitcost manual_percentage variation_no guid

* id order_by variation_id new_DUPAID item_desc uom qty rate hours production cost ocm profit vat status ts user_id project_id remarks total_ocm_amount total_profit_amount total_vat_amount total_cost total_directcost total_indirectcost total_unitcost total_adjusted_unitcost manual_percentage variation_no guid

* id main_id type_ unit qty rate cost

* id main_id type_ unit qty rate cost

* id main_id type_ unit qty rate cost

* id main_id type_ unit qty rate cost

* id order_by pk_addtolist variation_id item_desc uom qty rate hours production cost ocm profit vat status ts user_id project_id remarks total_ocm_amount total_profit_amount total_vat_amount total_cost total_directcost total_indirectcost total_unitcost total_adjusted_unitcost manual_percentage variation_no guid

* id main_id isHauling type_ no_personnel hours rate cost

* id main_id isHauling type_ no_personnel hours rate cost

* id main_id isHauling type_ no_personnel hours rate cost

* id config

* id user_name user_id ts

* id accomplishment_id project_id contractor inpection_date completion_date issued_date remarks account_desc account_code fa_setup_id main_fund amount estimated_useful ts guid

* pkid incharge_id incharge_by ref_no app_date user_id status ts

* pkid mainid pow_id 1 1b 1c 1d 2 3 3a 3b 4 5 6 7 8 9 10 11 date_saved

* pkid ref_no app_date quarterly yr user_id status ts

* id main_id pow_id 1 2 2_2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

* id refno transdate commu_name commu_number commu_id project_id approval_date approval_byid approval_byname approval_remarks revise_date revise_byid revise_byname revise_remarks status ts

* id refno transdate palc_name palc_id project_id form_name form_id status ts

* id mainid contract_amount wt_contract revise_amount wt_revise prev_amount wt_previous this_amount wt_thisperiod todate_amount wt_todate

* id mainid orig_amount orig_wt revise_amount revise_wt prev_wt prev_amount this_wt this_amount to_wt to_amount

* id signame sigpos ts order_by

* id main_id ItemNo item_id Description org_qty Unit org_unit_cost org_amount Wt revised_qty revised_cont_amount revised_wt prev_acc prev_wt prev_amt accomplishment accomplishment_wt accomplishment_amount total_acc total_wt total_amt add_qty add_unitcost add_amnt ded_qty ded_unitcost ded_amnt extra_qty extra_unit extra_unitcost extra_amnt amount_ ts isBoldText swa_guid dupa_id

* id main_id ItemNo item_id Description org_qty Unit org_unit_cost org_amount Wt revised_qty revised_cont_amount revised_wt accomplishment accomplishment_wt accomplishment_amount prev_acc prev_wt prev_amt total_acc total_wt total_amt add_qty add_unitcost add_amnt ded_qty ded_unitcost ded_amnt extra_qty extra_unit extra_unitcost extra_amnt amount_ ts

* id ref_no app_date asof_date project_id project_name project_loc owner_id contractor_id contractor Project_cost less_previous bill_count project_cd revised_cd approved save_USER EDIT_USER sum_original_amount sum_original_wt sum_revise_amount sum_revise_wt sum_prev_amount sum_prev_wt sum_this_amount sum_this_wt sum_todate_amount sum_todate_wt sum_AmountDue variationID isTagging conformed_by conformed_pos status timestamp manual_cal

* id ref_no app_date asof_date project_id project_name project_loc owner_id contractor_id contractor Project_cost bill_count project_cd revised_cd approved save_USER EDIT_USER firstquarter secondquarter thirdquarter fourthquarter status timestamp

* id swa_id proj_id percentage date_ ts stat

* id mainid cell_origwt cell_revisewt cell_origamount cell_addamount cell_dedamount cell_extraamount cell_reviseamount

* id mainid orig_amount orig_wt revise_amount revise_wt add_amount ded_amount extra_amount

* id ref_no app_date inspectionDate project_id projectName projectLoc projectClass ToID To_ Remarks issue_by RequestedBy RequestedByID stat ts

* pkid refno appdate accomplishment_date save_USER EDIT_USER status ts

* id mainid proj_id projname loc contractor p_start p_end no_ofdays contractamnt accomplishment remarks

* id mainid cell_origwt cell_revisewt cell_prev_wt cell_this_wt cell_todate_wt

* id mainid orig_amount orig_wt revise_amount revise_wt prev_amount prev_wt this_amount this_wt todate_amount todate_wt

* id trans_date refno projectname project_id projectloc project_duration abc amount authorized authorizedid ts stat

* id refno trans_date pow_number pow_id swa_number swa_id project_id project_name project_name_address contractor contractor_id contractor_rep original_contract revised_contract total_cost percent_one billcount as_of ts stat date_project_finish cert_date_done date_issued decimal_setting isTagging user_id fa_id this_amount this_wt

* id mainid chk req_no req

* id requirements

* id ref_no app_date effective_date project_id projectName projectLoc resumeNo suspensionOrderNo contractor_id contractor contract_type daysUsedtoDate revisedDueDate NTPDate ContractDate ContractDuration days_remaining Subject Remarks issue_by project_in_charge project_in_chargeID stat ts

* AVID refno AVname Date Stat _DT

* id swa_id project_id ntp day_elapse original_duedate original_cd actual_completion ts

* id main_id insp_by insp_pos ordering

* id pow_id project_id project_name location contractor original_amount revise_amount calendar_days revisecalendar_days accomplishment ntp due_date revisedue_date completed_date remarks ts user_id status

* id ref_no app_date ext_no project_id projectName projectLoc suspensionOrderNo contractor_id contractor contract_type daysUsedtoDate revisedDuration ContractDuration NTPDate CompletionDate completion_time completionDate1 Subject Remarks issue_by thus stat ts project_in_charge project_in_chargeID save_user_id

* id mainid revise_no contract_duration revise_contract_duration revise_extension ts

* id var_orderno ref_no app_date project_id projectName projectLoc projectNo contractor_id contractor contract_type total_days_extension contract_days cost_difference previous_net_cost contract_amt estimated_revised_amt description_of_work reasons_for_change reviseduration number_allowed issue_by sum_original_amount sum_original_wt sum_additive_amount sum_deductive_amount sum_extra_works sum_revise_amount sum_revise_wt sum_total_amount conformed_pos conformed_by stat ts user_id manual_cal

* id main_id POW_id POW project_id projName itemNo item_description unit percent_WT orig_qty orig_unit_cost orig_amount add_qty add_unit_cost add_amount deduct_qty deduct_unit_cost deduct_amount extra_qty extra_unit extra_unit_cost exta_amount revised_qty revised_unit_cost revised_amount revised_wt dupa_id detailed_qty_id isBoldText guid grp_guid

* id main_id desc reason type_id type ts

* id var_id ntp day_elapse original_duedate original_cd actual_completion ts

* id form_type form_id project_id conformed_by conformed_pos prep_by prep_pos chek1_by chek1_pos chek2_by chek2_pos rec_approve_by rec_approve_pos approve_by approve_pos ts

select table ecao_classification_setup eceo_annual_inspection_report eceo_application eceo_application_bldg eceo_application_cost eceo_application_details eceo_application_info eceo_application_others eceo_application_process eceo_application_renewlogs eceo_application_update_status eceo_approval_alteration eceo_app_alteration_permit eceo_app_bp220 eceo_app_bp220_dtl eceo_app_commercial_subdivision eceo_app_commercial_subdivision_dtl eceo_app_development_permit eceo_app_farmlot_subd eceo_app_farmlot_subd_dtl eceo_app_locational_memorial_park_cemetery eceo_app_locational_memorial_park_cemetery_dtl eceo_app_memorial_park_cemetery eceo_app_palc_corporation eceo_app_simple_subdivision eceo_app_simple_subdivision_dtl eceo_app_simple_subdivision_pd97 eceo_app_simple_subdivision_pd97_dtl eceo_architectural_permit eceo_billing eceo_billing_fees_additional eceo_billing_fees_details eceo_billing_fees_details_bak eceo_billing_fees_localrevenue eceo_billing_fees_main eceo_billing_fees_main_bak eceo_bldg_additional eceo_bldg_documents eceo_bldg_nature eceo_bldg_scope eceo_bldg_signatory eceo_bridge_administration eceo_bridge_constructiontype eceo_bridge_inventory eceo_bridge_inventory_details eceo_bridge_physical_condition eceo_bridge_type eceo_building_cancelled_logs eceo_building_permit eceo_building_violation eceo_building_violation_details eceo_building_violation_main eceo_building_with_fsec eceo_certificate_of_annual_electrical_inspection eceo_certificate_of_occupancy eceo_certificate_of_occupancy_bplist eceo_certificate_of_occupancy_dtl eceo_certificate_of_use eceo_certified_true_copy eceo_certified_true_copy_dtl eceo_change_of_use eceo_change_of_use_dtl eceo_change_of_use_req eceo_char_of_occupancy eceo_civil_permit eceo_communication eceo_communication_logs eceo_concrete_pouring eceo_concrete_pouring_details eceo_concrete_pouring_testingsched eceo_concrete_pouring_type eceo_demolition_permit eceo_dev_farmlot_subd eceo_dev_permit_bp220 eceo_dev_permit_commercial_subdivision eceo_division eceo_dole_fees eceo_drainage_inventory eceo_drainage_type eceo_electrical_permit eceo_electronics_permit eceo_endorsement_to_veco eceo_evaluation_sheet eceo_excavation_and_ground_permit eceo_fencing_docs eceo_fencing_permit eceo_mechanical_permit eceo_non_compliance eceo_non_compliance_dtl eceo_notice_of_directed_acceleration eceo_notice_of_rectification eceo_notice_of_rectification_details eceo_notice_of_termination eceo_notice_of_termination_details eceo_obo_defaults_signatory eceo_palc_requirements eceo_palc_type eceo_permit_evaluation_form_entry_dtl eceo_permit_evaluation_form_entry_main eceo_permit_evaluation_form_setup eceo_permit_section eceo_permit_types eceo_plumbing_permit eceo_pole_type eceo_project_incharge eceo_project_status_logs eceo_road_class eceo_road_condition eceo_road_direction eceo_road_inventory eceo_road_km_post_info eceo_road_pavement_type eceo_road_terrain eceo_sanitary_permit eceo_scaffolding_permit eceo_showcause_order eceo_sidewalk_construction_permit eceo_signatory_persons eceo_sign_civil_permit eceo_sign_electrical_permit eceo_sign_electronics_permit eceo_sign_permit eceo_sign_permit_others eceo_site_inspection_report eceo_site_inspection_report_dtl eceo_street_lights eceo_street_lights_details eceo_street_lights_details_history eceo_street_lights_list_of_fixtures eceo_subdivision eceo_subdivision2 eceo_subdivision3 eceo_subdivision4 eceo_subdivision_approval eceo_subdivision_billingfees_details eceo_subdivision_billingfees_main eceo_subdivision_section eceo_sub_division eceo_sub_division2 eceo_sub_division3 eceo_sub_sub_setup eceo_suspension_order eceo_temp_electrical_permit eceo_temp_electrical_use eceo_temp_sidewalk_permit eceo_use_or_occupancy eceo_work_details obo_annual_charges_groups obo_permits setup_project_registration_applicant setup_project_registration_board_of_directors setup_project_registration_business setup_project_registration_capital_type setup_project_registration_main setup_project_registration_property setup_project_registration_status setup_project_registration_type tbl_bill_detailed_qty tbl_dupa_detailed_qty tbl_eceo_allow_swa_approve tbl_eceo_dupa_equipment tbl_eceo_dupa_equipment_bkp tbl_eceo_dupa_equipment_main tbl_eceo_dupa_item tbl_eceo_dupa_item_bkp tbl_eceo_dupa_item_dtl tbl_eceo_dupa_item_dtl_bkp tbl_eceo_dupa_item_dtl_main tbl_eceo_dupa_item_dtl_xxxxxx tbl_eceo_dupa_item_main tbl_eceo_dupa_labor tbl_eceo_dupa_labor_bkp tbl_eceo_dupa_labor_main tbl_eceo_excess_setup tbl_eceo_list_lgu_allow_user tbl_eceo_project_finish tbl_eceo_projweeklymain tbl_eceo_projweeklystatus tbl_eceo_quarterly_logs tbl_eceo_quarterly_logs_dtl tbl_eng_communication_list tbl_eng_palc_list tbl_eng_swa_cell_decimal_setting tbl_eng_swa_decimal_setting tbl_eng_swa_default_signatory tbl_eng_swa_detail tbl_eng_swa_detail_obo tbl_eng_swa_main tbl_eng_swa_main_obo tbl_eng_swa_percent tbl_eng_variation_order_cell_setting tbl_eng_variation_order_decimal_setting tbl_inspection_request tbl_obo_project_monitoring_logs tbl_obo_project_monitoring_logs_dtl tbl_obo_swa_cell_setting tbl_obo_swa_decimal_setting tbl_pakyaw_application tbl_project_accomplishment tbl_project_accomplishment_dtl tbl_project_accomplishment_requirment tbl_resume_order tbl_road_avsurfcond tbl_swa_signatory_details tbl_swa_signatory_details_emp tbl_tagging_of_oldprojects tbl_timeextension tbl_timeextension_logs tbl_variation_order tbl_variation_order_dtl tbl_variation_order_other tbl_var_signatory_details tbl_var_swa_signatory . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table ecao_classification_setup eceo_annual_inspection_report eceo_application eceo_application_bldg eceo_application_cost eceo_application_details eceo_application_info eceo_application_others eceo_application_process eceo_application_renewlogs eceo_application_update_status eceo_approval_alteration eceo_app_alteration_permit eceo_app_bp220 eceo_app_bp220_dtl eceo_app_commercial_subdivision eceo_app_commercial_subdivision_dtl eceo_app_development_permit eceo_app_farmlot_subd eceo_app_farmlot_subd_dtl eceo_app_locational_memorial_park_cemetery eceo_app_locational_memorial_park_cemetery_dtl eceo_app_memorial_park_cemetery eceo_app_palc_corporation eceo_app_simple_subdivision eceo_app_simple_subdivision_dtl eceo_app_simple_subdivision_pd97 eceo_app_simple_subdivision_pd97_dtl eceo_architectural_permit eceo_billing eceo_billing_fees_additional eceo_billing_fees_details eceo_billing_fees_details_bak eceo_billing_fees_localrevenue eceo_billing_fees_main eceo_billing_fees_main_bak eceo_bldg_additional eceo_bldg_documents eceo_bldg_nature eceo_bldg_scope eceo_bldg_signatory eceo_bridge_administration eceo_bridge_constructiontype eceo_bridge_inventory eceo_bridge_inventory_details eceo_bridge_physical_condition eceo_bridge_type eceo_building_cancelled_logs eceo_building_permit eceo_building_violation eceo_building_violation_details eceo_building_violation_main eceo_building_with_fsec eceo_certificate_of_annual_electrical_inspection eceo_certificate_of_occupancy eceo_certificate_of_occupancy_bplist eceo_certificate_of_occupancy_dtl eceo_certificate_of_use eceo_certified_true_copy eceo_certified_true_copy_dtl eceo_change_of_use eceo_change_of_use_dtl eceo_change_of_use_req eceo_char_of_occupancy eceo_civil_permit eceo_communication eceo_communication_logs eceo_concrete_pouring eceo_concrete_pouring_details eceo_concrete_pouring_testingsched eceo_concrete_pouring_type eceo_demolition_permit eceo_dev_farmlot_subd eceo_dev_permit_bp220 eceo_dev_permit_commercial_subdivision eceo_division eceo_dole_fees eceo_drainage_inventory eceo_drainage_type eceo_electrical_permit eceo_electronics_permit eceo_endorsement_to_veco eceo_evaluation_sheet eceo_excavation_and_ground_permit eceo_fencing_docs eceo_fencing_permit eceo_mechanical_permit eceo_non_compliance eceo_non_compliance_dtl eceo_notice_of_directed_acceleration eceo_notice_of_rectification eceo_notice_of_rectification_details eceo_notice_of_termination eceo_notice_of_termination_details eceo_obo_defaults_signatory eceo_palc_requirements eceo_palc_type eceo_permit_evaluation_form_entry_dtl eceo_permit_evaluation_form_entry_main eceo_permit_evaluation_form_setup eceo_permit_section eceo_permit_types eceo_plumbing_permit eceo_pole_type eceo_project_incharge eceo_project_status_logs eceo_road_class eceo_road_condition eceo_road_direction eceo_road_inventory eceo_road_km_post_info eceo_road_pavement_type eceo_road_terrain eceo_sanitary_permit eceo_scaffolding_permit eceo_showcause_order eceo_sidewalk_construction_permit eceo_signatory_persons eceo_sign_civil_permit eceo_sign_electrical_permit eceo_sign_electronics_permit eceo_sign_permit eceo_sign_permit_others eceo_site_inspection_report eceo_site_inspection_report_dtl eceo_street_lights eceo_street_lights_details eceo_street_lights_details_history eceo_street_lights_list_of_fixtures eceo_subdivision eceo_subdivision2 eceo_subdivision3 eceo_subdivision4 eceo_subdivision_approval eceo_subdivision_billingfees_details eceo_subdivision_billingfees_main eceo_subdivision_section eceo_sub_division eceo_sub_division2 eceo_sub_division3 eceo_sub_sub_setup eceo_suspension_order eceo_temp_electrical_permit eceo_temp_electrical_use eceo_temp_sidewalk_permit eceo_use_or_occupancy eceo_work_details obo_annual_charges_groups obo_permits setup_project_registration_applicant setup_project_registration_board_of_directors setup_project_registration_business setup_project_registration_capital_type setup_project_registration_main setup_project_registration_property setup_project_registration_status setup_project_registration_type tbl_bill_detailed_qty tbl_dupa_detailed_qty tbl_eceo_allow_swa_approve tbl_eceo_dupa_equipment tbl_eceo_dupa_equipment_bkp tbl_eceo_dupa_equipment_main tbl_eceo_dupa_item tbl_eceo_dupa_item_bkp tbl_eceo_dupa_item_dtl tbl_eceo_dupa_item_dtl_bkp tbl_eceo_dupa_item_dtl_main tbl_eceo_dupa_item_dtl_xxxxxx tbl_eceo_dupa_item_main tbl_eceo_dupa_labor tbl_eceo_dupa_labor_bkp tbl_eceo_dupa_labor_main tbl_eceo_excess_setup tbl_eceo_list_lgu_allow_user tbl_eceo_project_finish tbl_eceo_projweeklymain tbl_eceo_projweeklystatus tbl_eceo_quarterly_logs tbl_eceo_quarterly_logs_dtl tbl_eng_communication_list tbl_eng_palc_list tbl_eng_swa_cell_decimal_setting tbl_eng_swa_decimal_setting tbl_eng_swa_default_signatory tbl_eng_swa_detail tbl_eng_swa_detail_obo tbl_eng_swa_main tbl_eng_swa_main_obo tbl_eng_swa_percent tbl_eng_variation_order_cell_setting tbl_eng_variation_order_decimal_setting tbl_inspection_request tbl_obo_project_monitoring_logs tbl_obo_project_monitoring_logs_dtl tbl_obo_swa_cell_setting tbl_obo_swa_decimal_setting tbl_pakyaw_application tbl_project_accomplishment tbl_project_accomplishment_dtl tbl_project_accomplishment_requirment tbl_resume_order tbl_road_avsurfcond tbl_swa_signatory_details tbl_swa_signatory_details_emp tbl_tagging_of_oldprojects tbl_timeextension tbl_timeextension_logs tbl_variation_order tbl_variation_order_dtl tbl_variation_order_other tbl_var_signatory_details tbl_var_swa_signatory .	select column