Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OSHA


                               OSHA FILE

                         OSHA Incident History

The OSHA Incident History file contains the history of OSHA incidents.

REFERENCED BY

HOSH.1    HR90.1    PA149     PA248     PA249     PA290
PA49.1    PA49.3    PA490     PA549     HR170     HR70.1
PA91.1    PA92.1

UPDATED BY

PA372     PA590     PA90.1    PA90.3    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OSH-COMPANY            Numeric 4                                 PA372   PA590
Element: Company Hr    Contains the company number that          PA90.1
                       represents an established company.

OSH-EMPLOYEE           Numeric 9                                 PA372   PA590
Element: Employee      An employee number is assigned to each    PA90.1
                       person employed by the company.  It is
                       used to correlate all information
                       related to the employee.

OSH-SEQ-NBR            Numeric 4                                 PA372   PA590
Element: Sequence NumbeSequence number.                          PA90.1

OSH-DATE               Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date          This field contains the date of injury    PA90.1
                       or illness.

OSH-ILL-INJ            Alpha 2                                   PA372   PA590
Illness or Injury      This field contains the illness or        PA90.1
Indicator              injury indicator.
                       IL = Illness
                       IN = Injury

OSH-DESCRIPTION        Alpha 30  (Lower Case)                    PA372   PA590
Element: Description   This field contains the description of    PA90.1
                       the illness or injury.

OSH-JOB-CODE           Alpha 9                                   PA372   PA590
Element: Job Code      This field contains the job code          PA90.1
                       performed when the incident occurred.
                       The job code must be valid in JOBCODE.

OSH-PROCESS-LEVEL      Alpha 5                                   PA372   PA590
Element: Process Lev HrThis field contains the employee's        PA90.1
                       process level or the process level where
                       the incident occurred.

OSH-DEPARTMENT         Alpha 5                                   PA372   PA590
Element: Department    This field contains the employee's        PA90.1
                       department or the department where the
                       incident occurred.

OSH-AGE                Numeric 2                                 PA372   PA590
Element: Age           This field contains the employee's age    PA90.1
                       when the incident occurred.

OSH-SEX                Alpha 1                                   PA372   PA590
Element: Gender        Employee's gender when incident           PA90.1
                       occurred.
                       F = Female
                       M = Male

OSH-PHY-LST-NAME       Alpha 15  (Lower Case)                    PA372   PA590
Element: Physician LastThis field contains the physician's       PA90.1
                       last name.

OSH-PHY-FST-NAME       Alpha 14  (Lower Case)                    PA372   PA590
Element: Physician FirsThis field contains the physician's       PA90.1
                       first name.

OSH-PHY-MID-INIT       Alpha 1                                   PA372   PA590
Physician Middle       This field contains the physician's       PA90.1
Initial                middle initial.

OSH-HOSP-NAME          Alpha 30  (Lower Case)                    PA372   PA590
Element: Hospital Name This field contains the hospital name.    PA90.1

OSH-DEATH              Alpha 1                                   PA372   PA590
Death Resulted         This field indicates if the incident      PA90.1
Indicator              resulted in death.
                       N = No
                       Y = Yes

OSH-DEAD-DATE          Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date of Death This field contains the date of death.    PA90.1

OSH-CMP-PREM           Alpha 1                                   PA372   PA590
Occurred on Company    This field indicates if the incident      PA90.1
Premises               occurred on company premises.
                       N = No
                       Y = Yes

OSH-LOCAT-CODE         Alpha 10                                  PA372   PA590
Element: Location      This field contains the location of the   PA90.1
                       incident.  The location must be  valid
                       in PCODES.

OSH-SHIFT              Numeric 1                                 PA372   PA590
Element: Shift         This field contains the shift worked      PA90.1
                       when the incident occurred.
                       1 = Shift 1
                       2 = Shift 2
                       3 = Shift 3
                       4 = Shift 4
                       5 = Shift 5
                       6 = Shift 6
                       7 = Shift 7
                       8 = Shift 8
                       9 = Shift 9

