SWIPTFIR

Sewer IPT Inspection Test Results

Field Name

Caption

Mask

Description

Field Type

IR_AM_CD

Analysis Method

5x

Analysis Method

Text

IR_AM_TY

Analysis Method Text

60x

Analysis Method Text

Text

IR_AVAL

Authority Value

nnnnnnnn.nn

Authority Value

Double

IR_BML

Below Min Limit

 

Below Minimum Limit

Boolean

IR_CEDIT

Continuous Edit

 

Continuous Edit

Boolean

IR_CM_CD

Collection Method

5x

Collection Method

Text

IR_CM_TY

Collection Method Text

60x

Collection Method Text

Text

IR_CRESULTS

Conc Results

10x

Conc Results

Text

IR_CRT_BY

Created By

25x

Created By

Text

IR_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

IR_DC

Daily Compliance

 

Daily Compliance

Boolean

IR_DETECT

Below Detectable Limit

 

Below Detectable Limit

Boolean

IR_DLIMIT

Daily Limit

nnnnnnnn.nn

Daily Limit

Double

IR_DLLIM

Daily Lower Limit

nnnnnnnn.nn

Daily Lower Limit

Double

IR_DMLEVEL

Daily Magnitude Level

nnnnnnnn.nn

Daily Magnitude Level

Double

IR_DMNC

Daily Magnitude NC

 

Daily Magnitude Non-Compliance

Boolean

IR_DNC

Daily Non-Compliance

 

Daily Non-Compliance

Boolean

IR_DRESULT

Daily Result

nnnnnnnn.nn

Daily Result

Double

IR_EMSL

Exceeds Max Surcharge

 

Exceeds Maximum Surcharge Limit

Boolean

IR_END_DT

End Date Sampled

mm/dd/yyyy

End Date Sampled

Date/Time

IR_END_TM

End Time Sampled

hh:mm am

End Time Sampled

Date/Time

IR_EPL

Exceeds Permit Limit

 

Exceeds Permit Limit

Boolean

IR_ESL

Exceeds Surcharge Limit

 

Exceeds Surcharge Limit

Boolean

IR_EST_CD

Estimated Code

nnn

Estimated Code

Integer

IR_EST_TY

Estimated Code Text

50x

Estimated Code Text

String

IR_ID

Insp Test Results Rec #

nnnnnnnn

Autonumber ID

Long Integer

IR_II_ID

Facility Insp Record No

nnnnnnnn

Link to SWIPTFI.II_ID

Long Integer

IR_IP_ID

Facility Test Rec #

nnnnnnnn

Link to SWIPTFT.IP_ID

Long Integer

IR_ISAMP

Ignore Sample

 

Ignore Sample

Boolean

IR_ISAMPC

Ignore Sample Comments

254x

Ignore Sample Comments

String

IR_ITEM

Item

30x

Item

Text

IR_LTRM

Last Test for Month

 

Last Test Results for the Month

Boolean

IR_MC

Monthly Compliance

 

Monthly Compliance

Boolean

IR_ML

Minimum Limit

nnnnnnnn.nn

Minimum Limit

Double

IR_MLIMIT

Monthly Limit

nnnnnnnn.nn

Monthly Limit

Double

IR_MLLIM

Monthly Lower Limit

nnnnnnnn.nn

Monthly Lower Limit

Double

IR_MMLEVEL

Monthly Magnitude Level

nnnnnnnn.nn

Monthly Magnitude Level

Double

IR_MMNC

Monthly Magnitude NC

 

Monthly Magnitude Non-Compliance

Boolean

IR_MNC

Monthly Non-Compliance

 

Monthly Non-Compliance

Boolean

IR_MOD_BY

Last Mod By

25x

Last Modified By

Text

IR_MOD_DT

Last Mod Date

mm/dd/yyyy

Last Modified Date

Date/Time

IR_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

IR_MRESULT

Monthly Result

nnnnnnnn.nn

Monthly Result

Double

IR_MSL

Max Surcharge Limit

nnnnnnnn.nn

Maximum Surcharge Limit

Double

IR_NUMBER

Line Number

nnnn

Line Number

Integer

IR_PARA_CD

Parameter

5x

Parameter

Text

IR_PARA_TY

Parameter Text

60x

Parameter Text

Text

IR_PL

Permit Limit

nnnnnnnn.nn

Permit Limit

Double

IR_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

IR_SL

Surcharge Limit

nnnnnnnn.nn

Surcharge Limit

Double

IR_SNCLD

SNC Daily Lower Limit

nnnnnnnn.nn

SNC Daily Lower Limit

Double

IR_SNCLM

SNC Monthly Lower Limit

nnnnnnnn.nn

SNC Monthly Lower Limit

Double

IR_STRT_DT

Start Date Sampled

mm/dd/yyyy

Start Date Sampled

Date/Time

IR_STRT_TM

Start Time Sampled

hh:mm am

Start Time Sampled

Date/Time

IR_SVAL

Self Monitored Value

nnnnnnnn.nn

Self Monitored Value

Double

IR_UOM_CD

UOM

10x

UOM

Text

IR_UOM_TY

UOM Text

60x

UOM Text

Text