Definitions of pi-database flags :

1. GRB tables :

1.     Table Alert fields :
   
   
   • source_id - should be checked in database table alert_source_type
     
     

     DATABASE VALUE	VALUE DESCRIPTION	C++ ENUM NAME
     0	UNKNOWN	eUNKNOWN_SOURCE
     1	HETE	eHETE
     2	INTEGRAL	eINTEGRAL
     3	IPN	eIPN
     4	KONUS	eKONUS
     5	SPIACS	eSPIACS
     6	SWIFT	eSWIFT
     7	SAX	eSAXWFC
     8	ASM	eASM
     9	CGRO/BATSE	eCGRO
     10	RHESSI	eRHESSI

     
     
   • alert_type - type of alert , all allowed values listed in table below, maybe in future they will be put to some table :
     
     

     DATABASE VALUE	VALUE DESCRIPTION	C++ ENUM NAME
     0	UNDEFINED
     1	BATSE ORIGINAL
     2	TEST
     3	IMALIVE
     4	KILL
     11	BATSE_MAXBC
     21	Bradford_TEST
     22	BATSE_FINAL
     24	BATSE_LOCBURST
     25	ALEXIS
     26	RXTE-PCA_ALERT
     27	RXTE-PCA
     28	RXTE-ASM_ALERT
     29	RXTE-ASM
     30	COMPTEL
     31	IPN_RAW
     32	IPN_SEGMENT
     33	SAX-WFC_ALERT
     34	SAX-WFC
     35	SAX-NFI_ALERT
     36	SAX-NFI
     38	spare/unused
     39	IPN_POSITION
     40	HETE_S/C_ALERT
     41	HETE_S/C_UPDATE
     42	HETE_S/C_LAST
     43	HETE_GNDANA
     44	HETE_Test
     45	GRB_CNTRPART
     51	INTEGRAL_POINTDIR
     52	INTEGRAL_SPIACS
     53	INTEGRAL_WAKEUP
     54	INTEGRAL_REFINED
     55	INTEGRAL_OFFLINE

     
     
   • instrument_id - ID of instrument , intruments definitions are stored in setup database table alert_instruments, field values are listed here :
     
     

     DATABASE VALUE	SATELLITE	VALUE DESCRIPTION	C++ ENUM NAME
     100	HETE	WXM	eUNKNOWN_INTRUMENT
     101	HETE	FREGATE	eHETE_WXM
     102	HETE	SXC	eHETE_FREGATE
     201	INTEGRAL	SPIACS	eHETE_SXC
     202	INTEGRAL	IBIS	eSPIACS_INSTRUMENT
     203	INTEGRAL	ISGRI	eINTEGRAL_IBIS
     501	SWIFT	BAT	eINTEGRAL_ISGRI
     502	SWIFT	XRT	eKONUS_INSTRUMENT
     503	SWIFT	UVOT	eSWIFT_BAT_INSTRUMENT
     400	WIND/KONUS	KONUS	eSWIFT_XRT
     900	CGRO	BATSE	eSWIFT_UVOT
     1000	RHESSI

     
     
   • alert_status definitions of values should be used from setup database table alert_status :
     
     
     

     DATABASE VALUE	VALUE DESCRIPTION	C++ ENUM NAME
     0	UNKNOWN	eUNKNOWN_STATUS
     1	PROBABLE GRB	ePROBABLE
     2	DEFINITE GRB	eDEFINITE
     3	TEST	eTEST
     4	NOT GRB	eNOT_GRB
     5	FLARE	eFLARE
     6	SOLAR FLARE	eSOLAR_FLARE
     7	SGR	eSGR
     8	PARTICLE	ePARTICLE
     9	NOISE	eNOISE
     10	CRAB	eCRAB
     11	KNOWN SOURCE	eKNOWN_SOURCE
     12	XRF	eXRF

     
     
   • validity :
     
     

     DATABASE VALUE	VALUE DESCRIPTION	C++ ENUM NAME
     0	UNKNOWN	eValidityUnknown
     1	Possible GRB	ePossibleGRB
     2	Definite GRB	eDefiniteGRB
     3	Short Spike	eShortSpike
     4	Solar Activity	eSolarActivity
     5	Noise	eValNoise