Object Type	Table
Datasource	IPMA
Database	icsa

Instrument Focal Plane Geometry Information. This has been static since revolution 22, but it has been identified as useful to have this information available for the first 22 revolutions. The information has been provided by Flight Dynamics (FD).

Use and Related Data

The dataset ID can be used to link to the pointing_ifpg table to link the pointing (in the aph) to the IFPG dataset
used for the first 21 revolutions.

Population

Values provided by FD.

Columns

Name	Datatype	Null

dataset_id	tinyint	No

comment	varchar(100)	No

cam_y1	float	No

cam_z1	float	No

cam_y2	float	No

cam_z2	float	No

cam_y3	float	No

cam_z3	float	No

pht_y1	float	No

pht_z1	float	No

pht_y2	float	No

pht_z2	float	No

pht_y3	float	No

pht_z3	float	No

lws_y1	float	No

lws_z1	float	No

lws_y2	float	No

lws_z2	float	No

lws_y3	float	No

lws_z3	float	No

sws_y1	float	No

sws_z1	float	No

sws_y2	float	No

sws_z2	float	No

sws_y3	float	No

sws_z3	float	No

sws_y4	float	Yes

sws_z4	float	Yes

column dataset_id

Dataset identifier. Used to link to the pointing_ifpg table
from which can be linked to the pointings (in the aph table).

column comment

Comment.

column cam_y1
column cam_y2
column cam_y3

column cam_z1
column cam_z2
column cam_z3

column lws_y1
column lws_y2
column lws_y3

column lws_z1
column lws_z2
column lws_z3

column pht_y1
column pht_y2
column pht_y3

column pht_z1
column pht_z2
column pht_z3

column sws_y1
column sws_y2
column sws_y3
column sws_y4

column sws_z1
column sws_z2
column sws_z3
column sws_z4

Table Usage (MB)

Distribution of Table Space

Data	0.01	Data	37.50 %
Indexes	0.00	Indexes	0.00 %
Unused	0.01	Unused	62.50 %
Total	0.02	Number of Rows	13

Dependencies

Referencing Objects

Object Name Object Type

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.ifpg 
(
    dataset_id tinyint      NOT NULL,
    comment    varchar(100) NOT NULL,
    cam_y1     float        NOT NULL,
    cam_z1     float        NOT NULL,
    cam_y2     float        NOT NULL,
    cam_z2     float        NOT NULL,
    cam_y3     float        NOT NULL,
    cam_z3     float        NOT NULL,
    pht_y1     float        NOT NULL,
    pht_z1     float        NOT NULL,
    pht_y2     float        NOT NULL,
    pht_z2     float        NOT NULL,
    pht_y3     float        NOT NULL,
    pht_z3     float        NOT NULL,
    lws_y1     float        NOT NULL,
    lws_z1     float        NOT NULL,
    lws_y2     float        NOT NULL,
    lws_z2     float        NOT NULL,
    lws_y3     float        NOT NULL,
    lws_z3     float        NOT NULL,
    sws_y1     float        NOT NULL,
    sws_z1     float        NOT NULL,
    sws_y2     float        NOT NULL,
    sws_z2     float        NOT NULL,
    sws_y3     float        NOT NULL,
    sws_z3     float        NOT NULL,
    sws_y4     float        NULL,
    sws_z4     float        NULL
)
LOCK ALLPAGES
go