Bolt: Details for Table

Table Name:	part_event
Table Number:	423
Group:	Product Mgr
Description:	Reported fault events on installed parts. Reserved; option
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_part_event

Keyboard shortcuts available

Fields:

(double-click a column header to select column text)

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
instance_nm	CHAR	varchar		80			Instance name of the part on which the fault was reported. For network-reported faults, this is the IP address
objid	LONG	int	3			DIRECT	Internal record number
rpt_agent	CHAR	varchar		30			Host ID (SNMP sysObject ID) of the agent software running on the vendor's hardware
rpt_event_gid	LONG	int				DIRECT	Generic trap ID number of the reported fault
rpt_event_sid	LONG	int				DIRECT	Specific trap ID number of the reported fault
rpt_part_nm	CHAR	varchar		255			Selection ID from the network management system's topology datababse
rpt_severity	CHAR	varchar		20			The severity of the fault as reported by the network management system
rpt_time	CLK_TIME	datetime					Fault or event time from network management interface reporting system
snmp_cm_nm	CHAR	varchar		30			This is the SNMP community name that a network management application recognizes when issuing SNMP Set requests to the managed node. It is agent assigned
snmp_mib	CHAR	varchar		30			SNMP Management Information Base object number on which the fault is reported; e.g., 1.3.6.1.2.1.1.2
snmp_nm	CHAR	varchar		30			SNMP reporting source name; e.g., OpenView, HP, RMON, etc

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
part_event2case	MTM	case	case2part_event	Cases opened against the part event		mtm_case54_ part_event0
part_event2site_part	MTO	site_part	site_part2part_event	Installed part to which the fault applies

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
part_event_index	rpt_time:rpt_event_gid:rpt_event_sid:instance_nm:part_event2site_part	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
part_event_index	rpt_time, rpt_event_gid, rpt_event_sid, instance_nm, part_event2site_part	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

part_event

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user