INCIDENT_REPORT(SQL Table) |
Index Back |
|---|---|
Incident ReportHolds optionally-specified information about the reports that are produced from the Health & Safety system. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Default Value: 0 |
| 2 | REG_REGION |
Character(5) | VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: INCIDENT_DATA.REG_REGION Prompt Table: REG_HANDS_VW |
| 3 | REPORT_DATE |
Date(10) | DATE | Report Date |
| 4 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | REPORT_TIME | Time(15) | TIMESTAMP | Report Time |
| 6 | HS_TIMEZONE1 | Character(9) | VARCHAR2(9) NOT NULL |
Health and Safety Time Zone Field 1
Prompt Table: PSTIMEZONE |
| 7 | REPORT_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Person Reporting
Prompt Table: PERSON_NAME |
| 8 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL |
Location SetID
Prompt Table: SETID_TBL |
| 9 | REPORT_LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Reporting Location
Prompt Table: HS_LOCATION_VW |
| 10 | RPT_STATUS_CAN | Character(1) | VARCHAR2(1) NOT NULL |
Report Status
F=Final P=Preliminary Default Value: P |
| 11 | FIRM_NBR_RPT_CAN | Number(6,0) | INTEGER NOT NULL |
Firm Number Reporting
Prompt Table: WCB_WEBREG_DTLS |
| 12 | OP_LOCN_RPT_CAN | Number(3,0) | SMALLINT NOT NULL |
Oper. Location Reporting
Prompt Table: WCB_EMPREL_OPN |
| 13 | COMMENTS | Long Character | CLOB | Comment |