OSH-HOW                Alpha 50  (Lower Case)                    PA372   PA590
How Incident           Occurs 2 Times                            PA90.1
Occurred               This field contains the description of
                       how the incident occurred.

OSH-BODY-PART          Alpha 50  (Lower Case)                    PA372   PA590
Element: Affected Body This field contains the description of    PA90.1
                       the body part(s) affected by the
                       incident.

OSH-OBJ-SUBS           Alpha 50  (Lower Case)                    PA372   PA590
Involved Object or     This field contains the description of    PA90.1
Substance              the object or substance.

OSH-DAYS-OUT           Numeric 3                                 PA372   PA590
Element: Days Out      This field contains the number of days    PA90.1
                       away from work.

OSH-DAYS-REST          Numeric 3                                 PA372   PA590
Element: Days RestricteThis field contains the number of days    PA90.1
                       restricted from certain types of work.

OSH-ILLNESS-TYPE       Alpha 2                                   PA372   PA590
Element: Illness Type  This field contains the type of illness.  PA90.1
                       1 = Musculoskeletal disorder
                       2 = Skin disorder
                       3 = Respiratory condition
                       4 = Poisoning
                       5 = Hearing loss
                       6 = Disorder from physical agent
                       7 = Disorder from repeated trauma
                       8 = Dust disease of the lungs
                       9 = Other occupational illness

OSH-WC-FLAG            Alpha 1                                   PA372   PA590
Workers Comp           This field indicates whether the          PA90.1
Reportable Flag        incident was reportable with regard to
                       workers compensation.
                       N = No
                       Y = Yes

OSH-OSHA-FLAG          Alpha 1                                   PA372   PA590
Element: Osha Flag     Reserved for future development.          PA90.1
                       N = No
                       Y = Yes

OSH-INCIDENT           Alpha 10                                  PA372   PA590
Element: Incident      Contains user-defined incident            PA90.1
                       information.

OSH-ILLNESS            Alpha 10                                  PA372   PA590
Element: Illness       Contains user-defined illness             PA90.1
                       information.

OSH-FULL-NAME          Derived
Element: Full Name     Reserved for future development.

OSH-ESTABLISHMENT      Alpha 10                                  PA372   PA590
Element: Establishment Contains the establishment where          PA90.1
                       incident occurred.

OSH-INCID-STATUS       Alpha 10                                  PA372   PA590
Element: Incid Status  Contains the user-defined incident        PA90.1
                       status.

OSH-OUTCOME            Alpha 10                                  PA372   PA590
Element: Outcome       Contains the user-defined incident        PA90.1
                       outcome.

OSH-COST               Signed 11.2                               PA372   PA590
Element: Cost          Contains the incident cost.               PA90.1  PA90.3

OSH-INCID-CAT          Alpha 10                                  PA372   PA590
Element: Incid Cat     Contains the user-defined incident        PA90.1
                       category.

OSH-WC-CLAIM           Alpha 15                                  PA372   PA590
Element: Wc Claim      Contains the workers compensation claim   PA90.1
                       number.

OSH-GOVT-FLAG          Alpha 1                                   PA372   PA590
Element: Govt Flag     Indicates whether case must be reported   PA90.1
                       to the government.
                       Y = Yes
                       N = No

OSH-GOVT-CASE          Numeric 8                                 PA372   PA590
Element: Govt Case     Contains the government case number.      PA90.1

OSH-PRIOR-ESTAB        Alpha 10                                  PA372   PA590
Element: Prior Estab   If the incident is related to a prior     PA90.1
                       incident, this field contains the
                       establishment where the prior incident
                       occurred.

OSH-PRIOR-SEQ-NBR      Numeric 4                                 PA372   PA590
Element: Prior Seq Nbr If the incident is related to a prior     PA90.1
                       incident, this field contains the prior
                       report number.

OSH-BODY-PART-CD       Alpha 10                                  PA372   PA590
Element: Body Part Cd  Contains the user-defined body part       PA90.1
                       that was injured by the incident.

