SWNET

Pipe Inventory

Field Name

Caption

Mask

Description

Field Type

NT_ACADED

Record Drawn on Map?

 

Record Drawn on Map?

Boolean

NT_ACTIVE

Active

 

Active Flag

Boolean

NT_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

NT_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

NT_BASIN

Flow Basin

25x

Flow Basin

Text

NT_BED_CD

Bedding

nnn

Bedding Code

Integer

NT_BED_TY

Bedding Text

25x

Bedding Text

Text

NT_BR_CD

Default WO Cat

10x

Default Category Code

Text

NT_BR_TY

Default WO Cat Text

60x

Default Category Code

Text

NT_CAPAC

Capacity (cfs)

nnnn.nn

Capacity (cfs)

Double

NT_CF_DINV

Adj DS Inv Elev

nnnn.nn

DS Inv Elev Adjustment

Double

NT_CF_DRIM

Adj DS Rim Elev

nnnn.nn

DS Rim Elev Adjustment

Double

NT_CF_UINV

Adj US Inv Elev

nnnn.nn

US Inv Elev Adjustment

Double

NT_CF_URIM

Adj US Rim Elev

nnnn.nn

US Rim Elev Adjustment

Double

NT_CFREQ

Cleaning Freq

nnn

Cleaning Freq

Integer

NT_CFRQ_CD

Cleaning Freq Units

nnn

Cleaning Freq Units

Integer

NT_CFRQ_TY

Cleaning Freq Units Tex

10x

Cleaning Freq Units Tex

Text

NT_CLEN_CD

Cleaning Freq

nnn

Cleaning Frequency Code

Integer

NT_CLEN_TY

Cleaning Freq Text

30x

Cleaning Frequency Text

Text

NT_CLINST

Cleaning Instructions

254x

Cleaning Instructions

Text

NT_CLN_CD

Cleaning Area

nnn

Cleaning Area Code

Integer

NT_CLN_TY

Cleaning Area Text

25x

Cleaning Area Text

Text

NT_COF

Consequence of Failure

nnnn.

Consequence of Failure

Double

NT_COND

General Condition

nnnnnnnn.nn

General Condition

Double

NT_CONINST

Construction Instructions

254x

Construction Instructions

Text

NT_CREW

Collected By

30x

Collected By

Text

NT_CRITCAL

Criticality

nnnnnn.

Criticality

Double

NT_CRT_BY

Created By

25x

Created By

Text

NT_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

NT_DIA

Dia/Height (in)

nnnn

Dia/Height (in)

Double

NT_DIST_CD

District

nnn

District Code

Integer

NT_DIST_TY

District Text

25x

District Text

Text

NT_DOC_FLG

Document Available

 

Document Available

Boolean

NT_DS_INV

DS Invert

nnnn.nn

Active DS Invert

Double

NT_DS_RIM

DS Rim

nnnn.nn

Active DS Rim

Double

NT_DS_STA

DS Station

nnnnnn.nn

DS Station

Double

NT_DSBLOCK

DS Collap/Blocked

1x

Downstream Block

Text

NT_DSCLNNO

DS TV Clean Total #

nnnn

Downstream Remaining Cleaning Number

Integer

NT_DSCLNRT

DS Clean Rating

nnnnn.n

Downstream Remaining Cleaning Ratings

Double

NT_DSCONCD

DS Last TV Cond

nnn

Downstream Condition

Integer

NT_DSCONTY

DS Last TV Cond Text

25x

Downstream Condition Text

Text

NT_DSDEPO

DS Depo Depth

nnn.nn

Downstream Deposition

Double

NT_DSDEPTH

DS Flow Depth

nnn.nn

Downstream Depth

Double

NT_DSFLWNO

DS TV Flow Total #

nnnn.nnn

Downstream Remaining Flow Number

Double

NT_DSFLWRT

DS Flow Rating

nnnnn.n

Downstream Remaining Flow Rating

Double

NT_DSID

DS Struc Rec #

 

DS Link to SWNETMH.MA_MHID

Long Integer

NT_DSINVO

Record DS Invert

nnnn.nn

Record DS Invert

Double

NT_DSLCLN

DS Lamp Clean #

nnnn.nnn

Downstream Cleaning No

Double

NT_DSLFLW

DS Lamp Flow #

nnnn.nnn

Downstream Infiltration Value

Double

NT_DSLMPDT

DS Lamping Date

mm/dd/yyyy

Downstream Lamping Date

Date/Time

NT_DSLSTR

DS Lamp Struc #

