SNBI Data Validation Cross-Checks
Validation Cross-checks confirm that required data has been submitted and that the data meets criteria based on the values reported for other SNBI items.
Example: The value for one of the Features datasets for a bridge indicates there is a railroad below the bridge. Data validation cross-checks to confirm that a railroad dataset (SNBI Items B.RR.01, B.RR.02, and B.RR.03) have also been reported for the bridge.
There are three types of errors identified with validation cross-checks:
- Critical - data must be corrected and resubmitted within 15 business days
- Error - data should be confirmed and corrected prior to the next year’s data submittal
- Flag - verify flags are not actual errors or correct prior to the next year’s data submittal, if needed
Item ID | Item Name | X-Check Error Type | Message | Conditions for FLAG/ERROR | FLAG/ERROR Message |
---|---|---|---|---|---|
B.L.07 | Border Bridge Number | Processing instructions | Processing for non-Border Bridges | (BL07 = "N") process all data items | |
B.L.07 | Border Bridge Number | Processing instructions | Processing for Border Bridges with a foreign country | (BL07 = 0) Border Bridge with a foreign country - process all data items | |
B.L.07 | Border Bridge Number | Processing instructions | Processing for Border Bridges where submitting State is the Designated Lead State | (BL07 <> "N") AND (BL10 = BL01) - process all data items | |
B.L.07 | Border Bridge Number | Processing instructions and Flags | First data validation is B.L.07 Border Bridge Number - checking for Border Bridges with submitting State as the Neighboring State | (BL07 <> "N") AND (BL10 <> BL01) - process only the following data items: BID01; BID03; BL01; BL02; BL03; BL04; BL07; BL08; BL09; BL10; BL12; BF01; BF02; BF03; BRT01; BRT02; BRT03; BRT04; BRT05;BH03; BH06; BH07; BH18 NOTE: If data items not in this list are submitted - FLAG | BL07/BL10 combination indicates bridge is submitted by the Neighboring State and should only include abbreviated record items |
SNBI Items with Temporary Codes | Flag | Monitoring progress towards eliminating SNBI items with temporary codes by the 2028 deadline - this flag counts the number of bridge records - it does not count the number of SNBI items | Flag bridge record if any SNBI items within the record contain temporary codes | Your agency's submitted inventory has XX,XXX bridge records with SNBI items that contain temporary codes | |
B.ID.01 | Bridge Number | Critical | Combination of State Code and Bridge Number should be unique within the inventory for that State | (BL01, BID01, BCL 01 combination IS NOT UNIQUE in BL01 inventory) | Combination of BL01 State Code, BID01 Bridge Number, and BCL01 Owner is not unique within the inventory |
B.ID.02 | Bridge Name | Flag | Bridge Name should be reported for all bridges - the SNBI recommends providing a general description for the bridge if a commonly known name does not exist | (BL07 = "N") AND (BID02 =null) | Missing BID02 Bridge Name |
B.ID.02 | Bridge Name | Flag | Bridge Name should be reported for all bridges - the SNBI recommends providing a general description for the bridge if a commonly known name does not exist | (BL07 <> "N") AND (BL10 = BL01) AND (BID02 = null) | Bridge is a Border Bridge and State is Designated Lead State - missing BID02 Bridge Name |
B.ID.03 | Previous Bridge Number | Flag | Previous Bridge Number should not be the same as the Bridge Number | (BID03 = BID01) | BID01 Bridge Number is the same as BID03 Previous Bridge Number |
B.L.05 | Latitude | Critical | Latitude must be reported for all highway bridges | (BL07 = "N") AND (BL05 =null) | BL05 Latitude must be reported for all bridges |
B.L.05 | Latitude | Critical | Latitude must be reported for all highway bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BL05 =null) | Bridge is a Border Bridge and State is Designated Lead State - BL05 Latitude must be reported for all bridges |
B.L.06 | Longitude | Critical | Longitude must be reported for all highway bridges | (BL07 = "N") AND (BL06 =null) | BL06 Longitude must be report |
B.L.06 | Longitude | Critical | Longitude must be reported for all highway bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BL06 =null) | Bridge is a Border Bridge and State is Designated Lead State - BL06 Longitude must be reported |
B.L.07 | Border Bridge Number | Flag | When Border Bridge Number is not equal to zero or "N" then Border Bridge Number and Border Bridge State combination should be unique within the "other state's" inventory. | (BL07 <> "N"); (BL08, BL07 combination IS NOT UNIQUE in inventory of BL08) | Border Bridge BL08 Border Bridge State or Country Code and BL07 Border Bridge Number combination cannot be found in the bordering state's inventory |
B.L.08 | Border Bridge State or Country Code | Critical | When Border Bridge Number is not equal to "N" then Border Bridge State or Country Code must be reported | (BL07 <> "N") AND (BL08 = null) | Bridge is a Border Bridge - BL08 Border Bridge State or Country Code must be reported by both States |
B.L.08 | Border Bridge State or Country Code | Critical | When reported Border Bridge State or Country Code should not be the same as the State Code | (BL07 <> "N") AND (BL08 = BL01) | Bridge is a Border Bridge - BL08 border State or Country Code must not be equal to BL01 State Code |
B.L.09 | Border Bridge Inspection Responsibility | Critical | When Border Bridge Number is not equal to "N" Border Bridge Inspection Responsibity must be reported | (BL07 <> "N") AND (BL09 = null) | Bridge is a Border Bridge - BL09 Border Bridge Inspection Responsibility must be reported by both States |
B.L.09 | Border Bridge Inspection Responsibility | Critical | When reported the sum of the values for Border Bridge Inspection Responsibity for the Designated Lead State and the Neighboring State should equal 2 - this check is not done for Border Bridges that cross an international border | FLAG if any of the following conditions are met: When (BL07 <> "N") AND (BL10 = BL01) AND (BL09 = 0); then for (BL07,BL08 combination in BL08 inventory); (BL09 <> 2) When (BL07 <> "N") AND (BL10 = BL01) AND (BL09 = 1); then for (BL07,BL08 combination in BL08 inventory); (BL09 <> 1) When (BL07 <> "N") AND (BL10 = BL01) AND (BL09 = 2); then for (BL07,BL08 combination in BL08 inventory); (BL09 <> 0) |
Bridge is a Border Bridge - BL09 Border Bridge Inspection Responsibility is not consistent with the value reported by the Neighboring State |
B.L.10 | Border Bridge Designated Lead State | Critical | When Border Bridge Number is not equal to "N" Border Bridge Designated Lead State must be reported | (BL07 <> "N") AND (BL10 = null) | Bridge is a Border Bridge - BL10 Designated Lead State must be reported by both States - for Border Bridges that cross international borders BL10 should be equal to BL01 State Code |
B.L.10 | Border Bridge Designated Lead State | Critical | When reported Border Bridge Designated Lead State should be equal to either BL01 or BL08 and it should be the same value for both States | (BL07 <> "N") AND (BL10 <> BL01 or BL08) | Bridge is a Border Bridge - BL10 Designated Lead State must be equal to either BL01 State Code or BL08 Border Bridge State or Country Code |
B.L.10 | Border Bridge Designated Lead State | Critical | When reported Border Bridge Designated Lead State should be equal to either BL01 or BL08 and it should be the same value for both States - this check is not done for Border Bridges that cross an international border | (BL07 <> "N") AND (BL10 <> BL10 for BL07, BL08 combination in BL08 inventory) | Bridge is a Border Bridge - BL10 Border Bridge Designated Lead State is not consistent with the value reported by the other State |
B.L.11 | Bridge Location | Error | Bridge Location must be reported for all bridges | (BL07 = "N") AND (BL11 = null) | BL11 Bridge Location must be reported |
B.L.11 | Bridge Location | Error | Bridge Location must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BL11 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BL11 Bridge Location must be reported |
B.L.12 | Metropolitan Planning Organization | Critical | Metropolitan Planning Organization must be reported for all highway features carried on the bridge when the highway is on the NHS | (BF01 = H01) AND (BH03 = "Y") AND (BL12 = null) | Highway feature carried on the bridge is designated "on" the NHS - BL12 Metropolitan Planning Organization must be reported - by both States for Border Bridges |
B.CL.01 | Owner | Critical | Owner must be reported for all bridges | (BL07 = "N") AND (BCL01 = null) | BCL01 Owner must be reported |
B.CL.01 | Owner | Critical | Owner must be reported for all bridges | When (BL07 <> "N") AND (BL10 = BL01) AND (BCL01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BCL01 Owner must be reported |
B.CL.02 | Maintenance Responsibility | Critical | Maintenance Responsibility must be reported for all bridges | (BL07 = "N") AND (BCL02 = null) | BCL02 Maintenance Responsibility must be reported |
B.CL.02 | Maintenance Responsibility | Critical | Maintenance Responsibility must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BCL02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BCL02 Maintenance Responsibility must be reported |
B.CL.03 | Federal or Tribal Land Access | Error | Federal or Tribal Land Access must be reported for all bridges | (BL07 = "N") AND (BCL03 = null) | BCL03 Federal or Tribal Land Access must be reported |
B.CL.03 | Federal or Tribal Land Access | Error | Federal or Tribal Land Access must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BCL03 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BCL03 Federal or Tribal Land Access must be reported |
B.CL.04 | Historic Significance | Error | Historic Significance must be reported for all bridges | (BL07 = "N") AND (BCL04 = null) |
BCL04 Historic Significance must be reported |
B.CL.04 | Historic Significance | Error | Historic Significance must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BCL04 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BCL04 Historic Significance must be reported |
B.CL.05 | Toll | Error | Toll must be reported for all bridges | (BL07 = "N") AND (BCL05 = null) | BCL05 Toll must be reported |
B.CL.05 | Toll | Error | Toll must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BCL05 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BCL05 Toll must be reported |
B.CL.06 | Emergency Evacuation Designation | Error | Emergency Evacuation Designation must be reported for all bridges | (BL07 = "N") AND (BCL06 = null) | BCL06 Emergency Evacuation Designation must be reported |
B.CL.06 | Emergency Evacuation Designation | Error | Emergency Evacuation Designation must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BCL06 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BCL06 Emergency Evacuation Designation must be reported |
"Spans" | Span Data Set | Critical | At least one Span Dataset must be reported for all bridges | (BL07 = "N") AND (BSP01 = null) | At least one Span dataset must be reported for all bridges |
"Spans" | Span Data Set | Critical | At least one Span Dataset must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BSP01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - at least one Span dataset must be reported for all bridges |
B.SP.01 | Span Configuration Designation | Critical | All "Span" datasets must have a unique State Code, Bridge Number, Span Configuration combination (BL01, BID01, BSP01) among all "Spans" datasets for a Bridge | (BL01, BID01, BSP01 Spans Dataset combination) is NOT UNIQUE among the Spans Datasets | Duplicate Span datasets have been submitted for this bridge |
B.SP.01 | Span Configuration Designation | Critical | State Code, Bridge Number combination (BL01, BID01) from Span datasets should match State Code, Bridge Number (BL01, BID01) from the Primary Dataset | (BL01, BID01 from Spans Dataset <> BL01, BID01 combination from Primary dataset) | BL01 State Code/BID01 Bridge Number combination from the Span dataset does not match the BL01 State Code/BID01 Bridge Number combination from the Primary dataset for this bridge |
B.SP.01 | Span Configuration Designation | Error | If any part of a Bridge is not a Culvert then at least one Span Configuration Designation (BSP01) must be designated as Main Span (BSP01 = M01) in the "Spans" Data Sets | IF among all datasets exists (BSP01 = A## OR W##) AND (BSP01 <> M##) | Main Span dataset missing - all bridges that are not designated as culverts must have at least one main Span dataset |
B.SP.02 | Number of Spans | Error | Number of Spans must be reported for each "Span" Data Set | (BSP02 = null) | Missing BSP02 Number of Spans |
B.SP.02 | Number of Spans | Error | Sum of Number of Spans in all "Spans" Data Sets for a bridge should be greater than zero | SUM([BSP02 FROM ALL SPAN DATASETS]) = 0 | BSP02 Number of Spans was reported as "zero" for this bridge |
B.SP.03 | Number of Beam Lines | Error | Number of Beam Lines must be reported for each "Span" Data Set | (BSP03 = null) | Missing BSP03 Number of Beam Lines |
B.SP.03 | Number of Beam Lines | Error | Sum of all Number of Beam Lines in "Spans" Data Sets should be greater than zero for all Span Types except rigid and flexible pipe Bridges | (BSP06 <> P01 or P02) AND (SUM([BSP03 FROM ALL SPAN DATASETS]) = 0) | BSP03 Number of Beam Lines was reported as "zero" for this bridge |
B.SP.03 | Number of Beam Lines | Error | Sum of all Number of Beam Lines in "Spans" Data Sets for rigid and flexible pipe Bridges should be "zero". | (BSP06 = P01 or P02) AND (SUM(ALL[BSP03]) <> 0) | BSP03 Number of Beam Lines for this flexible pipe bridge should be "zero" |
B.SP.03 | Number of Beam Lines | Flag | Sum of all Number of Beam Lines in "Spans" Data Sets for most frame and slab Span Types should not be greater than one (1) | (BSP06 = F01, F02, S01, or S02) AND (SUM(ALL[BSP03]) > 1) | BSP03 Number of Beam Lines for most frame and slab bridges should be "one" |
B.SP.04 | Span Material | Error | Span Material must be reported for each "Span" Data Set | (BSP04 = null) | Missing BSP04 Span Material |
B.SP.05 | Span Continuity | Error | Span Continuity must be reported for each "Span" Data Set | (BSP05 = null) | Missing BSP05 Span Continuity |
B.SP.05 | Span Continuity | Error | Span Continuity must be reported for each "Span" Data Set | (BSP01 = C## or V##) AND (BSP06 = P01 or P02) AND (BSP05 <> 7) | BSP05 Span Continuity for rigid or flexible pipe spans that rely on soil interaction to support vertical loads should be reported as "7 - buried" |
B.SP.06 | Span Type | Error | Span Type must be reported for each "Span" Data Set | (BSP06 = null) | Missing BSP06 Span Type |
B.SP.07 | Span Protective System | Error | Span Protective System must be reported for each "Span" Data Set | (BSP07 = null) | Missing BSP07 Span Protective System |
B.SP.08 | Deck Interaction | Error | Deck Interaction must be reported for each "Span" Data Set Deck Material and Type (BSP09) indicates there is no deck | (BSP09 <> 0) AND (BSP08 = null) | Missing BSP08 Deck Interaction |
B.SP.08 | Deck Interaction | Error | Deck Interaction must be reported for each "Span" Data Set Deck Material and Type (BSP09) indicates there is no deck | (BSP09 = 0) AND (BSP08 <> null) | Do not report BSP08 Deck Interaction when BSP09 = 0 |
B.SP.09 | Deck Material and Type | Error | Deck Material and Type must be reported for each "Span" Data Set | (BSP09 = null) | Missing BSP09 Deck Material and Type |
B.SP.09 | Deck Material and Type | Flag | Deck Material and Type should be equal to zero for spans under fill | (BSP09 = 0) AND (BSP05 <> 7) | BSP09 Deck Material and Type should not be equal to "zero" for bridges and culverts that are not under fill |
B.SP.09 | Deck Material and Type | Error | Deck Material and Type should be equal to zero for spans under fill | (BSP05 = 7) AND (BSP09 <> 0) | BSP09 Deck Material and Type should equal "zero" for bridges and culverts under fill |
B.SP.09 | Deck Material and Type | Error | Deck Material and Type should be equal to the value for Span Material for slabs, and the slab portion of 3-sided and 4-side concrete rigid frame bridges and culverts not under fill | (BSP04 = C01, C02, C03, C04, C05, CX, CR-T, or CP-T) AND (BSP06 = F01, F02, or F-T) AND (BSP05 <> 7) AND (BSP09 <> BSP04) | BSP09 Deck Material and Type should be equal to BSP04 Span Material for concrete slabs, and the slab portion of 3-sided and 4-sided rigid frame bridges and culverts not under fill |
B.SP.10 | Wearing Surface | Error | Wearing Surface must be reported for a "Span" Data Set except when the Deck Material and Type indicate there is no deck | (BSP09 <> 0) AND (BSP10 = null) | BSP10 Wearing Surface must be reported except when BSP09 is equal to "zero" |
B.SP.10 | Wearing Surface | Error | Wearing Surface must be reported for a "Span" Data Set except when the Deck Material and Type indicate there is no deck | (BSP09 = 0) AND (BSP10 <> null) | Do not report BSP10 Wearing Surface when BSP09 is equal to "zero" |
B.SP.11 | Deck Protective System | Error | Deck Protective System must be reported for a "Span" Data Set except when the Deck Material and Type indicate there is no deck | (BSP09 <> 0) AND (BSP11 = null) | BSP11 Deck Protective System must be reported except when BSP09 is equal to "zero" |
B.SP.11 | Deck Protective System | Error | Deck Protective System must be reported for a "Span" Data Set except when the Deck Material and Type indicate there is no deck | (BSP09 = 0) AND (BSP11 <> null) | Do not report BSP11 Deck Protective System when BSP09 is equal to "zero" |
B.SP.12 | Deck Reinforcing Protective System | Error | Deck Reinforcing Protective System must be reported for a "Span" Data Set when Deck Material and Type indicates there is reinforced concrete deck | (BSP09 = C01, C02, C03, C04, C05, CX, CR-T, or CP-T) AND (BSP12 = null) | BSP12 Deck Reinforcing Protective System must be reported when BSP09 Deck Material and Type is concrete (codes c01, c02, c03, c04, c05, cx) |
B.SP.12 | Deck Reinforcing Protective System | Error | Deck Reinforcing Protective System must be reported for a "Span" Data Set when Deck Material and Type indicates there is reinforced concrete deck | (BSP09 <> C01, C02, C03, C04, C05, CX, CR-T, or CP-T) AND (BSP12 <> null) | Do not report BSP12 Deck Reinforcing Protective System if BSP09 Deck Material and Type is not concrete (all codes other than c01 thru cx) |
B.SP.13 | Deck Stay-in-Place Forms | Error | Deck Stay-In-Place Forms must be reported for a "Span" Data Set except when the Deck Material and Type indicate there is no deck | (BSP09 <> 0) AND (BSP13 = null) | BSP13 Deck Stay-in-Place Forms must be reported except when BSP09 is equal to "zero" |
B.SP.13 | Deck Stay-in-Place Forms | Error | Deck Stay-In-Place Forms must be reported for a "Span" Data Set except when the Deck Material and Type indicate there is no deck | (BSP09 = 0) AND (BSP13 <> null) | Do not report BSP13 Deck Stay-in-Place Forms when BSP09 is equal to "zero" |
"Substructure" | Substructure Data Set | Critical | One Substructure Dataset must be reported for all bridges | (BL07 = "N") AND (BSB01 = null) | This at least one Substructure dataset must be reported |
"Substructure" | Substructure Data Set | Critical | One Substructure Dataset must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BSB01 = null) | This bridge is a Border Bridge and State is the Designated Lead State - at lease one Substructure dataset must be reported |
B.SB.01 | Substructure Configuration Designation | Critical | All "Substructure" datasets must have a unique State Code, Bridge Number, Substructure Configuration combination (BL01, BID01, BSB01) among all "Spans" datasets for a Bridge | (BL01, BID01, BSB01 Substructure dataset combination) is NOT UNIQUE among the Substructure datasets | Duplicate Substructure datasets have been submitted for this bridge |
B.SB.01 | Substructure Configuration Designation | Critical | State Code, Bridge Number combination (BL01, BID01) from Substructure Datasets should match State Code, Bridge Number (BL01, BID01)from the Primary Dataset; | (BL01, BID01 from Substructure dataset <> BL01, BID01 combination from Primary dataset) | BL01 State Code/BID01 Bridge Number combination from the Substructure dataset does not match the BL01 State Code/BID01 Bridge Number combination from the Primary dataset for this bridge |
B.SB.02 | Number of Substructure Units | Error | Number of Substructure Units must be reported for each "Substructure" Data Set | (BSB02 = null) | Missing BSB02 Number of Substructure Units |
B.SB.03 | Substructure Material | Error | Substructure Material must be reported for each "Substructure" Data Set | (BSB03 = null) | Missing BSB03 Substructure Material |
B.SB.04 | Substructure Type | Error | Substructure Type must be reported for each "Substructure" Data Set | (BSB04 = null) | Missing BSB04 Substructure Type |
B.SB.05 | Substructure Protective System | Error | Substructure Protective System must be reported for a "Span" Data Set except when Substructure Type indicates that there are no Substructures or that Bridge rests directly on the foundation | (BSB04 <> 0) AND (BSB05 = null) | BSB05 Substructure Protective System must be reported except when BSB04 Substructure Type is equal to "zero" |
B.SB.05 | Substructure Protective System | Error | Substructure Protective System must be reported for a "Span" Data Set except when Substructure Type indicates that there are no Substructures or that Bridge rests directly on the foundation | (BSB04 = 0) AND (BSB05 <> null) | Do not report BSB05 Substructure Protective System when BSB04 Subtructure Type is equal to "zero" |
B.SB.06 | Foundation Type | Error | Foundation Type must be reported for each "Substructure" Data Set | (BSB06 = null) | Missing BSB06 Foundation Type |
B.SB.07 | Foundation Protective System | Error | Foundation Protective System must be reported for each "Substructure" Data Set | (BSB07 = null) | Missing BSB07 Foundation Protective System |
B.RH.01 | Bridge Railings | Error | Bridge Railings must be reported for all bridges | (BL07 = "N") AND (BRH01 = null) | BRH01 Bridge Railings must be reported |
B.RH.01 | Bridge Railings | Error | Bridge Railings must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BRH01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BRH01 Bridge Railings must be reported |
B.RH.02 | Transitions | Error | Transitions must be reported for all bridges | (BL07 = "N"); (BRH02 = null) | BRH02 Transitions must be reported |
B.RH.02 | Transitions | Error | Transitions must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BRH02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BRH02 Transitions must be reported |
B.G.01 | NBIS Bridge Length | Critical | NBIS Bridge Length must be reported for all bridges | (BL07 = "N") AND (BG01 = null) | BG01 NBIS Bridge Length must be reported |
B.G.01 | NBIS Bridge Length | Critical | NBIS Bridge Length must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG01 NBIS Bridge Length must be reported |
B.G.01 | NBIS Bridge Length | Error | NBIS Bridge Length should not be greater than Total Bridge Length for a Bridge | (BG01) > (BG02) | BG01 NBIS Bridge Length should not be greater than BG02 Total Bridge Length |
B.G.02 | Total Bridge Length | Critical | Total Bridge Length must be reported for all bridges | (BL07 = "N") AND (BG02 = null) | BG02 Total Bridge Length must be reported |
B.G.02 | Total Bridge Length | Critical | Total Bridge Length must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG02 Total Bridge Length must be reported |
B.G.03 | Maximum Span Length | Critical | Maximum Span Length must be reported for all bridges | (BL07 = "N") AND (BG03 = null) | BG03 Maximum Span Length must be reported |
B.G.03 | Maximum Span Length | Critical | Maximum Span Length must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG03 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG03 Maximum Span Length must be reported |
B.G.03 | Maximum Span Length | Error | For a single span bridge the Maximum Span Length should be equal to Minimum Span Length | (SUM([BSP02 IN ALL SPAN DATASETS ]) = 1) AND (BG03 <> BG04) | For single span bridges - BG03 Maximum Span Length should equal BG04 Minimum Span Length |
B.G.04 | Minimum Span Length | Critical | Minimum Span Length must be reported for all bridges | (BL07 = "N") AND (BG04 = null) | BG04 Minimum Span Length must be reported |
B.G.04 | Minimum Span Length | Critical | Minimum Span Length must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG04 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG04 Minimum Span Length |
B.G.05 | Bridge Width Out-to-Out | Critical | Bridge Width Out-to-Out must be reported for all bridges | (BL07 = "N") AND (BG05 = null) | BG05 Bridge Width Out-to-Out must be reported |
B.G.05 | Bridge Width Out-to-Out | Critical | Bridge Width Out-to-Out must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG05 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG05 Bridge Width Out-to-Out must be reported |
B.G.06 | Bridge Width Curb-to-Curb | Critical | Bridge Width Curb-to-Curb must be reported for all bridges | (BL07 = "N") AND (BG06 = null) | BG06 Bridge Width Curb-to-Curb must be reported |
B.G.06 | Bridge Width Curb-to-Curb | Critical | Bridge Width Curb-to-Curb must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG06 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG06 Bridge Width Curb-to-Curb must be reported |
B.G.06 | Bridge Width Curb-to-Curb | Flag | Bridge Width Curb-to-Curb should not be greater than Bridge Width Out-to-Out when bridge is not a Sidehill Bridge | (BG14 <> N) AND (BG06 > BG05) | BG06 Bridge Width Curb-to-Curb should not be greater than BG05 Bridge Width Out-to-Out when BG14 Sidehill Bridge is equal to "N" |
B.G.07 | Left Curb or Sidewalk Width | Critical | Left Curb or Sidewalk Width must be reported for all bridges | (BL07 = "N") AND (BG07 = null) | BG07 Left Curb or Sidewalk Width must be reported |
B.G.07 | Left Curb or Sidewalk Width | Critical | Left Curb or Sidewalk Width must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG07 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG07 Left Curb or Sidewalk Width must be reported |
B.G.08 | Right Curb or Sidewalk Width | Critical | Right Curb or Sidewalk Width must be reported for all bridges | (BL07 = "N") AND (BG08 = null) | BG08 Right Curb or Sidewalk Width must be reported |
B.G.08 | Right Curb or Sidewalk Width | Critical | Right Curb or Sidewalk Width must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG08 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG08 Right Curb or Sidewalk Width must be reported |
B.G.09 | Approach Roadway Width | Critical | Approach Roadway Width must be reported for all bridges | (BL07 = "N") AND (BG09 = null) | BG09 Approach Roadway Width must be reported |
B.G.09 | Approach Roadway Width | Critical | Approach Roadway Width must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG09 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG09 Approach Roadway Width must be reported |
B.G.10 | Bridge Median | Critical | Bridge Median must be reported for all bridges | (BL07 = "N") AND (BG10 = null) | BG10 Bridge Median must be reported |
B.G.10 | Bridge Median | Critical | Bridge Median must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG10 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG10 Bridge Median must be reported |
B.G.11 | Skew | Critical | Skew must be reported for all bridges | (BL07 = "N") AND (BG11 = null) | BG11 Skew must be reported |
B.G.11 | Skew | Critical | Skew must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG11 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG11 Skew must be reported |
B.G.12 | Curved Bridge | Error | Curved Bridge must be reported for all bridges | (BL07 = "N") AND (BG12 = null) | BG12 Curved Bridge must be reported |
B.G.12 | Curved Bridge | Error | Curved Bridge must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG12 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG12 Curved Bridge must be reported |
B.G.13 | Maximum Bridge Height | Error | Maximum Bridge Height must be reported for all bridges | (BL07 = "N") AND (BG13 = null) | BG13 Maximum Bridge Height must be reported |
B.G.13 | Maximum Bridge Height | Error | Maximum Bridge Height must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG13 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG13 Maximum Bridge Height must be reported |
B.G.14 | Sidehill Bridge | Error | Sidehill Bridge must be reported for all bridges | (BL07 = "N") AND (BG14 = null) | BG14 Sidehill Bridge must be reported |
B.G.14 | Sidehill Bridge | Error | Sidehill Bridge must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BG14 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BG14 Sidehill Bridge must be reported |
B.G.15 | Irregular Deck Area | Flag | Report Irregular Deck Area when the value is significantly different from the Calculated Deck Area (BG16) | (BG15 < 0.5 x BG16) OR (BG15 > 1.5 x BG16) | Reasonableness Check: Value reported for BG17 Irregular Deck Area is less than half the calculated value for BG16 Deck Area; or Reasonableness Check: Value reported for BG17 Irregular Deck Area is greather than 1.5 times the calculated value for BG16 Calculated Deck Area |
"Features" | Feature Data Set | Critical | One Features Dataset carried on the bridge must be reported for all bridges | (BF01 = null) | At least one Features dataset must be reported for all bridges |
"Features" | Feature Data Set | Critical | One Features Dataset carried on the bridge must be reported for all bridges | (BF01 = H01) AND (BF02 <> "C") | BF01 Feature Type = "H01" (highway) must be carried on the bridge (BF02 = "C") |
"Features" | Feature Data Set | Critical | One Features Dataset carried on the bridge must be reported for all bridges | (BF01 <> H01) AND (BF02 = "C") | BF01 Feature Type = "H01" (highway) must be carried on the bridge (BF02 = "C") |
B.F.01 | Feature Type | Critical | All "Features" datasets must have a unique State Code, Bridge Number, Feature Type combination (BL01, BID01, BF01) among all "Features" datasets for a Bridge | (BL01, BID01, BF01 Features dataset combination) is NOT UNIQUE among the Features datasets | Duplicate Features datasets have been reported for this bridge |
B.F.01 | Feature Type | Critical | State Code, Bridge Number combination (BL01, BID01) from Features Datasets should match State Code, Bridge Number (BL01, BID01)from the Primary Dataset | (BL01, BID01 from Features dataset <> BL01, BID01 combination from Primary dataset) | BL01 State Code/BID01 Bridge Number combination from the Features dataset does not match the BL01 State Code/BID01 Bridge Number combination from the Primary dataset for this bridge |
B.F.02 | Feature Location | Error | Feature Location must be reported for all bridges | (BF02 = null) | BF02 feature location must be reported for all bridges - by both States for Border Bridges |
B.F.03 | Feature Name | Error | Feature Name must be reported for all bridges | (BF03 = null) | BF03 feature name must be reported for all bridges - by both States for Border Bridges |
B.H.01 | Functional Classification | Critical | Functional Classification must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH01 = null) | BH01 Functional Classification must be reported |
B.H.01 | Functional Classification | Critical | Functional Classification must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH01 Functional Classification must be reported |
B.H.01 | Functional Classification | Flag | Functional Classification must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH01 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH01 Functional Classification for this Features dataset |
B.H.02 | Urban Code | Error | Urban Code must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH02 = null) | BH02 Urban Code must be reported |
B.H.02 | Urban Code | Error | Urban Code must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH02 Urban Code must be reported |
B.H.02 | Urban Code | Flag | Urban Code must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH02 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH02 Urban Code for this Features dataset |
B.H.03 | NHS Designation | Critical | NHS Designation must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 = null) AND (BH03 = null) | BH13 NHS Designation must be reported - by both States for Border Bridges |
B.H.03 | NHS Designation | Flag | NHS Designation must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH03 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH03 NHS Designation for this Features dataset |
B.H.04 | National Highway Freight Network | Critical | National Highway Freight Network must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH04 = null) | BH04 National Highway Freight Network must be reported |
B.H.04 | National Highway Freight Network | Critical | National Highway Freight Network must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH04 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH04 National Highway Freight Network must be reported |
B.H.04 | National Highway Freight Network | Flag | National Highway Freight Network must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH04 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH04 National Highway Freight Network for this Features dataset |
B.H.05 | STRAHNET Designation | Critical | STRAHNET Designation must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH05 = null) | BH05 STRAHNET designation must be reported |
B.H.05 | STRAHNET Designation | Critical | STRAHNET Designation must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH05 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH05 STRAHNET designation must be reported |
B.H.05 | STRAHNET Designation | Flag | STRAHNET Designation must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH05 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH05 STRAHNET designation |
B.H.06 | LRS Route ID | Error | LRS Route ID is reported for all highway Features datasets associated with a bridge | (BF01 = H##) AND (BH06 = null) | BH06 LRS Route ID must be reported - by both States for Border Bridges |
B.H.07 | LRS Mile Point | Error | LRS Mile Point is reported for all highway Features datasets associated with a bridge | (BF01 = H##) AND (BH07 = null) | BH07 LRS Mile Point must be reported - by both States for Border Bridges |
B.H.08 | Lanes on Highway | Critical | Lanes on Highway must be reported for all highway Features datasets associated with a bridge except when that Features is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH08 = null) | BH08 Lanes on Highway must be reported |
B.H.08 | Lanes on Highway | Critical | Lanes on Highway must be reported for all highway Features datasets associated with a bridge except when that Features is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH08 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH08 Lanes on Highway must be reported |
B.H.08 | Lanes on Highway | Flag | Lanes on Highway must be reported for all highway Features datasets associated with a bridge except when that Features is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 <> null) AND (BH08 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH08 Lanes on Highway |
B.H.08 | Lanes on Highway | Error | When the highway Feature is carried on the bridge and the Bridge Width Curb-to-Curb is less than sixteen feet then Lanes on Highway should be coded as one | (BF01 = H01) AND (BG06 < 16.0) AND (BH08 <> 1) | BG06 Bridge Width Curb-to-Curb is less than 16.0 feet - BH08 Lanes on Highway should be equal to "one" |
B.H.09 | Annual Average Daily Traffic | Error | Annual Average Daily Traffic must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH09 = null) | BH09 Annual Average Daily Traffic must be reported |
B.H.09 | Annual Average Daily Traffic | Error | Annual Average Daily Traffic must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH09 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH09 Annual Average Daily Traffic must be reported |
B.H.09 | Annual Average Daily Traffic | Flag | Annual Average Daily Traffic must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH09 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH09 Annual Average Daily Traffic |
B.H.10 | Annual Average Daily Truck Traffic | Error | Annual Average Daily Truck Traffic must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH10 = null) | BH10 Annual Average Daily Truck Traffic must be reported |
B.H.10 | Annual Average Daily Truck Traffic | Error | Annual Average Daily Truck Traffic must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH10 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH10 Annual Average Daily Truck Traffic must be reported |
B.H.10 | Annual Average Daily Truck Traffic | Flag | Annual Average Daily Truck Traffic must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH10 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH10 Annual Average Daily Truck Traffic |
B.H.11 | Year of Annual Average Daily Traffic | Error | Year of Annual Average Daily Traffic must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH11 = null) | BH11 Year of Annual Average Daily Traffic must be reported |
B.H.11 | Year of Annual Average Daily Traffic | Error | Year of Annual Average Daily Traffic must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH11 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH11 Year of Annual Average Daily Traffic must be reported |
B.H.11 | Year of Annual Average Daily Traffic | Flag | Year of Annual Average Daily Traffic must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 <> null) AND (BH11 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH11 Year of Annual Average Daily Traffic |
B.H.12 | Highway Maximum Usable Vertical Clearance | Error | Highway Maximum Usable Vertical Clearance must be reported for all highway Features associated with a bridge except under the following conditions: 1) Highway feature is below the bridge and is designated as non-NHS 2) Highway feature is carried on another Bridge in the inventory |
(BL07 = "N") AND (BF01 = H##) AND (BF02 <> "B") AND (BH18 = null) AND (BH12 = null) | Bridge is not a Border Bridge and feature is not below the bridge - BH12 Highway Maximum Usable Vertical Clearance must be reported |
B.H.12 | Highway Maximum Usable Vertical Clearance | Error | Highway Maximum Usable Vertical Clearance must be reported for all highway Features associated with a bridge except under the following conditions: 1) Highway feature is below the bridge and is designated as non-NHS 2) Highway feature is carried on another Bridge in the inventory |
(BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BF02 <> "B") AND (BH18 = null) AND (BH12 = null) | Bridge is a Border Bridge and State is the Designated Lead State and feature is not below the bridge - BH12 Highway Maximum Usable Vertical Clearance must be reported |
B.H.12 | Highway Maximum Usable Vertical Clearance | Error | Highway Maximum Usable Vertical Clearance must be reported for all highway Features associated with a bridge except under the following conditions: 1) Highway feature is below the bridge and is designated as non-NHS 2) Highway feature is carried on another Bridge in the inventory |
(BL07 = "N") AND (BF01 = H##) AND (BF02 = "B") AND (BH03 = "Y") AND (BH18 = null) AND (BH12 = null) | feature is below the bridge and "on" the NHS - BH12 Highway Maximum Usable Vertical Clearance must be reported |
B.H.12 | Highway Maximum Usable Vertical Clearance | Error | Highway Maximum Usable Vertical Clearance must be reported for all highway Features associated with a bridge except under the following conditions: 1) Highway feature is below the bridge and is designated as non-NHS 2) Highway feature is carried on another Bridge in the inventory |
(BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BF02 = "B") AND (BH03 = "Y") AND (BH18 = null) AND (BH12 = null) | Bridge is a Border Bridge and State is the designated State - feature is below the bridge and "on" the NHS - BH12 Highway Maximum Usable Vertical Clearance must be reported |
B.H.12 | Highway Maximum Usable Vertical Clearance | Flag | Highway Maximum Usable Vertical Clearance must be reported for all highway Features associated with a bridge except under the following conditions: 1) Highway feature is below the bridge and is designated as non-NHS 2) Highway feature is carried on another Bridge in the inventory |
When (BL07 = "N") AND (BF01 = H##) AND (BH18 <> null) AND (BH12 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH12 Highway Maximum Usable Vertical Clearance |
B.H.13 | Highway Minimum Vertical Clearance | Critical | Highway Minimum Vertical Clearance must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH13 = null) | BH13 Highway Minimum Vertical Clearance must be reported |
B.H.13 | Highway Minimum Vertical Clearance | Critical | Highway Minimum Vertical Clearance must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH13 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH13 Highway Minimum Vertical Clearance must be reported |
B.H.13 | Highway Minimum Vertical Clearance | Flag | Highway Minimum Vertical Clearance must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH13 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH13 Highway Minimum Vertical Clearance |
B.H.14 | Highway Minimum Horizontal Clearance, Left | Error | Highway Minimum Horizontal Clearance Left must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BF02 = "B") AND (BH18 = null) AND (BH14 = null) | BH14 Highway Minimum Horizontal Clearance, Left must be reported |
B.H.14 | Highway Minimum Horizontal Clearance, Left | Error | Highway Minimum Horizontal Clearance Left must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BF02 = "B") AND (BH18 = null) AND (BH14 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH14 Highway Minimum Horizontal Clearance, Left must be reported |
B.H.14 | Highway Minimum Horizontal Clearance, Left | Flag | Highway Minimum Horizontal Clearance Left must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH14 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH14 Highway Minimum Horizontal Clearance, Left |
B.H.15 | Highway Minimum Horizontal Clearance, Right | Error | Highway Minimum Horizontal Clearance Right must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BF02 = "B") AND (BH18 = null) AND (BH15 = null) | BH15 Highway Minimum Horizontal Clearance, Right must be reported |
B.H.15 | Highway Minimum Horizontal Clearance, Right | Error | Highway Minimum Horizontal Clearance Right must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BF02 = "B") AND (BH18 = null) AND (BH15 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH15 Highway Minimum Horizontal Clearance, Right must be reported |
B.H.15 | Highway Minimum Horizontal Clearance, Right | Flag | Highway Minimum Horizontal Clearance Right must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH15 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH15 Highway Minimum Horizontal Clearance, Right |
B.H.16 | Highway Maximum Usable Surface Width | Error | Highway Maximum Usable Surface Width must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH02 <> "B") AND (BH18 = null) AND (BH16 = null) | BH16 Highway Maximum Usable Surface Width must be reported |
B.H.16 | Highway Maximum Usable Surface Width | Error | Highway Maximum Usable Surface Width must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH02 <> "B") AND (BH18 = null) AND (BH16 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH16 Highway Maximum Usable Surface Width must be reported |
B.H.16 | Highway Maximum Usable Surface Width | Error | Highway Maximum Usable Surface Width must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH02 = "B") AND (BH02 = "Y") AND (BH18 = null) AND (BH16 = null) | feature is "below" the bridge and "on" the NHS - BH16 Highway Maximum Usable Surface Width must be reported |
B.H.16 | Highway Maximum Usable Surface Width | Error | Highway Maximum Usable Surface Width must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH02 = "B") AND (BH02 = "Y") AND (BH18 = null) AND (BH16 = null) | Bridge is a Border Bridge and State is the lead designated State - feature is "below" the bridge and "on" the NHS - BH16 Highway Maximum Usable Surface Width must be reported |
B.H.16 | Highway Maximum Usable Surface Width | Flag | Highway Maximum Usable Surface Width must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH16 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH16 Highway Maximum Usable Surface Width |
B.H.17 | Bypass Detour Length | Critical | Bypass Detour Length must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 = "N") AND (BF01 = H##) AND (BH18 = null) AND (BH17 = null) | BH17 Bypass Detour Length must be reported |
B.H.17 | Bypass Detour Length | Critical | Bypass Detour Length must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = H##) AND (BH18 = null) AND (BH17 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BH17 Bypass Detour Length must be reported |
B.H.17 | Bypass Detour Length | Flag | Bypass Detour Length must be reported for all highway Features associated with a bridge except when that Feature is carried on another Bridge in the inventory | (BF01 = H##) AND (BH18 <> null) AND (BH17 <> null) FLAG and IGNORE | BH18 crossing Bridge Number indicates this highway feature is carried on another bridge - do not report BH17 Bypass Detour Length |
B.H.18 | Crossing Bridge Number | Critical | All Crossing Bridge Numbers reported should have a separate and unique bridge record in that State's inventory | (BH18 <> null) THEN (BL01, BH18 combination in Features dataset = BL01, BID01 in Primary dataset) | BL01 State Code/BH18 crossing Bridge Number combination does not match any BL01 State Code/BID01 Bridge Number combination in the Primary dataset |
B.RR.01 | Railroad Service Type | Error | Railroad Service Type must be reported for all railroad Features associated with a bridge | (BL07 = "N") AND (BF01 = R##) AND (BRR01 = null) | Bridge is not a Border Bridge- BRR01 Railroad Service Type must be reported for all railroad features |
B.RR.01 | Railroad Service Type | Error | Railroad Service Type must be reported for all railroad Features associated with a bridge | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = R##) AND (BRR01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BRR01 Railroad Service Type must be reported for all railroad features |
B.RR.02 | Railroad Minimum Vertical Clearance | Error | Railroad Minimum Vertical Clearance must be reported for all railroad Features associated with a bridge | (BL07 = "N") AND (BF01 = R##) AND (BF02 = "B") AND (BRR02 = null) | BRR02 Railroad Minimum Vertical Clearance must be reported for all railroad features "below" the bridge |
B.RR.02 | Railroad Minimum Vertical Clearance | Error | Railroad Minimum Vertical Clearance must be reported for all railroad Features associated with a bridge | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = R##) AND (BF02 = "B") AND (BRR02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BRR02 Railroad Minimum Vertical Clearance must be reported for all railroad features "below" the bridge |
B.RR.03 | Railroad Minimum Horizontal Offset | Error | Railroad Minimum Horizontal Offset must be reported for all railroad Features associated with a bridge | (BL07 = "N") AND (BF01 = R##) AND (BF02 = "B") AND (BRR03 = null) | BRR03 Railroad Minimum Horizontal Offset must be reported for all railroad features "below" the bridge |
B.RR.03 | Railroad Minimum Horizontal Offset | Error | Railroad Minimum Horizontal Offset must be reported for all railroad Features associated with a bridge | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = R##) AND (BF02 = "B") AND (BRR03 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BRR03 Railroad Minimum Horizontal Offset must be reported for all railroad features "below" the bridge |
"Routes" | Routes Data Set | Critical | A minimum of one Routes Dataset must be reported for each highway Feature associated with a bridge | (BF01 = H##) AND (BRT01 = null) | At least one routes dataset must be reported for each "highway" feature |
B.RT.01 | Route Designation | Critical | All "Routes" datasets must have a unique State Code, Bridge Number, Feature Type, Route Designation combination (BL01, BID01, BF01, BRT01) among all "Routes" datasets for a highway Feature | (BL01, BID01, BF01, RT01 Routes dataset combination) is NOT UNIQUE among the Routes datasets | Duplicated routes datasets have been submitted for this bridge |
B.RT.01 | Route Designation | Critical | State Code, Bridge Number, Feature Type combination (BL01, BID01, BF01) from Routes Datasets should match State Code, Bridge Number, Feature Type (BL01, BID01, BF01) from the Features Dataset | (BL01, BID01, BF01 from Routes dataset <> BL01, BID01, BF01 combination from Features dataset) | BL01 State Code/BID01 Bridge Number/BF01 Feature Type combination from the routes dataset does not match the BL01 State Code/BID01 Bridge Number/BF01 Feature Type combination from the Features dataset for this bridge |
B.RT.02 | Route Number | Error | Route Number must be reported for all highway Features associated with a bridge | (BF01 = H##) AND (BRT02 = null) | BRT02 Route Number must be reported for all highway features |
B.RT.03 | Route Direction | Error | Route Direction must be reported for all highway Features associated with a bridge | (BF01 = H##) AND (BRT03 = null) | BRT03 Route Direction must be reported for all highway features |
B.RT.04 | Route Type | Error | Route Type must be reported for all highway Features associated with a bridge | (BF01 = H##) AND (BRT04 = null) | BRT04 Route Type must be reported for all highway features |
B.RT.05 | Service Type | Error | Service Type must be reported for all highway Features associated with a bridge | (BF01 = H##) AND (BRT05 = null) | BRT05 Service Type must be reported for all highway features |
"Navigable Waterway" | Navigable Waterway Data Set | Critical | A minimum of one Navigable Waterway Dataset must be reported for all waterway Features associated with a bridge | (BL07 = "N") AND (BF01 = W##) AND (BN01 = null) | Bridge not a Border Bridge - at least one Navigation dataset must be submitted for all "waterway" features |
"Navigable Waterway" | Navigable Waterway Data Set | Critical | A minimum of one Navigable Waterway Dataset must be reported for all waterway Features associated with a bridge | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = W##) AND (BN01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - at least one Navigation dataset must be submitted for all "waterway" features |
B.N.01 | Navigable Waterway | Critical | All "Navigable Waterway" datasets must have a unique State Code, Bridge Number, Feature Type, Navigable Waterway combination (BL01, BID01, BF01, BN01) among all "Navigable Waterway" datasets for a waterway Feature | (BL01, BID01, BF01, BN01 Navigable Waterway dataset combination) is NOT UNIQUE among the Navigable Waterway datasets | Duplicate Waterway datasets have been submitted for this bridge |
B.N.02 | Navigable Waterway | Critical | State Code, Bridge Number, Feature Type combination (BL01, BID01, BF01) from Navigable Waterway Datasets should match State Code, Bridge Number, Feature Type (BL01, BID01, BF01) from the Features Dataset | (BL01, BID01, BF01 from Navigable Waterway dataset <> BL01, BID01, BF01 combination from Features dataset) | BL01 State Code/BID01 Bridge Number/BF01 Feature Type combination from the waterway dataset does not match the BL01 State Code/BID01 Bridge Number/BF01 Feature Type combination from the Features dataset for this bridge |
B.N.02 | Navigation Minimum Vertical Clearance | Error | Navigation Minimum Vertical Clearance must be reported for all waterway Features with a Navigable Waterway | (BL07 = "N") AND (BF01 = W##) AND (BN01 = "Y") AND (BN02 = null) | BN02 Navigation Minimum Vertical Clearance must be reported for all "waterway" features with a navigable waterway |
B.N.02 | Navigation Minimum Vertical Clearance | Error | Navigation Minimum Vertical Clearance must be reported for all waterway Features with a Navigable Waterway | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = W##) AND (BN01 = "Y") AND (BN02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BN02 Navigation Minimum Vertical Clearance must be reported for all "waterway" features with a navigable waterway |
B.N.03 | Movable Bridge Maximum Navigation Vertical Clearance | Error | Movable Bridge Maximum Navigation Vertical Clearance must be reported for all moveable bridges with waterway Features and Navigable Waterway | (BL07 = "N") AND (BF01 = W##) AND (BSP06 = "M") AND (BN01 = "Y") AND (BN03 = null) | BN03 Moveable Bridge Maximum Navigation Vertical Clearance must be reported for all "waterway" features with a navigable waterway "below" a moveable Span Type |
B.N.03 | Movable Bridge Maximum Navigation Vertical Clearance | Error | Movable Bridge Maximum Navigation Vertical Clearance must be reported for all moveable bridges with waterway Features and Navigable Waterway | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = W##) AND (BSP06 = "M") AND (BN01 = "Y") AND (BN03 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BN03 Moveable Bridge Maximum Navigation Vertical Clearance must be reported for all "waterway" features with a navigable waterway "below" a moveable Span Type |
B.N.04 | Navigation Channel Width | Error | Navigation Channel Width must be reported for all Navigable Waterway associated with a waterway Feature | (BL07 = "N") AND (BF01 = W##) AND (BN01 = "Y") AND (BN04 = null) | BN04 Navigation Channel Width must be reported for all "waterway" features with a navigable waterway |
B.N.04 | Navigation Channel Width | Error | Navigation Channel Width must be reported for all Navigable Waterway associated with a waterway Feature | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = W##) AND (BN01 = "Y") AND (BN04 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BN04 Navigation Channel Width must be reported for all "waterway" features with a navigable waterway |
B.N.05 | Navigation Channel Minimum Horizontal Clearance | Error | Navigation Channel Minimum Horizontal Clearance must be reported for all Navigable Waterway associated with a waterway Feature | (BL07 = "N") AND (BF01 = W##) AND (BN01 = "Y") AND (BN05 = null) | BN05 Navigation Channel Minimum Horizontal Clearance must be reported for all "waterway" features with a navigable waterway |
B.N.05 | Navigation Channel Minimum Horizontal Clearance | Error | Navigation Channel Minimum Horizontal Clearance must be reported for all Navigable Waterway associated with a waterway Feature | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = W##) AND (BN01 = "Y") AND (BN05 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BN05 Navigation Channel Minimum Horizontal Clearance must be reported for all "waterway" features with a navigable waterway |
B.N.06 | Substructure Navigation Protection | Error | Substructure Navigation Protection must be reported for all Navigable Waterway associated with a waterway Feature | (BL07 = "N") AND (BF01 = W##) AND (BN01 = "Y") AND (BN06 = null) | BN06 Substructure Navigation Protection must be reported for all "waterway" features with a navigable waterway |
B.N.06 | Substructure Navigation Protection | Error | Substructure Navigation Protection must be reported for all Navigable Waterway associated with a waterway Feature | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 = W##) AND (BN01 = "Y") AND (BN06 = null) | Bridge is Border Bridge and State is the Designated Lead State - BN06 Substructure Navigation Protection must be reported for all "waterway" features with a navigable waterway |
B.LR.01 | Design Load | Error | Design Load must be reported for all bridges | (BL07 = "N") AND (BLR01 = null) | BLR01 Design Load must be reported for all bridges |
B.LR.01 | Design Load | Error | Design Load must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BLR01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BLR01 Design Load must be reported for all bridges |
B.LR.02 | Design Method | Error | Design Method must be reported for all bridges | (BL07 = "N") AND (BLR02 = null) | BLR02 Design Method must be reported for all bridges |
B.LR.02 | Design Method | Error | Design Method must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BLR02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BLR02 Design Load must be reported for all bridges |
B.LR.03 | Load Rating Date | Error | Load Rating Date must be reported when an initial or updated load rating has been completed for a bridge | (BL07 = "N") AND ((BLR05 <> null) OR (BLR06 <> null)) AND (BLR03 = null) | BLR03 Load Rating date must be reported when an initial or updated load rating has been completed |
B.LR.03 | Load Rating Date | Error | Load Rating Date must be reported when an initial or updated load rating has been completed for a bridge | (BL07 <> "N") AND (BL10 = BL01) AND ((BLR05 <> null) OR (BLR06 <> null)) AND (BLR03 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BLR03 Load Rating date must be reported when an initial or updated load rating has been completed |
B.LR.04 | Load Rating Method | Error | Load Rating Method must be reported when an initial or updated load rating has been completed for a bridge | (BL07 = "N") AND ((BLR05 <> null) OR (BLR06 <> null)) AND (BLR04 = null) | BLR04 Load Rating Method must be reported when an initial or updated load rating has been completed |
B.LR.04 | Load Rating Method | Error | Load Rating Method must be reported when an initial or updated load rating has been completed for a bridge | (BL07 <> "N") AND (BL10 = BL01) AND ((BLR05 <> null) OR (BLR06 <> null)) AND (BLR04 = null) | Bridge is a border and State is the Designated Lead State - BLR04 Load Rating Method must be reported when an initial or updated load rating has been completed |
B.LR.05 | Inventory Load Rating Factor | Flag | Inventory Load Rating Factor must be reported when an initial or updated load rating has been completed for a bridge | (BL07 = "N") AND ((BLR03 <> null) OR (BLR04 <> null) OR (BL06 <> null)) AND (BLR05 = null) | Other load rating data fields indicate a new load rating may have been completed recently but BLR05 Inventory Load Rating Factor has not been reported for this bridge |
B.LR.05 | Inventory Load Rating Factor | Flag | Inventory Load Rating Factor must be reported when an initial or updated load rating has been completed for a bridge | (BL07 <> "N") AND (BL10 = BL01) AND ((BLR03 <> null) OR (BLR04 <> null) OR (BL06 <> null)) AND (BLR05 = null) | Bridge is a Border Bridge and State is the Designated Lead State - other load rating data fields indicate a new load rating may have been completed recently but BLR05 Inventory Load rating Factor has not been reported for this bridge |
B.LR.06 | Operating Load Rating Factor | Flag | Operating Load Rating Factor must be reported when an initial or updated load rating has been completed for a bridge | (BL07 = "N") AND ((BLR03 <> null) OR (BLR04 <> null) OR (BL05 <> null)) AND (BLR06 = null) | Other load rating data fields indicated a new load rating may have been completed recently but BLR06 Operating Load Rating Factor has not been reported for this bridge |
B.LR.06 | Operating Load Rating Factor | Flag | Operating Load Rating Factor must be reported when an initial or updated load rating has been completed for a bridge | (BL07 <> "N") AND (BL10 = BL01) AND ((BLR03 <> null) OR (BLR04 <> null) OR (BL05 <> null)) AND (BLR06 = null) | Bridge is a Border Bridge and State is the Designated Lead State - other load rating data fields indicated a new load rating may have been completed recently but BLR06 Operating Load Rating Factor has not been reported for this bridge |
B.LR.07 | Controlling Legal Load Rating Factor | Flag | Controlling Legal Load Rating Factor must be reported when an initial or updated load rating has been completed for a bridge | (BL07 = "N") AND ((BLR03 <> null) OR (BLR04 <> null) OR (BLR05 <> null) OR (BLR06 <> null)) AND (BLR07 = null) | Other load rating data fields indicated a new load rating may have been completed recently but BLR07 Controlling Legal Load Rating Factor has not been reported for this bridge |
B.LR.07 | Controlling Legal Load Rating Factor | Flag | Controlling Legal Load Rating Factor must be reported when an initial or updated load rating has been completed for a bridge | (BL07 <> "N") AND (BL10 = BL01) AND ((BLR03 <> null) OR (BLR04 <> null) OR (BLR05 <> null) OR (BLR06 <> null)) AND (BLR07 = null) | Bridge is a Border Bridge and State is the Designated Lead State - other load rating data fields indicated a new load rating may have been completed recently but BLR07 Controlling Legal Load Rating Factor has not been reported for this bridge |
B.LR.08 | Routine Permit Loads | Error | Routine Permit Loads must be reported for all bridges | (BL07 = "N") AND (BLR08 = null) | BLR08 Routine Permit Loads must be reported for all bridges |
B.LR.08 | Routine Permit Loads | Error | Routine Permit Loads must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BLR08 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BLR08 Routine Permit Loads must be reported for all bridges |
"Posting Status" | Load Posting Status Data Set | Critical | One Posting Status dataset must be reported for all bridges | (BL07 = "N") AND (BPS02 = null) | At least one Load Posting Status dataset must be reported for all bridges |
"Posting Status" | Load Posting Status Data Set | Critical | One Posting Status dataset must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BPS02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - at least one Load Posting Status dataset must be reported for all bridges |
B.PS.02 | Posting Status Change Date | Critical | All "Posting Status" datasets must have a unique State Code, Bridge Number, Posting Status Change Date combination (BL01, BID01, BSP02) among all "Posting Status" datasets for a Bridge | (BL01, BID01, BPS02 Posting Status dataset combination) is NOT UNIQUE among the Posting Status datasets | Duplicate Load Posting Status datasets have been reported for this bridge |
B.PS.02 | Posting Status Change Date | Critical | State Code, Bridge Number combination (BL01, BID01) from Posting Status Dataset should match State Code, Bridge Number (BL01, BID01)from the Primary Dataset | (BL01, BID01 from Posting Status dataset <> BL01, BID01 combination from Primary dataset) | BL01 State Code/BID01 Bridge Number combination from the Load Posting Status dataset does not match the BL01 State Code/BID01 Bridge Number combination from the Primary dataset for this bridge |
B.PS.01 | Load Posting Status | Error | Load Posting Status must be reported for all bridges | (BL07 = "N") AND (BPS01 = null) | BPS01 Load Posting Status must be reported for all bridges |
B.PS.01 | Load Posting Status | Error | Load Posting Status must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BPS01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BPS01 Load Posting Status must be reported for all bridges |
"Evaluation and Posting" Datasets | Legal Load Configuration | Critical | Legal Load Configuration must be reported for all bridges | (BL07 = "N") AND (BEP01 = null) | At least one Load Evaluation and Posting dataset must be submitted for all bridges |
"Evaluation and Posting" Datasets | Legal Load Configuration | Critical | Legal Load Configuration must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BEP01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - at least one Load Evaluation and Posting dataset must be submitted for all bridges |
B.EP.01 | Legal Load Configuration | Critical | All "Load Evaluation and Posting" datasets must have a unique State Code, Bridge Number, Legal Load Configuration combination (BL01, BID01, BEP01) among all "Posting Status" datasets for a Bridge | (BL01, BID01, BEP01 Load Evaluation and Posting dataset combination) is NOT UNIQUE among the Load Evaluation and Posting datasets | Duplicate Load Evaluation and Posting datasets have been reported for this bridge |
B.EP.01 | Legal Load Configuration | Critical | State Code, Bridge Number combination (BL01, BID01) from Load Evaluation and Posting Dataset should match State Code, Bridge Number (BL01, BID01)from the Primary Dataset | (BL01, BID01 from Load Evaluation and Posting dataset <> BL01, BID01 combination from Primary dataset) | BL01 State Code/BID01 Bridge Number combination from the Load Evaluation and Posting dataset does not match the BL01 State Code/BID01 Bridge Number combination from the Primary dataset for this bridge |
B.EP.02 | Legal Load Rating Factor | Error | Legal Load Rating Factor must be reported for all bridges | (BL07 = "N") AND (BEP02 = null) | BEP02 Legal Load Rating Factor must be reported for all bridges |
B.EP.02 | Legal Load Rating Factor | Error | Legal Load Rating Factor must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BEP02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BEP02 Legal Load Rating Factor must be reported for all bridges |
B.EP.03 | Posting Type | Error | Posting Type must be reported for all bridges with a Legal Load Rating Factor less than one | (BL07 = "N") AND (BEP02 < 1.00) AND (BEP03 = null) | BEP03 Posting Type must be reported when Legal Load Rating Factor is less than "1.0" |
B.EP.03 | Posting Type | Error | Posting Type must be reported for all bridges with a Legal Load Rating Factor less than one | (BL07 <> "N") AND (BL10 = BL01) AND (BEP02 < 1.00) AND (BEP03 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BEP03 Posting Type must be reported when Legal Load Rating Factor is less than "1.0" |
B.EP.04 | Posting Value | Error | Posting Value must be reported for all bridges with a Legal Load Rating Factor less than one and the bridge is posted for Gross Load, Single Axle Load, Tandem Axle Load, Truck Load or Other | (BL07 = "N") AND (BEP02 < 1.00) AND (BEP03 = "G" or "A" or "D" or "T" or "X") AND (BEP04 = null) | BEP04 Posting Value must be reported when Legal Load Rating Factor is less than "1.0" - except when Posting Type is equal to "g, a, d, t or x" |
B.EP.04 | Posting Value | Error | Posting Value must be reported for all bridges with a Legal Load Rating Factor less than one and the bridge is posted for Gross Load, Single Axle Load, Tandem Axle Load, Truck Load or Other | (BL07 <> "N") AND (BL10 = BL01) AND (BEP02 < 1.0) AND (BEP03 = "G" or "A" or "D" or "T" or "X") AND (BEP04 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BEP04 Posting Value must be reported when Legal Load Rating Factor is less than "1.0" - except when Posting Type is equal to "G, A, D,T or X" |
B.C.01 | Deck Condition Rating | Critical | Deck Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC01 = null) | BC01 Deck Condition Rating must be reported for all bridges |
B.C.01 | Deck Condition Rating | Critical | Deck Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC01 Deck Condition Rating must be reported for all bridges |
B.C.01 | Deck Condition Rating | Flag | When the value for the Deck Material and Type in ANY Spans dataset is not equal to zero then the Deck Condition Rating should be within the range of 0 - 9; | (BSP09 in ANY Spans dataset <> 0) AND (BC01 <> RANGE (0 - 9)) | BC01 Deck Condition Rating is not in the valid value range of "0 - 9" |
B.C.01 | Deck Condition Rating | Flag | When the value for the Deck Material and Type in ALL Spans datasets is equal to zero then the Deck Condition Rating should equal "N" | (BSP09 in ALL Spans Datasets = 0) AND (BC01 <> "N") | Spans datasets indicate no deck is present for this bridge - BC01 Deck Condition Rating should be equal to "N" |
B.C.02 | Superstructure Condition Rating | Critical | Superstructure Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC02 = null) | BC02 Superstructure Condition Rating must be reported for all bridges |
B.C.02 | Superstructure Condition Rating | Critical | Superstructure Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC02 Superstructure Condition Rating must be reported for all bridges |
B.C.02 | Superstructure Condition Rating | Flag | If the Span Configuration Designation in ANY of the Spans Datasets is not equal to C## or V##; then Superstructur Condition Rating should be within the range of 0 - 9 | (BSP01 <> C## or V## in ANY Spans dataset) AND (BC02 <> RANGE (0 - 9)) | BC02 Superstructure Condition Rating is not in the valid value range of "0-9" |
B.C.02 | Superstructure Condition Rating | Flag | If the Span Configuration Designation in ANY of the Spans Datasets is equal to C## or V## and Span Continuity is not equal to seven; then Superstructur Condition Rating should be within the range of 0 - 9 | (BSP01 = C## or V## in ANY Spans dataset) AND (BSP05 <> 7) AND (BC02 <> RANGE (0 - 9)) | BC02 Superstructure Condition Rating is not in the valid value range of "0-9" |
B.C.02 | Superstructure Condition Rating | Flag | If the Span Configuration Designation in ALL of the Spans Datasets is equal to C## or V## AND Span Continuity is equal to seven; then Superstructur Condition Rating should be equal to "N" | (BSP01 = C## or V## in ALL Spans dataset) AND (BSP05 = 7) AND (BC02 <> "N") | Superstructure Condition Ratingpans datasets indicate no superstructure is present for this bridge - BC02 Superstructure Condition Rating should be equal to "N" |
B.C.03 | Substructure Condition Rating | Critical | Substructure Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC03 = null) | BC03 Substructure Condition Rating must be reported for all bridges |
B.C.03 | Substructure Condition Rating | Critical | Substructure Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC03 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC03 Substructure Condition Rating must be reported for all bridges |
B.C.03 | Substructure Condition Rating | Flag | If the Span Configuration Designation in ANY of the Spans Datasets is not equal to C## or V##; then Substructur Condition Rating should be within the range of 0 - 9 | (BSP01 <> C## or V## in ANY Spans dataset) AND (BC03 <> RANGE (0 - 9)) | BC03 Substructure Condition Rating is not in the valid value range of "0-9" |
B.C.03 | Substructure Condition Rating | Flag | If the Span Configuration Designation is equal to C## or V## and Span Continuity is not equal to seven; then Substructur Condition Rating should be within the range of 0 - 9 | (BSP01 = C## or V## in ANY Spans dataset) AND (BSP05 <>7) AND (BC03 <> RANGE (0 - 9)) | BC03 Substructure Condition Rating is not in the valid value range of "0-9" |
B.C.03 | Substructure Condition Rating | Flag | If the Span Configuration Designation in ALL of the Spans Datasets is equal to C## or V## AND the Span Continuity is equal to seven; then Substructure Condition Rating should be equal to "N" | (BSP01 = C## or V## in ALL Spans dataset) AND (BSP05 = 7) AND (BC03 <> "N") | Spans datasets indicate no substructure is present for this bridge - BC03 Substructure Condition Rating should be equal to "N" |
B.C.04 | Culvert Condition Rating | Critical | Culvert Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC04 = null) | BC04 Culvert Condition Rating must be reported for all bridges |
B.C.04 | Culvert Condition Rating | Critical | Culvert Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC04 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC04 Culvert Condition Rating must be reported for all bridges |
B.C.04 | Culvert Condition Rating | Flag | If the Span Configuration Designation in ALL of the Spans Datasets is equal to C## or V## AND the Span Continuity is equal to seven; then Substructure Condition Rating should be within the range of 0 - 9 | (BSP01 = C## or V## in ALL Spans dataset) AND (BSP05 = 7) AND (BC04 <> RANGE (0 -9)) | BC04 Culvert Condition Rating is not in the valid value range of "0-9" |
B.C.04 | Culvert Condition Rating | Flag | If the Span Configuration Designation in ALL of the Spans Datasets is not equal to C## or V##; then Substructure Condition Rating should be equal to "N" | (BSP01 <> C## or V## in ANY Spans dataset) AND (BC04 <> "N") | Spans datasets indicate this bridge is not a culvert - BC04 Culvert Condition Rating should be equal to "N" |
B.C.05 | Bridge Railing Condition Rating | Error | Bridge Railing Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC05 = null) | BC05 Bridge Railing Condition Rating must be reported for all bridges |
B.C.05 | Bridge Railing Condition Rating | Error | Bridge Railing Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC05 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC05 Bridge Railing Condition Rating must be reported for all bridges |
B.C.05 | Bridge Railing Condition Rating | Error | Bridge Railing Condition Rating should be within the range of 0 - 9 or "N" | (BC05 <> RANGE(0-9), "N")) | BC05 Bridge Railing Condition Rating is not in the valid value range of "0-9" or "N" |
B.C.06 | Bridge Railing Transitions Condition Rating | Error | Bridge Railing Transition Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC06 = null) | BC06 Bridge Railing Transition Condition Rating must be reported for all bridges |
B.C.06 | Bridge Railing Transitions Condition Rating | Error | Bridge Railing Transition Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC06 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC06 Bridge Railing Transition Condition Rating must be reported for all bridges |
B.C.06 | Bridge Railing Transitions Condition Rating | Error | Bridge Railing Transition Condition Rating should be within the range of 0 - 9 or "N" | (BC06 <> RANGE (0-9, "N")) | BC06 Bridge Railing Transition Condition Rating is not in the valid value range of "0-9" or "N" |
B.C.07 | Bridge Bearings Condition Rating | Error | Bridge Bearings Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC07 = null) | BC07 Bridge Bearings Condition Rating must be reported for all bridges |
B.C.07 | Bridge Bearings Condition Rating | Error | Bridge Bearings Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC07 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC07 Bridge Bearings Condition Rating must be reported for all bridges |
B.C.07 | Bridge Bearings Condition Rating | Error | Bridge Bearings Condition Rating should be within the range of 0 - 9 or "N" | (BC07 <> RANGE(0-9, "N")) | BC07 Bridge Bearings Condition Rating is not in the valid value range of "0-9" or "N" |
B.C.08 | Bridge Joints Condition Rating | Error | Bridge Joints Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC08 = null) | BC08 Bridge Joints Condition Rating must be reported for all bridges |
B.C.08 | Bridge Joints Condition Rating | Error | Bridge Joints Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC08 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC08 Bridge Joints Condition Rating must be reported for all bridges |
B.C.08 | Bridge Joints Condition Rating | Error | Bridge Joints Condition Rating should be within the range of 0 - 9 or "N" | (BC08 <> RANGE(0-9, "N")) | BC08 Bridge Joints Condition Rating is not in the valid value range of "0-9" or "N" |
B.C.09 | Channel Condition Rating | Error | Channel Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC09 = null) | BC09 Channel Condition Rating must be reported for all bridges |
B.C.09 | Channel Condition Rating | Error | Channel Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC09 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC09 Channel Condition Rating must be reported for all bridges |
B.C.09 | Channel Condition Rating | Error | Channel Condition Ratings for waterway Features should be within the range of 0 - 9 | (BF01 in ANY Features dataset = W##) AND (BC09 <> RANGE (0 - 9)) | BC09 Channel Condition Rating range should be in the valid value range of "0-9" for all bridges with a "waterway" feature |
B.C.09 | Channel Condition Rating | Error | Channel Condition Ratings for bridges without waterway Features should be equal to "N" | (BF01 in ALL Features dataset <> W##) AND (BC09 <> "N") | BC09 Channel Condition Rating should be equal to "N" for all bridges that do not have a "waterway" feature |
B.C.10 | Channel Protection Condition Rating | Error | Channel Protection Condition Rating must be reported for all bridges | (BL07 = "N") AND (BC10 = null) | BC10 Channel Protection Condition Rating must be reported for all bridges |
B.C.10 | Channel Protection Condition Rating | Error | Channel Protection Condition Rating must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC10 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC10 Channel Protection Condition Rating must be reported for all bridges |
B.C.10 | Channel Protection Condition Rating | Error | Channel Protection Condition Ratings for waterway Features should be within the range of 0 - 9 | (BF01 in ANY Features dataset = W##) AND (BC10 <> RANGE (0 - 9)) | BC10 Channel Protection Condition Rating should be in the valid value range of "0-9" for all bridges with a "waterway" feature |
B.C.10 | Channel Protection Condition Rating | Error | Channel Protection Condition Ratings for bridges without waterway Features should be equal to "N" | (BF01 in ALL Features dataset <> W##) AND (BC10 <> "N") | BC10 Channel Protection Condition Rating should be equal to "N" for all bridge that do not have a "waterway" feature |
B.C.11 | Scour Condition Rating | Error | Scour Condition Ratings based on the observed or measured scour must be reported for all bridges | (BL07 = "N") AND (BC11 = null) | BC11 Scour Condition Rating must be reported for all bridges |
B.C.11 | Scour Condition Rating | Error | Scour Condition Ratings based on the observed or measured scour must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BC11 = null) | Bridge is a Border Bridge and State is the designed lead State - BC11 Scour Condition Rating must be reported for all bridges |
B.C.11 | Scour Condition Rating | Error | Channel Protection Condition Ratings for waterway Features should be within the range of 0 - 9 | (BF01 in ANY Features dataset = W##) AND (BC11 <> RANGE (0 - 9)) | BC11 Scour Condition Rating should be in the valid value range of "0-9" for all bridges with a "waterway" feature |
B.C.11 | Scour Condition Rating | Error | Channel Protection Condition Ratings for bridges without waterway Features should be equal to "N" | (BF01 in ALL Features dataset <> W##) AND (BC11 <> "N") | BC11 Scour Condition Rating should be equal to "N" for bridges without a "waterway" feature |
B.C.14 | NSTM Inspection Condition | Error | NSTM Inspection Condition must be reported for all bridges when the value for NSTM Inspection Required is equal to "Y" | (BL07 = "N") AND (BIR01 = "Y") AND (BC14 = null) | BC14 NSTM Inspection Condition must be reported for bridges that require NSTM inspection |
B.C.14 | NSTM Inspection Condition | Error | NSTM Inspection Condition must be reported for all bridges when the value for NSTM Inspection Required is equal to "Y" | (BL07 <> "N") AND (BL10 = BL01) AND (BIR01 = "Y") AND (BC14 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC14 NSTM Inspection Condition must be reported for bridges that require NSTM inspection |
B.C.14 | NSTM Inspection Condition | Error | When reported, the value for NSTM Inspection Condition Rating should be within the range of 0 - 9 | (BIR01 = "Y") AND (BC14 <> RANGE (0 - 9)) | BC14 NSTM Inspection Condition should be in the valid value range of "0-9" for bridges that require NSTM inspection |
B.C.14 | NSTM Inspection Condition | Flag | NSTM Inspection Condition should not be reported when the value for NSTM Inspection Required is not equal to "Y" | (BIR01 <> "Y") AND (BC14 <> null) | Do not report BC14 NSTM Inspection Condition for bridges that do not require NSTM inspection |
B.C.15 | Underwater Inspection Condition | Error | Underwater Inspection Condition must be reported for all bridges when the value for Underwater Inspection Required is equal to "Y" | (BL07 = "N") AND (BIR03 = "Y") AND (BC15 = null) | BC15 Underwater Inspection Condition must be reported for bridges that require underwater inspection |
B.C.15 | Underwater Inspection Condition | Error | Underwater Inspection Condition must be reported for all bridges when the value for Underwater Inspection Required is equal to "Y" | (BL07 <> "N") AND (BL10 = BL01) AND (BIR03 = "Y") AND (BC15 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BC15 Underwater Inspection Condition must be reported for bridges that require underwater inspection |
B.C.15 | Underwater Inspection Condition | Error | When reported, the value for Underwater Inspection Condition Rating should be within the range of 0 - 9 | (BIR03 = "Y") AND (BC15 <> RANGE (0 - 9)) | BC15 Underwater Inspection Condition should be in the valid value range of "0-9" for bridge that require underwater inspection |
B.C.15 | Underwater Inspection Condition | Flag | Underwater Inspection Condition should not be reported when the value for Underwater Inspection Required is not equal to "Y" | (BIR03 <> "Y") AND (BC15 <> null) | Do not report BC15 Underwater Inspection Condition for bridges that do not require underwater inspection |
B.IR.01 | NSTM Inspection Required | Error | NSTM Inspection Required must be reported for all bridges with Span Material or Substructure Material equal to steel | (BL07 = "N") AND (BSP04 OR BSB03 = "S01" or "S02" or "S03" or "S05" or "SX") AND (BIR01 = null) | BIR01 NSTM Insepection Required must be reported for all bridges with steel superstructure and/or steel substructure |
B.IR.01 | NSTM Inspection Required | Error | NSTM Inspection Required must be reported for all bridges with Span Material or Substructure Material equal to steel | (BL07 <> "N") AND (BL10 = BL01) AND (BSP04 OR BSB03 = "S01" or "S02" or "S03" or "S05" or "SX") AND (BIR01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BIR01 NSTM Insepection Required must be reported for all bridges with steel superstructure and/or steel substructure |
B.IR.01 | NSTM Inspection Required | Flag | NSTM Inspection Required must be reported for all bridges with Span Material or Substructure Material equal to steel | (BSP04 OR BSB03 <> "S01" or "S02" or "S03" or "S05" or "SX") AND (BIR01 <> null) | Do not report BIR01 NSTM Insepection Required for bridges that do not have steel superstructure and/or steel substructure |
B.IR.02 | Fatigue Details | Error | Fatigue Details must be reported for all bridges with Span Material or Substructure Material equal to steel | (BL07 = "N") AND (BSP04 OR BSB03 = "S01" or "S02" or "S03" or "S05" or "SX") AND (BIR02 = null) | BIR02 Fatigue Details must be reported for all bridges with steel superstructure and/or steel substructure |
B.IR.02 | Fatigue Details | Error | Fatigue Details must be reported for all bridges with Span Material or Substructure Material equal to steel | (BL07 <> "N") AND (BL10 = BL01) AND (BSP04 OR BSB03 = "S01" or "S02" or "S03" or "S05" or "SX") AND (BIR02 = null) | Bridge is a Border Bridge - BIR02 Fatigue Details must be reported for all bridges with steel stuperstructure and/or steel substructure |
B.IR.02 | Fatigue Details | Flag | Fatigue Details must be reported for all bridges with Span Material or Substructure Material equal to steel | (BSP04 OR BSB03 <> "S01" or "S02" or "S03" or "S05" or "SX") AND (BIR02 <> null) | Do not report BIR02 Fatigue Details for bridges that do not have steel superstructure and/or steel substructure |
B.IR.03 | Underwater Inspection Required | Error | Underwater Inspection Required must be reported for all bridges with a waterway Feature | (BL07 = "N") AND (BF01 in ANY Features dataset = W##) AND (BIR03 = null) | BIR03 Underwater Inspection Required must be reported for all bridges with a "waterway" feature |
B.IR.03 | Underwater Inspection Required | Error | Underwater Inspection Required must be reported for all bridges with a waterway Feature | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 in ANY Features dataset = W##) AND (BIR03 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BIR03 Underwater Inspection Required must be reported for all bridges with a "waterway" feature |
B.IR.03 | Underwater Inspection Required | Flag | Underwater Inspection Required must be reported for all bridges with a waterway Feature | (BF01 in ALL Features dataset <> W##) AND (BIR03 <> null) | Do not report BIR03 Underwater Inspection Required for bridges that do not have a "waterway" feature |
B.IR.04 | Complex Feature | Error | Complex Feature must be reported for all bridges | (BL07 = "N") AND (BIR04 = null) | BIR04 Complex Feature must be reported for all bridges |
B.IR.04 | Complex Feature | Error | Complex Feature must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BIR04 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BIR04 Complex Feature must be reported for all bridges |
B.IE.01 | Inspection Type | Critical | All "Inspection Event" datasets must have a unique State Code, Bridge Number, Inspection Type, Inspection Begin Date combination (BL01, BID01, BIE01, BIE02) among all "Inspection Event" datasets for a Bridge | (BL01, BID01, BIE01, BIE02 Inspection Events dataset combination) is NOT UNIQUE among the Inspection Events datasets | Duplicate Inspection Event datasets have been submitted for this bridge |
B.IE.01 | Inspection Type | Critical | State Code, Bridge Number combination (BL01, BID01) from Inspection Events Dataset should match State Code, Bridge Number (BL01, BID01)from the Primary Dataset | (BL01, BID01 from Inspection Events dataset <> BL01, BID01 combination from Primary dataset) | BL01 State Code/BID01 Bridge Number combination from the Inspection Event dataset does not match the BL01 State Code/BID01 Bridge Number combination from the Primary dataset for this bridge |
B.IE.02 | Inspection Begin Date | Critical | Inspection Begin Date must be reported for all Inspection Events associated with a bridge | (BL07 = "N") AND (BIE02 = null) | BIE02 Inspection Begin Date must be reported for all inspection events regardless of inspection type |
B.IE.02 | Inspection Begin Date | Critical | Inspection Begin Date must be reported for all Inspection Events associated with a bridge | (BL07 <> "N") AND (BL10 = BL01) AND (BIE02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BIE02 Inspection Begin Date must be reported for all inspection events regardless of inspection type |
B.IE.03 | Inspection Completion Date | Error | Inspection Completion Date must be reported for all Inspection Events associated with a bridge | (BIE03 = null) | BIE03 Inspection Completion Date must be reported for all inspection events regardless of inspection type |
B.IE.04 | Nationally Certified Bridge Inspector | Error | Team Leader must be reported for initial, routine, in-depth, NSTM, underwater, and special Inspection Events associated with a bridge | (BIE01 = 1 or 2 or 3 or 4 or 6 or 7) AND (BIE04 = null) | BIE04 Nationally Certified Bridge Inspector must be reported for all initial, routine, underwater, NSTM, in-depth, or special inspections |
B.IE.05 | Inspection Interval | Error | Inspection Interval must be reported for all inspection events regardless of inspection type | (BIE05 = null) | BIE05 Inspection Interval must be reported for all inspection events |
B.IE.05 | Inspection Interval | Flag | The value for Inspection Intervals for damage and scour monitoring Inspection Types that do not have defined Inspection Intervals should be equal to zero | (BIE01 = 5 or 9) AND (BIE05 <> 0) | BIE05 Inspection Interval should be equal to "0" for inspection types that do not have a defined inspection interval |
B.IE.07 | Risk-Based Inspection Interval Method | Error | Risk-Based Inspection Interval Method must be reported for all inspection events regardless of inspection type | (BIE07 = null) | BIE07 Risk-Based Inspection Interval Method must be reported for all inspection events regardless of inspection type |
B.IE.07 | Risk-Based Inspection Interval Method | Flag | The value for Risk-Based Inspection Interval Method for initial, damage, in-depth, special, service and scour monitoring Inspection Types should be equal to "N" | (BIE01 = 1 or 5 or 6 or 7 or 8 or 9) AND (BIE07 <> "N") | BIE07 risk-based inspection interval method should be equal to "N" for initial, damage, in-depth, special, service, or scour monitoring inspection types |
B.IE.07 | Risk-Based Inspection Interval Method | Flag | The value for Risk-Based Inspection Interval Method for routine, underwater and NSTM Inspection Types should be equal to one or two | (BIE01 = 2 or 3 or 4) AND (BIE07 <> 1 or 2) | BIE07 risk-based inspection interval method should be equal to "1" or "2" for routine, underwater, and nstm inspection types |
B.IE.10 | Inspection Data Update Date | Error | Inspection Data Update Date must be reported for all Inspection Event datasets associated with a bridge | (BIE10 = null) | BIE10 Inspection Data Update Date must be reported for all inspection events |
"Element Identification" | Element Identification Dataset | Critical | Element Identification datasets must be reported for ALL bridges on the NHS | (BL07 = "N") AND (BF01 in ANY Features dataset = "Hxx") AND (BF02 = "C") AND (BH03 = "Y") AND (BE01 = null) | Element Identification datasets must be reported for bridges with a "highway" feature carried "on" the bridge that has been designated as being "on" the NHS |
"Element Identification" | Element Identification Dataset | Critical | Element Identification datasets must be reported for ALL bridges on the NHS | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 in ANY Features dataset = "Hxx") AND (BF02 = "C") AND (BH03 = "Y") AND (BE01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - Element Identification datasets must be reported for bridges with a "highway" feature carried "on" the bridge that has been designated as being "on" the NHS |
B.E.01 | Element Number | Critical | All "Element" datasets must have unique State Code, Bridge Number, Element Number, Element Parent Number combination for a Bridge | When (BL01, BID01, BE01, BE02 Inspection Events dataset combination) is NOT UNIQUE among the Element Identification datasets | Duplicate Element Identification datasets have been submitted for this bridge |
B.E.01 | Element Number | Flag | When the value for Wearing Surface in ALL Spans Datasets is equal to zero indicating there is no Wearing Surface; then Element Number should not equal 510 | (BSP10 in ALL Spans datasets = 0) AND (BE01 in ANY Element Identification dataset = 510) | Spans dataset indicates there is no Wearing Surface on the deck of this bridge - BE01 Element Number should not equal "510" |
B.E.01 | Element Number | Flag | When the value for Span Protective System in ALL Spans Datasets is not equal to C01, C02, C03, C04 or CX; then Element Number should not equal 515 or 521 | (BSP07 in ALL Spans datasets <> C01 or C02 or C03 or C04, or CX) AND (BE01 in ANY Element Identificaiton dataset = 515 or 521) | Spans dataset indicates there are no protective "coating" systems on the superstucture of this bridge - BE01 Element Number should not equal "515" or "521" |
B.E.01 | Element Number | Flag | When the value for Substructure Protective System in ALL Spans Datasets is not equal to C01, C02, C03, or CX; then Element Number should not equal 515 or 521 | (BSB05 in ALL Substructures datasets <> C01 or C02 or C03 or CX) AND (BE01 in ANY Element Identificaiton dataset = 515 or 521) | Substructures dataset indicates there are no protective "coating" systems on the substructure of this bridge - BE01 Element Number should not equal "515" or "521" |
B.E.01 | Element Number | Flag | When the value for Span Continuity in ALL Spans Datasets is not equal to five; then Element Number should not equal 161 | (BSP05 in ALL Spans datasets <> 5) AND (BE01 in ANY Element Identification dataset = 161) | Spans dataset indicates there are no pin and hangar assemblies for this bridge - BE01 Element Number should not equal "161" |
B.E.02 | Element Parent Number | Critical | Element Parent Numbers are required for Wearing Surface and Protective Coating elements - Element Identification dataset for wearing surfaces and protective coatings cannot be processed without it | (BE01 = 510 or 515 or 521) AND (BE02 = null) | BE02 Element Parent Number is required for Element Numbers 510, 515, and 521 - Element Identification dataset cannot be processed without it |
B.E.02 | Element Parent Number | Error | Element Parent Numbers for Wearing Surface and Protective Coating elements should not equal zero | (BE01 = 510 or 515 or 521) AND (BE02 = 0) | Element Number indicates this element is a Wearing Surface or protective coating - BE02 Element Parent Number must not equal "0" |
B.E.03 | Element Total Quantity | Error | Element Total Quantity must be reported for Element Identification datasets associated with a bridge | (BE03 = null) | BE03 Element Total Quantity must be reported for all Element Identification datasets |
B.E.03 | Element Total Quantity | Critical | The value for Element Total Quantity should be equal to the sum of all four Element Quantity Condition States within the Element Identification dataset | (BE03 <> (BCS01 + BCS02 + BCS03 + BCS04)) | BE03 Element Total Quantity does not equal the sum of the quantities identified in CS1, CS2, CS3, and CS4 |
B.CS.01 | Element Quantity Condition State One | Error | Element Quantity Condition State One must be reported for all Element Identification datasets associated with a bridge | (BCS01 = null) | BCS01 Element Quantity Condition State "one" must be reported for all Element Identification datasets - including "zero" when applicable |
B.CS.02 | Element Quantity Condition State Two | Error | Element Quantity Condition State Two must be reported for all Element Identification datasets associated with a bridge | (BCS02 = null) | BCS02 Element Quantity Condition State "two" must be reported for all Element Identification datasets - including "zero" when applicable |
B.CS.03 | Element Quantity Condition State Three | Error | Element Quantity Condition State Three must be reported for all Element Identification datasets associated with a bridge | (BCS03 = null) | BCS03 Element Quantity Condition State "three" must be reported for all Element Identification datasets - including "zero" when applicable |
B.CS.04 | Element Quantity Condition State Four | Error | Element Quantity Condition State Four must be reported for all Element Identification datasets associated with a bridge | (BCS04 = null) | BCS04 Element Quantity Condition State "four" must be reported for all Element Identification datasets - including "zero" when applicable |
B.AP.01 | Approach Roadway Alignment | Error | Approach Roadway Alignment must be reported for all bridges | (BL07 = "N") AND (BAP01 = null) | BAP01 Approach Roadway Alignment must be reported for all bridges |
B.AP.01 | Approach Roadway Alignment | Error | Approach Roadway Alignment must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BAP01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BAP01 Approach Roadway Alignment must be reported for all bridges |
B.AP.02 | Overtopping Likelihood | Error | Overtopping Likelihood must be reported for all bridges with waterway Features | (BL07 = "N") AND (BF01 in ANY Features dataset = W##) AND (BAP02 = null) | BAP02 Overtopping Likelihood must be reported for all bridges with a "waterway" feature below the bridge |
B.AP.02 | Overtopping Likelihood | Error | Overtopping Likelihood must be reported for all bridges with waterway Features | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 in ANY Features dataset = W##) AND (BAP02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BAP02 Overtopping Likelihood must be reported for all bridges with a "waterway" feature below the bridge |
B.AP.03 | Scour Vulnerability | Error | Scour Vulnerability must be reported for all bridges with waterway Features | (BL07 = "N") AND (BF01 in ANY Features dataset = W##) AND (BAP03 = null) | BAP03 Scour Vulnerability must be reported for all bridges with a "waterway" feature below the bridge |
B.AP.03 | Scour Vulnerability | Error | Scour Vulnerability must be reported for all bridges with waterway Features | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 in ANY Features dataset = W##) AND (BAP03 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BAP03 Scour Vulnerability must be reported for all bridges with a "waterway" feature below the bridge |
B.AP.04 | Scour Plan of Action | Error | Scour Plan of Action must be reported for all bridges with waterway Features | (BL07 = "N") AND (BF01 in ANY Features dataset = W##) AND (BAP04 = null) | BAP04 Scour Plan of Action must be reported for all bridges with a "waterway" feature below the bridge |
B.AP.04 | Scour Plan of Action | Error | Scour Plan of Action must be reported for all bridges with waterway Features | (BL07 <> "N") AND (BL10 = BL01) AND (BF01 in ANY Features dataset = W##) AND (BAP04 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BAP04 Scour Plan of Action must be reported for all bridges with a "waterway" feature below the bridge |
B.AP.05 | Seismic Vulnerability | Error | Seismic Vulnerability must be reported for all bridges | (BL07 = "N") AND (BAP05 = null) | BAP05 Seismic Vulnerability must be reported for all bridges |
B.AP.05 | Seismic Vulnerability | Error | Seismic Vulnerability must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BAP05 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BAP05 Seismic Vulnerability must be reported for all bridges |
B.W.01 | Year Built | Error | Year Built must be reported for all bridges | (BL07 = "N") AND (BW01 = null) | BW01 year built must be reported for all bridges |
B.W.01 | Year Built | Error | Year Built must be reported for all bridges | (BL07 <> "N") AND (BL10 = BL01) AND (BW01 = null) | Bridge is a Border Bridge and State is the Designated Lead State - BW01 year built must be reported for all bridges |
"Work Events" Dataset Key Fields | REQUIRES: BL01 State Code BID01 Bridge Number BW02 Year Work Performed |
Critical | Work Events dataset must be reported for all bridges; All "Work Events" datasets must have a unique State Code, Bridge Number, Year Work Performed combination (BL01, BID01, BW02) among all "Work Events" datasets for a Bridge | (BL07 = "N") AND (BW02 = null) | Work performed for a bridge must be reported every year - Work Events dataset is missing - BE02 year work performed must be reported as a key field |
"Work Events" Dataset Key Fields | REQUIRES: BL01 State Code BID01 Bridge Number BW02 Year Work Performed |
Critical | Work Events dataset must be reported for all bridges; All "Work Events" datasets must have a unique State Code, Bridge Number, Year Work Performed combination (BL01, BID01, BW02) among all "Work Events" datasets for a Bridge | (BL07 = "N") AND (BL10 = BL01) AND (BW02 = null) | Bridge is a Border Bridge and State is the Designated Lead State - work performed for a bridge must be reported every year - Work Events dataset is missing - BE02 year work performed must be reported as a key field |
B.W.02 | Year Work Performed | Critical | State Code, Bridge Number combination (BL01, BID01) from Work Events Dataset should match State Code, Bridge Number combination (BL01, BID01)from the Primary Dataset | (BL01, BID01 from Work Events dataset <> BL01, BID01 combination from Primary dataset) | BL01 State Code/BID01 Bridge Number combination from the work events dataset does not match the BL01 State Code/BID01 Bridge Number combination from the Primary dataset for this bridge |
B.W.02 | Year Work Performed | Flag | Year Work Performed should be greater than Year Built for any Work Events dataset | (BW02 < BW01) | BW02 Year Work Performed is earlier or equal to BW01 Year Built |
B.W.03 | Work Performed | Error | When Work Performed in the Work Events dataset is equal to "BR1" meaning the bridge has been replaced; no other work types should be reported in that Work Event dataset | (BW03 CONTAINS("BR1" and ANY OTHER CODES) | BW03 Work Performed indicates the bridge has been replaced - no other codes should be reported in this dataset |
B.W.03 | Work Performed | Flag | Work Performed for scour, channel or channel protection should not be reported for bridges that do not have waterway Features | (BF01 in ALL Features datasets <> W##) AND (BW03 = SC1 or SC2 or CP1 or CP2 or CH1) | BW03 Work Performed includes scour, channel, and channel protection codes for a bridge does not have a "waterway" feature below the bridge |
B.W.03 | Work Performed | Flag | Work Performed for railings should not be reported for bridge that do not have railings | (BRH01 or BRH 02 = "N") AND (BW03 = RT1 or RT2) | BW03 Work Performed includes bridge railing and transition codes for a bridge does have railings or Transitions |
B.W.03 | Work Performed | Flag | Superstructure/substructure work items reported for a culvert. | (B.SP.01 = C## or V## in ALL Spans Datasets) AND (BW03 = IN(SP1, SP2, SP3, SP5, SP6, SP7, SB1, SB2, SB3, SB5, SB6, SB7)) | BW03 Work Performed includes superstructure and substructure work codes for a culvert that include superstructure or substructure |
B.W.03 | Work Performed | Flag | Culvert work items reported for non-culvert. | (B.SP.01 = M## or A## or W##) in ALL Spans datasets) AND (BW03 = IN(CU2, CU3, CU4, CU5, CU6, CU7)) | BW03 Work Performed includes culvert work codes for a bridge that does not include culvert elements |
B.W.03 | Work Performed | Flag | Work Performed bridge replacement code is not consistent with Previous Bridge Number reported. | (BW03 = "BR1") AND (BID01 = BID01 from the previous year) AND (BID03 <> 0) | BW03 Work Performed codes include "BR1" indicating the bridge has been replaced and original Bridge Number has been retained - Previous Bridge Number should be equal to "zero" |
B.W.03 | Work Performed | Flag | Deck rehabilitation codes reported with Deck replacement codes | (BW03 = DK1 and IN(DK2, DK3)) | BW03 Work Performed includes deck replacement code with deck rehabilitation codes |
B.W.03 | Work Performed | Flag | Supestructure rehabilitation codes reported with Superstructure replacement code | (BW03 = SP1 and IN(SP2, SP3)) | BW03 Work Performed includes superstructure replacement code with superstructure rehabilitation codes |
B.W.03 | Work Performed | Flag | Substructure replacement code reported with substructure replacement code | (BW03 = SB1 and IN(SB2, SB3)) | BW03 Work Performed codes include substructure replacment code with substructure rehabilitation codes |
B.W.03 | Work Performed | Flag | Deck major rehabilitation code reported with Deck minor rehabilitation code | (BW03 = DK2 and DK3) | BW03 Work Performed - report only "DK2" deck major rehabilitation when both major and minor rehabilitation activities were completed on the deck |
B.W.03 | Work Performed | Flag | Supestructure major rehabitation code reported with Superstructure minor rehabilitation code | (BW03 = SP2 and SP3) | BW03 Work Performed - report only "SP2" superstructure major rehabilitation when both major and minor rehabilitation activities were completed on the superstructure |
B.W.03 | Work Performed | Flag | Substructure major rehabilitation code reported with substructure minor rehabilitation code | (BW03 = SB2 and SB3) | BW03 Work Performed - report only "SB2" substructure major rehabilitation when both major and minor rehabilitation activities were completed on the substructure |
B.W.03 | Work Performed | Flag | Culvert major rehabilitation code reported with culvert minor rehabilitation code | (BW03 = CU2 and CU3) | BW03 Work Performed - report only "CU2" culvert major rehabilitation when both major and minor rehabilitation activities were completed on the culvert |