Object Type	Table
Datasource	IPMA
Database	icsa

The columns of this table are derived directly from the cam_cstat table located in the IPA database.

Use and Related Data

None.

Population

This table has been populated during BKRP by db-import.

Columns

Name	Datatype	Null

obsno	int	No

utc_start_1	int	No

utc_start_2	int	No

utc_end_1	int	No

utc_end_2	int	No

csgpukst	int	No

csgpuken	int	No

csgpikst	int	No

csgpiken	int	No

cstadeid	tinyint	No

cstamode	tinyint	No

cstaentw	smallint	No

cstafltw	smallint	No

cstalnsw	smallint	No

cstaselw	smallint	No

cstaread	smallint	No

cstatint	smallint	No

cstaanom	tinyint	No

cstaconf	tinyint	No

cstaprim	tinyint	No

cstavers	smallint	No

cstaproc	smallint	No

cstagain	smallint	No

cstaoffs	smallint	No

cstabflg	smallint	No

cstaacim	smallint	No

cstasaim	smallint	No

cstacvfi	smallint	No

filename	char(12)	No

version	char(4)	No

column csgpiken

ITK end time.

column csgpikst

ITK start time.

column csgpuken

UTK end time.

column csgpukst

UTK start time.

column cstaacim

Number of images accumulated (derived from F2ACCIMA).

column cstaanom

Error code for mode termination.

column cstabflg

Black-body status (derived from F2BBFLAG).

column cstaconf

Configuration number within AOT.

column cstacvfi

CFV increment in motor steps (derived from CVFINCR).

column cstadeid

Detector ID:

column cstaentw

Position of the entrance wheel.

column cstafltw

Position of the filter wheel.

column cstagain

Electronics gain (derived from F2ADCGAI).

column cstalnsw

Position of the lens wheel.

column cstamode

Current mode (1, 2, 3 or 4).

column cstaoffs

Electronics offset (derived from F2ADCOFF).

column cstaprim

CAM prime (0) or parallel (1).

column cstaproc

On board processing (derived from F2IMPROC).

column cstaread

Number of detector readouts per mode.

column cstasaim

Number of images sampled (derived from F2SAMIMA).

column cstaselw

Position of the selection wheel.

column cstatint

Elementary integration time (CAMTU).

column cstavers

Version number of CAM CSTA FITS product.

column filename

FITS product filename.

column obsno

Observation number constructed as follows:

revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.

Please see SCREW 385.

column utc_end_1

UTC time of the end of the observation truncated to a whole number of seconds after the beginning of the year 1989.

column utc_end_2

Remaining fraction of a second that had been truncated from the preceding UTC value (utc_end_1).

column utc_start_1

UTC time of the start of the observation truncated to a whole number of seconds after the beginning of the year 1989.

column utc_start_2

Remaining fraction of a second that had been truncated from the preceding UTC value (utc_start_1).

column version

Version of the CAM CSTA FITS product file. This is derived from the FILEVERS keyword in the header of the CAM CSTA FITS product.

Table Usage (MB)

Distribution of Table Space

Data	12.57	Data	70.57 %
Indexes	5.15	Indexes	28.90 %
Unused	0.09	Unused	0.53 %
Total	17.81	Number of Rows	141541

Dependencies

Referencing Objects

Object Name Object Type

dbo.cam_cstat.cam_cstat_ux2 INDEX

dbo.cam_cstat.cam_cstat_ix1 INDEX

dbo.cam_cstat.cam_cstat_ix2 INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.cam_cstat 
(
    obsno       int      NOT NULL,
    utc_start_1 int      NOT NULL,
    utc_start_2 int      NOT NULL,
    utc_end_1   int      NOT NULL,
    utc_end_2   int      NOT NULL,
    csgpukst    int      NOT NULL,
    csgpuken    int      NOT NULL,
    csgpikst    int      NOT NULL,
    csgpiken    int      NOT NULL,
    cstadeid    tinyint  NOT NULL,
    cstamode    tinyint  NOT NULL,
    cstaentw    smallint NOT NULL,
    cstafltw    smallint NOT NULL,
    cstalnsw    smallint NOT NULL,
    cstaselw    smallint NOT NULL,
    cstaread    smallint NOT NULL,
    cstatint    smallint NOT NULL,
    cstaanom    tinyint  NOT NULL,
    cstaconf    tinyint  NOT NULL,
    cstaprim    tinyint  NOT NULL,
    cstavers    smallint NOT NULL,
    cstaproc    smallint NOT NULL,
    cstagain    smallint NOT NULL,
    cstaoffs    smallint NOT NULL,
    cstabflg    smallint NOT NULL,
    cstaacim    smallint NOT NULL,
    cstasaim    smallint NOT NULL,
    cstacvfi    smallint NOT NULL,
    filename    char(12) NOT NULL,
    version     char(4)  NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.cam_cstat.cam_cstat_ux2	INDEX
dbo.cam_cstat.cam_cstat_ix1	INDEX
dbo.cam_cstat.cam_cstat_ix2	INDEX