STRDSEG

Road Segment Inventory

Field Name	Caption	Mask	Description	Field Type
RS_AAREA	Additional Area	nnnnnn.nn	Additional Area	Double
RS_ADT	Highest Seg ADT	nnnnnn	Segment ADT	Long Integer
RS_ALTID	Alt Seg ID	20x	Alt Asset ID	Text
RS_AREA	Area	nnnnnn.nn	Area	Double
RS_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
RS_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
RS_BR_CD	Default WO Cat	10x	Default Category Code	Text
RS_BR_TY	Default WO Cat Text	60x	Default Category Text	Text
RS_BRP	Beg Ref Post	nnnnnnnn.nnn	Beginning Reference Post	Double
RS_BXC	Beg X Coord	-nnnnnnnn.nnnn	Beginning X Coordinate	Double
RS_BYC	Beg Y Coord	-nnnnnnnn.nnnn	Beginning Y Coordinate	Double
RS_CBS	Curr Beg Station	nnnnnnnn.nn	Current Beginning Stationing	Double
RS_CES	Curr End Station	nnnnnnnn.nn	Current Ending Stationing	Double
RS_CLAS_CD	Classification	nnn	Classification	Integer
RS_CLAS_TY	Classification Text	25x	Classification Text	Text
RS_COF	Consequence of Failure	nnnn.	Consequence of Failure	Double
RS_COND_CD	Last Condition	nnn	Last Condition	Integer
RS_COND_TY	Last Condition Text	30x	Last Condition Text	Text
RS_CPRIOR	Calculated Priority	nnnnnnn.n	Calculated Priority	Double
RS_CRT_BY	Created By	25x	Created By	Text
RS_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
RS_CUR_PCI	Current PCI	nnn.n	Current PCI	Double
RS_DESC	Description	100x	Description	Text
RS_DIR_CD	Direction	nnn	Direction	Integer
RS_DIR_TY	Direction Text	25x	Direction Text	Text
RS_DIS_CD	District	5x	District	Text
RS_DIS_TY	District Text	50x	District Text	Text
RS_DOC_FLG	Document Available		Doc Available: Doc Flag	Boolean
RS_ERP	End Ref Post	nnnnnnnn.nnn	Ending Reference Post	Double
RS_ESFV	Environ Factor	nnnnn.nn	Environmental Stress Factor	Double
RS_EXC	Ending X Coord	-nnnnnnnn.nnnn	Ending X Coordinate	Double
RS_EYC	Ending Y Coord	-nnnnnnnn.nnnn	Ending Y Coordinate	Double
RS_FISHOUL	From In Shoulder Width	nnnnnnnn.	From Inside Shoulder Width	Double
RS_FOSHOUL	From Out Shoulder Width	nnnnnnnn.	From Outside Shoulder Width	Double
RS_ID	Road Seg Rec ID	nnnnnnnn	Road Seg Rec ID	Long Integer
RS_INMAP	In Map		In Map Flag	Boolean
RS_INSP_DT	Last Date	mm/dd/yyyy	Last Date of Inspection	Date/Time
RS_LANEL	Lane Length	nnnnnnnn.nn	Lane Length	Double
RS_LANES	# of Lanes	nnn	# of Lanes	Integer
RS_LANEW	Lane Width	nnnnnnnn.	Lane Width	Double
RS_LENGTH	Length	nnnnnnnn.nn	Length	Double
RS_LSFV	Load Factor	nnnnn.nn	Load Stress Factor	Double
RS_MEDIAN	Median Width	nnnnnnnn.	Median Width	Double
RS_MITIGAT	Mitigation	nnnnnnnn.nn	Mitigation	Double
RS_MOD_BY	Last Modified By	25x	Last Modified By	Text
RS_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date	Date/Time
RS_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
RS_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
RS_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
RS_NLSFV	Non-Load Factor	nnnnn.nn	Non-Load Stress Factor	Double
RS_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
RS_OBS	Org. Beg Station	nnnnnnnn.nn	Original Beginning Stationing	Double
RS_OES	Org. End Station	nnnnnnnn.nn	Original Ending Stationing	Double
RS_OPCI	Override PCI	nnn.n	Model Override PCI	Double
RS_OPCI_DT	Override PCI Date	mm/dd/yyyy	Override PCI Date	Date/Time
RS_PAVE_CD	Pavement Type	nnn	Pavement Type	Integer
RS_PAVE_TY	Pavement Type Text	25x	Pavement Type Text	Text
RS_PCI	Inspected PCI	nnn.n	Last Inspection PCI	Double
RS_POF	Probability of Failure	nnn.nn	Probability of Failure	Double
RS_PRHB_CD	Planned Next Rehab	nnn	Planned Next Rehab	Integer
RS_PRHB_DT	Planned Maint Date	mm/dd/yyyy	Planned Maint Date	Date/Time
RS_PRHB_TY	Planned Next Rehab Text	30x	Planned Next Rehab Text	Text
RS_PRPATCH	Patching %	nnn.n	Percent Patching	Double
RS_PVALUE	Present Value	nnnnnnnnn.nn	Present Value	Double
RS_RCOST	Replacement Cost	nnnnn.nn	Replacement Cost	Double
RS_REHB_CD	Last Rehab	nnn	Last Rehab	Integer
RS_REHB_DT	Last Maint Date	mm/dd/yyyy	Last Maint Date	Date/Time
RS_REHB_TY	Last Rehab Text	30x	Last Rehab Text	Text
RS_REPL_DT	Replacement Date	mm/dd/yyyy	Replacement Date	Date/Time
RS_RH_ID	Road Rec ID	nnnnnnnn	Link to STRDROAD.RH_ID	Long Integer
RS_RISK	Risk	nnnn.	Risk - COF * POF	Double
RS_RLIFE	Remaining Life	nnnn.nn	Remaining Life	Double
RS_ROW	ROW Width	nnnnnnnn.	ROW Width	Double
RS_ROWVER			Rowversion for optimistic locking	Date/Time
RS_RSFV	Roughness Factor	nnnnn.nn	Roughness Stress Factor	Double
RS_RVALUE	Replacement Value	nnnnnnnnn.nn	Replacement Value	Double
RS_SDIS_CD	SubDistrict	5x	SubDistrict	Text
RS_SDIS_TY	SubDistrict Text	50x	SubDistrict Text	Text
RS_SSFV	Structural Factor	nnnnn.nn	Structural Stress Factor	Double
RS_STAT_CD	Status	nnn	Status	Integer
RS_STAT_TY	Status Text	25x	Status Text	Text
RS_STRE_CD	Pavement Strength	nnn	Pavement Strength	Integer
RS_STRE_TY	Pavement Strength Text	25x	Pavement Strength Type	Text
RS_STYPE_CD	Sub-Type	nnn	Sub-Type	Integer
RS_STYPE_TY	Sub-Type Text	25x	Sub-Type Text	Text
RS_SUPER	Supervisor	60x	Supervisor	Text
RS_T_C_EST	Curb Replace Est	nnnnn.nn	Total Curb Repl. Est.	Double
RS_T_CURB	Curb Length	nnnnn.nn	Total Curbs	Double
RS_T_DW	Driveway Units	nnnnn.nn	Total Driveway	Double
RS_T_DW_E	DW Replace Est	nnnnn.n	Total Driveway Repl Est.	Double
RS_T_PATCH	Total Patching	nnnn.	Total Patching	Double
RS_T_SW	Sidewalk Length	nnnnn.nn	Total Sidewalk	Double
RS_T_SW_E	SW Replace Est	nnnnn.nn	Total Sidewalk Repl. Est.	Double
RS_TAREA	Total Area	nnnnnn.nn	Total Area	Double
RS_TISHOUL	To Inside Shoulder Width	nnnnnnnn.	To Inside Shoulder Width	Double
RS_TOSHOUL	To Outside Shoulder Width	nnnnnnnn.	To Outside Shoulder Width	Double
RS_TRET_CD	Surface Treatment	nnn	Surface Treatment	Integer
RS_TRET_TY	Surface Treatment Text	50x	Surface Treatment Text	Text
RS_TYPE_CD	Type	10x	Type	Text
RS_TYPE_TY	Type Text	60x	Type Text	Text
RS_USER1CD	User 1	nnn	User 1	Integer
RS_USER1TY	User 1 Text	25x	User 1 Text	Text
RS_USER2CD	User 2	nnn	User 2	Integer
RS_USER2TY	User 2 Text	25x	User 2 Text	Text
RS_USER3CD	User 3	nnn	User 3	Integer
RS_USER3TY	User 3 Text	25x	User 3 Text	Text
RS_USER4	User 4	30x	User 4	Text
RS_USER5	User 5	30x	User 5	Text
RS_USER6	User 6	30x	User 6	Text
RS_USER7	User 7	nnnnnnnn.nn	User 7	Double
RS_USER8	User 8	nnnnnnnn.nn	User 8	Double
RS_USER9	User 9	nnnnnnnn.nn	User 9	Double
RS_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
RS_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
RS_USER12	User 12	mm/dd/yyyy	User 12	Date/Time
RS_USER13	User 13		User 13	Boolean
RS_USER14	User 14		User 14	Boolean
RS_USER15	User 15		User 15	Boolean
RS_USER16CD	User 16	nnn	User 16	Integer
RS_USER16TY	User 16 Text	50x	User 16 Text	String
RS_USER17CD	User 17	nnn	User 17	Integer
RS_USER17TY	User 17 Text	50x	User 17 Text	String
RS_USER18CD	User 18	nnn	User 18	Integer
RS_USER18TY	User 18 Text	50x	User 18 Text	String
RS_USER19CD	User 19	nnn	User 19	Integer
RS_USER19TY	User 19 Text	50x	User 19 Text	String
RS_USER20CD	User 20	nnn	User 20	Integer
RS_USER20TY	User 20 Text	50x	User 20 Text	String
RS_USER21	User 21	50x	User 21	String
RS_USER22	User 22	50x	User 22	String
RS_USER23	User 23	50x	User 23	String
RS_USER24	User 24	50x	User 24	String
RS_USER25	User 25	50x	User 25	String
RS_USER26	User 26	nnnnnnnn.nn	User 26	Double
RS_USER27	User 27	nnnnnnnn.nn	User 27	Double
RS_USER28	User 28	nnnnnnnn.nn	User 28	Double
RS_USER29	User 29	nnnnnnnn.nn	User 29	Double
RS_USER30	User 30	nnnnnnnn.nn	User 30	Double
RS_USER31	User 31	mm/dd/yyyy hh:mm am	User 31	DateTime
RS_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
RS_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
RS_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
RS_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
RS_USER36	User 36		User 36	Boolean
RS_USER37	User 37		User 37	Boolean
RS_USER38	User 38		User 38	Boolean
RS_USER39	User 39		User 39	Boolean
RS_USER40	User 40		User 40	Boolean
RS_WIDTH	Width	nnn.	Width	Double
RS_WO_COMM	WO Comment	255x	WO Comment	Text
RS_YARD_CD	Yard	5x	Yard	Text
RS_YARD_TY	Yard Text	50x	Yard Text	Text