POSC Specifications: Epicentre Version 3.0 | 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.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- data_collection.identifier
The name of the Data Collection.
- instance_create_date (O: TIMESTAMP)
- e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
- last_updated (O: TIMESTAMP)
- e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
- r_data_collection_type (FNK, M: CHAR VARYING(80))
- data_collection.ref_data_collection_type
The kind or type of Data Collection.
Defines a foreign key to table r_data_collection_type.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- instance_creator (O: CHAR VARYING(80))
- e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
- last_updated_by (O: CHAR VARYING(80))
- e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
- source (O: CHAR VARYING(80))
- e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
- activity_s (FSK, O: CHAR VARYING(19))
- process_data.activity
Defines the activity which created this instance.
Defines a foreign key to table activity.
- business_associate_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 business_associate.
- document_specification_s (FSK, O: CHAR VARYING(19))
document_specification_t (O: CHAR VARYING(30))
- data_collection.document_specification
Defines the source document for the instances in the collection.
document_specification_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_specification_t: Defines the name of the referenced table. Possible values are defined in @document_specification.
- populated_by_s (FSK, O: CHAR VARYING(19))
- data_collection.populated_by
Defines the activity which assembled existing instances to form this data collection.
Defines a foreign key to table activity.
- process_parameter_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_parameter.
- updated_by_s (FSK, O: CHAR VARYING(19))
- data_collection.updated_by
The activity which updated the instances pointed to by this data collection.
Defines a foreign key to table activity.
Table is related to: data_collection_content, document_specification_part, @graphical_element, process_data_item
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:13:35 2001
© Copyright 2001 POSC. All rights reserved.