OSHA – OSHA Incident History

System
Personnel (PA)
Prefix
OSH
Primary key
COMPANY, EMPLOYEE, ESTABLISHMENT, SEQ-NBR
Fields
108
Updated by
8 programs
Referenced by
12 programs

OSHA is the OSHA Incident History table in Lawson Personnel (prefix OSH). It is indexed by COMPANY, EMPLOYEE, ESTABLISHMENT, SEQ-NBR (OSHSET1); alternate indexes: OSHSET2 and OSHSET3. It is related 1:1 to CUCODES, PCODES, PRSYSTEM, INSTCTRYCD, DEPTCODE, EMPLOYEE, OSHESTAB, JOBCODE and 2 more and 1:M to PACOMMENTS, PAINCICOST, OSHESTDTL and PAFOLLOWUP. It is updated by HR11.1, PA115, PA290, PA372, PA490, PA590, PA90.1 and PA90.3 and referenced by HOSH.1, HR170, HR70.1, HR90.1, PA149, PA248, PA249, PA49.1 and 4 more. The table has 108 fields, 3 indexes and 34 documented relations.

About OSHA

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

Fields (108)

Column = COBOL field name without the OSH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#OSH-COMPANY PK
COMPANY		Numeric 4Contains the company number that represents an established company.PA290, PA372, PA490, PA590, PA90.1
#OSH-EMPLOYEE PK
EMPLOYEE		Numeric 9An 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 PK
SEQ_NBR		Numeric 4Sequence number.PA290, PA372, PA490, PA590, PA90.1
#OSH-DATE SET2
DATE		Numeric 8 (yyyymmdd)This field contains the date of injury or illness.PA290, PA372, PA490, PA590, PA90.1
#OSH-ILL-INJ
ILL_INJ		Alpha 2This field contains the illness or injury indicator.
  • IL Illness
  • IN Injury
PA290, PA372, PA490, PA590, PA90.1
#OSH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the description of the illness or injury.PA290, PA372, PA490, PA590, PA90.1
#OSH-JOB-CODE
JOB_CODE		Alpha 9This 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
PROCESS_LEVEL		Alpha 5This field contains the employee's process level or the process level where the incident occurred.PA290, PA372, PA490, PA590, PA90.1
#OSH-DEPARTMENT
DEPARTMENT		Alpha 5This field contains the employee's department or the department where the incident occurred.PA290, PA372, PA490, PA590, PA90.1
#OSH-AGE
AGE		Numeric 2This field contains the employee's age when the incident occurred.PA290, PA372, PA490, PA590, PA90.1
#OSH-SEX
SEX		Alpha 1Employee's gender when incident occurred.
  • F Female
  • M Male
PA290, PA372, PA490, PA590, PA90.1
#OSH-PHY-LST-NAME
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
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
PHY_MID_INIT		Alpha 1This field contains the physician's middle initial.PA290, PA372, PA490, PA590, PA90.1
#OSH-HOSP-NAME
HOSP_NAME		Alpha 30 (Lower Case)This field contains the hospital name.PA290, PA372, PA490, PA590, PA90.1
#OSH-DEATH
DEATH		Alpha 1This field indicates if the incident resulted in death.
  • N No
  • Y Yes
PA290, PA372, PA490, PA590, PA90.1
#OSH-DEAD-DATE
DEAD_DATE		Numeric 8 (yyyymmdd)This field contains the date of death.PA290, PA372, PA490, PA590, PA90.1
#OSH-CMP-PREM
CMP_PREM		Alpha 1This field indicates if the incident occurred on company premises.
  • N No
  • Y Yes
PA290, PA372, PA490, PA590, PA90.1
#OSH-LOCAT-CODE
LOCAT_CODE		Alpha 10This field contains the location of the incident. The location must be valid in PCODES.PA290, PA372, PA490, PA590, PA90.1
#OSH-SHIFT
SHIFT		Numeric 1This 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
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
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
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
DAYS_OUT		Numeric 3This field contains the number of days away from work.PA290, PA372, PA490, PA590, PA90.1
#OSH-DAYS-REST
DAYS_REST		Numeric 3This field contains the number of days restricted from certain types of work.PA290, PA372, PA490, PA590, PA90.1
#OSH-ILLNESS-TYPE
ILLNESS_TYPE		Alpha 2This 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
WC_FLAG		Alpha 1This 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
OSHA_FLAG		Alpha 1Reserved for future development.
  • N No
  • Y Yes
