OSHA

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 PA92.1


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSH-COMPANY
Element: Company Hr
Numeric 4
Contains the company number that represents an established company.
PA290 PA372
PA490 PA590
PA90.1
OSH-EMPLOYEE
Element: Employee
Numeric 9
An employee number is assigned to each person employed by the company. It is used to correlate all information related to the employee.
PA290 PA372
PA490 PA590
PA90.1
OSH-SEQ-NBR
Element: Seq Nbr
Numeric 4
Sequence number.
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the date of injury or illness.
PA290 PA372
PA490 PA590
PA90.1
OSH-ILL-INJ
Element: Ill Inj
Alpha 2
This field contains the illness or injury indicator.
IL = Illness
IN = Injury
PA290 PA372
PA490 PA590
PA90.1
OSH-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the illness or injury.
PA290 PA372
PA490 PA590
PA90.1
OSH-JOB-CODE
Element: Job Code
Alpha 9
This field contains the job code performed when the incident occurred. The job code must be valid in JOBCODE.
PA290 PA372
PA490 PA590
PA90.1
OSH-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
This field contains the employee's process level or the process level where the incident occurred.
PA290 PA372
PA490 PA590
PA90.1
OSH-DEPARTMENT
Element: Department
Alpha 5
This field contains the employee's department or the department where the incident occurred.
PA290 PA372
PA490 PA590
PA90.1
OSH-AGE
Element: Age
Numeric 2
This field contains the employee's age when the incident occurred.
PA290 PA372
PA490 PA590
PA90.1
OSH-SEX
Element: Sex
Alpha 1
Employee's gender when incident occurred.
F = Female
M = Male
PA290 PA372
PA490 PA590
PA90.1
OSH-PHY-LST-NAME
Element: Phy Lst Name
Alpha 15 (Lower Case)
This field contains the physician's last name.
PA290 PA372
PA490 PA590
PA90.1
OSH-PHY-FST-NAME
Element: Phy Fst Name
Alpha 14 (Lower Case)
This field contains the physician's first name.
PA290 PA372
PA490 PA590
PA90.1
OSH-PHY-MID-INIT
Element: Phy Mid Init
Alpha 1
This field contains the physician's middle initial.
PA290 PA372
PA490 PA590
PA90.1
OSH-HOSP-NAME
Element: Hosp Name
Alpha 30 (Lower Case)
This field contains the hospital name.
PA290 PA372
PA490 PA590
PA90.1
OSH-DEATH
Element: Death
Alpha 1
This field indicates if the incident resulted in death.
N = No
Y = Yes
PA290 PA372
PA490 PA590
PA90.1
OSH-DEAD-DATE
Element: Dead Date
Numeric 8 (yyyymmdd)
This field contains the date of death.
PA290 PA372
PA490 PA590
PA90.1
OSH-CMP-PREM
Element: Cmp Prem
Alpha 1
This field indicates if the incident occurred on company premises.
N = No
Y = Yes
PA290 PA372
PA490 PA590
PA90.1
OSH-LOCAT-CODE
Element: Locat Code
Alpha 10
This field contains the location of the incident. The location must be valid in PCODES.
PA290 PA372
PA490 PA590
PA90.1
OSH-SHIFT
Element: Shift
Numeric 1
This field contains the shift worked 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
PA290 PA372
PA490 PA590
PA90.1
OSH-HOW
Element: How
Alpha 50 (Lower Case)
Occurs 2 Times
This field contains the description of how the incident occurred.
PA290 PA372
PA490 PA590
PA90.1
OSH-BODY-PART
Element: Body Part
Alpha 50 (Lower Case)
This field contains the description of the body part(s) affected by the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-OBJ-SUBS
Element: Obj Subs
Alpha 50 (Lower Case)
This field contains the description of the object or substance.
PA290 PA372
PA490 PA590
PA90.1
OSH-DAYS-OUT
Element: Days Out
Numeric 3
This field contains the number of days away from work.
PA290 PA372
PA490 PA590
PA90.1
OSH-DAYS-REST
Element: Days Rest
Numeric 3
This field contains the number of days restricted from certain types of work.
PA290 PA372
PA490 PA590
PA90.1
OSH-ILLNESS-TYPE
Element: Illness Type
Alpha 2
This field contains the type of illness.
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
PA290 PA372
PA490 PA590
PA90.1
OSH-WC-FLAG
Element: Wc Flag
Alpha 1
This field indicates whether the incident was reportable with regard to workers compensation.
N = No
Y = Yes
PA290 PA372
PA490 PA590
PA90.1
OSH-OSHA-FLAG
Element: Osha Flag
Alpha 1
Reserved for future development.
N = No
Y = Yes
PA290 PA372
PA490 PA590
PA90.1
OSH-INCIDENT
Element: Incident
Alpha 10
Contains user-defined incident information.
PA290 PA372
PA490 PA590
PA90.1
OSH-ILLNESS
Element: Illness
Alpha 10
Contains user-defined illness information.
PA290 PA372
PA490 PA590
PA90.1
OSH-FULL-NAME
Element: Full Name
Derived
Reserved for future development.
OSH-ESTABLISHMENT
Element: Establishment
Alpha 10
Contains the establishment where incident occurred.
PA290 PA372
PA490 PA590
PA90.1
OSH-INCID-STATUS
Element: Incid Status
Alpha 10
Contains the user-defined incident status.
PA290 PA372
PA490 PA590
PA90.1
OSH-OUTCOME
Element: Outcome
Alpha 10
Contains the user-defined incident outcome.
PA290 PA372
PA490 PA590
PA90.1
OSH-COST
Element: Cost
Signed 11.2
Contains the incident cost.
PA290 PA372
PA490 PA590
PA90.1 PA90.3
OSH-INCID-CAT
Element: Incid Cat
Alpha 10
Contains the user-defined incident category.
PA290 PA372
PA490 PA590
PA90.1
OSH-WC-CLAIM
Element: Wc Claim
Alpha 15
Contains the workers compensation claim number.
PA290 PA372
PA490 PA590
PA90.1
OSH-GOVT-FLAG
Element: Govt Flag
Alpha 1
Indicates whether case must be reported to the government.
Y = Yes
N = No
PA290 PA372
PA490 PA590
PA90.1
OSH-GOVT-CASE
Element: Govt Case
Numeric 8
Contains the government case number.
PA290 PA372
PA490 PA590
PA90.1
OSH-PRIOR-ESTAB
Element: Prior Estab
Alpha 10
If the incident is related to a prior incident, this field contains the establishment where the prior incident occurred.
PA290 PA372
PA490 PA590
PA90.1
OSH-PRIOR-SEQ-NBR
Element: Prior Seq Nbr
Numeric 4
If the incident is related to a prior incident, this field contains the prior report number.
PA290 PA372
PA490 PA590
PA90.1
OSH-BODY-PART-CD
Element: Body Part Cd
Alpha 10
Contains the user-defined body part that was injured by the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-REPORTS-TO
Element: Reports To
Numeric 9
Contains the employee to whom the incident was reported.
PA290 PA372
PA490 PA590
PA90.1
OSH-REPORT-TO-NAME
Element: Report To Name
Alpha 30 (Lower Case)
Contains the employee or individual to whom the incident was reported.
PA290 PA372
PA490 PA590
PA90.1
OSH-REPORTS-BY
Element: Reports By
Numeric 9
Contains the employee who reported the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-REPORT-BY-NAME
Element: Report By Name
Alpha 30 (Lower Case)
Contains the employee or individual who reported the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-WITNESS
Element: Witness
Numeric 9
Contains the employee who witnessed the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-WIT-NAME
Element: Wit Name
Alpha 30 (Lower Case)
Contains the employee or individual who witnessed the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-WIT-ADDR1
Element: Wit Addr1
Alpha 30 (Lower Case)
Contains the first line of the witness's address.
PA290 PA372
PA490 PA590
PA90.1
OSH-WIT-CITY
Element: Wit City
Alpha 58 (Lower Case)
Contains the witness's city.
PA290 PA372
PA490 PA590
PA90.1
OSH-WIT-STATE
Element: Wit State
Alpha 2
Contains the witness's state.
PA290 PA372
PA490 PA590
PA90.1
OSH-WIT-ZIP
Element: Wit Zip
Alpha 10
Contains the witness's postal code.
PA290 PA372
PA490 PA590
PA90.1
OSH-WIT-CNTRY-CD
Element: Wit Cntry Cd
Alpha 2
PA290 PA372
PA490 PA590
PA90.1
OSH-WIT-PHN-CNTRY
Element: Wit Phn Cntry
Alpha 6
Contains the witness's telephone country code.
PA290 PA372
PA490 PA590
PA90.1
OSH-WIT-PHONE-NBR
Element: Wit Phone Nbr
Alpha 15
Contains the witness's telephone number.
PA290 PA372
PA490 PA590
PA90.1
OSH-WIT-PHONE-EXT
Element: Wit Phone Ext
Alpha 5
Contains the witness's telephone extension.
PA290 PA372
PA490 PA590
PA90.1
OSH-EMP-STATUS
Element: Emp Status
Alpha 2
Contains the employee's status when incident occurred.
1 = Full Time
2 = Part Time
3 = Casual
4 = Seasonal
5 = Apprentice
6 = Student
7 = Learner
8 = Volunteer
9 = Other
PA290 PA372
PA490 PA590
PA90.1
OSH-SUPERVISOR-EMP
Element: Supervisor Emp
Numeric 9
Contains the supervisor to whom the employee reported when the incident occurred.
PA290 PA372
PA490 PA590
PA90.1
OSH-SUP-NAME
Element: Sup Name
Alpha 30 (Lower Case)
Contains the name of the supervisor to whom the employee reported when the incident occurred.
PA290 PA372
PA490 PA590
PA90.1
OSH-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
Contains the address where the incident took place.
PA290 PA372
PA490 PA590
PA90.1
OSH-CITY
Element: Hr City
Alpha 58 (Lower Case)
Contains the city where the incident took place.
PA290 PA372
PA490 PA590
PA90.1
OSH-STATE
Element: State
Alpha 2
Contains the state where the incident took place.
PA290 PA372
PA490 PA590
PA90.1
OSH-ZIP
Element: Zip
Alpha 10
Contains the postal code where the incident took place.
PA290 PA372
PA490 PA590
PA90.1
OSH-FIRST-AID-BY
Element: First Aid By
Numeric 9
Contains the employee who provided first aid.
PA290 PA372
PA490 PA590
PA90.1
OSH-FIRST-AID-NAME
Element: First Aid Name
Alpha 30 (Lower Case)
Contains the employee or individual who provided first aid.
PA290 PA372
PA490 PA590
PA90.1
OSH-PHYSICIAN
Element: Physician
Alpha 10
Contains the physician who treated the employee.
PA290 PA372
PA490 PA590
PA90.1
OSH-PATIENT-FLAG
Element: Patient Flag
Alpha 1
Indicates whether the employee was hospitalized as a result of the incident.
N = No
Y = Yes
PA290 PA372
PA490 PA590
PA90.1
OSH-HOSPITAL
Element: Hospital
Alpha 10
Contains the user-defined hospital where the employee was treated after the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-TIME-START-WK
Element: Time Start Wk
Numeric 6 (hhmmss)
Contains the employee's normal work start time.
PA290 PA372
PA490 PA590
PA90.1
OSH-TIME-END-WK
Element: Time End Wk
Numeric 6 (hhmmss)
Contains the employee's normal work stop time.
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE-INJURY
Element: Date Injury
Numeric 8 (yyyymmdd)
Contains the date the incident took place.
PA290 PA372
PA490 PA590
PA90.1
OSH-TIME-INJURY
Element: Time Injury
Numeric 6 (hhmmss)
Contains the time the incident took place.
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE-LAST-WORK
Element: Date Last Work
Numeric 8 (yyyymmdd)
Contains the last date the employee worked after the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-TIME-LAST-WORK
Element: Time Last Work
Numeric 6 (hhmmss)
Contains the last time the employee worked after the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE-OUT
Element: Date Out
Numeric 8 (yyyymmdd)
Contains the first date the employee did not attend work due to the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE-NOTIFIED1
Element: Date Notified1
Numeric 8 (yyyymmdd)
Contains the date the employer was notified of the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-TIME-NOTIFIED1
Element: Time Notified1
Numeric 6 (hhmmss)
Contains the time the employer was notified of the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE-NOTIFIED2
Element: Date Notified2
Numeric 8 (yyyymmdd)
Contains the date the employer was notified of lost time.
PA290 PA372
PA490 PA590
PA90.1
OSH-TIME-NOTIFIED2
Element: Time Notified2
Numeric 6 (hhmmss)
Contains the time the employer was notified of lost time.
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE-1
Element: Date 1
Numeric 8 (yyyymmdd)
If the employee returned to work after the incident, contains the first date of the date range.
PA290 PA372
PA490 PA590
PA90.1
OSH-TIME-1
Element: Time 1
Numeric 6 (hhmmss)
If the employee returned to work after the incident, contains the start time.
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE-2
Element: Date 2
Numeric 8 (yyyymmdd)
If the employee returned to work after the incident, contains the last date of the date range.
PA290 PA372
PA490 PA590
PA90.1
OSH-TIME-2
Element: Time 2
Numeric 6 (hhmmss)
If the employee returned to work after the incident, contains the ending time.
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE-RETURNED
Element: Date Returned
Numeric 8 (yyyymmdd)
Contains the date the employee returned to work after the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-TIME-RETURNED
Element: Time Returned
Numeric 6 (hhmmss)
Contains the time the employee returned to work after the incident.
PA290 PA372
PA490 PA590
PA90.1
OSH-HOURS-FLAG
Element: Hours Flag
Alpha 1
Indicates whether the employee was absent from work due to the incident.
N = No
Y = Yes
PA290 PA372
PA490 PA590
PA90.1
OSH-WORK-FLAG
Element: Work Flag
Alpha 1
Indicates whether the employee is able to perform other duties at work.
N = No
Y = Yes
PA290 PA372
PA490 PA590
PA90.1
OSH-WAGES-FLAG
Element: Wages Flag
Alpha 1
Indicates whether the employee will earn reduced wages due to performing other work duties.
N = No
Y = Yes
PA290 PA372
PA490 PA590
PA90.1
OSH-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
PA290 PA372
PA490 PA590
PA90.1 PA90.3
OSH-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA290 PA372
PA490 PA590
PA90.1 PA90.3
OSH-USER-ID
Element: User
Alpha 10 (Lower Case)
PA290 PA372
PA490 PA590
PA90.1 PA90.3
OSH-SEVERITY
Element: Severity
Alpha 10
Contains the user-defined incident severity.
PA290 PA372
PA490 PA590
PA90.1
OSH-USER-FIELD1
Element: User Field1
Alpha 30
This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.
PA290 PA372
PA490 PA590
PA90.1
OSH-USER2
Element: User2
Alpha 10
Contains the second field of user-defined information.
PA290 PA372
PA490 PA590
PA90.1
OSH-USER3
Element: User3
Alpha 10
Contains the third field of user-defined information.
PA290 PA372
PA490 PA590
PA90.1
OSH-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency in which the incident costs are recorded.
PA290 PA372
PA490 PA590
PA90.1 PA90.3
OSH-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA290 PA372
PA490 PA590
PA90.1 PA90.3
OSH-COUNTRY-CODE
Element: Country Code
Alpha 2
Contains the country where the incident took place.
PA290 PA372
PA490 PA590
PA90.1
OSH-BASE-CURRENCY
Element: Base Currency
Alpha 5
Contains the company base currency.
PA290 PA372
PA490 PA590
PA90.1 PA90.3
OSH-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
PA290 PA372
PA490 PA590
PA90.1 PA90.3
OSH-BASE-AMOUNT
Element: Base Amt
Signed 15.2
Contains the incident costs in the company's base currency.
PA290 PA372
PA490 PA590
PA90.1 PA90.3
OSH-INCIDENT-SITE
Element: Incident Site
Alpha 30 (Lower Case)
PA290 PA372
PA490 PA590
PA90.1
OSH-REPORT-COMP-BY
Element: Report Comp By
Numeric 9
PA290 PA372
PA490 PA590
PA90.1
OSH-RPT-COMP-NAME
Element: Rpt Comp Name
Alpha 30 (Lower Case)
PA290 PA372
PA490 PA590
PA90.1
OSH-RPT-COMP-DATE
Element: Rpt Comp Date
Numeric 8 (yyyymmdd)
PA290 PA372
PA490 PA590
PA90.1
OSH-EMERGENCY-ROOM
Element: Emergency Room
Alpha 1
PA290 PA372
PA490 PA590
PA90.1
OSH-SHARP-DEVICE
Element: Sharp Device
Alpha 10
PA290 PA372
PA490 PA590
PA90.1
OSH-BRND-SHARP-DEV
Element: Brnd Sharp Dev
Alpha 10
PA290 PA372
PA490 PA590
PA90.1


OSHA FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSHSET1 COMPANY
EMPLOYEE
ESTABLISHMENT
SEQ-NBR
HOSH.1 HR11.1
HR90.1 PA115
PA149 PA248
PA249 PA290
PA372 PA49.1
PA49.3 PA490
PA549 PA590
PA90.1 PA90.2
PA90.3
OSHSET2 COMPANY
EMPLOYEE
DATE
ESTABLISHMENT
SEQ-NBR
KeyChange
HR170 HR70.1
PA91.1
OSHSET3 COMPANY
ESTABLISHMENT
SEQ-NBR*
EMPLOYEE
PA290 PA372
PA490 PA590
PA90.1 PA92.1


OSHA FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
  PAC-DATE
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


File created: Thu Jun 09 02:24:51 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.