Changes to Admin > Codes Tables

Version 8.2.2 Changes

• AMD/JMF ASPHALT TYPES: New for Version 8.2.2 Added a user controlled codes table for the Asphalt Types attribute added in Version 8.2.

• CONTRACT ADJ.OTHER LINE ITEMS: Increased the Quantity field so that numbers greater than 9.99 can be entered.

• CONT. DET. FILE TYPE: Corrected the Expiration Date format so that adding a new row no longer causes the window to crash.

• CONT. DET. M&T FILE LOCATION: Corrected the Expiration Date format so that adding a new row no longer causes the window to crash.

• CONT. DET. RECORD TYPE: Corrected the Expiration Date format so that adding a new row no longer causes the window to crash.

Version 8.1.1 Changes

• CONSTANTS: Added Final Certification - Full Oversight and Final Certification - Not Full Oversight fields. These fields contain the name and address for Project Certification letters.

Version 8.0

• AMD/JMF YEARS: New for Version 8.0 This code table supports the new functionality that allows authorized users to select the year designation on an Asphalt Mix Design.

Version 7.2.1 Changes

• CONSTANTS: Added Project Guarantee First Notify Days and Project Guarantee Second Notify Days. Authorized users may now control how many days prior to expiration the first and second Project Guarantee notifications are sent. Currently set to 60 and 30 days.

Version 7.1 Changes

• CONTRACT STATUS CODES: The following values were added to this codes table:
  • Accepted

• DIVISION: The codes table has been modified to split Section 7&9 into separate sections 7 and 9.

Version 5.8 Changes

• DENSITY STATUS: Authorized users only - A change has been made to protect the Category column. Changes to this column are no longer allowed, due to possible duplication in Code/Category combinations.

• DENSITY TYPE: Authorized users only - A change has been made to protect the Category column. Changes to this column are no longer allowed, due to possible duplication in Code/Category combinations.

• FUNCTION CODE: A correction was made to display a warning message when an expired function is selected. (Access restricted to those with proper security).

Version 5.6 Changes

• FUNCTION CODE: Increased the Description field size.

Version 5.5.1

• FUNCTION CODE: New for Version 5.5.1 This lists provides an additional attribute for Contract Line Items and was required for BSIP Implementation. Function Codes have been added to all existing Line Items. The following are the Active Function Codes that can be assigned to any newly created Line Items:
  • 2650 Contract CEI (Formerly 265)
  • 5086 Contract Resurfacing (Formerly 401)
  • 7610 Contractors - Land (Formerly 39G)
  • 7620 Design/Build Firms (Formerly 39H)
  • 7630 Public/Private Agrmt (Formerly 39P)
  • 7640 Contractors - Roads (Formerly 392)

Version 5.4 Changes

• STATE: An Out of Country column to is now available to indicate places which are not in the United States. This is used to enforce the ZIP code formatting requirements.

Version 4.4 Changes

• AUTHORIZING LAB TYPE: The value REs Sample Authorization Lab was added.

Version 4.1 Changes

• CONT. ADJ. AUTH. for CHG.: Altered Unit Price (Section 104-5) now reads Rev Unit Price, OR/UR

Version 4.0 Changes

• ACTION: The following actions were added to this codes table:
  • Accept
  • Approve
  • Generate
  • Reset Line Item Indicators
  • Modify Contract Adjustment
  • Merge Work Orders
  • Pay
  • Process Approval
  • Reject
  • Sample Authorized
  • Sample Unauthorized
  • Transfer

• AUTHORIZING LAB TYPE: Traffic Engineering and Roadside Environmental have been expired.

• CERTIFICATION PERCENT: New for Version 4.0 The following values used in entering Subcontracts were added to this codes table:
  • 60%
  • 100%

• CONCRETE CLASS: New for Version 4.0 These codes describe the class of concrete in a concrete mix.

• CONSTANTS: The following values required for Estimate Processing were added to this codes table:
  • Unit Price Threshold Percent (10)
  • Verbal Approval Threshold (15,000)
  • LOM Dollar Amount Threshold (5,000)
  • AC Price Threshold Percent (5)
  • Fuel Price Threshold Percent (10)
  • MPP Invoice Percent (90)
  • MPP Minimum (10,000)
  • Contract Time Consideration Comment
  • Liquidated Damages Threshold Percent (1)
  • New Mail Codes (SUB, SEC, WON, WOM, CON_90, CNS, MPI, MPN, ADJ, ATH, EST, and MTR)
  • Initial Retainage Percent (5)
  • Reduced Retainage Percent (2)
  • Line Item Number Upper Limit (1,000)
  • Line Item Number Excluded (600)

• CONSTRUCTION ENGINEER: New for Version 4.0 These codes identify Construction Engineers by job title and are used by the Contract Adjustments functions.

• CONT. ADJ. AUTH. for CHG.: New for Version 4.0 These codes describe the NCDOT Standard Specifications Authority for Change for Contract Adjustments.

• CONT. ADJ. STATUS: New for Version 4.0 These codes identify the various statuses of a Contract Adjustment.

• CONT. ADJ. TYPE: New for Version 4.0 These codes identify the various statuses of a Contract Adjustment.

• CONT. ADJ. TYPE OF WORK: New for Version 4.0 These codes describe the type of work (Bridge, Roadway or Both) for a Contract Adjustment.

