The Work tables store information about Work Orders, Requests, PM's, Project Management, and Planning.
TableName |
Description |
Account Number Inventory |
|
Action Limit List Table |
|
Assigned By Limit List Table |
|
Field setup table for Asset default values |
|
Asset Default Value fields |
|
Work Building Permits |
|
Work Building Permit Inspections |
|
Userdefined Categories |
|
Stores a list of fields that will be included in a work asset lookup |
|
Project Cost Centers |
|
Routine Work Check List |
|
Work Task Check List |
|
Work Order Check List |
|
Classification Resources |
|
Work Employee Classes to Budget Allocation Linking Table |
|
Work Employee Classes to Employee Setup Linking Table |
|
Relate table between GCLSSFLD and UCLSSFLD and WKUCLASS |
|
Relate table between GCONTFLD and UCONTFLD and WKUCON |
|
Relate table between GCREWFLD AND UCREWLD and WKUCREW |
|
Employee Certification Classes |
|
Work Employee Classes to Certification Linking Table |
|
Crew Resources |
|
Daily Inspection Bacti Testing |
|
Work Order Inspection Construction Activity |
|
Daily Inspection Easement Tab |
|
Work Order Inspections |
|
Daily Inspection Contractors |
|
Daily Inspection Staff |
|
Daily Inspection Equipment |
|
Daily Inspection Tracking |
|
Eden Account Number Tracking |
|
Employee Certifications |
|
Work Certifications to Employee Setup Linking Table |
|
Assigned By Limit List Table |
|
Eden Project Number Tracking |
|
Relate table between GEQIPFLD AND UEQIPFLD and WKUEQT |
|
Exclusion Day Setup |
|
Task Work Flow Steps |
|
Relate table between GFLUIDFLD and UFLUIDFLD and WKFLUID |
|
Fiscal Year |
|
Grid Memo |
|
Line Geometry Table |
|
Polygon Geometry Table |
|
Point Geometry Table |
|
Links the PDA Sync module to Categories |
|
PDA Sync Setup module |
|
Statistics for PDA Sync Module |
|
Relate table between GLEADFLD AND ULEADFLD in the user db and WKUEMP |
|
Memo Table |
|
Assets on Master Projects |
|
Relate table between GMTRFLD and UMTRFLD and WKMTR |
|
Request Notification Comments |
|
Work Orders |
|
Work Order Locations |
|
Table to hold defined pay periods for timesheet |
|
Planning by Department |
|
Work Permits |
|
Assets on Work Permits |
|
Permit Conversations |
|
Work Permit Check List |
|
Daily Inspection for Permits |
|
Final Inspection Correction List for Permits |
|
Permit Enforcement |
|
Permit Enforcement Type |
|
Permit Type Fees |
|
Work Permit Type Setup Fees |
|
Permit Locations |
|
Work Permit Types |
|
Work Permit Type Setup Checklist |
|
Work Permit Type Setup |
|
Permit and WO Link table |
|
Permit Email Tracking |
|
Work Project Management Program |
|
Sub Project |
|
Project Contracts |
|
Project Contract Approver Library |
|
Project Contract Approver Library Details |
|
Project Contract Details |
|
Project Contract Estimates |
|
Project Contract Approver Library |
|
Project Contract Estimate Details |
|
Final Inspection for Contracts |
|
Project Contract Final Inspection Approver List |
|
Contractors on Final Inspection for Contracts |
|
Final Inspection Correction List for Contracts |
|
Final Inspection Attendees for Contracts |
|
Daily Inspection for Contracts |
|
Project Contract Daily Inspection Approver List |
|
Contractors on Daily Inspection for Contracts |
|
Equipment on Daily Inspection for Contracts |
|
Project Contract Daily Inspection Approver Library |
|
Project Contract Daily Inspection Approver Library Details |
|
Work Project and Contract Linking Table |
|
Lab Testing for Contracts |
|
Maintenance Bond Inspections for Contracts |
|
Project Contract Maintenance Bond Inspection Approver List |
|
Contractors on Maintenance Bonds for Contracts |
|
Maintenance Bond Correction List for Contracts |
|
Project Change Orders |
|
Project Conversations |
|
Water Test Requests for Contracts |
|
Project Contract Water Test Results Approver List |
|
Water Test Request - Pipes Tested for Contracts |
|
Project Expenditures |
|
Project Funding Ecumbrances or Purchase Orders |
|
Purchase Order Change Orders |
|
Project Contractor Invoices |
|
Project Invoice Details |
|
Project Invoice PO Details |
|
Project PO Details |
|
Project PO Details Line Items |
|
Project PO Details Line Items Linked to Invoices |
|
Daily Inspection for Project |
|
Equipment on Daily Inspection for Projects |
|
Contractors on Daily Inspection for Projects |
|
Final Inspection for Project |
|
Contractors on Final Inspection for Projects |
|
Final Inspection Correction List for Contracts |
|
Final Inspection Attendees for Contracts |
|
Project Contractor Payments |
|
Project PO and Work Order Linking Table |
|
Project Grant Funding |
|
Project Invoice Payments |
|
Lab Testing for Project |
|
Master Project |
|
Maintenance Bond Inspections for Projects |
|
Contractors on Maintenance Bonds for Projects |
|
Maintenance Bond Correction List for Projects |
|
Master Project Activity table |
|
Master Project Activity History table |
|
Master Project Activity Lookup Table |
|
Master Project Activity Lookup Detail Table |
|
Work Project - Permits Connected |
|
Project Activities |
|
Project Activities History |
|
Project Revenue Sources |
|
Project Subcontractors |
|
Project Tasks |
|
Project Sub Tasks |
|
Water Test Requests for Projects |
|
Water Test Request - Pipes Tested for Contracts |
|
Planning by Tasks for Category |
|
Planning Task Resources |
|
Requests |
|
Table used to store the unique email/request pairing |
|
Request Feedback |
|
Work Request Locations |
|
Request Notifications |
|
Requesters |
|
Request Tracking data |
|
Work Order Resources |
|
Cost Setup Markup Library Details |
|
Work Routines |
|
Assets on requests |
|
Routine Work Exclusion Days |
|
Work PM Asset Filter Table |
|
Routine Work Locations |
|
Grouped PM Scheduling |
|
Routine Work - Other PMs Affected |
|
Routine Work Resources |
|
Routine Work System ID table |
|
Work PM Tracking Table |
|
Routine Work Tasks |
|
Scheduled PMs per Year |
|
Problem Script Setup |
|
Request Scripts |
|
Work Flow Setup Shift |
|
Table to track spatial changes in the work records |
|
Table to store the user-defined timesheets |
|
Table to hold fields assigned to Timesheets |
|
Table to store which groups have been assigned to timesheets |
|
Table used to hold timesheet locks added by supervisors |
|
Used to store records of when timesheets were submitted |
|
Holds Subsets for Reports |
|
Master Project Email Tracking Table |
|
Master Project Employee Tracking Table |
|
Project Purchase Order Email Tracking Table |
|
LINKING TASKS TO ASSETS ON WORK ORDERS |
|
Account Numbers |
|
Asset Class Library |
|
Work Asset Class System Asset Component Records |
|
Architect/Engineer Setup |
|
Asset Class Associating Asset to Forms |
|
Alternate Zones |
|
Work Flow Setup Causes |
|
Classification Setup |
|
Cost Markup Setup Library |
|
Cost Setup Markup Library Details |
|
Contractor Setup |
|
Work Flow Setup Crews |
|
Work Flow Setup Employees |
|
Work Flow Setup Associating Employees to Parts Warehousing |
|
Work Flow Setup Equipment |
|
Work Flow Setup Equipment Availability |
|
Fluid Setup |
|
Work Flow Setup Materials |
|
Maintenance Zones |
|
Work Flow Setup Problems |
|
Project Account Numbers |
|
Work Flow Setup Associating Causes to Categories |
|
Categories to Classifications |
|
Categories to Contractors |
|
Work Flow Setup Associating Crews to Categories |
|
Work Flow Setup Associating Employees to Categories |
|
Work Flow Setup Associating Equipment to Categories |
|
Categories to Fluids |
|
Work Flow Setup Associating Materials to Categories |
|
Work Flow Setup Associating Problems to Categories |
|
Work Flow Setup Problem Notifications Category Specific |
|
Work Flow Setup Associating Tasks to Category |
|
Work Flow Setup Task Notifications Category Specific |
|
Equipment Employee Usage |
|
Work Flow Setup Resulting Tasks |
|
Work Flow Setup Associating Problems to Maintenance Zones |
|
Work System Assembly Component |
|
Work Flow Setup Tasks (Actions) |
|
Utility Locate |
|
Utility Checklist Setup |
|
Utility Checklist Setup Items |
|
Utility Locate Checklist |
|
Utility Locate Contacts |
|
Utility Member Setup Table |
|
Utility Locate - Members Contacted |
|
Utility Locate - Damage done to Others |
|
Utility Locate Amount Owed To |
|
Utility Locate Violations |
|
Utility Locate Damage Witnesses |
|
Maintenance Zone Supervisors for Task |
|
Work Flow Setup Task Notifications |
|
Resources for Multiple Work Tasks |
|
Work Tasks Multiple Work Tasks |
|
Contractor Setup |
|
Violations Setup Table |
|
Work Order Associated PM Table |
|
System ID Table for all Assets |
|
Work Order Event Occurrences |
|
Work Order Flow Steps |
|
Work Linking Table (Work Orders, Requests, Routine) |
|
Work Order Resulting Tasks |
|
Work Order Tracking |
|
Work Order Tasks |
|
Work Water Loss |
|
Water Loss and WO Link table |
|
In This Section |