nnnn.nnn

Downstream Structural No

Double

NT_DSMAN

DS Structure

25x

Downstream Manhole Number

Text

NT_DSMAXFT

DS Max Dist

nnnn.n

Downstream Max Distance

Double

NT_DSMAXOB

DS Max Obs

nnnn

Downstream Max Observations

Integer

NT_DSPADT

DS Last PACP Date

mm/dd/yyyy

Downstream TV Date

Date/Time

NT_DSPROM

DS Pipe O&&M

nnn.n

DS PACP Pipe Ratings O&M

Double

NT_DSPRS

DS Pipe Structural

nnn.n

DS PACP Pipe Ratings Structural

Double

NT_DSPRT

DS Pipe Total

nnn.n

DS PACP Pipe Ratings Total

Double

NT_DSQROM

DS Quick O&&M

30x

DS PACP Quick Rating O&M

Text

NT_DSQRS

DS Quick Structural

30x

DS PACP Quick Rating Structural

Text

NT_DSQRT

DS Quick Total

30x

DS PACP Quick Rating Total

Text

NT_DSRIMO

Record DS Rim

nnnn.nn

Record DS Rim

Double

NT_DSSTRNO

DS TV Struct Total #

nnnn

Downstream Remaining Structural Number

Integer

NT_DSSTRRT

DS Struct Rating

nnnnn.n

Downstream Remaining Structural Ratings

Double

NT_DSTVDT

DS Last TV Date

mm/dd/yyyy

Downstream TV Date

Date/Time

NT_DSVEL

DS Velocity

nnn.nn

Downstream Velocity

Double

NT_DT_CONS

Date Constructed

mm/dd/yyyy

Date Constructed

Date/Time

NT_FASSET

Fixed Asset ID

nnnnnnnn

Fixed Asset ID

Long Integer

NT_FLOW_CD

Flow Type

nnn

Flow Type Code

Integer

NT_FLOW_TY

Flow Type Text

40x

Flow Type Text

Text

NT_FTYP_CD

From End Type

nnn

From End Type

Integer

NT_FTYP_TY

From End Type Text

25x

From End Type Text

Text

NT_GOVT_CD

Benefit District

nnn

Benefit District Code

Integer

NT_GOVT_TY

Benefit District Text

25x

Benefit District Text

Text

NT_ID

Pipe Rec #

nnnnnnnn

Unique ID

Long Integer

NT_IDM

IDM

nnnn.nn

Inch-Diameter-Miles

Double

NT_IFREQ

Inspection Freq

nnn

Inspection Freq

Integer

NT_IFRQ_CD

Inspection Freq Units

nnn

Inspection Freq Units

Integer

NT_IFRQ_TY

Inspection Freq Units Text

10x

Inspection Freq Units Text

String

NT_IGNORE

Ignore in Model

 

Ignore Pipe Segment in Modeling Runs

Boolean

NT_IMG_FLG

 

 

Image Available

Boolean

NT_IMPR_CD

Improve Method

nnn

Improvement Method

Integer

NT_IMPR_TY

Improve Method Text

40x

Improvement Method Text

Text

NT_INDX_CD

Index

75x

Index Number

Text

NT_INMAP

In Map?

 

Flag indicating this feature is in the map

Boolean

NT_INSP_DT

Inspection Date

mm/dd/yyyy

Inspection Date

DateTime

NT_INST1

Instructions 1

254x

Instructions 1

Text

NT_INST2

Instructions 2

254x

Instructions 2

Text

NT_INVLOCK

Inv. Elevation Lock

 

Invert Elevation Lock :

Boolean

NT_JOINTS

Est # of Joints

nnn

Est # of Joints

Integer

NT_LCLN_DT

Last Cleaning Date

mm/dd/yyyy

Last Cleaning Date

Date/Time

NT_LEN_CD

Length Status

nnn

Length Status Code

Integer

NT_LEN_TY

Length Status Text

25x

Length Status Text

Text

NT_LENGTH

Length (ft)

nnnnn.n

Length (ft)

Double

NT_LINE_CD

Line Type

nnn

Line Type Code

Integer

NT_LINE_DT

Lining Date

mm/dd/yyyy

Pipe Lining Date

Date/Time

NT_LINE_TY

Line Type Text

40x

Line Type Text

Text

NT_LINEYR

Year Lined

4x

Year Lined

Text

NT_LINR_CD

Liner

nnn

Liner Code

Integer

NT_LINR_TY

Liner Text

40x

Liner Text

Text

