INCIDENT_NBRA=Accident
B=Industrial Accident
C=Contamination
D=Industrial Accident (Official)
E=Exposure
H=Hazardous Condition
I=Incident
L=Illness
N=Injury
O=Dangerous Occurrence
P=Unsafe Practice
S=Safety Violation
V=Vehicle/Equipment Accident
INCID_SRCH_BRA(SQL View) |
Index Back |
|---|---|
Incident Search BrazilIncident Search Brazil |
| SELECT INCIDENT_NBR , INCIDENT_TYPE , INCIDENT_DT , LOCATION_NAME FROM PS_INCIDENT_DATA WHERE REG_REGION = 'BRA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 2 | INCIDENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Incident Type
A=Accident B=Industrial Accident C=Contamination D=Industrial Accident (Official) E=Exposure H=Hazardous Condition I=Incident L=Illness N=Injury O=Dangerous Occurrence P=Unsafe Practice S=Safety Violation V=Vehicle/Equipment Accident |
| 3 | INCIDENT_DT | Date(10) | DATE NOT NULL | Incident Date |
| 4 | LOCATION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Location Name |