OSH-REPORTS-TO         Numeric 9                                 PA372   PA590
Element: Reports To    Contains the employee to whom the         PA90.1
                       incident was reported.

OSH-REPORT-TO-NAME     Alpha 30  (Lower Case)                    PA372   PA590
Element: Report To NameContains the employee or individual to    PA90.1
                       whom the incident was reported.

OSH-REPORTS-BY         Numeric 9                                 PA372   PA590
Element: Reports By    Contains the employee who reported the    PA90.1
                       incident.

OSH-REPORT-BY-NAME     Alpha 30  (Lower Case)                    PA372   PA590
Element: Report By NameContains the employee or individual who   PA90.1
                       reported the incident.

OSH-WITNESS            Numeric 9                                 PA372   PA590
Element: Witness       Contains the employee who witnessed the   PA90.1
                       incident.

OSH-WIT-NAME           Alpha 30  (Lower Case)                    PA372   PA590
Element: Wit Name      Contains the employee or individual who   PA90.1
                       witnessed the incident.

OSH-WIT-ADDR1          Alpha 30  (Lower Case)                    PA372   PA590
Element: Wit Addr1     Contains the first line of the            PA90.1
                       witness's address.

OSH-WIT-CITY           Alpha 18  (Lower Case)                    PA372   PA590
Element: Wit City      Contains the witness's city.              PA90.1

OSH-WIT-STATE          Alpha 2                                   PA372   PA590
Element: Wit State     Contains the witness's state.             PA90.1

OSH-WIT-ZIP            Alpha 10                                  PA372   PA590
Element: Wit Zip       Contains the witness's postal code.       PA90.1

OSH-WIT-CNTRY-CD       Alpha 2                                   PA372   PA590
Element: Wit Cntry Cd                                            PA90.1

OSH-WIT-PHN-CNTRY      Alpha 6                                   PA372   PA590
Element: Wit Phn Cntry Contains the witness's telephone          PA90.1
                       country code.

OSH-WIT-PHONE-NBR      Alpha 15                                  PA372   PA590
Element: Wit Phone Nbr Contains the witness's telephone number.  PA90.1

OSH-WIT-PHONE-EXT      Alpha 5                                   PA372   PA590
Element: Wit Phone Ext Contains the witness's telephone          PA90.1
                       extension.

OSH-EMP-STATUS         Alpha 2                                   PA372   PA590
Element: Employee StatuContains the employee's status when       PA90.1
                       incident occurred.
                       1 = Full Time
                       2 = Part Time
                       3 = Casual
                       4 = Seasonal
                       5 = Apprentice
                       6 = Student
                       7 = Learner
                       8 = Volunteer
                       9 = Other

OSH-SUPERVISOR-EMP     Numeric 9                                 PA372   PA590
Element: Supervisor EmpContains the supervisor to whom the       PA90.1
                       employee reported when the incident
                       occurred.

OSH-SUP-NAME           Alpha 30  (Lower Case)                    PA372   PA590
Element: Supervisor's NContains the name of the supervisor to    PA90.1
                       whom the employee reported when the
                       incident occurred.

OSH-ADDR1              Alpha 30  (Lower Case)                    PA372   PA590
Element: Address 1     Contains the address where the incident   PA90.1
                       took place.

OSH-CITY               Alpha 18  (Lower Case)                    PA372   PA590
Element: City          Contains the city where the incident      PA90.1
                       took place.

OSH-STATE              Alpha 2                                   PA372   PA590
Element: State or ProviContains the state where the incident     PA90.1
                       took place.

OSH-ZIP                Alpha 10                                  PA372   PA590
Element: Postal Code   Contains the postal code where the        PA90.1
                       incident took place.


OSH-FIRST-AID-BY       Numeric 9                                 PA372   PA590
Element: First Aid By  Contains the employee who provided        PA90.1
                       first aid.

OSH-FIRST-AID-NAME     Alpha 30  (Lower Case)                    PA372   PA590
Element: First Aid NameContains the employee or individual who   PA90.1
                       provided first aid.

