Reading out specific Data Model definition - second option

Reading out the Data Model definition can be used to verify what data models do exist and what items and levels are defined. This is most useful, when creating a new data model or wanting to modify an existing data model.

User can do this either by using applications such as:

This can also be used for building custom solutions based on applications which allow for an ODBC connection such as:

Litmus does provide such as custom solution which can be downloaded from our Central Portal.

Execute Stored Procedure PROREC_ProRec_ReadConfiguration.

Data Models are a hierarchy used to organize and relate Production Record Event data according to ISA-88 rules.

To read out a specific data model definition, call the stored procedure PROREC_ProRec_ReadConfiguration using the T-SQL EXEC or EXECUTE keyword and provide the Input variables. Below is an example using T-SQL in SQL Server Management Studio:

The function returns a table as result.