NT_LOC_CD

Location

nnn

Location Code

Integer

NT_LOC_TY

Location Text

50x

Location Text

Text

NT_LOCK

Elevation Lock

 

Elevation Lock

Boolean

NT_LWOT_DT

Last WO Task Date

mm/dd/yyyy

Last WO Task Date

DateTime

NT_MANG_CD

Managed By

nnn

Managed By

Integer

NT_MANG_TY

Managed By Text

25x

Managed By Text

Text

NT_MANNING

Mannings

n.nnn

Mannings n Value

Double

NT_MAT_CD

Material

nnn

Material Code

Integer

NT_MAT_TY

Material Text

50x

Material Text

Text

NT_MITIGAT

Mitigation

nnnnnnnn.nn

Mitigation

Double

NT_MOD_BY

Modified By

25x

Modified By

Text

NT_MOD_DT

Modified Date

mm/dd/yyyy

Modified Date

Date/Time

NT_MOD_TM

Modified Time

hh:mm am

Modified Time

Date/Time

NT_MOV_FLG

 

 

Movie Available

Boolean

NT_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

NT_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

NT_NCLN_DT

Next Cleaning Date

mm/dd/yyyy

Next Cleaning Date

Date/Time

NT_NINSP_DT

Next Inspection Date:

mm/dd/yyyy

Next Inspection Date:

DateTime

NT_NO_US

Upstream Count

nnnnnnnn

Number of Pipe Segments Upstream

Long Integer

NT_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

NT_NUMBER

Alt Pipe ID

61x

Alt Pipe ID

Text

NT_OCOND_CD

Overall Cond

nnn

Overall Cond

Integer

NT_OCOND_TY

Overall Cond Text

25x

Overall Cond Text

String

NT_OWN_CD

Owner

nnn

Owner Code

Integer

NT_OWN_TY

Owner Text

100x

Owner Text

Text

NT_PA_ID_I

Incoming Pipe to Plant

nnnnnnnn

Link to EFPLANT.PA_ID: Incoming Pipe to Plant

Long Integer

NT_PA_ID_O

Outgoing Pipe from Plant

nnnnnnnn

Link to EFPLANT.PA_ID: Outgoing Pipe from Plant

Long Integer

NT_POF

Probability of Failure

nnn.nn

Probability of Failure

Double

NT_PROJ_NO

Project Number

10x

Project Number

Text

NT_PSECLTH

Pipe Sec Length (ft)

nnnn.n

Pipe Section Length

Double

NT_PVALUE

Present Value

nnnnnnnn.nn

Present Value

Double

NT_RCOST

Replacement Cost

nnnnn.nn

Replacement Cost

Double

NT_REPL_DT

Replacement Date

mm/dd/yyyy

Replacement Date

Date/Time

NT_REVIEW

Review Comments

 

Review Comments

Boolean

NT_RISK

Risk

nnnn.

Risk - COF * POF

Double

NT_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

NT_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

NT_RVALUE

Replacement Value

nnnnnnnnn.nn

Replacement Value

Double

NT_S_T_R

Sec-Twn-Rng

10x

Section-Township-Range

Text

NT_SHAP_CD

Pipe Shape

nnn

Shape Code

Integer

NT_SHAP_TY

Pipe Shape Text

40x

Shape Text

Text

NT_SLOPE

Slope %

-nn.nnn

Slope %

Double

NT_SLP_LCK

Slope Lock

 

Slope Lock

Boolean

NT_SMK_CD

Smoke Result

nnn

Smoke Result Code

Integer

NT_SMK_FLW

Smoke Flow

nnnn.nn

Smoke Flow Amount

Double

NT_SMK_TY

Smoke Result Text

25x

Smoke Result Text

Text

NT_SMKDT

Smoke Date

mm/dd/yyyy

Last Smoke Testing Date

Date/Time

NT_SN_ID

Pump Station Record No

nnnnnnnn

Link to SWSTATN.SN_ID

Long Integer

NT_ST_DINV

DS Invert Status

1x

DS Invert Status

Text

NT_ST_DRIM

DS Rim Status

1x

DS Rim Status

Text

NT_ST_UINV

US Invert Status

1x

US Invert Status

Text

NT_ST_URIM

US Rim Status

1x

US Rim Status

Text

NT_STAT_CD

Status

nnn

Status

Integer

NT_STAT_TY

Status Text

25x

Status Text

Text

NT_STYPE_CD

Subtype

nnn

GIS Subtype Code

Integer

NT_STYPE_TY

