| 
 | 
                              HAZARD FILE
                              Hazard Code
The Hazard Code file contains valid hazard codes that can be attached to an
Item Master record to identify the item as hazardous.
REFERENCED BY
IC00.1    IC110     IC209     IC330     PO30.1    POIE.1
WH140
UPDATED BY
IC09.1    IC10.2    IC11.1    IC811
FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY
HAZ-ITEM-GROUP         Alpha 5                                   IC09.1
Element: Item Group    This field contains the identifier for
                       a group of items that can be shared by
                       one or more companies.
HAZ-HAZARD-CODE        Alpha 8                                   IC09.1
Element: Hazard Code   This field contains a short code
                       describing why an item can be hazardous.
HAZ-DESCRIPTION        Alpha 30  (Lower Case)                    IC09.1
Element: Description   This field contains the description of
                       the hazard code.
HAZ-ACTIVE-STATUS      Alpha 1                                   IC09.1
Element: Status        This field is used to limit the usage
                       of specific hazard codes.
                       A = Active
                       I = Inactive
HAZ-USED-FL            Alpha 1                                   IC09.1  IC10.2
Element: Used          This field indicates whether the code     IC11.1  IC811
                       has been used on the Item Master file.
                       Once a code has been used, it cannot be
                       deleted, only made inactive.
                       N = No
                       Y = Yes
                         HAZARD FILE INDEX
NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN
HAZSET1   ITEM-GROUP                                             IC00.1  IC09.1
          HAZARD-CODE                                            IC10.1  IC10.2
                                                                 IC11.1  IC110
                                                                 IC209   IC330
                                                                 IC811   PO30.1
                                                                 POIE.1  WH140
                         HAZARD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH
Itemgroup      ITEMGROUP    Required
                            HAZ-ITEM-GROUP    -> ITG-ITEM-GROUP
 |