event_type

These records define a categorization of events.

Some examples of event types are measurement, alarm, and inspection.

The fields in the event_type table are listed in the following table.

Table 1. Fields in the event_type table
Field	Type	Comments
`event_type_cd`	string(50)	Required.
`event_type_name`	string(200)	Required.
`language_cd`	string(50)	Optional. This value must reference a row in the language table.
`tenant_cd`	string(50)	Optional. This value must reference a row in the tenant table.

event_type code snippet

You can use the following SQL Code snippet to retrieve metadata in the format that is required by the upsert API.

For example, if you lost the original files that are used to load metadata, you can use the snippet to retrieve the data, make changes, and submit the changes by using the upsert API.

The command must be on a single line, not as shown here.

 SELECT M.EVENT_TYPE_CD, M.EVENT_TYPE_NAME, L.LANGUAGE_CD, T.TENANT_CD FROM 
SYSREC.MASTER_EVENT_TYPE M JOIN SYSREC.LANGUAGE L ON M.LANGUAGE_ID = 
L.LANGUAGE_ID JOIN SYSREC.TENANT T ON M.TENANT_ID = T.TENANT_ID