Subtype Text

25x

GIS Subtype Text

Text

NT_SURF_CD

Surface

nnn

Surface Code

Integer

NT_SURF_TY

Surface Text

25x

Surface Text

Text

NT_TAG

Record Tag for Progr

 

Record Tag for Program

Boolean

NT_TRAP_CD

Trap Area

nnn

Trap Area Code

Integer

NT_TRAP_TY

Trap Area Text

25x

Trap Area Text

Text

NT_TTYP_CD

To End Type

nnn

To End Type

Integer

NT_TTYP_TY

To End Type Text

25x

To End Type Text

Text

NT_TV_CD

TV Frequency

nnn

TV Frequency Code

Integer

NT_TV_TY

TV Frequency Text

30x

TV Frequency Text

Text

NT_TVINST

TV Instructions

254x

TV Instructions

Text

NT_UPDIA

Upsize Dia Needed

nnnn

Upsize Dia Needed

Integer

NT_US_INV

US Invert

nnnn.nn

Active US Invert

Double

NT_US_RIM

US Rim

nnnn.nn

Active US Rim

Double

NT_US_STA

US Station

nnnnnn.nn

US Station

Double

NT_USBLOCK

US Collap/Blocked

1x

Upstream Block

Text

NT_USCLNNO

US TV Clean Total #

nnnn

Upstream Remaining Cleaning Number

Integer

NT_USCLNRT

US Clean Rating

nnnnn.n

Upstream Remaining Cleaning Ratings

Double

NT_USCONCD

US Last TV Cond

nnn

Upstream Condition

Integer

NT_USCONTY

US Last TV Cond Text

25x

Upstream Condition Text

Text

NT_USDEPO

US Depo Depth

nnn.nn

Upstream Deposition

Double

NT_USDEPTH

US Flow Depth

nnn.nn

Upstream Depth

Double

NT_USER1CD

User 1

nnn

User 1

Integer

NT_USER1TY

User 1 Text

25x

User 1 Text

Text

NT_USER2CD

User 2

nnn

User 2

Integer

NT_USER2TY

User 2 Text

25x

User 2 Text

Text

NT_USER3CD

User 3

nnn

User 3

Integer

NT_USER3TY

User 3 Text

25x

User 3 Text

Text

NT_USER4

User 4

nnnnnnnnn.nn

User 4

Double

NT_USER5

User 5

30x

User 5

Text

NT_USER6

User 6

 

User 6

Boolean

NT_USER7

User 7

 

User 7

Boolean

NT_USER8

User 8

 

User 8

Boolean

NT_USER9

User 9

mm/dd/yyyy

User 9

Date/Time

NT_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

NT_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

NT_USER12

User 12

-nnnnnnnnn.nn

User 12

Double

NT_USER13

User 13

-nnnnnnnnn.nn

User 13

Double

NT_USER14

User 14

30x

User 14

Text

NT_USER15

User 15

30x

User 15

Text

NT_USER16CD

User 16

nnn

User 16

Integer

NT_USER16TY

User 16 Text

25x

User 16 Text

Text

NT_USER17CD

User 17

nnn

User 17

Integer

NT_USER17TY

User 17 Text

25x

User 17 Text

Text

NT_USER18

User 18

30x

User 18

Text

NT_USER19

User 19

30x

User 19

Text

NT_USER20

User 20

-nnnnnnnnn.nn

User 20

Double

NT_USER21

User 21

-nnnnnnnnn.nn

User 21

Double

NT_USER22

User 22

mm/dd/yyyy

User 22

Date/Time

NT_USER23

User 23

mm/dd/yyyy

User 23

Date/Time

NT_USER24

User 24

 

User 24

Boolean

NT_USER25

User 25

 

User 25

Boolean

NT_USER26

User 26

60x

User 26

Text

NT_USER27

User 27

60x

User 27

Text

NT_USER28

User 28

 

User 28

Boolean

NT_USER29

User 29

 

User 29

Boolean

NT_USER30

User 30

 

User 30

Boolean

NT_USER31CD

User 31

nnn

User 31

Integer

NT_USER31TY

User 31 Text

30x

User 31 Text

Text

NT_USER32CD

User 32

nnn

User 32

Integer

NT_USER32TY

User 32 Text

30x

User 32 Text

Text

NT_USER33CD

User 33

nnn

User 33

Integer

NT_USER33TY

User 33 Text

30x

User 33 Text

Text

NT_USER34CD

User 34

nnn

User 34

Integer

NT_USER34TY

