An association which defines the roles that a business associate has for a facility over a period of time. Examples are: a company is the operator, a person is responsible for maintenance, a company is the construction or drilling contractor, etc. These are functional roles in general, not job titles.

bsasc_fcl_asn_s (PK, M: CHAR VARYING(19))

Surrogate key of the table.


bsasc_s (FSK, M: CHAR VARYING(19))

business_associate_facility_association.business_associate
This is the business associate for whom this role is defined.
Defines a foreign key to table bsasc.


facility_s (FSK, M: CHAR VARYING(19))
facility_t (M: CHAR VARYING(16))

business_associate_facility_association.facility
Specifies the facility for which this association with a business associate is defined.
facility_s: Implements a foreign key to a row in one of the tables projected from entity facility depending on the value of the next column (See below).
facility_t: Defines the name of the referenced table. Possible values are defined in @facility.


r_bsasc_fcl_rle_nm (FNK, M: CHAR VARYING(40))

business_associate_facility_association.ref_business_associate_facility_role
The role or function that the business associate has for the facility. Examples are drilling contractor, operator, safety officer, auditor, caterer, etc.
Defines a foreign key to table r_bsasc_fcl_rle.


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.


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.