POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
General facilities may be parts of one or more general facilities. They may be connected and versioned. Like facility, general facility describes the business function or service to which equipment and materials may be put. A general facility may defined in accordance with the description and specification of a typical facility.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- facility.identifier
The name of the facility.
- 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).
- r_existence_kind (FNK, M: CHAR VARYING(80))
- facility.ref_existence_kind
The existence kind for the facility e.g. actual, planned, required or predicted.
Defines a foreign key to table r_existence_kind.
- entity_type_nm (M: CHAR VARYING(30))