PA290, PA372, PA490, PA590, PA90.1
#OSH-INCIDENT
INCIDENT		Alpha 10Contains user-defined incident information.PA290, PA372, PA490, PA590, PA90.1
#OSH-ILLNESS
ILLNESS		Alpha 10Contains user-defined illness information.PA290, PA372, PA490, PA590, PA90.1
#OSH-FULL-NAME
FULL_NAME		DerivedReserved for future development.—
#OSH-ESTABLISHMENT PK
ESTABLISHMENT		Alpha 10Contains the establishment where incident occurred.PA290, PA372, PA490, PA590, PA90.1
#OSH-INCID-STATUS
INCID_STATUS		Alpha 10Contains the user-defined incident status.PA290, PA372, PA490, PA590, PA90.1
#OSH-OUTCOME
OUTCOME		Alpha 10Contains the user-defined incident outcome.PA290, PA372, PA490, PA590, PA90.1
#OSH-COST
COST		Signed 11.2Contains the incident cost.PA290, PA372, PA490, PA590, PA90.1, PA90.3
#OSH-INCID-CAT
INCID_CAT		Alpha 10Contains the user-defined incident category.PA290, PA372, PA490, PA590, PA90.1
#OSH-WC-CLAIM
WC_CLAIM		Alpha 15Contains the workers compensation claim number.PA290, PA372, PA490, PA590, PA90.1
#OSH-GOVT-FLAG
GOVT_FLAG		Alpha 1Indicates whether case must be reported to the government.
  • Y Yes
  • N No
PA290, PA372, PA490, PA590, PA90.1
#OSH-GOVT-CASE
GOVT_CASE		Numeric 8Contains the government case number.PA290, PA372, PA490, PA590, PA90.1
#OSH-PRIOR-ESTAB
PRIOR_ESTAB		Alpha 10If 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
PRIOR_SEQ_NBR		Numeric 4If 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
BODY_PART_CD		Alpha 10Contains the user-defined body part that was injured by the incident.PA290, PA372, PA490, PA590, PA90.1
#OSH-REPORTS-TO
REPORTS_TO		Numeric 9Contains the employee to whom the incident was reported.PA290, PA372, PA490, PA590, PA90.1
#OSH-REPORT-TO-NAME
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
REPORTS_BY		Numeric 9Contains the employee who reported the incident.PA290, PA372, PA490, PA590, PA90.1
#OSH-REPORT-BY-NAME
REPORT_BY_NAME		Alpha 30 (Lower Case)Contains the employee or individual who reported the incident.PA290, PA372, PA490, PA590, PA90.1
#OSH-WITNESS
WITNESS		Numeric 9Contains the employee who witnessed the incident.PA290, PA372, PA490, PA590, PA90.1
#OSH-WIT-NAME
WIT_NAME		Alpha 30 (Lower Case)Contains the employee or individual who witnessed the incident.PA290, PA372, PA490, PA590, PA90.1
#OSH-WIT-ADDR1
WIT_ADDR1		Alpha 30 (Lower Case)Contains the first line of the witness's address.PA290, PA372, PA490, PA590, PA90.1
#OSH-WIT-CITY
WIT_CITY		Alpha 58 (Lower Case)Contains the witness's city.PA290, PA372, PA490, PA590, PA90.1
#OSH-WIT-STATE
WIT_STATE		Alpha 2Contains the witness's state.PA290, PA372, PA490, PA590, PA90.1
#OSH-WIT-ZIP
WIT_ZIP		Alpha 10Contains the witness's postal code.PA290, PA372, PA490, PA590, PA90.1
#OSH-WIT-CNTRY-CD
WIT_CNTRY_CD		Alpha 2—PA290, PA372, PA490, PA590, PA90.1
#OSH-WIT-PHN-CNTRY
WIT_PHN_CNTRY		Alpha 6Contains the witness's telephone country code.PA290, PA372, PA490, PA590, PA90.1
#OSH-WIT-PHONE-NBR
WIT_PHONE_NBR		Alpha 15Contains the witness's telephone number.PA290, PA372, PA490, PA590, PA90.1
#OSH-WIT-PHONE-EXT
WIT_PHONE_EXT		Alpha 5Contains the witness's telephone extension.PA290, PA372, PA490, PA590, PA90.1
#OSH-EMP-STATUS
EMP_STATUS		Alpha 2Contains 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
SUPERVISOR_EMP		Numeric 9Contains the supervisor to whom the employee reported when the incident occurred.PA290, PA372, PA490, PA590, PA90.1
#OSH-SUP-NAME
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
ADDR1		Alpha 30 (Lower Case)Contains the address where the incident took place.PA290, PA372, PA490, PA590, PA90.1
#OSH-CITY
CITY		Alpha 58 (Lower Case)Contains the city where the incident took place.PA290, PA372, PA490, PA590, PA90.1
#OSH-STATE
STATE		Alpha 2Contains the state where the incident took place.PA290, PA372, PA490, PA590, PA90.1
#OSH-ZIP
ZIP		Alpha 10Contains the postal code where the incident took place.PA290, PA372, PA490, PA590, PA90.1
#OSH-FIRST-AID-BY
FIRST_AID_BY		Numeric 9Contains the employee who provided first aid.PA290, PA372, PA490, PA590, PA90.1
#OSH-FIRST-AID-NAME
FIRST_AID_NAME		Alpha 30 (Lower Case)Contains the employee or individual who provided first aid.PA290, PA372, PA490, PA590, PA90.1
#OSH-PHYSICIAN
PHYSICIAN		Alpha 10Contains the physician who treated the employee.PA290, PA372, PA490, PA590, PA90.1
#OSH-PATIENT-FLAG
PATIENT_FLAG		Alpha 1Indicates whether the employee was hospitalized as a result of the incident.
  • N No
  • Y Yes
