This association shows how a planned or expected activity can be fulfilled by an actual activity.
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).
fulfill_s (FSK, M: CHAR VARYING(19))
activity_fulfillment.fulfill
This defines the activity that is fulfilled by this association with another activity.
Defines a foreign key to table activity.
fulfillment_s (FSK, M: CHAR VARYING(19))
activity_fulfillment.fulfillment
This defines the activity that fulfills the other activity defined by this association.
Defines a foreign key to table activity.
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.
activity_fulfillment.relative_time
The relative offset of the start time of the fulfillment activity from the start time of the fulfill activity. Positive offsets are interpreted as meaning later in time (e.g., late). relative_time_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
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".