| POSC Specifications Version 2.2 |
Epicentre Relational Implementation |
Defines a set of E and P Data instances. A data collection may be a result of an activity, which may give it identity. Data collections can act as process data, meaning that the data specified as being a member of the data collection are processed. Their role in the process may be defined via process data item.
- data_collection_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- data_collection_nm (O: CHAR VARYING(40))
- data_collection.name
The name of the Data Collection.
- activity_s (FSK, O: CHAR VARYING(19))
activity_t (O: CHAR VARYING(16))
- process_data.activity
Defines the activity which created this instance.
activity_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
activity_t: Defines the name of the referenced table. Possible values are defined in @activity.
- bsasc_s (FSK, O: CHAR VARYING(19))
- data_collection.business_associate
Defines the business associate that was the source of the data in this collection.
Defines a foreign key to table bsasc.
- document_spec_s (FSK, O: CHAR VARYING(19))
document_spec_t (O: CHAR VARYING(16))
- data_collection.document_specification
Defines the source document for the instances in the collection.
document_spec_s: Implements a foreign key to a row in one of the tables projected from entity document_specification depending on the value of the next column (See below).
document_spec_t: Defines the name of the referenced table. Possible values are defined in @document_specification.
- populated_by_s (FSK, O: CHAR VARYING(19))
populated_by_t (O: CHAR VARYING(16))
- data_collection.populated_by
Defines the activity which assembled existing instances to form this data collection.
populated_by_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
populated_by_t: Defines the name of the referenced table. Possible values are defined in @activity.
- process_par_s (FSK, O: CHAR VARYING(19))
- data_collection.process_parameter
Defines the role of the data in the activity which created it.
Defines a foreign key to table process_par.
- r_data_coll_ty_nm (FNK, O: CHAR VARYING(40))
- data_collection.ref_data_collection_type
The kind or type of Data Collection.
Defines a foreign key to table r_data_coll_ty.
- updated_by_s (FSK, O: CHAR VARYING(19))
updated_by_t (O: CHAR VARYING(16))
- data_collection.updated_by
The activity which updated the instances pointed to by this data collection.
updated_by_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
updated_by_t: Defines the name of the referenced table. Possible values are defined in @activity.
Table is related to: dae_frame, @document_specification, @graphical_element, parameter_value, process_data_it
Intersection Tables: coll_cntn_x, reference_data_x
Primary Key Constraint on: DATA_COLLECTION_S
Generated on Mon Dec 1 10:16:42 1997
© Copyright 1997 POSC. All rights reserved.