PA290, PA372, PA490, PA590, PA90.1
#OSH-HOSPITAL
HOSPITAL		Alpha 10Contains the user-defined hospital where the employee was treated after the incident.PA290, PA372, PA490, PA590, PA90.1
#OSH-TIME-START-WK
TIME_START_WK		Numeric 6 (hhmmss)Contains the employee's normal work start time.PA290, PA372, PA490, PA590, PA90.1
#OSH-TIME-END-WK
TIME_END_WK		Numeric 6 (hhmmss)Contains the employee's normal work stop time.PA290, PA372, PA490, PA590, PA90.1
#OSH-DATE-INJURY
DATE_INJURY		Numeric 8 (yyyymmdd)Contains the date the incident took place.PA290, PA372, PA490, PA590, PA90.1
#OSH-TIME-INJURY
TIME_INJURY		Numeric 6 (hhmmss)Contains the time the incident took place.PA290, PA372, PA490, PA590, PA90.1
#OSH-DATE-LAST-WORK
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
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
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
DATE_NOTIFIED1		Numeric 8 (yyyymmdd)Contains the date the employer was notified of the incident.PA290, PA372, PA490, PA590, PA90.1
#OSH-TIME-NOTIFIED1
TIME_NOTIFIED1		Numeric 6 (hhmmss)Contains the time the employer was notified of the incident.PA290, PA372, PA490, PA590, PA90.1
#OSH-DATE-NOTIFIED2
DATE_NOTIFIED2		Numeric 8 (yyyymmdd)Contains the date the employer was notified of lost time.PA290, PA372, PA490, PA590, PA90.1
#OSH-TIME-NOTIFIED2
TIME_NOTIFIED2		Numeric 6 (hhmmss)Contains the time the employer was notified of lost time.PA290, PA372, PA490, PA590, PA90.1
#OSH-DATE-1
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
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
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
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
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
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
HOURS_FLAG		Alpha 1Indicates whether the employee was absent from work due to the incident.
  • N No
  • Y Yes
PA290, PA372, PA490, PA590, PA90.1
#OSH-WORK-FLAG
WORK_FLAG		Alpha 1Indicates whether the employee is able to perform other duties at work.
  • N No
  • Y Yes
