|
Object
Type
|
Table
|
|
Datasource
|
IPMA
|
|
Database
|
icsa
|
Contains general references and information related to Calibration
Observations (Calibration Observations Documentation) for the four ISO
instruments (CAM, LWS, PHT and SWS).
The POF- and ICS blocks are extracted from the uplink
MDB, aot_pof and aot_ics tables.
Use and Related
Data
This information is available on observation basis, for CUS
observations only.
Population
The table is populated by the script caldetails.csh.
The tables are populated with bcp character dump files
of the uplink MDB
database tables aot_ics and aot_pof.
The script can take one or more of the following arguments:
no args:
This assumes that the table has been created in the database
icsa, and that any temporary tables needed have been built and populated
with the necessary data.
-build:
Forces the building of the table in the icsa database
-build_all:
Forces the building and population of all temporary tables
needed.
-compress:
Is used to indicate that the datafiles have been compressed
with the UNIX utility 'compress'. The data files will be re-compressed
after use.
-nodrop:
Indicates that temporary tables should not be dropped
after use.
| Name |
Datatype |
Null |
| |
| obsno |
int |
No |
|
|
| pof |
text |
Yes |
|
|
| ics |
text |
Yes |
|
|
column ics
ICS block extracted from the uplink MDB aot_ics table.Pseudo-ics
block for CUS observations.
column obsno
Observation number constructed as follows:
revolution number * 1000000 + target number * 1000 +
observation sequence number * 10 + type.
Please see SCREW 385 for further details.
column pof
POF block extracted from the uplink MDB aot_pof table.
Pseudo-pof block for CUS observations.
|
Table
Usage (MB)
|
Distribution
of Table Space
|
|
Data
|
0.22
|
Data
|
0.52
%
|
|
Indexes
|
41.30
|
Indexes
|
99.40
%
|
|
Unused
|
0.03
|
Unused
|
0.08
%
|
|
Total
|
41.55
|
Number
of Rows
|
4708
|
| Object Name |
Object Type |
| dbo.caldetails.caldetails_pk |
INDEX |
CREATE TABLE dbo.caldetails
(
obsno int NOT NULL,
pof text NULL,
ics text NULL
)
LOCK ALLPAGES
go