| POSC Specifications Version 2.2 |
Epicentre Relational Implementation |
A description of interest in a business object for a business associate. The derived interest makeups for a business object defines the interest fractions held by different business associates. The derived interest makeups for a business associate describes the interest fractions defined for all business objects. The derived interest fractions are based on contract designations from specific contracts (which may not be available). The derived interest makeup fractions should always be consistent with the contract designations they are based upon, but if contract information is missing, the fractions may no longer be derivable.
- derv_int_mkup_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- interest_for_s (FSK, M: CHAR VARYING(19))
interest_for_t (M: CHAR VARYING(16))
- derived_interest_makeup.interest_for
The business object for which the derived interest makeup is defined.
interest_for_s: Implements a foreign key to a row in one of the tables projected from entity business_object depending on the value of the next column (See below).
interest_for_t: Defines the name of the referenced table. Possible values are defined in @business_object.
- interest_of_s (FSK, M: CHAR VARYING(19))
- derived_interest_makeup.interest_of
The business associate for whom the derived interest makeup is defined.
Defines a foreign key to table bsasc.
- description (O: CHAR VARYING(2000))
- transient_association.description
A description of the transient association.
- 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_uom.
- end_time (O: TIMESTAMP)
- transient_association.end_time
End time of the association.
- fraction (O: FLOAT(6))
- derived_interest_makeup.fraction
The fraction of the interest in the business object that belongs to the business associate.
- start_time (O: TIMESTAMP)
- transient_association.start_time
Start time of the association.
- caused_by_s (FSK, O: CHAR VARYING(19))
caused_by_t (O: CHAR VARYING(16))
- transient_association.caused_by
Specifies the activity which establishes this association.
caused_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).
caused_by_t: Defines the name of the referenced table. Possible values are defined in @activity.
- r_transient_period (FNK, O: CHAR VARYING(40))
- 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_pd.
- terminated_by_s (FSK, O: CHAR VARYING(19))
terminated_by_t (O: CHAR VARYING(16))
- transient_association.terminated_by
Specifies the activity which established the termination of a transient association between two objects.
terminated_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).
terminated_by_t: Defines the name of the referenced table. Possible values are defined in @activity.
Table is related to: dae_frame, @graphical_element, parameter_value
Intersection Tables: coll_cntn_x, basis_x
Primary Key Constraint on: DERV_INT_MKUP_S
Generated on Mon Dec 1 10:16:45 1997
© Copyright 1997 POSC. All rights reserved.