POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A rule which governs the relationships between two business associate types, i.e., it determines what type may be associated in a specified role with another type. For example, a department is an administrative member of a company, and a company is a subsidiary of a corporation.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- 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).
- associated_type (FNK, M: CHAR VARYING(80))
- ref_bus_assn_structure_rule.associated_type
This is the type of the associated business associated in a structure rule. This type of associate is used as a reference to define the rule for another type of associate. For a rule constraining a team to be part of a department, this would point to department. Note: to state that a department may be composed of teams requires a second rule applied to the department since the symmetry of associations should not be assumed.
Defines a foreign key to table r_business_associate.
- business_associate_type (FNK, M: CHAR VARYING(80))
- ref_bus_assn_structure_rule.business_associate_type
This is the type of business associate for which the rule applies. For a rule constraining a team to be part of a department, this would point to team.
Defines a foreign key to table r_business_associate.
- r_business_association_role (FNK, M: CHAR VARYING(80))
- ref_bus_assn_structure_rule.ref_business_association_role
The business associate role for which the rule applies.
Defines a foreign key to table r_business_association_role.
- r_bus_assn_structure (FNK, M: CHAR VARYING(80))
- ref_bus_assn_structure_rule.ref_bus_assn_structure
Specifies the business association structure to which this rule applies.
Defines a foreign key to table r_bus_assn_structure.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- effective_date (O: DATE)
- ref_bus_assn_structure_rule.effective_date
The date after which the business association structure rule becomes effective.
- expiry_date (O: DATE)
- ref_bus_assn_structure_rule.expiry_date
The date after which the business association structure rule is no longer effective.
- 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".
- source_content (O: CHAR VARYING(80))
- ref_aliasable_data.source_content
This is the original source of the data. This is the person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc. This may be the same as or different from the provider of the instance (e.g., POSC).
- source_reference (O: CHAR VARYING(2000))
- ref_aliasable_data.source_reference
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
- status (O: CHAR VARYING(11))
- ref_aliasable_data.status
The status of this instance in the version of Epicentre running in a data store. This is an enumerated datatype for which the following are the possible values: current, provisional, deprecated. Current - use without restriction. Provisional - use with caution, this value is for comment and may not appear in future releases of Epicentre. Deprecated - avoid use if possible, it is planned to remove this value in the next major release of Epicentre.
- naming_system (FNK, O: CHAR VARYING(80))
- ref_aliasable_data.naming_system
The naming system in which the identifier is specified and determined to be unique.
Defines a foreign key to table naming_system.
- version_s (FSK, O: CHAR VARYING(19))
- ref_aliasable_data.version
This describes the version of this instance as defined by the provider.
Defines a foreign key to table r_version.
Table is related to: code_alias, data_collection_content, document_specification_part, @graphical_element
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: R_BUSINESS_ASSOCIATION_ROLE, R_BUS_ASSN_STRUCTURE, ASSOCIATED_TYPE, BUSINESS_ASSOCIATE_TYPE
Generated on Tue Jul 10 19:11:56 2001
© Copyright 2001 POSC. All rights reserved.