GUS Schema >> RAD::IntegrityStatInput

Each entry in this table describes one of the inputs to a particular integrity statistic run involving a trusted set of values in RAD and a newly added set of corresponding values, to catch possible inconsistencies with the loading of the latter. For example, if the integrity statistic computes the correlation between raw and normalized log2 ratios in a given 2-channel array experiment to check that the normalized values were properly loaded, for each element on the array there are 3 inputs: the raw value of the numerator (trusted input), the raw value of the denominator (trusted input), and the value of the normalized log2 ratio.

column nulls? type description
INTEGRITY_STAT_INPUT_ID no NUMBER(10,0) primary key Edit
INTEGRITY_STATISTIC_ID no RAD::IntegrityStatistic (NUMBER(8,0) ) FK to IntegrityStatistic, pointing to the value of the statistic for which the current entry is one of the inputs. Edit
INPUT_TABLE_ID no Core::TableInfo (NUMBER(10,0) )FK to TableInfo, pointing to the table for which the id held in input_row_id is primary key. Edit
INPUT_ROW_ID no NUMBER(10,0) The id, in the table pointed to by integrity_table_id, of the row representing the current input. Edit
ROW_DESIGNATION STRING(200) A designation to be used, if the current input is a trusted input, to illustrate how this input is employed in the IntegrityStatistic.trusted_input_formula. Edit
IS_TRUSTED_INPUT NUMBER(1,0) Edit
MODIFICATION_DATE no DATE Edit
USER_READ no NUMBER(1,0) Edit
USER_WRITE no NUMBER(1,0) Edit
GROUP_READ no NUMBER(1,0) Edit
GROUP_WRITE no NUMBER(1,0) Edit
OTHER_READ no NUMBER(1,0) Edit
OTHER_WRITE no NUMBER(1,0) Edit
ROW_USER_ID no NUMBER(12,0) Edit
ROW_GROUP_ID no NUMBER(4,0) Edit
ROW_PROJECT_ID no NUMBER(4,0) Edit
ROW_ALG_INVOCATION_ID no NUMBER(12,0) Edit

Child tables:

Subclasses: