POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
Each instance of this entity represents an association between two business associates. Each instance of a business association has a role which is defined for one business associate with respect to another business associate. For example, ABC Company has the role of contractor with respect to XYZ Company. Note: each association is defined in one direction only, and the inverse should be defined as another association if required.
- 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_with_s (FSK, M: CHAR VARYING(19))
- business_association.associated_with
The business associate that is used as the one being associated with. To record that Blue Box Co. is a subsidiary of Big Sky Corp. (as an association defined for Blue Box Co.), this characteristic points to Big Sky Corp.
Defines a foreign key to table business_associate.
- business_associate_s (FSK, M: CHAR VARYING(19))
- business_association.business_associate
The business associate for which this association is defined. To record that Blue Box Co. is a subsidiary of Big Sky Corp. (as an association defined for Blue Box Co.), this characteristic points to Blue Box Co.
Defines a foreign key to table business_associate.
- r_business_association_role (FNK, M: CHAR VARYING(80))
- business_association.ref_business_association_role
The role defined for a business associate with respect to another business associate.
Defines a foreign key to table r_business_association_role.
- r_bus_assn_structure (FNK, M: CHAR VARYING(80))
- business_association.ref_bus_assn_structure
This designates the business association structure that allows this business association, and implies that this association is authorized by the business association structure rules defined by the designated business association structure.
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.
- duration (O: FLOAT)
duration_u (FNK, O: CHAR VARYING(15))
- transient_association.duration
Defines the duration of the association expressed in any valid units of time.
duration_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- end_time (O: TIMESTAMP)
end_time_cd (O: CHAR(1))
end_time_yr (O: FLOAT)
end_time_yp (O: INTEGER)
end_time_dy (O: INTEGER)
end_time_hr (O: INTEGER)
end_time_mt (O: INTEGER)
end_time_st (O: FLOAT)
end_time_of (O: FLOAT)
- transient_association.end_time
End time of the association.
- 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.
- is_current (O: CHAR(1))
- transient_association.is_current
When TRUE, this flag indicates that this instance is designated as a current instance. This flag can be used in place of time based attributes or can be used in conjunction with them; however, it should not conflict with them.
- 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".
- start_time (O: TIMESTAMP)
start_time_cd (O: CHAR(1))
start_time_yr (O: FLOAT)
start_time_yp (O: INTEGER)
start_time_dy (O: INTEGER)
start_time_hr (O: INTEGER)
start_time_mt (O: INTEGER)
start_time_st (O: FLOAT)
start_time_of (O: FLOAT)
- transient_association.start_time
Start time of the association.
- caused_by_s (FSK, O: CHAR VARYING(19))
- transient_association.caused_by
Specifies the activity which establishes this association.
Defines a foreign key to table activity.
- r_transient_period (FNK, O: CHAR VARYING(80))
- transient_association.ref_transient_period
The type of period over which the property applies, such as day, month, quarter, cumulative, etc.
Defines a foreign key to table r_transient_period.
- terminated_by_s (FSK, O: CHAR VARYING(19))
- transient_association.terminated_by
Specifies the activity which established the termination of a transient association between two objects.
Defines a foreign key to table activity.
Table is related to: business_associate_job_title, data_collection_content, document_specification_part, @graphical_element
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:05:24 2001
© Copyright 2001 POSC. All rights reserved.