Skip to main content

Currently Skimming:


Pages 126-135

The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.


From page 126...
... 126 A p p e n d i x C introduction The logical data model consists of approximately 115 entities and numerous relationships. The data model includes six subject areas, one for each core data object in the conceptual model, as follows: • Utility conflict subject area; • Utility facility subject area; • Utility agreement subject area; • Project subject area; • Document subject area; and • User subject area.
From page 127...
... 127 Table C.1. Utility Conflict Subject Area Entity Definitions Name Definition COMMENT A COMMENT is miscellaneous information that provides extra detail or description for an event.
From page 128...
... 128 Table C.2. Utility Conflict Types ID Name 0 Conflict with roadway project features 1 Conflict with another utility feature 2 Conflict with utility regulations or standards 3 Conflict with safety regulations 4 Conflict with transportation construction or phasing Table C.3.
From page 129...
... 129 Utility Agreement Subject Area The utility agreement subject area includes entities that provide information about utility agreements, associated documentation, and the cost reimbursement process. Table C.6 lists the entities in this subject area.
From page 130...
... 130 Table C.6. Utility Agreement Subject Area Entity Definitions Name Definition ACCOUNTING METHOD An ACCOUNTING METHOD is a process that accounts for costs incurred during the adjustment of a utility facility, such as the category cost approach or the unit cost approach.
From page 131...
... 131 Name Definition UTILITY AGREEMENT DATE TYPE A UTILITY AGREEMENT DATE TYPE is the characterization of a date or milestone that is associated with the process of completing and approving a UTILITY AGREEMENT. Examples of a UTILITY AGREEMENT DATE TYPE are agreement submittal date, agreement returned to utility for corrections date, and agreement approval or execution date.
From page 132...
... 132 document Subject Area The document subject area includes entities that provide information about documents used in connection with other subject areas, including utility conflicts, projects, and utility agreements. Table C.8 lists the entities included in this subject area.
From page 133...
... 133 Table C.8. Document Subject Area Entity Definitions Name Definition AGREEMENT DOCUMENT An AGREEMENT DOCUMENT is a document that identifies the relationships, rights, and responsibilities between two or more parties.
From page 134...
... 134 the user who made a change to a utility conflict and thus created a new UTILITY CONFLICT EVENT. The data model manages DOT users and external users in separate entities to enable the assignment of different privileges for each user group.
From page 135...
... 135 DOT PROJECT SYSTEM USER enables a many-to-many relationship between SYSTEM USER and PROJECT so that a PROJECT can have multiple SYSTEM USERS and a SYSTEM USER can be assigned to multiple PROJECTS. ROLE describes the specific function(s)

Key Terms



This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More information on Chapter Skim is available.