ERMHDR 6.0.0 2013-02-20 Project admin Adminstrator dbxDatabaseNoName Project Management USD %T CURRTYPE %F curr_id decimal_digit_cnt curr_symbol decimal_symbol digit_group_symbol pos_curr_fmt_type neg_curr_fmt_type curr_type curr_short_name group_digit_cnt base_exch_rate %R 1 0 $ . , #1.1 (#1.1) Dollar USD 3 1 %R 10 2 $ . , #1.1 (#1.1) Argentine Peso ARS 3 3.077 %R 11 2 A$ . , #1.1 (#1.1) Australian Dollar AUST 3 1.208 %R 13 2 R$ . , #1.1 (#1.1) Brazilian Real BRL 3 2.014 %R 14 2 Ł . , #1.1 (#1.1) British Pound U.K.Ł 3 0.685097 %R 15 2 CA$ . , #1.1 (#1.1) Canadian Dollar CAD 3 1.10573 %R 16 2 Y . , #1.1 (#1.1) Chinese Yuan CNY 3 7.694 %R 17 2 € . , #1.1 (#1.1) EURO EUR 3 0.739088 %R 20 2 HK$ . , #1.1 (#1.1) Hong Kong Dollar HKD 3 7.81967 %R 21 2 Rs . , #1.1 (#1.1) Indian Rupee INR 3 40.67 %R 23 2 Ą . , #1.1 (#1.1) Japanese Yen JPY 3 120.167 %R 24 2 K . , #1.1 (#1.1) Korean Won KRW 3 924.743 %R 25 2 N$ . , #1.1 (#1.1) Mexican Peso MXN 3 10.7938 %R 26 2 R . , #1.1 (#1.1) Russian Rouble RUB 3 25.8085 %R 28 2 Sk . , #1.1 (#1.1) Swedish Krona SEK 3 6.80579 %R 29 2 kr . , #1.1 (#1.1) Swiss Franc CHF 3 1.21864 %R 30 2 NIS . , #1.1 (#1.1) Israel Shekel ILS 3 3.96384 %T OBS %F obs_id parent_obs_id guid seq_num obs_name obs_descr %R 565 0 Innovative GC %T PROJECT %F proj_id fy_start_month_num chng_eff_cmp_pct_flag rsrc_self_add_flag allow_complete_flag rsrc_multi_assign_flag ts_rsrc_mark_act_finish_flag ts_rsrc_vw_inact_actv_flag checkout_flag project_flag step_complete_flag cost_qty_recalc_flag sum_only_flag batch_sum_flag name_sep_char def_complete_pct_type proj_short_name acct_id orig_proj_id source_proj_id base_type_id clndr_id sum_base_proj_id task_code_base task_code_step priority_num wbs_max_sum_level risk_level strgy_priority_num last_checksum critical_drtn_hr_cnt def_cost_per_qty last_recalc_date plan_start_date plan_end_date scd_end_date add_date sum_data_date last_tasksum_date fcst_start_date def_duration_type task_code_prefix guid def_qty_type add_by_name web_local_root_path proj_url def_rate_type add_act_remain_flag act_this_per_link_flag def_task_type act_pct_link_flag critical_path_type task_code_prefix_flag def_rollup_dates_flag use_project_baseline_flag rem_target_link_flag reset_planned_flag allow_neg_act_flag sum_assign_level last_fin_dates_id last_baseline_update_date loaded_scope_level export_flag new_fin_dates_id next_data_date close_period_flag trsrcsum_loaded %R 759 1 N Y Y Y N N N Y N N N Y . CP_Drtn MQP-PGBT 720 1000 10 10 2 3 500 0 0 2013-07-15 00:00 2013-04-16 00:00 2013-08-22 17:00 2013-02-20 23:30 DT_FixedDUR2 A 70B+uIMhREi1boh5YY1XfA QT_Hour admin COST_PER_QTY N Y TT_Task Y CT_TotFloat Y Y Y Y N N SL_Taskrsrc 7 Y %T CALENDAR %F clndr_id default_flag clndr_name proj_id base_clndr_id last_chng_date clndr_type clndr_data %R 720 Y Standard 5 Day Workweek w/ Basic Holidays 2007-04-13 00:00 CA_Base (0||CalendarData()( (0||DaysOfWeek()( (0||1()()) (0||2()( (0||0(s|08:00|f|12:00)()) (0||1(s|13:00|f|17:00)()))) (0||3()( (0||0(s|08:00|f|12:00)()) (0||1(s|13:00|f|17:00)()))) (0||4()( (0||0(s|08:00|f|12:00)()) (0||1(s|13:00|f|17:00)()))) (0||5()( (0||0(s|08:00|f|12:00)()) (0||1(s|13:00|f|17:00)()))) (0||6()( (0||0(s|08:00|f|12:00)()) (0||1(s|13:00|f|17:00)()))) (0||7()()))) (0||VIEW(ShowTotal|Y)()) (0||Exceptions()( (0||0(d|37865)()) (0||1(d|37952)()) (0||2(d|37953)()) (0||3(d|37980)()) (0||4(d|37981)()) (0||5(d|37987)()) (0||6(d|38138)()) (0||7(d|38173)()) (0||8(d|38236)()) (0||9(d|38316)()) (0||10(d|38317)()) (0||11(d|38345)()) (0||12(d|38352)()) (0||13(d|38502)()) (0||14(d|38537)()) (0||15(d|38600)()) (0||16(d|38680)()) (0||17(d|38681)()) (0||18(d|38712)()) (0||19(d|38719)()) (0||20(d|38866)()) (0||21(d|38902)()) (0||22(d|38964)()) (0||23(d|39044)()) (0||24(d|39045)()) (0||25(d|39076)()) (0||26(d|39083)()) (0||27(d|39230)()) (0||28(d|39267)()) (0||29(d|39328)()) (0||30(d|39408)()) (0||31(d|39409)()) (0||32(d|39441)()) (0||33(d|39448)()) (0||34(d|39594)()) (0||35(d|39633)()) (0||36(d|39692)()) (0||37(d|39779)()) (0||38(d|39780)()) (0||39(d|39807)()) (0||40(d|39814)()) (0||41(d|39958)()) (0||42(d|39997)()) (0||43(d|40063)()) (0||44(d|40143)()) (0||45(d|40144)()) (0||46(d|40172)()) (0||47(d|40179)()) (0||48(d|40329)()) (0||49(d|40364)()) (0||50(d|40427)()) (0||51(d|40507)()) (0||52(d|40508)()) (0||53(d|40536)()))))) %T PROJWBS %F wbs_id proj_id obs_id seq_num est_wt proj_node_flag sum_data_flag status_code wbs_short_name wbs_name phase_id parent_wbs_id ev_user_pct ev_etc_user_value orig_cost indep_remain_total_cost ann_dscnt_rate_pct dscnt_period_type indep_remain_work_qty anticip_start_date anticip_end_date ev_compute_type ev_etc_compute_type guid tmpl_guid plan_open_state %R 10173 759 565 408 1 Y N WS_Open MQP-PGBT MQP-Parking Garage Bridge-Truss 4264 4 0.88 0 0 EC_Cmp_pct EE_Rem_hr Aap8OC8vk0GAIGMlUAKnFw %T SCHEDOPTIONS %F schedoptions_id proj_id sched_outer_depend_type sched_open_critical_flag sched_lag_early_start_flag sched_retained_logic sched_setplantoforecast sched_float_type sched_calendar_on_relationship_lag sched_use_expect_end_flag sched_progress_override level_float_thrs_cnt level_outer_assign_flag level_outer_assign_priority level_over_alloc_pct level_within_float_flag level_keep_sched_date_flag level_all_rsrc_flag LevelPriorityList %R 1 759 SD_Both N Y Y N FT_FF rcal_Predecessor Y N 0 N 5 25 N Y Y priority_type,ASC %T TASK %F task_id proj_id wbs_id clndr_id est_wt phys_complete_pct rev_fdbk_flag lock_plan_flag auto_compute_act_flag complete_pct_type task_type duration_type review_type status_code task_code task_name rsrc_id total_float_hr_cnt free_float_hr_cnt remain_drtn_hr_cnt act_work_qty remain_work_qty target_work_qty target_drtn_hr_cnt target_equip_qty act_equip_qty remain_equip_qty cstr_date act_start_date act_end_date late_start_date late_end_date expect_end_date early_start_date early_end_date restart_date reend_date target_start_date target_end_date review_end_date rem_late_start_date rem_late_end_date cstr_type priority_type suspend_date resume_date float_path float_path_order guid tmpl_guid cstr_date2 cstr_type2 driving_path_flag act_this_per_work_qty act_this_per_equip_qty external_early_start_date external_late_end_date create_date update_date create_user update_user old_restart_date old_reend_date old_remain_drtn_hr_cnt %R 80919 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1000 Elevated Slab 0 0 56 0 0 0 56 0 0 0 2013-08-13 08:00 2013-08-21 17:00 2013-08-13 08:00 2013-08-21 17:00 2013-08-13 08:00 2013-08-21 17:00 2013-08-13 08:00 2013-08-21 17:00 2013-08-13 08:00 2013-08-21 17:00 PT_Normal Ab13nk13tUOrfg5t4Ps2tQ Y 0 0 2013-02-20 23:30 2013-02-20 23:30 admin admin 2013-04-16 08:00 2013-04-24 17:00 56 %R 80920 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1010 Reinforcement-Elevated Slab 40 40 8 0 0 0 8 0 0 0 2013-08-21 08:00 2013-08-21 17:00 2013-08-14 08:00 2013-08-14 17:00 2013-08-14 08:00 2013-08-14 17:00 2013-08-14 08:00 2013-08-14 17:00 2013-08-21 08:00 2013-08-21 17:00 PT_Normal JCDEILsjt02XIP4XOx6GMw N 0 0 2013-02-04 22:47 2013-02-04 22:47 admin admin 2013-04-16 08:00 2013-04-16 17:00 8 %R 80921 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1020 Formwork-Elevated Slab 0 0 40 0 0 0 40 0 0 0 2013-08-06 08:00 2013-08-12 17:00 2013-08-06 08:00 2013-08-12 17:00 2013-08-06 08:00 2013-08-12 17:00 2013-08-06 08:00 2013-08-12 17:00 2013-08-06 08:00 2013-08-12 17:00 PT_Normal Ry+qiVKr1E+/kG7VlC6OTw Y 0 0 2013-02-04 22:47 2013-02-04 22:47 admin admin 2013-04-16 08:00 2013-04-22 17:00 40 %R 80922 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1040 Piers/Columns 0 0 56 0 0 0 56 0 0 0 2013-07-25 08:00 2013-08-02 17:00 2013-07-25 08:00 2013-08-02 17:00 2013-07-25 08:00 2013-08-02 17:00 2013-07-25 08:00 2013-08-02 17:00 2013-07-25 08:00 2013-08-02 17:00 PT_Normal FHQT9YIObkaq5z9XtFtZXQ Y 0 0 2013-02-20 23:30 2013-02-20 23:30 admin admin 2013-04-16 08:00 2013-04-24 17:00 56 %R 80923 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1050 Excavation 0 0 8 0 0 0 8 0 0 0 2013-07-15 08:00 2013-07-15 17:00 2013-07-15 08:00 2013-07-15 17:00 2013-07-15 08:00 2013-07-15 17:00 2013-07-15 08:00 2013-07-15 17:00 2013-07-15 08:00 2013-07-15 17:00 PT_Normal yX1zADs/a0qW5C9yRQtJcg Y 0 0 2013-02-04 22:47 2013-02-04 22:47 admin admin 2013-04-16 08:00 2013-04-16 17:00 8 %R 80924 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1060 Fill 216 216 8 0 0 0 8 0 0 0 2013-08-22 08:00 2013-08-22 17:00 2013-07-16 08:00 2013-07-16 17:00 2013-07-16 08:00 2013-07-16 17:00 2013-07-16 08:00 2013-07-16 17:00 2013-08-22 08:00 2013-08-22 17:00 PT_Normal 5Yp4gbdshEGMXhww7qBdwQ N 0 0 2013-02-04 22:47 2013-02-04 22:47 admin admin 2013-04-16 08:00 2013-04-16 17:00 8 %R 80925 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1080 Steel HSS Truss BC (L) 0 0 8 0 0 0 8 0 0 0 2013-08-05 08:00 2013-08-05 17:00 2013-08-05 08:00 2013-08-05 17:00 2013-08-05 08:00 2013-08-05 17:00 2013-08-05 08:00 2013-08-05 17:00 2013-08-05 08:00 2013-08-05 17:00 PT_Normal 7F1qSUmNKEOyQQKFea8F+g Y 0 0 2013-02-20 23:30 2013-02-20 23:30 admin admin 2013-04-16 08:00 2013-04-16 17:00 8 %R 80926 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1090 Footings 0 0 56 0 0 0 56 0 0 0 2013-07-16 08:00 2013-07-24 17:00 2013-07-16 08:00 2013-07-24 17:00 2013-07-16 08:00 2013-07-24 17:00 2013-07-16 08:00 2013-07-24 17:00 2013-07-16 08:00 2013-07-24 17:00 PT_Normal EMEFE6+2h0Co1D0QDZI8wA Y 0 0 2013-02-20 23:30 2013-02-20 23:30 admin admin 2013-04-16 08:00 2013-04-24 17:00 56 %R 80928 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1110 Steel HSS Truss TC (L) 80 0 8 0 0 0 8 0 0 0 2013-08-21 08:00 2013-08-21 17:00 2013-08-07 08:00 2013-08-07 17:00 2013-08-07 08:00 2013-08-07 17:00 2013-08-07 08:00 2013-08-07 17:00 2013-08-21 08:00 2013-08-21 17:00 PT_Normal ZmCQQTJxm0WARuYAoQhkmQ DkkHoex5QzSxJGvkoN0LDQ N 0 0 2013-02-20 23:30 2013-02-20 23:30 admin admin 2013-04-16 08:00 2013-04-16 17:00 8 %R 80929 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1120 Steel HSS Truss WEB (L) 80 0 8 0 0 0 8 0 0 0 2013-08-20 08:00 2013-08-20 17:00 2013-08-06 08:00 2013-08-06 17:00 2013-08-06 08:00 2013-08-06 17:00 2013-08-06 08:00 2013-08-06 17:00 2013-08-20 08:00 2013-08-20 17:00 PT_Normal /JRryuzYJEyIZHn+Gr0Ryg DkkHoex5QzSxJGvkoN0LDQ N 0 0 2013-02-20 23:30 2013-02-20 23:30 admin admin 2013-04-16 08:00 2013-04-16 17:00 8 %R 80930 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1130 Steel HSS Truss XRC 80 80 8 0 0 0 8 0 0 0 2013-08-22 08:00 2013-08-22 17:00 2013-08-08 08:00 2013-08-08 17:00 2013-08-08 08:00 2013-08-08 17:00 2013-08-08 08:00 2013-08-08 17:00 2013-08-22 08:00 2013-08-22 17:00 PT_Normal CfHk8xlzjUitzjOU2GcymQ DkkHoex5QzSxJGvkoN0LDQ N 0 0 2013-02-20 23:30 2013-02-20 23:34 admin admin 2013-04-16 08:00 2013-04-16 17:00 8 %R 80931 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1030 Railing 0 0 8 0 0 0 8 0 0 0 2013-08-22 08:00 2013-08-22 17:00 2013-08-22 08:00 2013-08-22 17:00 2013-08-22 08:00 2013-08-22 17:00 2013-08-22 08:00 2013-08-22 17:00 2013-08-22 08:00 2013-08-22 17:00 PT_Normal adjEg0Fr3E+v3T4UgiPOCg Y 0 0 2013-02-20 23:31 2013-02-20 23:31 admin admin 2013-04-16 00:00 2013-04-16 17:00 8 %R 80932 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1070 Procurement of Steel 8 8 224 0 0 0 224 0 0 0 2013-07-16 08:00 2013-08-22 17:00 2013-07-15 08:00 2013-08-21 17:00 2013-07-15 08:00 2013-08-21 17:00 2013-07-15 08:00 2013-08-21 17:00 2013-07-16 08:00 2013-08-22 17:00 PT_Normal lpwb9avPJE63pSt4nE9gEA N 0 0 2013-02-20 23:31 2013-02-20 23:31 admin admin 2013-04-16 08:00 2013-05-23 17:00 224 %R 80933 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1140 Procurement of Concrete 176 176 56 0 0 0 56 0 0 0 2013-08-14 08:00 2013-08-22 17:00 2013-07-15 08:00 2013-07-23 17:00 2013-07-15 08:00 2013-07-23 17:00 2013-07-15 08:00 2013-07-23 17:00 2013-08-14 08:00 2013-08-22 17:00 PT_Normal SWl/JGgdIUiqvOdkW3/xaQ N 0 0 2013-02-20 23:31 2013-02-20 23:31 admin admin 2013-04-16 08:00 2013-04-24 17:00 56 %R 80934 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1150 Wearing Surface 0 0 8 0 0 0 8 0 0 0 2013-08-22 08:00 2013-08-22 17:00 2013-08-22 08:00 2013-08-22 17:00 2013-08-22 08:00 2013-08-22 17:00 2013-08-22 08:00 2013-08-22 17:00 2013-08-22 08:00 2013-08-22 17:00 PT_Normal KXtPtVynE0WHEuZ0hyzxlg Y 0 0 2013-02-20 23:31 2013-02-20 23:31 admin admin 2013-04-16 00:00 2013-04-16 17:00 8 %R 80936 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1160 Steel HSS Truss BC (R) 0 0 8 0 0 0 8 0 0 0 2013-08-05 08:00 2013-08-05 17:00 2013-08-05 08:00 2013-08-05 17:00 2013-08-05 08:00 2013-08-05 17:00 2013-08-05 08:00 2013-08-05 17:00 2013-08-05 08:00 2013-08-05 17:00 PT_Normal NUc4hZhYRkalbyN7Gv7+mQ Y 0 0 2013-02-20 23:34 2013-02-20 23:34 admin admin 2013-04-16 00:00 2013-04-16 17:00 8 %R 80937 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1170 Steel HSS Truss TC (R) 80 0 8 0 0 0 8 0 0 0 2013-08-21 08:00 2013-08-21 17:00 2013-08-07 08:00 2013-08-07 17:00 2013-08-07 08:00 2013-08-07 17:00 2013-08-07 08:00 2013-08-07 17:00 2013-08-21 08:00 2013-08-21 17:00 PT_Normal JU0Tm0ldBUyh2oifAusl1w N 0 0 2013-02-20 23:34 2013-02-20 23:34 admin admin 2013-04-16 00:00 2013-04-16 17:00 8 %R 80939 759 10173 720 1 0 N N N CP_Drtn TT_Task DT_FixedDUR2 RV_OK TK_NotStart A1190 Steel HSS Truss WEB (R) 80 0 8 0 0 0 8 0 0 0 2013-08-20 08:00 2013-08-20 17:00 2013-08-06 08:00 2013-08-06 17:00 2013-08-06 08:00 2013-08-06 17:00 2013-08-06 08:00 2013-08-06 17:00 2013-08-20 08:00 2013-08-20 17:00 PT_Normal W01vFQlFx0WcTZEkjmXRgg N 0 0 2013-02-20 23:35 2013-02-20 23:35 admin admin 2013-04-16 00:00 2013-04-16 17:00 8 %T TASKPRED %F task_pred_id task_id pred_task_id proj_id pred_proj_id pred_type lag_hr_cnt float_path aref arls %R 67839 80924 80923 759 759 PR_FS 0 2013-07-15 17:00 2013-08-22 08:00 %R 67840 80926 80923 759 759 PR_FS 0 2013-07-15 17:00 2013-07-16 08:00 %R 67842 80929 80925 759 759 PR_FS 0 2013-08-05 17:00 2013-08-20 08:00 %R 67843 80928 80929 759 759 PR_FS 0 2013-08-06 17:00 2013-08-21 08:00 %R 67845 80930 80928 759 759 PR_FS 0 2013-08-07 17:00 2013-08-22 08:00 %R 67846 80930 80937 759 759 PR_FS 0 2013-08-07 17:00 2013-08-22 08:00 %R 67847 80939 80936 759 759 PR_FS 0 2013-08-05 17:00 2013-08-20 08:00 %R 67848 80937 80939 759 759 PR_FS 0 2013-08-06 17:00 2013-08-21 08:00 %R 67849 80919 80921 759 759 PR_FS 0 2013-08-12 17:00 2013-08-13 08:00 %R 67850 80920 80921 759 759 PR_FS 0 2013-08-12 17:00 2013-08-21 08:00 %R 67851 80921 80925 759 759 PR_FS 0 2013-08-05 17:00 2013-08-06 08:00 %R 67852 80921 80936 759 759 PR_FS 0 2013-08-05 17:00 2013-08-06 08:00 %R 67853 80922 80926 759 759 PR_FS 0 2013-07-24 17:00 2013-07-25 08:00 %R 67854 80925 80922 759 759 PR_FS 0 2013-08-02 17:00 2013-08-05 08:00 %R 67855 80936 80922 759 759 PR_FS 0 2013-08-02 17:00 2013-08-05 08:00 %R 67856 80934 80919 759 759 PR_FS 0 2013-08-21 17:00 2013-08-22 08:00 %R 67857 80934 80920 759 759 PR_FS 0 2013-08-14 17:00 2013-08-22 08:00 %R 67858 80931 80919 759 759 PR_FS 0 2013-08-21 17:00 2013-08-22 08:00 %R 67859 80931 80920 759 759 PR_FS 0 2013-08-14 17:00 2013-08-22 08:00 %R 67862 80931 80937 759 759 PR_FS 0 2013-08-07 17:00 2013-08-22 08:00 %R 67863 80931 80928 759 759 PR_FS 0 2013-08-07 17:00 2013-08-22 08:00 %R 67864 80920 80919 759 759 PR_SS 8 2013-08-13 17:00 2013-08-09 08:00 %E