STAGATE

ITS AutoGate Inventory

Field Name	Caption	Mask	Description	Field Type
AG_AACCOUNT	Asset Account #	45x	Asset Account #	Text
AG_APNUMACT	Asset Proj No - Acct	40x	Asset Proj No - Acct	Text
AG_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
AG_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
AG_BR_CD	Default Category Code	10x	Default Category Code	String
AG_BR_TY	Default Category Text	60x	Default Category Text	String
AG_CB_ID	Link to Street Cabinet	nnnnnnnn	Link to STCABINET	Long Integer
AG_CM_ID	Link to Controller	nnnnnnnn	Link to STCNTRLINV	Long Integer
AG_CO_ID	Communication Rec #	nnnnnnnn	Link to STCOM.CO_ID	Long Integer
AG_COMMENT1	Long Note		Long Note	Memo
AG_CRT_BY	Created By	25x	Created By	String
AG_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
AG_CS	Current Station	nnnnnnnn.nn	Current Station	Double
AG_DE_ID	Communication Device Rec #	nnnnnnnn	Link to STCOMD.DE_ID	Long Integer
AG_DEPL_DT	Deployed Date	mm/dd/yyyy hh:mm am	Deployed Date	DateTime
AG_DIR_CD	Direction	nnn	Direction	Integer
AG_DIR_TY	Direction Text	25x	Direction Text	String
AG_DIST_CD	District	nnn	District	Integer
AG_DIST_TY	District Text	50x	District Text	String
AG_DOC_FLG	Document Available		Document Available	Boolean
AG_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
AG_GE_ID	Link to Equipment	nnnnnnnn	Link to EFEQUIP.GE_ID	Long Integer
AG_GISNEED_CD	Needs GIS	nnn	Needs GIS	Integer
AG_GISNEED_TY	Needs GIS Text	100x	Needs GIS Text	Text
AG_ID	AutoGate Record Number	nnnnnnnn	Auto ID	Long Integer
AG_INITCST	Initial Cost	nnnnnnnn.nn	Initial Cost	Double
AG_INMAP	In Map Flag		In Map Flag	Boolean
AG_INST_BY	Installed By	30x	Installed By	String
AG_INST_DT	Installation Date	mm/dd/yyyy hh:mm am	Installation Date	DateTime
AG_INT_ID	Link to Intersections	nnnnnnnn	Link to INTNET.INT_ID	Long Integer
AG_INTERC	Interchange	30x	Interchange	String
AG_LATLONG_X	Latlong X	nnnnnnnn.nn	Latlong X	Double
AG_LATLONG_Y	Latlong Y	nnnnnnnn.nn	Latlong Y	Double
AG_LOCAT	Location	100x	Location	String
AG_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
AG_MA_ID	Link to Mast arm	nnnnnnnn	Link to STMARM.MA_ID	Long Integer
AG_MAN_CD	Manufacturer	nnn	Manufacturer	Integer
AG_MAN_TY	Manufacturer Text	25x	Manufacturer Text	String
AG_MOD_BY	Last Modified By	25x	Last Modified By	String
AG_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
AG_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
AG_MODELNO	Model Number	30x	Model Number	String
AG_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
AG_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
AG_NOTES	Notes	255x	Notes	String
AG_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
AG_NUMBER	AutoGate ID	50x	AutoGate ID	String
AG_OS	Orginal Station	nnnnnnnn.nn	Orginal Station	Double
AG_OWN_CD	Owner	nnn	Owner	Integer
AG_OWN_TY	Owner Text	100x	Owner Text	String
AG_PL_ID	Link to Pole	nnnnnnnn	Link to STPOLINV.PL_ID	Long Integer
AG_POS_CD	Position	nnn	Position	Integer
AG_POS_TY	Position Text	25x	Position Text	String
AG_PROJNO	Project Number	30x	Project Number	String
AG_PVALUE	Present Value	nnnnnnnn.nn	Present Value	Double
AG_RAMP	Ramp	30x	Ramp	String
AG_REPL_DT	Replacement Date	mm/dd/yyyy hh:mm am	Replacement Date	DateTime
AG_RH_ID	Road Rec #	nnnnnnnn	Link to STRDROAD.RH_ID	Long Integer
AG_RLIFE	Remaining Life	nnnnnnnn.nn	Remaining Life	Double
AG_ROUTE	Route	30x	Route	String
AG_ROWVER	Rowversion for optimistic locking		Rowversion for optimistic locking	TimeStamp
AG_RP	Ref Post	nnnnnnnn.nn	Ref Post	Double
AG_RPM	Reference Post	nnnnnnnn.nn	Reference Post	Double
AG_RVALUE	Replacement Value	nnnnnnnn.nn	Replacement Value	Double
AG_SB_ID	Link to Subsegments	nnnnnnnn	Link to STSUBSEG.SB_ID	Long Integer
AG_SN_ID	Link to Segments	nnnnnnnn	Link to STNET.SN_ID	Long Integer
AG_SP_ID	Link to Supersegments	nnnnnnnn	Link to STSUPER.SP_ID	Long Integer
AG_STAT_CD	Status	nnn	Status	Integer
AG_STAT_TY	Status Text	25x	Status Text	String
AG_STYPE_CD	GIS Sub-Type	nnn	GIS Sub-Type	Integer
AG_STYPE_TY	GIS Sub-Type Text	25x	GIS Sub-Type Text	String
AG_TYPE_CD	Type	nnn	Type	Integer
AG_TYPE_TY	Type Text	25x	Type Text	String
AG_USER1CD	User 1	nnn	User 1	Integer
AG_USER1TY	User 1 Text	25x	User 1 Text	String
AG_USER2CD	User 2	nnn	User 2	Integer
AG_USER2TY	User 2 Text	25x	User 2 Text	String
AG_USER3CD	User 3	nnn	User 3	Integer
AG_USER3TY	User 3 Text	25x	User 3 Text	String
AG_USER4	User 4	50x	User 4	String
AG_USER5	User 5	50x	User 5	String
AG_USER6	User 6	50x	User 6	String
AG_USER7	User 7	nnnnnnnn.nn	User 7	Double
AG_USER8	User 8	nnnnnnnn.nn	User 8	Double
AG_USER9	User 9	nnnnnnnn.nn	User 9	Double
AG_USER10	User 10	mm/dd/yyyy hh:mm am	User 10	DateTime
AG_USER11	User 11	mm/dd/yyyy hh:mm am	User 11	DateTime
AG_USER12	User 12	mm/dd/yyyy hh:mm am	User 12	DateTime
AG_USER13	User 13		User 13	Boolean
AG_USER14	User 14		User 14	Boolean
AG_USER15	User 15		User 15	Boolean
AG_USER16CD	User 16	nnn	User 16	Integer
AG_USER16TY	User 16 Text	50x	User 16 Text	String
AG_USER17CD	User 17	nnn	User 17	Integer
AG_USER17TY	User 17 Text	50x	User 17 Text	String
AG_USER18CD	User 18	nnn	User 18	Integer
AG_USER18TY	User 18 Text	50x	User 18 Text	String
AG_USER19CD	User 19	nnn	User 19	Integer
AG_USER19TY	User 19 Text	50x	User 19 Text	String
AG_USER20CD	User 20	nnn	User 20	Integer
AG_USER20TY	User 20 Text	50x	User 20 Text	String
AG_USER21	User 21	50x	User 21	String
AG_USER22	User 22	50x	User 22	String
AG_USER23	User 23	50x	User 23	String
AG_USER24	User 24	50x	User 24	String
AG_USER25	User 25	50x	User 25	String
AG_USER26	User 26	nnnnnnnn.nn	User 26	Double
AG_USER27	User 27	nnnnnnnn.nn	User 27	Double
AG_USER28	User 28	nnnnnnnn.nn	User 28	Double
AG_USER29	User 29	nnnnnnnn.nn	User 29	Double
AG_USER30	User 30	nnnnnnnn.nn	User 30	Double
AG_USER31	User 31	mm/dd/yyyy hh:mm am	User 31	DateTime
AG_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
AG_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
AG_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
AG_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
AG_USER36	User 36		User 36	Boolean
AG_USER37	User 37		User 37	Boolean
AG_USER38	User 38		User 38	Boolean
AG_USER39	User 39		User 39	Boolean
AG_USER40	User 40		User 40	Boolean
AG_X	X Coordinate	nnnnnnnn.nn	X Coordinate	Double
AG_Y	Y Coordinate	nnnnnnnn.nn	Y Coordinate	Double