OSH-PHYSICIAN          Alpha 10                                  PA372   PA590
Element: Physician     Contains the physician who treated the    PA90.1
                       employee.

OSH-PATIENT-FLAG       Alpha 1                                   PA372   PA590
Element: Patient Flag  Indicates whether the employee was        PA90.1
                       hospitalized as a result of the
                       incident.
                       N = No
                       Y = Yes

OSH-HOSPITAL           Alpha 10                                  PA372   PA590
Element: Hospital      Contains the user-defined hospital        PA90.1
                       where the employee was treated after the
                       incident.

OSH-TIME-START-WK      Numeric 6  (hhmmss)                       PA372   PA590
Element: Time Start Wk Contains the employee's normal work       PA90.1
                       start time.

OSH-TIME-END-WK        Numeric 6  (hhmmss)                       PA372   PA590
Element: Time End Wk   Contains the employee's normal work       PA90.1
                       stop time.

OSH-DATE-INJURY        Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date Injury   Contains the date the incident took       PA90.1
                       place.

OSH-TIME-INJURY        Numeric 6  (hhmmss)                       PA372   PA590
Element: Time Injury   Contains the time the incident took       PA90.1
                       place.

OSH-DATE-LAST-WORK     Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date Last WorkContains the last date the employee       PA90.1
                       worked after the incident.

OSH-TIME-LAST-WORK     Numeric 6  (hhmmss)                       PA372   PA590
Element: Time Last WorkContains the last time the employee       PA90.1
                       worked after the incident.

OSH-DATE-OUT           Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date Out      Contains the first date the employee      PA90.1
                       did not attend work due to the incident.

OSH-DATE-NOTIFIED1     Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date Notified1Contains the date the employer was        PA90.1
                       notified of the incident.

OSH-TIME-NOTIFIED1     Numeric 6  (hhmmss)                       PA372   PA590
Element: Time Notified1Contains the time the employer was        PA90.1
                       notified of the incident.

OSH-DATE-NOTIFIED2     Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date Notified2Contains the date the employer was        PA90.1
                       notified of lost time.

OSH-TIME-NOTIFIED2     Numeric 6  (hhmmss)                       PA372   PA590
Element: Time Notified2Contains the time the employer was        PA90.1
                       notified of lost time.

OSH-DATE-1             Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date 1        If the employee returned to work after    PA90.1
                       the incident, contains the first date of
                       the date range.

OSH-TIME-1             Numeric 6  (hhmmss)                       PA372   PA590
Element: Time 1        If the employee returned to work after    PA90.1
                       the incident, contains the start time.

OSH-DATE-2             Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date 2        If the employee returned to work after    PA90.1
                       the incident, contains the last date of
                       the date range.

OSH-TIME-2             Numeric 6  (hhmmss)                       PA372   PA590
Element: Time 2        If the employee returned to work after    PA90.1
                       the incident, contains the ending time.

OSH-DATE-RETURNED      Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date Returned Contains the date the employee returned   PA90.1
                       to work after the incident.

OSH-TIME-RETURNED      Numeric 6  (hhmmss)                       PA372   PA590
Element: Time Returned Contains the time the employee returned   PA90.1
                       to work after the incident.

OSH-HOURS-FLAG         Alpha 1                                   PA372   PA590
Element: Hours Flag    Indicates whether the employee was        PA90.1
                       absent from work due to the incident.
                       N = No
                       Y = Yes

OSH-WORK-FLAG          Alpha 1                                   PA372   PA590
Element: Work Flag     Indicates whether the employee is able    PA90.1
                       to perform other duties at work.
                       N = No
                       Y = Yes

OSH-WAGES-FLAG         Alpha 1                                   PA372   PA590
Element: Wages Flag    Indicates whether the employee will       PA90.1
                       earn reduced wages due to performing
                       other work duties.
                       N = No
                       Y = Yes

OSH-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Date Stamp    This field contains the server date       PA90.1  PA90.3
                       (month, date, and year) of the last
                       change to this record.

