TableName |
Description |
PDAWarehouse Sync Setup module |
|
Statistics for PDA Sync Module |
|
Import Data Mapping |
|
Import Saved Settings |
|
Part Location Quantities |
|
Parts Location Logs |
|
Locations |
|
Part Cost |
|
Part Hazard Codes |
|
Parts |
|
Purchase Order |
|
Purchase Order Details |
|
Purchase Order Receipt |
|
Purchase Order Receipt Details |
|
Requisitions |
|
Requisition Details |
|
Parts Imported Review |
|
Transactions |
|
Vendors |
|
Link table for Vendors and Parts |
|
Vendor Rankings for Parts |
|
Warehouses |
|
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 |
|
Work Permit Check List |
|
Permit Enforcement |
|
Permit Enforcement Type |
|
Permit Type Fees |
|
Work Permit Type Setup Fees |
|
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 |
|
Work Project and Contract Linking Table |
|
Project Change Orders |
|
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 |
|
Project Contractor Payments |
|
Project PO and Work Order Linking Table |
|
Project Grant Funding |
|
Project Invoice Payments |
|
Master Project |
|
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 |
|
Planning by Tasks for Category |
|
Planning Task Resources |
|
Requests |
|
Table used to store the unique email/request pairing |
|
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 |
|
Architect/Engineer Setup |
|
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 Employee Availability |
|
Work Flow Setup Employee Issued Parts |
|
Work Flow Setup Employee Payroll Administration |
|
Time Codes |
|
Work Flow Setup Associating Employees to Parts Warehousing |
|
Work Flow Setup Equipment |
|
Work Flow Setup Equipment Availability |
|
Task Work Flow Steps Sub-Tasks |
|
Fluid Setup |
|
Work Flow Setup Materials |
|
Maintenance Zones |
|
Work Flow Setup Problem Notifications |
|
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 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 |