User 34 Text

30x

User 34 Text

Text

NT_USER35CD

User 35

nnn

User 35

Integer

NT_USER35TY

User 35 Text

30x

User 35 Text

Text

NT_USER36

User 36

30x

User 36

Text

NT_USER37

User 37

30x

User 37

Text

NT_USER38

User 38

30x

User 38

Text

NT_USER39

User 39

30x

User 39

Text

NT_USER40

User 40

30x

User 40

Text

NT_USER41

User 41

nnnnnnnn.nn

User 41

Double

NT_USER42

User 42

nnnnnnnn.nn

User 42

Double

NT_USER43

User 43

nnnnnnnn.nn

User 43

Double

NT_USER44

User 44

nnnnnnnn.nn

User 44

Double

NT_USER45

User 45

nnnnnnnn.nn

User 45

Double

NT_USER46

User 46

mm/dd/yyyy

User 46

Date/Time

NT_USER47

User 47

mm/dd/yyyy

User 47

Date/Time

NT_USER48

User 48

mm/dd/yyyy

User 48

Date/Time

NT_USER49

User 49

mm/dd/yyyy

User 49

Date/Time

NT_USER50

User 50

mm/dd/yyyy

User 50

Date/Time

NT_USER51CD

User 51

10x

User 51

String

NT_USER51TY

User 51 Text

60x

User 51 Text

String

NT_USER52CD

User 52

10x

User 52

String

NT_USER52TY

User 52 Text

60x

User 52 Text

String

NT_USER53CD

User 53

10x

User 53

String

NT_USER53TY

User 53 Text

60x

User 53 Text

String

NT_USER54CD

User 54

10x

User 54

String

NT_USER54TY

User 54 Text

60x

User 54 Text

String

NT_USER55CD

User 55

10x

User 55

String

NT_USER55TY

User 55 Text

60x

User 55 Text

String

NT_USFLWNO

US TV Flow Total

nnnn.nnn

Upstream Remaining Flow Number

Double

NT_USFLWRT

US Flow Rating

nnnnn.n

Upstream Remaining Flow Rating

Double

NT_USID

US Struc Rec #

 

US Link to SWNETMH.MA_MHID

Long Integer

NT_USINVO

Record US Invert

nnnn.nn

Record US Invert

Double

NT_USLCLN

US Lamp Clean #

nnnn.nnn

Upstream Cleaning No

Double

NT_USLFLW

US Lamp Flow #

nnnn.nnn

Upstream Infiltration Value

Double

NT_USLMPDT

US Lamping Date

mm/dd/yyyy

Upstream Lamping Date

Date/Time

NT_USLSTR

US Lamp Struc #

nnnn.nnn

Upstream Structural No

Double

NT_USMAN

US Structure

25x

Upstream Manhole Number

Text

NT_USMAXFT

US Max Dist

nnnn.n

Upstream Max Distance

Double

NT_USMAXOB

US Max Obs

nnnn

Upstream Max Observations

Integer

NT_USPADT

US Last PACP Date

mm/dd/yyyy

Upstream TV Date

Date/Time

NT_USPROM

US Pipe O&&M

nnn.n

US PACP Pipe Ratings O&M

Double

NT_USPRS

US Pipe Structural

nnn.n

US PACP Pipe Ratings Structural

Double

NT_USPRT

US Pipe Total

nnn.n

US PACP Pipe Ratings Total

Double

NT_USQROM

US Quick O&&M

30x

US PACP Quick Rating O&M

Text

NT_USQRS

US Quick Structural

30x

US PACP Quick Rating Structural

Text

NT_USQRT

US Quick Total

30x

US PACP Quick Rating Total

Text

NT_USRIMO

Record US Rim

nnnn.nn

Record US Rim

Double

NT_USSTRNO

US TV Struct Total #

nnnn

Upstream Remaining Structural Number

Integer

NT_USSTRRT

US Struct Rating

nnnnn.n

Upstream Remaining Structural Ratings

Double

NT_USTVDT

US Last TV Date

mm/dd/yyyy

Upstream TV Date

Date/Time

NT_USVEL

US Velocity

nnn.nn

Upstream Velocity

Double

NT_WIDTH

Pipe Width (in)

nnnn

Pipe Width (in)

Double

NT_WO_COMM

Short Comment

255x

This short comment gets copied to work orders

Text

NT_X

X Coordinate

nnnnnnnn.nn

X Coordinate

Double

NT_Y

Y Coordinate

nnnnnnnn.nn

Y Coordinate

Double