OSH-TIME-STAMP         Numeric 6  (hhmmss)                       PA372   PA590
Element: Time Stamp    Contains the server time (hour, minute,   PA90.1  PA90.3
                       and second) when the record was last
                       changed.

OSH-USER-ID            Alpha 10  (Lower Case)                    PA372   PA590
Element: User          Contains the user ID of the person who    PA90.1  PA90.3
                       last changed this record.

OSH-SEVERITY           Alpha 10                                  PA372   PA590
Element: Severity      Contains the user-defined incident        PA90.1
                       severity.

OSH-USER-FIELD1        Alpha 30                                  PA372   PA590
Item Mster User        This is the first user definable field.   PA90.1
Defined Field1         It can be used to capture any data that
                       the user wants.  The title of the field
                       is setup in IC00.


OSH-USER2              Alpha 10                                  PA372   PA590
Element: User2         Contains the second field of              PA90.1
                       user-defined  information.

OSH-USER3              Alpha 10                                  PA372   PA590
Element: User3         Contains the third field of               PA90.1
                       user-defined information.

OSH-CURRENCY-CODE      Alpha 5                                   PA372   PA590
Element: Currency Code Contains the currency in which the        PA90.1  PA90.3
                       incident costs are recorded.

OSH-CURR-ND            Numeric 1                                 PA372   PA590
Account Currency       Represents the number of decimals         PA90.1  PA90.3
Code                   defined for the currency of the object.

OSH-COUNTRY-CODE       Alpha 2                                   PA372   PA590
Element: Country Code  Contains the country where the incident   PA90.1
                       took place.

OSH-BASE-CURRENCY      Alpha 5                                   PA372   PA590
Element: Base Currency Contains the company base currency.       PA90.1  PA90.3

OSH-BASE-ND            Numeric 1                                 PA372   PA590
Base Number Of         The number of decimal positions defined   PA90.1  PA90.3
Decimals               for the company base currency.

OSH-BASE-AMOUNT        Signed 15.2                               PA372   PA590
Element: Base Amount   Contains the incident costs in the        PA90.1  PA90.3
                       company's base currency.

OSH-INCIDENT-SITE      Alpha 30  (Lower Case)                    PA372   PA590
Element: Incident Site                                           PA90.1

OSH-REPORT-COMP-BY     Numeric 9                                 PA372   PA590
Element: Report Comp By                                          PA90.1

OSH-RPT-COMP-NAME      Alpha 30  (Lower Case)                    PA372   PA590
Element: Rpt Comp Name                                           PA90.1

OSH-RPT-COMP-DATE      Numeric 8  (yyyymmdd)                     PA372   PA590
Element: Rpt Comp Date                                           PA90.1

OSH-EMERGENCY-ROOM     Alpha 1                                   PA372   PA590
Element: Emergency Room                                          PA90.1

OSH-SHARP-DEVICE       Alpha 10                                  PA372   PA590
Element: Sharp Device                                            PA90.1

OSH-BRND-SHARP-DEV     Alpha 10                                  PA372   PA590
Element: Brnd Sharp Dev                                          PA90.1

                         OSHA FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OSHSET1   COMPANY                                                HOSH.1  HR11.1
          EMPLOYEE                                               HR90.1  PA115
          ESTABLISHMENT                                          PA149   PA248
          SEQ-NBR                                                PA249   PA290
                                                                 PA372   PA49.1
                                                                 PA49.3  PA490
                                                                 PA549   PA590
                                                                 PA90.1  PA90.2
                                                                 PA90.3

OSHSET2   COMPANY       KeyChange                                HR170   HR70.1
          EMPLOYEE                                               PA91.1
          DATE
          ESTABLISHMENT
          SEQ-NBR

OSHSET3   COMPANY                                                PA372   PA590
          ESTABLISHMENT                                          PA90.1  PA92.1
          SEQ-NBR*
          EMPLOYEE

                         OSHA FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Base Currency  CUCODES      Required
                            When (OSH-CURRENCY-CODE != Spaces )

                            OSH-BASE-CURRENCY     -> CUC-CURRENCY-CODE

