ERMHDR 8.1 2016-03-08 Project tpemai2 Maida, John 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 2 $ . , #1.1 (#1.1) Dollar USD 3 1
%T OBS
%F obs_id parent_obs_id guid seq_num obs_name obs_descr
%R 565 0 NJDOT
%R 596 565 LL+UINMr1BGu5r+3J21jJh 0 Lambert, Dave (CPM) CPM
%R 597 596 C5vl3bIs1BG8fQAgr29D3R 4213957 Jaffe, Richard (CPS) Manager, Quality Management Services
%R 644 597 +agYywBO1BG6ngDAT1VREx 101 Systems Operations (SO)
%R 821 644 +0YwclYO3ku7TM8dvd9PXh 117 Grant, Sheryl
%T PCATTYPE
%F proj_catg_type_id seq_num proj_catg_short_len proj_catg_type
%R 21 0 5 UPC Number
%R 22 7 4 Project Manager
%R 25 13 11 Primary Designer
%R 29 9 2 Project Classification
%R 32 26 1 Construction - Region
%R 41 6 4 Program Manager
%R 42 21 2 County/Munic 1
%R 61 2 9 Contract No.
%R 62 22 2 County/Munic 2
%R 64 23 2 County/Munic 3
%R 68 20 2 Project Phase
%R 71 19 10 Schedule Type
%R 72 11 8 Construction Type
%R 78 14 3 Schedule Template Type
%T PCATVAL
%F proj_catg_id proj_catg_type_id seq_num proj_catg_short_name parent_proj_catg_id proj_catg_name
%R 3504 61 1 ######### Not Assigned
%R 3667 21 1 ##### Not Assigned
%R 3668 41 1 #### Not Assigned
%R 3669 22 1 #### Not Assigned
%R 3670 29 0 ## Not Assigned
%R 3671 25 2 ########### Not Assigned
%R 5459 42 0 ## Not Assigned
%R 5518 68 9 CO Construction
%R 5546 32 0 # Not Assigned
%R 5855 71 8 S1 Designer Schedule
%R 5857 62 0 ## Not Assigned
%R 5858 64 0 ## Not Assigned
%R 6166 72 0 ######## Not Assigned
%R 7962 78 1 1 Old Logic
%T PROJECT
%F proj_id fy_start_month_num rsrc_self_add_flag allow_complete_flag rsrc_multi_assign_flag checkout_flag project_flag step_complete_flag cost_qty_recalc_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 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 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 cr_external_key apply_actuals_date loaded_scope_level export_flag new_fin_dates_id next_data_date close_period_flag sum_refresh_date trsrcsum_loaded
%R 2237 1 Y Y Y N Y N N Y . CP_Units CNT0 1804 1000 10 10 0 0.00 2015-10-19 00:00 2001-06-26 00:00 2016-08-23 08:00 2002-02-27 00:00 DT_FixedDrtn A l9Ows1jU9kuJU5Y+JNq4th QT_Hour N COST_PER_QTY Y Y TT_Task N CT_DrivPath N N N Y Y N SL_Taskrsrc 7 Y 1899-12-30 00:00
%T CALENDAR
%F clndr_id default_flag clndr_name proj_id base_clndr_id last_chng_date clndr_type day_hr_cnt week_hr_cnt month_hr_cnt year_hr_cnt rsrc_private clndr_data
%R 1804 N CNT0 - Global 2011-07-27 00:00 CA_Base 8 40 172 2000 N (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|40791)()) (0||1(d|40826)()) (0||2(d|40855)()) (0||3(d|40858)()) (0||4(d|40871)()) (0||5(d|40903)()) (0||6(d|40910)()) (0||7(d|40924)()) (0||8(d|40959)()) (0||9(d|41005)()) (0||10(d|41057)()) (0||11(d|41094)()) (0||12(d|41155)()) (0||13(d|41190)()) (0||14(d|41219)()) (0||15(d|41225)()) (0||16(d|41235)()) (0||17(d|41268)())))))
%R 1805 N CNT0 - 1 - State Bus. Days 2013-12-24 00:00 CA_Base 8 40 172 2000 N (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|36892)()) (0||1(d|36934)()) (0||2(d|36941)()) (0||3(d|37076)()) (0||4(d|37137)()) (0||5(d|37172)()) (0||6(d|37201)()) (0||7(d|37207)()) (0||8(d|37217)()) (0||9(d|37250)()) (0||10(d|37257)()) (0||11(d|37277)()) (0||12(d|37299)()) (0||13(d|37305)()) (0||14(d|37344)()) (0||15(d|37403)()) (0||16(d|37441)()) (0||17(d|37501)()) (0||18(d|37543)()) (0||19(d|37565)()) (0||20(d|37571)()) (0||21(d|37588)()) (0||22(d|37615)()) (0||23(d|37622)()) (0||24(d|37641)()) (0||25(d|37664)()) (0||26(d|37669)()) (0||27(d|37729)()) (0||28(d|37767)()) (0||29(d|37806)()) (0||30(d|37865)()) (0||31(d|37907)()) (0||32(d|37929)()) (0||33(d|37936)()) (0||34(d|37952)()) (0||35(d|37980)()) (0||36(d|37987)()) (0||37(d|38005)()) (0||38(d|38029)()) (0||39(d|38033)()) (0||40(d|38086)()) (0||41(d|38138)()) (0||42(d|38173)()) (0||43(d|38236)()) (0||44(d|38271)()) (0||45(d|38293)()) (0||46(d|38302)()) (0||47(d|38316)()) (0||48(d|38345)()) (0||49(d|38352)()) (0||50(d|38369)()) (0||51(d|38394)()) (0||52(d|38404)()) (0||53(d|38436)()) (0||54(d|38502)()) (0||55(d|38537)()) (0||56(d|38600)()) (0||57(d|38635)()) (0||58(d|38664)()) (0||59(d|38667)()) (0||60(d|38680)()) (0||61(d|38712)()) (0||62(d|38719)()) (0||63(d|38733)()) (0||64(d|38761)()) (0||65(d|38768)()) (0||66(d|38821)()) (0||67(d|38866)()) (0||68(d|38902)()) (0||69(d|38964)()) (0||70(d|38999)()) (0||71(d|39028)()) (0||72(d|39031)()) (0||73(d|39044)()) (0||74(d|39076)()) (0||75(d|39083)()) (0||76(d|39097)()) (0||77(d|39125)()) (0||78(d|39132)()) (0||79(d|39178)()) (0||80(d|39230)()) (0||81(d|39267)()) (0||82(d|39328)()) (0||83(d|39363)()) (0||84(d|39392)()) (0||85(d|39398)()) (0||86(d|39408)()) (0||87(d|39441)()) (0||88(d|39448)()) (0||89(d|39468)()) (0||90(d|39490)()) (0||91(d|39496)()) (0||92(d|39528)()) (0||93(d|39594)()) (0||94(d|39633)()) (0||95(d|39692)()) (0||96(d|39734)()) (0||97(d|39756)()) (0||98(d|39763)()) (0||99(d|39779)()) (0||100(d|39807)()) (0||101(d|39814)()) (0||102(d|39832)()) (0||103(d|39856)()) (0||104(d|39860)()) (0||105(d|39913)()) (0||106(d|39958)()) (0||107(d|39997)()) (0||108(d|40063)()) (0||109(d|40098)()) (0||110(d|40120)()) (0||111(d|40128)()) (0||112(d|40172)()) (0||113(d|40179)()) (0||114(d|40196)()) (0||115(d|40221)()) (0||116(d|40224)()) (0||117(d|40270)()) (0||118(d|40329)()) (0||119(d|40364)()) (0||120(d|40427)()) (0||121(d|40462)()) (0||122(d|40484)()) (0||123(d|40493)()) (0||124(d|40507)()) (0||125(d|40536)()) (0||126(d|40543)()) (0||127(d|40585)()) (0||128(d|40634)( (0||0(s|08:00|f|16:00)()))) (0||129(d|40637)( (0||0(s|08:00|f|16:00)()))) (0||130(d|40638)( (0||0(s|08:00|f|16:00)()))) (0||131(d|40639)( (0||0(s|08:00|f|16:00)()))) (0||132(d|40640)( (0||0(s|08:00|f|16:00)()))) (0||133(d|40641)( (0||0(s|08:00|f|16:00)()))) (0||134(d|40644)( (0||0(s|08:00|f|16:00)()))) (0||135(d|40645)( (0||0(s|08:00|f|16:00)()))) (0||136(d|40646)( (0||0(s|08:00|f|16:00)()))) (0||137(d|40647)( (0||0(s|08:00|f|16:00)()))) (0||138(d|40648)( (0||0(s|08:00|f|16:00)()))) (0||139(d|40651)( (0||0(s|08:00|f|16:00)()))) (0||140(d|40652)( (0||0(s|08:00|f|16:00)()))) (0||141(d|40653)( (0||0(s|08:00|f|16:00)()))) (0||142(d|40654)( (0||0(s|08:00|f|16:00)()))) (0||143(d|40655)( (0||0(s|08:00|f|16:00)()))) (0||144(d|40658)( (0||0(s|08:00|f|16:00)()))) (0||145(d|40659)( (0||0(s|08:00|f|16:00)()))) (0||146(d|40660)( (0||0(s|08:00|f|16:00)()))) (0||147(d|40661)( (0||0(s|08:00|f|16:00)()))) (0||148(d|40662)( (0||0(s|08:00|f|16:00)()))) (0||149(d|40728)()) (0||150(d|40791)()) (0||151(d|40826)()) (0||152(d|40855)()) (0||153(d|40858)()) (0||154(d|40871)()) (0||155(d|40903)()) (0||156(d|40910)()) (0||157(d|40924)()) (0||158(d|40959)()) (0||159(d|41005)()) (0||160(d|41057)()) (0||161(d|41094)()) (0||162(d|41155)()) (0||163(d|41190)()) (0||164(d|41219)()) (0||165(d|41225)()) (0||166(d|41235)()) (0||167(d|41268)()) (0||168(d|41275)()) (0||169(d|41295)()) (0||170(d|41323)()) (0||171(d|41362)()) (0||172(d|41421)()) (0||173(d|41459)()) (0||174(d|41519)()) (0||175(d|41561)()) (0||176(d|41583)()) (0||177(d|41589)()) (0||178(d|41606)()) (0||179(d|41633)()) (0||180(d|41640)()) (0||181(d|41659)()) (0||182(d|41687)()) (0||183(d|41718)( (0||0(s|08:00|f|16:00)()))) (0||184(d|41747)()) (0||185(d|41757)( (0||0(s|08:00|f|16:00)()))) (0||186(d|41785)()) (0||187(d|41794)( (0||0(s|08:00|f|16:00)()))) (0||188(d|41824)()) (0||189(d|41883)()) (0||190(d|41908)( (0||0(s|08:00|f|16:00)()))) (0||191(d|41925)()) (0||192(d|41947)()) (0||193(d|41954)()) (0||194(d|41970)()) (0||195(d|41998)()) (0||196(d|42005)()) (0||197(d|42023)()) (0||198(d|42051)()) (0||199(d|42097)()) (0||200(d|42149)()) (0||201(d|42188)()) (0||202(d|42254)()) (0||203(d|42289)()) (0||204(d|42311)()) (0||205(d|42319)()) (0||206(d|42334)()) (0||207(d|42363)()) (0||208(d|42370)()) (0||209(d|42387)()) (0||210(d|42415)()) (0||211(d|42454)()) (0||212(d|42520)()) (0||213(d|42555)()) (0||214(d|42587)()) (0||215(d|42653)()) (0||216(d|42682)()) (0||217(d|42685)()) (0||218(d|42698)()) (0||219(d|42730)()) (0||220(d|42737)()) (0||221(d|42751)()) (0||222(d|42786)()) (0||223(d|42839)()) (0||224(d|42884)()) (0||225(d|42920)()) (0||226(d|42982)()) (0||227(d|43017)()) (0||228(d|43046)()) (0||229(d|43049)()) (0||230(d|43062)()) (0||231(d|43094)())))))
%R 5035 N CNT0 - 4 - 7 Day Work Week 2007-05-02 00:00 CA_Base 8 40 172 2000 N (0||CalendarData()( (0||DaysOfWeek()( (0||1()( (0||0(s|08:00|f|12:00)()) (0||1(s|13:00|f|17:00)()))) (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||0(s|08:00|f|12:00)()) (0||1(s|13:00|f|17:00)()))))) (0||VIEW(ShowTotal|Y)()) (0||Exceptions()())))
%T PROJPCAT
%F proj_id proj_catg_type_id proj_catg_id
%R 2237 21 3667
%R 2237 22 3669
%R 2237 25 3671
%R 2237 29 3670
%R 2237 32 5546
%R 2237 41 3668
%R 2237 42 5459
%R 2237 61 3504
%R 2237 62 5857
%R 2237 64 5858
%R 2237 68 5518
%R 2237 71 5855
%R 2237 72 6166
%R 2237 78 7962
%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 sched_use_project_end_date_for_float enable_multiple_longest_path_calc limit_multiple_longest_path_calc max_multiple_longest_path use_total_float_multiple_longest_paths key_activity_for_multiple_longest_paths LevelPriorityList
%R 1 2237 SD_Both N Y Y N FT_FF rcal_Predecessor Y N 0 N 5 25 N Y Y Y N Y 10 Y priority_type,ASC
%T PROJWBS
%F wbs_id proj_id obs_id seq_num 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 39411 2237 821 1800 Y N WS_Closed CNT0 Construction Scheduling Template 4284 0.00 0.00 EC_Cmp_pct EE_Rem_hr 71jGHgYxZESZ0dlPJKyNsx
%R 39412 2237 821 13640 N N WS_Closed P Procurement 39411 0.00 0.00 EC_Cmp_pct EE_Rem_hr BihZkbbXtkGYhCGQoqu4Ph
%R 39413 2237 821 13180 N N WS_Closed C Construction 39411 0.00 0.00 EC_Cmp_pct EE_Rem_hr SpP7tFSVC0G9iPDdMOrZFR
%R 39414 2237 821 13170 N N WS_Closed 0 Milestones 39411 0.00 0.00 EC_Cmp_pct EE_Rem_hr w7pbNUyU6kKLx3ENz8x9YR
%R 39415 2237 821 13620 N N WS_Closed 10 Final Cleanup 39413 0.00 0.00 EC_Cmp_pct EE_Rem_hr Co8rJ/f0NU2J0R8cQYQ7JB
%R 39416 2237 821 13650 N N WS_Closed CS Contractor Submittals (Not Materials) 39412 0.00 0.00 EC_Cmp_pct EE_Rem_hr fYlHZbQyIEG+AagivpMi1B
%R 39417 2237 821 13190 N N WS_Closed 00 Administrative 39413 0.00 0.00 EC_Cmp_pct EE_Rem_hr QR40dovgOE2lJX7GSKnxJB
%R 39418 2237 821 13200 N N WS_Closed 01 Stage 1 39413 0.00 0.00 EC_Cmp_pct EE_Rem_hr Pnurpry81EGaLLq04TOgAB
%R 39419 2237 821 13660 N N WS_Closed 01 Safety Plan 39416 0.00 0.00 EC_Cmp_pct EE_Rem_hr SI4LXcG9Ak+JLrcgTNJ/7h
%R 39420 2237 821 13201 N N WS_Closed 1A Stage 1 A 39418 0.00 0.00 EC_Cmp_pct EE_Rem_hr iq5ZnkW4aU25TxK0NojNVh
%R 108090 2237 821 13201 N N WS_Closed 1B Stage 1 B 39418 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr hdVFSPsWJkG0EmpcAJUabR
%R 108091 2237 821 13201 N N WS_Closed 1C Stage 1 C 39418 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr WlpkgveGa0Clm4hFDddSGR
%R 108092 2237 821 13210 N N WS_Closed 1D Stage 1 D 39418 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr LDSsqedIlE2gbBwuE9ax0R
%R 108093 2237 821 13201 N N WS_Closed 02 Stage 2 39413 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr jRCaGuK4M0mLk5aDoI9tcx
%R 108094 2237 821 13201 N N WS_Closed 2A Stage 2 A 108093 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr 5NU1i9u3SkCIcGXGwUSg3B
%R 108095 2237 821 13203 N N WS_Closed 2B Stage 2 B 108093 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr vmq9LkB+r0GXVQOgMLwUxB
%R 108096 2237 821 13203 N N WS_Closed 2C Stage 2 C 108093 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr LsR6LG+A80S/kci1JANbNh
%R 108097 2237 821 13203 N N WS_Closed 2D Stage 2 D 108093 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr TqXpK/gHX0y4iAtBr5ZAAh
%R 108098 2237 821 13202 N N WS_Closed 03 Stage 3 39413 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr KISzRVpJPUidwYYo1dYySR
%R 108099 2237 821 13203 N N WS_Closed 3A Stage 3 A 108098 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr ImxKKBLgGUyCKVn4uHwcyR
%R 108100 2237 821 13203 N N WS_Closed 3B Stage 3 B 108098 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr WhG1/Fh/bU+/rzGZATgpYR
%R 108101 2237 821 13203 N N WS_Closed 3C Stage 3 C 108098 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr rmWPiu0UO0efJWG+ybwDNR
%R 108102 2237 821 13203 N N WS_Closed 3D Stage 3 D 108098 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr z7+fbOMWmkKfbiLLVozYZB
%R 108103 2237 821 13203 N N WS_Closed 04 Stage 4 39413 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr h381oSh0HEqcMZ+ZBJa5sh
%R 108104 2237 821 13204 N N WS_Closed 4A Stage 4 A 108103 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr RwjmRmRUzky+I1KmQLjnUR
%R 108105 2237 821 13204 N N WS_Closed 4B Stage 4 B 108103 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr Hf9aWc/kWkiPoLkeT3zdTB
%R 108106 2237 821 13204 N N WS_Closed 4C Stage 4 C 108103 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr eQ6IVNZnh0atbtn5rYrCjR
%R 108107 2237 821 13204 N N WS_Closed 4D Stage 4 D 108103 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr rRS0+thVukeWyTFCVuwpAR
%R 108108 2237 821 13204 N N WS_Closed 05 Stage 5 39413 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr z7QvLVSE3kyoo00OvJ9lbB
%R 108109 2237 821 13205 N N WS_Closed 5A Stage 5 A 108108 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr J3WNRXKnTU+js27VIbWgSB
%R 108110 2237 821 13205 N N WS_Closed 5B Stage 5 B 108108 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr 2SDiczhhoUae+kRJ/NnVux
%R 108111 2237 821 13205 N N WS_Closed 5C Stage 5 C 108108 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr ExpbhhC9xUu3egSX9c3muB
%R 108112 2237 821 13205 N N WS_Closed 5D Stage 5 D 108108 0 0 0.00 0.00 EC_Cmp_pct EE_Rem_hr KUiCT80nIEa0mnJG1Zui0x
%T ACTVTYPE
%F actv_code_type_id actv_short_len seq_num actv_code_type proj_id wbs_id actv_code_type_scope
%R 1297 4 17340 RESP - Responsibility AS_Global
%T TASK
%F task_id proj_id wbs_id clndr_id phys_complete_pct rev_fdbk_flag lock_plan_flag auto_compute_act_flag complete_pct_type task_type duration_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 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
%R 268734 2237 39417 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart A100 Time frame between Advertisement and Bid(Verify) 0 0 120 0 0 0 120 0 0 0 2015-10-19 08:00 2015-11-09 17:00 2015-10-19 08:00 2015-11-09 17:00 2015-10-19 08:00 2015-11-09 17:00 2015-10-19 08:00 2015-11-09 17:00 2015-10-19 08:00 2015-11-09 17:00 PT_Normal Ac42gVLEE0KqR83qrId7Ox Y 0 0 2015-10-20 11:41 tp2szar
%R 268735 2237 39417 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart A200 Time frame Between Bid and Award -Verify Duration 0 0 120 0 0 0 120 0 0 0 2015-11-10 08:00 2015-12-02 17:00 2015-11-10 08:00 2015-12-02 17:00 2015-11-10 08:00 2015-12-02 17:00 2015-11-10 08:00 2015-12-02 17:00 2015-11-10 08:00 2015-12-02 17:00 PT_Normal Qf/bbDInCEOZ3BELxNOlpx Y 0 0 2015-10-20 11:41 tp2szar
%R 268736 2237 39417 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart A300 Time frame Between Award and Construction -Verify 0 0 320 0 0 0 320 0 0 0 2015-12-03 08:00 2016-02-01 17:00 2015-12-03 08:00 2016-02-01 17:00 2015-12-03 08:00 2016-02-01 17:00 2015-12-03 08:00 2016-02-01 17:00 2015-12-03 08:00 2016-02-01 17:00 PT_Normal Bu2e5n8uwUGYaXuKY0E5CB Y 0 0 2015-10-20 11:41 tp2szar
%R 268737 2237 39420 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart C100 Blank Activity to Show Scheduling WBS 0 0 800 0 0 0 800 0 0 0 2016-02-02 08:00 2016-06-23 17:00 2016-02-02 08:00 2016-06-23 17:00 2016-02-02 08:00 2016-06-23 17:00 2016-02-02 08:00 2016-06-23 17:00 2016-02-02 08:00 2016-06-23 17:00 PT_Normal 7BmZQWpcOUWJ58rFTj0mcB Y 0 0 2015-10-20 11:41 tp2szar
%R 268738 2237 39415 5035 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart F9000 Final Cleanup - Punch list - Submittals 0 0 480 0 0 0 480 0 0 0 2016-06-24 08:00 2016-08-22 17:00 2016-06-24 08:00 2016-08-22 17:00 2016-06-24 08:00 2016-08-22 17:00 2016-06-24 08:00 2016-08-22 17:00 2016-06-24 08:00 2016-08-22 17:00 PT_Normal Vckv5xJtaEu+z6ipxrLMhB Y 0 0 2015-10-20 11:41 tp2szar
%R 268739 2237 39414 1805 0 N N Y CP_Drtn TT_Mile DT_FixedDrtn TK_NotStart M100 Advertise Date 0 0 0 0 0 0 0 0 0 0 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 PT_Normal cW0jLnQOD0S9pHFhmgNbrh Y 0 0 2015-10-20 11:41 tp2szar
%R 268740 2237 39414 1805 0 N N Y CP_Drtn TT_Mile DT_FixedDrtn TK_NotStart M200 Bid Date 0 0 0 0 0 0 0 0 0 0 2015-11-10 08:00 2015-11-10 08:00 2015-11-10 08:00 2015-11-10 08:00 2015-11-10 08:00 2015-11-10 08:00 2015-11-10 08:00 2015-11-10 08:00 2015-11-10 08:00 2015-11-10 08:00 PT_Normal uKsASneHdUavsGY2xyJiJx Y 0 0 2015-10-20 11:41 tp2szar
%R 268741 2237 39414 1805 0 N N Y CP_Drtn TT_Mile DT_FixedDrtn TK_NotStart M300 Award Date 0 0 0 0 0 0 0 0 0 0 2015-12-03 08:00 2015-12-03 08:00 2015-12-03 08:00 2015-12-03 08:00 2015-12-03 08:00 2015-12-03 08:00 2015-12-03 08:00 2015-12-03 08:00 2015-12-03 08:00 2015-12-03 08:00 PT_Normal J9582AFmYEOLs9dX2wTF1R Y 0 0 2015-10-20 11:41 tp2szar
%R 268742 2237 39414 1805 0 N N Y CP_Drtn TT_Mile DT_FixedDrtn TK_NotStart M400 Start Design Work (Design/Build only) 1680 1680 0 0 0 0 0 0 0 0 2016-08-23 08:00 2016-08-23 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2016-08-23 08:00 2016-08-23 08:00 PT_Normal 4FB9bhskVki7oV6JD1LHrh N 0 0 2015-10-20 11:41 tp2szar
%R 268743 2237 39414 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart M480 Complete Design Work (Design/Build only) 1680 1680 0 0 0 0 0 0 0 0 2016-08-22 17:00 2016-08-22 17:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2016-08-22 17:00 2016-08-22 17:00 PT_Normal h6SBCW7j+kyxj/VHhQGKhB N 0 0 2015-10-20 11:41 tp2szar
%R 268744 2237 39414 1805 0 N N Y CP_Drtn TT_Mile DT_FixedDrtn TK_NotStart M500 Construction Start Date 0 0 0 0 0 0 0 0 0 0 2016-02-02 08:00 2016-02-02 08:00 2016-02-02 08:00 2016-02-02 08:00 2016-02-02 08:00 2016-02-02 08:00 2016-02-02 08:00 2016-02-02 08:00 2016-02-02 08:00 2016-02-02 08:00 PT_Normal 4seYvuNM5kW5RVMIH5URHh Y 0 0 2015-10-20 11:41 tp2szar
%R 268745 2237 39414 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart M600 Stage __ Complete (Increase by 5) 1680 1680 0 0 0 0 0 0 0 0 2016-08-22 17:00 2016-08-22 17:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2016-08-22 17:00 2016-08-22 17:00 PT_Normal 62KHgjIGhUqJ0typJ1lDjx N 0 0 2015-10-20 11:41 tp2szar
%R 268746 2237 39414 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart M700 Interim Completion Date(s) (Increase by 10) 1680 1680 0 0 0 0 0 0 0 0 2016-08-22 17:00 2016-08-22 17:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2016-08-22 17:00 2016-08-22 17:00 PT_Normal YILBl/HzIUG/M8GZkq6/+h N 0 0 2015-10-20 11:41 tp2szar
%R 268747 2237 39414 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart M800 ROW Availability Date (Increase by 5) 1680 1680 0 0 0 0 0 0 0 0 2016-08-22 17:00 2016-08-22 17:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2015-10-19 08:00 2016-08-22 17:00 2016-08-22 17:00 PT_Normal DF+zNbPBt0GEdLUfPgnKFR N 0 0 2015-10-20 11:41 tp2szar
%R 268748 2237 39414 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart M900 Substantial Completion 0 0 0 0 0 0 0 0 0 0 2016-06-23 17:00 2016-06-23 17:00 2016-06-24 08:00 2016-06-24 08:00 2016-06-24 08:00 2016-06-24 08:00 2016-06-24 08:00 2016-06-24 08:00 2016-06-23 17:00 2016-06-23 17:00 PT_Normal krq6jdKlikOUyDLxRjPxQR Y 0 0 2015-10-20 11:41 tp2szar
%R 268749 2237 39414 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart M950 Completion 0 0 0 0 0 0 0 0 0 0 2016-08-22 17:00 2016-08-22 17:00 2016-08-23 08:00 2016-08-23 08:00 2016-08-23 08:00 2016-08-23 08:00 2016-08-23 08:00 2016-08-23 08:00 2016-08-22 17:00 2016-08-22 17:00 PT_Normal eBAdWfeV7EGFLJC2vTQy4B Y 0 0 2015-10-20 11:41 tp2szar
%R 268750 2237 39419 1805 0 N N Y CP_Drtn TT_Task DT_FixedDrtn TK_NotStart PS100 Safety Plan (For Display Purposes) 1520 1520 160 0 0 0 160 0 0 0 2016-07-25 08:00 2016-08-22 17:00 2015-10-19 08:00 2015-11-17 17:00 2015-10-19 08:00 2015-11-17 17:00 2015-10-19 08:00 2015-11-17 17:00 2016-07-25 08:00 2016-08-22 17:00 PT_Normal FBStKlfZakyVoYTUriY2Yh N 0 0 2015-10-20 11:41 tp2szar
%T ACTVCODE
%F actv_code_id parent_actv_code_id actv_code_type_id actv_code_name short_name seq_num color
%R 70257 1297 Prime Contractor CONP 10
%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 330420 268740 268734 2237 2237 PR_FS 0 2015-11-09 17:00 2015-11-10 08:00
%R 330421 268741 268735 2237 2237 PR_FS 0 2015-12-02 17:00 2015-12-03 08:00
%R 330422 268744 268736 2237 2237 PR_FS 0 2016-02-01 17:00 2016-02-02 08:00
%R 330423 268748 268737 2237 2237 PR_FS 0 2016-06-23 17:00 2016-06-23 17:00
%R 330424 268749 268738 2237 2237 PR_FS 0 2016-08-22 17:00 2016-08-22 17:00
%R 330425 268734 268739 2237 2237 PR_FS 0 2015-10-19 08:00 2015-10-19 08:00
%R 330426 268735 268740 2237 2237 PR_FS 0 2015-11-10 08:00 2015-11-10 08:00
%R 330427 268736 268741 2237 2237 PR_FS 0 2015-12-03 08:00 2015-12-03 08:00
%R 330428 268737 268744 2237 2237 PR_FS 0 2016-02-02 08:00 2016-02-02 08:00
%R 330429 268738 268748 2237 2237 PR_FS 0 2016-06-24 08:00 2016-06-24 08:00
%T TASKACTV
%F task_id actv_code_type_id actv_code_id proj_id
%R 268738 1297 70257 2237
%E