PA290, PA372, PA490, PA590, PA90.1
#OSH-WAGES-FLAG
WAGES_FLAG		Alpha 1Indicates 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
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
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
USER_ID		Alpha 10 (Lower Case)—PA290, PA372, PA490, PA590, PA90.1, PA90.3
#OSH-SEVERITY
SEVERITY		Alpha 10Contains the user-defined incident severity.PA290, PA372, PA490, PA590, PA90.1
#OSH-USER-FIELD1
USER_FIELD1		Alpha 30This 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
USER2		Alpha 10Contains the second field of user-defined information.PA290, PA372, PA490, PA590, PA90.1
#OSH-USER3
USER3		Alpha 10Contains the third field of user-defined information.PA290, PA372, PA490, PA590, PA90.1
#OSH-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the incident costs are recorded.PA290, PA372, PA490, PA590, PA90.1, PA90.3
#OSH-CURR-ND
CURR_ND		Numeric 1The 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
COUNTRY_CODE		Alpha 2Contains the country where the incident took place.PA290, PA372, PA490, PA590, PA90.1
#OSH-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company base currency.PA290, PA372, PA490, PA590, PA90.1, PA90.3
#OSH-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.PA290, PA372, PA490, PA590, PA90.1, PA90.3
#OSH-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the incident costs in the company's base currency.PA290, PA372, PA490, PA590, PA90.1, PA90.3
#OSH-INCIDENT-SITE
INCIDENT_SITE		Alpha 30 (Lower Case)—PA290, PA372, PA490, PA590, PA90.1
#OSH-REPORT-COMP-BY
REPORT_COMP_BY		Numeric 9—PA290, PA372, PA490, PA590, PA90.1
#OSH-RPT-COMP-NAME
RPT_COMP_NAME		Alpha 30 (Lower Case)—PA290, PA372, PA490, PA590, PA90.1
#OSH-RPT-COMP-DATE
RPT_COMP_DATE		Numeric 8 (yyyymmdd)—PA290, PA372, PA490, PA590, PA90.1
#OSH-EMERGENCY-ROOM
EMERGENCY_ROOM		Alpha 1—PA290, PA372, PA490, PA590, PA90.1
#OSH-SHARP-DEVICE
SHARP_DEVICE		Alpha 10—PA290, PA372, PA490, PA590, PA90.1
#OSH-BRND-SHARP-DEV
BRND_SHARP_DEV		Alpha 10—PA290, PA372, PA490, PA590, PA90.1

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OSHSET1
  1. COMPANY
  2. EMPLOYEE
  3. ESTABLISHMENT
  4. SEQ-NBR
PrimaryHOSH.1, HR11.1, HR90.1, PA115, PA149, PA248, PA249, PA290 +9 more
OSHSET2
  1. COMPANY
  2. EMPLOYEE
  3. DATE
  4. ESTABLISHMENT
  5. SEQ-NBR
KeyChangeHR170, HR70.1, PA91.1
OSHSET3
  1. COMPANY
  2. ESTABLISHMENT
  3. SEQ-NBR ↓
  4. EMPLOYEE
PA290, PA372, PA490, PA590, PA90.1, PA92.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CUCODESPCODESPRSYSTEMINSTCTRYCDDEPTCODEEMPLOYEEOSHESTABJOBCODEPAEMPLOYEEOSHAPACOMMENTSPAINCICOSTOSHESTDTLPAFOLLOWUPOSHA

