POSC Specifications Version 2.2
Data Access and Exchange v2.2
Static Work Environment Relational Implementation
DAE_LEAF_FRAME
(DAE_LEAF_FRAME)
(DDL)
A frame at the bottom of the hierarchy of frames.
dae_leaf_frame_s
(PK, M: CHAR VARYING(19))
Surrogate key of the table.
property_type_s
(FSK, M: CHAR VARYING(19))
dae_leaf_frame
.property_type
must property type
Defines a foreign key to table
r_property_kind
.
bdal_name
(O: CHAR VARYING(40))
dae_leaf_frame
.bdal_name
Name of the Bulk Data Access library (if any) which controls this frame.
first_value
(O: FLOAT(6))
dae_leaf_frame
.first_value
Value of the cell where all dimension indexes are at their lowest bound.
inval_evnt_cnt
(O: INTEGER)
dae_leaf_frame
.inval_evnt_cnt
Number of write events to the frame since statistics were calculated.
last_value
(O: FLOAT(6))
dae_leaf_frame
.last_value
Value of the cell where all dimension indexes are at their highest bound.
maximum_value
(O: FLOAT(6))
dae_leaf_frame
.maximum_value
Maximum observed value within the leaf.
mean_value
(O: FLOAT(6))
dae_leaf_frame
.mean_value
The average value of all non-null cells.
minimum_value
(O: FLOAT(6))
dae_leaf_frame
.minimum_value
Minimum observed value within the leaf.
population_count
(O: INTEGER)
dae_leaf_frame
.population_count
Number of non-null cells in the leaf.
rec_key
(O: CHAR VARYING(40))
dae_leaf_frame
.rec_key
Recognition key assigned by the controlling Bulk Data Access library (if any).
standard_dev
(O: FLOAT(6))
dae_leaf_frame
.standard_dev
The standard deviation of non-null cells.
value_formula
(O: CHAR VARYING(255))
dae_leaf_frame
.value_formula
A formula that defines a value for the leaf frame.
parent_frame_s
(FSK, O: CHAR VARYING(19))
parent_frame_l
(O: INTEGER)
dae_frame
.members
must have as members
parent_frame_s
: Defines a foreign key to table
dae_frame
.
parent_frame_l
: Provides the ordering of rows.
property_axis_s
(FSK, O: CHAR VARYING(19))
dae_leaf_frame
.property_axis
may property axis
Defines a foreign key to table
cord_sys_axis
.
unit_acronym
(FNK, O: CHAR VARYING(15))
dae_leaf_frame
.unit_acronym
may property unit
Defines a foreign key to table
r_uom
.
Primary Key Constraint on:
DAE_LEAF_FRAME_S
Generated on Mon Dec 1 10:27:38 1997
© Copyright 1997 POSC. All rights reserved.