Body Part      PCODES       Required
                            When (OSH-BODY-PART-CD != Spaces )

                            "BP"                  -> PCO-TYPE
                            OSH-BODY-PART-CD      -> PCO-CODE

Company        PRSYSTEM     Required

                            OSH-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Country        INSTCTRYCD   Required
                            When (OSH-COUNTRY-CODE != Spaces )

                            OSH-COUNTRY-CODE      -> INT-COUNTRY-CODE

Currency       CUCODES      Required
                            When (OSH-CURRENCY-CODE != Spaces )

                            OSH-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Department     DEPTCODE     Required
                            When OSH-DEPARTMENT != Spaces

                            OSH-COMPANY           -> DPT-COMPANY
                            OSH-PROCESS-LEVEL     -> DPT-PROCESS-LEVEL
                            OSH-DEPARTMENT        -> DPT-DEPARTMENT

Employee       EMPLOYEE     Required

                            OSH-COMPANY           -> EMP-COMPANY
                            OSH-EMPLOYEE          -> EMP-EMPLOYEE

Establishment  OSHESTAB     Required
                            When (OSH-ESTABLISHMENT != Spaces )

                            OSH-COMPANY           -> OTB-COMPANY
                            OSH-ESTABLISHMENT     -> OTB-ESTABLISHMENT

First Aid By   EMPLOYEE     Required
                            When (OSH-FIRST-AID-BY != Zeroes )

                            OSH-COMPANY           -> EMP-COMPANY
                            OSH-FIRST-AID-BY      -> EMP-EMPLOYEE

Hospital       PCODES       Required
                            When (OSH-HOSPITAL != Spaces )

                            "HO"                  -> PCO-TYPE
                            OSH-HOSPITAL          -> PCO-CODE

Illness        PCODES       Required
                            When OSH-ILL-INJ = "IL"

                            "IL"                  -> PCO-TYPE
                            OSH-ILLNESS           -> PCO-CODE

Illness Type   PCODES       Required
                            When (OSH-ILLNESS != Spaces )

                            "IL"                  -> PCO-TYPE
                            OSH-ILLNESS           -> PCO-CODE

Incident       PCODES       Required
                            When (OSH-INCIDENT != Spaces )

                            "IN"                  -> PCO-TYPE
                            OSH-INCIDENT          -> PCO-CODE

Incident Cat   PCODES       Required
                            When (OSH-INCID-CAT != Spaces )

                            "IC"                  -> PCO-TYPE
                            OSH-INCID-CAT         -> PCO-CODE

Incident Outcm PCODES       Required
                            When (OSH-OUTCOME != Spaces )

                            "IO"                  -> PCO-TYPE
                            OSH-OUTCOME           -> PCO-CODE

Incident Stat  PCODES       Required
                            When (OSH-INCID-STATUS != Spaces )

                            "IS"                  -> PCO-TYPE
                            OSH-INCID-STATUS      -> PCO-CODE

Job Code       JOBCODE      Required
                            When OSH-JOB-CODE != Spaces

                            OSH-COMPANY           -> JBC-COMPANY
                            OSH-JOB-CODE          -> JBC-JOB-CODE

Location       PCODES       Required
                            When OSH-LOCAT-CODE != Spaces

                            "LO"                  -> PCO-TYPE
                            OSH-LOCAT-CODE        -> PCO-CODE

Pa Employee    PAEMPLOYEE   Required

                            OSH-COMPANY           -> PEM-COMPANY
                            OSH-EMPLOYEE          -> PEM-EMPLOYEE

Physician      PCODES       Required
                            When OSH-PHYSICIAN != Spaces

                            "PY"                  -> PCO-TYPE
                            OSH-PHYSICIAN         -> PCO-CODE

