ENTITYSPECUSE
The ENTITYSPECUSE table defines the way a spec will be used to define an entity such as a product.
This table is used by the following domain.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
SPEC_USE_ID | A unique, system-generated key that identifies the usage of a spec by an entity in the system. | BIGINT | Not Null | Yes |
ENTITY_NAME | The type of entity this spec use is related to. | VARCHAR(250) | Not Null | No |
INSTANCE_PK | The primary key of the related entity. | BIGINT | Not Null | No |
SPEC_ID | A unique, system-generated key that identifies a spec in the system. | BIGINT | Not Null | No |
SPEC_USE_TP_CD | The code assigned to the spec use type. | BIGINT | Not Null | No |
SPEC_CASCADE_TP_CD | The code assigned to the cascade action type for a spec. For example, if this spec is cascaded to descendents in the entity's hierarchy. | BIGINT | Not Null | No |
EXPLICIT_DEF_IND | Indicates that the spec has been defined for the first time on this entity. | CHAR(1) | Not Null | No |
METADATA_INFO_TP_CD | The code assigned to the metadata info type. | BIGINT | Not Null | No |
START_DT | The date when this record becomes active. | TIMESTAMP | Not Null | No |
END_DT | The date when this record becomes inactive. | TIMESTAMP | Null | No |
LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
DESTINATION_ENTITY_NAME | The destination entity this spec use is related to. | VARCHAR(250) | Null | No |
SEARCHABLE_IND | This is an indicator ("Y" or "N") which indicates whether the associated spec is to be searchable in the context of the destination entity. | CHAR(1) | Null | No |