![Page 1: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/1.jpg)
Consultants and SiteManager
![Page 2: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/2.jpg)
History
![Page 3: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/3.jpg)
History
• In 1988 the first TUG Conference was held in Oklahoma
• At that time, Oklahoma made a commitment to participate in the CMS, now known as SiteManager
• Oklahoma used a mainframe progressive estimate system for years, even with the first consultant contracts
• Oklahoma field offices had a single user to input all the pay quantities for all contracts
![Page 4: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/4.jpg)
History
• SiteManager enthusiasts saw the need to get the department prepared for the change ahead– Management – If it’s not broke, don’t fix it!– More personnel involved and educated– Better hardware
• What could buy us some time?
![Page 5: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/5.jpg)
Y2K Scare
• So here comes the Y2K scare.
• Mainframe breakdown?
• Used it as a concern
![Page 6: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/6.jpg)
History
• FieldManager• CAS• And the field offices started receiving laptops
![Page 7: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/7.jpg)
One Giant Leap
• After lots of planning, devotion, cussing, and swearing, SiteManager Construction was implemented in Oklahoma in 2004!
• Consultant contracts were still loaded into CAS until we could get them started in SiteManager
![Page 8: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/8.jpg)
Consultants in SiteManager???
• We issued the programs to the consultant offices.– SiteManager– VPN Client Software– Oracle
![Page 9: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/9.jpg)
Woohoo!!!
• The consultants were in SiteManager
![Page 10: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/10.jpg)
What???
• We couldn’t distinguish Oklahoma contracts from consultant contracts
![Page 11: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/11.jpg)
What Now????
• We needed to know which jobs in each division were given to the consultants
• We wanted the least impact on the user
![Page 12: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/12.jpg)
Brainstorming
![Page 13: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/13.jpg)
Consultant Codes
• We wanted to give the consultants a code that would easily distinguish them from the Oklahoma offices
• We wanted to add each consultant to each division
• We had it all figured out!
![Page 14: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/14.jpg)
Roadblock
![Page 15: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/15.jpg)
Roadblock
• What will this do to the other Trns·port modules?
• Historical data
• We determined this type of change would affect LAS, PES, the jobs we had left in CAS and FieldManager, and DSS as well as the closed contracts in SM.
![Page 16: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/16.jpg)
Resolution
• We realized at this point we needed InfoTech’s help
• The quote from InfoTech was substantial but we needed the change
• We started meeting with InfoTech
![Page 17: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/17.jpg)
Done
• December 1, 2007
• With InfoTech’s help, we ran the scripts they provided which updated the code in all affected areas
• The consultants were added using the same code format
![Page 18: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/18.jpg)
Residency CodesResidency Old Code New Code
DIV RES DIV RES
MUSKOGEE 1 1 01 100SALLISAW 1 2 01 200DIV. 1 BRIDGE 1 7 01 700ANTLERS 2 1 02 100HEAVENER 2 2 02 200
Consultants
EST ? ? DIV # 001Tetra Tech ? ? DIV # 002Cobb Eng ? ? DIV # 003
![Page 19: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/19.jpg)
What’s New
• We updated all the affected reports and reporting tools
• We even added a field in some SiteManager screens to make it easier on the user
![Page 20: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/20.jpg)
Contracts Screen
![Page 21: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/21.jpg)
Consultant Tracking
• This helps us make decisions on each consultant
• Keeps contract money from being tied up from consultant jobs
![Page 22: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/22.jpg)
In Closing
![Page 23: Consultants and SiteManager. History In 1988 the first TUG Conference was held in Oklahoma At that time, Oklahoma made a commitment to participate in](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649da25503460f94a8f4bc/html5/thumbnails/23.jpg)
Was it worth it?