Table Name: MASTER
No. |
Column Name |
Type |
Unit |
Description |
1 |
NAME |
varchar(50) |
|
Designation of the Pointed Source Target name. FITS keyword OBJECT. |
2 |
RA |
double |
degree |
Right Ascension (Pointing Position) RA (J2000) of the satellite pointing position (FITS keyword RA_NOM). |
3 |
DEC |
double |
degree |
Declination (Pointing Position) DEC (J2000) of the satellite pointing position (FITS keyword DEC_NOM). |
4 |
LII |
double |
degree |
Galactic Longitude (Pointing Position) Calculated from (RA, DEC) |
5 |
BII |
double |
degree |
Galactic Latitude (Pointing Position) Calculated from (RA, DEC). |
6 |
ROLL_ANGLE |
double |
degree |
Roll Angle (degrees) FITS keyword PA_NOM. |
7 |
TIME |
double |
mjd |
Start Time of the Observation In UTC. FITS keyword DATE-OBS. |
8 |
STOP_TIME |
double |
mjd |
Stop Time of the Observation In UTC. FITS keyword DATE-END. |
9 |
OBSID |
varchar(11) |
|
Unique Observation/Sequence Number 9-digit numeral. FITS keyword OBS_ID. |
10 |
EXPOSURE |
double |
s |
Effective Total Observation Exposure (s) Shortest exposure of the XIS sensors which are operated normally. The exposure is calculated as the sum of GTIs of all the cleaned event files for a given sensor (including different observation modes), and the deadtime is not taken into account. |
11 |
TIME_AWARDED |
double |
s |
Awarded Exposure Time (s) |
12 |
XIS0_EXPO |
double |
s |
XIS0 Effective Exposure on Source (s) |
13 |
XIS1_EXPO |
double |
s |
XIS1 Effective Exposure on Source (s) |
14 |
XIS2_EXPO |
double |
s |
XIS2 Effective Exposure on Source (s) |
15 |
XIS3_EXPO |
double |
s |
XIS3 Effective Exposure on Source (s) |
16 |
XIS0_NUM_MODES |
smallint(6) |
|
Number of XIS0 Modes |
17 |
XIS1_NUM_MODES |
smallint(6) |
|
Number of XIS1 Modes |
18 |
XIS2_NUM_MODES |
smallint(6) |
|
Number of XIS2 Modes |
19 |
XIS3_NUM_MODES |
smallint(6) |
|
Number of XIS3 Modes |
20 |
HXD_NUM_MODES |
smallint(6) |
|
Number of HXD Modes |
21 |
HXD_EXPO_CO |
double |
s |
HXD Coarse Clock Rate Effective Exposure on Source (s) |
22 |
HXD_EXPO_FI |
double |
s |
HXD Fast Clock Rate Effective Exposure on Source (s) |
23 |
HXD_EXPO_NO |
double |
s |
HXD Normal Clock Rate Effective Exposure on Source (s) |
24 |
HXD_EXPO |
double |
s |
HXD All Clock Rate Effective Exposure on Source (s) |
25 |
HXD_EXPO_WAM |
double |
s |
HXD WAM Effective Exposure on Source (s) |
26 |
HXD_BURSTS |
smallint(6) |
|
Number of HXD Bursts |
27 |
PROCESSING_STATUS |
varchar(24) |
|
Processing Status |
28 |
PROCESSING_DATE |
double |
mjd |
Date of Processing |
29 |
PUBLIC_DATE |
double |
mjd |
Public Date Date when the data becomes public. |
30 |
DISTRIBUTION_DATE |
double |
mjd |
First Distribution Date Date when the data were first distributed to the user. This field will never be changed even if the data are processed more than once. |
31 |
PROCESSING_VERSION |
varchar(15) |
|
Version of Processing Script Taken from the FITS PROCVER keyword. |
32 |
NUM_PROCESSED |
smallint(6) |
|
Number of Times Sequence Has Been Processed Taken from the FITS SEQPNIM keyword. |
33 |
SOFTWARE_VERSION |
varchar(80) |
|
Software Version Used in the Pipeline Taken from the FITS SOFTVER keyword. |
34 |
PRNB |
varchar(8) |
|
Proposal Number |
35 |
ABSTRACT |
text |
|
Proposal Abstract |
36 |
SUBJECT_CATEGORY |
varchar(60) |
|
Proposal Category |
37 |
CATEGORY_CODE |
smallint(6) |
|
Proposal Category Code |
38 |
PRIORITY |
varchar(5) |
|
Proposal Priority |
39 |
PI_LNAME |
varchar(30) |
|
Proposal Principal Investigator Last Name |
40 |
PI_FNAME |
varchar(30) |
|
Proposal Principal Investigator First Name |
41 |
COPI_LNAME |
varchar(30) |
|
Proposal Co-PI Last Name |
42 |
COPI_FNAME |
varchar(30) |
|
Proposal Co-PI First Name |
43 |
COUNTRY |
varchar(30) |
|
Country of Proposal Principal Investigator or Collaboration |
44 |
CYCLE |
tinyint(4) |
|
Proposal Cycle Number |
45 |
OBS_TYPE |
varchar(10) |
|
Observation Type (e.g., TOO) |
46 |
TITLE |
varchar(120) |
|
Proposal Title |
47 |
AIMPOINT |
char(3) |
|
Indicates Nominal Pointing Was with XIS or HXD |
48 |
INJECTION |
char(1) |
|
Flag Indicates Observation Was Carried Out with XIS Charge Injection |
Table Name: XISLOG
No. |
Column Name |
Type |
Unit |
Description |
1 |
NAME |
varchar(50) |
|
Designation of the Pointed Source |
2 |
RA |
double |
degree |
Right Ascension (Pointing Position) |
3 |
DEC |
double |
degree |
Declination (Pointing Position) |
4 |
LII |
double |
degree |
Galactic Longitude (Pointing Position) |
5 |
BII |
double |
degree |
Galactic Latitude (Pointing Position) |
6 |
ROLL_ANGLE |
double |
degree |
Roll Angle (degrees) |
7 |
TIME |
double |
mjd |
Start Time of the Observation |
8 |
STOP_TIME |
double |
mjd |
Stop Time of the Observation |
9 |
OBSID |
varchar(11) |
|
Unique Observation/Sequence Number |
10 |
EXPOSURE |
double |
s |
Effective Total Observation Exposure (s) |
11 |
INTEGRATION_TIME |
double |
s |
Integration Time (s) |
12 |
XIS |
varchar(4) |
|
Indicates the Active XIS Unit in Use |
13 |
DATAMODE |
varchar(10) |
|
Indicates the Data Mode in Use |
14 |
EDITMODE |
varchar(8) |
|
Indicates the Edit Mode in Use: 2x2, 3x3, or 5x5 |
15 |
MICROCODE |
varchar(4) |
|
Indicates the Code Assigned to Each Datamode |
16 |
CLK_MODE |
varchar(10) |
|
Indicates the Clock Mode in Use |
17 |
WINDOW_OPTION |
int(11) |
|
Indicates the Window Option in Use: 0 |
18 |
WINDOW_START |
int(11) |
|
Start Address of the Window |
19 |
WINDOW_SIZE |
int(11) |
|
Size of the Window |
20 |
PSUM_LINE |
int(11) |
|
Number of Lines That Are Summed When the Psum Clock Is in Use |
21 |
AREA_HSTART |
varchar(20) |
|
Start Address of the Horizontal Area Discriminator |
22 |
AREA_HSTOP |
varchar(20) |
|
Stop Address of the Horizontal Area Discriminator |
23 |
AREA_VSTART |
varchar(20) |
|
Start Address of the Vertical Area Discriminator |
24 |
AREA_VSTOP |
varchar(20) |
|
Stop Address of the Vertical Area Discriminator |
25 |
DISCR_TYPE |
varchar(10) |
|
Indicates the Type of Discriminator: 0 |
26 |
GRADE_TELM |
varchar(10) |
|
Indicates the On-Board Grade Telemetry Present: 0 |
27 |
EVTTHRE_LOW |
varchar(30) |
|
Event Discriminator Lower Bound |
28 |
EVTTHRE_UP |
varchar(30) |
|
Event Discriminator Upper Bound |
29 |
AREA_DISCR |
varchar(10) |
|
Flag Indicates Area Discriminator Enabled |
30 |
GRADE_DISCR |
varchar(10) |
|
Flag Indicates Grade Discriminator Enabled |
31 |
CONF_TYPE |
char(2) |
|
Configuration of the Area and Grade Discriminators and Event Threshold |
32 |
FILENAME |
varchar(40) |
|
XIS File Containing the Data with the Configuration Setting Described |
33 |
PROCESSING_DATE |
double |
mjd |
Date of Processing |
34 |
PROCESSING_VERSION |
varchar(15) |
|
Version of Processing Script |
35 |
NUM_PROCESSED |
smallint(6) |
|
Number of Times Sequence Has Been Processed |
36 |
INJECTION |
char(1) |
|
Flag Indicates Observation Was Carried Out with XIS Charge Injection |
Table Name: LOG
No. |
Column Name |
Type |
Unit |
Description |
1 |
SEQ_NO |
varchar(9) |
|
Unique Observation/Sequence Number. This is the primary key. |
2 |
TARGET |
varchar(32) |
|
The target name, basically given by the PI. |
3 |
RA_PLAN |
float(7,4) |
degree |
Right ascension of the pointing position used in operation (J2000.0). |
4 |
DEC_PLAN |
float(7,4) |
degree |
Declination of the pointing position used in operation (J2000.0). |
5 |
MNV_START |
datetime |
|
The date and time of the maneuver start. |
6 |
NEXT_MNV_START |
datetime |
|
The date and time of the maneuver start for the NEXT target. |
7 |
EULER_1 |
float(7,4) |
degree |
The first euler angle (defined in ZYZ) of the satellite. |
8 |
EULER_2 |
float(7,4) |
degree |
The second euler angle (defined in ZYZ) of the satellite. |
9 |
EULER_3 |
float(7,4) |
degree |
The third euler angle (defined in ZYZ) of the satellite. |
10 |
REMARKS |
text |
|
remarks of the satellite/instruments operation, if any. |