GPBR_INCID_SRCH(SQL View) |
Index Back |
|---|---|
Incident Search BrazilIncident Search Brazil |
| SELECT DISTINCT COMPANY , CASE WHEN XRF.CAT_TYPE_BRA = '1' THEN '01' WHEN XRF.CAT_TYPE_BRA = '2' THEN '02' WHEN XRF.CAT_TYPE_BRA = '3' THEN '03' END , DAT.INCIDENT_NBR , DAT.INCIDENT_TYPE , DAT.INCIDENT_DT , DAT.LOCATION_NAME FROM PS_INCIDENT_DATA DAT , PS_GPBR_DRVCAT_XRF XRF , PS_GPBR_DRIVER_DAT DRV WHERE REG_REGION = 'BRA' AND DAT.INCIDENT_NBR = XRF.GPBR_INCIDENT_NBR AND DRV.GPBR_DRIVER_SEQ = XRF.GPBR_DRIVER_SEQ AND XRF.GPBR_EVENT_CD = 'S-2210' UNION SELECT DISTINCT COMPANY , '04' , DAT.INCIDENT_NBR , DAT.INCIDENT_TYPE , DAT.INCIDENT_DT , DAT.LOCATION_NAME FROM PS_INCIDENT_DATA DAT , PS_GPBR_DRVCAT_XRF XRF , PS_GPBR_DRIVER_DAT DRV WHERE REG_REGION = 'BRA' AND DAT.INCIDENT_NBR = XRF.GPBR_INCIDENT_NBR AND DRV.GPBR_DRIVER_SEQ = XRF.GPBR_DRIVER_SEQ AND XRF.GPBR_EVENT_CD = 'S-2210' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPBR_CAT_TYP2 |
Character(2) | VARCHAR2(2) NOT NULL |
CAT Type Form
01=Initial 02=Reopened 03=Death Communication 04=All |
| 3 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Default Value: 0 |
| 4 | 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 M=Near Miss N=Injury O=Dangerous Occurrence P=Unsafe Practice R=Environmental S=Safety Violation V=Vehicle/Equipment Accident |
| 5 | INCIDENT_DT | Date(10) | DATE NOT NULL | Incident Date |
| 6 | LOCATION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Location Name |