Prior Incident OSHA         Required
                            When OSH-PRIOR-SEQ-NBR != Zeroes

                            OSH-COMPANY           -> OSH-COMPANY
                            OSH-EMPLOYEE          -> OSH-EMPLOYEE
                            OSH-PRIOR-ESTAB       -> OSH-ESTABLISHMENT
                            OSH-PRIOR-SEQ-NBR     -> OSH-SEQ-NBR

Process Level  PRSYSTEM     Required
                            When OSH-PROCESS-LEVEL != Spaces

                            OSH-COMPANY           -> PRS-COMPANY
                            OSH-PROCESS-LEVEL     -> PRS-PROCESS-LEVEL

Report By      EMPLOYEE     Required
                            When (OSH-REPORTS-BY != Zeroes )

                            OSH-COMPANY           -> EMP-COMPANY
                            OSH-REPORTS-BY        -> EMP-EMPLOYEE

Report To      EMPLOYEE     Required
                            When (OSH-REPORTS-TO != Zeroes )

                            OSH-COMPANY           -> EMP-COMPANY
                            OSH-REPORTS-TO        -> EMP-EMPLOYEE

Severity       PCODES       Required
                            When OSH-SEVERITY != Spaces

                            "IE"                  -> PCO-TYPE
                            OSH-SEVERITY          -> PCO-CODE

Super Emp      EMPLOYEE     Required
                            When (OSH-SUPERVISOR-EMP != Zeroes )

                            OSH-COMPANY           -> EMP-COMPANY
                            OSH-SUPERVISOR-EMP    -> EMP-EMPLOYEE

User2          PCODES       Required
                            When OSH-USER2 != Spaces

                            "I2"                  -> PCO-TYPE
                            OSH-USER2             -> PCO-CODE

User3          PCODES       Required
                            When OSH-USER3 != Spaces

                            "I3"                  -> PCO-TYPE
                            OSH-USER3             -> PCO-CODE

Wit Country    INSTCTRYCD   Required
                            When (OSH-WIT-CNTRY-CD != Spaces )

                            OSH-WIT-CNTRY-CD      -> INT-COUNTRY-CODE

Witness        EMPLOYEE     Required
                            When (OSH-WITNESS != Zeroes )

                            OSH-COMPANY           -> EMP-COMPANY
                            OSH-WITNESS           -> EMP-EMPLOYEE

                         OSHA FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Comments       PACOMMENTS   Delete Cascades

                            OSH-COMPANY           -> PAC-COMPANY
                            Zeroes                -> PAC-EMP-APP
                            "OS"                  -> PAC-CMT-TYPE
                            OSH-EMPLOYEE          -> PAC-EMPLOYEE
                            Spaces                -> PAC-JOB-CODE
                            OSH-ESTABLISHMENT     -> PAC-ACTION-CODE
                            OSH-SEQ-NBR           -> PAC-LN-NBR
                                                     PAC-SEQ-NBR

Costs          PAINCICOST   Delete Cascades

                            OSH-COMPANY           -> PAI-COMPANY
                            OSH-EMPLOYEE          -> PAI-EMPLOYEE
                            OSH-ESTABLISHMENT     -> PAI-ESTABLISHMENT
                            OSH-SEQ-NBR           -> PAI-INCIDENT-NBR
                                                     PAI-EFFECT-DATE
                                                     PAI-SEQ-NBR

Establish Dtl  OSHESTDTL
                            Valid When (OSH-ESTABLISHMENT != Spaces )

                            OSH-COMPANY           -> ODT-COMPANY
                            OSH-ESTABLISHMENT     -> ODT-ESTABLISHMENT
                                                     ODT-PROCESS-LEVEL
                                                     ODT-DEPARTMENT
                                                     ODT-LOCAT-CODE

Follow Up      PAFOLLOWUP   Delete Cascades

                            OSH-COMPANY           -> PAF-COMPANY
                            OSH-EMPLOYEE          -> PAF-EMPLOYEE
                            OSH-ESTABLISHMENT     -> PAF-ESTABLISHMENT
                            OSH-SEQ-NBR           -> PAF-INCIDENT-NBR
                                                     PAF-EFFECT-DATE
                                                     PAF-SEQ-NBR