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     PA49.1
PA49.3    PA549     HR170     HR70.1    PA91.1

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

OSH-SHIFT              Numeric 1                                 PA290   PA372
Element: Shift         This field contains the shift worked      PA490   PA590
                       when the incident occurred.               PA90.1
                       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)                    PA290   PA372
How Incident           Occurs 2 Times                            PA490   PA590
Occurred               This field contains the description of    PA90.1
                       how the incident occurred.

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

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

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

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

OSH-ILLNESS-TYPE       Alpha 2                                   PA290   PA372
Element: Illness Type  This field contains the type of illness.  PA490   PA590
                       DU = Dust Disease of the Lungs            PA90.1
                       O = All Other Occupational Illness
                       P = Poisoning
                       PA = Disorder From Physical Agent
                       RE = Respiratory Due to Toxins
                       SK = Skin Disease or Disorder
                       TR = Disorder from Repeated Trauma

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

OSH-EMP-STATUS         Alpha 2                                   PA290   PA372
Element: Employee StatuContains the employee's status when       PA490   PA590
                       incident occurred.                        PA90.1
                       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                                 PA290   PA372
Element: Supervisor EmpContains the supervisor to whom the       PA490   PA590
                       employee reported when the incident       PA90.1
                       occurred.

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

OSH-USER-ID            Alpha 10  (Lower Case)                    PA290   PA372
Element: User                                                    PA490   PA590
                                                                 PA90.1  PA90.3

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

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

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

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

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

OSH-CURR-ND            Numeric 1                                 PA290   PA372
Account Currency                                                 PA490   PA590
Code                                                             PA90.1  PA90.3

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

OSH-BASE-CURRENCY      Alpha 5                                   PA290   PA372
To Company Base        Contains the company base currency.       PA490   PA590
Currency                                                         PA90.1  PA90.3

OSH-BASE-ND            Numeric 1                                 PA290   PA372
Account Currency                                                 PA490   PA590
Code                                                             PA90.1  PA90.3

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

                         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                                                PA290   PA372
          ESTABLISHMENT                                          PA490   PA590
          SEQ-NBR*                                               PA90.1
          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  PCODES       Required
                            When (OSH-ESTABLISHMENT != Spaces )

                            "ET"                  -> PCO-TYPE
                            OSH-ESTABLISHMENT     -> PCO-CODE

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
                            Spaces                -> 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

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