Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
activation	CLK_TIME	datetime					The date that the model was activated
archive	CLK_TIME	datetime					The date that the model was activated
description	CHAR	varchar		255			Model description
model_type	CHAR	varchar		32			Type of object
model_type_rank	LONG	int				DIRECT	Type rank of model
name	CHAR	varchar		32			Model name
OBJID	LONG	int	3			DIRECT	Internal record number
session_objid	LONG	int				DIRECT	Internal record number for session
status	CHAR	varchar					Status of object
status_rank	LONG	int				DIRECT	Status rank of model

SQL:

(
select table_model_ds_se_view.objid, table_model_ds_se_view.name,
table_model_ds_se_view.description, table_model_ds_se_view.activation,
table_model_ds_se_view.model_type, table_model_ds_se_view.model_type_rank,
table_model_ds_se_view.status, table_model_ds_se_view.status_rank,
table_model_ds_se_view.session_objid, table_model.archived_dt as archive
from table_model_ds_se_view, table_model
where table_model_ds_se_view.status_rank=3 and table_model.objid=table_model_ds_se_view.objid
and table_model_ds_se_view.objid not in (Select submodel_objid from table_combined_model_view where status_rank=3)
union
select table_model_rs_dt_ds_se_view.objid, table_model_rs_dt_ds_se_view.name,
table_model_rs_dt_ds_se_view.description, table_model_rs_dt_ds_se_view.activation,
table_model_rs_dt_ds_se_view.model_type, table_model_rs_dt_ds_se_view.model_type_rank,
table_model_rs_dt_ds_se_view.status, table_model_rs_dt_ds_se_view.status_rank,
table_model_rs_dt_ds_se_view.session_objid, table_model.archived_dt as archive
from table_model_rs_dt_ds_se_view, table_model
where table_model_rs_dt_ds_se_view.status_rank=3 and table_model.objid=table_model_rs_dt_ds_se_view.objid
and table_model_rs_dt_ds_se_view.objid not in (Select submodel_objid from table_combined_model_view where status_rank=3)
union
select table_model_rs_list_view.objid, table_model_rs_list_view.name,
table_model_rs_list_view.description, table_model_rs_list_view.activation,
table_model_rs_list_view.model_type, table_model_rs_list_view.model_type_rank,
table_model_rs_list_view.status, table_model_rs_list_view.status_rank,
table_model_rs_list_view.session_objid, table_model.archived_dt as archive
from table_model_rs_list_view, table_model
where table_model_rs_list_view.status_rank=3 and table_model.objid=table_model_rs_list_view.objid
and table_model_rs_list_view.objid not in (Select submodel_objid from table_combined_model_view where status_rank=3)
)