Structure Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
SC_ADJ_CD |
Street Adjacency |
nnn |
Street Adjacency |
Integer |
SC_ADJ_TY |
Street Adjacency Txt |
25x |
Street Adjacency Text |
Text |
SC_AREA |
Square Footage |
nnnn.nn |
Square Footage |
Double |
SC_AUTO |
Struct Rec ID |
nnnnnnnn |
Internal Struct ID |
Long Integer |
SC_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
SC_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
SC_BEG_X |
Beginning X Coord |
-nnnnnnnnn.nn |
Beginning X Coordinate |
Double |
SC_BEG_Y |
Beginning Y Coord |
-nnnnnnnnn.nn |
Beginning Y Coordinate |
Double |
SC_BEG_Z |
Beginning Z Coord |
-nnnnnnnnn.nn |
Beginning Z Coordinate |
Double |
SC_BRP |
Beginning Reference Post |
nnnnnnnn.nn |
Beginning Reference Post |
Double |
SC_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
SC_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
SC_CBS |
Current Beginning Stationing |
nnnnnnnn.nn |
Current Beginning Stationing |
Double |
SC_CES |
Current Ending Stationing |
nnnnnnnn.nn |
Current Ending Stationing |
Double |
SC_CGC_CD |
Channel General Cond |
1x |
Channel & Channel Protection General Condition |
Text |
SC_CGC_TY |
Channel General Cond Text |
30x |
Channel & Channel Protection General Condition Text |
Text |
SC_CINSP_DT |
Date Inspected |
mm/dd/yyyy |
Date Inspected |
Date/Time |
SC_CNXT_DT |
Next Inspection |
mm/dd/yyyy |
Next Inspection |
Date/Time |
SC_COF |
Consequence of Failure |
nnnn. |
Consequence of Failure |
Double |
SC_COLOR_C |
Color |
nnn |
Color |
Integer |
SC_COLOR_T |
Color Text |
25x |
Color Text |
Text |
SC_COM_ID |
Structure ID |
15x |
Structure ID |
Text |
SC_COMM |
Comments |
|
Comments |
Long Integer |
SC_COND_CD |
Condition |
nnn |
Condition |
Integer |
SC_COND_TY |
Condition Text |
25x |
Condition Text |
Text |
SC_CONS_DT |
Construction Date |
mm/dd/yyyy |
Construction Date |
Date/Time |
SC_COV_DEP |
Cover Depth |
nnn.nn |
Cover Depth |
Double |
SC_CRT_BY |
Created By |
25x |
Created By |
Text |
SC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
SC_CULGC_CD |
Culvert General Cond |
1x |
Culvert & Retaining Walls General Condition |
Text |
SC_CULGC_TY |
Culvert General Cond Text |
30x |
Culvert & Retaining Walls General Condition Text |
Text |
SC_DIAM |
Diameter |
nnn.n |
Diameter |
Double |
SC_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
SC_END_X |
Ending X Coord |
-nnnnnnnnn.nn |
Ending X Coordinate |
Double |
SC_END_Y |
Ending Y Coord |
-nnnnnnnnn.nn |
Ending Y Coordinate |
Double |
SC_END_Z |
Ending Z Coord |
-nnnnnnnnn.nn |
Ending Z Coordinate |
Double |
SC_ERP |
Ending Reference Post |
nnnnnnnn.nn |
Ending Reference Post |
Double |
SC_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
SC_FINANCE |
Finance Codes |
20x |
Finance Codes |
Text |
SC_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
SC_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
SC_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
SC_IMG_FLG |
|
|
Image Available |
Boolean |
SC_INMAP |
In Map? |
|
|
Boolean |
SC_INSP_DT |
Inspection Date |
mm/dd/yyyy |
Inspection Date |
Date/Time |
SC_KIND_CD |
Type |
nnn |
Type |
Integer |
SC_KIND_TY |
Type Text |
25x |
Type Text |
Text |
SC_LEGEND |
Legend |
20x |
Legend |
Text |
SC_LENGTH |
Length |
nnnnn.n |
Length |
Double |
SC_LIFE |
Life Expectancy |
nnn |
Life Expectancy |
Integer |
SC_LOC |
General Location |
100x |
General Location |
Text |
SC_LOD_RAT |
Load Limit (Tons) |
nnn |
Load Limit (Tons) |
Integer |
SC_MAK_PRS |
Object Markers |
|
Object Markers |
Boolean |
SC_MAPID |
Map Reference ID |
20x |
Map Reference ID |
Text |
SC_MAT_CD |
Material |
nnn |
Material |
Integer |
SC_MAT_TY |
Material Text |
25x |
Material Text |
Text |
SC_MITIGAT |
Mitigation |
nnnnnnnn.nn |
Mitigation |
Double |
SC_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
SC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
SC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
SC_MOV_FLG |
|
|
Movie Available |
Boolean |
SC_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
SC_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
SC_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
SC_OBS |
Original Beginning Stationing |
nnnnnnnn.nn |
Original Beginning Stationing |
Double |
SC_OES |
Original Ending Stationing |
nnnnnnnn.nn |
Original Ending Stationing |
Double |
SC_OWN_CD |
Ownership |
nnn |
Ownership |
Integer |
SC_OWN_TY |
Ownership Text |
25x |
Ownership Text |
Text |
SC_POF |
Probability of Failure |
nnn.nn |
Probability of Failure |
Double |
SC_POSTED |
Load Limit Posted |
|
Load Limit Posted |
Boolean |
SC_PVALUE |
Present Value |
nnnnnnnnn.nn |
Present Value |
Double |
SC_RCOST |
Replacement Cost |
nnnnn.nn |
Replacement Cost |
Double |
SC_REFR_CD |
Refresh Freq |
nnn |
Refresh Frequency |
Integer |
SC_REFR_TY |
Refresh Freq Text |
25x |
Refresh Frequency Text |
Text |
SC_REPL_DT |
Replacement Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
SC_RGC_CD |
Roadway General Cond |
1x |
Roadway General Condition |
Text |
SC_RGC_TY |
Roadway General Cond Text |
30x |
Roadway General Condition Text |
Text |
SC_RH_ID |
Road Rec # |
nnnnnnnn |
Long Integer |
|
SC_RISK |
Risk |
nnnn. |
Risk - COF * POF |
Double |
SC_RLIFE |
Remaining Life |
nnnn.nn |
Remaining Life |
Double |
SC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
SC_RVALUE |
Replacement Value |
nnnnnnnnn.nn |
Replacement Value |
Double |
SC_STAT_CD |
Status |
nnn |
Status |
Integer |
SC_STAT_TY |
Status Text |
25x |
Status Text |
Text |
SC_STYPE_CD |
GIS Sub Type |
nnn |
Sub-Type |
Integer |
SC_STYPE_TY |
GIS Sub Type |
25x |
Sub-Type Text |
Text |
SC_SUF_RAT |
Sufficiency Rating |
nnn.n |
Sufficiency Rating |
Double |
SC_TRET_CD |
End Treatment |
nnn |
End Treatment |
Integer |
SC_TRET_TY |
End Treatment Text |
25x |
End Treatment Text |
Text |
SC_TYPE_CD |
Structure Type |
nnn |
Structure Type |
Integer |
SC_TYPE_TY |
Structure Type Text |
25x |
Structure Type Text |
Text |
SC_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
SC_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
SC_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
SC_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
SC_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
SC_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
SC_USER4 |
User 4 |
nnnnnnnnn.nn |
User 4 |
Double |
SC_USER5 |
User 5 |
30x |
User 5 |
Text |
SC_USER6 |
User 6 |
|
User 6 |
Boolean |
SC_USER7 |
User 7 |
|
User 7 |
Boolean |
SC_USER8 |
User 8 |
|
User 8 |
Boolean |
SC_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
SC_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
SC_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
SC_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
SC_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
SC_USER14 |
User 14 |
30x |
User 14 |
Text |
SC_USER15 |
User 15 |
30x |
User 15 |
Text |
SC_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
SC_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
SC_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
SC_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
SC_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
SC_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
SC_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
SC_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
SC_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
SC_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
SC_USER21 |
User 21 |
50x |
User 21 |
String |
SC_USER22 |
User 22 |
50x |
User 22 |
String |
SC_USER23 |
User 23 |
50x |
User 23 |
String |
SC_USER24 |
User 24 |
50x |
User 24 |
String |
SC_USER25 |
User 25 |
50x |
User 25 |
String |
SC_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
SC_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
SC_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
SC_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
SC_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
SC_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
SC_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
SC_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
SC_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
SC_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
SC_USER36 |
User 36 |
|
User 36 |
Boolean |
SC_USER37 |
User 37 |
|
User 37 |
Boolean |
SC_USER38 |
User 38 |
|
User 38 |
Boolean |
SC_USER39 |
User 39 |
|
User 39 |
Boolean |
SC_USER40 |
User 40 |
|
User 40 |
Boolean |
SC_VALUE |
Dollar Value |
nnnnnnnnn.nn |
Dollar Value |
Double |
SC_WIDTH |
Width |
nnn.n |
Width |
Double |
SC_WO_COMM |
WO Comment |
255x |
This short comment gets copied to work orders |
Text |