• CONT. LINE ITEM STATUS: New for Version 4.0 These codes identify the various statuses of a contract line item. They are used by the Contract Maintenance, Contract Adjustments, Contract Tracking, and Contract Estimates modules.

• CONTRACT STATUS CODES: The following values were added to this codes table:
  • Pending Approval
  • Approved

• CONTRACT TIME EVENT TYPE: New for Version 4.0 These codes describe the different types of contract time events used to assess liquidated damages or pay incentives on Contract Times with Rate Unit of Measures not equal to Day.

• CONTRACT TRACKING STATUS: New for Version 4.0 These codes identify the various statuses of a Contract Tracking entry. They are used by the Contract Estimates module.

• CONTRACT TYPE: New for Version 4.0 These codes describe the different types of contracts and are used to determine Approval Authority in Contract Adjustments.

• DIVISION: New for Version 4.0 These codes list the 14 divisions across the state and their associated M&T Section.

• ESTIMATE DETAIL: New for Version 4.0 System generated Line Items such as AC and Fuel Adjustment are maintained in this table.

• ESTIMATE END DATE: Estimate Cycle Day now reads Estimate End Day.

• ESTIMATE STATUS: New for Version 4.0 This table lists the various statuses of an estimate.

• ESTIMATE TYPE: New for Version 4.0 This table lists the different types of an estimate.

• FACILITY TYPE: Removed in Version 4.0 This information will be maintained in the DOH Vendor System with the release of Version 4.

• HOW RECEIVED: New for Version 4.0 This listing contains the Contract Tracking functions which can be entered in the How Received field of the Minimum Sampling Guide.

• IA TEST FORMATS: New for Version 4.0 These codes identify the different types of independent assurance test formats that can be attributed to a specific test format.

• M&T ENGINEER: New for Version 4.0 This table lists the M&T Engineers by job title.

• MATL. PREPAYMENT STATUS: New for Version 4.0 This table lists the various statuses of a material prepayment.

• MSG RESPONSIBILITY: The following value was added to this codes table:
  • Design Services

• OWNING LAB: New for Version 4.0 These codes identify the different labs that own test formats.

• PAYMENT TYPE: Removed in Version 4.0 This codes table has been removed from HiCAMS.

• PRETEST MATCH: The following values have been removed from this codes table:
  • Match Alt ID’s/Match From Sample
  • Match From Sample

• RATE UNIT OF MEASURE: The Extension UOM column has been added.

• SAMPLE TEST STATUS: Penalty – Does Not Meet Specs now reads Pay Adjustment – Does Not Meet Specs.

• SAMPLING/TESTING RESP: New for Version 4.0 These codes identify the different groups of personnel who have responsibility for taking a sample. These groups are used on the Minimum Sampling Guide.

• TEST STANDARD ORG: Removed in Version 4.0 This information is now maintained on the Materials and Test Webpage.

• TEST STATUS: New for Version 4.0 These codes identify the different statuses of a test.

Prior Releases

• AIR-ENTRAIN. VIB. STATUS: These codes describe the Air Entrainment and Vibration states in a concrete mix.

• CARD COLOR: Lists the colors used to represent paper sample cards in the Enter Sample Details window.

• CONTRACT TIME STATUS: These codes identify the various statuses of a Contract Time.

• COUNTY: Lists the 100 counties in North Carolina and the division in which they are located. Also contains Statewide, N/A, and Out of State Categories. These relationships are used throughout HiCAMS and DOH Vendor.

• CRITICAL MATERIAL: Lists the Criticality Code used for Material Types in the Minimum Sampling Guide. The code describes each material's importance to Project Certification.

• MATERIAL CERTIFICATION: Lists the Certification Types defined in Section 106-3 of the Standard Specifications. Can be updated by Authorized Users.

• METRIC/ENGLISH: This table lists the Unit of Measure categories for Pay Items and Materials.

• OFFFICE LOC TYPE: This table lists the office Location Types and Categories that are used in the Security Tables.

• PARTICIPATING CODE: This table lists the contract funding participation codes.

• PAY ITEM CODE: This table lists the categories Pay Items can belong to, such as Guardrail, Lighting, Signing, etc.

• POZZOLAN TYPE: These codes identify the type of pozzolan for a concrete mix.

• ROUTE TYPE: Lists the Route Types available for addition to the contract during Activation.

• SAMPLE ALT STATUS: Lists the statuses of Alternate IDs assigned to Samples.

• SAMPLE ALT TYPE: Lists the Types of Alternate IDs assigned to Samples.

• SAMPLE FROM: Lists the places from which Samples may be taken. These are available for selection during the entry of a Sample. Can be updated by Authorized Users.

• SAMPLE FROM: Lists the owners of Samples, such as Project, M&T, Prod/Supp. The Sample Owner is selected during the entry of Samples. Can be updated by Authorized Users.

• SAMPLE PART STATUS: Identifies the statuses Sample Parts can have.

• SPEC YEAR: Contains a listing of the years that NCDOT Specifications have been released. Used by Contract Details and Master Pay Items.

• STAFF JOB TITLE: List the Job Titles available for selection when entering new staff or updating existing staff.

• TEST CATEGORY: Lists the Testing Categories used when entering Samples.

• UNIT OF MEASURE: Lists the Units of Measure used for Pay Items and Materials.

• UOM CONVERSION: These codes provide the conversion factors for translation from English to Metric and Metric to English.

• WATER SOURCE: These codes describe the water sources in a concrete mix.

Page last updated 23 January 2012