Record Mapping
The record mapping table contains the regulations for mapping records in the set of rules to value assignment types in EH&S.
Table Fields in the Record Mapping Table
|
Table Field |
Description |
|
Internal_Id |
Name of the record in the set of rules |
|
Group |
Optional assignment of the record to a composition in the set of rules In the rule editor, this assignment is visible in the tree structure and is not therefore listed explicitly. |
|
External_Id |
Name of the assigned value assignment type or identifier in EH&S (see section Syntax) |
|
Description |
Description text for the record |
|
Options |
Options that govern access to the data in EH&S more closely |
The first two fields together identify the record uniquely in the set of rules.
Assignment to Value Assignment Types and Identifiers
You can assign records in the set of rules to the following elements in EH&S:
Syntax
In the following syntax description, optional parts are shown in square brackets
[ ]. The square brackets themselves do NOT belong to the syntax.Three periods ... indicate a random number of repetitions of the previous syntax element.
You assign records to the value assignment types in EH&S by entering the value assignment type in the External_Id field in the syntax
The value assignment type density from the standard property tree would be entered in the following way:
M:SAP_EHS_1013_005
Facts for records that are assigned to value assignment types can only have the letters M, A, F, S, R, L, U, 7, b, d, or f in their External_Id, meaning they represent fields of the value assignment table ESTVA or characteristics, or additional information.
You assign records to identifiers in EH&S by entering the identifier in the External_Id field in the syntax
Facts for records that are assigned to identifiers can only have the letters I or U in their External_Id, meaning they represent fields of the identifier table ESTRI or usages.
You assign records to tables in an external Microsoft Access database by entering the table and database name in the External_Id field in the syntax
The database must be accessible from the EH&S Expert server PC and can be present in Access 97 or Access 2000 format.
<Database> is the file name of the Microsoft Access database. If a full path is not specified, the database is expected to be in the same directory as the rule file. For sets of rules saved in the SAP System, the working directory entered in the administration tool for the EH&S Expert applies.
Facts for records that are assigned to external tables can only have the letter T in their External_Id.
Options for Records
|
Option |
Description |
|
/USAGE=<Rating>,<Validity area>. [,Exclude indicator[Active indicator[Relevancy indicator]]] [,...] |
The value assignments of the value assignment type are read or written with the specified list of ratings and validity areas. As an option, you can set the exclude indicator with X or –.You can still set or deactivate the active indicator and the relevancy indicator either with X or –.If not specified, the exclude indicator is not set, the active indicator is set, and the relevancy indicator is not set. For records that are read from EH&S, specifying the active and relevancy indicators has no effect. Only active value assignments are read. For more information on using the /USAGE option as a selection criterion, see Data Selection by Usage. |
|
/NOUSAGE |
This option prevents the usage entered in the EH&S Expert as a parameter for this value assignment type from being written. This option must be used if a usage that is defined as a fact is to cancel the default setting. Otherwise the usage that is defined as a fact would be written additionally. This option is not necessary for header data and identifiers in EH&S 2.7B. Here the usage passed as a parameter is not written implicitly. If a usage is required, it must be written explicitly with the /USAGE option or by means of a fact. |
|
/DEF=<Characteristic>:<Value> [,...] |
When reading a value assignment type (record) you can use this option to specify a selection of data records, for example, only oral toxicity data records of type "LD50." You must enter the internal phrase key as the default value for phrase-related characteristics. You cannot fill characteristics with a default value. |