Object Type	Table
Datasource	IPMA
Database	icsa

Contains information relating to the version of RTA/QLA files used for any given revolution.

Use and Related Data

References to IDB definition files stored on-line. This information is available on a revolution basis.

Population

From RTA/QLA installation and release notes as well as the MMS history.

Columns

Name	Datatype	Null

rta_qla_version	char(7)	No

startrev	smallint	Yes

endrev	smallint	Yes

release_date	datetime	No

install_date	datetime	Yes

calq_cam_version	decimal(3,1)	No

calq_sws_version	decimal(3,1)	No

calq_pht_version	decimal(3,1)	No

cam_idb_def_gen	smallint	No

cam_par_idb_def_gen	smallint	No

cam_par_v13_action_idb_def_gen	smallint	No

cam_v13_action_idb_def_gen	smallint	No

pht_fs_idb_def_gen	smallint	No

pht_fs_old_idb_def_gen	smallint	No

lws_idb_def_gen	smallint	No

lws_old_idb_def_gen	smallint	No

sws_idb_def_gen	smallint	No

sws_fm_idb_def_gen	smallint	No

sws_fs_idb_def_gen	smallint	No

sws_old_idb_def_gen	smallint	No

comment	varchar(64)	Yes

column calq_cam_version
column calq_pht_version
column calq_sws_version
column cam_idb_def_gen
column cam_par_idb_def_gen
column cam_par_v13_action_idb_def_gen
column cam_v13_action_idb_def_gen

RTA/QLA files version numbers.

column endrev

Applies until revolution.

column install_date

RTA/QLA install date.

column lws_idb_def_gen
column lws_old_idb_def_gen
column pht_fs_idb_def_gen
column pht_fs_old_idb_def_gen

RTA/QLA files version number.

column release_date

RTA/QLA release date.

column comment

Comment.

column rta_qla_version

RTA/QLA version number.

column startrev

Applies from revolution.

column sws_idb_def_gen
column sws_fm_idb_def_gen
column sws_fs_idb_def_gen
column sws_old_idb_def_gen

RTA/QLA files version numbers.

Table Usage (MB)

Distribution of Table Space

Data	0.01	Data	4.17 %
Indexes	0.01	Indexes	5.56 %
Unused	0.13	Unused	90.28 %
Total	0.14	Number of Rows	41

Dependencies

Referencing Objects

Object Name Object Type

dbo.rta_qla.rta_qla_config_info_pk INDEX

dbo.rta_qla.rta_qla_calq_sws_fk INDEX

dbo.rta_qla.rta_qla_calq_pht_fk INDEX

dbo.rta_qla.rta_qla_calq_cam_fk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.rta_qla 
(
    rta_qla_version                char(7)      NOT NULL,
    startrev                       smallint     NULL,
    endrev                         smallint     NULL,
    release_date                   datetime     NOT NULL,
    install_date                   datetime     NULL,
    calq_cam_version               decimal(3,1) NOT NULL,
    calq_sws_version               decimal(3,1) NOT NULL,
    calq_pht_version               decimal(3,1) NOT NULL,
    cam_idb_def_gen                smallint     NOT NULL,
    cam_par_idb_def_gen            smallint     NOT NULL,
    cam_par_v13_action_idb_def_gen smallint     NOT NULL,
    cam_v13_action_idb_def_gen     smallint     NOT NULL,
    pht_fs_idb_def_gen             smallint     NOT NULL,
    pht_fs_old_idb_def_gen         smallint     NOT NULL,
    lws_idb_def_gen                smallint     NOT NULL,
    lws_old_idb_def_gen            smallint     NOT NULL,
    sws_idb_def_gen                smallint     NOT NULL,
    sws_fm_idb_def_gen             smallint     NOT NULL,
    sws_fs_idb_def_gen             smallint     NOT NULL,
    sws_old_idb_def_gen            smallint     NOT NULL,
    comment                        varchar(64)  NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.rta_qla.rta_qla_config_info_pk	INDEX
dbo.rta_qla.rta_qla_calq_sws_fk	INDEX
dbo.rta_qla.rta_qla_calq_pht_fk	INDEX
dbo.rta_qla.rta_qla_calq_cam_fk	INDEX