OSHA

OSHA Incident History

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

REFERENCED BY
HR90.1 PA149 PA248 PA249 PA49.1 PA49.3
PA549


UPDATED BY
PA290 PA372 PA490 PA590 PA90.1 PA90.3
HOSH.1 HR11.1 PA115 HR170 HR70.1 PA91.1
PA92.1

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 18 (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: City		Alpha 18 (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
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: Wed Jun 08 20:50:22 2016

Home
Contact Us



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