Tables and Fields definition differences between schema database (v23.1 schema) and project database (v23.2 Schema) Compiled 10/21/2017 at 11:32:16 Project database table definitions missing: Schema database table definitions missing: afm_enterprise_graphics afm_password_token asset_attribute_std bl_use_val builder_component_type campus cf_schedules cf_schedules_assign cf_schedules_days cf_schedules_variances compliance_contract_cost construction_types_val csistd custodiantype eq_asset_attribute helpdesk_sla_priority ls_amort_sched ls_class_audit ls_ledger_entries quest_answer_ext quest_answer_ext_sync quest_answer_option_ext quest_question_ext question_ext questionnaire_ext site_org smsbuilder_ci staging activity_log_hactivity_log fields: Schema database field definitions missing: cause_type cb_units_id contact_id date_esc_comp_orig date_esc_resp_orig doc doc1 doc2 doc3 doc4 doc_file1 doc_file2 doc_file3 gp_id hcm_abate_by hcm_class1_id hcm_class2_id hcm_class3_id hcm_cond_id hcm_estimate_num hcm_fittings_num hcm_friable hcm_harea_id hcm_haz_rank_id hcm_haz_rating_id hcm_haz_status_id hcm_id hcm_is_hazard hcm_labeled hcm_loc_notes hcm_loc_typ_id hcm_pending_act hcm_pipe_cnt hcm_qty incident_id location_id questionnaire_id reg_program reg_requirement regulation related_id repair_type ta_id time_esc_comp_orig time_esc_resp_orig Common field definition differences: Project Value | Schema Value ac_id ml_heading Account Code | Account Code act_quest max_val | assessment_id ml_heading Associated with Assessment Id | Associated with Assessment Id cf_id ml_heading Craftsperson Code | Craftsperson Code cost_cat_id ml_heading Cost Category | Cost Category date_approved ml_heading Date Approved | Date Approved date_escalation_completion ml_heading Date Escalation for Completion Occurs | Date Escalation for Completion Occurs date_escalation_response ml_heading Date Escalation for Response Occurs | Date Escalation for Response Occurs dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code ehandle ml_heading Entity Handle / Unique ID | Entity Handle / Unique ID eq_id afm_size 12 | 32 escalated_completion ml_heading Escalated for Completion? | Escalated for Completion? escalated_response ml_heading Escalated for Response? | Escalated for Response? lat decimals 16 | 8 afm_size 24 | 16 lon decimals 16 | 8 afm_size 24 | 16 manager ml_heading Service Desk Manager | Service Desk Manager pct_complete ml_heading Percent Complete | Percent Complete phone_requestor ml_heading Requestor Phone | Requestor Phone pmp_id ml_heading PM Procedure | PM Procedure po_id ml_heading Purchase Order Code | Purchase Order Code project_id ml_heading Project Code | Project Code recurring_rule ml_heading Recurring Rule | Recurring Rule requestor ml_heading Requested By | Requested By satisfaction ml_heading Satisfaction Rating | Satisfaction Rating satisfaction_notes ml_heading Satisfaction Notes | Satisfaction Notes step_status ml_heading Step Status | Step Status time_escalation_completion ml_heading Time Escalation for Completion Occurs | Time Escalation for Completion Occurs time_escalation_response ml_heading Time Escalation for Response Occurs | Time Escalation for Response Occurs time_requested ml_heading Time Requested | Time Requested time_required ml_heading Time Required | Time Required vn_id ml_heading Vendor Code | Vendor Code wbs_id ml_heading Work Breakdown Structure Code | WBS Code wo_id ml_heading Work Order Code | Work Order Code work_team_id ml_heading Work Team Code | Work Team Code wr_id ml_heading Work Request Code | Work Request Code activity_log_step_waiting fields: Common field definition differences: Project Value | Schema Value activity_log_id ml_heading Service Request ID | Service Request ID cf_id ml_heading Response By Craftsperson Code | Response By Craftsperson Code date_created ml_heading Date Created | Date Created date_response ml_heading Date Responded To | Date Responded To em_id ml_heading Response By Employee Name | Response By Employee Name status ml_heading Basic Status | Basic Status step ml_heading Workflow Step | Workflow Step step_code ml_heading Step Code | Step Code step_log_id ml_heading Step Log Id | Step Log Id step_type ml_heading Step Type | Step Type time_created ml_heading Time Created | Time Created time_response ml_heading Time Responded To | Time Responded To user_name ml_heading Response By User Name | Response By User Name vn_id ml_heading Response By Vendor Code | Response By Vendor Code activity_log_sync fields: Schema database field definitions missing: action_title date_completed date_required date_scheduled date_scheduled_end date_started guid location_id manager pct_complete priority questionnaire_id_ext reg_program reg_requirement regulation Common field definition differences: Project Value | Schema Value activity_type afm_type Calculated | Std comments v23.2 Mobile Compliance | v21.2 Mobile ml_heading Action Type | Action Type doc1_isnew enum_list 0;No;1;Yes | doc2_isnew enum_list 0;No;1;Yes | doc3_isnew enum_list 0;No;1;Yes | doc4_isnew enum_list 0;No;1;Yes | doc_isnew enum_list 0;No;1;Yes | project_id afm_type Calculated | None comments v23.2 Mobile Compliance | V21.2 Mobile ml_heading Project Code | Project Code status afm_type Calculated | None comments v23.2 Mobile Compliance | v21.2 Mobile sl_heading | Status activity_logview fields: Common field definition differences: Project Value | Schema Value ac_id ml_heading Account Code | Account Code act_quest max_val | assessment_id ml_heading Associated with Assessment Id | Associated with Assessment Id cf_id ml_heading Craftsperson Code | Craftsperson Code cost_cat_id ml_heading Cost Category | Cost Category cost_var ml_heading Cost Variance | Cost Variance date_approved ml_heading Date Approved | Date Approved date_escalation_completion ml_heading Date Escalation for Completion Occurs | Date Escalation for Completion Occurs date_escalation_response ml_heading Date Escalation for Response Occurs | Date Escalation for Response Occurs dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code ehandle ml_heading Entity Handle / Unique ID | Entity Handle / Unique ID eq_id afm_size 12 | 32 escalated_completion ml_heading Escalated for Completion? | Escalated for Completion? escalated_response ml_heading Escalated for Response? | Escalated for Response? manager ml_heading Service Desk Manager | Service Desk Manager pct_complete ml_heading Percent Complete | Percent Complete phone_requestor ml_heading Requestor Phone | Requestor Phone pmp_id ml_heading PM Procedure | PM Procedure po_id ml_heading Purchase Order Code | Purchase Order Code project_id ml_heading Project Code | Project Code recurring_rule ml_heading Recurring Rule | Recurring Rule requestor ml_heading Requested By | Requested By satisfaction ml_heading Satisfaction Rating | Satisfaction Rating satisfaction_notes ml_heading Satisfaction Notes | Satisfaction Notes step_status ml_heading Step Status | Step Status time_escalation_completion ml_heading Time Escalation for Completion Occurs | Time Escalation for Completion Occurs time_escalation_response ml_heading Time Escalation for Response Occurs | Time Escalation for Response Occurs time_requested ml_heading Time Requested | Time Requested time_required ml_heading Time Required | Time Required vn_id ml_heading Vendor Code | Vendor Code wbs_id ml_heading Work Breakdown Structure Code | WBS Code wo_id ml_heading Work Order Code | Work Order Code work_team_id ml_heading Work Team Code | Work Team Code wr_id ml_heading Work Request Code | Work Request Code activitytype fields: Schema database field definitions missing: action_wfr afm_flds_trans fields: Common field definition differences: Project Value | Schema Value afm_module edit_group SYSTEM MGR | afm_size edit_group SYSTEM MGR | afm_type edit_group SYSTEM MGR | allow_null edit_group SYSTEM MGR | attributes edit_group SYSTEM MGR | autonumbered_id edit_group SYSTEM MGR | change_type edit_group SYSTEM MGR | chosen_action edit_group SYSTEM MGR | comments edit_group SYSTEM MGR | data_dict_diffs edit_group SYSTEM MGR | data_type edit_group SYSTEM MGR | decimals edit_group SYSTEM MGR | dep_cols edit_group SYSTEM MGR | dflt_val edit_group SYSTEM MGR | edit_group edit_group SYSTEM MGR | edit_mask edit_group SYSTEM MGR | enum_list edit_group SYSTEM MGR | field_grouping edit_group SYSTEM MGR | field_name edit_group SYSTEM MGR | is_atxt edit_group SYSTEM MGR | is_tc_traceable edit_group SYSTEM MGR | max_val edit_group SYSTEM MGR | min_val edit_group SYSTEM MGR | ml_heading edit_group SYSTEM MGR | num_format edit_group SYSTEM MGR | primary_key edit_group SYSTEM MGR | rec_action edit_group SYSTEM MGR | ref_table edit_group SYSTEM MGR | review_group edit_group SYSTEM MGR | sl_heading edit_group SYSTEM MGR | sql_table_diffs edit_group SYSTEM MGR | string_format edit_group SYSTEM MGR | table_name edit_group SYSTEM MGR | transfer_status edit_group SYSTEM MGR | validate_data edit_group SYSTEM MGR | afm_wf_rules fields: Common field definition differences: Project Value | Schema Value transfer_status edit_group SYSTEM MGR | asset_trans fields: Schema database field definitions missing: date_end_custodian date_start_custodian Common field definition differences: Project Value | Schema Value mod_field afm_size 32 | 16 mod_table afm_size 32 | 16 trans_type enum_list Location;Location;Ownership;Ownership;Status;Status;Value;Value;Owner Custodian;Owner Custodian | Location;Location;Ownership;Ownership;Status;Status;Value;Value bl fields: Schema database field definitions missing: age bl_ci bl_number bl_status_year bl_use_val construction_type_val contact_email cost_replace count_ls is_bl_addacc is_bl_hist is_bl_hsecurity is_child_occupied perimeter qty_life_expect source_date_update source_feed_comments source_record_id source_status source_system_id source_table source_time_update stat_life_remain structure_type value_bldg value_deprec_remain value_extras value_land Common field definition differences: Project Value | Schema Value campus_id afm_size 32 | 8 contact_name afm_size 32 | 25 contact fields: Schema database field definitions missing: url csi fields: Schema database field definitions missing: builder_comp_type_id csi_std source_date_update source_feed_comments source_record_id source_status source_system_id source_table source_time_update docs_assigned fields: Schema database field definitions missing: answer_id docs_assigned_sync fields: Common field definition differences: Project Value | Schema Value doc_isnew enum_list 0;No;1;Yes | eq fields: Schema database field definitions missing: builder_sms_level campus_id date_dep_closing_month eq_ci source_table Common field definition differences: Project Value | Schema Value source_record_id afm_size 36 | 32 status enum_list in;In service;out;Out of Service;rep;In Repair;stor;In storage;salv;Salvaged;sold;Sold;miss;Missing;disp;Disposed;don;Donated;sto;Stolen;todi;To be disposed | in;In service;out;Out of Service;rep;In Repair;stor;In storage;salv;Salvaged;sold;Sold;miss;Missing;disp;Disposed;don;Donated;sto;Stolen eq_audit fields: Common field definition differences: Project Value | Schema Value survey_photo_eq_isnew enum_list 0;No;1;Yes | survey_redline_eq_isnew enum_list 0;No;1;Yes | eq_req_items fields: Schema database field definitions missing: p01_value p02_value p03_value p04_value p05_value p06_value p07_value p08_value p09_value p10_value p11_value p12_value eq_system fields: Schema database field definitions missing: source_record_id source_system_id finanal_params fields: Schema database field definitions missing: ls_id finanal_sum fields: Schema database field definitions missing: cpm_buildersms_ci_pct ls_id finanal_sum_life fields: Schema database field definitions missing: ls_id hactivity_logmonth fields: Common field definition differences: Project Value | Schema Value ac_id ml_heading Account Code | Account Code act_quest max_val | assessment_id ml_heading Associated with Assessment Id | Associated with Assessment Id cf_id ml_heading Craftsperson Code | Craftsperson Code cost_cat_id ml_heading Cost Category | Cost Category cost_var ml_heading Cost Variance | Cost Variance date_approved ml_heading Date Approved | Date Approved date_escalation_completion ml_heading Date Escalation for Completion Occurs | Date Escalation for Completion Occurs date_escalation_response ml_heading Date Escalation for Response Occurs | Date Escalation for Response Occurs dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code ehandle ml_heading Entity Handle / Unique ID | Entity Handle / Unique ID eq_id afm_size 12 | 32 escalated_completion ml_heading Escalated for Completion? | Escalated for Completion? escalated_response ml_heading Escalated for Response? | Escalated for Response? manager ml_heading Service Desk Manager | Service Desk Manager pct_complete ml_heading Percent Complete | Percent Complete phone_requestor ml_heading Requestor Phone | Requestor Phone pmp_id ml_heading PM Procedure | PM Procedure po_id ml_heading Purchase Order Code | Purchase Order Code project_id ml_heading Project Code | Project Code recurring_rule ml_heading Recurring Rule | Recurring Rule requestor ml_heading Requested By | Requested By satisfaction ml_heading Satisfaction Rating | Satisfaction Rating satisfaction_notes ml_heading Satisfaction Notes | Satisfaction Notes service_provider ml_heading Service Provider | Service Provider step_status ml_heading Step Status | Step Status time_escalation_completion ml_heading Time Escalation for Completion Occurs | Time Escalation for Completion Occurs time_escalation_response ml_heading Time Escalation for Response Occurs | Time Escalation for Response Occurs time_requested ml_heading Time Requested | Time Requested time_required ml_heading Time Required | Time Required vn_id ml_heading Vendor Code | Vendor Code wbs_id ml_heading Work Breakdown Structure Code | WBS Code wo_id ml_heading Work Order Code | Work Order Code wr_id ml_heading Work Request Code | Work Request Code helpdesk_sla_response fields: Schema database field definitions missing: cost_code location_id reg_program reg_requirement regulation hwr fields: Schema database field definitions missing: date_start_on_hold reg_program reg_requirement regulation time_on_hold time_start_on_hold hwr_month fields: Common field definition differences: Project Value | Schema Value activity_type ml_heading Action Type | Action Type cost_var ml_heading Cost Variance | Cost Variance date_closed ml_heading Date Work Request Closed | Date Work Request Closed em_id ml_heading Employee Name | Employee Name eq_id afm_size 12 | 32 escalated_completion ml_heading Escalated for Completion? | Escalated for Completion? escalated_response ml_heading Escalated for Response? | Escalated for Response? manager ml_heading Service Desk Manager | Service Desk Manager site_id ml_heading Site Code | Site Code work_team_id ml_heading Work Team Code | Work Team Code hwrcf fields: Schema database field definitions missing: is_scheduled ls fields: Schema database field definitions missing: class_wiz_step1_done class_wiz_step2_done class_wiz_step3_done date_commencement date_end_fasb date_inception eq_id fasb_ls_class fasb_ls_type fasb_review_status fasb_workflow_status increm_borrow_rate initial_direct_cost initial_lease_liability is_auto_transfer is_early_termination is_facility_specialized is_gross_rent is_index_included is_landlord_allowance is_lease_contracted is_lease_expanded is_lease_near_eol is_npv_exceed_90_fmv is_option_to_buy is_parking_designated is_purchase_option is_renewal_changed is_rent_below_market is_residual_unknown is_short_term_lease is_term_exceed_life lease_payments lease_term lease_term_remain pct_liability_over_fmv pct_term_over_life remaining_life_bldg straight_line_exp value_bldg mo fields: Schema database field definitions missing: from_team_id to_team_id Common field definition differences: Project Value | Schema Value mo_type comments Trinidad; v.23.2 Move Management - added Team to enum list | Trinidad enum_list Employee;Employee;New Hire;New Hire;Leaving;Employee Leaving;Equipment;Equipment;Asset;Asset;Room;Room;Team;Team; | Employee;Employee;New Hire;New Hire;Leaving;Employee Leaving;Equipment;Equipment;Asset;Asset;Room;Room ml_heading Move Type | Move Type mo_scenario_em fields: Schema database field definitions missing: auto_number filename from_bl_id from_fl_id from_rm_id team_id Common field definition differences: Project Value | Schema Value em_id allow_null Yes | No ml_heading Employee To Move | Employee To Move primary_key 0 | 3 project_id ml_heading Project Code | Project Code primary_key 0 | 1 scenario_id ml_heading Scenario Name | Scenario Name primary_key 0 | 2 op fields: Schema database field definitions missing: date_renewal_signed is_reasonably_certain Common field definition differences: Project Value | Schema Value cost_est comments FASB 842 Update | ml_heading Cost - Estimated | Cost/Year - Estimated num_format Budget Currency | Default op_type comments FASB 842 Update | enum_list N/A;N/A;AUTOMATIC TRANSFER OWNERSHIP;AUTOMATIC TRANSFER OF OWNERSHIP;CONTRACTION;CONTRACTION;EARLY TERMINATION;EARLY TERMINATION;EXPANSION;EXPANSION;EXTENSION;EXTENSION;OPTION TO BUY;OPTION TO BUY;RENEWAL;RENEWAL;RENEW LONGER TERM;RENEW LONGER TERM;OPTION TO SUBLET;OPTION TO SUBLET;IMPROVEMENTS;IMPROVEMENTS;REASSIGNMENT;REASSIGNMENT;LEASE END;LEASE END | N/A;N/A;CONTRACTION;CONTRACTION;EARLY TERMINAT.;EARLY TERMINAT.;EXPANSION;EXPANSION;EXTENSION;EXTENSION;OPTION TO BUY;OPTION TO BUY;RENEWAL;RENEWAL;OPTION TO SUBLET;OPTION TO SUBLET;IMPROVEMENTS;IMPROVEMENTS;REASSIGNMENT;REASSIGNMENT;LEASE END;LEASE END; ml_heading Option Type | Option Type afm_size 32 | 16 org fields: Schema database field definitions missing: comments cost_replace org_ci source_date_update source_feed_comments source_record_id source_status source_system_id source_table source_time_update Common field definition differences: Project Value | Schema Value org_id afm_size 36 | 32 ot fields: Common field definition differences: Project Value | Schema Value status enum_list Pipeline;Pipeline;UNDER CONTRACT;Under Contract;ESCROWED;Escrowed;IN SERVICE;In Service;Owned;Owned;OWNED AND LEASED;Owned and Leased;LEASED;Leased;SUB-LEASED;Sub-Leased;SUB LET;Sub Let;FOR SALE;For Sale;LEASED (EXPIRED);Leased (Expired);OUT OF SERVICE;Out of Service;ABANDONED;Abandoned;DONATED;Donated;Disposed;Disposed;SOLD;Sold;UNKNOWN;Unknown;N/A;N/A;To be disposed;To be disposed | Pipeline;Pipeline;UNDER CONTRACT;Under Contract;ESCROWED;Escrowed;IN SERVICE;In Service;Owned;Owned;OWNED AND LEASED;Owned and Leased;LEASED;Leased;SUB-LEASED;Sub-Leased;SUB LET;Sub Let;FOR SALE;For Sale;LEASED (EXPIRED);Leased (Expired);OUT OF SERVICE;Out of Service;ABANDONED;Abandoned;DONATED;Donated;Disposed;Disposed;SOLD;Sold;UNKNOWN;Unknown;N/A;N/A pmp fields: Schema database field definitions missing: cost_cat_id pms fields: Schema database field definitions missing: cost_code criticality days_early days_late due_date_from int1_recurrence int2_recurrence int3_recurrence int4_recurrence location_id parent_pms_id reg_program reg_requirement regulation sla_work_team_id Common field definition differences: Project Value | Schema Value interval_type comments V.23.2 Building Operations PM Planning | dflt_val r | d enum_list r;Recurrence Pattern;d;Days;ww;Weeks;m;Months;q;Quarters;yyyy;Years;i;Miles;h;Hours;e;Meter;a;Manual | d;Days;ww;Weeks;m;Months;q;Quarters;yyyy;Years;i;Miles;h;Hours;e;Meter;a;Manual ml_heading Interval Type | Interval Type pmsd fields: Schema database field definitions missing: date_completed date_earliest date_latest date_orig_todo is_cancelled is_deferred wo_id property fields: Schema database field definitions missing: value_bldg value_extras value_land Common field definition differences: Project Value | Schema Value status enum_list PIPELINE;Pipeline;UNDER CONTRACT;Under Contract;ESCROWED;Escrowed;IN SERVICE;In Service;OWNED;Owned;OWNED AND LEASED;Owned and Leased;LEASED;Leased;SUB-LEASED;Sub-Leased;SUB LET;Sub Let;FOR SALE;For Sale;LEASED (EXPIRED);Leased (Expired);OUT OF SERVICE;Out of Service;ABANDONED;Abandoned;DONATED;Donated;DISPOSED;Disposed;SOLD;Sold;N/A;N/A;UNKNOWN;Unknown;todi;To be disposed | PIPELINE;Pipeline;UNDER CONTRACT;Under Contract;ESCROWED;Escrowed;IN SERVICE;In Service;OWNED;Owned;OWNED AND LEASED;Owned and Leased;LEASED;Leased;SUB-LEASED;Sub-Leased;SUB LET;Sub Let;FOR SALE;For Sale;LEASED (EXPIRED);Leased (Expired);OUT OF SERVICE;Out of Service;ABANDONED;Abandoned;DONATED;Donated;DISPOSED;Disposed;SOLD;Sold;N/A;N/A;UNKNOWN;Unknown regprogram fields: Schema database field definitions missing: date_approved date_effective date_expired date_last_reviewed date_renewed date_review is_contract regrequirement fields: Schema database field definitions missing: questionnaire_id regviolation fields: Schema database field definitions missing: cost_base_budget cost_base_payment cost_cat_id cost_total_payment cost_vat_budget cost_vat_payment ctry_id currency_budget currency_payment date_used_for_mc_budget date_used_for_mc_payment exchange_rate_budget exchange_rate_override exchange_rate_payment vat_amount_override vat_percent_override vat_percent_value Common field definition differences: Project Value | Schema Value cost_total comments v23.2 Compliance - Contract Management | v20.2 Compliance ml_heading Cost - Penalty/Fines (Budget) | Cost - Penalty/Fines num_format Budget Currency | Default afm_size 12 | 10 resrmview fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code cost_rmres ml_heading Cost of Room Reservation | Cost of Room Reservation date_cancelled ml_heading Date Cancelled | Date Cancelled date_created ml_heading Date Created | Date Created date_last_modified ml_heading Date Last Modified | Date Last Modified date_rejected ml_heading Date Rejected | Date Rejected date_start ml_heading Date Start | Date Start fl_id ml_heading Floor Code | Floor Code guests_external ml_heading # of External Guests | # of External Guests guests_internal ml_heading # of Internal Guests | # of Internal Guests recurring_order ml_heading Recurring Order | Recurring Order res_id ml_heading Reservation Code | Reservation Code rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code rmres_id ml_heading Room Reservation Code | Room Reservation Code status ml_heading Status of Room Reservation | Status of Room Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start user_last_modified_by ml_heading Last Modified By | Last Modified By resrsview fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code cost_rsres ml_heading Cost of Resource Reservation | Cost of Resource Reservation date_cancelled ml_heading Date Cancelled | Date Cancelled date_created ml_heading Date Created | Date Created date_last_modified ml_heading Date Last Modified | Date Last Modified date_rejected ml_heading Date Rejected | Date Rejected date_start ml_heading Date Start | Date Start fl_id ml_heading Floor Code | Floor Code quantity ml_heading Requested Quantity | Requested Quantity recurring_order ml_heading Recurring Order | Recurring Order res_id ml_heading Reservation Code | Reservation Code resource_id ml_heading Resource Code | Resource Code rm_id ml_heading Room Code | Room Code rsres_id ml_heading Resource Reservation Code | Resource Reservation Code status ml_heading Status of Resource Reservation | Status of Resource Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start user_last_modified_by ml_heading Last Modified By | Last Modified By resview fields: Common field definition differences: Project Value | Schema Value ac_id ml_heading Internal Account | Internal Account attendees ml_heading Attendees's Email Addresses | Attendees's Email Addresses cost_res ml_heading Cost of Reservation | Cost of Reservation date_cancelled ml_heading Date Cancelled | Date Cancelled date_created ml_heading Date Created | Date Created date_end ml_heading Date End | Date End date_last_modified ml_heading Date Last Modified | Date Last Modified date_start ml_heading Date Start | Date Start doc_event ml_heading Event Document | Event Document dp_id ml_heading Dept. for Chargeback | Dept. for Chargeback dv_id ml_heading Division for Chargeback | Division for Chargeback email ml_heading Requestor's Email | Requestor's Email phone ml_heading Requestor's Phone # | Requestor's Phone # recurring_date_modified ml_heading Recurring Date Individually Modified | Recurring Date Individually Modified recurring_rule ml_heading Recurring Rule | Recurring Rule res_id ml_heading Reservation Code | Reservation Code res_parent ml_heading Parent Reservation Code | Parent Reservation Code res_type ml_heading Reservation Type | Reservation Type reservation_name ml_heading Reservation Name | Subject time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start user_created_by ml_heading Created By | Created By user_last_modified_by ml_heading Last Modified By | Last Modified By user_requested_by ml_heading Requested By | Requested By user_requested_for ml_heading Requested For | Requested For rm fields: Common field definition differences: Project Value | Schema Value org_id afm_size 36 | 32 rm_trial fields: Schema database field definitions missing: cap_em rm_cat rm_type rmpct fields: Common field definition differences: Project Value | Schema Value org_id afm_size 36 | 32 rrappdet fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start fl_id ml_heading Floor Code | Floor Code res_id ml_heading Reservation Code | Reservation Code resource_id ml_heading Resource Code | Resource Code rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code status ml_heading Status of Room Reservation | Status of Room Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start user_requested_by ml_heading Requested By | Requested By rrcostdet fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code res_id ml_heading Reservation Code | Reservation Code reservation_name ml_heading Reservation Name | Subject resource_id ml_heading Resource Code | Resource Code rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code status ml_heading Status of Room Reservation | Status of Room Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start user_requested_by ml_heading Requested By | Requested By rrdayresocc fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start res_id ml_heading Reservation Code | Reservation Code resource_id ml_heading Resource Code | Resource Code resource_name ml_heading Resource Std. Name | Resource Std. Name resource_std ml_heading Resource Standard | Resource Standard rsres_id ml_heading Resource Reservation Code | Resource Reservation Code site_id ml_heading Site Code | Site Code status ml_heading Status of Resource Reservation | Status of Resource Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start rrdayrmocc fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start fl_id ml_heading Floor Code | Floor Code res_id ml_heading Reservation Code | Reservation Code rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code rmres_id ml_heading Room Reservation Code | Room Reservation Code site_id ml_heading Site Code | Site Code status ml_heading Status of Room Reservation | Status of Room Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start rrdayrmres fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code name ml_heading Building Name | Building Name phone ml_heading Requestor's Phone # | Requestor's Phone # res_id ml_heading Reservation Code | Reservation Code reservation_name ml_heading Reservation Name | Subject rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code status ml_heading Status of Reservation | Status of Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start tr_id ml_heading Trade Code | Trade Code user_requested_for ml_heading Requested For | Requested For vn_id ml_heading Vendor Code | Vendor Code rrdayrmresplus fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code phone ml_heading Requestor's Phone # | Requestor's Phone # quantity ml_heading Requested Quantity | Requested Quantity res_id ml_heading Reservation Code | Reservation Code resource_id ml_heading Resource Code | Resource Code rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start user_requested_for ml_heading Requested For | Requested For rrdayrresplus fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code name ml_heading Building Name | Building Name phone ml_heading Requestor's Phone # | Requestor's Phone # quantity ml_heading Requested Quantity | Requested Quantity res_id ml_heading Reservation Code | Reservation Code reservation_name ml_heading Reservation Name | Subject resource_id ml_heading Resource Code | Resource Code resource_name ml_heading Resource Name | Resource Name resource_std ml_heading Resource Standard | Resource Standard rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code status ml_heading Status of Resource Reservation | Status of Resource Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start tr_id ml_heading Trade Code | Trade Code user_requested_for ml_heading Requested For | Requested For vn_id ml_heading Vendor Code | Vendor Code rrmoncostdp fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_dp_id ml_heading Division Code - Department Code | Division Code - Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code res_id ml_heading Reservation Code | Reservation Code resource_id ml_heading Resource Code | Resource Code rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code rrmonnumrres fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code resource_id ml_heading Resource Code | Resource Code resource_std ml_heading Resource Standard | Resource Standard site_id ml_heading Site Code | Site Code status ml_heading Status of Reservation | Status of Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start rrmonreq fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code status ml_heading Status of Reservation | Status of Reservation rrmonresrej fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code resource_id ml_heading Resource Code | Resource Code resource_std ml_heading Resource Standard | Resource Standard site_id ml_heading Site Code | Site Code status ml_heading Status of Resource Reservation | Status of Resource Reservation rrmonrmcap fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code status ml_heading Status of Reservation | Status of Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start rrmonthresquant fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start res_id ml_heading Reservation Code | Reservation Code resource_id ml_heading Resource Code | Resource Code resource_name ml_heading Resource Std. Name | Resource Std. Name resource_std ml_heading Resource Standard | Resource Standard rsres_id ml_heading Resource Reservation Code | Resource Reservation Code site_id ml_heading Site Code | Site Code status ml_heading Status of Resource Reservation | Status of Resource Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start rrmonusearr fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code status ml_heading Status of Reservation | Status of Reservation time_end ml_heading Time End | Time End time_start ml_heading Time Start | Time Start rrressheet fields: Common field definition differences: Project Value | Schema Value date_start ml_heading Date Start | Date Start res_id ml_heading Reservation Code | Reservation Code rrressheetplus fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code ctry_id ml_heading Country Code | Country Code date_start ml_heading Date Start | Date Start dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code res_id ml_heading Reservation Code | Reservation Code reservation_name ml_heading Reservation Name | Subject rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code user_requested_by ml_heading Requested By | Requested By user_requested_for ml_heading Requested For | Requested For rrwrrestr fields: Common field definition differences: Project Value | Schema Value bl_id ml_heading Building Code | Building Code config_id ml_heading Configuration Code | Configuration Code ctry_id ml_heading Country Code | Country Code date_assigned ml_heading Date to Perform | Date to Perform description ml_heading Work Description | Work Description dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code fl_id ml_heading Floor Code | Floor Code name ml_heading Building Name | Building Name phone ml_heading Requestor's Phone # | Requestor's Phone # prob_type ml_heading Problem Type | Problem Type requestor ml_heading Requested by | Requested by res_id ml_heading Reservation Code | Reservation Code resource_name ml_heading Resource Name | Resource Name rm_arrange_type_id ml_heading Room Arrangement Type | Room Arrangement Type rm_id ml_heading Room Code | Room Code site_id ml_heading Site Code | Site Code status ml_heading Status of Resource Reservation | Status of Resource Reservation tr_id ml_heading Trade Code | Trade Code vn_id ml_heading Vendor Code | Vendor Code runoffarea fields: runofftype fields: sb fields: Common field definition differences: Project Value | Schema Value sb_desc ml_heading Space Requirements Description / Source / Rationale | Space Requirements Description site fields: Schema database field definitions missing: campus_id comments contact_id cost_replace site_ci site_number source_date_update source_feed_comments source_record_id source_status source_system_id source_table source_time_update surveyrm_sync fields: Common field definition differences: Project Value | Schema Value survey_photo_isnew enum_list 0;No;1;Yes | survey_redline_rm_isnew enum_list 0;No;1;Yes | system_bl fields: Schema database field definitions missing: csi_id source_date_update source_feed_comments source_record_id source_status source_system_id source_table source_time_update system_bl_ci ta fields: Schema database field definitions missing: cost_dep_value date_dep_closing_month Common field definition differences: Project Value | Schema Value status enum_list in;In Use;out;Out of Service;rep;In Repair;stor;In Storage;salv;Salvaged;sold;Sold;miss;Missing;disp;Disposed;don;Donated;sto;Stolen;todi;To be disposed | in;In Use;out;Out of Service;rep;In Repair;stor;In Storage;salv;Salvaged;sold;Sold;miss;Missing;disp;Disposed;don;Donated;sto;Stolen team fields: Schema database field definitions missing: custodian_type digital_signature is_owner ta_id team_assoc fields: Common field definition differences: Project Value | Schema Value org_id afm_size 36 | 32 wohwo fields: Common field definition differences: Project Value | Schema Value ac_id ml_heading Account Code | Account Code bl_id ml_heading Building Code | Building Code cost_estimated ml_heading Estimated Cost | Estimated Cost cost_labor ml_heading Cost of Labor | Cost of Labor cost_other ml_heading Other Costs | Other Costs cost_parts ml_heading Cost of Parts | Cost of Parts cost_tools ml_heading Cost of Tools | Cost of Tools cost_total ml_heading Total Cost | Total Cost date_assigned ml_heading Date to Perform | Date to Perform date_closed ml_heading Date Work Order Closed | Date Work Order Closed date_completed ml_heading Date Work Order Completed | Date Work Order Completed date_created ml_heading Date Work Order Created | Date Work Order Created date_issued ml_heading Date Work Order Issued | Date Work Order Issued description ml_heading Primary Work Description | Primary Work Description dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code name_authorized ml_heading Work Order Authorized by | Work Order Authorized by name_of_planner ml_heading Work Order Planned by | Work Order Planned by option1 ml_heading Option 1 | Option 1 option2 ml_heading Option 2 | Option 2 priority ml_heading Work Order Priority | Work Order Priority qty_open_wr ml_heading Number of Open Requests | Number of Open Requests time_closed ml_heading Time Work Order Closed | Time Work Order Closed time_completed ml_heading Time Work Order Completed | Time Work Order Completed time_created ml_heading Time Work Order Created | Time Work Order Created time_issued ml_heading Time Work Order Issued | Time Work Order Issued tr_id ml_heading Primary Trade Required | Primary Trade Required wo_id ml_heading Work Order Code | Work Order Code wo_type ml_heading Primary Work Type | Primary Work Type work_team_id ml_heading Work Team Code | Work Team Code wr fields: Schema database field definitions missing: date_start_on_hold reg_program reg_requirement regulation time_on_hold time_start_on_hold wr_step_waiting fields: Common field definition differences: Project Value | Schema Value cf_id ml_heading Response By Craftsperson Code | Response By Craftsperson Code date_created ml_heading Date Created | Date Created date_response ml_heading Date Responded To | Date Responded To em_id ml_heading Response By Employee Name | Response By Employee Name role_name ml_heading Role Name | Role Name status ml_heading Basic Status | Basic Status step ml_heading Workflow Step | Workflow Step step_code ml_heading Step Code | Step Code step_log_id ml_heading Step Log Id | Step Log Id step_type ml_heading Step Type | Step Type time_created ml_heading Time Created | Time Created time_response ml_heading Time Responded To | Time Responded To user_name ml_heading Response By User Name | Response By User Name vn_id ml_heading Response By Vendor Code | Response By Vendor Code wr_id ml_heading Work Request Code | Work Request Code wr_sync fields: Schema database field definitions missing: eq_condition eq_status guid mob_eq_fields_changed priority_label Common field definition differences: Project Value | Schema Value doc1_isnew enum_list 0;No;1;Yes | doc2_isnew enum_list 0;No;1;Yes | doc3_isnew enum_list 0;No;1;Yes | doc4_isnew enum_list 0;No;1;Yes | wrcf fields: Schema database field definitions missing: is_scheduled wrcf_sync fields: Schema database field definitions missing: is_scheduled wrhwr fields: Schema database field definitions missing: date_start_on_hold reg_program reg_requirement regulation time_on_hold time_start_on_hold Common field definition differences: Project Value | Schema Value ac_id ml_heading Account Code | Account Code act_labor_hours ml_heading Actual Labor Hours | Actual Labor Hours activity_log_id ml_heading Action Item ID | Action Item ID activity_type ml_heading Action Type | Action Type allow_work_on_holidays ml_heading Allow Work on Holidays? | Allow Work on Holidays? bl_id ml_heading Building Code | Building Code cause_type ml_heading Cause Code | Cause Code cf_notes dflt_val | ml_heading Craftspersons Notes | Craftspersons Notes completed_by ml_heading Completed by | Completed by cost_est_labor ml_heading Estimated Cost of Labor | Estimated Cost of Labor cost_est_other ml_heading Estimated Other Costs | Estimated Other Costs cost_est_parts ml_heading Estimated Cost of Parts | Estimated Cost of Parts cost_est_tools ml_heading Estimated Cost of Tools | Estimated Cost of Tools cost_est_total ml_heading Estimated Total Cost | Estimated Total Cost cost_labor ml_heading Cost of Labor | Cost of Labor cost_other ml_heading Other Costs | Other Costs cost_parts ml_heading Cost of Parts | Cost of Parts cost_tools ml_heading Cost of Tools | Cost of Tools cost_total ml_heading Total Cost | Total Cost curr_meter_val ml_heading Current Equip. meter reading | Current Equip. meter reading date_assigned ml_heading Date to Perform | Date to Perform date_closed ml_heading Date Work Request Closed | Date Work Request Closed date_completed ml_heading Date Work Completed | Date Work Completed date_escalation_completion ml_heading Date Escalation for Completion Occurs | Date Escalation for Completion Occurs date_escalation_response ml_heading Date Escalation for Response Occurs | Date Escalation for Response Occurs date_est_completion ml_heading Date of Est. Completion | Date of Est. Completion date_requested ml_heading Date Work Requested | Date Work Requested date_stat_chg ml_heading Date of Last Status Change | Date of Last Status Change desc_other_costs ml_heading Other Costs Description | Other Costs Description description dflt_val | ml_heading Work Description | Work Description down_time ml_heading Equipment Down (Hours) | Equipment Down (Hours) dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code eq_id ml_heading Equipment Code | Equipment Code afm_size 12 | 32 escalated_completion ml_heading Escalated for Completion? | Escalated for Completion? escalated_response ml_heading Escalated for Response? | Escalated for Response? est_labor_hours ml_heading Estimated Labor Hours | Estimated Labor Hours fl_id ml_heading Floor Code | Floor Code lat decimals 16 | 8 afm_size 24 | 16 location ml_heading Problem Location | Problem Location lon decimals 16 | 8 afm_size 24 | 16 manager ml_heading Service Desk Manager | Service Desk Manager msg_delivery_status ml_heading Message Delivery Status | Message Delivery Status option1 ml_heading Option 1 | Option 1 option2 ml_heading Option 2 | Option 2 phone ml_heading Requestor's Phone # | Requestor's Phone # pmp_id ml_heading PM Procedure | PM Procedure pms_id ml_heading PM Schedule Code | PM Schedule Code priority ml_heading Work Request Priority | Work Request Priority prob_type ml_heading Problem Type | Problem Type repair_type ml_heading Repair Type | Repair Type requestor ml_heading Requested by | Requested by res_id ml_heading Reservation Code | Reservation Code rm_id ml_heading Room Code | Room Code rmres_id ml_heading Room Reservation Code | Room Reservation Code rsres_id ml_heading Resource Reservation Code | Resource Reservation Code satisfaction ml_heading Satisfaction Rating | Satisfaction Rating satisfaction_notes ml_heading Satisfaction Notes | Satisfaction Notes serv_window_days ml_heading Service Window Days | Service Window Days serv_window_end ml_heading Service Window End | Service Window End serv_window_start ml_heading Service Window Start | Service Window Start site_id ml_heading Site Code | Site Code status ml_heading Work Request Status | Work Request Status status_sort ml_heading Status Sort | Status Sort step_status ml_heading Work Request Step Status | Work Request Step Status time_completed ml_heading Time Work Completed | Time Work Completed time_escalation_completion ml_heading Time Escalation for Completion Occurs | Time Escalation for Completion Occurs time_escalation_response ml_heading Time Escalation for Response Occurs | Time Escalation for Response Occurs time_requested ml_heading Time Work Requested | Time Work Requested time_stat_chg ml_heading Time of Last Status Change | Time of Last Status Change tr_id ml_heading Primary Trade Required | Primary Trade Required vn_id ml_heading Primary Vendor | Primary Vendor wo_id ml_heading Assigned to Work Order | Assigned to Work Order work_team_id ml_heading Work Team Code | Work Team Code wr_id ml_heading Work Request Code | Work Request Code wrview fields: Common field definition differences: Project Value | Schema Value ac_id ml_heading Account Code | Account Code act_labor_hours ml_heading Actual Labor Hours | Actual Labor Hours activity_log_id ml_heading Action Item ID | Action Item ID activity_type ml_heading Action Type | Action Type allow_work_on_holidays ml_heading Allow Work on Holidays? | Allow Work on Holidays? bl_id ml_heading Building Code | Building Code cause_type ml_heading Cause Code | Cause Code cf_notes dflt_val | ml_heading Craftspersons Notes | Craftspersons Notes completed_by ml_heading Completed by | Completed by cost_est_labor ml_heading Estimated Cost of Labor | Estimated Cost of Labor cost_est_other ml_heading Estimated Other Costs | Estimated Other Costs cost_est_parts ml_heading Estimated Cost of Parts | Estimated Cost of Parts cost_est_tools ml_heading Estimated Cost of Tools | Estimated Cost of Tools cost_est_total ml_heading Estimated Total Cost | Estimated Total Cost cost_labor ml_heading Cost of Labor | Cost of Labor cost_other ml_heading Other Costs | Other Costs cost_parts ml_heading Cost of Parts | Cost of Parts cost_tools ml_heading Cost of Tools | Cost of Tools cost_total ml_heading Total Cost | Total Cost curr_meter_val ml_heading Current Equip. meter reading | Current Equip. meter reading date_assigned ml_heading Date to Perform | Date to Perform date_closed ml_heading Date Work Request Closed | Date Work Request Closed date_completed ml_heading Date Work Completed | Date Work Completed date_escalation_completion ml_heading Date Escalation for Completion Occurs | Date Escalation for Completion Occurs date_escalation_response ml_heading Date Escalation for Response Occurs | Date Escalation for Response Occurs date_est_completion ml_heading Date of Est. Completion | Date of Est. Completion date_requested ml_heading Date Work Requested | Date Work Requested date_stat_chg ml_heading Date of Last Status Change | Date of Last Status Change desc_other_costs ml_heading Other Costs Description | Other Costs Description description dflt_val | ml_heading Work Description | Work Description down_time ml_heading Equipment Down (Hours) | Equipment Down (Hours) dp_id ml_heading Department Code | Department Code dv_id ml_heading Division Code | Division Code eq_id ml_heading Equipment Code | Equipment Code afm_size 12 | 32 escalated_completion ml_heading Escalated for Completion? | Escalated for Completion? escalated_response ml_heading Escalated for Response? | Escalated for Response? est_labor_hours ml_heading Estimated Labor Hours | Estimated Labor Hours fl_id ml_heading Floor Code | Floor Code location ml_heading Problem Location | Problem Location manager ml_heading Service Desk Manager | Service Desk Manager msg_delivery_status ml_heading Message Delivery Status | Message Delivery Status option1 ml_heading Option 1 | Option 1 option2 ml_heading Option 2 | Option 2 phone ml_heading Requestor's Phone # | Requestor's Phone # pmp_id ml_heading PM Procedure | PM Procedure pms_id ml_heading PM Schedule Code | PM Schedule Code priority ml_heading Work Request Priority | Work Request Priority prob_type ml_heading Problem Type | Problem Type repair_type ml_heading Repair Type | Repair Type requestor ml_heading Requested by | Requested by res_id ml_heading Reservation Code | Reservation Code rm_id ml_heading Room Code | Room Code rmres_id ml_heading Room Reservation Code | Room Reservation Code rsres_id ml_heading Resource Reservation Code | Resource Reservation Code satisfaction ml_heading Satisfaction Rating | Satisfaction Rating satisfaction_notes ml_heading Satisfaction Notes | Satisfaction Notes serv_window_days ml_heading Service Window Days | Service Window Days serv_window_end ml_heading Service Window End | Service Window End serv_window_start ml_heading Service Window Start | Service Window Start site_id ml_heading Site Code | Site Code status ml_heading Work Request Status | Work Request Status status_sort ml_heading Status Sort | Status Sort step_status ml_heading Work Request Step Status | Work Request Step Status time_completed ml_heading Time Work Completed | Time Work Completed time_escalation_completion ml_heading Time Escalation for Completion Occurs | Time Escalation for Completion Occurs time_escalation_response ml_heading Time Escalation for Response Occurs | Time Escalation for Response Occurs time_requested ml_heading Time Work Requested | Time Work Requested time_stat_chg ml_heading Time of Last Status Change | Time of Last Status Change tr_id ml_heading Primary Trade Required | Primary Trade Required vn_id ml_heading Primary Vendor | Primary Vendor wo_id ml_heading Assigned to Work Order | Assigned to Work Order work_team_id ml_heading Work Team Code | Work Team Code wr_id ml_heading Work Request Code | Work Request Code