One to one (30) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequiredWhen (OSH-CURRENCY-CODE != Spaces)
OSH-BASE-CURRENCY→CUC-CURRENCY-CODE
Body PartPCODESRequiredWhen (OSH-BODY-PART-CD != Spaces)
"BP"→PCO-TYPE
OSH-BODY-PART-CD→PCO-CODE
CompanyPRSYSTEMRequired
OSH-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredWhen (OSH-COUNTRY-CODE != Spaces)
OSH-COUNTRY-CODE→INT-COUNTRY-CODE
CurrencyCUCODESRequiredWhen (OSH-CURRENCY-CODE != Spaces)
OSH-CURRENCY-CODE→CUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen OSH-DEPARTMENT != Spaces
OSH-COMPANY→DPT-COMPANY
OSH-PROCESS-LEVEL→DPT-PROCESS-LEVEL
OSH-DEPARTMENT→DPT-DEPARTMENT
EmployeeEMPLOYEERequired
OSH-COMPANY→EMP-COMPANY
OSH-EMPLOYEE→EMP-EMPLOYEE
EstablishmentOSHESTABRequiredWhen (OSH-ESTABLISHMENT != Spaces)
OSH-COMPANY→OTB-COMPANY
OSH-ESTABLISHMENT→OTB-ESTABLISHMENT
First Aid ByEMPLOYEERequiredWhen (OSH-FIRST-AID-BY != Zeroes)
OSH-COMPANY→EMP-COMPANY
OSH-FIRST-AID-BY→EMP-EMPLOYEE
HospitalPCODESRequiredWhen (OSH-HOSPITAL != Spaces)
"HO"→PCO-TYPE
OSH-HOSPITAL→PCO-CODE
IllnessPCODESRequiredWhen OSH-ILL-INJ = "IL"
"IL"→PCO-TYPE
OSH-ILLNESS→PCO-CODE
Illness TypePCODESRequiredWhen (OSH-ILLNESS != Spaces)
"IL"→PCO-TYPE
OSH-ILLNESS→PCO-CODE
IncidentPCODESRequiredWhen (OSH-INCIDENT != Spaces)
"IN"→PCO-TYPE
OSH-INCIDENT→PCO-CODE
Incident CatPCODESRequiredWhen (OSH-INCID-CAT != Spaces)
"IC"→PCO-TYPE
OSH-INCID-CAT→PCO-CODE
Incident OutcmPCODESRequiredWhen (OSH-OUTCOME != Spaces)
"IO"→PCO-TYPE
OSH-OUTCOME→PCO-CODE
Incident StatPCODESRequiredWhen (OSH-INCID-STATUS != Spaces)
"IS"→PCO-TYPE
OSH-INCID-STATUS→PCO-CODE
Job CodeJOBCODERequiredWhen OSH-JOB-CODE != Spaces
OSH-COMPANY→JBC-COMPANY
OSH-JOB-CODE→JBC-JOB-CODE
LocationPCODESRequiredWhen OSH-LOCAT-CODE != Spaces
"LO"→PCO-TYPE
OSH-LOCAT-CODE→PCO-CODE
Pa EmployeePAEMPLOYEERequired
OSH-COMPANY→PEM-COMPANY
OSH-EMPLOYEE→PEM-EMPLOYEE
PhysicianPCODESRequiredWhen OSH-PHYSICIAN != Spaces
"PY"→PCO-TYPE
OSH-PHYSICIAN→PCO-CODE
Prior IncidentOSHARequiredWhen 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 LevelPRSYSTEMRequiredWhen OSH-PROCESS-LEVEL != Spaces
OSH-COMPANY→PRS-COMPANY
OSH-PROCESS-LEVEL→PRS-PROCESS-LEVEL
Report ByEMPLOYEERequiredWhen (OSH-REPORTS-BY != Zeroes)
OSH-COMPANY→EMP-COMPANY
OSH-REPORTS-BY→EMP-EMPLOYEE
Report ToEMPLOYEERequiredWhen (OSH-REPORTS-TO != Zeroes)
OSH-COMPANY→EMP-COMPANY
OSH-REPORTS-TO→EMP-EMPLOYEE
SeverityPCODESRequiredWhen OSH-SEVERITY != Spaces
"IE"→PCO-TYPE
OSH-SEVERITY→PCO-CODE
Super EmpEMPLOYEERequiredWhen (OSH-SUPERVISOR-EMP != Zeroes)
OSH-COMPANY→EMP-COMPANY
OSH-SUPERVISOR-EMP→EMP-EMPLOYEE
User2PCODESRequiredWhen OSH-USER2 != Spaces
"I2"→PCO-TYPE
OSH-USER2→PCO-CODE
User3PCODESRequiredWhen OSH-USER3 != Spaces
"I3"→PCO-TYPE
OSH-USER3→PCO-CODE
Wit CountryINSTCTRYCDRequiredWhen (OSH-WIT-CNTRY-CD != Spaces)
OSH-WIT-CNTRY-CD→INT-COUNTRY-CODE
WitnessEMPLOYEERequiredWhen (OSH-WITNESS != Zeroes)
OSH-COMPANY→EMP-COMPANY
OSH-WITNESS→EMP-EMPLOYEE

One to many (4) — child tables

RelationTableRulesConditionField map
CommentsPACOMMENTSDelete 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
CostsPAINCICOSTDelete 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 DtlOSHESTDTLValid When (OSH-ESTABLISHMENT != Spaces)
OSH-COMPANY→ODT-COMPANY
OSH-ESTABLISHMENT→ODT-ESTABLISHMENT
—→ODT-PROCESS-LEVEL
—→ODT-DEPARTMENT
—→ODT-LOCAT-CODE
Follow UpPAFOLLOWUPDelete 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

Programs

Updated by (8)

Referenced by (12)