`spectral` DataBase Overview

XRCF Logs
Time Averaged XRCF Logs
XSS logs
Time Averaged XSS Logs
XSPEC Model Defaults
HXDS Data File Headers
HXDS Reduced Data by XSPEC Model
Miscellaneous Tables

XRCF Logs

Table	Description
aperlog	Aperture logs from the XRCF. Contains detector and aperture info indexed by time.
coordlog	Coord logs from the XRCF. Contains testname and status info indexed by time and runid.
gatlog	Gas and temperature log from the XRCF. Contains pressure and temperture info indexed by time.
hsalog	HXDS shutter assembly log from the XRCF. Contains shutter commands and their results index by time.
ratelog	Detector rate info collected at the XRCF. It is indexed by time.
stglog	Stage logs from the XRCF. Contains stage info, indexed by time and runid.

Time Averaged XRCF Logs

Table	Description
fltchm_avgdev	Filter chamber logs from the XSS at the XRCF. Contains filter thickness and position info indexed by time and runid, detector, iteration.
gat_avgdev	Gat logs from the XRCF. Contains detector tempertures and pressure info indexed by time and runid, detector, iteration.
pcgas_avgdev	Gas temperature and pressure logs from the XSS at XRCF for the FPC5. Contains pressure and temperture info indexed by time and runid, detector, iteration.

XSS logs

Table	Description
xsslog_dcm
xsslog_fltchm
xsslog_fpc
xsslog_hirefs
xsslog_ics1
xsslog_ics2
xsslog_ics3
xsslog_offln
xsslog_onln
xsslog_pcgas
xsslog_pntsrc
xsslog_vgc1
xsslog_vgc2
xsslog_vgc3
xsslog_vgc4

Time Averaged XSS Logs

Table	Description
pntsrc_avgdev	Point source beam currents, voltages, and bias info from the XSS at XRCF index by time and runid, detector, iteration.

XSPEC Model Defaults

Table	Description
dflt_constant	Default values for the XSPEC constant model.
dflt_filter	Default values for the XSPEC filter model.
dflt_gaussian	Default values for the XSPEC gaussian model.
dflt_jmkmod	Default values for the XSPEC jmkmod model.
dflt_jmkmod16	Default values for the XSPEC jmkmod16 model.
dflt_jmkmod4	Default values for the XSPEC jmkmod4 model.
dflt_jmkmod8	Default values for the XSPEC jmkmod8 model.
dflt_jmkramer	Default values for the XSPEC jmkramer model.
dflt_jmmodel	Default values for the XSPEC jmmodel model.
dflt_jmmodel0	Default values for the XSPEC jmmodel0 model.
dflt_kram	Default values for the XSPEC kram model.
dflt_powerlaw	Default values for the XSPEC powerlaw model.

HXDS Data File Headers

Table	Description
hsihdr	FITS header of HSI images parsed by keywords. Contains everything a FITS header contains and is index by runid and iteration.
phahdr	PHA header parsed out line by line. Contains software version, shutter configuration, livetime and other info indexed by time and runid, detector, iteration.
sumhdr	The PHA sum files' headers. Contains everything a sum file header contains.

HXDS Reduced Data by XSPEC Model

Table	Description
xp_gaussian	Fit parameters from XSPEC gaussian model. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_gaussian_in	Fit parameters from XSPEC gaussian model. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_general	General info from XSPEC fits. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_jmkmod	Fit parameters from XSPEC jmkmod model. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_jmkmod4	Fit parameters from XSPEC jmkmod4 model. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_jmkmod4_in	Fit parameters from XSPEC jmkmod4 model. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_jmkmod8	Fit parameters from XSPEC jmkmod8 model. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_jmkmod8_in	Fit parameters from XSPEC jmkmod8 model. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_jmkmod_in	Fit parameters from XSPEC jmkmod model. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_powerlaw	Fit parameters from XSPEC powerlaw model. Contains one line per PHA file, indexed by runid, detector, and iteration.
xp_powerlaw_in	Fit parameters from XSPEC powerlaw model. Contains one line per PHA file, indexed by runid, detector, and iteration.

Miscellaneous Tables

Table	Description
as_run_cmdb	The as run CMDB. Contains corrections the the req run to reflect how the tests were actually run. From /proj/asc/cal/DRAFT_as_run.cmdb April 28, 1999.
as_meas_cmdb	The as measured CMDB. Measured quantities are used to update some fields in the as run CMDB.
pitch_yaw	A table of pitch and yaw values for all phases at XRCF.
pitch_yaw_phase1	A table of pitch and yaw values for phase 1 at XRCF.
pitch_yaw_phase2	A table of pitch and yaw values for phase 2 at XRCF.
rdistartstop	A mapping of start and stop times to runid, detector, and iteration.
req_run_cmdb	The req run CMDB. Contains everything the CMDB contained in its finally state.
runidstartstop	A mapping of start and stop times to runids.
tl_all	Project Science Timeline for all XRCF phases
tl_phase1	Project Science Timeline for XRCF Phase 1
tl_phase2_1	Project Science Timeline for XRCF Phase 2 Part 1 (ACIS2C)
tl_phase2_2	Project Science Timeline for XRCF Phase 2 Part 1 (HRC)
tl_phase2_3	Project Science Timeline for XRCF Phase 2 Part 1 (ACIS)
trwid_ri	A mapping of TRW ID to runid and iteration. There may be more than one row per trwid.
trwid_runid	A mapping of TRW ID to runid. There may be more than one runid per trwid.
trwid_shutters_meas	A mapping of TRW ID to as-measured shutter configuration. There may be more than one shutter configuration per TRW ID
trwid_startstop	A mapping of TRW ID to start, stop, and abort times.