Table Name:	asaf_result
Table Number:	271
Group:	Info Retrieval
Description:	Stores the result of the service interuption report. Reserved; option
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_asaf_result

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
after_hour_min	LONG	int				DIRECT	Number of available after hours uptime minutes. Reserved; option
asaf_ratio	FLOAT	real					Calculated as <avail_min; scheduled_down_time> / avail_min. Reserved; option
avail_min	LONG	int				DIRECT	Number of potential uptime minutes. Reserved; option
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
end_time	CLK_TIME	datetime	30				End time for the report results. Reserved; option
is_current	LONG	int				DIRECT	Because asaf_results objects are recycled, must mark the current object. This indicates the current object. Reserved; option
objid	LONG	int	3			DIRECT	Internal record number. Reserved; option	Search (1)
period_number	LONG	int				DIRECT	Period report is in; e.g., monthly, quarterly. Reserved; option
sched_down_min	LONG	int				DIRECT	Amount of scheduled downtime. Reserved; option
sort_order	LONG	int				DIRECT	Order in which the report data is sorted. Reserved; option
start_time	CLK_TIME	datetime	29				Start time for the report results. Reserved; option
unsched_down_min	LONG	int				DIRECT	Amount of unscheduled downtime. Reserved; option

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
asaf_result2site	OTOP	site	site2asaf_result	Site for which the report was run. Reserved; option			Search (1)
asaf_result2user	MTO	user	user2asaf_result	User that ran the report. Reserved; option			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
297	asaf_user_site	asaf_result, site, user

My Recent Objects

asaf_result

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user